[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: SQL... other question.
****** message to minivend-users from William Tan <william@absolutely.com.sg> ******
Hi,
Looks like you want to do a SELECT statement across tables. I've
wondered about this. There are a couple of ways to do it, according to
the docs ([sql] and [data] tags). The latter way is a simple "select"
that queries any table that you've configured in minivend.
<PARAM MV=data
MV.TABLE=myTable
MV.COL=columnName
MV.ROW=[value anyVariable]>
For more complicated SELECT's use the [sql] tag.
Regards,
wil.
On Fri, 21 May 1999, G. Tyler Koblasa wrote:
> ****** message to minivend-users from "G. Tyler Koblasa" <gtyler@onestop.net> ******
>
> I am a bit confused.. Let me explain all the details..
>
> There are a number of Tables included in the database, which include a
> title, skuid, description, weight, and price...
>
> Currently this info. is accessible through the SQL database, residing in a
> number of different Tables. I have installed minivend, and need to access
> and use the description from one table (based on a similar skuid) .. the
> price and weight from another.
>
> Right now, it can read/access the SQL db... but looks only to the products
> db... where would an example of the sql.. item tags.. be found ?
>
>
> thanks
>
> Tyler K.
> Team OneStop
>
> At 02:22 AM 5/21/99 -0400, you wrote:
> >****** message to minivend-users from mikeh@minivend.com ******
> >
> >Quoting G. Tyler Koblasa (gtyler@onestop.net):
> >>
> >> Greetings...
> >>
> >> The dilemma I am encountering now is that minivend looks for specific
> >> fields inside the products table. The SQL server currently has a few other
> >> tables installed, which contain the description, weight, and price... the
> >> needed content for the products table.
> >>
> >> I do not believe there is a way to create a link from lets say the weight
> >> field in Products on over to the weight field in Someothertable. is
> there ?
> >>
> >> if not.. i believe it would be most practical, as opposed to copying all
> >> data into this new table, to modify the SELECT query it uses to obtain the
> >> needed info.
> >> how might someone accomplish this ?
> >>
> >
> >Hi,
> >
> >I can tell you why you might not be getting an answer. I for one can't figure
> >out what you are talking about. 8-)
> >
> > [item-field weight] and [item-data products weight] are usually the same
> >
> > [item-data othertable weight] is just as valid
> >
> > Shipping table can contain othertable::weight as a field
> >
> >What do you mean by "link"? Why are you talking about adjusting
> >SQL queries? What is the *data* you are trying to access? Just go
> >and get it and put it where it belongs.
> >
> >--
> >Mike Heins http://www.minivend.com/ ___
> > Internet Robotics |_ _|____
> > 131 Willow Lane, Floor 2 | || _ \
> >It's a little-known fact Oxford, OH 45056 | || |_) |
> >that the Y1K problem caused <mikeh@minivend.com> |___| _ <
> >the Dark Ages. -- unknown 513.523.7621 FAX 7501 |_| \_\
> >-
> >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
> >
>
> --
> http://onestop.net
> Your OneStop Network
> 'a full service internetworking firm'
>
> Tel 805.895.1001 Fax 805.685.5541
>
> we offer a OneStop solution for:
> Development / Web Hosting / ECommerce / Marketing / Internet Radio
> Broadcasting and ...
> a Free Home on the Net! (including Free Email services)
> -
> 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
