PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

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