well, not exactly. this is what the script would do in the first place. for each record there is one insert-statement.
if he's taking the trouble of making it a prepared statement, he might as well insert multiple rows at a time.
personally, i would first try the LOAD DATA INFILE approach.
i...
To start off, i didn't take a look at your script...these are just mysql-hints.
First, start a transaction and lock the table in question in exclusive mode.
SET auto_commit = 'off';
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
START TRANSACTION;
LOCK TABLE `myTable` WRITE;
-- or LOCK TABLE...
in case it has to be perl und you don't mind using wget, you could also do
my $content = `wget -O - 'http://dynamicdns-park-your-domain.com/update?host=yadda&domain=example.com&password=123456abcdef'`;
not tested, but you get the idea. good luck :-)
does it really have to be perl doing this?
maybe it would be simpler to just use wget. i'd be surprised if it wasn't installed.
since cron is taking care of this, i figure you don't have much need for the actual content returned from calling the url.
i'd just have cron execute:
wget -O -...
maybe you want something the likes of
#!/usr/bin/perl
my @field = ("H S", "A B", "B A");
my %map = ('S' => 'Sam', 'B' => 'Bernhard');
foreach my $i (0..2) {
foreach my $key (keys %map) {
if ($field[$i] =~ /$key$/) {
print $map{$key},"\n";
}
}
}
prints
Sam
Bernhard
i'm not sure about this...but shouldn't any acpi-compliant bios provide some interface for these kinds of things? in that case it should work on your new PCs. maybe checkout some acpi-stuff, if there is any on cpan.
cheers
michael
seems sensible :) the goal for my suggestion was primarily to circumvent the timeout of the script. (btw, how does the server kill the script? maybe installing some signal handlers will do the trick *g*). if you pass all <input type=file> values at once and the perl script takes care of...
i think the problem with the "system" function is that -- to my knowledge -- it is a blocking one. meaning: the system call will return only after the command invoked by it has terminated. i don't know, but i would expect, that the script invoking the "system" function would still be killed...
i working quite a lot with something similar. unfortunately we're using php insted of perl, but in this case it doesn't really matter either way. of course, cpan definately is the first place to check out. i don't know if theres something useful on cpan, but we do it like this.
1) read and...
Hi,
can anyone tell me how to create a Toplevel (MainWindow->new) that is maximized? I'm using Linux, so the $mw->state('zoomed'); thingie does not work :(
thanks,
michael
i asked myself a very simple question while reading this...i propably already had the idea, but since it's not mentioned anywhere:
do you have access to log files? if it's a permission problem, shouldnt there be something in there somewhere?
cheers,
michael
hi, i'm only looking at your pattern...try
if ($con =~ /^skins\/([0-9a-fA-F]{32})\/) {
notice the following:
- in your code the regex operator was =!, it actually is =~. the negation is !~
- the m introducing the pattern slipped into the pattern itself. in your case, it's unnecessary anyway...
aloha,
maybe i'm totally wrong, but i think that's quite impossible. sprintf is usually used to output something to a scalar. a scalar containing a string is totally independent of fonts etc.
for details on sprintf and printf, see the perlfunc manpage (run "perldoc perlfunc"). maybe curses are...
i think flow control insturctions like next and last apply to the innermost loop. so just make "last" the next command after you deleted the line. but somehow this seems pretty obvious, i don't know if i got your post right.
greetings,
michael
Hi, i once had a similar problem. maybe this will help:
http://www.tek-tips.com/viewthread.cfm?qid=1420124&page=1
Another option could be to fork the system calls. i think you could also jerry-rig a workaround by appending "&" to the command, which starts a new process and returns control...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.