problem with null values

Results 1 to 2 of 2

Thread: problem with null values

  1. #1
    Join Date
    Dec 1969

    Default problem with null values

    hi,<BR> i am fetching a value from the database and displaying it in the table.<BR> it workds fine when i there are some values for that field. if it&#039;s null it throws an error,<BR>ADODB.Field error &#039;80020009&#039; <BR>Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. <BR><BR> when it ried the response.write(sql), for the fields in null value, it prints,<BR><BR>select user_name from ihtuser where user_id =&#039;&#039; <BR><BR>what shall i do to solve this?<BR>please help

  2. #2
    Join Date
    Dec 1969

    Default RE: problem with null values

    check the recordset&#039;s EOF<BR><BR>If not objRS.EOF then<BR>&#039; display something<BR>else<BR>&#039; don&#039;t<BR>end if

Posting Permissions

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