Hey Matt,
What DB are you using?
If you are using MS-SQL you can get a recordset of all tables in your current
database by using the following:
<cfquery name="qryAllTables" sql="select name from sysobjects where type='U'"
...>
Then loop thru this recordset and for each table:
select * from #qryAllTables.name#
Then use ColumnList method of the newest quyery to get a comma delimited list
of each field in the '*'.
Loop thru the each field of every record looking for your @.
This might not be the most effective method ... but it should get you started.
Cheers,
Bill
In a message dated 9/3/01 2:22:45 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> Ok, I have been presented ith a problem. Someone with an existing
> ColdFusion site which I have never worked on has come to me with a
> request. They would like me to extract all of the email addresses
> from thier database. I thought at first that this would be a simple
> task but when I actually went in to look at the database I found out
> otherwise... There are over 200 tables in this db and after sampling a
> few of the tables I discovered that the email fields from one table to
> the next do not conform.
> How would I go about writing a query to search through every table and
> extracting any entries with the @ symbol? Any ideas?
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
