[ANN] libDatabase 2.0.1.20

[Pierre Sahores]

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
> trevor at mangomultimedia.com
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at 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