Hi there
That works except for the fact that I hit the query first and get an error
Incorrect syntaz 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#)
Can I use a cfqueryparam to get around the problem?
Tks 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290121
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
