EMAIL PROTECTED]>
Cc: "Bodo Eing" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 11:55 AM
Subject: Re: (Fwd) "Can't call method execute" error "undefined value"
> I think the problem is that the connect method failed. Use the dou
Date sent: Mon, 5 Mar 2001 10:04:44 -0800 (PST)
From: Luis Colon <[EMAIL PROTECTED]>
Subject: Re: (Fwd) "Can't call method execute" error "undefined value"
To: Bodo Eing <[EMAIL PROTECTED]>, [
On Mon, Mar 05, 2001 at 10:04:44AM -0800, Luis Colon wrote:
> $dbh =
> DBI->connect("DBI:Oracle:host=$host;sid=$sid;port=1521",$user,
> $password) or die "Can't connect:$DBI::errstr\n";
>
> $deviationid = time();
> $statement = "INSERT INTO CGTI_AR VALUES
>
>($deviationid,$formdata{'Requestor_N
r_Email'},$formdata{'Requestor_Telephone'})";
>
> my $sth = $dbh->prepare($statement);
>
> $sth->execute;
> $sth->finish;
> $dbh->disconnect;
>
> }
>
>
> --- Bodo Eing <[EMAIL PROTECTED]> wrote:
> > Date sent:
On Mon, 5 Mar 2001, Luis Colon wrote:
> my $sth = $dbh->prepare($statement);
You need to make sure that this call is successful. I would also use
placeholders:
$statement = qq(INSERT INTO CGTI_AR VALUES(?,?,?,?));
my $sth = $dbh->prepare($statement) or die "error preparing statement
Date sent:Mon, 5 Mar 2001 16:30:56 +
> From: Tim Bunce <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Copies to:[EMAIL PROTECTED]
> Subject: (Fwd) "Can't call method execute"
> error "
Luis,
On Mon, Mar 05, 2001 at 04:30:56PM +, Tim Bunce wrote:
> - Forwarded message from Luis Colon <[EMAIL PROTECTED]> -
>
> Date: Mon, 5 Mar 2001 07:44:29 -0800 (PST)
> From: Luis Colon <[EMAIL PROTECTED]>
> Subject: "Can't call method execute" error "undefined value"
> To: [EMAIL P
Date sent: Mon, 5 Mar 2001 16:30:56 +
From: Tim Bunce <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Copies to: [EMAIL PROTECTED]
Subject: (Fwd) "Can't call method execute" error "und
- Forwarded message from Luis Colon <[EMAIL PROTECTED]> -
Date: Mon, 5 Mar 2001 07:44:29 -0800 (PST)
From: Luis Colon <[EMAIL PROTECTED]>
Subject: "Can't call method execute" error "undefined value"
To: [EMAIL PROTECTED]
Please assist:
I'm trying to create an interactive HTML that will
P