Re: [mv] Big troubles with SQL

[Randy Moore <ramoore@axion-it.net>]

******    message to minivend-users from Randy Moore <ramoore@axion-it.net>     ******

At 6/15/00 07:25 AM , you wrote:
>******    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>

Hi Gianluca,

Try this structure instead. It works for me.

   [query list=1 ml=999 sql="select code,title,price from products where 
title = 'cream' "]
   [list]
   <TR>
     <TD>[page [sql-code]][sql-code]</A></TD>
     <TD>[sql-param title]</TD>
     <TD>[sql-param price]</TD>
   </TR>
   [/list]


Randy Moore
Axion Information Technologies, Inc.

email     ramoore@axion-it.net
phone   301-408-1200
fax        301-445-3947
-
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