BTW, Trevor, does sqlYoga resolve this issue internally? If so it would make a really great selling point for sqlYoga!
Bob On Dec 13, 2010, at 12:00 PM, Sivakatirswami wrote: > I'm a dbase - sql newbie when it comes to actually writing a web front end > for capturing and inserting data into a database. I can do code to read and > use data, no problem, but this is my very first project where I actually all > on my own without Andre's help, write a front end to accept input. > > Using revServer I managed to copy some robust escape routines to validate and > block malicious code (thanks to Rabit - RevIngniter Libraries) > > but now I have this problem were people in foreign countries are using odd > characters and for some reason the INSERT fails.. > > e.g > > Paramparaís > > a word used in a comment: the second character from the last is a curly > single possessive apostrophe before "s")...as it ended up in my log file > where we do capture all the data in a text file... but it broke the INSERT, > the dbase never got a record... > > Another case of a registration from someone in Spain I get this in my text > log file: > > Address1: Avda. Europa 108, Urb. BarcelÛ Blq 11, 7 C > Address2: > City: M·laga > State: M·laga > Zip: 29003 > Country: Spain > > but the database insertion fails. Can anyone help me with a LiveCode function > that will "massage" these characters to escape them and pass them to the > dbase (PostGreSQL) and be inserted? > > TIA! > > Sivakatirswami > > > > > > > > > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
