Ok, I think you are asking a bit much as you haven't posted any code to
indicate what you are trying yourself, but I'll give you a helping hand as
I'm sure I did the same when I started coding!
<!---First do a query to get all the employees names and ID's--->
<CFQUERY DATASOURCE="MyDSN" NAME="GetNameID">
SELECT ID, NAME
FROM tblEmployees
</CFQUERY>
<!--- Start the form--->
<FORM ACTION="EmployeeDetail.cfm" METHOD="POST">
<!---Output the query result, one employee and checkbox per line--->
<CFOUTPUT QUERY="GetNameID">
#GetNameID.Name# <INPUT TYPE="CHECKBOX" NAME="EmployeeID" VALUE="#ID#"><BR>
</CFOUTPUT>
<INPUT TYPE="SUBMIT">
</FORM>
<!--- Now on EmployeeDetail.cfm --->
<!--- Run the query to get all details of employees who were ticked --->
<CFQUERY DATASOURCE="MyDSN" NAME="GetNameID">
SELECT *
FROM tblEmployees
WHERE 1 = 1 AND
<CFLOOP LIST="#FORM.EmployeeID" INDEX="CurrentID">
OR ID = #CurrentID#
</CFLOOP>
</CFQUERY>
Hope this helps!
Ben
-----Original Message-----
From: Ang�l Stewart [mailto:[EMAIL PROTECTED]]
Sent: 05 July 2000 16:08
To: [EMAIL PROTECTED]
Subject: How do I read a list of employee IDs returned from a form,with
checkboxes??
Hi folkses!
G morning to you all :)
A client wants me to return a list of Employees by Department, which may
result in about 100 or so rows in a simple table.
He wants to click a checkbox / radio button to select say..20 employees that
she wants to edit.
(This can be anything else beside a checkbox..doesn't matter)
I need a way to then pull the Employee ID for these checked records, in
order to display them in a table on a followup page for editing.
How am I going to get these employee IDs to be passed to the next page when
she submits the form?
I'm stumped :-(
Oh..btw. My deadline for this is tomorrow morning.
wheee!
-Gel
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
