Link to home
Start Free TrialLog in
Avatar of thatelvis
thatelvis

asked on

error '800a000d' bigint

Hello,

this is a column in my mysql database

 `landline_tusr` bigint(19) unsigned zerofill default NULL,

it is for a telephone number. but when I try and view it on my page I get the following error

error '800a000d'
Type mismatch
/wowa_detail.asp, line 674


this is my line 674

<% If(RecStar.Fields.Item("landline_tusr").Value) > (0) Then %>

any idea as to how i can get it to appear on my page with out an error


regards

Kenny





Avatar of hongjun
hongjun
Flag of Singapore image

Is the value null?
Try changing this line to...

<% If IsNull(RecStar.Fields.Item("landline_tusr").Value) Then %>
ASKER CERTIFIED SOLUTION
Avatar of bugs021997
bugs021997
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thatelvis
thatelvis

ASKER

thanks
@thatelvis

Glad was of some help to you....

Cheers
^_^
BUGS