RE: mySQL equivalent of MS Access Money fieldtype?
Yes. This is a terribly annoying problem. Oh well, that's what happens when there's only one number type. -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:03 PM To: CF-Talk Subject: Re: mySQL equivalent of MS Access Money fieldtype? On Tuesday, Dec 17, 2002, at 14:48 US/Pacific, Jochem van Dieten wrote: I believe the rounding baheviour of SQL is not specified to the point where you can say a priori that math will not introduce errors with any datatype. You always have to check the manual, because even with operations involving 2 exact numeric values the outcome is often implementation-defined. Actually, although this was exactly my point (use a binary integer for cents), you have reminded me of a slight problem for us CFers: namely that CF doesn't actually have a binary integer type but uses numeric instead which is inherently floating point... :( Moral: if you're really doing heavy math in pennies and can't risk any rounding errors, you'll need to use Java and code the formulae in int or long types! Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CreateDateTime function??
Hi, My intention is to allow a user to select 'how long' eg, months, weeks, days, hours, minutes, it took to solve a problem, this information will then be stored as one field in the database. It is the intention that searches etc can be carried out on this information for comparison. Thanks for the help so far, Lisa -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 04:27 To: CF-Talk Subject: RE: CreateDateTime function?? Why add a date if you want to store an interval? I mean, if you want to calculate a new date it is the obvious route, but the request was to store it. Lisa: Can you confirm on your question? is, how to store the selected values into one field of my database? Am not sure what your purpose is behind all this. ***Logically.. you would just give a drop down of dates(MM-DD-) HH:MM*** If i understand the question correctly.. User comes in and selects something to happen(e.g Email me cheap flights after this period) 2 weeks 3 days 5 hours 10 minutes... Yes the question is how do you store weeks days hours and minutes... My understanding is a future dateTime has to be created and the database field would be a DateTime field.. in that case...? cfscript //create a default current date with form data... myDate=CreateDateTime(year(now()),month(now),day(now()),form.hrs,form.mins,s econd(now)); //adding weeks here myDate=DateAdd(ww,form.ww,myDate()); //adding days here myDate=DateAdd(d,form.dd,myDate()); /cfscript myDate would be the future date created from the form.. to be inserted into the database in one DateTime FIELD. Joe -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 6:58 PM To: CF-Talk Subject: Re: CreateDateTime function?? Joe Eugene wrote: All you need is create a default date and use function DateAdd(,defaultDate) and create whatever..date you want. Check previous post for code. Why add a date if you want to store an interval? I mean, if you want to calculate a new date it is the obvious route, but the request was to store it. Isn't creating a new date and converting that new date back to an interval when you need to extract the interval just a whole lot of extra hassle? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CreateDateTime function??
Lisa Donnelly wrote: My intention is to allow a user to select 'how long' eg, months, weeks, days, hours, minutes, it took to solve a problem, this information will then be stored as one field in the database. It is the intention that searches etc can be carried out on this information for comparison. Use an interval. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: debug report/image magick with cfexecute
Actually it is probably because you haven't specified a timeout == from docs = timeout Optional 0 Length of time, in seconds, that ColdFusion waits for output from the spawned program. 0: equivalent to non-blocking mode. A very high value: equivalent to blocking mode If the value is 0: ColdFusion starts a process and returns immediately. ColdFusion may return control to the calling page before any program output displays. To ensure that program output displays, set the value to 2 or higher. If the outputFile attribute is not specified, any program output is discarded == from docs = WG -Original Message- From: jon hall [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 02:30 To: CF-Talk Subject: Re: debug report/image magick with cfexecute That's interesting...makes me think that cfexecute doesn't report it's content back to whatever the cf equivalent to stdout is, or it just works in a different way than the other tags, or someone forgot about cfexceute :). I wonder if putting cfoutput's around the cfexecute would work...probably not, but just a thought. A possible solution would be to pipe the output of imagemagick to a file and read it in, or use cfexecute to write the output to a file and read that file it... -- jon mailto:[EMAIL PROTECTED] Tuesday, December 17, 2002, 8:53:21 PM, you wrote: OH I thought if I did something like this: OH CF_SaveContent variable=debugReport OH CFEXECUTE OH NAME=F:\ImageMagick-5.5.1-Q8\mogrify.exe OH ARGUMENTS=-format jpg -antialias -mask unsharpen -quality 70 OH F:\Inetpub\wwwroot\inserts\ps\#name# OH F:\Inetpub\wwwroot\inserts\ps\#tempFile#.jpg -debug -verbose -log OH /CFEXECUTE OH /CF_SaveContent OH cfoutput OH #debugReport# OH /cfoutput OH I would get the results of the cfexecute, arguments include -debug, report OH .. but I'm shooting blanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: working with image magick
Yeah we have had this issue too. Bad PDFs seem to choke nearly all PDF processors , including adobes own, and ActivePDF etc. They all just die. I wrote a small, check to help root out some of the bad ones cfset f = #ServerDirectory#\#ServerFile# cffile action=READ file=#f# variable=data cfif find(%!,data,1) and find (PS-Adobe-,data) cfset valid = 1 cfelse cfset valid = 0 /cfif cffile action=DELETE file=#f# It seems to help. If you have the time, which I didn't, you chould use the file program or code, most linux dists. have it installed or cygwin.com for win32. This uses a file called a magic file which defines signatures for different types of files, and then the file command tells you what type of file it is. You can use this to tell if your PDF files is bad, works 99% percent of the time. I you write one, give me a copy! WG For some reason, once in a while, there is a bad PDF that causes GhostScript to choke. When that happens, cf_magicktag throws an error. Is there anyway to get the tag to just skip over the bad PDF and continue process the batch? H. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT : Mac / IE / OS X
Hi, sorry for the OT but I know some of you use OSX!
I am having a real problem with IE 5.2.2. on OS X with the following code :
!--- in the head ---
script language=JavaScript type=text/JavaScript
!--
function spawn() { /
window.open('index.cfm','foo','scrollbars=no,width=739,height=540,screenX=0,
screenY=0,top=0,left=0');
//window.location.href = http://www.foo.com;;
}
//--
/script
body onLoad=spawn();
This all works fine on a PC but on a Macintosh with the above config, it
seems to load the window.open no problem, but it then proceeds to reload the
opener page and in turn reload child window, its like its in a loop? again,
this only happens on the Macintosh!?
Has anyone experienced this or have a workaround?
Thanks!
Neil
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT : Mac / IE / OS X
erm... forget itit was a skoolboy error :-)
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: 18 December 2002 12:09
To: CF-Talk
Subject: OT : Mac / IE / OS X
Hi, sorry for the OT but I know some of you use OSX!
I am having a real problem with IE 5.2.2. on OS X with the following code :
!--- in the head ---
script language=JavaScript type=text/JavaScript
!--
function spawn() { /
window.open('index.cfm','foo','scrollbars=no,width=739,height=540,screenX=0,
screenY=0,top=0,left=0');
//window.location.href = http://www.foo.com;;
}
//--
/script
body onLoad=spawn();
This all works fine on a PC but on a Macintosh with the above config, it
seems to load the window.open no problem, but it then proceeds to reload the
opener page and in turn reload child window, its like its in a loop? again,
this only happens on the Macintosh!?
Has anyone experienced this or have a workaround?
Thanks!
Neil
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Re: OT : Mac / IE / OS X
Robertson-Ravo, Neil (RX) wrote: I'm running into some of the very problems you mention. I tried Decimal as the field type, but 100.5 gets rounded up to 101.00...not good. I tried Integer, but when, for example, 100.50 gets entered into a formfield, then inserted into the db, it gets truncated to 100. How do I set up Integer to retain 2 decimal places? cfqueryparam cfsqltype=CF_SQL_INTEGER Value=#LSCurrentFormat(LSParseNumber(Form.UCPaymentAmount))# CFQUERYPARAM value=100.5 CFSQLType=CF_SQL_DECIMAL scale=2 integers are whole numbers and you need to specific how many decimal points using scale as above... z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: cferror
Here's my notes on cferror types (CF 4.5 SP2, Solaris, Oracle 8i): Chris Norloff type=expression - catches bad expression like select * from m_job_summary where job_id=#doesnt_exist# type=database - catches bad SQL like select * from m_job_summary GROUP ORDER BY - catches invalid column like select * from m_job_summary where doesnt_exist=10 type=missinginclude - catches missing cfincluded files - catches missing cfmodule files. type=lock - catches problem with lock, such as timing out while waiting to get exclusive access. type=any Catches things not caught by a previous cfcatch statement. Example: - timeout error. Sometimes timeout error has type COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT. Sometimes type is UNKNOWN and the message is Request timed out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: need tag for dropdown and input
Late to this thread (doing holiday things), but here's some pure JavaScript and a form that does what you want more. There are 2 select boxes: Available Topics, and Chosen Topics, prioritized. 1) you can move from one select box to the other 2) you can add new topics from a text field 3) you can move Chosen Topics up or down in the select box 4) you can email the chosen topics You could customize this into a tag or use CF to populate the select box etc. You can easily change the text boxes to dropdowns, etc. HTH Dick Valerie L. Criswell writes: I know I've seen it somewhere on my journeys. It's the tag that displays both a dropdown (populated from a query) as well as an accompanying text input so that the if the needed value isn't listed in the dropdown, the user can enter it into the text box. But only one variable for the value is sent. Anyone know where I can pick this up? I'm not sure what to search for on the DevX. I sure wish they would make a more powerful and relevant search tool. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: need tag for dropdown and input
Er, ahh--- I guess a URL would help :) http://idisk.mac.com/dicklacara/Public/ComboBox.html HTH Dick On Wednesday, December 18, 2002, at 05:30 AM, Dick Applebaum wrote: Late to this thread (doing holiday things), but here's some pure JavaScript and a form that does what you want more. There are 2 select boxes: Available Topics, and Chosen Topics, prioritized. 1) you can move from one select box to the other 2) you can add new topics from a text field 3) you can move Chosen Topics up or down in the select box 4) you can email the chosen topics You could customize this into a tag or use CF to populate the select box etc. You can easily change the text boxes to dropdowns, etc. HTH Dick Valerie L. Criswell writes: I know I've seen it somewhere on my journeys. It's the tag that displays both a dropdown (populated from a query) as well as an accompanying text input so that the if the needed value isn't listed in the dropdown, the user can enter it into the text box. But only one variable for the value is sent. Anyone know where I can pick this up? I'm not sure what to search for on the DevX. I sure wish they would make a more powerful and relevant search tool. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: cferror
First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and may be pretty basic, but I learned a fair amount from the exercise APPLICATION.CFM file: !--- code for sending error message to web developer/site admin cferror type=exception template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] !--- code for person viewing web page--- cferror type=request template=error_page.cfm mailto=[EMAIL PROTECTED] ERROR_ADMIN.cfm: (file to send message to web page developer/admin) cfmail from=[EMAIL PROTECTED] subject=Web Site Error Report to=[EMAIL PROTECTED] type=html Error Date/Time: #DateFormat(Now())# at #TimeFormat(Now(),h:m tt)#p Viewers Browser: #http_user_agent#p Page error was generated: #error.template#p URL Query string of Client's request: #error.QueryString#p #error.diagnostics# /cfmail ERROR_PAGE.CFM (excerpt of page that viewer sees) We have logged the following information that will help us identify and correct the problem: UL LIError occurred at B#ERROR.Datetime#/B LIYour IP address is B#ERROR.RemoteAddress#/B LIYour browser is B#ERROR.Browser#/B LIYou were trying to process B#ERROR.Template#?#ERROR.QueryString#/B /UL If you can provide us with any additional information that would help us fix this problem, please send E-Mail to: A HREF=mailto:#ERROR.MailTo#;#ERROR.MailTo#/A. Tim Laureska -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:26 AM To: CF-Talk Subject: RE: cferror Here's my notes on cferror types (CF 4.5 SP2, Solaris, Oracle 8i): Chris Norloff type=expression - catches bad expression like select * from m_job_summary where job_id=#doesnt_exist# type=database - catches bad SQL like select * from m_job_summary GROUP ORDER BY - catches invalid column like select * from m_job_summary where doesnt_exist=10 type=missinginclude - catches missing cfincluded files - catches missing cfmodule files. type=lock - catches problem with lock, such as timing out while waiting to get exclusive access. type=any Catches things not caught by a previous cfcatch statement. Example: - timeout error. Sometimes timeout error has type COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT. Sometimes type is UNKNOWN and the message is Request timed out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: MM: Is the UK's CFMX the same as the US?
Yes. It's the same. Phil -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:03 AM To: [EMAIL PROTECTED] Cc: Phil Costa Subject: Re: MM: Is the UK's CFMX the same as the US? On Tuesday, Dec 17, 2002, at 10:41 US/Pacific, Matt Robertson wrote: Does anyone know if there any difference in the CFMX sold in the U.S. vs. the one sold in the United Kingdom? As far as I know, we only produce one set of English bits so, yes, the UK version should be the same as the US version. Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Announcement: CFMX Exam Buster Released
Awesome Brian! Right on time. I was going to take the CF5 test today. (I thought the CFMX test would be alot different since I've never used CFMX). I just took the demo test and got 78%. I had a couple lucky guesses on the UDF stuff, but I think I'll buy the app, wait a week and take the CFMX test. Any certified CFMXers taken the demo test? What're your opinions of it. Greg -Original Message- From: Brian Simmons [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 11:27 PM To: CF-Talk Subject: Announcement: CFMX Exam Buster Released CFMX Exam Buster from CentraSoft (http://www.centrasoft.com) CFMX Exam Buster is the ultimate testing tool specifically designed to help ColdFusion MX developers earn their ColdFusion MX Certification through the Macromedia Certified Professional Program. CFMX Exam Buster has over 750 questions designed to help you prepare for all aspects of the actual ColdFusion MX Certification exam. CFMX Exam Buster allows you to take eleven different tests, topic tests for your weak areas, and the ability to create random tests. During your test you can save your test in progress, submit comments, bookmark questions, pause your test, and much more. You can control the look and feel of the CFMX Exam Buster application, by controling the fonts, colors, and appearance of many controls, to create a studying environment with which you are comfortable. After your test is scored, you will be shown a comprehensive breakdown of your test results. There is a DEMO version on the Centrasoft website (http://www.centrasoft.com), which allows you to check out all the features of the program, plus one whole test. I'm always asked whether CFMX Exam Buster works, and I'm proud to say that I obtained my Advanced ColdFusion MX Developer Certification today (12/17/02) and the ONLY study aid I used was my own CFMX Exam Buster. Worked like a charm. Check out CFMX Exam Buster today! Thanks, Brian Simmons [EMAIL PROTECTED] The ultimate ColdFusion MX Certification Exam testing tool: Check out CFMX Exam Buster at: http://www.centrasoft.com ColdFusion MX, and Macromedia are registered trademarks of Macromedia Corporation. Macromedia Corporation in no way endorses or is affiliated with Centrasoft Corporation. ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Calling a component on solaris
Hi, I'm calling a component on a win2000 box like this: cfinvoke component=services.system.cfcs.lang method=MenuText returnvariable=linkLangNames cfinvokeargument name=lang value=#session.lang#/ /cfinvoke but this code is not working on a Solaris box. I get a Could not find the template services.system.cfcs.lang Any idea what I should take care of when I'm going from Windows to Solaris? Cheers Steini ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Calling a component on solaris
Assuming that the file structure and CF are setup exactly the same.. It could be a case-sensitivity issue ? HTH -Original Message- From: Steini Jonsson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 15:13 To: CF-Talk Subject: Calling a component on solaris Hi, I'm calling a component on a win2000 box like this: cfinvoke component=services.system.cfcs.lang method=MenuText returnvariable=linkLangNames cfinvokeargument name=lang value=#session.lang#/ /cfinvoke but this code is not working on a Solaris box. I get a Could not find the template services.system.cfcs.lang Any idea what I should take care of when I'm going from Windows to Solaris? Cheers Steini ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Converting a php script to cf
I am trying to convert a php script that reads a text file with email
addresses (1 per line) and puts them in a database into a CF script.
Here's the original php code
PHP
$filename=master_email.txt;
$fp=fopen($filename, r);
$EmailList = fread ($fp, filesize ($filename));
$EmailList = explode (\n,$EmailList);
$EmailList=(array_unique($EmailList));
$count=count($EmailList);
print $count.br;
sort($EmailList);
foreach($EmailList as $email)
{
if($email!=)
{
$query=Insert into $table_name (email) values ('$email');
$result=$conn-Execute($query); //Uses adodb db library
print $email.br;
}
}
Here's the CF code I have so far
CF
cffile
action = read
file = C:\inetpub\wwwroot\intranet\master_email.txt
variable = EmailList
I'm new at this so any help would be greatly appreciated.
Luis R. Lebron
Project Manager
Sigmatech, Inc
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
RE: CreateDateTime function??
In light of this new information my original suggestion still stands. If you format your data as a string (EX: ww:dd:hh:mm) then it will sort correctly (assuming you zero pad 3 = 03) and pure string comparison will yield correct results. ( 00:03:11:15 GT 00:03:11:25 ) -John- At 09:11 AM 12/18/2002 +, you wrote: Hi, My intention is to allow a user to select 'how long' eg, months, weeks, days, hours, minutes, it took to solve a problem, this information will then be stored as one field in the database. It is the intention that searches etc can be carried out on this information for comparison. Thanks for the help so far, Lisa -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 04:27 To: CF-Talk Subject: RE: CreateDateTime function?? Why add a date if you want to store an interval? I mean, if you want to calculate a new date it is the obvious route, but the request was to store it. Lisa: Can you confirm on your question? is, how to store the selected values into one field of my database? Am not sure what your purpose is behind all this. ***Logically.. you would just give a drop down of dates(MM-DD-) HH:MM*** If i understand the question correctly.. User comes in and selects something to happen(e.g Email me cheap flights after this period) 2 weeks 3 days 5 hours 10 minutes... Yes the question is how do you store weeks days hours and minutes... My understanding is a future dateTime has to be created and the database field would be a DateTime field.. in that case...? cfscript //create a default current date with form data... myDate=CreateDateTime(year(now()),month(now),day(now()),form.hrs,form.mins,s econd(now)); //adding weeks here myDate=DateAdd(ww,form.ww,myDate()); //adding days here myDate=DateAdd(d,form.dd,myDate()); /cfscript myDate would be the future date created from the form.. to be inserted into the database in one DateTime FIELD. Joe -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 6:58 PM To: CF-Talk Subject: Re: CreateDateTime function?? Joe Eugene wrote: All you need is create a default date and use function DateAdd(,defaultDate) and create whatever..date you want. Check previous post for code. Why add a date if you want to store an interval? I mean, if you want to calculate a new date it is the obvious route, but the request was to store it. Isn't creating a new date and converting that new date back to an interval when you need to extract the interval just a whole lot of extra hassle? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Converting a php script to cf
EmailList can be treated as a list with a cr/lf delimiter, if it's a
windows text file you can just use chr(10)
Something like
cfloop list=#EmailList# index=i delimiters=#chr(10)#
cfif len(i) gt 0 and find(@,i)
cfquery datasource=dsn name=whatever
INSERT into tblemails
(emailAddress)
values
('#i#')
/cfquery
/cfif
/cfloop
That's totally off the top of my head and hasn't been tested, but it's
not far off.
Good luck
-Original Message-
From: Luis Lebron [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2002 15:11
To: CF-Talk
Subject: Converting a php script to cf
I am trying to convert a php script that reads a text file with email
addresses (1 per line) and puts them in a database into a CF script.
Here's the original php code
PHP
$filename=master_email.txt;
$fp=fopen($filename, r);
$EmailList = fread ($fp, filesize ($filename));
$EmailList = explode (\n,$EmailList);
$EmailList=(array_unique($EmailList));
$count=count($EmailList);
print $count.br;
sort($EmailList);
foreach($EmailList as $email)
{
if($email!=)
{
$query=Insert into $table_name (email) values ('$email');
$result=$conn-Execute($query); //Uses adodb db library
print $email.br;
}
}
Here's the CF code I have so far
CF
cffile
action = read
file = C:\inetpub\wwwroot\intranet\master_email.txt
variable = EmailList
I'm new at this so any help would be greatly appreciated.
Luis R. Lebron
Project Manager
Sigmatech, Inc
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
RE: Converting a php script to cf
here u go
others can explain any code...
cfset newline = chr(13) chr(10)
cfset filename=master_email.txt
cffile action=read file=#filename# variable=Emails
cfset emailarray = ListToArray(#Emails#,#newline#))
!--- stript out duplicates here ---
cfoutput
#Arraylen(emailarray)#br
/cfoutput
cfloop from=1 to=#Arraylen(emailarray)# index=i
cfquery
insert into Table
(email)
values
('#emailarray[i]#')
/cfquery
cfoutput
#emailarray[i]#br
/cfoutput
/cfloop
WG
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Re: Calling a component on solaris
unfortunately case-sensitivity is not the problem - Original Message - From: Mike Townend [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 4:15 PM Subject: RE: Calling a component on solaris Assuming that the file structure and CF are setup exactly the same.. It could be a case-sensitivity issue ? HTH -Original Message- From: Steini Jonsson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 15:13 To: CF-Talk Subject: Calling a component on solaris Hi, I'm calling a component on a win2000 box like this: cfinvoke component=services.system.cfcs.lang method=MenuText returnvariable=linkLangNames cfinvokeargument name=lang value=#session.lang#/ /cfinvoke but this code is not working on a Solaris box. I get a Could not find the template services.system.cfcs.lang Any idea what I should take care of when I'm going from Windows to Solaris? Cheers Steini ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CreateDateTime function??
John Morgan wrote: In light of this new information my original suggestion still stands. If you format your data as a string (EX: ww:dd:hh:mm) then it will sort correctly (assuming you zero pad 3 = 03) and pure string comparison will yield correct results. ( 00:03:11:15 GT 00:03:11:25 ) But you can't do math on it without resorting to ugly workarounds. One of the nice parts of a good interval implementation in a DBMS is that many operations just work automatically. For example, if you want to add 2 intervals, just use interval + interval. Division/multiplication by numbers, substracting intervals, they all work using the normal arithmetic operators. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Disturbing CFMX Error
I never saw that message, but the first thing I would do is check the hard drive. It may be a sign of impending hard disk failure. Run diagnostics on it and listen to it to see if it is making strange noises. It could also be a sign of a problem with the controller or cable. First run a complete backup. Al a1webs.com Received the following error this afternoon in the standard debug display on all pages on the site: []java.io.FileNotFoundException: D:\CFusionMX\lib\neo-runtime.xml (The system cannot find the file specified) This cleared itself after 5-10 refreshes. Anyone else seen this? Any ideas? Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CreateDateTime function??
Good point. My method would make the data more readable in the database but your method would be more flexible. -John- At 04:54 PM 12/18/2002 +0100, you wrote: John Morgan wrote: In light of this new information my original suggestion still stands. If you format your data as a string (EX: ww:dd:hh:mm) then it will sort correctly (assuming you zero pad 3 = 03) and pure string comparison will yield correct results. ( 00:03:11:15 GT 00:03:11:25 ) But you can't do math on it without resorting to ugly workarounds. One of the nice parts of a good interval implementation in a DBMS is that many operations just work automatically. For example, if you want to add 2 intervals, just use interval + interval. Division/multiplication by numbers, substracting intervals, they all work using the normal arithmetic operators. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: CreateDateTime function??
John Morgan wrote:
Good point. My method would make the data more readable in the database but
your method would be more flexible.
More readable? The copy-pasted example below uses some non-standard
extensions like week and century, but you will get the point:
test=# create table ivtest (test interval);
test=# insert into ivtest values ('1 week 3 days 2 hours 45 seconds');
test=# insert into ivtest values ('1 century 2 years 4 months 42 week 3
days 17 hours 33 seconds');
test=# select * from ivtest;
test
10 days 02:00:45
102 years 4 mons 297 days 17:00:33
test=# select sum(test) from ivtest;
sum
102 years 4 mons 307 days 19:01:18
Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
RE: Restarting the ColdFusion MX Service - Solved
For those interested here is a bat file I setup to do the Restarting of the services. The problem seemed to be that Jrun.exe would not stop when stoping CFMX. So i had to use the kill command. You can find kill.exe in the Windows Resource Kit. This seems to solve it everytime. The cycling of IIS may not be necessary but it make me feel better. ECHO OFF NET STOP World Wide Web Publishing Service NET STOP ColdFusion MX Application Server NET STOP ColdFusion MX ODBC Agent NET STOP ColdFusion MX ODBC Server ECHO Killing JRun ... KILL jrun.exe ECHO JRun is Dead ... ECHO. NET START ColdFusion MX ODBC Agent NET START ColdFusion MX ODBC Server NET START ColdFusion MX Application Server NET START World Wide Web Publishing Service ECHO ON Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Mayer Sent: Tuesday, December 17, 2002 10:42 AM To: Mark Johnson; CF-Talk Subject: Re: Restarting the ColdFusion MX Service Somewhere I have read that restarting does not work properly sometimes ... service needs to be stopped and started. try a net stop ... and net start ... does that clear things? Best regards, Peter Orginale Nachricht Von: Mark Johnson [EMAIL PROTECTED] Betreff: Restarting the ColdFusion MX Service Datum/Zeit: Tuesday, 17. December 2002 17:59:20 Having a terrible time lately getting the CFMX service to start back up. When I restart the service i get the following message attempting to start up The ColdFusion MX Application Server service could not be started. Check the server default log files for more information. The information in the default_err.log is less then helpfull. The service will not run and I notice that jrun.exe is still running in the background. Anyone have any fool proof method for getting these things to cycle properly. The only thing so far that seems to clear it is a reboot. Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cferror
Hi, Tim. I implemented your approach below and it works well, except that when the request type error occurs, I do get the email sent to the admin, but the only thing that shows up in the browser is a blank screen. If I add your error_page.cfm code to the error_admin.cfm page then the admin email is sent, then the error message to the user is displayed. Why do we need two pages? (I assume that exception error code, being set to any will catch every type of error that occurs and therefore, the error_admin.cfm page will always be executed?) Thanks, Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:54 AM To: CF-Talk Subject: RE: cferror First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and may be pretty basic, but I learned a fair amount from the exercise APPLICATION.CFM file: !--- code for sending error message to web developer/site admin cferror type=exception template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] !--- code for person viewing web page--- cferror type=request template=error_page.cfm mailto=[EMAIL PROTECTED] ERROR_ADMIN.cfm: (file to send message to web page developer/admin) cfmail from=[EMAIL PROTECTED] subject=Web Site Error Report to=[EMAIL PROTECTED] type=html Error Date/Time: #DateFormat(Now())# at #TimeFormat(Now(),h:m tt)#p Viewers Browser: #http_user_agent#p Page error was generated: #error.template#p URL Query string of Client's request: #error.QueryString#p #error.diagnostics# /cfmail ERROR_PAGE.CFM (excerpt of page that viewer sees) We have logged the following information that will help us identify and correct the problem: UL LIError occurred at B#ERROR.Datetime#/B LIYour IP address is B#ERROR.RemoteAddress#/B LIYour browser is B#ERROR.Browser#/B LIYou were trying to process B#ERROR.Template#?#ERROR.QueryString#/B /UL If you can provide us with any additional information that would help us fix this problem, please send E-Mail to: A HREF=mailto:#ERROR.MailTo#;#ERROR.MailTo#/A. Tim Laureska -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:26 AM To: CF-Talk Subject: RE: cferror Here's my notes on cferror types (CF 4.5 SP2, Solaris, Oracle 8i): Chris Norloff type=expression - catches bad expression like select * from m_job_summary where job_id=#doesnt_exist# type=database - catches bad SQL like select * from m_job_summary GROUP ORDER BY - catches invalid column like select * from m_job_summary where doesnt_exist=10 type=missinginclude - catches missing cfincluded files - catches missing cfmodule files. type=lock - catches problem with lock, such as timing out while waiting to get exclusive access. type=any Catches things not caught by a previous cfcatch statement. Example: - timeout error. Sometimes timeout error has type COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT. Sometimes type is UNKNOWN and the message is Request timed out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Random Iterations
Hi Everyone, I have a problem I can't figure out and I am hoping someone on the list can help me figure out how to do it. I need to generate iteration tables. For Example: For a 3 digit iteration: All The possible combinations for these 3 digits; 1 2 3 I would end up with: 1 1,2,3 2 1,3,2 3 2,1,3 4 3,2,1 5 2,3,1 6 3,1,2 I need to auto generate tables with up to 15 digits. Can anyone figure out the code to do this? Any help would be appreciated. Thanks, Eric Dobris ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Disturbing CFMX Error
I'd also suggest installing latest service pack (sp3) if not done so already. Presuming you're running a windows environment of course. -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 15:58 To: CF-Talk Subject: Re: Disturbing CFMX Error I never saw that message, but the first thing I would do is check the hard drive. It may be a sign of impending hard disk failure. Run diagnostics on it and listen to it to see if it is making strange noises. It could also be a sign of a problem with the controller or cable. First run a complete backup. Al a1webs.com Received the following error this afternoon in the standard debug display on all pages on the site: []java.io.FileNotFoundException: D:\CFusionMX\lib\neo-runtime.xml (The system cannot find the file specified) This cleared itself after 5-10 refreshes. Anyone else seen this? Any ideas? Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Dynamic Application Variable and the Duplicate() Function
Well, I can set my dynamic variable just fine, but reading it appears to be an issue. Please let me know what you think about this: cflock type=readonly scope=application timeout=5 cfif isdefined(application.class#url.class#) cfset request.adList = duplicate(application.class#url.class#) /cfif /cflock The above throws an invalid expression format error. I've tried this a variety of ways but can't get it to work. The application variable is a two-dimensional array. Thanks, Ryan Farrell .:i:. Programmer Nuovo Technologies [EMAIL PROTECTED] 850-939-1548 x16 http://www.nuovotech.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Updater 2 woes Part ][
We decided to update our live MX servers with updater 2 even though the updater bombed on our development server. Stupid I know. But it worked! It worked rather well and solved many of our odd issues we couldn't code around. Just thought I should post an atta-boy since I (and most others) often post problems. As an aside I'd like to give props to Sean Corfield, Tom Harwood, Damon (the new guy I think), Debbie, and Christine (I think that was your name sorry if I got it wrong) for your hard work. cf_Rob surname=Rohan/ http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Dynamic Application Variable and the Duplicate() Function
Use bracket notation. This applies to any struct: cfset foo = application[class#url.class#] === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:46 AM To: CF-Talk Subject: Dynamic Application Variable and the Duplicate() Function Well, I can set my dynamic variable just fine, but reading it appears to be an issue. Please let me know what you think about this: cflock type=readonly scope=application timeout=5 cfif isdefined(application.class#url.class#) cfset request.adList = duplicate(application.class#url.class#) /cfif /cflock The above throws an invalid expression format error. I've tried this a variety of ways but can't get it to work. The application variable is a two-dimensional array. Thanks, Ryan Farrell .:i:. Programmer Nuovo Technologies [EMAIL PROTECTED] 850-939-1548 x16 http://www.nuovotech.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Calling a component on solaris
Ok I found it.. duhh Some time ago I added a customtags path on the Windows box, so that I could use relative paths with components. I just forgot about it... Now it's working perfectly. Cheers Steini - Original Message - From: Steini Jonsson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 4:43 PM Subject: Re: Calling a component on solaris unfortunately case-sensitivity is not the problem - Original Message - From: Mike Townend [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 4:15 PM Subject: RE: Calling a component on solaris Assuming that the file structure and CF are setup exactly the same.. It could be a case-sensitivity issue ? HTH -Original Message- From: Steini Jonsson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 15:13 To: CF-Talk Subject: Calling a component on solaris Hi, I'm calling a component on a win2000 box like this: cfinvoke component=services.system.cfcs.lang method=MenuText returnvariable=linkLangNames cfinvokeargument name=lang value=#session.lang#/ /cfinvoke but this code is not working on a Solaris box. I get a Could not find the template services.system.cfcs.lang Any idea what I should take care of when I'm going from Windows to Solaris? Cheers Steini ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Updater 2 woes Part ][
Anyone figured out why it bombs on some systems and not others? We are paranoid to install the new one. The 1st updater worked great on two of our servers, and the 3rd server we had to re-configure everything. -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:00 PM To: CF-Talk Subject: Updater 2 woes Part ][ We decided to update our live MX servers with updater 2 even though the updater bombed on our development server. Stupid I know. But it worked! It worked rather well and solved many of our odd issues we couldn't code around. Just thought I should post an atta-boy since I (and most others) often post problems. As an aside I'd like to give props to Sean Corfield, Tom Harwood, Damon (the new guy I think), Debbie, and Christine (I think that was your name sorry if I got it wrong) for your hard work. cf_Rob surname=Rohan/ http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Dynamic Application Variable and the Duplicate() Function
Cool, thanks! -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:59 AM To: CF-Talk Subject: RE: Dynamic Application Variable and the Duplicate() Function Use bracket notation. This applies to any struct: cfset foo = application[class#url.class#] === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:46 AM To: CF-Talk Subject: Dynamic Application Variable and the Duplicate() Function Well, I can set my dynamic variable just fine, but reading it appears to be an issue. Please let me know what you think about this: cflock type=readonly scope=application timeout=5 cfif isdefined(application.class#url.class#) cfset request.adList = duplicate(application.class#url.class#) /cfif /cflock The above throws an invalid expression format error. I've tried this a variety of ways but can't get it to work. The application variable is a two-dimensional array. Thanks, Ryan Farrell .:i:. Programmer Nuovo Technologies [EMAIL PROTECTED] 850-939-1548 x16 http://www.nuovotech.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Random SQL statement
I have a table with a Unique ID field and I would like to do a random select on the table UID. Basically I want to send the user to a page that displays that random record. Does SQL have a random function? I cant find anything in my books. SELECT rand(ID) FROM table Or should I select all records from the table and use CF to pick a random record from the dataset? Thanks, Chad ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Random Iterations
That requires a pretty intense algorithm, you going to be doing this often? I'd recommend doing this in C or Java... What platform? If it's the same 15 numbers just do it once ! WG -Original Message- From: Dobris, Eric [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 16:45 To: CF-Talk Subject: Random Iterations Hi Everyone, I have a problem I can't figure out and I am hoping someone on the list can help me figure out how to do it. I need to generate iteration tables. For Example: For a 3 digit iteration: All The possible combinations for these 3 digits; 1 2 3 I would end up with: 1 1,2,3 2 1,3,2 3 2,1,3 4 3,2,1 5 2,3,1 6 3,1,2 I need to auto generate tables with up to 15 digits. Can anyone figure out the code to do this? Any help would be appreciated. Thanks, Eric Dobris ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Random SQL statement
If you are using sqlserver then you could use a stored proc...we use... CREATE PROCEDURE [dbo].[spr_randomrecord] AS DECLARE @Rows int SET @Rows = SELECT Max(ID) FROM Tables get_random: SELECT * FROM Table WHERE ID = (SELECT CAST((RAND() * @Rows) AS int) + 1) IF (@@rowcount = 0) GOTO get_random GO You just need to change the relevant table and id names HTH -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 17:09 To: CF-Talk Subject: Random SQL statement I have a table with a Unique ID field and I would like to do a random select on the table UID. Basically I want to send the user to a page that displays that random record. Does SQL have a random function? I cant find anything in my books. SELECT rand(ID) FROM table Or should I select all records from the table and use CF to pick a random record from the dataset? Thanks, Chad ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Random SQL statement
This link goes into this in depth. http://www.aspalliance.com/stevesmith/articles/randomselect.asp ~Jason -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:09 PM To: CF-Talk Subject: Random SQL statement I have a table with a Unique ID field and I would like to do a random select on the table UID. Basically I want to send the user to a page that displays that random record. Does SQL have a random function? I cant find anything in my books. SELECT rand(ID) FROM table Or should I select all records from the table and use CF to pick a random record from the dataset? Thanks, Chad ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: cferror
Even though you've implemented CFERROR to catch EXCEPTIONS, you should still have another CFERROR with REQUEST in case your EXCEPTION handling page ever generates an error. If it does, it will be caught by the REQUEST CFERROR. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:42 AM To: CF-Talk Subject: RE: cferror Hi, Tim. I implemented your approach below and it works well, except that when the request type error occurs, I do get the email sent to the admin, but the only thing that shows up in the browser is a blank screen. If I add your error_page.cfm code to the error_admin.cfm page then the admin email is sent, then the error message to the user is displayed. Why do we need two pages? (I assume that exception error code, being set to any will catch every type of error that occurs and therefore, the error_admin.cfm page will always be executed?) Thanks, Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:54 AM To: CF-Talk Subject: RE: cferror First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and may be pretty basic, but I learned a fair amount from the exercise APPLICATION.CFM file: !--- code for sending error message to web developer/site admin cferror type=exception template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] !--- code for person viewing web page--- cferror type=request template=error_page.cfm mailto=[EMAIL PROTECTED] ERROR_ADMIN.cfm: (file to send message to web page developer/admin) cfmail from=[EMAIL PROTECTED] subject=Web Site Error Report to=[EMAIL PROTECTED] type=html Error Date/Time: #DateFormat(Now())# at #TimeFormat(Now(),h:m tt)#p Viewers Browser: #http_user_agent#p Page error was generated: #error.template#p URL Query string of Client's request: #error.QueryString#p #error.diagnostics# /cfmail ERROR_PAGE.CFM (excerpt of page that viewer sees) We have logged the following information that will help us identify and correct the problem: UL LIError occurred at B#ERROR.Datetime#/B LIYour IP address is B#ERROR.RemoteAddress#/B LIYour browser is B#ERROR.Browser#/B LIYou were trying to process B#ERROR.Template#?#ERROR.QueryString#/B /UL If you can provide us with any additional information that would help us fix this problem, please send E-Mail to: A HREF=mailto:#ERROR.MailTo#;#ERROR.MailTo#/A. Tim Laureska -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:26 AM To: CF-Talk Subject: RE: cferror Here's my notes on cferror types (CF 4.5 SP2, Solaris, Oracle 8i): Chris Norloff type=expression - catches bad expression like select * from m_job_summary where job_id=#doesnt_exist# type=database - catches bad SQL like select * from m_job_summary GROUP ORDER BY - catches invalid column like select * from m_job_summary where doesnt_exist=10 type=missinginclude - catches missing cfincluded files - catches missing cfmodule files. type=lock - catches problem with lock, such as timing out while waiting to get exclusive access. type=any Catches things not caught by a previous cfcatch statement. Example: - timeout error. Sometimes timeout error has type COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT. Sometimes type is UNKNOWN and the message is Request timed out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Random Iterations
If I wanted to do this, I would look up combinatorics on Google. There are a lot of sites that have javascripts that do exactly this. It depends on how many items you have as to the processing power it would take to compute these. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:15 PM To: CF-Talk Subject: RE: Random Iterations That requires a pretty intense algorithm, you going to be doing this often? I'd recommend doing this in C or Java... What platform? If it's the same 15 numbers just do it once ! WG -Original Message- From: Dobris, Eric [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 16:45 To: CF-Talk Subject: Random Iterations Hi Everyone, I have a problem I can't figure out and I am hoping someone on the list can help me figure out how to do it. I need to generate iteration tables. For Example: For a 3 digit iteration: All The possible combinations for these 3 digits; 1 2 3 I would end up with: 1 1,2,3 2 1,3,2 3 2,1,3 4 3,2,1 5 2,3,1 6 3,1,2 I need to auto generate tables with up to 15 digits. Can anyone figure out the code to do this? Any help would be appreciated. Thanks, Eric Dobris ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: cferror
Hey... we added this to our error page... works like a charm: cfmail to=[EMAIL PROTECTED] cc=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Cold Fusion Error type=HTML CFDump var=#error#CFDump var=#cgi#/cfmail Gives a ton of diagnostic data that usually helps us in finding/reproducing the source of the error. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:42 AM To: CF-Talk Subject: RE: cferror Hi, Tim. I implemented your approach below and it works well, except that when the request type error occurs, I do get the email sent to the admin, but the only thing that shows up in the browser is a blank screen. If I add your error_page.cfm code to the error_admin.cfm page then the admin email is sent, then the error message to the user is displayed. Why do we need two pages? (I assume that exception error code, being set to any will catch every type of error that occurs and therefore, the error_admin.cfm page will always be executed?) Thanks, Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:54 AM To: CF-Talk Subject: RE: cferror First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and may be pretty basic, but I learned a fair amount from the exercise APPLICATION.CFM file: !--- code for sending error message to web developer/site admin cferror type=exception template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] !--- code for person viewing web page--- cferror type=request template=error_page.cfm mailto=[EMAIL PROTECTED] ERROR_ADMIN.cfm: (file to send message to web page developer/admin) cfmail from=[EMAIL PROTECTED] subject=Web Site Error Report to=[EMAIL PROTECTED] type=html Error Date/Time: #DateFormat(Now())# at #TimeFormat(Now(),h:m tt)#p Viewers Browser: #http_user_agent#p Page error was generated: #error.template#p URL Query string of Client's request: #error.QueryString#p #error.diagnostics# /cfmail ERROR_PAGE.CFM (excerpt of page that viewer sees) We have logged the following information that will help us identify and correct the problem: UL LIError occurred at B#ERROR.Datetime#/B LIYour IP address is B#ERROR.RemoteAddress#/B LIYour browser is B#ERROR.Browser#/B LIYou were trying to process B#ERROR.Template#?#ERROR.QueryString#/B /UL If you can provide us with any additional information that would help us fix this problem, please send E-Mail to: A HREF=mailto:#ERROR.MailTo#;#ERROR.MailTo#/A. Tim Laureska -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:26 AM To: CF-Talk Subject: RE: cferror Here's my notes on cferror types (CF 4.5 SP2, Solaris, Oracle 8i): Chris Norloff type=expression - catches bad expression like select * from m_job_summary where job_id=#doesnt_exist# type=database - catches bad SQL like select * from m_job_summary GROUP ORDER BY - catches invalid column like select * from m_job_summary where doesnt_exist=10 type=missinginclude - catches missing cfincluded files - catches missing cfmodule files. type=lock - catches problem with lock, such as timing out while waiting to get exclusive access. type=any Catches things not caught by a previous cfcatch statement. Example: - timeout error. Sometimes timeout error has type COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT. Sometimes type is UNKNOWN and the message is Request timed out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: debug report/image magick with cfexecute
That, sir, is the correct answer. Thank you. -Original Message- From: webguy [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:44 AM To: CF-Talk Subject: RE: debug report/image magick with cfexecute Actually it is probably because you haven't specified a timeout == from docs = timeout Optional 0 Length of time, in seconds, that ColdFusion waits for output from the spawned program. 0: equivalent to non-blocking mode. A very high value: equivalent to blocking mode If the value is 0: ColdFusion starts a process and returns immediately. ColdFusion may return control to the calling page before any program output displays. To ensure that program output displays, set the value to 2 or higher. If the outputFile attribute is not specified, any program output is discarded == from docs = ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Random Iterations -
BTW you know there are 1,307,674,368,000 different non-ordered sets WG -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 17:15 To: CF-Talk Subject: RE: Random Iterations That requires a pretty intense algorithm, you going to be doing this often? I'd recommend doing this in C or Java... What platform? If it's the same 15 numbers just do it once ! WG -Original Message- From: Dobris, Eric [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 16:45 To: CF-Talk Subject: Random Iterations Hi Everyone, I have a problem I can't figure out and I am hoping someone on the list can help me figure out how to do it. I need to generate iteration tables. For Example: For a 3 digit iteration: All The possible combinations for these 3 digits; 1 2 3 I would end up with: 1 1,2,3 2 1,3,2 3 2,1,3 4 3,2,1 5 2,3,1 6 3,1,2 I need to auto generate tables with up to 15 digits. Can anyone figure out the code to do this? Any help would be appreciated. Thanks, Eric Dobris ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cferror
So, it would be best to have the code to send an email to the admin and the code to display the error message to the user on the page that is called when the Exception error is triggered... Then, if the Exception trigger errors, the regular Request error page will kick in and display the normal error message to the user without the admin email being sent, since CF Tags can be used with Request error pages. Am I getting this? Also, I've got the code for the error page just below the CFAPPLICATION tag like this: CFERROR Type=exception Template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] CFERROR Type=request Template=error_page.cfm mailto=[EMAIL PROTECTED] Then, the rest of the page's code. Do I need any kind of Catch/Try to bypass the Request Error code above if the Exception Error code is processed? I would guess not, since when the Exception Error code is processed, everything comes to a halt, anyway...right? Thanks for your insights. Rick -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:18 PM To: CF-Talk Subject: RE: cferror Even though you've implemented CFERROR to catch EXCEPTIONS, you should still have another CFERROR with REQUEST in case your EXCEPTION handling page ever generates an error. If it does, it will be caught by the REQUEST CFERROR. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:42 AM To: CF-Talk Subject: RE: cferror Hi, Tim. I implemented your approach below and it works well, except that when the request type error occurs, I do get the email sent to the admin, but the only thing that shows up in the browser is a blank screen. If I add your error_page.cfm code to the error_admin.cfm page then the admin email is sent, then the error message to the user is displayed. Why do we need two pages? (I assume that exception error code, being set to any will catch every type of error that occurs and therefore, the error_admin.cfm page will always be executed?) Thanks, Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:54 AM To: CF-Talk Subject: RE: cferror First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and may be pretty basic, but I learned a fair amount from the exercise APPLICATION.CFM file: !--- code for sending error message to web developer/site admin cferror type=exception template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] !--- code for person viewing web page--- cferror type=request template=error_page.cfm mailto=[EMAIL PROTECTED] ERROR_ADMIN.cfm: (file to send message to web page developer/admin) cfmail from=[EMAIL PROTECTED] subject=Web Site Error Report to=[EMAIL PROTECTED] type=html Error Date/Time: #DateFormat(Now())# at #TimeFormat(Now(),h:m tt)#p Viewers Browser: #http_user_agent#p Page error was generated: #error.template#p URL Query string of Client's request: #error.QueryString#p #error.diagnostics# /cfmail ERROR_PAGE.CFM (excerpt of page that viewer sees) We have logged the following information that will help us identify and correct the problem: UL LIError occurred at B#ERROR.Datetime#/B LIYour IP address is B#ERROR.RemoteAddress#/B LIYour browser is B#ERROR.Browser#/B LIYou were trying to process B#ERROR.Template#?#ERROR.QueryString#/B /UL If you can provide us with any additional information that would help us fix this problem, please send E-Mail to: A HREF=mailto:#ERROR.MailTo#;#ERROR.MailTo#/A. Tim Laureska -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:26 AM To: CF-Talk Subject: RE: cferror Here's my notes on cferror types (CF 4.5 SP2, Solaris, Oracle 8i): Chris Norloff type=expression - catches bad expression like select * from m_job_summary where job_id=#doesnt_exist# type=database - catches bad SQL like select * from m_job_summary GROUP ORDER BY - catches invalid column like select * from m_job_summary where doesnt_exist=10 type=missinginclude - catches missing cfincluded files - catches missing cfmodule files. type=lock - catches problem with lock, such as timing out while waiting to get exclusive access. type=any Catches things not caught by a previous cfcatch statement. Example: - timeout error. Sometimes timeout error has type
RE: Random SQL statement
I think you can modify the following to do what you want. CFOUTPUT QUERY=RandHint STARTROW=#randrange(1,RandHint.recordcount)# MAXROWS=1#RandHint.Hints#/cfoutput best, paul At 12:15 PM 12/18/02 -0500, you wrote: This link goes into this in depth. http://www.aspalliance.com/stevesmith/articles/randomselect.asp ~Jason -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:09 PM To: CF-Talk Subject: Random SQL statement I have a table with a Unique ID field and I would like to do a random select on the table UID. Basically I want to send the user to a page that displays that random record. Does SQL have a random function? I cant find anything in my books. SELECT rand(ID) FROM table Or should I select all records from the table and use CF to pick a random record from the dataset? Thanks, Chad ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Another Disturbing MX Error
Error,jrpp-293,12/18/02,12:28:21,,null The specific sequence of files included or processed is: null java.lang.OutOfMemoryError I had the following error occur yesterday and today once. When it happens you have to do a complete CF cycle. The ColdFusion Java VM MAX setting is still at its default of 512Mb and the machine has 1gig of ram. When i checked the jrun.exe process it was running around 360Mb. Any ideas? Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: cferror
Wish I could use the CFDump tag...I'm still on CF 4.5.2... Would it be worth it to setup the CFDump custom tag that I believe is available for pre-MX (?) versions? Rick -Original Message- From: jon roig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:30 PM To: CF-Talk Subject: RE: cferror Hey... we added this to our error page... works like a charm: cfmail to=[EMAIL PROTECTED] cc=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Cold Fusion Error type=HTML CFDump var=#error#CFDump var=#cgi#/cfmail Gives a ton of diagnostic data that usually helps us in finding/reproducing the source of the error. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:42 AM To: CF-Talk Subject: RE: cferror Hi, Tim. I implemented your approach below and it works well, except that when the request type error occurs, I do get the email sent to the admin, but the only thing that shows up in the browser is a blank screen. If I add your error_page.cfm code to the error_admin.cfm page then the admin email is sent, then the error message to the user is displayed. Why do we need two pages? (I assume that exception error code, being set to any will catch every type of error that occurs and therefore, the error_admin.cfm page will always be executed?) Thanks, Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:54 AM To: CF-Talk Subject: RE: cferror First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and may be pretty basic, but I learned a fair amount from the exercise APPLICATION.CFM file: !--- code for sending error message to web developer/site admin cferror type=exception template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] !--- code for person viewing web page--- cferror type=request template=error_page.cfm mailto=[EMAIL PROTECTED] ERROR_ADMIN.cfm: (file to send message to web page developer/admin) cfmail from=[EMAIL PROTECTED] subject=Web Site Error Report to=[EMAIL PROTECTED] type=html Error Date/Time: #DateFormat(Now())# at #TimeFormat(Now(),h:m tt)#p Viewers Browser: #http_user_agent#p Page error was generated: #error.template#p URL Query string of Client's request: #error.QueryString#p #error.diagnostics# /cfmail ERROR_PAGE.CFM (excerpt of page that viewer sees) We have logged the following information that will help us identify and correct the problem: UL LIError occurred at B#ERROR.Datetime#/B LIYour IP address is B#ERROR.RemoteAddress#/B LIYour browser is B#ERROR.Browser#/B LIYou were trying to process B#ERROR.Template#?#ERROR.QueryString#/B /UL If you can provide us with any additional information that would help us fix this problem, please send E-Mail to: A HREF=mailto:#ERROR.MailTo#;#ERROR.MailTo#/A. Tim Laureska -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:26 AM To: CF-Talk Subject: RE: cferror Here's my notes on cferror types (CF 4.5 SP2, Solaris, Oracle 8i): Chris Norloff type=expression - catches bad expression like select * from m_job_summary where job_id=#doesnt_exist# type=database - catches bad SQL like select * from m_job_summary GROUP ORDER BY - catches invalid column like select * from m_job_summary where doesnt_exist=10 type=missinginclude - catches missing cfincluded files - catches missing cfmodule files. type=lock - catches problem with lock, such as timing out while waiting to get exclusive access. type=any Catches things not caught by a previous cfcatch statement. Example: - timeout error. Sometimes timeout error has type COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT. Sometimes type is UNKNOWN and the message is Request timed out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
OT: AOL?
Is anyone having any difficulty sending mail to AOL??? I have been unable to send mail to aol for the past 2 days My IPS are not blacklisted... I cannot figure this out... Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Random Iterations -
Yes, I just need to be able to generate them and choose 40 random combinations. I don't need to actually buld a table with 1,307,674,368,000 rows. Eric -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:37 PM To: CF-Talk Subject: RE: Random Iterations - BTW you know there are 1,307,674,368,000 different non-ordered sets WG -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 17:15 To: CF-Talk Subject: RE: Random Iterations That requires a pretty intense algorithm, you going to be doing this often? I'd recommend doing this in C or Java... What platform? If it's the same 15 numbers just do it once ! WG -Original Message- From: Dobris, Eric [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 16:45 To: CF-Talk Subject: Random Iterations Hi Everyone, I have a problem I can't figure out and I am hoping someone on the list can help me figure out how to do it. I need to generate iteration tables. For Example: For a 3 digit iteration: All The possible combinations for these 3 digits; 1 2 3 I would end up with: 1 1,2,3 2 1,3,2 3 2,1,3 4 3,2,1 5 2,3,1 6 3,1,2 I need to auto generate tables with up to 15 digits. Can anyone figure out the code to do this? Any help would be appreciated. Thanks, Eric Dobris ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CreateDateTime function??
thanks for all your help guys, i got it sorted,
Lisa
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2002 16:18
To: CF-Talk
Subject: Re: CreateDateTime function??
John Morgan wrote:
Good point. My method would make the data more readable in the database
but
your method would be more flexible.
More readable? The copy-pasted example below uses some non-standard
extensions like week and century, but you will get the point:
test=# create table ivtest (test interval);
test=# insert into ivtest values ('1 week 3 days 2 hours 45 seconds');
test=# insert into ivtest values ('1 century 2 years 4 months 42 week 3
days 17 hours 33 seconds');
test=# select * from ivtest;
test
10 days 02:00:45
102 years 4 mons 297 days 17:00:33
test=# select sum(test) from ivtest;
sum
102 years 4 mons 307 days 19:01:18
Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: OT: AOL?
At 17:49 18/12/2002 Kris Pilles said Is anyone having any difficulty sending mail to AOL??? I have been unable to send mail to aol for the past 2 days My IPS are not blacklisted... I cannot figure this out... What do you have your Max Recpt set for? I think from others AOL will refuse if you try and deliver more than 10 in a single connection. Try delivering a single email and see if that gets through. Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Updater 2 woes Part ][
Good to hear, We had a couple snags when installing a new server (Solaris) and installing the Updater right away but we eventually got it working. Seems it installs a precompiled admin which may cause some strange behaviour if u install the cfide outside the default location. P.S. Damon certainly not the new guy...but he's certainly been active in the community lately which is great! Cheers, Stace -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:00 PM To: CF-Talk Subject: Updater 2 woes Part ][ We decided to update our live MX servers with updater 2 even though the updater bombed on our development server. Stupid I know. But it worked! It worked rather well and solved many of our odd issues we couldn't code around. Just thought I should post an atta-boy since I (and most others) often post problems. As an aside I'd like to give props to Sean Corfield, Tom Harwood, Damon (the new guy I think), Debbie, and Christine (I think that was your name sorry if I got it wrong) for your hard work. cf_Rob surname=Rohan/ http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Random Iterations -
Just 40 random ones ? Well that would be easier :-) The issue then is, how random? Random is relative, random for a bicycle lock or random to arm a nuke? ;-] WG -Original Message- From: Dobris, Eric [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 17:58 To: CF-Talk Subject: RE: Random Iterations - Yes, I just need to be able to generate them and choose 40 random combinations. I don't need to actually buld a table with 1,307,674,368,000 rows. Eric -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:37 PM To: CF-Talk Subject: RE: Random Iterations - BTW you know there are 1,307,674,368,000 different non-ordered sets WG -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 17:15 To: CF-Talk Subject: RE: Random Iterations That requires a pretty intense algorithm, you going to be doing this often? I'd recommend doing this in C or Java... What platform? If it's the same 15 numbers just do it once ! WG -Original Message- From: Dobris, Eric [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 16:45 To: CF-Talk Subject: Random Iterations Hi Everyone, I have a problem I can't figure out and I am hoping someone on the list can help me figure out how to do it. I need to generate iteration tables. For Example: For a 3 digit iteration: All The possible combinations for these 3 digits; 1 2 3 I would end up with: 1 1,2,3 2 1,3,2 3 2,1,3 4 3,2,1 5 2,3,1 6 3,1,2 I need to auto generate tables with up to 15 digits. Can anyone figure out the code to do this? Any help would be appreciated. Thanks, Eric Dobris ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: OT: AOL?
No good This sucks... MY clients are starting to notice this too. Weird thing is the mail just disappears... No bounce back or anything like that... KP -Original Message- From: Gordon Burns [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:00 PM To: CF-Talk Subject: Re: OT: AOL? At 17:49 18/12/2002 Kris Pilles said Is anyone having any difficulty sending mail to AOL??? I have been unable to send mail to aol for the past 2 days My IPS are not blacklisted... I cannot figure this out... What do you have your Max Recpt set for? I think from others AOL will refuse if you try and deliver more than 10 in a single connection. Try delivering a single email and see if that gets through. Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Strange CFAS 5 Error
Why would: cfoutput #VARIABLES.start# br #REQUEST.LISTINGS.MAXROWS# /cfoutput cfset variables.end = variables.start + request.listings.maxrows - 1 Where Variables.start=51 and request.listings.maxrows=50 throw this error: An error occurred while evaluating the expression: variables.end = variables.start + request.listings.maxrows - 1 Error near line 16, column 7. Cannot convert 51Please, check the ColdFusion manual for the allowed conversions between data types === repeatedly? best, paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: OT: AOL?
I set Max Recpt = 1 At 01:15 PM 12/18/02 -0500, you wrote: No good This sucks... MY clients are starting to notice this too. Weird thing is the mail just disappears... No bounce back or anything like that... That's the AOL way best, paul KP -Original Message- From: Gordon Burns [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:00 PM To: CF-Talk Subject: Re: OT: AOL? At 17:49 18/12/2002 Kris Pilles said Is anyone having any difficulty sending mail to AOL??? I have been unable to send mail to aol for the past 2 days My IPS are not blacklisted... I cannot figure this out... What do you have your Max Recpt set for? I think from others AOL will refuse if you try and deliver more than 10 in a single connection. Try delivering a single email and see if that gets through. Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: OT: AOL?
AOL has their own rules (and, believe it or not, they are not consistant among their servers) and they tend to send mail into a black hole (never to be seen or heard from again) if one of their mystery rules are upset. You can find *some* help here: http://postmaster.info.aol.com/ HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Kris Pilles [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:15 PM Subject: RE: OT: AOL? No good This sucks... MY clients are starting to notice this too. Weird thing is the mail just disappears... No bounce back or anything like that... KP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT: AOL?
That's what I went to. I found just blasting out the mail results in a few getting thru, then the sender is blocked for an indeterminate (but fairly short) period of time. I have a client that's a medical association. They have a large member mailing list with a TON of AOL addresses. I built a mailer that loops over a query and sends an individual email to each recipient AND throttles down the speed of the operation, so as not to flood my mail queue with recipients, or trigger whatever floodgate-alert AOL has in place. Uses cfmail, its query parameter and startrow/maxrows parms. The safe speed I found is disgustingly slow. 10 messages every 17 seconds, and it was important to tie in my mail spool interval (cf admin) to the job. I have a 15 second interval there, so the throttling never doubles up two loads of mail in the queue. Also related is how fast your mail server can send the messages once they arrive in that queue. I also found this to be an issue with msn/hotmail. Throttling the mail solves the problem. You can probably go faster than 10 every 17 secs. Like I said... Disgustingly slow. I just was charged with a guaranteed safe speed and that's what I eventually settled on. Would love to hear any specifics from anyone else with experience on this. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Gordon Burns [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:00 AM To: CF-Talk Subject: Re: OT: AOL? At 17:49 18/12/2002 Kris Pilles said Is anyone having any difficulty sending mail to AOL??? I have been unable to send mail to aol for the past 2 days My IPS are not blacklisted... I cannot figure this out... What do you have your Max Recpt set for? I think from others AOL will refuse if you try and deliver more than 10 in a single connection. Try delivering a single email and see if that gets through. Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT: AOL?
Damn aol.. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:29 PM To: CF-Talk Subject: RE: OT: AOL? That's what I went to. I found just blasting out the mail results in a few getting thru, then the sender is blocked for an indeterminate (but fairly short) period of time. I have a client that's a medical association. They have a large member mailing list with a TON of AOL addresses. I built a mailer that loops over a query and sends an individual email to each recipient AND throttles down the speed of the operation, so as not to flood my mail queue with recipients, or trigger whatever floodgate-alert AOL has in place. Uses cfmail, its query parameter and startrow/maxrows parms. The safe speed I found is disgustingly slow. 10 messages every 17 seconds, and it was important to tie in my mail spool interval (cf admin) to the job. I have a 15 second interval there, so the throttling never doubles up two loads of mail in the queue. Also related is how fast your mail server can send the messages once they arrive in that queue. I also found this to be an issue with msn/hotmail. Throttling the mail solves the problem. You can probably go faster than 10 every 17 secs. Like I said... Disgustingly slow. I just was charged with a guaranteed safe speed and that's what I eventually settled on. Would love to hear any specifics from anyone else with experience on this. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Gordon Burns [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:00 AM To: CF-Talk Subject: Re: OT: AOL? At 17:49 18/12/2002 Kris Pilles said Is anyone having any difficulty sending mail to AOL??? I have been unable to send mail to aol for the past 2 days My IPS are not blacklisted... I cannot figure this out... What do you have your Max Recpt set for? I think from others AOL will refuse if you try and deliver more than 10 in a single connection. Try delivering a single email and see if that gets through. Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: OT: AOL?
On 12/18/02, Kris Pilles penned: No good This sucks... MY clients are starting to notice this too. Weird thing is the mail just disappears... No bounce back or anything like that... I occasionally have similar problems. I ALWAYS use them as an opportunity to point out to my client that they are LIKELY losing other e-mails, some which may be important. I point out to them (as Howie did to you) that they don't generally bounce the e-mails, so the sender has no way of knowing what the problem is so they may rectify it, or even if there is a problem on his/her end and that the best course of action is to dump AOL for a true ISP. That said, I do have an AOL account which I use for testing web sites. Email address is buddy123. I'll be glad to check the account if you want to send something there. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
cf server randomly changing the case of file paths in windows
Windows 2000 Server, SP 3 IIS 5 CF 5 I'm using this in the application.cfm and in a user defined function which is used elsewhere in the app... getdirectoryfrompath(getcurrenttemplatepath()) the actual path is: C:\Inetpub\wwwroot\dev\etc... however, these functions don't return this in either place -- nor do they return a consistent result, instead they return: application.cfm = c:\inetpub\wwwroot\dev\etc... ( as though lcase() -- no lcase() function is used ) user defined function = C:\INETPUB\WWWROOT\DEV\ETC... ( as though ucase() -- no ucase() function is used ) Anybody have any ideas? I wouldn't worry about it too much accept that I'm trying to make the application *nix compatible, so I can't use comparenocase() on file paths because *nix users may legitimately have 2 directories with the same name and comparenocase() would screw that up. But if I can't change this behavior, then I can't use it in Windows. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CF and Authorize.net
Hi, Authorize.net is pretty easy to implement (although I don't find it so secure to put username and password into the source code). Just POST the information with CFHTTP and evaluate the response string via CFHTTP.FILECONTENT. It's a comma seperated list, so you can use either ListGetAt or ListToArray to evaluate. Mahmut Basaran Measure Twice Cut Once - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 11:27 PM Subject: CF and Authorize.net Hey All, I'm trying to implement the WebLink service offered by Authorize.net. I want to have them handle the cc info collection and send the response back to my server (all very easy to do). The issue is that Authorize.net's tech support doesn't seem to be able to tell me the name of the huge response string the POST back to my server (they just say it's in the guide...ya right). Apparently this monster string is a list of key/value pairs (should be dead simple to parse using ListGetAt()). the problem is that nobody can tell me what the freakin name of the string is...so how do I reference it?? I'm sure I can just do a test Tx and see what gets passed back, but right now I'm waiting on merchant info from the client and can't do a test Tx. So if anybody knows waht this mystery string is named, please fire it my way. Thanks in advance ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT: AOL?
Aol says my reverse DNS is not up But everything on my server appears to be working fine I guess its my fault after all lol -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:44 PM To: CF-Talk Subject: RE: OT: AOL? On 12/18/02, Kris Pilles penned: No good This sucks... MY clients are starting to notice this too. Weird thing is the mail just disappears... No bounce back or anything like that... I occasionally have similar problems. I ALWAYS use them as an opportunity to point out to my client that they are LIKELY losing other e-mails, some which may be important. I point out to them (as Howie did to you) that they don't generally bounce the e-mails, so the sender has no way of knowing what the problem is so they may rectify it, or even if there is a problem on his/her end and that the best course of action is to dump AOL for a true ISP. That said, I do have an AOL account which I use for testing web sites. Email address is buddy123. I'll be glad to check the account if you want to send something there. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Another Disturbing MX Error
On Wednesday, Dec 18, 2002, at 09:43 US/Pacific, Mark Johnson wrote: Error,jrpp-293,12/18/02,12:28:21,,null The specific sequence of files included or processed is: null java.lang.OutOfMemoryError I had the following error occur yesterday and today once. When it happens you have to do a complete CF cycle. The ColdFusion Java VM MAX setting is still at its default of 512Mb and the machine has 1gig of ram. When i checked the jrun.exe process it was running around 360Mb. Any ideas? Java memory usage will ebb and flow depending on activity. I suspect that at 12:28 there was sufficient activity on your system to require more than 512Mb RAM. By the time you checked later, that memory usage had shrunk back to 360Mb. This is not unusual. Since your machine has virtual memory, you can safely push the JVM max up quite a bit and heavy load will then just slow the system down rather than run it up against the memory limit. I think the maximum allowable is around 3600Mb (it's a certain amount under 4Gb but I can't quite remember what the threshold is). In order to scale your system, you could look at CFMX for J2EE which allows multiple instances and therefore multiple JVMs to service traffic on your website. See my blog for a brief note and a reference to a MM article on this: http://www.corfield.org/blog/2002_12_01_archive.html#86145208 Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT: AOL?
Ya know.. Don't let them hit you with that. The problem is, new sysadmins tend to think that making changes is part of their job. We had a MAJOR battle with HUD since one of our customers submits information to them via email regularly. Suddenly, they could not contact HUD, due to a policy change by a new admin who decided that if the email server didn't reverse to the same domain name, it was most-likely SPAM. The problem is (as you are most likely aware) that with 1000's of domain names on a single mail server, how could you POSSIBLY reverse to them? Even if you added all the reverse names to your DNS server manually, it would never answer with the right one first.. So it's not logical. We have to force them to understand that THEY are not the ONLY ISP on the planet... and that making willy-nilly admin decisions effects millions. If we fight back, they will change the policy. Just my .02... | -Original Message- | From: Kris Pilles [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, December 18, 2002 11:05 AM | To: CF-Talk | Subject: RE: OT: AOL? | | | Aol says my reverse DNS is not up But everything on my | server appears to be working fine I guess its my fault | after all lol | | -Original Message- | From: Bud [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, December 18, 2002 1:44 PM | To: CF-Talk | Subject: RE: OT: AOL? | | | On 12/18/02, Kris Pilles penned: | No good This sucks... MY clients are starting to notice this | too. Weird thing is the mail just disappears... No | bounce back or | anything like that... | | I occasionally have similar problems. I ALWAYS use them as an | opportunity to point out to my client that they are LIKELY losing | other e-mails, some which may be important. I point out to them (as | Howie did to you) that they don't generally bounce the e-mails, so | the sender has no way of knowing what the problem is so they may | rectify it, or even if there is a problem on his/her end and that the | best course of action is to dump AOL for a true ISP. | | That said, I do have an AOL account which I use for testing web | sites. Email address is buddy123. I'll be glad to check the account | if you want to send something there. | -- | | Bud Schneehagen - Tropical Web Creations | | _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ | ColdFusion Solutions / eCommerce Development | [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Slightly OT: SQL VIEW gets out of sync??
Les, I have also seen this. It's related to using * in the view, and then changing what * means by adding or removing columns in a table called by the view. To avoid it in the future, take the time to write out the specific fields you are calling. Otherwise, when you add/remove a field from the original table, you will have to go back into the view and just re-save it. If I had to pin down a cause, I would say that when you save the view, it caches the fields (specifically the location of the fields in relation to their table) that map to *, and doesn't re-examine them until you save again. Think of it as a list. If you have a list listA = 1,2,3,4,5 and call listGetAt(listA,3), it returns 3. then you delete item 2, and listGetAt(listA,3) will return 4. Specifically naming the fields will remove the ambiguity, and call the field directly rather than a reference to the field. -Jeff Date: Mon, 16 Dec 2002 14:18:04 -0500 From: Les Mizzell [EMAIL PROTECTED] Subject: Slightly OT: SQL VIEW gets out of sync?? Anybody ever seen this before... Got a View set up in a SQL Database using inner joins...which is then displaying data on a CF page. View looks like: SELECT app_Master.*, app_register.*, app_1.*, app_2.*, app_3.*, app_4.*, app_5.* *snip* I'm not calling any specific fields in any tables All works fine until I go into a specific table in the SQL Administrator any add or change a row to the table. If I now look at my CF display pagencalling the view, the displayed stuff will be off - say, last name is now displaying where the first name should be or something - the SQL View has gotten data out of sync somehow. Only way I can fix it is to go back into the SQL administrator and resave the view. Ideas?
Re: OT: AOL?
That may be true but you would think that they would reject the mail properly instead of just tossing it into a black hole... Howie - Original Message - From: Kris Pilles [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 2:04 PM Subject: RE: OT: AOL? Aol says my reverse DNS is not up But everything on my server appears to be working fine I guess its my fault after all lol ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: OT: AOL?
But usually a mail server that does RDNS checks the reverse dns against the server name specified in the HELO part of the protocol. So, as long as your mail server uses that reverse dns name in its HELO, you should be OK. Regards, Howie - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 2:12 PM Subject: RE: OT: AOL? Ya know.. Don't let them hit you with that. The problem is, new sysadmins tend to think that making changes is part of their job. We had a MAJOR battle with HUD since one of our customers submits information to them via email regularly. Suddenly, they could not contact HUD, due to a policy change by a new admin who decided that if the email server didn't reverse to the same domain name, it was most-likely SPAM. The problem is (as you are most likely aware) that with 1000's of domain names on a single mail server, how could you POSSIBLY reverse to them? Even if you added all the reverse names to your DNS server manually, it would never answer with the right one first.. So it's not logical. We have to force them to understand that THEY are not the ONLY ISP on the planet... and that making willy-nilly admin decisions effects millions. If we fight back, they will change the policy. Just my .02... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Random SQL statement
Does it actually have to be random per se? If you have a site with moderate traffic, I might just iterate a counter in the application scope so that it /appears/ random to a user, but keeps the overhead minimal. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Chad [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, December 18, 2002 12:09 PM : To: CF-Talk : Subject: Random SQL statement : : : I have a table with a Unique ID field and I would like to do a random : select on the table UID. : : Basically I want to send the user to a page that displays that random : record. : : Does SQL have a random function? I cant find anything in my books. : SELECT rand(ID) : FROM table : : Or should I select all records from the table and use CF to pick a : random record from the dataset? : : Thanks, : Chad : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Strange CFAS 5 Error
Looks like somehow you've accidentally set variables.start to 51Please instead of 51 -- you know that CF will assign values even if you don't ask nicely, right? :-P --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: paul smith [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, December 18, 2002 1:17 PM : To: CF-Talk : Subject: Strange CFAS 5 Error : : : Why would: : : cfoutput : #VARIABLES.start# : br : #REQUEST.LISTINGS.MAXROWS# : /cfoutput : : cfset variables.end = variables.start + request.listings.maxrows - 1 : : Where Variables.start=51 and request.listings.maxrows=50 : : throw this error: : : : An error occurred while evaluating the expression: : variables.end = variables.start + request.listings.maxrows - 1 : Error near line 16, column 7. : : Cannot convert 51Please, check the ColdFusion manual for the allowed : conversions between data types : === : : repeatedly? : : best, paul : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Random Iterations -
So what you want to do is like shuffling a deck of cards, but you only have 15 cards. The way I always handled that kind of thing was to make an array of the right length (N=15), initialize it with identity values (so array[1] = 1, array[2] = 2, etc). Then write a loop that goes from 1 to N. In the loop, generate a random number from 1 to N and swap the array value at the current loop index with the array value indexed by the random number. Each run through this loop is a shuffle. To get a nice randomization, shuffle the deck seven times. Mark -Original Message- From: Dobris, Eric [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:58 PM To: CF-Talk Subject: RE: Random Iterations - Yes, I just need to be able to generate them and choose 40 random combinations. I don't need to actually buld a table with 1,307,674,368,000 rows. Eric -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:37 PM To: CF-Talk Subject: RE: Random Iterations - BTW you know there are 1,307,674,368,000 different non-ordered sets WG -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 17:15 To: CF-Talk Subject: RE: Random Iterations That requires a pretty intense algorithm, you going to be doing this often? I'd recommend doing this in C or Java... What platform? If it's the same 15 numbers just do it once ! WG -Original Message- From: Dobris, Eric [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 16:45 To: CF-Talk Subject: Random Iterations Hi Everyone, I have a problem I can't figure out and I am hoping someone on the list can help me figure out how to do it. I need to generate iteration tables. For Example: For a 3 digit iteration: All The possible combinations for these 3 digits; 1 2 3 I would end up with: 1 1,2,3 2 1,3,2 3 2,1,3 4 3,2,1 5 2,3,1 6 3,1,2 I need to auto generate tables with up to 15 digits. Can anyone figure out the code to do this? Any help would be appreciated. Thanks, Eric Dobris ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: cferror
Yes. I use cfdump almost every single day. I find it to be one of the most useful custom tags every written. You can find multiple versions of it in the Developer's Exchange. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:46 AM To: CF-Talk Subject: RE: cferror Wish I could use the CFDump tag...I'm still on CF 4.5.2... Would it be worth it to setup the CFDump custom tag that I believe is available for pre-MX (?) versions? Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: cferror
It's TOTALLY worth it. I use it all the time. CF_DUMP Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:46 PM To: CF-Talk Subject: RE: cferror Wish I could use the CFDump tag...I'm still on CF 4.5.2... Would it be worth it to setup the CFDump custom tag that I believe is available for pre-MX (?) versions? Rick -Original Message- From: jon roig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:30 PM To: CF-Talk Subject: RE: cferror Hey... we added this to our error page... works like a charm: cfmail to=[EMAIL PROTECTED] cc=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Cold Fusion Error type=HTML CFDump var=#error#CFDump var=#cgi#/cfmail Gives a ton of diagnostic data that usually helps us in finding/reproducing the source of the error. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:42 AM To: CF-Talk Subject: RE: cferror Hi, Tim. I implemented your approach below and it works well, except that when the request type error occurs, I do get the email sent to the admin, but the only thing that shows up in the browser is a blank screen. If I add your error_page.cfm code to the error_admin.cfm page then the admin email is sent, then the error message to the user is displayed. Why do we need two pages? (I assume that exception error code, being set to any will catch every type of error that occurs and therefore, the error_admin.cfm page will always be executed?) Thanks, Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:54 AM To: CF-Talk Subject: RE: cferror First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and may be pretty basic, but I learned a fair amount from the exercise APPLICATION.CFM file: !--- code for sending error message to web developer/site admin cferror type=exception template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] !--- code for person viewing web page--- cferror type=request template=error_page.cfm mailto=[EMAIL PROTECTED] ERROR_ADMIN.cfm: (file to send message to web page developer/admin) cfmail from=[EMAIL PROTECTED] subject=Web Site Error Report to=[EMAIL PROTECTED] type=html Error Date/Time: #DateFormat(Now())# at #TimeFormat(Now(),h:m tt)#p Viewers Browser: #http_user_agent#p Page error was generated: #error.template#p URL Query string of Client's request: #error.QueryString#p #error.diagnostics# /cfmail ERROR_PAGE.CFM (excerpt of page that viewer sees) We have logged the following information that will help us identify and correct the problem: UL LIError occurred at B#ERROR.Datetime#/B LIYour IP address is B#ERROR.RemoteAddress#/B LIYour browser is B#ERROR.Browser#/B LIYou were trying to process B#ERROR.Template#?#ERROR.QueryString#/B /UL If you can provide us with any additional information that would help us fix this problem, please send E-Mail to: A HREF=mailto:#ERROR.MailTo#;#ERROR.MailTo#/A. Tim Laureska -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:26 AM To: CF-Talk Subject: RE: cferror Here's my notes on cferror types (CF 4.5 SP2, Solaris, Oracle 8i): Chris Norloff type=expression - catches bad expression like select * from m_job_summary where job_id=#doesnt_exist# type=database - catches bad SQL like select * from m_job_summary GROUP ORDER BY - catches invalid column like select * from m_job_summary where doesnt_exist=10 type=missinginclude - catches missing cfincluded files - catches missing cfmodule files. type=lock - catches problem with lock, such as timing out while waiting to get exclusive access. type=any Catches things not caught by a previous cfcatch statement. Example: - timeout error. Sometimes timeout error has type COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT. Sometimes type is UNKNOWN and the message is Request timed out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup
RE: Issue: Change row color on mouse over in Netscape 4.7
I actually think it's getting to be a good time to force them to upgrade.
There was a time where websites started coming along that had a minimum
Nutscrape 4/IE 4 requirement. Why not take a moment and raise the bar to IE
5 / Nutscrape 6 /Opera 6 / Mozilla 1.0... Makes sense to me...
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 12:55 PM
To: CF-Talk
Subject: Re: Issue: Change row color on mouse over in Netscape 4.7
You won't get it to work, NS 4.7's CSS and DHTML support is very weak.
I'm also real sure that you can't use an onMouseOver event on a TR or a TD
in 4.7
However, from a philosophical perspective (and I don't mean to get OT or
cause a furor), if your users are about average as far as browser stats, I
wouldn't even bother to offer anything beyond a basic, presentable layout in
NS4.x since they are a very small minority (5% on our site). But that's
just me, I love browsers with solid CSS support :-)
Pete
- Original Message -
From: James Blaha [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 1:17 PM
Subject: Issue: Change row color on mouse over in Netscape 4.7
Hello Everyone:
I've spent too many hours on this I hit a wall. I'm using the code
below to alternate row color for my table and when you mouse over each
row it should change the background color for the row. It works in IE
5+ and Netscape 6+ but I can't get it to work in Netscape 4.7 any
ideas?
TR valign=top
bgcolor=###iif(currentrow MOD 2,DE('BFCCE6'),DE('D8DFE1'))#
onmouseover=this.style.backgroundColor='##FAF7B8'; window.status='My
Window Message';return true;
onmouseout=this.style.backgroundColor='###iif(currentrow MOD
2,DE('BFCCE6'),DE('D8DFE1'))#'; window.status=''; return true;
Bonus Question: I'm working within a framed page it possible when the
user mouse's over the row to send a value to a window.status for
Netscape 4.7?
Regards,
James Blaha
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Slightly OT: SQL VIEW gets out of sync??
It's supposed to be a little better in SQL2K, but at least in SQL7 it's even worse than this: Given this structure TABLE x column a column b column c TABLE y column x column y column z create view myview as SELECT x.a, x.b, y.z from x inner join y on y.x = x.a go In my experience / testing, the view myview will have to be resaved any time a column is added to or removed from either table x or table y, even if myview doesn't reference that column in any way. This has to do with the way that SQL server references columns in tables and views with an ordinal number ( i.e. column 3 instead of column x ). The fact that these columns need not be sequential if a column is removed from the middle doesn't seem to matter either, so, if you had a table with 5 columns and you removed column 4, the table would then have columns 1-3 and 5, but you would still have to update any views which referenced that table, even if those views didn't reference columns 4 or 5 in any way. ( Don't ask me why it's all cluster-fucked like this, I haven't got a clue ). The solution that some sql folks have come up with is to check for dependant views when a column is added or removed from a given table and update all those dependant views using a stored procedure. If you have full control of the sql server, you can even go so far as to create an insert/delete trigger on the syscolumns table so that you don't have to manually run the stored procedure to update the views. The problem you may run into, however, is that if you have a view which explicitely references a column that you've removed from the table, the attempt to update the view will result in an error and you'll lose the view and have to recreate it manually. Here are the sp's I use to grab view data from the syscomments table and updat them. CREATE VIEW dbo.tap_ViewsDependant AS SELECT DISTINCT t2.name AS viewname, t.name AS dependson FROM sysobjects t inner join syscolumns c ON ( c.id = t.id ) inner join sysdepends dep on ( dep.depid = c.id ) inner join sysobjects t2 on ( t2.id = dep.id ) where objectproperty(t2.id, N'IsView') = 1 and (objectproperty(t.id, N'IsView') = 1 or objectproperty(t.id, N'IsUserTable') = 1) GO create PROCEDURE dbo.tap_ViewUpdate @viewname nvarchar(128) AS DECLARE @sysid INT; DECLARE @view NVARCHAR(4000); DECLARE @dropview NVARCHAR(200); SET @sysid = (SELECT ID FROM sysobjects WHERE name = @viewname AND OBJECTPROPERTY(ID, N'IsView') = 1) IF @sysid IS NOT NULL BEGIN SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; BEGIN TRANSACTION; SET @view = (SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = @viewname); SET @dropview = 'DROP VIEW ' + @viewname; EXEC sp_executesql @dropview; EXEC sp_executesql @view; COMMIT TRANSACTION; END GO create PROCEDURE dbo.tap_ViewsUpdateDependant @tablename nvarchar(128) AS DECLARE @currentview nvarchar(128); DECLARE curView CURSOR LOCAL FAST_FORWARD FOR SELECT DISTINCT viewname FROM dbo.tap_ViewsDependant WHERE dependson = @tablename OPEN curView; FETCH NEXT FROM curView INTO @currentview; WHILE (@@FETCH_STATUS = 0) BEGIN EXEC dbo.tap_ViewUpdate @viewname = @currentview; FETCH NEXT FROM curView INTO @currentview; END CLOSE curView; DEALLOCATE curView; GO so after you change the columns in your employee table, you would then run EXEC dbo.tap_ViewsUpdateDependant @tablename = 'employee'; and this would update any views that depend on your employee table To make this a trigger you'd have to modify the view dbo.tap_ViewsDependant to include the id of the table from the sysobjects table and use that to reference the id in the syscolumns table to check for dependancies in your insert/delete trigger on syscolumns... hth Les, I have also seen this. It's related to using * in the view, and then changing what * means by adding or removing columns in a table called by the view. To avoid it in the future, take the time to write out the specific fields you are calling. Otherwise, when you add/remove a field from the original table, you will have to go back into the view and just re-save it. If I had to pin down a cause, I would say that when you save the view, it caches the fields (specifically the location of the fields in relation to their table) that map to *, and doesn't re-examine them until you save again. Think of it as a list. If you have a list listA = 1,2,3,4,5 and call listGetAt(listA,3), it returns 3. then you delete item 2, and listGetAt(listA,3) will return 4.
RE: Issue: Change row color on mouse over in Netscape 4.7
I actually think it's getting to be a good time to force them to upgrade. There was a time where websites started coming along that had a minimum Nutscrape 4/IE 4 requirement. Why not take a moment and raise the bar to IE 5 / Nutscrape 6 /Opera 6 / Mozilla 1.0... Makes sense to me... NS 7 -- if you raise it to 6 you preclude people being able to see / use a lot of Flash MX stuff... which is funny because the Mozilla build 6 came from didn't have that problem. but it was fairly well documented on Bugzilla at the time. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cferror
Yea, I've heard of people using the cfa_dump tag from spectra ( installed independantly of the spectra api ), but cf_objectdump was pretty good -- I ended up editing it myself, because iirc the last iteration I saw of it on the devex displayed structures horizontally instead of vertically, which is a huge pain in the ass if you've got a large structure to display, because then you're scrolling horizontally to see stuff you would otherwise be able to fit all in the empty, unused white-space below the output of the tag. ;P Yes. I use cfdump almost every single day. I find it to be one of the most useful custom tags every written. You can find multiple versions of it in the Developer's Exchange. == = Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:46 AM To: CF-Talk Subject: RE: cferror Wish I could use the CFDump tag...I'm still on CF 4.5.2... Would it be worth it to setup the CFDump custom tag that I believe is available for pre-MX (?) versions? Rick ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Issue: Change row color on mouse over in Netscape 4.7
Yeah, you will not get it to work in Netscape 4.x. The only way to swap
background colors effect to work in Netscape 4.x is to make each table row a
LAYER and then use document.write on an onmouseover event to rewrite the
contents of the layer with a different color. VERY painful. You might want
to look at the nav-bar solution we developed for www.frbatlanta.org (visit
using netscape 4, then do view-source) to get a sense of what real PAIN is
like!
Regards,
Steve Drucker
CEO
Fig Leaf Software
w. www.figleaf.com
p. (877) FIG-LEAF
-Original Message-
From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 2:39 PM
To: CF-Talk
Subject: RE: Issue: Change row color on mouse over in Netscape 4.7
I actually think it's getting to be a good time to force them to upgrade.
There was a time where websites started coming along that had a minimum
Nutscrape 4/IE 4 requirement. Why not take a moment and raise the bar to
IE
5 / Nutscrape 6 /Opera 6 / Mozilla 1.0... Makes sense to me...
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 12:55 PM
To: CF-Talk
Subject: Re: Issue: Change row color on mouse over in Netscape 4.7
You won't get it to work, NS 4.7's CSS and DHTML support is very weak.
I'm also real sure that you can't use an onMouseOver event on a TR or a TD
in 4.7
However, from a philosophical perspective (and I don't mean to get OT or
cause a furor), if your users are about average as far as browser stats, I
wouldn't even bother to offer anything beyond a basic, presentable layout
in
NS4.x since they are a very small minority (5% on our site). But that's
just me, I love browsers with solid CSS support :-)
Pete
- Original Message -
From: James Blaha [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 1:17 PM
Subject: Issue: Change row color on mouse over in Netscape 4.7
Hello Everyone:
I've spent too many hours on this I hit a wall. I'm using the code
below to alternate row color for my table and when you mouse over each
row it should change the background color for the row. It works in IE
5+ and Netscape 6+ but I can't get it to work in Netscape 4.7 any
ideas?
TR valign=top
bgcolor=###iif(currentrow MOD 2,DE('BFCCE6'),DE('D8DFE1'))#
onmouseover=this.style.backgroundColor='##FAF7B8'; window.status='My
Window Message';return true;
onmouseout=this.style.backgroundColor='###iif(currentrow MOD
2,DE('BFCCE6'),DE('D8DFE1'))#'; window.status=''; return true;
Bonus Question: I'm working within a framed page it possible when the
user mouse's over the row to send a value to a window.status for
Netscape 4.7?
Regards,
James Blaha
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
RE: Strange CFAS 5 Error
LOL... there's a possibility that it may not be interpreting one of your variables as a numeric value ... You might try putting val() around both of your variables in that cfset tag and see if that solves the immediate issue. If so, then you've got a handle on figuring out just exactly what's going on with it. Looks like somehow you've accidentally set variables.start to 51Please instead of 51 -- you know that CF will assign values even if you don't ask nicely, right? :-P --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: paul smith [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, December 18, 2002 1:17 PM : To: CF-Talk : Subject: Strange CFAS 5 Error : : : Why would: : : cfoutput : #VARIABLES.start# : br : #REQUEST.LISTINGS.MAXROWS# : /cfoutput : : cfset variables.end = variables.start + request.listings.maxrows - 1 : : Where Variables.start=51 and request.listings.maxrows=50 : : throw this error: : : : An error occurred while evaluating the expression: : variables.end = variables.start + request.listings.maxrows - 1 : Error near line 16, column 7. : : Cannot convert 51Please, check the ColdFusion manual for the allowed : conversions between data types : === : : repeatedly? : : best, paul : ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Caching issue (and no, it's not trusted cache
Hi all, I'm having a problem where an Application.cfm file that I've updated is not consistent with what's being executed. I have a request.dsn variable which was changed but the change is not reflected on the server both from observed behavior and the debug window shows request.dsn being set to the old value. Things I checked: - Trusted cache is not on (this is a development box). - I deleted everything in /opt/coldfusionmx/wwwroot/WEB-INF/cfclasses - I touch-ed the Application.cfm file to make sure that it's timestamp is new. - I verified the date/time on the server is current. The server config is CFMX (Updater 2) on Solaris 2.8, iPlanet 6.0 SP 4 I can create new test files and put them out on the server and they run fine, it's just changes to existing files (like adding debug info etc.) that don't work. I've restarted CF a number of times including after removing the class files. This is pretty odd because I've been working with this server for the past few weeks without a problem and there aren't any other developers using it. I just noticed that there doesn't seem to be a class file that corresponds to Application.cfm in the cfclasses directory. A bit strange because I can see an OnRequestEnd in there. I've no idea what else I can try and I have a demo deadline looming so any help anyone can give would be greatly appreciated! Thanks!! Kevin Kevin Gilchrist CISSP Aim: mcgiollachriost MSN: kevin_gilchrist ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Another Disturbing MX Error
Sean, I like the theory, but there is one part that doesn't make sense. This error continued to happen until i restarted the service and more explicitily killed jrun. There are about twenty of the errors listed below. While it was happening i looked at Task Manager and zeroed in on the jrun process and it was running well under the 512MB limit. Which seems to point to the fact that it was no longer taking up 512MB of memory. If that is true then what was happening. Did it reach the threshold once and now not know how to recover from it even though the memory usage was much lower? Mark -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:12 AM To: CF-Talk Subject: Re: Another Disturbing MX Error On Wednesday, Dec 18, 2002, at 09:43 US/Pacific, Mark Johnson wrote: Error,jrpp-293,12/18/02,12:28:21,,null The specific sequence of files included or processed is: null java.lang.OutOfMemoryError I had the following error occur yesterday and today once. When it happens you have to do a complete CF cycle. The ColdFusion Java VM MAX setting is still at its default of 512Mb and the machine has 1gig of ram. When i checked the jrun.exe process it was running around 360Mb. Any ideas? Java memory usage will ebb and flow depending on activity. I suspect that at 12:28 there was sufficient activity on your system to require more than 512Mb RAM. By the time you checked later, that memory usage had shrunk back to 360Mb. This is not unusual. Since your machine has virtual memory, you can safely push the JVM max up quite a bit and heavy load will then just slow the system down rather than run it up against the memory limit. I think the maximum allowable is around 3600Mb (it's a certain amount under 4Gb but I can't quite remember what the threshold is). In order to scale your system, you could look at CFMX for J2EE which allows multiple instances and therefore multiple JVMs to service traffic on your website. See my blog for a brief note and a reference to a MM article on this: http://www.corfield.org/blog/2002_12_01_archive.html#86145208 Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT: AOL?
I see your point, however, in my own case as a email hosting provider, I have the settings set to enable SMTP AUTH, which is what you mean by doing the reverse lookup. I also make it a point to create the in-addr-arpa record in DNS that takes care of it. That is just another task in hosting email domains. In fact I use a script that takes care of all this when adding a new domain. If you were an ISP or hosting provider, you would be aware of the constant attacks by others trying to spoof one of your hosted addresses, including virus attacks such as the Klez Virus, which are all turned away at the server. That is my story, and I am sticking to it! :-) = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:12 PM Subject: RE: OT: AOL? | Ya know.. Don't let them hit you with that. | | The problem is, new sysadmins tend to think that making changes is part | of their job. We had a MAJOR battle with HUD since one of our customers | submits information to them via email regularly. Suddenly, they could | not contact HUD, due to a policy change by a new admin who decided that | if the email server didn't reverse to the same domain name, it was | most-likely SPAM. The problem is (as you are most likely aware) that | with 1000's of domain names on a single mail server, how could you | POSSIBLY reverse to them? Even if you added all the reverse names to | your DNS server manually, it would never answer with the right one | first.. So it's not logical. | | We have to force them to understand that THEY are not the ONLY ISP on | the planet... and that making willy-nilly admin decisions effects | millions. If we fight back, they will change the policy. | | Just my .02... | | | | | -Original Message- | | From: Kris Pilles [mailto:[EMAIL PROTECTED]] | | Sent: Wednesday, December 18, 2002 11:05 AM | | To: CF-Talk | | Subject: RE: OT: AOL? | | | | | | Aol says my reverse DNS is not up But everything on my | | server appears to be working fine I guess its my fault | | after all lol | | | | -Original Message- | | From: Bud [mailto:[EMAIL PROTECTED]] | | Sent: Wednesday, December 18, 2002 1:44 PM | | To: CF-Talk | | Subject: RE: OT: AOL? | | | | | | On 12/18/02, Kris Pilles penned: | | No good This sucks... MY clients are starting to notice this | | too. Weird thing is the mail just disappears... No | | bounce back or | | anything like that... | | | | I occasionally have similar problems. I ALWAYS use them as an | | opportunity to point out to my client that they are LIKELY losing | | other e-mails, some which may be important. I point out to them (as | | Howie did to you) that they don't generally bounce the e-mails, so | | the sender has no way of knowing what the problem is so they may | | rectify it, or even if there is a problem on his/her end and that the | | best course of action is to dump AOL for a true ISP. | | | | That said, I do have an AOL account which I use for testing web | | sites. Email address is buddy123. I'll be glad to check the account | | if you want to send something there. | | -- | | | | Bud Schneehagen - Tropical Web Creations | | | | _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ | | ColdFusion Solutions / eCommerce Development | | [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 | | | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: OT: AOL?
Correct = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:18 PM Subject: Re: OT: AOL? | But usually a mail server that does RDNS checks the reverse dns against the server name specified in the HELO part of | the protocol. So, as long as your mail server uses that reverse dns name in its HELO, you should be OK. | | Regards, | | Howie | | - Original Message - | From: Lee Fuller [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Wednesday, December 18, 2002 2:12 PM | Subject: RE: OT: AOL? | | | Ya know.. Don't let them hit you with that. | | The problem is, new sysadmins tend to think that making changes is part | of their job. We had a MAJOR battle with HUD since one of our customers | submits information to them via email regularly. Suddenly, they could | not contact HUD, due to a policy change by a new admin who decided that | if the email server didn't reverse to the same domain name, it was | most-likely SPAM. The problem is (as you are most likely aware) that | with 1000's of domain names on a single mail server, how could you | POSSIBLY reverse to them? Even if you added all the reverse names to | your DNS server manually, it would never answer with the right one | first.. So it's not logical. | | We have to force them to understand that THEY are not the ONLY ISP on | the planet... and that making willy-nilly admin decisions effects | millions. If we fight back, they will change the policy. | | Just my .02... | | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Caching issue (and no, it's not trusted cache
This may sound strange but try deleting the cfclasses directory itself. We had an odd case of caching on our Solaris box with corrupted CF admin pages and that was the only thing that worked! Stace -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:09 PM To: CF-Talk Subject: Caching issue (and no, it's not trusted cache Hi all, I'm having a problem where an Application.cfm file that I've updated is not consistent with what's being executed. I have a request.dsn variable which was changed but the change is not reflected on the server both from observed behavior and the debug window shows request.dsn being set to the old value. Things I checked: - Trusted cache is not on (this is a development box). - I deleted everything in /opt/coldfusionmx/wwwroot/WEB-INF/cfclasses - I touch-ed the Application.cfm file to make sure that it's timestamp is new. - I verified the date/time on the server is current. The server config is CFMX (Updater 2) on Solaris 2.8, iPlanet 6.0 SP 4 I can create new test files and put them out on the server and they run fine, it's just changes to existing files (like adding debug info etc.) that don't work. I've restarted CF a number of times including after removing the class files. This is pretty odd because I've been working with this server for the past few weeks without a problem and there aren't any other developers using it. I just noticed that there doesn't seem to be a class file that corresponds to Application.cfm in the cfclasses directory. A bit strange because I can see an OnRequestEnd in there. I've no idea what else I can try and I have a demo deadline looming so any help anyone can give would be greatly appreciated! Thanks!! Kevin Kevin Gilchrist CISSP Aim: mcgiollachriost MSN: kevin_gilchrist ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: cferror
Rick: You don't need the try/catch blocks for setting up the CFERROR tags. You might consider setting up your error templates like the following: !--- exception_error.cfm --- !--- Use CFMAIL to send diagnostic/error data to admin --- CFINCLUDE TEMPLATE=request_error.cfm !--- request_error.cfm --- !--- Display error message to user --- This way, there's only a single displayable error screen to maintain. And just to clarify, if you use 2 CFERROR tags, one with TYPE=Exception and the other with TYPE=Request, the TYPE=Exception should catch every uncaught error except those that are generated by the error handler defined in the TYPE=Exception CFERROR tag. Those are caught by the TYPE=Request handler. BTW, the above is true only if the EXCEPTION attribute is not specified or is set to All. If you specify a distinct exception, then only exceptions of that type will be handled by the specified error handler. However, there's no reason why you can specify multiple CFERROR TYPE=Exception tags as in: CFERROR TYPE=Request TEMPLATE=request_error.cfm CFERROR TYPE=Exception EXCEPTION=Database TEMPLATE=db_exception.cfm CFERROR TYPE=Exception EXCEPTION=Application TEMPLATE=app_exception.cfm I don't know what would happen though if you did the above and also included an EXCEPTION=All. Would it catch everything, ignoring the other tags, or would it catch everything not specified in the other tags. Order might matter in this case (as it does when declaring CFCATCH blocks). Dunno... if I have some time tonight, I'll try to remember to test it out. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:38 PM To: CF-Talk Subject: RE: cferror So, it would be best to have the code to send an email to the admin and the code to display the error message to the user on the page that is called when the Exception error is triggered... Then, if the Exception trigger errors, the regular Request error page will kick in and display the normal error message to the user without the admin email being sent, since CF Tags can be used with Request error pages. Am I getting this? Also, I've got the code for the error page just below the CFAPPLICATION tag like this: CFERROR Type=exception Template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] CFERROR Type=request Template=error_page.cfm mailto=[EMAIL PROTECTED] Then, the rest of the page's code. Do I need any kind of Catch/Try to bypass the Request Error code above if the Exception Error code is processed? I would guess not, since when the Exception Error code is processed, everything comes to a halt, anyway...right? Thanks for your insights. Rick -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:18 PM To: CF-Talk Subject: RE: cferror Even though you've implemented CFERROR to catch EXCEPTIONS, you should still have another CFERROR with REQUEST in case your EXCEPTION handling page ever generates an error. If it does, it will be caught by the REQUEST CFERROR. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:42 AM To: CF-Talk Subject: RE: cferror Hi, Tim. I implemented your approach below and it works well, except that when the request type error occurs, I do get the email sent to the admin, but the only thing that shows up in the browser is a blank screen. If I add your error_page.cfm code to the error_admin.cfm page then the admin email is sent, then the error message to the user is displayed. Why do we need two pages? (I assume that exception error code, being set to any will catch every type of error that occurs and therefore, the error_admin.cfm page will always be executed?) Thanks, Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:54 AM To: CF-Talk Subject: RE: cferror First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and may be pretty basic, but I learned a fair amount from the exercise APPLICATION.CFM file: !--- code for sending error message to web developer/site admin cferror type=exception template=error_admin.cfm EXCEPTION=Any
RE: cferror
Depends on how much and what kind of data you want to receive. You can also manually mimic CFDUMP (i.e. Loop over FORM.FormFields, etc.). -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:46 PM To: CF-Talk Subject: RE: cferror Wish I could use the CFDump tag...I'm still on CF 4.5.2... Would it be worth it to setup the CFDump custom tag that I believe is available for pre-MX (?) versions? Rick -Original Message- From: jon roig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:30 PM To: CF-Talk Subject: RE: cferror Hey... we added this to our error page... works like a charm: cfmail to=[EMAIL PROTECTED] cc=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Cold Fusion Error type=HTML CFDump var=#error#CFDump var=#cgi#/cfmail Gives a ton of diagnostic data that usually helps us in finding/reproducing the source of the error. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:42 AM To: CF-Talk Subject: RE: cferror Hi, Tim. I implemented your approach below and it works well, except that when the request type error occurs, I do get the email sent to the admin, but the only thing that shows up in the browser is a blank screen. If I add your error_page.cfm code to the error_admin.cfm page then the admin email is sent, then the error message to the user is displayed. Why do we need two pages? (I assume that exception error code, being set to any will catch every type of error that occurs and therefore, the error_admin.cfm page will always be executed?) Thanks, Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:54 AM To: CF-Talk Subject: RE: cferror First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and may be pretty basic, but I learned a fair amount from the exercise APPLICATION.CFM file: !--- code for sending error message to web developer/site admin cferror type=exception template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] !--- code for person viewing web page--- cferror type=request template=error_page.cfm mailto=[EMAIL PROTECTED] ERROR_ADMIN.cfm: (file to send message to web page developer/admin) cfmail from=[EMAIL PROTECTED] subject=Web Site Error Report to=[EMAIL PROTECTED] type=html Error Date/Time: #DateFormat(Now())# at #TimeFormat(Now(),h:m tt)#p Viewers Browser: #http_user_agent#p Page error was generated: #error.template#p URL Query string of Client's request: #error.QueryString#p #error.diagnostics# /cfmail ERROR_PAGE.CFM (excerpt of page that viewer sees) We have logged the following information that will help us identify and correct the problem: UL LIError occurred at B#ERROR.Datetime#/B LIYour IP address is B#ERROR.RemoteAddress#/B LIYour browser is B#ERROR.Browser#/B LIYou were trying to process B#ERROR.Template#?#ERROR.QueryString#/B /UL If you can provide us with any additional information that would help us fix this problem, please send E-Mail to: A HREF=mailto:#ERROR.MailTo#;#ERROR.MailTo#/A. Tim Laureska -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:26 AM To: CF-Talk Subject: RE: cferror Here's my notes on cferror types (CF 4.5 SP2, Solaris, Oracle 8i): Chris Norloff type=expression - catches bad expression like select * from m_job_summary where job_id=#doesnt_exist# type=database - catches bad SQL like select * from m_job_summary GROUP ORDER BY - catches invalid column like select * from m_job_summary where doesnt_exist=10 type=missinginclude - catches missing cfincluded files - catches missing cfmodule files. type=lock - catches problem with lock, such as timing out while waiting to get exclusive access. type=any Catches things not caught by a previous cfcatch statement. Example: - timeout error. Sometimes timeout error has type COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT. Sometimes type is UNKNOWN and the message is Request timed out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Re: OT: AOL?
I am not trying to start a flame war here, I just want to make sure noone gets the wrong impression and confirm or disprove what I thought SMTP-AUTH was. As far as I can tell from RFC 2554 SMTP-AUTH really has nothing to do with checking reverse DNS, it is just an authentication method. on Wed Dec 18 samcfug spoke forth with the blessed manuscript I see your point, however, in my own case as a email hosting provider, I have the settings set to enable SMTP AUTH, which is what you mean by doing the reverse lookup. I also make it a point to create the in-addr-arpa record in DNS that takes care of it. That is just another task in hosting email domains. In fact I use a script that takes care of all this when adding a new domain. If you were an ISP or hosting provider, you would be aware of the constant attacks by others trying to spoof one of your hosted addresses, including virus attacks such as the Klez Virus, which are all turned away at the server. That is my story, and I am sticking to it! :-) = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:12 PM Subject: RE: OT: AOL? | Ya know.. Don't let them hit you with that. | | The problem is, new sysadmins tend to think that making changes is part | of their job. We had a MAJOR battle with HUD since one of our customers | submits information to them via email regularly. Suddenly, they could | not contact HUD, due to a policy change by a new admin who decided that | if the email server didn't reverse to the same domain name, it was | most-likely SPAM. The problem is (as you are most likely aware) that | with 1000's of domain names on a single mail server, how could you | POSSIBLY reverse to them? Even if you added all the reverse names to | your DNS server manually, it would never answer with the right one | first.. So it's not logical. | | We have to force them to understand that THEY are not the ONLY ISP on | the planet... and that making willy-nilly admin decisions effects | millions. If we fight back, they will change the policy. | | Just my .02... | | | | | -Original Message- | | From: Kris Pilles [mailto:[EMAIL PROTECTED]] | | Sent: Wednesday, December 18, 2002 11:05 AM | | To: CF-Talk | | Subject: RE: OT: AOL? | | | | | | Aol says my reverse DNS is not up But everything on my | | server appears to be working fine I guess its my fault | | after all lol | | | | -Original Message- | | From: Bud [mailto:[EMAIL PROTECTED]] | | Sent: Wednesday, December 18, 2002 1:44 PM | | To: CF-Talk | | Subject: RE: OT: AOL? | | | | | | On 12/18/02, Kris Pilles penned: | | No good This sucks... MY clients are starting to notice this | | too. Weird thing is the mail just disappears... No | | bounce back or | | anything like that... | | | | I occasionally have similar problems. I ALWAYS use them as an | | opportunity to point out to my client that they are LIKELY losing | | other e-mails, some which may be important. I point out to them (as | | Howie did to you) that they don't generally bounce the e-mails, so | | the sender has no way of knowing what the problem is so they may | | rectify it, or even if there is a problem on his/her end and that the | | best course of action is to dump AOL for a true ISP. | | | | That said, I do have an AOL account which I use for testing web | | sites. Email address is buddy123. I'll be glad to check the account | | if you want to send something there. | | -- | | | | Bud Schneehagen - Tropical Web Creations | | | | _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ | | ColdFusion Solutions / eCommerce Development | | [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 | | | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: OT: AOL?
Right - smtp auth has nothing to do with a server (like an AOL mail server) verifying reverse DNS on your mail server. Regards, Howie - Original Message - From: Jason Burnett [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 3:24 PM Subject: Re: OT: AOL? I am not trying to start a flame war here, I just want to make sure noone gets the wrong impression and confirm or disprove what I thought SMTP-AUTH was. As far as I can tell from RFC 2554 SMTP-AUTH really has nothing to do with checking reverse DNS, it is just an authentication method. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: OT: AOL?
Ah, excuse me, the validate sender is a separate selection on the mail server. Sorry = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: Jason Burnett [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 2:24 PM Subject: Re: OT: AOL? | I am not trying to start a flame war here, I just want to make sure | noone gets the wrong impression and confirm or disprove what I thought | SMTP-AUTH was. As far as I can tell from RFC 2554 SMTP-AUTH | really has nothing to do with checking reverse DNS, it is just an | authentication method. | | on Wed Dec 18 samcfug spoke forth with the blessed manuscript | I see your point, however, in my own case as a email hosting provider, I have | the settings set to enable SMTP AUTH, which is what you mean by doing the | reverse lookup. I also make it a point to create the in-addr-arpa record in | DNS that takes care of it. That is just another task in hosting email domains. | In fact I use a script that takes care of all this when adding a new domain. | If you were an ISP or hosting provider, you would be aware of the constant | attacks by others trying to spoof one of your hosted addresses, including virus | attacks such as the Klez Virus, which are all turned away at the server. | That is my story, and I am sticking to it! :-) | | = | Douglas White | group Manager | mailto:[EMAIL PROTECTED] | http://www.samcfug.org | = | - Original Message - | From: Lee Fuller [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Wednesday, December 18, 2002 1:12 PM | Subject: RE: OT: AOL? | | | | Ya know.. Don't let them hit you with that. | | | | The problem is, new sysadmins tend to think that making changes is part | | of their job. We had a MAJOR battle with HUD since one of our customers | | submits information to them via email regularly. Suddenly, they could | | not contact HUD, due to a policy change by a new admin who decided that | | if the email server didn't reverse to the same domain name, it was | | most-likely SPAM. The problem is (as you are most likely aware) that | | with 1000's of domain names on a single mail server, how could you | | POSSIBLY reverse to them? Even if you added all the reverse names to | | your DNS server manually, it would never answer with the right one | | first.. So it's not logical. | | | | We have to force them to understand that THEY are not the ONLY ISP on | | the planet... and that making willy-nilly admin decisions effects | | millions. If we fight back, they will change the policy. | | | | Just my .02... | | | | | | | | | -Original Message- | | | From: Kris Pilles [mailto:[EMAIL PROTECTED]] | | | Sent: Wednesday, December 18, 2002 11:05 AM | | | To: CF-Talk | | | Subject: RE: OT: AOL? | | | | | | | | | Aol says my reverse DNS is not up But everything on my | | | server appears to be working fine I guess its my fault | | | after all lol | | | | | | -Original Message- | | | From: Bud [mailto:[EMAIL PROTECTED]] | | | Sent: Wednesday, December 18, 2002 1:44 PM | | | To: CF-Talk | | | Subject: RE: OT: AOL? | | | | | | | | | On 12/18/02, Kris Pilles penned: | | | No good This sucks... MY clients are starting to notice this | | | too. Weird thing is the mail just disappears... No | | | bounce back or | | | anything like that... | | | | | | I occasionally have similar problems. I ALWAYS use them as an | | | opportunity to point out to my client that they are LIKELY losing | | | other e-mails, some which may be important. I point out to them (as | | | Howie did to you) that they don't generally bounce the e-mails, so | | | the sender has no way of knowing what the problem is so they may | | | rectify it, or even if there is a problem on his/her end and that the | | | best course of action is to dump AOL for a true ISP. | | | | | | That said, I do have an AOL account which I use for testing web | | | sites. Email address is buddy123. I'll be glad to check the account | | | if you want to send something there. | | | -- | | | | | | Bud Schneehagen - Tropical Web Creations | | | | | | _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ | | | ColdFusion Solutions / eCommerce Development | | | [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 | | | | | | | | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Caching issue (and no, it's not trusted cache
Didn't work unfortunately. -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:16 PM To: CF-Talk Subject: RE: Caching issue (and no, it's not trusted cache This may sound strange but try deleting the cfclasses directory itself. We had an odd case of caching on our Solaris box with corrupted CF admin pages and that was the only thing that worked! Stace -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:09 PM To: CF-Talk Subject: Caching issue (and no, it's not trusted cache Hi all, I'm having a problem where an Application.cfm file that I've updated is not consistent with what's being executed. I have a request.dsn variable which was changed but the change is not reflected on the server both from observed behavior and the debug window shows request.dsn being set to the old value. Things I checked: - Trusted cache is not on (this is a development box). - I deleted everything in /opt/coldfusionmx/wwwroot/WEB-INF/cfclasses - I touch-ed the Application.cfm file to make sure that it's timestamp is new. - I verified the date/time on the server is current. The server config is CFMX (Updater 2) on Solaris 2.8, iPlanet 6.0 SP 4 I can create new test files and put them out on the server and they run fine, it's just changes to existing files (like adding debug info etc.) that don't work. I've restarted CF a number of times including after removing the class files. This is pretty odd because I've been working with this server for the past few weeks without a problem and there aren't any other developers using it. I just noticed that there doesn't seem to be a class file that corresponds to Application.cfm in the cfclasses directory. A bit strange because I can see an OnRequestEnd in there. I've no idea what else I can try and I have a demo deadline looming so any help anyone can give would be greatly appreciated! Thanks!! Kevin Kevin Gilchrist CISSP Aim: mcgiollachriost MSN: kevin_gilchrist ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: AOL?
We are as well. Seems they're having some sort of trouble. | -Original Message- | From: Kris Pilles [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, December 18, 2002 9:50 AM | To: CF-Talk | Subject: OT: AOL? | | | Is anyone having any difficulty sending mail to AOL??? I | have been unable to send mail to aol for the past 2 days | My IPS are not blacklisted... I cannot figure this out... | | Kris Pilles | Website Manager | Western Suffolk BOCES | 507 Deer Park Rd., Building C | Phone: 631-549-4900 x 267 | E-mail: [EMAIL PROTECTED] | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cferror
Sounds good. I'll try the CFINCLUDE route...should work better. Thanks, Mosh. Rick -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:18 PM To: CF-Talk Subject: RE: cferror Rick: You don't need the try/catch blocks for setting up the CFERROR tags. You might consider setting up your error templates like the following: !--- exception_error.cfm --- !--- Use CFMAIL to send diagnostic/error data to admin --- CFINCLUDE TEMPLATE=request_error.cfm !--- request_error.cfm --- !--- Display error message to user --- This way, there's only a single displayable error screen to maintain. And just to clarify, if you use 2 CFERROR tags, one with TYPE=Exception and the other with TYPE=Request, the TYPE=Exception should catch every uncaught error except those that are generated by the error handler defined in the TYPE=Exception CFERROR tag. Those are caught by the TYPE=Request handler. BTW, the above is true only if the EXCEPTION attribute is not specified or is set to All. If you specify a distinct exception, then only exceptions of that type will be handled by the specified error handler. However, there's no reason why you can specify multiple CFERROR TYPE=Exception tags as in: CFERROR TYPE=Request TEMPLATE=request_error.cfm CFERROR TYPE=Exception EXCEPTION=Database TEMPLATE=db_exception.cfm CFERROR TYPE=Exception EXCEPTION=Application TEMPLATE=app_exception.cfm I don't know what would happen though if you did the above and also included an EXCEPTION=All. Would it catch everything, ignoring the other tags, or would it catch everything not specified in the other tags. Order might matter in this case (as it does when declaring CFCATCH blocks). Dunno... if I have some time tonight, I'll try to remember to test it out. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:38 PM To: CF-Talk Subject: RE: cferror So, it would be best to have the code to send an email to the admin and the code to display the error message to the user on the page that is called when the Exception error is triggered... Then, if the Exception trigger errors, the regular Request error page will kick in and display the normal error message to the user without the admin email being sent, since CF Tags can be used with Request error pages. Am I getting this? Also, I've got the code for the error page just below the CFAPPLICATION tag like this: CFERROR Type=exception Template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] CFERROR Type=request Template=error_page.cfm mailto=[EMAIL PROTECTED] Then, the rest of the page's code. Do I need any kind of Catch/Try to bypass the Request Error code above if the Exception Error code is processed? I would guess not, since when the Exception Error code is processed, everything comes to a halt, anyway...right? Thanks for your insights. Rick -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:18 PM To: CF-Talk Subject: RE: cferror Even though you've implemented CFERROR to catch EXCEPTIONS, you should still have another CFERROR with REQUEST in case your EXCEPTION handling page ever generates an error. If it does, it will be caught by the REQUEST CFERROR. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:42 AM To: CF-Talk Subject: RE: cferror Hi, Tim. I implemented your approach below and it works well, except that when the request type error occurs, I do get the email sent to the admin, but the only thing that shows up in the browser is a blank screen. If I add your error_page.cfm code to the error_admin.cfm page then the admin email is sent, then the error message to the user is displayed. Why do we need two pages? (I assume that exception error code, being set to any will catch every type of error that occurs and therefore, the error_admin.cfm page will always be executed?) Thanks, Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:54 AM To: CF-Talk Subject: RE: cferror First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and
OT: refresh iframe
Have 2 iframes in a page: iframe names are matchList and matchDetail. When making certain updates in a matchDetail template, want to refresh the template in matchList. Have done this in standard frames with something like the code below in the main frame to refresh a list in a side frame: Script parent.List.location=myList.cfm /script Is there something similar for iframes? Tried script matchList.location=myList.cfm /script but that didn't do it. Thanks for any suggestions. E. Keith Dodd Wings of Eagles Services www.wingserv.com - [This E-mail scanned for viruses by declude AntiVirus Software] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Setting the focus to form select box item.
The options[] element of the select is an array. Arrays in javascript
begin with 0.
Cutter
Bosky, Dave wrote:
I'm using the onsubmit function to check the length of a form textfield to
verify it contains at least one character.
If the value is less than one character I want to return false and set the
focus to the first item in a select box.
What am I leaving out?
-
function validateForm(form) {
if (form.myText.value.length 1 ){
alert ('You must select at least one question to continue. n\nClick
OK!);
form.mySelect.options[1].focus();
return false;
}
return true;
}
-
FORM action=update.cfm method=post onSubmit=return
validateForm(this);
INPUT TYPE=TEXT NAME=myText VALUE=
SELECT NAME='mySelect SIZE=20 MULTIPLE
OPTION VALUE=11/OPTION
OPTION VALUE=22/OPTION
OPTION VALUE=33/OPTION
/SELECT
INPUT TYPE=SUBMIT VALUE=GO
/FORM
-
thx
Dave
HTC Disclaimer: The information contained in this message may be privileged and
confidential and protected from disclosure. If the reader of this message is not the
intended recipient, or an employee or agent responsible for delivering this message
to the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by replying to the
message and deleting it from your computer. Thank you.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Re: Setting the focus to form select box item.
SelectedIndex is a read-only property in all browsers except Navigator
3 (O'Reilly's JavaScript: The Definitive Guide).
Cutter
Scott Brady wrote:
function validateForm(form) {
if (form.myText.value.length 1 ){
alert ('You must select at least one question to continue. n\nClick
OK!);
form.mySelect.options[1].focus();
return false;
}
return true;
}
Try this:
function validateForm(form) {
if (form.myText.value.length 1 ){
alert ('You must select at least one question to continue. n\nClick
OK!);
form.mySelect.selectedIndex = 0; // The first index
form.mySelect.focus();
return false;
}
return true;
}
Scott
Scott Brady
http://www.scottbrady.net/
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
RE: refresh iframe
If I remember correctly iframes have an href property you can set to change/update the page. Like an image. i.e. ..matchList.href = 'blah.html' this is just off the top of my head though so I could be crazy wrong. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: E. Keith Dodd [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:18 PM To: CF-Talk Subject: OT: refresh iframe Have 2 iframes in a page: iframe names are matchList and matchDetail. When making certain updates in a matchDetail template, want to refresh the template in matchList. Have done this in standard frames with something like the code below in the main frame to refresh a list in a side frame: Script parent.List.location=myList.cfm /script Is there something similar for iframes? Tried script matchList.location=myList.cfm /script but that didn't do it. Thanks for any suggestions. E. Keith Dodd Wings of Eagles Services www.wingserv.com - [This E-mail scanned for viruses by declude AntiVirus Software] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: refresh iframe
Actually I think it src...? Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: E. Keith Dodd [mailto:[EMAIL PROTECTED]] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Setting the focus to form select box item.
I have written JavaScript code that modifies SELECT.selectedIndex
without problems in NS6.x and IE5+.
Anyway, as for Dave's problem, change:
form.mySelect.options[1].focus();
To:
form.mySelect.options[1].selected = true;
form.mySelect.focus();
OR:
form.mySelect.selectedIndex = 1; // or 0
form.mySelect.focus();
The OPTION object does not have a focus() method in NS JS 1.3 spec.
James Ang
Programmer
MedSeek, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 1:20 PM
To: CF-Talk
Subject: Re: Setting the focus to form select box item.
SelectedIndex is a read-only property in all browsers except Navigator
3 (O'Reilly's JavaScript: The Definitive Guide).
Cutter
Scott Brady wrote:
function validateForm(form) {
if (form.myText.value.length 1 ){
alert ('You must select at least one question to continue. n\nClick
OK!);
form.mySelect.options[1].focus();
return false;
}
return true;
}
Try this:
function validateForm(form) {
if (form.myText.value.length 1 ){
alert ('You must select at least one question to continue. n\nClick
OK!);
form.mySelect.selectedIndex = 0; // The first index
form.mySelect.focus();
return false;
}
return true;
}
Scott
Scott Brady
http://www.scottbrady.net/
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: refresh iframe
Just reload like you would a normal window... Make sure you use the id attribute of the tag, not the name attribute of it. iframeid.location.href.reload(); Yes, it's src, not href... Although an iframe is also a window, and a window has the href attribute, so I think you can use either... -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:46 PM To: CF-Talk Subject: RE: refresh iframe If I remember correctly iframes have an href property you can set to change/update the page. Like an image. i.e. .matchList.href = 'blah.html' this is just off the top of my head though so I could be crazy wrong. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: E. Keith Dodd [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:18 PM To: CF-Talk Subject: OT: refresh iframe Have 2 iframes in a page: iframe names are matchList and matchDetail. When making certain updates in a matchDetail template, want to refresh the template in matchList. Have done this in standard frames with something like the code below in the main frame to refresh a list in a side frame: Script parent.List.location=myList.cfm /script Is there something similar for iframes? Tried script matchList.location=myList.cfm /script but that didn't do it. Thanks for any suggestions. E. Keith Dodd Wings of Eagles Services www.wingserv.com - [This E-mail scanned for viruses by declude AntiVirus Software] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
