hide session variable if recordset is 2

[aonefun]

I am creating a Session variable in my code as follows:

Session("VendorPartNumber") = (Recordset1.Fields.Item("ManufacturerPartNumber").Value)

I receive this error message: "Requested operation requires a current record" when ManufacturerPartNumber is empty.

Is there an IF statement that I can place the session code into to avoid the error message or is there an alternative method?

 

[DotNetGnat]

if Recordset1.EOF AND Recordset1.BOF then
'recordset is empty...
else
Session("VendorPartNumber") = (Recordset1.Fields.Item("ManufacturerPartNumber").Value)
end if

-DNG

 

[bslintx]

just wanted to clarify that if you do not want to use an else...you don't need to...it's often used for a message like dng has in a comment or good for debugging

' open database connection
' execute sql

if NOT Recordset1.EOF then
Session("VendorPartNumber") = (Recordset1("ManufacturerPartNumber"))
end if

 

[aonefun]

Thank you so much for the information.

However, I have now changed the code so that the session variable equals a Request.Form, as follows:

Session("VendorPartNumber") = Request.Form("VendorPartNumber")

How would I put the following into correct syntax:

If Request.Form("VendorPartNumber") IS NOT NULL (or do I use empty)
THEN
Session("VendorPartNumber") = Request.Form("VendorPartNumber")

Can I then create something like

Else
Session("VendorParNumber") = "EMPTY VALUE"

because I'm afraid the next page requires a value for the session variable.

Thanks for your valuable time!

 

[Chopstik]

NULL and an empty string are two separate values. Often, if I need to look for both of them, what I do is what you indicated in your post.

if myVal = "" or isNull(myVal) then

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[guitarzan]

Or, you can append a blank string to the value in the comparison, which turns a Null value into a blank string. For example;

if (myVal & "") = "" Then
'myVal is either null, or a blank/empty string
else
'myVal has something in it.
end if