Hi.

I have problem to extract correct data from a detail page.

Here is my query in the record set:
----------------------------------
SELECT klubb1.teamId, klubb1.teamname, klubb1.bosted,
klubb1.contactperson, klubb1.telefon, dfloy.floynavn, drom.etasje,
drom.romnavn, drom.aktiv

FROM KLUBB1, dfloy, drom

WHERE klubb1.TeamId = drom.teamid and dfloy.FloyID = drom.FloyID and
klubb1.TeamID = 'MMColParam'

ORDER BY RomID
--------------------------------
The variables look like this:

Name = MMColParam
Default value = 130
Run-time value = ReQuest.QueryString("klubb1.TeamID"

When I change the default value and click the test botton everything works
fine.
---------------------
From the masterpage: altaturneringen.no/_asp/html/bosted_index.asp
I have a link to the detail page.
altaturneringen.no/_asp/html/bopel.asp?TeamId=155
(The default value is TeamID=130, The page will not give me the TeamID=155)

In the detail page I have set the "move to specific record", but the detail
page shows just the default value.

I can not find out what's wrong. My be it is because I do the query from
three tables.

Please help me if you can.

Wenche Jensen.<font face='Courier New'></font id='Courier New'>

Edited by - on 01 Aug 2004 02:23:13

Edited by - on 01 Aug 2004 02:26:59

Hi,

You have a problem in the querystring set in the runtime variable, change it to the following:

Name = MMColParam
Default value = 130
Run-time value = ReQuest.QueryString("TeamID"

Regards
Vince

DMX Talkzone Manager

Visit my home: www.chez-vince.com
(Now completely CSS based and bye bye to all tables!)

VBScript | ASP | HTML | CSS | SQL | Oracle | Hosting