RE: URL Variables
Thanks! >From: "Bobby Hartsfield" <[EMAIL PROTECTED]> >Reply-To: cf-talk@houseoffusion.com >To: CF-Talk >Subject: RE: URL Variables >Date: Tue, 18 Oct 2005 18:26:29 -0400 > >Urlencodedformat() everything after '?newURL=' > >And then urlDecode(url.newurl) when you need to pull it back out > > >www.domain.com/page.cfm?newURL=#urlencodedformat(www.domain.com/page2.cfm?va >r1=a&var2=b)# > >and... > >#urldecode(url.newURL)# > > >..:.:.:.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com > > >-Original Message- >From: B G [mailto:[EMAIL PROTECTED] >Sent: Tuesday, October 18, 2005 5:42 PM >To: CF-Talk >Subject: URL Variables > >Is this possible? > >I want to pass a string containing URL variables through a URL. For >example: > >www.domain.com/page.cfm?newURL=www.domain.com/page2.cfm?var1=a&var2=b > >In other words on page2.cfm I should reference > >#URL.newURL# outputs www.domain.com/page2.cfm?var1=a&var2=b > >Thanks > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221413 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
URL Variables
Is this possible? I want to pass a string containing URL variables through a URL. For example: www.domain.com/page.cfm?newURL=www.domain.com/page2.cfm?var1=a&var2=b In other words on page2.cfm I should reference #URL.newURL# outputs www.domain.com/page2.cfm?var1=a&var2=b Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221390 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IIS/Index Server/CF and ASP
I had thought something similiar. In fact, other colleagues have said pretty much the same thing. Two things about this strategy are unclear to me. 1) Index server IS cataloging CFM pages so even if I knew where there was such a list, adding it may or may not have an impact on the output. 2) When creating an index there are a very limited number of items to configure. Since you point it to a specific web site running on IIS I assume that IIS must be telling it to some degree that CFM pages are to be treated like HTM pages. Now I notice that MS Word Docs are also returned, but likewise have no DOCTITLE. So I think you're definitely pointing in the right direction to say Index Server doesn't recognize the same file structure as HTM so doesn't know how to populate DOCTITLE. I don't know enough about ASP, but there must be some way to say: Any suggestions? >From: Jerry Johnson <[EMAIL PROTECTED]> >Reply-To: cf-talk@houseoffusion.com >To: CF-Talk >Subject: Re: IIS/Index Server/CF and ASP >Date: Thu, 22 Sep 2005 15:35:42 -0400 > >I do not have any specific info for you, just a guess and direction to >research. > >My guess is that whatever is doing the indexing (a filter of some >sort) does not know that CFM files have a similar structure to .HTM >files. You are probably going to need to add cfm files to the list of >filetypes processed by the htm filter. > >I have no idea how. > >On 9/22/05, B G <[EMAIL PROTECTED]> wrote: > > This is going to be broad, but is based on a CF problem I am having. > > > > I have an ASP search page which is referencing Index Server catalogs. >It's > > a standard one I found and I believe is commonly used. I can provide >the > > whole code if necessary. > > > > The Index Server appears to be cataloging both HTML and CFML pages > > correctly. The search results page returns both HTML and CFML > > appropriately. The problem is that CFM pages don't have the DOCTITLE > > information appearing. It is simply blank. This is information that >would > > be contained within . > > > > Here's the output code for searchresults.asp: > > > > Response.write " > """class=main>"" & oRS("doctitle") & """ > > > > I have confirmed that the CFM pages do indeed contain valid TITLE data. > > This is happening to all CFM pages and no HTM pages. > > > > Anyone have any insight? Thanks! > > > > > > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219013 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
IIS/Index Server/CF and ASP
This is going to be broad, but is based on a CF problem I am having. I have an ASP search page which is referencing Index Server catalogs. It's a standard one I found and I believe is commonly used. I can provide the whole code if necessary. The Index Server appears to be cataloging both HTML and CFML pages correctly. The search results page returns both HTML and CFML appropriately. The problem is that CFM pages don't have the DOCTITLE information appearing. It is simply blank. This is information that would be contained within . Here's the output code for searchresults.asp: Response.write """ & oRS("doctitle") & """ I have confirmed that the CFM pages do indeed contain valid TITLE data. This is happening to all CFM pages and no HTM pages. Anyone have any insight? Thanks! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219000 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Bulletproof processing - Ensuring Safe CC transactions
I am developing a nightly batch process which will process CC's through Verisign, then update records as approved in order to release back orders which have had inventory replenished. The process is simple enough, though I need to ensure reliable recovery should something go wrong. I'm looking for additional suggestions, or insight into the process which I may be missing. Here's my outline: 1) Query orders to be released 2) Write a text log of invoices which are expected to be processed (record count, row number, invoice ID, customer number, amount) 3) Send CC to Verisign, get approval for each transaction, write to log with row number, invoice ID, customer ID, verisign reference number 4) Update Database with approval info, write to log indicating db has been updated. 5) When ALL transactions have completed, mark log as completed, indicate approvals and denials, 6) Generate email sent to me and others indicating entire process was complete along with transaction statistics. The log is written AFTER each step in this process so that it can be reviewed to determine which invoice failed, and at what point it failed. Also, I will be wrapping this in TRY/CATCH with error reporting to provide further details. This should catch most errors that pop up (crabby DBA can't sleep and decides to do server maintenance in the middle of the night and shuts down server?) But there are those extreme occasions when CF simply restarts itself. Anyone else have these? TRY/CATCH won't catch this behavior. This is the thing that worries me most. I will have the log to show where a transactions fails, but in the event of a shut down, no other info. Am I worrying too much? Am I missing something? Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214109 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RegEx question: Multiple replaces in one statement
Thanks! I actually did have the one line with REReplace but a well hidden syntax error got me to separate the two. For my own education, what is REReplace doing that Replace is not which adds the overhead? >From: <[EMAIL PROTECTED]> >Reply-To: cf-talk@houseoffusion.com >To: CF-Talk >Subject: RE: RegEx question: Multiple replaces in one statement >Date: Fri, 29 Jul 2005 11:19:07 -0500 > >Here's how I would do it: > >Replace(Replace(qGetBrandNames.Brand_Names,"~","(r)","ALL"),"^","&##8482;","ALL") > > > > >You're still calling replace twice, but it's only one line of code. And >Barney's right...don't use REReplace if you don't need it, it's extra >overhead. > >Dave > >---Original Message- >From: Barney Boisvert [mailto:[EMAIL PROTECTED] >Sent: Friday, July 29, 2005 12:05 PM >To: CF-Talk >Subject: Re: RegEx question: Multiple replaces in one statement > > >Nope, but you don't REreplace at all, a simple replace will do the >trick just as well, and with less overhead. You could even use >replaceList, but I'd not recommend that, as it has some weird quirks. > >cheers, >barneyb > >On 7/29/05, B G <[EMAIL PROTECTED]> wrote: > > Is it possible to replace two different items in a string? > > > > I have a table holding brand names. All ~ should be (r) AND all ^ >should be > > TM. Currently I am doing the following: > > > > "ALL")#"> > > > > > > Is it possible to do this in one REReplace statement? > > > > Thanks. > > > > >-- >Barney Boisvert >[EMAIL PROTECTED] >360.319.6145 >http://www.barneyb.com/ > >Got Gmail? I have 50 invites. > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213294 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RegEx question: Multiple replaces in one statement
Is it possible to replace two different items in a string? I have a table holding brand names. All ~ should be ® AND all ^ should be TM. Currently I am doing the following: Is it possible to do this in one REReplace statement? Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFDIRECTORY - previous & next
Thanks to you both. This may be academic, but reducing CFDIR calls to as few as possible would be prudent, no? On a small scale performance may not suffer, but accessing the HDD can quickly create lag as file sizes and numbers grow. >From: S. Isaac Dealey <[EMAIL PROTECTED]> >Reply-To: cf-talk@houseoffusion.com >To: CF-Talk >Subject: Re: CFDIRECTORY - previous & next >Date: Thu, 23 Jun 2005 18:15:33 -0400 > >Barney's suggestion should work... as an alternative suggestion, you >could either use ListFindNoCase() against the cfdirectory's name >column to locate the current image: > > > >And then use "index" to locate the next and last images in that >cfdirectory query. > >Or you can pass the index of the image in that query to the page and >omit the listfindnocase() statement all-together. > >When you have the index of an image you can easily get the names of >the next and last images in the directory using >cfdirectory.name[index+1] and cfdirectory.name[index-1] or compare >against cfdirectory.recordcount to know if the current image is the >last one in the directory. > >You do need to make sure you use a sort order in the cfdirectory tag, >as cfdirectory will produce semi-random results otherwise. > > >s. isaac dealey 954.522.6080 >new epoch : isn't it time for a change? > >add features without fixtures with >the onTap open source framework > >http://www.fusiontap.com >http://coldfusion.sys-con.com/author/4806Dealey.htm > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210453 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFDIRECTORY - previous & next
I've been noodling around with a photo gallery which relies on Picasa2 to create thumbs and web friendly images. The app use cfdirectory to read the list of jpegs in any given directory making it easy to add and delete at will without updating the static HTML pages Picasa2 generates. It's basic, but works well. My app is three basic pages. A page which lists folders. A page which lists thumbnails when the user chooses a folder, and of course a page which shows the large image when the user clicks on one of the thumbnails. I've been wanting to add a PREVIOUS - NEXT feature on the main image page so the user doesn't have to always hit BACK to the thumbs to navigate to the next image. I don't see any way of using CFDIRECTORY to determine which file is next based on the current position. I'm guessing that I will have to create a list of filenames and keep it in a session so that I can call the filename based on list position. Any other theories? Thanks! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210439 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Java and JVM page in CF Administrator
Right, I had forgotten about jvm.config. That's not a problem. I'm not too familiar with J2EE, but I'm pretty sure my setup is not. Would it be reported in the complete SETTINGS list? Or license? Also, if not J2EE, do I have a corrupt installation? Thanks. >From: Douglas Knudsen <[EMAIL PROTECTED]> >Reply-To: cf-talk@houseoffusion.com >To: CF-Talk >Subject: Re: Java and JVM page in CF Administrator >Date: Tue, 24 May 2005 17:31:53 -0400 > >sounds like you have the J2EE version with full Jrun. In this case the >CFAdmin tool doesn't have this. You can use the JMC, I think its fixed now, >used to have a bug that messedup your JVM settings. Personally, I mod these >directly. See JRun/bin for your jvm.config. Note by default, this file >applies to all JRun instances. > >DK > >On 5/24/05, B G <[EMAIL PROTECTED]> wrote: > > > > This question is in regards to CFMX 6.1 Enterprise. > > > > I am working on a box I inherited and in the admin there is no link to >the > > Java and JVM settings. I have never seen this before and I have no idea > > where to even look to correct this. Could the installation be corrupt? >All > > CF pages seem to behave correctly but I cannot edit the Class Path for a > > new > > app I am trying to install. > > > > Any ideas? Thanks in advance! > > > > BG > > > > > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207668 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Java and JVM page in CF Administrator
This question is in regards to CFMX 6.1 Enterprise. I am working on a box I inherited and in the admin there is no link to the Java and JVM settings. I have never seen this before and I have no idea where to even look to correct this. Could the installation be corrupt? All CF pages seem to behave correctly but I cannot edit the Class Path for a new app I am trying to install. Any ideas? Thanks in advance! BG ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207592 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Decimal Formatting
Beautiful! That did the trick! Thank you. >From: Barney Boisvert <[EMAIL PROTECTED]> >Reply-To: cf-talk@houseoffusion.com >To: CF-Talk >Subject: Re: Decimal Formatting >Date: Tue, 12 Apr 2005 14:45:33 -0700 > >NUMBER columns are actually stored as strings, so you'll always get >exactly 2 decimal places. Try this: > > > #int(myNum)# > > #REreplace(myNum, "0+$", "")# > > >cheers, >barneyb > >On Apr 12, 2005 2:38 PM, B G <[EMAIL PROTECTED]> wrote: > > There's a simple solution here that is eluding me so please forgive my >"end > > of day cloud" that is obstructing me. > > > > I am trying to format a value that is stored in Oracle NUMBER(5,2) >datatype > > so that if it is a whole number it won't display x.00. > > > > For example, value 25.75 is fine and displays properly, value 18, should >NOT > > display 18.00. Likewise, 10.5 should NOT be 10.50. But this is the > > behaviour I am getting. > > > > What are you thoughts? > >-- >Barney Boisvert >[EMAIL PROTECTED] >360.319.6145 >http://www.barneyb.com/ > >Got Gmail? I have 50 invites. > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202499 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Decimal Formatting
There's a simple solution here that is eluding me so please forgive my "end of day cloud" that is obstructing me. I am trying to format a value that is stored in Oracle NUMBER(5,2) datatype so that if it is a whole number it won't display x.00. For example, value 25.75 is fine and displays properly, value 18, should NOT display 18.00. Likewise, 10.5 should NOT be 10.50. But this is the behaviour I am getting. What are you thoughts? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202494 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How does CF Mail Server Work?
Thanks! >From: "Howie Hamlin" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: How does CF Mail Server Work? >Date: Mon, 27 Sep 2004 14:22:44 -0400 > >The main info page is here: > >http://postmaster.info.aol.com/ > >The whitelist signup info is here: > >http://postmaster.info.aol.com/whitelist/index.html > >HTH, > >-- >Howie Hamlin - inFusion Project Manager >On-Line Data Solutions, Inc. - www.CoolFusion.com >inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >PrismAV - Virus scanning for ColdFusion applications > >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm > > > - Original Message - > From: Burns, John D > To: CF-Talk > Sent: Monday, September 27, 2004 2:17 PM > Subject: *Spam* RE: How does CF Mail Server Work? > > > Do you have any links with info on that? > > John Burns > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How does CF Mail Server Work?
Interesting. That should shed some light. >From: Matt Robertson <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: How does CF Mail Server Work? >Date: Mon, 27 Sep 2004 11:04:31 -0700 > >Paul Vernon wrote > > > Matt (MySecretBase) has updated his throttling articles which can be >found > > here... > >Paul discreetly doesn't mention it but there is very likely a way to >use his very inexpensive CFX_ValidEmail to help with determining your >mail issues as well. It has a way of reaching out to the destination >mail server and figuring out if an address is going to accept mail. >Coupled to the slow-speed trickler bit I use, there shouldn't be any >issues associated with this sort of extended validation. > >As soon as I get the time I'm building it into my own CMS' trickler as >an optional add-on. I plan on keeping a separate list of failures >and, once an address crosses the threshold of X failures, doing >something to ban the address. > >Cheers, > >-- >--Matt Robertson-- >MSB Designs, Inc. >mysecretbase.com > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How does CF Mail Server Work?
In the past I have used something similar to throttle emails that are sent. With CFMX I it wasn't necessary as it was in previous versions. Maybe it's time to bring it back. My IT guy who has dealt with similar AOL issues has indicated that he never got a clear answer from AOL on what would trigger email being blocked. He even seemed to indicate that it can depend on which server of their cluster happens to handle your emails. Sometimes it gets blocked, other times not. Has anyone seen a good resource that might indicate how many is too many for AOL and others in a bulk email? Thanks. >From: "Paul Vernon" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: How does CF Mail Server Work? >Date: Mon, 27 Sep 2004 16:42:09 +0100 > >You may want to look at throttling down CFMX sending out mails to AOL or >MSN >and some of the other larger mail providers. > >High numbers of mails originating from the same IP look like spam so a >single mail can get through but bulk is blocked... To get around this, you >need to slow down how you send to these companies > >Matt (MySecretBase) has updated his throttling articles which can be found >here... > >http://mysecretbase.com/Slowing_Down_CFMAIL.cfm > >http://mysecretbase.com/Slowing_Down_CFMail_2004.cfm > >Paul > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
How does CF Mail Server Work?
My site sends a fairly large number of emails on a daily basis. In addition to newsletters that are sent to subscribers there are notifications of a variety of types (message board, requests for info, registrations, etc) As the newsletter subscriber list grows I am trying to manage it better by unsubscribing users that have email addresses that are no longer valid. I have written a script that reads bounced messages, finds the email address, matches it against certain tables and takes the appropriate action. This part works ok. But I am noticing that all AOL users and large groups of other domains are all rejected. The bounced message doesn't say why. Just that delivery failed. When I send an email via my personal account to an address (AOL) that was rejected when it came from the web site it appears to be received ok. The two email addresses I am sending from have the same domain so I don't think that that whole domain or IP has been blacklisted. Also, in the event viewer I see errors like "Could not connect to domain xxx.com" which I don't understand. System is Win2000, CFMX 6.1 Enterprise using Windows mail server. I realize this question is vague but the gist is this: What is mail server doing that needs to connect to a domain in order to delivery an email? Could this be what is causing some mails to be rejected? Could a specific address be blocked (note: messages that are bounced because of suspected spam have a different message) ? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Comparing two records within the query
Thanks for your help on this. I am pretty sure I have the query down as I need. I used a variation of your UNION'ed query. Since we don't have one ISDN for each title, I stripped the suffix off of the ID (-01 or -03) to artificially create a unique ID for each title. Thanks again! >From: "Cornillon, Matthieu (Consultant)" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Comparing two records within the query >Date: Thu, 9 Sep 2004 11:54:22 -0400 > > >> Another option is to do a self-join. > > > This works, though I am not getting all rows returned and I haven't >quite > > > figured why yet. I hate to rely on the titles being exactly the same. >I > > > have data where one title contains the words DVD while the VHS version > > doesn't. > > Unfortunately, you are running into a fundamental data identity issue >here. >Here, identity is "a particular movie, regardless of format". The goal of >your application is to return a list of identities (as defined above), with >available format information included. > >If you had some unique identifier (similar to ISBN) for movies, something >that said 002943018 = "What's Eating Gilbert Grape?" regardless of whether >it was VHS, Beta, DVD, Laserdisc, or celluloid, you could do this >comparison >flawlessly and easily. Unfortunately, I am guessing that you have no such >unique identifier, and further that no such identifier even exists. > >(Interesting idea: use IMDBs data. They identify "What's Eating Gilbert >Grape" as tt0108550. If you used this, you could even dynamically generate >links to IMDB for more information. You would have to create a table of >titles and these unique IDs somehow, and this would be a bunch of work, >but--as I said--interesting idea. If you link to them, they might not even >mind, in which case you could ask them to send you a list of titles and >IDs. >Again, just a brainstorm.) > >Back to the issue at hand: if you had such an identifier, you would be all >set. But you don't. So, you are using title, which is pretty good. But >you have problems. "The Manchurian Candidate" is not good as an identity: >it could mean either the 1962 or the 2004 version. Also, you have this >format data appended. > >I recommend that you add a column to the table that is "cleaned title". >You >then cycle through the database and remove that VHS and DVD note. While >you >do it, you could create a mediaformat column as suggested before. You >could >leave the original title as is, if you want, or go to the cleaned title. I >see no way around doing at least this. > >Of course, once you have done that, the question is why you don't have a >relational database with one table that holds videos where each row is a >unique identity, and another table that holds stock, indicating, among >other >things, what media format the stock item is. > >If you don't split the table like this, I would still recommend that you >create some sort of internal unique ID that you use to identify a movie >entity. Others might know more on this issue, but my guess is that >comparing titles (even after the cleaning described above) will be slower >than comparing numeric values, thereby leading to faster joins. > >HTH, >Matthieu > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Comparing two records within the query
Yes, this is exactly the thing I'm looking for. This works, though I am not getting all rows returned and I haven't quite figured why yet. I hate to rely on the titles being exactly the same. I have data where one title contains the words DVD while the VHS version doesn't. Thanks >From: "Cornillon, Matthieu (Consultant)" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Comparing two records within the query >Date: Wed, 8 Sep 2004 13:12:36 -0400 > >Another option is to do a self-join. I'll make some assumptions here that >may not be true, but which you can modify to fit the truth. Key among >those >is that you have column called VID_MediaFormat holding either DVD or VHS. >(I know you don't have this, but you seem to have some way of determining >media_type, so you can just edit this to fit.) > >SELECT V1.pkVID AS pkVID_DVD, V1.VID_Title AS VID_Title_DVD, V2.pkVID AS >pkVID_VHS, V2.VID_Title AS VID_Title_VHS, V1.VID_Title AS SortTitle >FROM VIDEOS V1, VIDEOS V2 >WHERE V1.VID_MediaFormat = 'DVD' AND > V2.VID_MediaFormat = 'VHS' AND > V1.pkVID <> V2.pkVID AND > V1.VID_Title = V2.VID_Title (+) > >UNION > >SELECT V1.pkVID AS pkVID_DVD, V1.VID_Title AS VID_Title_DVD, V2.pkVID AS >pkVID_VHS, V2.VID_Title AS VID_Title_VHS, V2.VID_Title AS SortTitle >WHERE V1.VID_MediaFormat = 'DVD' AND > V2.VID_MediaFormat = 'VHS' AND > V1.pkVID <> V2.pkVID AND > V2.VID_Title = V1.VID_Title (+) AND > V1.VID_Title IS NULL > >ORDER BY SortTitle > >Here's how it works. The first SELECT statement pulls out all DVD titles >in >the column called VID_Title_DVD, with matching VHS titles (if they exist) >in >VID_Title_VHS. The second SELECT statement puts all VHS titles WITHOUT a >matching DVD title into VID_Title_VHS, and leaves VID_Title_DVD null. So, >the first half gets titles with DVD only or DVD and VHS, and the second >half >gets VHS only. Finally, the ORDER BY clause uses the SortTitle column >(which is the same as VID_Title_DVD in the first SELECT statement and the >same as VID_Title_VHS in the second SELECT statement) to order it together. > >It should return a results list with two columns (plus other stuff) like >this: > >VID_Title_DVD VID_Title_VHS >Arthur (DVD) Arthur(VHS) >Benji (DVD) Benji (VHS) > CHUD (VHS) >Dave (DVD) >ET (DVD) ET (VHS) >Fresh (DVD) >Go (DVD) >Heat (DVD) Heat(VHS) > Ishtar (VHS) >Juice (DVD) Juice (VHS) > >Processing this on output should be easy. > >HTH, >Matthieu > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Comparing two records within the query
That may be possible. Though it's not always up to me to get the marketing dept and the DB people to do work so my life is easier. Nonetheless...The basic nature of this kind of compare is eluding me. Even if I had two records, one with DVD and one with VHS in the MEDIA_TYPE field, I'd still need to have some way to identify that while displaying the records. >From: "Bryan Stevenson" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: Comparing two records within the query >Date: Tue, 7 Sep 2004 13:52:17 -0700 > >I'd strongly advise you add a column called Media_Type and use VHS or DVD >as a media type codethat will make your life much easier ;-) > >Bryan Stevenson B.Comm. >VP & Director of E-Commerce Development >Electric Edge Systems Group Inc. >phone: 250.480.0642 >fax: 250.480.1264 >cell: 250.920.8830 >e-mail: [EMAIL PROTECTED] >web: www.electricedgesystems.com > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Comparing two records within the query
Here's the dilemna: I have a catalog of videos I want to list. The product ID's indicate whether the video is VHS or DVD. For example -01 = The Teletubbies meet Jason (VHS) -03 = The Teletubbies meet Jason (DVD). Two records for each title if available in both media. In the list I want only one record displayed, the user chooses via radio button VHS or DVD. But not all title are available in both formats. They could be either, or, or both. So the record would be displayed as: Title - Media (if only one) Choose media (if both) - $price In the query, how can I create a flag that indicates that an id number has a partner record which indicates a video is available in both formats? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFHTTP, Struts and some other stuff...
I apologize in advance if my question isn't detailed. I confess I'm not too familiar with an application I inherited but still must troubleshoot. I have an app written in a combo of CF (CFMX 6.1 on Win2000, IIS) and Java using struts. Most of the work is being done in Java with CF doing the output and controls. The calls are mostly being made via CFHTTP and output with CFHTTP.Filecontent. The problem is the app runs EXTREMELY slow. I am having a hard time debugging where the bottleneck is. Whether it's the queries, which don't show in CF debug since they're done in java, or whether it's a throughput issue resulting from passing too much data through CFHTTP. Any guidance on where to get info to help debug is greatly appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Mail in Undeliverable Folder
Due to an IP change on our server and an application that didn't get updated I have quite a number of emails in the undeliverable folder that I would like to send out. Has anyone converted these and drop them in the spool so they get sent? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Web Team Project Management App
I've been using proworkflow www.proworkflow.com It's a good product and they are very responsive. >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Web Team Project Management App >Date: Fri, 06 Aug 2004 18:15:45 + > >Our company is moving from a one man to a three man development team. I >would looking for an application that we could use preferable built in CF >to help manage incoming project requests and track the progress/stage of >each developer. > >Does anyone have any advice or read any good articles about CF team >management? We all know how difficault it can be to manage developers. > > >Thanks > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Finding good developers
Thanks all for the suggestions. In my experience, my best candidates have been those with whom I've been able to have good discussions with. My interviews are very informal. As one suggestion noted, though someone might not know what MVC stands for, if they can articulate work they've done that results in a certain method, then they probably can produce good code. On sourcing though, other than a site like Craigslist, what have been your best sources for candidates? Newspaper ads? Monster.com? Other job sites? Recruiters? >From: "Burns, John D" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Finding good developers >Date: Wed, 30 Jun 2004 16:48:41 -0400 > >One final addition and then I'll shut up... > >I've been asked by a previous employer what I am most excited about >learning or what new CF functionality am I currently playing >with/learning/using that excites me. This will let you know if the >person is attempting to grow and learn or if they're just someone who >has been doing it for years and sometimes if they "know it all". I >personally value someone who is trying to learn as much as they can (and >seems to retain most of it) over someone who is really good at something >that is out of touch with new trends and technologies. > >John Burns > >-Original Message- >From: Whittingham, P [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 30, 2004 4:11 PM >To: CF-Talk >Subject: RE: Finding good developers > >If you are looking for example for a Cold Fusion developer, find years >of experience in html/css/_javascript_/dhtml and Cold Fusion along with >lots of sqlstored procedures. Then ask several questions from easy to >hard questions on those areas, giving your staff to help create the >questions. They will at least get an idea of the potential applicate. >Also, graphic tools (Photoshop/Fireworks) questions might be good also. >Asking for their previous work might be hard for the applicate, since >his/her work might be the property of his current employer. I've been >involved on both side over the last 25 years and a 'good' developer can >sometimes 'sense' a another good one. > >- Pat > > > > >From: B G [mailto:[EMAIL PROTECTED] >Sent: Wed 6/30/2004 1:24 PM >To: CF-Talk >Subject: OT: Finding good developers > > >Not to say that this list isn't stocked with good developers! > >But...As my department is growing my need to find good staff is >increasing. >I need to find good resources for both full-time positions and temporary >contract/project based openings. My experience with headhunters has >been very consistent. They're pushy and they don't really care about my >staffing needs as long as I place someone. Can anyone offer some advice >on companies that offer staffing solutions or other similar resources? >Any thoughts on this are greatly appreciated. For local info I am >located in Chicago. > >Thanks! > >BG > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Finding good developers
Not to say that this list isn't stocked with good developers! But...As my department is growing my need to find good staff is increasing. I need to find good resources for both full-time positions and temporary contract/project based openings. My experience with headhunters has been very consistent. They're pushy and they don't really care about my staffing needs as long as I place someone. Can anyone offer some advice on companies that offer staffing solutions or other similar resources? Any thoughts on this are greatly appreciated. For local info I am located in Chicago. Thanks! BG [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
How to output last line first
Has anyone tried to present the output of a process so that the last line is at the top of the page? For example, I have a process that runs through thousands of records, I want the user to observe the results of each record. In the CFLOOP I can CFFLUSH and print the results, but by default each new line is at the bottom of the page, thus creating a situation where the user will have to scroll to the end repeatedly. But if that last result is printed at the top, the first records completed will be pushed to the bottom of the page and the user will not need to scroll at all. Thanks. BG [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Macromedia.com running on top of Mach II
This thread has been interesting for a number of reasons. I read most of the posts offered on this list because there is quite often a nugget of knowledge I glean whether the thread addresses a specific issue I happen to be dealing with. I've learned a lot from those of you who have been most vocal on this issue. I wouldn't pretend to be qualified enough to know the intent of MM's decision to use one methodology or one technology over another. But it's a simple fact that knowing they have evaluated Mach-II and implemented it in parts of their site raises its value next time I need to make a similar decision. BG [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX 'bug'? Easy to crash CFMAIL.
>It's not a bug in CFMX, but rather your app. If your app thinks "foo@ >bar.com" or "foo@@bar.com" is a valid email address and lets someone enter >it, your app is broke. I don't agree fully with this. While I validate new emails on the forms I create, I don't always have control over new data. Lists can be imported, other staff can access the database from the backend etc. Old bad data lives on despite our best efforts. I got hit with this one immediately after upgrading to 6.0. I'm surprised more people haven't complained. But I addressed it as an annoyance, validated emails as they are being input AND as they are being sent, and flagged bad ones to not be sent to in the future. It was surprising that what seemed to work well in 4.5 didn't work well in MX. But, for me it was an education, I wasn't diligent enough about allowing garbage in. BG >From: Thomas Chiverton <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: CFMX 'bug'? Easy to crash CFMAIL. >Date: Tue, 20 Jan 2004 17:05:37 + > >On Tuesday 20 Jan 2004 16:57 pm, Adam Reynolds wrote: > > Thomas, > > Technically it is a bug. Cfmail should not throw an exception when >passed > > an email address (no matter what the content) Particularly if this is a >new > > bug introduced into 6.1 > >It wasn't being passed an email address though, was it, which was my point. >It was therefore within it's rights to throw an exception. The change in >behaviour should have been documented, I agree. > >Also, though, Matt's testing should have caught this - because we test with >real world data don't we :-) > >There is also a general rule about app design that goes along the lines of >"try/catch any interaction with outside systems" - that would be things >like >mail servers, databases and fax machines. > > > Your email didn't help and the tone of it was derogatory. This list is > > there for people to help each other. Please respect that. > >And I've both given and recieved it. > >-- >Tom Chiverton >Advanced ColdFusion Programmer > >Tel: +44(0)1749 834997 >email: [EMAIL PROTECTED] >BlueFinger Limited >Underwood Business Park >Wookey Hole Road, WELLS. BA5 1AF >Tel: +44 (0)1749 834900 >Fax: +44 (0)1749 834901 >web: www.bluefinger.com >Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple >Quay, BRISTOL. BS1 6EG. >*** This E-mail contains confidential information for the addressee >only. If you are not the intended recipient, please notify us >immediately. You should not use, disclose, distribute or copy this >communication if received in error. No binding contract will result from >this e-mail until such time as a written document is signed on behalf of >the company. BlueFinger Limited cannot accept responsibility for the >completeness or accuracy of this message as it has been transmitted over >public networks.*** > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL - Selecting a Month
The DB is Oracle. What worked was more like: WHERE TO_CHAR(My_Date,'MM/YY') = '08/03' Thanks! >From: "J E VanOver" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: SQL - Selecting a Month >Date: Wed, 3 Sep 2003 16:00:16 -0700 > >Yep, should work. SQL Server Books Online says: > >MONTH >Returns an integer that represents the month part of a specified date. > >Syntax >MONTH ( date ) > > >Looks the same to me! > > >-Original Message- >From: B G [mailto:[EMAIL PROTECTED] >Sent: Wednesday, September 03, 2003 1:57 PM >To: CF-Talk >Subject: OT: SQL - Selecting a Month > > >I know there is an easy answer to this that's escaping me at the moment. > >CF has a function Month() which will pull the number of the month out of a >date. Is there a similar function to use in a SELECT statement that works >the same way? > >Here's what I want: > >SELECT My_Date >FROM All_Dates >WHERE Month(My_Date) = 8 > >Returns all entires from All_Dates that are August. Easy? > >Thanks! > >BG > >_ >MSN 8: Get 6 months for $9.95/month http://join.msn.com/?page=dept/dialup > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
OT: SQL - Selecting a Month
I know there is an easy answer to this that's escaping me at the moment. CF has a function Month() which will pull the number of the month out of a date. Is there a similar function to use in a SELECT statement that works the same way? Here's what I want: SELECT My_Date FROM All_Dates WHERE Month(My_Date) = 8 Returns all entires from All_Dates that are August. Easy? Thanks! BG _ MSN 8: Get 6 months for $9.95/month http://join.msn.com/?page=dept/dialup ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Application Development/Documentation
As our applications get more complex, documenting new apps, and mods to existing apps is becoming increasingly important. It's time to abandon the old "notes on napkins" methodoolgy for something a little better. Does anyone use a documentation tool for recording details of complex applications? Maybe a standard set of forms? Any recommendations are greatly appreciated. BG _ MSN 8: Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
TEST - Please reply *at least once
Sorry to do this to you all, but I haven't seen any of my messages or responses in the last few days. Thanks! _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
OT: Chat Server Software
Anyone have a recommendation for Chat Software? I worked with Chatspace quite a few years ago and remember it being relatively good. They still appear to be well regarded. We have Fusetalk Pro but the chat leaves a bit to be desired. Thanks! BG _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Separating IIS from CF
What kind of traffic would one expect to see to make a distributed mode installation necessary or at least prudent? BG >From: Matt Robertson <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Separating IIS from CF >Date: Thu, 07 Aug 2003 15:38:52 -0400 > >Tony wrote: > >can you? > >Yup you can. Its CF in 'distributed mode'; isn't that the term? Not clear >on the ramifications other than spreading load around. :) This came up in >here a few weeks back. I'll bet an archive search has a shot at finding >something. > >--Matt-- > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Mach II 1.0 released
Has anyone noticed www.mach-ii.com not available? 8-13-03 5pm Central Time. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Querying a text file
Thanks- I've got a couple options to import the file directly into the db without using cffile. That's a good thing. What this discussion has done, though, is presented the problem of preventing a user from uploading a file that's too big to begin with. It seems there are two solutions. One is an expensive utilitiy from http://www.softartisans.com/. I've also seen a couple applets that can read a file size before it's uploaded but they require the user to download the applet first. I'd like the process to be seamless to the user but safeguarded for us. BG >From: "Mark Stewart" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Querying a text file >Date: Fri, 1 Aug 2003 14:34:56 -0400 > >Couple days late on this, but... I usually use SQL Server DTS packages to >do my heavy file lifting - I set-up a connection to the file and place the >contents into the db. If I'm not worried about real time data, I schedule >the package. You can also run a dts package through cf using COM. You >really don't want to use cffile with what you're doing. I don't know if >you're using sql server or if your host will allow you to utilize dts >packages (probably not), but it's worth a try. > >Mark > > >-Original Message- >From: B G [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 30, 2003 5:40 PM >To: CF-Talk >Subject: Querying a text file > > >I am building an application where users can upload a comma delimited text >file to a unique user directory then retrieve the data from it for later >use. The structure of the file will be pre-defined and the users must >follow that format. Field names are included in the first row. > >I had intentionally decided not to import that data from the text file into >a table because of the file size. Reading the contents of a file with >CFFILE puts the entire contents into a variable which takes up memory. 100 >users all working with 10 meg files at the same time could cause a problem. > >But I am finding that no host will offer to support a text ODBC connection. >I even had one tell me it couldn't be done. Also, a few have stated that >querying a text file is too flaky to be considered reliable. > >Has anyone had any experience similar to this? Am I worrying about using >too much RAM unnecessarily? Perhaps a more efficient way to get the >contents of the text file other than CFFILE? > >Thanks! > >BG > >_ >Add photos to your e-mail with MSN 8. Get 2 months FREE*. >http://join.msn.com/?page=features/featuredemail > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF tag for highlighting text in a textfield?
I've been looking into a similar function myself. I would like to stay away from adding a rich text editor to the form. I'm starting to lean toward a Message Board Markup Language. Anyone have any insight? BG >From: [EMAIL PROTECTED] (Rafael Alan Bleiweiss) >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: CF tag for highlighting text in a textfield? >Date: Fri, 01 Aug 2003 11:52:00 -0500 > >Anyone ever do this or know of a custom tag? > >I've got a form that needs to be checked against a list of bad words, and >the refresh of the page needs to have the text in the textarea with the >matched bad words highlighted in bold or red font... > >What's it take to do this? > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Querying a Text File vs An MS Access Table
Interesting, but my real question is the performance issue. With large files and simultaneous users, will using CFFILE to read the file and importing to a table choke a machine even with a good amount of RAM? BG >From: "Ryan Emerle" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Querying a Text File vs An MS Access Table >Date: Thu, 31 Jul 2003 12:23:58 -0400 > >Here's a CFX tag that imports any type of delimited files and converts them >to a CF query. It's mighty fast.. > >http://www.insapi.com/products/development_tools.cfm#cfx_textimport > >Perhaps it is something that would be useful? > >-Ryan > >-Original Message- >From: B G [mailto:[EMAIL PROTECTED] >Sent: Thursday, July 31, 2003 12:19 PM >To: CF-Talk >Subject: Querying a Text File vs An MS Access Table > > >I am building an application where users can upload a comma delimited text >file to a unique user directory then retrieve the data from it for later >use. The structure of the file will be pre-defined and the users must >follow that format. Field names are included in the first row. > >I had intentionally decided not to import that data from the text file into >a table because of the file size. Reading the contents of a file with >CFFILE puts the entire contents into a variable which takes up memory. 100 >users all working with 10 meg files at the same time could cause a problem. > >But I am finding that no host will offer to support a text ODBC connection. >I even had one tell me it couldn't be done. Also, a few have stated that >querying a text file is too flaky to be considered reliable. > >Has anyone had any experience similar to this? Am I worrying about using >too much RAM unnecessarily? Perhaps a more efficient way to get the >contents of the text file other than CFFILE? > >Thanks! > >BG > >_ >Add photos to your messages with MSN 8. Get 2 months FREE*. >http://join.msn.com/?page=features/featuredemail > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Querying a Text File vs An MS Access Table
I am building an application where users can upload a comma delimited text file to a unique user directory then retrieve the data from it for later use. The structure of the file will be pre-defined and the users must follow that format. Field names are included in the first row. I had intentionally decided not to import that data from the text file into a table because of the file size. Reading the contents of a file with CFFILE puts the entire contents into a variable which takes up memory. 100 users all working with 10 meg files at the same time could cause a problem. But I am finding that no host will offer to support a text ODBC connection. I even had one tell me it couldn't be done. Also, a few have stated that querying a text file is too flaky to be considered reliable. Has anyone had any experience similar to this? Am I worrying about using too much RAM unnecessarily? Perhaps a more efficient way to get the contents of the text file other than CFFILE? Thanks! BG _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Querying a text file
I am building an application where users can upload a comma delimited text file to a unique user directory then retrieve the data from it for later use. The structure of the file will be pre-defined and the users must follow that format. Field names are included in the first row. I had intentionally decided not to import that data from the text file into a table because of the file size. Reading the contents of a file with CFFILE puts the entire contents into a variable which takes up memory. 100 users all working with 10 meg files at the same time could cause a problem. But I am finding that no host will offer to support a text ODBC connection. I even had one tell me it couldn't be done. Also, a few have stated that querying a text file is too flaky to be considered reliable. Has anyone had any experience similar to this? Am I worrying about using too much RAM unnecessarily? Perhaps a more efficient way to get the contents of the text file other than CFFILE? Thanks! BG _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cf hosting - CFFILE
I just looked at them. Go to http://www.readyhosting.com/ and hit the Cold Fusion MX Plan Details link. It appears they do allow CFFILE. BG >From: "mayo" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: cf hosting - CFFILE >Date: Tue, 29 Jul 2003 17:29:09 -0400 > >I've been using readyhosting. I recommend it for low-end CF hosting. >They're >very reliable. However they do not support CFFILE. (surprise, surprise) > >Does anyone know of a good low-end host (100-150/year) that supports >CFFILE. >I have a client for whom CFFILE would be perfect but I don't think that he >would go for paying substantially more for hosting than he is currently. > >Gilbert Midonnet > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cf-talk@houseoffusion.com
Hey all! I am building an application that will accept comma delimited files of a standard format from a variety of users which need to be processed and inserted into a database. My concern is the text files may at some point in the future become too large to "Read" using CFFILE since this tag stores the contents in memory. What would be considered too big? By my guesstimating a 5meg text file roughly equals 70K records (the size I expect to see initially). 100 users could be uploading and processing at the same time meaning 500meg of RAM is being utilized. My server has 1 gig of RAM so this doesn't appear problematic at the moment. Am I considering all the important angles? I read about a possible alternative in the archives making the uploaded text file a datasource. An interesting option but I don't see how that would work considering I will have multiple users running concurrently. Each uploaded file would need to be named uniquely with the user's User_ID and Session info. Any other options? Thanks! BJG _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any one find a fix for the "null null The error occurred on line x" error?
Do you have Client Variables on? >From: "Mark W. Breneman" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Any one find a fix for the "null null The error occurred on line >x" error? >Date: Thu, 5 Jun 2003 11:43:59 -0500 > >I just installed updater 3 hoping this "null null" problem would go away. >But, just got three in a row from the same IP address (same user). > >The error simply says: >null null >The error occurred on line 4. > >There is no cf code on that line. >only Welcome to urbana.org > >I get this error on different pages. Not just the index.cfm page. > >Any thoughts? > > > >Mark W. Breneman >-Macromedia Certified ColdFusion Developer >-Network / Web Server Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Troubleshooting Performance - CFMX
Can someone tell me if they've seen the following behavior and if this is normal. All of this is related to the CPU maxxing out at 100% and the whole JRUN.exe problem. The following situation is easily repeatable on my server: I monitor Task Manager and CFSTAT at the same time. When CPU usage stays in the 75%-100% range, requests running NEVER goes below 1. Frequently it rises until the 25 limit where they go to queue. At this point I turn off IIS and the CPU stays the same, roughly 50%-75% and Requests Running will eventually dwindle back to one. But never back to zero. How can a web server, which is not serving ANY pages to ANYONE, see such CPU use? And what request remains? There is no other activity on this box when IIS is off. I've tried nearly all the suggeestions I've read, except for uninstalling and reinstalling IIS. I've got updated Oracle drivers, I've updated to Sun's JRE 1.4, I've got all the updaters, all the IIS patches... I'm at a loss. Even those who have paid MM for tech support don't seem to have an answer. Any ideas? Thanks! BG _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Web Server Machine Specs
Yes, thanks. I have seen that too with a bad connection between Oracle and the web server. I should have noted it is an IIS/Win2000 box. CFMX with all the updaters. Task manager shows jrun.exe to be the worst culprit of usage. Taking nearly 100% at times. >From: Andre Turrettini <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Web Server Machine Specs >Date: Fri, 30 May 2003 14:29:26 -0600 > >I'd check your database. It may of grown and slowed down. Make sure any >client var table isnt too big and not in registry. If the code hasnt >changed and there arent more users and the apps on the server havent >changed, then its either something accumulating on the server or something >external and thats often the database. > >DRE > > > -Original Message- > > From: B G [mailto:[EMAIL PROTECTED] > > Sent: Friday, May 30, 2003 2:17 PM > > To: CF-Talk > > Subject: OT: Web Server Machine Specs > > > > > > I've got a web server that has been running well until > > recently. Suddenly I > > see maxed out CPU usage and CFSTAT shows requests go to queue > > frequently > > which results in bad lag on the site. There hasn't been any > > significant > > change I can track to this. I'm wondering if the machine has > > simply lived > > it's useful life. > > > > Site stats: > > > > 12 million hits/month > > 350K user sessions/month > > Heavy CF use > > > > The machine is a Dell, dual pentium 800's, 2 gig ram. Memory > > usage is nill. > > > > Any ideas if this traffic could be bogging down a machine like this? > > > > Thanks! > > > > _ > > Protect your PC - get McAfee.com VirusScan Online > > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Web Server Machine Specs
I've got a web server that has been running well until recently. Suddenly I see maxed out CPU usage and CFSTAT shows requests go to queue frequently which results in bad lag on the site. There hasn't been any significant change I can track to this. I'm wondering if the machine has simply lived it's useful life. Site stats: 12 million hits/month 350K user sessions/month Heavy CF use The machine is a Dell, dual pentium 800's, 2 gig ram. Memory usage is nill. Any ideas if this traffic could be bogging down a machine like this? Thanks! _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4