> -----Original Message-----
> From: Pascal Peters [mailto:[EMAIL PROTECTED]
> Sent: 29 July 2004 17:23
> To: CF-Talk
> Subject: RE: Question about cfqueryparam
>
> You can't use cfqueryparam like this, it won't get evaluated. It has
to
> be in the cfquery.
>
> <cfquery datasource="media" name="get_office">
> select office_id
> from office
> #request.filter#
> where 0=0
> <cfif len(attributes.office_num)>
> and office_num in (<cfqueryparam list='Yes'
> value='#attributes.office_num#'
> cfsqltype='CF_SQL_VARCHAR'>)
> </cfif>
> </cfquery>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
