simpli int/str problem

[sinan .]

i thank you all, first of al ill change my dictinary variable name :)
then ill use %s and %d . and thanks for other examples,these examples
enchance my python-way thinking. :)

On 8/12/05, Scott David Daniels <Scott.Daniels at acm.org> wrote:
> Paolino wrote:
> > sinan . wrote:
> >
> >> hi all,
> >> i have a string and int values in same dictionary like this
> >> dict = {'str_name': 'etc' , 'int_name' : 112 }
> Bad idea to call this "dict" -- that is a system-defined name
> for the dictionary type. I'll use "holder" below.
> 
> >> the error occures when do this
> >> SQL = "INSERT INTO (`AH`, `BH` ) VALUES ('" + dict['str_name'] + "',
> >> '" + dict['int_name'] + "')"
> ^^ I suspect this should be:
>     SQL = "INSERT INTO TABLENAME(AH, BH) VALUES (...
> >> cursor.execute(SQL)
> >> python does not accep dict['int_name'] in SQL variable but when i
> >> convert this variable to the str , python accepts but i cannot insert
> >> that into database because database only accept int in `BH `
> >> thanks.
> 
> > Try use:
> > SQL = "INSERT INTO (`AH`, `BH` ) VALUES
> > ('%s,%d)"%(dict['str_name'],dict['int_name'])
> This will work, but the DB interface allows you to leave the
> variable formatting to it.  Depending on the parameter style
> your DB interface supports, you may use at least one of:
> 
>     cursor.execute("INSERT INTO TABLENAME(AH, BH) VALUES(?, ?)",
>                    [(holder['str_name'], holder['int_name'])])
> or
>     cursor.execute("INSERT INTO TABLENAME(AH, BH) VALUES(:1, :2)",
>                    [(holder['str_name'], holder['int_name'])])
>     ### I think, it _might_ be ...(0, :1)",
> or
>     cursor.execute("INSERT INTO TABLENAME(AH, BH) "
>                    "VALUES(:str_name, :int_name)",
>                    holder)
> 
> --Scott David Daniels
> Scott.Daniels at Acm.Org
> --
> http://mail.python.org/mailman/listinfo/python-list
>