Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Gemini 2.0.2 and SQL Server 2005 compliance

web-app

Hi,

We need to migrate Gemini database from SQL Server 2000 to Sql Server 2005.

But the gemini application  fails with the 'Ambiguos column name' message . When we ran the trace  we noticed that the application used the following SQL Statement :

select field1, field1 from table1 order by field1

which is not SQL 2005 Compliant . Was it fixed in the more recent versions?

Thanks
polzovatel
· 1 		polzovatel
Tuesday, November 13, 2007, 2:15:43 PM
Replies (1)
helpful
0
not helpful

This must be a custom field definition, check your custom fields defs.
Mark Wing
· 9108 		Mark Wing
Tuesday, November 13, 2007, 7:00:48 PM