CODEWITHSUNDEEP
sqlcoldfusioncfquerycfqueryparam
Stephane
Stephane

Reputation: 5078

How to create a function in CFML within some SQL queries?

I would like to create a function in CFML taking 3 parameters (a number and two dates). The function will then perform a few cfquery queries on these data like SELECT, UPDATE and INSERT...Any idea on how to code this function ? I'm a cfml newbie so be nice

Upvotes: 0

Views: 93

Answers (2)

Snipe656
Snipe656

Reputation: 845

Adobe docs have a section on how to write UDFs(User Defined Functions). Probably best to start there:

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=UDFs_03.html

Upvotes: 2

Busches
Busches

Reputation: 1964

What you're asking for is very basic and reviewing the documentation of cffunction should be enough to get you started: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f5c.html

Upvotes: 3

Related Questions