Discovering if an SQL statement has output NULL??

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!

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

Code:

---

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

---

To add data to a database

Code:

---

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

---

Hope this helps,