My bug. Fixed in version 1.5 of mysql.plt, which I just uploaded to PLaneT. Thanks for the report! -Jon <div class="gmail_quote">On Thu, Oct 1, 2009 at 4:46 PM, Scott Hickey <<a href="mailto:sshickey@qwest.net" target="_blank">sshickey@qwest.net</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Using the latest dbi + jazmysql, I get an error trying to insert a null value into column defined as nullable in MySQL. 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? (define (get-handle) (connect 'jazmysql "localhost" 3306 "golfscore" "golfscore" '#:schema "golfscore")) (define-struct hole_played (hole_number par score putts fairway_hit round_played_id [id #:auto] )) (define (insert-hole_played hp) (let ((a-handle (get-handle))) (exec a-handle "insert into hole_played (hole_number, par, score, putts, fairway_hit, round_played_id) VALUES (?hole_number, ?par, ?score, ?putts, ?fairway_hit, ?round_played_id)" `( (hole_number . ,(hole_played-hole_number hp)) (par . ,(hole_played-par hp)) (score . ,(hole_played-score hp)) (putts . ,(hole_played-putts hp)) (fairway_hit . ,(hole_played-fairway_hit hp)) (round_played_id . ,(hole_played-round_played_id hp)))) (caadr (query a-handle "select LAST_INSERT_ID()" '())))) (insert-hole_played (make-hole_played 1 4 4 2 null 1)) uncaught exception: #<exn:mysql errno=1210 sqlstate="HY000" message="Incorrect arguments to mysql_stmt_execute"> Scott Hickey Senior Consultant Object Partners, Inc. _________________________________________________ For list-related administrative tasks: <a href="http://list.cs.brown.edu/mailman/listinfo/plt-scheme" target="_blank">http://list.cs.brown.edu/mailman/listinfo/plt-scheme</a> </blockquote></div>