You could add control like this... and you would then have the ability to manage 
certain pages that dealt with multiple articles of content.

SELECT content FROM contentTable
WHERE circuit = '#fusebox.thisCircuit#' 
        AND switch = '#fusebox.fuseaction#'
        AND item = '#cfparam("attributes.item",0)#'

You can grab the cfparam udf at cflib.org along with many other good udfs. If you do 
not know how to number items... use the maxID technology from fusebox and modify it to 
manage your content. Zero would be default.

John Farrar

>>> [EMAIL PROTECTED] 03/25/02 05:26PM >>>
I don't have the exact layout of the Fusebox structure in front of me,
but wouldn't it be something like

SELECT content FROM contentTable
WHERE circuit = '#fusebox.thisCircuit#' 
        AND switch = '#fusebox.fuseaction#'

---
Billy Cravens


-----Original Message-----
From: Rob C [mailto:[EMAIL PROTECTED]] 
Sent: Monday, March 25, 2002 3:51 PM
To: [EMAIL PROTECTED] 
Subject: Dynamic Queries Based on V3 Fuseaction Circuit and Switch

Is this possible? I have one circuit dedicated to all of my subpages. 
This circuit has its own layout. What I did is I added 2 columns to my 
content table in my db. One column is called circuit one is called 
switch. Now based on my fuseaction that directs the user to the correct 
page I want to pull the correct data from the database. But I have no 
idea how to write this. Any help would be appreciated.

Thanks,
Rob

Why do I do this to myself?

==^================================================================
This email was sent to: [email protected]

EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9
Or send an email to: [EMAIL PROTECTED]

T O P I C A -- Register now to manage your mail!
http://www.topica.com/partner/tag02/register
==^================================================================

Reply via email to