Home > DeveloperSection > Interviews > How can you create dynamic query?

Posted on    May-17-2011 2:19 AM

 Cold Fusion Cold Fusion 
 1 Answer(s)
  1168  View(s)
Rate this:

Awadhendra Tiwari

Total Post:510

Posted on    May-17-2011 12:00 AM

Dynamic SQL is a SQL code that your program generates using variables before the SQL is executed.
In coldfusion, CFQUERY give full provision to write all conditional logic & looping to derive the dynamic sql statement to execute. You can use dynamic SQL to accomplish tasks such as adding WHERE clauses to a search based on the fields that the user filled out on a search criteria page.

Don't want to miss updates? Please click the below button!

Follow MindStick