RE: [plum] Using DisplayList with Custom Queries

[Mark Fuqua]

Hey anne,

 

I have never been able to get this to work either.  But if you are so inclined, you can build your own page with the same look and feel as a PLUM page.  This really does not answer your inquiry, but like I said, I have never been able to get the custom query to work.  This is how I do it.  Not what you are looking for...but at least it is something.

 

 

 

THERE IS A BUNCH OF CODE ABOVE HERE, BUT WHAT IS BELOW IS WHAT I WANTED TO SHOW YOU.  NOTE THE **AND CAP LETTERS THROUGH OUT.  IF YOU DON'T ALREADY KNOW ABOUT THESE ITEMS, IT WILL HELP ALOT.

 

<table cellspacing="0" cellpadding="0" border="0" width="100%"> **SET SPACING AND PADDING TO 0 OR THERE WILL BE SPACES BETWEEN CELLS
 
 <tr>
  <td class="listlabel" colspan="6">Daily Tasks</td> ** CLASS="listlabel" WITH <th> BELOW WILL LOOK JUST LIKE PLUM LIST.

 </tr>
 <tr>
  <th class="centeralign">Include</th>
  <th class="centeralign">#of times</th>
  <th class="centeralign">Ref. No.</th>
  <th class="leftalign">Task Name</th>
  <th class="leftalign">Labor Rate</th>
  <th class="rightalign">No. Min.</th></tr>
   <cfoutput>
   <cfset i=1>
   <form name="form1" action="" method="post">
   <cfloop query="dailytask">
 
   <tr class="#Application.Formatting.AlternateRowShading(currentRow)#">    **THIS DOES THE ALTERNATE ROW SHADING
    <td class="centeralign"><input name="check#i#" type="checkbox" ></td>
    <td class="centeralign"><input name="number#i#" type="text" size="1" value="1" >
   </td>
    <td class="centeralign">#dailytask.DailyTaskId#
    <input type="hidden" name="dailyTaskId#i#" value="#DailyTask.DailyTaskId#" >
   </td>
   <td>#dailyTask.TaskName#
   <input type="hidden" name="taskname#i#" value="#dailytask.taskName#">
   </td>
   <td>#dailyTask.LaborRate#
   <input type="hidden" name="laborRate#i#" value="#DailyTask.LaborRate#">
   </td>
   <td class="rightalign">#dailyTask.NumberMinutes#
   <input type="hidden" name="numberMinutes#i#" value="#dailyTask.NumberMinutes#">
   </td></TR>
   <cfset i = i+1>
    </cfloop></table>
    <input type="hidden" name="maxValue" value="#i#"></cfoutput>
  <input type="submit" name="submit" value="submit">
</form>
<cfmodule template="#Request.layout#/Footer.cfm">

 

Hope that helps some.  I am looking foward to figuring out the custom query thing myself as well.

 

Mark

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Anne Girardeau
Sent: Monday, November 21, 2005 4:55 PM
To: plum@mail.productivityenhancement.com
Subject: [plum] Using DisplayList with Custom Queries

Does anyone have an example of how to use a Custom Query with DisplayList?  I've been battling with this for awhile and keep getting various errors which is a good indication that I'm not doing something right.

 

Thanks so much,

--Anne

Confidentiality Notice: This E-Mail transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the E-Mail address. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or reliance upon the contents of this E-Mail is strictly prohibited. If you have received this E-Mail transmission in error, please reply to the sender, so arrangements can be made for proper delivery, and then delete the message from your system. Thank you.

********************************************************************** 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 **********************************************************************