>Kannst du deine SP posten?
CREATE PROCEDURE sp_getcommissions
@paramStartDate smalldatetime,
@paramEndDate smalldatetime
AS
/* erster SELECT */
SELECT
*viele Felder*
FROM
dbo.tblCommissions
LEFT JOIN dbo.tblOrders
ON dbo.tblCommissions.lngCOMCommID = dbo.tblOrders.lngCOMCommID
LEFT JOIN
dbo.tblOrderTypes
ON dbo.tblOrders.lngORTOrderTypeID = dbo.tblOrderTypes.lngORTOrderTypeID
WHERE
sdtCOMCommDate >= @paramStartDate AND
sdtCOMCommDate <= @paramEndDate
ORDER BY
tblCommissions.nvcCOMCommNumber DESC,
tblCommissions.lngCOMCommID DESC
/* zweiter SELECT */
SELECT
SUM(tblOrders.fltORDPurchaseOrderAmount) as fltORDSumPurchaseAmount
FROM
dbo.tblCommissions
LEFT JOIN dbo.tblOrders
ON dbo.tblCommissions.lngCOMCommID = dbo.tblOrders.lngCOMCommID
WHERE
sdtCOMCommDate >= @paramStartDate AND
sdtCOMCommDate <= @paramEndDate
/* dritter SELECT */
SELECT
SUM(tblInvoices.fltINVInvoiceAmount) as fltINVSumInvoiceAmount
FROM
dbo.tblCommissions
LEFT JOIN dbo.tblInvoices
ON dbo.tblCommissions.lngCOMCommID = dbo.tblInvoices.lngCOMCommID
WHERE
sdtCOMCommDate >= @paramStartDate AND
sdtCOMCommDate <= @paramEndDate
/* hier kommt der heute hinzugef�gte SELECT */
SELECT
SUM(tblCommissions.fltCOMCommPmntAmnt) as fltCOMSumPaymentAmount
FROM
dbo.tblCommissions
WHERE
sdtCOMCommDate >= @paramStartDate AND
sdtCOMCommDate <= @paramEndDate
GO
>Ggf. ASP-Code?
' * erster Select
Do While Not rsXML.Eof
' *Felder des ersten SELECT's
Loop
'* Zweiter Select
Set rsqXML = rsqXML.NextRecordset
InsertXMLNode objXMLDocument, _
objfltORDSumPurchaseAmount, _
"fltXMNORDSumPurchaseAmount", _
objXMLRoot, _
rsqXML("fltORDSumPurchaseAmount")
' * dritter Select
Set rsqXML = rsqXML.NextRecordset
InsertXMLNode objXMLDocument, _
objfltINVSumInvoiceAmount, _
"fltXMNINVSumInvoiceAmount", _
objXMLRoot, _
rsqXML("fltINVSumInvoiceAmount")
' * vierter Select
Set rsqXML = rsqXML.NextRecordset
Set rsqXML = rsqXML.NextRecordset
InsertXMLNode objXMLDocument, _
objfltCOMSumPaymentAmount, _
"fltXMNCOMSumPaymentAmount", _
objXMLRoot, _
rsqXML("fltCOMSumPaymentAmount")
>Was passiert denn, wenn du nur einmal springst? Bist Du dann noch auf
>dem alten RS?
dann erhalte ich, egal ob ich das Feld via rsXML("fltCOMSumPaymentAmount")
oder rsXML(0) anspreche, immer die Meldung, da� ein Feld mit diesem
Namen nicht gefunden werden konnte.
Gruss
Alex
www.aspintranet.de
~~~~~~~~~~~~~~~~~~~~~~~~~~~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
