Maybe it is simple, but I need a combined search (ASP)

[smercado98]

I am a beginner in Dreamweaver Ultradev. Maybe it is too simple but I need help. I don't know how to do a combined search. I need to select a Country in a database and all the information of this country related to art, geography or history.

In this case the field country is named "pais" and the other field (art, geography, etc) is "rubro". Recordset is named RS_findrubros and Table name is "rubros"

My problem is that I don't know how to write this search. In a simple search, I use "var1" to menu/list "country"

I dont'n know if I have to name "var2" to "rubro" field.

On the other hand, I've used "MMColParam" related to "var1", but in this example, I don't know what SQL parameters I have to use:

If somebody could help me and tell me how can I sustitute the following parameters:

name: RS_findrubros

connection: conexion_rubros

SQL:
SELECT*
FROM rubros
WHERE rubro = 'MColParam'
ORDER BY nombre ASC

variables: + -
Name Default Value Run-Time Value
MMColParam Historia Request.QueryString ('var1')

 

[schase]

hey Smerc,

Probably better to hand code one I'm guessing - I've never done one. But I took a browse over in the ASP forum here and found a few for you to take a look at.

thread333-84983 "Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart

 

[schase]

shoot that only did one.

well here they are again.

thread333-84983 another

thread333-26085 yet another

thread333-26065 how that works "Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart

 

[gcastillo]

You need to use a query like this:
SELECT tblNegocio.nombreNegocio, tblGiro.giroNegocio
FROM tblGiro INNER JOIN tblNegocio ON tblGiro.claveGiro = tblNegocio.claveGiro;

In this example, the tblnegocio has the data for the negocio, and the key of the Giro. In the table tblGiro are the descriptions of the giro, with the respective Key. The querie shows the negocio data AND the description of the Giro. You need to make the relationships in Access. Hope this helps.