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
CLIENTID1=3
CLIENTID2=1
CLIENTID3=1
CLIENTID4=4
CLIENTID5=2
FRIHOURS1=0
FRIHOURS2=0
FRIHOURS3=0
FRIHOURS4=0
FRIHOURS5=0
MONHOURS1=0
MONHOURS2=1.50
MONHOURS3=2.00
MONHOURS4=2.00
MONHOURS5=0
SATHOURS1=0
SATHOURS2=0
SATHOURS3=1.50
SATHOURS4=0
SATHOURS5=1.25
SUBMIT=Preview Timesheet
SUNHOURS1=1.75
SUNHOURS2=0
SUNHOURS3=0
SUNHOURS4=0
SUNHOURS5=0
TASKID1=5
TASKID2=1
TASKID3=1
TASKID4=8
TASKID5=6
THUHOURS1=2.25
THUHOURS2=0
THUHOURS3=0
THUHOURS4=2.50
THUHOURS5=1.25
TUEHOURS1=1.50
TUEHOURS2=0
TUEHOURS3=0
TUEHOURS4=2.25
TUEHOURS5=2.50
WEDHOURS1=0
WEDHOURS2=2.00
WEDHOURS3=0
WEDHOURS4=0
WEDHOURS5=0
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
