Numeric Value And String
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:
View Replies
ADVERTISEMENT
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.
Code: ....
View Replies
View Related
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:
View Replies
View Related
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:
SELECT *
FROM Table
WHERE Variable = Numeric
Is something like that possible?
View Replies
View Related
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.
Any ideas?
View Replies
View Related
How can I check that entered value in a text box is numeric or not in next page?
View Replies
View Related
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.
View Replies
View Related
how to control numeric entry into a textbox? so that no other character is allowed only numbers and decimal?
View Replies
View Related
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
View Replies
View Related
if i have a text as follow :
my phone number is 0123456789
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 :
my phone number is xxxxxxxxxx
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
I just can't seem to figure out this problem Here's the code:
minv = request.form("min")
maxv = request.form("max")
price = request.form("price")
Response.write(minv &" "& maxv &" "& price)
sSQK = "INSERT INTO tbl_weight (min, max, price) Values (" & minv &","& maxv &",'"& price &"')"
conn.Execute(sSQK)
Response.write("Gegevens toegevoegd!")
But it just keeps givving me an error
"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 ?
View Replies
View Related
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.
Any ideas?
View Replies
View Related
I need access to the bits of a Byte expression and the logical functions operatge bit-wise on numeric vales - per the VBScript CHM.
So how do I convert a Byte to its numeric value?
View Replies
View Related
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.
View Replies
View Related
How do I do that? This is for some bit-diddling, but the logical functions like AND require numeric expressions, per the book.
View Replies
View Related
How do I change this output to give me numbers instead of letters: Code:
Dim intCounter, intDecimal, strTicket
For intCounter = 1 To 6
Randomize
intDecimal = Int((26 * Rnd) + 1) + 64
strTicket = strTicket & Chr(intDecimal)...
View Replies
View Related
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 .
View Replies
View Related
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:
View Replies
View Related
I'm developing an Asp.NET system to take a CSV file uploaded via the web, parse it, and insert the values into an SQL database. My sticking point comes when I try to split() the string returned by readline() on the file.
The following code snippet works for me:
tokens = "one,two,three,four".Split(",")
for each token in tokens
response.write("<td>"+token+"</td>")
next
However, if I take the next line in the CSV, read using StreamReader.ReadLine on the PostedFile.InputStream, I receive "Object reference not set to an instance of an object." which I have narrowed down to be my string holding the line. Further investigation reveals that no other string member functions work on my line (.ToCharArray, .ToString, etc).
I suspect that StreamReader.ReadLine is not correctly returning a string, even though Response.Write(line) displays what I would expect .....
View Replies
View Related
I have a form in which several elements are expected to be all digits. Some of those elements can be left empty, but if specified they must be all digits. I have this Sub to edit them: ....
View Replies
View Related
I am pulling info from a sql server By default the query pulls back the inforamtion as text.Therefore when I go to calculate some figures its giving me a type mismatch error.
Is there a function in can call to convert a text string to an integer string using
rstSearch.Fields("name").Value .To pull back the info in a for loop
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch
View Replies
View Related
If a visitor doesn't put anything in the "Search" text box I'd like them to
be redirected to where they came from before the search form forwarded them
to the search.asp page. Therefore I've put the following at the top of
search.asp to do this.
View Replies
View Related
I am trying to search my access database for a string using LIKE and a wildcard.
Example:
Code:
Dim con
con = "SELECT names.* WHERE name LIKE 'sam*'"
For some reason this gives me no results even though I verified there is entries with the word sam in them.
Also tried using % instead of *. Also took out wildcard. I can search for an integer without a problem though, when I try a string, regardless if there's relevant entries I get nothing back at all.
View Replies
View Related
I am using an SQL statment with a LIKE clause. I am trying to print the actual SQL statement on the screen. However I cannot print a '%' character on the screen. I tried using Chr code and just % outright.
Random variables:
name, rank
Code:
sSQL = "SELECT * from myTable WHERE myField LIKE '" & name & "%'"
It just prints on the screen: (assume name=joe)
"SELECT * FROM myTable WHERE myField LIKE 'joe'"
View Replies
View Related
i have an object which is a string, (objrs4("points")) how do i convert it into int numbers.
View Replies
View Related
i need requirement for the current assignment Im working on.Part of my assignment I have to saved updated data from a datagrid and put into database. I had everything working, but without option strict and explicit. When I put it on i'm having trouble getting the value out of it.
What I need is to get the value out of the textbox control of a datagrid in edit mode. The value is supposed to be in Item.cells(2).Controls(0) but I have no clue on how to get it out correctly. Ive tried everything but keep getting errors that it cannot be converted to a string.
View Replies
View Related
the subject that i need to filter the URL from a memo field that having lots of URL in it, like when we post a message with URL www.websourceinfo.com it will become a base url link with click
View Replies
View Related
I searched google for this (probably easy to solve) problem, but all answerd there did not work hop someone can help me out.In an asp I want to check whether a string contains a " if so the response should be that the "-sign is not allowed.
Elseif InStr(1, username, """) > 0 then Response.Write "-sign is not allowed in the username."
Tried char(34) and /" and """ but none of these options seem to work.
View Replies
View Related
I guess this is easy, but I ask anyway.How can I cut 'www.' and '.no' or '.com' from a string?
example input:
www.norway.no
www.somewhere.com
I want this output:
norway
somewhere
How can I do this?
View Replies
View Related
splitted from this thread, I need to dosomething similar i need comare 2 variables. one of them conaints the other variable but have more information
i need compare
a= "red car"
b= "red"
and then i need ask if is b in A then c=b but i dont know how.
View Replies
View Related
converting string to hex like so:
for x = 1 to len(source)
target = target & hex(ascw(mid(source,x,1)))
next
How to convert it back to a string?
I got as far as:
for x = 1 to len(source) step 2
target = target & chr("&H" & mid(source,x,2))
next
but this fails with the pound sign (£ - £)
View Replies
View Related
