Thread: Data Access Error

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

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@webbods.com.au> wrote in message
news:200403190036.17909.nick.texidor@webbods.com.au...
> 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
>