Where Package_id in (<cfqueryparam value="123456789, 1234567800, 123576576, 7374474747" cfsqltype="integer" list="yes">)

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

  ----- Original Message -----
  From: Ciliotta, Mario
  To: CF-Talk
  Sent: Tuesday, July 27, 2004 9:29 AM
  Subject: CFQUERYPARAM

  Hi,

  I have a query that I am doing and I want to add the CFQUERYPARAM tag to it.
  What is the value for the tag for a comma delimited list of values.  

  Here is the Query:

  <CFQUERY NAME="Packages">
  Select Package_ID, Package_Cost,Package_Date
  From tbl_packages
  Where Package_id in (123456789, 1234567800, 123576576, 7374474747)
  </CFQUERY>

  Is it:

  <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#Package_List#">

  Thanks,
  Mario
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to