0
How to get the dbf table's Field Name and Field Type and Field Size In CF?
New Here
,
/t5/coldfusion-discussions/how-to-get-the-dbf-table-s-field-name-and-field-type-and-field-size-in-cf/td-p/539818
May 31, 2007
May 31, 2007
Copy link to clipboard
Copied
I have use DSN to connect to the dbf table,now i want to use
the <cfoutput> to show the dbf table's field
name、field type and field size,how to use CF to do
this.
Thanks.
Thanks.
TOPICS
Database access
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Contributor
,
/t5/coldfusion-discussions/how-to-get-the-dbf-table-s-field-name-and-field-type-and-field-size-in-cf/m-p/539819#M49396
Jun 01, 2007
Jun 01, 2007
Copy link to clipboard
Copied
Depends on the database. Some expose the schema information;
others are hard to extract.
Is the DB FoxPro? dBASE? DBC or free-table?
Is the DB FoxPro? dBASE? DBC or free-table?
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Advisor
,
/t5/coldfusion-discussions/how-to-get-the-dbf-table-s-field-name-and-field-type-and-field-size-in-cf/m-p/539820#M49397
Jun 01, 2007
Jun 01, 2007
Copy link to clipboard
Copied
On Microsoft SQL server you can use the INFORMATION_SCHEMA
objects to get information about the objects in a database. The
attached sample describes the columns in MyTable.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Flashcqxg
AUTHOR
New Here
,
/t5/coldfusion-discussions/how-to-get-the-dbf-table-s-field-name-and-field-type-and-field-size-in-cf/m-p/539821#M49398
Jun 02, 2007
Jun 02, 2007
Copy link to clipboard
Copied
Thank you,philh.
It's the Foxpro free-table.
I have use the method query.GetMetaData().GetColumnTypeName() to get the field type,
but the method query.GetMetaData().getColumnDisplaySize() can't run in CF MX 7,however, it can get the correct result in BlueDragon 7.0.
It's the Foxpro free-table.
I have use the method query.GetMetaData().GetColumnTypeName() to get the field type,
but the method query.GetMetaData().getColumnDisplaySize() can't run in CF MX 7,however, it can get the correct result in BlueDragon 7.0.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Contributor
,
/t5/coldfusion-discussions/how-to-get-the-dbf-table-s-field-name-and-field-type-and-field-size-in-cf/m-p/539822#M49399
Jun 03, 2007
Jun 03, 2007
Copy link to clipboard
Copied
From my reading, it's apparent that there are no good
built-in methods in either ODBC or OLEDB to get this info from Fox
tables. Free tables would be even more difficult because of the
lack of a defining container.
One thing to try is to write a Fox program that returns info from the AFIELDS() function. You can compile this program and place it in the system directory, and the Fox ODBC driver will treat it just like a built-in function so you can use it in CFQUERY statements.
Google "Foxpro ODBC AFIELDS()" for some ideas.
Good luck!
One thing to try is to write a Fox program that returns info from the AFIELDS() function. You can compile this program and place it in the system directory, and the Fox ODBC driver will treat it just like a built-in function so you can use it in CFQUERY statements.
Google "Foxpro ODBC AFIELDS()" for some ideas.
Good luck!
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Flashcqxg
AUTHOR
New Here
,
/t5/coldfusion-discussions/how-to-get-the-dbf-table-s-field-name-and-field-type-and-field-size-in-cf/m-p/539823#M49400
Jun 03, 2007
Jun 03, 2007
Copy link to clipboard
Copied
thanks philh .
In BlueDragon 7,getColumnDisplaySize() can get the field size,but in CF7 or CF8 trial,I can not .
I hope to get a better method to get the field size except AFIELDS().
thanks.
In BlueDragon 7,getColumnDisplaySize() can get the field size,but in CF7 or CF8 trial,I can not .
I hope to get a better method to get the field size except AFIELDS().
thanks.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Flashcqxg
AUTHOR
New Here
,
LATEST
/t5/coldfusion-discussions/how-to-get-the-dbf-table-s-field-name-and-field-type-and-field-size-in-cf/m-p/539824#M49401
Jul 05, 2007
Jul 05, 2007
Copy link to clipboard
Copied
can you help me?thans.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

