Skip site navigation (1) Skip section navigation (2)

From: "Mark G(dot) Franz" <mgfranz(at)pe(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Date: 2001-07-05 23:06:09
Message-ID: 035501c105a7$14823740$6401a8c0@mgflaptop (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Yes I'm a newbie...

I need to do a nested UPDATE to 2 tables, will this work?  (and no I didn't try it... production server)

st.executeUpdate("INSERT INTO Registration(ExpirationDate), Customer(UserName, Password) VALUES (DATETIME(NOW()+" + days + "), "+ username +", "+ password +" WHERE Customer.CustomerID=Registration.CustomerID AND Registration.CustomerID=" + id + ")"); 

Don't worry to much about the variables and such... just the SQL string.


pgsql-novice by date

Next:From: Daniel Ã…kerudDate: 2001-07-06 12:40:08
Subject: Transactions within a function
Previous:From: R VijayanathDate: 2001-07-05 15:33:04
Subject: can we write to a flat file from Postgresql procedure

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group