Sagewire Logo

Getting Database file date

5 Message(s) by 3 Author(s) originally posted in cfml discussion


From: GArlington Date:   Wednesday, October 24, 2007
wrote in message:
Greetings,
I'm a low level ColdFusion newbie and have a simple question. How can I get the
date of the data base file located on my server. I'd like to report that on the
page where the data is list ed. I'm new, so please be simple. Here's some info:
datasource = "mydata"
file location: = /database/mydata.mdb
thansk,
Stephen



RTFM: <CFDIRECTORY ...>


From: sbsmithfl Date:   Wednesday, October 24, 2007
Greetings,
I'm a low level ColdFusion newbie and have a simple question. How can I get the
date of the database file located on my server. I'd like to report that on the
page where the data is listed. I'm new, so please be simple. Here's some info:

datasource = "mydata"

file location: = /database/mydata.mdb

thansk,
Stephen


From: jdeline Date:   Wednesday, October 24, 2007
Take a look at the CFDIRECTORY tag which you can get to at
http://livedocs.adobe.com/Cold Fusion/8/htmldocs/index.html. Click CFML
Reference, then click Cold Fusion Tags. The ACTION="list" is what you want.


From: sbsmithfl Date:   Thursday, October 25, 2007
Thanks you, this is very helpful. But, this is still a bit above my head, as
I'm must beginning. This is what I have, which isn't working:

HEAD:

<CFDIRECTORY directory ="../database/" name="GetDate" action="LIST"
filter="*.mdb">
BODY:

<CFOUTPUT> #GetDate.dateLastModified#</CFOUTPUT>

I'm stumped?


From: jdeline Date:   Thursday, October 25, 2007
Your close. First, the directory must be an absolute pathname or an IP - for
example, <CFDIRECTORY directory="//12.3.123.123/c_drive/" name="getDate"
action="LIST" FILTER="*.mdb">
. This returns a list of all the .mdb files,
which you treat just like a query. So you do:

<CFOUTPUT QUERY="getDate">
#dateLaseModified#<BR>
</CFOUTPUT>



Next Message: Cold Fusion MX7 Developer Certification


Blogs related to Getting Database file date

Document
1800 documents document scanning document archive services clickbank documentation customs e60 documents c -130 aircraft documentary dvds documented bestialitystory travel 25apr date documents payne primary document on the american ...

Display
... motorola slvr l7 date is not displayed t-shirt display mannequins torso stand skyddsfilm display kamera most legible display pda maritime navigation recommended gps information display display images from a database using .ashx file ...

datawrite ink cartridges
... date base date based export scheme date bases date batch date batch command date batch dos date batch file date batch files date battle gettysburg date bay date bay of pigs invasion date bayo date beautiful women date before getting ...

What IIS Security?
In a small shop, a single NT box might be file server, database server, mail server, and intranet server -- all in one. You can see this bias toward multiple roles in IIS itself with its integrated HTTP, SMTP, FTP, and NNTP components, ...

Document
... minimize active document sbar.documentation travel 25apr date documents payne colisage routage documents process of ownership documentation of puppy debut hexagon documentary documentries of bigfoot documentsecurity.net nnl database ...

ncynce
... return value 1722 or contractor or corrupted cabinet file or count or counties or county or county bank and trust co or county map or credit card number or credit card number in or crocodiles at amazon or dare or database or death ...


Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional