: [EMAIL PROTECTED]
X-OriginalArrivalTime: 28 Aug 2003 15:05:52.0600 (UTC)
FILETIME=[DF921580:01C36D75]
On Wed, 27 Aug 2003 14:45:00 -0700, Zachary Buckholz wrote:
But since my perl code runs from the crontab sometimes jobs overlap and
I
might be popping mail for more then one site's feedback
I have a small perl script using DBI and DBD::Sybase as well as DBD::MySQL
It pops mail for a feedback system, after parsing the message to see if it's
good or bad it then inserts good messages (customer feedback) into a
Microsoft SQL 2000 database or if bad inserts them into a MySQL database.
I want to run a single query to generate a daily average response time in
seconds for a seven day period and have it return an array of 7 values (one
for each day of the week). Currently I have to run 7 queries and change the
between date values. Is it possible to do it in one query?
This query
I have a program which submits websites to search engines etc. It currently
submits to just under 10,000 and updates a text file as it runs. When it's
done it imports the data from the text file into a Microsoft SQL database
that I connect to using FreeTDS and the DBD::Sybase.
What I noticed is
Ok I was able to get it, perldoc perlref showed me.
But this is very very SLOW.
Am I doing it in an inefficient way or is something out of place?
Thanks
zack
sub select_url() {
my $select_query = SELECT check.url_id AS url_id, check.url_timeout,
url.url_protocol, url.url, url.contact_ids,
DBI/DBD itself. It's mostly dependent on how tuned is your db, your db
data structures, etc...
Ilya
-Original Message-
From: Zachary Buckholz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 2:45 AM
To: [EMAIL PROTECTED]
Subject: Re: SELECT FOR UPDATE ok, but how to der
I have two subs in my program one, selects a list of urls to work on and
then the next sub updates the selected url's because I am running fork and
don't want another process to check out the same url's thus causing things
to go crazy.
But my problem is that while this was good intentioned, it's
Sorry, I am using MySQL.
It does support FOR UPDATE, but would that still return the array reference?
Thanks
zack
- Original Message -
From: Michael A Chase [EMAIL PROTECTED]
To: Zachary Buckholz [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 9:23 PM
Subject: Re: REQ
Ok, now that I have a basic understanding of the FOR UPDATE , the initial
selectall_arrayref is confusing me.
The while loop is getting each row , but it's returning a reference.
So when I try to dereference it I am still getting a memory address which
tells me I am not doing it properly.
What
Are you using that expensive always costly Solaris OS?
If so you will need to spend several hours installing third part GNU
software to have a semi-functional system. Visit www.gnu.org and start
installing if you can't locate gcc on your system
If not using Solaris then the simple answer is gcc
I am having a hard time with a logic problem related to scheduling an event
based on data stored in a MySQL table. Below is a sample data set.
The basic concept is a monitoring program that checks a website to see if
its up or down based on info stored in a table.
The way I am doing it requires
sub select_url($current_time) {
my $dbh = DBI-connect(DBI:mysql:database=saint;host=localhost,user,password,
{'RaiseError' = 1});
my $select_query = SELECT url_id, chk_freq, url_timeout, UNIX_TIMESTAMP(lc_epoch)
FROM monitor_check
WHERE
12 matches
Mail list logo