Problem with property value containing a single quote
Posted: Wed Dec 08, 2004 11:46 pm
I created a new property called "Dish Sirius Channels" and added values for each of the channels I wanted in the property. One of the values was "Totally 70's". When I tried to assign IR I kept getting errors when HouseBot tried to insert the code into the PropertyValueIRMap table.
It took me a while to figure out what was going on but I finally figured out that the single quote (apostrophe) was the culprit. I'm quite sure this is an issue with the INSERT statement into the database since that character has special meaning. I've worked around it by removing that character from the property value but I figured I'd log it anyway.
-- Dave
It took me a while to figure out what was going on but I finally figured out that the single quote (apostrophe) was the culprit. I'm quite sure this is an issue with the INSERT statement into the database since that character has special meaning. I've worked around it by removing that character from the property value but I figured I'd log it anyway.
-- Dave