Is it actually possible to pass a sql statement
_with line breaks_ in as a procparam?? Or is this
Just the email wrapping..
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">
-----Original Message-----
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 15, 2004 4:46 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: Debugging
Adma,
cheers for that, but thats what I did on each occasion, i.e. QA (Query
Analyzer)...
-----Original Message-----
From: Adam Chapman [mailto:[EMAIL PROTECTED]
Sent: Thursday, 15 July 2004 4:47 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: Debugging
---
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/
