RE: [ cf-dev ] Unrecognized Fields

[Christopher Dawes]

Title: Message

Hey Snake,   restarted the MX ODBC Agent... seems to do the job fine.... I'll have to use the ihtk to restart the ODBC Agent via CFX...   thanks... been itching 'bout this one for ages!!   Regards, Christopher Dawes Dawes International From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: Tuesday, 1 June 2004 12:16 AM To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Unrecognized Fields I don't think that would help. Does a restart of the ODBC service fix it ? -----Original Message----- From: Christopher Dawes [mailto:[EMAIL PROTECTED] Sent: 31 May 2004 13:50 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Unrecognized Fields is there someway I could script the factory object to refresh the dsn list? From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: Monday, 31 May 2004 10:34 PM To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Unrecognized Fields I have had this b4, somehow the DSN was being cached, so it only remembered all the tables that were in the database last time it was being used. Try unchecking "maintain database connections". -----Original Message----- From: Christopher Dawes [mailto:[EMAIL PROTECTED] Sent: 31 May 2004 12:20 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Unrecognized Fields This happens for me also. I have to restart SQL and CF for it to recognise it. I have a vanilla install on my machine.   Chris Dawes. From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED] Sent: Monday, 31 May 2004 7:48 PM To: CF - List Subject: [ cf-dev ] Unrecognized Fields I am developing a site in CFMX with SQL 2000.   Everytime I add a field to ONE table and I run a query against it, CFMX doesn't recognize the new field. Other tables in the same db are fine.   To solve I have to restart cfmx service.   Any ideas? Allan Cliff