Re: [Sqlrelay-discussion] Problems with text fields containig the ? character

[David M. <dav...@fi...>]

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
>