| From: | "Mark G(dot) Franz" <mgfranz(at)pe(dot)net> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | |
| Date: | 2001-07-05 23:06:09 |
| Message-ID: | 035501c105a7$14823740$6401a8c0@mgflaptop |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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.
Thanks!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Åkerud | 2001-07-06 12:40:08 | Transactions within a function |
| Previous Message | R Vijayanath | 2001-07-05 15:33:04 | can we write to a flat file from Postgresql procedure |