Hi Gene, Could you build an array with the table names and then loop through the array doing the work for each table (using the variable in place of where you would normaly have your constant table name in the DBMS)?
----- Original Message ----- From: "Wolf, Gene" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 25, 2004 11:32 AM Subject: RE: Witango-Talk: Something completely different Scott, no, I could do that and that may be a solution. What I have, in essence, is a single ODBC with what amounts to multiple tables within the "database". All of the "tables" have the exact same structure so I want to loop through all of the records of one table, list them, then read all of the records of the next table, list them, etc. This is hard to explain but I hope this gives you a better idea of what I'm trying to do. Thanks for your help! -----Original Message----- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 2:19 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Something completely different Hi Gene, Not that I understand 100% of what you're doing, but I think you're saying each Excel file has a different ODBC connection, right? If you have an array that describes all your Excel file connections, then you can do a Loop on that and use Variables for your datasource connections - then you only need one Search Action and one set of code (for parsing the data) for the whole thing. See http://xmlx.ca/articles/571.aspx Hope this helps. Cheers.... Scott Cadillac, 403-281-6090 ~ [EMAIL PROTECTED] ------------ XML-Extranet ~ http://xmlx.ca ~ http://forums.xmlx.ca Well-formed Programming in C# .NET, Witango, MSIE and XML ------------ IExtranet ~ http://iextranet.ca Witango ~ http://witango.org EasyXSLT ~ http://easyxslt.ca IIS Watcher ~ http://iiswatcher.ca ------------ ________________________________ From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 11:46 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Something completely different OK, this may be way off the wall but I figured one of you folks would have tried this, or know it can't be done. I have a number of excel spreadsheets that I will be reading data from using Witango. There are about 14 of these sheets and I have working ODBC links to each one of these. Now, the format of all of these sheets is exactly the same and I need to be able to create the exact same reports from each of these spreadsheets. Is there any way I can change the table I'm looking at in either a search action or a direct DBMS so I can loop through a list of table names and create the reports without duplicating the code for every table? Does this make sense to anyone? *laughs* Gene Wolf Business Systems Analyst, TLMN DRS Optronics, Inc. 2330 Commerce Park Drive Palm Bay, Florida 32905 Phone: 321-309-0685 E-mail: [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
