Re: problem wil insert statement merging values

2004-04-09 Thread Roger Baklund
* dan orlic > INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as > category_id, '' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1 > + g.Desc2 + g.Desc3 as description, g.Desc4 as price,0 as quantity, '' > as comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type, > now() as

problem wil insert statement merging values

2004-04-08 Thread dan orlic
dan orlic wrote: INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as category_id, '' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1 + g.Desc2 + g.Desc3 as description, g.Desc4 as price,0 as quantity, '' as comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type, now() as