phpgroupware-developers
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-developers] Re: sitemgr - mssql bugs


From: totschnig . michael
Subject: [Phpgroupware-developers] Re: sitemgr - mssql bugs
Date: Tue, 28 Jan 2003 14:54:50 -0500
User-agent: Gnus/5.090007 (Oort Gnus v0.07) XEmacs/21.4 (Economic Science, i686-pc-linux)

Sigurd,

"Sigurd Nes" <address@hidden> a écrit:

> 3)
> I suspect there are some things fishy about the join statements in the
> function 'getallblocksforarea' in class.Content_SO.inc.php(63)
>
> I think it should be altered to (assuming 'view' is altered to
> 'viewable'):
>
> $sql = "SELECT t1.block_id, area, cat_id, page_id, t1.module_id,
> app_name, module_name, arguments, arguments_lang, sort_order, title,
> viewable, actif"
> . " FROM phpgw_sitemgr_content AS t1 LEFT JOIN "
> . " phpgw_sitemgr_modules AS t2 on t1.module_id=t2.module_id LEFT JOIN "
> . " phpgw_sitemgr_content_lang as t3 ON (t1.block_id=t3.block_id AND
> lang='$lang') "
> . " WHERE area = '$area' AND ((page_id = 0 and cat_id = 0)";

I tested your proposal on mySQL and it seems to work. But I'd like to
know what you think is wrong with the current SQL statement. It uses
two different ways to join tables, which both work, and can be
combined in MySQL. It is the combination of both that does not work in
MsSQL?

Michael




reply via email to

[Prev in Thread] Current Thread [Next in Thread]