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/
