Hi all… i have encountered this problematic situation. I have a database with description of some courses (a record per course). I would like to make a page (using asset listing) to generate a list of the course names as hyperlinks, and then when someone clicks on a particuar course, he would go on a page which displays data only about the specific course.
I have managed to successfully connect to the database and see the records as assets… and with ease can generate the asset listing page wiich displays all the records… but i can't find a way to make it display details of a particular record on a page (i mean, individual records… i know how to make a page which displays ALL records with details… but this is not acceptable since this would be an extremely long page!!)
You need to use the new dynamic parameters feature of DB Data Source; available in 3.16 only.
This allows you to pass data to the query via GET or POST vars and use it within the query. Doing this allows your DB Data Source to dynamically return a single value. You can use an asset listing to list this value and display it however you want. Because you know there is only going to be one, you can make it look like a standard page.
that's great… Is there an updated manual for this? or some doucmentation how it's done? (i assume some form of keyword??)
The docs on the Dynamic Params screen show you how to use it. Once you've created them, the Manual Edit mode of the DB Data Source provides a keyword drop-down to help you.
I don't think there is a 3.16 version of the Data Manual yet.