Learn the most important control and control categories that every architect and developer should include in their projects.
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?
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
The IsNumeric function returns a Boolean value that indicates whether a specified expression can be evaluated as a number. It returns True if the expression is recognized as a number; otherwise, it returns False.
<%
Dim x
x=10
response.write(IsNumeric(x
x=Empty
response.write(IsNumeric(x
x=Null
response.write(IsNumeric(x
x="10"
response.write(IsNumeric(x
x="911 Help"
response.write(IsNumeric(x
%>
The output of the code above will be:
True
True
False
True
False
<%
Dim x
x=10
response.write(IsNumeric(x
x=Empty
response.write(IsNumeric(x
x=Null
response.write(IsNumeric(x
x="10"
response.write(IsNumeric(x
x="911 Help"
response.write(IsNumeric(x
%>
The output of the code above will be:
True
True
False
True
False
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
The actual Code that is having an issue is:
Request.QueryString("event")="all"
If IsNumeric(Request.QueryString("event")) Then
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
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
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=
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
I am now using:
Surely it shouldnt be that hard? should it?
for:
If IsNumeric(Request.QueryString("event")) AND Len(Request.QueryString("event"))>0 AND NOT (Request.QueryString="" OR Request.QueryString="?") Then
Surely it shouldnt be that hard? should it?
for:
AND event_ID=
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trial
i would simply use:
to ensure a numeric event (ID) was provided
If IsNumeric(Request.QueryString("event")) Then
to ensure a numeric event (ID) was provided
This isnt even on the IF statement page that it is writing, its complete different section...I think somehow in your codes logic, it hits that line of code and run it, which causing the error and display on your page.
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP
From novice to tech pro — start learning today.
-
Microsoft ApplicationsCertification: MOS Microsoft Office Specialist - Word 2016 Part … 125 lessons
-
Microsoft ApplicationsCertification: MOS Microsoft Office Specialist - Outlook 2013 Par… 191 lessons
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
Open in new window
Miss )