[angru]

Im writtin' a program, a minor and very simple, for my exam. However, i have one database with three tables in it and have created relations between them.
now my problem is that I can search in the individual tables, but not in all of the through the relations.
My program looks as follows:

Code:

<%
Dim SoegeStreng, skjult, strCriteria, sqlsoeg
SoegeStreng=Request.Form("personnummer")
 
Set rs = Server.CreateObject("ADODB.Recordset")
strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ieusr2\users$\XXXXXX\XXXXXXX\writeaccess\databace.mdb"
 
sqlsoeg = "SELECT * FROM Patientoplysning WHERE Personnummer LIKE '%" & SoegeStreng & "%'" 
AND
sqlsoeg = "SELECT * FROM Sygdom WHERE Personnummer LIKE '%" & SoegeStreng & "%'"
 
rs.Open sqlsoeg, strDSN
 
Response.write RecToTable(rs)
 
rs.Close 
 
set rs=nothing
%>

The Xs in the strDSN is replacesments from the original, because it is private.


Can anybody please help me, i don't know what to do

[CreativeClans]

I don't know ASP, but the query to join the two tables should be something like:

Code:

SELECT * 
FROM Patientoplysning p
INNER JOIN Sygdom s
ON p.Personnummer = s.Personnummer
WHERE Personnummer LIKE '%" & SoegeStreng & "%'"

[angru]

dunno if Im really stupid, but it doesn't work..

[CreativeClans]

I'm sure you're not stupid, and I told you I don't know ASP, so maybe what I wrote isn't correct.
But... what does "doesn't work" mean? An error? No result? A different result from what you expected?

[angru]

It gives me an error 500, and i think that means a code error.. so no result, it will not even show the pagde..