Hi,
I am trying to "preload" a table with information based upon (1) some user
interaction and (2) stored information in another table. The user
information is no problem as it is in a form and I can pass the variables
along. The problem I have is in trying to use all the records I retrieve
with my SELECT statement. When I try to INPUT the new data into the table,
I only get the first record into the table even though the SELECT is
retrieving all my records. So, I tried using an array and looping in and
out to enter the data and then get it out. However, I can not seem to
retrieve the data for the INPUT statement as I tried nesting it within the
CFLOOP for auto-incrementation. Essentially, I am trying to input each data
point one at a time since my large SELECT results would not enter the entire
set.
Does anyone have a suggestion? I am stuck and am not sure where to go
from here. I appreciate any suggestions and would like to thank you in
advance.
emilio
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com