Dropdown Does Not Work; It Happens When Saving The Object!
Posted: Wed Feb 24, 2010 2:47 pm
Hi, this is my first thread in here (newbye). Yours seems to be one of the rare web based database development tool - open source - available; great work!
Following your video tutorials, "drop-down and textarea objects" when it comes to create the dropdown object; after saving it, in the SQL field are added two "\" as in the attached image, so that when I keep on following the tutorial I get an error when I try to add a new record after having clicked on the Sales button; the error is: "Could not execute : -- SELECT sli_option, sli_description FROM zzsys_list WHERE sli_name = \"gender\" . The same query works fine in PHPMyAdmin.
I have tried to recreate the dropdown object in another browser (firefox and internet explorer) and the issue remains.
May you help me to fix it please?
Cypherinfo.
Following your video tutorials, "drop-down and textarea objects" when it comes to create the dropdown object; after saving it, in the SQL field are added two "\" as in the attached image, so that when I keep on following the tutorial I get an error when I try to add a new record after having clicked on the Sales button; the error is: "Could not execute : -- SELECT sli_option, sli_description FROM zzsys_list WHERE sli_name = \"gender\" . The same query works fine in PHPMyAdmin.
I have tried to recreate the dropdown object in another browser (firefox and internet explorer) and the issue remains.
May you help me to fix it please?
Cypherinfo.