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?
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?