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.

CommentFileSizeAuthor
linktocontent_node-mssql.patch1.15 KBpcorbett

Comments

stborchert’s picture

stborchert
he/him
Primary language German
commented
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

pcorbett’s picture

pcorbett commented

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

stborchert’s picture

stborchert
he/him
Primary language German
commented
Version: 5.x-1.7 » 5.x-2.x-dev
Assigned: Unassigned » stborchert
Category: feature » task
Status: Postponed » Active

moved task to new development version

pcorbett’s picture

pcorbett commented

Thanks! Let me know if there are any issues.

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
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.

pcorbett’s picture

pcorbett commented
Status: Needs work » Closed (fixed)

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.