queryName.columnList ? -Adam
On Tue, 30 Nov 2004 11:18:03 -0400, Ian Littlefair <[EMAIL PROTECTED]> wrote: > 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 Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185675 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
