[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