Master Detail Page Problem

[singh83]

Hi,

could anyone please help with a problem I've encountered.

I have set up a master detail page using Dreamweaver's 'Insert Master Detail
Page Set' dialog box. The master page contains records displaying 2 fields : 1)
a unique number and 2) a title. The relevant detail page is supposed to display
when you click on the unique number (every record definitely has a unique
record number, as this is automatically generated by the database when the
record is created) in the master page.

The master page displays fine, but when I click on the ID/Unique number of a
record the detail page does not display. I simply get the following error:

Page Cannot be Displayed
HTTP 500 - Internal server error
Internet Explorer

I would really appreciate any help on this.

Thanks,

Sarb.

[Baxter]

After applying the go to detail page from the results page did you go to the
detail page and apply the move to specific record on it?
Dave
"singh83" <webforumsuser@macromedia.com> wrote in message
news:d27ffo$afh$1@forums.macromedia.com...

> Hi,
>
> could anyone please help with a problem I've encountered.
>
> I have set up a master detail page using Dreamweaver's 'Insert Master

Detail

> Page Set' dialog box. The master page contains records displaying 2 fields

: 1)

> a unique number and 2) a title. The relevant detail page is supposed to

display

> when you click on the unique number (every record definitely has a unique
> record number, as this is automatically generated by the database when the
> record is created) in the master page.
>
> The master page displays fine, but when I click on the ID/Unique number

of a

> record the detail page does not display. I simply get the following error:
>
> Page Cannot be Displayed
> HTTP 500 - Internal server error
> Internet Explorer
>
> I would really appreciate any help on this.
>
> Thanks,
>
> Sarb.
>

[singh83]

Hi,
thanks for the reply.
i used dreamweaver's built in mechanism, which writes all the code and server
scripts for me. I exactly followed the tutorial in dreamweaver's help on
building a master/detail page. I did the tutorial successfully, just don't know
what the problem is with this.

However, I have just realised that in my recordset in the detail page there is
an error. The query in detail page is (all automated by dreamweaver using
recordset dialog box):
SELECT*
FROM [Bug Report]
WHERE Bug ID = MMColParam

and the variables are:
Name Default Value Run-Time
Value
MMColParam 1
Request.QueryString("Bug ID")

I think the problem may be that I do not have a record in my database with an
ID value of 1 and this is the default value. If I try to change this to a value
that does exist e.g. 6, I get the error:

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'Bug ID = 6'.

Does this help?

Thanks,
Sarb.

[singh83]

sorry, the variables in the previous message do not appear clearly. It should say:
Name: MMColParam
Default Value: 1
Run-Time Value: Request.QueryString("Bug ID")

Sarb.