A text box that holds only ints ? 2

[neillovell]

<input type=&quot;text&quot; name=&quot;RowIDField&quot; size=&quot;4&quot; >

this is causing me problems in accessing my database because I am filtering using the autonumbers field. With this text box being text, the computer claims there's a mismatch in data types. How do I create a box that users input only numbers in to?

 

[neillovell]

Sorted, no need to worry

 

[HellTel]

An example of allowing only numerical input can be found at xutopia's site:

http://www.teaser.fr/~gharan/archive/good_keys.html

Of course, as it's a text input, the value will still be a text field, so you'll probably need to convert it.
value=parseInt(value);
will convert it to an integer.
Also, if you're using ASP, don't surround the variable with ' ' in your SQL statement as it will then consider it as text again.

 

[HellTel]

Oops, too late. How did you solve it?

 

[neillovell]

Oh in my SQL statement I had '' around the value, which was wrong. I looked up the parseInt function, and that didn't work (because of the '') - silly me!

Thanks for responding!!!!!!!!!!!

 

[xutopia]

I give a star to helltel for providing links to wonderful web sites! Gary

http://www.xutopia.com

Haran

 

[HellTel]