Use SQL Statements..!

["Michael Radke" <mra@trendware.de>]

******    message to minivend-users from "Michael Radke" <mra@trendware.de>     ******

As a "Re" on sorting, searching, in combination with SQL-
Tags, I would like to mention that *I* only use SQL-
Searches in combination with scratch and arg's anylonger,
this seems to be more flexible to fit my needs.

Example:

On the very first page, I show all "main product groups"
to the customer, this comes from a database already (so,
the shop-owner can add new groups easily maintaining his
database) :

[sql type="list" query="select distinct(products.maingrp),
maingrp.Text from products left join maingrp on 
products.maingrp=maingrp.grp order by maingrp.Text" base="products"]

[pagetarget href="auswahl" target="content" arg="[sql-param 0]"]
[sql-param 1]</a><br>
[/sql]



Now, Sub-groups should be displayed, also the sub-groups should
come from a database, in order to let the customer manage also
this by himself :

[set name="scratch_hg" interpolate=1][data arg][/set]

[sql type="list" query="select distinct(subgrp.Text),
subgrp.subgrp from products left join subgrp
ON products.subgrp=subgrp.subgrp where 
products.maingrp='[data arg]' and subgrp.Text
<> 'NULL'" base="products"]

[page href="subgrp" arg="[sql-param 1]"]
[sql-param 0]</a><br>[/sql]



The products now being displayed could be choosen by another
SQL-construct using that defined scratch and the given arg :

[sql type="list" query="select code, productcode, description, price
from products where subgrp='[data arg]' and 
maingrp='[scratch scratch_hg]'" base="products"]

...

[/sql]



You can easily manage everything by using SQL-constructs, I think
Minivend itself does nothing else. You can reduce the amount of
memory for not buffering any unwanted fields any longer, you can
decrease unwanted SQL-traffic at all, I think.

You can build product groups, subgroups and other subgroups as well.
I think, you can build almost everything with this.


Using MySQL, you can give your customers a interface to MS-Access
(via ODBC) for an example, you build the tables and, you build Forms
they should use, they can update anything offline and, the correct
scripts, "stored procedures" and macro's behind it, the MyODBC-
databases could be updated at once easily.


I have created three catalogs, the last two in this way, and I will
switch the first to this procedures as well because I think it's
the better way for anything..

Now, think about it, let me know what you think about this...

Regards,

Michael Radke
TRENDWARE Services


------------------------------------------------------
Trendware Services        CHECK OUT :
Holsteiner Ch. 225M       http://www.trendware.de
D-22457 Hamburg           http://www.pc-marketplace.de
Phone : 040 5598455-0     http://www.hamburger.de
Fax   : 040 5598455-90
------------------------------------------------------

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list