jeudi 8 août 2019

Putting the Value of the query in a checkbox

I have this data coming to me:

Query

Template: C:\lucee\tomcat\webapps\proj1queryies.cfm 
Execution Time: 36.1 ms 
Record Count: 2 
Cached: No 
Lazy: No 
SQL: 
SELECT TOP 100 * FROM tables order by 1 desc; 
ID  username    password    status
1   2   abx         Test         1
2   1   xyz         Test1        1

In my checkbox, which is just under the cfoutput query, i want to use the value of each column's value

but i cannot add a checkbox to all columns, the checkbox should appear appear in the first td, but the value should be dynamic based upon the chosen field value

so question, is there a different way to loop over query so i can use column names also, as cfoutput, i can't use the columnnames and they are dynamic




Aucun commentaire:

Enregistrer un commentaire