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?
when i set the checkScore1 to 100 or higher in the table field, the if else condition became FALSE? But it work for 70 to 99 ??
If checkMaxAttempt = "2" AND checkScore1 >= "70" Then
response.redirect "error.asp"
'last attempt check
ElseIf checkMaxAttempt <= "1" AND checkScore2 >= "70" Then
response.redirect "error.asp"
ElseIf checkMaxAttempt <= "0" Then
response.redirect "error.asp"
Else 'do nothing
End If
I am trying to test a users input to be an integer. Is there a simple function that i can use. Here is a simplified version of my attempt.
dim numTestNumber
numTestNumber = 6
if isNumeric(numTestNumber) = false then
Response.Write "The input must be numeric"
Response.End
end if
if Cint(numTestNumber) then
Response.Write "The Number is an Integer"
else
Response.Write "The Number is not an integer"
end if
I have code that loops through a directory reading files..
now the problem is that files are constantly being uploaded and I only want the file system object to read those that are finished being uploaded.
How can I check the properties of the file to see if it's in middle of being written before i read the file?
I'm adding fields to a table with this code:
sql = "ALTER TABLE companies ADD COLUMN fieldname int"
now "int" gives the number as a whole number but what is the syntax for this value to be allowed to involve decimals?
If i need to search the ticketnumber by using long integer, do i need to include the single quote like the example below.
strsql="Update offsitetape set status='Open' where ticketnumber =' "&problemopen&"' "
When I get the value from the textfield, do I need to convert it to integer or just leave it like that:
problemopen=request.form("tapestextfield")
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?
View Replies View RelatedIs there a way of converting an integer to a string. so can 200 become "200".........i need to do this cuz i want to append it to another string.
View Replies View RelatedI 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
Want to format table rows in a different style.
Any ideas?
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
How do i display this from the database.
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?
View Replies View RelatedHow can I make a variable to be an int instead of being a String?
I want to get it done in VBScript.
so if I have
id = "32"
how can I tell the browser to read that as a int instead of a string.
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"))
VBScript is the scripting language I am using.
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?
View Replies View RelatedI am looking at doing a rotating image using the date to count it up. I have found a small bit of script to do it but have to admit Code:
View Replies View RelatedI 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:
set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = sConnString
rs.Source = "SELECT * FROM tblFixtures WHERE FixtureID = " & strFixtureIDcurrent
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 3
rs.Open()
rs_numRows = 0
rs("ArticleID") = ""
rs("Result") = ""
rs.update
rs.close
set rs = nothing
However I am getting a Type Mismatch error on the rs("ArticleID") = "" line. Where have I gone wrong?
Database: Access 2000
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?
How to do the error handling if the users key in character into integer text field? If possible, please give example and show me the coding.
View Replies View RelatedI'll admit my ASP skills are very rusty, and come seeking help.
I'm currently using a dictionary object to store a multi-dimensional array.
I want to pass this dictionary object to an object, which holds an array of dictionary objects.
However I'm finding that the array is not getting set, thus I'm having great issue with dynamically resizing the object's property for every new dictionary object I'm adding.
I have a VC++ COM object which fires an event. I've written VB EXE apps against it and they receive the event notification.
I've now built a simple VB COM object which uses the VC++ COM object internally.
My question is, assuming the ASP page which loads the object does not immediately exit, will the VB COM object be able to receive the events from the internal object?
We are using .net 1.1 on windows 2003 server. This is we are facing in our
production server.
When we are doing the load testing we are getting the bellow error. While
the load testing this error is not coming frequently. When we run 20 threads
for 3 mins we are getting this error message 2 or 3 times. But this line of
code is executed by all the threads. Code:
I want to open a recordset object on an .asp page. When I open the recordset I would like to use a stored procedure that expects a parameter to be passed for the stored procedure. I will then use the recordset to loop thru the recordset, update values from the recordset and then update the database by passing parmeters to another stored procedure.
I would like to use the recordset object but can it be used to pass a parameter to a stored procedure? Do I need to use a command object to open the records instead in
order to pass the parameter to a stored procedure?
I have a custom function for checking if a variable has been set or not to make the code easier to read, as well as to keep it shorter.
However, I'm getting errors that "Object Variable not Set", even after I've already checked for null and empty. Code:
A three-tier user authentication system was running without a problem for almost a year and now is suddenly dysfunctional. We don't know of any changes to any of the servers. It's quite maddening. The details:
1) We know the COM+ app is instanced on the COM+ server (Win 2000). The component graphic spins when CreateObject is called.
2) The proxy is installed on an IIS server (Win 2000) with delivers the interface, written in ASP, to the client PC.
3) These are the error messages displayed when a method of DAMS is called: Code:
I'm working on a "hybrid" application some classic ASP, and some
asp.net. I'm trying to develop a support type page that checks necessary
components, database connections etc.. last item is to check for the .NET
extensions. Is there a way to do that from a classic ASP page?
I am working on a website that requires a login before accessing an appointment book application written in ASP.Basically what I want to do is when the customer first clicks on "appointment_book" link, it takes them to the registration form. After they are registered, It will then redirect them to the actual application.
I also want the same thing to happen when a customer clicks on the login link. I want them to login, then get redirected to the appointment_book.
at the moment the customer click on the registratration link and it shows them the registration form, they are then automatically logged in after registration. However, when I click on the Appointment_book link again, it brings me back to registration form. How can I have the link always point to the appointment book after they are registered or logged in?
let say:
http://www.domain1.com/index.asp?url=http://www.xxx.com/file.asp
can i restrict that only domain1.com can access to http://www.xxx.com/file.asp page?
so when user suft http://www.xxx.com/file.asp, they unable to view the content.both domain is on diff IP.
I have a form with several check boxes.they are all set to default to "unchecked."The db also defaults to unchecked.But,as soon as we hit the "form1.recordset.addnew" all of the cb's change themselves to "checked."?
Does anyone know of any nice ready made asp scripts to check a website's visitors age? I mean the sort of thing you see where you have to choose your day, month and year of birth from drop down lists to comply with US laws Code:
View Replies View Related