Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Function call from SQL statement


Message #1 by "Nirav Pradhan" <niravpradhan@y...> on Tue, 15 Oct 2002 22:10:50
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

  Return to Index