asked on ASP Syntax
This should be an easy one. I am not on my desktop so I cant make sure this is the correct syntax of the following IF, can someone please confirm it is so I can pass it to a collegue ?
Current code is:
That code works well, but I need to add to the first IF. I want to run REGIONS IF that blob session doesn't exist, but also if a field of the recordset "rs_blob" is = "" OR is NULL
This is how I entered the code, unfortunately I can't confirm at this time, can someone tell me if it looks correct ?
Current code is:
if Session("QFBlobid") = "" OR rs_Blob("Blobdata") = "" then
REGION A
If not rs_FormsBlb.EOF then
REGION B
else
Response.Write("Error EOF")
end if
end if
%>
That code works well, but I need to add to the first IF. I want to run REGIONS IF that blob session doesn't exist, but also if a field of the recordset "rs_blob" is = "" OR is NULL
This is how I entered the code, unfortunately I can't confirm at this time, can someone tell me if it looks correct ?
if Session("QFBlobid") = "" OR rs_Blob("Blobdata") = "" then OR OR rs_Blob("Blobdata") is NULL
REGION A
... etc
Web DevelopmentASPSQL
Last Comment
Aleks
ASKER
With that code is there no need to compare with a null ?
as it was using:
"" & rs_Blob("Blobdata")
it will cover up the comparison with null value.
meaning to say, even rs_Blob("Blobdata") contains null value, it will be replaced with "" as we using:
"" & rs_Blob("Blobdata")
"" & rs_Blob("Blobdata")
it will cover up the comparison with null value.
meaning to say, even rs_Blob("Blobdata") contains null value, it will be replaced with "" as we using:
"" & rs_Blob("Blobdata")
ASKER
I apologize for the wait. I added:
I get this error on that line:
error '80020009'
/bluedot/Intranet/Cases/fo
line 1061 is: if Session("QFBlobid") = "" OR "" & rs_Blob("Blobdata") = "" then
Note: Blobdata is a text field
if Session("QFBlobid") = "" OR "" & rs_Blob("Blobdata") = "" then
I get this error on that line:
error '80020009'
/bluedot/Intranet/Cases/fo
line 1061 is: if Session("QFBlobid") = "" OR "" & rs_Blob("Blobdata") = "" then
Note: Blobdata is a text field
ASKER
This seems to have worked:
if Session("QFBlobid") = "" OR isNull (rs_Blob("Blobdata")) then
if Session("QFBlobid") = "" OR isNull (rs_Blob("Blobdata")) then
ok, coool. so do you still need further assistance here?
ASKER
I want to make sure this will work not only if the field is NULL but also if it is 'empty' meaning ""
I want to make sure this will work not only if the field is NULL but also if it is 'empty' meaning ""what if we try:
if Session("QFBlobid") = "" OR isNull (rs_Blob("Blobdata")) or rs_Blob("Blobdata") = "" then
ASKER
I tried but I get the error I posted before:
error '80020009'
error '80020009'
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Actually this seems to have worked on every scenario we tried:
if Session("QFBlobid") = "" OR isNull (rs_Blob("Blobdata")) then
if Session("QFBlobid") = "" OR isNull (rs_Blob("Blobdata")) then
ASKER
Thanks for the follow up.
Open in new window