Re: Cold Fusion MX Reference Manual
Do you mean when you register ColdFusion MX the server or Macromedia Studio MX? Mitko Gerensky-Greene Make no search for water. But find thirst, And water from the very ground will burst. (A Persian mystic poet, quoted in Delight of Hearts, p. 77) The world is but one country and mankind its citizens Baha'i Faith http://www.us.bahai.org * - Original Message - From: Sam Farmer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 3:22 PM Subject: Re: Cold Fusion MX Reference Manual When you register CFMX MM will also offer to send you copies for free. Within the administrator is a link to the registration site. Did the above today. But the books haven't arrived yet.. Cheers, Sam - Original Message - From: Houk, Gary [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 2:43 PM Subject: RE: Cold Fusion MX Reference Manual Um.in case you_didn't_look, the document is 758 pages. Our printers often hang up, so sometimes printing a 20 page document is a challenge. The main reason for having the hardcopy is that I don't like to go through huge manuals online. I'd rather deal with the book (that USED to come with CF for free!). Thanks for the online store link guys. - Gary -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:41 PM To: CF-Talk Subject: RE: Cold Fusion MX Reference Manual Uh, so, download the .pdf and print it out? ... ? *looks confused* or.. download the CFStudio 5 help updaters and use it locally or ... if you're using DWMX, goto Help-Using ColdFusion and it's all there. ~Todd On Thu, 8 Aug 2002, Houk, Gary wrote: That's really a shame that you now have to purchase the language reference by buying ALL of the other manuals! I wonder why they decided to discontinue sending it out? Oh well, looks like it is time for an online purchase. - gary -Original Message- From: Vernon Viehe [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:25 PM To: CF-Talk Subject: RE: Cold Fusion MX Reference Manual Yes, you can. One way to purchase them is to go to the Macromedia Online store: http://dynamic.macromedia.com/bin/MM/store/US/product.jsp Click on the nav button for Books Training. On that page, you'll find ColdFusion documentation near the bottom of the page. Vernon Viehe ColdFusion Community Manager Developer Relations Macromedia, Inc. Online diary: http://vvmx.blogspot.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 11:25 AM To: CF-Talk Subject: Re: Cold Fusion MX Reference Manual You can purchase the manuals I believe. On Thu, 8 Aug 2002, Houk, Gary wrote: Hi everyone, CF used to come with a nice CFML reference manual with a complete listing of all the CF tags and functions. The documentation that I received with MX is less than 1/2 of what I received when I upgraded to CF 5. Is this the norm? Is there a CFMX reference manual available (other than the pdf)? - Gary -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Browser losing data with back button
Hi. I have a multi-page user registration system that handles this in a complicated, but clean way. I'll describe the whole thing: reg_init.cfm - Sets a series of Session variables corresponding to the form fields on all registration pages, e.g., Session.frmFirstName, Session.frmPhoneNumber, etc. Creates another series of session variables that are error indicators, named as field name followed by _ERR, e.g., Session.frmFirstName_ERR, etc. All values are set to zero-length strings or default values. This allows future pages to count on them no matter where the user is in the process, which accounts for strange paths through the multi-form wizard. reg1.cfm - The first form page in the registration process. Pulls values from Session variables (created in reg_init) into local variables, and plugs those values into the appropriate form fields. Next to each form field is a little red X image that is displayed IF the field_ERR variable is not . Since field_ERR will be filled with the error text (see next page, reg1_action.cfm), a JavaScript routine is also set there so that clicking on the red X shows the error message for that particular field. On submission, this page runs a series of simple JavaScript checks, leaving the more complicated validation for the next page. reg1_action.cfm - Does the heavy-duty form validation. If a value fails a test, its corresponding _ERR variable gets set to a message. Form variables are written to corresponding session variables for future use. At the end of this template, if a toggle variable shows that one or more variables failed validation, the user is bounced back to reg1.cfm. If the variables are all okay, the user is sent forward to reg2.cfm. The next registration pages are all the same, where they occur in pairs (reg2, reg2_action, etc.) The final page re-validates everything (yes, I know, I'm paranoid), pulls the session variables into local variables, kills the session variables, writes the entire record to the database, and goes to a congrats! page. I designed it this way based on the idea that every page should work right no matter what the preceding page is. Whether you are coming forward or backward through the wizard or getting bounced back because of an error, you still get the right results. If you set up your app like this, when the user selects something from the notes window, it should get saved in a session variable (by the _action page) and then pre-selected on the form page when it gets bounced back. Hope this helps. If you want me to explain any part of this, please let me know. Matthieu -Original Message- From: jgeorges [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:52 PM To: CF-Talk Subject: RE: Browser losing data with back button Tony, Thanks for your response. The first page contains a lot of data that is pulled in from a number of datasourses. The validation is somewhat complicated. I have used your suggestion on simpler pages. I was hoping there was a simpler solution. Sam --- On Thu 08/08, Tony Carcieri wrote: From: Tony Carcieri [mailto: [EMAIL PROTECTED]] To: [EMAIL PROTECTED] Date: Thu, 8 Aug 2002 14:36:47 -0400 Subject: RE: Browser losing data with back button have something like: onSubmit=return verify(this) and in your head: function verify(){ // Initialize field values error = false; ErrorMessage = 'Please correct the following errors...\n\n'; //Validate First Name if(document.form1.FirstName.value.length ErrorMessage = ErrorMessage + 'First Name is required. \n'; error = true } //Validate Last Name if(document.form1.LastName.value.length ErrorMessage = ErrorMessage + 'Last Name is required. \n'; error = true } } -Original Message- From: jgeorges [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:27 PM To: CF-Talk Subject: OT: Browser losing data with back button I have a form when submitted goes to a validation page. If there are errors, the errors are listed followed by a button that goes back to the form using JavaScript:history.go(-1);return true;. On the form one of the text boxes can be filled from a pop-up window. If the pop-up window is used and there are errors listed on the validation page, when the user clicks the back button in the browser (IE5.5) or clicks the button provided, the form loses all data entered or changed. If the pop-up is not used, all data entered or changed is preserved. This problem does not occur using Netscape. Is ther a fix for IE? Any help would be appreciated. Thanks, Sam Can a Web portal forever change your life? Win up to $25 Million on iWon - click here! __ Your ad could be here. Monies from ads go to support these lists and provide
Re: Cold Fusion MX Reference Manual
I'm pretty sure he means CFMX the server, Studio comes with it's own book. ~Todd On Thu, 8 Aug 2002, Mitko Gerensky-Greene wrote: Do you mean when you register ColdFusion MX the server or Macromedia Studio MX? Mitko Gerensky-Greene Make no search for water. But find thirst, And water from the very ground will burst. (A Persian mystic poet, quoted in Delight of Hearts, p. 77) The world is but one country and mankind its citizens Baha'i Faith http://www.us.bahai.org * - Original Message - From: Sam Farmer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 3:22 PM Subject: Re: Cold Fusion MX Reference Manual When you register CFMX MM will also offer to send you copies for free. Within the administrator is a link to the registration site. Did the above today. But the books haven't arrived yet.. Cheers, Sam - Original Message - From: Houk, Gary [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 2:43 PM Subject: RE: Cold Fusion MX Reference Manual Um.in case you_didn't_look, the document is 758 pages. Our printers often hang up, so sometimes printing a 20 page document is a challenge. The main reason for having the hardcopy is that I don't like to go through huge manuals online. I'd rather deal with the book (that USED to come with CF for free!). Thanks for the online store link guys. - Gary -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:41 PM To: CF-Talk Subject: RE: Cold Fusion MX Reference Manual Uh, so, download the .pdf and print it out? ... ? *looks confused* or.. download the CFStudio 5 help updaters and use it locally or ... if you're using DWMX, goto Help-Using ColdFusion and it's all there. ~Todd On Thu, 8 Aug 2002, Houk, Gary wrote: That's really a shame that you now have to purchase the language reference by buying ALL of the other manuals! I wonder why they decided to discontinue sending it out? Oh well, looks like it is time for an online purchase. - gary -Original Message- From: Vernon Viehe [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:25 PM To: CF-Talk Subject: RE: Cold Fusion MX Reference Manual Yes, you can. One way to purchase them is to go to the Macromedia Online store: http://dynamic.macromedia.com/bin/MM/store/US/product.jsp Click on the nav button for Books Training. On that page, you'll find ColdFusion documentation near the bottom of the page. Vernon Viehe ColdFusion Community Manager Developer Relations Macromedia, Inc. Online diary: http://vvmx.blogspot.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 11:25 AM To: CF-Talk Subject: Re: Cold Fusion MX Reference Manual You can purchase the manuals I believe. On Thu, 8 Aug 2002, Houk, Gary wrote: Hi everyone, CF used to come with a nice CFML reference manual with a complete listing of all the CF tags and functions. The documentation that I received with MX is less than 1/2 of what I received when I upgraded to CF 5. Is this the norm? Is there a CFMX reference manual available (other than the pdf)? - Gary -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Partially Masking a Variable?
Thanks Al, you have saved me alot of time and head scratching. Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:21 PM To: CF-Talk Subject: RE: Partially Masking a Variable? We show the last four digits and replace the rest with Xs. cfscript rawcardnumber=4111; leftMask=RepeatString(X,Len(rawcardnumber)-4); rightMask=Right(rawcardnumber,4); cardnumber=Variables.leftMask Variables.rightMask; /cfscript -Original Message- From: Paul [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:34 PM To: CF-Talk Subject: Partially Masking a Variable? I am outputting a credit card #, but for security puroposes I would like to be able to mask/hide the last 4 or so digits of the number. Any ideas as to how to go about this? Thanks -Paul __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfhttp Connection Failure
I pass a user name and password to a password protected page and get Connection Failure using cfhttp. what causes this. JT __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfhttp
on the cfhttp tag for username and password.. is it wanting a system pasword or a username and password to login to a cold fusion tag? JT __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfhttp Connection Failure
Not sure if this will do it, but check that you're passing in the entire URL of the page you're trying to pass to - e.g., http://www.mysite.com/page.cfm -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:57 PM To: CF-Talk Subject: cfhttp Connection Failure I pass a user name and password to a password protected page and get Connection Failure using cfhttp. what causes this. JT __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfhttp Connection Failure
yep did that to It sits in a password protected area -Original Message- From: Robyn Follen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 12:50 PM To: CF-Talk Subject: RE: cfhttp Connection Failure Not sure if this will do it, but check that you're passing in the entire URL of the page you're trying to pass to - e.g., http://www.mysite.com/page.cfm -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:57 PM To: CF-Talk Subject: cfhttp Connection Failure I pass a user name and password to a password protected page and get Connection Failure using cfhttp. what causes this. JT __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MS SQL global temp tables and CF's connections
I am hoping that some of you better versed in MS-SQL and CF could clear this up for me. Is there an issue with multiple users accidentally hitting the same data set that is contained in either a local(#tbl_name) or global(##tbl_name) temporary table? Books Online says that a local temp table is local to the current session, but how does a session relate to the connections that CF maintains, ie connection pooling? If we have, say 5 select intos, one after another in a stored proc, and while user 1 is on the 3'rd select into, user2 is on the first, and both are selecting into the same global/local table, based upon different where clauses, will this cause bad data, ie data that doesn't meet the where clauses per user, to enter the temp table? And thus the resulting record set returned would be incorrect? I know that this has a slim margin of happening, but I'm thinking concurrent access, same as the old insert new user, select max id problem. I would like to avoid a transactional lock because of the bottle neck, I would prefer a more proper approach. My feeling is that this is an issue, my dba doesn't, but both of us don't really know for sure. I hope I made sense, let me know if I didn't. Thanks. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stand-alone server
I could be wrong, but I believe somewhere in the CFMX beta forum an engineer wrote that it was a certain version of Apache that JRun's web server for CFMX was built on. Or I may just be making things up... If so, crack is on me at DevCon. IGOR ILYINSKY CREDIT|FIRST SUISSE|BOSTON -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 12:50 PM To: CF-Talk Subject: RE: Stand-alone server Yep, thats what I thought. I am sure the JRun is a custom implementation. N -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 08 August 2002 17:42 To: CF-Talk Subject: RE: Stand-alone server Basically, [the standalone server is] Apache Web Server, but I don't think that version has been released to the public. Its Apache? I was sure it was a JRun implementation (unless thats what JRun is too!) I don't think either JRun or CF MX use any Apache code for the standalone web server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfhttp Connection Failure
If this is on IIS, make sure you have basic authentication enabled. CF doesn't do windows or digest authentication. Only basic. HTH, Jeff Garza - Original Message - From: Jim Taylor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 1:03 PM Subject: RE: cfhttp Connection Failure yep did that to It sits in a password protected area -Original Message- From: Robyn Follen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 12:50 PM To: CF-Talk Subject: RE: cfhttp Connection Failure Not sure if this will do it, but check that you're passing in the entire URL of the page you're trying to pass to - e.g., http://www.mysite.com/page.cfm -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:57 PM To: CF-Talk Subject: cfhttp Connection Failure I pass a user name and password to a password protected page and get Connection Failure using cfhttp. what causes this. JT __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Installing CFMX on a drive other than C:
Has anyone installed ColdFusion MX (Pro or Ent) on a drive other than C? Something like D or F? We are setting up a new webserver and are currently planning the partitions. The idea was submitted to me to put the CFMX installation on D instead of C. Pros or cons to doing this? Does it wreak havoc on the Java (JRE) implementation? Ryan Kime [EMAIL PROTECTED] Web Developer Webco Industries __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Installing CFMX on a drive other than C:
D:\CFusionServerMX works 100% ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:23 PM To: CF-Talk Subject: Installing CFMX on a drive other than C: Has anyone installed ColdFusion MX (Pro or Ent) on a drive other than C? Something like D or F? We are setting up a new webserver and are currently planning the partitions. The idea was submitted to me to put the CFMX installation on D instead of C. Pros or cons to doing this? Does it wreak havoc on the Java (JRE) implementation? Ryan Kime [EMAIL PROTECTED] Web Developer Webco Industries __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Installing CFMX on a drive other than C:
Has anyone installed ColdFusion MX (Pro or Ent) on a drive other than C? Something like D or F? We are setting up a new webserver and are currently planning the partitions. The idea was submitted to me to put the CFMX installation on D instead of C. Pros or cons to doing this? Does it wreak havoc on the Java (JRE) implementation? Yes, you can install CF MX to any drive you like. I'd strongly recommend that you install it to a partition other than your system partition, which is usually C. I'd recommend that for all software you install on a server. It doesn't affect the JRE at all. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfhttp Connection Failure
is the cfhttp password and username attributes a windows system un pw -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 1:17 PM To: CF-Talk Subject: Re: cfhttp Connection Failure If this is on IIS, make sure you have basic authentication enabled. CF doesn't do windows or digest authentication. Only basic. HTH, Jeff Garza - Original Message - From: Jim Taylor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 1:03 PM Subject: RE: cfhttp Connection Failure yep did that to It sits in a password protected area -Original Message- From: Robyn Follen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 12:50 PM To: CF-Talk Subject: RE: cfhttp Connection Failure Not sure if this will do it, but check that you're passing in the entire URL of the page you're trying to pass to - e.g., http://www.mysite.com/page.cfm -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:57 PM To: CF-Talk Subject: cfhttp Connection Failure I pass a user name and password to a password protected page and get Connection Failure using cfhttp. what causes this. JT __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMX and client variables (size limit?)
I'm getting a lot of client variable errors after upgrading to MX. I get intermittent failed client variable operations when using a SQL7.0 database as a client variable repository. I am the only user using the site, so the deadlocked processes and failed transactions are very suspicious. We had no problems at all with the exact same setup on early versions of CF. I've had a number of errors, one reporting that there had been 500 failed transactions on the client variable datasource. And the funny thing is that this error was written to the browser using the H2 tag while debugging was disabled. Interesting. Now I can reproduce this error whenever my client variables are too big. As I said this was not a problem on earlier versions. -- Operation failed on the data source named skyline_clientvars. Reason of failure [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Invalid precision value -- This length of client variable string works fine on CF4.5. I also dropped and recreated the client variable reference in the administrator because I heard some one mention that there was an issue that was easily solved by forcing the administrator to write to a prefs/config file just by hitting it. I'm not sure if this is the correct way to calculate the size of the client var data, but I used cfdump to output it and then cut and paste it into a notepad and the doc weighed 17k. In general the application's client var string will almost never be this big, I was just testing. But in CF4.5 I thought the size limit was around 32k. It was definetly bigger than 17k! Has any one seen something similar? Can some one test this by doing a cffile action=read file=my17kfile.txt variable=client.myclientvar or something similar while client variables are enabled for DB storage. Brook Davies __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfhttp Connection Failure
Yes, you supply it the same credentials as though you are logging in via a browser. To enable basic authentication in IIS , open up the IIS MMC, browse to the website or folder you want to secure, right click and choose properties, go to the Directory Security tab, click on the Edit button and then make sure that the basic authentication box is checked, click OK. You should then be able to use CFHTTP to connect to that restricted resource. - Original Message - From: Jim Taylor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 1:39 PM Subject: RE: cfhttp Connection Failure is the cfhttp password and username attributes a windows system un pw -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 1:17 PM To: CF-Talk Subject: Re: cfhttp Connection Failure If this is on IIS, make sure you have basic authentication enabled. CF doesn't do windows or digest authentication. Only basic. HTH, Jeff Garza - Original Message - From: Jim Taylor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 1:03 PM Subject: RE: cfhttp Connection Failure yep did that to It sits in a password protected area -Original Message- From: Robyn Follen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 12:50 PM To: CF-Talk Subject: RE: cfhttp Connection Failure Not sure if this will do it, but check that you're passing in the entire URL of the page you're trying to pass to - e.g., http://www.mysite.com/page.cfm -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:57 PM To: CF-Talk Subject: cfhttp Connection Failure I pass a user name and password to a password protected page and get Connection Failure using cfhttp. what causes this. JT __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX and client variables (size limit?)
Brook Davies wrote: I'm not sure if this is the correct way to calculate the size of the client var data, but I used cfdump to output it and then cut and paste it into a notepad and the doc weighed 17k. In general the application's client var string will almost never be this big, I was just testing. Wouldn't Len() work directly in the database? And might the problem be caused by Unicode using double byte characters? But in CF4.5 I thought the size limit was around 32k. It was definetly bigger than 17k! Has any one seen something similar? Can some one test this by doing a cffile action=read file=my17kfile.txt variable=client.myclientvar or something similar while client variables are enabled for DB storage. The database I use for client variables allows up to 1 GB per field. So I suppose you could just change the datatype to something bigger (I presume MS SQL Server has something bigger as 32 KB). Jochem __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Installing CFMX on a drive other than C:
I second Dave's suggestion. I have always installed Windows NT or 2000 on the C drive and D is the CD and E is where software and Inetpub is placed. I have not had any problems with that configuration. Chris White Has anyone installed ColdFusion MX (Pro or Ent) on a drive other than C? Something like D or F? We are setting up a new webserver and are currently planning the partitions. The idea was submitted to me to put the CFMX installation on D instead of C. Pros or cons to doing this? Does it wreak havoc on the Java (JRE) implementation? Yes, you can install CF MX to any drive you like. I'd strongly recommend that you install it to a partition other than your system partition, which is usually C. I'd recommend that for all software you install on a server. It doesn't affect the JRE at all. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX and client variables (size limit?)
Len would tell me the length not the size of the client variables. I don't see how Unicode would be the problem if the problem only occurs when the client variables reach a certain size. The SQL Server field size is not an issue. This works with the same DB with CF4.5. At 10:46 PM 08/08/02 +0200, you wrote: Brook Davies wrote: I'm not sure if this is the correct way to calculate the size of the client var data, but I used cfdump to output it and then cut and paste it into a notepad and the doc weighed 17k. In general the application's client var string will almost never be this big, I was just testing. Wouldn't Len() work directly in the database? And might the problem be caused by Unicode using double byte characters? But in CF4.5 I thought the size limit was around 32k. It was definetly bigger than 17k! Has any one seen something similar? Can some one test this by doing a cffile action=read file=my17kfile.txt variable=client.myclientvar or something similar while client variables are enabled for DB storage. The database I use for client variables allows up to 1 GB per field. So I suppose you could just change the datatype to something bigger (I presume MS SQL Server has something bigger as 32 KB). Jochem __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Redirect from ASP to CF
I have an ASP application that passes information to a CF application using the following: response.redirect(http://www.somesite.com/d3/redirect.cfm?acctID=; Server.URLEncode(session(acct_id)) userid= Server.URLEncode(session(user_id)) user= Server.URLEncode(rs(id))) On dialup machines the values are lost but with cable it works fine. Any ideas what is going on? It stays on the same box. Using 3 servers with switching configured for .com and .net sites. TIA Cami __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfhttp Connection Failure
Jeff, We Have basic authentication in IIS enabled and I supply a user name and password to enter the directory of this section of the site.I still get a connection failure. Could the required cookie information be needed and if so how would i tel cfhttp what it is? Thanks a million. JT -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 1:42 PM To: CF-Talk Subject: Re: cfhttp Connection Failure Yes, you supply it the same credentials as though you are logging in via a browser. To enable , open up the IIS MMC, browse to the website or folder you want to secure, right click and choose properties, go to the Directory Security tab, click on the Edit button and then make sure that the basic authentication box is checked, click OK. You should then be able to use CFHTTP to connect to that restricted resource. - Original Message - From: Jim Taylor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 1:39 PM Subject: RE: cfhttp Connection Failure is the cfhttp password and username attributes a windows system un pw -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 1:17 PM To: CF-Talk Subject: Re: cfhttp Connection Failure If this is on IIS, make sure you have basic authentication enabled. CF doesn't do windows or digest authentication. Only basic. HTH, Jeff Garza - Original Message - From: Jim Taylor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 1:03 PM Subject: RE: cfhttp Connection Failure yep did that to It sits in a password protected area -Original Message- From: Robyn Follen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 12:50 PM To: CF-Talk Subject: RE: cfhttp Connection Failure Not sure if this will do it, but check that you're passing in the entire URL of the page you're trying to pass to - e.g., http://www.mysite.com/page.cfm -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:57 PM To: CF-Talk Subject: cfhttp Connection Failure I pass a user name and password to a password protected page and get Connection Failure using cfhttp. what causes this. JT __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX and client variables (size limit?)
I belive CF5.0 Client variables size was 120K. Docs say you can increase the size of client vars by increasing the size of the DB storage fields... Have you tried increasing the size of DB fields? U are also getting a precision error.. u can try resetting the DB field precision as well. Joe Certified Advanced ColdFusion Developer - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 4:56 PM Subject: CFMX and client variables (size limit?) I'm getting a lot of client variable errors after upgrading to MX. I get intermittent failed client variable operations when using a SQL7.0 database as a client variable repository. I am the only user using the site, so the deadlocked processes and failed transactions are very suspicious. We had no problems at all with the exact same setup on early versions of CF. I've had a number of errors, one reporting that there had been 500 failed transactions on the client variable datasource. And the funny thing is that this error was written to the browser using the H2 tag while debugging was disabled. Interesting. Now I can reproduce this error whenever my client variables are too big. As I said this was not a problem on earlier versions. -- Operation failed on the data source named skyline_clientvars. Reason of failure [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Invalid precision value -- This length of client variable string works fine on CF4.5. I also dropped and recreated the client variable reference in the administrator because I heard some one mention that there was an issue that was easily solved by forcing the administrator to write to a prefs/config file just by hitting it. I'm not sure if this is the correct way to calculate the size of the clien t var data, but I used cfdump to output it and then cut and paste it into a notepad and the doc weighed 17k. In general the application's client var string will almost never be this big, I was just testing. But in CF4.5 I thought the size limit was around 32k. It was definetly bigger than 17k! Has any one seen something similar? Can some one test this by doing a cffile action=read file=my17kfile.txt variable=client.myclientvar or something similar while client variables are enabled for DB storage. Brook Davies __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
500 Internal Server Error
I have a select list, a user chooses what category they want to view and click submit. The submit is a input type img. Most of the selects work as desired, but a few when selected and the form is submitted get a 500 internal server error. An example is below. form name=Category_Search method=post action=/categorysearch/index.cfm select name=Category option value=1Category 1/option option value=2Category 2/option /select input type=img src=/assets/images/gobutton.gif /form Category 1 will work correctly, but category 2 will show 500 internal server error. ?? P.S. This is not my actual code but setup basically the same without the variables, loop, tables, etc. Bryan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Redirect from ASP to CF
Hmm. Do redirects from ASP to ASP pages work properly as well? The dialup dudes could be going through a proxy. Client side redirects sometimes fail because of this. - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 2:54 pm Subject: Redirect from ASP to CF I have an ASP application that passes information to a CF application using the following: response.redirect(http://www.somesite.com/d3/redirect.cfm?acctID=; Server.URLEncode(session(acct_id)) userid= Server.URLEncode(session(user_id)) user= Server.URLEncode(rs(id))) On dialup machines the values are lost but with cable it works fine. Any ideas what is going on? It stays on the same box. Using 3 servers with switching configured for .com and .net sites. TIA Cami __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Redirect from ASP to CF
We have verified that more than half of the clients are not going through a proxy server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:26 PM To: CF-Talk Subject: Re: Redirect from ASP to CF Hmm. Do redirects from ASP to ASP pages work properly as well? The dialup dudes could be going through a proxy. Client side redirects sometimes fail because of this. - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 2:54 pm Subject: Redirect from ASP to CF I have an ASP application that passes information to a CF application using the following: response.redirect(http://www.somesite.com/d3/redirect.cfm?acctID=; Server.URLEncode(session(acct_id)) userid= Server.URLEncode(session(user_id)) user= Server.URLEncode(rs(id))) On dialup machines the values are lost but with cable it works fine. Any ideas what is going on? It stays on the same box. Using 3 servers with switching configured for .com and .net sites. TIA Cami __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Redirect from ASP to CF
So do ASP to ASP page redirects work properly? - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 3:27 pm Subject: RE: Redirect from ASP to CF We have verified that more than half of the clients are not going through a proxy server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:26 PM To: CF-Talk Subject: Re: Redirect from ASP to CF Hmm. Do redirects from ASP to ASP pages work properly as well? The dialup dudes could be going through a proxy. Client side redirectssometimes fail because of this. - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 2:54 pm Subject: Redirect from ASP to CF I have an ASP application that passes information to a CF application using the following: response.redirect(http://www.somesite.com/d3/redirect.cfm?acctID=; Server.URLEncode(session(acct_id)) userid= Server.URLEncode(session(user_id)) user= Server.URLEncode(rs(id))) On dialup machines the values are lost but with cable it works fine. Any ideas what is going on? It stays on the same box. Using 3 servers with switching configured for .com and .net sites. TIA Cami __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Redirect from ASP to CF
We use a redirect as part of the website to send it to a virtual directory and we don't have to pass anything at that point. So I guess the answer is I don't have any idea. We do use response.redirect with information but cookies are set by that time and the switching software knows to keep it on the box it came from. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:36 PM To: CF-Talk Subject: Re: RE: Redirect from ASP to CF So do ASP to ASP page redirects work properly? - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 3:27 pm Subject: RE: Redirect from ASP to CF We have verified that more than half of the clients are not going through a proxy server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:26 PM To: CF-Talk Subject: Re: Redirect from ASP to CF Hmm. Do redirects from ASP to ASP pages work properly as well? The dialup dudes could be going through a proxy. Client side redirectssometimes fail because of this. - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 2:54 pm Subject: Redirect from ASP to CF I have an ASP application that passes information to a CF application using the following: response.redirect(http://www.somesite.com/d3/redirect.cfm?acctID=; Server.URLEncode(session(acct_id)) userid= Server.URLEncode(session(user_id)) user= Server.URLEncode(rs(id))) On dialup machines the values are lost but with cable it works fine. Any ideas what is going on? It stays on the same box. Using 3 servers with switching configured for .com and .net sites. TIA Cami __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Redirect from ASP to CF
You may want to watch for headers already being written... Can't redirect a response after you started sending HTML to the client browser, i.e. do not put Redirect after HTML -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:41 PM To: CF-Talk Subject: RE: RE: Redirect from ASP to CF We use a redirect as part of the website to send it to a virtual directory and we don't have to pass anything at that point. So I guess the answer is I don't have any idea. We do use response.redirect with information but cookies are set by that time and the switching software knows to keep it on the box it came from. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:36 PM To: CF-Talk Subject: Re: RE: Redirect from ASP to CF So do ASP to ASP page redirects work properly? - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 3:27 pm Subject: RE: Redirect from ASP to CF We have verified that more than half of the clients are not going through a proxy server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:26 PM To: CF-Talk Subject: Re: Redirect from ASP to CF Hmm. Do redirects from ASP to ASP pages work properly as well? The dialup dudes could be going through a proxy. Client side redirectssometimes fail because of this. - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 2:54 pm Subject: Redirect from ASP to CF I have an ASP application that passes information to a CF application using the following: response.redirect(http://www.somesite.com/d3/redirect.cfm?acctID=; Server.URLEncode(session(acct_id)) userid= Server.URLEncode(session(user_id)) user= Server.URLEncode(rs(id))) On dialup machines the values are lost but with cable it works fine. Any ideas what is going on? It stays on the same box. Using 3 servers with switching configured for .com and .net sites. TIA Cami __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DWMX Tag Shorcut Keys
I remember reading this thread a while ago, both in the Kojak Beta Forum and here, but I finally buckled down and picked up DWMX, and I don't remember if you can create keyboard shortcuts for tags. The most I can dig up is CTRL-E for the Insert-Tag window, but in Studio 4.5.2, I have a bunch of hotkeys for cfoutput, cfquery, etc VTM windows. Can you do this? (My damned memory is fading!) Thanks! -- Scott Van Vliet Senior Technical Analyst Eclipse Advertising, Inc. T: 818.238.9388 x 242 F: 818.238.9193 2255 N. Ontario Suite 170 Burbank, CA 92504 [EMAIL PROTECTED] http://www.eclipseadvertising.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Sun One Webserver and CGI variables
Hi all, I'm testing the Sun One Web Server with CFMX and finding that it does not return all the CGI variables I'm used to seeing with Apache, IIS or even Website. Sun tech support sent me a JSP that appears to reference things like USER_AGENT etc, stuff that I'm interested in for browser detection. However, CFMX threw the following error when I ran the snoop.jsp page supplied by SUN. Is it possible that I need the Enterprise version of CFMX to access variables from the SUN ONE web server that I can access with CFMX pro using Apache, IIS or Website.? Thanks in advance for any ideas on this. Julian McNamara CFMX Error Msg A License Exception has been thrown You tried to access a restricted feature for the Professional edition: JSP Please Try The Following: ·Check the ·CFML Reference Manual to verify that you are using the correct syntax. ·Search the ·Knowledge Base to find a solution to your problem. Browser Remote Address 129.85.135.101 Referer Date/Time 08-Aug-02 06:07 PM Stack Trace coldfusion.license.LicenseManager$LicenseIllegalAccessException: A License Exception has been thrownat coldfusion.license.LicenseManager._checkJSP(Unknown Source)at coldfusion.license.LicenseManager.checkJSP(Unknown Source)at coldfusion.license.JspLicenseServlet.service(Unknown Source)at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sun One Webserver and CGI variables
See bug 3551963 - MX has the same problem with iPlanet on Solaris -Shawn -Original Message- From: Julian McNamara [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:24 PM To: CF-Talk Subject: Sun One Webserver and CGI variables Hi all, I'm testing the Sun One Web Server with CFMX and finding that it does not return all the CGI variables I'm used to seeing with Apache, IIS or even Website. Sun tech support sent me a JSP that appears to reference things like USER_AGENT etc, stuff that I'm interested in for browser detection. However, CFMX threw the following error when I ran the snoop.jsp page supplied by SUN. Is it possible that I need the Enterprise version of CFMX to access variables from the SUN ONE web server that I can access with CFMX pro using Apache, IIS or Website.? Thanks in advance for any ideas on this. Julian McNamara CFMX Error Msg A License Exception has been thrown You tried to access a restricted feature for the Professional edition: JSP Please Try The Following: ·Check the ·CFML Reference Manual to verify that you are using the correct syntax. ·Search the ·Knowledge Base to find a solution to your problem. Browser Remote Address 129.85.135.101 Referer Date/Time 08-Aug-02 06:07 PM Stack Trace coldfusion.license.LicenseManager$LicenseIllegalAccessException: A License Exception has been thrownat coldfusion.license.LicenseManager._checkJSP(Unknown Source)at coldfusion.license.LicenseManager.checkJSP(Unknown Source)at coldfusion.license.JspLicenseServlet.service(Unknown Source)at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348)at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 )at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4)at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DWMX Tag Shorcut Keys
Check out my instructions for assigning ctrl-3 to surround with #s. Same procedure for reassigning other shortcuts. However, we've found that at least one shortcut (ctrl-D) that we wanted to use in the code window would only work when in the design-mode window - so your mileage may vary, depending onthe exact keystrokes you're trying to assign to what menu items: http://vvmx.blogspot.com/2002_06_23_vvmx_archive.html#78289194 And don't forget, the Dreamweaver forum is a great place for help w/ DW. Those folks are really bright, friendly and know DW inside out! http://webforums.macromedia.com/dreamweaver -Vern Vernon Viehe ColdFusion Community Manager Developer Relations Macromedia, Inc. Online diary: http://vvmx.blogspot.com/ -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:14 PM To: CF-Talk Subject: DWMX Tag Shorcut Keys I remember reading this thread a while ago, both in the Kojak Beta Forum and here, but I finally buckled down and picked up DWMX, and I don't remember if you can create keyboard shortcuts for tags. The most I can dig up is CTRL-E for the Insert-Tag window, but in Studio 4.5.2, I have a bunch of hotkeys for cfoutput, cfquery, etc VTM windows. Can you do this? (My damned memory is fading!) Thanks! -- Scott Van Vliet Senior Technical Analyst Eclipse Advertising, Inc. T: 818.238.9388 x 242 F: 818.238.9193 2255 N. Ontario Suite 170 Burbank, CA 92504 [EMAIL PROTECTED] http://www.eclipseadvertising.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sun One Webserver and CGI variables
You need the Enterprise version to run JSP pages in CFMX. -kumaran -Original Message- From: Julian McNamara [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 6:24 PM To: CF-Talk Subject: Sun One Webserver and CGI variables Hi all, I'm testing the Sun One Web Server with CFMX and finding that it does not return all the CGI variables I'm used to seeing with Apache, IIS or even Website. Sun tech support sent me a JSP that appears to reference things like USER_AGENT etc, stuff that I'm interested in for browser detection. However, CFMX threw the following error when I ran the snoop.jsp page supplied by SUN. Is it possible that I need the Enterprise version of CFMX to access variables from the SUN ONE web server that I can access with CFMX pro using Apache, IIS or Website.? Thanks in advance for any ideas on this. Julian McNamara CFMX Error Msg A License Exception has been thrown You tried to access a restricted feature for the Professional edition: JSP Please Try The Following: *Check the *CFML Reference Manual to verify that you are using the correct syntax. *Search the *Knowledge Base to find a solution to your problem. Browser Remote Address 129.85.135.101 Referer Date/Time 08-Aug-02 06:07 PM Stack Trace coldfusion.license.LicenseManager$LicenseIllegalAccessException: A License Exception has been thrownat coldfusion.license.LicenseManager._checkJSP(Unknown Source)at coldfusion.license.LicenseManager.checkJSP(Unknown Source)at coldfusion.license.JspLicenseServlet.service(Unknown Source)at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DWMX Tag Shorcut Keys (Solved)
Figured it out. 1) Make a copy of the Macromedia Standard Keyboard Shortcut Set C:\Documents and Settings\svanvliet\Application Data\Macromedia\Dreamweaver MX\Configuration\Menus\Custom Sets\Macromedia Standard copy.xml 2) Find all of the CF Tag shortcuts, noted by DWMenu_Insert_CF_ and go! SHORTCUT ID=DWMenu_Insert_CF_Query keys=/ SHORTCUT ID=DWMenu_Insert_CF_Output keys=/ SHORTCUT ID=DWMenu_Insert_CF_Insert keys=/ For CTRL use Cmd For SHIFT use Shift For Alt use Alt Enjoy! -- Scott Van Vliet Senior Technical Analyst Eclipse Advertising, Inc. T: 818.238.9388 x 242 F: 818.238.9193 2255 N. Ontario Suite 170 Burbank, CA 92504 [EMAIL PROTECTED] http://www.eclipseadvertising.com -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:14 PM To: CF-Talk Subject: DWMX Tag Shorcut Keys I remember reading this thread a while ago, both in the Kojak Beta Forum and here, but I finally buckled down and picked up DWMX, and I don't remember if you can create keyboard shortcuts for tags. The most I can dig up is CTRL-E for the Insert-Tag window, but in Studio 4.5.2, I have a bunch of hotkeys for cfoutput, cfquery, etc VTM windows. Can you do this? (My damned memory is fading!) Thanks! -- Scott Van Vliet Senior Technical Analyst Eclipse Advertising, Inc. T: 818.238.9388 x 242 F: 818.238.9193 2255 N. Ontario Suite 170 Burbank, CA 92504 [EMAIL PROTECTED] http://www.eclipseadvertising.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Redirect from ASP to CF
Also instead of response.redirect, try: server.redirect Shawn Regan -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:41 PM To: CF-Talk Subject: RE: Redirect from ASP to CF Have you tried setting the URL to a variable and outputting it to the screen to ensure that it is correct? I have had issues with redirects and Mac browser (don't know if that's the situation), but try this to first see what your URL looks like. Dim theURL theURL = http://www.somesite.com/d3/redirect.cfm; theURL = theURL ?acctID= Server.URLEncode(session(acct_id)) theURL = theURL userid= Server.URLEncode(session(user_id)) theURL = theURL user= Server.URLEncode(rs(id))) reponse.write theURL -- Scott Van Vliet Senior Technical Analyst Eclipse Advertising, Inc. T: 818.238.9388 x 242 F: 818.238.9193 2255 N. Ontario Suite 170 Burbank, CA 92504 [EMAIL PROTECTED] http://www.eclipseadvertising.com -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:27 PM To: CF-Talk Subject: RE: Redirect from ASP to CF We have verified that more than half of the clients are not going through a proxy server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:26 PM To: CF-Talk Subject: Re: Redirect from ASP to CF Hmm. Do redirects from ASP to ASP pages work properly as well? The dialup dudes could be going through a proxy. Client side redirects sometimes fail because of this. - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 2:54 pm Subject: Redirect from ASP to CF I have an ASP application that passes information to a CF application using the following: response.redirect(http://www.somesite.com/d3/redirect.cfm?acctID=; Server.URLEncode(session(acct_id)) userid= Server.URLEncode(session(user_id)) user= Server.URLEncode(rs(id))) On dialup machines the values are lost but with cable it works fine. Any ideas what is going on? It stays on the same box. Using 3 servers with switching configured for .com and .net sites. TIA Cami __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion MX Reference Manual
Gary, Knowing that the Tag and Function references were one of the most used elements of any book by ColdFusion developers, we made sure to include a complete tag/function reference in our book. It'll be on shelves on Thursday, August 15th. You can also pre-order from Amazon. ~~~ Neil Ross, Principal Consultant Codesweeper Consulting 717.648.2520 [EMAIL PROTECTED] www.codesweeper.com ~ ~ ~ ~ ~ ~ ~ Did you order my new book yet? Inside ColdFusion MX http://www.amazon.com/exec/obidos/ASIN/0735713049/ref=pd_sbs_b_2/104-9231390-3960719 Houk, Gary wrote:Hi everyone, CF used to come with a nice CFML reference manual with a complete listing of all the CF tags and functions. The documentation that I received with MX is less than 1/2 of what I received when I upgraded to CF 5. Is this the norm? Is there a CFMX reference manual available (other than the pdf)? - Gary __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Spell Checker
Ok I have a project for you Cold Fusion / JavaScript guru's. My spelling sucks and I'm cheep so I don't want to pay for a spell checker and couldn't find a good one for free on the net. So I created one, it seems works fine but it is kind of slow, and it doesn't do suggested words. It can be downloaded here: http://www.samroach.com/downloads.html So if anyone wants to have a crack at fixing it up please get in contact with me at [EMAIL PROTECTED] or if anyone knows of a good free one please let me know. thanks, -- Sam __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
website redirect question
Hello everyone, This is not a CF question, I guess its more a server/dns question. We have our site redirecting to another company, we've been acquired, via an IIS hostheader redirect. We've also tried this using a meta redirect. The redirect works fine, the only problem is that we had some marketing campaigns that pointed to subsections of our site and now everything is going to the new company's website. Is there any way at all to get around this? Or by specifying a redirect at the root level, via IIS or Meta, going to cause this to happen? Thanks SR __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Task/Project Management App
Quantum Art advise me: The demo of Q-Project is still available at http://project.quantumart.com. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Michael Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 August 2002 2:58 PM To: CF-Talk Subject: RE: Task/Project Management App Hi, Thanks Kevin. I have checked those out already and was just wanting to see if anything else might be available. Thanks for the suggestion! Mike -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 1:24 AM To: CF-Talk Subject: RE: Task/Project Management App I recall finding some stuff in dev exchange __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion MX Reference Manual
Alphabetized or grouped by functionality? Original code examples along with reference? Those two criteria usually end up being the determining factor on whether or not I keep the book on my desk at work, or on my bookshelf at home. The reference manuals are perfect for when I need to know the exact syntax, so alphabetical is good there. But when I open my book, it's because I am not sure how this function or tag operates, or maybe don't even know what it is named, and want to see examples. -- jon mailto:[EMAIL PROTECTED] Thursday, August 8, 2002, 7:17:33 PM, you wrote: NR Gary, NR Knowing that the Tag and Function references were one of the most used elements of any book by ColdFusion developers, we made sure to include a complete tag/function reference in our book. It'll NR be on shelves on Thursday, August 15th. You can also pre-order from Amazon. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What is all these DSN's?
Does anyone know what these DSN's are for? I have a list of them, and I know I did not put them there. Which ones can I get rid of? CR0R8V36 CR Oracle8 v3.6 CRSS SQL SERVER CRXMLV36 CR XML v3.6 FLASH Microsoft Access Driver LocalServer SQL Server Douglas Brown Email: [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Task/Project Management App
How do you get in? -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:57 PM To: CF-Talk Subject: RE: Task/Project Management App Quantum Art advise me: The demo of Q-Project is still available at http://project.quantumart.com. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Michael Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 August 2002 2:58 PM To: CF-Talk Subject: RE: Task/Project Management App Hi, Thanks Kevin. I have checked those out already and was just wanting to see if anything else might be available. Thanks for the suggestion! Mike -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 1:24 AM To: CF-Talk Subject: RE: Task/Project Management App I recall finding some stuff in dev exchange __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Task/Project Management App
That is what I was wondering too...I figured it was one of those IQ tests or something :-) Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Dan Haley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 5:17 PM Subject: RE: Task/Project Management App How do you get in? -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:57 PM To: CF-Talk Subject: RE: Task/Project Management App Quantum Art advise me: The demo of Q-Project is still available at http://project.quantumart.com. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Michael Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 August 2002 2:58 PM To: CF-Talk Subject: RE: Task/Project Management App Hi, Thanks Kevin. I have checked those out already and was just wanting to see if anything else might be available. Thanks for the suggestion! Mike -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 1:24 AM To: CF-Talk Subject: RE: Task/Project Management App I recall finding some stuff in dev exchange __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Redirect from ASP to CF
I don't think there's a server.redirect. There is a server.transfer and server.execute however. -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 5:16 PM To: CF-Talk Subject: RE: Redirect from ASP to CF Also instead of response.redirect, try: server.redirect Shawn Regan -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:41 PM To: CF-Talk Subject: RE: Redirect from ASP to CF Have you tried setting the URL to a variable and outputting it to the screen to ensure that it is correct? I have had issues with redirects and Mac browser (don't know if that's the situation), but try this to first see what your URL looks like. Dim theURL theURL = http://www.somesite.com/d3/redirect.cfm; theURL = theURL ?acctID= Server.URLEncode(session(acct_id)) theURL = theURL userid= Server.URLEncode(session(user_id)) theURL = theURL user= Server.URLEncode(rs(id))) reponse.write theURL -- Scott Van Vliet Senior Technical Analyst Eclipse Advertising, Inc. T: 818.238.9388 x 242 F: 818.238.91932255 N. Ontario Suite 170 Burbank, CA 92504 [EMAIL PROTECTED] http://www.eclipseadvertising.com -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:27 PM To: CF-Talk Subject: RE: Redirect from ASP to CF We have verified that more than half of the clients are not going through a proxy server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:26 PM To: CF-Talk Subject: Re: Redirect from ASP to CF Hmm. Do redirects from ASP to ASP pages work properly as well? The dialup dudes could be going through a proxy. Client side redirects sometimes fail because of this. - Original Message - From: Cami Lawson [EMAIL PROTECTED] Date: Thursday, August 8, 2002 2:54 pm Subject: Redirect from ASP to CF I have an ASP application that passes information to a CF application using the following: response.redirect(http://www.somesite.com/d3/redirect.cfm?acctID=; Server.URLEncode(session(acct_id)) userid= Server.URLEncode(session(user_id)) user= Server.URLEncode(rs(id))) On dialup machines the values are lost but with cable it works fine. Any ideas what is going on? It stays on the same box. Using 3 servers with switching configured for .com and .net sites. TIA Cami __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Stored Procedure recordset.
I want to do something in TSQL if results are returned. I forgot the syntax. I think its selected but I can't be sure could someone point me in the right direction. Thanks, Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
getdate() in access
GENERAL PROBLEM There is a list of conferences. I would like to show upcoming conferences on one page and past conferences on another. Users are sending files up in excel. I'm linking them to Access and would like to run queries on the data. Since access is linked to excel the data type can't be modified from text to date. I tried creating new fields in excel and formating the field as date. but that didn't work. SQL attempt I would like to do a WHERE eventDate getdate() in access -- but nothing seems to work date() doesn't give an ODBC error but it doesn't do anything either. Cold Fusion Attempt I can't seem to be able to pass anything to a cfif DateCompare(#CreateDate(#eventDate#)#, Now()) IS -1 The wonderful queryName.fieldName didn't work this time. :-) I'm stuck on what to do. Aside from having users fill out a form and populate a MSSQL database. thx // gilbert midonnet __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: getdate() in access
Try datevalue(eventDate). Depending on the format of the text in evendDate, Access should convert it to a date. At least according to the many, many, many Access tables/queries/macros I've been converting to Oracle over the last two weeks ... ;) Dan -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 5:42 PM To: CF-Talk Subject: getdate() in access GENERAL PROBLEM There is a list of conferences. I would like to show upcoming conferences on one page and past conferences on another. Users are sending files up in excel. I'm linking them to Access and would like to run queries on the data. Since access is linked to excel the data type can't be modified from text to date. I tried creating new fields in excel and formating the field as date. but that didn't work. SQL attempt I would like to do a WHERE eventDate getdate() in access -- but nothing seems to work date() doesn't give an ODBC error but it doesn't do anything either. Cold Fusion Attempt I can't seem to be able to pass anything to a cfif DateCompare(#CreateDate(#eventDate#)#, Now()) IS -1 The wonderful queryName.fieldName didn't work this time. :-) I'm stuck on what to do. Aside from having users fill out a form and populate a MSSQL database. thx // gilbert midonnet __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stored Procedure recordset.
I think what you're looking for is @@recordcount that outputs the records affected... -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 5:38 PM To: CF-Talk Subject: Stored Procedure recordset. I want to do something in TSQL if results are returned. I forgot the syntax. I think its @@selected but I can't be sure could someone point me in the right direction. Thanks, Neil __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Stored Procedure recordset.
IF EXISTS ( Select Foo FROM Bar Where Whatever = 1) -- result set returned BEGIN -- BEGIN is equiv to java { end is like java } END ELSE -- no results returned BEGIN END -- jon mailto:[EMAIL PROTECTED] Thursday, August 8, 2002, 8:38:05 PM, you wrote: NH I want to do something in TSQL if results are returned. I forgot the NH syntax. I think its @@selected but I can't be sure could someone point me NH in the right direction. NH Thanks, NH Neil NH __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Installing CFMX on a drive other than C:
Our development server has it on D:\CfusionMX\.Works fine. Cheers Has anyone installed ColdFusion MX (Pro or Ent) on a drive other than C? Something like D or F? We are setting up a new webserver and are currently planning the partitions. The idea was submitted to me to put the CFMX installation on D instead of C. Pros or cons to doing this? Does it wreak havoc on the Java (JRE) implementation? Ryan Kime [EMAIL PROTECTED] Web Developer Webco Industries __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Stored Procedure recordset.
Oops, replace(myPost, 'java', 'javascript') :) -- jon mailto:[EMAIL PROTECTED] Thursday, August 8, 2002, 8:55:59 PM, you wrote: jh IF EXISTS ( Select Foo FROM Bar Where Whatever = 1) jh-- result set returned jhBEGIN jh-- BEGIN is equiv to java { end is like java } jhEND jh ELSE jh -- no results returned jhBEGIN jhEND jh -- jh jon jh mailto:[EMAIL PROTECTED] jh Thursday, August 8, 2002, 8:38:05 PM, you wrote: NH I want to do something in TSQL if results are returned. I forgot the NH syntax. I think its @@selected but I can't be sure could someone point me NH in the right direction. NH Thanks, NH Neil NH jh __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: getdate() in access
Are you sure your eventDate field is an acceptable date (ie. its datatype)? -- Scott Van Vliet Senior Technical Analyst Eclipse Advertising, Inc. T: 818.238.9388 x 242 F: 818.238.9193 2255 N. Ontario Suite 170 Burbank, CA 92504 [EMAIL PROTECTED] http://www.eclipseadvertising.com -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 5:42 PM To: CF-Talk Subject: getdate() in access GENERAL PROBLEM There is a list of conferences. I would like to show upcoming conferences on one page and past conferences on another. Users are sending files up in excel. I'm linking them to Access and would like to run queries on the data. Since access is linked to excel the data type can't be modified from text to date. I tried creating new fields in excel and formating the field as date. but that didn't work. SQL attempt I would like to do a WHERE eventDate getdate() in access -- but nothing seems to work date() doesn't give an ODBC error but it doesn't do anything either. Cold Fusion Attempt I can't seem to be able to pass anything to a cfif DateCompare(#CreateDate(#eventDate#)#, Now()) IS -1 The wonderful queryName.fieldName didn't work this time. :-) I'm stuck on what to do. Aside from having users fill out a form and populate a MSSQL database. thx // gilbert midonnet __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 500 Internal Server Error
Nothing obvious here. It would be helpful if you could indicate, or give some code, indicating what happens of the action page. I have a select list, a user chooses what category they want to view and click submit. The submit is a input type img. Most of the selects work as desired, but a few when selected and the form is submitted get a 500 internal server error. An example is below. form name=Category_Search method=post action=/categorysearch/index.cfm select name=Category option value=1Category 1/option option value=2Category 2/option /select input type=img src=/assets/images/gobutton.gif /form Category 1 will work correctly, but category 2 will show 500 internal server error. ?? P.S. This is not my actual code but setup basically the same without the variables, loop, tables, etc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Task/Project Management App
Standby ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: Friday, 9 August 2002 9:47 AM To: CF-Talk Subject: RE: Task/Project Management App How do you get in? -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:57 PM To: CF-Talk Subject: RE: Task/Project Management App Quantum Art advise me: The demo of Q-Project is still available at http://project.quantumart.com. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Michael Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 August 2002 2:58 PM To: CF-Talk Subject: RE: Task/Project Management App Hi, Thanks Kevin. I have checked those out already and was just wanting to see if anything else might be available. Thanks for the suggestion! Mike -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 1:24 AM To: CF-Talk Subject: RE: Task/Project Management App I recall finding some stuff in dev exchange __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX best practices and Imaging Lib
Comment on the font: I can deal with the tiny size, but when I print it out it is just a shade darker than the page. Not all that readable onscreen... definitely unreadable in print. Otherwise, looks interesting. -Patti - Original Message - From: Benoit Hediard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 9:30 AM Subject: CFMX best practices and Imaging Lib Hi, I've put online : - an Imaging UDF library (based on ImageJ), - some CFMX Best Practices (not bulletproof best practices, just some dev techniques I am using). http://www.benorama.com/coldfusion Next week, I'll add a Pagelet and I18N custom tags. Any feedbacks are welcome. Ben PS : I didn't want to start another CF blog, so I have done this small MX resource center, where I am going to share some of my MX work. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFC's question and the Arguments. (cfproperty vs this)
Sorry old thread, but got a question that would fit perfectly. What is the real difference between using cfproperty and the this scope? Are the only advantages the datatype validation? -- jon mailto:[EMAIL PROTECTED] Wednesday, August 7, 2002, 9:55:02 PM, you wrote: HH Sean, HH Was making the this scope public intentional or just something HH inadvertent that slipped through? HH -Original Message- HH From: Sean A Corfield [mailto:[EMAIL PROTECTED]] HH Sent: Wednesday, August 07, 2002 8:09 PM HH To: CF-Talk HH Subject: Re: CFC's question and the Arguments. HH On Tuesday, August 6, 2002, at 11:13 , Hal Helms wrote: You can refer to a passed value either as arguments.varName or just varName. I personally prefer the arguments.varName. HH I agree with Hal - be explicit. The this scope provides the global scope I think you're looking for. HH this creates *public* data members that are accessible directly from HH *outside* the component... cfcomponent hint=I am a Person cfset this.firstName = cfset this.lastName = cffunction name=setFirstName cfargument name=firstName type=string required=yes cfset this.firstName = arguments.firstName /cffunction /cfcomponent HH I can now do: HH cfset x = createObject(component,person)/ HH cfset x.firstName = Mickey/ HH i.e., without calling setFirstName(). HH If you want a *private* data member (and you normally should!), then use HH the unnamed scope: HH cfcomponent hint=I am a Person HHcfset firstName = HHcfset lastName = HHcffunction name=setFirstName HH cfargument name=firstName type=string required=yes HH cfset firstName = arguments.firstName HH/cffunction HH /cfcomponent __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Task/Project Management App
Here's the latest from Quantum Art Kevin, sorry about that. I gave you a wrong link. You need to use http://pm.quantumart.com/ and then demo/demo. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: Friday, 9 August 2002 9:47 AM To: CF-Talk Subject: RE: Task/Project Management App How do you get in? -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:57 PM To: CF-Talk Subject: RE: Task/Project Management App Quantum Art advise me: The demo of Q-Project is still available at http://project.quantumart.com. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Michael Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 August 2002 2:58 PM To: CF-Talk Subject: RE: Task/Project Management App Hi, Thanks Kevin. I have checked those out already and was just wanting to see if anything else might be available. Thanks for the suggestion! Mike -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 1:24 AM To: CF-Talk Subject: RE: Task/Project Management App I recall finding some stuff in dev exchange __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX best practices and Imaging Lib
Nice site! I want to add to the comment on the font: Why so tiny!? Bonnie E. Betts [EMAIL PROTECTED] www.bettsIT.com 703.508.9766 - Original Message - From: Benoit Hediard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 6:30 AM Subject: CFMX best practices and Imaging Lib Hi, I've put online : - an Imaging UDF library (based on ImageJ), - some CFMX Best Practices (not bulletproof best practices, just some dev techniques I am using). http://www.benorama.com/coldfusion Next week, I'll add a Pagelet and I18N custom tags. Any feedbacks are welcome. Ben PS : I didn't want to start another CF blog, so I have done this small MX resource center, where I am going to share some of my MX work. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does anyone use cfm-resources.com?
I used to use them. Had one of their free accounts. Like some have said, not the fastest in the west but great customer service and support. J. John Wilker Codito, ergo sum Web Applications Consultant, and Writer Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com I asked Do you know DOS? The reply was: No, but I met Tom and Drew a few minutes ago. -Original Message- From: James Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 7:48 AM To: CF-Talk Subject: Does anyone use cfm-resources.com? Hi, is anyone using, or know anything about cfm-resources.com. Kind of hard to believe you can get a site for $49.95 a YEAR, but being able to have a playground for experiments at that price would be nice. http://www.cfm-resources.com/ Thanks *** James Johnson SMB-Studios Innovative Online Learning for Spirit, Mind and Body www.smb-studios.com [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
experimenting with web services
Does anybody know what this error means? I have tried a series of Web services including the google one in the Macromedia tutorial (http://www.macromedia.com/desdev/mx/dreamweaver/articles/webservice.htm l) and no matter what service I try I keep getting this error. Thanks! Could not generate stub objects for web service invocation. Name: http://webservices.tei.or.th/getQuakeData.cfc?wsdl. WSDL: http://webservices.tei.or.th/getQuakeData.cfc?wsdl. java.net.NoRouteToHostException: Host unreachable: connect It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can't be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: experimenting with web services
Does anybody know what this error means? I have tried a series of Web services including the google one in the Macromedia tutorial (http://www.macromedia.com/ desdev/mx/dreamweaver/articles/webservice.html) and no matter what service I try I keep getting this error. Thanks! Could not generate stub objects for web service invocation. Name: http://webservices.tei.or.th/getQuakeData.cfc?wsdl. WSDL: http://webservices.tei.or.th/getQuakeData.cfc?wsdl. java.net.NoRouteToHostException: Host unreachable: connect It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. It sounds like your server can't reach the target server, since it's returning a Host unreachable error. Can you resolve DNS lookups from that server? If you run a browser from the server console, and you go to the URL, do you get a WSDL file? I do, so the target server appears to be working. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: experimenting with web services
Should have looked for the obvious! It's a new server for CFMX and it doesn't seem to be connecting to any web site. Thanks very much Dave. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, 9 August 2002 2:24 p.m. To: CF-Talk Subject: RE: experimenting with web services Does anybody know what this error means? I have tried a series of Web services including the google one in the Macromedia tutorial (http://www.macromedia.com/ desdev/mx/dreamweaver/articles/webservice.html) and no matter what service I try I keep getting this error. Thanks! Could not generate stub objects for web service invocation. Name: http://webservices.tei.or.th/getQuakeData.cfc?wsdl. WSDL: http://webservices.tei.or.th/getQuakeData.cfc?wsdl. java.net.NoRouteToHostException: Host unreachable: connect It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. It sounds like your server can't reach the target server, since it's returning a Host unreachable error. Can you resolve DNS lookups from that server? If you run a browser from the server console, and you go to the URL, do you get a WSDL file? I do, so the target server appears to be working. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: experimenting with web services
Name: http://webservices.tei.or.th/getQuakeData.cfc?wsdl. WSDL: http://webservices.tei.or.th/getQuakeData.cfc?wsdl. java.net.NoRouteToHostException: Host unreachable: connect It is funny i can get there ok ;-) might try the ip: 203.154.114.235 more human readable info at http://webservices.tei.or.th/ (same ip). --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 2/8/2545 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Stored Procedure recordset.
You guys sure it isn't @@rowcount? Neil - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 08, 2002 8:50 PM Subject: RE: Stored Procedure recordset. I think what you're looking for is @@recordcount that outputs the records affected... -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 5:38 PM To: CF-Talk Subject: Stored Procedure recordset. I want to do something in TSQL if results are returned. I forgot the syntax. I think its @@selected but I can't be sure could someone point me in the right direction. Thanks, Neil __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Installing CFMX on a drive other than C:
What'd really be neat would be to install/run it on a CD Dick On Thursday, August 8, 2002, at 01:22 PM, Ryan Kime wrote: Has anyone installed ColdFusion MX (Pro or Ent) on a drive other than C? Something like D or F? We are setting up a new webserver and are currently planning the partitions. The idea was submitted to me to put the CFMX installation on D instead of C. Pros or cons to doing this? Does it wreak havoc on the Java (JRE) implementation? Ryan Kime [EMAIL PROTECTED] Web Developer Webco Industries __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists