[mv] Big troubles with SQL

["Gianluca Mambelli" <gianlucam@hi-net.it>]

******    message to minivend-users from "Gianluca Mambelli" <gianlucam@hi-net.it>     ******

Hi everybody,
I'm an absolute beginner and I'm having some truobles.
I've set up a catalog with a DB named 'produtcs' (as the default)
In a browse page I wrote a query this way:

<TABLE>
<TR>
    <TD>CodeTD>
    <TD>Title</TD>
    <TD>Price</TD>
  </TR>
  [sql type=list query="select code,title,price from products where title = 'cream' "]
  <TR>
    <TD>[page [sql-code]][sql-code]</A></TD>
    <TD>[sql-param title]</TD>
    <TD>[sql-param price]</TD>
  </TR>
  [/sql]
 </TABLE>

When I get this page with a browser what comes out is only the first row of the table
Everything inside the tags [sql] [/sql] disappears !

In the 'error.log' file there are many of this messagge:
"Bad SQL query selector: 'type' for products"
What's wrong ?!?

Thanks a lot
Gianluca (Starving for some help!!!)

-
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