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>
--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.251 / Virus Database: 263.3.3 - Release Date: 6/18/2004
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to