Re: [mv] minivend and sql, it is not true LET ME EXPLAIN!!!!

[mike@minivend.com]

Quoting Paolo Torricelli (ptorric@tsc4.com):
> 
> what i mean regarding sql support:
> * it is limited to the minivend table, like products and so on.
> I've tryed to use it for a "tracking-number" like informations pages,
> integrated with another package (ERP) that make all the necessary
> transactions.
> 
> if you all are interested in what's the problem, please check at:
> grep sql-field * 
> in minivend/lib/Vend
> 
> i think the code is clear.
> 
> * i'm sorry for summoning this topic, it was only a technical topic (in my
> mind)
> 

I wouldn't jump in, but I don't want myths propagated on the
list without answer.

The docs clearly state that in most cases:

	[sql-field ...]

is the same as 

	[sql-data products ....]

But not the same as:

	[sql-data other_table ...]

but that if you want to address data outside the products table
you must use sql-data.

There are reasons for the difference, but you have to read the docs
for this.

And you can do selects to any table that any MV has a table in.

Bottom line:
	
	MiniVend can access any SQL table.
	MiniVend global UserTags can access any DBI function.

I don't see where the problem is other than the lack of understanding
about what [sql-field ...] is.

-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
My wife is great.  She doesn't      131 Willow Lane, Floor 2  | ||  _ \
care where I go, just as long as I  Oxford, OH  45056         | || |_) |
don't have any fun.                 <mikeh@minivend.com>     |___|  _ <
 -- Lee Trevino                     513.523.7621 FAX 7501        |_| \_\