Re: Storing Credit Card Info
Matt, Did you have a URL for the guy you mentioned below? -Novak - Original Message - From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, June 22, 2003 1:24 PM Subject: RE: Storing Credit Card Info > I second Stan's comments. That is an outstanding idea, Kate! I have > *exactly* the client who needs that solution; and realistically, > probably all of them. Sounds like a great convenience upgrade. > > Some guy is selling 16mb units with an erase protection switch and > optional password protection for US$1.99 each. $9.95 shipping but I bet > I can get a bulk deal. That'll let me stock up and just hand a client a > key. Great excuse to visit the locals and show my smiling face. > > Cheers, > > > Matt Robertson [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > > > -Original Message- > From: Stan Winchester [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 21, 2003 9:27 PM > To: CF-Talk > Subject: Storing Credit Card Info > > > Kay, > > Isn't technology great! I think the USB thumb drive is a wonderful idea! > If you could make a Windows utility and make using cfx_textcrypt / > cfx_cardcrypt a turn key process, then that is even better! When I first > asked my question about if there was a "best practice" to > store/implement the private key for cfx_textcrypt, I had no idea I would > get this kind of input. I am really impressed with the CF-Talk > community, and the way everyone pulls together to help each other. > > Thank you to all CF-Talkers, > Stan Winchester > AfterShock Web Design, LLC > [EMAIL PROTECTED] > http://www.aftershockweb.com/ > Tel. 503-244-3440 > Fax 503-244-3454 > > >Matt Robertson wrote: > >> You guessed it: I train the client to keep the private key in a text > > >> file on their own desktop or someplace safe locally. > > > >I've been thinking about doing something with one of those USB thumb > >drives - I don't know about the rest of the world but here in > >Australia you can now get the smallest (64MB, USB2) for around 20 > >bucks. Seems to me like a nice way of doing it - tell the client that > >when they're finished, they should unplug the "key" and put it back in > >the locked drawer or filing cabinet or whatever. We're even thinking > >of writing some kind of little Windows utility on it that pastes the > >key (stored on the drive) into the clipboard or even looks for the > >form field in the browser window. Just to cut out a step for the > >less-than-savvy client - and we all have *at least* one of those :) > > > >Anyway, I don't keep up with CFTALK as much as I'd like these days, > >but I work for PerthWeb, developers of cardcrypt and textcrypt. We > >also have a Windows-based decryption utility now, so you can encrypt > >the credit card number and email it to our client for manual > >processing if they don't have real-time processing (and you don't want > >to mess with PGP licensing). If anyone has any questions about any of > >our encryption products, please email me directly ([EMAIL PROTECTED] > >au). > > > >Cheers, > >Kay. > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Active PDF?
Howdy - I have a client who wanted to convert a number of Word-created forms to PDF's and put them up on their site. No sweat. Then, they wanted the user to be able to fill out form fields and have Acrobat do all the math, and they could print out a nice, cleanly filled-out form to sign and fax. Again, no problem at all. Now, however, they'd like to take the final step and have fully interactive PDF's - where certain dynamic fields are populated from database information, and the user can "submit" the PDF like they would any other web form and have CF process it accordingly. I've looked at ActivePDF, but before I dive into that, I wanted to send out some feelers to the group to see if anyone's worked with that with CF5 before. Money's not an object (to a point), so if there's a particularly awesome package there I should look into, I'm open to some suggestions. I am fiddling with XSL:FO syntax right now, but it's not exactly what I'm looking for, since I have to work off a previously-existing document (and I don't have a great deal of time to really get elbow-deep in *yet another* XML spec.) :) Thanks, - Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: xml XPath Equivalent in CF Notation
On Tuesday, Jun 24, 2003, at 20:04 US/Pacific, Joe Eugene wrote: > Cant figure this one out OR is it possible in CF xml Notation. > > XML.. > > > Java Programming > Ivor Horton > Ivor Horton > > > Here is what i want to return using XPath...All the "Author" for node > Element "Book" > > > > What is the CF Equivalent to the above in CFMX Notation > odoc.xmlRoot.Book[1]...? You can get to the elements of but that will be an array (I think) and you'll have to manually iterate through each element to see whether it is or not. Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
xml XPath Equivalent in CF Notation
Cant figure this one out OR is it possible in CF xml Notation. XML.. Java Programming Ivor Horton Ivor Horton Here is what i want to return using XPath...All the "Author" for node Element "Book" What is the CF Equivalent to the above in CFMX Notation odoc.xmlRoot.Book[1]...? Thanks, Joe Eugene ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Client variable problem -- duplicates in CDATA
Yet another reason why I hate to use CFID and CFTOKEN. Roll your own is the way to go... The recommendation to use UUIDs is probably your best bet. How long will it take to modify your code? Another solution is to manually clean out the CDATA and CGLOBAL tables. My guess is you have a bunch of old records in there where people haven't come back in AGES. Remember, CF has been known to not properly clean up the CDATA and CGLOBAL tables even though the CFAdmin settings are in there. You'll be able to quickly determine this by looking at your database tables (please tell me you ARE using database tables right?) -Novak - Original Message - From: "John Paul Ashenfelter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 1:17 PM Subject: Client variable problem -- duplicates in CDATA > Hi folks, > > Working with a client on an existing website -- we're getting this error: > > "Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'" > > We're using ColdFusion 5, MS-SQL 2000, Win2k server, Apache 1.3.24 web server. Client variables are being stored in an ODBC database. > > Of course it's straightforward to remove the offending row, but it's happening about once a week now to random visitors (that is, one or maybe two errors per week). Any thoughts? Googling turned up 2 not too useful hits. No luck in MM technotes so far, other than the suggestion to go to UUID-based keys, which would require reworking parts of the application. > > We've got about 400,000+ client ids/month, which seems really high to me based on site traffic, so I think somethings going on with the weird session/client/cookie "security" management code written by the original developers. Using Pro, not Enterprise so MIB client variables shouldn't be an issue. Any other thoughts? > > > Regards, > > John Paul Ashenfelter > CTO/Transitionpoint > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: http://www.maxfusion.co.uk/freebies.cfm
Neil and Brian, Thanks very much guys, I was looking for this everywhere. Seems the old copies aren't where they used to be. Although after compiling openssl yesterday all I had to do was the last step.. this one is already done for me. Regards, Jared Clinton. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 June 2003 10:32 PM To: CF-Talk Subject: http://www.maxfusion.co.uk/freebies.cfm Hey Christian Is the cfdecrpyt listed here allowed with MM? Thanks Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
site director question...
anyone have a minute to help me with site director 3? thanks! tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP still and again
>No work-around if you don't control the other side...gotta use an >external component of some kind. There are a few cfx_http's floating >around, i prefer msxml though since it's already on every windows >server. > >%3Crant%3E >Don't fall for the MM spin...4.5 was fine, it was just up to the >developer to be compliant by using urlEncodedFormat(). >%3C%2Frant%3E Oh haven't I screamed that at the top of my lungs over and over. :) I just don't believe the name portion should be encoded. That's why I don't name form fields with spaces and quotes and stuff like that. :) -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development & Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFHTTP still and again
>I believe that the HTTP 1.1 specification recommends, but does not >require, that the url, cookie, and form posts be URL encoded. >ColdFusion 4.5.x did not conform to the recommendations, but >ColdFusion 5.0 does. Check the content-type header on the HTTP >Request, I believe its >CONTENT_TYPE=application/x-www-form-urlencoded. > >The workaround is to operate on the name/value pairs with some >implementation of urldecode() on the receiving end. Yeah, that's always the problem. No control over the receiving end and ColdFusion seems to be the only application that encodes the name portion of the name/value pair. If I could find some spec somewhere that says that the name portion should be encoded, that would be wonderful. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development & Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP still and again
No work-around if you don't control the other side...gotta use an external component of some kind. There are a few cfx_http's floating around, i prefer msxml though since it's already on every windows server. %3Crant%3E Don't fall for the MM spin...4.5 was fine, it was just up to the developer to be compliant by using urlEncodedFormat(). %3C%2Frant%3E -- mailto:[EMAIL PROTECTED] Tuesday, June 24, 2003, 7:20:22 PM, you wrote: B> OK. Macromedia convinced me that they did the correct thing with CF B> 5.0 and fixed cfhttp to be http 1.1 compliant by encoding the form B> variables. Now I've hit a snag where I'm submitting form variables in B> CF 5 and the variables are being encoded along with the values. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFHTTP still and again
I believe that the HTTP 1.1 specification recommends, but does not require, that the url, cookie, and form posts be URL encoded. ColdFusion 4.5.x did not conform to the recommendations, but ColdFusion 5.0 does. Check the content-type header on the HTTP Request, I believe its CONTENT_TYPE=application/x-www-form-urlencoded. The workaround is to operate on the name/value pairs with some implementation of urldecode() on the receiving end. -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 7:20 PM To: CF-Talk Subject: CFHTTP still and again OK. Macromedia convinced me that they did the correct thing with CF 5.0 and fixed cfhttp to be http 1.1 compliant by encoding the form variables. Now I've hit a snag where I'm submitting form variables in CF 5 and the variables are being encoded along with the values. Example, the body of the post, which should look like this (according to the payment gateway tech folks)... &Field_1=value1&Field_2=value2 looks like this... &Field%5F1=value1&Field%5F2=value2 Note the underscores are being url encoded. So which is right? Should the entire POST be encoded or just the values? The tech folks say they have NEVER received a form post with the variable names encoded before. Thanks for any insight. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development & Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Storing Credit Card Info
Yup it sure would. Didn't think that post thru too well. The user will have to initiate the key load via a file upload-type form. Also key storage after creation will have to be pushed with cfcontent so that a file dialog opens up and the user makes the hopefully correct decision on where to store it. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFHTTP still and again
OK. Macromedia convinced me that they did the correct thing with CF 5.0 and fixed cfhttp to be http 1.1 compliant by encoding the form variables. Now I've hit a snag where I'm submitting form variables in CF 5 and the variables are being encoded along with the values. Example, the body of the post, which should look like this (according to the payment gateway tech folks)... &Field_1=value1&Field_2=value2 looks like this... &Field%5F1=value1&Field%5F2=value2 Note the underscores are being url encoded. So which is right? Should the entire POST be encoded or just the values? The tech folks say they have NEVER received a form post with the variable names encoded before. Thanks for any insight. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development & Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Thanks jochem... As ever!! On 24/6/03 23:52, "Jochem van Dieten" <[EMAIL PROTECTED]> wrote: > Ryan Mitchell wrote: >> >> Seems to be a bit hit and miss, it does the trick for querying db's, but >> inserts and stuff seem to be inserting funny chars... My pages have the >> >> > > That is not sufficient, it is overruled by the HTTP header which > defaults to UTF-8 in CF MX. > > >> And >> >> > > setEncoding() and cfcontent: > http://www.macromedia.com/support/coldfusion/internationalization/internationa > lization_cfmx/ > > Jochem > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Homesite + question
Homesite is on the studio CD (win-only, obviously), but you have to browse the CD to get to it; it's not in the nice flash installer thingy. You have to install it from there, the trial applications that you can download can't be converted to licensed applications that I've found. Kind of annoying, but such is life. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -Original Message- > From: John Wilker [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 3:51 PM > To: CF-Talk > Subject: Homesite + question > > > I downloaded the most recent Homesite plus installer and it's > trial. I have > a legit license for Studio MX, how do I get HS+ to see that? > > Hope that made sense. > > J > John Wilker > Software Engineer, Technical Writer > Sequent Technologies. > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple Messages
Yup. loads of 'em. --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- Original Message -- From: "Barney Boisvert" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 24 Jun 2003 15:15:17 -0700 >Is anyone else getting a fair number of dupes from the list? I've gotten at >least 3 copies of several messages, and at least 2 copies of many more. > >barneyb > >--- >Barney Boisvert, Senior Development Engineer >AudienceCentral >[EMAIL PROTECTED] >voice : 360.756.8080 x12 >fax : 360.647.5351 > >www.audiencecentral.com > >--- >Outgoing mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.491 / Virus Database: 290 - Release Date: 6/18/2003 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Storing Credit Card Info
>That presupposes I can do something where CF determines a list of >available drives. Haven't taken the time to figure out if CF has any >built-in functions to help with that task, or if its even possible. Hmmm... wouldn't you need some kind of signed ActiveX object or something to allow the browser access to the user's filesystem? K. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BLOBs and CF
On Tuesday, June 24, 2003, at 05:13 PM, Barney Boisvert wrote: > And it's worth mentioning that you can append URL variable in the IMG > tag, which obviously get passed to the CF template that generates the > image. That's a decent way to store all of your site's images in a database, if you are so inclined: Christian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: BLOBs and CF
IWasHere=True -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 3:35 PM To: CF-Talk Subject: RE: BLOBs and CF > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 5:14 PM > To: CF-Talk > Subject: RE: BLOBs and CF > > That's also a good way to see how many people read an HTML formatted email > that you send out. Not spam, of course, but periodic newsletter or the > like. And it's worth mentioning that you can append URL variable in the > IMG > tag, which obviously get passed to the CF template that generates the > image. And to round out the communication you can add cookies to the return to lay your server's mark on the sucker... I mean "patron". ;^) Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Homesite + question
> I downloaded the most recent Homesite plus installer and > it's trial. I have a legit license for Studio MX, how do > I get HS+ to see that? If I recall correctly, you should be able to use your Dreamweaver MX serial number during the install. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Ryan Mitchell wrote: > > Seems to be a bit hit and miss, it does the trick for querying db's, but > inserts and stuff seem to be inserting funny chars... My pages have the > > That is not sufficient, it is overruled by the HTTP header which defaults to UTF-8 in CF MX. > And > > setEncoding() and cfcontent: http://www.macromedia.com/support/coldfusion/internationalization/internationalization_cfmx/ Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Ryan Mitchell wrote: > Where do you add that connection string? > In the cfadmin or within the query? Admin, under advanced. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Client variable problem -- duplicates in CDATA
I've heard of people doing weird things like trying to keep a client on a single cfid token set of numbers. I'd check if something like this is going on. They may of tried to finagle some stuff with cfapplication. DRE -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:18 PM To: CF-Talk Subject: Client variable problem -- duplicates in CDATA Hi folks, Working with a client on an existing website -- we're getting this error: "Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'" We're using ColdFusion 5, MS-SQL 2000, Win2k server, Apache 1.3.24 web server. Client variables are being stored in an ODBC database. Of course it's straightforward to remove the offending row, but it's happening about once a week now to random visitors (that is, one or maybe two errors per week). Any thoughts? Googling turned up 2 not too useful hits. No luck in MM technotes so far, other than the suggestion to go to UUID-based keys, which would require reworking parts of the application. We've got about 400,000+ client ids/month, which seems really high to me based on site traffic, so I think somethings going on with the weird session/client/cookie "security" management code written by the original developers. Using Pro, not Enterprise so MIB client variables shouldn't be an issue. Any other thoughts? Regards, John Paul Ashenfelter CTO/Transitionpoint ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiple Messages
Is anyone else getting a fair number of dupes from the list? I've gotten at least 3 copies of several messages, and at least 2 copies of many more. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 6/18/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Database Availability
> > > I have a two identical databases on different sql boxes. One > > > primary and > > one back up. I would like to be able to do something like this in > > the application.cfm You should use an automatic failover. A quick search on the all knowing oracle revealed this gnomic answer " I think that "Merge replication with updating subscribers" should work for you: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql /reploptions_34hf.asp Cheers" And "http://doc.ddart.net/mssql/sql70/2_003_16.htm"; These are sql server specific, as you don't seem to identify which product you are using. Jon. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Homesite + question
I downloaded the most recent Homesite plus installer and it's trial. I have a legit license for Studio MX, how do I get HS+ to see that? Hope that made sense. J John Wilker Software Engineer, Technical Writer Sequent Technologies. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: BLOBs and CF
> -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 5:14 PM > To: CF-Talk > Subject: RE: BLOBs and CF > > That's also a good way to see how many people read an HTML formatted email > that you send out. Not spam, of course, but periodic newsletter or the > like. And it's worth mentioning that you can append URL variable in the > IMG > tag, which obviously get passed to the CF template that generates the > image. And to round out the communication you can add cookies to the return to lay your server's mark on the sucker... I mean "patron". ;^) Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Ok I added it in the cfadmin... Seems to be a bit hit and miss, it does the trick for querying db's, but inserts and stuff seem to be inserting funny chars... My pages have the And Lines in them... Is there anything else I should be putting in?? On 24/6/03 22:16, "Jochem van Dieten" <[EMAIL PROTECTED]> wrote: > Bryan Love wrote: >> What version of MySQL are you using? Try switching to 4.1 if you aren't >> using it... > > You are recommending people to switch to an alpha release? > > It might be a better idea to try the following in the connectionstring > first (presuming the database charset is iso-8859-1): > useUnicode=true&characterEncoding=iso-8859-1 > > Jochem > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Where do you add that connection string? In the cfadmin or within the query? On 24/6/03 22:16, "Jochem van Dieten" <[EMAIL PROTECTED]> wrote: > Bryan Love wrote: >> What version of MySQL are you using? Try switching to 4.1 if you aren't >> using it... > > You are recommending people to switch to an alpha release? > > It might be a better idea to try the following in the connectionstring > first (presuming the database charset is iso-8859-1): > useUnicode=true&characterEncoding=iso-8859-1 > > Jochem > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I remember...a macintosh version of cfmx...but...can't...find...it...
On Tuesday, Jun 24, 2003, at 13:17 US/Pacific, Barney Boisvert wrote: > Interesting, I'd never thought of doing it with mod_rewrite. That > module is > amazing. Damn confusing sometimes, but amazing none the less. Have > to play > with doing it that way. It's a very powerful module - it can conditionally set cookies, conditionally rewrite URLs, proxy requests, set Apache environment variables... > As for the XML file to allow files outside the approot, any idea what > file > it might be? I didn't see anything even remotely promsising on my > cursory > scan of the XML files in the web root. It seems like it should be a > CF-related file, rather than one pertaining to the underlying J2EE > server, > but I could be way off base. WEB-INF/jrun-web.xml is where you would normally add: / /Users/scorfiel/Sites I don't know what the equivalent is for Tomcat. Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Charsets when querying db
My mistake, I was reading up on the differences in unicode handling between 4.0 and 4.1 and I had 4.1 on my mind. Jochem is correct, you would not want to use 4.1. Good lookin' out, Jochem! +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:16 PM To: CF-Talk Subject: Re: Charsets when querying db Bryan Love wrote: > What version of MySQL are you using? Try switching to 4.1 if you aren't > using it... You are recommending people to switch to an alpha release? It might be a better idea to try the following in the connectionstring first (presuming the database charset is iso-8859-1): useUnicode=true&characterEncoding=iso-8859-1 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vertical Display...
I've got a sample of this code up at http://charlie.griefer.com/dyn_cols.cfm (server's kinda sluggish today...so bear with me) :) charlie - Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 2:20 PM Subject: Re: Vertical Display... > > > > > > > row)> > > > > > > > > > > #data[col][row]# > > > > > > > > Haven't checked this, and you'd need also to check what happens when > listlen(PairSizeList) is not a multiple of 4. > > Matthew Walker > Electric Sheep Web > http://www.electricsheep.co.nz/ > > > > - Original Message - > From: "Che Vilnonis" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, June 25, 2003 9:07 AM > Subject: Vertical Display... > > > > Last week there was code to display a query's content's 'vertically'. Say > I > > have the folllowing list: > > > > > > "8,8.5,9,10,11,12,13,14,15,16,17,18,19,20,22,24,26,28,30,32,34,36,38,40,42,4 > > 4,46,48"> > > > > How would I display that list in a table 'vertically' with 4 columns??? > > > > TIA-Ché > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Vertical Display...
here's another version: ",maxPerCol-(end-start))> #pairSizeArr[j]# #xtra# +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:25 PM To: CF-Talk Subject: RE: Vertical Display... matthew...you da man! thanks! -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 5:21 PM To: CF-Talk Subject: Re: Vertical Display... #data[col][row]# Haven't checked this, and you'd need also to check what happens when listlen(PairSizeList) is not a multiple of 4. Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: "Che Vilnonis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2003 9:07 AM Subject: Vertical Display... > Last week there was code to display a query's content's 'vertically'. Say I > have the folllowing list: > > "8,8.5,9,10,11,12,13,14,15,16,17,18,19,20,22,24,26,28,30,32,34,36,38,40,42,4 > 4,46,48"> > > How would I display that list in a table 'vertically' with 4 columns??? > > TIA-Ché > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
I've done this, and it worked well. Before I set my DSN, I did a cfquery, "Select "foo" as bar from myTable" Another way to do it is to write a custom tag wrapper for , and call it as you would cfquery: . The internals of the custom tag do a try, and if the query fails, they use dsn2. I've done things like this, too, and they also worked well, with little extra overhead. Jamie On Tue, 24 Jun 2003 13:23:07 -0700, in cf-talk you wrote: >wow - thank you all so much for the useful info. I do like the idea of the >external app. I wonder if an app like that could be used for load >balancing - but of course my VB and C++ skills suck. >Cheers > >Richard >- Original Message - >From: "Jim McAtee" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Tuesday, June 24, 2003 1:13 PM >Subject: Re: Database Availability > > >> Assuming you're using an ODBC datasource... How about an external >application >> this is constantly checking the availability of the databases in question, >and >> modifies the ODBC DSN to point at a working one? >> >> >> - Original Message - >> From: "admin" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> Sent: Tuesday, June 24, 2003 1:33 PM >> Subject: Database Availability >> >> >> > I hope that this isn't a stipid question but I'm sure it must have been >asked >> before. >> > >> > I have a two identical databases on different sql boxes. One primary and >one >> back up. I would like to be able to do something like this in the >> application.cfm >> > >> > >> > >> > >> > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Client variable problem -- duplicates in CDATA
How often are you purging the client store? Also, the switch to UUID-based keys is usually painless (just the flip of a switch), but I guess you're doing something odd with the client tokens? Jamie On Tue, 24 Jun 2003 16:17:46 -0400, in cf-talk you wrote: >Hi folks, > >Working with a client on an existing website -- we're getting this error: > >"Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'" > >We're using ColdFusion 5, MS-SQL 2000, Win2k server, Apache 1.3.24 web server. Client >variables are being stored in an ODBC database. > >Of course it's straightforward to remove the offending row, but it's happening about >once a week now to random visitors (that is, one or maybe two errors per week). Any >thoughts? Googling turned up 2 not too useful hits. No luck in MM technotes so far, >other than the suggestion to go to UUID-based keys, which would require reworking >parts of the application. > >We've got about 400,000+ client ids/month, which seems really high to me based on >site traffic, so I think somethings going on with the weird session/client/cookie >"security" management code written by the original developers. Using Pro, not >Enterprise so MIB client variables shouldn't be an issue. Any other thoughts? > > >Regards, > >John Paul Ashenfelter >CTO/Transitionpoint > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Vertical Display...
matthew...you da man! thanks! -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 5:21 PM To: CF-Talk Subject: Re: Vertical Display... #data[col][row]# Haven't checked this, and you'd need also to check what happens when listlen(PairSizeList) is not a multiple of 4. Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: "Che Vilnonis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2003 9:07 AM Subject: Vertical Display... > Last week there was code to display a query's content's 'vertically'. Say I > have the folllowing list: > > "8,8.5,9,10,11,12,13,14,15,16,17,18,19,20,22,24,26,28,30,32,34,36,38,40,42,4 > 4,46,48"> > > How would I display that list in a table 'vertically' with 4 columns??? > > TIA-Ché > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vertical Display...
#data[col][row]# Haven't checked this, and you'd need also to check what happens when listlen(PairSizeList) is not a multiple of 4. Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: "Che Vilnonis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2003 9:07 AM Subject: Vertical Display... > Last week there was code to display a query's content's 'vertically'. Say I > have the folllowing list: > > "8,8.5,9,10,11,12,13,14,15,16,17,18,19,20,22,24,26,28,30,32,34,36,38,40,42,4 > 4,46,48"> > > How would I display that list in a table 'vertically' with 4 columns??? > > TIA-Ché > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Vertical Display...
yes sirthat would be correct? a code snippet would be great! -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 5:13 PM To: CF-Talk Subject: Re: Vertical Display... By vertically, you mean 810 14 18 811 15 19 512 16 20 913 17 22 ? Jerry Johnson >>> [EMAIL PROTECTED] 06/24/03 05:07PM >>> Last week there was code to display a query's content's 'vertically'. Say I have the folllowing list: How would I display that list in a table 'vertically' with 4 columns??? TIA-ChT ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Vertical Display...
here is the query version (I did it with states): ...query for all states... #stateName# : The list version would be similar: . +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:07 PM To: CF-Talk Subject: Vertical Display... Last week there was code to display a query's content's 'vertically'. Say I have the folllowing list: How would I display that list in a table 'vertically' with 4 columns??? TIA-Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
I've done this, and it worked well. Before I set my DSN, I did a cfquery, "Select "foo" as bar from myTable" Another way to do it is to write a custom tag wrapper for , and call it as you would cfquery: . The internals of the custom tag do a try, and if the query fails, they use dsn2. I've done things like this, too, and they also worked well, with little extra overhead. Jamie On Tue, 24 Jun 2003 13:23:07 -0700, "admin" <[EMAIL PROTECTED]> wrote: >wow - thank you all so much for the useful info. I do like the idea of the >external app. I wonder if an app like that could be used for load >balancing - but of course my VB and C++ skills suck. >Cheers > >Richard >- Original Message - >From: "Jim McAtee" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Tuesday, June 24, 2003 1:13 PM >Subject: Re: Database Availability > > >> Assuming you're using an ODBC datasource... How about an external >application >> this is constantly checking the availability of the databases in question, >and >> modifies the ODBC DSN to point at a working one? >> >> >> - Original Message - >> From: "admin" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> Sent: Tuesday, June 24, 2003 1:33 PM >> Subject: Database Availability >> >> >> > I hope that this isn't a stipid question but I'm sure it must have been >asked >> before. >> > >> > I have a two identical databases on different sql boxes. One primary and >one >> back up. I would like to be able to do something like this in the >> application.cfm >> > >> > >> > >> > >> > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Charsets when querying db
Bryan Love wrote: > What version of MySQL are you using? Try switching to 4.1 if you aren't > using it... You are recommending people to switch to an alpha release? It might be a better idea to try the following in the connectionstring first (presuming the database charset is iso-8859-1): useUnicode=true&characterEncoding=iso-8859-1 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vertical Display...
At 05:07 PM 6/24/2003 -0400, you wrote: >Last week there was code to display a query's content's 'vertically'. Say I >have the folllowing list: > >"8,8.5,9,10,11,12,13,14,15,16,17,18,19,20,22,24,26,28,30,32,34,36,38,40,42,4 >4,46,48"> > >How would I display that list in a table 'vertically' with 4 columns??? Figure out your list length divvy by 4... so for that list, it would be... 28 / 4 = 7. Might have to round if your list isn't evenly divisible by 4, so that the last column comes up short. Then loop on your list... since you're talking columns, you're going to be putting this in a table, with one row, four cells. Whenever your list loop hits (in this case) seven items, close the , open a new . How you keep track of when it hits that point is up to you... might just start a counter, increment it by one every time, and when that counter hits your target value, zero it out and do the bits. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: BLOBs and CF
That's also a good way to see how many people read an HTML formatted email that you send out. Not spam, of course, but periodic newsletter or the like. And it's worth mentioning that you can append URL variable in the IMG tag, which obviously get passed to the CF template that generates the image. --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -Original Message- > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 1:47 PM > To: CF-Talk > Subject: BLOBs and CF > > > Just thought some others would like to see this. Using the > information that Christain provided ( from > http://www.markme.com/cantrell/archives/002736.cfm ) I did some playing. > > Place the appended code in it's own template (let's say > "FauxGIF.cfm"). Then call the template in an tag as in > - you'll get a single, pixel transparent > gif in the browser. > > This technique works in any version of CF higher than 4.5. Also > note that the graphic itself was previously converted to base64 > and that text saved for use here: this template is completely > self-contained: no source graphic is needed. > > You could of course use CFFILE and the toBase64() function to > capture the code needed for any image (or file for that matter, > but then you'd have to change the encoding). > > As it stands you'd be able to use this for page tracking or > somesuch. Changing the graphic (perhaps storing the encoded text > in a DB) and this makes for a nice foundation for a advertising > or logo tracking system. > > Sorry if this is old news... but I'm an old dog. It delights and > amazes me when, against all traditional wisdom, I learn a new trick. ;^) > > Here's page: > > > > > > > > #ToString(ToBinary("R0lGODlhAQABAIAAAP///wAAA CH5BAEALAABAAEAAAICRAEAOw=="))# --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 6/18/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vertical Display...
By vertically, you mean 810 14 18 811 15 19 512 16 20 913 17 22 ? Jerry Johnson >>> [EMAIL PROTECTED] 06/24/03 05:07PM >>> Last week there was code to display a query's content's 'vertically'. Say I have the folllowing list: How would I display that list in a table 'vertically' with 4 columns??? TIA-ChT ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Vertical Display...
Last week there was code to display a query's content's 'vertically'. Say I have the folllowing list: How would I display that list in a table 'vertically' with 4 columns??? TIA-Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Charsets when querying db
What version of MySQL are you using? Try switching to 4.1 if you aren't using it... http://www.mysql.com/doc/en/Charset-Unicode.html +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 1:45 PM To: CF-Talk Subject: Charsets when querying db Hello Im having some trouble with querying my db (Mysql on mx), and im getting ú replaced by funny characters and all sorts like that. I have a feeling its to do with the character sets the db is returning, and the charset on the page... I tried to change the page charset, but no difference, is there any way of forcing the db to return a charset... Either that or its a problem with cfmx... :) Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Charsets when querying db
Hello Im having some trouble with querying my db (Mysql on mx), and im getting ú replaced by funny characters and all sorts like that. I have a feeling its to do with the character sets the db is returning, and the charset on the page... I tried to change the page charset, but no difference, is there any way of forcing the db to return a charset... Either that or its a problem with cfmx... :) Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
BLOBs and CF
Just thought some others would like to see this. Using the information that Christain provided ( from http://www.markme.com/cantrell/archives/002736.cfm ) I did some playing. Place the appended code in it's own template (let's say "FauxGIF.cfm"). Then call the template in an tag as in - you'll get a single, pixel transparent gif in the browser. This technique works in any version of CF higher than 4.5. Also note that the graphic itself was previously converted to base64 and that text saved for use here: this template is completely self-contained: no source graphic is needed. You could of course use CFFILE and the toBase64() function to capture the code needed for any image (or file for that matter, but then you'd have to change the encoding). As it stands you'd be able to use this for page tracking or somesuch. Changing the graphic (perhaps storing the encoded text in a DB) and this makes for a nice foundation for a advertising or logo tracking system. Sorry if this is old news... but I'm an old dog. It delights and amazes me when, against all traditional wisdom, I learn a new trick. ;^) Here's page: #ToString(ToBinary("R0lGODlhAQABAIAAAP///wAAACH5BAEALAABAAEAAAICRAEAOw=="))# ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
No need to write a custom program...all you need is an uptime monitor that can fire an external executable, like What's Up, and a program that will modify a registry key when the service you are monitoring goes down...like this one from the Resource Kit. http://www.mkssoftware.com/docs/man1/registry.1.asp -- jon mailto:[EMAIL PROTECTED] Tuesday, June 24, 2003, 4:23:07 PM, you wrote: a> wow - thank you all so much for the useful info. I do like the idea of the a> external app. I wonder if an app like that could be used for load a> balancing - but of course my VB and C++ skills suck. a> Cheers a> Richard a> - Original Message - a> From: "Jim McAtee" <[EMAIL PROTECTED]> a> To: "CF-Talk" <[EMAIL PROTECTED]> a> Sent: Tuesday, June 24, 2003 1:13 PM a> Subject: Re: Database Availability >> Assuming you're using an ODBC datasource... How about an external a> application >> this is constantly checking the availability of the databases in question, a> and >> modifies the ODBC DSN to point at a working one? >> >> >> - Original Message - >> From: "admin" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> Sent: Tuesday, June 24, 2003 1:33 PM >> Subject: Database Availability >> >> >> > I hope that this isn't a stipid question but I'm sure it must have been a> asked >> before. >> > >> > I have a two identical databases on different sql boxes. One primary and a> one >> back up. I would like to be able to do something like this in the >> application.cfm >> > >> > >> > >> > >> > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
wow - thank you all so much for the useful info. I do like the idea of the external app. I wonder if an app like that could be used for load balancing - but of course my VB and C++ skills suck. Cheers Richard - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 1:13 PM Subject: Re: Database Availability > Assuming you're using an ODBC datasource... How about an external application > this is constantly checking the availability of the databases in question, and > modifies the ODBC DSN to point at a working one? > > > - Original Message - > From: "admin" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, June 24, 2003 1:33 PM > Subject: Database Availability > > > > I hope that this isn't a stipid question but I'm sure it must have been asked > before. > > > > I have a two identical databases on different sql boxes. One primary and one > back up. I would like to be able to do something like this in the > application.cfm > > > > > > > > > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Client variable problem -- duplicates in CDATA
Hi folks, Working with a client on an existing website -- we're getting this error: "Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'" We're using ColdFusion 5, MS-SQL 2000, Win2k server, Apache 1.3.24 web server. Client variables are being stored in an ODBC database. Of course it's straightforward to remove the offending row, but it's happening about once a week now to random visitors (that is, one or maybe two errors per week). Any thoughts? Googling turned up 2 not too useful hits. No luck in MM technotes so far, other than the suggestion to go to UUID-based keys, which would require reworking parts of the application. We've got about 400,000+ client ids/month, which seems really high to me based on site traffic, so I think somethings going on with the weird session/client/cookie "security" management code written by the original developers. Using Pro, not Enterprise so MIB client variables shouldn't be an issue. Any other thoughts? Regards, John Paul Ashenfelter CTO/Transitionpoint ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I remember...a macintosh version of cfmx...but...can't...find...it...
Interesting, I'd never thought of doing it with mod_rewrite. That module is amazing. Damn confusing sometimes, but amazing none the less. Have to play with doing it that way. As for the XML file to allow files outside the approot, any idea what file it might be? I didn't see anything even remotely promsising on my cursory scan of the XML files in the web root. It seems like it should be a CF-related file, rather than one pertaining to the underlying J2EE server, but I could be way off base. cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -Original Message- > From: Sean A Corfield [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 12:45 PM > To: CF-Talk > Subject: Re: I remember...a macintosh version of > cfmx...but...can't...find...it... > > > On Tuesday, Jun 24, 2003, at 11:10 US/Pacific, Barney Boisvert wrote: > > Say you've got Tomcat w/ CFMX running, along with an Apache 2 install, > > and > > you want to connect Tomcat to Apache to share the job of serving > > content. > > How would you go about doing it? > > You have several options. > > > The ideal setup would allow CF pages to > > reside outside /cfusion, and the Apache/Tomcat connector would be > > mod_jk2. > > CF pages can reside anywhere - you can change the document root in one > of the XML files. I haven't done it for Tomcat but I have done it for > JRun (although I use the JRun Management Console to set the document > root to avoid editing XML files!). > > Then I use mod_proxy and mod_rewrite rather than the connector module. > I do this because I have multiple sites running through the same Apache > instance. My rewrite rule looks like this: > > RewriteRule ^/cfusion(.*)$ http://127.0.0.1:8180/cfusion$1 [P,L] > > That rewrites and proxies all URLs beginning with /cfusion to the > Tomcat instance. You could easily do this: > > RewriteRule ^/(.*\.cf[cm])$ http://127.0.0.1:8180/$1 [P,L] > > That would map all .cfm / .cfc requests to Tomcat. You'd want > additional rewrites for .jsp and a special one for the Flash Remoting > gateway. > > For the development environment I have set up, this is just more > flexible for me. > > Sean A Corfield -- http://www.corfield.org/blog/ > > "If you're not annoying somebody, you're not really alive." > -- Margaret Atwood > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
Assuming you're using an ODBC datasource... How about an external application this is constantly checking the availability of the databases in question, and modifies the ODBC DSN to point at a working one? - Original Message - From: "admin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 1:33 PM Subject: Database Availability > I hope that this isn't a stipid question but I'm sure it must have been asked before. > > I have a two identical databases on different sql boxes. One primary and one back up. I would like to be able to do something like this in the application.cfm > > > > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
I used to have a script that ran a query and if it failed(using cfcatch) it fired an ASP page that used ADSI and recycled the cf server. This was on a CF4 box and the cf server would lose contact with the database and resetting the cf service fixed that. Clint - Original Message - From: "jon hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 3:09 PM Subject: Re: Database Availability > I can't say if it works or not, but you could try the > cf_IsColdFusionDataSource(dsn) function. > > One probably crazy idea off the top of my head, would be to write a > program that checked to see if the database is up, if not, switch the > ip address in the CF DSN settings in the registry (or wherever MX > stores it), and the switch should be transparent to pretty much > everything. > ...or maybe have the above connection testing set a server variable to > the connect string or provider dsn, and just use that server variable > in your cfquerys. > > Lot's more ways really...these ideas are pretty low tech as redundancy > solutions go. If you want to hit everything with the CF hammer > though... ;-) > > -- > jon > mailto:[EMAIL PROTECTED] > > Tuesday, June 24, 2003, 3:33:47 PM, you wrote: > a> I hope that this isn't a stipid question but I'm sure it must have been asked before. > > a> I have a two identical databases on different sql boxes. One primary and one back up. I would like to be able to do something like this in the application.cfm > > a> > a> > a> > a> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BLOBs and CF
Donnie, it's in the latest issue of aspnetPro. The article is called Easy Uploads Get files to your site with SQL server. Unfortunately you have to subscribe to the magazine to get the article. It's on their site as well http://www.aspnetpro.com but you have to be a paid subscriber to view the article. I'm not at home so I don't have anything specific I can take from the article and off the top of my head can't state any facts from it(wouldn't want to misquote anything). If you are interested in reading it you can email me off list and I might be able to email you the text of the article. Ben - Original Message - From: "Donnie Bachan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 3:42 PM Subject: Re: BLOBs and CF > Ben said: > " > I'd have to agree with Paul on this one. In one of the new issues of > aspNetPro magazine there is an article about storing files in your Database. > It is becoming more common to store images, files etc.. in your DB rather > than just putting a link to the file. Security is handled by the DB as well > so you don't worry as much about setting up secure directories. > " > > Ben, do you have the details on that issue of aspNetPro mag? Since this will > most likely end up using SQL Server that article may be very pertinent. > > The DB giants (Oracle,MS) obviously offer BLOBs as a datatype for a reason. > It has always been my personal practice to store the links to the file in > the DB and the actual files in the file system. After reading the comments > on both sides here I am beginning to think differently. I am still concerned > with the eventual size of the db if I store everything in there. On the > other hand using the system in a clustered may pose a problem although I > haven't fully investigated how one of the large DB vendors handle > replication etc. across the cluster. > > I agree that storing the files in the DB offers higher level of "protection" > of the files and that is a key point as far as I see. > > Thanks again for all those who have contributed to this discussion so far. > It is much appreciated. > > Best Regards, > > > Donnie Bachan > Phone: (718) 217-2883 > ICQ#: 28006783 > "Nitendo Vinces - By Striving You Shall Conquer" > == > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. > > _ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
I can't say if it works or not, but you could try the cf_IsColdFusionDataSource(dsn) function. One probably crazy idea off the top of my head, would be to write a program that checked to see if the database is up, if not, switch the ip address in the CF DSN settings in the registry (or wherever MX stores it), and the switch should be transparent to pretty much everything. ...or maybe have the above connection testing set a server variable to the connect string or provider dsn, and just use that server variable in your cfquerys. Lot's more ways really...these ideas are pretty low tech as redundancy solutions go. If you want to hit everything with the CF hammer though... ;-) -- jon mailto:[EMAIL PROTECTED] Tuesday, June 24, 2003, 3:33:47 PM, you wrote: a> I hope that this isn't a stipid question but I'm sure it must have been asked before. a> I have a two identical databases on different sql boxes. One primary and one back up. I would like to be able to do something like this in the application.cfm a> a> a> a> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Database Availability
cf doesn't handle this well at all. I have a check in an app like the below. The alivetest datasource has a short login timeout set on it. If the DB is up but there is an issue, this works. If the DB server is dead, as in off, or has disappeared, as in a network issue, this thing bombs. It, as well as any connection to the DB when this happens, ties up threads and causes general mayhem. I've thought about writing something that performs a ping/tnsping, but have not got to it. Our DB goes down so rarely that its not a high priority for me. This topic has seen some discussion before around here. select 42 as one from dual do whatever etc Doug >-Original Message- >From: Eric Creese [mailto:[EMAIL PROTECTED] >Sent: Tuesday, June 24, 2003 3:40 PM >To: CF-Talk >Subject: RE: Database Availability > > >Wouldn't these boxes be out of sync then as far as data goes? >I would hope you are applying some type of replication. > >I think you could set something up in the application file and >run a simple query to return a output from your prod box. If >there is a connection problem then you would know when you did >not return a value. you would want to trap that error so the >page would not fail though. > >-Original Message- >From: admin [mailto:[EMAIL PROTECTED] >Sent: Tuesday, June 24, 2003 2:34 PM >To: CF-Talk >Subject: Database Availability > > >I hope that this isn't a stipid question but I'm sure it must >have been asked before. > >I have a two identical databases on different sql boxes. One >primary and one back up. I would like to be able to do >something like this in the application.cfm > > > > >http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
run a query and catch any db errors... if an error is caught use the second one... - Original Message - From: "admin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 3:45 PM Subject: Re: Database Availability > the dbs's in quesion are read only and are automatically sync'd > - Original Message - > From: "Michael T. Tangorre" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, June 24, 2003 12:41 PM > Subject: Re: Database Availability > > > > I think the bigger issue would be how to keep them synched up if you > switch > > between them :-) > > > > > > - Original Message - > > From: "admin" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, June 24, 2003 3:33 PM > > Subject: Database Availability > > > > > > > I hope that this isn't a stipid question but I'm sure it must have been > > asked before. > > > > > > I have a two identical databases on different sql boxes. One primary and > > one back up. I would like to be able to do something like this in the > > application.cfm > > > > > > > > > > > > > > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
the dbs's in quesion are read only and are automatically sync'd - Original Message - From: "Michael T. Tangorre" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 12:41 PM Subject: Re: Database Availability > I think the bigger issue would be how to keep them synched up if you switch > between them :-) > > > - Original Message - > From: "admin" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, June 24, 2003 3:33 PM > Subject: Database Availability > > > > I hope that this isn't a stipid question but I'm sure it must have been > asked before. > > > > I have a two identical databases on different sql boxes. One primary and > one back up. I would like to be able to do something like this in the > application.cfm > > > > > > > > > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I remember...a macintosh version of cfmx...but...can't...find...it...
On Tuesday, Jun 24, 2003, at 11:10 US/Pacific, Barney Boisvert wrote: > Say you've got Tomcat w/ CFMX running, along with an Apache 2 install, > and > you want to connect Tomcat to Apache to share the job of serving > content. > How would you go about doing it? You have several options. > The ideal setup would allow CF pages to > reside outside /cfusion, and the Apache/Tomcat connector would be > mod_jk2. CF pages can reside anywhere - you can change the document root in one of the XML files. I haven't done it for Tomcat but I have done it for JRun (although I use the JRun Management Console to set the document root to avoid editing XML files!). Then I use mod_proxy and mod_rewrite rather than the connector module. I do this because I have multiple sites running through the same Apache instance. My rewrite rule looks like this: RewriteRule ^/cfusion(.*)$ http://127.0.0.1:8180/cfusion$1 [P,L] That rewrites and proxies all URLs beginning with /cfusion to the Tomcat instance. You could easily do this: RewriteRule ^/(.*\.cf[cm])$ http://127.0.0.1:8180/$1 [P,L] That would map all .cfm / .cfc requests to Tomcat. You'd want additional rewrites for .jsp and a special one for the Flash Remoting gateway. For the development environment I have set up, this is just more flexible for me. Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BLOBs and CF
Ben said: " I'd have to agree with Paul on this one. In one of the new issues of aspNetPro magazine there is an article about storing files in your Database. It is becoming more common to store images, files etc.. in your DB rather than just putting a link to the file. Security is handled by the DB as well so you don't worry as much about setting up secure directories. " Ben, do you have the details on that issue of aspNetPro mag? Since this will most likely end up using SQL Server that article may be very pertinent. The DB giants (Oracle,MS) obviously offer BLOBs as a datatype for a reason. It has always been my personal practice to store the links to the file in the DB and the actual files in the file system. After reading the comments on both sides here I am beginning to think differently. I am still concerned with the eventual size of the db if I store everything in there. On the other hand using the system in a clustered may pose a problem although I haven't fully investigated how one of the large DB vendors handle replication etc. across the cluster. I agree that storing the files in the DB offers higher level of "protection" of the files and that is a key point as far as I see. Thanks again for all those who have contributed to this discussion so far. It is much appreciated. Best Regards, Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 "Nitendo Vinces - By Striving You Shall Conquer" == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Database Availability
I think the bigger issue would be how to keep them synched up if you switch between them :-) - Original Message - From: "admin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 3:33 PM Subject: Database Availability > I hope that this isn't a stipid question but I'm sure it must have been asked before. > > I have a two identical databases on different sql boxes. One primary and one back up. I would like to be able to do something like this in the application.cfm > > > > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Database Availability
Wouldn't these boxes be out of sync then as far as data goes? I would hope you are applying some type of replication. I think you could set something up in the application file and run a simple query to return a output from your prod box. If there is a connection problem then you would know when you did not return a value. you would want to trap that error so the page would not fail though. -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:34 PM To: CF-Talk Subject: Database Availability I hope that this isn't a stipid question but I'm sure it must have been asked before. I have a two identical databases on different sql boxes. One primary and one back up. I would like to be able to do something like this in the application.cfm http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Database Availability
I hope that this isn't a stipid question but I'm sure it must have been asked before. I have a two identical databases on different sql boxes. One primary and one back up. I would like to be able to do something like this in the application.cfm http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Form Submission Hacking.
> perhaps you are right Dave. And Matt. > > I'm going to run over to the "Is Flash really that good" > thread to tell them that using flash solves this issue. No, unfortunately it doesn't. Flash content is just like any other client-side content in that respect. If you want to test this theory, just put up a Flash game on your site, have that game store high scores on your server, and see how quickly people put in impossible scores. For the life of me, I can't imagine why anyone would bother doing that - there's no logical incentive to do so - but it didn't take very long. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Client Variable in application.cfm
Yes.. I was doing it before the cfapplication statement.. That is fixed now.. But I'm still not clear about the client variables in the CFDATA table... When I delete all the client variables... How does and when do the records get removed completely? Thanks -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 11:55 AM To: CF-Talk Subject: Re: Client Variable in application.cfm My login stuff is cvar-based and handled in application.cfm too. Are you doing your login tests before the cfapplication statement? Code sample? --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- Original Message -- From: Tim Do <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 24 Jun 2003 10:09:38 -0700 >Hello all, > >What I'm trying to do is log the users out if they close their browser >window. I have a client variable set for the jsessionID after the user >logs in and in application.cfm checking whether that client var equals >to the current jsessionID why does application.cfm not know what >the client variable is? This worked before when all my variables were >sessions.. now I moved them all to client variables and this doesn't >seem to work anymore... It only works now if I move the logic to my >index.cfm and checking it there and logging the user out if the client >var and the jsessionid are different.. any ideas? > >Also... when I delete all the client variables like >DeleteClientVariable("browserSession") it deletes the data field in the >CFDATA table... how would I delete the whole record when a user logs >out? > >Thanks, >Tim > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Client Variable in application.cfm
My login stuff is cvar-based and handled in application.cfm too. Are you doing your login tests before the cfapplication statement? Code sample? --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- Original Message -- From: Tim Do <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 24 Jun 2003 10:09:38 -0700 >Hello all, > >What I'm trying to do is log the users out if they close their browser >window. I have a client variable set for the jsessionID after the user logs >in and in application.cfm checking whether that client var equals to the >current jsessionID why does application.cfm not know what the client >variable is? This worked before when all my variables were sessions.. now I >moved them all to client variables and this doesn't seem to work anymore... >It only works now if I move the logic to my index.cfm and checking it there >and logging the user out if the client var and the jsessionid are >different.. any ideas? > >Also... when I delete all the client variables like >DeleteClientVariable("browserSession") it deletes the data field in the >CFDATA table... how would I delete the whole record when a user logs out? > >Thanks, >Tim > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: multiple file upload
Yes it is.. I have uploaded 10 files before with one form one submission >>> [EMAIL PROTECTED] 06/24/03 02:35PM >>> Hi all, Anyone knows if the above is possible? My test with two input type=file and cffile in the same form doesn't seem to be able to upload both files to the server. I remembered reading about this but i've totally forgotten about it. Please help! TIA Anthony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: multiple file upload
Opps .. my mistake .. I renamed the not on the name attribute but the id attribute .. -Original Message- From: Anthony Wong [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 2:35 AM To: CF-Talk Subject: multiple file upload Hi all, Anyone knows if the above is possible? My test with two input type=file and cffile in the same form doesn't seem to be able to upload both files to the server. I remembered reading about this but i've totally forgotten about it. Please help! TIA Anthony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
multiple file upload
Hi all, Anyone knows if the above is possible? My test with two input type=file and cffile in the same form doesn't seem to be able to upload both files to the server. I remembered reading about this but i've totally forgotten about it. Please help! TIA Anthony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: I remember...a macintosh version of cfmx...but...can't...find...it...
> -Original Message- > From: Sean A Corfield [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 10:41 AM > To: CF-Talk > Subject: Re: I remember...a macintosh version of > cfmx...but...can't...find...it... > Let me know if you have any Mac issues! Not really a mac issue, per se, but I'll post anyway, since i'm working on a Mac when having the issue ;) Say you've got Tomcat w/ CFMX running, along with an Apache 2 install, and you want to connect Tomcat to Apache to share the job of serving content. How would you go about doing it? The ideal setup would allow CF pages to reside outside /cfusion, and the Apache/Tomcat connector would be mod_jk2. More specifically, in workers2.properties, I'd like to see a [uri:/*.cfm] section that works properly; I've thus far drawn a complete blank. I seem to recall a post regarding connecting apache and cfmx/tomcat on here a few weeks back, but a search of the archives didn't turn anything up, and googling has be less than fruitful. cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 6/18/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFChart: Set Axis Markers?
Good show Ryan! That did it! I used your calculations as is ... the only trick was to dynamically derive the max value based on the dataset, which I did with maxArray(). Thanks for your help! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I remember...a macintosh version of cfmx...but...can't...find...it...
On Tuesday, Jun 24, 2003, at 10:29 US/Pacific, Sean A Corfield wrote: > If you have the 1.4.1 JVM installed as your default, you need to run > the command-line installer: BTW, JRun only uses the 1.3.1 JVM (even if you have the 1.4.1 JVM installed). You can persuade Tomcat to use 1.4.1 but you also need to remove WEB-INF/cfusion/lib/tools.jar from the CFMX installation otherwise it will give you a class version error at compilation. Let me know if you have any Mac issues! Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Client Variable in application.cfm
You wouldn't happen to be trying to check a client variable before the declaration, would you? -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Tim Do [mailto:[EMAIL PROTECTED] : Sent: Tuesday, June 24, 2003 1:10 PM : To: CF-Talk : Subject: Client Variable in application.cfm : : : Hello all, : : What I'm trying to do is log the users out if they close their browser : window. I have a client variable set for the jsessionID after : the user logs : in and in application.cfm checking whether that client var equals to the : current jsessionID why does application.cfm not know what the client : variable is? This worked before when all my variables were : sessions.. now I : moved them all to client variables and this doesn't seem to work : anymore... : It only works now if I move the logic to my index.cfm and : checking it there : and logging the user out if the client var and the jsessionid are : different.. any ideas? : : Also... when I delete all the client variables like : DeleteClientVariable("browserSession") it deletes the data field in the : CFDATA table... how would I delete the whole record when a user logs out? : : Thanks, : Tim : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I remember...a macintosh version of cfmx...but...can't...find...it...
On Tuesday, Jun 24, 2003, at 08:19 US/Pacific, Christian Cantrell wrote: > We offer an OS X development version of CFMX for J2EE as a free > download (Products -> ColdFusion -> Try CFMX for J2EE). Note: since Updater 3 is a complete CFMX for J2EE install, you could skip the initial download / install of CFMX for J2EE and go straight to the Updater. When you download Updater 3, select the AIX version - it's a Java .jar file (62.05 Mb) - which is not obvious... This will give you version 58096 (the standard Mac OS X bits are version 55712). If you have the 1.4.1 JVM installed as your default, you need to run the command-line installer: java -jar coldfusion-j2ee-java.jar -i console If you have the 1.3.1 JVM installed as your default you can double-click the installer and run it in GUI mode - or you can run the command-line installer. The installer creates a WAR file (option 2) which you then explode into your app server per the installation notes. If you're using Safari, remember to *allow* pop-ups before you try to access the administrator the first time otherwise the setup pop-up will be blocked! > You might be thinking of the famous CFMX hack > pioneered by Dick Applebaum when CFMX was still relatively new. I > haven't heard of anyone really using it since we released the J2EE > version, but it's still an option. I still have it installed but haven't fired it up for ages. Frankly, with the free versions of JRun and CFMX for J2EE now available officially for the Mac, there seems no point in using that unsupported hack - but it was great while we were still waiting for OS X support so many thanx to Dick for that! Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BLOBs and CF
> > nonsense. we're storing vector data in databases these days. arcSDE for > > example comes with a couple of sql API for manipulating data in the db, > > performing spatial searches, etc. i do this for a living. > > > Vector data is just that vector _data_ A bunch of points that you join > together to draw a picture, he says simplifying it horribly. > The APIs are there to simplify the calculations that the database has to do > for the developer/end-user. well you've lost me with that--no idea what your point is now. vector data is binary, stored in db as BLOB or IMAGE just like word docs, images or whatever started this thread off. its better off in a database for reasons that were pointed out in this thread (and previously, this isn't the first time this issue has been raised on this list). thats the modern way of solving these kinds of problems. caves aren't really comfortable places to live. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Client Variable in application.cfm
Hello all, What I'm trying to do is log the users out if they close their browser window. I have a client variable set for the jsessionID after the user logs in and in application.cfm checking whether that client var equals to the current jsessionID why does application.cfm not know what the client variable is? This worked before when all my variables were sessions.. now I moved them all to client variables and this doesn't seem to work anymore... It only works now if I move the logic to my index.cfm and checking it there and logging the user out if the client var and the jsessionid are different.. any ideas? Also... when I delete all the client variables like DeleteClientVariable("browserSession") it deletes the data field in the CFDATA table... how would I delete the whole record when a user logs out? Thanks, Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLDAP ?
I got it! James Blaha wrote: >Hello All, > >Does anyone know if you can pass the user id and password for the >Directory Manager account and perform a query on all attributes in a >LDAP server database using CFLDAP? > >Regards, >James Blaha > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BLOBs and CF
> > Ah yes, but Graphical Information Systems are just that - Information > > Systems. > > the "G" is for geographical. > Sorry yes - that's what I meant. > > Given that a large percentage of what GIS systems do is interprete and > > extrapolate pure numbers I should hope that this is stored in a database. > > no, as a matter of historical fact they were not. most were (and some still > are) file based 3-5 years ago--we GIS practioners love our topology. we gave > it up for a while just to get decent database engine based databases. > Yeah I know... I had to deal with one briefly about 5 years ago ~shudder~ Which is why I said "hope" ;o) > > ;o) Images created from that extrapolated data or interpreted data > placed > > over an image is only the very top layer of what a GIS does. The User > > Interface if you will, not the entire application layer. > > nonsense. we're storing vector data in databases these days. arcSDE for > example comes with a couple of sql API for manipulating data in the db, > performing spatial searches, etc. i do this for a living. > Vector data is just that vector _data_ A bunch of points that you join together to draw a picture, he says simplifying it horribly. The APIs are there to simplify the calculations that the database has to do for the developer/end-user. Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Uploading Files with CFFile
> user has been bounced to a different machine (3 server hardware load > balanced environment) No that can't be it. The user will (well should) be on the same machine for the full http request. I think that temporary network failures to your UNC path is more likely. Code something like this is figure it out. CFMX has Win2K rights not sure what you mean by that ? CFMX is running under a user account I presume. That user has the permissions on the NAS.. WG -Original Message- From: Jeremy Bruck [mailto:[EMAIL PROTECTED] Sent: 24 June 2003 17:49 To: CF-Talk Subject: Uploading Files with CFFile Everyone, We are having some problems when users are uploading files. We don't get this error all the time, but about 4/5 times per day (out of 50ish uploads/day). The error from CFMX is "The directory either does not exist or is not accessible by this tag". We are using a UNC path over to a different server: \\216.xxx.xxx.xxx\E$\mfgq_live\uploads. The only thing we can think of is CFMX seems to create a *.tmp file upon upload. And after submission CFMX can't get back to the tmp file since the user has been bounced to a different machine (3 server hardware load balanced environment). Here is an example of the temp file: RFQ_FILE = C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp27206 .tmp FYI, users are uploading files to a NAS -- CFMX has Win2K rights to the NAS to get the files (JVM 1.4.102 on Apache 2.044). Could CFMX throw errors bucuase of this? Anyone have an idea how this works in CFMX? Thanks for the help! Jeremy Jeremy Bruck, VP of Technology ::MfgQuote www.mfgquote.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BLOBs and CF
> Ah yes, but Graphical Information Systems are just that - Information > Systems. the "G" is for geographical. > Given that a large percentage of what GIS systems do is interprete and > extrapolate pure numbers I should hope that this is stored in a database. no, as a matter of historical fact they were not. most were (and some still are) file based 3-5 years ago--we GIS practioners love our topology. we gave it up for a while just to get decent database engine based databases. > ;o) Images created from that extrapolated data or interpreted data placed > over an image is only the very top layer of what a GIS does. The User > Interface if you will, not the entire application layer. nonsense. we're storing vector data in databases these days. arcSDE for example comes with a couple of sql API for manipulating data in the db, performing spatial searches, etc. i do this for a living. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Uploading Files with CFFile
Everyone, We are having some problems when users are uploading files. We don't get this error all the time, but about 4/5 times per day (out of 50ish uploads/day). The error from CFMX is "The directory either does not exist or is not accessible by this tag". We are using a UNC path over to a different server: \\216.xxx.xxx.xxx\E$\mfgq_live\uploads. The only thing we can think of is CFMX seems to create a *.tmp file upon upload. And after submission CFMX can't get back to the tmp file since the user has been bounced to a different machine (3 server hardware load balanced environment). Here is an example of the temp file: RFQ_FILE = C:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp27206 .tmp FYI, users are uploading files to a NAS -- CFMX has Win2K rights to the NAS to get the files (JVM 1.4.102 on Apache 2.044). Could CFMX throw errors bucuase of this? Anyone have an idea how this works in CFMX? Thanks for the help! Jeremy Jeremy Bruck, VP of Technology ::MfgQuote www.mfgquote.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFChart: Set Axis Markers?
Well, you need some parameters added to your cfchart, such as: scalefrom="0" scaleto="x" gridlines="N" Try this calculation and see if it gets you what you want: x = 700 -- You know your max is 700 y = 100 -- You know you want intervals of 100 (700, 600, 500, etc) Therefore: N = (x/y = z) + 1 N = (700/100 = z) + 1 N = 7 + 1 N = 8 The + 1 is for the 0 marker. HTH, Ryan Kime -Original Message- From: Suyer, Ed [PRD Non-J&J] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:42 AM To: CF-Talk Subject: CFChart: Set Axis Markers? Hi folks, I currently have a cfchart that displays something like this: Line Graph (in ASCII) 650 | 577.8 | 505.6 | X 433 | / 361.1 |X/ 288.9 |/ \/ 216.7 | X \/ 144.4 | / X 72.2| X 0 | --- J A S N D U U E O E L G P V C How do I get the markers on the y-axis (650, 577.8, ..., 72.2, 0) to read: 700, 600, 500, 400, 300, 200, 100, 0? I'm not currently passing anything to cfchart or cfchartseries that generates these numbers. My guess is that CF takes an average internally to calculate these markers. Any help is much appreciated! TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BLOBs and CF
> > Yes the DB can handle the security as well, but I don't know that its any > > easier to code up DB security as it is to use secure directories. > > no, thats not the only reason. its been common in the GIS world for years > because it offers something more than file based system: > -functionality (via standard sql language), > -flexibility, > -data integrity, > -scalability, > -vast tool support of database vendors (ESRI, Oracle, MS, etc), > -easier server maintenance > > hey, the ice age really is over. > Ah yes, but Graphical Information Systems are just that - Information Systems. Information is just data that has meaning. Data you store in a database and interprete to become information. Given that a large percentage of what GIS systems do is interprete and extrapolate pure numbers I should hope that this is stored in a database. ;o) Images created from that extrapolated data or interpreted data placed over an image is only the very top layer of what a GIS does. The User Interface if you will, not the entire application layer. Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple popup window that auto loads
Very interesting twist... I wouldn't have thought of that... Another little snippet to add to my arsenal. Thanks Ryan! Cheers, Jeff - Original Message - From: "Hagan, Ryan Mr (Contractor ACI)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 9:16 AM Subject: RE: Simple popup window that auto loads Actually, you can. http://aspalliance.com/peterbrunone/impossible.asp -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 12:12 PM To: CF-Talk Subject: Re: Simple popup window that auto loads Don't forget that this will generate a message box since you cannot close the parent window programatically from the child. It's a javascript thing... Jeff - Original Message - From: "Bryan F. Hogan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 9:06 AM Subject: RE: Simple popup window that auto loads is serverside, is client side. You want something like