Re: CFMX ODBC/JDBC Drivers
Paul > pretty much everybody knows better than ms when it comes to JDBC & sql > server. ms's JDBC driver originally came from datadirect & hasn't really > progressed that far. and my own testing is exactly the opposite of your > findings, ms's JDBC driver was the 3rd slowest i tested: > > #1 jTDS http://jtds.sourceforge.net/ > #2 datadirect > #3 ms JDBC As well as performance, other aspects to a DB driver are stability & functionality (like support for SQL syntax & the JDBC spec). Did you do any comparative testing of these aspects as well as performance, or do you know of any such testing that's been done? We're thinking of trying out jTDS but I'm wondering whether the speed comes at a price & if so, what the tradeoff is. I've read what they say about jTDS on sourceforge and of course it sounds great, but any kind of independent corroboration would be nice, particularly from people who've used it in a CF context. Nick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191657 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFCs and virtual directories.
CFCs can be accessed in a few ways...
Via the standard CF custom tag directory, a custom-custom tag
directory, or in the immediate folder of the calling template:
createObject("component","myCFC")
Or in a folder below any of the above:
createObject("component","folder.from.current.location.myCFC")
There's a very specific search order that governs where CFCs should be
located and how CF finds them if you only specify a CFC name.
Check the livedocs here:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/buildi12.htm
Laterz,
J
On Tue, 25 Jan 2005 01:18:19 -0500, Dwayne Cole <[EMAIL PROTECTED]> wrote:
> I thought tha this mapping issue was the problem with cfc's. Mapping works
> when your using . I haven't wrapped most of my "cffunction"
> libraries with cfcomponent because of this issue of how to find them. Plus
> my "cfc's" don't contain instance data, I'm not using flash yet, and I'm not
> using webservices. So for me I works well to use to include the
> set of before I make the call or include them in the
> application.cfm page.
>
> Dwayne.
>
>
--
Continuum Media Group LLC
Burnsville, MN 55337
http://www.web-relevant.com
http://cfobjective.blogspot.com
~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191656
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFUNITED? What's the deal??
http://www.cfunited.org/ It's in DC this year... J On Tue, 25 Jan 2005 01:00:16 -0500, Dwayne Cole <[EMAIL PROTECTED]> wrote: > Where is it? > > > -- Original Message -- > From: Michael Smith <[EMAIL PROTECTED]> > Reply-To: cf-talk@houseoffusion.com > Date: Mon, 24 Jan 2005 22:07:22 -0500 > > >Yes we are planning on providing lunch all 3 days and an open bar > >reception on Wed night. It is 50% longer and 75% bigger. > >Also we have moved to a hotel that is about 3 times bigger and much > >nicer that the DoubleTree (not that the DoubleTree > >is bad but it is too small for CFUNITED-05. With a 1000 people coming we > >want this to be the premier > >ColdFusion event of the year, bar none! > >- Michael Smith, TeraTech > > > > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191655 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFCs and virtual directories.
I thought tha this mapping issue was the problem with cfc's. Mapping works
when your using . I haven't wrapped most of my "cffunction"
libraries with cfcomponent because of this issue of how to find them. Plus my
"cfc's" don't contain instance data, I'm not using flash yet, and I'm not using
webservices. So for me I works well to use to include the set of
before I make the call or include them in the application.cfm page.
Dwayne.
-- Original Message --
From: "DURETTE, STEVEN J \(AIT\)" <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date: Mon, 24 Jan 2005 14:05:09 -0500
>Hadn't thought of doing that.
>
>I tried to map to the directory in the CF Admin and it didn't work.
>
>Also, If I put it in a custom tag directory would I be able to browse
>directly to the cfc to see it's hint information?
>
>Right now I have been using:
> returnvariable="Session.menuInfo.menuMainText">
> value="#Session.Category#" />
>
>
>Would using it in a custom tag directory mean that I would have to
>change that code? This cfc was originally used for one url, now I have
>to allow all the other urls on the box be able to use it, but I don't
>want to have to recode everything on my current url. (I keep saying
>URL, but in actuality I should probably be saying IIS websites)
>
>Thanks,
>Steve
>
>-Original Message-
>From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
>Sent: Monday, January 24, 2005 1:42 PM
>To: CF-Talk
>Subject: Re: CFCs and virtual directories.
>
>
>It'll be available to everything on the server if it's at
>C:\CFusionMX\CustomTags (or equivalent)
>
>If you want to instantiate, just use
>createObject("component","cfcName");
>
>Or, alternatively, you could put it in a folder ala package-style and
>use:
>createObject("component","my.package.folders.cfcName");
>
>With that style, you'd use dots to separate your folder names instead
>of (back-)slashes, with no prefix.
>
>Or you can create a custom custom tag folder from within CF
>Administrator and do basically the same thing. Adding a new custom tag
>folder basically extends the real estate where CF looks for cf_ and
>component files.
>
>Laterz,
>J
>
>
>On Mon, 24 Jan 2005 13:28:08 -0500, jonese <[EMAIL PROTECTED]> wrote:
>> did you try to put your CFC in your custom tag directory? or create a
>> new CFC custom tag directory / mapping?
>>
>> ERJ
>>
>> On Mon, 24 Jan 2005 13:20:14 -0500, DURETTE, STEVEN J (AIT)
>> <[EMAIL PROTECTED]> wrote:
>> > Hi all,
>> >
>> > Got a quick question for you. I have created a cfc that I want
>> > available to all urls on our web server (this is on an intranet).
>So, I
>> > created a directory outside of the webroots and put the cfc there.
>Then
>> > I went into IIS and created virtual directories on each of the
>websites
>> > that points to that directory.
>> >
>> > Problem is it doesn't work. If I delete the virtual directory and
>copy
>> > the files into a directory of the same name that the virtual
>directory
>> > was everything works fine.
>> >
>> > I'm trying to reuse this code for all of the sites on my server, but
>I'm
>> > not sure how. I don't want to put a copy in each website because I
>want
>> > one place where I can make changes and it will cascade everywhere
>else.
>> >
>> > Thanks for any help you can give.
>> >
>> > Steve
>> >
>> >
>>
>>
>>
>>
>
>
>--
>Continuum Media Group LLC
>Burnsville, MN 55337
>http://www.web-relevant.com
>http://cfobjective.blogspot.com
>
>
>
>
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191654
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF 5 and CFMX together on the same files?
Here is an article how to run CF5 CFMX and BlueDragon: http://www.findarticles.com/p/articles/mi_m0MLU/is_9_5/ai_108331157 Cheers, Stan > Hi, > > It is possible to install CFMX and have it work together with CF 5. > But is it possible to have them share the same Web space (server > directory) and call either one or the other one on the same files? > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191653 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFUNITED? What's the deal??
Where is it? -- Original Message -- From: Michael Smith <[EMAIL PROTECTED]> Reply-To: cf-talk@houseoffusion.com Date: Mon, 24 Jan 2005 22:07:22 -0500 >Yes we are planning on providing lunch all 3 days and an open bar >reception on Wed night. It is 50% longer and 75% bigger. >Also we have moved to a hotel that is about 3 times bigger and much >nicer that the DoubleTree (not that the DoubleTree >is bad but it is too small for CFUNITED-05. With a 1000 people coming we >want this to be the premier >ColdFusion event of the year, bar none! >- Michael Smith, TeraTech > >Rick Root wrote: > >>I don't have a problem at all with CFUNITED's increased price. Last >>year it was overcrowded and too short... So now it's a day longer, which >>immediately adds 50% to the cost. >> >>And I think from the surveys last year, a lot of people were hoping to >>see some kind of food and drinks available in the morning... coffee, >>donuts, juice, etc... maybe they'll tack that on too. >> >>CFUN at $250 was a great deal. CFUNITED at $450 is still gonna be a >>great deal. >> >> - Rick >> >> >> >> > >-- >Due to TeraTech's growth we are seeking winning sales people >to sell custom software. For more details: >http://www.teratech.com/index.cfm?go=About.JobDetail&JobID=3 > >Michael Smith, TeraTech, Inc >405 E Gude Dr Ste 207, Rockville MD 20850 >Voice: +1-301-424-3903 x110 Fax:301-762-8185 >Web: http://www.teratech.com/sig/ >Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 >Winner in CFDJ awards Best Consulting. Member Team Fusebox. > > > ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191652 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Is there coldfusion based webmail product out there?
Who uses those? -- Original Message -- From: Jordan Michaels <[EMAIL PROTECTED]> Reply-To: cf-talk@houseoffusion.com Date: Mon, 24 Jan 2005 16:17:44 -0800 >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >Yes, from Macromedia. When you install Cold Fusion Server, the >installer gives you the option to install some sample applications. >(You generally do not want these in a production environment however) >A webmail client (I think it's called Email Taxi or something) is one >of the sample applications that get installed. > >HTH > >Warm regards, >Jordan Michaels >Vivio Technologies > >Discover Antartica wrote: > >|Is that from macromedia? is it part of the cf application kit from >Macromedia? >| >|Jordan Michaels <[EMAIL PROTECTED]> wrote:-BEGIN PGP SIGNED >MESSAGE- >|Hash: SHA1 >| >|Discover Antartica wrote: >| >||Is there coldfusion based webmail product out there? for free or >|paid, either one. >| >|Silly footers, always cutting off my responses! Here's what I >|attempted to write earlier: >| >|I believe one of the CF demo applications (which you can install when >|you install Cold Fusion Server) is an webmail client. Email Taxi or >|something? It's been a while since I've installed those though... >| >|HTH! >| >| >|- -- >|Warm regards, >|Jordan Michaels >|Vivio Technologies >|http://www.viviotech.net/ >|[EMAIL PROTECTED] >|-BEGIN PGP SIGNATURE- >|Version: GnuPG v1.2.4 (GNU/Linux) >|Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org >| >|iD8DBQFB9TWo/G4NWP5tBHcRAvqtAJ9JD7j8NekJWf9plGF3O/stAUfDOgCfT24D >|9K1mWyoIzTQc1ERnR8ByEks= >|=+Jdv >|-END PGP SIGNATURE- > > >- -- >Warm regards, >Jordan Michaels >Vivio Technologies >http://www.viviotech.net/ >[EMAIL PROTECTED] >-BEGIN PGP SIGNATURE- >Version: GnuPG v1.2.4 (GNU/Linux) >Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > >iD8DBQFB9ZAo/G4NWP5tBHcRAgLoAJ4wf7s6XLv0hLoIiCukEROa+Oi7JQCgmpS/ >pFYyf/qyWsOnANK8v5Vy6zQ= >=xAYh >-END PGP SIGNATURE- > > ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191651 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF 5 and CFMX together on the same files?
Yeah, it's possible, though you can't use the same Apache/IIS config, becuase you can't have both versions fighting over the .CFM mapping. Just set up two vhosts, one for CF5 and one for CFMX with the same directory path on the server, and you'll be golden. cheers, barneyb On Mon, 24 Jan 2005 20:18:12 -0500, Claude Schneegans <[EMAIL PROTECTED]> wrote: > Hi, > > It is possible to install CFMX and have it work together with CF 5. > But is it possible to have them share the same Web space (server directory) > and call either one or the other one on the same files? > > -- -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 8 invites. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191650 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What utility could I use to measure my clients' website bandwidth usage?
Thanks for the leads, everyone. I'll check out your recommendations... Rick -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 10:51 PM To: CF-Talk Subject: Re: What utility could I use to measure my clients' website bandwidth usage? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 www.etinc.com much more affordable if you build your own box, but no support for that. Works fine on 4.9, but couldn't get it to run in 4.10. I think their pre-compiled kernels have issues in 4.10. HTH, Jordan [EMAIL PROTECTED] wrote: |Doesn't have to be free, but I'm not just dying to spend money. | |I host websites and figured that at some point, charging |for bandwidth usage would become desirable, especially |if I decide to offer streaming media services... | |Rick | |-Original Message- |From: Emmet McGovern [mailto:[EMAIL PROTECTED] |Sent: Monday, January 24, 2005 7:24 PM |To: CF-Talk |Subject: RE: What utility could I use to measure my clients' website |bandwidth usage? | | |Are you looking for paid or free? | |emmet | |-Original Message- |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] |Sent: Monday, January 24, 2005 5:47 PM |To: CF-Talk |Subject: OT: What utility could I use to measure my clients' website |bandwidth usage? | |Anyone got any good tools to measure their clients' website bandwidth usage |so I can charge if they go beyond a certain amount? | |Windows 2000 Server... | |Thanks, | |Rick | | |-- |No virus found in this outgoing message. |Checked by AVG Anti-Virus. |Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005 | | | | | | | ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191649 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Inexpensive, CF-friendly payment gateway?
Try https://www.e-onlinedata.com/fullcityhosting (affiliate plug!) All the info is right there. I haven't found cheaper. We currently have just under 70 gateways in play right now. Uses authorize.net. Emmet -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 4:04 PM To: CF-Talk Subject: Re: Inexpensive, CF-friendly payment gateway? I have had positive experience with authorize.net, there is some pretty easy code on the macromedia dev site. Bob ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191648 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: # of Sites on a Server
Barney offered the best answer. We offer collocation and I've seen boxes come to a crawl with one busy phpbb/phpnuke site and other servers with over 700 sites on them running fine. It all depends on the traffic and code behind the site. Since it sounds like you control the code I would set up some basic performance monitors. The basic counters are... Memory: Pages/sec. Processor: \% Processor Time Physical disk: \% Disk Time Network: Bytes Total/Sec Have one server monitor the other. After 24-48 hours or so you can determine a good baseline and start tracking averages past that. Emmet -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 12:20 PM To: CF-Talk Subject: # of Sites on a Server All, I'm looking for some feedback on what you consider a resonable amount of clients to put on a dedicated server. We are currently running dual processor 1GB ram servers etc at our hosting provider. Each site includes our custom CMS and has a foot print of at least 20MB. Traffic varies from site to site but we haven't "seen" any real performance hits when we add new sites or other sites get an infusion of traffic. All in all each box right now has about 35 sites on it (one is CFMX Standard, the other is cf5 which we're migrating to CFMX Standard). What do you use as a guage to tell you how many clients to host on a server? When is too many? What tools etc are you using to monitor this? Thanks in advance Eric. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191647 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: What utility could I use to measure my clients' website bandwidth usage?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 www.etinc.com much more affordable if you build your own box, but no support for that. Works fine on 4.9, but couldn't get it to run in 4.10. I think their pre-compiled kernels have issues in 4.10. HTH, Jordan [EMAIL PROTECTED] wrote: |Doesn't have to be free, but I'm not just dying to spend money. | |I host websites and figured that at some point, charging |for bandwidth usage would become desirable, especially |if I decide to offer streaming media services... | |Rick | |-Original Message- |From: Emmet McGovern [mailto:[EMAIL PROTECTED] |Sent: Monday, January 24, 2005 7:24 PM |To: CF-Talk |Subject: RE: What utility could I use to measure my clients' website |bandwidth usage? | | |Are you looking for paid or free? | |emmet | |-Original Message- |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] |Sent: Monday, January 24, 2005 5:47 PM |To: CF-Talk |Subject: OT: What utility could I use to measure my clients' website |bandwidth usage? | |Anyone got any good tools to measure their clients' website bandwidth usage |so I can charge if they go beyond a certain amount? | |Windows 2000 Server... | |Thanks, | |Rick | | |-- |No virus found in this outgoing message. |Checked by AVG Anti-Virus. |Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005 | | | | | | | ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191646 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What utility could I use to measure my clients' website bandwidth usage?
Try one of the many hosting control panels for windows. Ensim has a 1/2 off sale right now. There's also Helm. My personal is favorite plesk, but only because their windows cp and nix cp's are identical. Ensims new cp for windows looks pretty nice though. Helm has a built in billing module. All will do what you're looking for and then some. http://www.ensim.com/ http://www.plesk.com http://www.webhostautomation.com/ (helm) Theres also Zpanel which is still free. http://www.thezpanel.com I have pretty good experience with the top 3 companies, I haven't tried ZPanel. Emmet -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 8:40 PM To: CF-Talk Subject: RE: What utility could I use to measure my clients' website bandwidth usage? Doesn't have to be free, but I'm not just dying to spend money. I host websites and figured that at some point, charging for bandwidth usage would become desirable, especially if I decide to offer streaming media services... Rick -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 7:24 PM To: CF-Talk Subject: RE: What utility could I use to measure my clients' website bandwidth usage? Are you looking for paid or free? emmet -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 5:47 PM To: CF-Talk Subject: OT: What utility could I use to measure my clients' website bandwidth usage? Anyone got any good tools to measure their clients' website bandwidth usage so I can charge if they go beyond a certain amount? Windows 2000 Server... Thanks, Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005 ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191645 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFPOP - returned timestamps GRR!
Adam, Point taken. But would why bother including a component which is flawed in two pretty fundamental ways? If this was a problem with an open source platform (say, PHP which by the way has several flawless POP3 implementations), I wouldn't be upset. I would politely request that it be fixed, and I would be able to obtain a bleeding edge patch to help test. But I chose CF for all the good things it offers. RAD being the main one. But why should I pay the (expensive) license fees for buggy software? Yes, it is buggy: there is no other way to describe it. Suddenly that "RAD" feature goes out the window while I dick around trying to come up with a disgusting, inelegant kludge. Do you release buggy, substandard software to your clients? Yes, software will always have bugs. But when they are present in development tools, its tenfold more frustrating. Anyway, the organisation I work for has a pretty good relationship with MS. I hope the substantial resources of MM can get bugs these fixed for me and all the other CF users out there. Regards, Jono > Sometimes your chosen platform cannot do what you think it should be > able to do. You are then forced to write code to get it to do what you > want. We call this programing. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191644 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Interview: .Net for the CF guy class and MDCFUG
In this interview with CF guru Adam Churvis we talk about learning .Net from ColdFusion. Adam is talking about this at the next MDCFUG meeting 2/8/05 and teaching a full day class on it the net day 2/9/05 First here is some class news: Tue 2/1/05 CF 202 - 508 & ColdFusion $199 Tue 2/8/05 CF 206 - ColdFusion SQL Skills $349 Wed 2/9/05 DN 101 - DotNet from CF $349 Tue 2/15/05 FB 101 - Intro to Fusebox $199 Tue 2/22/05 FB 201 - Intermediate Fusebox $349 *TeraTech 100% Learning Guarantee* We want you to be happy with our classes. If you are not 100% sure you learned everything you could from any of our classes then you may take it again at no charge on a space available basis. Michael Smith: I am talking with Adam Churvis of Productivity Enhancement about his upcoming class "Dot Net for the CF guy". Why should someone come to this class? Adam Churvis: Learning C# and ASP.NET is a great way to start quadrupling the number of opportunities available to you. MS: But isn't learning C# and ASP.NET is a pretty scary thing for many ColdFusion developers? AC: Yes, mainly because it is so very different from ColdFusion. Many perceive C# and ASP.NET to be way too hard for them to learn because it is an object oriented language with so many more details than ColdFusion, you have to compile your code before you can test it, it's strongly-typed, there's code-behind, etc. Actually it's like any other scary necessity you've encountered in your life: once you do it the first time you'll wonder how you ever lived without it, and the things that initially gave you butterflies are quickly dispelled once you get going. MS: What do you cover in the class? AC:We start by reviewing a ColdFusion MX application, then building the equivalent application in ASP.NET using C#. We build it in layers, starting slowly with the basics, then layering in more details, enhancements, and improvements in the code. It's a really cool way to see practical object oriented programming in a web application built right before your eyes. MS: What editor do you use? AC: Visual Studio .NET. It's a phenomenal tool, and we show you how to use it in the class. MS: Do you assume that people understand object-orientation? AC: We only assume that people *want* to begin learning object oriented programming, not that they already know much about it. The more they already know, the better, but it isn't necessary. We explain Objects, Class structures, Properties, Methods, Instances, Namespaces, Access modifiers, Encapsulation, Inheritance and Polymorphism. MS: What about forms in .Net? AC: The majority of the first half of the class is dedicated to building a practical web form application in .NET. We want people to feel fairly comfortable about building everyday forms using code-behind and basic objects before we move on to more involved topics. MS: Anything else that you cover in the class? AC: The best way to answer that is to refer you to the itinerary below. It's a pretty full plate, so we only get to touch on certain topics briefly, but we're going to spend as much time as the day allows on the different types of objects like enumerations, arrays and indexers, sorted lists, queues and stacks, exceptions, etc, and how they apply to real world programming tasks. MS: What if you want to go further with .Net application building? AC: When the course is over, you'll receive the code library used in the seminar so you can continue to learn on your own. And if you want to really get into building ASP.NET applications using C#, you can apply 100% of your seminar fee toward our intensive 5-day, 8AM to 7PM training course on C# and ASP.NET. MS: That is cool. Any other benefits? AC: Take a look at a pie chart of available jobs or projects by platform and add up all the slices you can personally handle right now, and then add that huge slice of C# and ask yourself if you'd like that many more opportunities made available to you for the picking. C# and ASP.NET are powerful tools for your toolbox. MS: What about helping your CF programming? AC: Yes, learning C# and ASP.NET will make you a better ColdFusion developer. Learning the practical basics of object oriented programming can't help but to give you a better, more informed perspective when approaching a new ColdFusion development project. ColdFusion CFC use many OO concepts. MS: That is great. See you at the class and the MDCFUG meeting the night before. More class info at http://www.teratech.com/training/oc_classes.cfm#DN101 - Dot Net DN 101 - DotNet for the CF guy ** Full Day course Sign-in 9:30am, Class 10am-5pm Just $349, includes lunch Prerequisite: CF102 or similar basic ColdFusion knowledge. Teachers: Adam and David Churvis This one day class is designed to both fast-track you into ASP.NET with C-Sharp and to teach you everything you'll need to know to build effective ASP.NET applications. Specifically suited for ColdFusion developers,
Re: CFUNITED? What's the deal??
Yes we are planning on providing lunch all 3 days and an open bar reception on Wed night. It is 50% longer and 75% bigger. Also we have moved to a hotel that is about 3 times bigger and much nicer that the DoubleTree (not that the DoubleTree is bad but it is too small for CFUNITED-05. With a 1000 people coming we want this to be the premier ColdFusion event of the year, bar none! - Michael Smith, TeraTech Rick Root wrote: >I don't have a problem at all with CFUNITED's increased price. Last >year it was overcrowded and too short... So now it's a day longer, which >immediately adds 50% to the cost. > >And I think from the surveys last year, a lot of people were hoping to >see some kind of food and drinks available in the morning... coffee, >donuts, juice, etc... maybe they'll tack that on too. > >CFUN at $250 was a great deal. CFUNITED at $450 is still gonna be a >great deal. > > - Rick > > > > -- Due to TeraTech's growth we are seeking winning sales people to sell custom software. For more details: http://www.teratech.com/index.cfm?go=About.JobDetail&JobID=3 Michael Smith, TeraTech, Inc 405 E Gude Dr Ste 207, Rockville MD 20850 Voice: +1-301-424-3903 x110 Fax:301-762-8185 Web: http://www.teratech.com/sig/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191642 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: What utility could I use to measure my clients' website bandwidth usage?
I remember Analog being pretty full featured. And free :) On Mon, 24 Jan 2005 20:40:27 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Doesn't have to be free, but I'm not just dying to spend money. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191641 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX + UTF8 vs Javascript
Claude Schneegans wrote: > Including the Javascrip files, but how do I edit them? notepad, cfstudio (just leave the BOM alone), cfeclipse, etc. > What do you mean "ghost echo", I'm still having a &?%$/ problem, and it is > not a ghost problem ;-) an email that got somehow recycled & shows up later on from the middle of that thread. > By the way, how should we call this behaving from CF which forces UTF-8 > uncompatible with Javascript? > A bug? nope, a victory for i18n standards, good practices, etc. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191640 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX + UTF8 vs Javascript: problem solved
Hi, I finally figured out that the iso-8859-1 characters where replaced by y not in the database, but during the post through the form. As Deanna Schneider pointed out, I needed to add both lines in the Application.cfm Now, in order the application is completely CF 5 and CFMX compatible, I use this in the application template: Thanks all for your help, especially Deanna. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191639 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX ODBC/JDBC Drivers
Robert Everland III wrote: > If you are using SQL Server 2000 you can always use SQL Server JDBC drivers. > Who better than MS to know how to handle their own server. I did some testing > by looping through different types of queries such as inserts, updates and > selects and with just 1000 queries Microsoft JDBC drivers were a couple > seconds faster than the built in JDBC drivers. pretty much everybody knows better than ms when it comes to JDBC & sql server. ms's JDBC driver originally came from datadirect & hasn't really progressed that far. and my own testing is exactly the opposite of your findings, ms's JDBC driver was the 3rd slowest i tested: #1 jTDS http://jtds.sourceforge.net/ #2 datadirect #3 ms JDBC ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191638 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What utility could I use to measure my clients' website bandwidth usage?
Doesn't have to be free, but I'm not just dying to spend money. I host websites and figured that at some point, charging for bandwidth usage would become desirable, especially if I decide to offer streaming media services... Rick -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 7:24 PM To: CF-Talk Subject: RE: What utility could I use to measure my clients' website bandwidth usage? Are you looking for paid or free? emmet -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 5:47 PM To: CF-Talk Subject: OT: What utility could I use to measure my clients' website bandwidth usage? Anyone got any good tools to measure their clients' website bandwidth usage so I can charge if they go beyond a certain amount? Windows 2000 Server... Thanks, Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005 ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191637 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query"Where in List" with UUID Problem
> And you don't have two copies of the atty table with different users?? Nope! > (Grasping at straws...) Me too! Sheesh. -- --- Les Mizzell ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191636 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query
> When you changed atty_id over to UUIDs from integers you did change the > datatype of the field in the DB to char(35) from int didn't you? :^) I just double checked it to be sure. Yes, I made the change. -- --- Les Mizzell ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191635 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CF 5 and CFMX together on the same files?
Hi, It is possible to install CFMX and have it work together with CF 5. But is it possible to have them share the same Web space (server directory) and call either one or the other one on the same files? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191634 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query"Where in List" with UUID Problem
And you don't have two copies of the atty table with different users?? (Grasping at straws...) -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 2:06 p.m. To: CF-Talk Subject: Re: Query"Where in List" with UUID Problem > I strongly suggest using the cfqueryparam solution presented earlier. I don't disagree, but that was giving an error too. Once I find the problem, I'll see if I can get cfqueryparam to work as well. > So, to go over the obvious, the data type of atty_id in atty is CHAR? Yes, it is: char(35) I've even systematically deleted almost EVERYTHING on the page except the query in its most simple form, and it's still giving me the error. I just double checked the datatype in the database as well. -- --- Les Mizzell ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191633 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query"Where in List" with UUID Problem
> I strongly suggest using the cfqueryparam solution presented earlier. I don't disagree, but that was giving an error too. Once I find the problem, I'll see if I can get cfqueryparam to work as well. > So, to go over the obvious, the data type of atty_id in atty is CHAR? Yes, it is: char(35) I've even systematically deleted almost EVERYTHING on the page except the query in its most simple form, and it's still giving me the error. I just double checked the datatype in the database as well. -- --- Les Mizzell ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191632 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
ColdFusion 5 RDS & Visual Source Safe
Hi gang, I've tried finding an answer to this and am stumped. I have a ColdFusion 5 instal (windows 2k server), no RDS password required in the admin. Visual Source Safe is set up with workspace directories. I'm using Dreamweaver MX 2004 for the editor and set up a site that uses Visual Source Safe Database as it's 'remote info'. Database path is a network share, Project is set up correctly, username is in there, but we use blank passwords (don't ask). Here is the magical issue, I can never use RDS to do anything in DW2004 - not even open the database tab. It prompts for username and password even though one is not enabled in the CF5 Admin. No matter what combo I use, it always says it can't authenticate, more specifically "Unable to authenticate on RDS server using current security information!". We don't use sandbox security. I also have no problem checking in/out files, modifying, etc. It's just RDS that is whack.. any suggestions? Sincerely, Rob Sherman ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191631 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query"Where in List" with UUID Problem
I strongly suggest using the cfqueryparam solution presented earlier.
It's safer.
-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 4:32 PM
To: CF-Talk
Subject: RE: Query"Where in List" with UUID Problem
I think you need this:
SELECT * FROM atty
WHERE atty_id IN (#pa_list#)
-Original Message-
From: Cynthia Reece [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 5:24 PM
To: CF-Talk
Subject: RE: Query"Where in List" with UUID Problem
Try your query like this:
SELECT * FROM atty
WHERE atty_id IN IN ('#ValueList(pa_list)#')
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 5:08 PM
To: CF-Talk
Subject: Query"Where in List" with UUID Problem
Doing this:
SELECT * FROM atty
WHERE atty_id IN (#pa_list#)
Originally, the pa_list was just numbers - 11,148,83,23
The query worked fine at that point.
However, a decision was made to use #CreateUUID()# to create the ID's,
so the pa_list NOW looks like:
1203,560,110,A6059FCB-BCD2-35D3-DD69BDA7A81553CF,A6081455-BCD2-35D3-DD69
BDA7A81553CF
Which is creating an error.
Not sure what my syntax problem is at the moment. Haven't had enough
coffee yet today.
Thanks,
--
---
Les Mizzell
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191630
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFLDAP and Large Seraches
Search for "ntdsutil" and "MaxPageSize". You will need to change this setting on each domain controller that you query. You will need administrator access and a command prompt on the domain controller. M!ke -Original Message- From: Charles Heizer [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 3:48 PM To: CF-Talk Subject: CFLDAP and Large Seraches Hello, I'm running in to a strange size limit issue with CFLDAP, where if I query my directory (ADAM) I only get back 1,000 results and this is the SearchSizeLimit which is a 1000 in ADAM. I was told by Microsoft that in order to do large searches I would need to change the query from the SearchSize to pages. Does anyone know how I can do this? Thanks, - Charles ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191629 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query
Hi Les, >>pa_list is the list of UUID's >> >> >> >>Then in the query: >> >>Where att_id IN (#PreserveSingleQuotes(pa_list)#) > > > > Jezz, this has got me pulling out my hair. If I set it up exactly like > you have it above, I'm *still* getting the "Error converting data type > varchar to numeric". > > What the hell is it trying to convert to numeric? When you changed atty_id over to UUIDs from integers you did change the datatype of the field in the DB to char(35) from int didn't you? :^) -- yours, Kym ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191628 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query"Where in List" with UUID Problem
So, to go over the obvious, the data type of atty_id in atty is CHAR? -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 12:43 p.m. To: CF-Talk Subject: Re: Query"Where in List" with UUID Problem Matthew Walker wrote: > > SELECT * > FROMatty > WHERE atty_id IN ( cfsqltype="CF_SQL_CHAR" list="Yes">) > This seems the best bet - but I'm still getting an error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to numeric. SELECT * FROM atty WHERE atty_id IN ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) ) ORDER BY Line of code: atty_id IN () Data Type in the database is set to CHAR Hmmm... -- --- Les Mizzell ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191627 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFPOP - returned timestamps GRR!
On Tue, 25 Jan 2005 09:15:10 +1000, Jon Austin <[EMAIL PROTECTED]> wrote: > I understand; if they would compile and run on Linux, I would be using > them in a flash. These MM bugs are seriously holding up our > development. Sometimes your chosen platform cannot do what you think it should be able to do. You are then forced to write code to get it to do what you want. We call this programing. Rock on. -Adam ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191626 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query
Larry White wrote:
> Try This:
>
> pa_list is the list of UUID's
>
>
>
> Then in the query:
>
> Where att_id IN (#PreserveSingleQuotes(pa_list)#)
Jezz, this has got me pulling out my hair. If I set it up exactly like
you have it above, I'm *still* getting the "Error converting data type
varchar to numeric".
What the hell is it trying to convert to numeric?
Full error message copied below:
[Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type
varchar to numeric.
The error occurred in
C:\Inetpub\wwwroot\nelsonmullins\lawyers\nelson-mullins-attorney_BAK.cfm:
line 88
Called from
C:\Inetpub\wwwroot\nelsonmullins\lawyers\nelson-mullins-attorney_BAK.cfm:
line 1
Called from
C:\Inetpub\wwwroot\nelsonmullins\lawyers\nelson-mullins-attorney_BAK.cfm:
line 88
Called from
C:\Inetpub\wwwroot\nelsonmullins\lawyers\nelson-mullins-attorney_BAK.cfm:
line 1
87 : FROM atty
88 : WHERE atty_id IN (#PreserveSingleQuotes(pa_list)#)
89 : ORDER BY last_name, first_name ASC
90 :
SQLSELECT * FROM NONatty WHERE atty_id <> 8787445854777 AND atty_id
IN
('25','17','375','480','546','346','121','506','132','439','437','35','435','1','76','632','1200','1200','1200','1201','1202','1203','560','110','A6059FCB-BCD2-35D3-DD69BDA7A81553CF','A6081455-BCD2-35D3-DD69BDA7A81553CF','A606B37D-BCD2-35D3-DD7136154C60D051')
ORDER BY last_name, first_name ASC
~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191625
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What utility could I use to measure my clients' website bandwidth usage?
Are you looking for paid or free? emmet -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 5:47 PM To: CF-Talk Subject: OT: What utility could I use to measure my clients' website bandwidth usage? Anyone got any good tools to measure their clients' website bandwidth usage so I can charge if they go beyond a certain amount? Windows 2000 Server... Thanks, Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191624 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query
Try This:
pa_list is the list of UUID's
Then in the query:
Where att_id IN (#PreserveSingleQuotes(pa_list)#)
>I think you need this:
>
>
>
>
>
>SELECT * FROM atty
>WHERE atty_id IN (#pa_list#)
>
>
>-Original Message-
>From: Cynthia Reece [mailto:[EMAIL PROTECTED]
>Sent: Monday, January 24, 2005 5:24 PM
>To: CF-Talk
>Subject: RE: Query"Where in List" with UUID Problem
>
>
>Try your query like this:
>
>
>SELECT * FROM atty
>WHERE atty_id IN IN ('#ValueList(pa_list)#')
>
>
>
>-Original Message-
>From: Les Mizzell [mailto:[EMAIL PROTECTED]
>Sent: Monday, January 24, 2005 5:08 PM
>To: CF-Talk
>Subject: Query"Where in List" with UUID Problem
>
>Doing this:
>
>
>
>
>SELECT * FROM atty
>WHERE atty_id IN (#pa_list#)
>
>
>Originally, the pa_list was just numbers - 11,148,83,23
>
>The query worked fine at that point.
>
>However, a decision was made to use #CreateUUID()# to create the ID's,
>so the pa_list NOW looks like:
>
>1203,560,110,A6059FCB-BCD2-35D3-DD69BDA7A81553CF,A6081455-BCD2-35D3-DD69
>BDA7A81553CF
>
>Which is creating an error.
>
>Not sure what my syntax problem is at the moment. Haven't had enough
>coffee yet today.
>
>Thanks,
>
>--
>---
>Les Mizzell
~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191623
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Is there coldfusion based webmail product out there?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yes, from Macromedia. When you install Cold Fusion Server, the installer gives you the option to install some sample applications. (You generally do not want these in a production environment however) A webmail client (I think it's called Email Taxi or something) is one of the sample applications that get installed. HTH Warm regards, Jordan Michaels Vivio Technologies Discover Antartica wrote: |Is that from macromedia? is it part of the cf application kit from Macromedia? | |Jordan Michaels <[EMAIL PROTECTED]> wrote:-BEGIN PGP SIGNED MESSAGE- |Hash: SHA1 | |Discover Antartica wrote: | ||Is there coldfusion based webmail product out there? for free or |paid, either one. | |Silly footers, always cutting off my responses! Here's what I |attempted to write earlier: | |I believe one of the CF demo applications (which you can install when |you install Cold Fusion Server) is an webmail client. Email Taxi or |something? It's been a while since I've installed those though... | |HTH! | | |- -- |Warm regards, |Jordan Michaels |Vivio Technologies |http://www.viviotech.net/ |[EMAIL PROTECTED] |-BEGIN PGP SIGNATURE- |Version: GnuPG v1.2.4 (GNU/Linux) |Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org | |iD8DBQFB9TWo/G4NWP5tBHcRAvqtAJ9JD7j8NekJWf9plGF3O/stAUfDOgCfT24D |9K1mWyoIzTQc1ERnR8ByEks= |=+Jdv |-END PGP SIGNATURE- - -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFB9ZAo/G4NWP5tBHcRAgLoAJ4wf7s6XLv0hLoIiCukEROa+Oi7JQCgmpS/ pFYyf/qyWsOnANK8v5Vy6zQ= =xAYh -END PGP SIGNATURE- ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191622 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cfstoredproc timeout problem with JDBC Oracle driver
We're using CFMX 6.1 w/ updater and there is a cfstoredproc that has been working fine previous to migrating to MX. This is an Oracle stored procedure and we were using the Oracle driver provided with CFMX. Now when we try to execute this procedure, it is taking at least 14 seconds to reply. We switched the driver for the datasource to use an ODBC socket driver and now it's fine. I'm not really seeing any proformance issues with other types of Oracle database queries using the Oracle driver, so what gives with the stored procedure calls? I was under the impression that the JDBC drivers were supposed to be faster than the ODBC drivers. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191621 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Groupe de discussion en français sur ColdFusion
no but if you find one please let me know. Dana On Mon, 24 Jan 2005 16:31:30 -0500, Claude Schneegans <[EMAIL PROTECTED]> wrote: > Hi, > > Does anyone knows any discussion group about ColdFusion in French? ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191620 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Scheduled Event
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lee wrote: |I have a project where CF is on a shared server and I |don't have access to admin to set up scheduled events. Is |there a utility where I could just set up a browser to hit |a page on schedule from a non server machine? | |Lee | Have you tried using the CFSCHEDULE tag? If that doesn't work, you can set up a cron job that uses wget or curl to hit the URL on a regular basis. HTH, - -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFB9Yx2/G4NWP5tBHcRApt5AKCXJSRJ3wy2aJ3xSY046LD4krbNrwCfdPJQ c6b2+8ywl4wE1TfxqCGegvA= =0duz -END PGP SIGNATURE- ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191619 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web service security / session mgmt
It's up to the caller to maintain that state. It might be done with session variables, a database, whatever, that's not your concern. The point is that you have to have something stateful, and it has to be managed on the client side (the PHP app, in this case). If the client needs to do the calls over a period of time, with different requests, and even different users initiating the interaction, then the client needs to either have some appropriate storage, or just accept the fact that they'll have to reauthenticate every time. Your job isn't to figure out how to deal with that, you just have to provide a means for them to do it. Note that the sessionID I mentioned is created and managed by me and is 100% separate from CF's session management (which I don't use in favor of a client variables-ish setup). Nothing to do with CF at all, becuase CF's tracking capabilities are tailored to client-side browsers. cheers, barneyb On Mon, 24 Jan 2005 17:30:04 -0600, Matt Knight <[EMAIL PROTECTED]> wrote: > That scenareo will work...as long as all requests are within a single > execution (1 HTTP request) > > What about this scenario: > > At X time, RPC call is made - server responds with sessionID > At X + 10 mins. - another call is made. Since the client does not > accept cookies, the CF server creates a new session. > > I want to go back to the original session. How can you tie future > requests to the first session. > > I know I can access the session object (jrunx.kernel...) and get session > data by ref. the sessionID. I'd prefer not to do that. > > Any ideas? > > > Matt Knight > [EMAIL PROTECTED] > Senior Application Engineer - iMatch > tel: 214-576-9532 > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 8 invites. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191618 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFPOP - returned timestamps GRR!
> Unfortunately, this is the case. Feel like writing a Java implementation? :) > I'm sure there are plenty of public-domain POP classes out there already. Can you say "no utf-7 support"? With Sun not supporting unicode utf-7 it seems to me that it's a poor choice for writing any sort of e-mail client until the utf-7 encoding dies out... This I suspect will take a long time... > OK, just to be clear, there is the "Date" header which is set by the sending > client. Then there are the "Received" headers which there is one of for each > "hop" that the mail takes. For instance, your message has 5: Yes this is correct. Received headers are added by the SMTP servers that relay the mail and as such their dates should be reliable. The DATE header however is set by the client and should be the sent DateTime but invariably thanks to spammers is usually hours, days or even years away from what would be considered an accurate datetime value... Also some mail clients don't format the date field correctly which is inexcusable As you saw with the headers you pasted, after accounting for timezones, the date time values are all within 6 minutes of each other. Allowing for server load and mail delays, the times are what you would expect with regards to normal e-mail delivery. > Yes, the original emails are deleted. But I then send a few more test ones, > and they are all fetched with the "date" column being set to the time I > last fetched/deleted. This would be the date field so it should report the date/time that you SENT your mails. If you sent them just after you deleted the other mails then this sounds about right... >> The POP3 daemon will only be responsible for adding a date to the >> received header of your mail. If you check using a telnet session to >> your POP account, you will see that the first received header you see >> will be the one that was added to the mail by your SMTP service. > > Is this the "date" header or the "received" header? This is the received header. > I understand; if they would compile and run on Linux, I would be using > them in a flash. These MM bugs are seriously holding up our development. You know much about Kylix??? They *should* port with some work to them and a port of the CFXAPI header to Kylix... Unfortunately, I don't have the time at the moment... :( Paul ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191617 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query"Where in List" with UUID Problem
Matthew Walker wrote: > > SELECT * > FROMatty > WHERE atty_id IN ( cfsqltype="CF_SQL_CHAR" list="Yes">) > This seems the best bet - but I'm still getting an error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to numeric. SELECT * FROM atty WHERE atty_id IN ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) ) ORDER BY Line of code: atty_id IN () Data Type in the database is set to CHAR Hmmm... -- --- Les Mizzell ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Scheduled Event
I have a project where CF is on a shared server and I don't have access to admin to set up scheduled events. Is there a utility where I could just set up a browser to hit a page on schedule from a non server machine? Lee ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191615 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web service security / session mgmt
That scenareo will work...as long as all requests are within a single execution (1 HTTP request) What about this scenario: At X time, RPC call is made - server responds with sessionID At X + 10 mins. - another call is made. Since the client does not accept cookies, the CF server creates a new session. I want to go back to the original session. How can you tie future requests to the first session. I know I can access the session object (jrunx.kernel...) and get session data by ref. the sessionID. I'd prefer not to do that. Any ideas? Matt Knight [EMAIL PROTECTED] Senior Application Engineer - iMatch tel: 214-576-9532 -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 5:07 PM To: CF-Talk Subject: Re: Web service security / session mgmt I use a sessionID value, much like a cookie. Every WS interaction starts with a call to the 'authenticate' method, passing credentials. If they're valid, a sessionID is returned, and must be passed with all subsequent reqeusts (the actual WS calls). SessionIDs expire after a bit of time, as expected, and I also expose a logout/unauthenticate method that will do it explicitly should the client be well behaved enough to care. cheers, barneyb On Mon, 24 Jan 2005 17:00:57 -0600, Matt Knight <[EMAIL PROTECTED]> wrote: > I need to secure access to web services AND maintain session with > through RPC. > > I have a PHP application that will be consuming my web services > written in CFMX (6.1). > > Any thoughts/ suggestions / lessons learned ?? > > Thanks, > > Matt > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 8 invites. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191614 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFPOP - returned timestamps GRR!
Hi Paul, Thanks for your input. > As you've already stated, you can't use CFX_POP3 so unless you can find a > Java based replacement for CFPOP you aren't going to be able to do much to > improve the state of your issues. Unfortunately, this is the case. Feel like writing a Java implementation? :) I'm sure there are plenty of public-domain POP classes out there already. > Identifying the content-type of each attachment would mean extra > functionality in CFPOP that just isn't there. It needs a column in its > results that matches the attachmentfiles in approach and for every > attachment, it should provide the content type. Yes, and this of course would make sense. > POP dates can't be trusted in the headers at all as they are set by the > Client application at the point of send. I regularly see junk dates. If > however there is a difference between CFPOP and other mail clients then that > is a problem. OK, just to be clear, there is the "Date" header which is set by the sending client. Then there are the "Recieved" headers which there is one of for each "hop" that the mail takes. For instance, your message has 5: Received: by 10.54.3.22 with SMTP id 22cs4099wrc; Mon, 24 Jan 2005 00:44:16 -0800 (PST) Received: by 10.54.29.4 with SMTP id c4mr370458wrc; Mon, 24 Jan 2005 00:44:16 -0800 (PST) Return-Path: Received: from houseoffusion.com (houseoffusion.com [64.118.64.245]) by mx.gmail.com with ESMTP id 43si210052wri.2005.01.24.00.44.12; Mon, 24 Jan 2005 00:44:16 -0800 (PST) Received-SPF: pass (gmail.com: domain of listmaster@houseoffusion.com designates 64.118.64.245 as permitted sender) Received: from LOCALHOST by LOCALHOST with ESMTP id 299154C824E719429891DCDF31C95694 Mon, 24 Jan 2005 03:38:57 -0500 > Hmmm... But you said the original mails were deleted. Have you tried looking > at the headers using a telnet session to your server and deciphering the > date field yourself as a double check. Yes, the original emails are deleted. But I then send a few more test ones, and they are all fetched with the "date" column being set to the time I last fetched/deleted. > It is parsed, you just can't trust it. - see above. Dang. > The POP3 daemon will only be responsible for adding a date to the received > header of your mail. If you check using a telnet session to your POP > account, you will see that the first received header you see will be the one > that was added to the mail by your SMTP service. Is this the "date" header or the "recieved" header? > > Is there a way to access the raw message source so I can at least > > parse it out myself? > > Not with CFPOP. You could emulate a POP client using some sort of socket > plugin for CF effectively emulating a telnet connection over port 110. Not interested; CF is not excatly an ideal protocol handler. > From my experience, CFFTP and CFHTTP although flaky in previous versions are > pretty robust in CFMX 6.0 and above CFMX6.1 updater for us is rock solid. Yeah, I'm just on a rant. :) > Ok, I won't tell you to use my tags :). Unless you wan't to write something > yourself. You are hosed on a Unix box :( Seriously though, if you need any > help with doing something like that, I'll try to help where I can. I've at > least got a heap load of experience with CF and POP3 that I can offer. I understand; if they would compile and run on Linux, I would be using them in a flash. These MM bugs are seriously holding up our development. > I agree this is another issue with CFPOP, CID fields could also be passed > back to the query in a similar fashion to attachmentfiles but they aren't > which is a shame. We have a bug open with MM on this, but I don't think we will even see it fixed in Blackstone. Thanks for your input. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191613 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFPOP - returned timestamps GRR!
Hi Paul, Thanks for your input. > As you've already stated, you can't use CFX_POP3 so unless you can find a > Java based replacement for CFPOP you aren't going to be able to do much to > improve the state of your issues. Unfortunately, this is the case. Feel like writing a Java implementation? :) I'm sure there are plenty of public-domain POP classes out there already. > Identifying the content-type of each attachment would mean extra > functionality in CFPOP that just isn't there. It needs a column in its > results that matches the attachmentfiles in approach and for every > attachment, it should provide the content type. Yes, and this of course would make sense. > Moving onto your other questions > > > 1. My POP account receives several emails. Fetching them with CF, the > > DATE column of the returned CFPOP query are all the same, for example > > 01/01/2000 10:10:10. The action is "getHeaderOnly". > > POP dates can't be trusted in the headers at all as they are set by the > Client application at the point of send. I regularly see junk dates. If > however there is a difference between CFPOP and other mail clients then that > is a problem. OK, just to be clear, there is the "Date" header which is set by the sending client. Then there are the "Received" headers which there is one of for each "hop" that the mail takes. For instance, your message has 5: Received: by 10.54.3.22 with SMTP id 22cs4099wrc; Mon, 24 Jan 2005 00:44:16 -0800 (PST) Received: by 10.54.29.4 with SMTP id c4mr370458wrc; Mon, 24 Jan 2005 00:44:16 -0800 (PST) Return-Path: Received: from houseoffusion.com (houseoffusion.com [64.118.64.245]) by mx.gmail.com with ESMTP id 43si210052wri.2005.01.24.00.44.12; Mon, 24 Jan 2005 00:44:16 -0800 (PST) Received-SPF: pass (gmail.com: domain of listmaster@houseoffusion.com designates 64.118.64.245 as permitted sender) Received: from LOCALHOST by LOCALHOST with ESMTP id 299154C824E719429891DCDF31C95694 Mon, 24 Jan 2005 03:38:57 -0500 > Sometimes, it depends on how robust the POP client is at handling > incorrectly formatted Date fields as to how good the date looks when its > returned... > > > 2. I fetch the emails using a regular POP3 client (Thunderbird 1.0 in > > this case), they display the correct date. This client is set to > > "delete" as they are downloaded. > > > > 3. I then send some more emails to my POP account and fetch them using > > CF. The DATE column is essentially "refreshed" to the time that > > Thunderbird fetched/deleted the emails. > Hmmm... But you said the original mails were deleted. Have you tried looking > at the headers using a telnet session to your server and deciphering the > date field yourself as a double check. Yes, the original emails are deleted. But I then send a few more test ones, and they are all fetched with the "date" column being set to the time I last fetched/deleted. > > If I switch off the "delete after download" option in Thunderbird, the > > date/time is not refreshed. > > > > This leads me to the conclusion that the DATE column in the query > > returned by CFPOP IS NOT parsed from the date header of the email > > message. > > > > It is parsed, you just can't trust it. - see above. Dang. > > > > Is it just me, or is this behaviour incredibly stupid? Is my POP3 > > daemon (courier pop3d MySQL enabled) broken? Yes, my system time is > > correct: synchronized with two stratum 1 NTP servers. > > The POP3 daemon will only be responsible for adding a date to the received > header of your mail. If you check using a telnet session to your POP > account, you will see that the first received header you see will be the one > that was added to the mail by your SMTP service. Is this the "date" header or the "received" header? > > Is there a way to access the raw message source so I can at least > > parse it out myself? > > Not with CFPOP. You could emulate a POP client using some sort of socket > plugin for CF effectively emulating a telnet connection over port 110. Not interested; CF is not exactly an ideal protocol handler. > > Is this wrong, or am I just crazy. What the frig is the point of > > having a half-assed poorly implemented POP3 client? God help me when I > > need to start using CFFTP or CFHTTP. > > From my experience, CFFTP and CFHTTP although flaky in previous versions are > pretty robust in CFMX 6.0 and above CFMX6.1 updater for us is rock solid. Yeah, I'm just on a rant. :) > > And no, don't tell me to use CFX_POP or something else, because a) the > > Macromedia implementation should work and b) I'm hosted on a Unix > > environment. > > Ok, I won't tell you to use my tags :). Unless you wan't to write something > yourself. You are hosed on a Unix box :( Seriously though, if you need any > help with doing something like that, I'll try to help where I can. I've at > least got a heap load of experience with CF and POP3 that I can offer. I understand; if they would compile a
Re: CFPOP - returned timestamps GRR!
Hi Paul, Thanks for your input. > As you've already stated, you can't use CFX_POP3 so unless you can find a > Java based replacement for CFPOP you aren't going to be able to do much to > improve the state of your issues. Unfortunately, this is the case. Feel like writing a Java implementation? :) I'm sure there are plenty of public-domain POP classes out there already. > Identifying the content-type of each attachment would mean extra > functionality in CFPOP that just isn't there. It needs a column in its > results that matches the attachmentfiles in approach and for every > attachment, it should provide the content type. Yes, and this of course would make sense. > Moving onto your other questions > > > 1. My POP account receives several emails. Fetching them with CF, the > > DATE column of the returned CFPOP query are all the same, for example > > 01/01/2000 10:10:10. The action is "getHeaderOnly". > > POP dates can't be trusted in the headers at all as they are set by the > Client application at the point of send. I regularly see junk dates. If > however there is a difference between CFPOP and other mail clients then that > is a problem. OK, just to be clear, there is the "Date" header which is set by the sending client. Then there are the "Recieved" headers which there is one of for each "hop" that the mail takes. For instance, your message has 5: Received: by 10.54.3.22 with SMTP id 22cs4099wrc; Mon, 24 Jan 2005 00:44:16 -0800 (PST) Received: by 10.54.29.4 with SMTP id c4mr370458wrc; Mon, 24 Jan 2005 00:44:16 -0800 (PST) Return-Path: Received: from houseoffusion.com (houseoffusion.com [64.118.64.245]) by mx.gmail.com with ESMTP id 43si210052wri.2005.01.24.00.44.12; Mon, 24 Jan 2005 00:44:16 -0800 (PST) Received-SPF: pass (gmail.com: domain of listmaster@houseoffusion.com designates 64.118.64.245 as permitted sender) Received: from LOCALHOST by LOCALHOST with ESMTP id 299154C824E719429891DCDF31C95694 Mon, 24 Jan 2005 03:38:57 -0500 > Sometimes, it depends on how robust the POP client is at handling > incorrectly formatted Date fields as to how good the date looks when its > returned... > > > 2. I fetch the emails using a regular POP3 client (Thunderbird 1.0 in > > this case), they display the correct date. This client is set to > > "delete" as they are downloaded. > > > > 3. I then send some more emails to my POP account and fetch them using > > CF. The DATE column is essentially "refreshed" to the time that > > Thunderbird fetched/deleted the emails. > Hmmm... But you said the original mails were deleted. Have you tried looking > at the headers using a telnet session to your server and deciphering the > date field yourself as a double check. Yes, the original emails are deleted. But I then send a few more test ones, and they are all fetched with the "date" column being set to the time I last fetched/deleted. > > If I switch off the "delete after download" option in Thunderbird, the > > date/time is not refreshed. > > > > This leads me to the conclusion that the DATE column in the query > > returned by CFPOP IS NOT parsed from the date header of the email > > message. > > > > It is parsed, you just can't trust it. - see above. Dang. > > > > Is it just me, or is this behaviour incredibly stupid? Is my POP3 > > daemon (courier pop3d MySQL enabled) broken? Yes, my system time is > > correct: synchronized with two stratum 1 NTP servers. > > The POP3 daemon will only be responsible for adding a date to the received > header of your mail. If you check using a telnet session to your POP > account, you will see that the first received header you see will be the one > that was added to the mail by your SMTP service. Is this the "date" header or the "recieved" header? > > Is there a way to access the raw message source so I can at least > > parse it out myself? > > Not with CFPOP. You could emulate a POP client using some sort of socket > plugin for CF effectively emulating a telnet connection over port 110. Not interested; CF is not excatly an ideal protocol handler. > > Is this wrong, or am I just crazy. What the frig is the point of > > having a half-assed poorly implemented POP3 client? God help me when I > > need to start using CFFTP or CFHTTP. > > From my experience, CFFTP and CFHTTP although flaky in previous versions are > pretty robust in CFMX 6.0 and above CFMX6.1 updater for us is rock solid. Yeah, I'm just on a rant. :) > > And no, don't tell me to use CFX_POP or something else, because a) the > > Macromedia implementation should work and b) I'm hosted on a Unix > > environment. > > Ok, I won't tell you to use my tags :). Unless you wan't to write something > yourself. You are hosed on a Unix box :( Seriously though, if you need any > help with doing something like that, I'll try to help where I can. I've at > least got a heap load of experience with CF and POP3 that I can offer. I understand; if they would compile a
Re: CF and Cloudscape/Derby
Robert - Do you use PostgreSQL as the database for any of your CF apps? If yes, how do you like it? I'm keeping my eyes open for a good portable database to use with CFEverywhere (http://www.sys-con.com/story/?storyid=47827&DE=1) and intend on playing with Cloudscape a bit more (Cloudscape isn't something you jump right into without having reviewed the docs). Cheers! Chuck Robert Everland III wrote: >What about PostgreSQL http://www.postgresql.org/ftp/ they just came out with a >native win32 version. They have integrated stored procedures unlike MYSQL. > > > >Bob Everland > > ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191610 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web service security / session mgmt
I use a sessionID value, much like a cookie. Every WS interaction starts with a call to the 'authenticate' method, passing credentials. If they're valid, a sessionID is returned, and must be passed with all subsequent reqeusts (the actual WS calls). SessionIDs expire after a bit of time, as expected, and I also expose a logout/unauthenticate method that will do it explicitly should the client be well behaved enough to care. cheers, barneyb On Mon, 24 Jan 2005 17:00:57 -0600, Matt Knight <[EMAIL PROTECTED]> wrote: > I need to secure access to web services AND maintain session with > through RPC. > > I have a PHP application that will be consuming my web services written > in CFMX (6.1). > > Any thoughts/ suggestions / lessons learned ?? > > Thanks, > > Matt > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 8 invites. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191609 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Web service security / session mgmt
I need to secure access to web services AND maintain session with through RPC. I have a PHP application that will be consuming my web services written in CFMX (6.1). Any thoughts/ suggestions / lessons learned ?? Thanks, Matt ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191608 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need single quotes in SQL but is stored inside variable. - SOLVED
OK what I did what output the the original select into a #temp table then made a simple SQL select call to the #temp table that whay i do not have to escape any single quotes. Work smart not hard. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 4:46 PM To: CF-Talk Subject: RE: Need single quotes in SQL but is stored inside variable. Have you tried it? I think it will work. Ade -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: 24 January 2005 22:33 To: CF-Talk Subject: RE: Need single quotes in SQL but is stored inside variable. Nope that does not work, rember I need the single quotes in the statement. -Original Message- From: Cynthia Reece [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 4:30 PM To: CF-Talk Subject: RE: Need single quotes in SQL but is stored inside variable. Can't you escape the single quotes like so? @QUERY= 'SELECT email FROM table WHERE donotemail = ''Y''' ~Cynthia -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 5:25 PM To: CF-Talk Subject: Need single quotes in SQL but is stored inside variable. I need to write out a SQL statement to a string and set it to a varible inwhich i can call it from the EXEC() command. However in my SQL state ment I have to use single quotes for string criteria for example : SELECT email FROM table WHERE donotemail = 'Y' But what I have to do is take that exmple and set it to a variable like so: @QUERY= 'SELECT email FROM table WHERE donotemail = 'Y'' How do I escape the single quotes around the Y? This is being done inside a stored proc in SQL2K. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 21/01/2005 ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191607 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need single quotes in SQL but is stored inside variable.
Hey Eric - I tried this out myself and it worked fine, Are you sure the problem isn't that the SET is missing in the front? SET @QUERY= 'SELECT email FROM table WHERE donotemail = ''Y''' If I do a print @Query of this afterwards I get the string back properly -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 5:33 PM To: CF-Talk Subject: RE: Need single quotes in SQL but is stored inside variable. Nope that does not work, rember I need the single quotes in the statement. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191606 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT: What utility could I use to measure my clients' website bandwidth usage?
Anyone got any good tools to measure their clients' website bandwidth usage so I can charge if they go beyond a certain amount? Windows 2000 Server... Thanks, Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005 ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191605 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need single quotes in SQL but is stored inside variable.
Have you tried it? I think it will work. Ade -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: 24 January 2005 22:33 To: CF-Talk Subject: RE: Need single quotes in SQL but is stored inside variable. Nope that does not work, rember I need the single quotes in the statement. -Original Message- From: Cynthia Reece [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 4:30 PM To: CF-Talk Subject: RE: Need single quotes in SQL but is stored inside variable. Can't you escape the single quotes like so? @QUERY= 'SELECT email FROM table WHERE donotemail = ''Y''' ~Cynthia -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 5:25 PM To: CF-Talk Subject: Need single quotes in SQL but is stored inside variable. I need to write out a SQL statement to a string and set it to a varible inwhich i can call it from the EXEC() command. However in my SQL state ment I have to use single quotes for string criteria for example : SELECT email FROM table WHERE donotemail = 'Y' But what I have to do is take that exmple and set it to a variable like so: @QUERY= 'SELECT email FROM table WHERE donotemail = 'Y'' How do I escape the single quotes around the Y? This is being done inside a stored proc in SQL2K. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 21/01/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191604 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Passing an Array through a session variable...
That'll pass a reference, right? -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 5:13 PM To: CF-Talk Subject: Re: Passing an Array through a session variable... could you elaborate? just set it in the session... on Application.cfm: (where n is the # of dimensions, of course) On Mon, 24 Jan 2005 14:06:19 -0800, Charles Heizer <[EMAIL PROTECTED]> wrote: > Hello, > I was wondering how to pass an array through a session variable? > > Thanks, > - Charles > > ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191603 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Passing an Array through a session variable...
Sorry, I guess I'm losing it. I think I just over thunk the whole thing :-P - Charles On Jan 24, 2005, at 2:12 PM, Charlie Griefer wrote: > could you elaborate? > > just set it in the session... on Application.cfm: > > (where n is > the # of dimensions, of course) > > > > > On Mon, 24 Jan 2005 14:06:19 -0800, Charles Heizer <[EMAIL PROTECTED]> > wrote: >> Hello, >> I was wondering how to pass an array through a session variable? >> >> Thanks, >> - Charles >> >> > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191602 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need single quotes in SQL but is stored inside variable.
Nope that does not work, rember I need the single quotes in the statement. -Original Message- From: Cynthia Reece [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 4:30 PM To: CF-Talk Subject: RE: Need single quotes in SQL but is stored inside variable. Can't you escape the single quotes like so? @QUERY= 'SELECT email FROM table WHERE donotemail = ''Y''' ~Cynthia -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 5:25 PM To: CF-Talk Subject: Need single quotes in SQL but is stored inside variable. I need to write out a SQL statement to a string and set it to a varible inwhich i can call it from the EXEC() command. However in my SQL state ment I have to use single quotes for string criteria for example : SELECT email FROM table WHERE donotemail = 'Y' But what I have to do is take that exmple and set it to a variable like so: @QUERY= 'SELECT email FROM table WHERE donotemail = 'Y'' How do I escape the single quotes around the Y? This is being done inside a stored proc in SQL2K. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191601 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query"Where in List" with UUID Problem
I think you need this:
SELECT * FROM atty
WHERE atty_id IN (#pa_list#)
-Original Message-
From: Cynthia Reece [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 5:24 PM
To: CF-Talk
Subject: RE: Query"Where in List" with UUID Problem
Try your query like this:
SELECT * FROM atty
WHERE atty_id IN IN ('#ValueList(pa_list)#')
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 5:08 PM
To: CF-Talk
Subject: Query"Where in List" with UUID Problem
Doing this:
SELECT * FROM atty
WHERE atty_id IN (#pa_list#)
Originally, the pa_list was just numbers - 11,148,83,23
The query worked fine at that point.
However, a decision was made to use #CreateUUID()# to create the ID's,
so the pa_list NOW looks like:
1203,560,110,A6059FCB-BCD2-35D3-DD69BDA7A81553CF,A6081455-BCD2-35D3-DD69
BDA7A81553CF
Which is creating an error.
Not sure what my syntax problem is at the moment. Haven't had enough
coffee yet today.
Thanks,
--
---
Les Mizzell
~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191600
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF and Cloudscape/Derby
What about PostgreSQL http://www.postgresql.org/ftp/ they just came out with a native win32 version. They have integrated stored procedures unlike MYSQL. Bob Everland ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191599 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need single quotes in SQL but is stored inside variable.
Can't you escape the single quotes like so? @QUERY= 'SELECT email FROM table WHERE donotemail = ''Y''' ~Cynthia -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 5:25 PM To: CF-Talk Subject: Need single quotes in SQL but is stored inside variable. I need to write out a SQL statement to a string and set it to a varible inwhich i can call it from the EXEC() command. However in my SQL state ment I have to use single quotes for string criteria for example : SELECT email FROM table WHERE donotemail = 'Y' But what I have to do is take that exmple and set it to a variable like so: @QUERY= 'SELECT email FROM table WHERE donotemail = 'Y'' How do I escape the single quotes around the Y? This is being done inside a stored proc in SQL2K. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191598 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query"Where in List" with UUID Problem
SELECT * FROMatty WHERE atty_id IN () -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 11:08 a.m. To: CF-Talk Subject: Query"Where in List" with UUID Problem Doing this: SELECT * FROM atty WHERE atty_id IN (#pa_list#) Originally, the pa_list was just numbers - 11,148,83,23 The query worked fine at that point. However, a decision was made to use #CreateUUID()# to create the ID's, so the pa_list NOW looks like: 1203,560,110,A6059FCB-BCD2-35D3-DD69BDA7A81553CF,A6081455-BCD2-35D3-DD69BDA7 A81553CF Which is creating an error. Not sure what my syntax problem is at the moment. Haven't had enough coffee yet today. Thanks, -- --- Les Mizzell ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191597 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Need single quotes in SQL but is stored inside variable.
I need to write out a SQL statement to a string and set it to a varible inwhich i can call it from the EXEC() command. However in my SQL state ment I have to use single quotes for string criteria for example : SELECT email FROM table WHERE donotemail = 'Y' But what I have to do is take that exmple and set it to a variable like so: @QUERY= 'SELECT email FROM table WHERE donotemail = 'Y'' How do I escape the single quotes around the Y? This is being done inside a stored proc in SQL2K. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191596 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query"Where in List" with UUID Problem
Try your query like this:
SELECT * FROM atty
WHERE atty_id IN IN ('#ValueList(pa_list)#')
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 5:08 PM
To: CF-Talk
Subject: Query"Where in List" with UUID Problem
Doing this:
SELECT * FROM atty
WHERE atty_id IN (#pa_list#)
Originally, the pa_list was just numbers - 11,148,83,23
The query worked fine at that point.
However, a decision was made to use #CreateUUID()# to create the ID's,
so the pa_list NOW looks like:
1203,560,110,A6059FCB-BCD2-35D3-DD69BDA7A81553CF,A6081455-BCD2-35D3-DD69
BDA7A81553CF
Which is creating an error.
Not sure what my syntax problem is at the moment. Haven't had enough
coffee yet today.
Thanks,
--
---
Les Mizzell
~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191595
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using CF Metrics
I can't really offer any of the details you are looking for, but I just wanted to toss out the caveat that the function you mentioned, as far as I know, doesn't work on CFMX deployed on J2EE. - Calvin -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 12:55 PM To: CF-Talk Subject: Using CF Metrics I'm attempting to set up some very basic monitoring of my server via a page use the getMetricData() function in CFMX 6.1. I'm wondering if anyone else is doing this, and if so, what kind of numbers alarm you? I know some of this has to do with the size of your server, etc. but I'm just looking for the key points to highlight. This page may end up being viewed by not-so-technical individuals, so I'm hoping to use those numbers to display a graph or a percentage or something that's easy to understand for the end user. I'm just looking for any insights that anyone has on this sort of thing. Thanks! John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191595 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Query"Where in List" with UUID Problem
Doing this: SELECT * FROM atty WHERE atty_id IN (#pa_list#) Originally, the pa_list was just numbers - 11,148,83,23 The query worked fine at that point. However, a decision was made to use #CreateUUID()# to create the ID's, so the pa_list NOW looks like: 1203,560,110,A6059FCB-BCD2-35D3-DD69BDA7A81553CF,A6081455-BCD2-35D3-DD69BDA7A81553CF Which is creating an error. Not sure what my syntax problem is at the moment. Haven't had enough coffee yet today. Thanks, -- --- Les Mizzell ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191593 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Passing an Array through a session variable...
could you elaborate? just set it in the session... on Application.cfm: (where n is the # of dimensions, of course) On Mon, 24 Jan 2005 14:06:19 -0800, Charles Heizer <[EMAIL PROTECTED]> wrote: > Hello, > I was wondering how to pass an array through a session variable? > > Thanks, > - Charles > > ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191592 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Passing an Array through a session variable...
Hello, I was wondering how to pass an array through a session variable? Thanks, - Charles ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191591 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Inexpensive, CF-friendly payment gateway?
I have had positive experience with authorize.net, there is some pretty easy code on the macromedia dev site. Bob ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191590 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: # of Sites on a Server
At 11:55 AM 1/24/2005, you wrote: >...and you'll know when its time as CF will start freaking out on you. > Your pager will no longer stay silent for weeks. Your girlfriend >will start hating that beeping sound. You will stat losing a lot of >sleep cuz you keep having to get up and restart CF... you'll know. Oh man, that all sounds way to familiar. Thank god for loadbalancers. BTW, we recently bought and are running a loadbalancer from http://www.loadbalancer.org/clustered.htm. They are a small company, but the product is great and the service is great. The load balancer comes with two units, a master and a slave (to avoid the loadbalancer becoming the single point of failure) and only costs 7,138.31 USD. We are very happy with it. Brook Davies logiforms.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191589 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX ODBC/JDBC Drivers
If you are using SQL Server 2000 you can always use SQL Server JDBC drivers. Who better than MS to know how to handle their own server. I did some testing by looping through different types of queries such as inserts, updates and selects and with just 1000 queries Microsoft JDBC drivers were a couple seconds faster than the built in JDBC drivers. http://www.microsoft.com/downloads/details.aspx?FamilyID=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en Bob Everland ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191588 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFLDAP and Large Seraches
Hello, I'm running in to a strange size limit issue with CFLDAP, where if I query my directory (ADAM) I only get back 1,000 results and this is the SearchSizeLimit which is a 1000 in ADAM. I was told by Microsoft that in order to do large searches I would need to change the query from the SearchSize to pages. Does anyone know how I can do this? Thanks, - Charles ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191587 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cferror issue
On Mon, 24 Jan 2005 16:43:42 -0400, Robert Everland III <[EMAIL PROTECTED]> wrote: > Why does cferror exception not catch an error like this > , it will just throw the error without being caught by cferror. > Because the CF engine doesn't even get as far as compiling the page. If the page isn't compiled correctly, then no user-defined error trapping will be processed. The syntax error stops the CF compiler dead in its tracks. Regards, Dave. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191586 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFMX ODBC/JDBC Drivers
Scott, The CFMX 6.1 Updater 1 comes with Macromedia drivers version 3.3. These drivers have been demonstrated by CF QA to be superior to earlier versions, including those that were in CFMX 6.1 and especially those that came with 6.0x. Macromedia CF QA recommends using the 3.3 driver version. Steve > -Original Message- > From: Scott Wolf [mailto:[EMAIL PROTECTED] > Sent: Monday, January 24, 2005 4:16 PM > To: CF-Talk > Subject: CFMX ODBC/JDBC Drivers > > I was looking through the archives for solutions to a couple > of database problems that we're having on one of our > development servers. One solution that I want to try is > rolling back the ODBC/JDBC drivers that come with MX 6.1 to > the ones from MX 6.0. I've seen this suggested in several > places, unfortunately I can't seem to find a source for the > appropriate files and a list of instructions. If anyone > could point me in the right direction, I'd greatly appreciate > it. Thank you. > > Scott Wolf | Network Administrator | GravityFree > 1960 Stickney Point Road | Second Floor > Sarasota | FL | 34231 | 800.207.4431 > 941.927.7674 | f 941.923.5429 > www.GravityFree.com > > > ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191585 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cferror issue
Why does cferror exception not catch an error like this , it will just throw the error without being caught by cferror. Bob ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191584 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX + UTF8 vs Javascript
>>change the defaultCharset value in cf_root/lib/neo-runtime.xml file: UTF-8 from UTF-8 to iso-8859-1. then stop/restart the cfserver service. Thanks for the trick. Since the server handles only English and French site, I don't think it should be a problem >>a better long term solution is to convert those files to unicode Including the Javascrip files, but how do I edit them? >>ps: i hope this isn't somekind of ghost echo of the same thread from last week??? What do you mean "ghost echo", I'm still having a &?%$/ problem, and it is not a ghost problem ;-) By the way, how should we call this behaving from CF which forces UTF-8 uncompatible with Javascript? A bug? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191583 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
=?iso-8859-1?Q?Groupe de discussion en fran=E7ais sur ColdFusion ??=
Hi, Does anyone knows any discussion group about ColdFusion in French? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191582 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX + UTF8 vs Javascript
Claude Schneegans wrote: > Do I also have to put in > EVERY page? not a bad idea actually (never be shy about encoding hints) but if you want this server to ONLY handle latin-1 then: change the defaultCharset value in cf_root/lib/neo-runtime.xml file: UTF-8 from UTF-8 to iso-8859-1. then stop/restart the cfserver service. a better long term solution is to convert those files to unicode (since cf5 won't really care anwyay), for $15 unifier's a pretty good deal: http://www.melody-soft.com/html/unifier.html ps: i hope this isn't somekind of ghost echo of the same thread from last week??? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191581 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX + UTF8 vs Javascript
When on see pages like this: http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=209&threadid=814963 I can really see I'm not the only one having problems with French characters under CFMX ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191580 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX ODBC/JDBC Drivers
I was looking through the archives for solutions to a couple of database problems that we're having on one of our development servers. One solution that I want to try is rolling back the ODBC/JDBC drivers that come with MX 6.1 to the ones from MX 6.0. I've seen this suggested in several places, unfortunately I can't seem to find a source for the appropriate files and a list of instructions. If anyone could point me in the right direction, I'd greatly appreciate it. Thank you. Scott Wolf | Network Administrator | GravityFree 1960 Stickney Point Road | Second Floor Sarasota | FL | 34231 | 800.207.4431 941.927.7674 | f 941.923.5429 www.GravityFree.com ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191579 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT- SQL2K stored proc ANSI_NULLS and ANSI_WARNINGS help needed.
Hey that worked, thanks. I tried this below the create statement and kept failing. Now i get a new error. Any idea/ i am searching for it on line as we speak, but everything I am find is for import not export. Error as follow: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed. [OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.] -Original Message- From: Cynthia Reece [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 3:00 PM To: CF-Talk Subject: RE: OT- SQL2K stored proc ANSI_NULLS and ANSI_WARNINGS help needed. Hi Eric, I've had this problem before. If you open the sproc from Query Analyzer you should see at the top of the sproc: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE GetEhotline AS .. I would add another line for SET ANSI_WARNINGS ON then save the sproc and try again. You can also try running these sprocs: sp_dboption , 'warnings' (to find out how they are set now) sp_dboption , 'warnings', true (to set warnings to ON) ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191578 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
"No Top Level Page Was Found" Error
I copied all of my files from my test server to the new production server. I still have yet to migrate my DSNs, so I was fully expecting an error when I brought up my default page, but the following is what I got: Execution Time No top level page was found. Exceptions 16:04:37.037 - java.lang.NullPointerException - in : line -1 Any hints as to what this means? TIA, Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191577 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX + UTF8 vs Javascript
Hi,
I'm still having a big problem with this application in French, moving from CF
5.0 to CFMX.
The problem is that all pages and data in the Access database are not in
Unicode, but in
plain good old iso-8859-1.
CFMX by default is converting every thing in UTF-8.
Explorer understand that it is UTF-8, and text looks ok.
The trouble is that Explorer thinks that the Javascript files are also in
UTF-8, but since they are not
translated by CF, they are not.
See this example here:
http://diplomes.med.umontreal.ca/test/test.htm
This file just contains
And the javascript file contains:
alert("é ");
When you call the htm page, the alert actually shows the character "é"
But when you call test.cfm instead, the alert shows a square, because the é was
interpreted as a bad UTF-8 string.
If I add the line
in the Application.cfm file, everything looks fine, including Javascript,
BUT now in every record edited on the site, any character higher that 127 is
replaced by ý (7D in hex)
in the database... :-(
Do I also have to put in
EVERY page?
This looks crazy, I have hundreds of pages and the code must also run on CF 5.0
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191576
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFCs and virtual directories.
Not if you have \CFCDir off the custom tag folder with menu.cfc inside it. And a CFC directly in the custom tag folder could be invoked directly, without any prefix or dots at all. And yeah... I mean... roughly speaking URL = .cfm file, and if an app contains many CFM files, then app = URL(s), but still... is it an application, a website, or a page. Explicity makes things make more sense. Now, if I could just make some of them make cents, I'd be happier. ;) Laterz! J On Mon, 24 Jan 2005 14:05:09 -0500, DURETTE, STEVEN J (AIT) <[EMAIL PROTECTED]> wrote: > Hadn't thought of doing that. > > I tried to map to the directory in the CF Admin and it didn't work. > > Also, If I put it in a custom tag directory would I be able to browse > directly to the cfc to see it's hint information? > > Right now I have been using: > returnvariable="Session.menuInfo.menuMainText"> > value="#Session.Category#" /> > > > Would using it in a custom tag directory mean that I would have to > change that code? This cfc was originally used for one url, now I have > to allow all the other urls on the box be able to use it, but I don't > want to have to recode everything on my current url. (I keep saying > URL, but in actuality I should probably be saying IIS websites) > > Thanks, > Steve > > > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191575 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT- SQL2K stored proc ANSI_NULLS and ANSI_WARNINGS help needed.
Hi Eric, I've had this problem before. If you open the sproc from Query Analyzer you should see at the top of the sproc: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE GetEhotline AS .. I would add another line for SET ANSI_WARNINGS ON then save the sproc and try again. You can also try running these sprocs: sp_dboption , 'warnings' (to find out how they are set now) sp_dboption , 'warnings', true (to set warnings to ON) ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191574 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFUNITED? What's the deal??
On Mon, 24 Jan 2005 14:09:44 -0500, Alex Sherwood <[EMAIL PROTECTED]> wrote: > Calvin Ward wrote: > >How do you get $725 per day? 3 days at $895 (early registration) should be > >less than $725 > I used the regular registration price of $1100. About 1/2 of the > conference is CF-related, so I divided $1100 by 1.5 to get $725. All the prices I quoted were early birds which makes MAX about $300 a day for all content. Bear in mind that parts of CFUN / CFUNITED also cover Flash / Flex so it isn't a 100% CF conference either. And, given the number of tracks at MAX, you can actually attend all CF, all the time which makes your "1/2" argument somewhat weaker. But thanx for adding MAX to the comparison - I was looking mostly at non-CF conferences by way of comparison. As for Figleaf, good to hear chops for them - I have no point of reference to compare them since I haven't attended their courses (nor TeraTech's). FWIW, I think $500 / day for training is a good deal anyway. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191573 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT- SQL2K stored proc ANSI_NULLS and ANSI_WARNINGS help needed.
I did that but I still can not get the SQL statment to fire and fill the excel file. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 2:36 PM To: CF-Talk Subject: RE: OT- SQL2K stored proc ANSI_NULLS and ANSI_WARNINGS help needed. Refer to books on-line (BOL). Lookup... SET ANSI_NULLS ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191572 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT- SQL2K stored proc ANSI_NULLS and ANSI_WARNINGS help needed.
> From: Eric Creese [mailto:[EMAIL PROTECTED] > Ok I have a created a stored procedure that gets a list of > email addresses on Thurdays and will write them to an EXCEL > file, the logic decent and works however when the statement > that fetches the data is run I keep getting the > > "Heterogeneous queries require the ANSI_NULLS and > ANSI_WARNINGS options to be set for the connection. This > ensures consistent query semantics. Enable these options and > then reissue your query." > > I tried setting them in the query statement itself but it > still fails, I tried setting them before running the stored > proc and that does not work either. I even tried EXEC them > alone before firing the main query. Anybody have any suggestions? Refer to books on-line (BOL). Lookup... SET ANSI_NULLS ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191571 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT- SQL2K stored proc ANSI_NULLS and ANSI_WARNINGS help needed.
Ok I have a created a stored procedure that gets a list of email addresses on Thurdays and will write them to an EXCEL file, the logic decent and works however when the statement that fetches the data is run I keep getting the "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query." I tried setting them in the query statement itself but it still fails, I tried setting them before running the stored proc and that does not work either. I even tried EXEC them alone before firing the main query. Anybody have any suggestions? CREATE PROCEDURE GetEhotline AS DECLARE @MONTH int, @DAYint, @YEAR int, @LASTDAYdatetime, @CHECKDATE datetime, @DOWint, @LASTTHUR datetime, @colListvarchar(200), @charIndint, @tsqlStmt varchar(1000), @NumOfColumns tinyint, @query varchar(1000), @dosStmtvarchar(200), @fileName varchar(200), @filenameendvarchar(8), @tsqlStmtNULL varchar(30), @tsqlStmtWARN varchar(30) --SELECT @CHECKDATE = convert(varchar(10),getdate(),101) SET @filenameend = CONVERT(varchar(10),getdate(),112) SET @CHECKDATE = '1/20/2005' --TEST SELECT @DOW = DATEPART(weekday,@CHECKDATE) -- First check which day of the week it is. Thursday is the 5th day of the week IF @DOW = 5 BEGIN -- Next check to see if it is the last thursday of the month SELECT @lastday = convert(varchar(10),(SELECT dbo.LastMonthDay(@CHECKDATE)),101) SELECT CONVERT(varchar(2), DATEPART(m,@lastday))+'/'+CONVERT(varchar(2),mon_day)+'/'+ CONVERT(varchar(4),DATEPART(,@lastday)) AS dateofmonth INTO #tmp_month_dates FROM mon WHERE mon_day <= DATEPART(d,@lastday); SELECT @LASTTHUR= CONVERT(varchar(10),max(cast(dateofmonth as datetime)),101) FROM #tmp_month_dates WHERE DATEPART(weekday,dateofmonth) =5 IF @LASTTHUR = @CHECKDATE BEGIN PRINT 'Today is The Last Thursday' DROP TABLE #tmp_month_dates; END ELSE BEGIN --PRINT 'Today is Thursday but not the last Thurday of the Month' --- GET "HTML" SUBSCRIBERS SET @NumOfColumns =1 SET @charInd=0 SET @colList = 'A' WHILE @charInd < @NumOfColumns - 1 BEGIN SET @charInd = @charInd + 1 SET @colList = @colList + ',' + char(65 + @charInd) END -- Create an Empty Excel file as the target file name by copying the template Empty excel File SET @fileName = 'g:\temp\HTML_'[EMAIL PROTECTED]'.xls' SET @dosStmt = ' copy g:\temp\empty.xls ' + @fileName EXEC master..xp_cmdshell @dosStmt -- Create a "temporary" linked server to that file in order to "Export" Data EXEC sp_addlinkedserver 'ExcelSource', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', @fileName, NULL, 'Excel 5.0' -- Construct a T-SQL statement that will actually export the query results to the Table in the target linked server SET @query ='SELECT email FROM thisDatabase.dbo.peopleroleup(nolock) WHERE email like '+ '"[EMAIL PROTECTED]"' + ' AND dontshowonline = '+'"N"'+ ' AND personid IN( SELECT personid FROM thisDatabase.dbo.people(nolock) WHERE lookup001id = 2 --html AND personid IN ( SELECT personid FROM persondem WHERE expdate > getdate() ));'
Re: Inexpensive, CF-friendly payment gateway?
Thx Adam. Lets talk prices and stuff off-list. This is for a client of mine who is asking me to help him wade thru his choices and find the right one. He's the actual customer. Michael, PF Pro works great under CF. I actually have it running on my server for a client. The trouble is they want like $100 per month now when you throw in the extra services that are now mandatory for new clients (the fraud prevention stuff). Tried placing a client with them a year ago and came up with a $100 minimum monthly nut. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com <[EMAIL PROTECTED]> wrote: > Matt, > > I can set you up with everything you need, including the ColdFusion code to > request authorization and process the response: > > http://www.productivityenhancement.com/services/Affiliates.cfm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191569 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Javascript question
Javascript supports what they call, the trenary operator (hopely called it
right).
var result = comparison ? true value : false value;
So you can do
if(a == b){
return true;
}else{
return false;
}
or
return a == b ? true : false;
or for the diehard javascript lovers.. *wink* comparisons with regular
expressions.
if(/abc|def/i.test(string)){
}
Where you test for the existence of abc OR def in string, with the modifier i
to ignore case.
~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191568
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CF and Cloudscape/Derby
I'm hearing about Cloudscape/Derby as a reasonable database alternative to MySQL etc. Is anyone here using it? Comments on performance? Scalability? Stability? Features? What's the best way to hook CF up to it? Thanks, Dave Merrill ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191567 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: # of Sites on a Server
What Barney said. I have more sites than that running on a dual-proc/1.5gb ram system running mostly fully-db-driven cms pages. Formerly that server also ran web and db services as well. Recently began migrating the sites to a CF/IIS-only box and the load decrease is really huge. Seems like the real traffic issues occur when the search engine bots crawl zillions of pages about one week out of every month. Either way, you have to babysit the server and, after observation and experience tells you its time, break up the load to a new box. ...and you'll know when its time as CF will start freaking out on you. Your pager will no longer stay silent for weeks. Your girlfriend will start hating that beeping sound. You will stat losing a lot of sleep cuz you keep having to get up and restart CF... you'll know. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191566 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ODBC Hangs
Me too pleaseI've been getting that error a fair amount on Win2K Advanced Serverhaven't had the time to investigate as it's only a Dev server. Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191565 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFUNITED? What's the deal??
Calvin Ward wrote:
>How do you get $725 per day? 3 days at $895 (early registration) should be
>less than $725
>
>
I used the regular registration price of $1100. About 1/2 of the
conference is CF-related, so I divided $1100 by 1.5 to get $725. The
math might be a little fuzzy, but you get the drift. I'd go to MAX over
CFFUN every year.
>-Original Message-
>From: Alex Sherwood [mailto:[EMAIL PROTECTED]
>Sent: Monday, January 24, 2005 12:18 PM
>To: CF-Talk
>Subject: Re: CFUNITED? What's the deal??
>
>Sean Corfield wrote:
>
>
>
>>The early bird price for Software Development West is over $530 a day.
>>
>>php{con was nearly $500 a day (early bird). JavaOne is about $400 a
>>day I think. ASP.NET Connections is around $350 a day (early bird). So
>>it doesn't seem to matter whether we're talking 'free' technology or
>>'proprietary'.
>>
>>
>>
>>
>
>Macromedia MAX is conspicuously missing from this breakdown. MAX breaks
>down to about $725 per day. I personally like MAX, and would rather
>attend it than CFFUN. But that was when MACR would allow attendees to
>have MGM or Universal Studios to themselves on of the nights!
>
>
>
>>What about training courses? Cheaper? More expensive? TeraTech courses
>>are about $350 a day (very reasonable). Figleaf? About $500 a day. I
>>searched around and most ColdFusion training seems to range from $400
>>upward. Hal's Mach II course is about $600 a day (and well worth it,
>>BTW).
>>
>>
>>
>>
>IMHO, Figleaf is worth every damned penny and then some. When I was just
>starting out in '97 - '98, I had Steve Drucker, Charlie Aerhart, Simon
>Horowith and Dave Watts as instructors for a wide range of courses. I've
>never taken a class at TeraTech, but if I were in DC to take another,
>I'd go to FigLeaf. I took a class at FigLeaf called "CF Top Gun" that
>taught some cool techniques that some longtime developers don't even
>think to use today!
>
>Just my unsolicited .02.
>
>
>
--
Alex Sherwood
Director, Internet Services
PHS Collection Agency
Phone: 813-283-4579
Web: www.phs-net.com
~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191564
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFCs and virtual directories.
Hadn't thought of doing that.
I tried to map to the directory in the CF Admin and it didn't work.
Also, If I put it in a custom tag directory would I be able to browse
directly to the cfc to see it's hint information?
Right now I have been using:
Would using it in a custom tag directory mean that I would have to
change that code? This cfc was originally used for one url, now I have
to allow all the other urls on the box be able to use it, but I don't
want to have to recode everything on my current url. (I keep saying
URL, but in actuality I should probably be saying IIS websites)
Thanks,
Steve
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 1:42 PM
To: CF-Talk
Subject: Re: CFCs and virtual directories.
It'll be available to everything on the server if it's at
C:\CFusionMX\CustomTags (or equivalent)
If you want to instantiate, just use
createObject("component","cfcName");
Or, alternatively, you could put it in a folder ala package-style and
use:
createObject("component","my.package.folders.cfcName");
With that style, you'd use dots to separate your folder names instead
of (back-)slashes, with no prefix.
Or you can create a custom custom tag folder from within CF
Administrator and do basically the same thing. Adding a new custom tag
folder basically extends the real estate where CF looks for cf_ and
component files.
Laterz,
J
On Mon, 24 Jan 2005 13:28:08 -0500, jonese <[EMAIL PROTECTED]> wrote:
> did you try to put your CFC in your custom tag directory? or create a
> new CFC custom tag directory / mapping?
>
> ERJ
>
> On Mon, 24 Jan 2005 13:20:14 -0500, DURETTE, STEVEN J (AIT)
> <[EMAIL PROTECTED]> wrote:
> > Hi all,
> >
> > Got a quick question for you. I have created a cfc that I want
> > available to all urls on our web server (this is on an intranet).
So, I
> > created a directory outside of the webroots and put the cfc there.
Then
> > I went into IIS and created virtual directories on each of the
websites
> > that points to that directory.
> >
> > Problem is it doesn't work. If I delete the virtual directory and
copy
> > the files into a directory of the same name that the virtual
directory
> > was everything works fine.
> >
> > I'm trying to reuse this code for all of the sites on my server, but
I'm
> > not sure how. I don't want to put a copy in each website because I
want
> > one place where I can make changes and it will cascade everywhere
else.
> >
> > Thanks for any help you can give.
> >
> > Steve
> >
> >
>
>
>
>
--
Continuum Media Group LLC
Burnsville, MN 55337
http://www.web-relevant.com
http://cfobjective.blogspot.com
~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191563
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Javascript question
>>My guess is that this is some kind of shorthand for an if-then-else Your guess is right. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191562 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFUNITED? What's the deal??
How do you get $725 per day? 3 days at $895 (early registration) should be
less than $725
-Original Message-
From: Alex Sherwood [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 12:18 PM
To: CF-Talk
Subject: Re: CFUNITED? What's the deal??
Sean Corfield wrote:
> The early bird price for Software Development West is over $530 a day.
>
>php{con was nearly $500 a day (early bird). JavaOne is about $400 a
>day I think. ASP.NET Connections is around $350 a day (early bird). So
>it doesn't seem to matter whether we're talking 'free' technology or
>'proprietary'.
>
>
Macromedia MAX is conspicuously missing from this breakdown. MAX breaks
down to about $725 per day. I personally like MAX, and would rather
attend it than CFFUN. But that was when MACR would allow attendees to
have MGM or Universal Studios to themselves on of the nights!
>What about training courses? Cheaper? More expensive? TeraTech courses
>are about $350 a day (very reasonable). Figleaf? About $500 a day. I
>searched around and most ColdFusion training seems to range from $400
>upward. Hal's Mach II course is about $600 a day (and well worth it,
>BTW).
>
>
IMHO, Figleaf is worth every damned penny and then some. When I was just
starting out in '97 - '98, I had Steve Drucker, Charlie Aerhart, Simon
Horowith and Dave Watts as instructors for a wide range of courses. I've
never taken a class at TeraTech, but if I were in DC to take another,
I'd go to FigLeaf. I took a class at FigLeaf called "CF Top Gun" that
taught some cool techniques that some longtime developers don't even
think to use today!
Just my unsolicited .02.
--
Alex Sherwood
Director, Internet Services
PHS Collection Agency
Phone: 813-283-4579
Web: www.phs-net.com
~|
Logware: a new and convenient web-based time tracking application. Start
tracking and documenting hours spent on a project or with a client with Logware
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191561
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
ODBC Hangs
I am encountering a problem where out site hangs. It appears that the ODBC Server hangs. What happens: I am working on improving some code then the next thing the page will time out with "Error Executing Database Query. Timed out trying to establish connection " I have tried to stop the ODBC but it will not stop. Jest saying "stopping". The only way is to restart the server. Could any one advise as to what is happening and how to solve this? When trying to view connections: []java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191560 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using CF Metrics
Like you said, it's all about server size & load. No 2 answers will be the same. That having been said and repeated, I would have to suggest you take a reading every minute, stick it in the database, then graph the settings or at least report high/low/average. The way getmetricdata() works is it takes the reading for that millisecond. You can run it 5 times a second and get different results. One number will be at zero, then 1/10th of a second later it can be at 200. It's really all about your app, and your averages. -nathan Burns, John D wrote: > I'm attempting to set up some very basic monitoring of my server via a > page use the getMetricData() function in CFMX 6.1. I'm wondering if > anyone else is doing this, and if so, what kind of numbers alarm you? I > know some of this has to do with the size of your server, etc. but I'm > just looking for the key points to highlight. This page may end up being > viewed by not-so-technical individuals, so I'm hoping to use those > numbers to display a graph or a percentage or something that's easy to > understand for the end user. I'm just looking for any insights that > anyone has on this sort of thing. Thanks! > > John Burns > Certified Advanced ColdFusion MX Developer > AI-ES Aeronautics, Web Developer > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191559 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query Help
I know its goofybut lets say the 500 lb gorilla wants to eat...and he likes crappy reports. Is there a logic pattern I should follow...or do I run the query to find total $ in order items that contain the inventory itemand then check the payments table for any payments, and then just say, well, if there was a payment...count it? I would love to do in a single SQL query... Know what I mean? -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 10:12 AM To: CF-Talk Subject: Re: Query Help Eric, I don't think the problem has anything to do with your knowledge of SQL. It's not typical for a company to allocate order payments to specific order line items; rather, payments are typically applied to the entire order. Therefore, how could you possibly determine which line item a payment should be applied to...unless I'm missing something. Dina - Original Message - From: "Eric Hoffman" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, January 24, 2005 7:27 AM Subject: Query Help > I have to make a report based upon this scenario...seems simple, yet I > can't get the numbers rightany pointers? (I have ordered a newer > Advanced SQL book in the meantime!!) > > Need to get orders within date range containing a part number and get > total dollars received in payments for this. > > So I query the orders tablewhich is related to the order_items > table, where each line item of the order is stored, but does include a > line_total field which did qty * rate charged. On the other hand, the > payments table is related to the orders table by order id, and shows > amount paid...but obviously not breaking out what of the payment applies > to what. > > So how do I query to get the applicable payment amount correct by that > item id? Right now my numbers are inflated because it gets the whole > order payment amount. Recievables higher than sales is great in > fantasyland. Mucho frustrating no doubt. > > Thanks guys. > > Eric > > ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191558 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
