I need to run a trim against every field that comes back from a particular query.
I'm trying to loop over each record, and then loop over each field, trim it and put it
back.
Here's the code.
<CFQUERY NAME="qryParAddress" datasource="#dsnName#" password="#dsnPassword#"
username="#dsnUsername#">
SELECT *
FROM tablename
</CFQUERY>
<cfloop query="qryParAddress">
<cfloop collection=#qryParAddress# item="currStudent">
<cfif len(trim(StructFind(qryParAddress, currStudent)))>
<cfset qryParAddress[currStudent] =
Trim(qryParAddress[currStudent])>
</cfloop>
</cfloop>
I'm concerned only about the <cfloop> part. Just assume the <cfquery> is all fine.
(This is not the query I'm actually using, and I'm certainly not actually doing a
SELECT *)
Please don't suggest a long list of individual field names being trimmed. There are
too many of them.
Its a CFC being called from flash, so debugging info is minimal. This is the error it
gave back to the flash net connection debugger:
....description: "Service threw an exception during method invocation: null"
.....details: "Service threw an exception during method invocation:
null:java.lang.UnsupportedOperationException:java.lang.UnsupportedOperationException
Can anyone see the error in what I'm doing?
Regards
Darren Tracey
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
