What is the function in ASP to see if an object / string is an integer?
I want to check the contents of a form, and if it's an integer, i.e a number, do something, else if it's a word do something else, and I'm not sure howto?
write a simple function to check the user input from a form. I need to check that the string contains only numbers, has a maximum leght of say 15 and that the first number is zero.
I have a little code to add multiple items to a shopping cart based page. This code works perfect, but it adds all of the info to the same input fields every time it loops. I need it to change the input names each time it loops. Here is the code:
I am trying to send a 'single' data type to a sql server db cell that is formatted for 'decimal' from asp/ado code and it is converting it to an integer. Should I be using some other data type in sql server?
I am trying to reiterate through a for..next..loop using an integer (i). I would like to know when it is either a odd or an even number, insteading of using the simple version below:
if i = 1 or i=3 or i = 5 then Response.Write "<tr " & strRowOdd & ">" & vbcrlf else Response.Write "<tr>" & vbcrlf end if
I have a set of values like name,age,desg,salary,year etc . currently i am getting the values using max(year) and displaying the values year is integer in my sqlserver db If you go thru my code (see attachment) you would be able to understand.
Now the problem is if a person gets promoted or hike in his salary i have to display two differnt salary on the same year how do i do that. currently i am displaying the values based on the max(year) max(year)-1 etc. i cannot modify the database. i have to do some changes on my coding only. Please view my coding as attachment (3000.txt).
For example Name Age Desig Salary Year abc 35 CEO 39000 2004 abc 35 CFO 38000 2003 abc 35 CTO 37000 2002 abc 35 CTO 35000 2001 abc 35 Direcotr30000 2001
I have a set of values like name,age,desg,salary,year etc
currently i am getting the values using max(year) and displaying the values year is integer in my sqlserver db If you go thru my code (see attachment) you would be able to understand.
Now the problem is if a person gets promoted or hike in his salary i have to display two differnt salary on the same year how do i do that. currently i am displaying the values based on the max(year) max(year)-1 etc. i cannot modify the database. i have to do some changes on my coding only. Code:
we have a recordset return by a stored procedure from MS SQL. basically this recordset is an integer value, but when we are checking is value something strange happens :
if RS(0) = -1 then ... end
for example RS(0)=46 and anyway our program runs what is inside the if ...end structure..
how can we cast -1 to integer... something like in C++ : (int)(-1).... in order to make sure that -1 in integer.
is any way possible to convert a string, which is a string of a number, to an integer (using VBScript). If not, are there any other solutions to have a number that is a string, and add one to increase that number?
I get the EmpID from the form which is a variant. When I do the following, I get an overflow error. Can you suggest of a way I can convert this EmpID to a number?Code:
'Get the EmpID from the form strEmpID = cInt(Request.Form("empid"))
I am calling a javascript function in my asp. I am passing a recordset value, a 7 digit integer, to this javascript function. However, in the function this value is not coming in correctly. say for example i am passing 0360001, in the function when i pass it to another window, its going as 122881.
I am asuming its because of the size of the default integer data type. If you think thats the reason, how can set a long integer data type to this value, if that can be done in asp.
I have a form, that has a drop down menu with number of options eb. home, work, mobile etc. However when the choice is added to the database table it appears as a number inside the table, even though the field in the table is set to a text value (it is an MS Access DB) Why is this?
I am trying to update an integer field in an Access database with a null value (ie, make the field empty). It currently has an integer in it. Here's the code I've tried, which normally works for all other updates:
How does one switch a converted currency format back to a plain integer in Asp. I have tried Cint but this produces an overflow error for the following:
NewPrice = CInt(Request.Form.Item("NewPrice"))
Microsoft VBScript runtime (0x800A0006) Overflow: 'Cint'
I have a form with several fields that are updated to a DB as an integer. I am using this code to validate the fields:
iincidentdet = CInt(iincidentdet) If Err.number <> 0 Then strErrorMsg = strErrorMsg & "Your entry for integer_field could " & _ "not be converted to an integer! Remember that integers " & _ "need to be from -32,768 to 32,767.<br />" & vbCrLf Err.Clear End If
when I use my tab to pass by one of the integer fields which should be a 'zero' or null. Is there a way to default the fields to a null value?
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
I have an input box that sends data over to the next page. This input box was in a loop, there creating data looking like this: 2, 0, 0, 3, 0, 4, 0, 22, 0, 0, 0
How do i break the data up in such a way that i can populate it into my db while running through a recordset?
i create a dynamic table to modify user/account for administrative management. I have modify & delete function to be performed.
The idea is that when the admin click the Delete link, he can delete a particular account/user. is it possible to pass variable of buff value to recID??
because when i see the result of request.querystring("recID"), i does not pass the mumerical value sound pretty simple but i can't get it. Code:
I am looking for something similar to "preg_match" and "preg_match_all" in PHP.
I have searched the forum with no luck. I hope you are able to give me some pointers
Basically I want to match some text from a form and loaded it into new variables making use of regular expressions. the text comes form a textarea input type. Code:
I have a bummer here. I have 3 sub R. that I need to call from a input button. I set up the following line, but the script just calls them with out having the button pressed. OOOO! Any ideas?
Is there any way to clean the user input before saving to the database.I tried to use..
Function StripNonNum(strInput) Dim regEx Set regEx = New RegExp regEx.Pattern ="^[w-.]{1,}@([da-zA-Z-]{1,}.){1,}[da-zA-Z-]{2,3}$" regEx.IgnoreCase = True regEx.Global = True StripNonNum = regEx.Replace(strInput, "") End Function
But It doesn't work when user cut&paste the information to screen.For eg.Cut&Paste from a CV which contains Bullet points is there any way to remove these bullet Points before data saving..