Do you REALLY need it to be "01"? Or are you comparing numerical values? You
can just use the Int() function on both values... like
<CFIF Int(SQLvar) EQ Int(Formvar)>
Though as long as you use "EQ" instead of "IS" (which is used to compare
STRINGS), you shouldn't need the Int() function at all...
----- Original Message -----
From: "David Baskin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 2:56 PM
Subject: 1s and 01s
> Hello, i'm passing a number from a form and then comparing it with a
number
> pulled out of the DB (SQL server) but when i do the comparison it's
against
> 1 (passed by the form) and 01 (passed by SQL). Can anyone tell me how to
> format the number coming from the form and CF to pass or be written as 01?
> Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
