yeah it was longvarchar before varchar...
-----Original Message-----
From: Adam Chapman [mailto:[EMAIL PROTECTED]
Sent: Thursday, 15 July 2004 5:06 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: Debugging
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/
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/
