humbletechie
IS-IT--Management
Hi
I am running a select statement off one database to accumulate the needed records that I would like appended to an SQL database. I have the results of my select statement output to a page and the fields I want appended I have in hidden form fields. I then have the form post to an update page. When it appends the records it appends all the records into the same field rather then each as it's own record. Ex. orderno = 1234567,2345678,444444 name = name1, name2, name3
Can someone help me with the update code? I need each result to append to it's own ID.
Thanks!!
I am running a select statement off one database to accumulate the needed records that I would like appended to an SQL database. I have the results of my select statement output to a page and the fields I want appended I have in hidden form fields. I then have the form post to an update page. When it appends the records it appends all the records into the same field rather then each as it's own record. Ex. orderno = 1234567,2345678,444444 name = name1, name2, name3
Can someone help me with the update code? I need each result to append to it's own ID.
Thanks!!