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?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.