I would think it is possible as its still a string, but I tried without linebreaks as well..
Cheers. -----Original Message----- From: Adam Chapman [mailto:[EMAIL PROTECTED] Sent: Thursday, 15 July 2004 5:03 PM To: CFAussie Mailing List Subject: [cfaussie] RE: Debugging 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/ 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/
