On Fri, May 23, 2008 at 1:58 PM, <[EMAIL PROTECTED]> wrote: > When I change it to CF_SQL_NUMERIC the error persists. Even if I remove > the entire statement > > , Location=<cfif IsDefined("FORM.Location") AND #FORM.Location# NEQ ""> > <cfqueryparam value="#FORM.Location#" cfsqltype="CF_SQL_NUMERIC" > maxlength="15"> > <cfelse> > 0 > </cfif> > > The error still persists.
is it numeric or is it integer? if the error persists without that line, can you paste the query as you currently have it? -- 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:305978 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4