MiniVend Akopia Services

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

Getting flypage to recognize item codes?



Hi,

   I'm having a hard time getting flypage.html to do the right thing for
   me.  Every time that I supply an item code I get an error:

      "Sorry, we are still under construction!  The item (epalp)
      doesn't have a catalog page yet..."

   If I have a page, say foo.html, with minivend code like this:

      [sql type=list
            query="select distinct p.code, p.invasive, p.sci_name, h.hardiness_name, s.size_name, p.price from plant as p left join size as s on s.size_id = p.size_id
       left join hardiness as h on h.hardiness_id = p.hardiness_id where p.sci_name like 'e%'" ]
      <font size=-1>
         <a href="[area [sql-code]]"><b>[sql-param sci_name]</b></a>
         [if type=explicit compare='[sql-param invasive]']
            <img src="/images/invasive.jpg" BORDER=0 ALT="invasive">
         [/if]
         [sql-param hardiness_name] [sql-param size_name] [sql-code]
         $[sql-param price]<br>
      </font>
      [/sql]

   it generates a list of all plants starting with the letter 'e' just 
   fine.  However, following a link brings me to the error above.

   Strangely enough, the old product codes from the artist pages seem
   to work, even if I remove the products directory entirely and restart
   minivend.

   I'm sure I'm missing something obvious here -- can anyone help 
   enlighten me? 

Thanks,

Chris



Search for: Match: Format: Sort by: