Query a Directory and delete all files more than 1...

weezerboy · ‎May 12, 2009

How would I query a directory and delete all files from that directory that are more than 1 hour old? I have used CFDIRECTORY before to post pages to the directory and to get directory info but I cant figure out how to query a directory and delete all files more than 1 hour old from that directory. 1 hour old means that the time NOW is more than an hour from the file's date/time on the server.

weezerboy · ‎Feb 24, 2009

How high do I go on the last 3 digits 232,233,234,235,236,237....when do I stop?

weezerboy · ‎Feb 24, 2009

I wasnt using the actual one in the post but here it is now 185.16.232.0/22

weezerboy · ‎Feb 24, 2009

I have a site that allows users to bypass a login screen and get direct access to my website depending on their IP address. I have implemented quite a few of these without problem. But now I have a client that has an IP range of 199.99.999.9/22 that I cant seem to get correct. I have tried CGI.REMOTE_ADDR CONTAINS '199.99.999.9' and Left(CGI.REMOTE_ADDR, 12)# EQ "199.99.999.9" to no avail. Is the /22 the problem?

weezerboy · ‎Dec 22, 2008

I have a column in my database that has values like this Row1 : RA1,RA2 Row2 : XA1,XA2 I have a search form that will pass a value and query the table. If the user enters RA1 I need the search to return row 1, it doesnt now When I run the search query the result for row 1 is 'RA1,RA2' so unless my user enters in RA1,RA2 no result is returned. I need a result returned if the user enters any of the values in the list not all of the values in the list. How would I do this

weezerboy · ‎Dec 03, 2008

Unfortunately this did not work. I made the timeout 5000..problem still exists I wrote 2 separate queries and I still get a timeout error. I send 1500 in the first query batch and 2000 in the second query batch....problem still exists. Any Help...server settings?

weezerboy · ‎Dec 01, 2008

I have been using a cfmail tag for a year with no problems. The size of my mailing list has grown, that I now get this error below The request has exceeded the allowable limit TAG:cfmail Any suggestions?

weezerboy · ‎Oct 08, 2008

I have a main query that selects all of the needed data including a column of dates. But when I query the main query (Q of Q) I get a syntax error because of the date. How can I query on the date using Q of Q? Do I need to format the date differently?

weezerboy · ‎Oct 02, 2008

I have a page with an iframe and it works OK in ALL IE browsers. But in Firefox when the parent page is refreshed the iframe content doesnt refresh. I couldnt use cfinclude. Any help?

weezerboy · ‎Sep 10, 2008

I have query results like this 123PKM AAPL WB 9865W CF QRST How can I determine if the query result begins with a number? Like 123PKM and 9865W do begin with a number. But the others dont.

weezerboy · ‎Feb 21, 2008

Here is the code..seems like this should work!!! I have created relationships for the 3 tables on conference_userid <cfquery name="conferencelist" datasource="conferences" dbtype="ODBC"> select n.* from NAMEINFOF n LEFT JOIN FUNCTIONSF f on n.conference_userid=f.conference_userid LEFT JOIN RESTAURANTF r on n.conference_userid=r.conference_userid where n.conference_userid=1 </cfquery> Here is the error message Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'n.conference_userid=f.conference_userid LEFT JOIN RESTAURANTF r on n.conference_userid=r.conference_userid'.

weezerboy · ‎Feb 20, 2008

I have 3 related tables named NAMEINFOF FUNCTIONSF RESTAURANTF Each person has 1 row in each table 1 row in NAMEINFOF 1 row in FUNCTIONSF 1 row in RESTAURANTF There is a column for each record in each table named conference_userid that relates the tables to each other. For example PAT has a conference_userid of 66 and PAT has a row in each of the 3 tables. I need to output the rows for Pat from each of the 3 tables in 1 query. I get this error [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.

weezerboy · ‎Jan 23, 2008

I need to enter a few formatted paragraphs into a textarea field and submit it to a database for output later. The problem I have is when I output the data from the db it loses all of the formatting (bold,styles etc..) AND I lose my paragraphs & breaks etc. Does anyone have any suggestions on how I can submit formatted text into a db via a form and have it keep the formatting so when I output it ..the formattting will be there?

weezerboy · ‎Dec 30, 2007

I am getting this error message when my users attempt to return to my site with an expired SESSION variable. Element FNAME is undefined in SESSION I could possibly fix the error but it would be difficult......... Since I know its going to occur ... How would I use CFCATCH/CFTRY-CFERROR to catch this error and redirect these users to the login screen? PAT

weezerboy · ‎Dec 30, 2007

I am getting this error message when my users attempt to return to my site with an expired SESSION variable. Element FNAME is undefined in SESSION I could possibly fix the error but it would be difficult......... Since I know its going to occur ... How would I use CFCATCH/CFTRY-CFERROR to catch this error and redirect these users to the login screen? PAT

weezerboy · ‎Sep 21, 2007

Excellent Job on the query...it works great

weezerboy · ‎Sep 20, 2007

I have a data table with columns like below. I am trying to figure a query or a q of q to get this answer. I need to know the net change in posper for eac teamid, then sort the results DESC. So for teamid 10258 the net posper change is 5521-4947 = 574, for teamid 10268 its 8580-5860=2720 etc After I have all of the nets i need to sort them..so for these 2 above it would be 10268-2720 10258-574 etc ID teamid gy posper 2527 10258 2007 5521 2828 10258 2006 4947 3126 10268 2007 8580 3420 10268 2006 5860 4892 10259 2006 20806 6109 10259 2007 18828 4891 10258 2006 8152 6108 10258 2007 8016

weezerboy · ‎Sep 18, 2007

I am querying a table with a column that has data like this Its four characters..the underscore ...then more stuff RSMA_pre0716 RSMA_pre0717 RSMA_pre0718 XLRN_pre0716 REOB_pre0716 REOB_pre0718 HJUY_pre0716 2KVV_pre0716 How can I get a query that finds fields that begin with a certain 4 letters. What would the query be for if I wanted to return ALL of the records that start with RSMA...only? I have tried LEFT access functions to no avail. I was hoping to get my results from the query without gat all records and then looking through a list or something. How can I get a query that finds fields that begin with a certain 4 letters. What would the query be for if I wanted to return ALL of the records that start with RSMA...only?

weezerboy · ‎Jul 31, 2007

I have strings that are file names...like index.cfm......test.pdf....messagepost.cfm I need to extract only what is to the left of the dot. Like for index.cfm...I need to extract index for test.pdf..I need to extract test for messagepost.cfm .. I need to extract messagepost I've tried variations of right ,left, mid..to no avail.. Any help.

weezerboy · ‎Jun 28, 2007

I have a form with 10 time fields. I need the user to input the time in military format like this 12:16. The problem is users are entering the time WITHOUT THE COLON and its causing problems. How can I check for the existance of a colon in these form fields. I need the colon to be there before I go onto further processing. PAT

weezerboy · ‎Apr 02, 2007

I am a 10 yr user of CF and currently use CFMX7. I need to create charts graphs and reports for a client. Should I learn to use CFMX7 for graphing, charting.. OR Is there a leading 3rd party software that would be better. PH

weezerboy · ‎Feb 28, 2007

I have put <input name = "var1" onClick="return false" etc ..........> on all of my radio buttons But that only kind of disables them.;;;;;;;;;;;;;;;.if i click on an uncheked radio button it unchecks the button that was selected leaving all of the radio buttons blank 2 questions Do I have to put something in the head tags re the onClick="return false" Do I have to put something different on the selected button instead of onClick="return false"

weezerboy · ‎Feb 28, 2007

I have a form that works very well that has check boxes and radio buttons. All is well with the form. But now I need to creat a printable version of the form after the user completes it. The problem is when the user gets to the printable version they can still click the radio buttons/check boxes. ( I know it doesnt write to the db) How can I create this printable version so that the radio buttons/check boxes cannot be changed?

weezerboy · ‎Feb 22, 2007

I just installed the CFMX 7.0 trial version but I think I installed it in the wrong directory. I had an existing version running perfect but downloaded 7 to try it out. I installed 7 in the same directory CFUSIONMX that I had my working copy. Now nothing works I cant get my pages to run and 127.0.0.1:8500 produces an error. AND I cant uninstall or remove using control panel. I'd like to try it out. Is there anyway to configure the trial version or remove it so I can get back to where I was.

weezerboy · ‎Feb 22, 2007

I had to provide my Verizon username and password info in the cf administrator and it works

weezerboy · ‎Feb 20, 2007

I have been using CF for 10 years and gave used the CFMAIL tags hundreds of times. But last week I switched to VERIZON for internet /email etc. Now I cant get my CFMAIL tags to send. I suspect that this has something to do with VERIZON blocking port25. But I had COMCAST and they supposedly blocked port25 too...But I never had any problems with CFMAIL sending. Now I have tried every email, cf administrator setting and cant get this CFMAIL to work. Any ideas? I also have an MSN account I could use and I tried today to use ...to no avail.

weezerboy · ‎Feb 12, 2007

yes PAULKD, that worked great! Now can I take another number which is my locality code and put it at the beginning of the numericssn (NumSSN) Like this Chicago --The code is 71 SSN is 259-95-9658 So I need the end result to be 71259959658 Excel would call it CONCATENATE...joining several strings into one string

weezerboy · ‎Feb 12, 2007

My client is suggesting I create some web interface using cold fusion that will take his access 2003 records and convert them into a dbf format which he then can take these dbf files and append them to his other Access 97 database? He wants me to automatically generate dbf files for each of the user records in the database. I agree I wish he would just do this using Access but he doesnt use Access 2003 etc............ Is there anyway to use cf to generate these files dbf files?

weezerboy · ‎Feb 12, 2007

Is anyone aware of any code that will take an SSN and remove the hyphens so I can use it as a numeric value? SSN: 222-22-2222 New 222222222

weezerboy · ‎Feb 12, 2007

I know with CFCONTENT TYPE tag I can convert my data to excel format. Is there a way to convert database tables, certain records to a dbf format?

weezerboy

weezerboy

Activity

Query a Directory and delete all files more than 1...

Re: CGI.REMOTE_ADDR Range Question

Re: CGI.REMOTE_ADDR Range Question

CGI.REMOTE_ADDR Range Question

SEARCH result

Re: CFMAIL Timeout

CFMAIL Timeout

Query Of Queries syntax error--DATES

Firefox and I FRAME caching

Determine if query result begins with a number

Re: 3 table join

3 table join

TEXTAREA Output & Formatting

CFCATCH/CFTRY-CFERROR

CFCATCH/CFTRY-CFERROR

Re: Access

Access

ACCESS

Extract from String

Check for Colon in Form Field

Charts & Reports

Re: Printable version with Radio buttons/Check Box...

Printable version with Radio buttons/Check Boxes

CFMX 7 Install Problem

Re: CFMAIL Port 25??

CFMAIL Port 25??

Re: Convet SSN to numeric

Re: CF Convert to DBF format?

Convet SSN to numeric

CF Convert to DBF format?