Recent content by r0nke

Thanks a bunch to everyone who responded.

Hello Is there a way I can see what the today's date is minus another date? So like today's date - 12/02/2004. But I need to see the result in months So for the example above, my answer would be 17 months. Thanks

Thanks ECAR: This is what I have but for some reason I get a syntax error. <cfstoredproc procedure="procname" datasource="dsn"> <cfprocparam type="in" dbvarname="@i_san" value=#form.value# cfsqltype="cf_sql_varchar2"> <cfprocparam type="out" cfsqltype="cf_sql_varchar2"...

I am looking to call an Oracle stored procedure, this is what I have been given and I dont know what to do with it. DECLARE o_firstcommdt VARCHAR2(4000); o_covlvl VARCHAR2(4000); o_covdesc VARCHAR2(4000); o_sitestate VARCHAR2(4000); o_amodel VARCHAR2(4000); o_salechannel VARCHAR2(4000)...

Thanks Dan

Hello I need to paste a page on my website for folks to test if they have JS and cookies enabled. Kind of like "click here to see if you have JS and cookies enabled". So I need some kind of code that can run that test. Any help would be great. Thanks

I am trying to prevent people from seeing the rather ugly and gray file not found template. So I made up my own page and I included it on my settings page on the my app. server. I have about 30 sites and this template is in the directory of these sites. When I try to test for a non existent...

Hello When the SQL or Oracle servers are restarted for some reason, my applications lose their connection to the database. After doing some research I found out Jrun is the culprit. Right now, the only way we are combating this is to restart Coldfusion. That is OK during business hours but it's...

Thanks for the response. All the above were correctly set up in application.cfm. What I mean is, say a website has 10 pages, the session variables are all set in page 1, page 2, 3 and 4 all use these session variables. Suddenly in page 5, it says those session variables were not defined. This...

Has anyone had problems with session variables disappearing? When I try processing a page, coldfusion says the session is undefined but that same session works in the previous page. I get the session undefined error like once every other day. The site never changes, the code never changes but...

Hi Folks For some odd reason, once in a while, legitimate emails instead of being sent will be routed to the undeliver folder in MX. Does anyone know of a fix for this? Thanks

TruthInSatire, You are right, what you posted was exactly what I needed. FALCONSEYE, Thank you for giving it a shot.

Hi folks, Please, how do i validate that the first two characters in a string are letters and the next 5 are numbers? Like so: xx12345 Dont care about any characters after the first seven. Regex or anything will do. Many thanks

You are right, it returns the Client's IP. So I guess, I am looking for the IP value of http_referrer. Thank you TruthInSatire

TruthInSatire thanks for your quick response. <cfoutput>#CGI.REMOTE_ADDR#</cfoutput> retrieves the IP of my site, not the referrer's IP. I was hoping for the referrer's IP