Re: Macromedia's destruction of the Allaire Site...
The "jsp" isn't Java Server pages, it's Broadvision, which is a JavaScript-based server that is outrageously expensive and slow as molasses. tom "Bud" <[EMAIL PROTECTED]> wrote in message news:p04320404b878b5c8747d@[192.168.0.1]... > On 1/26/02, tom muck penned: > >Also, everything on the MM site seems to take forever. Turn off the Flash > >and give me the information quickly. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Macromedia's destruction of the Allaire Site...
Great news Matt. I can see that the 3 days is for the fumigation of the machines. It's going to take that long to get the stink out from Broadvision. ;-) tom "Matt Brown" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > We announced this downtime in our forums and I did not do so here. It was > my fault that an announcement wasn't made. I will after this note. > > Now in our defense, the whole web team at MM *IS* the old Allaire team and > it is being DIRECTLY run by Jeremy Allaire and none other. Please lets just > end the MM vs Allire stuff, it is pure fantasy. > > What are we doing taking the site down? > > The downtime is not to do any small maintenance, it is a complete switch > off of Broadvision to a different ECRM system. No one here was happy at all > with bringing so much functionality down for that long, but it has to be > done in this case. Most of the site is fine, but anything that has to do > with membership is down and that is the problem you all are running into. > > If you have been to the Exchange and ever tried to download an extension, > you are familiar with some of the pain that our customers were going > through. This switch is one of many that will lead to us using CF for all > the parts of our site and that is a good thing and frankly is more > important for you on this list than any other MM customer segment as it > will help you point to a large site that is build entirely with MM products. > > Please have patience with us and know that we are not just doing dumb > things like this for no reason. > _ > > Matt Brown Community Manager > Macromedia (650) 481-4525 [EMAIL PROTECTED] > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Macromedia's destruction of the Allaire Site...
Fixing is one thing, but haven't these guys heard of staging servers? ;-) Also, everything on the MM site seems to take forever. Turn off the Flash and give me the information quickly. tom "Paul Hastings" <[EMAIL PROTECTED]> wrote in message 006901c1a63b$1af15770$[EMAIL PROTECTED]">news:006901c1a63b$1af15770$[EMAIL PROTECTED]... > this was posted a couple of days ago in the forums. i suppose > the announcement got lost as they don't have a blurb > specific forum anymoremaybe they're fixning all the stuff > we're complaining about. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: split (pardon my crap but this is french)
Stomp away. I've been corrected 4 times now, admitted the error of my ways, and posted a function that will do the split like a vb split function. Do you forgive me? ;-) I assumed that because I had it working like this in a page, that it was correct. I do it like that in VB, and assumed it to be similar in CF. tom "Brendan Avery" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > hey hey hey now. microphone check it, yo. i'm gonna have to strap on > my > correction boots and do a little stomp-down; > > the ONLY reason your example worked is that the delimiters are CASE > sensitive. what really happened is that <,>,P, and I all delimited > empty > string values when in sequence, so those values were not appended to > the > array. HOWEVER, try changing your myvar to this and watch what > happens: > > > > then scratch your head and go take so more french classes. > > *smooches* __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Mail Tag for Heavy Volume of Emails?
If you have a good dedicated mail server, is excellent. I've sent 400,000 in a day with no problems, other than the 65,535 email limit in the spool folder. You can break a job into several jobs of 50-60,000 each and let them fly. tom "Rey Bango" <[EMAIL PROTECTED]> wrote in message 009901c19562$f7002500$[EMAIL PROTECTED]">news:009901c19562$f7002500$[EMAIL PROTECTED]... > Anyone know of a 3rd party tag that can handle large volumes of email? > CFMail just isn't suited for mass emails and I wanted to go 3rd party. > > I looked at ActivMail but I can't get the guys from CFDev.com to reply. Any > other tags out there that you may know of? > > Thanks, > > Rey... __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Using CF to control Spam
Most spam comes from things that you sign up for on the Web, whether you realize that you are signing up for spam or not. I've had this email address for two years now and still only get one or two spams per day -- on a bad day. Certainly managable by spending the 1 or 2 seconds to hit the delete key. My email address is plastered all over my Web site, plus I post several hundred times per month in various newsgroups to the point where a search on Google lists my email address 3900 times. If spammers are harvesting email addresses from mailing lists and newsgroups, they are skipping mine. ;-) If you are careful about what you are signing up for, you can virtually eliminate spam. When you register at a Web site or register a product make sure you aren't leaving the default checkbox for "allow us to notify you of exciting offers from our co-conspirators/spammers" unchecked -- most sites have this spam button set ON by default. tom "W Luke" <[EMAIL PROTECTED]> wrote in message 007b01c191fe$faee5a90$0300a8c0@jazz">news:007b01c191fe$faee5a90$0300a8c0@jazz... > My inbox has become increasingly infested with spam - up to 30 a day now - > so I've been writing a small app in CF to help control it. Basically, the > robot logs into my current spam-infested inbox and checks each email against > a "trusted addresses" table in my db - if the email is from a trusted > source, it's sent to another "clean" POP. If it's potentially spam, a > message is sent to the sender and the email is quarantined in the db - if > that sender is a real person, they'll click on a link which will validate > their email address, add it to my "trusted addressbook" and deliver their > email to my clean POP. > > It works well, but it's annoying having to have another POP - can anyone > think of a better way of doing it? > > Will __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AOL and CFMAIL
You can get AOL for $4.95 a month if you limit your online activity to 3 hours a month. That's usually enough for testing. tom > I don't know if that's possible, and I don't know how useful that kind of > test would be anyway. To ensure that something works acceptably through AOL, > you'd really have to have it go through AOL - through their network and > proxies. An AOL account is just one of the costs of testing. ~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT Dreamweaver, Sorry
Do you have virus protection turned on? If so, try turning it off and starting it up. Virus protection will cause DW to take a long time to load. My copy of UltraDev typically runs about 50K of memory. tom <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > My apologies for the OT but this is one of the few places i get answers. > > We recently started using Dreamweaver 4 as a standard intranet app. I have > it loaded on a 1Ghz pentium w/256 MB RAM. I have it mapped to a VERY large > intranet site. the local root folder is a mapped network drive. > > Now the problem, it is taking FOR EVER to fire up dreamweaver on my pc. > when it starts it fires up @ about 8 MB of memory usage and balloons while > it's launching. i've let it run all the way up to 35000K according to the > NT task manager. at 35K of memory it showed no signs of stopping. I end > up killing the PID and now i'm stuck. > > how much memory does this thing need? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Datasources
Is there an easy way to get a list of ODBC datasources on the server through ColdFusion? Also, given a datasource, is there a way to get a list of tables from that datasource? tom ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
The only thing worse than spam is that nazi-like ORBZ. tom "Paris Lundis" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > yeah we have had problems with ORBS... weirdly it called one of our servers > open somehow because we customarily bounce bad mail back or have a responder > reply that the account has moved or is invalid... whatever, no relaying... > or so it says in my configuration.. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FAIL Spooling
How's the speed of CFFILE when used in big mailings? Have you tried it with 50,000 + emails? I tried out a custom tag that used CFFILE to send mails, and it was painfully slow. Using CFMAIL I can execute huge numbers of queries and send mails to my mail server quickly. The only bottleneck is the spool folder. tom > You can also use CFFILE to write directly to the Microsoft's SMTP server > pickup directory. We do this and it works great. Set up the SMTP server > purely as a relay off to a "real" mailserver, and messages fly off the > machine. Plus you are allowing the right tool to do the right job. CF > isn't a mass mailing server, it's an application server. A server designed > specifically for handling email is virtually always going to beat one that > just "also features" email capability. > > -Cameron > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Merant Text Driver: how to specify pipe character?
Yes, I did some playing around with it yesterday. Even if you specify a Delimiter=| in the connection string box of the CF Administrator, it doesn't add the parameter to the registry. It seems that it can only be done with the ODBC Administrator on the machine. tom <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > But if you look at the Merant Text Driver in the Win2K ODBC Data Source > Administrator it provides an input box to specify your delimiter character. > > Marc > > "tom muck" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I think that with the Merant driver you are limited to the delimiters in > the > > TableType drop-down box. If you look at the registry entries for a sample > > Merant driver, there aren't any other options for delimiters. > > > > tom > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL Spooling
We frequently run up against the limit. In fact I have a 400,000 email job coming thru this week. I would love to see the spool system improved to allow multiple spool folders and faster delivery to the mail server. My mail server is idle most of the time, even when sending huge jobs thru CF. When I send a huge job, I split it into 50,000 emails per drop. You can rename the files in the spool folder, so that CF still has room to add more. I suppose that 64K is far too many files to be handled by the Windows file system anyway. tom "Jim McAtee" <[EMAIL PROTECTED]> wrote in message 037201c17c68$31df10f0$352fa8ce@jim">news:037201c17c68$31df10f0$352fa8ce@jim... > Thanks, Tom. Not even through a registry setting, eh? > > Looks like any CF applications we had written for CF4 which were doing a > self-paced delivery of messages should be rewritten. There's not much sense > in it if CF has a maximum delivery speed of 400 messages per minute. I > suppose 24,000 messages per hour is reasonable, but if you've got the > processing power and adequate bandwidth, I don't understand why they'd want > to impose this limit. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL Spooling
There is no setting for the number of emails. The spooler delivers 100 mails every 60 seconds. You can change the interval to 15 seconds, but no lower. Also, there is a limit of 65,535 emails that can be delivered to the spool folder at one time. tom www.basic-ultradev.com "Jim McAtee" <[EMAIL PROTECTED]> wrote in message 02b501c17c57$ec7da220$352fa8ce@jim">news:02b501c17c57$ec7da220$352fa8ce@jim... > In the CF5 Administrator there's a parameter that controls how often the > server checks the mail spool. Is there a fixed number of messages that CF > relays to the mail server in each interval? Doing a mass mailing (40k > messages), it seems that mail is moving rather slowly from the CF spool. > The mail server being used is _very_ idle and could easily be relaying > messages faster. Is this a registry setting, or is there something else > limiting how fast CF moves these messages? > > Jim > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Merant Text Driver: how to specify pipe character?
I think that with the Merant driver you are limited to the delimiters in the TableType drop-down box. If you look at the registry entries for a sample Merant driver, there aren't any other options for delimiters. tom <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Thanks Tom. I thought about that, but I couldn't find any support docs at > Allaire or Merant to tell me the syntax for specifying a pipe delimiter. > > Marc Garrett > > "tom muck" <[EMAIL PROTECTED]> wrote in message > 3c0b956d$[EMAIL PROTECTED]">news:3c0b956d$[EMAIL PROTECTED]... > > You should be able to enter additional parameters from the CF > Administrators > > at the bottom of the CF Settings page, you can enter connection strings: > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Merant Text Driver: how to specify pipe character?
You should be able to enter additional parameters from the CF Administrators at the bottom of the CF Settings page, you can enter connection strings: "- Use this option only to add connection attributes that cannot be included in the ODBC data source definition. " tom www.basic-ultradev.com <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Thanks for the tip Jim. That works on my development machine, but I don't > think I can make the change to my production server (shared). > > Marc Garrett > > "Jim McAtee" <[EMAIL PROTECTED]> wrote in message > 010701c17abd$5a0aa820$352fa8ce@jim">news:010701c17abd$5a0aa820$352fa8ce@jim... > > It looks like in the CF Administrator's ODBC editing for the Merant Text ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Server Upgrade Ent or Pro?
Absolutely. Pro is fine if all you're running is SQL Server and one CF box. That's all we have here with no problems whatever, using both ODBC and OLEDB. tom www.basic-ultradev.com "BILLY CRAVENS" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > If you're not doing hard-core clustering, or running native Oracle drivers, > I've found Pro does the job. I'd guess that 75% of the Enterprise sales are > due to the word "Enterprise" in the title - desk monkeys and power-lunch > puppets really like that word. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DreamWeaver UltraDev 4 and CF Studio
Go to www.massimocorner.com for a set of ColdFusion objects for UltraDev that make it easier to work with, and also his Snippets extension to UltraDev, which allow you to work with snippets created in Homesite/CFStudio. If you use the two programs together you'll get the most for your money. UltraDev takes a little getting used to -- especially the floaty windows -- but you can do things in it that you can't do in CF Studio, such as applying rollover behaviors, javascript functions, adjusting table widths, inserting and optimizing images, turning complex code into point-and-click server behaviors, and doing complex recordset navigation easily. Having the button on Studio makes it easy to go back and forth. tom "Larry Juncker" <[EMAIL PROTECTED]> wrote in message 001701c16eef$83873580$2354ead1@HEARTLAND">news:001701c16eef$83873580$2354ead1@HEARTLAND... > Thanks - That was kind of what I had come to the conclusion of, Worthless > unless you totally use WYSIWYG > > I like to see what I am coding, so I guess I just stick with Studio. > > I guess I still don't see why they have the link to UD in Studio either, > what purpose does that solve? ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JavaScript book recommendation
My mistake. Just checked Amazon and it is saying December 15 for the new edition: http://www.amazon.com/exec/obidos/ASIN/0596000480/basicultradev-20 tom "tom muck" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > The 4th edition is out, but I haven't seen it in the stores yet. It was > released just this month I believe. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JavaScript book recommendation
The 4th edition is out, but I haven't seen it in the stores yet. It was released just this month I believe. tom www.basic-ultradev.com > You know offhand if it's being updated soon? I believe the last version > was the 3rd edition, and that came out in 98, right? (Sure, I know most > if it still applies, but it's almost 2002. ;) > > === > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JavaScript book recommendation
The best reference out there currently is the Wrox Programmer's Reference. If that's what you need, that's the book to get. There are a lot of good JavaScript books out there though, like JavaScript Bible (more of a tutorial/reference) and JavaScript: Definitive Guide (great overall intro to JavaScript). tom "Aidan Whitehall" <[EMAIL PROTECTED]> wrote in message A541FA096511D511BA0300D0B7B63A5F1E3270@whipsnade">news:A541FA096511D511BA0300D0B7B63A5F1E3270@whipsnade... > What JavaScript books can you recommend? I probably don't need a "dummies" > guide, but don't want something that's only useful as a reference. > > > > Thanks > > -- > Aidan Whitehall <[EMAIL PROTECTED]> > Macromedia ColdFusion Developer > Fairbanks Environmental +44 (0)1695 51775 > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dbtype=dynamic and mysql
I know nothing of Linux, sorry. The dynamic dbtype is an ODBC DSNLess
string, and I don't know if that is even possible on a Linux machine. Maybe
someone else can enlighten us.
tom
"Erik Retz" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Tom,
>
> Thank you. It works fine with CF 5 for windows, but not on linux.
>
> The following works on windows:
>
> DBTYPE="dynamic"
> CONNECTSTRING="driver=
>
{mysql};database=sw;server=209.206.185.132;uid=username;pwd=password;option
> =16386;">
> SELECT id from stores
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dbtype=dynamic and mysql
http://www.basic-ultradev.com/articles/dsnlesscoldfusion/index.asp tom "Erik Retz" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello, > > Anyone know the correct syntax for setting the connectstring to create a > dynamic db connection for MySql? I found info on access, MsSql and > Oracle, but no MySql. I'm trying to do some testing on a remote box that > I don't have cfadmin privileges on. > > Thanks. > > -Erik ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFID & CFTOKEN
You can put some code in your Application.cfm to automatically log out a user if they close a browser: tom www.basic-ultradev.com > 2) Does anyone know any JavaScript that will stop a user from clicking > the Close button on their browser, and bring up an alert telling them > they must log out? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: i don't understand cflock? can you explain it?
Yes, that is a read. If you even mention the variable name under your breath you should put a read only lock on it. If you are setting the variable put an exclusive lock on it. tom "David Green" <[EMAIL PROTECTED]> wrote in message 006e01c16b9e$83277310$c8c1fcd0@davidxp">news:006e01c16b9e$83277310$c8c1fcd0@davidxp... > Another question on understanding CFLOCK. when you say reading the > variable what is considered a read. Any time you use the variable say in a > cfoutput. Is this a read and should be locked? > > Thanks > David ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: still confused re locking
Put them into temporary page-level variables and lock them when transferring the values, so that you don't have to lock the query -- that is bad practice. Something like this: SELECT User_ID, nickname, expiry_date FROM tbl_client WHERE user_id=#variables.temp# As to your second situation, you could use the same approach: tom www.basic-ultradev.com "Seamus Campbell" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > I'm still confused over locking! > > I have this sort of query > > SELECT User_ID, nickname, expiry_date > FROM tbl_client > WHERE user_id=#SESSION.user_ID# > > > I should lock the #SESSION.user_ID# but am I right in thinking that locking > the whole query is wasteful? > > If so how do I get around this? > > What are the best practices? > > And what about hidden fields in forms eg > value="#SESSION.User_id#"> > > Lock the whole form? > Lock just the above line?? > > Any help would be appreciated (I have looked at Jim Schley's Best Practices > article and Ben Forta's article but they have confused me on the above 2 > points) > > Many thanks > > Seamus > ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Where does bounced email go?
You can use a with a FROM header if you want to control where the bounces go. CFMAIL will use the FROM attribute from the tag as a return-path header, and it will use your second from header as a from field. Here's some code to demonstrate: #message# The email will bounce to the [EMAIL PROTECTED] address if it fails, but the from and replyto fields will show [EMAIL PROTECTED] tom "Bruce Holm" <[EMAIL PROTECTED]> wrote in message 0aa201c16947$4dccb3a0$[EMAIL PROTECTED]">news:0aa201c16947$4dccb3a0$[EMAIL PROTECTED]... > If you send email out to a list using CFMAIL, where does bounces return > to? > > To the FROM field or the REPLY_TO field if both are present in the > outgoing header? > > - > Bruce Holm - Web Programmer > [EMAIL PROTECTED] > - > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion 5 UltraDev 4 - what is it?
Fairbanks & Pickford Beta? Not me. You have the wrong Tom. ;-) I get documents in all different formats -- mostly text-only or Word Perfect documents that have bullets, bold, italics, and underlining. Cut n paste into the design tab works wonders for that, especially considering that i only have about 30 minutes to convert a doc to HTML. tom "Neil Clark" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Tom, if my memory serves me correctly you were involved in the Fairbanks & > Pickford Beta programmes? Why are you using Cut n Paste for code? Surely the > Edit with DW is the option you should be utilising. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion 5 UltraDev 4 - what is it?
Unfortunately DW doesn't do the same thing that the design view of Homesite and CFStudio did. When you paste text into DW, all formatting is gone. When you paste text into the design tab, the formatting is preserved. I have to keep Homesite 4.5 on my computer to be able to have this functionality. I absolutely hate the fact that they removed the functionality from the program. tom "Neil Clark" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Spot, on. Dreamweaver is the tool for design and with Allaire and MM as > one, there is no need for duplication. > > Neil > Team Macromedia ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: locking within CFSCRIPT
> I still disagree, why should my greater application have or want to know > anything about how serviceAvailable() and related UDFs do the job they say > they will ? Because that's the way it is. You have two choices -- adapt your thinking and implement it the way that it works currently, or don't bother locking and risk the consequences. Rewrite your UDF in a way that makes sense for the current implementation of UDFs. ;-) When I first started CF I couldn't believe that I didn't have a way to call a function of my own design. I adapted my way of thinking and implemented code in a way that it worked. Now we have UDFs and there are a lot less hoops to go thru, but there still are a few hoops. We're still better off than we were a year ago. tom ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: can CF do multiple DB connection?
It sounds like you are confused by why the application.cfm has the DSN connection defined -- the main reason is so that you don't have to define it on every page and can change it in one place if you need to change it for any reason. If you want to use more than one, simply define more than one variable on the application.cfm page or hard-code the DSNs into the tags. You can have as many database connections as you need. Also, in CF 5 you can do a query of a query so that you can do queries across mulitple databases if you need to. tom "han peng" <[EMAIL PROTECTED]> wrote in message 003301c1654d$e04aa500$5b9a15a5@qubitsonyvaio">news:003301c1654d$e04aa500$5b9a15a5@qubitsonyvaio... > hi... ppl... > > i will like to check with u..ppl can cold fusion link to multiple > database at the same time..?? > > i noticed under application.cfm .. we normally put only 1 DSN connection. > > juz wonder.. is it possible to create multiple DSN connection..? and is it > possible to do multiple database query from a single query statement? > > hmm.. is there any gd website.. where i can find more info abt this..?!! coz > i need to do a recommendation which software to use for our new project. > > cheers > han > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMail Question
You can use either the query attribute of CFMAIL or a CFLOOP tag -- they both work in the same way with the same speed. Don't do both though -- that may be what you did before and created two loops. tom "Ben Densmore" <[EMAIL PROTECTED]> wrote in message 013a01c164a8$bed10fe0$082e9318@metropolis">news:013a01c164a8$bed10fe0$082e9318@metropolis... > Is it possible to use CFMail inside of a cfloop tag that calls a query? > I am doing that to send out 100 emails and it doesn't seem to do > anything. I'm kind of nervous to use the query attribute of the cfmail > tag because I think I remember I tried it once a long time ago and it > sent 100 emails to each of the people I sent it to. Is this true? ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cf_advancedemail version 2 beta testing
It sounds very interesting. Does the tag have any mechanism in place to avoid conflicts with the tag, such as if they were to both execute at the same time and attempt to write to the spool folder? I may have to look into it writing to my own mail server spool directory rather than the ColdFusion mail spool directory to avoid the 65,535 email limit of CF. Have you tried anything like this? tom "Jochem van Dieten" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Jim McAtee wrote: > > > Jochem, > > > > I just took a quick look at your tag. Nice work. I see that you write > > directly to the CF spool directory and that you require the passing of the > > SMTP server name to the tag (or else you try to pull this info from the > > registry). Looks like this is used only to build the 'x-cf-...' headers. > > Are those headers necessary for CF to pick up the message from its spool? > > > Yes. > > > > Also, is there no way to implement this just using CFMAIL, for systems where > > access to tags like CFFILE are restricted? > > > What use would my tag be without cffile anyway? The point is that you > can send attachments that appear inline. > > But I believe some people have got it to work using cfmail, at the > expense of some email clients not understanding it. The problem is that > CF adds some MIME-type regardless of what else is set. So you end up > with 2 MIME headers, one correct one from cf_advancedemail and an > incorrect one from cfmail. > > Jochem > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Single user CF5 license available
Hi John: For me, the bottom line is that someone who buys UltraDev to develop CF 5 pages has no local means of testing those pages because the development license is only for CF Studio users. For my money that means that MM is not committing to UltraDev as a development environment for ColdFusion. The CF Express issue is rather besides the point, because CF Express is a limited version of CF, which would be the same regardless of version number. A CF Express version 5 is not going to have UDFs or CFGraph anyways, so I don't see why MM would need another version of this. tom "John Dowdell" <[EMAIL PROTECTED]> wrote in message news:v02140b16b808d5445877@[10.112.254.244]... > I may be misunderstanding the core requests here, but the following I think > is what is being sought: > > -- update ColdFusion Express or produce something similar that is free and > which can be used for testing on a developer's server > > -- produce a parallel ability for JRun > > > Did I get this correct? If so, then I know Ben has already forwarded the > thread, and I'll drop the above summary in my weekly report too. If you > could also push the feature request in then this could help as well, > thanks: > http://www.macromedia.com/support/email/wishform/ ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Single user CF5 license available
> the only people who are upset about this are the ones who want to stay > "honest" - there's nothing to stop anyone from simply using the expired CF > evaluation as a single-user developer version. > > Dave Watts, CTO, Fig Leaf Software Exactly. As MM is trying to push UltraDev as an alternative for ColdFusion development, I think it would be fitting to allow the use of the single-user server for those people, or people using Homesite (another MM product). I'm only thinking of the people who are buying UltraDev without CF Studio, as they will have no reason to use features of CF Server 5.0 such as UDFs if they can't make them work on their development machines. Homesite comes free with UltraDev, and for many people this is enough -- no need for CF Studio. Personally I wouldn't be without CF Studio, and it's my tool of choice for most development, but that's besides the point. ;-) tom ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Single user CF5 license available
Yes, I believe that it checks to make sure you have CF Studio installed or it won't install. That means if you use Homesite or UltraDev, or any other tool, you can't install 5.0 as a development server. UltraDev does come with a single-user version of CF server 4.5, but if someone wants to use 5.0 legally, they have to buy CF Studio. tom "Ben Forta" <[EMAIL PROTECTED]> wrote in message 001601c1631c$c2c59f90$1e02a8c0@MILLIWAYS">news:001601c1631c$c2c59f90$1e02a8c0@MILLIWAYS... > Actually, there is a single user version license like there was in CF5. > There is info on it on www.macromedia.com. > > As for CF Express, right now it is still at v4.5, and is still available for > download. > > --- Ben ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Single user CF5 license available
Apparently MM wants to lose their potential ColdFusion developers to ASP, where you can always have a free server on your local machine. There is no conceivable reason why MM would not allow a developer to use a single-user version of CF server indefinitely. It's absolutely useless as a production server and it's only possible use is as a development server. Either that or they are content that developers will have to stick with 4.5. They aren't even allowing UltraDev users the benefit of using a local development server after spending $500 on the software. It doesn't make any sense to me. ;-) tom "Scott Brady" <[EMAIL PROTECTED]> wrote in message 005f01c16317$83db0090$f5b36441@dsbrady">news:005f01c16317$83db0090$f5b36441@dsbrady... > Ok, since you have to own CF Studio, are there plans to release a CF Express > version 5? I'd heard the answer was "No" before, but then we were told that > the CF Server Evalaution reverts to a single user license after expiration. > But, I understand that the Server license doesn't allow you to use that for > development? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access OLE DB vs. ODBC
You should be able to switch the connection type to OLEDB without any problem, as long as you don't specify a DBTYPE of "ODBC" in your tag. It is definitely more stable, although I've found that the latest (2.5 or 2.6) MDAC drivers are fairly stable. We used to have all sorts of crashes when we had the 2.1 MDAC version. We have a 1 gig Access 97 database which was later updated to a 1.6 gig Access 2000 database, and haven't had any problems with it in 2 years (very low volume) tom www.basic-ultradev.com > Does anyone have much experience using OLE DB instead of ODBC to connect to > Access databases that might be able to say whether it's any more stable? I > know that articles in the Allaire knowledgebase recommend OLE DB over ODBC. > Are there any differences in SQL statements when using OLE DB - that is, any > code changes required when changing from Access ODBC to OLE DB? > > Thanks, > Jim ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFmail Recount
> Actually, the system I described works on jobs of ~200,000 mails. I think > we run ~20,000 mails per hour, if memory serves. Yeah, that would take 20 > hours to process your list of 400,000, but then that's the price we pay for > using CF for bulk mail, eh? :) Sounds interesting. . .I'll look into it. Yes, that's the price we pay, but I also have sitting here email software that costs more than a luxury automobile and can deliver millions of messages that can't do the line-item billing the way that I can with ColdFusion and SQL Server. ;-) tom ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFmail Recount
> We had a similar problem and got around it by making our code smart enough > to only spool mail if there is less than 200 files in the spool directory. > Otherwise, it waits a minute and tries again. Sure, you may not be getting > optimal efficiency out of your mail spool, but you're also not crashing the > server. :) That would be good for small jobs, but I need to take jobs of 400,000 and break them into batches of 60,000 so that CF can work with it. We haven't had many problems other than the fact that we can only deliver 24,000 per hour to the mail server. I'm working on a method to deliver the emails directly to the mail server and bypass the CF spool directory entirely. tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFmail Recount
Unfortunately, ColdFusion doesn't give us the option to split the spool directory into mulitple directories, so the server will automatically write all the spool files out to that directory up to 65,535 files before crapping out. Then it only sifts through them at the rate of 400 per minute. It would be so nice if we had the option in the CF Administrator to split the spool directory or speed up the process of delivering the mail to the mail server. tom "Dave Watts" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > > It could also be that thousands of files in the same directory > > > > on a windows box kills the file system in some way. > > > > > > I don't think this'll "kill" the filesystem, but it will make > > > it extremely unresponsive. > > > > while it won't kill it, it certainly in any higher graphical > > sort of directory view (windows explorer, windows commander, etc.) > > will run the processor at 100% and drag everything else way > > down... you should try to keep directory entries to a minimum > > as a rule of thumb we see 400-500 files per directory being > > the high mark... ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MySQL?
In CF 5 you don't need an ODBC connection for MySQL -- you can use a DSNLess connection string. You still need to have the ODBC drivers installed, though. I have a brief article on the subject at http://www.basic-ultradev.com/articles/dsnlesscoldfusion/index.asp including a MySQL string that is tested and works. tom "Gary Groomer" <[EMAIL PROTECTED]> wrote in message 000b01c15e63$3511b250$2341b23f@lindy">news:000b01c15e63$3511b250$2341b23f@lindy... > The only way to connect to the ColdFusion Application Server is via an ODBC > connection. Therefore, download and install MyODBC. It is available at > http://www.mysql.com/downloads/api-myodbc.html. > > Gary Groomer > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Repost: OLEDB Pathing Question
Hmm. I must be missing something. The article only talks about OLE DB using SQL Server. I've gotten this to work with machines on the same network and across the country, but not like you described it. With SQL Server, you need to have one OLEDB data source already set up in the CF administrator going to the same server, then you can access different databases on that same server by specifying the dbname in the tag. So I always set up an OLE DB datasource going to Northwind, and then change the DBNAME in my tag to point to the correct database. Is this what you're talking about, or were you talking about Access? tom "Larry C. Lyons" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > Tom, > > I've been able to get the oledb to work following an article from July > 2000 (Vol2 #7) in CFDJ by Randy Smith. Its on the ColdFusion Developers > Journal site at http://www.sys-con.com/coldfusion/article.cfm?id=126. > But only when the db is on the same machine so far. > > larry > > tom muck wrote: > > > > Have you actually gotten this to work with a database on the same machine? > > I've been unable to make anything happen with OLEDB without first setting > > them up in the CF administrator. > > > > tom > > > > "Larry C. Lyons" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED]... > > > Because of the HOF server problems last week (and this week from the > > > sounds of it), there was no response to this, so I'm trying again. > > > > > > Using CF 4.5.2 on an NT box with all the most recent patches. The web > > > server is WebSite Pro 3.0 > > > > > > I'm experimenting with OLEDB for our data sources. From what I > > > understand, you can use direct OLEDB access for DSN-less DB connections, > > > however, you need to have at least one OLEDB connection for this to > > > work. > > > > > > So you can have something like this: > > > > > > > > > > > DATASOURCE = "#DBPath#" > > > DBTYPE = "OLEDB" > > > PROVIDER= "SQLOLEDB" > > > PROVIDERDSN = "#DBPath#" > > > USERNAME= "UserName" > > > PASSWORD= "Whatever" > > > >SELECT UserID, UserName, Street, City, UserState, Zip > > >FROM UserInfo > > >WHERE UserName = '#FORM.USERNAME#' > > > > > > > > > Here's the question, I can see how this works when the database is on > > > the same machine as the CF Server, but how do you set up the path to the > > > database when its on a separate machine? > > > > > > thanks, > > > > > > larry > > > > > > -- > > > Larry C. Lyons > > > ColdFusion/Web Developer > > > EBStor.com > > > 8870 Rixlew Lane, Suite 201 > > > Manassas, Virginia 20109-3795 > > > tel: (703) 393-7930 x253 > > > fax: (703) 393-2659 > > > http://www.ebstor.com > > > http://www.pacel.com > > > email: [EMAIL PROTECTED] > > > > > > Chaos, panic, and disorder - my work here is done. > > > -- > > -- > Larry C. Lyons > ColdFusion/Web Developer > EBStor.com > 8870 Rixlew Lane, Suite 201 > Manassas, Virginia 20109-3795 > tel: (703) 393-7930 x253 > fax: (703) 393-2659 > http://www.ebstor.com > http://www.pacel.com > email: [EMAIL PROTECTED] > > Chaos, panic, and disorder - my work here is done. > -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Repost: OLEDB Pathing Question
Have you actually gotten this to work with a database on the same machine? I've been unable to make anything happen with OLEDB without first setting them up in the CF administrator. tom "Larry C. Lyons" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > Because of the HOF server problems last week (and this week from the > sounds of it), there was no response to this, so I'm trying again. > > Using CF 4.5.2 on an NT box with all the most recent patches. The web > server is WebSite Pro 3.0 > > I'm experimenting with OLEDB for our data sources. From what I > understand, you can use direct OLEDB access for DSN-less DB connections, > however, you need to have at least one OLEDB connection for this to > work. > > So you can have something like this: > > > DATASOURCE = "#DBPath#" > DBTYPE = "OLEDB" > PROVIDER= "SALOLEDB" > PROVIDERDSN = "#DBPath#" > USERNAME= "UserName" > PASSWORD= "Whatever" > >SELECT UserID, UserName, Street, City, UserState, Zip >FROM UserInfo >WHERE UserName = '#FORM.USERNAME#' > > > Here's the question, I can see how this works when the database is on > the same machine as the CF Server, but how do you set up the path to the > database when its on a separate machine? > > thanks, > > larry > > -- > Larry C. Lyons > ColdFusion/Web Developer > EBStor.com > 8870 Rixlew Lane, Suite 201 > Manassas, Virginia 20109-3795 > tel: (703) 393-7930 x253 > fax: (703) 393-2659 > http://www.ebstor.com > http://www.pacel.com > email: [EMAIL PROTECTED] > > Chaos, panic, and disorder - my work here is done. > -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL
There are a lot. Here's a sampling: http://www.dsv.su.se/~jpalme/ietf/mail-headers/mail-headers.txt tom www.basic-ultradev.com "Rich Tretola" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Is there a complete list of Mail Params anywhere? > Rich > > -Original Message- > From: Howie Hamlin [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 25, 2001 2:30 PM > To: CF-Talk > Subject: Re: CFMAIL > > > Sure. Just use CFMailParam like: > > > > > > . > > > > HTH, > > Howie Hamlin - inFusion Project Manager > On-Line Data Solutions, Inc. - www.CoolFusion.com > 631-737-4668 x101 > inFusion Mail Server (iMS) - The Intelligent Mail Server > >>> Find out how iMS Stacks up to the competition: > http://www.coolfusion.com/imssecomparison.cfm > > > - Original Message - > From: "webmaster" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, September 25, 2001 1:40 PM > Subject: CFMAIL > > > > Does anyone know how I can send nail with cfmail and flag the message as > > "urgent" or "hi-priority" ? > > > > tia > > > > Richard > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MS Personal Web server, NIMBA and others
Yes, any Windows machine is vulnerable, with or without a Web server running. Get a virus protection software and update it to the latest DAT file and you should be OK. tom www.basic-ultradev.com "Earl, George" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > For our development platform we're running MS Personal Web Server on Win NT > 4.00 with our CF Studio. Are these installations of PWS vulnerable to NIMBA > and other viruses/worms/trojans? If yes, how do we protect them? Thanks. > > George ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Code Red backdoor triggered?
Unfortunately, this virus can hit you just as easily. It also comes by email and by opening up a page in an infected site, and also by accessing shared drives in a network. In all, I think it comes in 16 different ways. It's been called a cocktail of viruses. tom "Bud" <[EMAIL PROTECTED]> wrote in message news:p04320400b7d0e42a79ed@[192.168.0.2]... > One thing I'm eternally grateful for is the advice to go with > O'Reilly's Web Site and disable IIS. I've certainly gotten my 900 > bucks worth in sleepful nights and time not spent cleaning up all > this crap and would heartily recommend anyone that's not already > dependent upon those programs to spend the money. IIS and FP > Extensions will never run on a server of mine. The only MS programs > running on my servers are NT/2000, Internet Exploder, SQL Server and > Access 2000. I sit here and read all this crap and just grin. Not at > y'all, but at my wise decision to spend a little now rather than > continuously. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Code Red backdoor triggered?
McAfee didn't have a patch for it until about noon the day it came out. It had already hit hard by then. They've since updated the DAT file 3 times, each one better than the last. tom <[EMAIL PROTECTED]> wrote in message 11EDC356EC3AD311AAD30008C75DAFFCB832A4@GTUS_IAD_E01">news:11EDC356EC3AD311AAD30008C75DAFFCB832A4@GTUS_IAD_E01... > We are running McAfee and had all patches applied to our IIS 4 and still got > it. Our ISP cleaned it up for us without us even asking. I found out when > I put in the work order to have them pull it from the rack for us. All > better! For now. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Code Red backdoor triggered?
Invest in a virus program and you can have it clean everything automatically. Don't waste your time trying to do it manually. Plus, you want to be warned if any further attacks come in. If any exe files have been corrupted, you'll have to reinstall those, but we had good luck running the virus software with the lastest DAT file. tom <[EMAIL PROTECTED]> wrote in message 11EDC356EC3AD311AAD30008C75DAFFCB8329B@GTUS_IAD_E01">news:11EDC356EC3AD311AAD30008C75DAFFCB8329B@GTUS_IAD_E01... > OK. We just found out that our backup tapes are infected, too. Has anyone > found a way to clean this without a total reinstall? I am in the process of > copying the site files themselves to clean separately. If I can avoid a > total tear-down and rebuild, I would be eternally grateful. > > JoAnn A. Schlosser > Senior Consultant > Association Management Software > Grant Thornton LLP > Washington, D. C. > 703.837.4428 > > > > -Original Message- > From: Frank Priest [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 20, 2001 5:16 PM > To: CF-Talk > Subject: RE: Code Red backdoor triggered? > > > Thanks Robert, > > Norton has a cleanup solution now Fortunately the virus left .cfm files > alone:-) It's a major pain to clean up though. > > For anybody that still has problems with this, the renaming of the "cmd.exe" > file tip in an earlier post, helped me to get it at least under control > until Norton had a fix out. > > > Frank > > > > > -Original Message- > From: Matt Robertson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 19, 2001 4:53 PM > To: CF-Talk > Subject: RE: Code Red backdoor triggered? > > > Frank, > > According to CERT, you're out of luck. You're facing a network disconnect > and a ground-up reinstall. > > http://www.cert.org/tech_tips/win-UNIX-system_compromise.html > > Naturally you should research this thoroughly before doing something like > that. > > Sorry for the downer. > > --- > Matt Robertson[EMAIL PROTECTED] > MSB Designs, Inc., www.mysecretbase.com > --- > > >Anybody found a way to get rid of this thing? > >My Anti Virus software detects but can not do anything about it. > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: asp help
That's an UltraDev connection file. If you're going to use UltraDev to write your connections, you are better off using the connection interface rather than the resulting file. Check out http://www.basic-ultradev.com/articles/adoconnections for more information on OLEDB connection strings that are usable with SQL Server. Provider=SQLOLEDB; Data Source=xx.xx.xx.xx,1433; Network Library=DBMSSOCN; Initial Catalog=dbname;User ID=sa;Password=pass; tom "Joshua Tipton" <[EMAIL PROTECTED]> wrote in message 000201c1415a$90653b20$6401a8c0@webdev">news:000201c1415a$90653b20$6401a8c0@webdev... > Does anyone see a problem with this > > ' FileName="Connection_odbc_conn_dsn.htm" > ' Type="ADO" > ' HTTP="false" ' Catalog="" > ' Schema="" > ' MM_Lingerie_STRING = "dsn=sales;uid=admin;pwd=safe4176;" > MM_Lingerie_STRING= "Provider=SQLOLEDB.1; Network > Library=dbmssocn;Password=safe4176;User ID=admin;Initial > Catalogue=sales; Data Source=217.204.37.40;" > Session.Lcid=2057 > > Just to let you know I have the percent signs and > where they are > supposed to be. Receiving a connection error. Please help out > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Remember Passwords on LapTop Fails
Yes, I have this same problem as well on a Windows 2K laptop. It also seems to apply to web sites that have username/password fields. tom "Don Vawter" <[EMAIL PROTECTED]> wrote in message 000901c13df6$0e743330$6501a8c0@LAPTOP">news:000901c13df6$0e743330$6501a8c0@LAPTOP... > Win2K will not remember passwords on my laptop. It is a real pia to enter > email passwords for every email account every time I start Outlook Express. > It does not seem specific to outlook as passwords are not remembered in IE > either. Is there a registry setting I can check. Win2K Vaio FX 170K ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Studio 5.0 beta
You have to email the beta address, ask to be on the beta, and give your serial number from ColdFusion studio 4.5. You may also be too late, as it was announced here months ago. tom "Kelly Matthews" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Yes but right now when you login NO BETA SOFTWARE is listed, maybe they > removed it for the time being? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VBS to CF
You need to execute the query first (what the VBScript execute is doing) with: SELECT blah from blah Then loop thru the query with a or . Check the CF docs for details. There is no "movenext" in CF. There is no concept of a pointer to a current record. You can look at any or all of the results at any time. tom www.basic-ultradev.com "Janine Jakim" <[EMAIL PROTECTED]> wrote in message 1BEB99C913B7D411855F00B0D020F05B134006@STMS">news:1BEB99C913B7D411855F00B0D020F05B134006@STMS... > I'm looking at some vbs code and want to convert it to CF. I have most of > it, however, am not quite sure about one spot. > They use the line of code: > > Set orr=DBConnect.Execute(strSQL) > DBConnect had been set to Creat connection to DB > strSQL is the name of the query that they wrote. > > That makes sense to me. But then they set data fields and then to move to > the next record they use > orr.MoveNext > I'm wondering if there is an equivalent in CF. I thought a loop query would > do the trick but I'm not getting the results that I need. > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: how to randomly generate a string of 10
Try this:
theString = "";
for (i=0; i LT 10 ; i=i+1) {
theNum = RandRange(48,90);
if(theNum LTE 64 AND theNum GTE 58) {
i=i-1;
}else{
theString = theString & chr(theNum);
}
}
If you have CF 5, you can make a UDF out of it:
function getRandomString(theLength) {
theString = "";
for (i=0; i LT theLength ; i=i+1) {
theNum = RandRange(48,90);
if(theNum LTE 64 AND theNum GTE 58) {
i=i-1;
}else{
theString = theString & chr(theNum);
}
}
return theString;
}
#getRandomString(10)#
tom
www.basic-ultradev.com
"Alex Baban" <[EMAIL PROTECTED]> wrote in message news:3b9b02ea$[EMAIL PROTECTED]...
> I am trying to generate a random string of 10 alphanumeric characters.
> Then I will set a cookie on client browser with this value. I know how to
> set the cookie but
> I need help to generate the string.
> Is there any CF function for this?
> I would appreciate any help.
>
> Thanks in advance.
>
>
> --
>
>
> Alex Baban
> A+ Certified Computer Professional
> Phone: 604-521-8959
> Website: www.go.to/alexbaban
>
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Mimic clicking on the Reply button of an email
In an HTML message: mailto:[EMAIL PROTECTED]?subject=Hello there">[EMAIL PROTECTED] You can do it in plain text messages, as long as there are no spaces in the subject: mailto:[EMAIL PROTECTED]?subject=Re:Order#1233 tom www.basic-ultradev.com "Larry Juncker" <[EMAIL PROTECTED]> wrote in message 000f01c1371c$0af317c0$2354ead1@HEARTLAND">news:000f01c1371c$0af317c0$2354ead1@HEARTLAND... > Does anyone know how I can make a text link that > would mimic clicking the Reply button, so that I can include > a subject for the return email automatically? > > TIA > > Larry Juncker ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Formatting Text for Email/Text Files
True, I didn't read your post clearly. I'm using this for email attachments. To do what you need to do is a little or a lot more difficult. You can use list functions to separate the words at the space, adding words until you are up to 70 characters, or choose an arbitrary length less than seventy and add characters until you reach a space or punctuation mark. You could also use the CDONTS object to send the mail for you instead of CFMAIL if you are on a Windows server. tom "Dennis Powers" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Tom, > > Thanks for the idea, but I am stuck with CF 4.0.1 at the moment. However > won't your function just insert at the 70th character regardless of whether > is falls within a word? What I am trying to do is a "friendly" line break. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MIME Type email and CF
You can code the headers and boundaries manually. There are quite a few posts giving the full code for a multi-part email -- check the archives. tom "Clint Tredway" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am trying to send out a multi-part email that is both text and html with headers and a boundary so that I can just send one email and let the users client be able to read it. > > Clint ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Formatting Text for Email/Text Files
Here's a function for CF 5:
call it like
function makeNiceEmail(string, theLength) {
CRLF=chr(13);
for (i=theLength-1;i LTE Len(string);i=i+theLength){
string = Insert(CRLF,string,i);
}
return string;
}
tom
www.basic-ultradev.com
"Dennis Powers" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> It has been a long working weekend and my brain is suitably befuddled at
the
> moment. I am attempting to format text for use in an email or a RAW text
> file and wish to insert a carriage return/line feed at the closest space,
> with out breaking the words, to the 60-70 characters point for each line.
>
> I am pulling text data out of a database that only has CR/LF breaks at the
> paragraph level. The paragraphs can run several hundreds words (don't
ask -
> it's PhD speak stuff) I need to create text files from the data with CR/LF
> breaks inserted within the paragraphs to break at a space within the
> 60-70-character point.
>
> I am sure someone has done this before and am hoping that you might be
> willing to take pity on one of your fellow CF'ers and share some code.
>
>
> Best regards,
>
> Dennis Powers
> UXB Internet
> (203)879-2844
> http://www.uxbinfo.com/
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The biggest cfmail message?
Most HTML messages that are sent out are done this way. It's much easier on the mail server and the email reader if the images aren't included in the body. If you must include them, I posted some code here a couple months back that you may be able to use. As far as limits, there are no known limits. A lot of users have limited space in their inbox, though, especially people with free email accounts. tom "Dick Applebaum" <[EMAIL PROTECTED]> wrote in message news:v04220808b7b56406fd83@[63.15.99.55]... > At 4:22 PM +0100 8/31/01, Daniel Lancelot wrote: > >Is this content already displayed online? > > > >If so, rather than sending an email with all the images etc attached, you > >could link to all the image's online locations (absolute href's) and thus > >reduce your bandwidth requirements substantially (depending on the nature of > >the content...) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Plain text view in outlook?
Eudora Light is a limited HTML reader. It will pick up the HTML version before the text version. You can see the text version in Outlook by viewing the message Properties >> Details >> message source. You'll see both versions with all headers. tom www.basic-ultradev.com <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Probably most effective to get yourself a plain-text email client to > experiment with, assuming you have something that looks like a POP server. > An older version of Eudora (free "light" version at > ftp://ftp.eudora.com/eudora/eudoralight/windows/english/306/) should work. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Throttling CFMAIL
If you are having a problem with AOL, you should contact their support lines. Usually it has to do with a DNS issue with your mail server. AOL doesn't allow emails to come in that have problems with DNS or reverse DNS lookup because of all the spam they get. We had the same problem and it turned out to be a problem with a reverse DNS lookup on our mail server domain. Now we send thousands of billing statements to AOL customers with no problems. tom "DSJ / PC1, Inc." <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ok Cameron. Here's the deal. > > I run the web site for ColoradoRunner.com. On that web site, you will > notice that we collect e-mail addresses from those that opt to give it to > us, in the form of an e-mail collection box on the home page, as well as the > contest for the free shoe give away each and every week. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL Performance...
Does it use the JMail component from http://www.dimac.net ? tom "Gary Kraeger" <[EMAIL PROTECTED]> wrote in message 033b01c130b0$1b0e1690$[EMAIL PROTECTED]">news:033b01c130b0$1b0e1690$[EMAIL PROTECTED]... > Ian: > > If it is a one shot thing and you find that cfmail won't handle it. I would > be willing to let you use our tag jmail, on our server to help you out. > > Gary > cfdev.com > http://www.cfdev.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL syntax again
Thanks, that's very close to what I eventually used. There are actually no duplicate records. The example was simplified and the other fields weren't shown, but I have to match on fields that may contain duplicate values. tom <[EMAIL PROTECTED]> wrote in message 9B9D098EAC97D411938900805FFE1B62DA4901@GBVWFSMKS3">news:9B9D098EAC97D411938900805FFE1B62DA4901@GBVWFSMKS3... > Is there any reason why you are keeping duplicate records in table 2. If you > kept it unique, then you wouldn't have this problem. But to do it with the > data you have. You need to make a unique selection from table2 and then link > it back to table1. Something like this should work. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML Newsletters
Your template has to use instead of : SELECT * FROM dbo.Customers Hello #recordset1.name# and on mytemp.cfm SELECT * FROM dbo.Customers Here is your order dude: #Recordset2.orderdetail# tom "Nick Texidor" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Thanks Tom... I hadn't thought of using CFInclude... Trouble is, I want the > included file to process the queries!! And that bit doesn't work. I have > a page that when displayed is the newsletter I want to send... I also want > to use the same page to send to subscribers... It's the queries that are > causing me the problems! :^) > > > on 29/8/01 10:48 AM, tom muck at [EMAIL PROTECTED] wrote: > > > That's not a problem. Have you tried it? You can't use a query attribute > > of tag if you do it that way, but you can use a and send > > one at a time. It's actually just as fast. I always use a > > to include the coldfusion page as the body. > > > > tom > > > > "Nick Texidor" <[EMAIL PROTECTED]> wrote in message > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > >> I¹m trying to send an HTML newsletter via the CFMAIL tag but am having a > > few > >> problems. > >> > >> If I simply enter all the HTML code in the tag, it works ok. But I¹d like > >> to use an existing CF page, so that all the Queries run and then send the > >> resulting content. Can this be done, or would I need to embed all the > > HTML > >> code from the template into the CFMail tag. > >> > >> Should I maybe use CFHTTP to run that newsletter.cfm page to allow all the > >> queries to process, and then send the resulting output?? > >> > >> Thanks for any help/suggestions > >> > >> N > >> > >> > >> > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Macromedia strong arms developers into 5.0 upgrade
It sounds to me like you were being strong-armed into the Apache upgrade. If your old version of ColdFusion works with your old Web server, why upgrade? If your new Web server doesn't work with your old application server, it seems that there are two choices: go back to the old Web server or upgrade the application server. I wouldn't expect the old server to be upgraded to run newer upgrades of Web servers. I'm apprehensive about upgrading anything these days, with the technology advancing at such a rapid rate. It seems that every time you upgrade something, everything else becomes outdated. I'm still running Windows NT 4 server as my server, but I did make the leap to CF 5.0 because of the tremendous speed increase. tom "Justin Greene" <[EMAIL PROTECTED]> wrote in message 013445F6BB17D4119959005004AAEA9A47A54E@SPIDERMAN">news:013445F6BB17D4119959005004AAEA9A47A54E@SPIDERMAN... > Hi All, > I just had a very disturbing conversation with Macromedia. We have been > running CF/Apache on Windows for about 2.5 year now and developing on Cold > Fusion since the 1.5 days (cgi only). Version 1.3.20 of Apache for Win32 > (which has been available for over 6 months) is the first that Apache.org ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML Newsletters
That's not a problem. Have you tried it? You can't use a query attribute of tag if you do it that way, but you can use a and send one at a time. It's actually just as fast. I always use a to include the coldfusion page as the body. tom "Nick Texidor" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I¹m trying to send an HTML newsletter via the CFMAIL tag but am having a few > problems. > > If I simply enter all the HTML code in the tag, it works ok. But I¹d like > to use an existing CF page, so that all the Queries run and then send the > resulting content. Can this be done, or would I need to embed all the HTML > code from the template into the CFMail tag. > > Should I maybe use CFHTTP to run that newsletter.cfm page to allow all the > queries to process, and then send the resulting output?? > > Thanks for any help/suggestions > > N > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: load page when CF restarts
"Mike Amburn" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I would like to store some variables in the Server scope so that they're > available to all applications on the server. Is there an automated way > to load a specific page when CF restarts? > > -mike What about putting a command line in a bat file and placing it in your startup folder? Theoretically it should work. c:\cfusion\bin\cfml.exe c:\inetpub\wwwroot\mystartpage.cfm tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT:SQL syntax again
Actually there's no integrety problem, because it's a purely transactional database, and it was simplified for the question (id isn't the primary key for the table). This query works: select t1.id, t1.time, t2.email from table1 t1 left outer join (select distinct(email),id from table2) t2 on t1.id = t2.id tom "Deanna Schneider" <[EMAIL PROTECTED]> wrote in message 00d001c12b41$10421780$cdfb6880@deanna">news:00d001c12b41$10421780$cdfb6880@deanna... > Hm...It looks like you have a data integrity problem here. If the "id" is 2, > there should only be one record with ID = 2 in your first table. Otherwise, > your id is really a combination of the ID and the date, and you'll need the > date in your second table to do a proper join. > > Make sense? > > -d > > > > Deanna Schneider > Interactive Media Developer > [EMAIL PROTECTED] > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT:SQL syntax again
I have a simple query question that I haven't been able to figure out. I have a simple table like this (table 1): id,time 2,8/19/01 2,8/20/01 3,8/21/01 That table could have corresponding matches in a second table: id, email 1,[EMAIL PROTECTED] 2,[EMAIL PROTECTED] 2,[EMAIL PROTECTED] 2,[EMAIL PROTECTED] 3,[EMAIL PROTECTED] I need to match the ID number from table 1 to table 2, but only return results from table 1. In other words, I want my query results to show: id,time,email 2,8/19/01,[EMAIL PROTECTED] 2,8/20/01,[EMAIL PROTECTED] 3,8/21/01,[EMAIL PROTECTED] Every join I've tried gives me results that include all ID matches from table 2, which would be 4 rows and not 3 in this example. How would the query be worded for this? tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Parsing email
CFPOP is probably too slow for what you are trying to do. I wrote a similar app in Visual Basic that reads the spool directories of my mail server, appends all bounced emails to a huge text file, extracts email addresses using a regular expression, then deletes the files. Unfortunately it's a proprietary system for use with my mail server, but you could do something similar. There are some third party programs out there that do this sort of thing. Extractor Pro comes to mind. It will extract email addresses from many different sources. tom "ChristianWatt" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Does anyone do a lot of email parsing? We have started an email campaign > and since we are using a customer database up to two years old...from each > 27,000 emails I send...I am getting around 9-12k underliverables...out of > office...autoreplys...and others ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Syntax
Also, for the text driver to work properly, you should have the column names
as the first row in the text file.
tom
"tom muck" <[EMAIL PROTECTED]> wrote in message
3b7bfb4a$[EMAIL PROTECTED]">news:3b7bfb4a$[EMAIL PROTECTED]...
>
> DBTYPE="dynamic"
> CONNECTSTRING=
> "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\mydirectory\;
> Extensions=asc,csv,tab,txt;Persist Security Info=False;"
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Syntax
SELECT first,last from testnames.csv
Insert into employees (firstname,lastname) values ('#rs.first#','#rs.last#')
This works in CF 5 using a dynamic connection to the directory where the
text file is located. You can do it in CF 4.5 by setting a dsn to the
directory using the MS text driver.
I have some info on dynamic connections at
http://www.basic-ultradev.com/articles/dsnlesscoldfusion
tom
"Nathan Chen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Thank you, David, that's my next best option. My goal is to execute the
select and insert query from a cfm page
> without any manual work.
>
>
> David Baskin wrote:
>
> > Nathan, if you have a comma delimited file with the data you want to
import
> > into a table you can do an import in Enterprise Mgr. right click on the
> > table that you want the data in and go to all tasks > import data. point
to
> > the text file and follow the steps to import. HTH.
> >
> > d
> >
> > -Original Message-
> > From: Nathan Chen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, August 16, 2001 8:57 AM
> > To: CF-Talk
> > Subject: OT: SQL Syntax
> >
> > Hi, Everyone:
> >
> > Does anyone know how the syntax of selecting data from a text delimited
> > file and inserting into an exiting table? I kind of remember Oracle
> > database provides this kind of tool but not sure how. I am now using MS
> > SQL Server 7.0
> >
> > The simplied situation will something like this: a text file that
> > consists of two columns, first_name, last_name.(tab delimited or space
> > delimited). I need to select data in these columns and then insert them
> > into a table that consists of two columns, first_name, last_name. I
> > thought this would be a simple task but can't find any syntax in the SQL
> > server books. Any help is appreciated.
> >
> > Nathan Chen
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Studio 4.5.2/Dreamweaver 4 integration
I think there's a registry setting for that. You can add a button to the toolbar easily, though. http://www.basic-ultradev.com/articles/Homesite tom <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Anyone know how to configure CF Studio to integrate with Dreamweaver 4 > (with the button in the Studio editor) after un-installing UltraDev which > was the default instead? > > -- > Peter Tilbrook > Chief Web Developer > Lunar Power Internet Technologies > Unit 1, 26-28 Winchcombe Court > Mitchell, ACT, 2911 > AUSTRALIA > > Phone: +61-2-6242- > Fax: +61-2-6242-6655 > Web: http://www.lunarpower.com.au > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS Log Entry
It means a computer infected with Code Read virus is trying to infect your IIS. tom www.basic-ultradev.com "Bruce Sorge" <[EMAIL PROTECTED]> wrote in message 004301c12523$b9202820$[EMAIL PROTECTED]">news:004301c12523$b9202820$[EMAIL PROTECTED]... > All this talk about IIS Server logs got me to looking at my raw log files instead of just having WebTrends do the looking for me, and I have found a very interesting entry that I do not know what it is. It is: > 2001-08-13 00:35:00 195.124.132.5 - 10.7.128.164 80 GET /default.ida?NNN N%u9090%u6858%ucbd3%u7801%u9090%u6858%ucbd3%u7801%u9090%u6858%ucbd3% ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: An extra line of defense for you IIS-types
> We've been using host header names for quite some time, though not > specifically as a security measure. It forces the browser to provide an HTTP > Host header to identify the from which FQDN it's requesting. This allows you > to bind multiple virtual servers to a single IP address (which is why we use > it). Yes, I use it myself for that very same reason, but I always left the default directory in there as well using the IP address of that machine and no host header. We do have one server that has no domain names and no host headers. I was wondering if it would make sense to point a domain name to it and use host headers exclusively. Basically you're saying that it's an option now but the next worm may be able to circumvent this as well using simple reverse DNS lookup. Good info. Thanks. tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: An extra line of defense for you IIS-types
Has anyone else tried this? What's the potential downside? I tried in on several machines and the log entries for Code Red attempts went from about 1 per minute down to zero. tom www.basic-ultradev.com "Rick Osborne [Mojo]" <[EMAIL PROTECTED]> wrote in message 000101c12414$39519bc0$[EMAIL PROTECTED]">news:000101c12414$39519bc0$[EMAIL PROTECTED]... > Rick OsborneI realize this is a bit off-topic, but ... > > I spent a few hours last week going through logs in an attempt to analyze > how much we were affected by Code Red, even though we were never actually > vulnerable. (We have a guy here who is a patch zealot.) I was just curious > to see how many times we'd been hit, etc. I couldn't find a single attempt > in any of our log files. I thought this odd until I remembered that Code > Red, and most automated exploit tools like it, connects to the IP address of > the machine, not the host name. That is, they don't provide a Host header, > so IIS simply returns the "no web site configured for this address" error. > All of our sites are virtual and therefore require Host headers. One of the > items on our checklist for setting up servers is to disable/delete (good > luck, it keeps coming back) the Default Web Site and make sure that you > *cannot* access the site via an IP. It was just paranoia a few years ago > when we started doing it, but I'm beginning to think it might actually be A > Good Practice now. > > Yes, yes, I know the argument against it: if your DNS goes toasty how do you > access the site (use your local host config into fooling your browser into > thinking it went through DNS) and what about ancient browsers that don't use > Host headers? I don't have an answer for that second one ... our WebTrends > reports tell us that non-4.0+ browsers account for a fraction of a percent > of traffic on our sites, so we can get away with it. YMMV. > > Just food for thought. > > -- > Rick Osborne ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF 4.5 and CF 5 comparison
Every test I've done by timing our applications before upgrading and timing them after upgrading have shown that CF 5 is MUCH faster. We have a lot of database access in our apps, and have seen about a 300-400% improvement in speed, with no exaggeration. tom "Aidan Whitehall" <[EMAIL PROTECTED]> wrote in message A541FA096511D511BA0300D0B7B63A5F0E4BFC@whipsnade">news:A541FA096511D511BA0300D0B7B63A5F0E4BFC@whipsnade... > > I just did a comparison stress test between the 2 servers and > > it looks like > > 4.5 was similar and in most cases beat version 5. > > Aside from CFAS, were all other things equal on both servers (processor, > RAM, users hitting the box, etc)? > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Yipes - its raining ColdFusion 5 books
Check Forta's advanced book -- there are sections on creating tags in C++ and Delphi . I think the new edition is supposed to be out this month. tom www.basic-ultradev.com "Tracy Bost" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Almost bought the Instant Coldfusion book yesterday at B&N, but bought Forta's > new one instead. Will probably buy the other two sooner or later. > > I'm wondering if anybody is in the works (or know of a book) an in depth book > on writing C,C++, & Java tags with ColdFusion. > Also on using dlls & shared objects. Haven't been able to find much documention > or examples on this. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Upgrade 4.0 to 4.5 - COM Objects
Yes, after installing the CF server you should reinstall the MDAC version 2.5. Don't go up to 2.6 without installing 2.5 first. tom "Shari Jung" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > We just upgraded our old ColdFusion server from 4.0 to 4.5 in preparation > for installing 5.0. Now we are getting the following error. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Total Fix For Code Red
You could automate it thru CF to loop thru your log file: SELECT clienthost from internetlog.csv tom "Richard Kuryk" <[EMAIL PROTECTED]> wrote in message 3A8BAD034B37D3118C6F009027791324043F60D7@NTSVR1">news:3A8BAD034B37D3118C6F009027791324043F60D7@NTSVR1... > Yes, but if they don't know they have code red and there machine is > unpatched, I would imagine the admin is some home user that got a cd from of > nt server and doesn't have a clue how to properly configure and secure there > box. So for the people that are still infected they have every service > known to man running and probably won't even know what to do to correct the > situation, once notified! Now because of these morons we can't run a small > personal web site, since all high speed connections will start to shut down > incoming port 80. So far mine is still up, but not sure for how much longer > since my logs have tons of cable users requesting default.ida! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Connecting to DSN at crystaltech torough Ultradev 4 on a MAC
This is true, but in order to be able to access your databases from within CFStudio or from within UltraDev, you need an RDS password. This allows you to view the tables and columns from the live database and be able to use them to build your queries. If you have a local version of CF running, you probably set your own RDS password. When you install CF server, you are given the option of using the same password for RDS as the CF administrator, or a different password to be able to access data sources in CF Studio. tom "Brian Hogue" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > tom - > > Are we talking about the same thing? > > I know that all I do in CFquery is name, datasource, datatype, userid and > password. CrystalTech hosts my application. When I test locally, my CFqueries > have name, datasource and datatype. Can you reconcile what you said against what > I just said? Thanks in advance. > > -brian > > > tom muck wrote: > > > Yes, but to gain access thru RDS in CFStudio or UltraDev you need the RDS > > password. I wonder how other people do it in a shared environment. I've > > always had my own server, so I set my own passwords. They should be able to > > set a different password for RDS access thru Studio and UltraDev that > > doesn't allow access to the administrator. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Connecting to DSN at crystaltech torough Ultradev 4 on a MAC
Yes, but to gain access thru RDS in CFStudio or UltraDev you need the RDS password. I wonder how other people do it in a shared environment. I've always had my own server, so I set my own passwords. They should be able to set a different password for RDS access thru Studio and UltraDev that doesn't allow access to the administrator. tom "Brian Hogue" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > Max - > > I have a CF app at CT. Your Mac muddies the waters. As I recall, CT gave me > DSN, Userid and Password for my app. My local DSN is a different name. It does > not require Userid nor password. > > I put CT's information in my CFquery. I view the CT page in my browser. It does > the proper DB stuff. > > -brian > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMail Spool Interval
It controls how fast the emails are dumped to the mail server. When you execute a tag, the emails are dropped into the spool folder. Then, once every 60 seconds, 100 emails are dumped to the mail server. You can decrease this to 15 seconds to speed up mail delivery (400 per minute). tom www.basic-ultradev.com "Edward Chanter" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Maybe I'm being thick here, but what does the spool interval _actually_ do > in CF 4.5 > > Does it control how often the spool restarts ie. It sends all the mail it > can and then wait's an specified interval before starting again, or does it > control something else. > > Sorry if this is a dumb question but it is first thing in the morning :-O ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Embedding an image inline into an email
> > This will bomb on quite a few mailservers and mailclients. The RFC > dealing with mail (RFC 2822) says the following about line lengths: > > ' - Lines of characters in the body MUST be limited to 998 characters, > and SHOULD be limited to 78 characters, excluding the CRLF.' I'll have to look into this. You're probably right about some clients not being able to interpret the image here, but most "modern" clients will. I think a simple loop to break up the data will work here. tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Embedding an image inline into an email
The double content types are there for a reason: when you send a "multipart/alternative" email, the text version is seen by email readers that don't read the html versions (I don't know of any offhand, but they seem to work fine with these headers.) The HTML version is seen by Outlook Express, Outlook , Eudora Light, Eudora Pro, Netscape Messenger, etc. The image in embedded and is seen as an embedded image in readers like these (except for Eudora light) that can display an image. Because of the multipart header, other email readers will interpret the image as an attachment. After sending out hundreds of thousands of messages, we've found that these headers are compatible with a wide variety of readers. I've even added a third type-- text/x-aol for AOL versions 5 and sooner, although I usually send those out separately with no alternative versions. tom "Jochem van Dieten" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > AFAIK this generates double content type headers. Not all mail clients > will understand this. > > > Content-Transfer-Encoding: 7bit > > > This means that characters with an ASCII value above 127 are off-limits. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF 5.0 vs CF 4.5 - Enterprise vs Pro
Stick with Pro unless you need clustering or native DB drivers. Definitely upgrade to 5.0, though. You'll notice much better performance -- like 3 or 4 times faster execution times. tom www.basic-ultradev.com "David Caplan" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am building a fairly small CF site, low number of hits per month, with > relatively little security. Is there any reason for me to get CF Server > Enterprise, or can I stick with Professional Edition. Also, I have only used > CF 4.5 in the past, should we make the upgrade to CF 5.0, is it worth it? > Stable enough at this point? > > Thanks, > > David Caplan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Embedding an image inline into an email
Actually, make sure the multipart/alternative and boundary are on the same line -- it wrapped in the post. Write me offlist if you can't get it to work and I'll send you a working page. tom www.basic-ultradev.com "tom muck" <[EMAIL PROTECTED]> wrote in message 3b700a77$[EMAIL PROTECTED]">news:3b700a77$[EMAIL PROTECTED]... > Here you go. This works for me (image should be in the same folder as the > page, or adjust the CFFILE tag): > > from="[EMAIL PROTECTED]" > subject="test image" > > > > value='multipart/alternative; > boundary="7C252360672B03A0BAD013A5"'> ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Embedding an image inline into an email
Here you go. This works for me (image should be in the same folder as the page, or adjust the CFFILE tag): --7C252360672B03A0BAD013A5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit This is the text version. Blah. . . . --7C252360672B03A0BAD013A5 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit This is the HTML version. cid:003a01c11b56$c06b9d20$[EMAIL PROTECTED]";> --7C252360672B03A0BAD013A5 Content-Type: image/gif; name="myimage.gif" Content-Transfer-Encoding: base64 Content-ID: <003a01c11b56$c06b9d20$[EMAIL PROTECTED]> #data64# --7C252360672B03A0BAD013A5-- -- End -- tom www.basic-ultradev.com "Nick Betts" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hello all. > I need to bulk email a database of users. BAsically, I have an image I > need to embed in the email which is NOT pointing at a server, so somehow > I need to embed the image into the email so that even people not online > can view the image. Is there anyway using CFMAIl to do this? > > Cheers, > Nick Betts > -Original Message- > From: Nick Betts > Sent: 07 August 2001 11:20 > To: CF-Talk > Subject: RE: embedding a MIME image to an email - HELP URGENTLY! > > > Hello all. > I need to bulk email a database of users. BAsically, I have an image I > need to embed in the email which is NOT pointing at a server, so somehow > I need to embed the image into the email so that even people not online > can view the image. Is there anyway using CFMAIl to do this? > > Cheers, > Nick Betts ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfscript - pros/cons
If you do the loop with CFLOOP you aren't getting an accurate timing, because you are opening and closing the tags for each iteration of the loop. Also, as the original post said, the construct is different, because there are times when you might want more than CASE statement to execute, which you can do with CFSCRIPT because it requires the break statement. tom www.basic-ultradev.com "Zac Belado" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > At 03:00 AM 8/5/2001 +1000, you wrote: > >There are many areas where cfscript is not optimised, but having said > >that I can't vouch for CF5.0. > > Just did a quick test under CF 5. Iterated a switch statement 10,000 times > and iterated a similar CFSwitch statement the same number of times. (Loop > was done using CFLoop in order to eliminate loop structures as a timing issue) > > switch (cfscript) 1753 > > cfsswitch 811 > > So its still not optimised. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Blatant advertising (you have been warned)
That's excellent news, Ben. I'm glad to see you have some UltraDev coverage. ;-) tom www.basic-ultradev.com "Ben Forta" <[EMAIL PROTECTED]> wrote in message 002001c11576$0d241fc0$1e02a8c0@MILLIWAYS">news:002001c11576$0d241fc0$1e02a8c0@MILLIWAYS... > Because I am being asked about this several times a day now ... > > The new edition of my "ColdFusion 5 Web Application Construction Kit" is now > shipping. The book, now in it's 4th edition, has grown dramatically (it's > 50% bigger, excluding the appendixes!) and now includes coverage of CF5 > features, lots more basics and tips, project planning, methodologies > (including an overview of Fusebox, cfObjects, and others), server > configuration fine-tuning, code management, Flash integration, using > UltraDev, and much more. All the code examples and applications are new, > even the examples have all been updated and revamped, and the ever popular > tag and function references are now in electronic form (PDF) so you can > search and print them as needed. The book page is at > http://www.forta.com/books/0789725843/, and you can buy from Amazon.com (who > are taking advance orders) at ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Server memory use grows
That's good to know. tom <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > According to Microsoft's documentation (for what that's worth) SQL Server > will not dynamically allocate memory if that allocation would cause > swapping. The OS might, but not SQL Server. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Server memory use grows
You shouldn't have to "wait and see". There is a specified amount used by SQL Server which you can find out by right-clicking on the server in the Enterprise Manager and then click the Memory tab. I think it's set to 768 megs by default as the max and 0 as the min. You can also specify a fixed amount of memory. If you only have 512, you should set it to well below this value so that it doesn't start using virtual memory. tom www.basic-ultradev.com "John Fix 3rd" <[EMAIL PROTECTED]> wrote in message 000601c11527$39372e30$6a2f43ce@MONSTER">news:000601c11527$39372e30$6a2f43ce@MONSTER... > There's 512mb installed right now. OK, if that doesn't seem out of > line, then I'll leave it for a longer period next time and see what > happens. > > Thanks! > > John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sending 12,000 Emails Via CF 4.5 WOULD CF5 help?
The spool speed is identical in CF5 -- 100 emails coming out of the spool folder every 15 seconds maximum, if you change from the default of 60 seconds in the CF administrator. CF 5 will process your pages quicker, but the bottleneck is internal to CF. We do between 1,000-100,000 almost daily with no problems, and did so with CF 4.5 as well. There seems to be an internal maximum of 65,535 emails at any one time in the spool folder. tom www.basic-ultradev.com "William J Wheatley" <[EMAIL PROTECTED]> wrote in message 00a701c11521$16005870$020aa241@aepsserver">news:00a701c11521$16005870$020aa241@aepsserver... > Ok heres the issue i am having and email is driving me nuts. > I have a process that nightly finds members that have had there resumes searched on and i have it send out a daily email but there are 12000 emails that go out and its in a giant CF LOOP and i see the mails in the /opt/coldfusion/mail/spool directory but nothing happens with it? > > Would CF 5 help with the processing of the mail? > > > > > Bill Wheatley > Director of Development > Allaire Certified ColdFusion Developer > AEPS INC > Allaire ColdFusion Consulting Partner > www.aeps.com > www.aeps2000.com > 954-472-6684 X303 > ICQ: 417645 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfmail error with attachment
Upload the file send the email delete the file tom "Mak Wing Lok" <[EMAIL PROTECTED]> wrote in message 020e01c114b4$1bbfada0$06646464@makwinglok">news:020e01c114b4$1bbfada0$06646464@makwinglok... > any other alternative solution where i can do without uploading file? > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfserver installation problems
I have a development machine that had a beta version of CF 5 server on it. Now I have a release copy of CF 5 professional. I've tried to install it, but it doesn't allow me to, saying that there is a pre-release copy on the machine that has to be uninstalled first. I've tried to uninstall that version, but the same dialog box pops up. I've even gone in thru Add/Remove programs, and the same error message appears. Has anyone else run into this? I've tried everything, including deleting all traces from the registry and the cfusion folder. tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMail
"Thomas Chiverton" <[EMAIL PROTECTED]> wrote in message 0FE599B92CC1D311BE8300508BB1D1E901479623@LON1MLBX01">news:0FE599B92CC1D311BE8300508BB1D1E901479623@LON1MLBX01... > > Does anyone know what the email throughput rates are for > > cfmail running with > > a mail server (post.office) on another machine? > The highest throughput you can get is 400 emails per minute, based on the fact that the CF server spools 100 every 15 seconds to the mail server. That's if you increase the spool setting from the default of 60 seconds from the Administrator. Also, there is a 65,535 message limit, based on the spool file naming convention. tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfmail limits
I think it applies to both, but we're running CF 5. tom "Brian Hogue" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > tom - > > Is this CF 4.5 or CF 5? Thanks in advance. > > -brian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfmail limits
I've run up against what seems to be the upper limits of CFMAIL. It appears that the files stored in the Spool directory are named using a hex naming convention of .cfmail to .cfmail. When we recently sent more mails than the spool directory can handle (65535) the page crashed. Is there a way in ColdFusion to do any of the following?: change the naming convention to allow more spool files add more spool directories increase the amount of spool files sent to the mail server (currently limited to 100 every 15 seconds) change the header of the mail spool file so that I can write the spool files directly to the mail server spool folders. Thanks! tom ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (OT) Access SQL Statement
Access uses the pound sign to delimit dates: SELECT StartTime FROM myTalbe WHERE StartTime NOT BETWEEN #1899-12-30 18:00:00# AND #1899-12-30 18:30:00# ORDER BY StartTime You'll probably have to double them up to use the query in CF. tom "Skyward Internet Technology" <[EMAIL PROTECTED]> wrote in message 024601c11073$1f9645f0$bd08eb84@jasper">news:024601c11073$1f9645f0$bd08eb84@jasper... > I'm used to Oracle, so I always choke on Access stuff . . . > How do you do a NOT BETWEEN in Access? > (Note: StartTime is a Date/Time Field) > > EX: >SELECT StartTime >FROM myTalbe >WHERE StartTime NOT BETWEEN 1899-12-30 18:00:00 AND 1899-12-30 > 18:30:00 >ORDER BY StartTime > > Thanks, > Dave > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DSN Less connections
Try this: BLAH BLAH BLAH The connectstring attribute should be all on one line, and the MySQL ODBC drivers need to be installed. They can be downloaded from www.mysql.com. tom www.basic-ultradev.com "Fcc Paragon" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > Somebody Please HELP!! > > I have just been converted to Mysql database and I am now in the testing > stages, I am having trouble understanding the concepts of DSN Less > connections, I have an NT server running CF 4.5 and Mysql server all on the > same machine.How do reference the database from within a query. > > > BLAH BLAH BLAH > > > > In desperation > Mark Bryden > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
