I get so used to typing them into <INPUT>'s that I sometimes
forget to leave them out...
Rick
-----Original Message-----
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 19, 2004 2:04 PM
To: CF-Talk
Subject: Re: Invalid data type for BIGINT...why?
Don't put CFOUTPUT inside the CFQUERYPARAM
On Sat, 19 Jun 2004 14:09:01 -0400, Rick Faircloth wrote:
>
> Why would this error code
>
> Invalid data '13' for CFSQLTYPE 'CF_SQL_BIGINT'.
> (13 refers to the Session.Subscriber_ID in the code below)
>
> be sent for the following code?
>
> <CFLOOP Index="Newsletter_ID" List="#Form.Newsletter_ID#"
> Delimiters=",">
>
> <CFQUERY Name="AddSubscription" Datasource="#DSN#">
>
> Insert into subscriptions
>
> (Session.Subscriber_ID, Newsletter_ID)
>
> Values (
> <cfqueryparam cfsqltype="CF_SQL_BIGINT"
> Value="<CFOUTPUT>#Session.Subscriber_ID#</CFOUTPUT>">,
> <cfqueryparam cfsqltype="CF_SQL_BIGINT"
> Value="<CFOUTPUT>#Newsletter_ID#</CFOUTPUT>">
> )
>
> </CFQUERY>
>
> </CFLOOP>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
