Function that has sql statement

gop373 · #1 (**permalink**) 02-27-05, 08:26

I am trying to write function which consists of sql statement. Is it possible to do that ? I tried this code but it did not work. Any suggestion !!!


<%
Function Test(strColumn,strTable,strCondition)
set rst=server.createobject("adodb.recordset")
rst.open sql,conn,1,3
sql="Select"&strColumn&"From"&strTable&"where"&str Condition
End Function

dim a
a=Test("price","BA","id="&1)
response.write a
%>

rokslide · #2 (**permalink**) 02-27-05, 17:00

well what you have won't work, but something close to it will, more like...

Code:

<!--#include file="connect.asp"--> 
<%
Function Test(strColumn,strTable,strCondition)
  set rst=server.createobject("adodb.recordset")
  sql="Select"&strColumn&"From"&strTable&"where"&strCondition
  rst.open sql,conn,1,3
  Test = rst(strColumn)
End Function

dim a
a=Test("price","BA","id="&1)
response.write a
%>

Internet Services

Web Development

Digital Marketing

Consumer Tech