Re: Dbi.Mysql using parameters error - beginner simple problem

(defun get-user (db first second)
    (sql (format nil "select UserName, Pwd from Login where UserName  
= '~a' and Pwd = '~a'"
                 first second)
         :db db))
    (mysql-insert-id id))

I think you assign bad arguments to function `sql'.


On 2005/09/21, at 13:26, peggymark wrote:

> (defun get-user (db first second)
>    (sql " format nil select UserName, Pwd from Login where UserName  
> = '~a' and Pwd = '~a'"
>              first second
>             :db db)
>     (mysql-insert-id db))
>