Strings to Integers

[Phonez]

I realise that this might be the most easiest thing to do but for some reason I cant get it to work.

All I am trying to do is convert the value in a session variable into an integer so I can conpare it with a record in a database.

The term 'can't see the woods for the trees' comes to mind

 

[JohnYingling]

intW = Cint(strW)
lngW = CLng(strW)

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[cbokowski]

You should be able to use the CINT function
Cint(Session("blah&quot)

 

[Phonez]

This is the code that i've got:

num = Cint(session("client_id"))
.
.
strquery =  "select * from system where client_no = '" & num & "'"
set query = objconn.execute(strquery)
.
.

The client_no in system is a number anyway but I still appear to be getting a data type mismatch

 

[JuanitaC]

Take the single quotes off if you are passing a number... single quotes denote strings.

strquery = "select * from system where client_no=" & num