Re: Database: can't update database record (Solution)

[mikeh@minivend.com]

******    message to minivend-users from mikeh@minivend.com     ******

Quoting Yossi Cohen (YOSSI@prodigy.net):
> 
> Hi,
> 
> [loop-field] tag works with the products database only (that's a bit
> inconsistent behavior which I hope will be resolved in future versions of
> Minivend. 

This a constant misconception which I don't know what to do to
correct; I can't stand to see it any more. Several people have corrected
this on the mail list before, and I know it is documented. I should
do an FAQ, I guess. Sigh....

	[loop-field column] != [loop-data products column]

The following are all "magic":

	[item-field column]
	[loop-field column]
	[sql-field column]
	[field column key]

They find the column in the FIRST ProductsFile that matches
the item, or in the case of the [item-list] tag with [item-field],
the column from the database it is ordered in.

So if you have two databases:

Database   new   new.asc   TAB
Database   used  used.asc  TAB
ProductFiles  new used

and you do:

	[order 00-0011] Order the frame [/order]

it will select a used one if a new one is not available.
Furthermore, the same item-list:

	[item-list] [item-code]: [item-field description]
				[currency][item-field price][/currency]
	[/item-list]

can be used to display items from both the new and used database
together, with auto-selection.

This allows multiple product lines in multiple databases to
be aggregated while still sharing a common shopping cart, results
page, and other data items.

-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
Fast, reliable, cheap.              131 Willow Lane, Floor 2  | ||  _ \
Pick two and we'll talk.            Oxford, OH  45056         | || |_) |
 -- unknown                         <mikeh@minivend.com>     |___|  _ <
                                    513.523.7621 FAX 7501        |_| \_\
-
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