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: cchrysos at ovid dot com
Subject: Re: help with inserting text
Date: Feb 18 1998 9:02PM


It looks like Philip forgot to surround the character strings with quotes.
I believe single quotes will work without confusing Perl.

My example:

$select = "insert into link_table values ('$link_title', '$id',
'$unique_id', '$link_url', '$link_description')"

Quoting isn't necessary for numeric datatypes like int, float, decimal, and
so on. So, in this example, if the column for $id is an int, it doesn't
need quotes.

-- Chris

<------------------------------------------------------------->
Chris Chrysostom                  "What do castrated men have
Ovid Technologies                       to do with this?"
Sybase Database Administrator     "Oh, UNIX is an operating
(801)281-3884 ext 2398                  system"