<form> within <query> thus <input> each row with two links EDI 1

[josel]

This might soun crazy but here it is anyway.

<cfquery name=&quot;items&quot; ...>
select *
from items
</cfquery>

<cfoutput query=&quot;items&quot;>
<cfset count=#count# + &quot;1&quot;>
<cfset formname=&quot;name#count#&quot;>
<cfset colx=&quot;colx#count#&quot;>
<cfform name=&quot;#formname#&quot; action=&quot;itemsAction.cfm?...>
<table ...>
...
<cfinput name=&quot;#colx#&quot; ...>
<input type=&quot;sumit&quot; name=&quot;sumitx&quot; value=&quot; Sumit &quot;>
...
</table>
</cfform>
</cfoutput>

The idea is to be able to display all rows within a table and allow users to edit any row and sumit change for that row alone.

Also, be able to delete that row ONLY. So, the row might look like this:

ITEMCODE ITEM DESCRIPTION BLA BLA BLA Update Delete

The links or buttoms Update/Delete should trigger the action page or function(s) responsible for such deeds ...

The 1,000,000.00 questions are:

A) Am I off track? Above approach would be overkill ...
B) Is this best done using arrays? I am not at that level yet 8-(
C) Does anyown know of some tutorial that shows how somethign like this can be done?

Thank you all in advance!

josel If you have the knowledge, consult and educate those who need it! - Jose Lerebours

 

[tleish]

Have you looked into <CFGRID>?

http://www.macromedia.com/v1/docume...n/12_building_dynamic_java_forms/dwa12_07.htm

- tleish

 

[josel]

I will now! This looks very promising, thanks!!!!

josel If you have the knowledge, consult and educate those who need it! - Jose Lerebours