Try doing a regular sql query to update the database. I'll bet a $100 that
that's the problem. If not, try to telnet into mysql and do a
describe yourtable;
to see what the columns look like. I've heard that myodbc does a pretty
good job of transferring the data, but you never know what could have happened.
It must be monday...100's of emails just waiting to be answered!
Brett
At 03:38 PM 1/22/01 +0000, you wrote:
>Do you have any more information about this? I've just started updating
>someone elses code running on linux and although cfinsert does work fine,
>I'm having trouble getting cfupdate to work. The error is 'Primary key
>field ROWID not found.', but rowid ain't the primary key and the actual
>primary key is being submitted with the form.
>
>
>
>Mark
>
>
>At 07:49 AM 1/22/2001 -0700, you wrote:
> >This doesn't have anything to do with myodbc but when going from NT to
> >*nix, you'll see that <cfinsert> and <cfupdate> don't work. You'll have to
> >use the standard SQL query.
> >
> >Brett
> >
> >
> >At 08:58 AM 1/22/01 -0500, you wrote:
> >>Anyone have any pointers/tips on the conversion from Access to mySQL?
> >> I moved things over the weekend (using myODBC to just export tables)
> >> and for the most part things seem to have gone OK - my dates seem
> >> really messed up:
> >>
> >> Month 01, 2001 now reads: 65, 65535 :)
> >>
> >>But I imagine that is just a field type I need to change.
> >>
> >> Anything else I should look for or plan
> >> on changing? Also discovered CFTransaction doesn't work which
> >> hopefully won't be a problem.
> >>
> >> Thanks much
> >> Jim
> >>
> >>
> >>--------------------------------------------------------------------------
>----
> >>Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
> >>To Unsubscribe visit
> >>http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_linux
> >>or send a message to [EMAIL PROTECTED] with 'unsubscribe'
> >>in the body.
> >
> >
> >Brett Frisch
> >Director of Design and Internet Technologies
> >Web Design Works Inc.
> >
> >-------------------------------------------------
> >http://www.webdesignworks.com
> >1-970-266-9401 [Phone]
> >1-970-266-8311 [Fax]
> >1554 Quail Hollow Drive
> >Fort Collins, CO 80525
> >[EMAIL PROTECTED]
> >--------------------------------------------------
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
