Skip site navigation (1) Skip section navigation (2)

Re: Weird SQL Problem

From: Walter Kaan <wkaan(at)nswrdn(dot)com(dot)au>
To: operationsengineer1(at)yahoo(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Weird SQL Problem
Date: 2005-09-08 01:16:18
Message-ID: 1126142178.13589.3.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-novice
Maybe there are double quotes enclosing the aaaaaa string? This would
make them be interpreted as a column name.

WK

On Wed, 2005-09-07 at 16:48 -0700, operationsengineer1(at)yahoo(dot)com wrote:
> hi all,
> 
> i'm baffled by a sql issue.
> 
> i use adodb and the code is as follows (the sql should
> be pretty evident - even if you don't follow adodb).
> 
> $result_update = $db->Execute('UPDATE t_defect SET
> reworker_id = ' . $reworker_id . ', rework_completed =
> \'t\', rework_notes = ' . $rework_notes . ',
> rework_date = '. $db->DBDate(time()) . 'WHERE
> t_defect.defect_id = ' . $defect_id );
> 
> my problem is this...  the text input for
> $rework_notes kicks out a pgsql error as follows...
> 
> 'ERROR: column "aaaaaaaaaaaaaa" does not exist'
> 
> where "aaaaaaaaaaaaaa" is what i entered in the
> $rework _notes text area.
> 
> what am i missing here?  why is pgsql trying to find
> the column? rework_notes is varchar and i've done
> inserts for similarnote setups right and left with no
> problem.
> 
> tia...
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org


In response to

pgsql-novice by date

Next:From: DavidDate: 2005-09-08 02:01:19
Subject: Re: Weird SQL Problem
Previous:From: Michael GlaesemannDate: 2005-09-08 01:13:34
Subject: Re: Weird SQL Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group