Select records to show on action page 2

[toyt78]

I have a page that list all my records in an Access 2000 database.

I want to be able to check boxes next to specific records and then show those records only on the action page.

I seem to be having problem fetching the checked checkboxes where it always shows all the records on the action page instead of just the records I selected (checked).

Please advise.

<cfquery name="queOne" datasource="dsn">
SELECT *
FROM theTable
</cfquery>
<cfoutput query="queOne">

<form method = "post" action = "theActionPage.cfm">
<input type="Checkbox" value="#ID#" name="theCheck"> #name#

</cfoutput>
<br>
<input type="Submit" value="Submit">
</form>

theActionPage.cfm page

<cfparam name="form.theCheck" default="">
<cfquery name="que" datasource="dsn">
SELECT *
FROM theTable
</cfquery>

<cfoutput query="dsn">
<cfif listLen(form.theCheck) gt "">
  #ID# #name#<br>
</cfif>
</cfoutput>

 

[krisbrixon]

The checkbox will return a comma delimted list.

I would use the IN clause in SQL to limit my results to those results

<cfparam name="form.theCheck" default="">
<cfquery name="que" datasource="dsn">
SELECT *
FROM theTable 
WHERE ID IN (#FORM.theCheck#)
</cfquery>

<cfoutput query="que">
  #que.ID# #que.name#<br>
</cfoutput>

Also, the query name in the cfoutput was set to the datasource not the name.

Kris Brixon
www.brixon.org

 

[r937]

actually, the way the first page is coded, there are N forms, all named the same, and each one contains only one checkbox

what the action page receives is probably only the last form, with exactly one checkbox, and it'll be either checked or not

so why does it show all the records?

because whether it is checked or not, you CFPARAM the checkbox to an empty string!

this means it exists, which means that listLen(form.theCheck) will always be 1

why 1? because ListLen gives you the number of elements in the list

now, you tell me, is 1 greater than an empty string?

looks like it is, which is why you get all the records printed




r937.com | rudy.ca

 

[krisbrixon]

good eye Rudy, there are multiple problems. I missed that.

Change:

<cfoutput query="queOne">
<form method = "post" action = "theActionPage.cfm">

To:

<form method = "post" action = "theActionPage.cfm">
<cfoutput query="queOne">

Your first page has many <form> tags and one </form> tag.

Kris Brixon
www.brixon.org

 

[toyt78]

Thanks!!