Andre showed the way: use LiveCode's native databinding methods instead
of my old fashioned replacement strings and the values are automatically
escaped.
On 11/2/11 11:44 AM, Pete wrote:
Interesting. I don't have Postgres but I tried an insert into an SQLite
table with text containing an ampe
Hello Sivakatirswami,
I think it's an unicode problem if your database is UTF8.
I use this function in that case to execute the SQL:
function exeSQL_UTF8 pSQL -- pSQL is your SQL string
global gDB
local tRS
local tSQL
put unidecode(uniencode(pSQL),"UTF8") into tSQL
put revdb_
Interesting. I don't have Postgres but I tried an insert into an SQLite
table with text containing an ampersand and it worked just fine. Same with
mySQL. This was on my desktop machine though, not over the web.
The docs for SQLite,mySQL, and Postgres only mention the need to escape the
single-q
Trevor does. There are escaping handlers in his old MySQL Abstraction
Library, if you have that around.
On 2 November 2011 13:25, Sivakatirswami wrote:
> I'm having some difficulty with passing data from a web form to a
> PostGreSQL database. I'm using iRev on the server and gFormData has all th
I'm having some difficulty with passing data from a web form to a
PostGreSQL database. I'm using iRev on the server and gFormData has all
the data in the array. After handling all the data, running the CC
charges, sending notifications, everything works, but my final functions
to insert the dat
