I figured it out, turns out I had too many single quotes and it was confusing the SP call.
*now* I feel like I should go crawl into a hole for not seeing/trying it earlier! Moo, Hatton On Wed, Sep 7, 2011 at 12:35 PM, Judah McAuley <[email protected]> wrote: > > StackOverflow says you need to set a Database Context when executing > it inside an SP > > http://stackoverflow.com/questions/658780/passing-stored-procedure-to-sp-send-dbmail > > Cheers, > Judah > > On Wed, Sep 7, 2011 at 9:17 AM, C. Hatton Humphrey <[email protected]> > wrote: >> >>> Permissions differences to the attachment files/file system between >>> the direct call and the sp? >>> >>> do they both have the same permission access to the attachment files? >> >> Since the call was made from the same query window I would assume so. >> Unfortunately the error message I'm getting is much less than helpful! >> >> Thanks for the reply, >> Hatton > e: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:342293 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
