IsNumeric() = False

I wrote a stored procedure to INSERT a new row in the database. It returns the new ID via @@IDENTITY. This value is read by my ASP and stored in variable intNewID. The value displays fine via <%= intNewID %>. But when I tested it using IsNumeric(intNewID), it returned False.

View Replies


ADVERTISEMENT

Using Isnumeric

I am using an import process that scans an html file and exports data toa sql database table.One of the fields I import, on occasion has 2 numeric characters at the
very end. For example "thename 04".What I need to do is delete those numeric characters, if they exist.I thought about something like this:

if isnumeric(right(thename,2))=TRUE then

but what's next? How do I make a new THENAME field without those last two numeric characters if they exist?

View Replies View Related

IsNumeric

if Shift = "" Then
error_list.add "589343","desired shift must be specified."
b_error = true
end If

for this function, how can i implement isNumeric to get an error msg for the user so tell them not to key in char but to enter only INT.

View Replies View Related

IsNumeric?

I am using the recordset below but I only want to inner join fixtures on teams if Fixtures.HomeTeamID is a numeric value, how could I do this? Code:

Dim rsHomeT
SET rsHomeT = Server.CreateObject("ADODB.Recordset")
rsHomeT.Open "SELECT * FROM Fixtures INNER JOIN Teams ON Fixtures.HomeTeamID = Teams.TeamID WHERE Fixtures.LeagueID = " & ID & " ORDER BY iYear, iMonth, iDay ASC;", objConn

View Replies View Related

IsNumeric()

In my asp page (which I am using VBScript for)....if I use the IsNumeric(x) function, will this only evaluate true for integers x??? Or will it also evaluate to being true if x contains a decimal point????

View Replies View Related

Isnumeric Return True

why does isnumeric return true?

a=""
if isnumeric(a) then
response.write("test")
end if

empty isnt numerical is it?

View Replies View Related

IsNumeric() Isert Numaric And Double

I have received the following feedback for the two functions bellow:

"The ISNUMERIC test is WORTHLESS for checking for an INT value, because
ISNUMERIC will happily accept DOUBLE values, such as 89.11998811777 and
other values that are simply *NOT* INT values." Code:

View Replies View Related

Xml Variable FALSE

I'm not too familier with XML, this is probably a simple question but in my script I use this:

...
xml.Open "GET", url, FALSE
xml.Send()
Response.write xml.Responsetext
...

now, this is probably a very simple thing and I'm blind or something but how do I make it do something besides just quitting if it's false???

View Replies View Related

If Exist=false

I need a way to check if a certain folder exists. If it doesn't exist i want to create it. How can i do this?

View Replies View Related

SendEmail Returning False

I have two forms, each with its own processor ASP. Both use the SendEmail.asp mailer program. One form works, the other fails at the SendEmail call, and I cannot figure out why.

The form code of the form returning no mail sent: ....

View Replies View Related

True Or False In A Yes/no Field

in one of my sql queries on an asp page i am trying to select some data from an access table. The problem is the search criteria is based on a yes/no field. I need to find any record where the value is null or true. So far i have this:

if ISNULL(orseof("Returned")) OR orseof("Returned") = True then

the ISNULL section works it is just the = true bit that doesn't.

View Replies View Related

False User/password

I lethe user enter a username and password and through a SQL-statement I
check if there is a corresponding password in the database (Yes I know,
not very good security but for the moment it's enough). Problem is that
when I enter a false user/password, I want the code to redirect to
another .asp-page which states the user is not valid. Problem lies
within the statement "if rsMOS is nothing then response.redirect
"VWGloginAgain.asp" ". Somehow, the code does not return 'nothing' but
something else.
How do I figure out what it returns? Or, how can I make sure it returns
a 'nothing' when no such password is found in the database?
Here's my code snippet ('usr' and 'ww' are defined earlier; furthermore
I've left out the redirects, but I've tested the first
if-then-conditions and they work fine... Just the 'nothing' does not
work):

View Replies View Related

True Or False Quiz

i m trying to create a true and false quiz which accesses the questions from a access database processes the results and then writes back to the database

I dont know how to structure the code for the radio buttons,i also need to give the user immediate feedback, but i cant use pop up boxes

View Replies View Related

False 'ASP 0113' Error Message

Getting a false error message listed below. The error occurs only when using an ALIAS instead of actual computername i.e. the server name is INTRANET01 but the alias is HELPDESK.

error 'ASP 0113'

Script timed out

The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeOut or by changing the value in the IIS administration tools.

View Replies View Related

ASP CHECKBOX: How To Send True/false To DB

Been having problems sending a true/false value to my database from a checkbox/radio group. Using checkboxes.... Code:

View Replies View Related

Random True/false Quiz

Here's what I want to do (i'm kind of there in JavaScript, but want to move it to ASP).

I have 17 different html pages. quiz1.html > quiz17.html.

The user says take a quiz and it pops up a window holding quiz1.html.

Within each page is a true/false question. Upon answering the user is told:

1. what they answered.
2. if that is correct or not
3. a corresponding sentence about the question.
4. an image the corresponds to if they were corect or not.

(This is all done in javascript).

----

However, now I want to take these 17 questions and randomize them and choose 6 questions.

For example:

The window pops up and it's question 1 they do that then move to the next one. 1-6 (random out of 17.

I'd like to do this in ASP.

View Replies View Related

Assigning A Boolean Of True Or False To VBScript Variable...

Is there a way I can assign a value of true or false to a VBScript variable? I have a function where I want to initiate a value of false: Would this work? Code:

View Replies View Related

Display Ms Access True/false Fields As Check Marks On ASP Page

what is the easiest way to display Yes/No, True/Falst, On/Off MS Access fields as check marks on an ASP page? it would be either checked or unchecked.

View Replies View Related

Document.formulier.submit On Return False "page Cannot Be Displayed"

I'm having in my asp page a java script with function. It checks the form, see the code below:

When I click on my submit button is has onClick="invalid();"
If a field is indeed not filled in, it gives the alert message.

My problem is, when the alert apears and I click on OK it gives an errorpage, I won't that it returns to the form. Code:

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved