Hello: We're "reading in" a simple key/value list from a table via a stored procedure and assigning to an array in Witango. We then assigned the "0" column to the key name in column 1 for easy value lookup - something like
<@FOR START="1" STOP="<@NUMROWS ARRAY='request$MyArray'>" STEP="1"> <@ASSIGN "request$MyArray[<@CURROW>,0]" <@VAR "request$MyArray[<@CURROW>,1]">> </@FOR> So, <@var request$MyArray[Key1,2]> = Value1 <@var request$MyArray[Key2,2]> = Value2 etc However, if a particular key does NOT exist (which happens in our scenario) in the db (say Key3) then <@var request$MyArray[Key3,2]> is returning "value" instead of an empty value (as does <@var request$MyArray[somebogusname,2]>). I was expecting an empty value here. It's been awhile, but maybe this method is not optimal for checking the existence of a particular key/value pair in addition to accessing the values of various keys. Thanks in advance for any insight or recommendations. John Robert, best of luck with the recent acquisition. As so many have already commented, we also appreciate your diligence and responsiveness on the talk list and look forward to seeing where you take the product. I can't believe we started using the product back in 1996 - what a journey. -- John Hotaling [email protected] www.AuctionAnything.com 800-866-8009 ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
