Received: from wallace.ece.rice.edu (root@wallace.ece.rice.edu
 [128.42.12.154])
	by hub.org (8.9.3/8.9.3) with ESMTP id NAA75303
	for <pgsql-interfaces@hub.org>; Thu, 17 Jun 1999 13:56:33 -0400 (EDT)
	(envelope-from reedstrm@wallace.ece.rice.edu)
Received: by wallace.ece.rice.edu via sendmail from stdin
	id <m10ugOn-000LHFC@wallace.ece.rice.edu> (Debian Smail3.2.0.101)
	for pgsql-interfaces@hub.org; Thu, 17 Jun 1999 12:56:25 -0500 (CDT)
Date: Thu, 17 Jun 1999 12:56:25 -0500
From: "Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>
To: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Dumb Perl-related question
Message-ID: <19990617125625.A15387@wallace.ece.rice.edu>
References: <199906171726.SAA17199@w3s.ie>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Mailer: Mutt 0.95.3i
In-Reply-To: <199906171726.SAA17199@w3s.ie>;
	from Brendan McKenna on Thu, Jun 17, 1999 at 06:33:03PM +0000

On Thu, Jun 17, 1999 at 06:33:03PM +0000, Brendan McKenna wrote:
> 
> 	What I'm doing looks like this:
> 
>    $query   = "select recipe_name, occasion, num_served, prep_time, " .
>               "freezable, instructions "                              .
>               "from recipe "                                          .
>               "where recipe_name = '$recipe';";

I'm no perl expert, but your problem sounds like the query is being
constructed without any quotes around the constant, so perl must be eat
them. Does this work?

               "where recipe_name = \'$recipe\';";

-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005