No problem Jeff. It gave me the needed imptus to learn about listlabel, and alternate row shading. Now I am able to make a list or add form that looks just like lists and forms made with plum custom tags.
I am not yet familar with cfscript, would this accomplish the same thing? <cfquery name = vesselName datasource="#dsn#"> SELECT vesselId AS Vessel_VesselId, VesselName AS Vessel_VesselName.... ...</cfquery> Thanks for all your time on the list Jeff. One day I'll start answering as many ?'s as I ask. Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Fleitz Sent: Wednesday, September 21, 2005 10:53 AM To: [email protected] Subject: Re: [plum] custom query with <cf_displayViewForm> Hi Mark, Sorry for the late response. Your problem is the way you have to handle custom query column references in Plum. In your custom query you have to alias each column name as "table_column" in order for your control tags to pick up the columns correctly. Here is an example: <cfscript> qryResult = Application.DatabaseBlocks.SelectRecords( selectClause:"VesselID AS Vessel_VesselID,VesselName AS Vessel_VesselName", fromClause:"Vessel", whereClause:"VesselID = #URL.VesselID#"); </cfscript> Notice how the columns are aliased in the format I described. This is a known issue and will be removed in the next version of Plum, but for right now this should work fine for you if you use the "table_column" aliasing convention. v/r, Jeff Mark Fuqua wrote: > Has anyone else had trouble with using the custom query attribute on > <cf_DisplayViewForm> tag? > > I can not seem to get PLUM to not run the database block query and use mine > instead. > > I throws an error if I do not put <cf_PrimaryKey> in and if I do, it runs > the database blocks query with where = 0. > > It is running the query, and a cfdump shows the result is correct, Plum just > seems determined to use the Database Blocks generated query. > > Am I doing something wrong, or is there a workaround? > > Thanks, > > Mark > > > > > > > ********************************************************************** > 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 **********************************************************************
