I have a text box with a default value derived from a SQL statement. The SQL Select statement checks out in the MS SQL Server Management Studio. It returns a single value as it should. The value does show in the form as well. That is all good. But as soon as I configured the textbox to use the SQL statement for the default value, I got a message at the lower-left corner of IE8 saying the page was "done but with errors".
The SQL looks like this:
SELECT Value AS DefaultValue FROM dbo.Lists WHERE Listname = 'RL100PriceEach'
The IE8 errors look like this:
Message: Expected ')'
Line: 2084
Char: 157
Code: 0
URI:
http://MyDomainName.com/OrderForm.aspx
The bigger problem this error causes is that my initial javascript statements stop processing. Here is the problem that prompts me to get this resolved. I need the initial javascript to work.
When I configure the textbox to remove the SQL statement and enter the value myself, the error goes away and the initial javascript starts working again.
I need default value to be looked up from my price table, so I need this SQL Driven default value to work. The SQL syntax is good. But I have tried using the parentheses like the error message suggests but I have had no success.
Why does this error message appear? I'd like to clear that up so I have the correct default value and my initial javascript. - Thanks