Re: Multiple updates

2002-04-15 Thread Kittiphum Worachat
> That the thing see, the form(using GET instead of POST) sends data with > the new dates like this:- > > id=1&name=Mark&job_number=AA1&job_date=2002-5-19 > &id=2&name=Mark&job_number=AA2&job_date=2002-5-21 > &id=3&name=Mark&job_number=AA3&job_date=2002-5-25 > > and the UPDATE query like this:- >

Re: Multiple updates

2002-04-15 Thread DL Neil
Mark, Earlier joke rebounds - pardon me whilst I wipe the comedic egg from my face... > That the thing see, the form(using GET instead of POST) sends data with > the new dates like this:- > > id=1&name=Mark&job_number=AA1&job_date=2002-5-19 > &id=2&name=Mark&job_number=AA2&job_date=2002-5-21 > &

Re: Multiple updates

2002-04-15 Thread DL Neil
Mark, Is it a two-fer-one sale today? > I'm now trying to UPDATE the three records with one query. > > Once the data is INSERTED into the db with this - > > insert into mytable (id,name,job_number,job_date) values > ('1','Mark','AA1','2002-04-15'), > ('2','Mark','AA2','2002-04-16'), > ('3','Mark

Re: Multiple updates

2002-04-15 Thread Mark Dale
That the thing see, the form(using GET instead of POST) sends data with the new dates like this:- id=1&name=Mark&job_number=AA1&job_date=2002-5-19 &id=2&name=Mark&job_number=AA2&job_date=2002-5-21 &id=3&name=Mark&job_number=AA3&job_date=2002-5-25 and the UPDATE query like