I have a stored procedure that I use for sql validation.  If I hardcode the parameters for the procedure the validation works fine.  If I replace the parameters with tokens, I get the error below.  It looks like the values are not being passed to my procedure however I have changed my hidden fields to textboxes just to verify that they are being populated and they are.  I have also tried quotes around the tokens and I get the same results.  Any ideas?

Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Incorrect syntax near ','. ---> System.Data.SqlClient.SqlException: Incorrect syntax near ','. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText) at DataSprings.Modules.DynamicForms.SqlDataProvider.GetSQLDefault(String strSQL) at DataSprings.Modules.DynamicForms.DynamicQuestionController.GetSQLValidation(String strSQL) at DataSprings.Modules.DynamicForms.DynamicForms.ServerSideValidation() at DataSprings.Modules.DynamicForms.DynamicForms.SubmitForm(Boolean ProcessPaymentNotification, String strResponseID) --- End of inner exception stack trace ---

Update...
This only happens when my tokens come from questions that are hidden. If I change them to textboxes my validation works fine. I populate hidden questions all the time without any problems but with this form I am using a question event as follows:
Set question default based on another quesions reponse
Initiation/Postback Question: Select Member
Execute event for any response: checked
Initiation Response:***Select Member*** these values get populated from a stored proc
Affected Question: hState
Affected Question New Default Value: SQL Driven

SQL: Select State as DefaultValue from Members Where MemberId = $(MemberId)
***MemberId comes from a combobox question

I don't think I have ever populated hidden questions using a SQL Driven Default question event...Maybe that is what is worng?

HI, several questions:
1) when you say hidden questions, are they set to" Hide until forced visible by question event?"
or
2) they are set as "Hidden Fields"?
-- David

Hi,

Well, first I would enable debug mode so that you can see the exact query that is being generated. This should let you know if its an issue with tokens not being replaced and what values are getting generated etc...

The ability to set a default value, based on a SQL default, and based on a question event, is a new feature for 3.0. So its possible that this feature was only introduced/tested against textbox fields and not hidden fields. So if you change the field type from hidden to textbox does it then work? And changing it back to 'hidden' it doesn't?

-Chad

Chad, I resolved the error above but I am still having issues with populating a hidden field from a question event that sets the default value (using sql) for another question. The anser to your question above is YES. My question event sets the default value (using sql) of my EnablePGateway question to True or False. If EnablePGateway is hidden then it is not populated...or at least it does not have any affect on my PayPal gateway. If I change the EnablePGateway question to a textbox everything works fine.
Troy

HI, can you export your form to www.betasprings.com (username: host, password: dnnhost) so someone at Datasprings can take a look at your question event / SQL settings? Please type in the URL/tabid of your form here as well. Thanks. -- David

Troy,

Are you still having problems after the patch I sent? If so maybe we should schedule a quick go to meeting to discuss the issue.

-Chad