Q

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:

'tep_cfg_select_option(array('true','false')'

You'll need:

'tep_cfg_select_option(array(''true'',''false'')'

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

This was first published in March 2006

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

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close