Crystal Reports
Hi, Does anyone know how to call up or incorporate Crystal Reports in Cold Fusion MX and what version of Crystal Reports will work in MX? Thanks Best Regards, Amalan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
WAY OT: Printing a form field with javascript
Hi all. Sorry for the OT post. I've been searching and cannot find an answer, and I'm not a javascript guru by any stretch. I'm showing a long block of text in a textarea field. I'd like the user to be able to click a button and print only what is in that field. I'd prefer to do it without opening a new window, but if I have to I have to. Thanks a bunch. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cannot convert to number.
On 1/13/03, Jillian Carroll penned: I am having a really weird problem... I do some calculations in CF, they work on my development machine (Windows XP Home/Apache) but when I upload them to my host (Windows 2000/IIS) they don't work. I get this error... anybody able to help me on this one? *** *** *** snip !--- Next/Previous Logic Start --- !--- Set the number of records to display on each page. --- CFSET OnEachPage = #toolsviewnum# !--- Set the default startrow to 1 if a value was not passed. --- !--- Determine whether or not to show the previous or next links. --- CFPARAM NAME = StartRow DEFAULT = 1 !--- Set the value of endrow to the maxrows + startrow - 1 --- CFSET EndRow = StartRow + OnEachPage - 1 The first thing I'd check is what the value of toolsviewnum is. If it's blank, then that will cause the error. I couldn't see from your code where that value is being set. If that value is being pulled from a database, that may be why it works on the dev box and not on the host's server. Maybe the data is different in the test database. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: URL Scope
I wouldn't suggest client variables, nor any other type of session variable. Instead, once you complete your error checking on the action page you'll set a flag to true if there are any errors. I usually set Request.ErrorInd = 1 when there are errors encountered. Then check the value of Request.ErrorInd and if it's 1 you'll cfmodule the form. Be sure to use cfabort after the cfmodule though. This way all of your form scoped variables still exist and can populate the form fields and you don't have a messy url. I can give you more details on how to accomplish this if you're interested. ~Jason -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 11, 2003 10:31 PM To: CF-Talk Subject: Re: URL Scope Cool, thanks. The reason I posted was this: I have a form which is created dynamically, I want to fill the form with all of the information that the user has correctly filled in if any errors occur. The form basically contains attributes for files that have been submitted to the admin. The admin then has some options to fill in (who to send file too...). There can be 1 file, 10 files, 20 files described in this form. The admin can fill in information for 1 file at a time if he wishes, so form validation like required=yes cannot be used. So on the template that recieves the form information, I check for errors, if there are any I had thought of sending all of the information back through URL. Sometimes, there could be much. I thought there might be a problem. Would you suggest client variables for this? TIA, Yves - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 11, 2003 11:14 PM Subject: RE: URL Scope yves, i ran into that issue, when i was sending color variations, in hex to various pages for lines of reports, i simply store them in client variables and now hardly even have to use url variables, storing client vars in a db, and referencing them through cfid calls to match the values in the db, makes life sooo much easier, check them out! later. tony -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 11, 2003 8:17 PM To: CF-Talk Subject: RE: URL Scope Thanks! I had never come across any limit. I don't think I've ever seen the question posted either. The list (that's all you people of course) is an awesome resource!! :-) Give yourselves a round of applause!! Yves Arsenault Carrefour Infotech 5, Acadian Dr. Charlottetown, PEI C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: January 11, 2003 9:01 PM To: CF-Talk Subject: Re: URL Scope On 1/11/03 4:35 PM, Dick Applebaum [EMAIL PROTECTED] wrote: AFAIK, the official limit (total size of the URL) is 2k. However, many browsers web servers will handle more. Best to use post method, which is theoretically unlimited. Also, as a personal preference, I hate to see/copy/paste/read/click long URLs -- yeech! But URLS are SO NICE if you want details kept with a bookmark! And when you WANT to expose parameters (like a scrolling starting point or number of items displayed per page) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: URL Scope
There is a limit to the amount of data that can be passed through a url in NS and it's 2k. That number was from v.4 so I don't know if it's still true. I've never passed that much data through the url so I don't really know. ~Jason -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 11, 2003 8:17 PM To: CF-Talk Subject: RE: URL Scope Thanks! I had never come across any limit. I don't think I've ever seen the question posted either. The list (that's all you people of course) is an awesome resource!! :-) Give yourselves a round of applause!! Yves Arsenault Carrefour Infotech 5, Acadian Dr. Charlottetown, PEI C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: January 11, 2003 9:01 PM To: CF-Talk Subject: Re: URL Scope On 1/11/03 4:35 PM, Dick Applebaum [EMAIL PROTECTED] wrote: AFAIK, the official limit (total size of the URL) is 2k. However, many browsers web servers will handle more. Best to use post method, which is theoretically unlimited. Also, as a personal preference, I hate to see/copy/paste/read/click long URLs -- yeech! But URLS are SO NICE if you want details kept with a bookmark! And when you WANT to expose parameters (like a scrolling starting point or number of items displayed per page) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hosting and CFSchedule
I use cfdynamics and I don't think there is a limit to the number of cfschedule's you can run within an hour. Give them a call though and find out. CFDynamics.com ~Jason -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 2:40 PM To: CF-Talk Subject: Re: Hosting and CFSchedule you can always schedule a remote request from another box you have to request the URL :) I do that for redundancy sake across boxes locally and remotely... also works nicely to centralize all events in one place... -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Thane Sherrington [EMAIL PROTECTED] Date: Fri, 10 Jan 2003 14:09:18 -0400 Subject: Hosting and CFSchedule Can anyone recommend a good host that allows one to run CFSCHEDULE tasks every 15 minutes or so? I'm on CrystalTech, and while I really recommend them, they only allow scheduled tasks every hour. T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Design Pattern Question
Hi everyone, Thanks for all the positive feedbacks on benorama.com ColdFusion content. The articles I've put online are a set of Best practices and general design techniques that I daily used for advanced CFMX application development (in our company, a collaborative plate-form). They are certainly not perfect (it is not 100% MVC on the controller part) but they work very well. The idea is that you can take whatever you like and adapt them to your needs. I should add some more details on my use of CFCs, but I haven't updated the site since august 2002... For the moment, here it is on CF-Talk. I usually create : - Entity CFCs that correspond to physical persistent entity (usually a single row in one or several database tables). they inherits from a base Entity.cfc with init and getProperties methods, they usually have at least load, create, store and remove methods, Ex. : cfscript newsEntityInstance = createObject(component,com.mycompany.news.NewsEntity); newsEntityInstance.load(1011); newsEntityInstance.title = I have changed the title; // or newsEntityInstance.setTitle(I have changed the title); // if you create setter/getter functions for each properties newsEntityInstance.store(); /cfscript - Utility CFCs that encapsulate generic business logic and are not persistent and stateless. Ex. : cfscript newsUtility = createObject(component,com.mycompany.news.NewsUtility); lastNewsRecordSet = newsUtility.getLastNews(); /cfscript - Session CFCs that act as a facade to handle the client session (statefull). Ex. : !--- use the com.mycompany.member.MemberSession CFC put in session scope --- cfif session.currentMember.hasTheRightToDoThat() ... /cfif This is how I use CFCs for a 100% ColdFusion-based application, but if you have good J2EE skills in your team and if it is required, you might replace those CFCs by EJBs (with all their pros and cons...). Last month, I also spent some time to try to establish methodologies/best practices for complex Flash MX application development : how to nicely apply MVC to Flash MX and Flash remoting. Right now, I used facade CFCs on the server side and ActionScript proxy class on the client side, encapsulated in Flash components. Each Flash components correspond more or less to a CF pagelet. But Flash components are not only a View with some Model calls to get content, they integrate the full MVC pattern and use at least four ActionScript class (per component) : - a View class that dynamically display the content and set the layout, - a Model class to hold the data of the component, - a Controller class (the Broadcaster class based on the events listener/broadcaster mechanism), - a Service class to call the server components through one or several facade CFCs (the only CFCs with a remote access), - the main component class that contains and uses all those classes. But I am still not completely happy with that (pretty complex to develop and to maintain). I am going to re-work on it when I'll have sometimes during the following months. As soon as I have got something more clear and elegant, I'll put in online in the Flash section of benorama.com. Any feedbacks or suggestions on all those stuffs (ColdFusion or Flash) are welcome! Benoit Hediard www.benorama.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Join - Help!
I'm trying to look up the department name and group description using their ID's. But it only returns the records where it finds both department and group descriptions. Some records don't have a group description or department name. I believe I'm using the wrong type of join but I'm stumped. Any ideas or better ways of accomplishing this query. example: --- SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A INNER JOIN Dept B ON A.DepartmentID = B.DepartmentID INNER JOIN DeptGroups C ON A.GroupID = C.GroupID --- Thank You, Dave Bosky HTC Web Services [EMAIL PROTECTED] office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unix database syntactically similar to SQL Server?
On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter wrote: So does VMWare for Linux run under MacOSX? Now *that* would be a solution :) VirtualPC emulates a PC and runs on OS X. Right. But VMWare let's you install *lots* of OS's -- most *nix, most Win, even Solaris if you're a glutton for install punishment. With VMWare, you could run a virtual Win2k Server instance on your Mac and use it for the db part of the development. Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Join - Help!
Try using an RIGHT OUTER JOIN.. -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 14:09 To: CF-Talk Subject: SQL Join - Help! I'm trying to look up the department name and group description using their ID's. But it only returns the records where it finds both department and group descriptions. Some records don't have a group description or department name. I believe I'm using the wrong type of join but I'm stumped. Any ideas or better ways of accomplishing this query. example: --- SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A INNER JOIN Dept B ON A.DepartmentID = B.DepartmentID INNER JOIN DeptGroups C ON A.GroupID = C.GroupID --- Thank You, Dave Bosky HTC Web Services [EMAIL PROTECTED] office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Join - Help!
oops, sorry I think it should be a LEFT OUTER JOIN -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 14:11 To: CF-Talk Subject: RE: SQL Join - Help! Try using an RIGHT OUTER JOIN.. -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 14:09 To: CF-Talk Subject: SQL Join - Help! I'm trying to look up the department name and group description using their ID's. But it only returns the records where it finds both department and group descriptions. Some records don't have a group description or department name. I believe I'm using the wrong type of join but I'm stumped. Any ideas or better ways of accomplishing this query. example: --- SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A INNER JOIN Dept B ON A.DepartmentID = B.DepartmentID INNER JOIN DeptGroups C ON A.GroupID = C.GroupID --- Thank You, Dave Bosky HTC Web Services [EMAIL PROTECTED] office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Join - Help!
SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A INNER JOIN Dept B ON A.DepartmentID = B.DepartmentID LEFT OUTER JOIN DeptGroups C ON A.GroupID = C.GroupID Try that out Paul Giesehagen QuillDesign - Original Message - From: Bosky, Dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 8:08 AM Subject: SQL Join - Help! I'm trying to look up the department name and group description using their ID's. But it only returns the records where it finds both department and group descriptions. Some records don't have a group description or department name. I believe I'm using the wrong type of join but I'm stumped. Any ideas or better ways of accomplishing this query. example: --- SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A INNER JOIN Dept B ON A.DepartmentID = B.DepartmentID INNER JOIN DeptGroups C ON A.GroupID = C.GroupID --- Thank You, Dave Bosky HTC Web Services [EMAIL PROTECTED] office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Join - Help!
Quoting Bosky, Dave [EMAIL PROTECTED]: I'm trying to look up the department name and group description using their ID's. But it only returns the records where it finds both department and group descriptions. Some records don't have a group description or department name. I believe I'm using the wrong type of join but I'm stumped. Any ideas or better ways of accomplishing this query. SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A INNER JOIN Dept B ON A.DepartmentID = B.DepartmentID INNER JOIN DeptGroups C ON A.GroupID = C.GroupID SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A LEFT JOIN Dept B ON A.DepartmentID = B.DepartmentID LEFT JOIN DeptGroups C ON A.GroupID = C.GroupID Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Crystal Reports
This came up in the past couple weeks. As I remember the summary: The COM component (.ocx) that ships with Crystal 8.x and 9 may or may not work under CFMX. The Java-COM bridge can be problematic. But there is a Java wrapper (which I can verify that ships with CR 8.5 at least) that will let you manipulate Crystal reports as you would the COM object. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Amalan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 6:50 AM Subject: Crystal Reports Hi, Does anyone know how to call up or incorporate Crystal Reports in Cold Fusion MX and what version of Crystal Reports will work in MX? Thanks Best Regards, Amalan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Tracking Refferal Pages
DD, We have some code that we use in the application.cfm at homepage level. Here is the code we use: !--- wehre did the user come from? How did they find us? --- cfif (cgi.http_referer CONTAINS mfgquote.com is NO) and (cgi.http_referer is not ) cfif isDefined(URL.source) cfset Promo = URL.Source cfelse cfset Promo = /cfif CFQUERY NAME=InsertReferer DATASOURCE=#myDSN# INSERT INTO RefererLog (CFIdCFToken, refererURL, IP, Browser, Promo) VALUES ('#cookie.CFID#:#cookie.CFToken#', '#cgi.http_referer#', '#cgi.REMOTE_ADDR#', '#cgi.HTTP_USER_AGENT#', '#promo#') /CFQUERY /cfif As you can see above we insert the referer from outside sources into a database table. We also use the variable promo for URLs that come from Paid advertising so we can track it. Then upon registration we do an update of this table based off the user's CFID:CFTOKEN. Is this a perfect way? NO, but it does give us some great metrics to know how much each registered user costs us. Hope this helps, Jeremy Jeremy Bruck, VP of Technology ::MfgQuote 2690 Cumberland Parkway SE Suite 510 Atlanta, GA 30339 TEL: 678.556.2929 FAX: 678.556.2980 www.mfgquote.com [EMAIL PROTECTED] -Original Message- From: Double Down, Inc. [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 5:05 PM To: CF-Talk Subject: Tracking Refferal Pages Can anyone suggest a good method for tracking what page bought a surfer to my page? I need to be able to get that information and put it in a DB. TIA DDINC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Join - Help!
The left outer join appears to have done the trick! Thanks! Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:19 AM To: CF-Talk Subject: Re: SQL Join - Help! Quoting Bosky, Dave [EMAIL PROTECTED]: I'm trying to look up the department name and group description using their ID's. But it only returns the records where it finds both department and group descriptions. Some records don't have a group description or department name. I believe I'm using the wrong type of join but I'm stumped. Any ideas or better ways of accomplishing this query. SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A INNER JOIN Dept B ON A.DepartmentID = B.DepartmentID INNER JOIN DeptGroups C ON A.GroupID = C.GroupID SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A LEFT JOIN Dept B ON A.DepartmentID = B.DepartmentID LEFT JOIN DeptGroups C ON A.GroupID = C.GroupID Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Apostrophes become boxes and other odd characters in CFMX?
After upgrading an application from CF5 to CFMX, I have run into a situation where some apostrophes and quote marks are being transformed into weird boxes and other strange characters. This only seems to happen when users cut/paste text from word, and not when they type it directly into the text form fields. I have a feeling that this has something to do with the JDBC drivers, but wanted to ask the list first in case anyone else has run into this problem. CFMX + SQL Server on WinNT... Thanks! -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX for J2EE (JRun)
Yup, nslookup works fine, we can ping and resolve the name. I followed all of the mentioned docs on configuring as well. Any other ideas for this? Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apostrophes become boxes and other odd characters in CFMX?
Quoting Cameron Childress [EMAIL PROTECTED]: After upgrading an application from CF5 to CFMX, I have run into a situation where some apostrophes and quote marks are being transformed into weird boxes and other strange characters. This only seems to happen when users cut/paste text from word, and not when they type it directly into the text form fields. I have a feeling that this has something to do with the JDBC drivers, but wanted to ask the list first in case anyone else has run into this problem. I have a feeling it has to do with charsets. Are you explicitly specifying the charset everywhere? Have you taken advantage of the upgrade and switched to unicode in the process? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unix database syntactically similar to SQL Server?
If you use ANSI standard syntax it works on most with little changes... If you program in Transact (MS Only) or SQL+ (ORACLE only) you will have some issues. I tend to use the LEFT OUTER JOIN and INNER JOIN syntax and it works well through mySQl, MSSQL, and ORACLE 9i Jeff -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:12 AM To: CF-Talk Subject: Re: Unix database syntactically similar to SQL Server? On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter wrote: So does VMWare for Linux run under MacOSX? Now *that* would be a solution :) VirtualPC emulates a PC and runs on OS X. Right. But VMWare let's you install *lots* of OS's -- most *nix, most Win, even Solaris if you're a glutton for install punishment. With VMWare, you could run a virtual Win2k Server instance on your Mac and use it for the db part of the development. Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need insights into best high load CFMX install
Hello, we are about to start a contract for a large eCommerce application and can recommend to our client what optimal configuration is needed. They have never used CFMX but are big on ColdFusion 50. The nature of this new application is a skinned eCommerce engine where around 70 different web sites will run off the same codebase/engine. This will be a high demand app so I would like to get any feedback as to what you think is the best CFMX set up for this situation. It looks like Macromedia are touting CFMX on J-Run as a good combination and I read the recent article on MMs Website and although some of you pointed out the Linux improvements it looks like CFMX J-Run on Win 2k was the best performer. Thanks for any insights. Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL7 DB Update Procedure
The on-line database of listings, etc, at www.SMARTERYellowpages.com , Biz1, is read-only in normal operation. The off-line database, Biz2, is not read-only in normal operation, and it is currently updated daily on a backup machine, including automatic backup, and updating of full-text indexes (SQL7). It's backup is used to update Biz1. Since the 2 databases are on different machines, they can and do have the same name. Updating of Biz1 is a simple restore using the most recent Biz2 backup, followed by updating the full-text index. Is there a way to have Biz1 Biz2 on the same machine, and: To update Biz1, switch Biz2 to read-only. Switch www.SMARTERyellwpages.com to read from Biz2 instead of Biz1 Update Biz1 using the latest backup of Biz2. I haven't tried this but I wonder how to work around the difference DB names - or even if the name difference matters. best, paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Another Locking Question
Yes. Yes. -- Original Message -- From: Webmaster [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Sun, 12 Jan 2003 15:23:55 -0500 Hi, If I reference an APPLICATION var using isDefined, do I have to read lock it. Is the var really being read? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Apostrophes become boxes and other odd characters in CFMX?
Unfortunately, This was a straight upgrade from CF5 to CFMX and I haven't changed anything about the way it handles char encoding. I am playing with it some now, but do you have an example of the things I might need to change, tags/etc to get this to work? -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:44 AM To: CF-Talk Subject: Re: Apostrophes become boxes and other odd characters in CFMX? Quoting Cameron Childress [EMAIL PROTECTED]: After upgrading an application from CF5 to CFMX, I have run into a situation where some apostrophes and quote marks are being transformed into weird boxes and other strange characters. This only seems to happen when users cut/paste text from word, and not when they type it directly into the text form fields. I have a feeling that this has something to do with the JDBC drivers, but wanted to ask the list first in case anyone else has run into this problem. I have a feeling it has to do with charsets. Are you explicitly specifying the charset everywhere? Have you taken advantage of the upgrade and switched to unicode in the process? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HELP!!!! jrun-resources.xml
did an sql 2000 service pack upgrade and a win2k adv critical updates on all servers last night, and now one of my servers is having issues making a datasource connection to a machine that prior to last night, had no issues... here is the error I am getting, HELP Connection verification failed for data source: platypus []java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml The root cause was that: java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml first, where the heck is jrun-resources.xml? second, should I even be looking for this cause it is or isnt the problem? what should I do? I have verified the odbc connection on the machine, and it is fine going to the server, datasource test works 100% (from windows odbc connection form) just not from cf or the administrator setting it up thanks. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HELP!!!! jrun-resources.xml
Have you tried deleting and recreating the datasource? Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Apostrophes become boxes and other odd characters in CFMX?
I had the same issue and it was a character set issue. Here is the code that I used to fix my application: cfprocessingdirective pageencoding=iso-8859-1 cfset setEncoding(form,iso-8859-1) cfset setEncoding(URL,iso-8859-1) cfcontent type=text/html; charset=iso-8859-1 Another discussion about character sets: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3threadid=403175highlight_key=ykeyword1=MXkeyword2=character Chris White Unfortunately, This was a straight upgrade from CF5 to CFMX and I haven't changed anything about the way it handles char encoding. I am playing with it some now, but do you have an example of the things I might need to change, tags/etc to get this to work? -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:44 AM To: CF-Talk Subject: Re: Apostrophes become boxes and other odd characters in CFMX? Quoting Cameron Childress [EMAIL PROTECTED]: After upgrading an application from CF5 to CFMX, I have run into a situation where some apostrophes and quote marks are being transformed into weird boxes and other strange characters. This only seems to happen when users cut/paste text from word, and not when they type it directly into the text form fields. I have a feeling that this has something to do with the JDBC drivers, but wanted to ask the list first in case anyone else has run into this problem. I have a feeling it has to do with charsets. Are you explicitly specifying the charset everywhere? Have you taken advantage of the upgrade and switched to unicode in the process? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP!!!! jrun-resources.xml
Tony, Could this problem be related to case sensitivity?? Maybe if you changed the datasource in your templates to Platypus MX would recognize it. ~Dina - Original Message - From: Tony Weeg To: CF-Talk Sent: Monday, January 13, 2003 9:41 AM Subject: HELP jrun-resources.xml did an sql 2000 service pack upgrade and a win2k adv critical updates on all servers last night, and now one of my servers is having issues making a datasource connection to a machine that prior to last night, had no issues... here is the error I am getting, HELP Connection verification failed for data source: platypus []java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml The root cause was that: java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml first, where the heck is jrun-resources.xml? second, should I even be looking for this cause it is or isnt the problem? what should I do? I have verified the odbc connection on the machine, and it is fine going to the server, datasource test works 100% (from windows odbc connection form) just not from cf or the administrator setting it up thanks. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP!!!! jrun-resources.xml
of course :) but thanks anyway! ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Steve Lynch [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:54 AM To: CF-Talk Subject: HELP jrun-resources.xml Have you tried deleting and recreating the datasource? Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP!!!! jrun-resources.xml
jrun-resource.xml is where the information about the database is stored when you config it in the CF Admin. I'd verify that all the connection data there is correct, but I'd also try creating a new datasource that point to the same place through CF -- that way you know whether it's this particular entry or *all* connections to SQL 2000. I'm guessing it's all connections to SQL2000. You'd get the same sort of message if you simply erased info out of that xml config file. Having trouble guessing how an upgrade could have done that so you're probably dealing with something more annoying. Could you have done something like change the default connection method in sql server (e.g. from named pipes to TCP or vice-versa)? I've been running SQL2000 sp2 w/ the .669 cumulative patch/hotfix and can connect using CFMX just fine, but I had patched the SQL servers before the CFMX even rolled out. I can't remember precisely what the upgrade from SQL2k (or sp1) to sp2 did. But if it's only one web server, the the win server patch is where you need to look. bleah. You might try changing over to TCP connections as a test (assuming you're using named pipes) or vice-versa to verify whether the problem is in the connection method itself or something more subtle. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:41 AM Subject: HELP jrun-resources.xml did an sql 2000 service pack upgrade and a win2k adv critical updates on all servers last night, and now one of my servers is having issues making a datasource connection to a machine that prior to last night, had no issues... here is the error I am getting, HELP Connection verification failed for data source: platypus []java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml The root cause was that: java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml first, where the heck is jrun-resources.xml? second, should I even be looking for this cause it is or isnt the problem? what should I do? I have verified the odbc connection on the machine, and it is fine going to the server, datasource test works 100% (from windows odbc connection form) just not from cf or the administrator setting it up thanks. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unix database syntactically similar to SQL Server?
I wonder what kind of system specs would be required to run an emulator, MS SQL Server, CFMXJ2EE, JRun4 and Jedit on a Mac? Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:12 AM To: CF-Talk Subject: Re: Unix database syntactically similar to SQL Server? On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter wrote: So does VMWare for Linux run under MacOSX? Now *that* would be a solution :) VirtualPC emulates a PC and runs on OS X. Right. But VMWare let's you install *lots* of OS's -- most *nix, most Win, even Solaris if you're a glutton for install punishment. With VMWare, you could run a virtual Win2k Server instance on your Mac and use it for the db part of the development. Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP!!!! jrun-resources.xml
thanks dina, but this is now what im getting Connection verification failed for data source: platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. using the same info that I have set up the datasource with in the administrator settings in windows!!! ARGGGH ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:50 AM To: CF-Talk Subject: Re: HELP jrun-resources.xml Tony, Could this problem be related to case sensitivity?? Maybe if you changed the datasource in your templates to Platypus MX would recognize it. ~Dina - Original Message - From: Tony Weeg To: CF-Talk Sent: Monday, January 13, 2003 9:41 AM Subject: HELP jrun-resources.xml did an sql 2000 service pack upgrade and a win2k adv critical updates on all servers last night, and now one of my servers is having issues making a datasource connection to a machine that prior to last night, had no issues... here is the error I am getting, HELP Connection verification failed for data source: platypus []java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml The root cause was that: java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml first, where the heck is jrun-resources.xml? second, should I even be looking for this cause it is or isnt the problem? what should I do? I have verified the odbc connection on the machine, and it is fine going to the server, datasource test works 100% (from windows odbc connection form) just not from cf or the administrator setting it up thanks. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP!!!! jrun-resources.xml
john, I forget where in the heck do I change from tcp to named pipes? I forget? thanks ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:54 AM To: CF-Talk Subject: Re: HELP jrun-resources.xml jrun-resource.xml is where the information about the database is stored when you config it in the CF Admin. I'd verify that all the connection data there is correct, but I'd also try creating a new datasource that point to the same place through CF -- that way you know whether it's this particular entry or *all* connections to SQL 2000. I'm guessing it's all connections to SQL2000. You'd get the same sort of message if you simply erased info out of that xml config file. Having trouble guessing how an upgrade could have done that so you're probably dealing with something more annoying. Could you have done something like change the default connection method in sql server (e.g. from named pipes to TCP or vice-versa)? I've been running SQL2000 sp2 w/ the .669 cumulative patch/hotfix and can connect using CFMX just fine, but I had patched the SQL servers before the CFMX even rolled out. I can't remember precisely what the upgrade from SQL2k (or sp1) to sp2 did. But if it's only one web server, the the win server patch is where you need to look. bleah. You might try changing over to TCP connections as a test (assuming you're using named pipes) or vice-versa to verify whether the problem is in the connection method itself or something more subtle. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:41 AM Subject: HELP jrun-resources.xml did an sql 2000 service pack upgrade and a win2k adv critical updates on all servers last night, and now one of my servers is having issues making a datasource connection to a machine that prior to last night, had no issues... here is the error I am getting, HELP Connection verification failed for data source: platypus []java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml The root cause was that: java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml first, where the heck is jrun-resources.xml? second, should I even be looking for this cause it is or isnt the problem? what should I do? I have verified the odbc connection on the machine, and it is fine going to the server, datasource test works 100% (from windows odbc connection form) just not from cf or the administrator setting it up thanks. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Apostrophes become boxes and other odd characters in CFMX?
That did it! Thanks... -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] -Original Message- From: Chris White [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:52 AM To: CF-Talk Subject: RE: Apostrophes become boxes and other odd characters in CFMX? I had the same issue and it was a character set issue. Here is the code that I used to fix my application: cfprocessingdirective pageencoding=iso-8859-1 cfset setEncoding(form,iso-8859-1) cfset setEncoding(URL,iso-8859-1) cfcontent type=text/html; charset=iso-8859-1 Another discussion about character sets: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3 threadid=403175highlight_key=ykeyword1=MXkeyword2=character Chris White Unfortunately, This was a straight upgrade from CF5 to CFMX and I haven't changed anything about the way it handles char encoding. I am playing with it some now, but do you have an example of the things I might need to change, tags/etc to get this to work? -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:44 AM To: CF-Talk Subject: Re: Apostrophes become boxes and other odd characters in CFMX? Quoting Cameron Childress [EMAIL PROTECTED]: After upgrading an application from CF5 to CFMX, I have run into a situation where some apostrophes and quote marks are being transformed into weird boxes and other strange characters. This only seems to happen when users cut/paste text from word, and not when they type it directly into the text form fields. I have a feeling that this has something to do with the JDBC drivers, but wanted to ask the list first in case anyone else has run into this problem. I have a feeling it has to do with charsets. Are you explicitly specifying the charset everywhere? Have you taken advantage of the upgrade and switched to unicode in the process? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP!!!! jrun-resources.xml
rewind, this server is actually a sql7 server not 2000 our other servers are 2000 not sql7does this change the stakes? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:54 AM To: CF-Talk Subject: Re: HELP jrun-resources.xml jrun-resource.xml is where the information about the database is stored when you config it in the CF Admin. I'd verify that all the connection data there is correct, but I'd also try creating a new datasource that point to the same place through CF -- that way you know whether it's this particular entry or *all* connections to SQL 2000. I'm guessing it's all connections to SQL2000. You'd get the same sort of message if you simply erased info out of that xml config file. Having trouble guessing how an upgrade could have done that so you're probably dealing with something more annoying. Could you have done something like change the default connection method in sql server (e.g. from named pipes to TCP or vice-versa)? I've been running SQL2000 sp2 w/ the .669 cumulative patch/hotfix and can connect using CFMX just fine, but I had patched the SQL servers before the CFMX even rolled out. I can't remember precisely what the upgrade from SQL2k (or sp1) to sp2 did. But if it's only one web server, the the win server patch is where you need to look. bleah. You might try changing over to TCP connections as a test (assuming you're using named pipes) or vice-versa to verify whether the problem is in the connection method itself or something more subtle. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:41 AM Subject: HELP jrun-resources.xml did an sql 2000 service pack upgrade and a win2k adv critical updates on all servers last night, and now one of my servers is having issues making a datasource connection to a machine that prior to last night, had no issues... here is the error I am getting, HELP Connection verification failed for data source: platypus []java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml The root cause was that: java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml first, where the heck is jrun-resources.xml? second, should I even be looking for this cause it is or isnt the problem? what should I do? I have verified the odbc connection on the machine, and it is fine going to the server, datasource test works 100% (from windows odbc connection form) just not from cf or the administrator setting it up thanks. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP!!!! jrun-resources.xml
actually it cant be named pipes issue, I have an odbc connection from the webserver to the database server fine, and im referencing it using its computer name, not its ip. soF this sucks...any ideas? anyone? thanks a lot in advance ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:02 AM To: CF-Talk Subject: RE: HELP jrun-resources.xml john, I forget where in the heck do I change from tcp to named pipes? I forget? thanks ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:54 AM To: CF-Talk Subject: Re: HELP jrun-resources.xml jrun-resource.xml is where the information about the database is stored when you config it in the CF Admin. I'd verify that all the connection data there is correct, but I'd also try creating a new datasource that point to the same place through CF -- that way you know whether it's this particular entry or *all* connections to SQL 2000. I'm guessing it's all connections to SQL2000. You'd get the same sort of message if you simply erased info out of that xml config file. Having trouble guessing how an upgrade could have done that so you're probably dealing with something more annoying. Could you have done something like change the default connection method in sql server (e.g. from named pipes to TCP or vice-versa)? I've been running SQL2000 sp2 w/ the .669 cumulative patch/hotfix and can connect using CFMX just fine, but I had patched the SQL servers before the CFMX even rolled out. I can't remember precisely what the upgrade from SQL2k (or sp1) to sp2 did. But if it's only one web server, the the win server patch is where you need to look. bleah. You might try changing over to TCP connections as a test (assuming you're using named pipes) or vice-versa to verify whether the problem is in the connection method itself or something more subtle. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:41 AM Subject: HELP jrun-resources.xml did an sql 2000 service pack upgrade and a win2k adv critical updates on all servers last night, and now one of my servers is having issues making a datasource connection to a machine that prior to last night, had no issues... here is the error I am getting, HELP Connection verification failed for data source: platypus []java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml The root cause was that: java.sql.SQLException: No datasource named Platypus is configured in jrun-resources.xml first, where the heck is jrun-resources.xml? second, should I even be looking for this cause it is or isnt the problem? what should I do? I have verified the odbc connection on the machine, and it is fine going to the server, datasource test works 100% (from windows odbc connection form) just not from cf or the administrator setting it up thanks. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Emulators/VMWare for Mac (WAS: Re: Unix database syntactically similar to SQL Server?)
Requirements for VMWare (for Linux) are remarkable low, but you need a *lot* of memory, decent disk space, and solid processor. I run Linux and Windows emulations under Windows 2000 with 512MB and PIII/500 -- but like it better on the P4 1+ GHz and 1 GB RAM. Did a little research and not a solution (obviously) for Mac. Looks like x86 architecture is part of the lowlevel emulation -- not that I know anything about hardware emulation in software :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:54 AM Subject: RE: Unix database syntactically similar to SQL Server? I wonder what kind of system specs would be required to run an emulator, MS SQL Server, CFMXJ2EE, JRun4 and Jedit on a Mac? Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:12 AM To: CF-Talk Subject: Re: Unix database syntactically similar to SQL Server? On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter wrote: So does VMWare for Linux run under MacOSX? Now *that* would be a solution :) VirtualPC emulates a PC and runs on OS X. Right. But VMWare let's you install *lots* of OS's -- most *nix, most Win, even Solaris if you're a glutton for install punishment. With VMWare, you could run a virtual Win2k Server instance on your Mac and use it for the db part of the development. Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unix database syntactically similar to SQL Server?
So does VMWare for Linux run under MacOSX? Now *that* would be a solution :) VirtualPC emulates a PC and runs on OS X. Right. But VMWare let's you install *lots* of OS's -- most *nix, most Win, even Solaris if you're a glutton for install punishment. With VMWare, you could run a virtual Win2k Server instance on your Mac and use it for the db part of the development. VirtualPC lets you install *lots* of OS's as well, in fact there is very little diference between the two. -- Jay ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?)
You can also run virtualPC with windows for mac to get the SQL server http://store.apple.com/1-800-MY-APPLE/WebObjects/AppleStore.woa/98/wo/VF67Rc 18Gpi42MkkyAbB0CAsg2i/2.4.0.3.27.10.11.5.13.0 But I agree you will need lots of ram -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:11 AM To: CF-Talk Subject: Emulators/VMWare for Mac (WAS: Re: Unix database syntactically similar to SQL Server?) Requirements for VMWare (for Linux) are remarkable low, but you need a *lot* of memory, decent disk space, and solid processor. I run Linux and Windows emulations under Windows 2000 with 512MB and PIII/500 -- but like it better on the P4 1+ GHz and 1 GB RAM. Did a little research and not a solution (obviously) for Mac. Looks like x86 architecture is part of the lowlevel emulation -- not that I know anything about hardware emulation in software :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:54 AM Subject: RE: Unix database syntactically similar to SQL Server? I wonder what kind of system specs would be required to run an emulator, MS SQL Server, CFMXJ2EE, JRun4 and Jedit on a Mac? Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:12 AM To: CF-Talk Subject: Re: Unix database syntactically similar to SQL Server? On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter wrote: So does VMWare for Linux run under MacOSX? Now *that* would be a solution :) VirtualPC emulates a PC and runs on OS X. Right. But VMWare let's you install *lots* of OS's -- most *nix, most Win, even Solaris if you're a glutton for install punishment. With VMWare, you could run a virtual Win2k Server instance on your Mac and use it for the db part of the development. Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How do I pick out part of the string?
cfset mystring=/cfdocs/lifemoves/html/announcements.cfm cfset mycftemplate=ListLast(mystring,/) -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 11, 2003 11:32 PM To: CF-Talk Subject: How do I pick out part of the string? Hi, all. How do I pick out announcements.cfm from this string: /cfdocs/lifemoves/html/announcements.cfm ??? Thanks, Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?)
I got CFMXJ2EE/JRun4/Sybase_ASE up and running on my Mac ... Seems to work pretty well, now if someone only made a utility that would allow me to move data from SQL Server to Sybase without having to write queries. Yes, I AM lazy - thank you very much. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Roberson, Jeff, Mr (Contractor) ACI [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:20 AM To: CF-Talk Subject: RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?) You can also run virtualPC with windows for mac to get the SQL server http://store.apple.com/1-800-MY-APPLE/WebObjects/AppleStore.woa/98/wo/VF 67Rc 18Gpi42MkkyAbB0CAsg2i/2.4.0.3.27.10.11.5.13.0 But I agree you will need lots of ram -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:11 AM To: CF-Talk Subject: Emulators/VMWare for Mac (WAS: Re: Unix database syntactically similar to SQL Server?) Requirements for VMWare (for Linux) are remarkable low, but you need a *lot* of memory, decent disk space, and solid processor. I run Linux and Windows emulations under Windows 2000 with 512MB and PIII/500 -- but like it better on the P4 1+ GHz and 1 GB RAM. Did a little research and not a solution (obviously) for Mac. Looks like x86 architecture is part of the lowlevel emulation -- not that I know anything about hardware emulation in software :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:54 AM Subject: RE: Unix database syntactically similar to SQL Server? I wonder what kind of system specs would be required to run an emulator, MS SQL Server, CFMXJ2EE, JRun4 and Jedit on a Mac? Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ** ** * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:12 AM To: CF-Talk Subject: Re: Unix database syntactically similar to SQL Server? On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter wrote: So does VMWare for Linux run under MacOSX? Now *that* would be a solution :) VirtualPC emulates a PC and runs on OS X. Right. But VMWare let's you install *lots* of OS's -- most *nix, most Win, even Solaris if you're a glutton for install punishment. With VMWare, you could run a virtual Win2k Server instance on your Mac and use it for the db part of the development. Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cannot convert to number.
cfquery name=tools datasource=#dsn# username=jubilee password=cds337 Better change your password now. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cannot convert to number.
why? do you know the DSN...? -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 16:28 To: CF-Talk Subject: RE: Cannot convert to number. cfquery name=tools datasource=#dsn# username=jubilee password=cds337 Better change your password now. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cannot convert to number.
No, but better safe than sorry. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:32 AM To: CF-Talk Subject: RE: Cannot convert to number. why? do you know the DSN...? -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 16:28 To: CF-Talk Subject: RE: Cannot convert to number. cfquery name=tools datasource=#dsn# username=jubilee password=cds337 Better change your password now. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Apostrophes become boxes and other odd characters in CFMX?
Chris White wrote: cfprocessingdirective pageencoding=iso-8859-1 This one should go into every template. cfset setEncoding(form,iso-8859-1) cfset setEncoding(URL,iso-8859-1) cfcontent type=text/html; charset=iso-8859-1 These can be set once from Application.cfm Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cannot convert to number.
And as long as you can get a script on the server, can get a list of the DSN's Robert Bailey [EMAIL PROTECTED] Famous for nothing! http://www.tinetics.com -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 8:38 AM To: CF-Talk Subject: RE: Cannot convert to number. No, but better safe than sorry. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:32 AM To: CF-Talk Subject: RE: Cannot convert to number. why? do you know the DSN...? -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 16:28 To: CF-Talk Subject: RE: Cannot convert to number. cfquery name=tools datasource=#dsn# username=jubilee password=cds337 Better change your password now. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cannot convert to number.
I would have though you would need registry access? or object access? -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 16:45 To: CF-Talk Subject: RE: Cannot convert to number. And as long as you can get a script on the server, can get a list of the DSN's Robert Bailey [EMAIL PROTECTED] Famous for nothing! http://www.tinetics.com -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 8:38 AM To: CF-Talk Subject: RE: Cannot convert to number. No, but better safe than sorry. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:32 AM To: CF-Talk Subject: RE: Cannot convert to number. why? do you know the DSN...? -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 16:28 To: CF-Talk Subject: RE: Cannot convert to number. cfquery name=tools datasource=#dsn# username=jubilee password=cds337 Better change your password now. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP!!!! jrun-resources.xml
Tony Weeg wrote: thanks dina, but this is now what im getting Connection verification failed for data source: platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602Method=Full And if you get a 'cannot establish socket' error use telnet to verify the SQL server is actually listening. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cannot convert to number.
Yeah, would need to call an object. Not much for navigating the registry, though I am sure you can do it that way as well Robert Bailey [EMAIL PROTECTED] Famous for nothing! http://www.tinetics.com -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 8:43 AM To: CF-Talk Subject: RE: Cannot convert to number. I would have though you would need registry access? or object access? -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 16:45 To: CF-Talk Subject: RE: Cannot convert to number. And as long as you can get a script on the server, can get a list of the DSN's Robert Bailey [EMAIL PROTECTED] Famous for nothing! http://www.tinetics.com -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 8:38 AM To: CF-Talk Subject: RE: Cannot convert to number. No, but better safe than sorry. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:32 AM To: CF-Talk Subject: RE: Cannot convert to number. why? do you know the DSN...? -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 16:28 To: CF-Talk Subject: RE: Cannot convert to number. cfquery name=tools datasource=#dsn# username=jubilee password=cds337 Better change your password now. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?)
What about MSSQL's DTS? Does Sybase have something similar? At 11:32 AM 1/13/2003, you wrote: I got CFMXJ2EE/JRun4/Sybase_ASE up and running on my Mac ... Seems to work pretty well, now if someone only made a utility that would allow me to move data from SQL Server to Sybase without having to write queries. Yes, I AM lazy - thank you very much. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP!!!! jrun-resources.xml
excellent jochem, now here is what I get Connection verification failed for data source: Platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:48 AM To: CF-Talk Subject: Re: HELP jrun-resources.xml Tony Weeg wrote: thanks dina, but this is now what im getting Connection verification failed for data source: platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602Method=Full And if you get a 'cannot establish socket' error use telnet to verify the SQL server is actually listening. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How can I redirect a user?
I'm setting up authentication against a database, and I have the form data going to a seperate page that I want users not to see (just a preference of mine)...Once the page is done processing, I want to push the users off to a different page...How do I do that? Are there any CF tags for it? Thank you, Scott PS. I'm very wet behind my ears, so if there's some tricks for authenticating against a db, please feel free to tell me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP!!!! jrun-resources.xml
in my odbc connection, system dsn that I am setting up through windows I am using my correct login info, not \ as the usernameWTF ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:56 AM To: CF-Talk Subject: RE: HELP jrun-resources.xml excellent jochem, now here is what I get Connection verification failed for data source: Platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:48 AM To: CF-Talk Subject: Re: HELP jrun-resources.xml Tony Weeg wrote: thanks dina, but this is now what im getting Connection verification failed for data source: platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602Method=Full And if you get a 'cannot establish socket' error use telnet to verify the SQL server is actually listening. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cannot convert to number.
yeah, but both of these functions can be disabled via the CFAS IDE -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 16:53 To: CF-Talk Subject: RE: Cannot convert to number. Yeah, would need to call an object. Not much for navigating the registry, though I am sure you can do it that way as well Robert Bailey [EMAIL PROTECTED] Famous for nothing! http://www.tinetics.com -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 8:43 AM To: CF-Talk Subject: RE: Cannot convert to number. I would have though you would need registry access? or object access? -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 16:45 To: CF-Talk Subject: RE: Cannot convert to number. And as long as you can get a script on the server, can get a list of the DSN's Robert Bailey [EMAIL PROTECTED] Famous for nothing! http://www.tinetics.com -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 8:38 AM To: CF-Talk Subject: RE: Cannot convert to number. No, but better safe than sorry. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:32 AM To: CF-Talk Subject: RE: Cannot convert to number. why? do you know the DSN...? -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 16:28 To: CF-Talk Subject: RE: Cannot convert to number. cfquery name=tools datasource=#dsn# username=jubilee password=cds337 Better change your password now. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I redirect a user?
cflocation url=yourWebsite.cfm ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:52 AM To: CF-Talk Subject: How can I redirect a user? I'm setting up authentication against a database, and I have the form data going to a seperate page that I want users not to see (just a preference of mine)...Once the page is done processing, I want to push the users off to a different page...How do I do that? Are there any CF tags for it? Thank you, Scott PS. I'm very wet behind my ears, so if there's some tricks for authenticating against a db, please feel free to tell me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I redirect a user?
SCRIPT LANGUAGE=JavaScript window.location=whatever.cfm; /script Robert Bailey [EMAIL PROTECTED] Famous for nothing! http://www.tinetics.com -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 8:52 AM To: CF-Talk Subject: How can I redirect a user? I'm setting up authentication against a database, and I have the form data going to a seperate page that I want users not to see (just a preference of mine)...Once the page is done processing, I want to push the users off to a different page...How do I do that? Are there any CF tags for it? Thank you, Scott PS. I'm very wet behind my ears, so if there's some tricks for authenticating against a db, please feel free to tell me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfoutput formatting
I have an output block that looks like so, tr tdimg src=images/spacer.gif width=71 height=1 alt= border=0/td cfoutput query=getclients td valign=top width=26 class=copyinput class=copy name=theid type=checkbox value=#id#/td td valign=top width=200 class=copy#UCase(cusername)#br(#cpassword#)/td /cfoutput tdimg src=images/spacer.gif width=85 height=1 alt= border=0/td /tr After the cfoutput kicks out 4 records I need a new tr/tr to be created and then show the next 4 records in 4 more td's and so forth instead of getting one row with 120 cells in it. Maybe something with the cfoutputs on the out side of the tr and a loop inside or something. JLB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I redirect a user?
cflocation Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: Scott Wilhelm [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 13 Jan 2003 11:52:04 -0500 I'm setting up authentication against a database, and I have the form data going to a seperate page that I want users not to see (just a preference of mine)...Once the page is done processing, I want to push the users off to a different page...How do I do that? Are there any CF tags for it? Thank you, Scott PS. I'm very wet behind my ears, so if there's some tricks for authenticating against a db, please feel free to tell me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I redirect a user?
CFLOCATION URL=NewWebPage.cfm . [EMAIL PROTECTED] 01/13/03 11:52AM I'm setting up authentication against a database, and I have the form data going to a seperate page that I want users not to see (just a preference of mine)...Once the page is done processing, I want to push the users off to a different page...How do I do that? Are there any CF tags for it? Thank you, Scott PS. I'm very wet behind my ears, so if there's some tricks for authenticating against a db, please feel free to tell me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I redirect a user?
Look into the CFLOCATION tag. It does exactly what you're looking for (redirection). -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:52 AM To: CF-Talk Subject: How can I redirect a user? I'm setting up authentication against a database, and I have the form data going to a seperate page that I want users not to see (just a preference of mine)...Once the page is done processing, I want to push the users off to a different page...How do I do that? Are there any CF tags for it? Thank you, Scott PS. I'm very wet behind my ears, so if there's some tricks for authenticating against a db, please feel free to tell me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I redirect a user?
Scott, Some folks use the CFLOCATION tag for this redirect. I found a conflict with using this in the same page with an input of type=file. I prefer to use a little js on this script location.href('mypage.cfm'); /script Cutter Scott Wilhelm wrote: I'm setting up authentication against a database, and I have the form data going to a seperate page that I want users not to see (just a preference of mine)...Once the page is done processing, I want to push the users off to a different page...How do I do that? Are there any CF tags for it? Thank you, Scott PS. I'm very wet behind my ears, so if there's some tricks for authenticating against a db, please feel free to tell me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I redirect a user?
CFLOCATION depending on what you are doing on that page. I hate that you can not use cookies on the same page that you use a CFLOCATION. Robert Bailey [EMAIL PROTECTED] Famous for nothing! http://www.tinetics.com -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:00 AM To: CF-Talk Subject: RE: How can I redirect a user? cflocation url=yourWebsite.cfm ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:52 AM To: CF-Talk Subject: How can I redirect a user? I'm setting up authentication against a database, and I have the form data going to a seperate page that I want users not to see (just a preference of mine)...Once the page is done processing, I want to push the users off to a different page...How do I do that? Are there any CF tags for it? Thank you, Scott PS. I'm very wet behind my ears, so if there's some tricks for authenticating against a db, please feel free to tell me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP!!!! jrun-resources.xml
Tony Weeg wrote: excellent jochem, now here is what I get Connection verification failed for data source: Platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.. Any particular reason why you are using the ODBC bridge instead of the MS Type 4 drivers? What happens if you just specify u/p with the cfquery tag? Are you sure the server is not set to named pipes only? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?)
SQL Server has bcp, which let's you dump tables with a fair degree of control over format -- I'd bet Sybase has something similar. Or you could use DTS in MSSQL to do an export to Sybase. Both of those save writing queries :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 11:32 AM Subject: RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?) I got CFMXJ2EE/JRun4/Sybase_ASE up and running on my Mac ... Seems to work pretty well, now if someone only made a utility that would allow me to move data from SQL Server to Sybase without having to write queries. Yes, I AM lazy - thank you very much. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Roberson, Jeff, Mr (Contractor) ACI [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:20 AM To: CF-Talk Subject: RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?) You can also run virtualPC with windows for mac to get the SQL server http://store.apple.com/1-800-MY-APPLE/WebObjects/AppleStore.woa/98/wo/VF 67Rc 18Gpi42MkkyAbB0CAsg2i/2.4.0.3.27.10.11.5.13.0 But I agree you will need lots of ram -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:11 AM To: CF-Talk Subject: Emulators/VMWare for Mac (WAS: Re: Unix database syntactically similar to SQL Server?) Requirements for VMWare (for Linux) are remarkable low, but you need a *lot* of memory, decent disk space, and solid processor. I run Linux and Windows emulations under Windows 2000 with 512MB and PIII/500 -- but like it better on the P4 1+ GHz and 1 GB RAM. Did a little research and not a solution (obviously) for Mac. Looks like x86 architecture is part of the lowlevel emulation -- not that I know anything about hardware emulation in software :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:54 AM Subject: RE: Unix database syntactically similar to SQL Server? I wonder what kind of system specs would be required to run an emulator, MS SQL Server, CFMXJ2EE, JRun4 and Jedit on a Mac? Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ** ** * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:12 AM To: CF-Talk Subject: Re: Unix database syntactically similar to SQL Server? On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter wrote: So does VMWare for Linux run under MacOSX? Now *that* would be a solution :) VirtualPC emulates a PC and runs on OS X. Right. But VMWare let's you install *lots* of OS's -- most *nix, most Win, even Solaris if you're a glutton for install punishment. With VMWare, you could run a virtual Win2k Server instance on your Mac and use it for the db part of the development. Dick ~|
Re: How can I redirect a user?
There are several login tags available, but the best way is to just have a page that loggs the user in. I normally use a page called Login.cfm. All this page does is, checks the users information that they posted on the login form against the database, and if they are valid, I set some application level variables and the like, then redirect them to the appropriate page. If they do not have a account or did not enter their infrmation correctly, they are redirected to the login page with a message of what they did wrong. So for instance, the code could look like this: Validate the user againstthe database cfquery datasource=#Application.DSN# Name=qry_CheckUser Select Fname, Lname, UserID, Password From Users Where #TRIM(Users.UserID = Form.UserID)# AND #TRIM(Password = Form.Password) /cfquery Check to see if the information is valid cfif (qry_CheckUser.Recordcount) IS 1 set application, session or client variables here and redirect them with cflocation cfelse Set error message to display and send them back to the login page displaying the error message. /cfif This is a very simplified login routine. Like I said, there are several out there on the Developers Exchange. Just do a search for Login. - Original Message - From: Scott Wilhelm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:52 AM Subject: How can I redirect a user? I'm setting up authentication against a database, and I have the form data going to a seperate page that I want users not to see (just a preference of mine)...Once the page is done processing, I want to push the users off to a different page...How do I do that? Are there any CF tags for it? Thank you, Scott PS. I'm very wet behind my ears, so if there's some tricks for authenticating against a db, please feel free to tell me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SmartCard Enabled Websites?
Is it possible to SmartCard enable a website? I've got a customer requiring that we support SmartCard devices - I was under the impression SmartCard website authentication happened at the workstation level using software to control user access to specific sites. Is this not the case? Is there actual code to integrate into an application to make it SmartCard aware? Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP!!!! jrun-resources.xml
Are you using NTAuth or SQL auth to get in? As a quick test, create a datasource that uses the sa -- that verifies that SQL Auth is working correctly and the db is accessible. Then try connecting using NTAuth with whatever account you personally use to connect to the database (through things like Enterprise Manager or Query Analyzer). That login \ usually means something is messed up with NTAuth. Another quick check, you can do an admin-level share between the web server to the sql box using an account with sql permissions -- that will handle a bad set of credentials. Note that none of these are long-term solutions -- just ways to check/address the connectivity -- you want to isolate problem and of course fix it -- leaving CF connecting as SA can be bad news! Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 11:58 AM Subject: RE: HELP jrun-resources.xml in my odbc connection, system dsn that I am setting up through windows I am using my correct login info, not \ as the usernameWTF ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:56 AM To: CF-Talk Subject: RE: HELP jrun-resources.xml excellent jochem, now here is what I get Connection verification failed for data source: Platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:48 AM To: CF-Talk Subject: Re: HELP jrun-resources.xml Tony Weeg wrote: thanks dina, but this is now what im getting Connection verification failed for data source: platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602Method=Full And if you get a 'cannot establish socket' error use telnet to verify the SQL server is actually listening. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP!!!! jrun-resources.xml
on the server that is running my cfmx, I can make an odbc connection from windows to the other server that is running the sql server, test the datasource and all is well. the sql server is setup for mixed mode auth, and I am using a user/pass that I have and can verify. Connection verification failed for data source: Platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'platypus_admin'. Reason: Not associated with a trusted SQL Server connection.. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'platypus_admin'. Reason: Not associated with a trusted SQL Server connection.. is now the error I am gettingsome trusted server bs, that wasn't there just 12 hours ago before we made the changes!! so its like, nothing make sense. the cfmx server connects to other db's, the only diff is that the other sql servers are sql2000 not sql7 and of course, that they are on different machines. what in the heck could this possibly be? this is really making no effing sense!! oh, and no matter what dsn or datasource or user/pass combo I try nothing to that machine comes out ok, I get the same error regardless of the datasource name, etc...i have tried this from 2 production servers and 2 development machines, all to no availand the same error, the 2 dev servers have cfmx updater 2, the production servers have cfmx updater 1, so its not that either. any ideas? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 12:14 PM To: CF-Talk Subject: Re: HELP jrun-resources.xml Are you using NTAuth or SQL auth to get in? As a quick test, create a datasource that uses the sa -- that verifies that SQL Auth is working correctly and the db is accessible. Then try connecting using NTAuth with whatever account you personally use to connect to the database (through things like Enterprise Manager or Query Analyzer). That login \ usually means something is messed up with NTAuth. Another quick check, you can do an admin-level share between the web server to the sql box using an account with sql permissions -- that will handle a bad set of credentials. Note that none of these are long-term solutions -- just ways to check/address the connectivity -- you want to isolate problem and of course fix it -- leaving CF connecting as SA can be bad news! Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 11:58 AM Subject: RE: HELP jrun-resources.xml in my odbc connection, system dsn that I am setting up through windows I am using my correct login info, not \ as the usernameWTF ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:56 AM To: CF-Talk Subject: RE: HELP jrun-resources.xml excellent jochem, now here is what I get Connection verification failed for data source: Platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:48 AM To: CF-Talk Subject: Re: HELP jrun-resources.xml Tony Weeg wrote: thanks dina, but this is now what im getting Connection verification failed for data source: platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to
Re: cfoutput formatting
Set a number (cfset count = 1) and increment it every time the query runs. Every time the number is equal to 4, set it back to 1 and output a /trtr Hope that makes sense, too lazy to write code! Ryan On 13/1/03 17:00, Jeremy Bunton [EMAIL PROTECTED] wrote: I have an output block that looks like so, tr tdimg src=images/spacer.gif width=71 height=1 alt= border=0/td cfoutput query=getclients td valign=top width=26 class=copyinput class=copy name=theid type=checkbox value=#id#/td td valign=top width=200 class=copy#UCase(cusername)#br(#cpassword#)/td /cfoutput tdimg src=images/spacer.gif width=85 height=1 alt= border=0/td /tr After the cfoutput kicks out 4 records I need a new tr/tr to be created and then show the next 4 records in 4 more td's and so forth instead of getting one row with 120 cells in it. Maybe something with the cfoutputs on the out side of the tr and a loop inside or something. JLB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I redirect a user?
Yeah, with MX development I have been using their security, but I have usually rolled my own. I am also not in the habit of using multiple pages in my applications, usually a form of fusebox. I guess it is really how you feel comftable doing it, I am just not very fond of CFLOCATION at all, I use it to direct to downloads, that is about it, and only so the end user does not see the location of the file usually. Robert Bailey [EMAIL PROTECTED] Famous for nothing! http://www.tinetics.com -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:08 AM To: CF-Talk Subject: Re: How can I redirect a user? There are several login tags available, but the best way is to just have a page that loggs the user in. I normally use a page called Login.cfm. All this page does is, checks the users information that they posted on the login form against the database, and if they are valid, I set some application level variables and the like, then redirect them to the appropriate page. If they do not have a account or did not enter their infrmation correctly, they are redirected to the login page with a message of what they did wrong. So for instance, the code could look like this: Validate the user againstthe database cfquery datasource=#Application.DSN# Name=qry_CheckUser Select Fname, Lname, UserID, Password From Users Where #TRIM(Users.UserID = Form.UserID)# AND #TRIM(Password = Form.Password) /cfquery Check to see if the information is valid cfif (qry_CheckUser.Recordcount) IS 1 set application, session or client variables here and redirect them with cflocation cfelse Set error message to display and send them back to the login page displaying the error message. /cfif This is a very simplified login routine. Like I said, there are several out there on the Developers Exchange. Just do a search for Login. - Original Message - From: Scott Wilhelm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:52 AM Subject: How can I redirect a user? I'm setting up authentication against a database, and I have the form data going to a seperate page that I want users not to see (just a preference of mine)...Once the page is done processing, I want to push the users off to a different page...How do I do that? Are there any CF tags for it? Thank you, Scott PS. I'm very wet behind my ears, so if there's some tricks for authenticating against a db, please feel free to tell me. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfoutput formatting
I use mod to do this... table tr cfoutput query=getReviews td #UCase(cusername)#br(#cpassword#) cfif (currentRow mod 4) eq 0 /tr tr /cfif /cfoutput /tr /table On 13/1/03 17:00, Jeremy Bunton [EMAIL PROTECTED] wrote: I have an output block that looks like so, tr tdimg src=images/spacer.gif width=71 height=1 alt= border=0/td cfoutput query=getclients td valign=top width=26 class=copyinput class=copy name=theid type=checkbox value=#id#/td td valign=top width=200 class=copy#UCase(cusername)#br(#cpassword#)/td /cfoutput tdimg src=images/spacer.gif width=85 height=1 alt= border=0/td /tr After the cfoutput kicks out 4 records I need a new tr/tr to be created and then show the next 4 records in 4 more td's and so forth instead of getting one row with 120 cells in it. Maybe something with the cfoutputs on the out side of the tr and a loop inside or something. JLB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Design Pattern Question
Using Fusebox in conjunction with FLIP we have a complete application design and development environment from concept-discussion through coding-ongoing maintenance. There is one last very important point here, there have been many previous methodologies/frameworks applied to ColdFusion development. What is different in Fusebox is it has become the most widely used of all of them and that is a very considerable factor for those of us using teams of developers that can change, grow, shrink etc. Mike makes good points, but one of the key distinctions is that of *methodology* vs. *framework*. No question that Fusebox is a usefull framework (though one could argue it's incomplete since it's missing things like security, etc. That's a separate point). and that FLIP is a useful methodology. Methodologies can be religious wars -- XP vs RUP vs FLIP vs Agile vs whatever. I think most people take the useful parts and synthesize their own. Really good design/dev teams do this explicitly (e.g. we'll take A from XP and B, C, and D from FLIP, but also integrate E from RUP and this other cool methodology I like) Frameworks, which have their own religious wars, IMHO are much easier to judge on technical merits than methodologies (which can only be truly measured by results). In the Java world, there's Struts. There's velocity/turbine/torque. There's others, I certainly don't have the definitive list! But in the ASP/CF/PHP world, there's not really any solid frameworks other than Fusebox. And I like the way the new FB is headed -- it is much more of a framework than a set of guidelines (like FB2 basically was). MM's produced some pretty cool tools/services for building more robut frameworks in CF. I think the stuff at benorama is cool, but it's not really a framework (it's sorta like FB2 in that it's guidelines and a few tools). Fusebox has certainly become a defacto standard for CF frameworks, which is a good thing. But just like the Java world has room for several different frameworks, so does the CF world. Looking forward to seeing what's coming down the pike this year :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL7 DB Update Procedure
Make your datasource a variable defined in the application.cfm. Switch the datasource between databases as needed by changing the application.cfm. It will not matter if the databases are on the same machine or not as they can have different names and you can change what CF is looking at very easily. Justin -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:16 AM To: CF-Talk Subject: SQL7 DB Update Procedure The on-line database of listings, etc, at www.SMARTERYellowpages.com , Biz1, is read-only in normal operation. The off-line database, Biz2, is not read-only in normal operation, and it is currently updated daily on a backup machine, including automatic backup, and updating of full-text indexes (SQL7). It's backup is used to update Biz1. Since the 2 databases are on different machines, they can and do have the same name. Updating of Biz1 is a simple restore using the most recent Biz2 backup, followed by updating the full-text index. Is there a way to have Biz1 Biz2 on the same machine, and: To update Biz1, switch Biz2 to read-only. Switch www.SMARTERyellwpages.com to read from Biz2 instead of Biz1 Update Biz1 using the latest backup of Biz2. I haven't tried this but I wonder how to work around the difference DB names - or even if the name difference matters. best, paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP!!!! jrun-resources.xml
I second Joachem -- use the Type IV driver -- not the ODBC/JDBC bridge. But that aside, if you're getting trusted server errors, it's all about permissions. Try sharing a drive using the sql admin account (domain admin is optimal) from the cfmx box to the sql server. That should create a trusted connection. I'd check to make sure that all the relevant services are still running as you originally had them -- that if you ran CF and SQL as named users, that the scripts on install didn't flip them back to LocalSystem for some crazy reason. Another thing you could check -- log onto the CFMX box as the account you're using to connect to SQLServer (assuming NTauth) or running the SQL Server service as (assuming standard auth) and make sure you can validate against the domain. Not a likely thing to have changed, but I've seen weirder. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 12:26 PM Subject: RE: HELP jrun-resources.xml on the server that is running my cfmx, I can make an odbc connection from windows to the other server that is running the sql server, test the datasource and all is well. the sql server is setup for mixed mode auth, and I am using a user/pass that I have and can verify. Connection verification failed for data source: Platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'platypus_admin'. Reason: Not associated with a trusted SQL Server connection.. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'platypus_admin'. Reason: Not associated with a trusted SQL Server connection.. is now the error I am gettingsome trusted server bs, that wasn't there just 12 hours ago before we made the changes!! so its like, nothing make sense. the cfmx server connects to other db's, the only diff is that the other sql servers are sql2000 not sql7 and of course, that they are on different machines. what in the heck could this possibly be? this is really making no effing sense!! oh, and no matter what dsn or datasource or user/pass combo I try nothing to that machine comes out ok, I get the same error regardless of the datasource name, etc...i have tried this from 2 production servers and 2 development machines, all to no availand the same error, the 2 dev servers have cfmx updater 2, the production servers have cfmx updater 1, so its not that either. any ideas? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 12:14 PM To: CF-Talk Subject: Re: HELP jrun-resources.xml Are you using NTAuth or SQL auth to get in? As a quick test, create a datasource that uses the sa -- that verifies that SQL Auth is working correctly and the db is accessible. Then try connecting using NTAuth with whatever account you personally use to connect to the database (through things like Enterprise Manager or Query Analyzer). That login \ usually means something is messed up with NTAuth. Another quick check, you can do an admin-level share between the web server to the sql box using an account with sql permissions -- that will handle a bad set of credentials. Note that none of these are long-term solutions -- just ways to check/address the connectivity -- you want to isolate problem and of course fix it -- leaving CF connecting as SA can be bad news! Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 11:58 AM Subject: RE: HELP jrun-resources.xml in my odbc connection, system dsn that I am setting up through windows I am using my correct login info, not \ as the usernameWTF ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:56 AM To: CF-Talk Subject: RE: HELP jrun-resources.xml excellent jochem, now here is what I get Connection verification failed for data source: Platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect:
RE: HELP!!!! jrun-resources.xml
where does this TYPE IV driver come from where can I get it? or is it just the sql server driver that comes in the drop down? thanks ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 12:46 PM To: CF-Talk Subject: Re: HELP jrun-resources.xml I second Joachem -- use the Type IV driver -- not the ODBC/JDBC bridge. But that aside, if you're getting trusted server errors, it's all about permissions. Try sharing a drive using the sql admin account (domain admin is optimal) from the cfmx box to the sql server. That should create a trusted connection. I'd check to make sure that all the relevant services are still running as you originally had them -- that if you ran CF and SQL as named users, that the scripts on install didn't flip them back to LocalSystem for some crazy reason. Another thing you could check -- log onto the CFMX box as the account you're using to connect to SQLServer (assuming NTauth) or running the SQL Server service as (assuming standard auth) and make sure you can validate against the domain. Not a likely thing to have changed, but I've seen weirder. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 12:26 PM Subject: RE: HELP jrun-resources.xml on the server that is running my cfmx, I can make an odbc connection from windows to the other server that is running the sql server, test the datasource and all is well. the sql server is setup for mixed mode auth, and I am using a user/pass that I have and can verify. Connection verification failed for data source: Platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'platypus_admin'. Reason: Not associated with a trusted SQL Server connection.. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'platypus_admin'. Reason: Not associated with a trusted SQL Server connection.. is now the error I am gettingsome trusted server bs, that wasn't there just 12 hours ago before we made the changes!! so its like, nothing make sense. the cfmx server connects to other db's, the only diff is that the other sql servers are sql2000 not sql7 and of course, that they are on different machines. what in the heck could this possibly be? this is really making no effing sense!! oh, and no matter what dsn or datasource or user/pass combo I try nothing to that machine comes out ok, I get the same error regardless of the datasource name, etc...i have tried this from 2 production servers and 2 development machines, all to no availand the same error, the 2 dev servers have cfmx updater 2, the production servers have cfmx updater 1, so its not that either. any ideas? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 12:14 PM To: CF-Talk Subject: Re: HELP jrun-resources.xml Are you using NTAuth or SQL auth to get in? As a quick test, create a datasource that uses the sa -- that verifies that SQL Auth is working correctly and the db is accessible. Then try connecting using NTAuth with whatever account you personally use to connect to the database (through things like Enterprise Manager or Query Analyzer). That login \ usually means something is messed up with NTAuth. Another quick check, you can do an admin-level share between the web server to the sql box using an account with sql permissions -- that will handle a bad set of credentials. Note that none of these are long-term solutions -- just ways to check/address the connectivity -- you want to isolate problem and of course fix it -- leaving CF connecting as SA can be bad news! Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 11:58 AM Subject: RE: HELP jrun-resources.xml in my odbc connection, system dsn that I am setting up through windows I am using my correct login info, not \ as the usernameWTF ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer
web beacons
Yahoo is using something called web beacons. Can anyone simply explain how a single pixel gif is used as a web beacon. http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: web beacons
At 11:51 AM 1/13/2003, you wrote: Yahoo is using something called web beacons. Can anyone simply explain how a single pixel gif is used as a web beacon. http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian Is that the same thing as a web bug? You load an image off another server and in addition to sending back the image it also retrieves/sets cookies. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ASP to ColdFusion
I'm originally an ASP developer now working with ColdFusion...Does anyone know of any resources that would help in the conversion? (ASP-CF translations, tutorials, etc.) Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: web beacons
Everytime the image is requested on a page it counts as a hit (increments a counter) On 13/1/03 17:51, sebastian palmigiani [EMAIL PROTECTED] wrote: Yahoo is using something called web beacons. Can anyone simply explain how a single pixel gif is used as a web beacon. http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
Easy. cfcontent file=foo.gif type=application/whatever cfquery datasource=#application.ds# ...tracking query here... /cfquery You include the image, and some server-side code to process it. Done it a few times... -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:52 AM To: CF-Talk Subject: web beacons Yahoo is using something called web beacons. Can anyone simply explain how a single pixel gif is used as a web beacon. http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
I have used them before, to track the users, you pretty much refrence the image, and when reading your logfile you can single that one out and count your hits. I have also done things such as refrence an image that did not exist, with a 1x1 h and w attrib, and added the page dynamically to the end, and was able to watch the pages. Such as IMG SRC=nothing.gif?index.cfm or whatever. I have not done that in a while, though, but is helpful sometimes, especially if you want to track other websites that are not on your server. We have also set up a monitoring application before, where the website took .jpg images and processed them through the CF engine, so the actual jpg files were plain CFM text. We did it this way so that when we did have a subscription list, we could see who opened their emails, since we could refrence the image like IMG SRC=yadda.jpg?[EMAIL PROTECTED], which we put at the bottom of all our emails that we had on our list. We did this because most of the email clients out their would not accept an image src of anything that ended in CFM or ASP, etc..., so this was our work around. You could set cookies this way as well, since there is a header passed. You can use a regular page and make the image source a CFM page, just not in emails because of how the clients handle them. I think this was a little long winded, so sorry and probably just made a mess of my answer. Robert Bailey [EMAIL PROTECTED] Famous for nothing! http://www.tinetics.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:52 AM To: CF-Talk Subject: web beacons Yahoo is using something called web beacons. Can anyone simply explain how a single pixel gif is used as a web beacon. http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ASP to ColdFusion
Woo hoo... Another convert :-) A quick search on google gets some good introductury tutorials... http://hotwired.lycos.com/webmonkey/programming/coldfusion/tutorials/tutoria l2.html http://www.macromedia.com/support/coldfusion/tutorial_index.html http://kongtechnology.com/index.asp?im=cf1 -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:53 AM To: CF-Talk Subject: ASP to ColdFusion I'm originally an ASP developer now working with ColdFusion...Does anyone know of any resources that would help in the conversion? (ASP-CF translations, tutorials, etc.) Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
Yahoo is using something called web beacons. Can anyone simply explain how a single pixel gif is used as a web beacon. http://privacy.yahoo.com/privacy/us/pixels/details.html It's actually pretty simple, although I found it confusing too. And, while Yahoo calls them web beacons, which sounds very nice and acceptable, most people call them web bugs. Let's say I write a web page, and put it on my web server. Within my web page, I include an IMG tag pointing to a GIF on another server. You then enter the URL to my page in your browser, and view my web page. Your browser will, as part of the process, fetch the GIF from the other server. The other server can keep track of these requests, and set cookies on your browser. You might find this interesting and useful: http://www.eff.org/Privacy/Marketing/web_bug.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP!!!! jrun-resources.xml
The dropdown SQL Server is the native (OEM'ed Merant) java driver for MSSQL -- the ODBC Socket choice is the JDBC/ODBC bridge. Of course, using JDBC/ODBC bridge means you can test using ODBC :) You need a JDBC app to test JDBC connectivity. Hey -- as an side, when you say the ODBC connection work, are you simply using the Test Datasource in the MSSQL ODBC setup? I don't remember all the details, but it's not a complete test -- it's more like a ping (yes, there's a sql server there) than a real test (yes, login is successful). Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 12:50 PM Subject: RE: HELP jrun-resources.xml where does this TYPE IV driver come from where can I get it? or is it just the sql server driver that comes in the drop down? thanks ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 12:46 PM To: CF-Talk Subject: Re: HELP jrun-resources.xml I second Joachem -- use the Type IV driver -- not the ODBC/JDBC bridge. But that aside, if you're getting trusted server errors, it's all about permissions. Try sharing a drive using the sql admin account (domain admin is optimal) from the cfmx box to the sql server. That should create a trusted connection. I'd check to make sure that all the relevant services are still running as you originally had them -- that if you ran CF and SQL as named users, that the scripts on install didn't flip them back to LocalSystem for some crazy reason. Another thing you could check -- log onto the CFMX box as the account you're using to connect to SQLServer (assuming NTauth) or running the SQL Server service as (assuming standard auth) and make sure you can validate against the domain. Not a likely thing to have changed, but I've seen weirder. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 12:26 PM Subject: RE: HELP jrun-resources.xml on the server that is running my cfmx, I can make an odbc connection from windows to the other server that is running the sql server, test the datasource and all is well. the sql server is setup for mixed mode auth, and I am using a user/pass that I have and can verify. Connection verification failed for data source: Platypus []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'platypus_admin'. Reason: Not associated with a trusted SQL Server connection.. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'platypus_admin'. Reason: Not associated with a trusted SQL Server connection.. is now the error I am gettingsome trusted server bs, that wasn't there just 12 hours ago before we made the changes!! so its like, nothing make sense. the cfmx server connects to other db's, the only diff is that the other sql servers are sql2000 not sql7 and of course, that they are on different machines. what in the heck could this possibly be? this is really making no effing sense!! oh, and no matter what dsn or datasource or user/pass combo I try nothing to that machine comes out ok, I get the same error regardless of the datasource name, etc...i have tried this from 2 production servers and 2 development machines, all to no availand the same error, the 2 dev servers have cfmx updater 2, the production servers have cfmx updater 1, so its not that either. any ideas? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 12:14 PM To: CF-Talk Subject: Re: HELP jrun-resources.xml Are you using NTAuth or SQL auth to get in? As a quick test, create a datasource that uses the sa -- that verifies that SQL Auth is working correctly and the db is accessible. Then try connecting using NTAuth with whatever account you personally use to connect to the database (through things like Enterprise Manager or Query Analyzer). That login \ usually means something is messed
Re: web beacons
Hmm, well I'd tell ya to go to http://www.depressedpress.com, but the site seems to be majorly broken. - Original Message - From: sebastian palmigiani [EMAIL PROTECTED] Date: Monday, January 13, 2003 10:51 am Subject: web beacons Yahoo is using something called web beacons. Can anyone simply explain how a single pixel gif is used as a web beacon. http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
Oh yeah, and you can pass url parameters to that image as well... So let's say you send an email to employeeid 145. You can add a parameter the the src of the gif file in the html email you send him as such: img src=http://www.myserver.com/image.cfm?id=145; Then in the source... Of image.cfm, something like this appears: cfcontent file=foo.gif type=application/whatever cfquery datasource=#application.ds# insert into someTable (employeeid, date) values (#val(url.id)#, getdate()) /cfquery -Original Message- From: Costas Piliotis Sent: Monday, January 13, 2003 10:00 AM To: CF-Talk Subject: RE: web beacons Easy. cfcontent file=foo.gif type=application/whatever cfquery datasource=#application.ds# ...tracking query here... /cfquery You include the image, and some server-side code to process it. Done it a few times... -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:52 AM To: CF-Talk Subject: web beacons Yahoo is using something called web beacons. Can anyone simply explain how a single pixel gif is used as a web beacon. http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfoutput formatting
I use mod to do this... table tr cfoutput query=getReviews td #UCase(cusername)#br(#cpassword#) cfif (currentRow mod 4) eq 0 /tr tr /cfif /cfoutput /tr /table (I think you're missing the closing /td tag) One suggestion I'd add to the above is after you get out of the loop, you might need to pad the last row if the query doesn't return a multiple of 4 rows: cfif (currentRow mod 4) eq 0 /tr tr /cfif /cfoutput !--- This should get you the number of cells you need to add -- cfset padCells = 4 - getReview.RecordCount MOD 4 cfif padCells LT 4 cfloop from=1 to=#padCells# td nbsp; /td /cfloop /cfif /tr /table Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query help!
Can someone tell me what's wrong with this line: CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#formatdate(now(),mm-dd-yy)# /CFQUERY I can't figure out how to get a date query to work right... Thanks, Scott -Original Message- From: Costas Piliotis Sent: Mon 01/13/2003 01:01 PM To: CF-Talk Cc: Subject: RE: ASP to ColdFusion Woo hoo... Another convert :-) A quick search on google gets some good introductury tutorials... http://hotwired.lycos.com/webmonkey/programming/coldfusion/tutorials/tut oria l2.html http://www.macromedia.com/support/coldfusion/tutorial_index.html http://kongtechnology.com/index.asp?im=cf1 -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:53 AM To: CF-Talk Subject: ASP to ColdFusion I'm originally an ASP developer now working with ColdFusion...Does anyone know of any resources that would help in the conversion? (ASP-CF translations, tutorials, etc.) Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfoutput formatting
cfif [queryname].currentrow mod 4 is 0 /tr tr /cfif Cutter Ryan Mitchell wrote: Set a number (cfset count = 1) and increment it every time the query runs. Every time the number is equal to 4, set it back to 1 and output a /trtr Hope that makes sense, too lazy to write code! Ryan On 13/1/03 17:00, Jeremy Bunton [EMAIL PROTECTED] wrote: I have an output block that looks like so, tr tdimg src=images/spacer.gif width=71 height=1 alt= border=0/td cfoutput query=getclients td valign=top width=26 class=copyinput class=copy name=theid type=checkbox value=#id#/td td valign=top width=200 class=copy#UCase(cusername)#br(#cpassword#)/td /cfoutput tdimg src=images/spacer.gif width=85 height=1 alt= border=0/td /tr After the cfoutput kicks out 4 records I need a new tr/tr to be created and then show the next 4 records in 4 more td's and so forth instead of getting one row with 120 cells in it. Maybe something with the cfoutputs on the out side of the tr and a loop inside or something. JLB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query help!
I got it...I've gotta figure out a way to get ASP out of my head...lol Scott -Original Message- From: Scott Wilhelm Sent: Mon 01/13/2003 01:02 PM To: CF-Talk Cc: Subject: Query help! Can someone tell me what's wrong with this line: CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#formatdate(now(),mm-dd-yy)# /CFQUERY I can't figure out how to get a date query to work right... Thanks, Scott -Original Message- From: Costas Piliotis Sent: Mon 01/13/2003 01:01 PM To: CF-Talk Cc: Subject: RE: ASP to ColdFusion Woo hoo... Another convert :-) A quick search on google gets some good introductury tutorials... http://hotwired.lycos.com/webmonkey/programming/coldfusion/tutorials/tut oria l2.html http://www.macromedia.com/support/coldfusion/tutorial_index.html http://kongtechnology.com/index.asp?im=cf1 -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:53 AM To: CF-Talk Subject: ASP to ColdFusion I'm originally an ASP developer now working with ColdFusion...Does anyone know of any resources that would help in the conversion? (ASP-CF translations, tutorials, etc.) Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query help!
try cfquery name=previousDates datasource=calendar SELECT * FROM events WHERE eDate cfqueryparam value=createODBCDate(now()); /cfquery (assuming your eDate field is a date/time datatype...i don't think you'd need a dateFormat() function) hth, charlie Scott Wilhelm writes: Can someone tell me what's wrong with this line: CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#formatdate(now(),mm-dd-yy)# /CFQUERY I can't figure out how to get a date query to work right... Thanks, Scott -Original Message- From: Costas Piliotis Sent: Mon 01/13/2003 01:01 PM To: CF-Talk Cc: Subject: RE: ASP to ColdFusion Woo hoo... Another convert :-) A quick search on google gets some good introductury tutorials... http://hotwired.lycos.com/webmonkey/programming/coldfusion/tutorials/tut oria l2.html http://www.macromedia.com/support/coldfusion/tutorial_index.html http://kongtechnology.com/index.asp?im=cf1 -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:53 AM To: CF-Talk Subject: ASP to ColdFusion I'm originally an ASP developer now working with ColdFusion...Does anyone know of any resources that would help in the conversion? (ASP-CF translations, tutorials, etc.) Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query help!
Instead of dateformat try createodbcdate(now()) Cutter Scott Wilhelm wrote: Can someone tell me what's wrong with this line: CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#formatdate(now(),mm-dd-yy)# /CFQUERY I can't figure out how to get a date query to work right... Thanks, Scott -Original Message- From: Costas Piliotis Sent: Mon 01/13/2003 01:01 PM To: CF-Talk Cc: Subject: RE: ASP to ColdFusion Woo hoo... Another convert :-) A quick search on google gets some good introductury tutorials... http://hotwired.lycos.com/webmonkey/programming/coldfusion/tutorials/tut oria l2.html http://www.macromedia.com/support/coldfusion/tutorial_index.html http://kongtechnology.com/index.asp?im=cf1 -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:53 AM To: CF-Talk Subject: ASP to ColdFusion I'm originally an ASP developer now working with ColdFusion...Does anyone know of any resources that would help in the conversion? (ASP-CF translations, tutorials, etc.) Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query help!
Assuming that your running from a SQLServer or access DB (although it should work with mysql) try CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#now()# CFSQLTYPE=CF_SQL_TIMESTAMP /CFQUERY HTH -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 18:02 To: CF-Talk Subject: Query help! Can someone tell me what's wrong with this line: CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#formatdate(now(),mm-dd-yy)# /CFQUERY I can't figure out how to get a date query to work right... Thanks, Scott -Original Message- From: Costas Piliotis Sent: Mon 01/13/2003 01:01 PM To: CF-Talk Cc: Subject: RE: ASP to ColdFusion Woo hoo... Another convert :-) A quick search on google gets some good introductury tutorials... http://hotwired.lycos.com/webmonkey/programming/coldfusion/tutorials/tut oria l2.html http://www.macromedia.com/support/coldfusion/tutorial_index.html http://kongtechnology.com/index.asp?im=cf1 -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:53 AM To: CF-Talk Subject: ASP to ColdFusion I'm originally an ASP developer now working with ColdFusion...Does anyone know of any resources that would help in the conversion? (ASP-CF translations, tutorials, etc.) Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query help!
Please look at the help docs for cfqueryparam. It takes at least two params, one for value and another for type. You should specify the type. Also note that you don't have to format the date when passing to cfqueryparam. Best regards, Sam BTW, a lot of people don't use cfqueryparam until they have worked with CF for a while. I'm glad to see you're doing things the right way from the outset (that was your post about being a recent convert from ASP, right?). At 01:02 PM 1/13/2003, you wrote: Can someone tell me what's wrong with this line: CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#formatdate(now(),mm-dd-yy)# /CFQUERY I can't figure out how to get a date query to work right... Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
Yep.. One of the ways that spammers, these days, collect info on valid email addresses when using HTML email campaigns. You simply view the email, and BAM.. they know your email address is good. Old news | -Original Message- | From: Costas Piliotis [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 10:04 AM | To: CF-Talk | Subject: RE: web beacons | | | Oh yeah, and you can pass url parameters to that image as | well... So let's say you send an email to employeeid 145. | | You can add a parameter the the src of the gif file in the | html email you send him as such: | | img src=http://www.myserver.com/image.cfm?id=145; | | Then in the source... Of image.cfm, something like this | appears: cfcontent file=foo.gif | type=application/whatever cfquery datasource=#application.ds# | insert into someTable (employeeid, date) | values (#val(url.id)#, getdate()) | /cfquery | | -Original Message- | From: Costas Piliotis | Sent: Monday, January 13, 2003 10:00 AM | To: CF-Talk | Subject: RE: web beacons | | | Easy. | | cfcontent file=foo.gif type=application/whatever | cfquery datasource=#application.ds# | ...tracking query here... | /cfquery | | You include the image, and some server-side code to process | it. Done it a few times... | | -Original Message- | From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 9:52 AM | To: CF-Talk | Subject: web beacons | | | Yahoo is using something called web beacons. Can anyone | simply explain how a single pixel gif is used as a web beacon. | http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Query help!
CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#createODBCDateTime(now())# type=cf_sql_timestamp /CFQUERY -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 10:21 AM To: CF-Talk Subject: Re: Query help! Please look at the help docs for cfqueryparam. It takes at least two params, one for value and another for type. You should specify the type. Also note that you don't have to format the date when passing to cfqueryparam. Best regards, Sam BTW, a lot of people don't use cfqueryparam until they have worked with CF for a while. I'm glad to see you're doing things the right way from the outset (that was your post about being a recent convert from ASP, right?). At 01:02 PM 1/13/2003, you wrote: Can someone tell me what's wrong with this line: CFQUERY name=PreviousDates datasource=calendar SELECT * FROM Events WHERE eDate CFQUERYPARAM value=#formatdate(now(),mm-dd-yy)# /CFQUERY I can't figure out how to get a date query to work right... Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?)
You should be able to use DTS on the SQL server through ODBC to copy the databases. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:32 AM To: CF-Talk Subject: RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?) I got CFMXJ2EE/JRun4/Sybase_ASE up and running on my Mac ... Seems to work pretty well, now if someone only made a utility that would allow me to move data from SQL Server to Sybase without having to write queries. Yes, I AM lazy - thank you very much. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Roberson, Jeff, Mr (Contractor) ACI [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:20 AM To: CF-Talk Subject: RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?) You can also run virtualPC with windows for mac to get the SQL server http://store.apple.com/1-800-MY-APPLE/WebObjects/AppleStore.woa/98/wo/VF 67Rc 18Gpi42MkkyAbB0CAsg2i/2.4.0.3.27.10.11.5.13.0 But I agree you will need lots of ram -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:11 AM To: CF-Talk Subject: Emulators/VMWare for Mac (WAS: Re: Unix database syntactically similar to SQL Server?) Requirements for VMWare (for Linux) are remarkable low, but you need a *lot* of memory, decent disk space, and solid processor. I run Linux and Windows emulations under Windows 2000 with 512MB and PIII/500 -- but like it better on the P4 1+ GHz and 1 GB RAM. Did a little research and not a solution (obviously) for Mac. Looks like x86 architecture is part of the lowlevel emulation -- not that I know anything about hardware emulation in software :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:54 AM Subject: RE: Unix database syntactically similar to SQL Server? I wonder what kind of system specs would be required to run an emulator, MS SQL Server, CFMXJ2EE, JRun4 and Jedit on a Mac? Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ** ** * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 9:12 AM To: CF-Talk Subject: Re: Unix database syntactically similar to SQL Server? On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter wrote: So does VMWare for Linux run under MacOSX? Now *that* would be a solution :) VirtualPC emulates a PC and runs on OS X. Right. But VMWare let's you install *lots* of OS's -- most *nix, most Win, even Solaris if you're a glutton for install punishment. With VMWare, you could run a virtual Win2k Server instance on your Mac and use it for the db part of the development. Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community.
RE: HELP!!!! jrun-resources.xml
Of course, using JDBC/ODBC bridge means you can test using ODBC :) You need a JDBC app to test JDBC connectivity. Dick Applebaum pointed out a useful JDBC client for this sort of thing - ViennaSQL. It's a runnable JAR file: http://vienna.sourceforge.net/ Hey -- as an side, when you say the ODBC connection work, are you simply using the Test Datasource in the MSSQL ODBC setup? I don't remember all the details, but it's not a complete test -- it's more like a ping (yes, there's a sql server there) than a real test (yes, login is successful). I'm pretty sure this isn't correct. When you use this test, you connect to the specific database, using the specific username and password. The ping part happens before you even get that far in the ODBC Control Panel - when you select a server or server alias. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
You don't even have to view the mail if the gif is near/at the top and the user has something like Eudora's message preview pane set. (But then again, how many of the target demographics have even heard of Eudora ;-) OTOH, for legit opt-in mail, the message preview pane can also give a false (too high) indication of how many messages were read. best, paul At 10:23 AM 1/13/03 -0800, you wrote: Yep.. One of the ways that spammers, these days, collect info on valid email addresses when using HTML email campaigns. You simply view the email, and BAM.. they know your email address is good. Old news | -Original Message- | From: Costas Piliotis [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 10:04 AM | To: CF-Talk | Subject: RE: web beacons | | | Oh yeah, and you can pass url parameters to that image as | well... So let's say you send an email to employeeid 145. | | You can add a parameter the the src of the gif file in the | html email you send him as such: | | img src=http://www.myserver.com/image.cfm?id=145; | | Then in the source... Of image.cfm, something like this | appears: cfcontent file=foo.gif | type=application/whatever cfquery datasource=#application.ds# | insert into someTable (employeeid, date) | values (#val(url.id)#, getdate()) | /cfquery | | -Original Message- | From: Costas Piliotis | Sent: Monday, January 13, 2003 10:00 AM | To: CF-Talk | Subject: RE: web beacons | | | Easy. | | cfcontent file=foo.gif type=application/whatever | cfquery datasource=#application.ds# | ...tracking query here... | /cfquery | | You include the image, and some server-side code to process | it. Done it a few times... | | -Original Message- | From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 9:52 AM | To: CF-Talk | Subject: web beacons | | | Yahoo is using something called web beacons. Can anyone | simply explain how a single pixel gif is used as a web beacon. | http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: web beacons
The more sophisticated web bugs do not use a parameter, but instead actually use the filename itself to identify the individual and each email has a different image being requested. Quite effective in HTML email and on web pages. Justin -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 1:24 PM To: CF-Talk Subject: RE: web beacons Yep.. One of the ways that spammers, these days, collect info on valid email addresses when using HTML email campaigns. You simply view the email, and BAM.. they know your email address is good. Old news | -Original Message- | From: Costas Piliotis [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 10:04 AM | To: CF-Talk | Subject: RE: web beacons | | | Oh yeah, and you can pass url parameters to that image as | well... So let's say you send an email to employeeid 145. | | You can add a parameter the the src of the gif file in the | html email you send him as such: | | img src=http://www.myserver.com/image.cfm?id=145; | | Then in the source... Of image.cfm, something like this | appears: cfcontent file=foo.gif | type=application/whatever cfquery datasource=#application.ds# | insert into someTable (employeeid, date) | values (#val(url.id)#, getdate()) | /cfquery | | -Original Message- | From: Costas Piliotis | Sent: Monday, January 13, 2003 10:00 AM | To: CF-Talk | Subject: RE: web beacons | | | Easy. | | cfcontent file=foo.gif type=application/whatever | cfquery datasource=#application.ds# | ...tracking query here... | /cfquery | | You include the image, and some server-side code to process | it. Done it a few times... | | -Original Message- | From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] | Sent: Monday, January 13, 2003 9:52 AM | To: CF-Talk | Subject: web beacons | | | Yahoo is using something called web beacons. Can anyone | simply explain how a single pixel gif is used as a web beacon. | http://privacy.yahoo.com/privacy/us/pixels/details.html Sebastian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4