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

Reply via email to