Thank you..
You made me remember.. I got it solved now.. Have a good weekend.. ita --- Ben Johansen <[EMAIL PROTECTED]> wrote: > Hi > > The direct-dbms is not confined to simple selects > where you now the pattern > and the results. > therefore it will not return the same way as a > search action does. > > a search action will place the column in the 0 > (Zero) row of the returned > array > > if you put this in the results html of a search > action > <assign @@user$MyResults value="@@resultSet"> > then you could get the column name by saying > @@user$MyResults[0,1] = Name of column 1 of the > select statement > > also you can reference the data by using the column > name like so > @@user$MyResults[5,Name] = what's in the 5 row of > the Name column > > If you are looking for a little more functionality > out of the Search Action > you can you custom column > by right-clicking on the column area and selecting > custom action. you will > have to follow you database function in this area > > for example: > (datepart(DataField,'month')) as MonthValue > is a custom field definition that will extract the > month number out of a > datetime field > > hope this helps > > Ben Johansen - http://www.pcforge.com > Authorized WiTango Reseller > http://www.pcforge.com/WitangoGoodies.htm > latest beta downloads @ http://www.witango.ws > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > run run > Sent: Friday, August 30, 2002 5:08 PM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: Getting Column Names > > > > Hi List. > > How do you get column names from a direct-dbms > action? Well, I got a free form query box and > I can display field data from any table but > I want to know if you can accomplish this > (displaying field names dynamically) with > direct-dbms action or any search action? > > thank you.,. > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > with unsubscribe witango-talk in the > message body > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > with unsubscribe witango-talk in the > message body __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
