Results 1 to 2 of 2

Thread: roeland

  1. #1
    Join Date
    Dec 1969

    Default roeland

    I want to use a variable form a query string in my query but it doesn&#039;t seem to work, this is my query<BR>----------------<BR>SQL_query = "SELECT OnderwerpNaam, OnderwerpNr FROM Onderwerp WHERE OnderwerpNr=" & (Request.QueryString("OnderwerpNr"))<BR><BR>--------------------------------------<BR>and I get this error:<BR>------------------------------------------------------------<BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression &#039;OnderwerpNr=&#039;. <BR>---------------------------------------------<BR><BR>What should I do?

  2. #2
    Nils Bilhorn Guest

    Default RE: roeland

    Make sure that Request.QueryString("OnderwerpNr") contains a value. You can check by writing the query with response.write before executing it.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts