How to construct the opposite of "PassThru" SQL in ASP? i.e. the run time must execute only standard ASP functions.
Eg: the RDBMS has constructs like
Conn. Str="Select date_part('year', dtFieldName) as X from tblHavingDateField"
while I need to work it with
Conn.Str="Select date(dtFieldName) as X from tblHavingDateField".
In general, is there any flag to tell the system that I want to execute only ASP code? If possible, where do I plug this in? In the driver, provider?. Is it possible?.
I don't want to write parsers or custom controls.
End of question
Eg: the RDBMS has constructs like
Conn. Str="Select date_part('year', dtFieldName) as X from tblHavingDateField"
while I need to work it with
Conn.Str="Select date(dtFieldName) as X from tblHavingDateField".
In general, is there any flag to tell the system that I want to execute only ASP code? If possible, where do I plug this in? In the driver, provider?. Is it possible?.
I don't want to write parsers or custom controls.
End of question