Can I use CF 6.1 (including hot fixes)
to see what tables are in the schema ?
--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12840 of my spam emails to date.
Get the free SPAMfighter here:
which db are you using?
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
BobSharp wrote:
Can I use CF 6.1 (including hot fixes)
to see what tables are in the schema ?
~|
Adobe® ColdFusion® 8 software 8 is
as an example, MySQL supports SHOW FULL tables sql statement, which
will return all tables in this db associated with your sf dsn.
however, you need to know the actual name of your mysql db to access the
results of this query, because the name of the column which contains
table names is
MySQL
- Original Message -
From: Azadi Saryev az...@sabai-dee.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Monday, March 30, 2009 12:58 PM
Subject: Re: Finding schema details with CF 6.1 ?
which db are you using?
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
12:58 PM
Subject: Re: Finding schema details with CF 6.1 ?
which db are you using?
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
BobSharp wrote:
Can I use CF 6.1 (including hot fixes)
to see what tables are in the schema
What database are you using? There are different dialects on how to tease
that out. I would take a look at sql.cfc for the MSSQL . I have the sql for
MySQL some where in my archive if you need it..
H!
On Mon, Mar 30, 2009 at 6:57 AM, BobSharp bobsh...@ntlworld.com wrote:
Can I use CF
: Re: Finding schema details with CF 6.1 ?
What database are you using? There are different dialects on how to tease
that out. I would take a look at sql.cfc for the MSSQL . I have the sql
for
MySQL some where in my archive if you need it..
H!
On Mon, Mar 30, 2009 at 6:57 AM, BobSharp
az...@sabai-dee.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Monday, March 30, 2009 1:36 PM
Subject: Re: Finding schema details with CF 6.1 ?
seen my follow-up post? it was posted same time you posted your reply...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
BobSharp wrote
done it for a list of Tables, now need to
extract FULL details of individual Tables.
- Original Message -
From: Gerald Guido gerald.gu...@gmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Monday, March 30, 2009 1:55 PM
Subject: Re: Finding schema details with CF 6.1
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE 'pattern']
http://dev.mysql.com/doc/refman/5.0/en/show-columns.html
check out whole section 12.5.5 in MySQL reference manual for more SHOW
options:
http://dev.mysql.com/doc/refman/5.0/en/show.html
Azadi Saryev
Sabai-dee.com
What is the equivalent for columns ?
Could I output the Table's schema details ...
(column name, data type, size, format, NULL allowed ?, PrimaryKey, Indexes)
...ie: like a DUMP, without the data ?
Use information_schema to access database metadata
Thanks, but the CFC is a bit beyond me at the moment.
How would I insert it in a CFM page ?
- Original Message -
From: Gerald Guido gerald.gu...@gmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Monday, March 30, 2009 2:25 PM
Subject: Re: Finding schema details with CF 6.1
Correct me if I'm wrong, but it sounds like you're actually requesting that
someone go through that CFC for you and turn it into something that you can
copy and paste into a template.
On Mon, Mar 30, 2009 at 10:11 AM, BobSharp bobsh...@ntlworld.com wrote:
Thanks, but the CFC is a bit beyond
?
- Original Message -
From: Gerald Guido gerald.gu...@gmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Monday, March 30, 2009 2:25 PM
Subject: Re: Finding schema details with CF 6.1 ?
Sorry about that I had my coffee now... I wrote a query to do that a
while back. I can't find it now
details with CF 6.1 ?
Correct me if I'm wrong, but it sounds like you're actually requesting
that
someone go through that CFC for you and turn it into something that you
can
copy and paste into a template.
On Mon, Mar 30, 2009 at 10:11 AM, BobSharp bobsh...@ntlworld.com wrote:
Thanks
How to put what into a .cfm file? If you want to get column data for a
table, you can simply run a query against the information_schema table:
SELECT *
FROM INFORMATION_SCHEMA.Columns
WHERE table_name = 'yourtablename'
The CFC shows one way you can do this and encapsulate it (and other related
Bob, a quick tip on CfQuery. If use a SELECT * you can get at list of the
columns of a table using the #Queryname.ColumnList# syntax
Try this:
cfquery name=qgetschema datasource=Yourdsn
SELECT *
FROM INFORMATION_SCHEMA.Columns
WHERE table_name = 'yourtablename'
/cfquery
17 matches
Mail list logo