$dbh->prepare() problem

------=_NextPart_000_0030_01C42792.80E905C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

$sth=3D$dbh->prepare("insert into ivr =
(drv_dlv_dt,drv_dlv_tm,drv_flag_cln,drv_flag_sti,drv_flag_at d,drv_id,drv_=
flag,ld_nbr,cal_nbr,cal_flg,channel,unq_id,caller_id,comment ,shpdt) =
values =
(\'$c_dlvdt\',\'$c_dlvtm\',\'$c_clean\',\'$c_sti\',\'$c_atte nded\',\'$c_d=
rvnbr\',\'$c_drv_flag\',\'$c_ldnbr\',\'$c_callnbr\',\'$c_cal _flag\',\'$c_=
channel\',\'$c_unq_id\',\'$c_cal_id\',\'$c_comment\',\'$full _shpdt\')");

this statement in my AGI is generating these errors/warnings=20
plz sort out

Use of uninitialized value in concatenation (.) or string at =
/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.
Use of uninitialized value in concatenation (.) or string at =
/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.
Use of uninitialized value in concatenation (.) or string at =
/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.
Use of uninitialized value in concatenation (.) or string at =
/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.
------=_NextPart_000_0030_01C42792.80E905C0--

Re: $dbh->prepare() problem

Hi Atif,

----- Original Message -----
=46rom: Atif Rasheed
Sent: 21.04.2004, 11:19 Uhr

>$sth=3D$dbh->prepare("insert into ivr=20
>(drv_dlv_dt,drv_dlv_tm,drv_flag_cln,drv_flag_sti,drv_flag_a td,drv_id,drv_f=
lag,
>ld_nbr,cal_nbr,cal_flg,channel,unq_id,caller_id,comment,shp dt) values =20
>(\'$c_dlvdt\',\'$c_dlvtm\',\'$c_clean\',\'$c_sti\',\'$c_att ended\',\'$c_dr=
vnbr\'
>,\'$c_drv_flag\',\'$c_ldnbr\',\'$c_callnbr\',\'$c_cal_flag\ ',\'$c_channel\=
',\'$
>c_unq_id\',\'$c_cal_id\',\'$c_comment\',\'$full_shpdt\')");
>
>this statement in my AGI is generating these errors/warnings=20
>plz sort out
>
>Use of uninitialized value in concatenation (.) or string at=20
>/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.
>Use of uninitialized value in concatenation (.) or string at=20
>/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.
>Use of uninitialized value in concatenation (.) or string at=20
>/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.
>Use of uninitialized value in concatenation (.) or string at=20
>/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.

Well, one or more of your vars did not get assigned anything. But since you=
have several variables in your statement, it is hard to tell which one(s).

Did you try printing each of the variables on screen prior to the preparati=
on of your statement?

- Jan
--=20
How many Microsoft engineers does it take to screw in a lightbulb? None. Th=
ey just redefine "dark" as the new standard.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: $dbh->prepare() problem

Hi Atif,

----- Original Message -----
=46rom: Atif Rasheed
Sent: 21.04.2004, 11:19 Uhr

>$sth=3D$dbh->prepare("insert into ivr=20
>(drv_dlv_dt,drv_dlv_tm,drv_flag_cln,drv_flag_sti,drv_flag_a td,drv_id,drv_f=
lag,
>ld_nbr,cal_nbr,cal_flg,channel,unq_id,caller_id,comment,shp dt) values =20
>(\'$c_dlvdt\',\'$c_dlvtm\',\'$c_clean\',\'$c_sti\',\'$c_att ended\',\'$c_dr=
vnbr\'
>,\'$c_drv_flag\',\'$c_ldnbr\',\'$c_callnbr\',\'$c_cal_flag\ ',\'$c_channel\=
',\'$
>c_unq_id\',\'$c_cal_id\',\'$c_comment\',\'$full_shpdt\')");
>
>this statement in my AGI is generating these errors/warnings=20
>plz sort out
>
>Use of uninitialized value in concatenation (.) or string at=20
>/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.
>Use of uninitialized value in concatenation (.) or string at=20
>/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.
>Use of uninitialized value in concatenation (.) or string at=20
>/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.
>Use of uninitialized value in concatenation (.) or string at=20
>/var/lib/asterisk/agi-bin/acassens.agi line 503, line 14.

Well, one or more of your vars did not get assigned anything. But since you=
have several variables in your statement, it is hard to tell which one(s).

Did you try printing each of the variables on screen prior to the preparati=
on of your statement?

- Jan
--=20
How many Microsoft engineers does it take to screw in a lightbulb? None. Th=
ey just redefine "dark" as the new standard.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org