Re: Aliases in DBI/DBD

2004-12-24 Thread David N Murray
If you are trying something like my $sql = "select to_char(mf.ROW_MOD_DATE,'MM/DD/') "Modify Date" from tbl mf"; then its perl that's balking. (List hint: actual code samples are extremely helpful.) You need to escape the quotes within this string (well, that's one way to do it, anyway): my

Aliases in DBI/DBD

2004-12-24 Thread Robert
Hi list, how do I specify alias in DBI/DBD-Oracle select to_char(mf.ROW_MOD_DATE,'MM/DD/') "Modify Date", mf.mf_name "Manufacture" from table1 mf DBI/DBD doesn't like double quotes, is there any other way?. __ Do You Yahoo!? Tired o

Re: Problems Installing DBD::MySQL

2004-12-24 Thread Michael A Chase tech
On 12/23/2004 07:55 PM, Tony McCray said: Thanks Dave, you helped a lot actually. It turns out that I have a file in /lib called libnss_files.so.2. I made a copy of the file and got rid of the '.2' extension. I had to do the same thing with libnss_dns.so. I haven't tested it yet, but make, make tes

Re: Trying to install DBD::MySQL on raq3: sorted

2004-12-24 Thread Jim Byrne
on 12/24/04 10:04 AM, Jim Byrne at [EMAIL PROTECTED] wrote: > HI, > > I'm trying to install DBD-mysql-2.9004. I run perl Makefile.PL I > got the error that mysql_config can't be found. Hi, Looks like I've got it sorted - most of the test failures were due to me not giving the user and password

Trying to install DBD::MySQL on raq3 - Failed 17/18 test scripts, 5.56% okay. 727/730 subtests failed, 0.41% okay

2004-12-24 Thread Jim Byrne
HI, I'm trying to install DBD-mysql-2.9004. I run perl Makefile.PL I got the error that mysql_config can't be found. I have found mysql_config on my system (Raq3, perl v5.6.1 built for i586-linux) at /usr/local/mysql/bin/mysql_config - but I don't know how to feed this to the Makefile script - or