<cfquery ...>
        yourSQLUDF()
</cfquery>

It should be that simple, you may need to sort out permissions though.

Ade

-----Original Message-----
From: Kenton Gray [mailto:[EMAIL PROTECTED]
Sent: 25 February 2005 00:54
To: CF-Talk
Subject: Calling SQL User Defined Functions from Coldfusion


I'm currently trying to port an app from .net to coldfusion (for
various reasons), but the app uses microsoft sql server user defined
functions. I can't seem to find any reference on how to call them from
coldfusion, or if it's even possible.

Searching on google gives me alot of results for how to create
coldfusion user defined functions and how to create sql user defined
functions, but no information on how to use sql udfs in coldfusion :)

So hopefully everyones head didn't explode from trying to understand me,

Thanks
Kenton




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196448
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to