I think that was the second possibility I mentioned. If the inner query doesn't
find any rows, you want to do something else.
many thks. It works like I wished.
cheers.
Xaver
Quoting xaver biton <[EMAIL PROTECTED]>:
>> Perhaps if you list what you want to happen and what is happening in
>> more detail we can help.
One thing I forgot to mention before, I don't see any error checking. Do you
have $dbh->{RaiseError} set? If you don't, you need to check for errors at
ea
On Fri, Apr 08, 2005 at 01:01:02AM +0200, xaver biton wrote:
> >>while(my @row = $sql->fetchrow_array){
> >>$sql1->execute("$row[3]");
> >
> >What DBD module are you using?
> >If Oracle, are any of the fields CHAR?
>
> is MySql, the fields are char
Try writing the *smallest* script that demon
Hi Tim,
while(my @row = $sql->fetchrow_array){
$sql1->execute("$row[3]");
What DBD module are you using?
If Oracle, are any of the fields CHAR?
is MySql, the fields are char
Xaver
On Thu, Apr 07, 2005 at 01:05:49PM +0200, xaver biton wrote:
>
> while(my @row = $sql->fetchrow_array){
> $sql1->execute("$row[3]");
What DBD module are you using?
If Oracle, are any of the fields CHAR?
Tim.
Hi,
Perhaps if you list what you want to happen and what is happening in
more detail we can help.
Ok
my $sql = $dbh->prepare(q{select col1, col2, col3 from test});
the second:
my $sql1 = $dbh->prepare(q{select row1, row2, row3 from test1 where
test1.row = ?})
$sql->execute();
while(my @col = $s
On 04/07/2005 04:05 AM, xaver biton said:
i've 2 select query. the first one is like
my $sql = $dbh->prepare(q{select * from test});
If all you want is col4, it would be safer to use "SELECT col4...".
the second:
my $sql1 = $dbh->prepare(q{select * from test1 where test1.row = ?})
$sql->execute();
Hi,
i've 2 select query. the first one is like
my $sql = $dbh->prepare(q{select * from test});
the second:
my $sql1 = $dbh->prepare(q{select * from test1 where test1.row = ?})
$sql->execute();
while(my @row = $sql->fetchrow_array){
$sql1->execute("$row[3]");
while(m