Forums

PHP

This topic is locked

PHP Master Detail Page Set Problem :(

Posted 24 May 2003 13:04:22
1
has voted
24 May 2003 13:04:22 Peter Shankland posted:
Hi,

I am trying to use the PHP Master Detail Page Set Extension that comes with RK2 from Macromedia.

My problem is that I create the Master and Detail pages, and then insert the Application Object and follow the wizard through. Just as the wizard ends I get the error:

<b>SQL type not recognized: "</b>

Please take a look at www.r00x.co.uk/dvdMaster.php for an example of what happens when I then try to use the pages I have just created.

Can someone help as this has got me stumped!

Thanks.

Replies

Replied 26 May 2003 11:08:21
26 May 2003 11:08:21 Allan Kent replied:
heya,

at a first glance you're passing the DVD title through as the disc ID - maybe you should rather give each record in your database an integer based primary key and link to that instead. If you would rather pass the title through as you are, check that you are enclosing the title within quotes in the SQL query in the detail page. I don't have the extension installed at the moment, so I'm not sure whether it's expecting an integer as the ID for the record and not a text string.

allan

Reply to this topic