dealing with missing values

Results 1 to 2 of 2

Thread: dealing with missing values

  1. #1
    Join Date
    Dec 1969

    Default dealing with missing values

    *<BR>Is there any way to deal with missing values in a table when using a select statement. I&#039;m trying to return some data from a database using an SQL statement, which works fine but bombs out when it hits a record with a missing value in the where field with the following message<BR><BR>ADODB.Field error &#039;80020009&#039; <BR><BR>Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record. <BR><BR>? <BR><BR>any ideas<BR><BR>cheers Keith<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: dealing with missing values

    You can test for this contingency not to arise<BR><BR>set RS = connect.execuet("select x from t where c = 12")<BR>if RS.eof then<BR> &#039;no data satisfied the search criteria<BR>else<BR> &#039;handle data as intended<BR>end if<BR><BR>or if trying to write a multitude of records<BR><BR>set RS = connect.execuet("select x from t where c = 12")<BR>while not RS.eof<BR> response.write rs("x")<BR> rs.movenext<BR>wend<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