Problem to extract correct data from a detail page.

Hi there.

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 Default value Run-time value
MMColParam 130
ReQuest.QueryString("klubb1.TeamID")

When I change the default value and click the test botton everything works
fine.
---------------------
From the masterpage: http://altaturneringen.no/_asp/html/bosted_index.asp
I have a link to the detail page.
http://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.

Wenche

I have read a bit in the book "Dreamwever MX Databases" from SYBEX.
Now I'm woundering if I could use INNER JOIN in my SQL query in the record
set.

Wenche.

The reason why it is not working on the webpage is because, you have the
recordset looking for a Request.Querystring("klubb1.TeamID") and you are
passing a Request.Querystring("TeamID")

change the value for the MMColParam to Request.Querystring("TeamID") and it
should work fine.

I would suggest removing 130 from the default value, and this causes problems
when testing, as having a real value always gives you a results, when really
the page would give you an error if you sya used -1 as the default value, and
thus you would know it was not working.


Originally posted by: Newsgroup User
Hi there.

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 Default value Run-time value
MMColParam 130
ReQuest.QueryString("klubb1.TeamID")

When I change the default value and click the test botton everything works
fine.
---------------------
From the masterpage: http://altaturneringen.no/_asp/html/bosted_index.asp
I have a link to the detail page.
http://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.

Wenche

Thank you so much Carl.
Your instructions help me to solve the problem.

Wenche.


"CarlGrint" <webforumsuser (AT) macromedia (DOT) com> wrote

The reason why it is not working on the webpage is because, you have the
recordset looking for a Request.Querystring("klubb1.TeamID") and you are
passing a Request.Querystring("TeamID")

change the value for the MMColParam to Request.Querystring("TeamID") and
it
should work fine.

I would suggest removing 130 from the default value, and this causes
problems
when testing, as having a real value always gives you a results, when
really
the page would give you an error if you sya used -1 as the default value,
and
thus you would know it was not working.


Originally posted by: Newsgroup User
Hi there.

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 Default value Run-time value
MMColParam 130
ReQuest.QueryString("klubb1.TeamID")

When I change the default value and click the test botton everything
works
fine.
---------------------
From the masterpage: http://altaturneringen.no/_asp/html/bosted_index.asp
I have a link to the detail page.
http://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.

Wenche