[SQL] how to store this record ?? pg_atoi
Hello there Using coldfusion 4.5.1 together with postgreSQL 7.0.3 I try to store a new record in my table. There is an inputfield type="text" with the value of 6. I get the following error when I try to add a new record to the database. How to change this ??? Thanks in advance ... jr 6 Error Occurred While Processing Request |--| | Error Diagnostic Information || | || | || | ODBC Error Code = S1000 (General error) || | || | || | Error while executing the query; ERROR: pg_atoi: error in "6.00": can't parse || | ".00" || | || | || | The error occurred while processing an element with a general identifier of |(CFINSERT), | | occupying document position (14:3) to (19:76). || | || | || | Date/Time: Tue Jan 9 10:36:28 2001 || | Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0) || | Remote Address: 172.16.30.7 || | HTTP Referer: http://mondadori.pup.ch/main.cfm || | Query String: actionstring=add || |--| PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315
Re: [SQL] how to store this record ?? pg_atoi
Could you post the SQL/CF code? What type of field is the field in the database? I've used Cold Fusion and PostgreSQL and it seems to work fine for me. Poul L. Christiansen [EMAIL PROTECTED] wrote: > Hello there > > Using coldfusion 4.5.1 together with postgreSQL 7.0.3 I try to store a new > record in my table. There is an inputfield type="text" with the value of 6. > I get the following error when I try to add a new record to the database. > > How to change this ??? > > Thanks in advance ... jr > > 6 > > Error Occurred While Processing Request > > >|--| > | Error Diagnostic Information > | > | > | > | > | > | ODBC Error Code = S1000 (General error) > | > | > | > | > | > | Error while executing the query; ERROR: pg_atoi: error in "6.00": can't parse > | > | ".00" > | > | > | > | > | > | The error occurred while processing an element with a general identifier of >(CFINSERT), | > | occupying document position (14:3) to (19:76). > | > | > | > | > | > | Date/Time: Tue Jan 9 10:36:28 2001 > | > | Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0) > | > | Remote Address: 172.16.30.7 > | > | HTTP Referer: http://mondadori.pup.ch/main.cfm > | > | Query String: actionstring=add > | > >|--| > > > PFISTER + PARTNER, SYSTEM - ENGINEERING AG > Juerg Rietmann > Grundstrasse 22a > 6343 Rotkreuz > Switzerland > > phone: +4141 790 4040 > fax: +4141 790 2545 > mobile: +4179 211 0315 >
[SQL] PostgreSQL web page
I wonder why http://www.postgresql.org is not updated with news. The latest "Latest News" is from Nov 16. I have to go to http://www.pgsql.com to find some interesting news later than that: 2000-12-22 PostgreSQL, Inc. Releases Open Source Replication & Database and2000-12-12 2000 Linux Journal Editor's Choice Award for Best Database In fact I was looking for the Replication server. No mention seems to be available on postgresql.org. Also the mailing list archive for pgsql-sql is not listed here: http://www.postgresql.org/devel-corner/index.html - but you can see it if you write the correct URL yourself. -- Kaare Rasmussen --Linux, spil,--Tlf:3816 2582 Kaki Data tshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 Frederiksberg Lørdag 11.00-17.00 Web: www.suse.dk
Re: [SQL] PostgreSQL web page
On Tue, 9 Jan 2001, Kaare Rasmussen wrote: > I wonder why http://www.postgresql.org is not updated with news. The > latest "Latest News" is from Nov 16. I have to go to > http://www.pgsql.com to find some interesting news later than that: > 2000-12-22 PostgreSQL, Inc. Releases Open Source Replication & Database > and2000-12-12 2000 Linux Journal Editor's > Choice Award for Best Database > > In fact I was looking for the Replication server. No mention seems to be > available on postgresql.org. > > Also the mailing list archive for pgsql-sql is not listed here: > http://www.postgresql.org/devel-corner/index.html - but you can see it > if you write the correct URL yourself. I have no graphical browser right now, and lynx isn't installed, so I'm a bit at a disadvantage here ... but, pgsql-sql *should* be listed under users-gallery, not devel ... devel is -hackers, -bugs, -ports, etc ... Beyond that, the web site is maintained by Vince ... but I thought the Award was definitely up there already ...
Re: [HACKERS] Re: [SQL] PostgreSQL web page
> I have no graphical browser right now, and lynx isn't installed, so I'm a > bit at a disadvantage here ... but, pgsql-sql *should* be listed under > users-gallery, not devel ... devel is -hackers, -bugs, -ports, etc ... > > Beyond that, the web site is maintained by Vince ... but I thought the > Award was definitely up there already ... Looks OK here. Maybe a bad mirror. Do: http://www.postgresql.org/index.html to avoid any mirrors. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Re: [HACKERS] Re: [SQL] PostgreSQL web page
> Looks OK here. Maybe a bad mirror. Do: Nope. But I must admit that the item about the award is there - it's just dated November 16, where the date on pgsql.com is Dec. 12. But the thing I really wondered about was the missing announcement of the Replication Server. I thought it was an important news item for PostgreSQL, but I may of course be wrong! -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk
Re: [HACKERS] Re: [SQL] PostgreSQL web page
Error on pgsql.com ... I was nowhere near Las Vegas on Dec 12th ...
On Tue, 9 Jan 2001, Kaare Rasmussen wrote:
>
> > Looks OK here. Maybe a bad mirror. Do:
>
> Nope. But I must admit that the item about the award is there - it's just
> dated November 16, where the date on pgsql.com is Dec. 12.
>
> But the thing I really wondered about was the missing announcement of the
> Replication Server. I thought it was an important news item for PostgreSQL,
> but I may of course be wrong!
>
> --
> Kaare Rasmussen--Linux, spil,--Tlf:3816 2582
> Kaki Datatshirts, merchandize Fax:3816 2501
> Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED]
> 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
Re: [HACKERS] Re: [SQL] PostgreSQL web page
Erk, ookay, didn't think of that ... Kaare, what URL/mirror are you
hitting? Can you email Vince and let him know, so taht he can get that
removed?
Thanks ...
On Tue, 9 Jan 2001, Bruce Momjian wrote:
> > I have no graphical browser right now, and lynx isn't installed, so I'm a
> > bit at a disadvantage here ... but, pgsql-sql *should* be listed under
> > users-gallery, not devel ... devel is -hackers, -bugs, -ports, etc ...
> >
> > Beyond that, the web site is maintained by Vince ... but I thought the
> > Award was definitely up there already ...
>
> Looks OK here. Maybe a bad mirror. Do:
>
> http://www.postgresql.org/index.html
>
> to avoid any mirrors.
>
> --
> Bruce Momjian| http://candle.pha.pa.us
> [EMAIL PROTECTED] | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
[SQL] MATCH
MATCH is not implemented? -- Robert B. Easter [EMAIL PROTECTED] - -- CompTechNews Message Board http://www.comptechnews.com/ -- -- CompTechServ Tech Services http://www.comptechserv.com/ -- -- http://www.comptechnews.com/~reaster/
[SQL] Bad (null) varchar() external representation
Hi all,
I'm getting the following problem when trying to do a simple insert
statement...
"Bad (null) varchar() external representation"
WHY?
I'm running PostgreSQL 7.03 on Linux Mandrake 7.2 (using a specially
compiled version, not an RPM).
Here's the table :
foobar=# \d staff_details
Table "staff_details"
Attribute| Type | Modifier
+--+--
userid | varchar(24) | not null
password | char(13) |
name | varchar(96) |
role | smallint |
dob| date |
phone_one | varchar(14) |
phone_two | varchar(14) |
phone_three| varchar(14) |
address| varchar(280) |
status | smallint |
managers_notes | varchar(600) |
Index: staff_details_pkey
Constraints: (length(userid) < 25)
(length("password") < 14)
(length(name) < 97)
(length(phone_one) < 17)
(length(phone_two) < 17)
(length(phone_three) < 17)
(length(address) < 281)
(length(managers_notes) < 601)
foobar=# insert into staff_details values ('A', NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL);
ERROR: Bad (null) varchar() external representation
foobar=# insert into staff_details (userid, password, name, role, dob,
phone_one) values ('', 'foobarbaz1234', 'Joshua', 1,
'1970-07-01', '(03) 9867 5432');
ERROR: Bad (null) varchar() external representation
foobar=# insert into staff_details values ('',
encrypt('foo'), 'Joshua', 1, '1970-07-01', '(03) 9867 5432', '(041) 309
2819', NULL, '1 Blankety-Blank Way\nBazzville', NULL, NULL);
ERROR: Bad (null) varchar() external representation
etc...
I've tried everything I can think of, also exported and reloaded the
database, etc. This is a new table with nothing in it.
This is driving me nuts. :-(
+ Justin Clift
Database Administrator
[SQL] Possible bug? WAS :Bad (null) varchar() external representation.
Hi,
I haven't seen a mention of a maximum number of constraints of similar
applying to a table. If so, then could someone please point me to it...
The reason I mention this is because I've found what seems to be causing
this problem I'm experiencing with Postgres 7.03 :
CREATE TABLE "staff_details" (
"userid" character varying(24) NOT NULL,
"password" character(13) NOT NULL,
"name" character varying(96) NOT NULL,
"role" int2 NOT NULL,
"dob" date NOT NULL,
"phone_one" character varying(14) NOT NULL,
"phone_two" character varying(14),
"phone_three" character varying(14),
"address" character varying(280),
"status" int2,
"managers_notes" character varying(600),
CONSTRAINT "staff_details_uesrid" CHECK ((length(userid) < 25)),
CONSTRAINT "staff_details_password" CHECK ((length("password") <
14)),
CONSTRAINT "staff_details_name" CHECK ((length(name) < 97)),
CONSTRAINT "staff_details_dob" CHECK
(date_ge(date(("timestamp"('2001-01-08'::date) - '18 years
00:00'::"interval")), dob)),
CONSTRAINT "staff_details_phone_one" CHECK ((length(phone_one) <
17)),
CONSTRAINT "staff_details_phone_two" CHECK ((length(phone_two) <
17)),
CONSTRAINT "staff_details_phone_three" CHECK
((length(phone_three) < 17)),
CONSTRAINT "staff_details_address" CHECK ((length(address) <
281)),
CONSTRAINT "staff_details_managers_notes" CHECK
((length(managers_notes) < 601)),
PRIMARY KEY ("userid")
);
When I attempt to insert data into this table, I get the following error
:
foobar=# insert into staff_details values ('',
encrypt('foo'), 'Joshua', 1, '1970-07-01', '(03) 9867 5432', '(041) 309
2819', NULL, '1 Blankety-Blank Way\nBazzville', NULL, NULL);
Yet if I remove BOTH the "staff_details_phone_three" &
"staff_details_managers_notes" constraints it works :
foobar=# insert into staff_details values ('',
encrypt('foo'), 'Joshua', 1, '1970-07-01', '(03) 9867 5432', '(041) 309
2819', NULL, '1 Blankety-Blank Way\nBazzville', NULL, NULL);
INSERT 27605472 1
Removing EITHER of these constraints doesn't work, and neither does
removing any of the other constraints on this table. Just these two
TOGETHER. AND they're not even defined one-after-another possibly
indicating some formatting error.
Does anyone have an idea why this is occuring?
Regards and best wishes,
+ Justin Clift
Database Administrator
Justin Clift wrote:
>
> Hi all,
>
> I'm getting the following problem when trying to do a simple insert
> statement...
>
> "Bad (null) varchar() external representation"
>
> WHY?
>
> I'm running PostgreSQL 7.03 on Linux Mandrake 7.2 (using a specially
> compiled version, not an RPM).
>
> Here's the table :
>
> foobar=# \d staff_details
> Table "staff_details"
>Attribute| Type | Modifier
> +--+--
> userid | varchar(24) | not null
> password | char(13) |
> name | varchar(96) |
> role | smallint |
> dob| date |
> phone_one | varchar(14) |
> phone_two | varchar(14) |
> phone_three| varchar(14) |
> address| varchar(280) |
> status | smallint |
> managers_notes | varchar(600) |
> Index: staff_details_pkey
> Constraints: (length(userid) < 25)
> (length("password") < 14)
> (length(name) < 97)
> (length(phone_one) < 17)
> (length(phone_two) < 17)
> (length(phone_three) < 17)
> (length(address) < 281)
> (length(managers_notes) < 601)
>
> foobar=# insert into staff_details values ('A', NULL, NULL, NULL, NULL,
> NULL, NULL, NULL, NULL, NULL, NULL);
> ERROR: Bad (null) varchar() external representation
> foobar=# insert into staff_details (userid, password, name, role, dob,
> phone_one) values ('', 'foobarbaz1234', 'Joshua', 1,
> '1970-07-01', '(03) 9867 5432');
> ERROR: Bad (null) varchar() external representation
> foobar=# insert into staff_details values ('',
> encrypt('foo'), 'Joshua', 1, '1970-07-01', '(03) 9867 5432', '(041) 309
> 2819', NULL, '1 Blankety-Blank Way\nBazzville', NULL, NULL);
> ERROR: Bad (null) varchar() external representation
>
> etc...
>
> I've tried everything I can think of, also exported and reloaded the
> database, etc. This is a new table with nothing in it.
>
> This is driving me nuts. :-(
>
> + Justin Clift
> Database Administrator
