RE: Vbscript question

["David Pullen" <dpullen@xxxxxxx>]

Daniel

Just set your variable record set equal to objConn.Execute(strSQL)

The data will be returned.

i.e. 

answer= objConn.Execute(strSQL)

answer(0), answer(1) etc will contain the results

David


   Date: Thu, 30 May 2002 14:10:03 +0100
   From: "James, Daniel"
<daniel.james@xxxxxxx>
Subject: Vbscript question

Hi all

I've not marked this as OT, as its related to Homeseer :-)

I have managed to write a script that writes the number received on my
meteor into a Database, so I can record who called :-)

Anyhow I'm now looking at using a lookup to find the name of the person
who
called, against my directory of names and numbers.

My problem is how I get the output from my SQL statement into a
variable
that I can use in the code:

small snippet:

I so far have:

strSQL = "SELECT tblDirectory.Name FROM tblDirectory WHERE
tblDirectory.Number =" & "'" & sNumber &
"';"

objConn.Execute(strSQL)
            
but how do I get the output from the SQL statement back into homeseer?

Any ideas appreciated!!

Daniel

Yahoo! Groups Sponsor

ADVERTISEMENT

For more information: http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.