Comparing Numeric Values

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


ADVERTISEMENT

Decimal Numeric Values

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

Type Mismatch Error(numeric Values)

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

Comparing Recordset Values

i have a a SQL stored SP bringing out one recordset, I have a loop reading out all the records, what I would like to do it compare each record to the previous one and if it is the same then do something. I'm having trouble figuring out how to do the comparison as I loop through the records

View Replies View Related

Comparing Values In File With Db

I have an excel file with some data inside. I have to check the data in the excel file against that in access and print out all similar records. For example in the excel file in just one column: Code:

View Replies View Related

Comparing Count To Array Values

I have the following code to check if a field number matches a specific value. here is the code:

View Replies View Related

Numeric ASP

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

SQL Numeric

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

Numeric Variables

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 To Check Given Value Is Numeric Or Not

How can I check that entered value in a text box is numeric or not in next page?

View Replies View Related

Numeric Characters

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

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 View Related

Numeric Entry

how to control numeric entry into a textbox? so that no other character is allowed only numbers and decimal?

View Replies View Related

Numeric Validations

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

How To Check A Numeric

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

Numeric Fields

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

INSERT Numeric Variable

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

Issue With Numeric Variables

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

Convert Byte To Numeric Value

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

Converting A Byte Value To Its Numeric Value

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

Numeric Output Instead Of Letters

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

Split String Alpha Vs Numeric

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

How Do I Create A Numeric-type ADO Parameter Objectin Classic ASP

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

Comparing Value

I have an array, let's say: a(test1, test2, test3). test1 = 1, test2 = 3, test3 = 4.
I have a for loop:
for z= 0 to 2
if a(z) > 0 then (what I am trying to do is if test1 > 0 then do ...)
somecode
end if;
next
Could anyone let me what is wrong with my if statement? The code inside the if statement does not executed.

View Replies View Related

Comparing

let.... the strings are

a="234.5;678.3 "
b="678.3 "

on comparing this two i want to get 0 if the b value dosnt exist in a must return 1 .

View Replies View Related

Comparing Strings

i am having a problem with comparing two strings. I am taking
in the parameter rs("Company") and if this is empty i want to put some
text in there. I am testing it with an empty Company field and comparing
it like so:

temp1=rs("Company")
temp2=StrComp(temp1,NULL)

I have also tried it with
temp2=StrComp(temp1,"")

but each time i get nothing returned. Is there some rule about comparing a
string with an empty string?

View Replies View Related

Comparing Dates

I have an expiry date stored as a text field in the
following way "2003-08-23" (this gets round the US/UK
date prob)

The problem is I want to be able to show a Renew option
on the page FROM 30 days prior to that date. And then of
course if they don't renew, it unsubscribes them.

Question, how can I compare this date to see if todays
date is 30 days or closer to the expiry date?

View Replies View Related

Comparing Two Fields

Is there a way to do the following select (like in Dlookup?)

SELECT Permit_No FROM Table1 WHERE Table1.Address like Table2.Address

I want to get Permit_No from table1, but its WHERE condition depends on comparing two address fields in different tables. Will that work?

View Replies View Related

Comparing Tables?

I have this page with a drop down box which loads the itemnumbers dynamically. However, I want it to NOT load the numbers that already exist in the weborderlist. What can I do to my SQL statement to make this work?

Code:

SELECT (SELECT img_inv.item_num from img_inv, weborderlist WHERE img_inv.item_num <> weborderlist.item_num and weborderlist.orderid= '1') as test

View Replies View Related

Comparing Dates

how can i redirect a user when its 2 days before New Years, based on Date().

View Replies View Related

Comparing Two Tables

How do I compare the contents of two tables, to see what doesn't exist in the one table?

Something like "select company.name, company_scores.company_name from
company, company_scores where company.name not in
company_scores.company_name" ?

View Replies View Related

Comparing Unicode Value

Need to do a search engine to search through a bunch of static pages (html)). so uing asp. but the page is in chinese, so how do i scan each and every html file and search for the chinese word?

View Replies View Related

Comparing Of Recordsets

I have the following code with me Code:

<%
rs=Server.CreateObject("ADODB.recordset");
rs1=Server.CreateObject("ADODB.recordset");
sql="select coi_index_number,status,mkt_id_swno_0,mkt_id_swno_ 1,mkt_id_swno_2,mkt_id_swno_3,mkt_id_swno_4,mkt_id _swno_5,mkt_id_swno_6,mkt_id_swno_7,circle,name_of _msc from coi where coi_index_number='"+p2+"'";
sql1="select coi_index_number,status,mkt_id_swno_0,mkt_id_swno_ 1,mkt_id_swno_2,mkt_id_swno_3,mkt_id_swno_4,mkt_id _swno_5,mkt_id_swno_6,mkt_id_swno_7,circle,name_of _msc from coi1 where coi_index_number='"+p2+"'";
%>

Now i need to compare these two above mentioned recordsets....and want to pop up an alert box on the client side.....sayin whether they are same or no.

View Replies View Related







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