Graeme McGilvray
asked on
Defining a Number v Text
Hello all and thanks in advance for your assistance
I am having issues with what I thought was how to tell the difference between a number and text by using IsNumeric, however I am finding that for example
Is there something I am missing?
I am having issues with what I thought was how to tell the difference between a number and text by using IsNumeric, however I am finding that for example
If IsNumeric(Request.QueryString("all") Then
is processing and giving an output...Is there something I am missing?
ASKER
Sorry Manuel, yes I did miss it in this Question... however it is in the code.. sorry again
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for that Manuel
The issue im getting is...
x="all"
response.write(IsNumeric(x ))
If IsNumeric(x) Then
This is coming true and then proceeding in the IF statement
The issue im getting is...
x="all"
response.write(IsNumeric(x
If IsNumeric(x) Then
This is coming true and then proceeding in the IF statement
ASKER
The actual Code that is having an issue is:
Request.QueryString("event")="all"
If IsNumeric(Request.QueryString("event")) Then
x="all"this returned as false to me.
response.write(IsNumeric(x))
ASKER
Hi Ryan, in post 42071145, I am displaying the code that is having an issue... :(
I have just thought of something... Its showing up on a page that doesnt require is... eg http://dev.gptouring.com.a u/?
I have just thought of something... Its showing up on a page that doesnt require is... eg http://dev.gptouring.com.a
Request.QueryString("eventthis should be an invalid statement and your page would have generated an error on screen.")="all"
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'event_code=code_short AND event_start>Now() AND code_live=TRUE AND event_live=TRUE AND event_ID='.
as what i guess... from this error, it mentioned that Request.QueryString("event
so you need to have a better error handling in case Request.QueryString("event
ASKER
I think I have figured it out...
doesnt error... is that because it would see "" OR "?" as IsNumeric?
If IsNumeric(Request.QueryString("event")) AND NOT (Request.QueryString="" OR Request.QueryString="?") Then
doesnt error... is that because it would see "" OR "?" as IsNumeric?
If IsNumeric(Request.QueryStrnope... what if you have this?ing("event ")) AND NOT (Request.QueryString="" OR Request.QueryString="?") Then
http://dev.gptouring.com.au/?x
http://dev.gptouring.com.au/?bla=
etc?
ASKER
I am getting errors on:
http://dev.gptouring.com.a u/?categor y=70
Why would this happen?
Im not even asking for Request.QueryString("event ") on this page...
http://dev.gptouring.com.a
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'event_code=code_short AND event_start>Now() AND code_live=TRUE AND event_live=TRUE AND event_ID='.
Why would this happen?
Im not even asking for Request.QueryString("event
Im not even asking for Request.QueryString("event") on this page...
try post and examine the codes around:AND event_ID=
and you should fine that something is missing there
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yeah I a not sure why...
The homepage of the website is first in the hierarchy order and the Query that it is erroring on (the line we have seen
'event=') is after it.
just strange!
seems to be not erroring now, been through alot of pages and all good
The homepage of the website is first in the hierarchy order and the Query that it is erroring on (the line we have seen
'event=') is after it.
just strange!
seems to be not erroring now, been through alot of pages and all good
ASKER
Strange that it is doing this, but work around works
ASKER
Open in new window
Miss )