RE: [ic] Product Meta DB Lookup issue

["N.E.S.T. Solutions" <suppressed>]

> 
> N.E.S.T. Solutions wrote:
> >>"N.E.S.T. Solutions" <suppressed> wrote:
> >>
> >>>My tables columns are built like this:
> >>>
> >>>Products table:
> >>>sku description price (...) itemtype1 itemtype1brand (...) 
> itemtype2 
> >>>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.
> 
> Bye
> 	Racke
>

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
2ndDayAir::202

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

Martin

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users