> -----Original Message----- > From: daniel kessler [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 22, 2005 12:48 PM > To: CF-Talk > Subject: RE: testing for undefined > > >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 think you're better off - you can still make a generic query displayer using the indexed notation without conversion. > >> 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. Weird. Are you talking about an empty column or cell? If a column then wouldn't the whole query be empty? If a cell then it should be empty string not "undefined"... It's probably worth exploring, but since I really don't think you need the conversion at all it's probably a moot point. 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:210248 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
