FW: [Zope-DB] Re: How do you do update with multiple tables
Laura.McCord at doucet-austin.com
Fri Apr 30 16:08:12 EDT 2004
I was thinking the same thing and I tried that but doesn't that mean
that when I insert a new user I would have to know the pcid? When I
enter the user info I want it to be easy enough for the user to be able
to enter the name of the pc instead of the id. However, when I do the
update there is no pcid in the users table that will trigger the
users.pcname to update.
From: zope-db-bounces at zope.org [mailto:zope-db-bounces at zope.org] On
Behalf Of Sean Fulmer
Sent: Friday, April 30, 2004 2:58 PM
To: zope-db at zope.org
Subject: [Zope-DB] Re: How do you do update with multiple tables
Laura McCord wrote:
> First of all, I am passing an argument 'pcname'.
> I have two tables that are linked by pcname
> Table Users Table pcTable
> userid pcid
> username |-------- pcname
> useremail | pcmake
> useroffice | pcmodel
> userpwd | pcserial
> If I want to update the pcname in the pcTable then I want the pcname
> in the users table to update as well. How is this done? This is what I
> have so far:
> update pcTable ,users
> pcTable.pcname = '<dtml-var name="pcname" sql_quote>', pcTable.pcmake
> = '<dtml-var name="pcmake" sql_quote>', pcTable.pcmodel = '<dtml-var
> name="pcmodel" sql_quote>', pcTable.pcserial = '<dtml-var
> name="pcserial" sql_quote>', pcTable.pcmhz = '<dtml-var name="pcmhz"
> sql_quote>', pcTable.pcmbram = '<dtml-var name="pcmbram" sql_quote>',
> pcTable.pc_oem_os = '<dtml-var name="pc_oem_os" sql_quote>',
> pcTable.pc_oem_os_key = '<dtml-var name="pc_oem_os_key" sql_quote>',
> pcTable.pc_ip_add = '<dtml-var name="pc_ip_add" sql_quote>',
> users.pcTable = '<dtml-var name="pcname" sql_quote>'
> pcname = '<dtml-var name="pcname" sql_quote>'
> Is there something that I am forgetting?
Hard to tell what you're forgetting if you don't say what kind of
problem you're having (ie a detailed error message)
IMO, the correct thing to do would be add a pcid field to your user
table. If you join your tables on pcid, then you only need to change
pcname in one place.
Zope-DB mailing list
Zope-DB at zope.org
More information about the Zope-DB