Problem using dropdown menu feature

[drocra]

Hi all,

I recently began developing a project using Nubuilder for my company. So far, I've been very happy with it (even as someone with extremely limited programming experience).

I did have one problem that's sort of stopping me in my tracks. I was attempting to follow tutorial 2 to create a drop-down list. However, I'm having some problems entering the SQL code.

The problem is that after entering the following SQL code and saving...

SELECT sli_option, sli_description FROM zzsys_list
WHERE sli_name = "Number"

(this list has been previously created under Lists)

...Nubuilder seems to add \ marks before and after the quotation marks. So after saving and reentering the "Dropdown" screen, the query looks like this:

SELECT sli_option, sli_description FROM zzsys_list
WHERE sli_name = \"Number\"

I've run the original query in phpMyAdmin and it works fine. But this modified one doesn't work. When I try to run the report, I get the following error:

Could not execute : --

--------------------------------------------------------------------------------
SELECT sli_option, sli_description FROM zzsys_list WHERE sli_name = \"Number\"

Any idea what I'm doing wrong? Is this a known problem?

[michael]

Yes, this is a known problem with some configurations of PHP. There is a PHP setting called "magic quotes" which is responsible for automatically inserting the slash. You can read how to disable it in your php.ini file here.

[drocra]

Excellent - I was able to fix it by copying my php.ini to /nubuilder/productionnu2/. Thanks!

[steven]

Hi,

I asked Michael (from here - nuSoftware) to help you out on this one but he's been too busy.
Here's a post he gave someone else who had a similar problem.
http://forums.nubuilder.cloud/viewtopic.php?f=6&t=21
Let us know if you still have problems.

Steven