"Johnson, Shaunn" <[EMAIL PROTECTED]> writes: > --thanks for the reply. > > --i see the same example in the Perldoc for DBI, > --but what i don't see is if i can substitute: > > > >>> $sth->execute('Bill', 32); > > with something like this: > > >>> $sth->execute ('select tableowner from t_table'); > > and have the results from that be put in > place of '?'.
Ah, not directly - you can either do a subselect (which may or may not be supported by your particular database - I seem to recall reading that mySQL does not support it. I use Oracle here at work, and haven't used mySQL in quite a while), or do it in two steps. A subselect: SELECT table_owner, table_columns, table_def FROM master_table WHERE table_owner IN(SELECT tableowner FROM t_table) AND table_columns <= ? EOQ This basically runs the inner 'SELECT' query first, and feeds the results into the outer query. Check your database's documentation to see if subselects are supported. > --but perhaps i am getting too far ahead of myself > --(more likely than not). in the above example, > --you assign 'Bill' and '32' ... but what if > --i have a text file created (say the list of > --users from the original query). how can i > --put the list in? can i say something like > > >>> $sth->execute ($file); You cannot do that - > > --maybe read($file)? this is the part that doesn't > --make sense to me. how can i pass the list > --of users inside the sql? there is a part in > --the perldoc DBI that says something like > > open FH, "phone.csv" or die "blah, blah dead:$!"; > while (<FH>) { > chomp; > my ($name, phone) = split /,/; > $sth->execute($name, $phone); > ; > close $FH; Yes, the above should work...You might want to add some error handling to your parsing - for instance, what if the last line in the file is blank, or if you have a line like 'Bill Clinton,' ($phone ends up being undef) > --i'm going to test this to see if i can > --use my text file to put data into the > --query ... > > --it may just be that i will have to do > --this in a two or three step process. Yes, you will need to do two steps - at least I know of no other way. Good luck! -RN -- Robin Norwood Red Hat, Inc. "The Sage does nothing, yet nothing remains undone." -Lao Tzu, Te Tao Ching -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]