make a list of table names and do a cfloop through the list with a
cfquery in it.
something like this:
<cfloop list="#myTables#" index="i'>
<cfquery name="qExpires" datasource="myDSN">
SELECT *
FROM #i#
WHERE expires > #now()# (or whatever the criteria is)
</cfquery>
<cfset 'query#i#' = qExpires> <!--- store query --->
</cfloop>
HTH,
Josh
---
Exciteworks -- expert hosting for less!
http://exciteworks.com
reseller plans available
Robert Orlini wrote:
> I have a number of tables in one Access datasource. How would I loop
> thru all of them and search the expire date field?
>
> Robert Orlini
> HW Wilson
> 718-588-8400 x2656
> ô�ô
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
