numeric value and string

[Iona]

okay.. this should be long..

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.

Can anyone help me to overcome this?

here''s part of my code

If (diff = 0) OR (diff = 1) Then
If (maxunit1 < strnoofunit) OR (maxdoc1 < strnoofdoc) Then
rs2.close
conn.close
set rs2 = nothing
set conn = nothing
Server.Transfer ("maxunit2.asp" )
End If
ElseIf (diff = 2) Then
If (maxunit2 < strnoofunit) OR (maxdoc2 < strnoofdoc) Then
rs2.close
conn.close
set rs2 = nothing
set conn = nothing
Server.Transfer ("maxunit2.asp" )
End If
ElseIf (diff = 3) Then
If (maxunit3 < strnoofunit) OR (maxdoc3 < strnoofdoc) Then
rs2.close
conn.close
set rs2 = nothing
set conn = nothing
Server.Transfer ("maxunit2.asp" )
End if
ElseIf (diff = 4) Then
If (maxunit4 < strnoofunit) OR (maxdoc4 < strnoofdoc) Then
rs2.close
conn.close
set rs2 = nothing
set conn = nothing
Server.Transfer ("maxunit2.asp" )
End If
ElseIf (diff = 5) Then
If (maxunit5 < strnoofunit) OR (maxdoc5 < strnoofdoc) Then
rs2.close
conn.close
set rs2 = nothing
set conn = nothing
Server.Transfer ("maxunit2.asp" )
End If
Else
If (maxunit6 < strnoofunit) OR (maxdoc6 < strnoofdoc) Then
rs2.close
conn.close
set rs2 = nothing
set conn = nothing
Server.Transfer ("maxunit2.asp" )
End If
End If

'' -------------------------------------------------------------------------
'' finish
'' -------------------------------------------------------------------------
rs.Open "SELECT * FROM timesheet", conn, 3, 3
''Add a record
rs.AddNew
''Put username and password in record
rs("memberid") = Session("member id")
rs("reference_n o") = strrefno
rs("entry_date" ) = date()
rs("lspid") = Session("lspid" )
rs("solicitorid ") = Session("solid" )
rs("code") = strcode
rs("no_of_unit" ) = strnoofunit
rs("no_of_docum ent") = strnoofdoc
rs("note_legalm atter")= strlegalmatter
rs("note_entitl ement")= strentitle

''Save record
rs.Update

Thanks guys

-----------------------------
This message is posted by http://asp.forumszone.com

[Ray Costanzo [MVP]]

Don't store numeric data as text.

I'm not sure what your code is supposed to be doing, but if you're doing the
comparison in your code (as opposed to in a SQL [non]query), you can CInt
the values to compare them. You can also do that in the query.

iCurrentValue = yourRecordset.F ields.Item("you rColumn").Value
If iCurrentValue <> "Unlimited" Then
If CInt(iNewValue) > CInt(iCurrentVa lue) Then
''your code
End If
End If

Ray at work

"Iona" <io**********@h otmail.com> wrote in message
news:87******** *****@asp.forum szone.com...

okay.. this should be long..

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.
Can anyone help me to overcome this?

here''s part of my code

If (diff = 0) OR (diff = 1) Then
If (maxunit1 < strnoofunit) OR (maxdoc1 < strnoofdoc) Then
rs2.close
conn.close
set rs2 = nothing
set conn = nothing
Server.Transfer ("maxunit2.asp" )
End If
ElseIf (diff = 2) Then
If (maxunit2 < strnoofunit) OR (maxdoc2 < strnoofdoc) Then
rs2.close
conn.close

[Hal Rosser]

"Iona" <io**********@h otmail.com> wrote in message
news:87******** *****@asp.forum szone.com...

okay.. this should be long..

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.
Can anyone help me to overcome this?

If your data is brought in as a string, you need to cast it to a number to
be able to compare it numerically.
when you compare strings, it looks at the characters - not the actual
numbers.
f'rinstance:
If isNumeric(strVa riableName) then
dim intTemp as Double= System.Convert. ToDouble(strVar iableName)
etc
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.807 / Virus Database: 549 - Release Date: 12/8/2004