Re: [mv] All in one question.

[Marty Vance <mvance@lwm.com>]

Dan Busarow wrote:

> ******    message to minivend-users from Dan Busarow <dan@dpcsys.com>     ******
>
> On Mon, 3 Jan 2000, Marty Vance wrote:
> > I walked into the middle of this project, just in time to write the
> > minivend pages.  The catalog iteself was already set up.  The last two
> > weeks are the only experience I have with MiniVend.  Here's what I need
> > to accomplish:
> >
> > 1. An SQL search: "select * from art where galleryID = x"  x also needs
> > to be sent as an equivalent to [data session arg] in the form that
> > submits the search.  Or, I need some other way to access x in order to
> > substitute it into an image path.
>
> I always use [perl] for this but there is also a [set] tag
>
> [perl arg=scratch]
> $a = tag_data('session', 'arg');
>
> ($b,$c) = split /\|/, $a;
>
> if($b) {
>     $Safe{'scratch'}->{'type'} = $b;
>         $Safe{'scratch'}->{'uctype'} = ucfirst($b);
> }
>  ...
> [/perl]
>
> In your results page you access the value like this
>
> <h1>[scratch ucmanufact] [scratch uctype] Categories</h1>
>
> > 2.  The search results need to display the fields artID, title, and
> > artist in a [more-list] construct.
>
> When accessing a non-products table via [search_list] (not [more_list])
>
> [page href="products" arg="[item_data models code]"]
>                                       ^        ^
>                                                                            table    column
>
> Dan
> --
>  Dan Busarow                                                  949 443 4172
>  Dana Point Communications, Inc.                            dan@dpcsys.com
>  Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82
>
> -
> 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

Thanks for the info Dan.  However, your example won't work for me because x is set by the form
on the client side as mv_searchspec.  Any other ideas?

Marty Vance
LiveWire
mvance@lwm.com
www.lwm.com

begin:vcard 
n:Vance;Marty
tel;work:(314) 361-8500 ext. 315
x-mozilla-html:FALSE
org:LiveWire
adr:;;4814 Washington Blvd, Suite 300;St. Louis;MO;63108-1833;
version:2.1
email;internet:mvance@lwm.com
title:Web Developer
fn:Marty Vance
end:vcard