<cfset a = #select.columnlist#><cfloop index=

[vista]

<br><br>&lt;cfset a&nbsp;&nbsp;= #select.columnlist#&gt;<br><br>&lt;cfloop index=&quot;item&quot; list=&quot;#a#&quot; delimiters=&quot;,&quot;&gt;<br>&lt;cfoutput&gt;&lt;table border=&quot;1&quot; width=&quot;161&quot;&gt;<br>&lt;tr&gt;&lt;td width=&quot;60&quot;&gt;#item#&lt;/td&gt;<br>td width=&quot;85&quot;&gt;&lt;input type=&quot;text&quot; name=#item# size=&quot;10&quot; maxlength=&quot;10&quot;&gt;&lt;/td&gt;&lt;/tr&gt;<br>&lt;/table&gt;<br>&lt;/cfoutput&gt;<br><br>This code will loop the colummns from the table and present it in a form along with the text box on the side whose name i have given to be the same as the name of&nbsp;&nbsp;the columns.<br><br>My doubt is How do i insert the values&nbsp;&nbsp;in the textbox into the table ?<br><br>1)how will i write an insert statement for the same?<br><br>2)How will i validate these textboxes for&nbsp;&nbsp;number or characters?<br><br>3)How will i decide on the size of the textbox..a s it&nbsp;&nbsp;may vary from column to column..<br><br><br>but in the above loop..what would happen is i will get the list of the colummn on the lefthand and the textbox on the right hand with the same length and type which is not&nbsp;&nbsp;correct.<br><br>How do i solve this problem?<br><br>Thanx&nbsp;&nbsp;a lot<br><br>-shanks<br><br><br><br>

 

[SnakeHollywood]

The values in the textbox??<br>Can you explain exactly what data you are trying to output to the table.<br>a textbox assumes you have submitted a form and want the form values in the table, but you are looping through a select list of a query, so this is confusing as to what you are trying to do.<br><br> <p>Russ Michaels<br><a href=mailto:russ@satachi.com>russ@satachi.com</a><br><a href=

http://www.satachi.com>Satachi

Internet Development</a><br>For my personal book recommendations visit

http://www.satachi.com/books.html<br>

<br>