attach check box with database query result

[sweetyp2005]

When I create table to show result of a database query, I want to have a check
box in front of each row. And When user select check box then save those rows
in one files. Is that possible? If so how can I do it?

[jdeline]

The action page (the one that is processed when a user clicks the submit
button) will contain the value of each check box if it has been checked. Save
this value in a database table. See sample code below, where the value "hello"
is stored into the database field "foo" if the checkbox is checked. Otherwise,
a null value is stored.



<!--- form with checkbox --->
<FORM ACTION="results.cfm" ... >
<INPUT TYPE="checkbox" NAME="foo" VALUE="hello">
<INPUT TYPE="submit">
</FORM>

<!--- this is results.cfm --->
<CFPARAM NAME="foo" DEFAULT="">
<CFQUERY NAME="bar" ... >
INSERT INTO myTable (foo) VALUES ('#foo#')
</QUERY>

[jjsand28]

This would be easier accomplished (once you get over the learnign curve) by
structures. Then you could save the whole structure to a text file or whereever
you are saving it.

[url]http://tutorial171.easycfm.com/[/url]

[coderWil]

How do you have the database table created. 1 row per result? (comma dilemited
list of saved results?) or 1 row per saved result (as many rows created as
checked results from form.

The former will require 1 query insert, the latter will require 1 query insert
inside of a cfloop (<cfloop list="#form.foo#" index="thisresult"><insert
statement></cfloop>

sample checkbox code (checkboxes give comma dilemited results for multiple
checks on checkboxes with the same name) If all checkboxes are unchecked, then
the result page won't even have the variable name (error checking needed here))

<cfloop query="queryname">
<input type="checkbox" name="foo" value="distinctvalue of query row">
some text to describe the row results<br>
</cfloop>