Re: [Sqlrelay-discussion] Problems with text fields containig the ? character
Brought to you by:
mused
|
From: David M. <dav...@fi...> - 2006-06-16 13:53:44
|
PHP Pear DB requires that it's drivers support the ? character to delimit bind variables. SQL Relay translates ?'s into whatever the native bind variable delimiter is for whatever database you're using, or if your database doesn't support bind variables natively, it translates ?'s into :1,:2,:3,etc. and rewrites the query on the back end, performing substitutions. In this case, as Cesar points out, a workaround is to use the ? character. But there does appear to be a bug, ?'s should not be translated if they're found inside of quotes. I'll fix that in the driver and get it out in the next prerelease. Dave On Tue, 2006-06-13 at 19:33 +0200, Albert Vila wrote: > Hi all, > > I'm having problems doing queries (insert or update) that contains > the ? character. For example if I send the following query throught > the SQLRelay, > > update TABLE set url="http://mydomain.com/? > session=0101010&user=blabla" > > the ? character is rewrited with :1. > > The query then looks like: > > update TABLE set url="http://mydomain.com/: > 1session=0101010&user=blabla" > > Any ideas? > > Thanks > > > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |