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

[Cesar P. <cpe...@bt...>]

Maybe you could use ? instead of ?

Hope this helps.

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
Albert Vila
Sent: Tuesday, June 13, 2006 10:34 AM
To: sql...@li...
Subject: [Sqlrelay-discussion] Problems with text fields containig the
?character

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


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.4/363 - Release Date: 6/13/2006