ASP and databse

[jdm3]

after I have created a database, as followed Table products.mdb

I have the product category displaying fine and the search works fine also,
here is what I have, I want to include the search to perform a defined search, but don't know how to include other tables that are already existing in the products.mdb such as,

TblCountyID
ProvinceID
TblCityID

This is what I need to add below so that when we select Canada in a dropdown lost then selcting, a Province and then a City, So that after the search you are only retreiving the required fields. I can sure use some help on this.


Default.asp:

<!-- #INCLUDE FILE=&quot;adovbs.inc&quot; -->
<%
' Get Current Category
cat = TRIM( Request( &quot;cat&quot; ) )
IF cat = &quot;&quot; THEN cat = &quot;Home&quot;

' Get Search Phrase
searchFor = TRIM( Request( &quot;searchFor&quot; ) )


' Get Current Category
cat = TRIM( Request( &quot;cat&quot; ) )
IF cat = &quot;&quot; THEN cat = &quot;Home&quot;

' Open Database Connection
Set Con = Server.CreateObject( &quot;ADODB.Connection&quot; )
Con.Open &quot;accessDSN&quot;
' Open Recordset with Static Cursor
Set RS = Server.CreateObject( &quot;ADODB.Recordset&quot; )
RS.CursorType = adOpenStatic
RS.ActiveConnection = Con
RS.Open &quot;Select * FROM Products&quot;
' Display Count of Products
Response.Write &quot;Number of products: &quot;
Response.Write RS.RecordCount
%>

 

[Veep]

I'm not real clear on this. Are you asking how to join tables in a SQL statement?

 

[jdm3]

Yes I am looking for how I would write the asp codes

 

[Veep]

Here are some SQL tutorial links:

http://www.sqlcourse.com/

http://www.w3schools.com/sql/default.asp

http://www.1keydata.com/sql/sql.html

http://sqlzoo.net/

You can also open your version of MSAccess and go to the Help Index. Type in &quot;Join&quot; and it will give you several examples.

The coding of the SQL statements for joins wouldn't be any different from what you already have &quot;Select * From Products&quot;. The thing that would be different is the actual SQL statement.

 

[jdm3]

Yeah But that reading does not get me off the ground, all I am looking for the position and codes for the statement I made above, could someone please look at this and tell me what I need to change in these codes to make my search to include dropdowns, with CountryID and CityID

I have the product category displaying fine and the search works fine also,
here is what I have, I want to include the search to perform a defined search, but don't know how to include other tables that are already existing in the products.mdb such as,

TblCountyID
ProvinceID
TblCityID

This is what I need to add below so that when we select Canada in a dropdown lost then selcting, a Province and then a City, So that after the search you are only retreiving the required fields. I can sure use some help on this.


Default.asp:

<!-- #INCLUDE FILE=&quot;adovbs.inc&quot; -->
<%
' Get Current Category
cat = TRIM( Request( &quot;cat&quot; ) )
IF cat = &quot;&quot; THEN cat = &quot;Home&quot;

' Get Search Phrase
searchFor = TRIM( Request( &quot;searchFor&quot; ) )


' Get Current Category
cat = TRIM( Request( &quot;cat&quot; ) )
IF cat = &quot;&quot; THEN cat = &quot;Home&quot;

' Open Database Connection
Set Con = Server.CreateObject( &quot;ADODB.Connection&quot; )
Con.Open &quot;accessDSN&quot;
' Open Recordset with Static Cursor
Set RS = Server.CreateObject( &quot;ADODB.Recordset&quot; )
RS.CursorType = adOpenStatic
RS.ActiveConnection = Con
RS.Open &quot;Select * FROM Products&quot;
' Display Count of Products
Response.Write &quot;Number of products: &quot;
Response.Write RS.RecordCount
%>