SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 1265 | Next

Joseph W. Lowery

"Dreamweaver CS3 Bible"


To create a detail page filter, you declare a variable and add a WHERE clause referencing that variable. The
runtime value portion of the variable is different for each server model. Assume that you want to declare a
variable called theBrand, and the field is named Brand. In the Variables section of the Advanced Recordset
dialog box, click the Add (+) button and then enter the following values, according to your server model:
Server Model Name Default Value Runtime Value
ASP and .NET theBrand % Request.QueryString(???Brand???)
ColdFusion theBrand % #URL.Brand#
JSP theBrand % request.getParameter(???Brand???)
PHP TheBrand %
In this example, the WHERE clause would read:
WHERE Brand = ???theBrand??™
If you have already created a URL-parameter filtered recordset in the simple Recordset dialog box and then
switch to the Advanced mode, you will notice that Dreamweaver uses the variable name MMColParam. You
can continue to use this variable name or change it to something more meaningful if you prefer.
TIP TIP
733
Crafting Multiple-Page Applications 23
Using a server behavior to filter a recordset
As noted earlier, the other method for connecting a master page with a detail page involves using a
Dreamweaver server behavior.


Pages:
1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277