Re: Package of Crystal Reports Required for CF?
This is interesting. My input forms are totally dynamic as well. I'll check it out. Thanks. - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 6:41 PM Subject: Re: Package of Crystal Reports Required for CF? We combine CF and ASP for processing and use Recrystallize as a productivity tool. It generates the web pages. We only use the asp processing pages. The input forms which need, in our case, to be very dynamic and based on other systems with varying security are done with CF. Note that we have alot of reports and is cost effective for us. http://www.recrystallize.com - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 8:39 PM Subject: RE: Package of Crystal Reports Required for CF? Hi, i meant the actual tag cfreport.. not crystal report itself.. i found it a bit hard to get it working.. and once i did.. i found it abit lacking in functionality you can write a module or component yourself that works alot better... just take the ASP examples that come with the software and covert it to CF... or interface CF form with an ASP page that calls the crystal report (*.RPT) file.. search the MM CF forums.. for issues ppl have come across... hth joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 10:15 To: CF-Talk Subject: Re: Package of Crystal Reports Required for CF? Really, why? I've done a lot of hand-grown reports, but for a demo for a client, I want to use the widgets that come with crystal. Thanks. - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:18 PM Subject: RE: Package of Crystal Reports Required for CF? I have used Developer version... not sure about the standard version... plus i would stay away from cfreport... IMO..:) cheers Joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 2:41 To: CF-Talk Subject: Package of Crystal Reports Required for CF? Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Package of Crystal Reports Required for CF?
Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Package of Crystal Reports Required for CF?
Thanks, I just bought a copy of Crystal Standard 9.0. I wanted to make sure I hadn't wasted my money. I couldn't find anything specifically on the package requirements on Macromedia's site. I appreciate your help. - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 2:37 PM Subject: RE: Package of Crystal Reports Required for CF? Yes. You only need to be careful on version. CF 5 - CR 8; CF 4.5 - CR 7; CFMX - CR ? There is some experimental support for CF4.5 and CR 8. There is a hidden attribute on the cfreport tag. Should be in the knowledge base still. -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:41 AM To: CF-Talk Subject: Package of Crystal Reports Required for CF? Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Package of Crystal Reports Required for CF?
Really, why? I've done a lot of hand-grown reports, but for a demo for a client, I want to use the widgets that come with crystal. Thanks. - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:18 PM Subject: RE: Package of Crystal Reports Required for CF? I have used Developer version... not sure about the standard version... plus i would stay away from cfreport... IMO..:) cheers Joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 2:41 To: CF-Talk Subject: Package of Crystal Reports Required for CF? Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: access db
Here is what my host, www.HostMySite.com, recommends to unlock an Access db. (I have not tried this). FAQ: How to Overwrite an Existing Database I would like to upload an updated version of my access database. When I attempt to overwrite the existing database I am unable to. As a normal part of ODBC operation, your database file is locked by the ODBC connection. There is a trick you can use to unlock the database temporarily. You can write a page to query a non-existent column in an existing table in your database. This will temporarily unlock the database so that you can overwrite the file. Since the file will be re-locked quickly, especially if other pages are accessing the database, it is best to rename or delete the old database before uploading the new one. As soon as you upload the new database and run a good query, normal ODBC operation will resume. There are a few things you can do to maximize the success of the unlock page: 1. Make sure that no other pages are executing queries on the database. If a valid query is run right after your invalid query, the database will be locked again. 2. Since the database can be re-locked quickly, rename the .mdb file as soon as you run the invalid query. Then you can upload the new database and not worry about it locking again before you have a chance. 3. This trick often requires some patience - if it doesn't work at first, try it again a few times. Also, you may want to wait a few minutes and then try. You may want to rename, disable, or move any pages that query the database to prevent them from re-locking it. 4. If all else fails, upload another copy of the database with a different name. Email [EMAIL PROTECTED] and we will adjust the DSN. Hope this helps. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 6:52 AM Subject: RE: access db Yes, this is true...mostly. But in my case, when the last person closes the db it does not unlock. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:39 AM To: CF-Talk Subject: RE: access db Look for the ldb file- as per info below. Is there one defined? When you open an Access database file (.mdb) in shared mode, Microsoft Access also creates a locking information file (.ldb) with the same file name (for example, Northwind.ldb) and in the same folder as the database file. This locking information file stores the computer name (such as mypc) and security name (such as Admin) of each shared user of the database. Microsoft Access uses this information to control concurrency. In most cases, Microsoft Access automatically deletes the locking information file when the last user closes the database file. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Can a Word or Excel Document be Saved with a .CFM Extension and Retain Word or Excel Properties?
Hi, Is there anyway to save a Word or Excel document with a .CFM extension, to allow insertion and processing of CF logic for file security, but still retain the Word or Excel properties when opening up the .CFM file? I need to upload a number of Word and Excel docs for a customer, and need to provide password protection for the many individuals who will be accessing the documents. My host will provide directory password protection at $5 a person, but I really need something I can control myself. Any ideas? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Nevermind - Can a Word or Excel Document be Saved with a .CFM Extension and Retain Word or Excel Properties?
Nevermind, I figured it out. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Vacation Rental Software?
Does anyone know of a vacation rental software package written in CF? I have been trying to get the one from FusionFX but their site is down. Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Vacation Rental Software?
Basically, I need software that will let property owners register, pay a fee, and then upload info on their vacation rental to a central site. The owner of the site has an extremely limited budget, so the less I have to do the better. I'll probably end up trading work for cabin rentals - but they're in Lake Tahoe so that might not be too bad. You're right though, I might just take some buy car software. That's pretty similar. Thanks. - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 02, 2002 1:46 PM Subject: Re: Vacation Rental Software? What do you want it to do? You can then go and get any application, change buy car or buy book to rent villa On Fri, 2 Aug 2002, Jocelyn Isidro wrote: Does anyone know of a vacation rental software package written in CF? I have been trying to get the one from FusionFX but their site is down. Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Terrorism
Learn to be selfless I said. Are you kidding? It's selfless zealots who commit these acts. These people who have absolutely no value for their own lives or families, and give up all for the sake of the 'cause'. Self-interest is what keeps us safe. -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 12:41 PM To: CF-Talk Subject: RE: Terrorism I believe the larger ongoing conflicts are religion based. so to close with god and religion references is a bad omen of sorts... is it this god or mine and what do you know about god sort of conflict... the neutral genderless equal thing or PC for those types out there would be to identify that we wish everyone safety of self and family in this tie of conflict or loss. we should encourage people through our ethics and morality as opposed to the religious approach... I know it sounds dumb. I sat with a large group of about 300 young minded people just last night talking about Ethics... and yes indeed, those with Ethics tended to draw it from religious doctrine and speak in religious terms... It certainly drew lines in the sand... Me aethiest to a fault, sitting with a Catholic priest, next to a Jewish friend. Learn to be selfless I said. To listen.. To be slow to move.. Sometime wrong, but humbled to admit error and pay the dues. agree to disagree. draw lines on issues when needed.. Make borders to insulate and preserve the purity, if needed. I will post the Yahoo message thread URL... over 7k messages, mostly of hatred and faceless cowardess in response. Let's not become like that. I hope dearly, racism and vigilantism doesn't rear its ugly head. May all of us of the AMerican mind set no matter what doctrine or skin color live together in peace. [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Clint Tredway [EMAIL PROTECTED] Date: Tue, 11 Sep 2001 15:10:59 -0400 Subject: RE: Terrorism What alot of people on other lists that I belong are saying is that our belief in God and our faith in an unseeable bieng is ludicrus and is whats causing all this pain. I do not agree with this, but people can believe what they want. -- Original Message -- from: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 11 Sep 2001 13:47:16 -0500 i feel, as we all do, about todays happenings and wanted to keep quite but have to ask..., what is that supposed to mean? Neil Clark [EMAIL PROTECTED] on 09/11/2001 01:24:18 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Terrorism I think God was one of the main reasons why things like this happen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: attacks
I'll bet the people who did this didn't get paid a dime. And they probably have more volunteers than they can handle. Their 'reward' is martyrdom, not money. -Original Message- From: Jason Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 1:01 PM To: CF-Talk Subject: Re: attacks I agree to all that you said.and I feel for the families who were involved...but, as long as there are greedy people who will do ANYTING for money, we will not be safe. It's scary to think that a few dollars could make someone turn their head and not see what is going on. How could they live with themselves knowing what they allowed to happenbut then again, they couldn't have a soul or any morals. From: Paris Lundis [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: attacks Date: Tue, 11 Sep 2001 14:10:47 -0400 has anyone noted that this represents a great number of air related incidents arond DC.. DC where there is a no fly zone.. and where surface to sky ad portable missiles are available for such stuff?? The FAA needs to track more and better... inter and intra departmental communications needs improved. Boston Airport needs closed for a month and everyone fired. People need to be held accountable. We need dedicated people and more communications. All of this could have been minimized. I wish everyone the best in their quest to find loved ones today. [finding the future in the past, passing the future in the present] [connecting people, places and things] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Any Sites Showing Use of CF 5 Graphics Capability?
Does anyone know of any sites that showcase the use of CF 5.0's new graphics/charting functions? I need to justify the purchase of CF 5.0. Thanks, Jocelyn Isidro Sr. Software Engineer Pharmaceutical Care Network PCN with MedIntelligence Phone : 916.414.4753 Fax: 916.414.4647 E-mail : [EMAIL PROTECTED] www.pharmcarenet.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Any Sites Showing Use of CF 5 Graphics Capability?
Yeah. I know it's worth it, and we'll get a lot more than just graphics, but I need to get it in the door with charting capabilities. -Original Message- From: Kevin Mansel [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 10:55 AM To: CF-Talk Subject: RE: Any Sites Showing Use of CF 5 Graphics Capability? UDF's are enough to upgrade in my opinion... ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 10:54 AM To: CF-Talk Subject: Any Sites Showing Use of CF 5 Graphics Capability? Does anyone know of any sites that showcase the use of CF 5.0's new graphics/charting functions? I need to justify the purchase of CF 5.0. Thanks, Jocelyn Isidro Sr. Software Engineer Pharmaceutical Care Network PCN with MedIntelligence Phone : 916.414.4753 Fax: 916.414.4647 E-mail : [EMAIL PROTECTED] www.pharmcarenet.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Any Sites Showing Use of CF 5 Graphics Capability?
Not having performance issues. I just started a new job. They have an old version of CF Server. They don't want to upgrade unless CF 5.0 can do dynamic charts for some old printed reports. So I need to show my boss some sites that use Cold Fusion 5.0's charting capabilities, to prove to him that CF 5.0 can do dynamic charting, and that the purchase is worthwhile. Thanks. -Original Message- From: BT [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 11:00 AM To: CF-Talk Subject: RE: Any Sites Showing Use of CF 5 Graphics Capability? What type of performance issues if any are you having? What size pip do you have there? What are the specs on that server -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 2:00 PM To: CF-Talk Subject: Re: Any Sites Showing Use of CF 5 Graphics Capability? Not exactly a showcase but I use it here: http://www.vawter.com/display_popular.cfm and here: http://www.vawter.com/display.cfm - Original Message - From: Jocelyn Isidro [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 20, 2001 11:53 AM Subject: Any Sites Showing Use of CF 5 Graphics Capability? Does anyone know of any sites that showcase the use of CF 5.0's new graphics/charting functions? I need to justify the purchase of CF 5.0. Thanks, Jocelyn Isidro Sr. Software Engineer Pharmaceutical Care Network PCN with MedIntelligence Phone : 916.414.4753 Fax: 916.414.4647 E-mail : [EMAIL PROTECTED] www.pharmcarenet.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Repost: Creating Stored Procedures (DB2/NT)
Yes, you can. It's just a DB2 program that you can kick off via your connection software. I'm invoking a DB2 CL program from Powerbuilder. We use IBM's Client Access Express. It should work the same for CF. Jocelyn Isidro Sr. Software Engineer Pharmaceutical Care Network PCN with MedIntelligence Phone : 916.414.4753 Fax: 916.414.4647 E-mail : [EMAIL PROTECTED] www.pharmcarenet.com -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 11:35 AM To: CF-Talk Subject: Repost: Creating Stored Procedures (DB2/NT) Question, I know you can create Stored Procedures with SQL Server, Oracle and Sybase, how about DB2? Can it be done??? James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Repost: Creating Stored Procedures (DB2/NT)
DB2 UDB for AS400/Version 4.5 -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 1:24 PM To: CF-Talk Subject: Re: Repost: Creating Stored Procedures (DB2/NT) what version of DB2 are you running? Jocelyn Isidro wrote: Yes, you can. It's just a DB2 program that you can kick off via your connection software. I'm invoking a DB2 CL program from Powerbuilder. We use IBM's Client Access Express. It should work the same for CF. Jocelyn Isidro Sr. Software Engineer Pharmaceutical Care Network PCN with MedIntelligence Phone : 916.414.4753 Fax: 916.414.4647 E-mail : [EMAIL PROTECTED] www.pharmcarenet.com -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 11:35 AM To: CF-Talk Subject: Repost: Creating Stored Procedures (DB2/NT) Question, I know you can create Stored Procedures with SQL Server, Oracle and Sybase, how about DB2? Can it be done??? James ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Can't Find ODBC Source on New Server
Does anyone know why a datasource added and verified through the CF Administrator cannot be found by the CF template? I had to install CF on a new server because the old one got fried. Now when I run exactly the same template, CF is looking for the datasource in C:\WINNT\system32. I know I must be making a stupid error, but can't figure out what happened. As I said, it is verified as OK through Administrator in the directory where I put it (not C:\WINNT\system32). The query hasn't changed from the old server to the new. Here is the error message: Thank you in advance. "ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Could not find file 'C: \WINNT\system32\RPAdminTables.mdb'. SQL = "SELECT password, disabled, user_first_name, user_last_name, super_user FROM RPAdminTables.users WHERE user_id = 'JISIDRO'" Data Source = "RPAdminTables" SQL = "SELECT password, disabled, user_first_name, user_last_name, super_user FROM RPAdminTables.users WHERE user_id = 'JISIDRO'" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (60:1) to (60:63)." Jocelyn Isidro Web Application Programmer UC Davis Health Systems (916) 734-2519 (phone) (916) 453-0928 (fax) (916) 698-3831 (cell) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Never mind - Re: Can't Find ODBC Source on New Server
Never mind, I found my problem with a little more research. Thank you. Jocelyn Isidro Web Application Programmer UC Davis Health Systems (916) 734-2519 (phone) (916) 453-0928 (fax) (916) 698-3831 (cell) [EMAIL PROTECTED] cdavis.eduTo: [EMAIL PROTECTED] cc: 05/11/2000 08:22 AM Subject: Can't Find ODBC Source on New Server Please respond to cf-talk Does anyone know why a datasource added and verified through the CF Administrator cannot be found by the CF template? I had to install CF on a new server because the old one got fried. Now when I run exactly the same template, CF is looking for the datasource in C:\WINNT\system32. I know I must be making a stupid error, but can't figure out what happened. As I said, it is verified as OK through Administrator in the directory where I put it (not C:\WINNT\system32). The query hasn't changed from the old server to the new. Here is the error message: Thank you in advance. "ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Could not find file 'C: \WINNT\system32\RPAdminTables.mdb'. SQL = "SELECT password, disabled, user_first_name, user_last_name, super_user FROM RPAdminTables.users WHERE user_id = 'JISIDRO'" Data Source = "RPAdminTables" SQL = "SELECT password, disabled, user_first_name, user_last_name, super_user FROM RPAdminTables.users WHERE user_id = 'JISIDRO'" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (60:1) to (60:63)." Jocelyn Isidro Web Application Programmer UC Davis Health Systems (916) 734-2519 (phone) (916) 453-0928 (fax) (916) 698-3831 (cell) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Valuelist Delimiter?
I know this is a basic question, but how do you set the delimiter to something besides a comma when using Valuelist? I am running through a list of text descriptions that include commas, and when using Listgetat to get value, CF is parsing my internal commas as well. The CF documentation indicates a delimiter is an argument, but I can't seem to make it work. Thanks. Jocelyn Isidro Web Application Programmer UC Davis Health Systems (916) 734-2519 (phone) (916) 453-0928 (fax) (916) 698-3831 (cell) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF and DB2
I've set up DB2 CAE many, many times on our NT servers here. We started with V2.1, and recently upgraded to V5.2 on our NT servers here. We had a lot of trouble getting it to work initially, mostly due to our funky network set up (DB2/Datajoiner on Unix to LU6.2 to VTAM to DB2), but it works pretty reliably now. If you are using a mainframe version of DB2, I believe the DB2 version must be 5 or higher to run CAE 5.2. I don't know about the AS400 version. The CAE goes on the server, not on the PC, if you plan to use it with Cold Fusion on the server. Some CF java-based functions (e.g. certain functions of CFGRID) are not supported by the CAE 5.2 ODBC driver, at least not in our shop. Here is another link with the CAE download: http://www-4.ibm.com/software/data/db2/db2tech/clientpak.html Feel free to contact me with any questions. Jocelyn Isidro Web Application Programmer UC Davis Health Systems (916) 734-2519 (phone) (916) 453-0928 (fax) (916) 698-3831 (cell) [EMAIL PROTECTED] tate.ky.usTo: [EMAIL PROTECTED] cc: 04/12/00 06:40Subject: RE: CF and DB2 AM Please respond to cf-talk I have seen several reports of successful connections to DB2. I think "Client Access Enabler" is IBM's term for the DB2 client libraries that most, if not all, client applications would need to have installed in order to talk to DB2. If you have a DB2 admin around, ask them what IBM software is generally installed on a workstation to allow it to talk to DB2. -Original Message- From: Brian Cusack [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 12, 2000 9:38 AM To: [EMAIL PROTECTED] Subject: CF and DB2 Hello all, Do any of you have experience with Cold Fusion and a DB2 back end? Allaire maintains that there is some software called "Client Access Enabler" makes it possible for Cold Fusion to work with a DB2 database, but I am having some difficulty getting any information on this software. Thanks! Brian -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.