How to search for a record?

[bomayed]

I want to :

[ Select * From table ]

and I want to tell the script this condition :

[ IF "field! was not fond in the record" THEN ]

do something

[ END IF ]


can someone tell me how can this be done in ASP ?

thank you all

 

[mwolf00]

set rs = cn.execute("select * from myTable where fieldName = 'field value'&quot

if rs.eof then
'record was not found
else
'record was found
end if

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[bomayed]

Thanks mwolf00 , but I want to do :

[ SELECT * FROM TABLE ]

I don't want to use a where clause . .

 

[mwolf00]

Then you'll have to loop through the results...

set rs = cn.execute("select * from myTable&quot

valFound = false
do while not rs.eof
if rs("fieldName&quot = "some value" then
valFound = true
exit do
enf if
rs.movenext
loop

if valFound then
'handle here
end if

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[dmhirsch]

Are you trying to search for a particular column name, rather than the data contained within it?