SQL Insert in Corman Lisp

I've recently started using Corman Lisp, and am working with the ODBC-
SQL library that came with Corman 2.0. I want to be able to use a 
database to record values that are obtained by a user via a Lisp 
program. I can properly connect to the db (MS Access) via ODBC, and 
am able to insert values that are "set", such as:

(insert-records :into 
[tblTest] :attributes '(FirstName) :values '("My Name"))
(commit)

but I have no idea how to use values entered by the user, my code 
looks like:

defun ask (string)
  (format t "~a? " string)
  (read))

(setq somename (ask "What is your name"))
(setq somename (list somename))
(insert-records :into [tblTest] :attributes '(FirstName) :values 
somename)
(commit)

I'm getting a "too few parameters. expected 1" error. Anyone 
succesfully done this, or have any idea on what my problem might be?

Thanks for any help!!



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/W7NydA/hdqFAA/bW3JAA/SyjtlB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
[email protected]

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/