Getting the sql statement of a query
I want to create a component to further process a CF query passed to it. Does anybody know how I can retrieve the actual SQL statement from a query? Thanks Dominique ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Administrator Email Address
There's a way to do this using CFERROR. I've detailed it in this presentation. http://www.houseoffusion.com/error.ppt Is there a way to dynamically set the admin email address when an error pops up. I run about 10 sites on one server and I would like to send the admin email from the default error page to different addresses based on the website it came from. TIA Robert ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Can I get miliseconds in timeFormat()
Is it possible to get milisecond in timeFormat( )? Just wondering. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CF Credit Card Verification/ Authorization Question
Hi Brian, Feel free to contact Martin Leroux ( mailto:martin.leroux;sfcommerce.com ) for pricing details. You can also find contract details here: North Amercia: https://payment.firepay.com/surefire/ccs/reg/register.jsp?VERSION=1.0CURREN CY=USD,CAD UK: https://payment.firepay.com/surefire/ccs/reg/register.jsp?VERSION=1.0CURREN CY=EUR,GBPLOCALE=en_UK Cheers! Stace -Original Message- From: Yager, Brian T Contractor/Sverdrup [mailto:brian.yager;redstone.army.mil] Sent: Monday, October 21, 2002 11:00 AM To: CF-Talk Subject: RE: CF Credit Card Verification/ Authorization Question sfcommerce doesn't have pricing on their website..Can anyone who uses them shoot me an email off list as to what they charge? Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: CF-Ross [mailto:cf-ross;carolina.rr.com] Sent: Monday, October 21, 2002 9:35 AM To: CF-Talk Subject: Re: CF Credit Card Verification/ Authorization Question Thanks all for the feedback. Stace I'll be pushing sfcommerce. Thank you for the offer. Hope not too off topic for the rest of you guys. -Jason - Original Message - From: CF-Ross [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 21, 2002 2:31 AM Subject: Re: CF Credit Card Verification/ Authorization Question That's the thing. It's for a Client and he is doing much business, just not online, until now. Would that Merchant account be with his Bank? And if so what approach should I take? And, if he does not have a merchant account what would be a nice solution? I'm looking at Sfcommerce, Paypal, and Versign. If he does have a Merchant account what will that change? Any info is much appreciated! As I am not new to CF but this is my first ecommerce setup. Thanks. Jason - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 21, 2002 1:38 AM Subject: Re: CF Credit Card Verification/ Authorization Question Do you have your own merchant account or are you planning on using a 3rd party processor? -Novak - Original Message - From: CF-Ross [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 20, 2002 5:29 PM Subject: CF Credit Card Verification/ Authorization Question Anyone have suggestions on which Credit Card Authorization/ Verification systems are best suited for CF. I have the shopping cart built and all is set up but I'm not familiar with the actual CC Verification Process. Any comments, links, suggestions? Thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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 poll custom tag or application
Hi, Does anyone know of a free CF based poll custom tag or small application that can handle a multiple choice poll? I need something that will allow the users to select their top X choices from a list and then track the results of each possible choice. I need this is for a school assignment to aid in our team projects; therefore, I don't really have any sort of budget to work with. TIA for any input! Mike Wilson ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
POST problem in CFMX (was misnamed)
Check the VERBS setting for your extension mapping: Go to the web site properties in IIS Select the home directory tab click on the configuration button (near the bottom) Look at the two mappings for CF - .cfm and .cfc (you may have more). They should be configured to either ALL verbs, or GET,POST. good luck. -Original Message- From: Eric Creese [mailto:ecreese;popmail.com] Sent: Monday, October 21, 2002 9:33 AM To: CF-Talk Subject: How about Macromedia provide a more detailed configuration do cument for CFMX? I am at a client site that is a Microsoft Shop. I am developing a ColdFusion using MX. I am coming across some issues with regards to posting forms. It seems that when I use the get method, everything works fine but when I try to use the post method it fails without error message. I outputed the form's content on the action page and all thet it displays is the HTTP header information. I created another test to see if it was a CF issue or not so I scripted 3 HTML pages. 2 of the pages contain forms, one using get the other with post. They both post to the third HTML page. The get page worked and the post page raised a 405 error. I took the same three HTML pages and ran them locally on my harddrive and they both worked fine. I have uninstalled and reinstalled MX several times with the same results. This leads me to believe that there is an issue with IIS. Has anyone seen this before and can explain to me what the problem is? They are convinced that it is ColdFusion configuration issue (since they prefer to use ASP here) and I am trying to explain to them this is an IIS lockdown issue. I am not an IIS expert but seems to me that is where the issue lies. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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.
check/uncheck checkboxes
Guys,
I have this code which checks all checkboxes in a form :
function checkAll(theForm) {
for (i=0,n=theForm.elements.length;in;i++)
if (theForm.elements[i].name.indexOf('chkmsg') !=-1)
theForm.elements[i].checked = true;
}
I then call it via another checkbox :
input type=checkbox onClick=if (this.checked) checkAll(this.form);
This all works AOK except that I am missing the code to uncheck them!!! Can
anyone point me in the right direction with a solution?! I am sure its
fairly simple, but I just cant see it as of yet :-(
Neil
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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: check/uncheck checkboxes
Could you just run the same code with false instead of true?
Mark Stephenson
New Media Director
Evolution Internet
T: 0870 757 1631
F: 0870 757 1632
W: www.evolutioninternet.co.uk
E: [EMAIL PROTECTED]
WARNING:
---
The information contained in this document and attachments is confidential
and intended only for the person(s) named above. If you are not the
intended recipient you are hereby notified that any disclosure, copying,
distribution, or any other use of the information is strictly prohibited.
If you have received this document by mistake, please notify the sender
immediately and destroy this document and attachments without making any
copy of any kind.
AVIS IMPORTANT:
---
Les informations contenues dans le present document et ses pieces jointes
sont strictement confidentielles et reservees a l'usage de la (des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez
avise que toute divulgation, distribution, copie, ou autre utilisation de
ces informations est strictement prohibee. Si vous avez recu ce document
par erreur, veuillez s'il vous plait communiquer immediatement avec
l'expediteur et detruire ce document sans en faire de copie sous quelque
forme.
-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:Neil.Robertson-Ravo;csd.reedexpo.com]
Sent: 21 October 2002 16:32
To: CF-Talk
Subject: check/uncheck checkboxes
Guys,
I have this code which checks all checkboxes in a form :
function checkAll(theForm) {
for (i=0,n=theForm.elements.length;in;i++)
if (theForm.elements[i].name.indexOf('chkmsg') !=-1)
theForm.elements[i].checked = true;
}
I then call it via another checkbox :
input type=checkbox onClick=if (this.checked) checkAll(this.form);
This all works AOK except that I am missing the code to uncheck them!!! Can
anyone point me in the right direction with a solution?! I am sure its
fairly simple, but I just cant see it as of yet :-(
Neil
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Frames Issue
OK, I know this is going to be simple, but I haven't used frames very much. I'm in a fusebox setting. I have a variable which I'm setting in one template. Then the next template is included which defines a frameset. This variable is available in this template. But one of the frames is a cf template and the variable isn't resolvable there. I tried request and client scope with no luck. Here's the excerpt from my fbx_switch: cfcase value=tree2 cfinclude template=qry_drawtree.cfm cfinclude template=act_setvar.cfm SETS THE VARIABLE cfinclude template=dsp_tree2.cfm DEFINES THE FRAMESET /cfcase Here's the frameset: frameset rows=60,*,40 border=0 frame name=header src=dsp_header.cfm marginwidth=15 marginheight=15 scrolling=no frameborder=0 frameset cols=300,* border=0 frame name=tree src=dsp_treeframe.cfm marginwidth=2 marginheight=2 scrolling=auto frameborder=0 frame name=content src=dsp_content.cfm marginwidth=15 marginheight=15 scrolling=auto frameborder=0 /frameset frame name=footer src=dsp_footer.cfm marginwidth=15 marginheight=15 scrolling=no frameborder=0 /frameset And my variable isn't resolvable in dsp_treeframe.cfm. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Frames Issue
I tried request and client scope with no luck. Any reason not to use session ? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
English string extraction
HI all, I'm coordinating the translation of a CF extranet application to Japanese. I intend to hand off a spreadsheet of strings to be translated to a linguist. Right now I'm thinking that writing an app to try and strip out strings would be a multiple of the time it would take to copy and paste them by hand into a spreadsheet and taking not of line numbe and path/file name. That's a litle too open for human error too. This is also very definitely just a once-off project too i.e. there aren't any other apps that might be translated. This is a long shot but it'd make life easier if someone knew of a tool that might do this. I know they exist for compiled langauges so maybe there's one that might work for CFML? Thanks, Kevin ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: check/uncheck checkboxes
Neil,
selectall = true;
function checkAll(theForm) {
if (selectall == true) {
selectall = false;
theForm.selectallbutton.src = selectall_off.gif;
} else {
selectall = true;
theForm.selectallbutton.src = selectall_on.gif;
}
for (i=0,n=theForm.elements.length;in;i++)
if (theForm.elements[i].name.indexOf('chkmsg') !=-1)
theForm.elements[i].checked = selectall;
}
input name=selectallbutton type=image src=selectall_on.gif
alt=Select All onClick=checkAll(this.form);
The selectall variable goes in global Javascript space and I _think_ I have
the code right for setting the selectallbutton image
That should point you in the right direction.
Regards
Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
RE: Frames Issue
Yeah, it's not going to resolve the way you want. The frames have no solid connection to the calling page (frameset). Your best bet would be to include the shared variables in a URL string when you call the frames: frame name=tree src=dsp_treeframe.cfm?sharedVar=#thisNthat# marginwidth=2 marginheight=2 scrolling=auto frameborder=0 You could use SESSION or CLIENT scope, but it seems unnecessary, and then you would have to worry about locking. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Greg Luce [mailto:greg;thedatabaseplace.com] Sent: Monday, October 21, 2002 11:48 AM To: CF-Talk Subject: Frames Issue OK, I know this is going to be simple, but I haven't used frames very much. I'm in a fusebox setting. I have a variable which I'm setting in one template. Then the next template is included which defines a frameset. This variable is available in this template. But one of the frames is a cf template and the variable isn't resolvable there. I tried request and client scope with no luck. Here's the excerpt from my fbx_switch: cfcase value=tree2 cfinclude template=qry_drawtree.cfm cfinclude template=act_setvar.cfm SETS THE VARIABLE cfinclude template=dsp_tree2.cfm DEFINES THE FRAMESET /cfcase Here's the frameset: frameset rows=60,*,40 border=0 frame name=header src=dsp_header.cfm marginwidth=15 marginheight=15 scrolling=no frameborder=0 frameset cols=300,* border=0 frame name=tree src=dsp_treeframe.cfm marginwidth=2 marginheight=2 scrolling=auto frameborder=0 frame name=content src=dsp_content.cfm marginwidth=15 marginheight=15 scrolling=auto frameborder=0 /frameset frame name=footer src=dsp_footer.cfm marginwidth=15 marginheight=15 scrolling=no frameborder=0 /frameset And my variable isn't resolvable in dsp_treeframe.cfm. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: check/uncheck checkboxes
Is there one which uses a checkbox instead of an image/button?
-Original Message-
From: Stephen Moretti [mailto:stephen;cfmaster.co.uk]
Sent: 21 October 2002 17:07
To: CF-Talk
Subject: Re: check/uncheck checkboxes
Neil,
selectall = true;
function checkAll(theForm) {
if (selectall == true) {
selectall = false;
theForm.selectallbutton.src = selectall_off.gif;
} else {
selectall = true;
theForm.selectallbutton.src = selectall_on.gif;
}
for (i=0,n=theForm.elements.length;in;i++)
if (theForm.elements[i].name.indexOf('chkmsg') !=-1)
theForm.elements[i].checked = selectall;
}
input name=selectallbutton type=image src=selectall_on.gif
alt=Select All onClick=checkAll(this.form);
The selectall variable goes in global Javascript space and I _think_ I have
the code right for setting the selectallbutton image
That should point you in the right direction.
Regards
Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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: CFFile Questions
Just create the contents of the file as a variable. Then use cfFile action=write to append your variable to the end of the file. You know there are a whole mess of customTags out there to create Excel and Word docs for ya. Check out MM's Xchange. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Thane Sherrington [mailto:tsherr;auracom.com] Sent: Monday, October 21, 2002 10:48 AM To: CF-Talk Subject: CFFile Questions How could I use CFFile to create a command delimited file that would be then downloaded to the client's computer for use as a mail merge file for WordPerfect or Word? T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: File meta data lib (was: Re: counting # of characters in file)
Just an FYI, you should not create variables in UDFs without using the
var scope.
function FileLength(filename){
_File = createObject('java', 'java.io.File');
_File.init(JavaCast('string', filename));
return _File.length();
}
should be
function FileLength(filename){
var _File = createObject('java', 'java.io.File');
_File.init(JavaCast('string', filename));
return _File.length();
}
I had already altered them to Variables._File. Is that the same btw? I'm
lost here. Blame it on the lack of coffee :)
Jesse
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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.
Long form and variable names?
Hi all, This is probably a CF101 question, but I am missing it. I'm making an order form where each item is laid out in a table row with:itemNO,desc,price,quantity (input/text box). This is not a shopping cart. Just an order form for people who have an account. The items ordered will be sent to my client as an email, then also posted on the action page for the site visitor (you ordered x,y,z). Each row pulls the item number, desc, and price for display, then has an input/text box for the quantity to be entered. I'm passing along the description and ID data as hidden variables which will help to identify each ordered item and also to display for the visitor on the action page. When I test this, and try to hit the submit button, nothing happens. I suspect the problem is that each row has a formfield named 'quantity'. But how would this be handled alternately? I had originally had the input name for quantity to be input name=prod#ItemID#, but how then would I call this up on the resulting action page? And the email? The page in question is http://216.197.109.132/order.cfm . Thank you in advance for any help you can provide! Regards, Keith [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: check/uncheck checkboxes
Use the two code samples below to call for Selecting and UN-selecting
the checkboxes.
// This function will CHECK all elements on the page
function SelectAll() {
var i=0;
for( i=0 ; idocument.FileListing.elements.length; i++) {
document.FileListing.elements[i].checked=1;
}
}
// This function will UNCHECK all elements on the page
function ClearAll() {
var i=0;
for( i=0 ; idocument.FileListing.elements.length; i++) {
document.FileListing.elements[i].checked=0;
}
}
=== To call the SelectAll function:
INPUT TYPE=button VALUE=Select All NAME=Select_All
OnClick=SelectAll();
=== To call the ClearAll function:
INPUT TYPE=button VALUE=Clear All NAME=Clear_All
OnClick=ClearAll();
[EMAIL PROTECTED] 10/21/02 12:28PM
Is there one which uses a checkbox instead of an image/button?
-Original Message-
From: Stephen Moretti [mailto:stephen;cfmaster.co.uk]
Sent: 21 October 2002 17:07
To: CF-Talk
Subject: Re: check/uncheck checkboxes
Neil,
selectall = true;
function checkAll(theForm) {
if (selectall == true) {
selectall = false;
theForm.selectallbutton.src = selectall_off.gif;
} else {
selectall = true;
theForm.selectallbutton.src = selectall_on.gif;
}
for (i=0,n=theForm.elements.length;in;i++)
if (theForm.elements[i].name.indexOf('chkmsg') !=-1)
theForm.elements[i].checked = selectall;
}
input name=selectallbutton type=image src=selectall_on.gif
alt=Select All onClick=checkAll(this.form);
The selectall variable goes in global Javascript space and I _think_ I
have
the code right for setting the selectallbutton image
That should point you in the right direction.
Regards
Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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: counting # of characters in file
Paul Hastings wrote:
cfscript
function GetFileLength(filename){
file = createObject('java', 'java.io.File');
file.init(filename);
return file.length();
}
/cfscript
i think file is an overloaded method which will cause mx to barf (did you
try that code?). you might need to write a wrapper class.
I did now test it and it works. Just cast the filename to the type
string, and all is well :) (using JavaCast)
Jesse
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Re: English string extraction
This is a long shot but it'd make life easier if someone knew of a tool that might do this. I know they exist for compiled langauges so maybe there's one that might work for CFML? ibm's resource bundle manager is one cool tool for this sort of thing. http://www-106.ibm.com/developerworks/library/j-rbmgr/index.html --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/2545 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: counting # of characters in file
Jochem van Dieten wrote: Thomas Chiverton wrote: IIRC, this returns the length in bytes, not in characters. Same thing for ASCII text, innit ? Yes (unless we are talking forks/altenate datastreams). But I didn't see anybody confirm that the files were ASCII. Well, this returns the same as a len count of it's content. But I'm not sure what happens with multibyte characters. I tested it with several files, and alternate streams and filesystem overhead and security meta data are not added to this count. If you want to actually count the number of cars, there is probably no alternative then to actually loop through the contents and coutn it yourself. (as len() does). But this is way faster :)~ Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: counting # of characters in file
I did now test it and it works. Just cast the filename to the type string, and all is well :) (using JavaCast) surprised that javacast worked, never worked for me with numeric data. was it the string or inline use? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 16/10/2545 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CFIndex for Verity quit working - Needs Attention by Macromedia!
Is it possible you are trying to index a recordset over 250,000 records? The following is paraphrased from a Verity publication detailing the Macromedia OEM agreement: Here is a list of key counts limits by product per Verity: ColdFusion Professional:125,000 Documents Max. ColdFusion Enterprise: 250,000 Documents Max. ColdFusion Advanced:175,000 Documents Max. Coldfusion Developer Edition: 10,000 Documents Max. Features _NOT_ included with Macromedia's OEM agreement: 1. Brokered Search 2. Does not have access to any of Verity's automatic classification tools. 3. Does not support Relational Taxonomies. 4. Does not provide integration with a company's chosen security context. 5. Does not provide Verity's full document viewing capabilities. 6. Does not provide Verity's recommendation engine. 7. Does not provide a parametric search interface. 8. Does not provide hit count display for categories or parametric attribs. 9. Does not provide Federated search capabilities. 10. Does not provide Verity Gateways to content management solutions. 11. Does not provide Verity Gateways to enterprise e-mail applications. /verity As you can see according to Verity, there is no limitation of the Verity query language built into the Macromedia OEM agreement. Since this document is provided by Verity when they are trying to sell K2 to orgs that already have CFMX, I'm very confident that if sections of the query language had been limited or smurfed as part of the oem agreement, then Verity would have clearly stated this in big bold letters ;). I think you can safely read into this that the fact specific functions are not working in the CFMX verity implementation (like delete and soundex), is most likely due to a mistake in packaging on Macromedia's part. Someone from MM please address this thread! However, if there is indeed language level limitations in this OEM product, Macromedia has a responsibility to its developers to make a clear statement regarding exactly what is and isn't in this release! A few of you have asked for alternatives to the technology due to your aggravation with this implementation. Here are my thoughts on the matter: 1. For a large loose text/document search project I would recommend purchasing Verity's K2 server. I would urge you NOT to judge the Verity product based upon the oem experience delivered by the Verity97 agreement with Allaire, and the K2 agreement with macromedia. Verity's K2 is an extremely powerful product, and in my opinion the best in the field, but it is priced as such. 2. Consider using some of the database free text search utilities. Microsoft and Oracle both offer free text search utilities that run on their DB engine. MS specifically has a SOUNDEX implementation in their T-SQL implementation. This solution will place a considerably heavier burden on you as the developer, but is perhaps a more cost effective solution. You will likely never match verity's implementation of thesaurus matching, and other really cool things their engine does, but you can build a half way decent data centric search. 3. Look into competing technologies. Inktome is also a good search engine tool that you can license for your App. I haven't used them in the last 18 months, but I know they used to offer a pay as you go solution. .01 cents per query, etc. For a smaller load site this could often also be a viable alternative considering the entry cost of a K2 server. Good luck, Trey Rouse Data Architect Developer Rice University -Original Message- From: Mark Leder [mailto:mel;markleder.com] Sent: Sunday, October 20, 2002 1:16 AM To: CF-Talk Subject: CFIndex for Verity quit working Hi everyone, My client has an MS Access 2002 db which is periodically uploaded to the ISP server (Win XP-CF 5) and a CFIndex Action=refresh run on it. This process has been used successfully for several months now. The db when we started was about 4.5mb in size, now it's grown to about 11mb. The client does a compact and repair prior to uploading each time. The db only contains one table and one form, the table has an autoindex numbering for each record (no duplicates), and three other corresponding fields for each record (all memo fields). The problem is, the CF index has quit working on this database. I have not changed a single line of code. The CFQUERY prior to the CFINDEX used to retrieve the db records works normally. The CFIndex hangs, and the Access db goes into a locked condition (db.lbd). This whole process used to take about 1 minute for an indexing routine, now it won't work at all. I've had the ISP reboot the server but that doesn't help either. I've tried deleting and recreating the collection, which works, but it doesn't solve the problem. Below is the dbrefresh.cfm code for your review. Any ideas on how to resolve? HELP!!! I'm really stuck. Is there a file size limit that Verity won't work with if it exceeds
Re: Long form and variable names?
When you click the SUBMIT BUTTON nothing happens. This is because it is a BUTTON. The input type should be: type=submit [EMAIL PROTECTED] 10/21/02 12:40PM Hi all, This is probably a CF101 question, but I am missing it. I'm making an order form where each item is laid out in a table row with:itemNO,desc,price,quantity (input/text box). This is not a shopping cart. Just an order form for people who have an account. The items ordered will be sent to my client as an email, then also posted on the action page for the site visitor (you ordered x,y,z). Each row pulls the item number, desc, and price for display, then has an input/text box for the quantity to be entered. I'm passing along the description and ID data as hidden variables which will help to identify each ordered item and also to display for the visitor on the action page. When I test this, and try to hit the submit button, nothing happens. I suspect the problem is that each row has a formfield named 'quantity'. But how would this be handled alternately? I had originally had the input name for quantity to be input name=prod#ItemID#, but how then would I call this up on the resulting action page? And the email? The page in question is http://216.197.109.132/order.cfm . Thank you in advance for any help you can provide! Regards, Keith [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: is my redundancy solution a violation of licensing terms?
I love PostgreSQL, however for the majority of our apps, clients, and vendors if I made the suggestion to use PostgreSQL over Oracle or MS SQL, I'ld be laughed out of the room ;). But, PostgreSQL is a great product. The number one reason to use PostgreSQL - Select Distinct _ON_. Damn I love that ;). Trey Rouse -Original Message- From: Josh Trefethen [mailto:jtnewsletters;exciteworks.com] Sent: Saturday, October 19, 2002 1:22 PM To: CF-Talk Subject: RE: is my redundancy solution a violation of licensing terms? Switch to PostgreSQL! http://postgresql.org I made the switch from SQL Server a while back and haven't paid or worried about licensing for sometime; yet still enjoy advanced RDBMS features like stored procs, triggers, etc. Take a look... Josh Trefethen http://exciteworks.com Affordable CF Hosting on Linux -Original Message- From: Trey Rouse [mailto:trouse;rice.edu] Sent: Saturday, October 19, 2002 1:20 PM To: CF-Talk Subject: RE: is my redundancy solution a violation of licensing terms? I'm fairly certain this is a violation of both licensures. However, you CAN use your single SQL license to run on two boxes provided you configure them in a passive cluster. However your non-clustered fail over solution does not meet their definition of fail-over only. Microsoft has made a concession that if your implementation is purely as passive fail over, then they don't hit you twice for licensing. They admit that since only one license can actually be available at any given moment, they can't charge you for 2. In honesty, I was surprised when our M$ rep told us this ;). Perhaps Macromedia should consider allowing this when installed on OS enforced passive clusters as well ;). Trey Rouse -Original Message- From: John Innit [mailto:harmony;mtv.net] Sent: Thursday, October 17, 2002 8:22 PM To: CF-Talk Subject: is my redundancy solution a violation of licensing terms? I'm running a site on CF 4.5 on Win2K, IIS 5.0 and SQL 2000. We have 2 servers. Web server runs IIS 5.0, CF 4.5 and the DB Server runs SQL 2000 I want to set up a redundancy precaution where I install SQL Server on the Web server and CF and IIS on the DB server so that in the event of a hardware failure on either of the machines, I'll still be able to get the site up and running quickly. Does this violate the standard licensing agreements? I'm not sure what licenses we have, but I will check with my tech people, I just want to know if this is a viable option and if not can anyone suggest a way we can have a backup solution in the event of a hardware failure on either of my servers? Thanks for your help. The only difference between me and a madman is that I'm not mad. Innit ? - Salvador Dali + Co. (1904-1989) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Long form and variable names?
I saw this in your code: input type=button name=submit value=Submit Order It should be input type=submit name=submit value=Submit Order Type=button will not submit the form. Only tpe=submit will do so. -Patti Keith Taylor wrote: Hi all, This is probably a CF101 question, but I am missing it. I'm making an order form where each item is laid out in a table row with:itemNO,desc,price,quantity (input/text box). This is not a shopping cart. Just an order form for people who have an account. The items ordered will be sent to my client as an email, then also posted on the action page for the site visitor (you ordered x,y,z). Each row pulls the item number, desc, and price for display, then has an input/text box for the quantity to be entered. I'm passing along the description and ID data as hidden variables which will help to identify each ordered item and also to display for the visitor on the action page. When I test this, and try to hit the submit button, nothing happens. I suspect the problem is that each row has a formfield named 'quantity'. But how would this be handled alternately? I had originally had the input name for quantity to be input name=prod#ItemID#, but how then would I call this up on the resulting action page? And the email? The page in question is http://216.197.109.132/order.cfm . Thank you in advance for any help you can provide! Regards, Keith [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: CF Credit Card Verification/ Authorization Question
I implemented with them (authorize.net) as well - and a few simple if or swtich statements and I was done. First time I implemented was also my first year cf coding and it took me less than 4 hours to research, code and implement. jay Bud wrote: On 10/20/02, CF-Ross penned: Anyone have suggestions on which Credit Card Authorization/ Verification systems are best suited for CF. Authorize.net is always my first choice. No special CFX, COM, etc. needed. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: English string extraction
Thanks, I'll give that a look! -Original Message- From: Paul Hastings [mailto:paul;tei.or.th] Sent: Monday, October 21, 2002 12:58 PM To: CF-Talk Subject: Re: English string extraction This is a long shot but it'd make life easier if someone knew of a tool that might do this. I know they exist for compiled langauges so maybe there's one that might work for CFML? ibm's resource bundle manager is one cool tool for this sort of thing. http://www-106.ibm.com/developerworks/library/j-rbmgr/index.html --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/2545 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CFFile Questions
create a variable to hold the contents of the file, when you write the file you output the contents of the variable. ie. cfset cdf = 1,2,3,4,5,6,7 cffile action=WRITE file=filename.cdf output=#cdf# You'll probably need to know the end of record character, not sure what it is. HTH Eric From: Thane Sherrington [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: CFFile Questions Date: Mon, 21 Oct 2002 11:48:04 -0300 How could I use CFFile to create a command delimited file that would be then downloaded to the client's computer for use as a mail merge file for WordPerfect or Word? T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
cfmail tag and looping output
Hello List - One of my client has about 8,000 emails that have signed up for sales letters and newsletters on his site. I have been testing a simply query that pulls from 3 tables - creates an output that loops and executes the cfmail tag each time - using a ID that is primary so no duplicates are being sent.. It surprisingly doesn't take that long ( although I haven't tested on the full lot) BUT i have heard 1) Cfmail tag not being reliable 2) their must be a more efficient way to code this. So I am looking to this list to find if there is any truth to cfmail dropping results OR if there is other tags ( please hint) that I should really be looking into. Client wants me to manage this through some simple scripts - and would like to send html formated email. We are leaning away from purchasing 3rd party solutions and installing special server software is not possible. thanks! jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CFIndex for Verity quit working - Needs Attention by Macromedia!
I know nothing of the product but do recall a CF developer on another list raving about dtSearch as a replacement for the version of Verity packaged with CF. Might be worth looking at anyway: http://www.dtsearch.com/ Ken -Original Message- From: Trey Rouse [mailto:trouse;rice.edu] Sent: Monday, October 21, 2002 12:51 PM To: CF-Talk Subject: RE: CFIndex for Verity quit working - Needs Attention by Macromedia! Is it possible you are trying to index a recordset over 250,000 records? The following is paraphrased from a Verity publication detailing the Macromedia OEM agreement: Here is a list of key counts limits by product per Verity: ColdFusion Professional:125,000 Documents Max. ColdFusion Enterprise: 250,000 Documents Max. ColdFusion Advanced:175,000 Documents Max. Coldfusion Developer Edition: 10,000 Documents Max. Features _NOT_ included with Macromedia's OEM agreement: 1. Brokered Search 2. Does not have access to any of Verity's automatic classification tools. 3. Does not support Relational Taxonomies. 4. Does not provide integration with a company's chosen security context. 5. Does not provide Verity's full document viewing capabilities. 6. Does not provide Verity's recommendation engine. 7. Does not provide a parametric search interface. 8. Does not provide hit count display for categories or parametric attribs. 9. Does not provide Federated search capabilities. 10. Does not provide Verity Gateways to content management solutions. 11. Does not provide Verity Gateways to enterprise e-mail applications. /verity As you can see according to Verity, there is no limitation of the Verity query language built into the Macromedia OEM agreement. Since this document is provided by Verity when they are trying to sell K2 to orgs that already have CFMX, I'm very confident that if sections of the query language had been limited or smurfed as part of the oem agreement, then Verity would have clearly stated this in big bold letters ;). I think you can safely read into this that the fact specific functions are not working in the CFMX verity implementation (like delete and soundex), is most likely due to a mistake in packaging on Macromedia's part. Someone from MM please address this thread! However, if there is indeed language level limitations in this OEM product, Macromedia has a responsibility to its developers to make a clear statement regarding exactly what is and isn't in this release! A few of you have asked for alternatives to the technology due to your aggravation with this implementation. Here are my thoughts on the matter: 1. For a large loose text/document search project I would recommend purchasing Verity's K2 server. I would urge you NOT to judge the Verity product based upon the oem experience delivered by the Verity97 agreement with Allaire, and the K2 agreement with macromedia. Verity's K2 is an extremely powerful product, and in my opinion the best in the field, but it is priced as such. 2. Consider using some of the database free text search utilities. Microsoft and Oracle both offer free text search utilities that run on their DB engine. MS specifically has a SOUNDEX implementation in their T-SQL implementation. This solution will place a considerably heavier burden on you as the developer, but is perhaps a more cost effective solution. You will likely never match verity's implementation of thesaurus matching, and other really cool things their engine does, but you can build a half way decent data centric search. 3. Look into competing technologies. Inktome is also a good search engine tool that you can license for your App. I haven't used them in the last 18 months, but I know they used to offer a pay as you go solution. .01 cents per query, etc. For a smaller load site this could often also be a viable alternative considering the entry cost of a K2 server. Good luck, Trey Rouse Data Architect Developer Rice University -Original Message- From: Mark Leder [mailto:mel;markleder.com] Sent: Sunday, October 20, 2002 1:16 AM To: CF-Talk Subject: CFIndex for Verity quit working Hi everyone, My client has an MS Access 2002 db which is periodically uploaded to the ISP server (Win XP-CF 5) and a CFIndex Action=refresh run on it. This process has been used successfully for several months now. The db when we started was about 4.5mb in size, now it's grown to about 11mb. The client does a compact and repair prior to uploading each time. The db only contains one table and one form, the table has an autoindex numbering for each record (no duplicates), and three other corresponding fields for each record (all memo fields). The problem is, the CF index has quit working on this database. I have not changed a single line of code. The CFQUERY prior to the CFINDEX used to retrieve the db records works normally. The CFIndex hangs, and the Access db goes into a locked condition (db.lbd). This whole
Re: cfmail tag and looping output
If you are concerned about reliability then I would suggest that you have a look at iMS-SE. iMS-SE is a high-performance mail sending engine that allows you to send email without requiring an external mail server. iMS Pro is the mail sending engine behind this email list, BTW. More information and a comparison sheet are available from our web site (the direct links are in my signature, below). -- 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: Jason Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 21, 2002 4:11 PM Subject: cfmail tag and looping output Hello List - One of my client has about 8,000 emails that have signed up for sales letters and newsletters on his site. I have been testing a simply query that pulls from 3 tables - creates an output that loops and executes the cfmail tag each time - using a ID that is primary so no duplicates are being sent.. It surprisingly doesn't take that long ( although I haven't tested on the full lot) BUT i have heard 1) Cfmail tag not being reliable 2) their must be a more efficient way to code this. So I am looking to this list to find if there is any truth to cfmail dropping results OR if there is other tags ( please hint) that I should really be looking into. Client wants me to manage this through some simple scripts - and would like to send html formated email. We are leaning away from purchasing 3rd party solutions and installing special server software is not possible. thanks! jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
WHAT IS THE MM TAG EXCHANGE url
I cannot seem to find the URL for the tag exchange on the MM site. Can anyone point me ??? ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: WHAT IS THE MM TAG EXCHANGE url
I think you want http://devex.macromedia.com/ -Original Message- From: S V [mailto:cf_man;hotmail.com] Sent: Monday, October 21, 2002 1:18 PM To: CF-Talk Subject: WHAT IS THE MM TAG EXCHANGE url I cannot seem to find the URL for the tag exchange on the MM site. Can anyone point me ??? ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: WHAT IS THE MM TAG EXCHANGE url
http://devex.macromedia.com/developer/gallery/ [EMAIL PROTECTED] 10/21/02 01:18PM I cannot seem to find the URL for the tag exchange on the MM site. Can anyone point me ??? ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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.
Long form and variable names?
Thank you Patti and Randell. Sometimes the most obvious things escape us. I fixed the 'submit' button and that made it work. However, I am still having the problem with passing the data and posting it. On the action page, I reference the ordered items as follows: tr cfoutput td width=106font size=1 face=Verdana, Arial, Helvetica, sans-serif#form.orderedID#/font/td td width=246font size=1 face=Verdana, Arial, Helvetica, sans-serif#form.ordereddesc#/font/td td width=107font size=1 face=Verdana, Arial, Helvetica, sans-serifstrong#form.quantity#/strong/font/td /tr/cfoutput Nothing appears on the page, though, and when I view the page source, it is showing every single product! Not just the ones for which an order was placed in the quantity field. Shouldn't it only show the ones where quantity had a value? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: cfmail tag and looping output
I wouldn't trust cfMail for that many users. Not too mention the tax on your server. You really should explore third party solutions like majordomo and such. I've never been able to achieve consistent results when working with cfMail in large scale mailings. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jason Miller [mailto:millerj;etcnj.com] Sent: Monday, October 21, 2002 4:11 PM To: CF-Talk Subject: cfmail tag and looping output Hello List - One of my client has about 8,000 emails that have signed up for sales letters and newsletters on his site. I have been testing a simply query that pulls from 3 tables - creates an output that loops and executes the cfmail tag each time - using a ID that is primary so no duplicates are being sent.. It surprisingly doesn't take that long ( although I haven't tested on the full lot) BUT i have heard 1) Cfmail tag not being reliable 2) their must be a more efficient way to code this. So I am looking to this list to find if there is any truth to cfmail dropping results OR if there is other tags ( please hint) that I should really be looking into. Client wants me to manage this through some simple scripts - and would like to send html formated email. We are leaning away from purchasing 3rd party solutions and installing special server software is not possible. thanks! jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Relationship posts
If prefixing threads is such a bright idea, try mixing all of your mailing lists into one folder and see how easy it is to follow. There is a point where things get inconvenient. We're there. It takes about 30 seconds to create a folder in Outlook/Outlook Express, and maybe another minute to write a rule sending matching mail to that folder. C'mon... You guys all know this. Its not like y'all are sheep herders who just learned to spell email, let alone manage it. Create freaking folders and browse them. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Michael Dinowitz [mailto:mdinowit;houseoffusion.com] Sent: Sunday, October 20, 2002 3:17 PM To: CF-Talk Subject: Relationship posts In the last few weeks the CF-Talk list has been inundated with off topic posts about the relationship between the ColdFusion community and Macromedia. These discussions are important and should continue as a healthy debate, but they are NOT technical in nature. In order to try and keep the CF-Talk list to technical questions about ColdFusion, I'd like to suggest that those who want to discuss Macromedia and their practices subscribe to the CF-Partners list. If that list does not sound like the proper list, please email me personally with a new name for the list and I'll take it into consideration. Thank you for helping keep this technical list valuable to the community at large. Only you can help the growth of ColdFusion knowledge, only you Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cfmail tag and looping output
I don't know if it is possible with what you are doing, but you can do QUERY=... with the CFMAIL tag instead of looping over and calling the tag over and over. I believe this is faster. We have a need to send out a great many e-mails as well (about 3 times as many), and we are setting up a sort of round robin type process where mail will be sent out it chunks - perhaps you could look at that kind of process if the straight up mailing times out / fails. Cheers, Rob -Original Message- From: Jason Miller [mailto:millerj;etcnj.com] Sent: Monday, October 21, 2002 1:11 PM To: CF-Talk Subject: cfmail tag and looping output Hello List - One of my client has about 8,000 emails that have signed up for sales letters and newsletters on his site. I have been testing a simply query that pulls from 3 tables - creates an output that loops and executes the cfmail tag each time - using a ID that is primary so no duplicates are being sent.. It surprisingly doesn't take that long ( although I haven't tested on the full lot) BUT i have heard 1) Cfmail tag not being reliable 2) their must be a more efficient way to code this. So I am looking to this list to find if there is any truth to cfmail dropping results OR if there is other tags ( please hint) that I should really be looking into. Client wants me to manage this through some simple scripts - and would like to send html formated email. We are leaning away from purchasing 3rd party solutions and installing special server software is not possible. thanks! jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: cfmail tag and looping output
We ship out about 13-20k in one big swoop in a similar method as you described... The actual program never takes much time... It's the CFMAIL spooling that takes a long time... I can't verify that CFMAIL drops stuff... I know though that you will end up with erroneous entries in your UNDELIVERABLE mail folder under CFUSION... To fix that we run the resend undeliverable tag found in the Developer's Exchange... it works fine for us... AS far as other related problems... Time is probably the largest issue... Cause CF runs that query.. and then starts parsing emails to the CF mail directory... then the CF server at maximum once per minute tries sending a batch of them to your SMTP server, where they then sit and wait for the mail server to process them to the outside world... There is Jochem's tag which allows you to write the files directly to your mailservers pickup directory... That is an interesting thing to look at... There is also a third party mail replacement that someone on the list sells and is highly recommended... Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Jason Miller [EMAIL PROTECTED] Date: Mon, 21 Oct 2002 13:11:09 -0700 Subject: cfmail tag and looping output Hello List - One of my client has about 8,000 emails that have signed up for sales letters and newsletters on his site. I have been testing a simply query that pulls from 3 tables - creates an output that loops and executes the cfmail tag each time - using a ID that is primary so no duplicates are being sent.. It surprisingly doesn't take that long ( although I haven't tested on the full lot) BUT i have heard 1) Cfmail tag not being reliable 2) their must be a more efficient way to code this. So I am looking to this list to find if there is any truth to cfmail dropping results OR if there is other tags ( please hint) that I should really be looking into. Client wants me to manage this through some simple scripts - and would like to send html formated email. We are leaning away from purchasing 3rd party solutions and installing special server software is not possible. thanks! jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CFIndex for Verity quit working - Needs Attention by Macromedia!
Dtsearch is allegedly a very nice package.. THey post some very awe inspiring numbers and have ran ads for years in the classified sections of many tech magazines It comes with a nice, not free price tag.. If you have a unix server or proficiency with such checkout HTDIG.. its free... http://www.htdig.org/ -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Ken Wilson [EMAIL PROTECTED] Date: Mon, 21 Oct 2002 13:13:39 -0400 Subject: RE: CFIndex for Verity quit working - Needs Attention by Macromedia! I know nothing of the product but do recall a CF developer on another list raving about dtSearch as a replacement for the version of Verity packaged with CF. Might be worth looking at anyway: http://www.dtsearch.com/ Ken -Original Message- From: Trey Rouse [mailto:trouse;rice.edu] Sent: Monday, October 21, 2002 12:51 PM To: CF-Talk Subject: RE: CFIndex for Verity quit working - Needs Attention by Macromedia! Is it possible you are trying to index a recordset over 250,000 records? The following is paraphrased from a Verity publication detailing the Macromedia OEM agreement: Here is a list of key counts limits by product per Verity: ColdFusion Professional: 125,000 Documents Max. ColdFusion Enterprise:250,000 Documents Max. ColdFusion Advanced: 175,000 Documents Max. Coldfusion Developer Edition: 10,000 Documents Max. Features _NOT_ included with Macromedia's OEM agreement: 1. Brokered Search 2. Does not have access to any of Verity's automatic classification tools. 3. Does not support Relational Taxonomies. 4. Does not provide integration with a company's chosen security context. 5. Does not provide Verity's full document viewing capabilities. 6. Does not provide Verity's recommendation engine. 7. Does not provide a parametric search interface. 8. Does not provide hit count display for categories or parametric attribs. 9. Does not provide Federated search capabilities. 10. Does not provide Verity Gateways to content management solutions. 11. Does not provide Verity Gateways to enterprise e-mail applications. /verity As you can see according to Verity, there is no limitation of the Verity query language built into the Macromedia OEM agreement. Since this document is provided by Verity when they are trying to sell K2 to orgs that already have CFMX, I'm very confident that if sections of the query language had been limited or smurfed as part of the oem agreement, then Verity would have clearly stated this in big bold letters ;). I think you can safely read into this that the fact specific functions are not working in the CFMX verity implementation (like delete and soundex), is most likely due to a mistake in packaging on Macromedia's part. Someone from MM please address this thread! However, if there is indeed language level limitations in this OEM product, Macromedia has a responsibility to its developers to make a clear statement regarding exactly what is and isn't in this release! A few of you have asked for alternatives to the technology due to your aggravation with this implementation. Here are my thoughts on the matter: 1. For a large loose text/document search project I would recommend purchasing Verity's K2 server. I would urge you NOT to judge the Verity product based upon the oem experience delivered by the Verity97 agreement with Allaire, and the K2 agreement with macromedia. Verity's K2 is an extremely powerful product, and in my opinion the best in the field, but it is priced as such. 2. Consider using some of the database free text search utilities. Microsoft and Oracle both offer free text search utilities that run on their DB engine. MS specifically has a SOUNDEX implementation in their T-SQL implementation. This solution will place a considerably heavier burden on you as the developer, but is perhaps a more cost effective solution. You will likely never match verity's implementation of thesaurus matching, and other really cool things their engine does, but you can build a half way decent data centric search. 3. Look into competing technologies. Inktome is also a good search engine tool that you can license for your App. I haven't used them in the last 18 months, but I know they used to offer a pay as you go solution. .01 cents per query, etc. For a smaller load site this could often also be a viable alternative considering the entry cost of a K2 server. Good luck, Trey Rouse Data Architect Developer Rice University -Original Message- From: Mark Leder [mailto:mel;markleder.com] Sent: Sunday, October 20, 2002 1:16 AM To: CF-Talk Subject: CFIndex for Verity quit working Hi
RE: cfmail tag and looping output
Good advice. There's also a stored procedure in SQL Server that's supposed to be pretty good for mass mailings (sp_sendmail or something like that). If you DO use CFMail (I can't talk to its performance in 5 or MX -- I had issues with it in 4.5.1), BCC each cfmail to 20 or so recipients at a time (instead of sending 1 per person). That'll take some strain off the CF mail spooler (giving more of the load to the mail server) and get things out faster. ETC -Original Message- From: Howie Hamlin [mailto:howie;coolfusion.com] Sent: Monday, October 21, 2002 1:18 PM To: CF-Talk Subject: Re: cfmail tag and looping output If you are concerned about reliability then I would suggest that you have a look at iMS-SE. iMS-SE is a high-performance mail sending engine that allows you to send email without requiring an external mail server. iMS Pro is the mail sending engine behind this email list, BTW. More information and a comparison sheet are available from our web site (the direct links are in my signature, below). -- 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: Jason Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 21, 2002 4:11 PM Subject: cfmail tag and looping output Hello List - One of my client has about 8,000 emails that have signed up for sales letters and newsletters on his site. I have been testing a simply query that pulls from 3 tables - creates an output that loops and executes the cfmail tag each time - using a ID that is primary so no duplicates are being sent.. It surprisingly doesn't take that long ( although I haven't tested on the full lot) BUT i have heard 1) Cfmail tag not being reliable 2) their must be a more efficient way to code this. So I am looking to this list to find if there is any truth to cfmail dropping results OR if there is other tags ( please hint) that I should really be looking into. Client wants me to manage this through some simple scripts - and would like to send html formated email. We are leaning away from purchasing 3rd party solutions and installing special server software is not possible. thanks! jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Long form and variable names?
Well, I don't have the original code you posted, but you are opening a TR and then your CFOUTPUT, but you close the CFOUTPUT before the TR. That shouldn't cause your problem, but it should be fixed ;-) 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 - Original Message - From: Keith Taylor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 21, 2002 10:24 AM Subject: Long form and variable names? Thank you Patti and Randell. Sometimes the most obvious things escape us. I fixed the 'submit' button and that made it work. However, I am still having the problem with passing the data and posting it. On the action page, I reference the ordered items as follows: tr cfoutput td width=106font size=1 face=Verdana, Arial, Helvetica, sans-serif#form.orderedID#/font/td td width=246font size=1 face=Verdana, Arial, Helvetica, sans-serif#form.ordereddesc#/font/td td width=107font size=1 face=Verdana, Arial, Helvetica, sans-serifstrong#form.quantity#/strong/font/td /tr/cfoutput Nothing appears on the page, though, and when I view the page source, it is showing every single product! Not just the ones for which an order was placed in the quantity field. Shouldn't it only show the ones where quantity had a value? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: cfmail tag and looping output
iMS-SE ALL_THE_WAY. We have a client that sends 20,000 + emails day via their web admin for their site (they post jobs). It is very easy to setup and configurable. We love it. Tony Gruen sfnetworks -Original Message- From: Jason Miller [mailto:millerj;etcnj.com] Sent: Monday, October 21, 2002 1:11 PM To: CF-Talk Subject: cfmail tag and looping output Hello List - One of my client has about 8,000 emails that have signed up for sales letters and newsletters on his site. I have been testing a simply query that pulls from 3 tables - creates an output that loops and executes the cfmail tag each time - using a ID that is primary so no duplicates are being sent.. It surprisingly doesn't take that long ( although I haven't tested on the full lot) BUT i have heard 1) Cfmail tag not being reliable 2) their must be a more efficient way to code this. So I am looking to this list to find if there is any truth to cfmail dropping results OR if there is other tags ( please hint) that I should really be looking into. Client wants me to manage this through some simple scripts - and would like to send html formated email. We are leaning away from purchasing 3rd party solutions and installing special server software is not possible. thanks! jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Relationship posts
Lol.. Wow! Uhm.. I refuse to speak on the grounds that it may incriminate me. ;) | -Original Message- | From: Matt Robertson [mailto:matt;mysecretbase.com] | Sent: Monday, October 21, 2002 10:20 AM | To: CF-Talk | Subject: RE: Relationship posts | | | If prefixing threads is such a bright idea, try mixing all of | your mailing lists into one folder and see how easy it is to | follow. There is a point where things get inconvenient. | We're there. | | It takes about 30 seconds to create a folder in | Outlook/Outlook Express, and maybe another minute to write a | rule sending matching mail to that | folder. | | C'mon... You guys all know this. Its not like y'all are | sheep herders who just learned to spell email, let alone | manage it. Create freaking folders and browse them. | | --Matt Robertson-- | MSB Designs, Inc. | http://mysecretbase.com | | | | -Original Message- | From: Michael Dinowitz [mailto:mdinowit;houseoffusion.com] | Sent: Sunday, October 20, 2002 3:17 PM | To: CF-Talk | Subject: Relationship posts | | | In the last few weeks the CF-Talk list has been inundated | with off topic posts about the relationship between the | ColdFusion community and Macromedia. These discussions are | important and should continue as a healthy debate, but they | are NOT technical in nature. In order to try and keep the | CF-Talk list to technical questions about ColdFusion, I'd | like to suggest that those who want to discuss Macromedia and | their practices subscribe to the CF-Partners list. If that | list does not sound like the proper list, please email me | personally with a new name for the list and I'll take it into | consideration. Thank you for helping keep this technical list | valuable to the community at large. Only you can help the | growth of ColdFusion knowledge, only you | | Michael Dinowitz | Master of the House of Fusion | http://www.houseoffusion.com | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Long form and variable names?
You are getting a lot of data output... scroll down Should look like: 0010,0037,0046,0051,0310A,0357,0357A,0358,0358A,0359,0359A,0365,0404,0434,0471,0479,0502,0503,0508,0512,0531,0535,0555,0557,0565,0589,0606,0619,0621,0640,0247,0256,0428,0432,0450,0462,0474,0491,0504,0509,0521,0523,0539,0546,0564,0579,0585,0596,0599,0600,0605,0616,0622,0307,0313,0470,0472,0581,0252,0441,0442,0468,0516,0522,0588,0591,0613,0018,0040,0086,0188,0189,0191,0192,0352,0353,0366,0367,0384,0386,0387F,0387AF,0398,0399,0405,0405A,0408,0409,0438,0439,0449,0497,0499,0500,0506,0507,0518,0532,0533,0551,0558,0559,0562,0567,0568,0569,0572,0573,0574,0575,0584,0586L,0587L,0608,0609,0612,0614,0615,0620,0149,0382,0431,0463,0505,0528,0570,0592,0610,0617,0623,0492,0498,0560/font/td td width=246font size=1 face=Verdana, Arial, Helvetica, sans-serifTHREE DRAWER WALNUT TABLE,PAINTED REGENCY WINE TABLE,GENTLEMAN'S GUN BOX,COACHING BOX,FEDERAL DINING TABLE, 2 TABLES,FLUTED LEG DINING TABLE, ROUND,FLUTED LEG DINING TABLE, RECT.,TAPERED LEG DINING TABLE, RD.,TAPERED LEG DINING TABLE, RECT,TURNED LEG DINING TABLE, ROUND,TURNED LEG DINING TABLE, RECT.,MARBLE TOP TABLE,TUDOR TABLE,CARVED TABLE,COUNTRY OVAL TABLE,BREAD-BOARD FARM TABLE,LATTICED APRON TABLE,JAPANNED LIBRARY TABLE,TAVERN TABLE,DRUM TABLE,THREE-PART PEDESTAL DINING TABLE,PAINTED PEMBROKE TABLE,COTTON REEL TABLE,TRI-LEG TABLE,MANOR HOUSE WORK TABLE,LYRE-LEG TABLE,APOTHECARY TABLE,REFECTORY TABLE,FEDERAL PEDESTAL TABLE,PROVINCIAL DROP-LEAF TABLE,SERPENTINE CORNER CUPBOARD,SERPENTINE SIDEBOARD,BAILEY CHEST/SECRETAIRE,PINE SIDE BOARD,STEPPED BOOKCASE,ITALIAN CREDENZA,COLUMN BOOKCASE,PINE SERVER,GEORGE III WRITING CABINET,ARCHED DOORS SECRETARY,SECRETAIRE/BOOKCASE,MAPLE SIDEBOARD,BRASS GRILL CABINET,REGENCY DESK BOOKSHELF,HANGING CABINET,FEDERAL BOOKCASE,BANNER TOP SECRETAIRE,BROKEN PEDIMENT BOOKCASE,BREAKFRONT BOOKCASE ,CHATHAM MANOR CORNER CUPBOARD,QUEEN ANNE DOME-TOP CORNER CUPBOARD,CARLTON HOUSE DESK,JAPANNED NIGHT TABLE,BRACKET CLOCK BRACKET,FRET-TOP CLOCK,CHIPPENDALE GRANDMOTHER CLOCK,COLUMN CLOCK,LIBRARY CLOCK,COLUMN CHEST,YEW OYSTER BURL CHEST,OLIVE OYSTER BURL CHEST,WILLIAM MARY PANELED CHEST,MAHOGANY BOWFRONT CHEST,PAINTED FRENCH CHEST,REVERSE SERPENTINE CHEST,SWELLFRONT CHEST,VENETIAN ROCOCO COMMODE,BOOT STOOL,QUEEN ANNE BENCH,PADDOCK HOUSE BENCH,QUEEN ANNE SIDE CHAIR,QUEEN ANNE ARMCHAIR,CHIPPENDALE ARM CHAIR,CHIPPENDALE SIDE CHAIR,HEPPLEWHITE ARM CHAIR,HEPPLEWHITE SIDE CHAIR,ARROW BACK ARM CHAIR,ARROW BACK SIDE CHAIR,CANED LIBRARY CHAIR,YACHT CLUB CHAIR, LEATHER,TRUMPET-LEG CHAIR, FABRIC,OTTOMAN, FABRIC,FIRESIDE BENCH, LEATHER,RIBBED RAIL BENCH, FABRIC,COUNTRY FRENCH ARMCHAIR,COUNTRY FRENCH SIDE CHAIR,COUNTRY MANOR ARM CHAIR,COUNTRY MANOR SIDE CHAIR,REGENCY BAMBOO SETTEE DIMUITIVE,REGENCY BAMBOO SETTEE,CHINESE CHIPPENDALE ARMCHAIR,QUEEN ANNE WING CHAIR, LEATHER,LADDER BACK ARM CHAIR,LADDER BACK SIDE CHAIR,FEATHER BACK ARM CHAIR,FEATHER BACK SIDE CHAIR,COTTAGE SETTEE,KNOBBED ARM CHAIR,KNOBBED SIDE CHAIR,BRIGHTON SETTEE,GILLOWS ARM CHAIR,GILLOWS SIDE CHAIR,RIVIERA CHAIR,CHARLOTTE'S BENCH,CHESTERFIELD CLUB CHAIR,SPINDE-BACK CHAIR,DALMAHOY BENCH,UMBERLAND ARM CHAIR,XING ARM CHAIR,XING SIDE CHAIR,CYPRESS HALL SETTEE,HEPPLEWHITE ARM CHAIR, LEATHER,HEPPLEWHITE SIDE CHAIR, LEATHER,PROVINCIAL ARM CHAIR,PROVINCIAL SIDE CHAIR,BARREL-BACK CHAIR,MUSICIAN'S BENCH,COTTAGE ARM CHAIR,CHARLES I SIDE CHAIR,QUEEN ANNE CHINOISEIRIE MIRROR,CARVED BRACKET,PINE MIRROR,PEDESTAL CUPBOARD,FAUX BAMBOO MIRROR,PANELED MIRROR,JAPANNED SHELF,CHINOISERIE DRESSING MIRROR,UMBRELLA STAND WITH CASTORS,FLORAL PAINTED ARM CHAIR,LEATHER TRUNK ON STAND,FOUR POSTER BED,GEORGIAN BED, QUEEN,CANE-PANELLED BED, QUEEN/font/td [EMAIL PROTECTED] 10/21/02 01:24PM Thank you Patti and Randell. Sometimes the most obvious things escape us. I fixed the 'submit' button and that made it work. However, I am still having the problem with passing the data and posting it. On the action page, I reference the ordered items as follows: tr cfoutput td width=106font size=1 face=Verdana, Arial, Helvetica, sans-serif#form.orderedID#/font/td td width=246font size=1 face=Verdana, Arial, Helvetica, sans-serif#form.ordereddesc#/font/td td width=107font size=1 face=Verdana, Arial, Helvetica, sans-serifstrong#form.quantity#/strong/font/td /tr/cfoutput Nothing appears on the page, though, and when I view the page source, it is showing every single product! Not just the ones for which an order was placed in the quantity field. Shouldn't it only show the ones where quantity had a value? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
ArcIMS
oi Critter! Mind if I ask you a few questions about ArcIMS? Recently, I inherited a CF / ArcIMS project from a contractor who has since left. He produced no documentation around the system and took the ArcIMS product documentation with him, now I am struggling with a few tasks which should be simple. Essentially, I have some geocoded data which needs to appear on our system and cannot find where the information needs to be loaded into. I have a feeling there is some sort of ArcIMS administrator, or that there is a command line interface that will give me the information on where the database is handling the geocoded information. I have yet to find it... not having any documentation around ArcIMS is really holding me back on this. Do you happen to know 1) how to find the specific db ArcIMS is using or 2) where I can find some resources on how to do this? We've just hit crisis mode here (a regional director in Arizona is becoming irate and has contacted the offices of a US Senator where our product is used) and need a fast solution. Any help would be appreciated. Yours, Michael Haggerty ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: MX + ArcIMS
Hugo; Have time to answer a simple ArcIMS question? I recently 'inherited' an ArcIMS project from a contractor who has since accepted another job. He left with all the product documentation for ArcIMS and left no documentation for the project I am now in charge of. I am attempting to load some geocoded data into the ArcIMS system and having a tough time even finding where to load it! Is there some sort of an administrator which can give me this information? I ran the CF_ARCIMS tag with the action set to GetServiceInfo, which displayed the server location where ArcIMS is installed. Does ARCIMS use it's own database? Thanks in advance for any help you may choose to give. M -Original Message- From: Hugo Ahlenius [mailto:Ahlenius;grida.no] Sent: Wednesday, October 16, 2002 9:43 AM To: CF-Talk Subject: RE: MX + ArcIMS It depends on the release-date of ArcIMS 4.01, which ESRI claims should have MX support. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: cfmail tag and looping output
I have checked that site quite a bit - Problem is - I am not a network or server administrator - don't plan on it nor wish to be one. The solution is on our own server - but is co-located - I am always nervous installing products that I feel may effect the server. IF i need support of the host company - point blank a bad implmeentation or poor decision from me results in a $ loss. Very well can't charge my client for support on my own error :) I am the only one who administers the site, upgrades the server, the graphics, commerce back end - daily updates and all the cf code - so -therein lies hesitation installing and dealing with another product. Anyhow - I will be looking into iMS-SE since it's not the first time it's name popped up. Some great ideas on this. Glad to receive so many replies. thanks jay SFN Development wrote: iMS-SE ALL_THE_WAY. We have a client that sends 20,000 + emails day via their web admin for their site (they post jobs). It is very easy to setup and configurable. We love it. Tony Gruen sfnetworks -Original Message- From: Jason Miller [mailto:millerj;etcnj.com] Sent: Monday, October 21, 2002 1:11 PM To: CF-Talk Subject: cfmail tag and looping output Hello List - One of my client has about 8,000 emails that have signed up for sales letters and newsletters on his site. I have been testing a simply query that pulls from 3 tables - creates an output that loops and executes the cfmail tag each time - using a ID that is primary so no duplicates are being sent.. It surprisingly doesn't take that long ( although I haven't tested on the full lot) BUT i have heard 1) Cfmail tag not being reliable 2) their must be a more efficient way to code this. So I am looking to this list to find if there is any truth to cfmail dropping results OR if there is other tags ( please hint) that I should really be looking into. Client wants me to manage this through some simple scripts - and would like to send html formated email. We are leaning away from purchasing 3rd party solutions and installing special server software is not possible. thanks! jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: cfmail tag and looping output
Thanks - beleive it or not though this client is still on access 2000 database - with 40,000 unique hits a week. Hope to update to SQL within a few months - just need to get some of these emails out - Great idea on the BCC - I am not overly concerned with reliability becuase it is some initial mass mailings- once we cut through all the garabage mails - it would be nice that people expecting and depending on mail get it timely. Will look at 3rd party= but hesitant to go any perl (because I don't have much experience toying with perl) route which it seems most of there are in. thanks for the advice. jay miller Carlisle, Eric wrote: Good advice. There's also a stored procedure in SQL Server that's supposed to be pretty good for mass mailings (sp_sendmail or something like that). If you DO use CFMail (I can't talk to its performance in 5 or MX -- I had issues with it in 4.5.1), BCC each cfmail to 20 or so recipients at a time (instead of sending 1 per person). That'll take some strain off the CF mail spooler (giving more of the load to the mail server) and get things out faster. ETC -Original Message- From: Howie Hamlin [ mailto:howie;coolfusion.com mailto:howie;coolfusion.com ] Sent: Monday, October 21, 2002 1:18 PM To: CF-Talk Subject: Re: cfmail tag and looping output If you are concerned about reliability then I would suggest that you have a look at iMS-SE. iMS-SE is a high-performance mail sending engine that allows you to send email without requiring an external mail server. iMS Pro is the mail sending engine behind this email list, BTW. More information and a comparison sheet are available from our web site (the direct links are in my signature, below). -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com http://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 http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Jason Miller mailto:millerj;etcnj.com [EMAIL PROTECTED] To: CF-Talk mailto:cf-talk;houseoffusion.com [EMAIL PROTECTED] Sent: Monday, October 21, 2002 4:11 PM Subject: cfmail tag and looping output Hello List - One of my client has about 8,000 emails that have signed up for sales letters and newsletters on his site. I have been testing a simply query that pulls from 3 tables - creates an output that loops and executes the cfmail tag each time - using a ID that is primary so no duplicates are being sent.. It surprisingly doesn't take that long ( although I haven't tested on the full lot) BUT i have heard 1) Cfmail tag not being reliable 2) their must be a more efficient way to code this. So I am looking to this list to find if there is any truth to cfmail dropping results OR if there is other tags ( please hint) that I should really be looking into. Client wants me to manage this through some simple scripts - and would like to send html formated email. We are leaning away from purchasing 3rd party solutions and installing special server software is not possible. thanks! jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
CFX_SPELL Question/Problem
Hi All, We are having a problem I hope the list can help with. In a Nutshell, We purchased Forta's CFX_Spell tag and wrote a UI for it. Tested it with no problem. Then we moved it to our Production machine which is running CF 4.01 on Windows NT 4. (Before you say upgrade to CF5 or MX, Let me just state that this box houses a business critical app that runs fine under cf4.01 and we have not wanted to upgrade just yet.) When we moved it to Production and the user's started hitting the dll, the tag stopped working. After doing some better research I learned the CFX tag was not multi-thread safe and it was suggested to add cflock around the tag to force it to be single threaded. Did that and added cftrycfcatch logic around the cfx tag. I have included the logic below. Anyway, The additional logic caused something strange to happen. The Server Seemed to loose all session/Application variables and Would not allow access to any CFM pages only .html pages. We immediately shut off access to the dll and all code touching it. I sent numerous emails to forta, but have not gotten a response. Has anyone else experienced these problems? any resolutions/ suggestions on how to get this to work? Any help would be greatly appreciated. Here is the code used: cftry cflock name=spellock timeout=20 throwontimeout=Yes CFX_SPELL TEXT=#Form.CommentBox# name=spell LANGUAGE=#language# /cflock cfcatch type=ALL cflocation url=Update_review.cfm addtoken=NO /cfcatch /cftry ~Rich Rich Sloan Coldfusion Web Developer Follett Corporation-CTG 2233 West St. -River Grove, IL 60171 P 708.437.2360 E [EMAIL PROTECTED] www.follett.com
RE: CFX_SPELL Question/Problem
If you remove the logic (CFTRY/CFLOCK) .. everything goes back to normal? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Sloan, Richard [mailto:RSloan;follett.com] Sent: Monday, October 21, 2002 1:56 PM To: CF-Talk Subject: CFX_SPELL Question/Problem Hi All, We are having a problem I hope the list can help with. In a Nutshell, We purchased Forta's CFX_Spell tag and wrote a UI for it. Tested it with no problem. Then we moved it to our Production machine which is running CF 4.01 on Windows NT 4. (Before you say upgrade to CF5 or MX, Let me just state that this box houses a business critical app that runs fine under cf4.01 and we have not wanted to upgrade just yet.) When we moved it to Production and the user's started hitting the dll, the tag stopped working. After doing some better research I learned the CFX tag was not multi-thread safe and it was suggested to add cflock around the tag to force it to be single threaded. Did that and added cftrycfcatch logic around the cfx tag. I have included the logic below. Anyway, The additional logic caused something strange to happen. The Server Seemed to loose all session/Application variables and Would not allow access to any CFM pages only .html pages. We immediately shut off access to the dll and all code touching it. I sent numerous emails to forta, but have not gotten a response. Has anyone else experienced these problems? any resolutions/ suggestions on how to get this to work? Any help would be greatly appreciated. Here is the code used: cftry cflock name=spellock timeout=20 throwontimeout=Yes CFX_SPELL TEXT=#Form.CommentBox# name=spell LANGUAGE=#language# /cflock cfcatch type=ALL cflocation url=Update_review.cfm addtoken=NO /cfcatch /cftry ~Rich Rich Sloan Coldfusion Web Developer Follett Corporation-CTG 2233 West St. -River Grove, IL 60171 P 708.437.2360 E [EMAIL PROTECTED] www.follett.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Long form and variable names?
OK. I see now. Am indeed getting a LOT of output. This is showing every product by number, then every description. What I want/intend to have show is only those product numbers and descriptions that correspond with an order being made. That is, on the order form, (which appears in rows), the visitor enters a number next to a product, and that is what is passed (along with any other products ordered) to the results page. Instead, I'm getting them all. I know what I am doing wrong but don't know what to do to be right...what is wrong is that each row has a field 'ItemID', 'Description', and 'quantity' (this is the text box). These appear on the order form and the data is dynamically displayed. I know that the problem is that each product doesn't have a unique field name. But not sure how to display all these on the order page then assign each an individual id that would be passed to the results. Does that make sense? What I mean, is that I need to display all the products on the order form, but do I/how do I only pass along those which have an order placed in the text box? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Long form and variable names?
What I would do is when you display the items on the page awaiting input value for ordering, use: input name=quantity#ID# type=text size=8 Then on your action page Loop through your query and use: cfloop query=getitems cfif IsDefined(quantity Product_ID) IS YES cfset Order_value = #Evaluate(quantity Product_ID)# cfif order_value NEQ AND order_value GT 0 THIS IS A VALID ORDER --- OUTPUT ITEM NAME, ETC /cfif /cfif /cfloop [EMAIL PROTECTED] 10/21/02 01:58PM OK. I see now. Am indeed getting a LOT of output. This is showing every product by number, then every description. What I want/intend to have show is only those product numbers and descriptions that correspond with an order being made. That is, on the order form, (which appears in rows), the visitor enters a number next to a product, and that is what is passed (along with any other products ordered) to the results page. Instead, I'm getting them all. I know what I am doing wrong but don't know what to do to be right...what is wrong is that each row has a field 'ItemID', 'Description', and 'quantity' (this is the text box). These appear on the order form and the data is dynamically displayed. I know that the problem is that each product doesn't have a unique field name. But not sure how to display all these on the order page then assign each an individual id that would be passed to the results. Does that make sense? What I mean, is that I need to display all the products on t! he order form, but do I/how do I only pass along those which have an order placed in the text box? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CFX_SPELL Question/Problem
Rich, Please e-mail me directly off list on this one. --- Ben -Original Message- From: Adrocknaphobia Jones [mailto:adrocknatalk;hotmail.com] Sent: Monday, October 21, 2002 2:15 PM To: CF-Talk Subject: RE: CFX_SPELL Question/Problem If you remove the logic (CFTRY/CFLOCK) . everything goes back to normal? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Sloan, Richard [mailto:RSloan;follett.com] Sent: Monday, October 21, 2002 1:56 PM To: CF-Talk Subject: CFX_SPELL Question/Problem Hi All, We are having a problem I hope the list can help with. In a Nutshell, We purchased Forta's CFX_Spell tag and wrote a UI for it. Tested it with no problem. Then we moved it to our Production machine which is running CF 4.01 on Windows NT 4. (Before you say upgrade to CF5 or MX, Let me just state that this box houses a business critical app that runs fine under cf4.01 and we have not wanted to upgrade just yet.) When we moved it to Production and the user's started hitting the dll, the tag stopped working. After doing some better research I learned the CFX tag was not multi-thread safe and it was suggested to add cflock around the tag to force it to be single threaded. Did that and added cftrycfcatch logic around the cfx tag. I have included the logic below. Anyway, The additional logic caused something strange to happen. The Server Seemed to loose all session/Application variables and Would not allow access to any CFM pages only .html pages. We immediately shut off access to the dll and all code touching it. I sent numerous emails to forta, but have not gotten a response. Has anyone else experienced these problems? any resolutions/ suggestions on how to get this to work? Any help would be greatly appreciated. Here is the code used: cftry cflock name=spellock timeout=20 throwontimeout=Yes CFX_SPELL TEXT=#Form.CommentBox# name=spell LANGUAGE=#language# /cflock cfcatch type=ALL cflocation url=Update_review.cfm addtoken=NO /cfcatch /cftry ~Rich Rich Sloan Coldfusion Web Developer Follett Corporation-CTG 2233 West St. -River Grove, IL 60171 P 708.437.2360 E [EMAIL PROTECTED] www.follett.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Long form and variable names?
if you post your code then we can help you better. Clint - Original Message - From: Keith Taylor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 21, 2002 12:58 PM Subject: Long form and variable names? OK. I see now. Am indeed getting a LOT of output. This is showing every product by number, then every description. What I want/intend to have show is only those product numbers and descriptions that correspond with an order being made. That is, on the order form, (which appears in rows), the visitor enters a number next to a product, and that is what is passed (along with any other products ordered) to the results page. Instead, I'm getting them all. I know what I am doing wrong but don't know what to do to be right...what is wrong is that each row has a field 'ItemID', 'Description', and 'quantity' (this is the text box). These appear on the order form and the data is dynamically displayed. I know that the problem is that each product doesn't have a unique field name. But not sure how to display all these on the order page then assign each an individual id that would be passed to the results. Does that make sense? What I mean, is that I need to display all the products on the order form, but do I/how do I only pass along those which have an order placed in the text box? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Relationship posts
How dare you disparage sheep herders like that. Why my... actually, I don't know any sheep herders. Nevermind 8^). (Sorry, I had to) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Matt Robertson [mailto:matt;mysecretbase.com] Sent: Monday, October 21, 2002 1:20 PM To: CF-Talk Subject: RE: Relationship posts If prefixing threads is such a bright idea, try mixing all of your mailing lists into one folder and see how easy it is to follow. There is a point where things get inconvenient. We're there. It takes about 30 seconds to create a folder in Outlook/Outlook Express, and maybe another minute to write a rule sending matching mail to that folder. C'mon... You guys all know this. Its not like y'all are sheep herders who just learned to spell email, let alone manage it. Create freaking folders and browse them. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Michael Dinowitz [mailto:mdinowit;houseoffusion.com] Sent: Sunday, October 20, 2002 3:17 PM To: CF-Talk Subject: Relationship posts In the last few weeks the CF-Talk list has been inundated with off topic posts about the relationship between the ColdFusion community and Macromedia. These discussions are important and should continue as a healthy debate, but they are NOT technical in nature. In order to try and keep the CF-Talk list to technical questions about ColdFusion, I'd like to suggest that those who want to discuss Macromedia and their practices subscribe to the CF-Partners list. If that list does not sound like the proper list, please email me personally with a new name for the list and I'll take it into consideration. Thank you for helping keep this technical list valuable to the community at large. Only you can help the growth of ColdFusion knowledge, only you Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Really big file manipulation
Hey all - I have got a 76,000+ line data file (ZipUSA comma delim file) that I need to break into smaller tables in my DB. This needs to happen at least monthly, so I wrote a cfm template to automate the process. The problem I am having is speed and server load. I have tried using the following methods, and am wondering if anybody has any suggestions (apart from using SQL's DTS) Platform info: CF 5 on Win2k, IIS 5 writing to MSSQL 2000 The tables I am putting everything into are a state table, county table w/state reference, city table w/county reference, location/district table w/city reference and zip table w/district reference 1) Create temp SQL table, loop over file, write to temp table, query temp table, loop over query, and using conditional logic - break into table structure defined above, and drop temp table. This is the shortest method taking 20 minutes or so. The problem is that my SQL service's memory usage spirals out of control and when the template is finished, it never returns to normal. I have to restart the service to right it. 2) Same as above, but converts the data file into a CF function-made query and then do a query of query. (This is necessary to re-order data for break-down step) This one takes forever (an hour on the slowest run) and both the CF services and the SQL service take over the machine. 3) Read the data file, write a new one, then read that data file and loop over the lines, breaking it into the table structure above. This one also takes forever. Any suggestions at all on how to streamline the process would be really helpful, Thanks in advance Bill Henderson [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Really big file manipulation
I at one time had a 500,000 byte file to import 5 days a week. But that had to go to one table. Sorry my recommendations is on MSSQL DTS. [EMAIL PROTECTED] 10/21/02 02:23PM Hey all - I have got a 76,000+ line data file (ZipUSA comma delim file) that I need to break into smaller tables in my DB. This needs to happen at least monthly, so I wrote a cfm template to automate the process. The problem I am having is speed and server load. I have tried using the following methods, and am wondering if anybody has any suggestions (apart from using SQL's DTS) Platform info: CF 5 on Win2k, IIS 5 writing to MSSQL 2000 The tables I am putting everything into are a state table, county table w/state reference, city table w/county reference, location/district table w/city reference and zip table w/district reference 1) Create temp SQL table, loop over file, write to temp table, query temp table, loop over query, and using conditional logic - break into table structure defined above, and drop temp table. This is the shortest method taking 20 minutes or so. The problem is that my SQL service's memory usage spirals out of control and when the template is finished, it never returns to normal. I have to restart the service to right it. 2) Same as above, but converts the data file into a CF function-made query and then do a query of query. (This is necessary to re-order data for break-down step) This one takes forever (an hour on the slowest run) and both the CF services and the SQL service take over the machine. 3) Read the data file, write a new one, then read that data file and loop over the lines, breaking it into the table structure above. This one also takes forever. Any suggestions at all on how to streamline the process would be really helpful, Thanks in advance Bill Henderson [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
SoEditor and RegEx help
Hello, I'm using the SoEditor wyiwyg Editor and I need some help with a regular expression. The Soeditor when it is initially loaded prepopulates the text area with some basic html. Head and body tags etc. The problem I'm having with this is that if a user does not enter anything, it still looks like there is content in the textarea. I would like to be able to say cfif not (len(trim(form.textarea)) You did not enter anything!/cfif, but there will always be this default HTML in the textarea. So my question is how do I ues Regular expressions (which I know next to nothing about) to strip out the default content and check for user entered content only. I'm sure that other SoEditor users would find this useful, or maybe one of you have already done this? Here is the default code: HTML HEAD META NAME=GENERATOR Content=Microsoft DHTML Editing Control TITLE/TITLE /HEAD BODY style=FONT-FAMILY: DIVnbsp;/DIV /BODY /HTML Thanks for the help. I really need to learn regEx, can any one recommend a good book or online tutorial? -Brook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: MX + ArcIMS
I am attempting to load some geocoded data into the ArcIMS system and having a tough time even finding where to load it! you create a mapservice with the authoring tool (arcExplorer more or less). if you go to the arcIMS server, you should be able to get at these under the start menu, arcIMS. also esri's support.esri.com site is fairly good with info. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 16/10/2545 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Long form and variable names?
I was going to say pretty much the same thing but isn't there away to do this without using Evaluate()? Also, you've got some extraneous # signs: cfset Order_value = #Evaluate(quantity Product_ID)# should be: cfset Order_value = Evaluate(quantity Product_ID) -Original Message- From: Randell B Adkins [mailto:AdkinsR;GAO.GOV] Sent: Monday, October 21, 2002 2:15 PM To: CF-Talk Subject: Re: Long form and variable names? What I would do is when you display the items on the page awaiting input value for ordering, use: input name=quantity#ID# type=text size=8 Then on your action page Loop through your query and use: cfloop query=getitems cfif IsDefined(quantity Product_ID) IS YES cfset Order_value = #Evaluate(quantity Product_ID)# cfif order_value NEQ AND order_value GT 0 THIS IS A VALID ORDER --- OUTPUT ITEM NAME, ETC /cfif /cfif /cfloop [EMAIL PROTECTED] 10/21/02 01:58PM OK. I see now. Am indeed getting a LOT of output. This is showing every product by number, then every description. What I want/intend to have show is only those product numbers and descriptions that correspond with an order being made. That is, on the order form, (which appears in rows), the visitor enters a number next to a product, and that is what is passed (along with any other products ordered) to the results page. Instead, I'm getting them all. I know what I am doing wrong but don't know what to do to be right...what is wrong is that each row has a field 'ItemID', 'Description', and 'quantity' (this is the text box). These appear on the order form and the data is dynamically displayed. I know that the problem is that each product doesn't have a unique field name. But not sure how to display all these on the order page then assign each an individual id that would be passed to the results. Does that make sense? What I mean, is that I need to display all the products on t! he order form, but do I/how do I only pass along those which have an order placed in the text box? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: generating an excel spreadsheet from CF
Check these out: http://devex.macromedia.com/developer/gallery/SearchResults.cfm?keywords =Excelx=2y=15 Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Kola Oyedeji [mailto:kola;alexandermark.com] Sent: Monday, October 21, 2002 3:32 PM To: CF-Talk Subject: generating an excel spreadsheet from CF Hi I am trying to determine the best way to create an excel spreadsheet. Currently we have either written a comma delimited file or created an html table and used cfcontent to give it a mimetype which excel recognises. The problem is that spreadsheets generated this way tend to be quite large. Unfourtently we have a client who despite our advice would like to be able to generate an excel spreadsheet with around 11k rows. Are there any other ways? I've had a look at cfcomet and it appears you can use ADO on the server to generate a spreadsheet however it would appear that this requires excel on the server which our sysadmin people refuse to do for security reasons. Is there a better way? DO i actually need excel on the server to use ADO? Thanks Kola ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
db issue
Hello all I'm hoping someone else out there is familiar with the program FormFlow. Govt/Mil use the program to fill in forms. Formflow uses a database to hold the user information for the forms, DBase (options are Dbase, Dbase III+ and Dbase IV). We are trying to create a web application that will write to formflow's db. would seem simple. But when I go into CF administrator and try to create a mapping , CF does not seem to want to connect. (using CF 5). With some experimenting I found that I could create an Access db and do a link table to formflow's db and this mapping works. Using this round about method we can write to the formflow db, but we don't seem to be able to delete from it. We can go into the access db and open the linked table and see all the records, we can delete them in access but when formflows db is opened in formflow the records are still there and when the file is looked at in explorer the file size does not change. We can work with the link through Access if only we could figure out how to delete records through it. But would prefer to be able to write right to the Dbase tables. Has anyone else tried working with a dbase database without having dbase loaded? Thanks for any help Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: counting # of characters in file
Paul Hastings wrote: I did now test it and it works. Just cast the filename to the type string, and all is well :) (using JavaCast) surprised that javacast worked, never worked for me with numeric data. was it the string or inline use? Not using JavaCast kills it, using Javacast it works. The string is passed as variable to javacast. Same worked with Long values (from double - long). Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: SoEditor and RegEx help
Thanks for your quick replies quys, all code answers, I'll give them each a try and see whats best. I am aware that you can simply exclude the pageedit tag within the SoEditor, but then it also strips out any user added header and html info, which doesn't work so well. Brook At 03:06 PM 21/10/02 -0400, you wrote: Not a direct answer to your question, but... Did you know you can turn off the automatic insertion of that HTML gobblygook? PageEditSets whether the html being edited includes the HTML, HEAD, and BODY elements. Set this attribute to true if you are editing an entire HTML document, or set this to false if you are only editing a section or HTML. Defaults to false. Then you can actually test for an empty string. Jerry Johnson [EMAIL PROTECTED] 10/21/02 02:48PM Hello, I'm using the SoEditor wyiwyg Editor and I need some help with a regular expression. The Soeditor when it is initially loaded prepopulates the text area with some basic html. Head and body tags etc. The problem I'm having with this is that if a user does not enter anything, it still looks like there is content in the textarea. I would like to be able to say cfif not (len(trim(form.textarea)) You did not enter anything!/cfif, but there will always be this default HTML in the textarea. So my question is how do I ues Regular expressions (which I know next to nothing about) to strip out the default content and check for user entered content only. I'm sure that other SoEditor users would find this useful, or maybe one of you have already done this? Here is the default code: Thanks for the help. I really need to learn regEx, can any one recommend a good book or online tutorial? -Brook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: SoEditor and RegEx help
I don't think you need a regex for this. Just populate a variable with the default text and do a replace() on the incoming text before you test it for length. Something like: crap = default crap from SoEditor; content = replace(content, crap, ''); This way, if the default crap is submitted, it gets removed. Of course, if they only add to the beginning or end, you might run into trouble. You can either deal with this by checking the length against the length of the default content (what I'd do) or you can write an RE to do the replace (which seems like overkill and is easier to goof up). As far as good books go, Mastering Regular Expressions from O'Reilly is pretty good, though not CF specific. Of course, if you are using CFMX (almost?) everything that works in Perl will work. If you are using CF5, between Advanced CF5 Programming and Mastering RE's, you ought to be able to figure most things out. cfx_evangelism really_cool_thing=CF-RegEx And, if you need advice or have more in-depth questions, you can always go to: http://www.houseoffusion.com/cf_lists/index.cfm?method=threadsforumid=21 to read, post, or subscribe to the HoF CF-RegEx list. So far, on the CF-Regex list, we've had discussions on the differences between CF5 and MX REs, workarounds for limitations to the CF5 RE engine, a posting on what looks like a very nice UDF for stripping HTMl/CFML/XML/*ML tags (or not stripping them) via REs, and several questions asked and answered. /cfx_evangelism --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Brook Davies [mailto:brook;maracasmedia.com] : Sent: Monday, October 21, 2002 2:48 PM : To: CF-Talk : Subject: SoEditor and RegEx help : : : Hello, : : I'm using the SoEditor wyiwyg Editor and I need some help with a regular : expression. The Soeditor when it is initially loaded prepopulates : the text : area with some basic html. Head and body tags etc. : : The problem I'm having with this is that if a user does not enter : anything, : it still looks like there is content in the textarea. I would like to be : able to say cfif not (len(trim(form.textarea)) You did not enter : anything!/cfif, but there will always be this default HTML in the : textarea. So my question is how do I ues Regular expressions : (which I know : next to nothing about) to strip out the default content and check : for user : entered content only. I'm sure that other SoEditor users would find this : useful, or maybe one of you have already done this? : : Here is the default code: : : HTML : HEAD : META NAME=GENERATOR Content=Microsoft DHTML Editing Control : TITLE/TITLE : /HEAD : BODY style=FONT-FAMILY: : DIVnbsp;/DIV : /BODY : /HTML : : Thanks for the help. I really need to learn regEx, can any one : recommend a : good book or online tutorial? : : -Brook : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: SoEditor and RegEx help
Okay, the HTMl code got cut out. How can you paste HTML code to this list? I'm trying again with the below: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: SoEditor and RegEx help
Try the soEditor PageEdit attribute. See http://www.siteobjects.com/siteobjects/soeditor/lite/docs/index.cfm?method=i nvocation Matthew Walker http://www.matthewwalker.net.nz/ - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 7:48 AM Subject: SoEditor and RegEx help Hello, I'm using the SoEditor wyiwyg Editor and I need some help with a regular expression. The Soeditor when it is initially loaded prepopulates the text area with some basic html. Head and body tags etc. The problem I'm having with this is that if a user does not enter anything, it still looks like there is content in the textarea. I would like to be able to say cfif not (len(trim(form.textarea)) You did not enter anything!/cfif, but there will always be this default HTML in the textarea. So my question is how do I ues Regular expressions (which I know next to nothing about) to strip out the default content and check for user entered content only. I'm sure that other SoEditor users would find this useful, or maybe one of you have already done this? Here is the default code: HTML HEAD META NAME=GENERATOR Content=Microsoft DHTML Editing Control TITLE/TITLE /HEAD BODY style=FONT-FAMILY: DIVnbsp;/DIV /BODY /HTML Thanks for the help. I really need to learn regEx, can any one recommend a good book or online tutorial? -Brook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Really big file manipulation
Thanks for the tip on text drivers, I always forget to try that. Now to take this thread OT: The problem I have with DTS is that I am unfamiliar with how to do advanced data manipulation. In this case, I have to take every row of the text file, make a new county entry, take the identity for the city table, make a new entry for the city table with the county identity as a foreign key, and so on down the levels until I get to the zip table. And, of course, avoid multiple entries in the county, city and location tables. To make matters worse, I need the full state names in the state table, and the csv only has short state names. So, I have to start with an existing table that I made with stateID, name and short name for the states and reference this when inputting the counties. All this without any knowledge of how to set up advanced stuff in DTS. If you have a couple of key words for me to search for when looking up help in DTS, based on what I need to do, that would a big help. Or, is there a site somewhere with DTS packages for download similar to the MM developer's exchange? Bill Henderson [EMAIL PROTECTED] -Original Message- From: jon hall [mailto:jonhall;ozline.net] Sent: Monday, October 21, 2002 12:03 PM To: CF-Talk Subject: Re: Really big file manipulation Well DTS, possibly using cursors if you need to manipulate the data in some way would be the best way imho, but other than that, using an ODBC Text DSN would be a decent way to handle the job with just CF. Set up an ODBC Text datasource for your csv file. Then select all records out of the file into a query (it's blazingly fast), and use CF's query of queries to manipulate the data, then insert...or write out new files that map directly to the tables and use dts to run the import... Honestly though...using DTS is really the best way. If nothing is being done other than inserting data into the right places and maybe some string manipulation, SQL Server provides all the necessary tools to do this very fast. -- jon mailto:jonhall;ozline.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Long form and variable names?
There might be away around the Evaluate function but I have used the same setup on other items and seems to work just fine. [EMAIL PROTECTED] 10/21/02 02:27PM I was going to say pretty much the same thing but isn't there away to do this without using Evaluate()? Also, you've got some extraneous # signs: cfset Order_value = #Evaluate(quantity Product_ID)# should be: cfset Order_value = Evaluate(quantity Product_ID) -Original Message- From: Randell B Adkins [mailto:AdkinsR;GAO.GOV] Sent: Monday, October 21, 2002 2:15 PM To: CF-Talk Subject: Re: Long form and variable names? What I would do is when you display the items on the page awaiting input value for ordering, use: input name=quantity#ID# type=text size=8 Then on your action page Loop through your query and use: cfloop query=getitems cfif IsDefined(quantity Product_ID) IS YES cfset Order_value = #Evaluate(quantity Product_ID)# cfif order_value NEQ AND order_value GT 0 THIS IS A VALID ORDER --- OUTPUT ITEM NAME, ETC /cfif /cfif /cfloop [EMAIL PROTECTED] 10/21/02 01:58PM OK. I see now. Am indeed getting a LOT of output. This is showing every product by number, then every description. What I want/intend to have show is only those product numbers and descriptions that correspond with an order being made. That is, on the order form, (which appears in rows), the visitor enters a number next to a product, and that is what is passed (along with any other products ordered) to the results page. Instead, I'm getting them all. I know what I am doing wrong but don't know what to do to be right...what is wrong is that each row has a field 'ItemID', 'Description', and 'quantity' (this is the text box). These appear on the order form and the data is dynamically displayed. I know that the problem is that each product doesn't have a unique field name. But not sure how to display all these on the order page then assign each an individual id that would be passed to the results. Does that make sense? What I mean, is that I need to display all the products on t! he order form, but do I/how do I only pass along those which have an order placed in the text box? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: SoEditor and RegEx help
I could see the HTML in your message Matthew Walker http://www.matthewwalker.net.nz/ - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 7:54 AM Subject: Re: SoEditor and RegEx help Okay, the HTMl code got cut out. How can you paste HTML code to this list? I'm trying again with the below: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: SoEditor and RegEx help
Not a direct answer to your question, but... Did you know you can turn off the automatic insertion of that HTML gobblygook? PageEditSets whether the html being edited includes the HTML, HEAD, and BODY elements. Set this attribute to true if you are editing an entire HTML document, or set this to false if you are only editing a section or HTML. Defaults to false. Then you can actually test for an empty string. Jerry Johnson [EMAIL PROTECTED] 10/21/02 02:48PM Hello, I'm using the SoEditor wyiwyg Editor and I need some help with a regular expression. The Soeditor when it is initially loaded prepopulates the text area with some basic html. Head and body tags etc. The problem I'm having with this is that if a user does not enter anything, it still looks like there is content in the textarea. I would like to be able to say cfif not (len(trim(form.textarea)) You did not enter anything!/cfif, but there will always be this default HTML in the textarea. So my question is how do I ues Regular expressions (which I know next to nothing about) to strip out the default content and check for user entered content only. I'm sure that other SoEditor users would find this useful, or maybe one of you have already done this? Here is the default code: HTML HEAD META NAME=GENERATOR Content=Microsoft DHTML Editing Control TITLE/TITLE /HEAD BODY style=FONT-FAMILY: DIVnbsp;/DIV /BODY /HTML Thanks for the help. I really need to learn regEx, can any one recommend a good book or online tutorial? -Brook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Administrator Email Address
Is there a way to dynamically set the admin email address when an error pops up. I run about 10 sites on one server and I would like to send the admin email from the default error page to different addresses based on the website it came from. TIA Robert ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Session variables not expiring in CFMX
Exactly what I needed! - Original Message - From: Chris Kief [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 18, 2002 3:54 PM Subject: RE: Session variables not expiring in CFMX Nate, You are still able to end your session in this manner. A couple points that should be mentioned: - ColdFusion deletes expired session variables every 10 seconds to save processing time. If you cfdump the session structure after CF executes your cfapplication tag (say further down on the same page), you may still see that your session exists. - It is also recommended that you reset all other attributes to the desired settings in your cfapplication tag: cfapplication name=App_Name clientmanagement=yes applicationtimeout=#CreateTimeSpan(0, 0, 0, 30)# sessionmanagement=yes sessiontimeout=#CreateTimeSpan(0, 0, 0, 0)# If you would like to immediately end your session, I would suggest using the following right before the above cfapplication tag: cflock name=myAppSessionLogout type=exclusive timeout=5 cfset StructDelete(Session, cftoken) cfset StructDelete(Session, cfid) ...etc /cflock A bit redundant, but it does the job nicely. I have used this technique with much success with both 5 MX. HTHs, chris kief -Original Message- From: Nate [mailto:npetersn;xmission.com] Sent: Friday, October 18, 2002 12:57 PM To: CF-Talk Subject: Session variables not expiring in CFMX I am tring to test an application in CFMX that works fine in CF 5. Simply trying to expire session variables by directing the user to a page upon logout that contains the following: cfapplication name=App_Name sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,0,0)# This doesen't seem to be expiring the session variables in CFMX, and my goal is to have this application compatible with CF 5 and CFMX. Am I missing something that has changed in CFMX when trying to expire session variables in this manner? Nate ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Administrator Email Address
Robert; I set an Adminemail address in my Application scope and then have the email sent to the Application.Admin address. It seems to work pretty well. I do have a cftry and cfcastch set up on each page of the site and use a custom error message. Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: Robert Forsyth [mailto:robertf;wjla.com] Sent: Monday, October 21, 2002 2:01 PM To: CF-Talk Subject: Administrator Email Address Is there a way to dynamically set the admin email address when an error pops up. I run about 10 sites on one server and I would like to send the admin email from the default error page to different addresses based on the website it came from. TIA Robert ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Administrator Email Address
I use a site-wide error handler that first does a CFSWITCH on cgi.Server_Name. Then, based on that I can customize whatever I want to about error handling behavior on a domain by domain basis. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Administrator Email Address
What about something like: cfoutputa href=mailto:webmaster;#cgi.server_name#Email Webmaster/a/cfoutput If your cgi.server_name shows up as www.wherever.com you can just lop the www. part off. Pete - Original Message - From: Robert Forsyth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 21, 2002 3:01 PM Subject: Administrator Email Address Is there a way to dynamically set the admin email address when an error pops up. I run about 10 sites on one server and I would like to send the admin email from the default error page to different addresses based on the website it came from. TIA Robert ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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.
generating an excel spreadsheet from CF
Hi I am trying to determine the best way to create an excel spreadsheet. Currently we have either written a comma delimited file or created an html table and used cfcontent to give it a mimetype which excel recognises. The problem is that spreadsheets generated this way tend to be quite large. Unfourtently we have a client who despite our advice would like to be able to generate an excel spreadsheet with around 11k rows. Are there any other ways? I've had a look at cfcomet and it appears you can use ADO on the server to generate a spreadsheet however it would appear that this requires excel on the server which our sysadmin people refuse to do for security reasons. Is there a better way? DO i actually need excel on the server to use ADO? Thanks Kola ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cfmail tag and looping output
Jay, I understand your situation. We simply installed it onto the webserver (this client has a co-lo with us). They run over 6 million hits and about 9 GB transfer per month. iMS-SE was installed about 8 months ago and the site and mail server have run flawlessly. Another aspect to consider is support. They have their own mailing list (as well as participate on this one). Join their mail list and post some questions - you may be pleased with the responses. Anyway, glad to offer my .02 Tony Gruen [EMAIL PROTECTED] -Original Message- From: Jason Miller [mailto:millerj;etcnj.com] Sent: Monday, October 21, 2002 1:55 PM To: CF-Talk Subject: Re: cfmail tag and looping output I have checked that site quite a bit - Problem is - I am not a network or server administrator - don't plan on it nor wish to be one. The solution is on our own server - but is co-located - I am always nervous installing products that I feel may effect the server. IF i need support of the host company - point blank a bad implmeentation or poor decision from me results in a $ loss. Very well can't charge my client for support on my own error :) I am the only one who administers the site, upgrades the server, the graphics, commerce back end - daily updates and all the cf code - so -therein lies hesitation installing and dealing with another product. Anyhow - I will be looking into iMS-SE since it's not the first time it's name popped up. Some great ideas on this. Glad to receive so many replies. thanks jay SFN Development wrote: iMS-SE ALL_THE_WAY. We have a client that sends 20,000 + emails day via their web admin for their site (they post jobs). It is very easy to setup and configurable. We love it. Tony Gruen sfnetworks -Original Message- From: Jason Miller [mailto:millerj;etcnj.com] Sent: Monday, October 21, 2002 1:11 PM To: CF-Talk Subject: cfmail tag and looping output Hello List - One of my client has about 8,000 emails that have signed up for sales letters and newsletters on his site. I have been testing a simply query that pulls from 3 tables - creates an output that loops and executes the cfmail tag each time - using a ID that is primary so no duplicates are being sent.. It surprisingly doesn't take that long ( although I haven't tested on the full lot) BUT i have heard 1) Cfmail tag not being reliable 2) their must be a more efficient way to code this. So I am looking to this list to find if there is any truth to cfmail dropping results OR if there is other tags ( please hint) that I should really be looking into. Client wants me to manage this through some simple scripts - and would like to send html formated email. We are leaning away from purchasing 3rd party solutions and installing special server software is not possible. thanks! jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Pro v Enterprise? (was: The Hidden CF factor was RE: How Good is the Job Market for ColdFusion?)
Belated thanks to both you and Dave. -Kevin -Original Message- From: Vernon Viehe [mailto:vviehe;macromedia.com] Sent: Friday, October 18, 2002 3:41 PM To: CF-Talk Subject: RE: Pro v Enterprise? (was: The Hidden CF factor was RE: How Good is the Job Market for ColdFusion?) Dave's right in that some of the items listed do involve other installations, so not a feature of the Dev edition. Sorry I missed that. -Vern -Original Message- From: Dave Watts [mailto:dwatts;figleaf.com] Sent: Thursday, October 17, 2002 9:51 PM To: CF-Talk Subject: RE: Pro v Enterprise? (was: The Hidden CF factor was RE: How Good is the Job Market for ColdFusion?) If the Developer version is just the Enterprise version with an IP restriction, does the Developer version support: - JSP/servlets include - JSP/servlet execution - Server Sandbox Security - Application deployment services - System monitoring - Type IV drivers for Oracle, DB2, Sybase, and Informix It supports all of those things, just like Enterprise. - Dynamic load balancing - Automatic server failover - Service-level failover - Visual cluster administration I'm not sure about these. For obvious reasons, these aren't commonly used with Developer Edition. The clustering support is provided through ClusterCATS, which is essentially a separate install with CFMX, if I recall correctly, and it's on the Enterprise CD. So, I don't know if you have those available at all with Developer Edition, since that doesn't come on a CD. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Using JSP alongside CFML
There are a couple things in the release notes you should be aware of when installing CFMX stand-alone and JRun: - If you install ColdFusion MX on a computer that has JRun 3.x or 4.0 installed and JRun is configured to connect to an external web server, choosing to configure the same external web server for ColdFusion MX will cause JSP pages and servlets to be processed through ColdFusion MX instead of through JRun. - If you have ColdFusion MX installed on the IIS, Apache, or Netscape/iPlanet web server and then install JRun 3.x or JRun 4, the ColdFusion MX configuration is lost, and you must reconfigure your web server for ColdFusion MX. HTHs, chris kief -Original Message- From: Dave Watts [mailto:dwatts;figleaf.com] Sent: Monday, October 21, 2002 1:09 PM To: CF-Talk Subject: RE: Using JSP alongside CFML Anyone have recommendations for a JSP server that runs on IIS that will not interfere with CFMX? Is JRun the best option? How about Tomcat, will it run alongside CFMX and play nicely? If you're just interested in JSP and servlets, and nothing else, and you're using Enterprise Edition, you could just run them on CFMX. You can drop JSPs anywhere in your web root; you can put servlets in the appropriate /WEB-INF subdirectory, and you can put servlets elsewhere if you're willing to edit the appropriate text file. If you want more than that, you might consider getting JRun and installing CFMX for JRun on top of it. Altogether, it's about the same price as CFMX Enterprise for a single-processor server, I think (I'm not exactly sure about pricing, though). This will get you the best integration between your CF code and your Java stuff. However, you can also run a separate J2EE server on the same machine as a stand-alone CFMX install without too much trouble. I've just played around with this a very tiny bit, but haven't run into any problems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: generating an excel spreadsheet from CF
At 08:32 PM 10/21/02 +0100, Kola Oyedeji wrote: The problem is that spreadsheets generated this way tend to be quite large. Unfourtently we have a client who despite our advice would like to be able to generate an excel spreadsheet with around 11k rows. You could create a webquery in Excel to get the data. That's what I did. T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Really big file manipulation
I wrote an article (http://www.devx.com/java/free/articles/ml040802/ml040802-1.asp) on how to use JAXP to parse a CSV file into a DOM tree. One idea is to modify the code in the article to produce a WDDX document instead of the XML document I used. With the WDDX version of the file you could quickly get it into a database although the performance would still be a bit of a problem since CF would load the whole WDDX document into memory. Another idea would be to take the code from the article and modify it slightly to insert the data into a database using JDBC instead of creating DOM nodes. Since the parsing is done using SAX the memory requirements would be pretty low and your performance likely very good. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Bill Henderson [mailto:cf-talk;uutility.com] Sent: Monday, October 21, 2002 2:23 PM To: CF-Talk Subject: Really big file manipulation Hey all - I have got a 76,000+ line data file (ZipUSA comma delim file) that I need to break into smaller tables in my DB. This needs to happen at least monthly, so I wrote a cfm template to automate the process. The problem I am having is speed and server load. I have tried using the following methods, and am wondering if anybody has any suggestions (apart from using SQL's DTS) Platform info: CF 5 on Win2k, IIS 5 writing to MSSQL 2000 The tables I am putting everything into are a state table, county table w/state reference, city table w/county reference, location/district table w/city reference and zip table w/district reference 1) Create temp SQL table, loop over file, write to temp table, query temp table, loop over query, and using conditional logic - break into table structure defined above, and drop temp table. This is the shortest method taking 20 minutes or so. The problem is that my SQL service's memory usage spirals out of control and when the template is finished, it never returns to normal. I have to restart the service to right it. 2) Same as above, but converts the data file into a CF function-made query and then do a query of query. (This is necessary to re-order data for break-down step) This one takes forever (an hour on the slowest run) and both the CF services and the SQL service take over the machine. 3) Read the data file, write a new one, then read that data file and loop over the lines, breaking it into the table structure above. This one also takes forever. Any suggestions at all on how to streamline the process would be really helpful, Thanks in advance Bill Henderson [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Really big file manipulation
Your SQL server memory is mostly likely climbing trying to keep track of rollback information. Try using a nologged bulk copy when you create and load the temp table. If possible use update select or insert select for moving the data. Commit your transaction(s) more often if possible. Use cfqueryparm for all changing values (variables) in your SQL statments. Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Randell B Adkins To: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED] cc: OV Subject: Re: Really big file manipulation 10/21/2002 01:25 PM Please respond to cf-talk I at one time had a 500,000 byte file to import 5 days a week. But that had to go to one table. Sorry my recommendations is on MSSQL DTS. [EMAIL PROTECTED] 10/21/02 02:23PM Hey all - I have got a 76,000+ line data file (ZipUSA comma delim file) that I need to break into smaller tables in my DB. This needs to happen at least monthly, so I wrote a cfm template to automate the process. The problem I am having is speed and server load. I have tried using the following methods, and am wondering if anybody has any suggestions (apart from using SQL's DTS) Platform info: CF 5 on Win2k, IIS 5 writing to MSSQL 2000 The tables I am putting everything into are a state table, county table w/state reference, city table w/county reference, location/district table w/city reference and zip table w/district reference 1) Create temp SQL table, loop over file, write to temp table, query temp table, loop over query, and using conditional logic - break into table structure defined above, and drop temp table. This is the shortest method taking 20 minutes or so. The problem is that my SQL service's memory usage spirals out of control and when the template is finished, it never returns to normal. I have to restart the service to right it. 2) Same as above, but converts the data file into a CF function-made query and then do a query of query. (This is necessary to re-order data for break-down step) This one takes forever (an hour on the slowest run) and both the CF services and the SQL service take over the machine. 3) Read the data file, write a new one, then read that data file and loop over the lines, breaking it into the table structure above. This one also takes forever. Any suggestions at all on how to streamline the process would be really helpful, Thanks in advance Bill Henderson [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Really big file manipulation
Tried these - I thought not committing was the problem at first, but there was no appreciable change. Same with the nologged bulk, this lightened the load, but not much. And I always use queryparams. Bill Henderson [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:kpeterson;sehinc.com] Sent: Monday, October 21, 2002 1:25 PM To: CF-Talk Subject: Re: Really big file manipulation Your SQL server memory is mostly likely climbing trying to keep track of rollback information. Try using a nologged bulk copy when you create and load the temp table. If possible use update select or insert select for moving the data. Commit your transaction(s) more often if possible. Use cfqueryparm for all changing values (variables) in your SQL statments. Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Randell B Adkins To: CF-Talk cf- [EMAIL PROTECTED] [EMAIL PROTECTED] cc: OV Subject: Re: Really big file manipulation 10/21/2002 01:25 PM Please respond to cf-talk I at one time had a 500,000 byte file to import 5 days a week. But that had to go to one table. Sorry my recommendations is on MSSQL DTS. [EMAIL PROTECTED] 10/21/02 02:23PM Hey all - I have got a 76,000+ line data file (ZipUSA comma delim file) that I need to break into smaller tables in my DB. This needs to happen at least monthly, so I wrote a cfm template to automate the process. The problem I am having is speed and server load. I have tried using the following methods, and am wondering if anybody has any suggestions (apart from using SQL's DTS) Platform info: CF 5 on Win2k, IIS 5 writing to MSSQL 2000 The tables I am putting everything into are a state table, county table w/state reference, city table w/county reference, location/district table w/city reference and zip table w/district reference 1) Create temp SQL table, loop over file, write to temp table, query temp table, loop over query, and using conditional logic - break into table structure defined above, and drop temp table. This is the shortest method taking 20 minutes or so. The problem is that my SQL service's memory usage spirals out of control and when the template is finished, it never returns to normal. I have to restart the service to right it. 2) Same as above, but converts the data file into a CF function-made query and then do a query of query. (This is necessary to re-order data for break-down step) This one takes forever (an hour on the slowest run) and both the CF services and the SQL service take over the machine. 3) Read the data file, write a new one, then read that data file and loop over the lines, breaking it into the table structure above. This one also takes forever. Any suggestions at all on how to streamline the process would be really helpful, Thanks in advance Bill Henderson [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Really big file manipulation
If you are familiar enough with the DTS designer to use the Workflow events to chain tasks together that's probably all the dts knowledge you really need. I'd start by running the import wizard on the text file and saving the dts package for the import. Then go to the designer and open the package up and start writing queries to massage the data however necessary. Just doing everything in DTS will probably yield a huge speedup even before you start tweaking the process. There are many ways to do it, but this would be the easiest to start with I think. -- jon mailto:jonhall;ozline.net Monday, October 21, 2002, 4:09:07 PM, you wrote: BH Thanks for the tip on text drivers, I always forget to try that. BH Now to take this thread OT: BH The problem I have with DTS is that I am unfamiliar with how to do BH advanced data manipulation. In this case, I have to take every row of BH the text file, make a new county entry, take the identity for the city BH table, make a new entry for the city table with the county identity as a BH foreign key, and so on down the levels until I get to the zip table. BH And, of course, avoid multiple entries in the county, city and location BH tables. To make matters worse, I need the full state names in the state BH table, and the csv only has short state names. So, I have to start with BH an existing table that I made with stateID, name and short name for the BH states and reference this when inputting the counties. BH All this without any knowledge of how to set up advanced stuff in DTS. BH If you have a couple of key words for me to search for when looking up BH help in DTS, based on what I need to do, that would a big help. BH Or, is there a site somewhere with DTS packages for download similar to BH the MM developer's exchange? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Using JSP alongside CFML
Anyone have recommendations for a JSP server that runs on IIS that will not interfere with CFMX? Is JRun the best option? How about Tomcat, will it run alongside CFMX and play nicely? If you're just interested in JSP and servlets, and nothing else, and you're using Enterprise Edition, you could just run them on CFMX. You can drop JSPs anywhere in your web root; you can put servlets in the appropriate /WEB-INF subdirectory, and you can put servlets elsewhere if you're willing to edit the appropriate text file. If you want more than that, you might consider getting JRun and installing CFMX for JRun on top of it. Altogether, it's about the same price as CFMX Enterprise for a single-processor server, I think (I'm not exactly sure about pricing, though). This will get you the best integration between your CF code and your Java stuff. However, you can also run a separate J2EE server on the same machine as a stand-alone CFMX install without too much trouble. I've just played around with this a very tiny bit, but haven't run into any problems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Really big file manipulation
Do you know which phase of the process is eating the memory? Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Bill Henderson To: CF-Talk [EMAIL PROTECTED] cf-talk@uutil cc: ity.com Subject: RE: Really big file manipulation 10/21/2002 03:44 PM Please respond to cf-talk Tried these - I thought not committing was the problem at first, but there was no appreciable change. Same with the nologged bulk, this lightened the load, but not much. And I always use queryparams. Bill Henderson [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:kpeterson;sehinc.com] Sent: Monday, October 21, 2002 1:25 PM To: CF-Talk Subject: Re: Really big file manipulation Your SQL server memory is mostly likely climbing trying to keep track of rollback information. Try using a nologged bulk copy when you create and load the temp table. If possible use update select or insert select for moving the data. Commit your transaction(s) more often if possible. Use cfqueryparm for all changing values (variables) in your SQL statments. Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Randell B Adkins To: CF-Talk cf- [EMAIL PROTECTED] [EMAIL PROTECTED] cc: OV Subject: Re: Really big file manipulation 10/21/2002 01:25 PM Please respond to cf-talk I at one time had a 500,000 byte file to import 5 days a week. But that had to go to one table. Sorry my recommendations is on MSSQL DTS. [EMAIL PROTECTED] 10/21/02 02:23PM Hey all - I have got a 76,000+ line data file (ZipUSA comma delim file) that I need to break into smaller tables in my DB. This needs to happen at least monthly, so I wrote a cfm template to automate the process. The problem I am having is speed and server load. I have tried using the following methods, and am wondering if anybody has any suggestions (apart from using SQL's DTS) Platform info: CF 5 on Win2k, IIS 5 writing to MSSQL 2000 The tables I am putting everything into are a state table, county table w/state reference, city table w/county reference, location/district table w/city reference and zip table w/district reference 1) Create temp SQL table, loop over file, write to temp table, query temp table, loop over query, and using conditional logic - break into table structure defined above, and drop temp table. This is the shortest method taking 20 minutes or so. The problem is that my SQL service's memory usage spirals out of control and when the template is finished, it never returns to normal. I have to restart the service to right it. 2) Same as above, but converts the data file into a CF function-made query and then do a query of query. (This is necessary to re-order data for break-down step) This one takes forever (an hour on the slowest run) and both the CF services and the SQL service take over the machine. 3) Read the data file, write a new one, then read that data file and loop over the lines, breaking it into the table structure above. This one also takes forever. Any suggestions at all on how to streamline the process would be really helpful, Thanks in advance Bill Henderson [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Oracle 8 Native Drivers Failing
We have CF 5.0 on Win2K SP3 and Oracle 8.1.6 (8i) on Solaris. We cannot connect to the database using the Native 8.0 drivers. The 7.3 drivers work except for CFQUERYPARAM which the 7.3 drivers do not seem to support and we cannot do without. Does anybody have experience in this area? Why doesn't the native 8.0 drivers work? Dave === David R. Hannum Web Analyst/Programmer Ohio University Computer Services Administrative Systems (740) 597-2524 If your wife is having fun, and you're not . . . You're still having a lot more fun than if you're having fun, and she's not! (Red Green) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Stored Procedures and Triggers
Hi, Can anyone point in the direction of some tutorials on Creating Stored Procedures and Triggers in SQL Server? TIA *** James Johnson SMB-Studios Innovative Online Learning for Spirit, Mind and Body www.smb-studios.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CFX_SPELL Question/Problem
Just FYI, We use cfobject to call a custom dll that was written to talk to a FoxPro database using native FoxPro instead of ODBC and it also drops application and session scopes periodically. The strange thing is that when this happens, if you just wait a few seconds and then hit refresh on the browser, the variables are back. Andy -Original Message- From: Adrocknaphobia Jones [mailto:adrocknatalk;hotmail.com] Sent: Monday, October 21, 2002 11:33 AM To: CF-Talk Subject: RE: CFX_SPELL Question/Problem Rich, If you and Ben figure this one out, will you post a summary of the solution? I'm curious as to what causes CF to dump application and session scope like that. Is it just an old v4 bug? Was it the .dll? Was is cfLock or cfTry? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Ben Forta [mailto:ben;forta.com] Sent: Monday, October 21, 2002 2:15 PM To: CF-Talk Subject: RE: CFX_SPELL Question/Problem Rich, Please e-mail me directly off list on this one. --- Ben -Original Message- From: Adrocknaphobia Jones [mailto:adrocknatalk;hotmail.com] Sent: Monday, October 21, 2002 2:15 PM To: CF-Talk Subject: RE: CFX_SPELL Question/Problem If you remove the logic (CFTRY/CFLOCK) everything goes back to normal? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Sloan, Richard [mailto:RSloan;follett.com] Sent: Monday, October 21, 2002 1:56 PM To: CF-Talk Subject: CFX_SPELL Question/Problem Hi All, We are having a problem I hope the list can help with. In a Nutshell, We purchased Forta's CFX_Spell tag and wrote a UI for it. Tested it with no problem. Then we moved it to our Production machine which is running CF 4.01 on Windows NT 4. (Before you say upgrade to CF5 or MX, Let me just state that this box houses a business critical app that runs fine under cf4.01 and we have not wanted to upgrade just yet.) When we moved it to Production and the user's started hitting the dll, the tag stopped working. After doing some better research I learned the CFX tag was not multi-thread safe and it was suggested to add cflock around the tag to force it to be single threaded. Did that and added cftrycfcatch logic around the cfx tag. I have included the logic below. Anyway, The additional logic caused something strange to happen. The Server Seemed to loose all session/Application variables and Would not allow access to any CFM pages only .html pages. We immediately shut off access to the dll and all code touching it. I sent numerous emails to forta, but have not gotten a response. Has anyone else experienced these problems? any resolutions/ suggestions on how to get this to work? Any help would be greatly appreciated. Here is the code used: cftry cflock name=spellock timeout=20 throwontimeout=Yes CFX_SPELL TEXT=#Form.CommentBox# name=spell LANGUAGE=#language# /cflock cfcatch type=ALL cflocation url=Update_review.cfm addtoken=NO /cfcatch /cftry ~Rich Rich Sloan Coldfusion Web Developer Follett Corporation-CTG 2233 West St. -River Grove, IL 60171 P 708.437.2360 E [EMAIL PROTECTED] www.follett.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Really big file manipulation
As far as I can tell, if I am relying on SQL (as opposed to CF) for the bulk of the work, the insert into the temp table seems to be the hog. I am using cfflush to send progress reports to the browser, and when it hits the inserts it starts to bog down. The memory spike takes place somewhere between the 6,000th and 12,000th record, and stays spiked until I restart the MSSQLSERVER service. Bill Henderson [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:kpeterson;sehinc.com] Sent: Monday, October 21, 2002 1:52 PM To: CF-Talk Subject: RE: Really big file manipulation Do you know which phase of the process is eating the memory? Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Bill Henderson To: CF-Talk cf- [EMAIL PROTECTED] cf-talk@uutil cc: ity.com Subject: RE: Really big file manipulation 10/21/2002 03:44 PM Please respond to cf-talk Tried these - I thought not committing was the problem at first, but there was no appreciable change. Same with the nologged bulk, this lightened the load, but not much. And I always use queryparams. Bill Henderson [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:kpeterson;sehinc.com] Sent: Monday, October 21, 2002 1:25 PM To: CF-Talk Subject: Re: Really big file manipulation Your SQL server memory is mostly likely climbing trying to keep track of rollback information. Try using a nologged bulk copy when you create and load the temp table. If possible use update select or insert select for moving the data. Commit your transaction(s) more often if possible. Use cfqueryparm for all changing values (variables) in your SQL statments. Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Randell B Adkins To: CF-Talk cf- [EMAIL PROTECTED] [EMAIL PROTECTED] cc: OV Subject: Re: Really big file manipulation 10/21/2002 01:25 PM Please respond to cf-talk I at one time had a 500,000 byte file to import 5 days a week. But that had to go to one table. Sorry my recommendations is on MSSQL DTS. [EMAIL PROTECTED] 10/21/02 02:23PM Hey all - I have got a 76,000+ line data file (ZipUSA comma delim file) that I need to break into smaller tables in my DB. This needs to happen at least monthly, so I wrote a cfm template to automate the process. The problem I am having is speed and server load. I have tried using the following methods, and am wondering if anybody has any suggestions (apart from using SQL's DTS) Platform info: CF 5 on Win2k, IIS 5 writing to MSSQL 2000 The tables I am putting everything into are a state table, county table w/state reference, city table w/county reference, location/district table w/city reference and zip table w/district reference 1) Create temp SQL table, loop over file, write to temp table, query temp table, loop over query, and using conditional logic - break into table structure defined above, and drop temp table. This is the shortest method taking 20 minutes or so. The problem is that my SQL service's memory usage spirals out of control and when the template is finished, it never returns to normal. I have to restart the service to right it. 2) Same as above, but converts the data file into a CF function-made query and then do a query of query. (This is necessary to re-order data for break-down step) This one takes forever (an hour on the slowest run) and both the CF services and the SQL service take over the machine. 3) Read the data file, write a new one, then read that data file and loop over the lines, breaking it into the table structure above. This one also takes forever. Any suggestions at all on how to streamline the process would be really helpful, Thanks in advance Bill Henderson [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Stored Procedures and Triggers
There are some on my server: http://exciteworks.com/ec/sql.cfm Josh Trefethen http://exciteworks.com Quoting James Johnson [EMAIL PROTECTED]: Hi, Can anyone point in the direction of some tutorials on Creating Stored Procedures and Triggers in SQL Server? TIA *** James Johnson SMB-Studios Innovative Online Learning for Spirit, Mind and Body www.smb-studios.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Using JSP alongside CFML
Does anybody know how to get better debugging information with CFMX JSP? Sometimes i get the stack error with Refer Documentation.. which doesnt help alot.. Any Ideas? Joe On Mon, 21 Oct 2002 13:21:19 -0700 Chris Kief [EMAIL PROTECTED] wrote: There are a couple things in the release notes you should be aware of when installing CFMX stand-alone and JRun: - If you install ColdFusion MX on a computer that has JRun 3.x or 4.0 installed and JRun is configured to connect to an external web server, choosing to configure the same external web server for ColdFusion MX will cause JSP pages and servlets to be processed through ColdFusion MX instead of through JRun. - If you have ColdFusion MX installed on the IIS, Apache, or Netscape/iPlanet web server and then install JRun 3.x or JRun 4, the ColdFusion MX configuration is lost, and you must reconfigure your web server for ColdFusion MX. HTHs, chris kief -Original Message- From: Dave Watts [mailto:dwatts;figleaf.com] Sent: Monday, October 21, 2002 1:09 PM To: CF-Talk Subject: RE: Using JSP alongside CFML Anyone have recommendations for a JSP server that runs on IIS that will not interfere with CFMX? Is JRun the best option? How about Tomcat, will it run alongside CFMX and play nicely? If you're just interested in JSP and servlets, and nothing else, and you're using Enterprise Edition, you could just run them on CFMX. You can drop JSPs anywhere in your web root; you can put servlets in the appropriate /WEB-INF subdirectory, and you can put servlets elsewhere if you're willing to edit the appropriate text file. If you want more than that, you might consider getting JRun and installing CFMX for JRun on top of it. Altogether, it's about the same price as CFMX Enterprise for a single-processor server, I think (I'm not exactly sure about pricing, though). This will get you the best integration between your CF code and your Java stuff. However, you can also run a separate J2EE server on the same machine as a stand-alone CFMX install without too much trouble. I've just played around with this a very tiny bit, but haven't run into any problems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: BROWSER DETECT HELP
Does anyone know some simple code for browser,flash,activex,windows media, and real player detection? Please help! JOY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Really big file manipulation
When you are looping through and doing your inserts is the loop inside the cfquery tag or outside? Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Bill Henderson To: CF-Talk [EMAIL PROTECTED] cf-talk@uutil cc: ity.com Subject: RE: Really big file manipulation 10/21/2002 04:32 PM Please respond to cf-talk As far as I can tell, if I am relying on SQL (as opposed to CF) for the bulk of the work, the insert into the temp table seems to be the hog. I am using cfflush to send progress reports to the browser, and when it hits the inserts it starts to bog down. The memory spike takes place somewhere between the 6,000th and 12,000th record, and stays spiked until I restart the MSSQLSERVER service. Bill Henderson [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:kpeterson;sehinc.com] Sent: Monday, October 21, 2002 1:52 PM To: CF-Talk Subject: RE: Really big file manipulation Do you know which phase of the process is eating the memory? Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Bill Henderson To: CF-Talk cf- [EMAIL PROTECTED] cf-talk@uutil cc: ity.com Subject: RE: Really big file manipulation 10/21/2002 03:44 PM Please respond to cf-talk Tried these - I thought not committing was the problem at first, but there was no appreciable change. Same with the nologged bulk, this lightened the load, but not much. And I always use queryparams. Bill Henderson [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:kpeterson;sehinc.com] Sent: Monday, October 21, 2002 1:25 PM To: CF-Talk Subject: Re: Really big file manipulation Your SQL server memory is mostly likely climbing trying to keep track of rollback information. Try using a nologged bulk copy when you create and load the temp table. If possible use update select or insert select for moving the data. Commit your transaction(s) more often if possible. Use cfqueryparm for all changing values (variables) in your SQL statments. Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Randell B Adkins To: CF-Talk cf- [EMAIL PROTECTED] [EMAIL PROTECTED] cc: OV Subject: Re: Really big file manipulation 10/21/2002 01:25 PM Please respond to cf-talk I at one time had a 500,000 byte file to import 5 days a week. But that had to go to one table. Sorry my recommendations is on MSSQL DTS. [EMAIL PROTECTED] 10/21/02 02:23PM Hey all - I have got a 76,000+ line data file (ZipUSA comma delim file) that I need to break into smaller tables in my DB. This needs to happen at least monthly, so I wrote a cfm template to automate the process. The problem I am having is speed and server load. I have tried using the following methods, and am wondering if anybody has any suggestions (apart from using SQL's DTS) Platform info: CF 5 on Win2k, IIS 5 writing to MSSQL 2000 The tables I am putting everything into are a state table, county table w/state reference, city table w/county reference, location/district table w/city reference and zip table w/district reference 1) Create temp SQL table, loop over file, write to temp table, query temp table, loop over query, and using conditional logic - break into table structure
RE: Really big file manipulation
Outside -Original Message- From: [EMAIL PROTECTED] [mailto:kpeterson;sehinc.com] Sent: Monday, October 21, 2002 3:03 PM To: CF-Talk Subject: RE: Really big file manipulation When you are looping through and doing your inserts is the loop inside the cfquery tag or outside? Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Bill Henderson To: CF-Talk cf- [EMAIL PROTECTED] cf-talk@uutil cc: ity.com Subject: RE: Really big file manipulation 10/21/2002 04:32 PM Please respond to cf-talk As far as I can tell, if I am relying on SQL (as opposed to CF) for the bulk of the work, the insert into the temp table seems to be the hog. I am using cfflush to send progress reports to the browser, and when it hits the inserts it starts to bog down. The memory spike takes place somewhere between the 6,000th and 12,000th record, and stays spiked until I restart the MSSQLSERVER service. Bill Henderson [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:kpeterson;sehinc.com] Sent: Monday, October 21, 2002 1:52 PM To: CF-Talk Subject: RE: Really big file manipulation Do you know which phase of the process is eating the memory? Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Bill Henderson To: CF-Talk cf- [EMAIL PROTECTED] cf-talk@uutil cc: ity.com Subject: RE: Really big file manipulation 10/21/2002 03:44 PM Please respond to cf-talk Tried these - I thought not committing was the problem at first, but there was no appreciable change. Same with the nologged bulk, this lightened the load, but not much. And I always use queryparams. Bill Henderson [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:kpeterson;sehinc.com] Sent: Monday, October 21, 2002 1:25 PM To: CF-Talk Subject: Re: Really big file manipulation Your SQL server memory is mostly likely climbing trying to keep track of rollback information. Try using a nologged bulk copy when you create and load the temp table. If possible use update select or insert select for moving the data. Commit your transaction(s) more often if possible. Use cfqueryparm for all changing values (variables) in your SQL statments. Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Randell B Adkins To: CF-Talk cf- [EMAIL PROTECTED] [EMAIL PROTECTED] cc: OV Subject: Re: Really big file manipulation 10/21/2002 01:25 PM Please respond to cf-talk I at one time had a 500,000 byte file to import 5 days a week. But that had to go to one table. Sorry my recommendations is on MSSQL DTS. [EMAIL PROTECTED] 10/21/02 02:23PM Hey all - I have got a 76,000+ line data file (ZipUSA comma delim file) that I need to break into smaller tables in my DB. This needs to happen at least monthly, so I wrote a cfm template to automate the process. The problem I am having is speed and server load. I have tried using the following methods, and am wondering if anybody has any suggestions (apart from using SQL's DTS) Platform info: CF 5 on Win2k, IIS 5 writing to MSSQL 2000 The tables I am putting everything into are a state table, county table w/state reference, city table w/county reference, location/district table w/city reference and zip table w/district reference 1) Create temp SQL table, loop over file, write to temp table, query temp table, loop over query, and using conditional logic - break into table structure defined above, and drop temp table. This is the shortest method taking 20 minutes or so. The problem is that my SQL service's memory usage spirals out of control and when the template is finished, it never returns to normal. I have to restart the service to right it. 2) Same as above, but converts the data file into a CF function-made query and then do a query of query. (This is necessary to re-order data for break-down step) This one takes forever (an hour on the slowest run) and both the CF services and the SQL service take over the machine. 3) Read the data file, write a new
JSAPI for IIS
Hi, This might be slightly off-topic, but I'm trying to access some IIS information from coldfusion. I found some info on the Microsoft website, and they lead to JSAPI, a version of ISAPI for Java But I can'r find this JSAPI anywhere... does anyone here have it? It used to come with the IIS ResKit. Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
WDDX/XML
Hey All, I'm looking at options for building a mini shopping cart (mini meaning it will not hold more than say 5 items). I do not want to use SESSION variables, so I need a method of passing arrays or structures between pages. One method I thought about was using a specially delimited list stored in a cookie to hold the items (each line item seperated by | and each element of each line item seperated by something else). So position 1 in each line item would hold quantity, position 2 would hold price etc. (i.e. 2^5|5^10 would read 2 line items...first one with a quantity of 2 and a price of 5...second line item with a quantity of 5 and a price of 10). Being that there would never be a large amount of line items, the storga capacity of a cookie wouldn't be an issue. The above would work, but it's a tad kludgy for my liking. So, I'm looking for some WDDX/XML related solutions that might do the same thing. Requirements: Must work with Win2K running CF 5 Thanks in advance for any help. Let me know if I can clarify anything ;-) 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/index.cfm?sidebar=listsbody=lists/cf_talk 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
