Dynamic SQL Select Statement

[ebrandt]

This is just a conceptual question,

I have created methods that run SELECT statements and return the data set formated with html. This work great for predetermined critera when running complex or extenive reports.

Is it possible to pass a variable into the select statement?

I want the user to be able to enter criteria such as a date range, to return the data set.

I don't need any in depth responce, I just want to make sure I can accomplish this while I am testing all the functions I will need for my solution. I will most likely not dig into this issue for a few more weeks (If it is possible)

Thankx,
Erich

[patrick]

yes, that is no problem. Just build your statement like this:

Code: Select all

var query = 'select * from x where y = ' + somefield

somefield, then, is your dynamic part...

[ebrandt]

Thank you

[pbakker]

Also have a look at the SQL generator in the CRM demo. It's a good example of dynamically building SQL statements.

since the SQL statement is just a textstring, you can use all text string tools available, to dynamically build the SQL statement.

Paul