Apostrophes in text input not escaped

[lanshark]

First, nice program!

I'm using v1-rc1.

Declared a table, three columns, one coolumn is varchar(100). When I attempt to add  "Madison's Stuff" to that column, I get the following error: Query Error: near "s": syntax error.

I've tried to use the htmlspecialcharacters, addslashes, and the like from the dropdowns provided, but I am still unable to add text that has an apostrophe in it.

Thanks!

Jim

[aldo]

Sorry about the time it took for a reply!

Thanks for the comment Glad you like it.

Anyways, try sqlite_escape_string... The thing with SQLite is, that unlike MySQL, SQLite doesn't escape ' with a \, it escapes it with another ' so to escape ' it gets converted to '' which is what sqlite_escape_string does.

The reason htmlspecialchars doesn't work is the fact that the Quote Style parameter needs to be set to ENT_QUOTES in order to convert ' to the html entity. I suppose I make phpLiterAdmin do that..?

[lanshark]

Aldo,

  No problem on the reply time...

  I tried it with sqlite_escape_string and I still got the same error. If I get some time I'll debug it to find out just where the error is occurring.

  I'll pass along a diff file if I solve it.

Thanks!

Jim

[lanshark]

Aldo,

  It works in 0.90, but not v1-RC1.

  I'm glad I tried the stable release...

Cheers!

jim

[aldo]

Okay, so I guess something is wrong with the function calls in v1.0 RC, will look into it

~ UPDATE ~
I believe I found the problem, buildFunctionList had parameters in wrong order fixed in SVN, revision 36.