Thanks, that works (I'll have to read a bit to learn why)
except for one thing I didn't mention. (Everybody Lies :)
How ugly is this?
$sql = "INSERT into $table2"; # dynamic name with $user_id as root
$sql .= sprintf <<'EOF', join(',', @array);
I see.
I suppose this produced quite a few grins.
Ha
In article <[EMAIL PROTECTED]>,
"Eamon Daly" <[EMAIL PROTECTED]> writes:
> my $sql = sprintf <<'EOF', join(',', @array);
> SELECT col2, col3, col4
> FROM table1
> WHERE col1 IN (%s)
> EOF
> my $sth = $dbh->prepare($sql);
> $sth->execute() or die $sth->errstr();
This code is susceptible for an SQ
- Original Message -
From: "Eamon Daly" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, May 19, 2005 1:17 PM
Subject: Re: Efficient select/insert
my $sql = sprintf <<'EOF', join(',', @array);
inal Message -
From: "Jonathan Mangin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, May 19, 2005 11:52 AM
Subject: Re: Efficient select/insert
> This would be even faster if you could concatenate all of the elements
of
> @array into a single list
> This would be even faster if you could concatenate all of the elements
of
> @array into a single list then you could say:
>
> #My PERL skills are non existent so you need to write this part.
> #I am assuming that @array is holding a list of string values.
>
> foreach my $element (@array) {
> @ar
On 4/26/05, Jonathan Mangin <[EMAIL PROTECTED]> wrote:
> I would like to select several rows from one table
> and insert them into another nearly identical table
> using Perl/DBI:
>
> my @array = $q->param(); # HTML checkboxes
>
> foreach my $element (@array) {
>my $sql = "select col2, col3,
"Jonathan Mangin" <[EMAIL PROTECTED]> wrote on 04/26/2005 05:09:23
PM:
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Jonathan Mangin" <[EMAIL PROTECTED]>
> Cc:
> Sent: Tuesday, April 26, 2005 3:20 PM
> Subj
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, April 26, 2005 3:20 PM
Subject: Re: Efficient select/insert
"Jonathan Mangin" <[EMAIL PROTECTED]> wrote on 04/26/2005 12:26:20
PM:
I woul
"Jonathan Mangin" <[EMAIL PROTECTED]> wrote on 04/26/2005 12:26:20
PM:
> I would like to select several rows from one table
> and insert them into another nearly identical table
> using Perl/DBI:
>
> my @array = $q->param(); # HTML checkboxes
>
> foreach my $element (@array) {
>my $sql = "
- Original Message -
From: "Jonathan Mangin" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 26, 2005 11:26 AM
Subject: Efficient select/insert
I would like to select several rows from one table
and insert them into another nearly identical table
using Perl/DBI:
my @array = $q->param(); #
Give this a try. I used table aliases out of habit.
SELECT table1.id FROM table1 A
LEFT JOIN table2 B ON A.UserName = B.username
AND B.Group != 'Dedicated'
WHERE B.username IS NULL
AND A.StopTime = 0;
- Scott
> Hi I was wondering if anyone could help m
SELECT
t1.id
FROM
table1 t1,
table2 t2a,
table2 t2b
WHERE
t1.StopTime = 0 AND
(t2a.Group != 'Dedicated' AND t2a.UserName != t2b.Username) AND
t2a.UserName = t1.UserName
Not sure if you need those () though.
On 2 Feb 2001, Drew Wilder-Goodw
So that looks like it does a select for all in table2 who DO have
dedicated and just excludes those matches... thats an interesting way of
doing it.. but that would still return a row for the other groups that
the username belongs to in table2 right? so for instance if there is 2
entries in table
SELECT t1.id FROM table 1 t1
LEFT JOIN table2 t2 ON t1.UserName = t2.UserName
AND t2.Group = 'Dedicated'
AND t1.StopTime = 0
WHERE t2.id IS NULL;
--Greg Johnson
-Original Message-
From: Drew [mailto:[EMAIL PROTECTED]
14 matches
Mail list logo
