Are you enjoying the extensions? Did you like the support? Help others decide.

Leave a review

file SQL Server

More
11 years 8 months ago #780 by krombatz
SQL Server was created by krombatz
Hi there,

I'm trying to use the module with MS SQL Server.

Unfortunately, your using MySQL specific functions in the sql syntax like SUBSTRING_INDEX, CONCAT_WS and CHAR_LENGTH.

Should I try rewriting it on my own or do plan to support SQL Server in the future?

Greetings,
Thomas

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago - 11 years 8 months ago #781 by admin
Replied by admin on topic Re: SQL Server
Hello,
an updated version specifically made for Joomla! 2.5 is planned but won't come for another few weeks. In the meantime, I would suggest you look at the contact.php file in component\com_contact\models and use some of the code found in it to replace the CONCAT_WS and CHAR_LENGTH. I have not investigated in how to replace SUBSTRING_INDEX yet.
Thank you for your interest in Trombinoscope!
Olivier.
Last edit: 11 years 8 months ago by admin.

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #782 by admin
Replied by admin on topic Re: SQL Server
Here is a beta version that fixes your issue. Please try it and let me know if you have any other problem with it. Thanks!
Olivier.
Attachments:

Please Log in or Create an account to join the conversation.