RE: Need Help Parsing Text
Thank you very much! -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: Saturday, April 16, 2005 11:11 AM To: CF-Talk Subject: Re: Need Help Parsing Text OOPS, correction below... I got the AUTHOR column named incorrectly... sorry. If you want, you can view it here, too: http://w2ksrv1.neo.servequake.com/tmp/ath.cfm I'll leave it up for a few days... Laterz, J cfset myString = AUTHOR='GIESEMAN','SMITH', ABSTRACT='CAT','DOG','FISH' cfset myString = replace(myString,, ,||,all) cfset listOne = listFirst(myString,||) cfset listTwo = listLast(myString,||) cfset listOneEnd = listLast(listOne,=) cfset listTwoEnd = listLast(listTwo,=) pre cfoutput select * from tbl_whatever where author in (#listOneEnd#) and abstract in (#listtwoend#) /cfoutput /pre On 4/15/05, Gieseman, Athelene [EMAIL PROTECTED] wrote: I have a text field that contains saved search criteria. The field is called CRITERIA. I need to take the criteria in the field and make a valid SQL query out of it. For example, I have a record in the table that has the following in the CRITERIA field: -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://www.web-relevant.com/blogs/cfobjective ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203140 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Need Help Parsing Text
I have a text field that contains saved search criteria. The field is called CRITERIA. I need to take the criteria in the field and make a valid SQL query out of it. For example, I have a record in the table that has the following in the CRITERIA field: My string is: AUTHOR='GIESEMAN','SMITH', ABSTRACT='CAT','DOG','FISH' I want to find all the records that have either GIESEMAN or SMITH as the author AND where abstract contains either CAT, DOG or FISH. How can I auto-magically parse the string into a valid SQL query? Athelene Gieseman Chief Information Officer Stinson Morrison Hecker [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] This communication is from a law firm and may contain confidential and/or privileged information. If it has been sent to you in error, please contact the sender for instructions concerning return or destruction, and do not use or disclose the contents to others. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203106 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need Help Parsing Text
Thanks. This table, unfortunately, is not set up for full-text indexing. (This is from a third-party app, not my own.) So I think I'm going to be forced into inefficiency with LIKE. I'm using MS SQL. Thanks for replying so quickly! Athelene -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, April 15, 2005 3:33 PM To: CF-Talk Subject: Re: Need Help Parsing Text I think the bigger question if you're using CONTAINS then have you setup full-text indexes on the appropriate columns?? or are you going to use the inefficient LIKE '%string%' approach? Something to think aboutand the answer (combined with what database you use) will determine the final format of what you've shown us. ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203111 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need Help Parsing Text
Thank you SO much!! -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, April 15, 2005 3:49 PM To: CF-Talk Subject: Re: Need Help Parsing Text here goes ;-) cfset MyString = AUTHOR='GIESEMAN','SMITH', ABSTRACT='CAT','DOG','FISH' cfset AuthorChunk = ListGetAt(MyString,2,=) cfset AuthorList = Replace(AuthorChunk,, ABSTRACT,,ALL) cfset AuthorList = Replace(AuthorList,',,ALL) cfset AbstractList = ListGetAt(MyString,3,=) cfset AbstractList = Replace(AbstractList,',,ALL) AuhtorList should now be GEISEMAN,SMITH AbstractList should now be CAT,DOG,FISH Then just loop over each list and create your SQL ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203113 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: At my new job
I have a similar question. (I'm about to date myself now.) Many years ago I worked on a Wang VS system. There was a utility called CREATE which would allow you to take just about any data file or files and pull specific columns and rows from it to create a new file. For example, if I had 2 files (A and B) I could say: Start with file A, column 5 for a length of 4, but only for the first 10 rows. Add to the end of that row from file B, starting at position 19, length of 12, for the first 10 rows. Then add the characters ABC at the end of the row for 10 rows. Now start on row 11, etc. All of this was in a great utility that was easy to use. Is there anything out there today which would do a similar task? Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Jeffrey Polaski [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 12:50 PM To: CF-Talk Subject: FW: At my new job I'm fan of UltraEdit. It has a column mode which can save a lot of typing. Sometime I use XEmacs, another great editor, but I don't use it as much as I use UltraEdit. I've used it to edit some pretty big files, but It loads the whole file into memory, though. It sounds like you have a very specific task in mind for your editor. Depending on what you want to do, you might be able to write a Sed|Awk|Perl|Python|etc... script to do what you want. While we're on the topic of text editing, I also Python to do a lot of repetitive text generation. For example I can feed a table, a list of columns, and their type and size into a Python script and get back an insert and update statements, formatted like I want and with trim() and isdefined() where I want it. It's so much easier than doing it all by hand for data-entry type apps. Jeff Polaski Manager, Web Services Research Graduate Studies University California, Irvine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 8:00 AM To: CF-Talk Subject: At my new job Well i'm now settled in at my new job :) WHOO HOO!! After my boss tried to have me arrested for HACKING his servers and all that was fun my old boss was a threatster :) OK OK now to the point i need to find a win32 textbased editor that does not have to load the whole damn file into memory first. I remember it being on here before so i'm curious. Any help would be appreciated! Bill Wheatley Senior Database Developer Ediets.com Macromedia Certified Coldfusion Developer 954.360.9022 X159 __ 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: At my new job
I do use sql to do this. But this utility just let me plug in some values and go. No code to write. It was very quick and easy. -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 1:15 PM To: CF-Talk Subject: RE: At my new job Well you could parse files like that with CF, or just about any other language. Excel and Access can be used to do some of this, not sure about getting just 1 or 2 columns from separate files, then joining. Also you could do it with a SQL Server and write some join tables or views. I would think there would be many many ways to do it. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 2:09 PM To: CF-Talk Subject: RE: At my new job I have a similar question. (I'm about to date myself now.) Many years ago I worked on a Wang VS system. There was a utility called CREATE which would allow you to take just about any data file or files and pull specific columns and rows from it to create a new file. For example, if I had 2 files (A and B) I could say: Start with file A, column 5 for a length of 4, but only for the first 10 rows. Add to the end of that row from file B, starting at position 19, length of 12, for the first 10 rows. Then add the characters ABC at the end of the row for 10 rows. Now start on row 11, etc. All of this was in a great utility that was easy to use. Is there anything out there today which would do a similar task? Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Jeffrey Polaski [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 12:50 PM To: CF-Talk Subject: FW: At my new job I'm fan of UltraEdit. It has a column mode which can save a lot of typing. Sometime I use XEmacs, another great editor, but I don't use it as much as I use UltraEdit. I've used it to edit some pretty big files, but It loads the whole file into memory, though. It sounds like you have a very specific task in mind for your editor. Depending on what you want to do, you might be able to write a Sed|Awk|Perl|Python|etc... script to do what you want. While we're on the topic of text editing, I also Python to do a lot of repetitive text generation. For example I can feed a table, a list of columns, and their type and size into a Python script and get back an insert and update statements, formatted like I want and with trim() and isdefined() where I want it. It's so much easier than doing it all by hand for data-entry type apps. Jeff Polaski Manager, Web Services Research Graduate Studies University California, Irvine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 8:00 AM To: CF-Talk Subject: At my new job Well i'm now settled in at my new job :) WHOO HOO!! After my boss tried to have me arrested for HACKING his servers and all that was fun my old boss was a threatster :) OK OK now to the point i need to find a win32 textbased editor that does not have to load the whole damn file into memory first. I remember it being on here before so i'm curious. Any help would be appreciated! Bill Wheatley Senior Database Developer Ediets.com Macromedia Certified Coldfusion Developer 954.360.9022 X159 __ 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: CFGRID
I use to use it all the time. But there are a few problems I've encountered so I don't use it at all anymore. A few of the problems are: 1. CFGRID doesn't allow wrap around. This isn't a problem if your columns are very short. But it's difficult for users to manipulate data if they have to scroll within the column to see it. 2. CFGRID would not allow my DHTML menus to show up in front. So if there was a grid on the page, you couldn't see some parts of the menu. 3. When I upgraded to CF5, none of the grids wanted to work anymore. We had all kinds of Java issues. If I remember correctly, there are also issues with how dates and numbers can be formatted in the columns. All in all, I've gone to just using tables which provide a much nicer display for the user. The grids were a great way to get started. But as I've learned more about CF and coding in general, I've found that the grids were too limiting. It would be great if those limitations could be addressed in a future release. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 8:53 AM To: CF-Talk Subject: CFGRID Has anyone had any success with using CFGRID in an application? Its perfect for what I need to do but im a little weary about it... Any suggestions? Ie... Java version Bugs etc... __ 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: connection error
I had this happen to me last week for the first time. I'm not sure exactly what happened. I'm using CF 5.0 on Windows 2000. I restarted the server where CF lives and it worked just fine. It happened again last weekend when I changed a data source. It was almost like it needed to be restarted to refresh something. Restarting the CF services did not do the trick. Sorry I can't be more specific. Hopefully it will point you to something that you can simply restart or refresh to get it going. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Judy [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:02 PM To: CF-Talk Subject: connection error I have establised a connection with my SQL database throught CF Administrator and have verified it's connection. However, when I go to my main .cfm page, I get an error that it cannot find my base table. How can that be? I can see my database and see that it's connected and see all the tables in it when I open it in SQL? Anyone know what's going on? This is the exact message. Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Events'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (5:1) to (5:48). Date/Time: 04/22/02 15:50:15 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Here's my query to access the database: cfquery name=selectevent datasource=Events SELECT * FROM Events WHERE ID = ID /cfquery __ 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: connection error
That was not the issue in my case. I checked (and double checked and triple checked.) I also checked to be sure it was using TCP/IP and not Named Pipes. I also checked (and double checked and triple checked) the user id and password for the data source. I didn't change the ODBC data source at all because it was setup correctly. I restarted the server and all was well. Athelene -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 4:28 PM To: CF-Talk Subject: Re: connection error When the ODBC DSN was set up, the default database is master, so you are trying to connect to the Events table in the master database which doesn't exist. The solution will be to edit the ODBC DSN to point to the proper database HTH Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Gieseman, Athelene [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 5:09 PM Subject: RE: connection error I had this happen to me last week for the first time. I'm not sure exactly what happened. I'm using CF 5.0 on Windows 2000. I restarted the server where CF lives and it worked just fine. It happened again last weekend when I changed a data source. It was almost like it needed to be restarted to refresh something. Restarting the CF services did not do the trick. Sorry I can't be more specific. Hopefully it will point you to something that you can simply restart or refresh to get it going. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Judy [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:02 PM To: CF-Talk Subject: connection error I have establised a connection with my SQL database throught CF Administrator and have verified it's connection. However, when I go to my main .cfm page, I get an error that it cannot find my base table. How can that be? I can see my database and see that it's connected and see all the tables in it when I open it in SQL? Anyone know what's going on? This is the exact message. Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Events'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (5:1) to (5:48). Date/Time: 04/22/02 15:50:15 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Here's my query to access the database: cfquery name=selectevent datasource=Events SELECT * FROM Events WHERE ID = ID /cfquery __ 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: Opinions/Experience with Webex?
I've used Webex quite a bit to receive support from one of our vendors. It works very well for us. I've also been looking at using it to provide services to our clients. It's been very reliable when we've used it. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 1:21 PM To: CF-Talk Subject: Opinions/Experience with Webex? Anyone here have any experience with Webex http://www.webex.com that you could share? Or alternatives in the online meeting realm? Webex appears to suit our needs but would appreciate any feedback pro or con that anyone could share. Primary use will be for remotely training personnel on several CF-based web applications. Thanks, Ken __ 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
OT:SQL Help Needed!
I just went through a conversion from one product to another. As a part of that process, records were exported via CSV and imported into another MS SQL database. Somewhere along the way, not all of the records were imported. (It was done using the vendor's import utility which was useless in troubleshooting this issue.) The question is this: I want to find all of the records in the original DB that did not make it into the new one. There are only two tables involved. We copied the original table into the new database to make it easier. So now they are both in the same DB. The original table is called DOCMASTER. The new table is called VERSIONS. I need to find all of the records in DOCMASTER that do not exist in VERSIONS. The only way I can tell is from two fields in each. DOCMASTER.DOCNUM should equal VERSIONS.DOCNUMBER And DOCMASTER.VERSION should equal VERSIONS.VERSION How can I write a query to show me every record in DOCMASTER That didn't make it into VERSIONS? I know this should be easy. I apologize in advance. Very sleep deprived at this point. Any help is appreciated. Athelene Gieseman [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Help Needed!
Worked perfectly! Thank you! Now if I can only get them imported. Athelene -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 2:51 PM To: CF-Talk Subject: RE: SQL Help Needed! This will work in sql server. Don't think access supports compound outer joins... I could be mistaken though... Select * from Docmaster left outer join versions on docmaster.docnum = versions.docnumber and docmaster.version = versions.version Where verersions.docnumber is null -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 12:38 PM To: CF-Talk Subject: OT:SQL Help Needed! I just went through a conversion from one product to another. As a part of that process, records were exported via CSV and imported into another MS SQL database. Somewhere along the way, not all of the records were imported. (It was done using the vendor's import utility which was useless in troubleshooting this issue.) The question is this: I want to find all of the records in the original DB that did not make it into the new one. There are only two tables involved. We copied the original table into the new database to make it easier. So now they are both in the same DB. The original table is called DOCMASTER. The new table is called VERSIONS. I need to find all of the records in DOCMASTER that do not exist in VERSIONS. The only way I can tell is from two fields in each. DOCMASTER.DOCNUM should equal VERSIONS.DOCNUMBER And DOCMASTER.VERSION should equal VERSIONS.VERSION How can I write a query to show me every record in DOCMASTER That didn't make it into VERSIONS? I know this should be easy. I apologize in advance. Very sleep deprived at this point. Any help is appreciated. Athelene Gieseman [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: SQL Backup/Restore Question
Recently someone told me something about MS SQL backup/restore that I would like to verify. I haven't been able to find anything in any books or on the MS site to clarify. So I thought I'd ask here for either a direct answer or a place to go search. The Scenario: Backups are done every night at midnight. In between, backups of the transaction logs are done every two hours. The question: It's Thursday. I need to restore my database, but the most recent backup (e.g., Wed night) is corrupt. Can I go back to the previous backup (e.g. Tue night) and apply all of the transaction logs through Thursday? Or would I only be able to apply them up until the Wednesday night backup? I've been told that MS SQL won't let me apply transaction logs for (in this example) Thursday unless I started with the Wednesday night backup. I know Informix would allow me to apply all of the logs. We're about to switch to MS SQL and I want to be sure we set up the appropriate backup procedures. Any thoughts on how I could get to the bottom of this would be appreciated. Athelene Gieseman [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFREPORT and Error 500
I use Crystal 8.0 web page server. It's very easy to pass information from CF to the Crystal report. The following is an example of what I've done that has worked for me: cflocation url=http://kcweb/firmdaily/isweb/ISBudget/PO.rpt?Prompt0=#FindPO#; FindPO is the variable I'm sending from CF. It is the first Prompt variable in the report. If I were to send another, I'd add it to the end as Prompt1. E.g.: cflocation url=http://kcweb/firmdaily/isweb/ISBudget/PO.rpt?Prompt0=#FindPO#Prompt1=# TheOtherVariable# This has worked reliably for me. One word of caution though. I understand from someone on another list that version 8.5 requires a license for each person who runs a report off of the web page server. I haven't verified with Seagate. But if it's true, it would be way too expensive for us to use (with about 1000 users.) Maybe someone on this list can answer if they've used the latest version and if there is a licensing issue. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 1:14 PM To: CF-Talk Subject: Re: CFREPORT and Error 500 In the CF Forums you can find a lot about using CFReport. Last I checked the tag was depreciated since version 5 of Crystal Reports. Crystal has it's own webserver product now. Crystal seems to have spent a good deal of time integrating their product with ASP. I also remember some undocumented features to the CFReport tag you must use to pass parameters to the newer versions. Check the Forums. I hope the info is still there. If not, send me a direct email and I'll dig about my own archives for some of the examples I downloaded. Keep in mind that Crystal is on version 8 now. CFReport is meant to work with Version 5. Hope that helps. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/02/02 01:25PM I am trying to pass a variable to CFREPORT and I continue to receive the following. There is very little on the Allaire discussion forums about this. I am running CF 5 and CR 8.5. I thought the previous problems regarding CFREPORT has been fixed in CF 5. Anyone have an idea on this? Error Diagnostic Information Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 500 ocurred (Not enough memory for operation.). Crystal Library = C:\WINNT\system32\CRPE32.DLL (2/10/2001 1:43) DLL Version = 8.80, Engine Version = 8.80 The error occurred while processing an element with a general identifier of (CFREPORT), occupying document position (9:1) to (9:59). Date/Time: 04/02/02 11:02:09 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; T312461) Remote Address: 129.43.39.167 Alan L. Wolf MCSE, MCP, MCP + I SAIC Frederick PO Box B Bldg 458 Frederick, Maryland 21702 [EMAIL PROTECTED] 301-846-5479 (V) 301-846-6886 (F) __ 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
Creating a CSV File
I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)#_FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##rtrim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#chr(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34)#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editdate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(GetDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr(34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)##rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)#,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating a CSV File
I love this list! Thank you so much. Athelene -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:06 AM To: CF-Talk Subject: RE: Creating a CSV File Sorry, I forgot a couple of things ... cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfset theoutput = cfoutput query=GetDocs cfset theoutput = theoutput #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput cfset theoutput = /cfif /cfoutput-Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:02 AM To: CF-Talk Subject: RE: Creating a CSV File Store your information in a variable until you reach a certain number of records and then append it to the file. You will have a significantly reduced number of writes to the disk which is causing your slow response. Something like this: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cfset theoutput = #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput /cfif /cfoutput - Matt Small -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:31 AM To: CF-Talk Subject: Creating a CSV File I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDoc s.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ 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: Creating a CSV File
I'm using a stored procedure which puts the results into GetDocs. I'm getting an error on: getdocs.currentrecord It says it's not a valid column. Do I somehow need to setup something to determine the current record? Or is it not providing that since it's coming from a stored procedure? Athelene -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:06 AM To: CF-Talk Subject: RE: Creating a CSV File Sorry, I forgot a couple of things ... cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfset theoutput = cfoutput query=GetDocs cfset theoutput = theoutput #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput cfset theoutput = /cfif /cfoutput-Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:02 AM To: CF-Talk Subject: RE: Creating a CSV File Store your information in a variable until you reach a certain number of records and then append it to the file. You will have a significantly reduced number of writes to the disk which is causing your slow response. Something like this: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cfset theoutput = #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput /cfif /cfoutput - Matt Small -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:31 AM To: CF-Talk Subject: Creating a CSV File I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDoc s.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ 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: Creating a CSV File
Took a wild guess that it might need to be currentrow instead of currentrecord. Seems to be running now. THX. -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:32 AM To: CF-Talk Subject: RE: Creating a CSV File I'm using a stored procedure which puts the results into GetDocs. I'm getting an error on: getdocs.currentrecord It says it's not a valid column. Do I somehow need to setup something to determine the current record? Or is it not providing that since it's coming from a stored procedure? Athelene -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:06 AM To: CF-Talk Subject: RE: Creating a CSV File Sorry, I forgot a couple of things ... cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfset theoutput = cfoutput query=GetDocs cfset theoutput = theoutput #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput cfset theoutput = /cfif /cfoutput-Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:02 AM To: CF-Talk Subject: RE: Creating a CSV File Store your information in a variable until you reach a certain number of records and then append it to the file. You will have a significantly reduced number of writes to the disk which is causing your slow response. Something like this: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cfset theoutput = #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput /cfif /cfoutput - Matt Small -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:31 AM To: CF-Talk Subject: Creating a CSV File I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDoc s.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion
RE: CFMail - Sending a link in an email
This list is the best. Of course, after seeing the answer, I'm realizing how obvious that was. Thanks for your help and patience! -Original Message- From: Robert Long [mailto:[EMAIL PROTECTED]] Sent: Friday, March 02, 2001 10:30 AM To: CF-Talk Subject: RE: CFMail - Sending a link in an email I think Melissa nailed it. You need to supply some kind of address in the link tag. Since the email client is not a browser, it needs specific directions to the page you are linking to. So using http://intranet/usercalldisplay.cfm or something like that will help it find it's way to the page. Hope that helps. -Original Message- From: Melissa Fraher [mailto:[EMAIL PROTECTED]] Sent: Friday, March 02, 2001 9:47 AM To: CF-Talk Subject: Re: CFMail - Sending a link in an email Try putting in the entire address without the href tag. For example: http://www.yoursite.com/UserCallDisplay.cfm If I understand the other responses to your question correctly, when Outlook sees the http:// it will create a link. Melissa "Gieseman, Athelene" wrote: OK, let me try to post the code again. this time I change the tag in this message to say CF_mail. I'm guessing the post didn't like the real tag. cf_mail query="GetCall" to="#NewEmail#" from="[EMAIL PROTECTED]" subject="New Help Desk Ticket" type="HTML"htmlbodyThank you for reporting your issue to the Help Desk. Your call was logged into our database at #prettydatetime#. If your problem was not resolved at the time of your call you will be hearing back from a technician shortly. P div align="center"H3Call Information/h3/divP h4bfont color="Blue"Ticket Number:/font/b #GetCall.ID#P bfont color="Blue"Problem Description:/font/b BR #GetCall.Issue#P !--- a href="UserCallDisplay.cfm"Click here to see the status of your open calls./a --- /h4/body/html/cf_mail ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMail - Sending a link in an email
I have an application which sends out an email to our users. I'd like to include a link to an intranet page in the email. All of the recipients use Outlook. When I simply add an anchor tag, the mail message has the text, but it's not an active link. I've set the mail type to HTML. What else do I need to do? TIA. Athelene Gieseman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMail - Sending a link in an email
It is coming out as a link. But the url it translates into looks something like: 55-B0035980567AD311B4CD0090274EDA130700C46D185F46E1D211B4B50090274ED A1300937AB4C46D185F46E1D211B4B50090274EDA1302CC2BD7 My CFMail tag looks like this (the link is at the end): ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMail - Sending a link in an email
OK, let me try to post the code again. this time I change the tag in this message to say CF_mail. I'm guessing the post didn't like the real tag. cf_mail query="GetCall" to="#NewEmail#" from="[EMAIL PROTECTED]" subject="New Help Desk Ticket" type="HTML"htmlbodyThank you for reporting your issue to the Help Desk. Your call was logged into our database at #prettydatetime#. If your problem was not resolved at the time of your call you will be hearing back from a technician shortly. P div align="center"H3Call Information/h3/divP h4bfont color="Blue"Ticket Number:/font/b #GetCall.ID#P bfont color="Blue"Problem Description:/font/b BR #GetCall.Issue#P !--- a href="UserCallDisplay.cfm"Click here to see the status of your open calls./a --- /h4/body/html/cf_mail -Original Message- From: Robert Long [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 6:05 PM To: CF-Talk Subject: RE: CFMail - Sending a link in an email I use outlook and anything with an http:// in front of it becomes a link. http://www.yahoo.com Hope that helps... -Original Message- From: Roque,Carlos [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:18 PM To: CF-Talk Subject: RE: CFMail - Sending a link in an email Make sure you have full HTML tags i.e., HTML BODY , etc. and closing tags in the body. Carlos Roque I.S., Applications Web Development x2154 -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 1:43 PM To: CF-Talk Subject:CFMail - Sending a link in an email I have an application which sends out an email to our users. I'd like to include a link to an intranet page in the email. All of the recipients use Outlook. When I simply add an anchor tag, the mail message has the text, but it's not an active link. I've set the mail type to HTML. What else do I need to do? TIA. Athelene Gieseman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using Authentication window
This is a question I posed to the list some time ago. I tried way back when, but only the cf service login id was returned. I just tried again, and it's working fine. I'm confused as to what's different (or rather, what I did wrong the first time.) But very happy it's working!! Thank you to all who posted an answer on this. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 1:07 PM To: CF-Talk Subject: RE: Using Authentication window an authentication window? you mean like the one IIS pops up when using NTCR? after authentication, check CGI.AUTH_USER (CGI.REMOTE_USER might work as well. i've seen them both used). chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 12:46 PM To: CF-Talk Subject: Using Authentication window Does anyone know how to get a userid from a Authentication and pass that variable to CF so that I can use it to query a DB and populate some fields? I would appreicate it any help that you can offer. Thanks in Advance. Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: local user time
And we appreciate that in many cases. However, the purpose of a listserv is to share questions and answers. Often someone will ask a question that I haven't even thought about. But the answer is still interesting to me as I'm always trying to learn all I can. In fact, this particular question is of interest to me too. Remember when your teachers use to tell you that if you had a question, chances are that someone else had the same question too? I guess I'd rather someone err on the side of sending too much to the list rather than sending too little. I can always use my delete key. :-) If you decide not to post to the list, would you pls send me the information too? TIA. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 1:18 PM To: CF-Talk Subject: Re: local user time The reason I take it off the list, is so that the list doesn't get cluttered with meaningless emails... -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFGrid is too determined to be up front!
I'm trying to add a dynamic menu bar to one of my cf pages which has a CFGRID tag near the top of the page. The problem is that I can't get the menu to appear in front of the grid. Any suggestions? Athelene Gieseman [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFGrid is too determined to be up front!
I'm trying to add a dynamic menu bar to one of my cf pages which has a CFGRID tag near the top of the page. The problem is that I can't get the menu to appear in front of the grid. Any suggestions? Athelene Gieseman [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Duplicates
Is there something wrong with my account on this list if I keep getting duplicate (well more like quadruplicate) messages? If there's something I'm doing wrong, please let me know so I can fix it. The great thing about the list is that it's so active. But when the messages are sent over and over again, it gets to be unmanagable. Athelene Gieseman [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I know NOTHING about Crystal Reports!
I'm doing this via the web component server and page server. It works very well (after a bit of frustration figuring it out and setting it up.) The documentation is very weak. But the product itself is easy to use and it's easy to integrate CF. If you'd like more specific info, feel free to email me directly or via the list. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 12:34 PM To: CF-Talk Subject: OT:I know NOTHING about Crystal Reports! Hey all! As is the nature of our business, I had something thrown in my lap yesterday, and I'm just trying to figure out if Crystal Reports will accomplish this or not... Basically, we need a way to allow users to generate reports on the fly via their web browsers (we don't want to install anything on the client machines) based on different criteria. Once the report is generated, we want to dump the report info to Excel so that users can manipulate it as needed. I am looking into Crystal Reports 8 (Developer Ed.), and I THINK it can do this, but I'm not entirely sure. I want to know 100% for sure if Crystal Reports would be the way to do this before we go ahead and hire an outside contractor for Crystal Reports (our skill here aren't strong enough to do this in the timeframe management is asking for)... Any input is greatly appreciated! BTW, we are using CF 4.0, Oracle, and need to design for both NN and IE, 4.X and up. Thanks! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I know NOTHING about Crystal Reports!
No. I tried this for a while. Then heard (thru this list) that the CFREPORT tag would not work with CR8 and there was no plan to make it work. So I started working on Crystal instead. Actually, now that I'm using CR, I prefer it anyway. Athelene Gieseman -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 4:18 PM To: CF-Talk Subject: RE: I know NOTHING about Crystal Reports! We too are using this. You do not need the development version for this either. Has anyone had success using the CFREPORT tag with CrystalReports 8 and CF4??? Cheers! -- Douglas Knudsen LTT, that's Leveraged Technologies Team --- Hey! These views are mine! [EMAIL PROTECTED] Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 01/31/2001 05:04 PM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: RE: I know NOTHING about Crystal Reports! I'm doing this via the web component server and page server. It works very well (after a bit of frustration figuring it out and setting it up.) The documentation is very weak. But the product itself is easy to use and it's easy to integrate CF. If you'd like more specific info, feel free to email me directly or via the list. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 12:34 PM To: CF-Talk Subject: OT:I know NOTHING about Crystal Reports! Hey all! As is the nature of our business, I had something thrown in my lap yesterday, and I'm just trying to figure out if Crystal Reports will accomplish this or not... Basically, we need a way to allow users to generate reports on the fly via their web browsers (we don't want to install anything on the client machines) based on different criteria. Once the report is generated, we want to dump the report info to Excel so that users can manipulate it as needed. I am looking into Crystal Reports 8 (Developer Ed.), and I THINK it can do this, but I'm not entirely sure. I want to know 100% for sure if Crystal Reports would be the way to do this before we go ahead and hire an outside contractor for Crystal Reports (our skill here aren't strong enough to do this in the timeframe management is asking for)... Any input is greatly appreciated! BTW, we are using CF 4.0, Oracle, and need to design for both NN and IE, 4.X and up. Thanks! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ISP to support WAP and CF
I'm looking for a host that will support WAP and CF. I'm doing this just to have an opportunity to learn and test. Any suggestions? Athelene Gieseman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFUPDATE giving me problems, please help...
I've had this happen using CFGRIDUPDATE before. In that case it required that I use the keyonly="Yes" option. What happens if you just create a cfquery and use sql to do the update? I recently gave up on CFUPDATE because I can't get it to save a date/time field with the time. I always forget until I'm testing the app and I can't match up the date/time field with something or other. I've also had other problems that I can't quite remember now. (My brain only has about 4K of RAM. I'm in serious need of an upgrade!) It's a shame the tag doesn't work for me because it would save me a lot of time to use CFUPDATE. Especially when I later add a field to the database. If you can update the record with SQL, it might help to figure out why CFUPDATE isn't working. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Joby Bednar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 1:27 PM To: CF-Talk Subject: CFUPDATE giving me problems, please help... I have an admin form to add/edit records in an Access 2000 database. I try to edit a user's record and I get this error: Error Diagnostic Information SQL operation updated no rows. The SQL operation affected no rows.Either the Key value has changed or the row has been deleted. The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (30:1) to (30:50). The problem only comes up when I try to change the username field "username". As far as I can tell, even though I have an id field that is the key for the database, it thinks "username" is my key and CFUPDATE will give me this error. All other uses of the database work fine (other updates, query, delete, etc.) and I double checked to make sure "id" is the key and it is. Is "username" a reserved word somewhere where this would be such a problem? Is the problem with Access 2000 or CFUPDATE? Any help would be great. The code to update is very simple: cfupdate datasource="mydatasource" tablename="mytablename" Joby Bednar Director of Internet Design iNEOgroup.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: SQL Question
That was it! Thank you! -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 4:18 PM To: CF-Talk Subject: Re: OT: SQL Question On 1/16/01, Gieseman, Athelene penned: cfquery datasource="IS_Budget" name="SaveInvoiceQry" INSERT X_Invoices (Vendor, Inv_GL, Inv_City, Inv_Dept, Inv_Date, Inv_No, Inv_Desc, ApprovedDate, Notes, Inv_Amount) values ('#Vendor#', '#Inv_GL#', '#Inv_City#', '#Inv_Dept#', '#Inv_Date#', '#Inv_No#', '#Inv_Desc#', '#ApprovedDate#', '#Notes#', #Inv_Amount#) /cfquery I'm sure I'm not seeing something obvious. But it looks to me like there are 10 items for each of the values and table columns. Can anyone see what I'm not? One thing to look for is columns that don't have single quotes around them. If you input an #Inv_Amount# with a comma in it, like 1,000.00, it will think that is 2 fields, because of the comma. Try using: #rereplace(Inv_Amount, "[^0-9\.]+", "", "ALL")# Or even just: #replace(Inv_Amount, ",", "", "ALL")# -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: SQL Question
I am getting the following SQL error: Microsoft][ODBC SQL Server Driver][SQL Server]There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement. This doesn't happen all the time. I can't seem to find what's unique about the records that do insert from those that don't. The insert statement is as follows: cfquery datasource="IS_Budget" name="SaveInvoiceQry" INSERT X_Invoices (Vendor, Inv_GL, Inv_City, Inv_Dept, Inv_Date, Inv_No, Inv_Desc, ApprovedDate, Notes, Inv_Amount) values ('#Vendor#', '#Inv_GL#', '#Inv_City#', '#Inv_Dept#', '#Inv_Date#', '#Inv_No#', '#Inv_Desc#', '#ApprovedDate#', '#Notes#', #Inv_Amount#) /cfquery I'm sure I'm not seeing something obvious. But it looks to me like there are 10 items for each of the values and table columns. Can anyone see what I'm not? Athelene Gieseman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMail Time Stamp
I wrote in earlier too. Someone suggested a service pack. I'm hopeful that I'll soon have time to try that! Athelene Gieseman -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 4:52 AM To: CF-Talk Subject: RE: CFMail Time Stamp Is this the second error of this type I've seen on the list? 2001 bug ? ~ Justin -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 6:20 PM To: CF-Talk Subject: CFMail Time Stamp I have a problem with the time stamp on messages sent through cfmail. My servers clock is set at GMT -0500 but CFMail messages are being stamped with + 0400 wich is affecting the time sent by about 9 hours. Anyone have any insight as to why this is happening or where I go to correct it? Thanks, Chris Stoner ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Newbie Question about Application.cfm
I'm trying to use session variables for the first time. I've gone into CF Administrator and registered the ODBC to use session and client variables. I also added an Application.cfm file to the top directory where the app resides. The following is all I have in that file: !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleApplication Template/title /head cfapplication name="ISBudgetApp" clientmanagement="Yes" sessionmanagement="Yes" setclientcookies="Yes" body /body /html The application seems to work fine until I refresh. When I do that, the page just comes up blank, no error message, and the title on the browser is "Application Template". Sorry to ask what should be a simple question. But I've read through my books and can't figure this out. Help, please? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Newbie Question about Application.cfm
That was it! Thank you to all who answered. Athelene -Original Message- From: Nick Slay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 4:54 PM To: CF-Talk Subject: Re: Newbie Question about Application.cfm Hi Athlene, The Application.cfm file should not have any HTML in the file, otherwise that get's put on the page. The CFAPPLICATION tag should be the first thing in the file. After that you can set your session variables, and output header code etc etc Nick From: "Gieseman, Athelene" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 09 Jan 2001 15:51:53 -0600 To: CF-Talk [EMAIL PROTECTED] Subject: Newbie Question about Application.cfm I'm trying to use session variables for the first time. I've gone into CF Administrator and registered the ODBC to use session and client variables. I also added an Application.cfm file to the top directory where the app resides. The following is all I have in that file: !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleApplication Template/title /head cfapplication name="ISBudgetApp" clientmanagement="Yes" sessionmanagement="Yes" setclientcookies="Yes" body /body /html The application seems to work fine until I refresh. When I do that, the page just comes up blank, no error message, and the title on the browser is "Application Template". Sorry to ask what should be a simple question. But I've read through my books and can't figure this out. Help, please? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Refresh Page
Thanks. I tried this but get errors. Tells me that it can't find the page. Am I misunderstanding how it should be used? I used a CFSET to create the #SomeRandomValue#. Then, in the CFSET that creates the URL I added re=#SomeRandomValue#. I tried with and without quotes. Is there some way in particular that I should be appending it? FYI, I'm using CFLOCATION to set the URL for that page. Thanks in advance. Athelene -Original Message- From: Gena [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 10:10 PM To: CF-Talk Subject: Re: Refresh Page add to the end of URL re=#SomeRandomValue# and generate new SomeRandomValue every time. Regards - Original Message - From: "Gieseman, Athelene" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 19, 2000 2:51 PM Subject: OT: Refresh Page I'm having a problem with getting a page to refresh. I have a frame with two windows. The left window is a form with a cfselect. When the user selects an option, a word document is displayed in the right-hand frame. This works fine the first time. However when the user then selects another option from the left frame and submits the form, the right-hand frame does not load the new document unless you hit the refresh button on the browser. Can anyone help me with either 1) why the window won't bring up the new file without a refresh? or 2) what would be the javascript to refresh the whole frame page? I've tried several variations on document.refresh and other scripts to no avail. Any help would be appreciated. Athelene Gieseman [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Refresh Page
Not silly. I'm a newbie for sure! My original code for the page that was being called from the form was: (Selectdoc is the name of the form field that the user selects by.) cfset comparedate=#Dateformat(SelectDoc, "MM/DD/")# cfquery datasource="Erisa" name="GetDocDate" Select * from Minutes_Tbl where DOCDATE = '#comparedate#' /cfquery html cfset NewFile=#DateFormat(GetDocDate.docdate, "MMDD")# ".rtf" cfset ViewDoc="\PG_ERISA\MINUTES\DOCS\" #NewFile# head titleDisplay Document from iManage/title /head cflocation url="#ViewDoc#" addtoken="No" body script language="JavaScript" type="text/javascript" !-- Hide from old browsers parent.document.refresh //End hiding script from old browsers-- /script /body /html __ This works fine except that you have to click on the Refresh button on the browser to make the text of the document appear. When the page comes up, you can see the Word ruler bar look in the frame, but not the text. Thanks in advance for any input. Athelene -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 9:41 AM To: CF-Talk Subject: Re: Refresh Page Silly question, but are you putting your variable in cfouputs? Todd Ashworth - Original Message - From: "Gieseman, Athelene" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 19, 2000 10:00 AM Subject: RE: Refresh Page | Thanks. I tried this but get errors. Tells me that it can't find the page. | Am I misunderstanding how it should be used? I used a CFSET to create the | #SomeRandomValue#. Then, in the CFSET that creates the URL I added | re=#SomeRandomValue#. I tried with and without quotes. Is there some way | in particular that I should be appending it? FYI, I'm using CFLOCATION to | set the URL for that page. Thanks in advance. | | | Athelene | | -Original Message- | From: Gena [mailto:[EMAIL PROTECTED]] | Sent: Thursday, November 09, 2000 10:10 PM | To: CF-Talk | Subject: Re: Refresh Page | | | add to the end of URL re=#SomeRandomValue# and generate new SomeRandomValue | every time. | | Regards | | | - Original Message - | From: "Gieseman, Athelene" [EMAIL PROTECTED] | To: "CF-Talk" [EMAIL PROTECTED] | Sent: Tuesday, December 19, 2000 2:51 PM | Subject: OT: Refresh Page | | | I'm having a problem with getting a page to refresh. I have a frame with | two windows. The left window is a form with a cfselect. When the user | selects an option, a word document is displayed in the right-hand frame. | This works fine the first time. However when the user then selects | another | option from the left frame and submits the form, the right-hand frame does | not load the new document unless you hit the refresh button on the | browser. | Can anyone help me with either 1) why the window won't bring up the new | file | without a refresh? or 2) what would be the javascript to refresh the whole | frame page? I've tried several variations on document.refresh and other | scripts to no avail. Any help would be appreciated. | | Athelene Gieseman | [EMAIL PROTECTED] | | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Refresh Page
I'm having a problem with getting a page to refresh. I have a frame with two windows. The left window is a form with a cfselect. When the user selects an option, a word document is displayed in the right-hand frame. This works fine the first time. However when the user then selects another option from the left frame and submits the form, the right-hand frame does not load the new document unless you hit the refresh button on the browser. Can anyone help me with either 1) why the window won't bring up the new file without a refresh? or 2) what would be the javascript to refresh the whole frame page? I've tried several variations on document.refresh and other scripts to no avail. Any help would be appreciated. Athelene Gieseman [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Order By Question
I've got a query that works fine except that it seems to be ignoring the order by clause. It seems to be sorting in order of the primary key. Any suggestions? The query is: cfquery datasource="HelpDesk" name="EditRecordqry" Select *, DATENAME(MM, CALLDATE) + ' ' + DATENAME(DD, CALLDATE) + ', ' + DATENAME(, CALLDATE)AS 'DATEOFCALL', DATENAME(MM, LASTUPDATE) + ' ' + DATENAME(DD, LASTUPDATE) + ', ' + DATENAME(, LASTUPDATE)AS 'LU', Ext, EmailAddress from CALLS, USERS WHERE (CALLS.Closed='N' or CALLS.Closed IS NULL) AND (CALLS.Name = USERS.Name) order by Users.Name /cfquery I've also tried sorting by CALLS.Name, same result. Athelene Gieseman [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Time Stamp on CFMAIL email
I'm a bit confused as to where the time stamp comes from in the header of the email when sending an email via CFMAIL. We have a help desk database that emails our users when their call is entered into the database. The email includes, in the text, the date/time of the call (a field in the database itself.) That text is correct. However, the header of the email indicates that it happened about 11 hours earlier. I tried telling the users that we are just so good that we actually anticipate and close their calls before they even think to report the problem. Unfortunately, they're not buying it. I've checked the date/time on the CF Server, Exchange server and the help desk technicians PC. All check out fine. I also checked the time zone on each. Again, all looks fine. Can anyone point me in the right direction of where to look next? Athelene Gieseman [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Time Stamp on CFMAIL email
Sorry to be a pest. But I thought it might be helpful to copy the email that was sent out by CF. Again, I have verified the date/time and time zone on the CF server, exchange server and client pc. I also noted that our PDC was not accurate and corrected that with the same results. The following is the message. You can see the date field in the database in the message text. That was the correct date and time. But the message header is incorrect. I've taken a look at all of our other mail (i.e., not generated thru CF) and it's fine. Any thoughts would be much appreciated! The message from CF: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 9:57 PM To: [EMAIL PROTECTED] Subject: New Help Desk Ticket Thank you for reporting your issue to the Help Desk. Your call was logged into our database at 2000-12-01 08:56:00. If your problem was not resolved at the time of your call you will be hearing back from a technician shortly. Call Information Ticket Number: 894 Problem Description: test ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and IIS
I tried this just recently. Unfortunately, the user name it returned was the one that we use to log into the CF services. In other words, I logged into the web as user ABC and when I use the cgi.auth_user variable, it returns user XYZ. Can anyone shed any light on what I may be doing wrong? Also, I've searched for a place that would document those cgi variables. (I'm respectful of the comments on this list about using other resources first.) But I've had no luck. Any suggestions on where I could learn more? Several trips to the bookstore have gotten me no where. Of course, I love the bookstore and their thousands of technical guides. So it hasn't exactly been torture. :-) Athelene [EMAIL PROTECTED] -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 28, 2000 11:40 PM To: CF-Talk Subject: Re: CF and IIS Refer to the cgi variable cgi.auth_user. It will contain both the domain name and the username as in: MYNTDOMAIN\bob Jim - Original Message - From: "S R" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, November 28, 2000 5:43 PM Subject: CF and IIS Hi, Does anyone know how to have CF query IIS in order to grab the login name of someone who has logged into a website, via IIS? The alternative for me would be to set up a webpage based log in screen that coldfusion controls and grab the info that way, but I am exploring the IIS option first. Thank you SR ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfselect question
I usually do so in the sql select statement. By adding something like: Select *, LNAME + ', ' + FNAME AS FULLNAME order by FULLNAME Then I use the column FULLNAME in the cfselect. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: .elizabeth. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 28, 2000 11:23 AM To: CF-Talk Subject: cfselect question Okay, pretty simple question here: I have a cfselect form field that is being populated by the LName column in my Contacts table: cfselect name="ID" required="yes" query="qContacts" value="ID" display="LName" The code above works fine; my select box gets populated with all the last names in the contacts table. BUT, I need to display the contact's first AND last name (two separate columns in the database), and not just the last name. Is there a way to get the select box to display both columns? Thanks a lot, elizabeth ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ack!! Another CFGRID problem
Thanks. I've narrowed it down. Each time I try to apply a number format to one of the fields, this happens. The really strange thing is that once I apply the format, even if I later remove it, the same thing happens. For this particular app I'm happy to live with ugly numbers. But I don't know what I'll do when I really need to format them. Thanks for the help! Athelene -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Monday, November 20, 2000 9:10 AM To: CF-Talk Subject: RE: Ack!! Another CFGRID problem The only time I have had this happen is when I have some missing field in my cfgridrow... actually when I'm doing cfgrid outside of a cfform I have it happen for other reasons you probably won't experience while using the standard tags inside cfform... crazy... good luck. je -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 19, 2000 8:00 PM To: CF-Talk Subject: Ack!! Another CFGRID problem Tonight I had a problem with viewing a grid for the first time. I've read on this list that sometimes the grid isn't stable. So I'm wondering if that's the problem. The symptop is that the grid comes up. It appears to be blank, it's all just grey, no columns, rows, etc. But if you click somewhere within the grid, the data in that cell appears. (The grid mode is EDIT.) But only that cell appears. When you click on a different area, that cell appears and the other disappears. Help! Can someone tell me why this would happen? TIA. Athelene Gieseman [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Ack!! Another CFGRID problem
Tonight I had a problem with viewing a grid for the first time. I've read on this list that sometimes the grid isn't stable. So I'm wondering if that's the problem. The symptop is that the grid comes up. It appears to be blank, it's all just grey, no columns, rows, etc. But if you click somewhere within the grid, the data in that cell appears. (The grid mode is EDIT.) But only that cell appears. When you click on a different area, that cell appears and the other disappears. Help! Can someone tell me why this would happen? TIA. Athelene Gieseman [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_GRID question
I have another cfgrid question, is there anyway to have certain rows appear in a different color text? or bold or some other way to make certain rows stand out? Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: McCollough, Alan [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 6:36 PM To: CF-Talk Subject: CF_GRID question Hi, I've got a CF_GRID question, and not being a frequent CF_GRIDder, I figger here is the place to ask! I've got a CF_GRID in a form, and what I want to do is let the user select a row in the grid. Easy enough. BuTtTt, how do I pass a 'default' value to the CF_GRID tag, so that, say, the user's prior selection appears highlighted in the grid? And while I'm asking, is there some way to require a selection from the CF_GRID, as you would with a CFINPUT... required="yes" ?? Alan McCollough Web Programmer Allaire Certified ColdFusion Developer Alaska Native Medical Center ~~ Structure your ColdFusion code with Fusebox. Get the official book at https://secure.houseoffusion.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Newbie Security Question
The latest is that I setup my website to only allow registered users and the users are now prompted to login (integrated with NT authentication.) However, when I use CFOUTPUT with the variable #cgi.auth_user#, I get DOMAINNAME\Administrator as the output. I'm not logging into anything as Administrator. If someone could shed some light I'd be appreciative. Also, can someone recommend a good book on using the cgi variables or IIS? I plan a trip to the book store tonight! Thanks in advance. Athelene [EMAIL PROTECTED] -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 14, 2000 10:25 AM To: CF-Talk Subject: Re: Newbie Security Question Have you tried using #cgi.authuser#?, or is it auth_userI can never remember and have to always test it or look it up. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Newbie Security Question
I've been watching this list for a while and reading what I can find. Yet I'm still stuck. Please tell me if I've missed something. I have an application where I want the user to see only those sql records (using MS SQL 7.0) where a certain field is equivalent to their NT user id. It seems from what I've seen that it either can't be done or I may need some other component to make that happen. Is there a way to evaluate what the NT user id is? I don't need to validate their password. Once they've logged in I can assume they are that user. So all I really need is to be able to write a query that would select only the records where the field USERNAMEFIELD EQ #this is what I'm missing#. Can someone point me to a resource for figuring this out? TIA. Athelene Gieseman [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Newbie Security Question
OK. This is where my ignorance will really show. How do get the user id from NT? In other words, how do I set that variable? I'm sure I'm just missing something obvious. My apologies. Athelene -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 14, 2000 11:30 AM To: CF-Talk Subject: Re: Newbie Security Question You could save their NT user ID in a session variable and refer to that everytime you want to run a query. Kevin Schmidt Internet Services Director PWB Integrated Marketing and Communications Office: 734.995.5000 Mobile: 734.649.4843 - Original Message - From: "Gieseman, Athelene" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, November 14, 2000 9:41 AM Subject: Newbie Security Question I've been watching this list for a while and reading what I can find. Yet I'm still stuck. Please tell me if I've missed something. I have an application where I want the user to see only those sql records (using MS SQL 7.0) where a certain field is equivalent to their NT user id. It seems from what I've seen that it either can't be done or I may need some other component to make that happen. Is there a way to evaluate what the NT user id is? I don't need to validate their password. Once they've logged in I can assume they are that user. So all I really need is to be able to write a query that would select only the records where the field USERNAMEFIELD EQ #this is what I'm missing#. Can someone point me to a resource for figuring this out? TIA. Athelene Gieseman [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Newbie Security Question
Thanks. I tried both, but neither worked. I'm not sure I'm using the correct syntax. I tried looking these up in several books but I can't find it anywhere. Where might I learn more about these items and how to use them? Athelene -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 14, 2000 10:25 AM To: CF-Talk Subject: Re: Newbie Security Question Have you tried using #cgi.authuser#?, or is it auth_userI can never remember and have to always test it or look it up. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF editing software - vote
You might look at a product called Deltaview. You can download an eval at: http://www.workshare.net/flash/downloads.shtml Lawfirms use this product to compare revisions in documents. But it's a nice product in that it will compare all kinds of documents including text files, spreadsheets (both lotus and excel), Word, WordPerfect and more. Athelene [EMAIL PROTECTED] -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Friday, November 10, 2000 9:21 AM To: CF-Talk Subject: Re: CF editing software - vote Downloaded a trial of it - pretty good so far. Is it possible for it to compare 2 files and highlight differences, though? If not, does anyone know of a proggie capable of this? Windiff. Also textpad (from textpad.com) will compare two text files, but I don't think it highlights the changes, just prints them to a window. Textpad is a great text editor, by the way, used by a lot of programmers for all kinds of languages. Ryan Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Dynamic PDF
I finally have the web piece of Crystal Reports running and it works quite well. Get a hold of CR version 8 if you can. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Mike Sullivan [mailto:[EMAIL PROTECTED]] Sent: Monday, October 30, 2000 5:53 PM To: CF-Talk Subject: Dynamic PDF -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 All, Is there a way to create PDFs on the fly? My users get a results set from a query and I would like to give them a dynamic way to print it. Any thoughts on how it can be done? TIA Mike -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com iQA/AwUBOf4JHXYFmKomMlANEQJJ9QCgztd+pjH8xqPClOc8t4+C+AyTbGwAoL8i +Qlmxq7j9jccBYIrzdqrT4hA =uLlS -END PGP SIGNATURE- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Background images
I'm having trouble getting background images to work properly on CF pages. Is there something in particular I should be doing to make this work? All of the other formatting in the BODY tag is working fine. But the image doesn't show. It works fine on non-CF pages. Athelene [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Getting a background image to stick
I've been trying to use a background image on some CF pages. The colors, fonts, and all other format options in the body tag seem to work. But the image doesn't display. Can anyone tell me what I might be doing wrong? Also, I need an address to reach a list admin. Seems I'm getting all of my cf-talk messages twor or three times. I love this list. But I'll never get through all the mail! Athelene Gieseman [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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: Anyone using Crystal Reports 8 successfully?!
I just recently worked through this one (with some help from this list!) You'll want to install the CR Web Component Server. Once you have that up on your web server, you can just use a URL to display the report in the browser. From there the user can print it. I'm still having a problem with the refresh though. I've used a datasource in the report. And this works fine as long as I save the data in the report. But if the user clicks on the CR refresh button in the browser, they are prompted for an ID and password. No matter what ID and password I use there, I can't get the report to redisplay. I called Seagate about a week ago to try to figure out how to get around it. After being on hold for over 1/2 hour I accidentally disconnected the line. I haven't had the time to call back and wait again. But I don't think this should be hard to fix. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Mike Deane [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 7:34 AM To: '[EMAIL PROTECTED]' Subject: Anyone using Crystal Reports 8 successfully?! I have small problem, Crystal Reports, version 8. What gives? I am new to cold fusion and the CFREPORT tag does not seem to work and I can't seem to find any online resources to figure this one out. Thank you. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.mail-archive.com/cf-talk@houseoffusion.com/ 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: datasource on a network machine
I'm not sure I fully understand what you mapped. But we have several Access databases here that live on a machine other than the CF machine. We setup a network drive to the directory on the server where the db lives. Then I setup an ODBC connection using that network drive. Is that what you need to accomplish? Our server where the db lives is an NT 4.0 machine. The CF server is W2K. Athelene Gieseman -Original Message- From: Jeffrey Rose [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 16, 2000 2:01 PM To: [EMAIL PROTECTED] Subject: datasource on a network machine greetings list, How can we register an Access datasource on another server on our network? We have tried mapping the drive but this won't work on NT. We ran a test registering and verifying a datasource on a 98 machine and it succeeded. We need to be able to access the datasource on two different CF servers. TIA, - Jeffrey _ Jeffrey Rose XpressTrack: Smartware for Journals [EMAIL PROTECTED] http://xpresstrack.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.mail-archive.com/cf-talk@houseoffusion.com/ 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: response test, please?
7 or 8 seconds. Using Southwestern Bell. Kansas City, Missouri. No matter, I'm sure the site is worth the wait, no? :-) Athelene Gieseman -Original Message- From: Jared Clinton [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 8:50 PM To: [EMAIL PROTECTED] Subject: response test, please? Hi everyone, Can I ask a big favour? Some clients have been complaining of poor response times, I'm pretty sure its not the code (although it could be) but the network setup. We are using UUnet and it seems people on other backbones are experiencing large delays. Could some people please browse to http://www.transact-online.co.uk and tell me approximate load times for the initial page? Also what ISP you are using and whereabouts you are surfing from (if you don't mind telling that is). Thank you in advance, Jared Clinton. Transact Online. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.mail-archive.com/cf-talk@houseoffusion.com/ 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: Newbie Question - Creating Data Source for CSV text file
If your server is NT you can create an ODBC connection using the Microsoft Text Driver (txt and csv). I've experimented with it just a bit and it seems to work on very simple things. I would think that you'd want to weigh how many steps you want to take manipulating and moving data. If the csv driver works consistently, it might make things simpler. On the other hand, if the data is in a database, you have a lot more flexibility. If you don't need that flexibility, having fewer places where a breakdown could occur might be preferable. I know that we have a few processes where we extract information from an Informix database on Unix, have that data FTP'd to an NT Server, then another process runs on the NT server to import the data. Should be fine in a perfect world. But I don't live there! So occasionally some part of that process doesn't automatically run and the update doesn't happen. We're working on getting to the point where the NT application can be updated directly from the Informix database. Less places to break. Another consideration might be the long term plan for the current system. If it's not ODBC, will it be down the road? I would think that the vendor of the product would be moving in that direction. If so, a simple solution might be fine. In that case I'd give the ODBC data source a try. By the way, I usually just create my ODBC data sources right from the control panel. So I'm not sure if you get all of those same options using the CF Administrator. But if you don't, you should be able to just create it from ODBC32 under the Control Panel. Athelene -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:23 AM To: [EMAIL PROTECTED] Subject: RE: Newbie Question - Creating Data Source for CSV text file I have a customer that is a car dealership. They want to put their car inventory online. The company that makes their inventory database tells me that the data store is not ODBC compliant, but that they could output a CSV text file that they will auto-FTP to our servers in the middle of the night. Not exactly the most elegant solution, but it beats entering car data manually. :) Can I create an ODBC connection in the CF Administrator to use a CSV text file as a data source? I tried but I could not get it to verify the data source. You can use CSV files for ODBC datasource, but don't! The main reason is that ODBC holds onto sources like that once it's got them 2 Solutions; Open the CSV using CFFile - it's just a comma separated list per line Make a link table in Access which talks to the CSV - this is the much preferred solution as you can actually run SQL queries on the data This all assumes that the column list and names stay the same, and only the data itself changes Remember also that quotes screw up CSV files royally - so if they have any in their descriptions (as in 14" wheels) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.mail-archive.com/cf-talk@houseoffusion.com/ 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: Multiple value Select
OK. I copied the code into the document. Now it's not liking the first quote in the CFSELECT statement: cfselect name=3D"NewPG" size=3D"3" multiple Did I just misunderstand what the 3D represented? Is there just a syntax error I'm not seeing. Tried to find some reference to it in the books I have (I assumed it stood for dimension?) with no luck. TIA, Athelene -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 7:42 AM To: [EMAIL PROTECTED] Subject: Re: Multiple value Select This is a multi-part message in MIME format. --=_NextPart_000_00EF_01C001FF.3F8198C0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable RE: Multiple value SelectOk, now we have a bit of information. Try this: cfselect name=3D"NewPG" size=3D"3" multiple=20 CFOutput query=3D"GetPG" !--- OPENING CFOUTPUT ---=20 CFIF ListFindNoCase(EditNameQry.PracticeGroup,GetPG.PG)=20 CFSET PGSelected =3D "Selected"=20 CFELSE=20 CFSET PGSelected =3D ""=20 /cfif=20 Option #PGSelected# value=3D"#PG#"#PG#/option !--- NO=20 CFOUTPUTS ---=20 /cfoutput !--- CLOSING CFOUTPUT ---=20 /cfselect=20 Change the order of the parameters to the = Listfindnocase()/Listcontains() functions. If EditNameQry.PracticeGroup = is a comma seperated list and GETPG.PG is a single value, this should = work. DC - Original Message -=20 From: Gieseman, Athelene=20 To: '[EMAIL PROTECTED]'=20 Sent: Tuesday, August 08, 2000 21:36 Subject: RE: Multiple value Select No. That field would have multiple items in a comma-delimited format. = Not=20 even the first option is selected.=20 Athelene=20 -Original Message-=20 From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]=20 Sent: Tuesday, August 08, 2000 4:33 PM=20 To: [EMAIL PROTECTED]=20 Subject: RE: Multiple value Select=20 This may be a stupid question but the query EditNameQry is only = pulling one=20 value for PracticeGroup. Right? If not I'm sure that when you "view=20 source" you'll see that more than one option is "SELECTED". That will = confuse the browser and it will stay on the first option.=20 --K=20 -Original Message-=20 From: Mark Armendariz [mailto:[EMAIL PROTECTED]]=20 Sent: Tuesday, August 08, 2000 2:04 PM=20 To: [EMAIL PROTECTED]=20 Subject: RE: Multiple value Select=20 Yo may have a point.. try putting quotes around = EditNameQry.PracticeGroup.=20 Plus, if I replace=20 CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)=20 with=20 CFIF ListContains(GetPG.PG,"Agribusiness")=20 the Agribusiness option is selected. So I think I'm doing something = wrong=20 in how I'm using the second parameter of the ListContains.=20 -Original Message-=20 From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]=20 Sent: Tuesday, August 08, 2000 4:18 PM=20 To: '[EMAIL PROTECTED]'=20 Subject: RE: Multiple value Select=20 No luck. I think there's a problem in that the listcontains isn't = finding=20 any matches. I can't figure out why. I display the previously = selected=20 items in another part of the form and it is identical to the options = in the=20 database. There is a comma separating the selected items. For = example, the=20 record viewed via SQL shows: "Agribusiness,Commercial Litigation" = (less the=20 quotes) in the field. Both of those practice groups are identically = listed=20 in the GetPG.PG list. Yet neither of them are showing up selected in = the=20 control. Plus, if I replace=20 CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)=20 with=20 CFIF ListContains(GetPG.PG,"Agribusiness")=20 the Agribusiness option is selected. So I think I'm doing something = wrong=20 in how I'm using the second parameter of the ListContains.=20 Athelene=20 -Original Message-=20 From: Mark Armendariz [mailto:[EMAIL PROTECTED]]=20 Sent: Tuesday, August 08, 2000 3:00 PM=20 To: [EMAIL PROTECTED]=20 Subject: RE: Multiple value Select=20 take the cfoutput tags out of the options and put them within the = entire=20 select tag:=20 cfselect name=3D"NewPG" size=3D"3" multiple=20 CFOutput query=3D"GetPG" !--- OPENING CFOUTPUT ---=20 CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)=20 CFSET PGSelected =3D "Selected"=20 CFELSE=20 CFSET PGSelected =3D ""=20 /cfif=20 Option #PGSelected# value=3D"#PG#"#PG#/option !--- NO = CFOUTPUTS ---=20
RE: Multiple value Select
It works!!! Thank you so much to everyone who helped along the way. My goal is to one day be 1/10th as helpful to the list as the list has been to me. At this point (given how much I get and how little I now know), that's a huge goal. Thanks again. Athelene -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 12:25 PM To: [EMAIL PROTECTED] Subject: Re: Multiple value Select I am using Outlook Express, and have it set up to reply to messages in their original format, which in this case is HTML, or to compose new messages in plain text. For some reason the list is not properly handling the mime conversion. To see if perhaps this is fixed, I have changed it to send in plain text only, regardless of the format of the incoming message. It has been annoying to me, because other messages besides mine have been turned to mush. DC - Original Message - From: "Chapman, Katrina" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 09, 2000 17:03 Subject: RE: Multiple value Select The 3D shouldn't be there. It's because a very bad David;) is sending messages in HTML format, or some format other than plain text. Just remove any 3D's you may have copied and it should work. --K -Original Message----- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 8:50 AM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select OK. I copied the code into the document. Now it's not liking the first quote in the CFSELECT statement: cfselect name=3D"NewPG" size=3D"3" multiple Did I just misunderstand what the 3D represented? Is there just a syntax error I'm not seeing. Tried to find some reference to it in the books I have (I assumed it stood for dimension?) with no luck. TIA, Athelene -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 7:42 AM To: [EMAIL PROTECTED] Subject: Re: Multiple value Select This is a multi-part message in MIME format. --=_NextPart_000_00EF_01C001FF.3F8198C0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable RE: Multiple value SelectOk, now we have a bit of information. Try this: cfselect name=3D"NewPG" size=3D"3" multiple=20 CFOutput query=3D"GetPG" !--- OPENING CFOUTPUT ---=20 CFIF ListFindNoCase(EditNameQry.PracticeGroup,GetPG.PG)=20 CFSET PGSelected =3D "Selected"=20 CFELSE=20 CFSET PGSelected =3D ""=20 /cfif=20 Option #PGSelected# value=3D"#PG#"#PG#/option !--- NO=20 CFOUTPUTS ---=20 /cfoutput !--- CLOSING CFOUTPUT ---=20 /cfselect=20 Change the order of the parameters to the = Listfindnocase()/Listcontains() functions. If EditNameQry.PracticeGroup = is a comma seperated list and GETPG.PG is a single value, this should = work. DC - Original Message -=20 From: Gieseman, Athelene=20 To: '[EMAIL PROTECTED]'=20 Sent: Tuesday, August 08, 2000 21:36 Subject: RE: Multiple value Select No. That field would have multiple items in a comma-delimited format. = Not=20 even the first option is selected.=20 Athelene=20 -Original Message-=20 From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]=20 Sent: Tuesday, August 08, 2000 4:33 PM=20 To: [EMAIL PROTECTED]=20 Subject: RE: Multiple value Select=20 This may be a stupid question but the query EditNameQry is only = pulling one=20 value for PracticeGroup. Right? If not I'm sure that when you "view=20 source" you'll see that more than one option is "SELECTED". That will = confuse the browser and it will stay on the first option.=20 --K=20 -Original Message-=20 From: Mark Armendariz [mailto:[EMAIL PROTECTED]]=20 Sent: Tuesday, August 08, 2000 2:04 PM=20 To: [EMAIL PROTECTED]=20 Subject: RE: Multiple value Select=20 Yo may have a point.. try putting quotes around = EditNameQry.PracticeGroup.=20 Plus, if I replace=20 CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)=20 with=20 CFIF ListContains(GetPG.PG,"Agribusiness")=20 the Agribusiness option is selected. So I think I'm doing something = wrong=20 in how I'm using the second parameter of the ListContains.=20 -Original Message-=20 From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]=20 Sent: Tuesday, August 08, 2000 4:18 PM=20 To: '[EMAIL PROTECTED]'=20 Subject: RE: Multiple value Select=20 No luck. I think there's a problem in that the listcontains isn't = finding=20 any matches. I can't figure out why. I display the previously = selected=20 items in ano
RE: Multiple value Select
OK. I have another application where I do in fact use a table for the lookup. I've tried to use your example and apply it here. But nothing is selected. My code is as follows: cfquery datasource="FirmDirectory" name="EditNameQry" Select * from Employees where ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select * from PracticeGroups order by PG /cfquery cfselect name="NewPG" size="3" multiple CFLoop query="GetPG" CFIF ListContains(GetPG.PG,#EditNameQry.PracticeGroup#) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"cfoutput#PG#/cfoutput/option /cfloop /cfselect Note that if I replace the : CFIF ListContains(GetPG.PG,#EditNameQry.PracticeGroup#) with: CFIF ListContains(GetPG.PG,"Agribusiness") Then Agribusiness is in fact selected. So I'm assuming there's something wrong with that one line. Do you happen to see where I went wrong? TIA, Athelene -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 7:44 AM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select I did this sort of thing for an intranet i'm working on with selected company newsgroups... The best way to do it is with a database of your finance types. This will allow you to updae the select statement without changing the hard coding. So the form will always be right. Query that database and the user database. In the user database, you will want to save a comma delimited list of the finance types they are assigned for. When you bring up the select, you can scroll through all the finance types, and if the user had any in his/her list, they will set the FinanceSelected variable to 'selected.' if they're not in the list, FinanceSelected will be blank. Hope this helps... CFQuery Name="GetFinances" datasource="#Application.datasource#" SELECTFinanceName FROM tblFinances ORDER By FinanceName /CFQuery CFQuery Name="GetCustomer" datasource="#Application.datasource#" SELECTCustomerName, Address, Finances!--- This Field is a comma delimited list of the user's finances --- FROM tblCustomers WHERE CustomerID = #Attributes.CustomerID# /cfgquery Finances:br Select Name="Finances" size="#GetFinances.RecordCount#" multiple CFLoop query="Finances" CFIF ListContains(GetCustomer.Finances,#FinanceName#) CFSET FinanceSelected = "Selected" CFELSE CFSET FinanceSelected = "" /cfif Option #FiannceSelected# value="#FinanceName#"#FinanceName#/option /cfloop /select Mark Armendariz Righteous Design www.sorighteous.com [EMAIL PROTECTED] -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 6:34 PM To: [EMAIL PROTECTED] Subject: Multiple value Select I'm trying to set up a CFSELECT using the SELECTED option. I need to have the CFSELECT set up as multiple since more than one option is permitted. However, I can never seem to get the SELECTED option to properly highlight the options that are already stored in the record. (In other words, I want to create an edit screen where the previously stored values are preselected in this control.) Any thoughts on what I may be doing wrong? The code for my select follows: (Note that ViewGrid is a grid from which the user previously selected this record. I've also tried doing this from a query with the same result - nothing is selected.) cfselect name="FinanceType" size="2" selected="#ViewGrid.FinanceType#" multiple option value="Single Family Housing"Single Family Housing/option option value="501(c)(3)"501(c)(3)/option option value="Hospital Revenue"Hospital Revenue/option option value="Leasehold Revenue"Leasehold Revenue/option option value="Multifamily Housing"Multifamily Housing/option option value="General Obligation"General Obligation/option option value="NID"NID/option option value="Special Obligation"Special Obligation/option option value="Industrial Development"Industrial Development/option option value="TIF"TIF/option option value="TDD/TC"TDD/TC/option option value="Other"Other/option /cfselect -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or se
RE: Multiple value Select
Thanks for the quick response. Tried that and no luck. Athelene -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 12:10 PM To: [EMAIL PROTECTED] Subject: Re: Multiple value Select This is a multi-part message in MIME format. --=_NextPart_000_0242_01C0015B.7347C930 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable RE: Multiple value SelectSee if changing: ListContains(GetPG.PG,#EditNameQry.PracticeGroup#) to ListContains(GetPG.PG,EditNameQry.PracticeGroup) Makes a difference. The # signs are not required inside CF functions. DC - Original Message -=20 From: Gieseman, Athelene=20 To: '[EMAIL PROTECTED]'=20 Sent: Tuesday, August 08, 2000 17:03 Subject: RE: Multiple value Select OK. I have another application where I do in fact use a table for the = lookup. I've tried to use your example and apply it here. But = nothing is=20 selected. My code is as follows:=20 cfquery datasource=3D"FirmDirectory" name=3D"EditNameQry"=20 Select * from Employees where ID=3D'#EditGrid.ID#'=20 /cfquery=20 cfquery datasource=3D"FirmDirectory" name=3D"GetPG"=20 Select * from PracticeGroups order by PG=20 /cfquery=20 cfselect name=3D"NewPG" size=3D"3" multiple=20 CFLoop query=3D"GetPG"=20 CFIF=20 ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)=20 CFSET PGSelected =3D "Selected"=20 CFELSE=20 CFSET PGSelected =3D ""=20 /cfif=20 Option #PGSelected#=20 value=3D"#PG#"cfoutput#PG#/cfoutput/option=20 /cfloop=20 /cfselect=20 Note that if I replace the : CFIF=20 ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)=20 with: CFIF ListContains(GetPG.PG,"Agribusiness")=20 Then Agribusiness is in fact selected. So I'm assuming there's = something=20 wrong with that one line. Do you happen to see where I went wrong?=20 TIA,=20 Athelene=20 -Original Message-=20 From: Mark Armendariz [mailto:[EMAIL PROTECTED]]=20 Sent: Tuesday, August 08, 2000 7:44 AM=20 To: [EMAIL PROTECTED]=20 Subject: RE: Multiple value Select=20 I did this sort of thing for an intranet i'm working on with selected=20 company newsgroups... The best way to do it is with a database of your = finance types. This will allow you to updae the select statement = without=20 changing the hard coding. So the form will always be right. Query = that=20 database and the user database. In the user database, you will want = to save=20 a comma delimited list of the finance types they are assigned for. = When you=20 bring up the select, you can scroll through all the finance types, and = if=20 the user had any in his/her list, they will set the FinanceSelected = variable=20 to 'selected.' if they're not in the list, FinanceSelected will be = blank.=20 Hope this helps...=20 CFQuery Name=3D"GetFinances" datasource=3D"#Application.datasource#" = SELECTFinanceName=20 FROM tblFinances=20 ORDER By FinanceName=20 /CFQuery=20 CFQuery Name=3D"GetCustomer" datasource=3D"#Application.datasource#" = SELECTCustomerName,=20 Address,=20 Finances!--- This Field is a comma delimited = list=20 of the user's=20 finances ---=20 FROM tblCustomers=20 WHERE CustomerID =3D #Attributes.CustomerID#=20 /cfgquery=20 Finances:br=20 Select Name=3D"Finances" size=3D"#GetFinances.RecordCount#" multiple = CFLoop query=3D"Finances"=20 CFIF ListContains(GetCustomer.Finances,#FinanceName#)=20 CFSET FinanceSelected =3D "Selected"=20 CFELSE=20 CFSET FinanceSelected =3D ""=20 /cfif=20 Option #FiannceSelected# = value=3D"#FinanceName#"#FinanceName#/option=20 /cfloop=20 /select=20 Mark Armendariz=20 Righteous Design=20 www.sorighteous.com=20 [EMAIL PROTECTED]=20 -Original Message-=20 From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]=20 Sent: Monday, August 07, 2000 6:34 PM=20 To: [EMAIL PROTECTED]=20 Subject: Multiple value Select=20 I'm trying to set up a CFSELECT using the SELECTED option. I need to = have=20 the CFSELECT set up as multiple since more than one option is = permitted.=20 However, I can never seem to get the SELECTED option to properly = highlight=20 the options that are already stored in the record. (In other words, I = want=20 to create an edit screen where the previously stored values are = preselected=20 in
RE: Multiple value Select
Still no luck. I also added an rtrim function to each of the fields in that line. And I've tried David's suggestion of using listcontainsnocase. Still no luck. I also changed the code this way: CFIF listfindnocase(rtrim(getpg.pg),rtrim(EditNameQry.PracticeGroup)) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "Not Selected" /cfif Option #PGSelected# value="#PG#"cfoutput#PG# #PGSelected#/cfoutput/option so that I would be able to see if the PGSelected was being set at all. When I use this code, the output on all of the options has "Not Selected" after it. So I believe the problem is that the listcontains never finds a match. I've changed the database from a char to a varchar (based on earlier posts about that issue), edited all of the records in the file to eliminate any extra spaces at the end, used the rtrim function. And still it's not ever finding a match. I appreciate the continuing help! This one is making me crazy (well, more crazy than usual.) Athelene -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 1:34 PM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select Try replacing the cfloop with cfoutput like so: cfquery datasource="FirmDirectory" name="EditNameQry" Select* FROM Employees WHERE ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select* FROM PracticeGroups ORDER BY PG /cfquery cfselect name="NewPG" size="3" multiple CFOutput query="GetPG" CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"#PG#/option /cfoutput /cfselect I had the CFLoop in there because i had cfoutputs around it in my code... this should do it for you, if not, let me know... -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 1:03 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select OK. I have another application where I do in fact use a table for the lookup. I've tried to use your example and apply it here. But nothing is selected. My code is as follows: cfquery datasource="FirmDirectory" name="EditNameQry" Select * from Employees where ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select * from PracticeGroups order by PG /cfquery cfselect name="NewPG" size="3" multiple CFLoop query="GetPG" CFIF ListContains(GetPG.PG,#EditNameQry.PracticeGroup#) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"cfoutput#PG#/cfoutput/option /cfloop /cfselect Note that if I replace the : CFIF ListContains(GetPG.PG,#EditNameQry.PracticeGroup#) with: CFIF ListContains(GetPG.PG,"Agribusiness") Then Agribusiness is in fact selected. So I'm assuming there's something wrong with that one line. Do you happen to see where I went wrong? TIA, Athelene -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 7:44 AM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select I did this sort of thing for an intranet i'm working on with selected company newsgroups... The best way to do it is with a database of your finance types. This will allow you to updae the select statement without changing the hard coding. So the form will always be right. Query that database and the user database. In the user database, you will want to save a comma delimited list of the finance types they are assigned for. When you bring up the select, you can scroll through all the finance types, and if the user had any in his/her list, they will set the FinanceSelected variable to 'selected.' if they're not in the list, FinanceSelected will be blank. Hope this helps... CFQuery Name="GetFinances" datasource="#Application.datasource#" SELECTFinanceName FROM tblFinances ORDER By FinanceName /CFQuery CFQuery Name="GetCustomer" datasource="#Application.datasource#" SELECTCustomerName, Address, Finances!--- This Field is a comma delimited list of the user's finances --- FROM tblCustomers WHERE CustomerID = #Attributes.CustomerID# /cfgquery Finances:br Select Name="Finances" size="#GetFinances.RecordCount#" mu
RE: Multiple value Select
No luck. I think there's a problem in that the listcontains isn't finding any matches. I can't figure out why. I display the previously selected items in another part of the form and it is identical to the options in the database. There is a comma separating the selected items. For example, the record viewed via SQL shows: "Agribusiness,Commercial Litigation" (less the quotes) in the field. Both of those practice groups are identically listed in the GetPG.PG list. Yet neither of them are showing up selected in the control. Plus, if I replace CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) with CFIF ListContains(GetPG.PG,"Agribusiness") the Agribusiness option is selected. So I think I'm doing something wrong in how I'm using the second parameter of the ListContains. Athelene -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:00 PM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select take the cfoutput tags out of the options and put them within the entire select tag: cfselect name="NewPG" size="3" multiple CFOutput query="GetPG" !--- OPENING CFOUTPUT --- CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"#PG#/option !--- NO CFOUTPUTS --- /cfoutput !--- CLOSING CFOUTPUT --- /cfselect -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:44 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select Still no luck. I also added an rtrim function to each of the fields in that line. And I've tried David's suggestion of using listcontainsnocase. Still no luck. I also changed the code this way: CFIF listfindnocase(rtrim(getpg.pg),rtrim(EditNameQry.PracticeGroup)) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "Not Selected" /cfif Option #PGSelected# value="#PG#"cfoutput#PG# #PGSelected#/cfoutput/option so that I would be able to see if the PGSelected was being set at all. When I use this code, the output on all of the options has "Not Selected" after it. So I believe the problem is that the listcontains never finds a match. I've changed the database from a char to a varchar (based on earlier posts about that issue), edited all of the records in the file to eliminate any extra spaces at the end, used the rtrim function. And still it's not ever finding a match. I appreciate the continuing help! This one is making me crazy (well, more crazy than usual.) Athelene -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 1:34 PM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select Try replacing the cfloop with cfoutput like so: cfquery datasource="FirmDirectory" name="EditNameQry" Select* FROM Employees WHERE ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select* FROM PracticeGroups ORDER BY PG /cfquery cfselect name="NewPG" size="3" multiple CFOutput query="GetPG" CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"#PG#/option /cfoutput /cfselect I had the CFLoop in there because i had cfoutputs around it in my code... this should do it for you, if not, let me know... -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 1:03 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select OK. I have another application where I do in fact use a table for the lookup. I've tried to use your example and apply it here. But nothing is selected. My code is as follows: cfquery datasource="FirmDirectory" name="EditNameQry" Select * from Employees where ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select * from PracticeGroups order by PG /cfquery cfselect name="NewPG" size="3" multiple CFLoop query="GetPG" CFIF ListContains(GetPG.PG,#EditNameQry.PracticeGroup#) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"cfoutput#PG#/cfoutput/option /cfloop
RE: Multiple value Select
No. That field would have multiple items in a comma-delimited format. Not even the first option is selected. Athelene -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 4:33 PM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select This may be a stupid question but the query EditNameQry is only pulling one value for PracticeGroup. Right? If not I'm sure that when you "view source" you'll see that more than one option is "SELECTED". That will confuse the browser and it will stay on the first option. --K -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 2:04 PM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select Yo may have a point.. try putting quotes around EditNameQry.PracticeGroup. Plus, if I replace CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) with CFIF ListContains(GetPG.PG,"Agribusiness") the Agribusiness option is selected. So I think I'm doing something wrong in how I'm using the second parameter of the ListContains. -----Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 4:18 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select No luck. I think there's a problem in that the listcontains isn't finding any matches. I can't figure out why. I display the previously selected items in another part of the form and it is identical to the options in the database. There is a comma separating the selected items. For example, the record viewed via SQL shows: "Agribusiness,Commercial Litigation" (less the quotes) in the field. Both of those practice groups are identically listed in the GetPG.PG list. Yet neither of them are showing up selected in the control. Plus, if I replace CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) with CFIF ListContains(GetPG.PG,"Agribusiness") the Agribusiness option is selected. So I think I'm doing something wrong in how I'm using the second parameter of the ListContains. Athelene -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:00 PM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select take the cfoutput tags out of the options and put them within the entire select tag: cfselect name="NewPG" size="3" multiple CFOutput query="GetPG" !--- OPENING CFOUTPUT --- CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# value="#PG#"#PG#/option !--- NO CFOUTPUTS --- /cfoutput !--- CLOSING CFOUTPUT --- /cfselect -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 3:44 PM To: '[EMAIL PROTECTED]' Subject: RE: Multiple value Select Still no luck. I also added an rtrim function to each of the fields in that line. And I've tried David's suggestion of using listcontainsnocase. Still no luck. I also changed the code this way: CFIF listfindnocase(rtrim(getpg.pg),rtrim(EditNameQry.PracticeGroup)) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "Not Selected" /cfif Option #PGSelected# value="#PG#"cfoutput#PG# #PGSelected#/cfoutput/option so that I would be able to see if the PGSelected was being set at all. When I use this code, the output on all of the options has "Not Selected" after it. So I believe the problem is that the listcontains never finds a match. I've changed the database from a char to a varchar (based on earlier posts about that issue), edited all of the records in the file to eliminate any extra spaces at the end, used the rtrim function. And still it's not ever finding a match. I appreciate the continuing help! This one is making me crazy (well, more crazy than usual.) Athelene -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 1:34 PM To: [EMAIL PROTECTED] Subject: RE: Multiple value Select Try replacing the cfloop with cfoutput like so: cfquery datasource="FirmDirectory" name="EditNameQry" Select* FROM Employees WHERE ID='#EditGrid.ID#' /cfquery cfquery datasource="FirmDirectory" name="GetPG" Select* FROM PracticeGroups ORDER BY PG /cfquery cfselect name="NewPG" size="3" multiple CFOutput query="GetPG" CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup) CFSET PGSelected = "Selected" CFELSE CFSET PGSelected = "" /cfif Option #PGSelected# va
RE: CF Studio
I've seen it once or twice. I've also saved a file, closed it, opened it and the changes were not there. Thought it was just me. I kind of feel a little better now. :-) I haven't been able to pick up on a pattern of what might be causing it though. Slow network connection maybe? Athelene [EMAIL PROTECTED] -Original Message- From: Ken M. Mevand [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 05, 2000 12:49 AM To: 02 cf-talk Subject: CF Studio anyone has experienced this - after saving a document in studio, close it, then open, the entire file is empty? this has happened many times, and is very, very costly. -ken -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.mail-archive.com/cf-talk@houseoffusion.com/ 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: crystal reports and CF
Just as a follow up: I wrote in earlier about this same issue. I have since upgraded my Crystal Reports version from 7 to 8. I installed the CR Web piece and it works quite well on its own. I'd recommend that you get the Developers version if you plan to do more sophisticated work with it. Athelene [EMAIL PROTECTED] -Original Message- From: Norman Elton [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 8:03 AM To: CF-Talk Group (E-mail) Subject: Re: crystal reports and CF You are correct that CR was bundled "at one stage", unfortunately it is no longer sold this way. I believe version 4.0 was the first to leave it out (someone correct me if I'm wrong here), so older books still refer to it as part of the ColdFusion package. There is a tag for calling Crystal Reports (CFREPORT), but it does not work well with the latest releases of Crystal Reports (version 8). If you really need Crystal Reports, I've been told it's best just to use Crystal's reporting engine rather that can pull from a database rather than trying to integrate it with ColdFusion. Norman Elton Information Technology College of William Mary On Mon, 7 Aug 2000, Phil Palmer wrote: Can anyone tell me how the licensing of Crystal Reports and CF works? I have documentation which implies that a version of Crystal comes with CF but I have scanned the disks for CF Server and CF Studio versions 4.0 and 4.5 but I cannot see it. It doesnt seem to have installed by default. Am I incorrect in assuming that it was bundled as part of CF at one stage? Regards Phil Palmer Technical Director Engage Technology Pty Ltd e [EMAIL PROTECTED] p 0414 353 246 w www.engagetechnology.com.au -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.mail-archive.com/cf-talk@houseoffusion.com/ 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.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Multiple value Select
I'm trying to set up a CFSELECT using the SELECTED option. I need to have the CFSELECT set up as multiple since more than one option is permitted. However, I can never seem to get the SELECTED option to properly highlight the options that are already stored in the record. (In other words, I want to create an edit screen where the previously stored values are preselected in this control.) Any thoughts on what I may be doing wrong? The code for my select follows: (Note that ViewGrid is a grid from which the user previously selected this record. I've also tried doing this from a query with the same result - nothing is selected.) cfselect name="FinanceType" size="2" selected="#ViewGrid.FinanceType#" multiple option value="Single Family Housing"Single Family Housing/option option value="501(c)(3)"501(c)(3)/option option value="Hospital Revenue"Hospital Revenue/option option value="Leasehold Revenue"Leasehold Revenue/option option value="Multifamily Housing"Multifamily Housing/option option value="General Obligation"General Obligation/option option value="NID"NID/option option value="Special Obligation"Special Obligation/option option value="Industrial Development"Industrial Development/option option value="TIF"TIF/option option value="TDD/TC"TDD/TC/option option value="Other"Other/option /cfselect -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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: Hour Format
One way I've done this is to setup my select statement in my query to select the field as an alias name and format that through the SQL. Then, when you refer to the alias in the grid it will appear in the format you want. For example: SELECT *, DATEPART(hh, OLDTIMEHOUR) + ':' + DATEPART(mi, OLDTIMEMIN) AS NEWTIME Then use NEWTIME in your grid. p.s. I use MS SQL 7.0. You'd may need to modify this for another database. Athelene -Original Message- From: Luis [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 03, 2000 12:51 PM To: [EMAIL PROTECTED] Subject: Hour Format How can I format a Hour field into a CFGRID? regards, Luis Ramirez -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.mail-archive.com/cf-talk@houseoffusion.com/ 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.
Newbie Question
I've developed a few CF apps recently. Unfortunately, I work in an industry that still loves paper (law). So I need to be able to give my users print reports. I put Crystal Reports on my server and have developed several reports. And I tried using the CFREPORT tag with no luck. Looking through the Allaire forum it looks like that never will. What do most of you do to provide on-the-fly reporting? Is there another product that will do this? Or am I doing something wrong with what I have? Athelene Gieseman [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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: Lawyers...
I'd be happy to discuss this with you. I'm the Director of Info. Services for a law firm. I've put up two intranets using CF to drive some of the apps. There are a number of questions that you need to answer before you jump in. For example: 1) How large is the firm (number of attorneys?) 2) Which document manager do they use? (PCDOCS, iManage, Worlddox, other?) I've worked for law firms for about 17 years. (I usually tell folks that I just don't know any better!) And I've learned that this environment is very different from the corporate world. If you'd like to contact me directly, please feel free. Athelene Gieseman [EMAIL PROTECTED] (816) 691-3344 -Original Message- From: ClintonGallagher [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 12:14 PM To: CF-Talk Subject: Lawyers... I have an opportunity to do an intranet for a law firm that is operating two regional offices on the Novell Border Manager platform. They use Word Perfect and some other Document Management solution. Search, Document Management and Workflow are important to them. They've tried a Lotus Notes solution on an NT platform and are dissatisfied - with Notes - likely due to development costs. Their Admin has 'heard about' Cold Fusion and has expressed an interest in Cold Fusion as a solution. What do I say? How do I sell a Cold Fusion solution in this scenario? Obviously I must ask, "are there any CFML 'Intranet in a Box' applications that may be appropriate or other custom solutions for law firms I could sell and support with a development partner"? The project is in Milwaukee and extends to the Madison office, both of course in Wisconsin. %= Clinton Gallagher http://home.att.net/~csgallagher/ http://www.metromilwaukee.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.mail-archive.com/cf-talk@houseoffusion.com/ 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: CFTree
I've had this problem before with both the CFTree and CFGrid. It happened when I moved my site to a Win2K server. The problem was in how my IIS was setup to recognize the default server. Apparently, one of those settings let's CF know where to find the directory where those things are stored. Frankly, I did a lot of poking around in the IIS manager and just double-checked all of the port and IP settings. That did the trick. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Brian P. Doyle [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 1:48 PM To: [EMAIL PROTECTED] Subject: CFTree Has anyone used this tag much? I'm trying to use it to create an easily navigatable lsit of categories and subcategories that will pop up in a window and populate a select list. I have the same thing up and running with javascript instead of CF but I need to make it dynamically created by a query (or multiple queries) and CFTree seemed like an easy way to do that. I copied an example tree from the WACK and uploaded it just to get a feel for it. However I'm the only one that can view it for some reason. I sent the link o one of my coworkers and all he gets is the grey rectangle. Sent it to another co-worker with the same results. When we looked at the diagnostic information for the page it said that the applet could not be found. I tried enablecab but that didn't work. Has anyone run into/overcome this problem? Thanks in advance. -Brian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 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.mail-archive.com/cf-talk@houseoffusion.com/ 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.