Re: simple insert operation

I have faced & solved all the problems that you have mantioned ..
try-catch statements and this "lowercase" situation.
the lowercase situation was the most annoying one...

Thanks for your help...

Kevin Grittner wrote:

>Hi Ayd*n,
>
>Others have addressed your compile errors, but I see something which might cause you problems at run time.
>
>Identifiers which are not "quoted" will be treated as lower case in PostgreSQL, so your query will try to access "passtable"."idcol" instead of "passTable"."idCol". If you created the table without using quotes it will be in lower case and you will be OK referencing it without quotes no matter what capitalization you use; however, if the table really exists in your database with the camel case identifiers, you must use quotes.
>
>-Kevin
>
>
>
>
>>>>Ayd*n Toprak <aydin(dot)toprak(at)intengo(dot)com> 09/08/05 2:58 AM >>>
>>>>
>>>>
>
> String sqlQuery = "INSERT INTO passTable (idCol , pass) VALUES
>(3, 5)";
>
>
>
>
>