|
Home > Archive > IIS ASP > August 2004 > One SQL, two conns
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
One SQL, two conns
|
|
| Stuart Palmer 2004-08-29, 2:48 am |
| Hi There,
I'm writing an ASP cart and hit a problem.
I have 2 db's, one is products, one is cart contents.
Cart contents holds the unique ID from products when you do your 'basket'.
When I display the basket, I want to display the products name from the
products DB based on the ID stated in the cart DB
I have been informed I can do this with SQL some how, but that means I'd
have to create two conn objects? or can it be done another way?
Thx for the advise.
Stu
| |
| Pauline Parrot 2004-08-29, 2:48 am |
| You can put the first recordset in an array, then get the second
"Stuart Palmer" <stuartglenpalmer@ntlworld.com> wrote in message
news:_leYc.9$fU3.6@newsfe6-win.ntli.net...
> Hi There,
> I'm writing an ASP cart and hit a problem.
>
> I have 2 db's, one is products, one is cart contents.
>
> Cart contents holds the unique ID from products when you do your 'basket'.
>
> When I display the basket, I want to display the products name from the
> products DB based on the ID stated in the cart DB
>
> I have been informed I can do this with SQL some how, but that means I'd
> have to create two conn objects? or can it be done another way?
>
> Thx for the advise.
>
> Stu
>
>
| |
|
| On Sun, 29 Aug 2004 06:04:42 GMT, "Stuart Palmer"
<stuartglenpalmer@ntlworld.com> wrote:
>Hi There,
>I'm writing an ASP cart and hit a problem.
>
>I have 2 db's, one is products, one is cart contents.
>
>Cart contents holds the unique ID from products when you do your 'basket'.
>
>When I display the basket, I want to display the products name from the
>products DB based on the ID stated in the cart DB
>
>I have been informed I can do this with SQL some how, but that means I'd
>have to create two conn objects? or can it be done another way?
>
>Thx for the advise.
>
>Stu
>
2 DBs or 2 tables in 1 DB ?
what DB are you using access?
for SQL (as I've never used access) you would join the 2 tables
together to get the result. since I don't know your Table layouts
(Provide DDL) I'm just guessing.
SELECT p.ProdID, p.ProdName, b.Quantity, p.Price, (b.Quantity*p.Price)
as Total
FROM basket b INNER JOIN
Products p ON b.ProdID = p.ProdID
WHERE b.MemberID = 23 -- user number of logged in person.
HTH.
Al.
| |
| Manohar Kamath [MVP] 2004-08-29, 5:51 pm |
| Stuart,
A good practice is to connect to only one database, and take advantage of
connection pooling. You can create views in your product table, to the
tables within cart database. This way, you can just connect to one database.
--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Stuart Palmer" <stuartglenpalmer@ntlworld.com> wrote in message
news:_leYc.9$fU3.6@newsfe6-win.ntli.net...
> Hi There,
> I'm writing an ASP cart and hit a problem.
>
> I have 2 db's, one is products, one is cart contents.
>
> Cart contents holds the unique ID from products when you do your 'basket'.
>
> When I display the basket, I want to display the products name from the
> products DB based on the ID stated in the cart DB
>
> I have been informed I can do this with SQL some how, but that means I'd
> have to create two conn objects? or can it be done another way?
>
> Thx for the advise.
>
> Stu
>
>
| |
| Stuart Palmer 2004-08-29, 5:51 pm |
| Hi Harag,
Thx for the info, I know about Joining two tables in a DB together, but
I have two seperate MDB files (Yes, access. I don't have SQL server :o( ).
Have you opened two SQL Server Db's at the same time and managed to get
data from each? (A kind of JOIN but for mbd queries)
Thx
Stu
"Harag" <haragREMOVETHESECAPITALS@softhome.net> wrote in message
news:g593j0d2jdgsqkasv6tjhoo3ukucl8p78i@
4ax.com...
> On Sun, 29 Aug 2004 06:04:42 GMT, "Stuart Palmer"
> <stuartglenpalmer@ntlworld.com> wrote:
>
'basket'.[vbcol=seagreen]
>
> 2 DBs or 2 tables in 1 DB ?
> what DB are you using access?
>
> for SQL (as I've never used access) you would join the 2 tables
> together to get the result. since I don't know your Table layouts
> (Provide DDL) I'm just guessing.
>
> SELECT p.ProdID, p.ProdName, b.Quantity, p.Price, (b.Quantity*p.Price)
> as Total
> FROM basket b INNER JOIN
> Products p ON b.ProdID = p.ProdID
> WHERE b.MemberID = 23 -- user number of logged in person.
>
>
> HTH.
>
> Al.
>
>
>
| |
| Stuart Palmer 2004-08-29, 5:51 pm |
| Thx,
I think I understadn what you mean, but I am not quite understanding.
I have MDB db's. Are you saying I should be able to somehow add something to
the products MDB to state that I want it to connect to the other in some
manner?
Do you have a link to anything on the web that might be able to explain this
better? I have looked up connection pooling on the www but it offers me no
example (code/process for me to do this except enabling and disabling
it....which is done on the server (my Host won't let me do this I don't
think :o( )
Thx again
Stu
"Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> wrote in message
news:OEzbnKdjEHA.3608@TK2MSFTNGP09.phx.gbl...
> Stuart,
>
> A good practice is to connect to only one database, and take advantage of
> connection pooling. You can create views in your product table, to the
> tables within cart database. This way, you can just connect to one
database.
>
> --
> Manohar Kamath
> Editor, .netWire
> www.dotnetwire.com
>
>
> "Stuart Palmer" <stuartglenpalmer@ntlworld.com> wrote in message
> news:_leYc.9$fU3.6@newsfe6-win.ntli.net...
'basket'.[vbcol=seagreen]
>
>
| |
| Bob Barrows [MVP] 2004-08-29, 5:51 pm |
| Look up "linked tables" in Access online help.
Bob Barrows
Stuart Palmer wrote:[vbcol=seagreen]
> Thx,
> I think I understadn what you mean, but I am not quite understanding.
> I have MDB db's. Are you saying I should be able to somehow add
> something to the products MDB to state that I want it to connect to
> the other in some manner?
>
> Do you have a link to anything on the web that might be able to
> explain this better? I have looked up connection pooling on the www
> but it offers me no example (code/process for me to do this except
> enabling and disabling it....which is done on the server (my Host
> won't let me do this I don't think :o( )
>
> Thx again
> Stu
>
> "Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> wrote in
> message news:OEzbnKdjEHA.3608@TK2MSFTNGP09.phx.gbl...
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
|
|
|
|
|