Are you using
<CFOUTPUT QUERY="YourQuery">
<TR>
<TD#YourQuery.Data#</TD>
<TD#YourQuery.Data2#</TD>
</TR>
</CFOUTPUT>
This should output new data on a new table row for each record in database.
Tomas
-----Original Message-----
From: Emilio Silvas [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 6:24 AM
To: CF-Server
Subject: Data Preloading
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
