Dot Magee/HQ/McNichols is out of the office.

2008-12-24 Thread Dot . Magee
I will be out of the office starting 12/24/2008 and will not return until 01/05/2009. I will be glad to answer your email when I return. Thanks.

Re: R: insert statement

2008-12-24 Thread Nathan Maves
I am not sure why people continue to do this why not insert into some_table ( id, state, date ) values ( #id:NUMERIC#, #state:VARCHAR#, #date:DATE# ) This way it will insert the right data every time. If the value is null you get a null in the DB. I think you are only going to

Re: mysql issue...

2008-12-24 Thread Kai Grabfelder
sorry for the multiple answers. looks like google mail is somehow filtering the e-mails I'm sending to the list so that they don't appear in my inbox ;-( Regards Kai --- Original Nachricht --- Absender: pady Datum: 21.12.2008 19:59 > > Hi, > > ibatis 2.3 > mysql 5.0.29 > mysql-connector 5.0.4

Re: mysql issue...

2008-12-24 Thread Kai Grabfelder
Hi, this is kind of a mysql "feature". Connections that are not used for some time are automatically closed. If you are using spring you can workaround this with the following datasource configuration: Regards Kai --- Original Nachricht --- Absender: pady Datum: 21.1

R: insert statement

2008-12-24 Thread De Gaetano Giuseppe
Hi all, I faced with the same problem and I solved in this way: INSERT INTO some_table ID

insert statement

2008-12-24 Thread Gil Vernik
Hi there, I would like to write a dynamic insert statement, but both fields and values are dynamic. I mean insert into table_one ( !!! dynamic list of keys from the HashMap ) values ( !!! values ); I want both the list of column names