Le 17 févr. 06 à 21:24, Trevor DeVore a écrit :
On Feb 17, 2006, at 12:17 PM, Pierre Sahores wrote:
Indeed, i'm very interested by your libDatabase solution and i
will test it extensivelly as soon as possible. She is probably
more suitable than mine in about pedagogic tasks. Thanks for your
work on this great lib. I will report you how she works for me and
some collegues i'm, at this time, working with on a Web GIS system.
Pierre,
Thanks. I would be very interested to get your feedback. Question
- Do you know what the accepted form of escaping strings for
insertion into the PostGreSQL database is?
value='the value' is the main rule to apply. Special chars alike
lonly quote or simple quote need to be preceded with \. The best is
to see the man for more deteailled explainations or, else, to test
and read the pg error messages whose are always very well wrotten,
detailled and helpfull in terms of a pedagocial point of view.
I don't use PostGreSQL myself but I've read information that says
PostGreSQL supports C-style escaped characters (\f, \r, etc.) but
that this was going to be deprecated and you only need to escape
single quotes with '' and that to use escaped characters you should
prefix the value to insert with an "E" (or something like that).
Right now libDatabase uses the escape characters, but I'm thinking
it should just escape the single quote.
I don't never use "E" or so as escape char and don't know about this
escape way.
--
Trevor DeVore
Blue Mango Multimedia
[EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
Best,
--
Pierre Sahores
www.sahores-conseil.com
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution