even this still produces the same error, when executed in QA, again it works fine,
anyone yet?
<cfquery name="qXML" datasource="#application.setting.dsnMain#">
EXEC [spForXML] 'NYMPH', 'dbCCDB_development', 'SELECT * FROM
tblContact contact INNER JOIN tblPerson person ON
contact.fkPerson = person.pkIDPerson INNER JOIN
tblContact_Address contact_address ON
contact.pkIDContact = contact_address.fkContact INNER JOIN
tblOrganisation organisation ON contact.fkOrganisation =
organisation.pkIDOrganisation INNER JOIN tblAddress address ON
contact_address.fkAddress = address.pkIDAddress WHERE
(contact.pkIDContact = #session.contactEdit#) FOR XML AUTO, ELEMENTS'
</cfquery>
-----Original Message-----
From: Taco Fleur
Sent: Thursday, 15 July 2004 4:19 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: Debugging
Even executing the SP in cfquery gives me the same error, can anyone spot the problem?
<cfquery name="qXML" datasource="#application.setting.dsnMain#">
DECLARE @serverName VARCHAR(40)
DECLARE @databaseName VARCHAR(40)
SET @databaseName = DB_NAME()
EXEC [spForXML] @serverName = @@SERVERNAME, @databaseName =
@databaseName, @selectStatement = 'SELECT *
FROM tblContact contact
INNER JOIN tblPerson person
ON contact.fkPerson = person.pkIDPerson
INNER JOIN tblContact_Address contact_address
ON contact.pkIDContact =
contact_address.fkContact
INNER JOIN tblOrganisation organisation
ON contact.fkOrganisation =
organisation.pkIDOrganisation
INNER JOIN tblAddress address
ON contact_address.fkAddress =
address.pkIDAddress
WHERE (contact.pkIDContact = #session.contactEdit#)
FOR XML AUTO, ELEMENTS'
</cfquery>
-----Original Message-----
From: Taco Fleur
Sent: Thursday, 15 July 2004 4:07 PM
To: CFAussie Mailing List
Subject: [cfaussie] Debugging
No matter what I try I get a
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]The DBMS returned an unspecified error.
All the stuff runs fine in QA, anyone any idea how to get a more sensible error
message or even get to the bottom of this?
<cfstoredproc procedure="spForXML" datasource="#application.setting.dsnMain#">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
value="NYMPH" null="no">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
value="dbCCDB_development" null="no">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
value="SELECT *
FROM tblContact contact
INNER JOIN tblPerson person
ON contact.fkPerson = person.pkIDPerson
INNER JOIN tblContact_Address contact_address
ON contact.pkIDContact =
contact_address.fkContact
INNER JOIN tblOrganisation organisation
ON contact.fkOrganisation =
organisation.pkIDOrganisation
INNER JOIN tblAddress address
ON contact_address.fkAddress =
address.pkIDAddress
WHERE (contact.pkIDContact = #session.contactEdit#)
FOR XML AUTO, ELEMENTS" null="no">
<cfprocparam type="Out" cfsqltype="CF_SQL_VARCHAR"
variable="xmlDoc" null="no">
</cfstoredproc>
Register now for the 3rd National Conference on Tourism Futures, being held in
Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
Register now for the 3rd National Conference on Tourism Futures, being held in
Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
Register now for the 3rd National Conference on Tourism Futures, being held in
Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
