Enable MSSQL Support

pcorbett - October 10, 2007 - 17:32
Project:Link to content
Version:5.x-2.x-dev
Component:Code
Category:task
Priority:normal
Assigned:stBorchert
Status:closed
Description

This patch adjusts the linktocontent_node module to allow MSSQL Support. Specifically, it simply adjusts the ISNULL(column) MySQL/PgSQL function to "(column) IS NULL" - which is how MSSQL deals with a ISNULL test.

AttachmentSize
linktocontent_node-mssql.patch1.15 KB

#1

stBorchert - October 10, 2007 - 18:10
Status:active» postponed

Hi.
Thanks for this patch. I hope you can wait until the 5.x-2.x or 6.x-1.x release is out, because I didn't want to add features to 5.x-1.x.
The next version (including 5.x-2.x) will include some new features (like pagers for the node listing, or use of the planned hook_wysiwyg_plugin(), so copying the plugins and editing plugin_reg.php isn't neccessary anymore).

thanks again and greetings,

Stefan

#2

pcorbett - October 10, 2007 - 20:57

Not a big deal. Just trying to get some of my work on MSSQL out there for integration. Nice module, BTW.

#3

stBorchert - February 28, 2008 - 22:44
Version:5.x-1.7» 5.x-2.x-dev
Category:feature request» task
Assigned to:Anonymous» stBorchert
Status:postponed» active

moved task to new development version

#4

pcorbett - March 17, 2008 - 21:39

Thanks! Let me know if there are any issues.

#5

sun - August 29, 2008 - 00:33
Status:active» needs work

IS NULL is a valid statement on MySQL, too. I cannot speak for PostGreSQL, but given the new DB layer in D7 - who cares? ;)

If you change the patch to use IS NULL (without a switch), I'll probably commit it.

#6

pcorbett - September 2, 2008 - 19:13
Status:needs work» closed

Yeah, D7 basically "NULLs" the whole IS NULL issue, so let's leave it at that. If there is demand for this little patch, I can provide one.

 
 

Drupal is a registered trademark of Dries Buytaert.