Does any type of XML query work in this method? Can you simplfy it...
run a query for a single table and see if it works?
Maybe it is a JDBC driver issue.. Can you try other types of
connections?
>>> [EMAIL PROTECTED] 15/07/2004 4:06:31 pm >>>
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/
---
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/
