Обсуждение: Strange Insert Problem
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.
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
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?
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.
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