Need urgent help

Results 1 to 2 of 2

Thread: Need urgent help

  1. #1
    Join Date
    Dec 1969
    Posts
    83

    Default Need urgent help

    Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e10&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. <BR><BR>/TrackSystem/Edit.asp, line 9 <BR><BR>&#060;% set OBJConnection=server.createobject("adodb.connectio n")<BR>OBJConnection.open "DSN=Mydb"&#037;&#062;<BR>&#060;%id = Request.QueryString("ID")&#037;&#062; <BR>&#060;% SQLtemp = " select * from MyTable " & _ <BR>"WHERE ESSN = " & id<BR> <BR> set rspeople=OBJConnection.execute(SQLtemp)&#037;&#062 ;<BR>please tel me what&#039s wrong?<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    293

    Default RE: Need urgent help

    This is a shot in the dark, but if your field (ESSN) is a text type field you need to surround the value of ID with single quotes:<BR>&#060;% SQLtemp = " select * from MyTable " & _ <BR>"WHERE ESSN = &#039" & id & "&#039"<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
  •