RE: Vbscript question

["James, Daniel" <daniel.james@xxxxxxx>]

Thanks David / David /Mark / andy

for your replies

It now makes more sense :-)

I have the Database bit working now, I'm now working on getting the
Info
>from
I have not done any code for around 7+ years, and even then it wasn't
my
forte!!

Daniel

-----Original Message-----
From: David Pullen [mailto:dpullen@xxxxxxx]
Sent: 30 May 2002 16:06
To: ukha_d@xxxxxxx
Subject: RE: [ukha_d] Vbscript question


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





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 http://docs.yahoo.com/info/terms/



***********************************************************
This message is confidential and intended for the exclusive 
use of the addressee(s) only and remains the property of 
Exchange FS Group plc. You should not disclose its contents 
to any other person. If you are not the intended recipient 
please notify the sender named above immediately.

Registered Office: Munro House, Portsmouth Road, Cobham, 
Surrey, KT11 1TE. Registered in England No. 2596452
***********************************************************

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.