[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
[page scan ... ][/page]
Hi...
Trying to play with the ability to search my database...to provide
links to specific "product" areas, and am failing miserably...
Looking at the docs, under 'One-click searches', I found what I
think I want, so created:
[page scan sql=select code,description,price * 1.1 as price from products where showit and description like 'Targus%']
Targus Notebook Accessories
[/page]
Ran it through and it gave me a link of:
<a href="http://www.hub.org/hub_prod.cgi/scan/sql=select%20code%2cdescription%2cprice%20%2a%201%2e1%20as%20price%20from%20products%20where%20showit%20and%20description%20like%20%27Targus%25%27?3uZpD6bx;;9">
Targus Notebook Accessories
</a>
Looks okay so far.
When I click on it, though, I don't know what its giving me back...
My index.html page is really simple:
=====================
<HTML>
<HEAD>
<TITLE> __COMPANY__ Catalog </TITLE>
</HEAD>
<BODY MV="body 1">
__LOGOBAR__
<TABLE BORDER=2>
[page scan sql=select code,description,price * 1.1 as price from products where showit and description like 'Targus%']
Targus Notebook Accessories
[/page]
[sql type=html]select code,description,price * 1.1 as price from products where showit[/sql]
</TABLE>
__COPYRIGHT__
<!-- current page: @@MV_PAGE@@ -->
</BODY></HTML>
=======================
Create the link above, then display the whole products listing.
If I click, its giving me back:
http://www.hub.org/hub_prod.cgi/scan/sql=select%20code%2cdescription%2cprice%20%2a%201%2e1%20as%20price%20from%20products%20where%20showit%20and%20description%20like%20%27Targus%25%27?3uZpD6bx;;9
Which looks like the 'demo' pages (with the leftbar from the art pages)
and what looks like a 'listing' of products, with no data...*raised
eyebrow*
I'm guessing I'm missing a file here somewhere, that the scan is callign
to determine how its displaying things? Still reading through the docs,
but any pointers appreciated...
Thanks...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
