-
Null values
I got this error on my screen:
ADODB.field error '800A0BCD'
And I have <Null> values in the datebase. And that error message comes to
screen everytime I test. I have also string which should print the Null field,
but it doesnt!
Thanks in advance Miia
-
Re: Null values
"miia" <miia.kuokkkanen@sysforte.fi> wrote:
>
>I got this error on my screen:
>ADODB.field error '800A0BCD'
>
>And I have <Null> values in the datebase. And that error message comes to
>screen everytime I test. I have also string which should print the Null
field,
>but it doesnt!
>
>Thanks in advance Miia
*****************************************************************
Miia,
Try this out,
if isnull(rst(i)) then
response.write "<div align=right><strong>NULL</strong></div>"
else
response.write "<div align=right>" & rst(i) & "</div>"
end if
Hope it helps,
Pete
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks