ADO.Net in JScript Question

From: slimasian (evn22_at_drexel-dot-edu.no-spam.invalid)
Date: 05/03/04 

Date: 3 May 2004 14:05:06 -0500

Hey guys,

Relative newbie to ADO here. I wanted to see if I could perhaps
receive some guidance from the experts in here. I need to create an
ADO connection to a SQL Server database in JScript. I read SOME
material on MSDN, but it is very confusing. Just a few simple
questions...any help at all would be extremely appreciated:

1) How do I create an ADO connection through JScript? Once I do have
a connection, all I want to do is a simple query that will return
only one row...I'd assume once the ADO is open, I'd do something
similar to sqlConnection.ExecuteNonQuery, a la VB.NET?

2) Once my query has executed, how can I pass that value onto a
variable? Like I said, my query will only return one row, and I am
only selecting one value. How do I pass that onto a variable in
JScript?

Thanks a lot for the help, guys.

slim...

Relevant Pages

  • RE: ODBC query in VB code Need HELP
    ... Everything for ADO is in the first 2 messages that I gave you. ... Since your pass-through query already exists (including the ... Dim STRSQL As String ...
    (microsoft.public.access.formscoding)
  • Re: Connecting to Query
    ... practice examples of the ADO Command, Parameters, etc. you explained below. ... Second, with the selected territory ... >> combo box to select a product from a query based primarily on a link ...
    (microsoft.public.access.formscoding)
  • Re: On ADSI and LDAP
    ... the problem is how can I retrieve the value for myuser using the ... would be more efficient to use ADO to query AD for the attributes values. ... For more on using ADO, ... Dim adoCommand, adoConnection, strBase, strFilter, strAttributes ...
    (microsoft.public.scripting.vbscript)
  • Re: cant get query to run over ADO, but works fine in Access inte
    ... Thanks for the suggestions, Richard. ... the query so that unchanging parts of it are stored as a query with the part ... As I've had trouble with synchronizing ADO ... > Execute method of the ADO Connection object, but the issue is the same - you ...
    (microsoft.public.data.ado)
  • Re: Stored Procedure is running slow!
    ... > I run stored procedure from QA, it takes some 15 seconds to execute. ... > seconds when called from MS Fox Pro, via ADO. ... Try this in Query Analyzer: ... By default Query Analyzer runs with ARITHABORT ON, ...
    (microsoft.public.sqlserver.programming)