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: Raw Message | Whole Thread | 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!

Browse pgsql-novice by date

  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