|
|
|
|
|
|
| Author |
Message |
Mohsen Pahlevanzadeh *nix forums beginner
Joined: 14 Mar 2005
Posts: 23
|
Posted: Mon Mar 14, 2005 1:06 pm Post subject:
(unknown)
|
|
|
Dears,
When i wanna insert to my following code,I receive following error:
Insert into c(t) values('ccccccc'); --> It's my qurey.
Insert command failed!So i can't continue to insert in your table!
ERROR: pg_atoi: error in "ccccccc": can't parse "ccccccc"
my code :
pres = PQexec(pobj->connection2db, ins.c_str());
ins="";
if (!pres || PQresultStatus(pres) != PGRES_COMMAND_OK)
{
fprintf(stderr, "Insert command failed!So i can't continue to insert
in your table!\n");
cout << PQerrorMessage(pobj->connection2db);
pobj->exit_nicely(pobj->connection2db);
}
PQclear(pres);
When i print ins.c_str(),I see following statement:
Insert into z(e) values('10z');
It's true,But i recieve same error.
Please help me..............
--Mohsen
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly |
|
| Back to top |
|
 |
Miroslav Šulc *nix forums beginner
Joined: 05 Mar 2005
Posts: 9
|
Posted: Mon Mar 14, 2005 1:06 pm Post subject:
Re:
|
|
|
Mohsen Pahlevanzadeh wrote:
| Quote: | Dears,
When i wanna insert to my following code,I receive following error:
Insert into c(t) values('ccccccc'); --> It's my qurey.
Insert command failed!So i can't continue to insert in your table!
ERROR: pg_atoi: error in "ccccccc": can't parse "ccccccc"
Usually atoi functions perform conversion from string to integer (if my |
memory serves well). Maybe the problem is that you are trying to insert
string into numeric field.
|
|
| Back to top |
|
 |
Google
|
|
| Back to top |
|
 |
|
|
The time now is Fri Jan 09, 2009 6:37 am | All times are GMT
|
|
Loans | Web Hosting by Safehosting | Credit Cards | Libros arquitectura | Bankruptcy
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|