On Fri, May 23, 2008 at 1:14 PM, Patrick Hedgepath <[EMAIL PROTECTED]> wrote:
> Can anybody see the syntax error that CF8 keeps giving me for this query? The
> query was made by DW CS3 and worked until I added a new field by hand
> (Location). I can't see any reason it would not work.
>
> , Location=<cfif IsDefined("FORM.Location") AND #FORM.Location# NEQ "">
> <cfqueryparam value="#FORM.Location#" cfsqltype="cf_sql_clob" maxlength="15">
> <cfelse>
> 0
> </cfif>
shouldn't your <cfelse> be an empty string ("") instead of a 0?
--
A byte walks into a bar and orders a pint. Bartender asks him "What's
wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I
thought you looked a bit off."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305964
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
