J
Jerome
Hi,
I've got the following problem:
I want my ASP page to display a certain number (based on a COUNT query),
it works fine if the result is at least 1! If there are no records to be
counted (= the query is empty), I get errors.
What I've tried is this:
if rsNP_MB_Site.BOF = true or rsNB_MB_Site.EOF = true then
response.write "amount: 0"
else
response.write "amount: " & response.write
rsNP_MB_Site.Fields.Item("NP").Value
end if
But I keep getting an 'object required' error?
I've also tried with isnull(rsNP_MB_Site.Fields.Item("NP").Value) but
that didn't work out either.
Any help is greatly appreciated,
Jerome
I've got the following problem:
I want my ASP page to display a certain number (based on a COUNT query),
it works fine if the result is at least 1! If there are no records to be
counted (= the query is empty), I get errors.
What I've tried is this:
if rsNP_MB_Site.BOF = true or rsNB_MB_Site.EOF = true then
response.write "amount: 0"
else
response.write "amount: " & response.write
rsNP_MB_Site.Fields.Item("NP").Value
end if
But I keep getting an 'object required' error?
I've also tried with isnull(rsNP_MB_Site.Fields.Item("NP").Value) but
that didn't work out either.
Any help is greatly appreciated,
Jerome