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

Question

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

score 3 · Accepted Answer · answered Jun 13 '12 at 17:27

3

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

answered Jun 13 '12 at 17:27

Busches

1,964
16
19

score 2 · Answer 2 · answered Jun 13 '12 at 17:28

2

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

answered Jun 13 '12 at 17:28

Snipe656

845
7
15

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

2 Answers2