RE: Sessions being show to wrong users?
This sounds like sessions not being locked. Do a directory search on the web project, for "session." "server." "application." and look with those occurrences, if the have been embedded in a CFLOCK tag. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Andrew Grosset [mailto:[EMAIL PROTECTED] Sent: woensdag 26 januari 2005 3:33 To: CF-Talk Subject: Re: Sessions being show to wrong users? >Hello, >I have a login script on my site. It sets up a small series of session >variables. > >I am running CF 5, patched, on a very new server, with ample memory and >CPU. The server is hardly loaded, according to stats. > >This script was written about two years ago, and has not changed. > >Session information is stored in session variables. > >Very recently, a few visitors to my site arrive at the site and appear >to be logged in as other member's of the site. Some of them may not >even log in. I have restarted the cold fusion service. >This problem still persists. > >It appears that session variables are bleeding across to other sessions >on the site. > >I have started doing logging based on IP when initially logged in, and >the IP as they browse from page to page. I have found in a few >instances, the IP from the login, and the IP accessed via cgi aren't even from >the same subnet. These are always the sessions that have the wrong >information. > >Has anyone seen this problem? > >Thank you - can you post some code - showing how the session variables are set and read? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191759 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: Sessions being show to wrong users?
What is the URL that these people are coming in on ? Meaning, has Google cached one of your pages which has mypage.cfm?CFID=xxx&cftoken=xxx in the URL. If so, it is likely that CF is then recognising them as valid users and continuing the session. Only a thought. Also, it is possible that if people have the same kind of URL bookmarked then you would see a similar problem. Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.co.uk -Original Message- From: G. Brown [mailto:[EMAIL PROTECTED] Sent: 25 January 2005 18:27 To: CF-Talk Subject: Sessions being show to wrong users? Hello, I have a login script on my site. It sets up a small series of session variables. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191758 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: home page redirect
Don't you hate it when someone answers your question with a question: But why does your client insist on confounding user's expectations and risk pissing them off? Unless I'm dealing with a web app that requires a login or something similar, I know I'd be frustrated with that type of user experience. Okay, in addition to cgi.http_referer, maybe set a session variable only the home page and all other pages check for it existence and, if it's not there, redirect to the home page? - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, January 25, 2005 6:39 PM Subject: home page redirect > I have a client who wants everyone to be redirected to the home page that comes from another domain name other than the client's domain name. He wants everyone to start at the home page regardless of bookmarks or what is typed in the URL of the browser. > > Is there a way of doing that? I looked at cgi variable but could not find one that seems to fit. > > Sebastian > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191757 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: ColdFusion 5 RDS & Visual Source Safe
have u tried setting an RDS password? Doug On Tue, 25 Jan 2005 18:36:25 -0400, Rob Sherman <[EMAIL PROTECTED]> wrote: > As a follow up, it may have nothing to do with VSS.. RDS just doesn't work. > My co-worker has ColdFusion Studio 5 and can't connect via RDS either and is > prompted with the same error message "Unable to Authenticate.." even though > the ColdFusion 5 server is set to not require a password for RDS. > > This is a windows 2k server, does anyone have any suggestions that would > relate to IIS to ensure RDS will work? > > - Rob > > >We use this configuration regulary and it works fine for us so I > >reckon it must be your DWMX config. Does RDS work through the > >browser? > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191756 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: home page redirect
cgi.http_referer is what you could use http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Expressions5.htm On Tue, 25 Jan 2005 22:39:42 -0400, sp @ who. net sp @ who. net <[EMAIL PROTECTED]> wrote: > I have a client who wants everyone to be redirected to the home page that > comes from another domain name other than the client's domain name. He wants > everyone to start at the home page regardless of bookmarks or what is typed > in the URL of the browser. > > Is there a way of doing that? I looked at cgi variable but could not find one > that seems to fit. > > Sebastian > > ~| 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:191755 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
home page redirect
I have a client who wants everyone to be redirected to the home page that comes from another domain name other than the client's domain name. He wants everyone to start at the home page regardless of bookmarks or what is typed in the URL of the browser. Is there a way of doing that? I looked at cgi variable but could not find one that seems to fit. Sebastian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191754 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: Sessions being show to wrong users?
>Hello, >I have a login script on my site. It sets up a small series of session >variables. > >I am running CF 5, patched, on a very new server, with ample memory and >CPU. The server is hardly loaded, according to stats. > >This script was written about two years ago, and has not changed. > >Session information is stored in session variables. > >Very recently, a few visitors to my site arrive at the site and appear >to be logged in as other member's of the site. Some of them may not >even log in. I have restarted the cold fusion service. >This problem still persists. > >It appears that session variables are bleeding across to other sessions >on the site. > >I have started doing logging based on IP when initially logged in, and >the IP as they browse from page to page. I have found in a few >instances, the IP from the login, and the IP accessed via cgi aren't even from >the same subnet. These are always the sessions that have the wrong >information. > >Has anyone seen this problem? > >Thank you - can you post some code - showing how the session variables are set and read? ~| 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:191753 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: PHP equivalent of cfhtmlhead
Could be. I haven't actually implemented anything yet. Maybe it is just the equivalent of cfheader. George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191752 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: PHP equivalent of cfhtmlhead
George Abraham wrote: > Well for the time being, this is what I found as an > acceptable/workable alternative: > > http://www.zend.com/zend/art/buffering.php Ah yes, I've used ob_start() before... but isn't that pretty much only for http headers? - Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.3 - Release Date: 1/24/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191751 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: homegrown session variables
u could even store them in flashes shared objects like cookies and pass them back and forth very easily From: "Marlon Moyer" <[EMAIL PROTECTED]> Sent: Tuesday, January 25, 2005 8:02 PM To: CF-Talk Subject: homegrown session variables I'm thinking about trying to create my own session variables. I was thinking that it might be easier to recreate a session scope inside the application scope for use with web services. This way you could use the same model for both an HTML frontend and a Flash frontend, etc. I'm thinking that it should be as simple as assigning a user a unique Id and then creating a structure inside the application scope using the uid as the key. Then you could put a timestamp inside that structure and schedule a job to kill all old "sessions". Does the built-in CF session scope operate any differently than this? Anything I'm missing? ~| 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:191750 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
homegrown session variables
I'm thinking about trying to create my own session variables. I was thinking that it might be easier to recreate a session scope inside the application scope for use with web services. This way you could use the same model for both an HTML frontend and a Flash frontend, etc. I'm thinking that it should be as simple as assigning a user a unique Id and then creating a structure inside the application scope using the uid as the key. Then you could put a timestamp inside that structure and schedule a job to kill all old "sessions". Does the built-in CF session scope operate any differently than this? Anything I'm missing? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191749 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: cfqueryparam help
>That is because UCase() is a CF function and not an Oracle function. Oops. 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:191748 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: CFC newbie: trying the calendar API, getting error
it looks like it is specifically coded to run from the calendar
folder. Try creating a calendar folder and dropping all the files in
that and running it again.
I dropped the folder that unzipped from the download, into my webroot.
called /calendar/sample/index.cfm and the whole app came to life.
Good Luck
simeon
On Tue, 25 Jan 2005 12:38:23 -0500, Damien McKenna
<[EMAIL PROTECTED]> wrote:
> Greetings everyone.
>
> I'm trying out the calendar API
> (http://www.horwith.com/index.cfm?mode=entry&entry=C8837FD9-E081-0478-47
> F93823F4029950) and obviously have the directory structure messed up
> somehow as it isn't working. I've set it up where all of the files are
> under the site root and get this error:
>
> Could not find the ColdFusion Component calendar.cfc.calendar.
> Please check that the given name is correct and that the component
> exists.
> The error occurred in
> C:\Inetpub\wwwroot\secure3_spnvision_com\calendar\sample\Application.cfm
> : line 23
> 21 :// set this to the path to your component
> 22 :request.useScope.calendarCFCPath =
> "calendar.cfc.calendar";
> 23 :request.useScope.objCalendar = createObject("component",
> request.useScope.calendarCFCPath);
> 24 :request.useScope.objCalendar.init(now(), true);
> 25 :request.useScope.objCalendar.setWeekStart(1);
>
> Anyone care to help me set this up? Thanks.
>
> --
> Damien McKenna - Web Developer - [EMAIL PROTECTED]
> The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
> #include
>
>
~|
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:191747
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: Solution - NOAA Weather Forecast via CFMX Web Service
I have finally had to chance to play with this code. I would like to let anyone else who has tried this know that it works, if you have the proper version of ColdFusion. When I first tried it, I was running it on CF version: 6,1,0,63958 ColdFusion MX 6.1. But after I updated my CF to version: 6,1,0,83762 ColdFusion MX 6.1 Updater, all worked well. Now the fun starts, I see how I can integrate this with my outdoor recreation site! Yee haw! Thanks Jon Block for the nice CFC. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ...-Original Message- ...From: Dawson, Michael [mailto:[EMAIL PROTECTED] ...Sent: Tuesday, January 18, 2005 2:29 PM ...To: CF-Talk ...Subject: RE: Solution - NOAA Weather Forcast via CFMX Web Service ... ...I downloaded your CFC and copied the sample code from your web site. ... ...When I run the page, I get the following error: ... ...Could not perform web service invocation "NDFDgenByDay" because ...java.lang.IllegalArgumentException: argument type mismatch ... ...The error appears to be related to the "format" argument. At least, ...that is what CF has highlighted. ... ...-Original Message- ...From: Jon Block [mailto:[EMAIL PROTECTED] ...Sent: Monday, January 17, 2005 4:19 PM ...To: CF-Talk ...Subject: Solution - NOAA Weather Forcast via CFMX Web Service ... ...CF'ers, ... ...I figured out the problem that everybody was talking about in a previous ...thread from earlier in the month. This email describes how to make it ...work. ... ...The problem that (I think) everybody was having is that they forgot that ...web services are strongly typed but ColdFusion is not. That means you ...can't pass a string into an array of bits. You can use my simple CFC ...interface to all of this at ...(http://www.jonathanblock.com/pineapple/noaa.html) or you can do it ...yourself like I have in the example below... ... ...(example.cfm) ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...http://weather.gov/forecasts/xml/DWMLgen/wsdl/ndfdXML.wsdl"; ... method = "NDFDgenByDay" ... returnvariable = "xmlWeatherData"> ... ... ... ... ... ... ... ... ... ...Jon Block ... ... ... ... ... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191746 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
Woohoo! One thing I sometimes do (which in retrospect I might have mentioned) is to try deleting the bit with the error and seeing if the error goes away. In this case it wouldn't have, which would have been good to know. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 January 2005 11:30 a.m. To: CF-Talk Subject: Re: Query Larry White wrote: > Well, you have contradictions in your SQL: > WHERE atty_id <> 8787445854777 , indictes atty_id is numeric (no quotes) > yet the valuelist for atty_id is enclosed in quotes. It can't be both > ways. Yep, I *finally* figured that out! The error message kept pointing to the "Where" line though, which was throwing me off. The actual query on the page is almost 30 lines long - stupid me just lost it while searching for that one thing throwing it off Doh!!! Thanks! -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191745 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: ColdFusion 5 RDS & Visual Source Safe
As a follow up, it may have nothing to do with VSS.. RDS just doesn't work. My co-worker has ColdFusion Studio 5 and can't connect via RDS either and is prompted with the same error message "Unable to Authenticate.." even though the ColdFusion 5 server is set to not require a password for RDS. This is a windows 2k server, does anyone have any suggestions that would relate to IIS to ensure RDS will work? - Rob >We use this configuration regulary and it works fine for us so I >reckon it must be your DWMX config. Does RDS work through the >browser? ~| 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:191744 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: PHP equivalent of cfhtmlhead
Well for the time being, this is what I found as an acceptable/workable alternative: http://www.zend.com/zend/art/buffering.php George ~| 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:191743 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: > Well, you have contradictions in your SQL: > WHERE atty_id <> 8787445854777 , indictes atty_id is numeric (no quotes) > yet the valuelist for atty_id is enclosed in quotes. It can't be both > ways. Yep, I *finally* figured that out! The error message kept pointing to the "Where" line though, which was throwing me off. The actual query on the page is almost 30 lines long - stupid me just lost it while searching for that one thing throwing it off Doh!!! 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:191742 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: ColdFusion 5 RDS & Visual Source Safe
It could possibly be the DWMX config, but I'm not sure where to start in debugging that setup, afterall everything else works, just not RDS specifically. When you say "Does RDS work through the browser" do you mean web browser? -Rob >We use this configuration regulary and it works fine for us so I >reckon it must be your DWMX config. Does RDS work through the >browser? ~| 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:191741 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: cfqueryparam help
That is because UCase() is a CF function and not an Oracle function. On Tue, 25 Jan 2005 17:17:11 -0400, daniel kessler <[EMAIL PROTECTED]> wrote: > > Try, LIKE > cfsqltype="cf_sql_varchar"> > > ah that makes sense, thanks. I have a followup question. > I changed UPPER to UCase in the next line and received an error, > "UCase:invalid identifier", but it works fine with Agency in the line above > and with UPPER(city). I was just trying to be consistent. > > query line: > >AND UCase(agency) LIKE cfsqltype="cf_sql_varchar"> > > >AND UCase(city) LIKE cfsqltype="cf_sql_varchar"> > > > ~| 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:191740 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: cfqueryparam help
query line: AND UCase(agency) LIKE AND UCase(city) LIKE On the left side of the LIKE operator you have to use the syntax of the DBMS, on the right side of the LIKE operator you use the ColdFusion syntax. So change back to UPPER() on the left. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191739 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: cfqueryparam help
> Try, LIKE cfsqltype="cf_sql_varchar"> ah that makes sense, thanks. I have a followup question. I changed UPPER to UCase in the next line and received an error, "UCase:invalid identifier", but it works fine with Agency in the line above and with UPPER(city). I was just trying to be consistent. query line: AND UCase(agency) LIKE AND UCase(city) LIKE ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191738 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
I did my tests on a new coldfusion install, with 6.1 updater and all the hotfixes. 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:191737 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
If you saw my code you saw that the only thing I was doing was a select statement to the SQL server. The reason the second test was so fast was because I left caching on, so that I would get a more real world result. As I said earlier, I have no reason not to use JTDS, as a matter of fact if they were faster I would be more than willing to use them instead of Microsoft's drivers. As it stands now though, I have not been able to justify their use . Even though the tests on your website show the drivers being faster, it was done in a very specific manner, I need the drivers to work in a ColdFusion enviroment and if they aren't faster in ColdFusion then they are no use to me. I ask anyone else to run the same test I did. A loop that runs 100 times is by no means breaking a site, and in my opinion there is no real reason to bog a server down by running it for hours at a time. Real world users should be reading from the database significantly more than they should be doing anything else. Bob Everland ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191736 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: PHP equivalent of cfhtmlhead
> -Original Message- > From: Figy, Kam [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 25, 2005 4:48 PM > To: CF-Talk > Subject: RE: OT: PHP equivalent of cfhtmlhead > > It's also convenient if you want to have a global header include but > have page titles on a per-page basis. I use CFHTMLHEAD a lot - but I do wish there was a more generic processing for it. I'd like to be able to set an "include point" someplace on the page then later throw some content to it. For example I grab a tickcount from the beginning of application.cfm and at the end of OnRequestEnd.cfm. I then dump that to the output. But of course that information is outside the HTML tags (since I use Custom Tags to include Headers and Footers outside of the auto-includes). It would be nice to set a place for that information: something like: And then later use something like: (Or something like that) This is clearly what CFHTMLHEAD is doing already - I'd just like to make it more generic. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191735 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: PHP equivalent of cfhtmlhead
It's also convenient if you want to have a global header include but have page titles on a per-page basis. kam -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 11:17 AM To: CF-Talk Subject: Re: OT: PHP equivalent of cfhtmlhead Using cfhtmlhead, you can dynamically add references to other stylesheets or scripts that you don't normally want to clutter your page with. Since it does the addition of these references to the head section of the html before the html page is sent to the browser, it is of great help. George ~| 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:191734 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
I'd say the first time you use things, the classloader is loading the classes, so I wouldn't compare trial 1 and anything Try comparing trial 2 and trial 3. Do you get the same difference in results? What JVM's was jtds tested on? Perhaps jtds benchmarks across jvms should be published somewhere? -Dov -Original Message- From: Alin Sinpalean [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 3:30 PM To: CF-Talk Subject: Re: CFMX ODBC/JDBC Drivers Robert, I am a jTDS developer and I can tell you (and you may choose to believe me or not) that jTDS is definitely faster than the MS driver. I'm not familiar with CF but from what I can tell you are doing no processing of the results returned by the query, so the test is a bit irrelevant. You should go through all the results and read each column. Also, the difference between the first and the second run times for the MS driver (it's about a third faster in the second run) makes me think there's something wrong with the test (again, since I'm a Java, not CF programmer I can't say exactly what). Alin. ~| 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:191733 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 did it!!
This is a multi instance server. If I put a Virtual Directory pointing
to the CFCDir and then put in a CFA mapping to the CFCDir using the same
name as the virtual directory, the cfc works and programmers can browse
to the cfc and see the hints!
Thanks for all the help.
Steve
-Original Message-
From: Ben Rogers [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 4:21 PM
To: CF-Talk
Subject: RE: CFCs and virtual directories.
Duplicating the mapping should work. ColdFusion does not honor IIS
virtual
directories. You may be more used to ASP, in which "virtual directory"
and
"mapping" are synonymous.
To further complicate things, you may have to duplicate the mapping in
the
JRun config files as well. I've found that, sometimes, even ColdFusion
mappings are ignored. This seems to be the case when invoking a CFC as a
Web
service (which in turn uses mappings).
I believe this is only true in what Macromedia terms a multi-homed
server
configuration. If you're hosting a single site on the server, then you
probably won't see this as both JRun and ColdFusion are configured with
a
"/" mapping by default.
Ben Rogers
http://www.c4.net
v.508.240.0051
f.508.240.0057
> -Original Message-
> From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 25, 2005 3:39 PM
> To: CF-Talk
> Subject: RE: CFCs and virtual directories.
>
> Doug,
>
> That's been the issue all along. If I put the cfc into a directory
and
> make a virtual directory that points to it, the cfc doesn't work and
> browsing to the cfc doesn't work.
>
> If I do a cold fusion mapping to the cfc directory then the cfc works,
> but I can't let the programmers browse to the cfc to get the hint
> information. It just returns a file not found error.
>
> That is why I was considering doing both to see what happens. I just
> haven't had time to do it yet.
>
> If you can think of another way for the cfc to work and browsing to
the
> cfc to work, without copying it into each website, please let me know.
>
> Steve
>
>
> -Original Message-
> From: Douglas Knudsen [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 25, 2005 1:42 PM
> To: CF-Talk
> Subject: Re: CFCs and virtual directories.
>
>
> virtual directories respond to HTTP calls, in other words calls to
> IIS. Mappings are used by CF only. If you want a CF mapping to be
> available via HTTP, you have to create a virtual dir.
>
>
> Doug
>
>
> On Tue, 25 Jan 2005 11:57:14 -0500, DURETTE, STEVEN J (AIT)
> <[EMAIL PROTECTED]> wrote:
> > Ok, I did some testing and found out that while the cfc does work,
you
> > can't get information from it like you would if you by doing
something
> > like http://localserver/mycfcdir/mycfc.cfc
> >
> > I'm thinking about seeing what happens when you have both a virtual
> > directory in iis and a mapping in ColdFusion. Which would win out.
> > Would it still work.
> >
> > Later,
> > Steve
> >
> >
> > -Original Message-
> > From: John Beynon [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, January 25, 2005 6:55 AM
> > To: CF-Talk
> > Subject: Re: CFCs and virtual directories.
> >
> >
> > yes that will work...of course, if you had a folder named siteModel
> off
> > the webroot it would work too, provided your '/' cfmapping goes to
the
> > web root
> >
> > jb.
> >
> > > OK. So let's say i have a mapping in cf administrator called
> > > /siteModel. I should be be able to invoke a cfc by either
> > >
> > >
> > >
> > > or
> > >
> > > createObject("component","siteModel.myCFC")
> > >
> > > ?
> > >
> > > Dwayne
> > >
> > > -- Original Message --
> > > From: "Jared Rypka-Hauer - CMG, LLC" <[EMAIL PROTECTED]>
> > > Reply-To: cf-talk@houseoffusion.com
> > > Date: Tue, 25 Jan 2005 01:54:55 -0600
> > >
> > > >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
> > > bef
Re: CFMX ODBC/JDBC Drivers
Robert, I am a jTDS developer and I can tell you (and you may choose to believe me or not) that jTDS is definitely faster than the MS driver. I'm not familiar with CF but from what I can tell you are doing no processing of the results returned by the query, so the test is a bit irrelevant. You should go through all the results and read each column. Also, the difference between the first and the second run times for the MS driver (it's about a third faster in the second run) makes me think there's something wrong with the test (again, since I'm a Java, not CF programmer I can't say exactly what). Alin. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191731 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.
Duplicating the mapping should work. ColdFusion does not honor IIS virtual
directories. You may be more used to ASP, in which "virtual directory" and
"mapping" are synonymous.
To further complicate things, you may have to duplicate the mapping in the
JRun config files as well. I've found that, sometimes, even ColdFusion
mappings are ignored. This seems to be the case when invoking a CFC as a Web
service (which in turn uses mappings).
I believe this is only true in what Macromedia terms a multi-homed server
configuration. If you're hosting a single site on the server, then you
probably won't see this as both JRun and ColdFusion are configured with a
"/" mapping by default.
Ben Rogers
http://www.c4.net
v.508.240.0051
f.508.240.0057
> -Original Message-
> From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 25, 2005 3:39 PM
> To: CF-Talk
> Subject: RE: CFCs and virtual directories.
>
> Doug,
>
> That's been the issue all along. If I put the cfc into a directory and
> make a virtual directory that points to it, the cfc doesn't work and
> browsing to the cfc doesn't work.
>
> If I do a cold fusion mapping to the cfc directory then the cfc works,
> but I can't let the programmers browse to the cfc to get the hint
> information. It just returns a file not found error.
>
> That is why I was considering doing both to see what happens. I just
> haven't had time to do it yet.
>
> If you can think of another way for the cfc to work and browsing to the
> cfc to work, without copying it into each website, please let me know.
>
> Steve
>
>
> -Original Message-
> From: Douglas Knudsen [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 25, 2005 1:42 PM
> To: CF-Talk
> Subject: Re: CFCs and virtual directories.
>
>
> virtual directories respond to HTTP calls, in other words calls to
> IIS. Mappings are used by CF only. If you want a CF mapping to be
> available via HTTP, you have to create a virtual dir.
>
>
> Doug
>
>
> On Tue, 25 Jan 2005 11:57:14 -0500, DURETTE, STEVEN J (AIT)
> <[EMAIL PROTECTED]> wrote:
> > Ok, I did some testing and found out that while the cfc does work, you
> > can't get information from it like you would if you by doing something
> > like http://localserver/mycfcdir/mycfc.cfc
> >
> > I'm thinking about seeing what happens when you have both a virtual
> > directory in iis and a mapping in ColdFusion. Which would win out.
> > Would it still work.
> >
> > Later,
> > Steve
> >
> >
> > -Original Message-
> > From: John Beynon [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, January 25, 2005 6:55 AM
> > To: CF-Talk
> > Subject: Re: CFCs and virtual directories.
> >
> >
> > yes that will work...of course, if you had a folder named siteModel
> off
> > the webroot it would work too, provided your '/' cfmapping goes to the
> > web root
> >
> > jb.
> >
> > > OK. So let's say i have a mapping in cf administrator called
> > > /siteModel. I should be be able to invoke a cfc by either
> > >
> > >
> > >
> > > or
> > >
> > > createObject("component","siteModel.myCFC")
> > >
> > > ?
> > >
> > > Dwayne
> > >
> > > -- Original Message --
> > > From: "Jared Rypka-Hauer - CMG, LLC" <[EMAIL PROTECTED]>
> > > Reply-To: cf-talk@houseoffusion.com
> > > Date: Tue, 25 Jan 2005 01:54:55 -0600
> > >
> > > >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 (www.logware.us): a new and convenient web-based time tracking
application. S
Re: Sessions being show to wrong users?
Did CF5 allow you to user UUID instead of CFToken/CFID? If so, that mey help. On Tue, 25 Jan 2005 21:02:18 +, Michael Traher <[EMAIL PROTECTED]> wrote: > This may not be your senario , but this kind of problem can happen > when proxy servers are caching pages. Not sure if that helps in your > search. > > ~| 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:191729 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: Sessions being show to wrong users?
This may not be your senario , but this kind of problem can happen when proxy servers are caching pages. Not sure if that helps in your search. ~| 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:191728 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: cfqueryparam help
Try, LIKE On Tue, 25 Jan 2005 15:31:16 -0400, daniel kessler <[EMAIL PROTECTED]> wrote: > sorry it posted a bunch of times. I only clicked once so I don't know why it > did it, but sorry anyway. Hope this doesn't reply 5 times. > > ~| 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:191727 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.
Doug,
That's been the issue all along. If I put the cfc into a directory and
make a virtual directory that points to it, the cfc doesn't work and
browsing to the cfc doesn't work.
If I do a cold fusion mapping to the cfc directory then the cfc works,
but I can't let the programmers browse to the cfc to get the hint
information. It just returns a file not found error.
That is why I was considering doing both to see what happens. I just
haven't had time to do it yet.
If you can think of another way for the cfc to work and browsing to the
cfc to work, without copying it into each website, please let me know.
Steve
-Original Message-
From: Douglas Knudsen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 1:42 PM
To: CF-Talk
Subject: Re: CFCs and virtual directories.
virtual directories respond to HTTP calls, in other words calls to
IIS. Mappings are used by CF only. If you want a CF mapping to be
available via HTTP, you have to create a virtual dir.
Doug
On Tue, 25 Jan 2005 11:57:14 -0500, DURETTE, STEVEN J (AIT)
<[EMAIL PROTECTED]> wrote:
> Ok, I did some testing and found out that while the cfc does work, you
> can't get information from it like you would if you by doing something
> like http://localserver/mycfcdir/mycfc.cfc
>
> I'm thinking about seeing what happens when you have both a virtual
> directory in iis and a mapping in ColdFusion. Which would win out.
> Would it still work.
>
> Later,
> Steve
>
>
> -Original Message-
> From: John Beynon [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 25, 2005 6:55 AM
> To: CF-Talk
> Subject: Re: CFCs and virtual directories.
>
>
> yes that will work...of course, if you had a folder named siteModel
off
> the webroot it would work too, provided your '/' cfmapping goes to the
> web root
>
> jb.
>
> > OK. So let's say i have a mapping in cf administrator called
> > /siteModel. I should be be able to invoke a cfc by either
> >
> >
> >
> > or
> >
> > createObject("component","siteModel.myCFC")
> >
> > ?
> >
> > Dwayne
> >
> > -- Original Message --
> > From: "Jared Rypka-Hauer - CMG, LLC" <[EMAIL PROTECTED]>
> > Reply-To: cf-talk@houseoffusion.com
> > Date: Tue, 25 Jan 2005 01:54:55 -0600
> >
> > >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
> > >
> >
>
>
~|
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:191726
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: Dynamic table tag?
no but it comes built-in to dw look under the application tab for the lightning bolts (see this image) http://www.icandfashion.com/dt.jpg From: Stas Newdel <[EMAIL PROTECTED]> Sent: Tuesday, January 25, 2005 3:27 PM To: CF-Talk Subject: Re: Dynamic table tag? Dave, I haven't seen the one in Dreamweaver, is that an extension? On Tue, 25 Jan 2005 15:20:49 -0500, dave wrote: > like the one thats in dreamweaver? > > > From: Stas Newdel > Sent: Tuesday, January 25, 2005 1:57 PM > To: CF-Talk > Subject: Dynamic table tag? > > Hello, > > I am searching for a dynamic table tag, commercial or not, if there is > such a beast. This would aid in generating tables with static headers > and scrolling data rows. ~| 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:191725 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: cfqueryparam help
sorry it posted a bunch of times. I only clicked once so I don't know why it did it, but sorry anyway. Hope this doesn't reply 5 times. ~| 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:191724 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: Dynamic table tag?
This sounds like what you're after: http://webfx.eae.net/dhtml/collist/columnlist.html The demo: http://webfx.eae.net/dhtml/collist/demo.html -Original Message- From: Stas Newdel [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 11:56 AM To: CF-Talk Subject: Dynamic table tag? Hello, I am searching for a dynamic table tag, commercial or not, if there is such a beast. This would aid in generating tables with static headers and scrolling data rows. Thank you! ~| 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:191722 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: Dynamic table tag?
Dave, I haven't seen the one in Dreamweaver, is that an extension? On Tue, 25 Jan 2005 15:20:49 -0500, dave <[EMAIL PROTECTED]> wrote: > like the one thats in dreamweaver? > > > From: Stas Newdel <[EMAIL PROTECTED]> > Sent: Tuesday, January 25, 2005 1:57 PM > To: CF-Talk > Subject: Dynamic table tag? > > Hello, > > I am searching for a dynamic table tag, commercial or not, if there is > such a beast. This would aid in generating tables with static headers > and scrolling data rows. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191723 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
cfqueryparam help
I have a WHERE statement that I'm building, but I am having trouble adding
cfqueryparam to the agency field. This is Oracle and the agency field is a
varchar2(100). While I've simplified the query for the posting, it gives
displays the problem.
SELECT *
FROM internships
WHERE 1=1
AND UPPER(agency) like UPPER('%%')
AND r >= AND
r <=
This works if I use the commented out agency line. If I use the agency line
with CFQueryParam it gives an error, "Invalid Parameter Bindings" on the
following cfQueryParams (the last ones). If I use the commented-out agency
line, it gives no error.
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:191721
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: Dynamic table tag?
like the one thats in dreamweaver? From: Stas Newdel <[EMAIL PROTECTED]> Sent: Tuesday, January 25, 2005 1:57 PM To: CF-Talk Subject: Dynamic table tag? Hello, I am searching for a dynamic table tag, commercial or not, if there is such a beast. This would aid in generating tables with static headers and scrolling data rows. Thank you! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191720 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
Well, you have contradictions in your SQL: WHERE atty_id <> 8787445854777 , indictes atty_id is numeric (no quotes) yet the valuelist for atty_id is enclosed in quotes. It can't be both ways. >> 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191719 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: Oracle Date Field
You can use CreateODBCDate() functions to pass dates to Oracle. Oracle says CreateODBCDateTime() formats are supported too, but on some jdbc drivers it chokes. >http://www.macromedia.com/devnet/server_archive/articles/cf_best_practices_o >racle.html >http://www.macromedia.com/devnet/server_archive/articles/cfqueryparam_oracle >_databases.html > > >-Original Message- >From: ColdFusion Developer [mailto:[EMAIL PROTECTED] >Sent: Tuesday, 25 January 2005 6:54 >To: CF-Talk >Subject: Re: Oracle Date Field > >Thanks, like I said, been a long time since I used it. >By chance any website you may have I can reference for more questions like >this? > >Thanks again! > >James Holmes wrote: ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191718 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
Quick question, do the non-datadirect drivers support the return of Ref Cursors as a coldFusion query? -Adam On Wed, 26 Jan 2005 01:13:56 +0700, Paul Hastings <[EMAIL PROTECTED]> wrote: > Robert Everland III wrote: > > I would like to see the test you ran to see why are test vary so > > significantly. Were you using the latest Microsoft JDBC drivers? I am using > > the latest of every driver in this test. > > yes the very latest drivers were used (though again, mm has an even > newer driver as a fix for the problem that started this whole thing for > me). test table had 50k rows (if i recall, i'm at home right now). > select, update & delete queries were run (as well as some SP stuff but > weren't timed). cf was set to not save class files, both cf & sql > servers were stopped & restarted between runs. if i recall correctly, 1k > loops (or it might have been 10k) were run 5 times & the times averaged. > as i said it took hours. > > i've also been told by MM staff that their own tests showed datadirect > to be faster than ms. > > ~| 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:191717 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
Sessions being show to wrong users?
Hello, I have a login script on my site. It sets up a small series of session variables. I am running CF 5, patched, on a very new server, with ample memory and CPU. The server is hardly loaded, according to stats. This script was written about two years ago, and has not changed. Session information is stored in session variables. Very recently, a few visitors to my site arrive at the site and appear to be logged in as other member's of the site. Some of them may not even log in. I have restarted the cold fusion service. This problem still persists. It appears that session variables are bleeding across to other sessions on the site. I have started doing logging based on IP when initially logged in, and the IP as they browse from page to page. I have found in a few instances, the IP from the login, and the IP accessed via cgi aren't even from the same subnet. These are always the sessions that have the wrong information. Has anyone seen this problem? Thank you - ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191716 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: PHP equivalent of cfhtmlhead
Using cfhtmlhead, you can dynamically add references to other stylesheets or scripts that you don't normally want to clutter your page with. Since it does the addition of these references to the head section of the html before the html page is sent to the browser, it is of great help. George ~| 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:191715 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
Dynamic table tag?
Hello, I am searching for a dynamic table tag, commercial or not, if there is such a beast. This would aid in generating tables with static headers and scrolling data rows. Thank you! ~| 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:191714 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.
virtual directories respond to HTTP calls, in other words calls to
IIS. Mappings are used by CF only. If you want a CF mapping to be
available via HTTP, you have to create a virtual dir.
Doug
On Tue, 25 Jan 2005 11:57:14 -0500, DURETTE, STEVEN J (AIT)
<[EMAIL PROTECTED]> wrote:
> Ok, I did some testing and found out that while the cfc does work, you
> can't get information from it like you would if you by doing something
> like http://localserver/mycfcdir/mycfc.cfc
>
> I'm thinking about seeing what happens when you have both a virtual
> directory in iis and a mapping in ColdFusion. Which would win out.
> Would it still work.
>
> Later,
> Steve
>
>
> -Original Message-
> From: John Beynon [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 25, 2005 6:55 AM
> To: CF-Talk
> Subject: Re: CFCs and virtual directories.
>
>
> yes that will work...of course, if you had a folder named siteModel off
> the webroot it would work too, provided your '/' cfmapping goes to the
> web root
>
> jb.
>
> > OK. So let's say i have a mapping in cf administrator called
> > /siteModel. I should be be able to invoke a cfc by either
> >
> >
> >
> > or
> >
> > createObject("component","siteModel.myCFC")
> >
> > ?
> >
> > Dwayne
> >
> > -- Original Message --
> > From: "Jared Rypka-Hauer - CMG, LLC" <[EMAIL PROTECTED]>
> > Reply-To: cf-talk@houseoffusion.com
> > Date: Tue, 25 Jan 2005 01:54:55 -0600
> >
> > >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 (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191713
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: ActiveSync \ PDA \ Subscribing to content on my site
To clarify, I realize that I can dynamically generate the csv file in question on a schedule and plant the result in a given directory that I KNOW all of the users sync with, but is this the best way? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191712 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
CFC newbie: trying the calendar API, getting error
Greetings everyone.
I'm trying out the calendar API
(http://www.horwith.com/index.cfm?mode=entry&entry=C8837FD9-E081-0478-47
F93823F4029950) and obviously have the directory structure messed up
somehow as it isn't working. I've set it up where all of the files are
under the site root and get this error:
Could not find the ColdFusion Component calendar.cfc.calendar.
Please check that the given name is correct and that the component
exists.
The error occurred in
C:\Inetpub\wwwroot\secure3_spnvision_com\calendar\sample\Application.cfm
: line 23
21 :// set this to the path to your component
22 :request.useScope.calendarCFCPath =
"calendar.cfc.calendar";
23 :request.useScope.objCalendar = createObject("component",
request.useScope.calendarCFCPath);
24 :request.useScope.objCalendar.init(now(), true);
25 :request.useScope.objCalendar.setWeekStart(1);
Anyone care to help me set this up? Thanks.
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include
~|
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:191707
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: ColdFusion 5 RDS & Visual Source Safe
We use this configuration regulary and it works fine for us so I reckon it must be your DWMX config. Does RDS work through the browser? On Tue, 25 Jan 2005 12:31:27 -0400, Rob Sherman <[EMAIL PROTECTED]> wrote: > Hi Calvin, > Thanks for the suggestion. It's been tried and with the same results. I > suspect it has something to do with the use of Visual Source Safe as the > remote portion of the site settings. > > - Rob > > >Assign a password in RDS and then see if that works through DWMX? > > > >- Calvin > > > > ~| 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:191710 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
ActiveSync \ PDA \ Subscribing to content on my site
I am running on an INTRANET, and am interested in allowing our internal PDA users to 'subscribe' to a file on my site (a csv file), and have it download each time they sync their PDA, just like the way ActiveSync works for Yahoo content, etc. Can anyone point me in the right direction, or am I asking too much? 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:191711 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
Linkpoint & CF
Does anyone use LinkPoint/Card Services as a merchant provider and has Uplinkearth as a hosting provider? I have a few questions regarding the files provided from Linkpoint to use. Please contact me off the list if you do. 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:191709 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
Robert Everland III wrote: > I would like to see the test you ran to see why are test vary so > significantly. Were you using the latest Microsoft JDBC drivers? I am using > the latest of every driver in this test. yes the very latest drivers were used (though again, mm has an even newer driver as a fix for the problem that started this whole thing for me). test table had 50k rows (if i recall, i'm at home right now). select, update & delete queries were run (as well as some SP stuff but weren't timed). cf was set to not save class files, both cf & sql servers were stopped & restarted between runs. if i recall correctly, 1k loops (or it might have been 10k) were run 5 times & the times averaged. as i said it took hours. i've also been told by MM staff that their own tests showed datadirect to be faster than ms. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191708 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??
Deanna The correct date is 2/25/05. We are in the middle of moving the site to its own domain and forgot to update the date. Sorry about that We plan to have the hotel code up next week too. - Michael Smith, TeraTech, Inc http://www.teratech.com/ Deanna Schneider wrote: >Hey Michael, >You do know that you have two different early early bird deadlines listed - >one of which is Monday. I'm assuming that's the incorrect one, since there's >no hotel information or anything yet. > >- Original Message - >From: "Michael Smith" <[EMAIL PROTECTED]> >To: "CF-Talk" >Sent: Monday, January 24, 2005 9:07 PM >Subject: 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 >> >> >> >> > > > ~| 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:191706 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: ColdFusion 5 RDS & Visual Source Safe
Hi Calvin, Thanks for the suggestion. It's been tried and with the same results. I suspect it has something to do with the use of Visual Source Safe as the remote portion of the site settings. - Rob >Assign a password in RDS and then see if that works through DWMX? > >- Calvin > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191705 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: PHP equivalent of cfhtmlhead
Well, I don't think they'll validate, if they're outside the head, if that's a concern. - Original Message - From: "Rick Root" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, January 25, 2005 11:15 AM Subject: Re: OT: PHP equivalent of cfhtmlhead > Deanna Schneider wrote: >> I use it a lot for things like adding local styles to the head of a page. >> Or >> a local js function or something. > > Are there any browsers out there that ignore javascript and stylesheet > information placed outside the head section? > > I guess i've never felt any pressing need to do that... > > - Rick > > > ~| 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:191704 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: PHP equivalent of cfhtmlhead
Deanna Schneider wrote: > I use it a lot for things like adding local styles to the head of a page. Or > a local js function or something. Are there any browsers out there that ignore javascript and stylesheet information placed outside the head section? I guess i've never felt any pressing need to do that... - Rick ~| 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:191703 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??
Could we possibly move this to CF-Community as airfare isn't really CF related any more? Thanks, .pjf ~| 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:191702 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: PHP equivalent of cfhtmlhead
I use it a lot for things like adding local styles to the head of a page. Or a local js function or something. > There is no equivalent that I can think of. I've never used > either... seems like a pretty useless tag to me. > > - Rick > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191701 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.
Ok, I did some testing and found out that while the cfc does work, you
can't get information from it like you would if you by doing something
like http://localserver/mycfcdir/mycfc.cfc
I'm thinking about seeing what happens when you have both a virtual
directory in iis and a mapping in ColdFusion. Which would win out.
Would it still work.
Later,
Steve
-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 6:55 AM
To: CF-Talk
Subject: Re: CFCs and virtual directories.
yes that will work...of course, if you had a folder named siteModel off
the webroot it would work too, provided your '/' cfmapping goes to the
web root
jb.
> OK. So let's say i have a mapping in cf administrator called
> /siteModel. I should be be able to invoke a cfc by either
>
>
>
> or
>
> createObject("component","siteModel.myCFC")
>
> ?
>
> Dwayne
>
> -- Original Message --
> From: "Jared Rypka-Hauer - CMG, LLC" <[EMAIL PROTECTED]>
> Reply-To: cf-talk@houseoffusion.com
> Date: Tue, 25 Jan 2005 01:54:55 -0600
>
> >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
> >
>
~|
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:191700
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
Thanks Phil. I'd seen the devx article. One thing I noticed in it was these statements about admin requirements: "Larger relational DBMS, such as MySQL and Postgres are available today in open-source form. [snip] they require substantially greater levels of administrative oversight" "As to full commercial databases such as Oracle, DB2, SQL Server, and Informix, of course, they require significantly more administration" I've worked quite a bit with SQL Server, and while it's clearly more expensive, especially web licensing, and not small footprint, our admin load has been roughly zero, other than backup. Data file about 800M and growing, but not intense throughput, and it's been doing just fine. Is it other folks' impression that recent versions of SQL Server do generally need a lot of dba? How about MySQL? The article is clearly implying that Cloudscape doesn't; is that your impression? That's an important point for both developers and their clients. Dave Merrill > >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? > > > > With Tracking-Tools, I offer it as one of the the supported > database options (MSSQL, MYSQL, Oracle, and Cloudscape/Derby). It > works fine for my needs. For further info on how it stacks up to > other database options check the FAQs at > http://philcruz.com/cfeverywhere/ > > > >What's the best way to hook CF up to it? > > > > That's Part 2 of the CFEverywhere article series. It's coming soon... > > -Phil ~| 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:191699 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: PHP equivalent of cfhtmlhead
George Abraham wrote: > OK, > This is the only place I know where I might get an answer to this > question. What is the PHP equivalent of using cfhtmlhead to insert > stylesheet or javascript information before an HTML file is sent to > the browser? There is no equivalent that I can think of. I've never used either... seems like a pretty useless tag to me. - Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191698 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: PHP equivalent of cfhtmlhead
I dont think there is one, only includes and what have you Regards Mark Drew On Tue, 25 Jan 2005 11:29:39 -0500, George Abraham <[EMAIL PROTECTED]> wrote: > OK, > This is the only place I know where I might get an answer to this > question. What is the PHP equivalent of using cfhtmlhead to insert > stylesheet or javascript information before an HTML file is sent to > the browser? > > Thanks, > George > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191697 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: PHP equivalent of cfhtmlhead
OK, This is the only place I know where I might get an answer to this question. What is the PHP equivalent of using cfhtmlhead to insert stylesheet or javascript information before an HTML file is sent to the browser? Thanks, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191696 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
>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? > With Tracking-Tools, I offer it as one of the the supported database options (MSSQL, MYSQL, Oracle, and Cloudscape/Derby). It works fine for my needs. For further info on how it stacks up to other database options check the FAQs at http://philcruz.com/cfeverywhere/ >What's the best way to hook CF up to it? > That's Part 2 of the CFEverywhere article series. It's coming soon... -Phil ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191695 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: ODBC Hangs
> Can anyone help with this?? > > 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 Maybe: http://support.microsoft.com/default.aspx?scid=kb;en-us;139655 ~| 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:191694 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
Ok here is some quick testing I ran on the different datasources to compare speeds, I wanted to do it as quick as possible, before the thread dies off. I didn't really care which one won, I just want the fastest possible drivers. No settings have been changed. Classes were deleted after each test and server was restarted. Here is what the code I used looks like. Select userid From Users There are 606 records in this database 1. JTDS : 29891 ms 2. Datadirect : 20969 ms 3. Microsoft JDBC : 24000 ms Now I ran the exact same thing again, in reverse to see if restarting the server made a difference. 1. Microsoft JDBC : 16890 ms 2. Datadirect : 18672 ms 3. JTDS : 28922 ms (I refreshed the page 3 times and couldn't get it to go below this number, I have caching turned on) I would like to see the test you ran to see why are test vary so significantly. Were you using the latest Microsoft JDBC drivers? I am using the latest of every driver in this test. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191693 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: Scheduled Event
Hi Lee,
You can download a version of wget for windows (wget.exe) from
Gnuwin32.sourceforge.net and then use your system's "at" command to get
the page:
1) install wget
2) add the location of wget to the PATH.
3) make sure the Task Scheduler service is running
4) at the command prompt type:
at 16:30 /EVERY:TUESDAY "wget http://www.example.com/path/to/script.cfm
--append-output=wgetlog.txt"
check the docco for at ("help at") and wget ("wget -h") for more
options.
/t
>-Original Message-
>From: Lee [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, January 25, 2005 4:12 PM
>To: CF-Talk
>Subject: Re: Scheduled Event
>
>I've never used the cfschedule tag and just examined the
>documentation. What I'm trying to do is send an email with
>data once a week indefinately which could easily be set up
>with CF administration scheduler which I cannot get to.
>Cron looks like a unix tool. Can you launch an external
>web page using Windows Scheduled Tasks?
>
>
>On Mon, 24 Jan 2005 16:01:58 -0800
> Jordan Michaels <[EMAIL PROTECTED]> wrote:
>> -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 (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191692
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
Eric, You can find total payments made against orders in a specific date range that contain a specific part number by doing something like this: select sum(p.pmt) as order_pmts, i.part_number, o.order_number, o.order_date, o.order_total from orders o inner join order_items i on o.order_id = i.order_id inner join payments on o.order_id = p.order_id where o.order_date between and and i.part_number = group by o.order_date, i.part_number, o.order_total, o.order_number order by o.order_date If you need to find payments for orders with multiple part numbers, you can rewrite the part number filter to: and i.part_number in () This is not tested and is not database-specific since you didn't mention what DBMS you are using, but it should get you started in the right direction. Dina - Original Message - From: "Eric Hoffman" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, January 24, 2005 10:43 AM Subject: 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 > > > > > > > > ~| 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:191691 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
I've never used the cfschedule tag and just examined the documentation. What I'm trying to do is send an email with data once a week indefinately which could easily be set up with CF administration scheduler which I cannot get to. Cron looks like a unix tool. Can you launch an external web page using Windows Scheduled Tasks? On Mon, 24 Jan 2005 16:01:58 -0800 Jordan Michaels <[EMAIL PROTECTED]> wrote: > -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 (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191690 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?
Thanks to all. -- ___ 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:191689 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??
Hey Michael, You do know that you have two different early early bird deadlines listed - one of which is Monday. I'm assuming that's the incorrect one, since there's no hotel information or anything yet. - Original Message - From: "Michael Smith" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, January 24, 2005 9:07 PM Subject: 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 > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191688 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: problem solved
Credit goes back to Jochem. He's the one that helped me figure it out. - Original Message - From: "Claude Schneegans" <[EMAIL PROTECTED]> > Thanks all for your help, especially Deanna. > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191687 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.
yes that will work...of course, if you had a folder named siteModel off the
webroot it would work too, provided your '/' cfmapping goes to the web root
jb.
> OK. So let's say i have a mapping in cf administrator called
> /siteModel. I should be be able to invoke a cfc by either
>
>
>
> or
>
> createObject("component","siteModel.myCFC")
>
> ?
>
> Dwayne
>
> -- Original Message --
> From: "Jared Rypka-Hauer - CMG, LLC" <[EMAIL PROTECTED]>
> Reply-To: cf-talk@houseoffusion.com
> Date: Tue, 25 Jan 2005 01:54:55 -0600
>
> >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 (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191686
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??
I looked on Expedia the other night, a return flight was going to cost about £700!! Probably down to being right at the start of the summer holidays - i flew to Washington for a weekend in Sept and it cost me £200!! jb. >Cool - I'll do some investigating. > >Martin Parry >Macromedia Certified Developer >http://www.BeetrootStreet.co.uk > >-Original Message- >From: Greg Luce [mailto:[EMAIL PROTECTED] >Sent: 25 January 2005 12:30 >To: CF-Talk >Subject: Re: CFUNITED? What's the deal?? > >I just flew to Heathrow (plus a connection to Warsaw) in October for >$700 on British Airways. I've seen better deals than that with more >notice. > >Greg ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191685 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
Matt Knight wrote: > > 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. The client application has to maintain the session ID somehow. If not through cookies, then you have to attach the session ID to every URL. Without cookies though, it's a huge pain in the butt. - Rick ~| 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:191684 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??
Cool - I'll do some investigating. Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.co.uk -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: 25 January 2005 12:30 To: CF-Talk Subject: Re: CFUNITED? What's the deal?? I just flew to Heathrow (plus a connection to Warsaw) in October for $700 on British Airways. I've seen better deals than that with more notice. Greg ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191683 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
Barney Boisvert wrote: > 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. This is exactly what I do. I store the sessionID and userID in a database table, so when they authenticate using the sessionID, I take the userID associated, and verify that it's still a valid user... that way if a user gets deleted while they are currently in session, then their session automatically becomes invalid as well. - Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191682 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??
I just flew to Heathrow (plus a connection to Warsaw) in October for $700 on British Airways. I've seen better deals than that with more notice. Greg On Tue, 25 Jan 2005 09:43:05 -, Martin Parry <[EMAIL PROTECTED]> wrote: > Hey, I second that ;) - You're looking at about $1500-2000 at least, on > top of the spend for the day. > > However, I'm really quite keen to go.. Should be a gas. > > Martin Parry > Macromedia Certified Developer > http://www.BeetrootStreet.co.uk > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: 25 January 2005 09:51 > To: CF-Talk > Subject: RE: CFUNITED? What's the deal?? > > Although I attended CFUN last year (and it was definitely value for > money), > lets not forget, for those of us living in England, the price of the > flight > etc. also needs to be factored in to the overall price of attending > (unless > of course we get a discount :) ) > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191681 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 and Cloudscape/Derby
same here althought I had a little play with cloudscape, it looks like you need to create some sort of object that will start the connection. That article rocks. I must say that I have achieved the same portable environment with CFMX 7 , but I know you could do it from CFMX 6.1 simply by using tomcat and adding the application as a WAR. Wonder if it is too simple to explain? or should I write an article about it too? MD On Tue, 25 Jan 2005 09:39:04 -0200, Marco Antonio C. Santos <[EMAIL PROTECTED]> wrote: > Hi Dave. Not. Yet!!! I'm waiting the 2nd part of Phil Cruz and Dick > Applebaum article... ;-) > > Cheers > > Marco > > > On Tue, 25 Jan 2005 05:55:54 -0500, Dave Merrill <[EMAIL PROTECTED]> wrote: > > Marco, do you have any experience using Cloudscape? With CF? If so, any > > comments on performance, features, stability? Setup hints for connecting w > > CFMX61? > > > > Thanks, > > > > Dave Merrill > > > > > > > Portable? Or Embeddable? Postgre(30MB RAM space) and MySQL(50MB RAM > > > space) may be Portable but Cloudscape(2MB RAM space), HSQLDB, etc are > > > a good option for embeddable apps. And yes we're using PG for big apps > > > and MySQL for smaller... PG is very very nice... > > > > > > Cheers > > > > > > Marco > > > > > > > > > On Mon, 24 Jan 2005 17:14:27 -0600, Chuck Mason wrote: > > > > 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. > > > > > > > > ~| 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:191680 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?
There is an article on how to do this in Coldfusion Developers Journal, vol 5(2003), issue 9. http://sys-con.com/coldfusion/article.cfm?id=647 It allows you to set-up everything through IIS and have virtual directories like "mx", "cf5" and "bd" which route the request through the appropriate CF version. These all point to the same set of files. I've set this up on a development server and it works extremely well. Gavin -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: 25 January 2005 11:33 To: CF-Talk Subject: RE: CF 5 and CFMX together on the same files? Effectively have two sites that point at the same directory, one site uses CF 5, and one site uses CFMX. - Calvin -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 8:18 PM To: CF-Talk Subject: 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 (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191679 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 and Cloudscape/Derby
Hi Dave. Not. Yet!!! I'm waiting the 2nd part of Phil Cruz and Dick Applebaum article... ;-) Cheers Marco On Tue, 25 Jan 2005 05:55:54 -0500, Dave Merrill <[EMAIL PROTECTED]> wrote: > Marco, do you have any experience using Cloudscape? With CF? If so, any > comments on performance, features, stability? Setup hints for connecting w > CFMX61? > > Thanks, > > Dave Merrill > > > > Portable? Or Embeddable? Postgre(30MB RAM space) and MySQL(50MB RAM > > space) may be Portable but Cloudscape(2MB RAM space), HSQLDB, etc are > > a good option for embeddable apps. And yes we're using PG for big apps > > and MySQL for smaller... PG is very very nice... > > > > Cheers > > > > Marco > > > > > > On Mon, 24 Jan 2005 17:14:27 -0600, Chuck Mason wrote: > > > 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. > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191678 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
I set this up this week (Postgres) with MX Wasnt too much of a problem, I downloaded the driver from: http://jdbc.postgresql.org/ Under the JVM settings I added the path to the driver: C:\drivers\postgresql-8.0.309.jdbc2.jar, Then created a Datasource as follows: JDBC URL: jdbc:postgresql:/// Driver Class: org.postgresql.Driver username: password: And bingo, connected first time etc. Regards Mark Drew On Tue, 25 Jan 2005 05:55:54 -0500, Dave Merrill <[EMAIL PROTECTED]> wrote: > Marco, do you have any experience using Cloudscape? With CF? If so, any > comments on performance, features, stability? Setup hints for connecting w > CFMX61? > > Thanks, > > Dave Merrill > > > > Portable? Or Embeddable? Postgre(30MB RAM space) and MySQL(50MB RAM > > space) may be Portable but Cloudscape(2MB RAM space), HSQLDB, etc are > > a good option for embeddable apps. And yes we're using PG for big apps > > and MySQL for smaller... PG is very very nice... > > > > Cheers > > > > Marco > > > > > > On Mon, 24 Jan 2005 17:14:27 -0600, Chuck Mason wrote: > > > 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. > > > ~| 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:191677 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?
Effectively have two sites that point at the same directory, one site uses CF 5, and one site uses CFMX. - Calvin -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 8:18 PM To: CF-Talk Subject: 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 (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191676 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: ColdFusion 5 RDS & Visual Source Safe
Assign a password in RDS and then see if that works through DWMX? - Calvin -Original Message- From: Rob Sherman [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 7:04 PM To: CF-Talk Subject: 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191675 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
Can anyone help with this?? > 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191674 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: Oracle Date Field
The ORACLE docs site may help, the index you're after in this case is: http://www.oracle.com/pls/db92/db92.sql_keywords?letter=T&category=#index-TO ps assuming you're using 9i that is, the 8i & 10g docs are also there of course. On Tue, 25 Jan 2005 05:54:13 -0500, ColdFusion Developer <[EMAIL PROTECTED]> wrote: > Thanks, like I said, been a long time since I used it. > By chance any website you may have I can reference for more > questions like this? > > Thanks again! > > James Holmes wrote: > > >INSERT / UPDATE with to_date() > >SELECT with to_char() > > > >-Original Message- > >From: ColdFusion Developer [mailto:[EMAIL PROTECTED] > >Sent: Tuesday, 25 January 2005 6:48 > >To: CF-Talk > >Subject: Oracle Date Field > > > >Using a CF Query to add a record to Oracle, I havea date field to add When > >adding it, it is straightforward, right? > > > >When retrieving the date information, I need to do a To_Date function? > > > >Is that correct? > > > >Been a long time since I had to use Oracle. > > > > > > > > > > > > ~| 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:191673 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: Oracle Date Field
http://www.macromedia.com/devnet/server_archive/articles/cf_best_practices_o racle.html http://www.macromedia.com/devnet/server_archive/articles/cfqueryparam_oracle _databases.html -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 6:54 To: CF-Talk Subject: Re: Oracle Date Field Thanks, like I said, been a long time since I used it. By chance any website you may have I can reference for more questions like this? Thanks again! James Holmes wrote: >INSERT / UPDATE with to_date() >SELECT with to_char() > >-Original Message- >From: ColdFusion Developer [mailto:[EMAIL PROTECTED] >Sent: Tuesday, 25 January 2005 6:48 >To: CF-Talk >Subject: Oracle Date Field > >Using a CF Query to add a record to Oracle, I havea date field to add >When adding it, it is straightforward, right? > >When retrieving the date information, I need to do a To_Date function? > >Is that correct? > >Been a long time since I had to use Oracle. > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191672 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 and Cloudscape/Derby
Marco, do you have any experience using Cloudscape? With CF? If so, any comments on performance, features, stability? Setup hints for connecting w CFMX61? Thanks, Dave Merrill > Portable? Or Embeddable? Postgre(30MB RAM space) and MySQL(50MB RAM > space) may be Portable but Cloudscape(2MB RAM space), HSQLDB, etc are > a good option for embeddable apps. And yes we're using PG for big apps > and MySQL for smaller... PG is very very nice... > > Cheers > > Marco > > > On Mon, 24 Jan 2005 17:14:27 -0600, Chuck Mason wrote: > > 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. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191671 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: Oracle Date Field
Thanks, like I said, been a long time since I used it. By chance any website you may have I can reference for more questions like this? Thanks again! James Holmes wrote: >INSERT / UPDATE with to_date() >SELECT with to_char() > >-Original Message- >From: ColdFusion Developer [mailto:[EMAIL PROTECTED] >Sent: Tuesday, 25 January 2005 6:48 >To: CF-Talk >Subject: Oracle Date Field > >Using a CF Query to add a record to Oracle, I havea date field to add When >adding it, it is straightforward, right? > >When retrieving the date information, I need to do a To_Date function? > >Is that correct? > >Been a long time since I had to use Oracle. > > > > > ~| 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:191670 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: Oracle Date Field
TO_DATE is to add it (you also use it with the cfqueryparam and the cf_sql_type for datetime) TO_CHAR is to retrieve it in the format you want. > -Original Message- > From: ColdFusion Developer [mailto:[EMAIL PROTECTED] > Sent: 25 January 2005 11:48 > To: CF-Talk > Subject: Oracle Date Field > > Using a CF Query to add a record to Oracle, I havea date field to add > When adding it, it is straightforward, right? > > When retrieving the date information, I need to do a To_Date function? > > Is that correct? > > Been a long time since I had to use Oracle. > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191669 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: Oracle Date Field
INSERT / UPDATE with to_date() SELECT with to_char() -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 January 2005 6:48 To: CF-Talk Subject: Oracle Date Field Using a CF Query to add a record to Oracle, I havea date field to add When adding it, it is straightforward, right? When retrieving the date information, I need to do a To_Date function? Is that correct? Been a long time since I had to use Oracle. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191668 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
Oracle Date Field
Using a CF Query to add a record to Oracle, I havea date field to add When adding it, it is straightforward, right? When retrieving the date information, I need to do a To_Date function? Is that correct? Been a long time since I had to use Oracle. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191667 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 read this on "livedocs.macromedia.com" "If you invoke a CFC method remotely, using a specific URL, form field, Flash Remoting MX, or a web service invocation, ColdFusion looks in the specified path relative to the web root. For form fields and URLs specified directly on local web pages, ColdFusion also searches relative to the page directory" Does anyone know of any white papers or small books that provide nice examples and scenarios of when to invoke cfc's remotely? What are best practices of calling cfc's, when is it good to store cfc's in persistent scope variables (particularly server and application scope)etc. The chapters in most general and advanced books do a good job of introducing the use of CFC's, and the cfc book that I think Helms wrote is also good for discussing the OO thing, but I have yet to find any little books on specific cfc concepts. I thought Ben's Reality series would help but they (the one on flash and intranets) were a little to rich with dialog and role play (thanks Ben nevertheless). I like to see a book with diagrams, among other things, that illustrate how one cfc or a group of "system" of cfc's can work together to effectively and efficiently deliver reusability of code and functions to distributed, cross platform, cross medium, applications and websites. I would gladly pay $49.00 for such a book or even a collection of white papers that provide a good comprehensive view. In fact, I would be willing to submit comments about our efforts to leverage a system of function libraries, soon to be cfc's, to achieve useful decoupling and reusability. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191666 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 and Cloudscape/Derby
Hi Chuck Portable? Or Embeddable? Postgre(30MB RAM space) and MySQL(50MB RAM space) may be Portable but Cloudscape(2MB RAM space), HSQLDB, etc are a good option for embeddable apps. And yes we're using PG for big apps and MySQL for smaller... PG is very very nice... Cheers Marco On Mon, 24 Jan 2005 17:14:27 -0600, Chuck Mason <[EMAIL PROTECTED]> wrote: > 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 > > > > > > ~| 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:191664 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.
OK. So let's say i have a mapping in cf administrator called /siteModel. I
should be be able to invoke a cfc by either
or
createObject("component","siteModel.myCFC")
?
Dwayne
-- Original Message --
From: "Jared Rypka-Hauer - CMG, LLC" <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date: Tue, 25 Jan 2005 01:54:55 -0600
>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 (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191665
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??
Hey, I second that ;) - You're looking at about $1500-2000 at least, on top of the spend for the day. However, I'm really quite keen to go.. Should be a gas. Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.co.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 January 2005 09:51 To: CF-Talk Subject: RE: CFUNITED? What's the deal?? Although I attended CFUN last year (and it was definitely value for money), lets not forget, for those of us living in England, the price of the flight etc. also needs to be factored in to the overall price of attending (unless of course we get a discount :) ) ~| 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:191663 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
> > comparative testing of these aspects as well as performance, or do you know > > of any such testing that's been done? > > nope. are you volunteering? Well... we'll start by trying it out in a couple of apps & if we find out anything interesting will post it. Thanks Nick ~| 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:191662 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??
Although I attended CFUN last year (and it was definitely value for money), lets not forget, for those of us living in England, the price of the flight etc. also needs to be factored in to the overall price of attending (unless of course we get a discount :) ) Kola -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: 25 January 2005 07:47 To: CF-Talk Subject: 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 ~| 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:191661 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
Nick de Voil wrote: > 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 functionality is pretty much what you'd get from the other two drivers (except the datadirect driver that ships w/6.1 has a bug with unicode data in stored procedure OUTPUT vars, you can contact MM for updated drivers if this is an issue, neither ms or jTDS showed that issue which was why we tested jTDS actually). we didn't do any specific stability test but the speed tests were high load & ran for a couple of hours. nothing bad happened. we did inadvertently put the driver through some very minor sustained loading (forgot to swap it out & it was left & used on a development box for about 5 days or so). it is used in a couple of other products they've listed on their site. beyond that, no idea about its suitability for production. > comparative testing of these aspects as well as performance, or do you know > of any such testing that's been done? nope. are you volunteering? i recall that pete freitag blogged about this before: http://www.petefreitag.com/item/178.cfm maybe he's done some real load testing? ~| 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:191660 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
