This topic is locked
[SOLVED]

 Error when using MS SQL DB

12/30/2013 12:01:46 PM
Multiselect plugin support forum
T
Tim author

Hello,
It appears this plugin assumes a DB of MySQL. I am using MS SQL 2008 and, with debugging turned on to show the query, I get this output and error:
SELECT DISTINCT JobID,JobTitle,StoreDepartmentName FROM vJobTitles ORDER BY JobTitle
Microsoft SQL Server Native Client 10.0 error '80040e14'
Incorrect syntax near ''.


I believe the "
" should be "[". Can I adjust this in the source files somewhere?
Thanks,

Tim

admin 12/30/2013

Make sure you run the latest version of plugin. This issue was fixed in the latest version of plugin.

T
Tim author 12/31/2013

Ah yes, it had been a while since I downloaded it. The latest version works well.
Thanks. Happy New Year.

Tim