Re: Data Access Error

I am having this same problem -- executing a delete statement through the
ODBC driver that affects 0 rows throws an SQLException in Java -- is there a
workaround.

Thanks.

Michael

"Nick Texidor" <nick.texidor@xxxxxxxxxxxxxx> wrote in message
news:200403190036.17909.nick.texidor@xxxxxxxxxxxxxxxxx
> Hi, I'm hoping that someone can help me out with a small problem.
>
> I have just moved a website over from a MS Access database to a Postgres
one.
> The site is written in ColdFusion.  Most of the SQL commands worked fine,
> with the only changes being the boolean fields, which were bit under
Access.
>
> Anyway.. my problem is this.  I have a function that deletes pages in my
> content system.  This function fires off several ColdFusion queries, to
> delete records from various tables.   There may, or may not, be records in
> these tables that need to be deleted.
>
> The problem is this... if there are records to be deleted, everything runs
> fine and dandy.. however, of there are no records to be deleted, the
browser
> spits up a "Data Access Error" error page.  All it says is "Unknown Data
> Access Error".   I have played around enough to figure that it is when
there
> are no rows deleted that the error appears.  This has always worked when
the
> database used was Access.   I'm tried pasting the code directly into the
SQL
> window in phpPgAdmin, and the same code qorked, without returning an
error,
> where no records existed to be deleted.
>
> So I'm figuring that the error is lieing in the ODBC driver.   I have been
> through all the settings, but couldn't make it work.   Am I missing
> something, or is this a genuine bug?   Are there any other odbc drivers I
can
> try?  I can code SELECT queries all around the deletes to see if there is
> anything to delete, but this seems like a bit of overkill for something
that
> should really work.
>
> I'm running postgres on a windows NT machine, using the cygwin setup.
> Everything else seems great, just this problem.
>
> Any help would be greatly appreciated.
>
> Thanks
>
> Nick
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)