Re: Perl/DBI

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 columns

Re: Perl/DBI

> 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 b

Re: Perl/DBI

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

Re: Perl/DBI

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 searche

Re: Perl/DBI

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 quit

Re: Perl/DBI

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

Perl/DBI

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 columns from the search s

Re: Perl DBI / SQL Question

wer, but I am not sure what I have to do and the books I have here are either not answering the question, or I'm not finding the answer. 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. If all I need for th

Re: Perl DBI / SQL Question

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 ne

Re: Perl DBI / SQL Question

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

RE: Perl DBI / SQL Question

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 d

Re: Perl DBI / SQL Question

hat I have to do and the books I have here are either not answering the question, or I'm not finding the answer. 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. If all I need for this is some form of S

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

IL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[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: p

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

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 too

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

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 o

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

[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 stor

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

andpoint. Anyway, I'll leave go now... just thinking out loud... providing some 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

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

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 databa

Re: perl DBI

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

perl DBI

Hi all 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? mark ___ Odomos - the only mosquito protection outside 4 walls

Re: perl/DBI error

--- 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 h

perl/DBI error

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. Content-type: text/html Software error: DBD::mysql::db do failed: MySQL server

Re: Help: perl DBI

Hi Sarah, You probably should sign up for the dbi-users mailing list at . You can catch db errors using an eval statement. Search the DBI docs for eval and RaiseError for more info. HTH, William -- Lead Developer Knowmad Services Inc. || Internet Appli

Help: perl DBI

First of all, I am a complete beginner here. I've only learned about mysql within the last week and I've only been coding in perl for about a month. I only mention this because I still need explanations to be very simple. I have created a database for a very large file we have. I currently have