[EMAIL PROTECTED]

2006-03-10 Thread Alan Hicks

Re: Ibatis and flat files?

2005-09-22 Thread Alan Hicks
I stumbled across a project: www.csvBeans.org . It generates beans from a CSV file. The mappings are defined using XML. Worth a look -saved me loads of time. Alan. On Thu, 22 Sep 2005 18:57:57 +0100, Warren Bell <[EMAIL PROTECTED]> wrote: My company has several vendors who send us invoi

Re: Getting auto-generated keys in mySql

2005-08-17 Thread Alan Hicks
<[EMAIL PROTECTED]> wrote: NO! That is really, really not thread safe! Imagine what happens when 2 ppl do inserts at the same time... [insert #1][insert #2][query #1][query #2] Both [query #1] and [query #2] return the same id. Ooops! kaboom! Larry On 8/17/05, Alan Hicks <[EMAIL

Re: Getting auto-generated keys in mySql

2005-08-17 Thread Alan Hicks
Hi Brian, I had the same problem and could not find any working examples. Finally I stumbled upon the query where 'userId' is an auto-generated key in my mysql table. If you replace the query you have with this one you should be in business. SELECT MAX(userId) FROM tb_user Hope this help