Discovering if an SQL statement has output NULL??

[WinterMuteUK]

Hi again!

Erm, How can I check to see if an SQL statement has returned nothing? It's very late here and I can't think straight...

Also how would I add data from text inputs into a database?

thanks!

Chris!

[Negative0]

TO check for nothing use this as long as you opened forward only

if rs.eof = false then
'Returned something
else
msgbox "Nothing returned"
end if

To add data to a database

objConn.Execute "INSERT INTO table (FIELD1,FIELD2) VALUES ('" & text1.text & "','" & text2.text & "')"

Hope this helps,