[Microsoft][ODBC Microsoft Access Driver] Syntax e

Results 1 to 3 of 3

Thread: [Microsoft][ODBC Microsoft Access Driver] Syntax e

  1. #1
    T1k1 Guest

    Default [Microsoft][ODBC Microsoft Access Driver] Syntax e

    Help...<BR><BR>What the hell does that mean and how do i fix it.<BR><BR>&#060;%<BR>Dim iResultID, strSQL, objRS<BR>iResultID = Request.QueryString("ResultID")<BR>strSQL = "SELECT * FROM tblResults WHERE (ResultID = &#039;" & iResultID & "&#039;)"<BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Op en strSQL, objConn, , , adCmdTable<BR><BR>Do While Not objRS.EOF %&#062;<BR><BR>Thanx t1k1

  2. #2
    Join Date
    Dec 1969

    Default If iResultID is a....

    Numeric field...remove the quotes from around it.

  3. #3
    Reggie Guest

    Default Make iResultID an int also

    iResultID = Cint(Request.QueryString("ResultID"))<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