Classic ASP SQL string

Question

I need to pass generated sql string and query database and need to get data out of it.

      dim sql,spack
  spack="test"
  sql="select * from dbo.packageName A where a.custname=" & spack 

  set rs = getRs(sql)

This code statement return error. Could you please someone explain me how to pass parameter like above code segment(parameter spack).

Rab Khan · Accepted Answer · 2013-04-22 08:01:31Z

3

The Varial should be inclosed in single quotes

 sql="select * from dbo.packageName A where a.custname='" & spack & "'"

answered Apr 22, 2013 at 8:01

Rab Khan

35.7k4 gold badges52 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1