HOW CAN YOU CREATE DYNAMIC QUERY?

Awadhendra Tiwari

Total Post:510

Points:2550
Posted by  Awadhendra Tiwari
 1231  View(s)
Ratings:
Rate this:
  1. Awadhendra Tiwari

    Post:510

    Points:2550
    How can you create dynamic query?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!