Skip to content

bugger in parameterized queries #2

@XULRunner42

Description

@XULRunner42

res = dbh.query("INSERT INTO testtable (testrecord1, testrecord2)" + " VALUES (?, ?)", "string %' ' ' ' '", 'zxcvqwer');

is expected to work, but the single quote causes an error. Still an error if you use dbh.quote("string ' % '") for the parameter, which you shouldn't have to do anyway.

Error returned from errstr() looked like 1: near "zxcvqwer": syntax error

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions