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 there something I am missing?
ASP
Last Comment
Graeme McGilvray
ASKER
Sorry Manuel, yes I did miss it in this Question... however it is in the code.. sorry again
SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionASKER
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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
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
I have just thought of something... Its showing up on a page that doesnt require is... eg http://dev.gptouring.com.a
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
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?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
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=
ASKER
I am getting errors on:
http://dev.gptouring.com.a
Why would this happen?
Im not even asking for Request.QueryString("event
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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Open in new window
Miss )