Defining a Number v Text
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 there something I am missing?
GPTouring
GPTouring
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
GPTouring
Request.QueryString("event")="all"
If IsNumeric(Request.QueryString("event")) Then
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
GPTouring
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=
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...
AND event_ID=
and you should fine that something is missing there
GPTouring
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
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions