Simon, If you are using Access, the system tables all start with "M". Try MSysobjects
Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -----Original Message----- From: Simon Whittaker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 8:45 AM To: CF-Talk Subject: Re: Last Updated Date Thanks for your help - unfortunately - I am getting the following error when I try the code - do I have to change anything in CfAdministrator? Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'sysobjects'. Make sure it exists and that its name is spelled correctly. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:54). Date/Time: 10/02/01 13:43:51 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; poing!; Poing! Guest) Remote Address: 62.190.52.254 Cheers Simon ----- Original Message ----- From: "Steven Dworman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 1:05 PM Subject: RE: Last Updated Date > select refdate > from sysobjects > where name = 'TABLE NAME' > > > Steven D Dworman > ------------------------------------------------------------------------- > Web Consultant > Systems Administrator > > ComSpec International - http://www.comspec-intnl.com > phone: 248.647.8841 > cell: 734.972.9676 > ------------------------------------------------------------------------- > EMPOWER-XL ***Software for Higher Education*** > http://www.empower-xl.com > -----Original Message----- > From: Simon Whittaker [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 4:08 AM > To: CF-Talk > Subject: Re: Last Updated Date > > Cheers Howard and John, > > Unfortunately the option of having a seperate column or even a seperate > table is not really availablt - is there anyway of obtaining the last > modified date of a dbase or even any file? > > > Cheers > > Simon > ----- Original Message ----- > From: "John Paitel" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, October 01, 2001 6:28 PM > Subject: RE: Last Updated Date > > > > >You can create a column in your table called "DATE_MODIFIED" and update > that > > >with the current date each time the row is updated, then retrieve that > date > > >when displaying that record. > > > > I believe he wanted to see if it was possible without using another field. > > John > > > > > > Is it possible (without a seperate field/table) to obtain a last > updated > > > > date/time for an Access 2000 or SQL database and then display it on a > > > > page? > > > > It would also be brilliant to obtain a last updated date/time for a > > > > paticular record but I realise that this is less likely. > > > > > > > > I hope you can help, > > > > > > > > Cheers > > > > > > > > Simon > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
