I haven't tried manually parsing the form result from the CFGRID tag. I
think this WOULD work, as the debug code shows that the CFGRID submit
does generate the proper form fields. Its just the CFGRIDUPDATE that is
choking. Of course thats a lot more work than just saying CFGRIDUPDATE
this table.
I already have a backend db record input/editing interface done with
standard form input boxes. Just that this db (public records) has a lot
of data. I was looking for a quick and dirty way to get a nicer
interface on the data. Its a bit of a chore to edit multiple records
right now. I've been using Access linked to mySQL via myODBC but I've
found that the mix doesn't always work quite right. Occasionally updates
or edits won't work right (occasional field truncation to 256 characters
among other issues).
The goal is to provide a reasonably user-friendly and (more importantly)
efficient way to manage the data in MySQL. The data input and
manipulation is not necessarily being done by web savvy people. CFGRID
just seemed an easy way to get at least part way there.
I think I'll just have to switch to not-so-rapid development and
allocate the time to build it out.
Dan
-----Original Message-----
From: Joshua Meekhof [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 5:11 AM
To: CF-Linux
Subject: Re: cfgrid + cfgridupdate on Linux with Mysql DB
Dan,
Have you tried running your update against MYSQL using 'vanilla' sql
code? Sometimes using 'automatic' updates and inserts (i.e. cfupdate,
cfinsert) can be tricky to debug.
--
Josh Meekhof
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
