Robert Hicks wrote:
I have a large array of numbers that I need to use in an update SQL
statement using a "like" clause.
my @nums = ( 123 456 789 );
foreach my $num (@nums) {
$dbh->do(q{update table_name set item_desc1 = item_desc2 where equip
like # I draw a blank here
}
I am not sure
I have a large array of numbers that I need to use in an update SQL
statement using a "like" clause.
my @nums = ( 123 456 789 );
foreach my $num (@nums) {
$dbh->do(q{update table_name set item_desc1 = item_desc2 where
equip like # I draw a blank here
}
I am not sure how to use the $num i
GODIVA/CSC
PM Subject: RE: SQ
on Tue, 20 Aug 2002 19:16:16 GMT, Learn Perl wrote:
> Yes I want to have the columns come out in a sorted order without
> specifying them like "select col1, col2, col3 from database" because
> I have too many columns (close to 80). Is there ways to select a
> table w/o specifically telling the S
ue, 20 Aug 2002, Bob Showalter wrote:
> > -Original Message-
> > From: Bob Showalter [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, August 20, 2002 2:24 PM
> > To: 'learn perl'; [EMAIL PROTECTED]
> > Subject: RE: SQL question
> >
> >
&
> -Original Message-
> From: learn perl [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 20, 2002 3:16 PM
> To: Bob Showalter
> Cc: [EMAIL PROTECTED]
> Subject: RE: SQL question
>
>
> Yes I want to have the columns come out in a sorted order without
> spe
> -Original Message-
> From: learn perl [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 20, 2002 3:51 PM
> To: Bob Showalter
> Cc: [EMAIL PROTECTED]
> Subject: RE: SQL question
>
>
> For example, my column names are [1], [3], [5], [2] in the
> table.
much!
Eric
On Tue, 20 Aug 2002, Bob Showalter wrote:
> > -Original Message-
> > From: learn perl [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, August 20, 2002 3:16 PM
> > To: Bob Showalter
> > Cc: [EMAIL PROTECTED]
> > Subject: RE: SQL question
> >
&
Hi guys,
just wondering how to sort the columns in order using SQL. Does anybody
have any clue? for instance, my column headings are [1] [3] [2] [4] [2],
is there a way to SELECT the table with the columns sorted in order?
thanks!
Eric
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addit
