Re: Excel Download issue.

On 18/05/2005, Divya wrote: > In our application, we generate excel which is more than 150MB of > size. > But is there a way to provide the user with a hyper link, upon > clicking; that will open the file that is there in temp location in > the unix server. I use the following code to serve an e

Re: cacheing problem

On 28/03/2005, David Nicol wrote: > I am using dbd::mysql on activestate perl 5.8. When I select a row in > my program, change the row using the mysql administrator tool, and > select the row again in the program, the results are not changed. I > can get the new data by selecting a different r

Re: Can't connect to mySQL

On 18/03/2005, Dietmar Appelt wrote: > #H:\Perl>test.pl > #DBI connect('test:032dappelt','dappelt',...) failed: Client does not > support aut #hentication protocol requested by server; consider > upgrading MySQL client at H:\ #Perl\test.pl line 9 See e.g. http://www.nntp.perl.org/group/perl.dbi.u

Re: How do I detect non-select statements after calling $sth->execute()

on Wed, 04 Sep 2002 12:27:23 GMT, [EMAIL PROTECTED] (Roger Perttu) wrote: > I have absolutely no control of the "query". So a simple 'DROP DATABASE' would also be acceptable ;-) You can always write your own error handler. Search perldoc DBI for 'HandleError' -- felix

Re: Access connection

on Tue, 20 Aug 2002 09:35:56 GMT, [EMAIL PROTECTED] (Nicolas jourden) wrote: > I'm working on a script wich need to connect to an Access > database (test.mdb), does someone have some more information > like "how to" or RFC about the connection to the "file" > database... or a file exemple... Yo

Re: trouble using bind values with dynamic sql

on Tue, 13 Aug 2002 18:36:10 GMT, Michael spellbrink wrote: > Now I want to create select statements for $value in each of the > result @table_name. > something like that: > > for ($i= 0; $i<@table_name; $i++) > { > > my $sql2="select * from ? where ? = ?"; > my $sth=$dbh->prepare($

RE: Newbie question concerning DBI

on Tue, 09 Jul 2002 14:05:51 GMT, [EMAIL PROTECTED] (Timothy Helck) wrote: > Generally I prefer to cat together my select statement as a > string, then use prepare(). Like this: > my $SQL_sth1 = q > { SELECT * > FROM coverage_primary_loan > WHERE certificate_nu

Re: Looping script maintain db connection

on Wed, 26 Jun 2002 22:56:29 GMT, [EMAIL PROTECTED] (Tim Bunce) wrote: > Yeap. Something like: > > while (...) { > eval { >$dbh = DBI->connect_cached(..., { RaiseError => 1 >}); >... do the work here ... > } > } > >

Re: DBD::CSV from Windows to Unix?

on Wed, 26 Jun 2002 12:26:17 GMT, [EMAIL PROTECTED] (Jonathan) wrote: > How do I go about getting hold of the Unix version? -- felix

Re: Naive questions about speed

on Tue, 25 Jun 2002 13:36:03 GMT, [EMAIL PROTECTED] (Rory Campbell-Lange) wrote: > Although the Director application (sited on about 8 machines) > shouldn't tax the modest resources of our server, I am interested > in knowing if there are some simple ways of speeding up queries. > My particular

Re: Error using on Win32

on Mon, 24 Jun 2002 21:35:35 GMT, [EMAIL PROTECTED] (Pierre Rodrigues) wrote: > How can I correct the following error: > [error code snipped] > I have it on my Perl scripts running on a WinNT with all required > modules: DBI and DBD-mysql Show us your code. -- felix

Re: sth->fetchrow_array

on Thu, 13 Jun 2002 07:16:29 GMT, [EMAIL PROTECTED] (Philip M . Gollucci) wrote: > I need to write a wrapper function for calls to > $sth->fetchrow_array() where the SELECT statement will return > multiple rows. > > such that > > sub do_sql_array ($@) { > # on initial call: $sth = $dbh->p

Re: excessive memory usage not being released?

on Fri, 24 May 2002 21:00:31 GMT, [EMAIL PROTECTED] (Zachary Buckholz) wrote: > What I noticed is that each time through the process of submitting > a website to the list of search engines the memory usage of the > program increases by 1 meg. Since the program also uses Parallel > Fork Manager ea

Re: Need a little help...

on Fri, 24 May 2002 19:23:47 GMT, Scott V Nipp wrote: > I am trying to figure out a way to somehow test the FTP connection, and > if the connection is unsuccessful then I want to FTP to a different > server instead. use Net::FTP; my @servers = qw(server1 server2 server3); my $ftp;

RE: DBI "Prepare" Statement Not Working

on Tue, 21 May 2002 19:33:23 GMT, Ilya Sterin wrote: [Thread rearranged] >> From: [EMAIL PROTECTED] >> Can I bother you with another question - how do I open up a file and >> redirect the result set into it? > At this point it would really hep investing in a good perl book. > Learning Perl b

Re: DBI "Prepare" Statement Not Working

on Tue, 21 May 2002 13:22:23 GMT, [EMAIL PROTECTED] wrote: > Okay thanks, I added "my $dbh;" prior to the subroutine and am > still receiving the same error. Here is the code: > sub db_connect > { > use DBI; > use strict; > > my $db_connect = 'DUMY'; > my $dbh = DBI->connect("dbi:Oracle:$db_con

Re: DBI "Prepare" Statement Not Working

[Private message returned back to list] Please send further questions to the mailing list instead of by private email. Other list members may want to contribute. > > >The query does work in Sql*plus. I'm not getting any errors from my >connect string. Here is the sub with my dbh definition:

Re: DBI "Prepare" Statement Not Working

on Tue, 21 May 2002 12:34:53 GMT, [EMAIL PROTECTED] wrote: > my $sth = $dbh->prepare("select rollup_code, rollup_value, > french_flag > from FMC_REPORT_CREATE_PARAMS > where aggr_rpt_id = 2 > order by report_seq_num");

Re: slow CONNECT to Oracle

on Tue, 14 May 2002 16:58:50 GMT, [EMAIL PROTECTED] (Peter Masiar) wrote: > Problem: > I am running IIS on Win2000 (%.00.2192), + Servce pack 2 > ActiveState Perl 5.6.1 build 631 > DBI 1.14 > Oracle 8.0.5.0.0 for NT > connecting via Oracle ODBC (file has date from 1998) Why ODBC and not DBD::Or

Re: adding a field

on Mon, 13 May 2002 00:25:36 GMT, [EMAIL PROTECTED] (Todd Derenne) wrote: > I'm using dbi with Mysql and want to add a field to an existing > table while maintaining the data in the table. How is this done? To add a CHAR(20) field, you could use: $dbh->do( qq{ ALTER TABLE mytable

Re: Need some help

on Thu, 09 May 2002 22:57:23 GMT, [EMAIL PROTECTED] (Rene Lovato) wrote: > I'm looking for DBI: ( ODBC, CSV, ORACLE) that I can install on my > Windows client. I can only find tar files and I can not unpack > them. It would be nice to find them in a Zip format or is there a > windows app to unpa

Re: Help...

on Tue, 07 May 2002 13:32:01 GMT, [EMAIL PROTECTED] (Walnut) wrote: > On Wed, 4 Apr 2001 14:58:49 -0700 , you wrote: > >> The address to unsubscribe has an "=" sign in it, and my >> Outlook cuts off the email address there. How do I unsubscribe? >> <[EMAIL PROTECTED] >> > >> Thanx

Re: Nulls, undef, split and ODBC

on Tue, 07 May 2002 09:48:39 GMT, [EMAIL PROTECTED] (Simon Oliver) wrote: > my @data = map {length($_) ? $_ : undef} split(@$row); You do realize that you are splitting $_ here? -- felix

Re: DBI 500 server error

on Thu, 02 May 2002 17:40:48 GMT, [EMAIL PROTECTED] (Lori Thompson) wrote: > I have a simple perl/cgi script which reads the username and > password from a form and connects to the database using the Perl > DBI module. The script works fine on the command line but not > through the web server (u

Re: urgent beginners problem!

on Fri, 19 Apr 2002 12:36:38 GMT, [EMAIL PROTECTED] (Michael spellbrink) wrote: > [...] > but when i try to fetchrow_array > (to get columns a and b in @a and @b), > i get only errors. could anyone help? What errors? Could you post the offending code and the error messages? That way it will be

Re: mysql query

on Wed, 10 Apr 2002 03:11:40 GMT, Andrey wrote: > What is wrong with this query: > > select * from MYTABLE where MYTABLE.entry NOT IN (select > ANOTHERTABLE.entry from ANOTHERTABLE) Current stable versions (3.23.x) of MySQL do not support sub-selects. See

Re: Big Chunk Of data

on Mon, 08 Apr 2002 20:29:07 GMT, Daniel Rozengurtel wrote: > Hello All, > > i am trying to select a big chunk of data to archive it into a flat > file. Its a " select * " query which normally returns 1,200,000 > records. > 1. Is there anything in DBI/DBD that I can use to do the job > without