From: | "Michael Fork" <mfork00(at)yahoo(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Data Access Error |
Date: | 2004-03-23 04:22:17 |
Message-ID: | c3oe1n$2ogc$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(dot)texidor(at)webbods(dot)com(dot)au> wrote in message
news:200403190036(dot)17909(dot)nick(dot)texidor(at)webbods(dot)com(dot)au(dot)(dot)(dot)
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | David P. Lurie | 2004-03-23 09:11:05 | postgresql equivalent to ms access parameter query |
Previous Message | Chris Gamache | 2004-03-19 22:24:38 | Tracking down "unexpected EOF on client connection" |