heya ppls,
I've encountered a prob with Q of Q's and wondered if anyone else has had the same
prob.
I'm querying my DB then using querySetCell to add further values.
Then needed to re-order my query with the new values.
<!--- original query looks like --->
<cfquery name="getValueData" datasource="#request.datasource#">
SELECT DISTINCT valueID, valueName, '' as valueAddress, '' as
valueStaff
</cfquery>
<cfoutput query="getValueData">
<cfset
querySetCell(getValueData,"valueAddress",variables.thisAddress,getValueData.currentRow)>
<cfset
querySetCell(getValueData,"valueStaff",variables.thisStaffName,getValueData.currentRow)>
</cfoutput>
<!--- original output has data as expected --->
<cfoutput query="getValueData">
valueID = 345,
valueName = someValue,
valueAddress = Fifteenth st,
valueStaff = Jeff Strong
</cfoutput>
<!--- now use Q of Q to order this query --->
<cfquery name="getValueData2" dbtype="query">
SELECT valueID, valueName, valueAddress, valueStaff
FROM getValueData
ORDER BY valueStaff
</cfquery>
<!--- output now returns the following --->
<cfoutput query="getValueData2">
valueID = 345,
valueName = so,
valueAddress = Fi,
valueStaff = Je
</cfoutput>
Anyone else ever had the same experience?
Thanx in advance
Drew
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
