Gina,
I don't have a specific response to your question, only a suggestion. If
your form fields correspond to columns in a table, you might find
everything much easier to deal with if you modify the structure of your
database. You have, essentially, these types of information:
CLIENTID1,TASKID1,SUNHOURS1,MONHOURS1,TUEHOURS1,WEDHOURS1,THUHOURS1,
FRIHOURS1,SATHOURS1. To get different ClientIDs, you change the "1" to a
different number and add new columns to the table.
What you might consider is breaking this up into at least two tables, one
for the ClientID, and the second one for the tasks and hours associated
with that ID. All of the fields in the second table can have the ending
number dropped, then be combined into a single table with only 9 columns.
The ClientID field would be the link back to your Client table. Doing this
will shrink the size and complexity of your database, make it easier to add
new ClientIDs, if needed, and make inserts, updates, and deletes, not to
mention select queries, a snap to write.
HTH,
--John
Gina Shillitani
<gshillitani@Gecko To: "'[EMAIL PROTECTED]'"
Media.com> <[EMAIL PROTECTED]>
cc:
09/05/2000 08:10 Subject: Inserting (or updating)
more than one record
AM at a time
Please respond to
cf-talk
I have more than one set of fields to insert or update in a table. See
below
for the fields and sample data... can someone tell me the best way to
insert
or update multiple rows?
Form Fields:
FIELDNAMES=CLIENTID1,TASKID1,SUNHOURS1,MONHOURS1,TUEHOURS1,WEDHOURS1,THUHOUR
S1,FRIHOURS1,SATHOURS1,CLIENTID2,TASKID2,SUNHOURS2,MONHOURS2,TUEHOURS2,WEDHO
URS2,THUHOURS2,FRIHOURS2,SATHOURS2,CLIENTID3,TASKID3,SUNHOURS3,MONHOURS3,TUE
HOURS3,WEDHOURS3,THUHOURS3,FRIHOURS3,SATHOURS3,CLIENTID4,TASKID4,SUNHOURS4,M
ONHOURS4,TUEHOURS4,WEDHOURS4,THUHOURS4,FRIHOURS4,SATHOURS4,CLIENTID5,TASKID5
,SUNHOURS5,MONHOURS5,TUEHOURS5,WEDHOURS5,THUHOURS5,FRIHOURS5,SATHOURS5,SUBMI
T
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.