Re: Vbscript question

[David Sussman <davids@xxxxxxx>]

The Exectue method returns a Recordset, so:

      Dim rs
      Set rs = objConn.Execture(strSQL)

      Dim DirName
      DirName = rs("Name")

>From there on you're on your own! I know nothing about HomeSeer (yet).

d


"James, Daniel" <daniel.james@xxxxxxx> wrote in message
news:<6553BCF3E25DD2118F0A00AA00AE6AAA44CF5F@tigger>...
> 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
>  
> <http://rd.yahoo.com/M=223174.2050758.3519166.1501134/D=egroupweb/S=1705
> 041992:HM/A=1060415/R=0/*http://adfarm.mediaplex.com/ad/ck/1866-6766-103
> 9-0?1022764793734039> How Much Money Can We Save You?
LowerMyBills.com
> 
>  
> <http://us.adserver.yahoo.com/l?M=223174.2050758.3519166.1501134/D=egrou
> pmail/S=1705041992:HM/A=1060415/rand=202752463>
      
> 
> For more information: http://www.automatedhome.co.uk
> <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
> <http://docs.yahoo.com/info/terms/>
. 


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.