my $get_case_text = $dbh->prepare("
> SELECT
> a.sr_num sr_num,
> a.sr_title sr_title,
> a.sr_stat_id sr_stst_id
> FROM
> s_srv_req
sr_stst_id
FROM
s_srv_req a
WHERE sr_num = ?");
$get_case_text->execute($sr_num) || $dbh->errstr;
($sr_num,$sr_title,$sr_stat_id) = $get_case_text->fetchrow_array();
$get_case_text->finish;
}
ETC..
On Thu, 2002-05-30 at 14:29, Lance Prais wrote:
> Janek,
> I tried that originally with the same results. I am perplexed to why this
> is happening, anyone have any ideas?
>
>
> Thanks
> Lance
>
Try this. I have no idea why it would work and the other wouldn't, but
it is worth a try.
reading a file and passing a variable
Lance Prais wrote at Thu, 30 May 2002 01:47:34 +0200:
Perhaps you missed to chomp th $ln.
So $ln = "1-294613112\n" what is perhaps not what you wanted.
> This is the most bizarre thing I have ever seen. I am using the following
code: There is
&g
Lance Prais wrote at Thu, 30 May 2002 01:47:34 +0200:
Perhaps you missed to chomp th $ln.
So $ln = "1-294613112\n" what is perhaps not what you wanted.
> This is the most bizarre thing I have ever seen. I am using the following code:
>There is
> absolutely no reason why this should not return
inish;
print "--> SR(bulk): $case->{sr_num}\n";
print "--> User Id(name): $case->{sr_title}\n";
$line++;
}
close(BULK);
$dbh->disconnect;
-Original Message-
From: Chas Owens [mailto:[EMAIL PROTECTED]]
Sent: We
t; Thanks
> Lance
>
> -Original Message-
> From: Chas Owens [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 29, 2002 4:11 PM
> To: Lance Prais
> Cc: Perl
> Subject: RE: Problem reading a file and passing a variable
>
> On Wed, 2002-05-29 at 17:05, Lance Pra
Wednesday, May 29, 2002 4:11 PM
To: Lance Prais
Cc: Perl
Subject: RE: Problem reading a file and passing a variable
On Wed, 2002-05-29 at 17:05, Lance Prais wrote:
> [Chas],
> Thank you, you made me realize the value of indention like never before.
> In the past I used the "=?&quo
On Wed, 2002-05-29 at 17:05, Lance Prais wrote:
> [Chas],
> Thank you, you made me realize the value of indention like never before.
> In the past I used the "=?" to return results form the query but in this
> case when I used in and run this script it does not error out but instead
> the query
On Wed, 2002-05-29 at 16:13, Lance Prais wrote:
> I am m using the following code to read from a .txt file. I am running into
> a problem that I am not sure why it is happening.
> The problem is when I run this script the SQL is not reading the variable.
> I am testing to make sure the .txt file
on Wed, 29 May 2002 20:13:13 GMT, Lance Prais wrote:
There is no need to post your message three times in less than 10 minutes.
> while( my $ln = )
> {
> chomp($ln);
> #use the items of the
> my $get_case_text = $dbh->prepare("SELECT a.sr_num ,b.name ,b.loc
> ,a.sr_title,f.mid_name ,
I am m using the following code to read from a .txt file. I am running into
a problem that I am not sure why it is happening.
The problem is when I run this script the SQL is not reading the variable.
I am testing to make sure the .txt file contains data and it does.
I get the following error:
D
I am m using the following code to read from a .txt file. I am running into
a problem that I am not sure why it is happening.
The problem is when I run this script the SQL is not reading the variable.
I am testing to make sure the .txt file contains data and it does.
I get the following error:
D
I am m using the following code to read from a .txt file. I am running into
a problem that I am not sure why it is happening.
The problem is when I run this script the SQL is not reading the variable.
I am testing to make sure the .txt file contains data and it does.
I get the following error:
D
14 matches
Mail list logo
