[plt-scheme] bzlib/dbi error trying to insert a null value

From: YC (yinso.chen at gmail.com)
Date: Thu Oct 1 20:17:10 EDT 2009

On Thu, Oct 1, 2009 at 2:57 PM, Jon Zeppieri <zeppieri at gmail.com> wrote:

> My bug.  Fixed in version 1.5 of mysql.plt, which I just uploaded to
> PLaneT.
> Thanks for the report!

Jon - thanks for chiming in and fix it so quickly.

 On Thu, Oct 1, 2009 at 4:46 PM, Scott Hickey <sshickey at qwest.net> wrote:
>> Also, I added code that is MySQL specific to return the row id for the row
>> inserted. Is there a database agnostic way to get that id using the dbi
>> module?
Scott -

DBI will depend on the underlying driver for such functionalities. jaz/mysql
appears to return the last inserted id in its side-effect struct.  Until I
have it wrapped with the next release - you can retrieve the data by
explicitly requiring (require (planet jaz/mysql)) and then use
side-effect-insert-id to get the data back.

I'll have to think about how to approach this since each database returns
different side effects.  If anyone have thoughts into this matter please let
me know - I would love to hear it.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.racket-lang.org/users/archive/attachments/20091001/00ed9682/attachment.html>

Posted on the users mailing list.