This query fails:
insert into house values("xy","xy","jhsgghskjhds")
The _exact_ same query works when I connect to the same database through an ODBC
connector, instead of a JDBC connector.
Yes, I am changing the key values each time so it is not trying to insert a key value
that already exists.
Darren
> -----Original Message-----
> From: Geoff Bowers [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 10 March 2004 11:02 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] Re: JDBC SQL problems
>
>
> Darren Tracey wrote:
> > I'm converting all my SQL to use a JDBC datasource instead of the
> > original ODBC datasources, to avoid the mysterious server crashes as
> > detailed in other threads. With the modifications I explained in my
> > original emails, all my SELECT statements work fine. Every single
> > insert, update and delete statement causes this error:
> ...snip...
>
> Send through the code from CFQUERY to /CFQUERY. Might be
> easier for us
> all to get our collective head around what you're doing in there.
>
> -- geoff
> http://www.daemon.com.au/
>
>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> [EMAIL PROTECTED]
>
> MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
> http://www.mxdu.com/ + 24-25 February, 2004
>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
