Re: [mv] SQL Select Issue.

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

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

try:

[query sql="select (code, category) where code=[value widget]" list=1]
[sql-code]has the first item returned
[sql-param category] for the second
[sql-param code] also gets first item
[/query]

That should work IIRC.

Nick

----- Original Message -----
From: Jason M. Korkin <jkorkin@korksoft.com>
To: <minivend-users@minivend.com>
Sent: Tuesday, April 11, 2000 11:40 AM
Subject: [mv] SQL Select Issue.


> ******    message to minivend-users from "Jason M. Korkin"
<jkorkin@korksoft.com>     ******
>
> Hi all,
>     Its been a while... :-)
>
>     Using MV4.03 and attempting to do a SQL query with MySQL... DB is
known working with
> MV already... Here is my snippet:
>
>     [sql interpolate=1]
>     select (code, category) where code = [value widget]
>     [/sql]
>
>     How does this data get returned?  I cannot seem to get it to be
anything other than a
> ARRAY(0x...) -- which mean that I'm not referencing it properly I believe.
Any ideas?  I
> know that this will only be returning one record...
>
>     Thanks,
>
>     Jason Korkin.
>
>
> --
> KORKSOFT - Internet Consulting Group
> System Integration, E-Commerce, C++/Perl/PHP/ASP
> http://www.korksoft.com
> http://www.atworkservers.com
> Tel: (603) 472-8262
> Cel: (603) 682-8672
>
>
> -
> 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