[DOCS] Select statement error !!!!

2003-09-24 Thread Vutharkar Goutham
Hello, I am doing a simple program with PostgreSql wherein i am giving a select statement as an argument to PQexec like this char query[1024]; strcpy(query,"Select * from Udp_Table"); res = PQexec(conn,query); if(!res || PQresultStatus(res)! = PGRES_COMMAND_OK) { fprintf(stderr,"Select Failed.

Re: [DOCS] Select statement error !!!!

2003-09-24 Thread Oliver Elphick
On Wed, 2003-09-24 at 11:27, Vutharkar Goutham wrote: > Hello, > > I am doing a simple program with PostgreSql wherein i am giving a select > statement as an argument to PQexec like this > > > char query[1024]; > strcpy(query,"Select * from Udp_Table"); > now if i try to execute the above stat

Re: [DOCS] Select statement error !!!!

2003-09-24 Thread Tom Lane
"Vutharkar Goutham" <[EMAIL PROTECTED]> writes: > strcpy(query,"Select * from Udp_Table"); > res = PQexec(conn,query); > if(!res || PQresultStatus(res)! = PGRES_COMMAND_OK) > { > fprintf(stderr,"Select Failed.\n"); The result status from a successful SELECT will be PGRES_TUPLES_OK; PGRES_COM

Re: [DOCS] Select statement error !!!!

2003-09-24 Thread Vutharkar Goutham
Hello, I am sorry that this isn't the right group to putup the question but i am desperate to get it right and moreover thats what the major hindrance to our project. We are doing Intrusion Detection System as project to fulfill the requirement of completion of Post Graduation in MSIT. So we

Re: [DOCS] Select statement error !!!!

2003-09-24 Thread Oliver Elphick
On Wed, 2003-09-24 at 15:48, Vutharkar Goutham wrote: ... > So we are using PostgreSQL as our database to store the captured data from a > LAN or from outside network. So in the mean process we successfully captured > the data packets and sent them into the database tables but the problem is > w