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.
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.
No comments:
Post a Comment