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