Classic ASP SQL string

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).

Answers


The Varial should be inclosed in single quotes

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

Need Your Help

Visual C++ 2012 missing mspdb110.dll

visual-c++ visual-studio-2012 cmd

I am trying to compile on cmd using cl and it says that I'm missing mspdb110.dll.

How can I focus on a given table's row using javascript/jquery?

javascript jquery

Having a big html table with many rows that does not fit on the screen, do you know how to focus on a given row with javascript/jquery avoiding the need to scroll down?