Thread: Strange Insert Problem

Strange Insert Problem

From

Lola Lee

Date:

09 January 2004, 09:26:57

I'm having a really strange insert problem, which I cannot figure out.

I have a table in my database, which I created using the following
query (I'm using Postgresql 7.4, if this helps):

CREATE TABLE yarncolor (
        yarn_color_id       SERIAL,
        yarn_id             int NULL,
        yarn_color_nm        varchar(35) NULL,
        yarn_color_num       varchar(10) NULL,
        yarn_color_desc      varchar(50) NULL,
        discontinued_flg     boolean NULL,
        yarn_color_lud       timestamp NULL,
        PRIMARY KEY (yarn_color_id),
        FOREIGN KEY (yarn_id)
                              REFERENCES yarn
);

Everytime I try to insert a record in this table via ColdFusion
generated page, I get this error message (I also get this in
phpPgMyAdmin):

SQL error:
ERROR:  column "anemone" does not exist


In statement:
INSERT INTO YarnColortwo (yarn_id, yarn_color_nm, yarn_color_num,
yarn_color_desc, yarn_color_lud) VALUES ( 15, Anemone, 616, whatever,
now() )

I'm at a loss as to why does Postgresql think there is a column named
"anemone".  Yes, I tried another string of character and get the same
message.  Anyone have an idea what may be going on?


--

Lola - mailto:lola@his.com
http://www.lolajl.net | Blog at http://www.lolajl.net/blog/
Check out this blog:  http://www.denbeste.nu
I'm in Bowie, MD, USA, halfway between DC and Annapolis.

Re: Strange Insert Problem

From

Bruno LEVEQUE

Date:

09 January 2004, 09:41:28

Hi,

First, in insert, every strings must be quoted. Your query becomes :

INSERT INTO YarnColortwo (yarn_id, yarn_color_nm, yarn_color_num,
yarn_color_desc, yarn_color_lud) VALUES ( 15, 'Anemone', 616,
'whatever', now() ).

Try this and report back.

Bruno



Lola Lee wrote:

> I'm having a really strange insert problem, which I cannot figure out.
>
> I have a table in my database, which I created using the following
> query (I'm using Postgresql 7.4, if this helps):
>
> CREATE TABLE yarncolor (
>        yarn_color_id       SERIAL,
>        yarn_id             int NULL,
>        yarn_color_nm        varchar(35) NULL,
>        yarn_color_num       varchar(10) NULL,
>        yarn_color_desc      varchar(50) NULL,
>        discontinued_flg     boolean NULL,
>        yarn_color_lud       timestamp NULL,
>        PRIMARY KEY (yarn_color_id),
>        FOREIGN KEY (yarn_id)
>                              REFERENCES yarn
> );
>
> Everytime I try to insert a record in this table via ColdFusion
> generated page, I get this error message (I also get this in
> phpPgMyAdmin):
>
> SQL error:
> ERROR:  column "anemone" does not exist
>
>
> In statement:
> INSERT INTO YarnColortwo (yarn_id, yarn_color_nm, yarn_color_num,
> yarn_color_desc, yarn_color_lud) VALUES ( 15, Anemone, 616, whatever,
> now() )
>
> I'm at a loss as to why does Postgresql think there is a column named
> "anemone".  Yes, I tried another string of character and get the same
> message.  Anyone have an idea what may be going on?
>
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque@net6d.com
http://www.net6d.com

Re: Strange Insert Problem

From

"John K. Herreshoff"

Date:

09 January 2004, 10:35:28

I'd hazard that you need ' around Anemone as in 'Anemone'.

HTH.

John.

On Friday 09 January 2004 05:25, Lola Lee wrote:
> I'm having a really strange insert problem, which I cannot figure out.
>
> I have a table in my database, which I created using the following
> query (I'm using Postgresql 7.4, if this helps):
>
> CREATE TABLE yarncolor (
>         yarn_color_id       SERIAL,
>         yarn_id             int NULL,
>         yarn_color_nm        varchar(35) NULL,
>         yarn_color_num       varchar(10) NULL,
>         yarn_color_desc      varchar(50) NULL,
>         discontinued_flg     boolean NULL,
>         yarn_color_lud       timestamp NULL,
>         PRIMARY KEY (yarn_color_id),
>         FOREIGN KEY (yarn_id)
>                               REFERENCES yarn
> );
>
> Everytime I try to insert a record in this table via ColdFusion
> generated page, I get this error message (I also get this in
> phpPgMyAdmin):
>
> SQL error:
> ERROR:  column "anemone" does not exist
>
>
> In statement:
> INSERT INTO YarnColortwo (yarn_id, yarn_color_nm, yarn_color_num,
> yarn_color_desc, yarn_color_lud) VALUES ( 15, Anemone, 616, whatever,
> now() )
>
> I'm at a loss as to why does Postgresql think there is a column named
> "anemone".  Yes, I tried another string of character and get the same
> message.  Anyone have an idea what may be going on?

Re: Strange Insert Problem

From

Lola Lee

Date:

09 January 2004, 10:46:00

At 11:38 AM +0100 1/9/04, Bruno LEVEQUE wrote:
>First, in insert, every strings must be quoted. Your query becomes :
>
>INSERT INTO YarnColortwo (yarn_id, yarn_color_nm, yarn_color_num,
>yarn_color_desc, yarn_color_lud) VALUES ( 15, 'Anemone', 616,
>'whatever', now() ).

Works now - thanks!

--

Lola - mailto:lola@his.com
http://www.lolajl.net | Blog at http://www.lolajl.net/blog/
Check out this blog:  http://www.denbeste.nu
I'm in Bowie, MD, USA, halfway between DC and Annapolis.

Re: Strange Insert Problem

From

Martin Atukunda

Date:

11 January 2004, 18:21:14

On Friday 09 January 2004 13:25, you wrote:
> I'm having a really strange insert problem, which I cannot figure out.
>
> I have a table in my database, which I created using the following
> query (I'm using Postgresql 7.4, if this helps):
>
> CREATE TABLE yarncolor (
>         yarn_color_id       SERIAL,
>         yarn_id             int NULL,
>         yarn_color_nm        varchar(35) NULL,
>         yarn_color_num       varchar(10) NULL,
>         yarn_color_desc      varchar(50) NULL,
>         discontinued_flg     boolean NULL,
>         yarn_color_lud       timestamp NULL,
>         PRIMARY KEY (yarn_color_id),
>         FOREIGN KEY (yarn_id)
>                               REFERENCES yarn
> );
>
> Everytime I try to insert a record in this table via ColdFusion
> generated page, I get this error message (I also get this in
> phpPgMyAdmin):
>
> SQL error:
> ERROR:  column "anemone" does not exist
>
>
> In statement:
> INSERT INTO YarnColortwo (yarn_id, yarn_color_nm, yarn_color_num,
> yarn_color_desc, yarn_color_lud) VALUES ( 15, Anemone, 616, whatever,
> now() )

I don't know how ColdFusion does it but, you should quote the strings that you
are inserting into the database i.e:

INSERT INTO YarnColortwo(
    yarn_id,
    yarn_color_nm,
    yarn_color_num,
    yarn_color_desc,
    yarn_color_lud)
VALUES ( 15,
    'Anemone',
    '616',
    'whatever',
    now()
    )

> I'm at a loss as to why does Postgresql think there is a column named
> "anemone".  Yes, I tried another string of character and get the same
> message.  Anyone have an idea what may be going on?

--
"If we don't succeed, we run the risk of failure."
--Bill Clinton, President