I keep on getting an error now
Incorrect syntax near ')'
INNER JOIN dbo.People AS p ON p.people_Id = ps.peopleSummary_peopleId
WHERE peopleSummaryPeriod =
#getcurrentperiod.peopleSummaryPeriod#
AND ps.peopleSummary_peopleId IN (#form.availabletest#)
It bworks if I have selections made but I hit the query first and it strikes
this issue.
Can I use a cfqueryparam or something to get around this issue.
Tkx in advance.
>Try:
>where peopleid IN (#form.availabletest#)
>
>
>For some reason when I dumped the form neither of the boxes were displayed
>as being in the form and I have not been able to figure out why - its a
>mystery.
>
>So I have decided on an alternative strategy initially.
>
>Hi there
>
>I have now placed a select list on a page which is working properly. I have
>dumped the form and if I select 3 records from the list I have 3 items
>selected. So good so far.
>
>These 3 items are recordids - I want to use them in a query such as
>
>The code shows the select list and then after that is the query to select
>the records to use later on in the page.
>
>Thanks in advance.
>
>Toby
>
>
><select name="availabletest" size="10" multiple style="width:200;"> <cfloop
>query="getpeople"> <option value="#people_id#">#People_LastName#,
>#People_FirstName#</option> </cfloop> </select>
>
>
>
>SELECT p.people_id,
> p.people_FirstName,
> p.people_LastName
>From tbl_people p
>where peopleid = #form.availabletest#
>order by p.people_Lastname
>
>
>Thanks in advance for feedback
>
>T
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290122
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
