Hello All,
I am new to ASP and SQL, and I am not sure if it is possible to call
function from select statement. I am trying to write a query in ASP and
following is the piece of my code:
strSQL = "SELECT * FROM
D:\inetpub\wwwroot\update\courses\coursebulletin.csv "_
& "WHERE '"& myFunction(course_no)&"' = '"& strCourse _
& "' AND school like '%"& strSchool _
& "%' ORDER BY course_no ;"
myFunction(course_no) is user defined function, and course_no is the
variable I needed to grab from db table. When I run this code myFunction
do not get any value passed. Is there anyway I can pass the variable value
as demostrated above.
Any help appreciated. Nirav