Re: SQL... other question.

["G. Tyler Koblasa" <gtyler@onestop.net>]

******    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