Thread:

From

"Mark G. Franz"

Date:

05 July 2001, 22:07:28

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!