Disconnecting from a database may cause outstanding changes to be committed. This has nothing to do with DBI. It depends on the RDBMS. If you do not wish to commit the changes call $dbh->rollback() before calling $dbh->disconnect() .
Another advice is to use $dbh->do() for non-SELECT statements. It is simpler. :-)...
kershell
Last Activity: Apr 19 '07, 05:05 PM
Joined: Apr 4 '07
Location: Norfolk, UK
-
For EXISTS, PostgreSQL documentation clearly says that
So even the LIMIT 1 should not be required. If there is no ORDER BY clause in a query there is no reason for all rows to be accessed.
If i do this
I get
I interpret it as the limit on the subquery being applied before the main query executes. I could be wrong....Leave a comment:
-
Certainly. And go through the bioperl tutorial at http://www.bioperl.org/wiki/Bptutorial.pl...Leave a comment:
-
In this line:
my $fasta_file = $query->param('sequenc e');
$fasta_file contains the sequence(s) which have been submitted on you r webpage. $fasta_file is not the name of a file.
This bit of code
my $seq_in=Bio::Se qIO->new(
'-file' => '$fasta_file',
'-format' => 'fasta'
);
expects a filename, not the contents of a fasta file. You don't have...Leave a comment:
-
Have a look at the File::Find module. It is a part of Perl installation which means nothing needs to be installed....Leave a comment:
-
Presumably the scripts compiles and runs from the command line. Make sure of that. And, In this line
delete the space between html and \n\n....Leave a comment:
-
What I meant to ask was that did you compile the kernel yourself or installed a precompiled one? It is clear that you have a precompiled kernel from Mandriva. Parallel port support needs to be compiled in the kernel and I think Mandriva have not done so in the supplied kernel. You can find out by asking on a Mandriva specific forum or the Mandriva website.
To compile the kernel you will need to install the Kernel sources and then configure...Leave a comment:
-
Try adding 'LIMIT 1' at the end of the subquery.Leave a comment:
-
OK then. You need to give more information.
- What linux is it? Kernel version?
- Did you compile the kernel?
- what is the output of 'uname -a' ?...Leave a comment:
-
- su - # become root
cd /proc
find -iname '*par*'
For example, when I did this on my machine I got this
Code:./sys/dev/parport ./partitions
Leave a comment:
- su - # become root
No activity results to display
Leave a comment: