[thelist] problem formatting ASP/Access WHERE statement
Norman Beresford
n.beresford at anansi.co.uk
Fri Nov 22 07:49:01 CST 2002
Hi Dunston
At a guess your ArticleID field is an integer (or an Autonumber field), so
don't use a string.
strQuery = "SELECT
ArticleID,ArticleTitle,ArticleFile,ArticleSummary,ArticleContent,ColumnName,
CurrentIssue,AuthorID,FullName,IssueID,IssueFile,FutureIssue FROM
ArticlesQuery WHERE ArticleID = " & request.querystring("ArticleID")
HTH
Norman
More information about the thelist
mailing list