>You can display everything as you want using just the query - why waste the >time to convert the query to something else to do this?
I'm trying to make it reusable so that I can include it wherever I need it. If I use the same name everywhere, db_info and then use that in all my queries, then I can repopulate them easily. But that is certainly the way I may end up doing it. >> I still have the original problem of testing for undefined. > >Well - sort of. Queries aren't "sparse" arrays - their values should always >be "empty space" (although I think exceptions can arise when you build the >queries from scratch). when I populate that struct, when I set the info to whatever is in the db, the first time it comes to a variable in a form (value='#db_info.blah#') that was populated by an empty column seems to be undefined and I receive an error stating so, on the line that contains the form element. Of course, I won't know that until I can test for undefined and set it to something else. >I think that > ><cfif MyQuery.Col[Row] NEQ ""> > < ... defined ... > ><cfelse> > < ... not defined ... > ></cfif> > >Should do it. > >However this really isn't "defined" but "empty" - CF treats nulls and empty >spaces the same in queries. > >Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210243 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
