Unable to Parse QueryExecute Functions

[jerronjames]

                var result = QueryExecute("
            SELECT info_card_id, document_num, revision_nm, title_nm
            FROM tdc_doc_infocard
            WHERE info_card_id = :sourceTemplateNum
            ORDER BY UPPER(document_num) ASC, revision_seq DESC
        ", { sourceTemplateNum = { value="#sourceTemplateNum#", cfsqltype="cf_sql_varchar" }});

Is reporting:

decompile: [ public function getSourceTemplates(required sourceTemplateNum) {, var result = QueryExecute(' , SELECT info_card_id, document_num, revision_nm, title_nm , FROM tdc_doc_infocard , WHERE info_card_id = :sourceTemplateNum , ORDER BY UPPER(document_num) ASC, revision_seq DESC , ', {sourceTemplateNum:{value:'#sourceTemplateNum#',cfsqltype:'cf_sql_varchar'}}); return result;, }] { var result = QueryExecute(' SELECT info_card_id, document_num, revision_nm, title_nm FROM tdc_doc_infocard WHERE info_card_id = :sourceTemplateNum ORDER BY UPPER(document_num) ASC, revision_seq DESC ', {sourceTemplateNum:{value:'#sourceTemplateNum#',cfsqltype:'cf_sql_varchar'}}); return result; }

[ryaneberly]

the parser seems to get it ok.

Is it an issue with the CFLint objects and the decompile method?

[ryaneberly]

@jerronjames, That's from the FunctionLengthChecker isn't it?
it's printing a decompile of the function body twice.

[jerronjames]

Indeed it is with the function length checker. I just excluded it, and it ran fine. Guess I’ll be working on that next week!

From: ryaneberly [mailto:notifications@github.com]
Sent: Tuesday, April 28, 2015 3:05 PM
To: cflint/CFLint
Cc: Jerron James
Subject: Re: [CFLint] Unable to Parse QueryExecute Functions (#49)

@jerronjameshttps://github.com/jerronjames, That's from the FunctionLengthChecker isn't it?
it's printing a decompile of the function body twice.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/49#issuecomment-97206725.