Click to See Complete Forum and Search --> : Exception occurred (getting empty field from table)


gerjan
06-24-2003, 06:50 AM
Hello I get the following (not saying anything) error in case a field in my DB table contains no value.

Exception occurred.

When I give the field a value, it workes fine!!

----
code

'select the table

sqstringgebr = "SELECT website FROM gebruikers WHERE username ='"&username&"' order by id DESC"
set objRSgebr = objConngebr.execute (sqstringgebr)

'I get the value from the field website

set website = objRSgebr("website")

'He gives the error some lines further when I try to call the variable website (online when the field is empty)
if website = "" then


Have I forgotten something important?

gerjan
06-24-2003, 07:40 AM
Tnx! It worked!

So null isn't the same as "" ?