* Frank Saab <[EMAIL PROTECTED]> [2002-12-26 16:09]:
> Two things in this message:
> (1) how I solved a problem with 'make install' for DBI - is there a better
> way to do this?
The correct way, given your example below, would be:
perl Makefile.PL PREFIX=~/usr/local
> (2) a problem with insta
* chad kellerman <[EMAIL PROTECTED]> [2002-12-19 09:27]:
> Hi guys,
Hi, chad.
> I am starting to work a lot with perl DBI and mysql a lot lately.
> One of the bigger issues that I am having is that whenever I do a select
> statement to grab variable froma db.. is seems that they are always
> re
* Mitchel, Jennifer (Jem) <[EMAIL PROTECTED]> [2002-12-17 04:19]:
> Hi all,
>
> I am getting the following error out of a script.
> DBI->connect(carespro) failed: ORA-12154: TNS:could not resolve
> service name (DBD ERROR: OCIServerAttach) at test.cgi line 11 Can't
> call method "prepare"
On Wednesday, December 11, 2002, at 01:47 PM, Bong Tumanut wrote:
> I just did some testing. Your SQL is
> SELECT ... IN 1 2 3
> That's syntactically incorrect.
IIRC, IN requires parens and commas:
$sql = "SELECT ... IN (" . join(", ", @some_array) . ")";
Or just:
local $" = ", ";
$sql =
* Chris Rogers <[EMAIL PROTECTED]> [2002-11-26 09:45]:
> Is there a way to get a list of all table names in specific database
> using DBI::mysql in Perl?
Can you use SHOW TABLES? E.g.:
sub show_tables {
my $dbh = shift;
my ($sth, @tables, $table);
$sth = $dbh->prepare("SHOW