Incorrect syntax error

Results 1 to 2 of 2

Thread: Incorrect syntax error

  1. #1
    Join Date
    Dec 1969

    Default Incorrect syntax error

    The following code is giving me an Incorrect syntax error ??<BR>The request function is pulling info from a text field that is laso getting it&#039;s info from another table<BR><BR> Dim SetRSObjSecond, ConnectToRSSecond, NameId<BR> Set NameId = Request.form("txtClient")<BR> <BR> &#039;Make a second recordset object<BR> Set SetRSObjSecond = Server.CreateObject("ADODB.Recordset")<BR> ConnectToRSSecond = "Select name, telephone, fax, e_mail from Customers WHERE name=" & NameId & ";"<BR> ConnectToRSSecond, SetDBObj<BR><BR>thanks guyz

  2. #2
    Join Date
    Dec 1969

    Default RE: Incorrect syntax error

    Remove the &#039;Set&#039; on this line:<BR><BR>Set NameId = Request.form("txtClient") <BR><BR>Set is used with objects.

Posting Permissions

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