Look up ruby "system" or "exec" commands. Also consider connecting to the DB directly with ODBC or DBI. -Chris
On 4/30/07, alan <[EMAIL PROTECTED]> wrote: > 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
