Vbscript question

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

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


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