Re: [mv] MV4.0alpha10 SQL parse problem

[Mike Heins <mike@minivend.com>]

******    message to minivend-users from Mike Heins <mike@minivend.com>     ******

Quoting Christian J. M|ller (cmueller@polinet.ch):
> 
> Installation is MV4.0alpha10 on Linux SUSE 6.3 using mySQL 23.7 alpha.
> 
> I am trying to implement a ling with a one-click SQL search like:
> 
> <A HREF="[tag sql]select code, isbn, title, author from products where
> searchcrit1 = 'architecture'[/tag]"> architecture</A>
> 

[tag sql] and [tag scan] are no longer supported in MV 4; if it isn't
in the WHATSNEW file I will put it there.

You need the standard:

	[area scan
			st=db
			sq=select ....
			]

st=sql is a synonym for st=db. This, by the way, will work on not only
MySQL but MiniVend databases. You need SQL::Statement for any of this to
work. When I release MiniVend 4 beta I will probably once again put it
on CPAN and make SQL::Statement a requirement.

In MV, it would be:

	[area scan
			se=architecture
			sf=searchcrit
			rf=code,isbn,title,author
			st=db
			op=eq
			co=yes
			]

This would not require SQL::Statement.

-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
In character, in manners, in        131 Willow Lane, Floor 2  | ||  _ \
style, in all things, the           Oxford, OH  45056         | || |_) |
supreme excellence is               <mikeh@minivend.com>     |___|  _ <
simplicity. -- Longfellow           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