Not likely it's null but I went ahead & tried it using VAL & still get the same error.
Any other suggestions? This site is using CF5 if that helps - database is SQL 2000 Thanks, Donna >Is it possible there's a null value in that column? That would result in >an empty string for CF and "gt" would be an invalid operator. > ><cfif val(getDollDetails.price) gt 0> might be better. > >-----Original Message----- >From: Donna French [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 10, 2006 5:02 PM >To: CF-Talk >Subject: CFIF inside a Form > >I'm trying to use the following code inside a <FORM> tag that uses POST: > ><cfif getDollDetails.price gt 0> > <input type="hidden" name="price" >value="#Trim(getDollDetails.price)#"> ><cfelse> > <input type="hidden" name="price" value="#Trim(getDollDetails.srp)#"> ></cfif> > >Is there a trick to doing this because I've written similar code without >problems. The error says: > >An error occurred while evaluating the expression: > > price GT 0 > > >I'm scoping the price variable and quad checked the name of the query. >What am I missing here??? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249518 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
