[thelist] ODBC Text Driver w/ ColdFusion

.jeff jeff at members.evolt.org
Tue Oct 15 19:13:01 CDT 2002


howdy,

i'm using the merant odbc text driver that comes with cf5 to query log files.  i'm looping over the query results and creating individual log files for each unique http_host.  i'm running into a problem though.  it appears as if the http_host column can't handle more than 22 characters.  this is really odd though because there are several other fields that are being queried as well and return quite a few more characters without any difficulty.  i was wondering if anyone has any experience with this driver and might have a clue as to what's happening.

i'll probably just end up doing a bulk copy of the logfiles into ms sql 2k and then querying from there, but i thought i'd see if all the crack smoking for me today has affected this project as well.

thanks,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/




More information about the thelist mailing list