You can also try:
INNER JOIN dbo.People AS p ON p.people_Id = ps.peopleSummary_peopleId
WHERE peopleSummaryPeriod = #getcurrentperiod.peopleSummaryPeriod#
<cfif len(trim(form.availabletest))>
AND ps.peopleSummary_peopleId IN
(#listQualify(form.availabletest,"'")#)
-----Original Message-----
From: Azadi Saryev [mailto:[EMAIL PROTECTED]
Sent: Thursday, 4 October 2007 12:01 PM
To: CF-Talk
Subject: Re: code not working
you can. try:
<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.availabletest#"
list="yes"> instead of your #form.availabletest#
but i think you should also do:
INNER JOIN dbo.People AS p ON p.people_Id = ps.peopleSummary_peopleId
WHERE peopleSummaryPeriod =
#getcurrentperiod.peopleSummaryPeriod#
<cfif len(trim(form.availabletest))>
AND ps.peopleSummary_peopleId IN (<cfqueryparam
cfsqltype="cf_sql_varchar" value="#form.availabletest#" list="yes">)
</cfif>
and make sure that you cfparam your from.availabletest at the top of your
page!:
<cfparam name="form.availabletest" default="">
Azadi
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290129
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
