Re: ADO, multiple statements and Perl

(any other comment or criticism on the code is warmly welcome)

I'll point out a SQL bug in your code:

    my $sql = << "__SQL__";

declare \@AZIONE    int;
set \@AZIONE = (SELECT id FROM desAz WHERE az LIKE 'XXXX%' );
select * from desCc where id = \@AZIONE;
    
__SQL__
[download]

It is possible that SELECT id FROM desAz WHERE az like '...' could return more than one row, @AZIONE will get set to the last value returned. That's one of the reasons why using a JOIN here would be a lot better.

Michael

Comment on Re: ADO, multiple statements and Perl Select or Download Code

Replies are listed 'Best First'.
Re: Re: ADO, multiple statements and Perl by l3nz (Friar) on Nov 24, 2003 at 16:09 UTC
Yes, I know; in fact the problem does not arise for the very data that area in the "original" query that I used when developing. In the case it should, it means that such data is corrupted and I want everything to abend and be notified when looking at the logs. Anyway thanks.	[reply]