|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Sybperl
Date: Apr 8 2000 2:04PM
AGaneshalingam@globewireless.com writes:
> Hello to all,
> I'm having problem trying to insert data into table. Every time I tried to
> run my script I get the following error:
> Server Message: (In srv_cb) Message Number: 249, Serverity 16, State 1, Line
> 1 Server 'HQ_MSGSRV' Message String: Syntax error during implicit conversion
> of VARCHAR value '$plan' to a SMALLDATETIME field.
> Following is my sybperl code:
> my $sql = q!insert into pco..pco ( purpose, description, risk,
> location_soft, name_soft, implement_by, princ_dev, plan_date)
> values( "$purpose", "$des", "$risk", "$loc", "$name", "$imp", "$princ",
> "$plan")!;
You're using the q() quote operator, which is the same as using '', so
no variable interpolation is happening. You need to use the qq()
operator.
Michael
--
Michael Peppler -||- Data Migrations Inc.
mpeppler@peppler.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com
|
