Not sure about the search page issue. I abandoned using a separate search page a long time ago because I think the
embedded search forms in the list work really well. Have you tried it that way, or is a separate search page a
requirement? Try adding a couple simple search fields on the list and see if it works that way.
Not sure what is up with the kick to the index page. Maybe C2
(churvis-squared) have some ideas.
Jeff
Dirk Marshall wrote:
Not sure if that works or not, when I reference a query in the list
page and hit it from the search page it sends me to the main index
page. Remove the reference and the list comes up fine.
Is there no way from the list page to figure out what the value of
this variable is or is there another variable with the same value?
Attributes.listQuery.TableName_FieldName[currentRow]
Thanks for all your input, I am learning a lot aobut how this is setup.
On Wed, 16 Feb 2005 14:57:39 -0800, Dirk Marshall
<[EMAIL PROTECTED]> wrote:
Jeff, so what you are saying is using the databaseblocks component
create the query for the list instead of going right from the table?
Sounds like it should work. I will give it a try.
Thanks
On Wed, 16 Feb 2005 17:42:38 -0500, Jeff Fleitz <[EMAIL PROTECTED]> wrote:
Not sure whether I understand you, but maybe you should try using a custom
query that uses an outer join to the lookup
you are talking about and reference it in the query attribute of the
DisplayList tag. Then test to see if the column
value is null, and display the link accordingly.
Will that work?
Jeff
Dirk Marshall wrote:
That concept works but I am unsure how to get the variable I need to evaluate.
This is the variable that is in the link as displayed between the
displaylistlinks tag
#Attributes.listQuery.TableName_FieldName[currentRow]#
I need to know if that variable is "" or has data
This variable is in the link as the record key to link to the lookup
table but if I try to access this variable in any other way than in
the specific link format it throws an error saying attributes is
undefined. From what I can interpret the entire link text is pulled
into the cf_displaylistlinks tag and passed to the cf_displaylist
where it is evaluated and the link is passed back.
Thanks
On Wed, 16 Feb 2005 14:20:07 -0500, Adam Churvis
<[EMAIL PROTECTED]> wrote:
Like this:
--------------------------------------------------------------------
<!--- Create a UDF that returns either a hyperlink or an empty string,
depending upon your criteria --->
<cffunction name="IsLink" access="public" returntype="string" output="No">
<cfargument name="arg1" type="numeric" required="yes">
<cfargument name="arg2" type="string" required="yes">
<cfargument name="arg3" type="date" required="yes">
<cfset var myLink = "">
<cfif Arguments.arg3 GT Now()>
<cfset myLink = "[<a href='cfmpage.cfm'>Click Me</a>]">
</cfif>
<cfreturn myLink>
</cffunction>
<cfmodule template="#Request.adminLayout#/Header.cfm" pageType="Database">
<cf_DisplayList table="SomeTable" rowsPerPage="50" label="Example"
displayALinkToThisSearchForm="No">
<cf_PrimaryKey primaryKeyColumn="SomeColumn" primaryKeyType="integer">
<cf_DisplayColumnInList column="AnotherColumn" label="Ex2"
type="varchar(80)">
<cf_DisplayColumnInList column="YetAnotherColumn" label="Ex3"
type="datetime">
<cf_DisplayListLinks add="AddForm.cfm" view="No" edit="EditForm.cfm"
delete="DeleteForm.cfm">
[<a href="AList.cfm?FromDrill=1">Something</a>]
<!--- Call the UDF in the Caller scope --->
#Caller.IsLink(arg1, arg2, arg3)#
</cf_DisplayListLinks>
</cf_DisplayList>
<cfmodule template="#Request.adminLayout#/Footer.cfm">
------------------------------------------------------
Let me know how that works for you.
Respectfully,
Adam Phillip Churvis
Member of Team Macromedia
http://www.ProductivityEnhancement.com
Download Plum and other cool development tools,
and get advanced intensive Master-level training:
* C# & ASP.NET for ColdFusion Developers
* ColdFusion MX Master Class
* Advanced Development with CFMX and SQL Server 2000
----- Original Message -----
From: "Dirk Marshall" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, February 16, 2005 1:34 PM
Subject: [plum] Display link
I am sure there is a simple solution to this I just can't see it at
the moment. I have a link in a list that is a drill down to another
table. I want to hide that link for a record if there is no value in
the linked field otherwise an error comes up if the link is clicked.
The linked lookup field value may not be filled in when the record is
created as it might not be known yet. Anyway within the
cf_displaylistlinks tag I have the following link
[<a
href="#Application.absoluteUrlRoot#/admin/UDOZoneCodes/UDOZoneCodesList.cfm?
UDOZoneCode=#URLEncodedFormat(Trim(Attributes.listQuery.ADD_ZoneInfo_UDOZone
Code[currentRow]))#&FromDrill=1">UDO
Zone Codes</a>]
I thought I would just wrap the link in an if statement doing a check on
the
Attributes.listQuery.ADD_ZoneInfo_UDOZoneCode[currentRow] variable
However it appears that variable is put together in the displaylist
tag and has to be in the link format to be recognized. How do I get
that variable value to validate if it has a value or not? I guess I
really just need to know what scope the variable is in to be able to
find it.
Thanks
Dirk
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
