> You might have decimal or some other form that will pass the IsNumber()
> test, but fail on the query. CFDUMP is your friend.
If I am specifically after a positive integer I use...
reFind('[^\d]',variable)
which will return 0 if nothing but numbers are found, very usefull for
database keys which are almost always positive integers.
--
Jay
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2890
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
