converting html text to float

[dcarbone]

I'm trying to insert a number collect from an HTML text box, into an access database, into a number field...but i always get type mismatch. How can i convert this to a number, because i dont want the field in the database to be text.

 

[GaryC123]

Variables are variable in ASP so you should just be doing

Insert into tablename (fieldname) Values (" & number & &quot"

Just make sure you don't enclose it in apostrophes

http://www.intouchmedialtd.com

 

[fergman]

it is also possible to use cint (type coeresion) it isn't really an int variable but it should work for your purposes.
if memory serves it is just cint(variable)

 

[Tarwn]

cLng, cDbl, and cDec are also available (as well as several more)

-T

[sub]01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111[/sub]
The never-completed website:

http://www.tiernok.com/