Still strugling on this one

[Andy]

Sorry for posting again, but i'm very much stuck :-(

Here's the problem.

I have three tables: Products - Retailers - Prices

When i enter a new retailer they don't have any products.
What i want to do is populate the new retailer with all of the productID's
from the products table.
I'm at the stage where i can enter a new retailer, create a session for the
new retailer "UserID".

Now i need to somehow enter all of the productID's into the retailer based
on the session "UserID"

I've read the one or two replies from previous posts, but can't get any of
them working.

Help! before i go bald(er)

Andy

[darrel]

> Now i need to somehow enter all of the productID's into the retailer based

> on the session "UserID"

I think what you want is another table that connects retailers to products.

-Darrel

[Andy]

Hi Darrel
I do have a linking table that links the retailer with the products. This is
the Price table.

Thanks
Andy


"darrel" <notreal@hotmail.com> wrote in message
news:d48grf$gof$1@forums.macromedia.com...

>> Now i need to somehow enter all of the productID's into the retailer
>> based
>> on the session "UserID"

>
> I think what you want is another table that connects retailers to
> products.
>
> -Darrel
>
>
>

[darrel]

> Hi Darrel

> I do have a linking table that links the retailer with the products. This

is

> the Price table.

OK. Well, I'm not completely clear on what you are trying to do.

So, when a person enters a new retailer into the retailer table, you then
want to automatically enter a retalier+product relationship in the price
table for every item?

-Darrel

[Paul Whitham TMM]

Andy

If every retailer can sell every product then why are you creating this
table anyway. It seem to me a pointless exercise unless you are going to
limit them, or allow different prices.

BTW did the code I posted not work.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Andy" <AndyjhughesNOSPAM@ntlworld.com> wrote in message
news:d48gav$fut$1@forums.macromedia.com...

> Sorry for posting again, but i'm very much stuck :-(
>
> Here's the problem.
>
> I have three tables: Products - Retailers - Prices
>
> When i enter a new retailer they don't have any products.
> What i want to do is populate the new retailer with all of the productID's
> from the products table.
> I'm at the stage where i can enter a new retailer, create a session for

the

> new retailer "UserID".
>
> Now i need to somehow enter all of the productID's into the retailer based
> on the session "UserID"
>
> I've read the one or two replies from previous posts, but can't get any of
> them working.
>
> Help! before i go bald(er)
>
> Andy
>
>
>

[Andy]

Hi Paul
Each retailer will have his/her own pricing structure.
I tried your code but kept getting this error:

Microsoft JET Database Engine (0x80040E0C)
Command text was not set for the command object.
/MyWebs/Dynamic Brochure/adm1n/new_retailer_populate.asp, line 16

Line 16 is: set adoRs=adoCn.Execute(srtSQL)


Thanks again
Andy



"Paul Whitham TMM" <paul@valleybiz.net> wrote in message
news:d4993s$n7l$1@forums.macromedia.com...

> Andy
>
> If every retailer can sell every product then why are you creating this
> table anyway. It seem to me a pointless exercise unless you are going to
> limit them, or allow different prices.
>
> BTW did the code I posted not work.
>
> --
> Regards
>
> Paul Whitham
> Macromedia Certified Professional for Dreamweaver MX2004
> Valleybiz Internet Design
> [url]www.valleybiz.net[/url]
>
> Team Macromedia Volunteer for Ultradev/Dreamweaver MX
> [url]www.macromedia.com/support/forums/team_macromedia[/url]
>
> "Andy" <AndyjhughesNOSPAM@ntlworld.com> wrote in message
> news:d48gav$fut$1@forums.macromedia.com...

>> Sorry for posting again, but i'm very much stuck :-(
>>
>> Here's the problem.
>>
>> I have three tables: Products - Retailers - Prices
>>
>> When i enter a new retailer they don't have any products.
>> What i want to do is populate the new retailer with all of the
>> productID's
>> from the products table.
>> I'm at the stage where i can enter a new retailer, create a session for

> the

>> new retailer "UserID".
>>
>> Now i need to somehow enter all of the productID's into the retailer
>> based
>> on the session "UserID"
>>
>> I've read the one or two replies from previous posts, but can't get any
>> of
>> them working.
>>
>> Help! before i go bald(er)
>>
>> Andy
>>
>>
>>

>
>
>

[Paul Whitham TMM]

Looks like a typo in the line. It should be

set adoRs=adoCn.Execute(strSQL)


--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Andy" <AndyjhughesNOSPAM@ntlworld.com> wrote in message
news:d4b2sc$epa$1@forums.macromedia.com...

> Hi Paul
> Each retailer will have his/her own pricing structure.
> I tried your code but kept getting this error:
>
> Microsoft JET Database Engine (0x80040E0C)
> Command text was not set for the command object.
> /MyWebs/Dynamic Brochure/adm1n/new_retailer_populate.asp, line 16
>
> Line 16 is: set adoRs=adoCn.Execute(srtSQL)
>
>
> Thanks again
> Andy
>
>
>
> "Paul Whitham TMM" <paul@valleybiz.net> wrote in message
> news:d4993s$n7l$1@forums.macromedia.com...

> > Andy
> >
> > If every retailer can sell every product then why are you creating this
> > table anyway. It seem to me a pointless exercise unless you are going to
> > limit them, or allow different prices.
> >
> > BTW did the code I posted not work.
> >
> > --
> > Regards
> >
> > Paul Whitham
> > Macromedia Certified Professional for Dreamweaver MX2004
> > Valleybiz Internet Design
> > [url]www.valleybiz.net[/url]
> >
> > Team Macromedia Volunteer for Ultradev/Dreamweaver MX
> > [url]www.macromedia.com/support/forums/team_macromedia[/url]
> >
> > "Andy" <AndyjhughesNOSPAM@ntlworld.com> wrote in message
> > news:d48gav$fut$1@forums.macromedia.com...

> >> Sorry for posting again, but i'm very much stuck :-(
> >>
> >> Here's the problem.
> >>
> >> I have three tables: Products - Retailers - Prices
> >>
> >> When i enter a new retailer they don't have any products.
> >> What i want to do is populate the new retailer with all of the
> >> productID's
> >> from the products table.
> >> I'm at the stage where i can enter a new retailer, create a session for

> > the

> >> new retailer "UserID".
> >>
> >> Now i need to somehow enter all of the productID's into the retailer
> >> based
> >> on the session "UserID"
> >>
> >> I've read the one or two replies from previous posts, but can't get any
> >> of
> >> them working.
> >>
> >> Help! before i go bald(er)
> >>
> >> Andy
> >>
> >>
> >>

> >
> >
> >

>
>
>