Output Of dump_results

2001-10-27 Thread John Abel
Hi, I have written a Perl script to run SQL commands, and then uses DBI->dump_results. I need to be able to capture the output of this into a variable. However, no matter what I do, all I end up with, is the last line. Any help would be appreciated. Thanks John --

Apostrophe In SELECT

2001-10-24 Thread John Abel
Hi, I am having bother trying to perform a select, that has an apostrophe in the value I’m looking for. Below is the Perl code I’m using. $SQLStatement = "SELECT ID FROM Albums WHERE Name = '".$DBHandle->quote($Name)."';"; $STLookUpHandle=$DBHandle->prepare($SQLStatement);

Upgrade Query: Solaris7 To 8

2001-10-04 Thread John Abel
Hi, I have MySQL currently running under Solaris7, and wish to set-up a slave, also running Solaris7. At some point, though, the slave will be upgraded to Solaris8. Will the MySQL binaries still work OK, or will I need to install the Solaris8 binaries? Also, would it be possible to have th