MiniVend Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

RESULTS.HTML



******    message to minivend-users from "Black Samba" <darrenl@blacksamba.com>     ******

I have my mysql database all set up, and I made a simple search inquiry from
a fresh page (see below). The search returns artist and title, but not
price, and seems to autogenerate a page called process.htm based on SOME
part of the included results.html.

The quesion is, how do I configure results.html, or change which page is
displayed returning results from a SQL query? It says in the dox that I can
use the other tags the same way with SQL as normally, but the item-price for
example doesn't find my fields with different names.

Any tips or examples of working SQL searches and RESULTS.html would be cool!

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
	<title>Untitled</title>
</head>

<body>
     <FORM ACTION="[process-target _self]" METHOD=POST>
     <INPUT TYPE="hidden" NAME="mv_search_file" VALUE="products">
     <INPUT TYPE="hidden" NAME="mv_search_field" VALUE="artist">
     <INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="sql">
     <INPUT TYPE=text NAME="mv_searchspec" SIZE=20>
        This is your form_field_artist

     <INPUT TYPE="submit" NAME="mv_todo" VALUE="Search">
     <INPUT TYPE="hidden" NAME="mv_doit" VALUE="search">
 <INPUT TYPE="submit" name="mv_click" value="Continue Shopping">

  [set Continue Shopping]
  mv_todo=return
  mv_nextpage=browse
  mv_change_frame=_top
  [/set]



</body>
</html>


-D-

Black Samba Design Services
Darren Littlejohn
darrenl@blacksamba.com
831-454-9580

BLACK SAMBA IS NOW!
http://www.blacksamba.com


> -----Original Message-----
> From: owner-minivend-users@minivend.com
> [mailto:owner-minivend-users@minivend.com]On Behalf Of Black Samba
> Sent: Thursday, March 18, 1999 11:37 PM
> To: minivend-users@minivend.com
> Subject: RE: Bundle::Mysql:DBD and Bundle:DBI - Solution
>
>
> ******    message to minivend-users from "Black Samba"
> <darrenl@blacksamba.com>     ******
>
> The solution to this one I forgot is that for some reason the CPAN install
>
> perl -CPAN -e shell (an automated perl module installation
> program - pretty
> cool)
>
> doesn't work right with the DBI module and the Mysql::DBD, so it has to be
> done manually. So, download the module, run perl Makefile.PL on
> DBI 1.10 and
> THEN you can do the same with the Mysql module.
>
> I've now created a mysql database, set the catalog.cfg directive
> to read it,
> set NoImport to
> prevent overwriting my data. Now on to changing the database to suit my
> client's needs, adn then populating it before trying to make Minivend use
> it.
>
>
> -D-
>
> Black Samba Design Services
> Darren Littlejohn
> darrenl@blacksamba.com
> 831-454-9580
>
> BLACK SAMBA IS NOW!
> http://www.blacksamba.com
>
>
> > -----Original Message-----
> > From: owner-minivend-users@minivend.com
> > [mailto:owner-minivend-users@minivend.com]On Behalf Of Black Samba
> > Sent: Thursday, March 18, 1999 10:48 PM
> > To: minivend-users@minivend.com
> > Subject: Bundle::Mysql:DBD and Bundle:DBI
> >
> >
> > ******    message to minivend-users from "Black Samba"
> > <darrenl@blacksamba.com>     ******
> >
> > I've been having some trouble with the DBD module for Mysql not
> > installing.
> > There are thr following choices on CPAN. Which one works?
> >
> > Bundle::Mysql
> > Bundle:DBD:mysql 2.16 and 2.17 or similar
> > Bundle:DBI
> >
> >
> >
> > -D-
> >
> > Black Samba Design Services
> > Darren Littlejohn
> > darrenl@blacksamba.com
> >
> > BLACK SAMBA IS NOW!
> > http://www.blacksamba.com
> >
> >
> > -
> > 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
> >
>
> -
> 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
>

-
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


Search for: Match: Format: Sort by: