2. ASPRunnerPro General questions
  3. User option for each record returned.
This topic is locked

User option for each record returned.

 		10/21/2005 06:58:11
ASPRunnerPro General questions
P
 Paul S author

Hi,
I would like a field returned on the list and view pages as an input. I.e. like the delete checkbox. If the box is checked by a user then the corresponding table row no longer appears in the list view but is not deleted.
Is this at all possible? Or maybe via a hyperlink instead of a checkbox. In this case, is is possible to send a command to a database yes/no field in a http:// address.
Thanks

Paul
W
 		WeB 10/21/2005

In Step5 in the ASPRunner program you have the Edit SQL Query window. You can add a line at the bottom(end) of the query, something like this

where [hide] <> 'on'


You will substitue hide with your checkbox field name. This will only show records where the checkbox is not checked. If you ever wanted to turn that record back on so users could see it again you would have to go in the database and set that field back to null. Let me know if this helps.
P
 		Paul S author 10/22/2005

Sort of.
Basiclly I want to generate a checkbox in a field for each record returned in the list and view pages, except for those records of the logged in user. If this checkbox was then checked by another user who was viewing records, it would change the value of that field in the Database to no. This field in the DB would already be Yes by default.
I guess what I really would like is the 'Edit As' options on the formatting page of ASPPro to be in the 'View As' options too.
Thanks for your help.

Paul
Sergey Kornilov admin 10/25/2005

Paul,
we thought about ading a Checkbox as a "View as" option.
The problem is that checkboxes on the list page would confuse users because they cannot really edit data on this page.
P
 		Paul S author 10/26/2005

Sergey,
Thanks, I understand, I shall try a different approach.
Paul