Also might be worth checking what the max length
For CF_SQL_VARCHAR datatype is.. Maybe give
CF_SQL_LONGVARCHAR a crack..
Adam
Your code:
<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">
---
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/
