| From: | Assad Jarrahian <jarraa(at)gmail(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Prepared statements and default values |
| Date: | 2006-01-10 03:24:37 |
| Message-ID: | 4bd3e1480601091924q54cfee5cs1c6744638e650fff@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
I have a preparedStatement with the following query
"UPDATE usersettings SET gpsfrequency = ? , serverurl = ? where
username = ? ;";
In the db, the table userSettings has a default value specified for
gps_frequency .
So when I write code
if (client.getSettings().getField(Settings.GPS_FREQUENCY).compareTo(""))==0)
<what goes here> //pick up the default value from the db.
else
setUserSettings.setInt(++i,
Integer.parseInt(client.getSettings().getField(Settings.GPS_FREQUENCY)));
<what goes here> .. I basically want to send something that lets the
db know to use the DEFAULT value. (its of type int0)
So what does go here?
any help would be much appreciated.
-a
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wall | 2006-01-10 03:30:37 | Re: Prepared statements and default values |
| Previous Message | Jaime Casanova | 2006-01-09 17:48:38 | Fwd: [BUGS] BUG #2139: Problem when calling functions without any argument |