Chris W wrote:
I have inherited a site written in perl. Recently an intermittent
problem has come up and when users log into the site, they end up seeing
other users data. I personally can not reproduce the problem but it has
happened enough that I am sure it is more than just a fluke. Does
an
Chris W wrote:
I have inherited a site written in perl. Recently an intermittent
problem has come up and when users log into the site, they end up seeing
other users data. I personally can not reproduce the problem but it has
happened enough that I am sure it is more than just a fluke. Does
an
On Jan 22, 2008 11:11 PM, Chris W <[EMAIL PROTECTED]> wrote:
> I have inherited a site written in perl. Recently an intermittent
> problem has come up and when users log into the site, they end up seeing
> other users data. I personally can not reproduce the problem but it has
> happened enough
I have inherited a site written in perl. Recently an intermittent
problem has come up and when users log into the site, they end up seeing
other users data. I personally can not reproduce the problem but it has
happened enough that I am sure it is more than just a fluke. Does
anyone know of
I have inherited a site written in perl. Recently an intermittent
problem has come up and when users log into the site, they end up seeing
other users data. I personally can not reproduce the problem but it has
happened enough that I am sure it is more than just a fluke. Does
anyone know of any
Aaron Reist wrote:
How I get off this mailing list?
I tried the link at the bottom of the message, (many times) but it
doesnt seem to work.
http://learn.perl.org/faq/beginners-cgi.html#1.2%20%20how%20do%20i%20unsubscribe
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-
params into mysql table>
> Shad Keene wrote:> > Sean,> > > > Thanks...I got it to work. It turned out
that I didn't have default> > values for the other columns so it wouldn't enter
one column into the> > database w/o default values for the others.
> From: /Sean Davis <[EMAIL PROTECTED]>/
> To: /Shad Keene <[EMAIL PROTECTED]>/
> Subject: /Re: pushing web form params into mysql table/
> Date: /Tue, 26 Jun 2007 21:06:47 -0400/
> >Shad Keene wrote:
> >>
> >>Sean,
>
t; 1KDownload
One more quick question...does it matter if I have the "names" from
the form (i.e. group title of synregime for values of ET, AT, RI, FLT,
CUT) or do I just input the values and mysql puts them in the right
group according to the value name. That could be where I'm going
wrong. Thanks!!
Shad
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
[EMAIL PROTECTED] wrote:
> On Jun 25, 3:19 pm, [EMAIL PROTECTED] (Ricky Zhou) wrote:
>> Greg Jetter wrote:
>>> my $query = "insert into tablename
>>> (atablenaem1,atablename2,atablename3)VALUES($SubjPerform,$somthing2,
>>> $somthing3);
>>> # insert stuff in the db
>>> $dbh->do($query) or die "$DB
On Jun 25, 3:19 pm, [EMAIL PROTECTED] (Ricky Zhou) wrote:
> Greg Jetter wrote:
> > my $query = "insert into tablename
> > (atablenaem1,atablename2,atablename3)VALUES($SubjPerform,$somthing2,
> > $somthing3);
>
> > # insert stuff in the db
>
> > $dbh->do($query) or die "$DBI::errstr";
>
> To preve
Greg Jetter wrote:
> my $query = "insert into tablename
> (atablenaem1,atablename2,atablename3)VALUES($SubjPerform,$somthing2,
> $somthing3);
>
>
> # insert stuff in the db
>
> $dbh->do($query) or die "$DBI::errstr";
To prevent SQL injection, etc. It's strongly recommended that you use
place
On Sunday June 24 2007 6:39 pm, [EMAIL PROTECTED] wrote:
> This is rather long, but I just posted my old perl script, mysql
> table, and my new html form of which I'm trying to pass the values
> into the mysql table. I'm digging into mysql now as I was previously
> using
This is rather long, but I just posted my old perl script, mysql
table, and my new html form of which I'm trying to pass the values
into the mysql table. I'm digging into mysql now as I was previously
using a program to pass form values to a .csv spreadsheet, but it was
suggested that u
On 4/10/06, Sara <[EMAIL PROTECTED]> wrote:
> I have been stuck here, SOS call:
>
> Using CGI.pm, I have the script calling certain categories from mySQL table.
>
> my $cat = $q->param('cat');
> my $dbh -> prepare ("SELECT * FROM main WHERE CAT=&#x
On Mon, 2006-04-10 at 10:02 +0500, Sara wrote:
> Calling the categories starting with PHP and Perl didn't cause any issue, but
> when I called the Categories
> starting with C_and_C++, nothing was shown because CGI.pm was removing the
> characters ++.
> I replaced the
I have been stuck here, SOS call:
Using CGI.pm, I have the script calling certain categories from mySQL table.
my $cat = $q->param('cat');
my $dbh -> prepare ("SELECT * FROM main WHERE CAT='$cat'");
Sample Categories('CAT') are given belo
"Andrew Kennard" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi all
>
>
>my $Vals;
>for ( my $i=1;$i<=32;$i++ ) {
>$Vals.='?,';
>}
>chop $Vals;
Ugh.
$vals = join(', ', ('?') x 32 );
Ideally, you should have your data in an array, then:
my $sql = "IN
Thanks to you both for your replies
GenMainRecData did indeed contain a feature that produced this result !
Regards
Andrew
"Wiggins d'Anconia" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Bob Showalter wrote:
>> Andrew Kennard wrote:
>>
>
> [snip]
>
>>
>> No, you shouldn't
Bob Showalter wrote:
> Andrew Kennard wrote:
>
[snip]
>
> No, you shouldn't have to do that. Your first approach is correct, so we
> need to find out what's going wrong there...
>
Can you show us GenMainRecData? Are you sure it isn't the culprit here,
possibly it is already doing data mungin
Andrew Kennard wrote:
> Hi all
>
> Done lots of googling but this simple thing still has me stumped
>
> The perl code to insert stuff into an mysql table is this
>
> my $Vals;
> for ( my $i=1;$i<=32;$i++ ) {
> $Vals.='?,';
> }
Hmm,
Hi all
Done lots of googling but this simple thing still has me stumped
The perl code to insert stuff into an mysql table is this
my $Vals;
for ( my $i=1;$i<=32;$i++ ) {
$Vals.='?,';
}
chop $Vals;
my @TheRecord=&GenMainRecData();
my $sth = $dbh
Hi all
Done lots of googling but this simple thing still has me stumped
The perl code to insert stuff into an mysql table is this
my $Vals;
for ( my $i=1;$i<=32;$i++ ) {
$Vals.='?,';
}
chop $Vals;
my @TheRecord=&GenMainRecData();
my $sth = $dbh
I'm using the vec feature to create a bit vector and I want to write it to a
mysql database. When this did not work using a string field, I tried tiny
blob. It is writing some bits. When I get results back, they are not what I
started with.
Here is my code. Can someone tell me what I am
But you did not post the correction/solution=)
sorry about that. The resolution was to re-read the section of the
cgi::session documentation which talks about the data table.
"Session data is stored in the form of hash table, in key value pairs"
I thought that the first argument to the p
On Thu, 11 Nov 2004 13:09:58 -0600, Harley Davidson
<[EMAIL PROTECTED]> wrote:
> problem solved. reading the module docs like a technical manual instead of
> a comic strip seemed to help;)
But you did not post the correction/solution=)
So, others may be doomed to repeat...
--
WC -Sx- Jon
problem solved. reading the module docs like a technical manual instead of
a comic strip seemed to help;)
_
Dont just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
--
To
Hello,
I have to send this from my hotmail account, I apologize in advance if it's
completely unreadable;)
I am using CGI::Session, storing the session data in mysql. I am able to
store the appropriate values into the id and a_session columns. However, I
am also trying to store store
On Fri, 3 Sep 2004, Octavian Rasnita wrote:
This might be helpful for more users, because a system admin can
create automaticly a special dir where the users can put their config
files, and "insert" that file in httpd.conf.
After that, every user can create its own config file, with any
variabl
IL PROTECTED]>; "michael watson (IAH-C)"
<[EMAIL PROTECTED]>
Sent: Friday, September 03, 2004 3:56 PM
Subject: Re: CGI scripts, security and MySQL
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
On Fri, 3 Sep 2004, Octavian Rasnita wrote:
No, the environment variables are set a single time at the start (or
restart) of the web server.
Ok, that's what I thought.
So in what way does this help manage a pool of several users?
This seems to be a solution in search of some other problem...
--
Ch
- Original Message -
From: "Chris Devers" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "michael watson (IAH-C)"
<[EMAIL PROTECTED]>
Sent: Friday, September 03, 2004 3:31 PM
Subject: Re: CGI script
On Fri, 3 Sep 2004, Octavian Rasnita wrote:
You can put something like this, in httpd.conf file:
include ...path_to_file
And make the directory where sits that file readable only by the root user.
Then, in that file, put something like:
SetEnv usr user_name
SetEnv pass parolissima
Those 2 environme
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 03, 2004 3:08 PM
Subject: Re: CGI scripts, security and MySQL
> On Fri, 3 Sep 2004, michael watson (IAH-C) wrote:
>
> > I need to make this secure such that only users I want can use the
> > s
database, and then log-out
at the end.
What is the best way to do this? I've thought about creating a MySQL
user/password for each person who needs to enter data, but I don't
want them to have to enter their username and password on every form.
I guess what I need is some sort of pers
Hi
I need to know what is the accepted way of handling the following. I
have a MySQL database, and a host of CGI scripts which present forms to
the users as web pages, they fill them in and then the data is written
to the database. I need to make this secure such that only users I want
can use
Wondering whether MySQL or Postgres is faster (or better) via CGI
(which is the topic of this list) is sort of like wondering whether a
JAPH which has less characters is in fact faster that longer equivalent
code - all without looking at maintenance, ease of use, and
understandability. I know
satellite link on a ship this past week, and right now
I'm using a 10 cents per minute cellphone modem. When I get back to a
free link, I'll post more.
But in short, MySQL was great when it was the only game in town.
But PostgreSQL has leapfrogged MySQL now in every area including
features,
>>>>> "Bill" == Bill Jones <[EMAIL PROTECTED]> writes:
Bill> Even Blackboard, a major CMS / distance learning software developer,
Bill> abandoned MySQL in favor of baby Oracle.
Bill> ("Baby" Oracle is no better than PostgresSQL IMO. Plus Postg
s list not the beginners-cgi, see:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=3FD34DFD.7080207%40danconia.org
> But in short, MySQL was great when it was the only game in town.
> But PostgreSQL has leapfrogged MySQL now in every area including
> features, perform
Greetings =)
--- "Randal L. Schwartz" <[EMAIL PROTECTED]> wrote:
> The only reason to use MySQL these days is ignorance or legacy.
>
Even Blackboard, a major CMS / distance learning software developer,
abandoned MySQL in favor of baby Oracle.
("Baby" Oracle i
Does this mean that PostgreSQL is faster than MySQL?
In most simple web applications I could work even with text files databases,
so MySQL is very enough.
But if PostgreSQL is faster, the situation changes...
Teddy
- Original Message -
From: "Randal L. Schwartz" <[EMAIL P
on a ship this past week, and right now
I'm using a 10 cents per minute cellphone modem. When I get back to a
free link, I'll post more.
But in short, MySQL was great when it was the only game in town.
But PostgreSQL has leapfrogged MySQL now in every area including
features, performance,
> >>By the way... it's consensus amongst experts that MySQL has hit
> >>nearly end-of-life. If you're starting a new project, use PostgreSQL
> >>instead. A real Database... not a database wannabe.
> >>The only reason to use MySQL these days is ignora
Paul Archer wrote:
Yesterday, Randal L. Schwartz wrote:
By the way... it's consensus amongst experts that MySQL has hit
nearly end-of-life. If you're starting a new project, use PostgreSQL
instead. A real Database... not a database wannabe.
The only reason to use MySQL these days is
artz wrote:
By the way... it's consensus amongst experts that MySQL has hit
nearly end-of-life. If you're starting a new project, use PostgreSQL
instead. A real Database... not a database wannabe.
The only reason to use MySQL these days is ignorance or legacy.
I've done a quick se
Yesterday, Randal L. Schwartz wrote:
> By the way... it's consensus amongst experts that MySQL has hit
> nearly end-of-life. If you're starting a new project, use PostgreSQL
> instead. A real Database... not a database wannabe.
>
> The only reason to use MySQL these da
Randal L. Schwartz wrote:
"Remko" == Remko Lodder <[EMAIL PROTECTED]> writes:
Remko> I have the book "MySQL and Perl" from Paul Dubois,
By the way... it's consensus amongst experts that MySQL has hit
nearly end-of-life. If you're starting a
From: "Randal L. Schwartz" <[EMAIL PROTECTED]>
> Please, never ever post the URL to your website. "Blind leading
> Blind" comes to mind.
>
> --
> Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
Well... talking about that saying, I am blind and I have tought other bl
>>>>> "Remko" == Remko Lodder <[EMAIL PROTECTED]> writes:
Remko> I have the book "MySQL and Perl" from Paul Dubois,
By the way... it's consensus amongst experts that MySQL has hit
nearly end-of-life. If you're starting a new project, use
> "Luinrandir" == Luinrandir Hernsen <[EMAIL PROTECTED]> writes:
Luinrandir> If you are new to perl.. avoid the O'Reilly books... there
Luinrandir> are, IMHO, written by PhD's for PhD's
This is clearly a minority opinion or a misstated fact. Thank
goodness. :)
I'm not a PhD, and I write for
I learned Perl by reading 'Learning Perl, 2nd ed.' and found it very easy to read - on
top of that 'CGI Programming with Perl' is also a good read.
I'd suggest you give O'Reilly a try - I don't buy any other publisher for my
Linux/Perl books.
John Halladay
Green Aspen, Inc.
Web Development - Serv
, 2004 8:32 AM
> To: [EMAIL PROTECTED]
> Subject: Re: CGI and mySQL book, any recommendation.
>
>
> >>>>> "Sara" == Sara <[EMAIL PROTECTED]> writes:
>
> Sara> Looking to buy a comprehsive book on CGI and SQL, any
> recommendations.
>
&
Hey Sara,
Sara wrote:
Looking to buy a comprehsive book on CGI and SQL, any recommendations.
I have the book "MySQL and Perl" from Paul Dubois,
For me that's an excellent book. Only i have the dutch
version so i cant give you the ISBN nr of it.
Hopethis helps
Thanks,
Sara.
YW
Real information to your answer..
I use these...
CGI Programming on the world wide web / O'Reilly
CGI by example / Niles & Dwight
CGI Programming / Hamilton
www.MySQL.com
If you are new to perl.. avoid the O'Reilly books... there are, IMHO,
written by PhD's for PhD's
the "Visual" books ," R
>>>>> "Sara" == Sara <[EMAIL PROTECTED]> writes:
Sara> Looking to buy a comprehsive book on CGI and SQL, any recommendations.
In the same section where they have books on "apples and oranges".
That is... CGI and SQL (SQL or MySQL? You said both) a
Looking to buy a comprehsive book on CGI and SQL, any recommendations.
Thanks,
Sara.
.
>
> <- dbd_st_execute 0 rows
> <- execute= '0E0' at db_load_1-2.pl line 128
> -> bind_param for DBD::mysql::st (DBI::st=HASH(0x8104f14)~0x8104e3c 1
> ''310-673-5515'')
> <- bind_param= 1 at db_load_1-2.pl line 122
>
erified that the data is correct in '$rh_row->{prop_str_addr}' and
that it is quoted but for some reason myql isn't recieving the data any help would be
appreciated.
<- dbd_st_execute 0 rows
<- execute= '0E0' at db_load_1-2.pl line 128
-> bind_param fo
nd undef to the
proper parameter. Is that what you're doing, or are you binding
something else, such as 0 or the empty string?
Have you tried turning on DBI's trace facility to see what's happening?
P.S., you don't need the semicolons at the ends of the query strings.
That
> If you want them set to NULL using DBI, you have to bind undef to the
> proper parameter. Is that what you're doing, or are you binding
> something else, such as 0 or the empty string?
>
No the initial values in the DB are set to null, with the exception of one field. I'm
trying to assign th
before I begin sorry for the cross post but i'm desperate
The routine in question is below. It's pretty straight forward its a series of loops
which basically matches the row then dumps data stored in hash ref into the DB. for
some reason the script runs with no errors (ran with strict) I can ve
I have a script which function is to parse through a comma seperated data
file, check if the entry is already existing, then if not enter the data
into a mysql table. However, it only seems to be finding a match on the
third time around. ie if 'john brown' is in the data file it
I finally got the database connected but it won't create the table for me.
Can we only create tables at the command line?
$sth = $dbh->prepare (CREATE TABLE test
(first_field CHAR(10),
second_field INT)) or print "Can't create table: " . DBI->errstr;
$sth -> execute($test) or print "Can'
Teresa Raymond wrote:
Hello,
I was wondering if anyone could help me solve this problem. The script
appears not to be connecting to the database. This script prints "Here
we go" but never prints "Database connected". I used the format that the
hosting company supplied.
"DBI:mysql:$database:loc
On Sat, 22 Nov 2003 10:14:38 -0500, Teresa Raymond wrote:
> This script
> prints "Here we go" but never prints "Database connected". I used the
> format that the hosting company supplied.
Teresa,
your script seems fine to me... but you might want to read the documentation
of the auto-f
Hello,
I was wondering if anyone could help me solve this problem. The script
appears not to be connecting to the database. This script prints "Here we
go" but never prints "Database connected". I used the format that the
hosting company supplied.
"DBI:mysql:$database:localhost","$username","$
If I store a dbh in a session as in, $session->param("DB",$dbh), what
happen when the session expire due to expire setting? Will the dbh still
be in memory or cleaned up?
-thanks
-
eMail solutions by
http://www.swanmail.com
--
To unsubscribe, e-mail: [E
Hello out there...
I wanted to thank everyone who has kindly offered their assistance
with my current project. Of course I have more questions,
But first I wanted to share how I solved my current issue.
It's displays a clever mySQL trick! -- see script below:
Dave Gilden
( kora mus
had to this?
# I haven't done DBI much though.
my $drh = DBI->install_driver( 'mysql' );
my $dbh = DBI->connect("DBI:mysql:$user_name:$sql_server",
$user_name, $user_password);
# Do not return this error message in production c
from Ft. Worth,
Dave
-script to delete records from mySQL database
#!/usr/bin/perl -w
# update_guestbook.cgi
use CGI qw/:standard/;
use CGI::Carp qw(fatalsToBrowser);
use DBI;
use strict;
my $user_name = "###";
my $user_password = "###";
my $sql_server = &q
t){
my $tmp = ($sort_direction) ? (shift @data_out) : (pop @data_out);
print $tmp;
}
# End Table Rows
print "\n";
print "\n", end_form, "\n" ,end_html;
print "\n";
exit;
##
# SUBS
##
my $path_to_cgi = "http://##
On Fri, 19 Sep 2003 09:51:20 -0500, David Gilden <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am taking over a site that was on a M$ server and redoing the Guest book and form
> pages
> in PERL. Question I have is the design of database.
>
> I hav
Hello,
I am taking over a site that was on a M$ server and redoing the Guest book and form
pages
in PERL. Question I have is the design of database.
I have the following fields: Name varchar(80)
Date date
email
I have a multi-table MySQL database that holds different pieces of
information that will all be displayed on a web page template. The general
principle is that non web people will be able to populate web pages through
an admin panel. The data in all of the MqSQL tables will be entered by the
Thanks for the detailed answer. I have dealt with JOIN clauses briefly in
the past, but not in this context. I will have to revisit on my own. As
far as grabbing the unique id, I am definitely going to use the DBI module
for contacting MySQL. When I am looking at your piece of code, I had a
Hughes, Andrew wrote:
I have a multi-table MySQL database that holds different pieces of
information that will all be displayed on a web page template. The general
principle is that non web people will be able to populate web pages through
an admin panel. The data in all of the MqSQL tables will
I want to create a very simple backend for a user. Basically a portion of a
page will be kept in a database. The user will navigate to a certain page
and then Perl will pull the data out of the db in a textfield. The users
changes it and hits submit and pop it goes back in.
The question is this. C
bh
my $dbh = DBI
->connect('DBI:mysql:database=dnazary_test:hostnamte=localhost',
'root', 'mysql');
open (IFH, $infile) or die ("Could not open input
file.");
foreach () {
# Strict on @fields
my @fields = split (/ /, $_);
#
y, June 10, 2003 9:44 AM
To: Nazary, David; [EMAIL PROTECTED]
Cc: Nazary, David
Subject: Re: Inserting data into MySql using perl script
On Monday June 9 2003 3:49 pm, Nazary, David wrote:
> Hi,
>
> I am unable to insert data into MySql with following script:
>
> #!/usr/bin/pe
On Monday June 9 2003 3:49 pm, Nazary, David wrote:
> Hi,
>
> I am unable to insert data into MySql with following script:
>
> #!/usr/bin/perl
> use DBI;
> use Mysql;
> $infile = "/cadfs8/sys/dnazary/mysql_test_data1";
> $dbh = DBI ->connect('DBI:
Hi Roberto,
I made your suggested changes and I got the same error mesage:
#!/usr/bin/perl
use DBI;
use Mysql;
$infile = "/cadfs8/sys/dnazary/mysql_test_data1";
$dbh = DBI ->connect('DBI:mysql:dnazary_test;host=localhost', 'root', 'mysql');
open (IFH,
Hi,
On Mon, Jun 09, 2003 at 04:49:41PM -0700, Nazary, David wrote:
>
> I am unable to insert data into MySql with following script:
>
> #!/usr/bin/perl
> use DBI;
> use Mysql;
Not needed, you may comment it out.
> $infile = "/cadfs8/sys/dnazary/mysql_test_data
Hi,
I am unable to insert data into MySql with following script:
#!/usr/bin/perl
use DBI;
use Mysql;
$infile = "/cadfs8/sys/dnazary/mysql_test_data1";
$dbh = DBI ->connect('DBI:mysql:dnazary_test:localhost', 'root', 'mysql');
open (IFH, $infile) or
If I have a table with date column formatted -00-00, and I want to force
a specified date into the column as opposed to just using "now", how would I
change the following? Sorry if this is a little off topic but I thought
someone here might know. Not a cross-post, I'm not even
On Sun, 23 Feb 2003 at 20:09, Ed Sickafus opined:
ES:Server: Linux (RedHat 7.2) Apache 1.3.x
ES:I'm trying to run an introductory exercise out of MySQL Cookbook by Paul
ES:DeBois
ES:Accessing MySQL from a PC via PuTTY to ISP's UNIX
ES:I can get to the mysql> prompt but no further.
Server: Linux (RedHat 7.2) Apache 1.3.x
I'm trying to run an introductory exercise out of MySQL Cookbook by Paul
DeBois
Accessing MySQL from a PC via PuTTY to ISP's UNIX
I can get to the mysql> prompt but no further.
Welcome to the MySQL monitor. Commands end with ; or \g.
Hi
Can anybody help me I have a problem installing DBD::Mysql on a windows XP
machine.
Running ppm install DBD::mysql returns the message "Read a PPD for
'DBD-mysql' but it is not intended for this build of Perl
(MSWin32-x86-multi-thread)
Thanks
Alex
--
To unsubscribe,
Thanks for pointing me to the right list, to be honest I didnt know
which one to post to,
And mysql_config is in this location,
/usr/local/mysql/bin/mysql_config
i.e mysql is in /usr/local/mysql/
is this the 'normal' location?
Wiggins D'Anconia wrote:
What does this have
What does this have to do with CGI?? [EMAIL PROTECTED] would be a
better list for this question.
However, do you have MySQL installed in an abnormal location, or where
is the 'mysql_config' executable on your system? If it is in a "normal"
location and you just installe
Hi, I am trying to install DBD::Mysql and I am getting error, I am new
to perl and modules, here is the screen print, I'll appreciate any help
please.
CPAN.pm: Going to build J/JW/JWIED/DBD-mysql-2.1024.tar.gz
Can't exec "mysql_config": No such file or directory at M
On Mon, 6 Jan 2003 at 20:44, Hughes, Andrew opined:
HA:That makes a lot of sense. If I strip out the pipes, tabs, hard returns
HA:etc. going into the database table, do you think that I should be okay not
HA:using the module?
why waste your time?
the csv modules already on cpan do it all for yo
, Andrew
Cc: [EMAIL PROTECTED]
Sent: 1/6/2003 6:21 PM
Subject: RE: how to print mysql table to text file backup with perl
On Mon, 6 Jan 2003 at 15:11, Hughes, Andrew opined:
HA:my $filename = "out.txt";
HA:open(OUTFILE,">$filename");
HA: $stmt = qq { select * from 2002broc
On Mon, 6 Jan 2003 at 15:11, Hughes, Andrew opined:
HA:my $filename = "out.txt";
HA:open(OUTFILE,">$filename");
HA: $stmt = qq { select * from 2002brochurecontest };
HA: $sth = $dbh->prepare ($stmt);
HA: $sth->execute ();
HA: $count = 0;
HA: while (my $row = $sth->fetchrow_hashref())
HA:{
|$row->{purchase}\n";
}
$sth->finish();
close(OUTFILE);
Thanks,
Andrew
-Original Message-
From: LRMK [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 2:16 PM
To: Hughes, Andrew; [EMAIL PROTECTED]
Subject: Re: how to print mysql table to text file backup wi
TED]>
Sent: Tuesday, January 07, 2003 12:58 AM
Subject: how to print mysql table to text file backup with perl
> I have a mysql table with about 3000 rows of data on which that I need to
> perform a daily backup. Because I am on a shared hosting account I do not
> have administrative rights
I have a mysql table with about 3000 rows of data on which that I need to
perform a daily backup. Because I am on a shared hosting account I do not
have administrative rights to the database. To back it up currently I have
a script that prints each line of data to the browser delimited with
I agree with what John Herbold already posted but would add:
This probably has more to do with your hardware up to a point. Running
mysql on a 486 is going to obviously not be as efficient as running it
on a dual sun box, etc.
In a previous position we ran 50 or so databased sites that ranged
are looking for a transaction system with row level locks ect that
one would use for a larger and more complex system, lets say for online
purchases etc you might want to check into the version of MySQL that they
charge a little for. But my understanding is that would be for major
systems. I would
Sorry, another out of topic.
Is it safe to use mySQL in cgi? I meant, if my update.pl perl cgi will do this :
connect to mysql database
insert into table values (values from FORM)
... other tasks ...
close
What happen if there are, let say 100 people accessing that perl cgi? I meant
1 - 100 of 180 matches
Mail list logo
