[Zope-DB] how to insert values from select in one shot?

Jaroslav Lukesh lukesh at seznam.cz
Wed Mar 16 04:21:06 EST 2005


Dne úterý, 15. března 2005 17:05 Greg Fischer napsal(a):
>  INSERT INTO jobs (Customer_Id, Problem)
>  SELECT jobs.Customer_Id, jobs.Problem
>  FROM jobs
>  WHERE jobs.job_id = <dtml-var job_id>
>
> That should work in mssql, try that.  (slightly modified from Charlie)

It works. Great thanks for your help,

-- 

                        Jaroslav Lukesh
  -----------------------------------------------------------
  This e-mail can not contain any viruses because I use Linux



More information about the Zope-DB mailing list