RE: [Ruqueue-user] problem with escaping single quotes?

[Ramon P. Quezada]

Hi Michiel,

 

I’m glad you got it to work properly.  I will look into correcting the two renderings.  Thanks a lot. 

 

-Ray

---

From: van Mil, Michiel [mailto:address@hidden]
Sent: Monday, December 05, 2005 3:10 PM
To: Ramon P. Quezada
Cc: John Fulton
Subject: RE: [Ruqueue-user] problem with escaping single quotes?

 

Sorry for the flurry of spam but I confirm it is a php.ini setting that caused this:

 

; Magic quotes for incoming GET/POST/Cookie data.

magic_quotes_gpc = On

; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.

magic_quotes_runtime = On

; Use Sybase-style magic quotes (escape ' with '' instead of \').

magic_quotes_sybase = Off

 

I turned the first two options On (they were off by default) and now the tickets don’t disappear.

A minor glitch: now any quote is escaped by a backslash in the ticket comments:

Single quote: \'

Two quotes  : \'\'

Two quotes with text: \'test\'

Double Quote: "

Double quote text: "test"

Double quotes: ""

 

However, in the mail the system sends out this shows up as:

Single quote: '

 

Two quotes  : ''

 

Two quotes with text: 'test'

 

Double Quote: "

 

Double quote text: "test"

 

Double quotes: ""

 

Note the extra lines in between, and the single quotes render well. Double quotes are turned into " for some reason.

 

I googled around for a bit on the single quote problem and people on the internet(s) are saying things like

Use mysql_escape_string() before insert to db, then stripslashes() before dsiplaying it.

Which doesn’t mean a lot to me but maybe it does to you?

 

Regards,

Michiel

 

---

From: Ramon P. Quezada [mailto:address@hidden
Sent: maandag 5 december 2005 20:09
To: van Mil, Michiel
Cc: John Fulton
Subject: [Ruqueue-user] problem with escaping single quotes?

 

Hi Michiel,

 

I’m glad you enjoy the project.  I tried adding and editing the ticket with quotes and could not reproduce this problem.  Each time I was able to view the ticket in its queue with its appropriate subject and body.  Can you provide me with the exact steps, including the information you typed into the form with single quotes that you took when this happened?

 

Thanks,

Ray