20003 Syntax error

Results 1 to 2 of 2

Thread: 20003 Syntax error

  1. #1
    Join Date
    Dec 1969

    Default 20003 Syntax error

    Can you think of any reasons why I am getting this syntax error on the "strsqld=splitconf(w)" line even though sql is getting the stmt and executing it correctly? When writing it out, it appears exactly how it should. (The splitconf is a textarea form results.)<BR><BR>&#060;---------------------Error---------------------------------&#062;<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039; <BR>[Unisys ODBC Access Driver 50.01.150] -20003 Syntax error <BR><BR>&#060;---------------------Code----------------------------------&#062;<BR> If Request.Form.Item("button4")="Execute SQL stmt(s)" then<BR> Dim strsqld,w,sendrevoke<BR> For w = 0 to ubound(splitconf)<BR> strsqld=splitconf(w)<BR> sendrevoke = oConnSQL.execute(strsqld) <BR> Next <BR> End If

  2. #2
    Join Date
    Dec 1969

    Default Error NOT on that line

    Sometimes, line numbers reported in ASP errors can be off by one or two.<BR><BR>That error is on the NEXT line.<BR><BR>And you SAY that you are writing it out, but you aren&#039;t showing us.<BR><BR>For w = 0 to ubound(splitconf)<BR> strsqld=splitconf(w)<BR> Response.Write "splitconf(" & w & ") is " & strsqld & "&#060;br/&#062;"<BR> sendrevoke = oConnSQL.execute(strsqld) <BR>Next <BR><BR>What does that show you, just before you get the error?<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