Need help.count total data from 2 database

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 429,971 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,565 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 1031 | Replies: 0

•

Join Date: Mar 2007

Posts: 1

Reputation: toeffendi is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

toeffendi

Offline

Newbie Poster

Need help.count total data from 2 database

Mar 16th, 2007

have 2 database
1. list of product = product type & Product catalog
-------------------------
product type Product catalog
AA a1
BB b1
-------------------------

2. Detail of product = product catalog & detail product
-------------------------
Product
catalog detail
a1 1
a1 1
a1 1
b1 1
b1 1
b1 1
b1 1
-------------------------
<%
Dim product__MMColParam
product__MMColParam = "Product"
If (Request("MM_EmptyValue") <> "") Then
product__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim product
Dim product_numRows

Set product = Server.CreateObject("ADODB.Recordset")
product.ActiveConnection = MM_data_STRING
product.Source = "SELECT * FROM list of product WHERE Product_type = '" +

Replace(product__MMColParam, "'", "''") + "' ORDER BY Product_catalog ASC"
product.CursorType = 0
product.CursorLocation = 2
product.LockType = 1
product.Open()

product_numRows = 0
%>
<%
Dim Rec_count__MMColParam
Rec_count__MMColParam = "a1"
If (Request("MM_EmptyValue") <> "") Then
Rec_count__MMColParam = Request("MM_EmptyValue")
End If
%>
<%