On Wed, Oct 8, 2008 at 4:48 PM, Mike Mabey <[EMAIL PROTECTED]> wrote: > > > > Okay, I just tried it, and here's the output: > > SETTING NONUPDATE FOR parts > USING DATASTRUCTURE parts > Dabo Error Log: Wed Oct 08 16:44:47 2008: Error in scanChangedRows: (1054, > "Unknown column 'parts.name' in 'field list'") > SQL: update `parts` set `parts`.`name` = 'Comparator / OP AMPs' where > `parts`.`index`=1 > > If memory serves me correctly, I've run into the problem of naming a table > column something that threw off the code that worked with it. I'll try > renaming the `name` column, changing the code in my app to reflect that, and > then I'll let you know how it works out. > > Thanks for your help. I appreciate it. > > Mike M. >
Well, changing the `name` field to `cat_name` didn't change anything. I still get the following: SETTING NONUPDATE FOR parts USING DATASTRUCTURE parts Dabo Error Log: Wed Oct 08 16:53:55 2008: Error in scanChangedRows: (1054, "Unknown column 'parts.cat_name' in 'field list'") SQL: update `parts` set `parts`.`cat_name` = 'Comparator / OP AMPs' where `parts`.`index`=1 I'm wondering why it's trying to set `parts`.`cat_name` instead of trying to set `parts`.`parent_category` = 21 or whatever the index is for that entry in `categories`. Let me try the code that John just suggested and see what happens. Thanks, Mike M. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
