RE: SQL Update - Now I'm royally confused

2001-02-20 Thread Philip Arnold - ASP
> Hint look at the SELECT INTO Statement Normally I wouldn't have this problem, but I think the 80+ hour weeks are catching me up Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" **

RE: SQL Update - Now I'm royally confused

2001-02-20 Thread Donn
Hint look at the SELECT INTO Statement -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 8:16 AM To: CF-Talk Subject: RE: SQL Update - Now I'm royally confused > I have not tested this but try > > UPDATE t1 >

RE: SQL Update - Now I'm royally confused

2001-02-20 Thread Philip Arnold - ASP
> I have not tested this but try > > UPDATE t1 > SET table1.Title=table2.Title, > table1.Body=table2.Body, > table1.Section=table2.Section > FROM table1 t1 > INNER JOIN table2 t2 ON(t1.ID = t2.ID) > > I think the way you are doing it will not work > because of your placement of the join cl

RE: SQL Update - Now I'm royally confused

2001-02-20 Thread Jeremy Allen
that and see if it helps Phillip. Jeremy Allen elliptIQ Inc. >-Original Message- >From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, February 20, 2001 9:33 AM >To: CF-Talk >Subject: SQL Update - Now I'm royally confused > > >OK, aft

SQL Update - Now I'm royally confused

2001-02-20 Thread Philip Arnold - ASP
OK, after that SP question, and some experimentation, I've decided to start doing most of the work with CF, and then shift over to SPs when I know I've got the SQL working Anyway, I'm trying to do the update from one table to another in SQL using a JOIN - it's SQL Server 7 update table1 inner jo