[ic] Product Meta DB Lookup issue
nest_consulting at yahoo.ca
Wed Aug 30 19:35:30 EDT 2006
> N.E.S.T. Solutions wrote:
> >>"N.E.S.T. Solutions" <nest_consulting at yahoo.ca> wrote:
> >>>My tables columns are built like this:
> >>>Products table:
> >>>sku description price (...) itemtype1 itemtype1brand (...)
> >>>itemtype2brand (...) [around 250 columns, 20 item types]
> >>Have you considered splitting the 250 columns into a
> >>separate table? Perhaps one table with sku, description and
> >>price etc. and another with sku, type and brand?
> > Actually yes, that's part of the re-design, cause it's been
> growing way
> > too big. But first, I want to avoid having to edit my products meta
> > options
> > by hand, cause I have to do this for about 20 fields
> (lists). Same for
> > other fields that repeats.
> > So do you know what I'm doing wrong with the external DB lookup?
> First of all check your error.log for messages and the MySQL
> log whether
> Interchange uses the correct query or not.
Yes I did,see below. I was trying to use any DB to get data out of, and
I always get the same :
SELECT DISTINCT DBNAME::COLUMN from DBNAME order by DBNAME::COLUMN
instead of getting something like
SELECT DISTINCT COLUMN from DBNAME order by COLUMN
admin/meta_editor SQL query failed: Bad column name (from
2ndDayAir::202): '2ndDayAir::202' at
/usr/local/interchange/lib/Vend/SQL_Parser.pm line 838.
query was: SELECT DISTINCT 2ndDayAir::202 FROM 2ndDayAir ORDER BY
Is that the way it's supposed to be or is there something screwed up in
what I'm doing?
Thank you in advance for any pointers
More information about the interchange-users