I recently moved our website to a new server (Windows 2000 / IIS 5 - same as
the previous server), and now I get type mismatch errors whenever a variable
is compared against a numeric value, unless I use the cInt function to
convert it to an explicit integer type.
For example, the following code:
dim sRecordCount
[open a database and assign the record count to the above variable...]
if sRecordCount > 0 then ...
On the new server I am forced to use: if cInt(sRecordCount) > 0 then ...
I can't figure out what has changed, if anything. Same OS version, same IIS
version.
After moving my website from one server to another (Windows 2000, IIS 5, same as old server), I am forced to use the cInt function to convert all variables that compare against a numeric value.
For example, on the old server I could code something like this: If sRecCount > 0 then . . .
The new server requires me to use: If cInt(RecCount) > 0 then . . .
If I don't use the cInt function, I get a Type Mismatch error. I can't see anything that is different from one server to another.
I need to display in my form fields the last record in my access database, which is a numerical value, then add 1 to that value. The code i have so far is: Code:
I'm trying to write an SQL statement that will pull out only numbers from a field. Within that field will be records that contain text, but i just want the records that have numbers in that field. Can I say something like:
I have a variable I'm pulling from a database that's a phone number in XXX-XXX-XXXX format. What I'm looking for is a way to strip out all non-numeric characters from the variable (XXXXXXXXXX). I don't want it to look only for "-", since sometimes, there are also alpha characters entered as well.
I made up a table in database with access consists of columns with text type. Some of them I put in data with numeric value and some of them I put in "Unlimited" as the value. Then, I allowed people to insert data but only with conditions. They can insert data if the value they are trying to insert is smaller than the one in the database. For "unlimited" value, they can insert any value. My problem is.... if the limited value in the database is 35, we cant insert data of 40 but we can insert data of 100. It seems that the code only takes the first number to be compared to the value in the database. Code:
I need some help on validating the number entered by the user in the ASP form . The number should be accepted in the format : 1,234.5648 and should be rejected in the format : 1, 234.456.46 or 1, 234.456 i.e. the format with more then one blank space or more then one decimal point etc.
i am trying with /^[0-9]*.[0-9]+$/; format. I checking all space and decimal point but also not taking data like 1.234
i need to check the text and not allow to have more than 7 digit number occur in the text and then change the 0123456789 to xxxxxxxxx.Finally the text will become :
I have a few ASP pages for my companies web site that allows members to enter reports. A big problem I am running into is for dollar amount/numeric data. The entry line consists of 7 input boxes.
3 of those boxes are used for dollar amounts, but I am having a problem when the member types anything other than what is expected; instead of 32.56 they may type in 32..56 this is just one of the types of keying errors. When the page is submitted and the validation/update script runs I will get "Type mismatch: 'ccur' " errors and the script will stop. is there a way to validate the numeric data so I can avoid these problems?
Normally to declare a value as numeric I use Clng() HOWEVER I now have some Numeric values with decimal places, which I need to tell the page when they are picked up from the form that they are in fact numeric, but retaining the decimal places too, which would I use... as all the ones I have used previously Cint, Clng, Fix, etc. do not retain the decimal places.
"Microsoft JET Database Engine error '80040e14' Syntax error in INSERT INTO statement. "
I think it has to do something with the "minv" and "maxv" those two are numbers and if I remove them the INSERT command goes fine... but what am I doing wrong ?
i have numeric value in my database with two decimal. now i have search page where user can type numeric value. so i want to compare user entered value with my db value. the result will give less than or equal value to user entered value. i had tried following
est = request.form("est")
sql = "select * from mytable where est_cost <= '%"&est&"%'"
but is not working. i think there is some syntax error in comparing numeric value.
I have a text file that I'm reading into a SQL table, from there I need to run various scripts on it to clean it up. One being, there is field that comes in as:
ie: JNJG12345 MAN5678 XY4656565
I need to split this by Alpha characters, then Numeric characters and be able to input them into seperate fields as such:
JNJG 12345 MAN 5678 XY 4656565
I have managed to locate a script that Memnoch came up with: http://forums.aspfree.com/t24666/s....ht=split+string that managed to get me where I am now.
How do I get the loop to stop once it finds the first occurence of a number? Below is the code I am using.
i have 3 columns in sql server . all of them are numeric value. when a user enter my site i take the value of userid (numeric one) i assign it as session("userid ") . after a query i take 2 value (both numeric again) from my table and write this code. if towhom=session("userid") then towhom=fromwhom . it gives an error .. how can i solve it. Type Mismatch Error .
I need to create an ADO Parameter object with the "Numeric" type. How do I go about this?
I thot that I'd be able to follow the pattern of creating ADO parameters with the more "regular" types (Varchar, Integer, etc..) but apparently, there's some conflict somewhere between my ASP line that calls ADO's CreateParameter method, the ADO Command's Execute method, and the SQLServer Stored Procedure's parameter declarations. Code:
I am trying to build a web based database using Access and ASP. I can retreive data form the database in a web page. I can send data from one page to another. However, I am stuck trying to figure out how to make the data variable. I would like the second page to display only data the user selected from a drop down list in the previous web page. I tried using the WHERE function and replace the hard coded information with a variable, but it isn't accepting the code. Could someone please help with this? I have research mulitple sites and can't find this particular piece of code or in tutorials. I must be missing something because seems like it would be basic stuff.
I'm trying to reference a username variable that is saved after the user logs in. I can reference it using $(Username) in standard html parts of the page but how do i use it in the script sections enclosed with <% %>
on the page.asp it searches the database for the specific record with id=3. now i cant use : variable = Request.Form("id"), because the information does not come from a form, and request.querystring doesn't want to work either.
I have a webpage with a list of items with checkboxes and a submit button. On the click of the submit button, I call a vbscript that loops through the items and put the values of the checked items in an array or string, and then jump to a new page.
Now I either want to send this variable to the new page, or I want to save the values to a mySQL database table, so I can use the values on the new page.
It seems I can't use session variables (session.contents) for this because that's server-side only.
Is there any way to get input boxes by thier id rather than thier name? (Request.Form("elementname")) I don't want to have to give every box its own id and name when they are just going to be the same.
I know that it's possible to pass more than one url variable using '&' querying 2 columns in the database.However,I want to pass both the words 'piano' and 'keyboard' to the same column [instruments] in a database).
Here is the code for just 'piano' and this works fine.
Search_quick.asp?<%="search="&"piano"%>
This is processed by a request.querystring("search")
I'm building an application that allows visitors to our site to view GPS survey data. The data is collected several times a day and the files written to a different directory each day. Thus, for July, there are 31 folders.
There is a calendar on the site that people can click on the date they want to get the data for. Then, a window will open and the contents of that days directory will be displayed in the window.
Our app is at http://test.c-b.com/CORS/ - the data is supposed to be accessed from the calendar but now all I can do is view the root files. I just can't figure out how to target another directory with the FSO using a variable passed from a querystring.
