Hello,
I have created a multi-table insert script in python, the problem is that this worked fine on an older PostgreSQL db (7.2) but now I get an
Error, psycopg2.ProgrammingError: missing FROM-clause entry for table "business_name_business_name_seq"
Here is part of the script
It is a Z SQL Method for Zope.
##########
INSERT INTO business_name (business_name, business_url, business_type_id)
values (<dtml-sqlvar business_name type="string" >, <dtml-sqlvar business_url type="string">, <dtml-sqlvar business_type_list_id type="int">);
<dtml-var sql_delimiter>
INSERT INTO business_address (street_name, town, city, postcode, county_id, business_name_id) values
(<dtml-sqlvar street_name type="string">,
<dtml-sqlvar town type="string">,
<dtml-sqlvar city type="string">,
<dtml-sqlvar postcode type="string">,
<dtml-sqlvar county_list type="int">,
business_name_business_name_seq.last_value);
#########
Here I want to take the last_value for the business_name_id that was generated in the first insert and put it as the related item in the next INSERT table.
Is there a better way to do this? I have 4 tables all related and one input form.
Many thanks
Norman
All new Yahoo! Mail "The new Interface is stunning in its simplicity and ease of use." - PC Magazine