Ok... it's a draw. I think you both replied simultaneously
and with equal fervor!
Now, back to the issue at hand! :o)
The solution isn't working for me. (Even with CFQP)
<cfquery name="get_properties" datasource="XXXX">
select p.street_number, p.street_name, p.city
from properties p
where p.city in <cfqueryparam cfsqltype="cf_sql_varchar" list="yes"
value="#session.approved_cities#">
</cfquery>
Anything wrong with the code (typo's, etc)?
Any other ideas why it's not working?
Rick
> -----Original Message-----
> From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 30, 2008 7:31 AM
> To: CF-Talk
> Subject: RE: Any way to make this query work like this?
>
> I said this before you said that but I knew you were gonna say that so I was
> able to say this about that.
>
> ..:.:.:.:.:.:.:.:.:.:.
> Bobby Hartsfield
> http://acoderslife.com
> http://cf4em.com
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308312
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
