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



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings