to get the length of the longest entry you could do something like this
select max(length(#fieldname#) from #tableName# with oracle.. is that what your trying to find? -----Original Message----- From: Chris Lofback [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:10 PM To: CF-Talk Subject: RE: DB ? Yes, the max allowable length of a field. So for a field that is varchar2(200) it would return 200. And no, this is of absolutely no use for examining any of the entries in the field! :( Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 3:03 PM To: CF-Talk Subject: RE: DB ? > Do you mean the max field length of a text field in a DB table? In Oracle > it would be something like this: > > select data_length > from user_tab_columns > where table_name = '#UCase("TableName")#' > and column_name = '#UCase("ColumnName")#' > >SQL Server probably has a similar construct. That gets the maximum allowable length of the column right? SQL server has this also... I believe its in the syscolumns table, though, afaik he's looking for the actual length of the longest entry ... Isaac Dealey www.turnkey.to 954-776-0046 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
