Na gut :)
also hier mal ein typischer SQL f�r die Linkauswahl. Es werden nachher die
Links in 18er Paketen pro Seite ausgegeben:
SELECT tblLinks.*, tblTarget.fldName as extfldName,
tblFunction.fldPage as extfldPage, tblFunction.fldAddFields as
extfldAddFields,tblLinks.fldImage_1 AS fldImage FROM (tblLinks INNER JOIN
tblTarget ON tblLinks.fldTarget = tblTarget.fldID) INNER JOIN tblFunction ON
tblLinks.fldFunction = tblFunction.fldID WHERE fldShow=-1 AND fldSubLink=0
AND (fldDomainNo=0 OR fldDomainNo=1) AND ((IsNull(fldDateStart) OR NOT
fldDateStart>#6/13/2003#) XOR (fldCalendar=-1)) AND (IsNull(fldDateEnd) OR
NOT fldDateEnd<#6/13/2003#) AND ( EXISTS (SELECT fldLinkID FROM tblLinkCat
WHERE fldLinkID=tblLinks.fldID AND fldCatID=106)) ORDER BY tblLinks.fldID
DESC
SELECT Count(*) FROM (tblLinks INNER JOIN tblTarget ON
tblLinks.fldTarget = tblTarget.fldID) INNER JOIN tblFunction ON
tblLinks.fldFunction = tblFunction.fldID WHERE [$language$] fldShow=-1 AND
fldSubLink=0 AND (fldDomainNo=0 OR fldDomainNo=1) AND ((IsNull(fldDateStart)
OR NOT fldDateStart>#6/13/2003#) XOR (fldCalendar=-1)) AND
(IsNull(fldDateEnd) OR NOT fldDateEnd<#6/13/2003#) AND ( EXISTS (SELECT
fldLinkID FROM tblLinkCat WHERE fldLinkID=tblLinks.fldID AND fldCatID=106))
Die zweite SQL ist n�tig, damit ich das Paging einigermassen selber basteln
kann (xxx Eintr�ge gefunden etc.)
Diese beiden Bl�cke werden also 3 mal aufgerufen, wobei der letzte Aufruf
der komplizierteste ist, da am l�ngsten.
Hier nochmal der letzte:
SELECT tblLinks.*, tblTarget.fldName as extfldName,
tblFunction.fldPage as extfldPage, tblFunction.fldAddFields as
extfldAddFields,tblLinks.fldImage_1 AS fldImage FROM (tblLinks INNER JOIN
tblTarget ON tblLinks.fldTarget = tblTarget.fldID) INNER JOIN tblFunction ON
tblLinks.fldFunction = tblFunction.fldID WHERE fldShow=-1 AND fldSubLink=0
AND (fldDomainNo=0 OR fldDomainNo=1) AND ((IsNull(fldDateStart) OR NOT
fldDateStart>#6/13/2003#) XOR (fldCalendar=-1)) AND (IsNull(fldDateEnd) OR
NOT fldDateEnd<#6/13/2003#) AND ( EXISTS (SELECT fldLinkID FROM tblLinkCat
WHERE fldLinkID=tblLinks.fldID AND fldCatID=122) OR EXISTS (SELECT fldLinkID
FROM tblLinkCat WHERE fldLinkID=tblLinks.fldID AND fldCatID=123) OR EXISTS
(SELECT fldLinkID FROM tblLinkCat WHERE fldLinkID=tblLinks.fldID AND
fldCatID=124) OR EXISTS (SELECT fldLinkID FROM tblLinkCat WHERE
fldLinkID=tblLinks.fldID AND fldCatID=125) OR EXISTS (SELECT fldLinkID FROM
tblLinkCat WHERE fldLinkID=tblLinks.fldID AND fldCatID=126) OR EXISTS
(SELECT fldLinkID FROM tblLinkCat WHERE fldLinkID=tblLinks.fldID AND
fldCatID=127)) ORDER BY tblLinks.fldID DESC
SELECT Count(*) FROM (tblLinks INNER JOIN tblTarget ON
tblLinks.fldTarget = tblTarget.fldID) INNER JOIN tblFunction ON
tblLinks.fldFunction = tblFunction.fldID WHERE [$language$] fldShow=-1 AND
fldSubLink=0 AND (fldDomainNo=0 OR fldDomainNo=1) AND ((IsNull(fldDateStart)
OR NOT fldDateStart>#6/13/2003#) XOR (fldCalendar=-1)) AND
(IsNull(fldDateEnd) OR NOT fldDateEnd<#6/13/2003#) AND ( EXISTS (SELECT
fldLinkID FROM tblLinkCat WHERE fldLinkID=tblLinks.fldID AND fldCatID=122)
OR EXISTS (SELECT fldLinkID FROM tblLinkCat WHERE fldLinkID=tblLinks.fldID
AND fldCatID=123) OR EXISTS (SELECT fldLinkID FROM tblLinkCat WHERE
fldLinkID=tblLinks.fldID AND fldCatID=124) OR EXISTS (SELECT fldLinkID FROM
tblLinkCat WHERE fldLinkID=tblLinks.fldID AND fldCatID=125) OR EXISTS
(SELECT fldLinkID FROM tblLinkCat WHERE fldLinkID=tblLinks.fldID AND
fldCatID=126) OR EXISTS (SELECT fldLinkID FROM tblLinkCat WHERE
fldLinkID=tblLinks.fldID AND fldCatID=127))
Danke
Ciao
Janko
~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~
Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular
ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com
_______________________________________________
Database.asp mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/database.asp
