Re: [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>
>
>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]

Thanks so much Randy, but unfortunately I'm working with Minivend v.3.1x and I think your
solution works under v. 4.x of Minivend, isn't it ???


-
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