Re: Perl/DBI

2007-07-24 Thread David Busby
Shawn Hinchy wrote: Hello all, I am getting to the point where I need to start thinking about doing pagination for search results. I did some searches and it looks like there are some pagination modules, but I am not quite interested in going that route yet. I am using a handful of

Re: Perl/DBI

2007-06-24 Thread Tyler Gee
On 6/24/07, Shawn Hinchy [EMAIL PROTECTED] wrote: Hello all, I am getting to the point where I need to start thinking about doing pagination for search results. I did some searches and it looks like there are some pagination modules, but I am not quite interested in going that route yet. I

Re: Perl/DBI

2007-06-24 Thread Shawn Hinchy
Quoting Tyler Gee [EMAIL PROTECTED]: On 6/24/07, Shawn Hinchy [EMAIL PROTECTED] wrote: Hello all, I am getting to the point where I need to start thinking about doing pagination for search results. I did some searches and it looks like there are some pagination modules, but I am not quite

Re: Perl/DBI

2007-06-24 Thread Tyler Gee
On 6/24/07, Shawn Hinchy [EMAIL PROTECTED] wrote: Quoting Tyler Gee [EMAIL PROTECTED]: On 6/24/07, Shawn Hinchy [EMAIL PROTECTED] wrote: Hello all, I am getting to the point where I need to start thinking about doing pagination for search results. I did some searches and it looks like

Re: Perl/DBI

2007-06-24 Thread Greg Jetter
On Sunday June 24 2007 8:31 am, Shawn Hinchy wrote: Hello all, I am getting to the point where I need to start thinking about doing pagination for search results. I did some searches and it looks like there are some pagination modules, but I am not quite interested in going that route yet.

Re: Perl/DBI

2007-06-24 Thread Paul Archer
If you are not interested in using the modules, it is not actually that hard to roll your own. In the past I have done different things for total counts, either two separate queries, one just a 'SELECT COUNT(*)' and the other to actually fetch the data. Depending on your data you might be

Re: Perl DBI / SQL Question

2005-09-16 Thread Scott R. Godin
Vance M. Allen wrote: Sorry if the cross-posting wasn't appropriate, but I need help with this and am not sure if it's more appropriate to post under CGI or DBI since it involves both...I want to be sure that I can get help from the best source. My question is probably a simple answer, but I

Re: Perl DBI / SQL Question

2005-09-15 Thread Vance M. Allen
I use MySQL 4.1.7 under Fedora Core 3. Vance Bob Showalter [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Vance M. Allen wrote: I need to know how to retrieve through Perl DBI a listing of possible ENUM elements from a field for processing under a CGI script. Need to know what

Re: Perl DBI / SQL Question

2005-09-15 Thread Sean Davis
On 9/14/05 8:32 PM, Vance M. Allen [EMAIL PROTECTED] wrote: I use MySQL 4.1.7 under Fedora Core 3. Vance Bob Showalter [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Vance M. Allen wrote: I need to know how to retrieve through Perl DBI a listing of possible ENUM elements

Re: Perl DBI / SQL Question

2005-09-14 Thread Vance M. Allen
Sorry if the cross-posting wasn't appropriate, but I need help with this and am not sure if it's more appropriate to post under CGI or DBI since it involves both...I want to be sure that I can get help from the best source. My question is probably a simple answer, but I am not sure what I have

RE: Perl DBI / SQL Question

2005-09-14 Thread Bob Showalter
Vance M. Allen wrote: I need to know how to retrieve through Perl DBI a listing of possible ENUM elements from a field for processing under a CGI script. Need to know what database you're talking about. This will probably involve querying data dictionary views or tables. Some DBI drivers also

Re: How to secure database password? (was Re: Perl/DBI newbie: password storage / security question)

2003-11-27 Thread Todd Farmer
]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 12:04 AM Subject: How to secure database password? (was Re: Perl/DBI newbie: password storage / security question) Hello, Many thanks to R. Joseph Newton, Motherofperls, essential quint

How to secure database password? (was Re: Perl/DBI newbie: password storage / security question)

2003-09-17 Thread zedgar
Hello, Many thanks to R. Joseph Newton, Motherofperls, essential quint and Chuck Fox for answering my questions, however it is still not what I was asking about. My previous posts were long and maybe unclear so I'll try to get straight to the point this time, adding more details at the bottom

Re: How to secure database password? (was Re: Perl/DBI newbie: password storage / security question)

2003-09-17 Thread Chuck Fox
Zedgar, You are chasing the yourself into circles. Security is dictated by circumstances and resources available. In our case, we had plenty of both and developed for our needs the best solution. Insofar as the storing of the password for the login that is used to get the password, we took

Re: Perl/DBI newbie: password storage / security question

2003-09-14 Thread zedgar
R. Joseph Newton wrote: [EMAIL PROTECTED] wrote: I'm basically concerned about the security of writing a simple web frontend to SQL database, the most important question being: how should I store the database password? [...] There are tens of websites on the server and every database access

Re: Perl/DBI newbie: password storage / security question

2003-09-14 Thread essential quint
food for thought... etc... Good luck! quint From: [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Perl/DBI newbie: password storage / security question Date: Sat, 13 Sep 2003 21:25:55 -0500 (EST) R. Joseph Newton wrote: [EMAIL PROTECTED] wrote: I'm

Re: Perl/DBI newbie: password storage / security question

2003-09-14 Thread R. Joseph Newton
[EMAIL PROTECTED] wrote: Thank you Joseph and Motherofperls for your tips, however I need something more than security through obscurity, as this database is going to store our customers personal information (real name and contact information) which is absolutely unacceptable to be stored

Re: perl DBI

2003-03-25 Thread Brett W. McCoy
On 26 Mar 2003, mark sony wrote: What are the good online sites which will give details about perl DBI, about using perl interacting with databases,right from basic to advanced stage? Start with http://dbi.perl.org/ -- Brett

Re: perl/DBI error

2002-11-10 Thread Ovid
--- Murli [EMAIL PROTECTED] wrote: Hi !! Has any one encountered the following error ? Thanks and advance!! Cheers always!! Murli [Sun Nov 10 11:34:38 2002] icpMeanSD.pl: DBD::mysql::db do failed: MySQL server has gone away at icpWtMeanSD.pm line 152. The most likely issue here is