in reply to Re: Quotes In CGI
in thread Quotes In CGI
Your original problem statement is:
Well Im having a problem if a user fills out one of my forms and puts somethi g in quotes, and when that gets printed from the database everything beyond the quptes is whiped out, they dont even show up in txt fields.Let's break this down. From what you've shown, quotes in a field should get correctly quoted on insert to the database. Have you verified that data is truncated once it's in the database? Assuming that the corrupted data is from the "description" field, what does SELECT description FROM items WHERE itemid=? show, when you plug in the right itemid?
If it's correct in the database, then you've narrowed the search, and we can then start examining the path data takes on the way back from the database. E.g., If you're putting data that contains quotes into HTML edit controls, you'll need to entity-escape the data.
And please post your responses under the correct node. It makes the discussion easier to follow.
|
|---|