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]
- Invalid data type for BIGINT...why? Rick Faircloth
- RE: Invalid data type for BIGINT...why? Philip Arnold
- RE: Invalid data type for BIGINT...why? Rick Faircloth