Problem solve Get help with specific problems with your technologies, process and projects.

Fixing bad coding within a SQL query

SQL Server Development expert Greg Low troubleshoots a programming issue within a SQL query.

I am having a problem with the following SQL query.

(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Image Amplification', 'IMAGE_AMPLIFICATION', 'false', 'Enable to display image amplification and not popup windows. Good for popup blockers.', '4', '9', 'tep_cfg_select_option(array('true', 'false'), ', now()); (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Image Amplification Factor', 'IMAGE_AMPLIFICATION_FACTOR', '2.5', 'The image amplification factor to big image size devided by small image size', '4', '10', now());

My Internet service provider tells me that there is a programming issue within my code. Can you help me fix this error?

It's a bit hard to tell from this script but my guess is that you are trying to have the value tep_cfg_select_option(array('true','false') as a string value.

If so, you'll need to make the single quotes double quotes, so instead of:


You'll need:


Click here to view questions and answers from all of our SQL Server experts.

Dig Deeper on SQL-Transact SQL (T-SQL)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.