Re: [mv] SQL Query

["Nick Pleis" <npleis@saratogaweb.com>]

******    message to minivend-users from "Nick Pleis" <npleis@saratogaweb.com>     ******

[query sql=" select * from whatever"]
[/query]

[query sql="select * From whatever" list =1] will iterate through
everything. Access field names with
[sql-param field_name], you can access the first returned value with
[sql-code]

Nick
-----Original Message-----
From: Andrey Buikis <support@hyper.it>
To: minivend-users@minivend.com <minivend-users@minivend.com>
Date: Thursday, July 20, 2000 11:54 AM
Subject: [mv] SQL Query


>******    message to minivend-users from Andrey Buikis <support@hyper.it>
******
>
>Hello,
>I have database with autoaccessories which can be UNIVERSAL and for
>specific SPECIFIC CAR.
>I just try to implement the query which shows me the list of "universal"
>products as well as
>specific car products.
>Here is example of working MySQL query:
>
>select sku from products where
> ( firm='Bridgestone' and category='Wheels' ) and ( cartype='' or
>cartype='FERRARI' )
>
>Anyone knows how to implement this query in MV?
>I've tryed this one but seems that MV doesnt pass cartype='' string.
>
>[page href=scan
> arg="
> st=sql
> ml=5
> sq=select sku from products where ( firm='Bridgestone' and
>groups='Wheels' ) and ( cartype='' or cartype='FERRARI' )
> "]
>Bridgestone Wheels for your Ferrari
>[/page]
>
>
>Thanks,
>Andrey
>-
>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

-
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