Hello,
I have configured a dependent dropdown and enabled 'Lookup wizard as Edit box with AJAX popup'. That gives me the following error.
[codebox]Microsoft OLE DB Provider for SQL Server error '80040e07'
Conversion failed when converting the varchar value 'ALA' to data type int.
/webapp/include/commonfunctions.asp, line 2881
[/codebox]
The error occurs in function loadSelectContent and the query that it tries to execute looks like this
[codebox]SELECT [BusinessKey],[BusinessKey] FROM [CountryLookup] WHERE [DataSourceID]=3 AND [BusinessKey]=0[/codebox]
[BusinessKey] is data type varchar, but it looks like it thinks it is an integer.
If I disable 'Lookup wizard as Edit box with AJAX popup', everything works fine and the selected value is loaded when the edit page loads.
BR,
Mikael