I'm using the following stored procedure and using cfdump to see the output. This is the stored procedure:-
<cfstoredproc procedure="mysp" dataSource="mydsn" username="myusername" password="mypassword"> <cfprocparam value="#Form.username#" cfsqltype="CF_SQL_INTEGER" type="In"> <cfprocparam value="#Form.password#" cfsqltype="CF_SQL_VARCHAR" type="In"> <cfprocresult name="searchResults"> </cfstoredproc> <cfdump var="#searchResults#" > The output from cfdump returns :B1 P_KEY Y 1234567 The "Y" denotes that the user has a normal login. There are three other "flags" that can be returned based on the user's situation "A", "E" or "W" but I don't know what the column names are. How can I reference whether a "Y", "A", "E" or "W" are returned when I don't know the column id's? TIA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185672 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
