problem with sql query

Results 1 to 2 of 2

Thread: problem with sql query

  1. #1
    merot Guest

    Default problem with sql query

    Is this sytax correct?<BR>Query = "SELECT * FROM Message WHERE MessageID =&#039;" & request("MessageID")&"&#039;"<BR>set message = Connect.Execute(Query)<BR><BR>why do i always get this error:<BR><BR>ADODB.Field error &#039;80020009&#039; <BR><BR>No current record. <BR><BR>thanx<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: problem with sql query

    The syntax is correct i suppose.<BR>But there are not any matching records to your query so you&#039;re getting the following error, since no record is found

Posting Permissions

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