Re: insert data in to columns base on the selection of the list box.

2007-04-03 Thread Carlos Proal
Can you tell us what exactly is your problem ? ie returned error, logic, or what ? My first impression es that your insert is wrong, because inserts cant have "where" conditions (it makes no sense) probably you want to do a completely new insert including the column1 or maybe you want an u

RE: insert data in to columns base on the selection of the list box.

2007-04-03 Thread Jerry Schwartz
Without knowing where the values of column2, column3, and column4 are coming from it's a little hard to say what the best technique would be. Usually one would take the POSTed value from the select control and use it to retrieve the related data from a table in your data base. Regards, Jerry Sch