Urgent Dayabase Help Required

[pepps]

HI There urgent help needed

I am currently hosting two of our company websites, they are similar websites and both share the same database.

The database folder is in the root directory of site 1 also all the admin pages for uploading to the two different sites are also located in site 1.

The problem i have is this: I add products to the database via the admin pages the products could either be related to site 1 or site 2, i am also using the newest version of Pure asp upload so i can attach datasheets to the various products.

Once i have added products to site 1 and click on the product i am looking for it then gives me a link to where the datasheet resides for this particular site it is fine the path would be "domainname\pdfs\products" i can then click on the dynamic link which returns the file.

IF however i have added products to site2 via the admin pages in site1, serach for a product and need to pull up the associated datasheet the url looks like this "site2\pdfs\products" everything in that path is correct except the path should be site1 not site 2 as that is where all the datasheets are stored.

How then is it possible to acheive this.

Thanks

John Pepper

[Newsgroup_User · Accepted solution]

I believe the easy way to fix your problem on Site 2 is to manually modify
the dynamic link to point to Site1 using a full URL.

I am assuming you are only storing the name of the document, if that is so
then you probably see something like this for the link:

<a href="<%=(RS_YOURNAME.Fields.Item("YOURCOLUMN").Value)%>">LINK NAME</a>

change it to:

<a
href=" http://www.SITE1.com\pdfs\products\<%=(RS_YOURNAME.Fields.Item("YOURCOLUMN").Value)%>">LINK
NAME</a>

Let us know if that works for you.




"pepps" <webforumsuser@macromedia.com> wrote in message
news:eqq0i0$q15$1@forums.macromedia.com...
> HI There urgent help needed
>
> I am currently hosting two of our company websites, they are similar
> websites
> and both share the same database.
>
> The database folder is in the root directory of site 1 also all the admin
> pages for uploading to the two different sites are also located in site 1.
>
> The problem i have is this: I add products to the database via the admin
> pages
> the products could either be related to site 1 or site 2, i am also using
> the
> newest version of Pure asp upload so i can attach datasheets to the
> various
> products.
>
> Once i have added products to site 1 and click on the product i am looking
> for
> it then gives me a link to where the datasheet resides for this particular
> site
> it is fine the path would be "domainname\pdfs\products" i can then click
> on the
> dynamic link which returns the file.
>
> IF however i have added products to site2 via the admin pages in site1,
> serach
> for a product and need to pull up the associated datasheet the url looks
> like
> this "site2\pdfs\products" everything in that path is correct except the
> path
> should be site1 not site 2 as that is where all the datasheets are stored.
>
> How then is it possible to acheive this.
>
> Thanks
>
> John Pepper
>
>