you dont need to use sqlplus - use the ruby dbi module

----- Original Message -----
From: alan <[EMAIL PROTECTED]>
Date: Monday, April 30, 2007 6:21 pm
Subject: [Wtr-general] manipulating dos prompt with watir

> In my watir script i would like to have it go to open a dos 
> command window and start sqlplus, then run a simple query to see 
> if a member exists, the flow would be something like:
> open cmd.exe
> log in as [EMAIL PROTECTED]
> pass the password somewhere around here
> do query select * from members where name = 'testername'
> if cmd contains(testername)
> puts 'yay'
> else
> puts 'drat'
> end
> 
> is this easily done? so far after spending most of the day in 
> google and trying some different ideas I still have nothing. 
> suggestions?i'm new to sql and watir, but since i did make watir 
> send results to and excel file I figure this must also be doable.
> _______________________________________________
> Wtr-general mailing list
> [email protected]
> http://rubyforge.org/mailman/listinfo/wtr-general
> 
_______________________________________________
Wtr-general mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/wtr-general

Reply via email to