>Stephen Moretti (cfmaster) wrote: > >Oh! Meant to say..... > >You should still be able to access that :B1 column inside a >cfloop/cfoutput, like this : searchResults[":B1"] > >Stephen
Thanks. To give you some background I don't have any control over the SP. I'm using the user credentials that gives them access to another application as a form front-end to access some dynamic reports. I've had a look at the SP and with my limited knowledge of Oracle SP's it looks as though the column id's are created based on what the user's enter. column :B1 is created if the user's login details are ok. "Y" is then "dumped" into the column. column 'N'(single quotes)is created if the user enters an incorrect password. This produces an "N". column 'A' is created if the user exceeds three attempts to login. This produces an "A". column 'W' is created if the passworrd is due to expire soon. This produces a "W". column P_KEY remains the same. In CF I assume I'll have to check to see if the column-name exists first and then use the character returned to allow access or return a message. I've not yet figured that one out yet! Ian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185783 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
