problem Recordset

Results 1 to 3 of 3

Thread: problem Recordset

  1. #1
    afan Guest

    Default problem Recordset

    I write the below code for generate for the unique serial no for user. there is no record in databse name &#039;jon&#039; then i need when the record set give null value then sno become 1 other wise increament in the sno.<BR><BR>in my case no record with name jon then Rs_sno is null.<BR>the insert query give this error.<BR><BR>------<BR>error<BR>------<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e14&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. <BR><BR>/addressbook/editcalendarIns.asp, line 97 <BR><BR>----------<BR>code<BR>----------<BR>set Rs_sno = objcon.execute("select max(sno) from calendar where user_name=&#039;jon&#039; ")<BR><BR>if Rs_sno.EOF then<BR>sno = 1<BR>Response.Write(sno)<BR>end if<BR><BR>if not Rs_sno.EOF then<BR>sno = Rs_sno(0) + 1<BR>Response.Write(sno)<BR><BR>end if<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: please help me

    please help me i am waiting for reply

  3. #3
    Ed Guest

    Default RE: problem Recordset

    Where is your insert statement? What is line 97?

Posting Permissions

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