RE: Fusebox - opinions?
Not to mention the fact you get to be lazier because somebody has already done the documentation for you and it's readily available. Instead of coming up with a bunch of documentation I tediously created and walking the new developer through it I can just say, go to this site and read up. Come back when your done. Lazy is good. Rick -Original Message- From: Kevin Miller [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 3:25 PM To: CF-Talk Subject: RE: Fusebox - opinions? I think the difference is that there is a good chance that an outside contractor might already know Fusebox. That won't be the case for something custom. Kevin [EMAIL PROTECTED] 11/19/01 01:13PM If someone led you to believe there was a real difference...they were mistaken. -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 4:11 PM To: CF-Talk Subject: RE: Fusebox - opinions? I know if I need more developers on a project I don't have to waste time teaching them from the ground up, they can learn on their own. I really fail to see how this is any different than learning any developmental methodology. If someone has to read my methodology docs or someone has to read the fusebox docs they are still spending time reading and learning. What's the difference? ~~ 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) Getting Unique Max() Value
Here's a quick stabb at it: SELECT auc_bids.BIDS_ID, auc_bids.ITEMS_ID, auc_bids.BIDDERS_ID, auc_bids.MAX_BID, auc_bids.WINNING_BID, auc_items.ITEMS_ID, auc_items.ITEM_NUM, auc_items.TITLE, auc_items.DONOR, sum(auc_items.MAX_BID) as ItemMaxBid (SELECT Max(MAX_BID) FROM auc_bids WHERE BIDDERS_ID = #session.BIDDERS_ID#) AS MaxBid, (SELECT Max(WINNING_BID) FROM auc_bids WHERE BIDDERS_ID = #session.BIDDERS_ID#) AS CurrentBid FROMauc_bids, auc_items WHERE auc_bids.BIDDERS_ID = #session.BIDDERS_ID# AND auc_bids.ITEMS_ID = auc_items.ITEMS_ID GROUP BY auc_bids.BIDS_ID, auc_bids.ITEMS_ID, auc_bids.BIDDERS_ID, auc_bids.MAX_BID, auc_bids.WINNING_BID, auc_items.ITEMS_ID, auc_items.ITEM_NUM, auc_items.TITLE, auc_items.DONOR, MaxBid Rick -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 4:49 PM To: CF-Talk Subject: (sql) Getting Unique Max() Value I'm working on a charity auction application. I have a page where I want to output all of a logged-in user's bids. The page needs to show the item bid on, the current bid, the user's max bid. Here's the SQL I've tried: SELECT auc_bids.BIDS_ID, auc_bids.ITEMS_ID, auc_bids.BIDDERS_ID, auc_bids.MAX_BID, auc_bids.WINNING_BID, auc_items.ITEMS_ID, auc_items.ITEM_NUM, auc_items.TITLE, auc_items.DONOR, (SELECT Max(MAX_BID) FROM auc_bids WHERE BIDDERS_ID = #session.BIDDERS_ID#) AS MaxBid, (SELECT Max(WINNING_BID) FROM auc_bids WHERE BIDDERS_ID = #session.BIDDERS_ID#) AS CurrentBid FROMauc_bids, auc_items WHERE auc_bids.BIDDERS_ID = #session.BIDDERS_ID# AND auc_bids.ITEMS_ID = auc_items.ITEMS_ID The problem is, the MaxBid, for example, all come out with the highest bid for all items bid on by this user. In other words, if the user bid $1,000 on Item A and $10 is his high bid on item B, Item B is still listed as having a high bid of $1,000. So I'm trying to figure out how to get a unique Max() value for each item as a separate item. H. ~~ 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
originating domain
Does anybody know a way to get the originating domain the user is accessing your site from? Thanks, Rick ~~ 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: Disabling back button
I think this was it: script language=JavaScript type=text/javascript window.history.forward(); /script Rick -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 7:58 AM To: CF-Talk Subject: RE: Disabling back button I remember some time ago seeing a script (I think it was at www.javascript.com ) that replaced the history of the back button with the current page. This essentialy disables the back button. And if my memory serves me correctly, it was just a little snippet of code. Mark -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 3:51 PM To: CF-Talk Subject: Disabling back button Is there a possible and simple way to do this - or is it a nightmare to do? Will ~~ 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
from web media to print?
I wanted to get feedback on how you all handle print versions of your data. I've had a number of clients that after I've built this great site with administrable content, they call up and say Why don't the products print out on my printer like they show up on the website?. For some reason they think a product catalog on a website should transfer automatically transfer over to a print catalog. Have any of you found good ways to deal with this. I'm looking for suggestions/direction because this comes up all the time and I have yet to provide my clients with a good flexible solution. Thanks, Rick ~~ 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: Throttling CFMAIL
You could use a meta=refresh for whatever interval you wanted. Then use a session variable to keep track of what record your on and increment it every time the page loads. Make sense? Rick -Original Message- From: DSJ / PC1, Inc. [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:24 PM To: CF-Talk Subject: Throttling CFMAIL Does anyone know how I would be able to throttle a batch of cfmail processes? For instance, let's say I've got a database of 1000 e-mail addresses (opt-in of course), and I want to wait 30 seconds between each one that get's sent out. Any way I can do this? Thanks, Dennis St. John PC1, Inc. ~~ 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
DELETE FROM TABLE -Original Message- From: Rayna Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 2:36 PM To: CF-Talk Subject: SQL I am trying to clear some data out of a table i created which is used in a CF application I am developing. I don't want the data in the table anymore (it's a development table so no harm if I delete the data). I know the SQL statement is Truncate to delete the data and not the table, but I can't figure out what the statement is or how it should be correctly worded. Any help would be greatly appreciated. Thanks, Rayna Rayna Evans AAMC 2501 M Street, 2nd Fl Washington, DC 20037 202-862-6243 (direct) Extension 4243 (internal) ~~ 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
reg expression help please?
Hoping someone with regular expression knowledge could help me. I need to take a string and eliminate everything but numbers, - negative signs and . decimal points. Basically just leaving pos and neg decimal numbers filtering out anything else. Anyone willing to help? Thanks, Rick ~~ 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
cf mail hanging
I'm having a periodic problem where a message is hung in the cf mail spooler directory on the cf server and is sent over and over again until it's cleared out. When I log onto the server there is usually a Dr. Watson error that need to be cleared out before the message can be delete. Anyone have any ideas on what may be causing this? The server is a Pentium NT 4.0, IIS 5.0 and cf server 4.5. Thanks, Rick ~~ 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
OT - dynamically populating pdf forms
I found some archives that said the best way to do this is to use acrobat to create the forms and a fdf file. Then use this fdf file as a template to create on the fly with cf populated with the data you want to use. What I'm hoping is that somebody has some sample code (would make a good custom tag too) to dynamically create these fdf files. Anybody know of anything to save me some time on this? Thanks, Rick ~~ 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
SOT: Form builder software
Hi all, I need to find a better solution than html forms to meet my clients needs. My client has a bunch of paper forms and documents that he wants to use online. I've tried creating these in html but the lack of formatting and print control is causing some problems. Not to mention the huge amount of time it's taking. Does anybody know of a better way to create these forms online. I need them to be able to except input from a database to populate the fields in the form and to be manually updateable online. I found one product that may work, it's called Liquid Forms and converts the forms to editable pdf versions. Any other solutions out there you guys can recommend? Thanks, Rick ~~ 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: GROUP BY gives an error?
A better question is what the heck are you trying to do. If you use a group by clause in sql you either need to include each field you're selecting in the group by clause or do some sort of aggregate function to them. If you trying to group the query by makename, then just order by makename in the sql code and use cfoutput query= group=makename to group it in your output. Rick -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 6:31 PM To: CF-Talk Subject: GROUP BY gives an error? Hello cf-Talk, I have a simple query. cfquery name=best datasource=#Application.dsn# SELECT modelname, modeldescription, makename, year FROM MODELS WHERE rating = 'Very Compatible' GROUP BY makename /cfquery It keeps giving me this error:ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'modelname' as part of an aggregate function. What the heck am I missing here? The makename field is a lookup field in an Access database, would this have anything to do with it? So far the lookup has worked fine in queries. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ 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 - batch printing dynamic pages
Does anybody know of a way to batch print a bunch of dynamic cf pages? Basically, is what I want to do is collect some data from the user by a form and then using that data to fill in the dynamic content, print out a number of documents. This needs to be done by clicking a button if at all possible. I have the forms and the templates built. Just don't know how to trigger the print job for the user. Thanks, Rick ~~ 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
Creating Dynamic documents
Hello all ye people, Does anybody know of a way to let a user build documents dynamically and include fields that can be dynamically inputted from a previous form. For example, I would like the user to be able to create a buyer contract for a product, allow them to add whatever legal terms and conditions that might apply, and then make this document live for the customer. So when the customer go's to buy the product they will get asked a number of required questions (based on what parameters where specified as being required when the document was made), then these answers will be used to dynamically create the document with all the required info. Hopefully that made at least a little bit of sense. Thanks for any help! Rick ~~ 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: catalog.wci filling up hard drive space?
We have a server that is filling up hard disk space very quickly and most of the growth is happening in this catalog.wci folder. Is this the logging folder for index server? If not what is it used for and how can I control it's growth? Thanks, Rick ~~ 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 - synch files automatically
I am having problems replicating images across to load balanced servers. We have users that are upload images to one server and need to have an automated way to check the other server for this file and if it doesn't exist we need to transfer a copy over. Has anyone came across any solutions for this. Thanks for any help! Rick ~~ 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: Resume Field
We use WebEditPro for similar needs which has always been bought fairly cheaply for unlimited access per domain name. I think it's 300 per domain name unless you buy ten or more. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 2:42 PM To: CF-Talk Subject: RE: Resume Field Check out ezEdit (www.siteobjects.com) IE only. There used to be a Java Editor floating around. Very limited functionality. Duane -Original Message- From: Christine Kelley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 3:03 PM To: CF-Talk Subject: Resume Field Hi all! Is there a custom tag that has a textarea that will accept formatting? Example...there is a textarea now where people can enter their resumes, but all the formatting (spacing) gets lost due to the ignoring of white space. People just like to copy their resumes from Word and paste them into the field. The field should just accept regular text (not HTML). I've looked in to EWebEditPro, but I believe there is a limit on how many people can use it at once (unless an unlimited user license is bought...expensive). Any ideas? Any help is greatly appreciated :) Christine ~~ 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
How do i set up a Java CFX tag.
I need to use a cfx tag written in java and am not sure how to set it up. Do I need to install a Java Virtual Machine on the server? Any thing else required? The error I get now is asking me to set up a JVM on the server. How do I do this. Can someone help me get started? Thanks, Rick ~~ 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
exploiting shopping carts
Hey all, I just got this article today about how people are exploiting shopping cart logic to change prices and essentially stealing products. After some testing on my own carts I have been able to exploit some of them by building a form with all there required hidden fields and modifying there values. Of course this wouldn't be a problem if they weren't sending pricing information as a hidden variable but many of them do. Do you guys have any recommendation for preventing this on carts built this way? I've thought of checking the http_referer to make sure the request comes from the same domain the site is in but I'm not sure there isn't a better solution that I'm missing. I've attached the address to the article for you all to read. http://msn.zdnet.com/msn/zdnet/story/0%2C12461%2C2692337-hud00025mn6%2C00.ht ml Rick ~~ 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
verity error
Hey all, I'm getting this verity error now when I try and search, create, or index a verity collection: Error occurred in tag CFSEARCH Internal Error: VDKSessionNew failed Error Code: -100 Anybody have any suggestions? I've been searching everywhere I can think and haven't found any solutions. Thanks! Rick ~~ 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: verity error
I found the problem. Apparently you need a "common" directory under the verity directory. I just copied it from another server with the same version and the problem was fixed. Just in case anybody else runs into this. Rick -Original Message----- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 2:59 PM To: CF-Talk Subject: verity error Hey all, I'm getting this verity error now when I try and search, create, or index a verity collection: Error occurred in tag CFSEARCH Internal Error: VDKSessionNew failed Error Code: -100 Anybody have any suggestions? I've been searching everywhere I can think and haven't found any solutions. Thanks! Rick ~~ 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
Can CF work with a FileMakerPro database?
I've been asked if I can interface with a FileMaker database using CFS. I understand that the 5.0 version of FileMaker does support ODBC connections. I would then assume there wouldn't be any problems working with the information in this type of database but I would like someone to confirm that for me. Can anybody verify that this is a feasible solution to use CF to interface with a FileMaker Pro 5 database? Is there anything I should be aware of before I commit to this? Thanks, Rick ~~ 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: connecting to remote SQL server via TCP-IP
Make sure you have your default network library set to tcp-ip (this is in your "client network utility" on your machine). Rick -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 1:06 PM To: CF-Talk Subject: OT:connecting to remote SQL server via TCP-IP Hi Can anyone give me any guidelines on how to setup a SQL server to allow remote access through enterprise manager? I try connecting to the IP address of the machine, but I get the error : Client unable to establish connection|ConnectionOpen (CreateFile() in SQL server registration. Thanks Daniel Lancelot Web Developer Netstep Corporate Communications Tel +44 (0) 1422 200308 Fax +44 (0) 1422 200306 e-mail: [EMAIL PROTECTED] www: http://www.netstep.co.uk NOTE: The information contained in this e-mail is intended for the named recipient(s) only. It may also be privileged and confidential. If you are not an intended recipient, you must not copy, distribute or take any action in reliance upon it. No warranties or assurances are made in relation to the safety and content of this e-mail and any attachments. No liability is accepted for any consequences arising from it. ~~ 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: Input type=File
Here's a script I got to change the file button to an image. It might give you some ideas at least. form name="form" input type="Text" name="textField" action="beautyFileUpload.htm" input type="image" src="whatever.gif" name="button" value="File Upload" onclick="document.form.fileField.click(); return false;"br span id="fileField" style="display:none;"input type="File" name="fileField" onchange="document.form.textField.value=document.form.fileField.value;"/sp an input type="Submit" /form Looking over it again it looks like it just uses a button image type and then uses javascript to invoke the file functionality when clicked. So, I'm sure you could do the same thing with a regurlar button type and give it the text you would like instead of using an image. I've tested it with an image and it works in IE anyway. Rick -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 8:34 AM To: CF-Talk Subject: Input type=File Is there a way to change the button text on a file field? Rick ~~ 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
Verity doesn't work with office 2000 documents!
Anybody else run into this. Apparently with cfs versions 4.0 and 4.51 verity will not index office 2000 documents. This is having a huge impact on my sites. Has anybody found a way to work around this. Possibly by using alternative verity application? Thanks for any help! Rick ~~ 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
duplicate() or readonly lock?
I have some confusion on reading shared memory variables. I've been using a read locks to read shared memory variables to a request scope for using through the site, but I've recently heard of people using the duplicate() function to read shared memory variables. Can anybody help me why I should use one method over the other? Also, with the duplicate function do I still need to lock it? Thanks for any help on this. I'm thoroughly confused on this already confusion subject. Rick ~~ 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
a single quote bug with cf4.0?
I'm having a problem with a query. I've isolated the problem to a field that contains a single quote and can't figure out why it's now escaping it correctly. Is there a bug with cf 4.0 with not escaping single quotes, or is it something else? Thanks for any help! Here's the error I'm getting: ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. SQL = "Insert into Reference (LegacyNum, DocumentLink, Title, PubAbbr, Authors, CorporateSource, PubName, ConferenceLocation, MeetingDate, Publisher, Availability, ISSN, ISBN, LibCongressNum, CODEN, OrderNum, PubDate, PubYear, Edition, VolumeNum, IssueNum, Pagination, Pages, Language, Notes, DocType, MediaType, Abstract, Descriptors, ADD_Date, ADD_Initials, CHG_Date, CHG_Initials) Values('JAW71029', '', 'Water Utilities'' Use of Plastic Pipe: Skagit County', 'JAW', 'Yale, Robert A.', '', 'Journal American Water Works Association', '', '', 'AWWA', 'AWWA', '0003-150X', '', '', 'JAWWA5', '', 'February', '1971', '', '63', '2', '124-126', '3', 'English', 'tables', 'Jnl Article', '', 'The successful use of plastic material pipes in the Public Utility District No. 1 of Skagit County Washington is discussed. One reason for the success is having experienced installers, keeping in contact with manufacturers and using conservative pressure ratings. The water district also has experienced cost savings using the plastic pipe.', 'Plastic Pipe^Costs', 'DAW', '19951002', '', '')" ~~ 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: Getting Rid of a Query
Maybe version 5.0 with it's partial rendering will provide some of this functionality. Rick -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 12:23 AM To: CF-Talk Subject: Re: Getting Rid of a Query Rick, Thanks. I'm pretty sure as well that the query doesn't persist between requests, but maybe I didn't state this clearly enough. If I've got a template that does a huge amount of processing, with many queries and other memory-intensive operations, I'd just as soon release memory ASAP _during_ the processing of the template. Once again, I'm not sure how to do this, or even if CF's memory management and deallocation mechanisms go into play before a template is fully processed. It would be good to know, however. Jim - Original Message - From: "Rick Lamb" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 6:09 PM Subject: RE: Getting Rid of a Query I'm pretty sure that the only time the query is resident in memory is during the initial request, unless you specify it to be cached or set to a session variable. So I don't think that is going to get you anywhere. Although, it might be a good idea to look into a way to make sure the odbc connection doesn't persist beyond the initial database call. I'm not sure the best way to do this. I know you can specify in CF admin not to maintain database connections. You may also look into using CFUSION_DISABLE_CONNECTIONS([DSN],1) to kill the connection. Rick -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 6:20 PM To: CF-Talk Subject: Getting Rid of a Query I need to run a query to create a list via ValueList(). Afterwards I no longer need the qeury itself. How can I get rid of it (deallocate the memory used) and does this actuall free the memory immediately? If it doesn't, I suppose there's no real point. Jim ~~ 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: CFLOCK question
Yep. I would say a for sure chance. Only a 4.5 attribute. Use the name attribute instead. Rick -Original Message- From: JB Mentzer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 9:25 AM To: CF-Talk Subject: CFLOCK question Hi all I'm attempting to execute this: cflock scope="APPLICATION" timeout="30" type="EXCLUSIVE" On CF Server 4.0. This is the error I'm getting: Just in time compilation error An unknown attribute 'scope' has been encountered at document position (35:10) to (35:14) while processing tag CFLOCK. This tag can only take the following attributes: NAME THROWONTIMEOUT TIMEOUT TYPE I removed the attribute and the error goes away. Any chance that CF Server 4.0 doesn't support the scope attribute? Thanks! * John * ~~ 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: How to kill session variables ???
With 4.5 session variables are stored as a structure. So you can use structDelete function to delete. Rick -Original Message- From: Vani Kolli [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 4:43 PM To: CF-Talk Subject: How to kill session variables ??? Can anyone help me how do i kill session varibales explicitly ?? Thanks Vani ~~ 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
cfstoredproc vs. exec storeproc
Do any of you guys know what the advantages are when using the cf tag cfstoredproc instead of just executing the stored procedure through a sql statement? It seems easier and cleaner to me to do it through a sql statement, but they must have developed the tag for a reason. What am I missing? Thanks, Rick ~~ 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: executing a dts package
I'm trying to execute a dts package through CF but have only been able to do it through the dtsrun.exe utility and using cfexecute. The problem is the server I need to do this on doesn't have dts installed. Is there anyway I can still execute a dts packaged from this machine? Maybe using a stored procedure? Thanks! Rick ~~ 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: killing locks on files?
That will help in some cases, but usually it's because somebody is reading the file or downloading the file via cffile or cfcontent. I would like to be able to kick them out regardless of what there doing and make modifications to the file. Rick -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 6:10 PM To: CF-Talk Subject: RE: killing locks on files? you can kill DSN locks using CFUSION_DISABLE_DBCONNECTIONS (4.5.x only) if a query of the excel file has caused the lock. you didn't specify what "process" has locked the file though. -Original Message----- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 3:05 PM To: CF-Talk Subject: killing locks on files? Anybody know how to kill a process lock on a file. I'm trying to rename an excel file but it's erroring out saying the a process has it locked and I need to find a way to get around this. Thanks! Rick ~~ 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: killing locks on files?
I was wrong on my last post. It's happenning when I try to upload a file and then try and rename the file that was uploaded in the same request. Rick -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 6:10 PM To: CF-Talk Subject: RE: killing locks on files? you can kill DSN locks using CFUSION_DISABLE_DBCONNECTIONS (4.5.x only) if a query of the excel file has caused the lock. you didn't specify what "process" has locked the file though. -Original Message----- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 3:05 PM To: CF-Talk Subject: killing locks on files? Anybody know how to kill a process lock on a file. I'm trying to rename an excel file but it's erroring out saying the a process has it locked and I need to find a way to get around this. Thanks! Rick ~~ 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: Insert NULL Values in SQLSERVER.
Your code would insert a blank space. Sounds like you need something like this: CFIF trim(ListGetAt(Phone,x)) contains "n/a" Phone = null, CFELSE Phone = '#ListGetAt(Phone,x)#', /CFIF -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 12:57 PM To: CF-Talk Subject: Insert NULL Values in SQLSERVER. I was trying to insert a blank or null value into the table, if the current list item contains 'n/a'. Not having much success this afternoon. CFIF trim(ListGetAt(Phone,x)) contains "n/a" Phone = ' ', CFELSE Phone = '#ListGetAt(Phone,x)#', /CFIF Thanks, Dave ~~ 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
import excel
Do you guys know of a way to insert an uploaded excel document into a database? Rick ~~ 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: Setting a timeout on a page
Try supplying the requestTimeOut=whatever url variable. Rick -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 10:31 AM To: CF-Talk Subject: Setting a timeout on a page Ok, I've looked through my ColdFusion books, been through the Allaire knowledge base, and the cf-talk archives. I hope someone here can help me. I thought there was a way to specify a timeout period on a CF page? I would like to keep the default of 30 seconds set in the CF Administrator, but I have a few pages which do some whois lookups which may add up to more than 30 seconds, and are timing out. Isn't there a way to increase the timeout value for just this page? Was there something you could put on the URL? If I could set it in the code that would be better. If such a thing exists, *I wish it was documented*! I have all the Allaire books that come with CF, as well as just about every other book there is to get on CF. I even searched the studio help. Maybe I missed it somewhere. Thanks, Ryan ~~ 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: Dynamic variable construction and it's use
#Evaluate(session.application_view_list[i].name "_red")# would ouptut the value. So would #evaluate(countvar)# Rick -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 12:42 PM To: CF-Talk Subject: Dynamic variable construction and it's use Hi there, If construct a variable name dynamically like; cfset countvar="#session.application_view_list[i].name#_red" How do I then output the contents of the newly constructed variable? If the code above evaluated to a variable name e.g. "oracledb_red", how would I do the equivalent of cfoutput #oracledb_red# /cfoutput Doing cfoutput #countvar# /cfoutput will obviously just output the new variable name but not it's contents. I've tried various permutations of #'s and quotes but can't seem to get it right. Is there a way to do this? Thanks, Kevin ~~ 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
array length of a dimension?
I need to find the arraylen of a 2 dimensional array. Can somebody recommend a technique to do this? Thanks, Rick ~~ 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: SQL Create Table
I far I know, there is no such thing as a Boolean datatype. You could try creating a user defined datatype as a bit or integer, then applying a rule to have it only allow 0 or 1. Not sure if that would work, but it's an idea. Rick -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 1:57 PM To: CF-Talk Subject: RE: SQL Create Table So, I still don't know how to create a boolean column H. ~~ 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: array length of a dimension?
never mind. i figured it out while i was waiting for my post to show up. turns out i had a combination of little problems. once i got those fixed, arraylen worked fine. rick -Original Message- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 1:20 PM To: CF-Talk Subject: array length of a dimension? I need to find the arraylen of a 2 dimensional array. Can somebody recommend a technique to do this? Thanks, Rick ~~ 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: array length of a dimension?
Cool. Thank you all! Rick -Original Message- From: Christoph Schmitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 4:25 PM To: CF-Talk Subject: AW: array length of a dimension? Hi, ArrayLen(MyArray) gives you the length of the first dimension. ArrayLen(MyArray[1]) will return the length of the second dimension: cfset MyArray = ArrayNew(2) cfset MyArray[1][1] = "1" cfset MyArray[1][2] = "1" cfset MyArray[1][3] = "1" cfset MyArray[2][1] = "1" cfset MyArray[2][2] = "1" cfoutput #ArrayLen(MyArray)#br !--- returns 2 --- #ArrayLen(MyArray[1])#br !--- returns 3 --- #ArrayLen(MyArray[2])# !--- returns 2 --- /cfoutput HTH, Chris -Ursprüngliche Nachricht- Von: Rick Lamb [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 25. Januar 2001 20:20 An: CF-Talk Betreff: array length of a dimension? I need to find the arraylen of a 2 dimensional array. Can somebody recommend a technique to do this? Thanks, Rick ~~ 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: SQL Server Index
Verity should do a better job if your not already using it. Rick -Original Message- From: Katrina Chapman [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 10:09 AM To: CF-Talk Subject: SQL Server Index Merry Meet, I have a small problem. I have a database, SQL Server 7.0, that has a collection of 22945 articles. This database grows by about 150 articles a day. The text of the articles are stored in text fields. I need to allow searching on the text field but with that many records it just lags. I wanted to create an index on that field to speed up the search, but since it is a text field and longer than 900 bytes SQL won't let me index it. Does anyone know how I can speed up the search? Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.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
wddx limitations?
Hi all, I'm considering using wddx for an application and want to get some advice on whether any of you have hit limits when uploading serialized wddx strings into database fields and when submitting long wddx strings across pages using form fields. I've heard story's of people running into these restrictions and was hoping to hear whether it's as common as it sounds and if there are any solutions. I would also like to confirm what the limiting factor is. Is it the database, webserver, client or something else? Anyone have information on this? Thanks, Rick ~~ 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
How do I work with XML?
I'm going to be getting database updates as xml doc's from a third party. Can somebody give me some direction on working with this? I need to know how I can first import the data into a SQL 7.0 database, then how to work with it using CF. Any direction would be very helpful. Thanks, Rick ~~ 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 - encryption for sql 7.0
I've tried to get some help for this from the sql lists but haven't got any response, so I'm going with the trusty CF group on this. Is what I'm looking for is software to encrypt certain table fields in a sql 7.0 database. I would also like to here from any of you on how you handle sensitive data, either on the database side, or through your applications. I'm referring to things like credit card information. Thanks, Rick ~~ 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 STORED PROCEDURES
Here's an example script I was given that show how you can loop through a query using a cursor. Hope it helps. Rick USE Master GO DECLARE @DBname VarChar(50) DECLARE DBCursor SCROLL CURSOR FOR SELECT Name FROM Master..SysDatabases ORDER BY Name -- ORDER BY DBID -- Sys DBIDs: 1 - 6 ; User DBIDs = 7 OPEN DBCursor FETCH NEXT FROM DBCursor INTO @DBName WHILE (@@FETCH_STATUS = 0) -- 0:fetch successful -1:fetch failed -2:row mia BEGIN PRINT @DBname -- do stuff FETCH NEXT FROM DBCursor INTO @DBName END CLOSE DBCursor DEALLOCATE DBCursor This one adds a little bit of Dynamic SQL, which I often find it necessary to use. /* MinimalCursor+DynoSQL.sql */ /* JWM 200011013 */ USE Master GO DECLARE @DBname VarChar(50) DECLARE @SQLString VarChar(255) SET NOCOUNT ON DECLARE DBCursor SCROLL CURSOR FOR SELECT Name FROM Master..SysDatabases ORDER BY DBID -- ORDER BY DBID -- Sys DBIDs ~= 1 - 6 ; User DBIDs ~= 7 IF EXISTS ( SELECT * FROM Information_Schema.Tables WHERE Table_Name = 'tmpUserTable' ) DROP TABLE tmpUserTable CREATE TABLE tmpUserTable ( Users VarChar(50) ) OPEN DBCursor FETCH NEXT FROM DBCursor INTO @DBName WHILE (@@FETCH_STATUS = 0) -- 0:fetch successful -1:fetch failed -2:row mia BEGIN TRUNCATE TABLE tmpUserTable PRINT '*** ' + @DBname + ' Database ***' -- do stuff SET @SQLString = 'INSERT INTO tmpUserTable SELECT ' + '[Name]' + ' FROM ' + @DBName + '..SysUsers' EXEC (@SQLString) PRINT @SQLString SELECT * FROM tmpUserTable FETCH NEXT FROM DBCursor INTO @DBName END CLOSE DBCursor DEALLOCATE DBCursor SET NOCOUNT OFF -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 12:20 PM To: CF-Talk Subject: OT SQL STORED PROCEDURES WITH THE IF/ELSE/ on Stored Procedures is there a way to write a storedproc so it was like this SELECT * from member where membernumber 0 IF @name is "0" and name='blah' end if @this eq "that" and that='test' end to make it only run certain things if certain values are set Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorized alterations to this e-mail or attachment to it ~~ 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: Storing images in SQL
Larry, I've asked this question before also. And got similar responses as yours which is appreciated. But is there any way you could tell us (a number of people have asked this question) why it's slower and messier. I'm sure for somebody that knows the details on what it takes to do this can logically agree with you (and others who have said the same) and I too would like to be one of those well informed people that come to the same conclusion for the same reasons. Could you or anyone else familiar with the techniques required for this please elaborate on this so I can say something other than "it's a bad idea because that's what somebody said." Thanks, Rick -Original Message- From: Larry C. Lyons [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 3:28 PM To: CF-Talk Subject: Re: Storing images in SQL Michael, In a nutshell don't. Its far faster, easier and a lot less messy to store the images's name and then dynamically construct the path information. regards, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Michael Buffington wrote: Does anyone have any experience storing images in SQL 7.0, and retrieving them in CF? Any tips would help! Michael Buffington ~~ 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
line breaks in cfmail
Hey all, I have this ongoing problem with line breaks not being respecting when formatting my email bodies using the cfmail tag. For example something like this: cfmail Email Address: #form.email# Business Name: #form.businessname# /cfmail Is showing up like this when sent: Email Address: #form.email# Business Name: #form.businessname# Any suggestions? Thx! Rick ~~ 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: line breaks in cfmail
Using Html type would explain things. But that is not the case. I still haven't found the cause of this, but I was given a work around. The suggestion to use cfprocessingdirective suppresswhitespace="no" by Ed allowed me to get it to format the way I needed. Thanks for all of the suggestions! Rick -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 11:14 AM To: CF-Talk Subject: Re: line breaks in cfmail If you have the TYPE attribute to HTML, you'll beed to specify a break tag: lt;BRgt; At 09:22 AM 1/4/01 -0600, you wrote: Hey all, I have this ongoing problem with line breaks not being respecting when formatting my email bodies using the cfmail tag. For example something like this: cfmail Email Address: #form.email# Business Name: #form.businessname# /cfmail Is showing up like this when sent: Email Address: #form.email# Business Name: #form.businessname# Any suggestions? Thx! Rick ~~ 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: !-#include file=cfFile.cfm -
That's not going to work because it has to run before the html is parsed, which is when the SSI is included. Rick -Original Message- From: Eric Fickes [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 11:19 AM To: CF-Talk Subject: !-#include file="cfFile.cfm" - Hello all, Has anyone ever included a cfm file inside of a .html file? I've got an HTML page that I would like to include a small CF page inside of and I can't seem to get it to work. I've tried the following !-#include file="cfFile.cfm" - !-#include virtual="cfFile.cfm" - and neither seem to do anything. Any ideas? E ~~ 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
aliasing using cfmail
Do any of you guys know how to alias the "from" parameter as to include a display name along with the email address? EG: cfmail from="Rick [[EMAIL PROTECTED]]" /cfmail Thx! Rick ~~ 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: setting structures into arrays
I seem to remember last time I did something like this that ArrayAppend worked. Either way I know I found another way around this without using the duplicate function sense I was not using cfs 4.5. Let me know if you are in a similar situation and I will look up the code I used. Rick -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 11:08 AM To: CF-Talk Subject: RE: setting structures into arrays The problem is that setting the array variable as you have just puts a pointer to "order". When that changes, so will your reference. Instead, use "history[1] = Duplicate( order )". Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan 22-25 == -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 12:05 PM To: CF-Talk Subject: setting structures into arrays Hey Guys: I am having problems creating an array of structures and serializing it into a wddx package for client storage in a db. My code looks like this: cfscript history=ArrayNew(1); order=StuctNew(); StructInsert(order, "id", "0001"); StructInsert(order, "date", "01/01/2001"); history[1]=order; StructClear(order); StuctInsert(order, "id", "0002"); StrictInsert(order, "date", "01/02/2001"); history[2]=order; /cfscript I then serialize and store the data. However what happends is that the "history" array has a length of two, but both are set to the second structures values. Any ideas?? Thanks in advance, Greg ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update to Null
UPDATE Employees SET Age = NULL WHERE Id = 2 This has always worked fine for me using MS SQL 7.0 and MS Access. Rick -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 9:31 PM To: CF-Talk Subject: OT: Update to Null Is it possible to UPDATE the value of a numeric field to NULL? Here's the scenario, which must be common: The records of the Employees database table are displayed in an HTML table, with an Edit and Delete button in each row. The user clicks Edit to display a particular record in an editable form. If the user clears the Age field and submits the form, what would the SQL UPDATE statement look like? I don't think this works: UPDATE Employees SET Age = NULL WHERE Id = 2 I could test on FORM.Age and then do "SET Age = -1" if no age was specified, but I'd rather not. Thanks. -David ~~ 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
storing images in SQL database
Could you guys give me suggestions for the best way to store images in a database. Thanks, Rick ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: storing images in SQL database
This is also how I've always done it. But I'm curious if there is a way to store the actual image in the database. I was thinking maybe I could use one of CF's binary functions to convert it to binary, then to wddx or store it directly in the database as binary. If it wasn't much of a performance hit, and is possible, seems to be a much cleaner solution. Rick -Original Message- From: Jennifer Larkin [mailto:[EMAIL PROTECTED]] Sent: Friday, December 29, 2000 5:07 PM To: CF-Talk Subject: Re: storing images in SQL database Quoting Rick Lamb [EMAIL PROTECTED]: Could you guys give me suggestions for the best way to store images in a database. I usually just store the image name in the database. If necessary you could also store the path to the image in the database. Other than that I don't know what you need to know. - This mail sent through IMP: sparky.drule.org ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT - How can I make an external request?
This may sound weird, but I was hoping somebody here would know of a tool that can simulate or proxy through a browser request as if I was outside of my internal network. Basically I'm having a problem simulating dns and routing that people are experiencing on the sites we host and I think it's usually because my request isn't being routed outside of our network and is using our internal dns. I would like a way to make a browser request for a website but have the request act as if it was made outside of our network accurately simulate what our external users are experiencing. Any ideas? Thanks! Rick ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: how many milliseconds is too many?
If your using MS SQL, views do a good job of this too. You can consolidate your normalized data in a central location and still keep your ever expandable normalized database. Best of both worlds. Rick -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 12:08 PM To: CF-Talk Subject: RE: how many milliseconds is too many? This may not apply to your situation, but it is worth investigating. Consider creating a shadow database (possibly denormalized) to address the performance issue... organize the data to fit the specific processing requirements of your most frequently used queries. Then take advantage of stored procedures, caching, etc to reduce processing to the absolute minimum. To the purists, this may be heresy. But if the success of the site depends on the performance, it may be critical to depart from "pure" database design tenets, waste some storage... but get the job done. I am reminded of a quote from my years at IBM: "A job worth doing, is worth doing poorly... if there is no other choice" You're correct - sometimes there's no other choice. However, this step shouldn't be taken lightly. Very often, when I see people working with denormalized data, and I ask them about it, they say "we did it this way for performance", even though they could have gotten the performance they needed without denormalization - they just didn't know how (or know better). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPARAM or CFSET
I use cfparam for a number or reasons: It helps avoid errors by cfparam all your varaibles so they will always be defined. I also saves the hasle of having to do something like this: cfif not isdefined("url.var") cfset url.var=0 /cfif instead use: cfparam name="url.var" default=0 Which will do the same thing. Hope that helps. Rick -Original Message- From: Eric Fickes [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 5:32 PM To: CF-Talk Subject: CFPARAM or CFSET Could anybody school me in the difference between using CFPARAM and CFSET. I see CFPARAM all the time, but the little documentation that I've seen about CFPARAM makes it sound just like CFSET. E ~~ 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: Problem with cachedwithin
It will also work if you just evaluate the timespan first: cfset cache = "#CreateTimeSpan(0,2,0,0)#" cfquery name="test" datasource="#datasource#" cachedWithin="#cache#" Rick -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 14, 2000 5:49 PM To: CF-Talk Subject: RE: Problem with cachedwithin This works: cfset cache = "CreateTimeSpan(0,2,0,0)" cfquery name="#qryName#" datasource="#DSN#" cachedwithin="#Evaluate(cache)#" Bob -Original Message- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: December 14, 2000 4:20 PM To: CF-Talk Subject: Problem with cachedwithin The following works: cfquerydatasource="#request.dsn.name#" username="#request.dsn.user#" password="#request.dsn.pwd#" name="variables.getObjectList" cachedwithin="#createtimespan(0,2,0,0)#" while the following two do not: cfset variables.timeSpan = createtimespan(0,2,0,0) cfquerydatasource="#request.dsn.name#" username="#request.dsn.user#" password="#request.dsn.pwd#" name="variables.getObjectList" cachedwithin="#variables.timeSpan#" cfset variables.timeSpan = 2 cfquerydatasource="#request.dsn.name#" username="#request.dsn.user#" password="#request.dsn.pwd#" name="variables.getObjectList" cachedwithin="#createtimespan(0,variables.timeSpan,0,0)#" Testing with simple outputs of #createtimespan(0,variables.timespan,0,0)#, etc. all seem to provide the same result, so why won't it work in the cfquery. I'm basing my assumption that it isn't working by the debug output that will change from saying "Cached Query" to giving a time in milliseconds. If this won't work, how else do you dynamically refresh a cached query whenever you want to? Thanks, Dan The information contained in this message is privileged and confidential. It is intended solely for the use of the named recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the contents of this transmission is strictly prohibited. If you receive this message in error, please notify the sender immediately. Thank you. ~~ 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: Unlimited Line Item Subform functionality in a FORM
Bob, Sounds to me like your talking about an everyday shopping cart. I would use a associative array (structure) to store all the items names and values for each item and then append each of these structures to an array. At the end of the order, just loop through the array and output the structures (or line items) into the database. Make sure you have your line item table set up with a foreign key to the parent order table by using an order id. Then to pull an order just join the two tables by the order id. If none of this makes sense to you, just look at some tutorials on doing a shopping cart in Cold Fusion and they should give you the ideas you need. Rick -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 8:32 AM To: CF-Talk Subject: Unlimited Line Item Subform functionality in a FORM Hi all, Here's the scenario: A user is entering an order, the order will have some info associated with it, and then the order can have multiple line items added to it. Each line item will have a number of attributes (like product, quantity, etc.). In a program like Access, you can create a form for the Order, and then create a subform for the line items. You can easily set it up so that the user can enter as many line items as they like. After they enter a line item, the interface adds a new blank line item. We need to replace an Access application with a ColdFusion application and provide this same functionality. If we have to, we could provide input fields for a specific number of line items, and then provide a button to add more items, but I was wondering if anyone knows of any custom tags, applets or ActiveX controls that would provide this functionality. Or perhaps I'm missing an obvious easy solution. Any suggestions would be greatly appreciated. Thanks, Bob ~~ 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
division
This was suppose to be easy... I'm trying to divide a recordcount by 100 and then round up. Currently my recordcount is 162 and i'm using the ceiling function to round up but it keeps giving me 1. I've tried using number format and decimal format with no luck. Any suggestions? Code below: cfset temp = decimalFormat(getdealers.recordcount\100) cfset variables.totalpages = ceiling(temp) Thanks, Rick ~~ 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: division
Ok. I'm a dumb @#$!. I just needed to point my slash the right way, /, not \. HeHe! So when you guys get this in 2 hours or so, excuse my thickness. Rick -Original Message- From: Rick Lamb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 11:02 AM To: CF-Talk Subject: division This was suppose to be easy... I'm trying to divide a recordcount by 100 and then round up. Currently my recordcount is 162 and i'm using the ceiling function to round up but it keeps giving me 1. I've tried using number format and decimal format with no luck. Any suggestions? Code below: cfset temp = decimalFormat(getdealers.recordcount\100) cfset variables.totalpages = ceiling(temp) Thanks, Rick ~~ 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: query between 2 database types
Gona have to wait for CF 5.0. It has the ability to query a query which will allow this. Rick -Original Message- From: Eli Shechter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 12:26 PM To: CF-Talk Subject: query between 2 database types Hi I recently started using a program that runs off a oracle database, and my website runs off SQL server 7.0 how can I run a query so that within one query I can pull data from both databases? Thank You Eli Shechter ~~ 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: passing cfquery results to another page
Correct me if I'm wrong here, but I didn't think client, form, url, or cookies variables can hold complex data like a wddx packet. I would suggest using a session or application variables for these techniques. Rick -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 9:19 AM To: CF-Talk Subject: RE: passing cfquery results to another page There are a number of ways, the first two that come to mind are: 1. Store it in a session variable. 2. Convert it to a WDDX packet, then store it in a client or cookie variable, or pass it via a URL or form parameter. The last two aren't advisable if the query is of any reasonable size. Bob -Original Message- From: sam sidhom [mailto:[EMAIL PROTECTED]] Sent: December 7, 2000 9:42 AM To: CF-Talk Subject: passing cfquery results to another page Can anyone tell me if there is anyway CF will pass the results of a CFQuery to another page without having to requery the database? Thanks, Jennifer Johnson ~~ 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: Form Question
Just name the checkbox's the same name and have the value be the id of each record in the database. Then when you do your update/delete you would use the in clause in your sql statement like so: update table1 set productname = '#form.productname#', description = '#form.description#' where id in (#form.name#) Rick -Original Message- From: Jim Mixon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 06, 2000 12:14 AM To: CF-Talk Subject: Form Question Always wondered about how to do this and now I got a client that wants it done .. . hopefully, someone on this esteemed list can point me in the right direction on the RESULTS page of a search, I display check boxes next to each result representing the ability to delete that particular record . . . after selecting only the records I want to delete from the entire list of results, I hit the submit button and only the records that were checked are deleted and the remainder records are left intact . . . I have seen an example of this feature at hotmail.com with the contents of your email box and the option to randomly select emails to delete and then hit one button that performs the action but leaves unchecked emails intact ... . . any help on this out there . . ??? thanks in advance . . . Jim Mixon - CEO APT POINT NET, Inc. "A Premiere InterNET Gateway" . . . [EMAIL PROTECTED] http://www.apt.net/ PO Box 160217 Hialeah, FL 33016 305-418-4111 FAX (305) 418-4111 press 7 and SEND! powered by Cold Fusion 4.01 . . . . feel the force! CF Hosting Now Available . . . . ! ~~ 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: development mappings
Can you map a drive to this location \\servername\sharename\inetpub\wwwroot\foldername? if not then you either don't have correct permissions or you have the path\sharename wrong. To figure the browse path you'll have to check with the webserver it's on and see what the root is for the website your trying to access. Then from there you can establish the path. To verify the path for the server (if on a nt sytem) you can try mapping to the admin share c$ if you have permission, which will start you at the root of the c drive. Then you can verify your path from there. Rick -Original Message- From: Kevin Willyerd [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 10:21 AM To: CF-Talk Subject: development mappings Hi all, I am having trouble setting up the development mappings for a remote server in studio. I have: Studio Path \\servername\sharename\inetpub\wwwroot\foldername Server Path c:\inetpub\wwwroot\foldername Browser Path http://xxx.xxx.xxx.xxx(ipaddress)/foldername/ What am I doing wrong? Kevin ~~ 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: Bulk imports into database
Data transformation services works really well. It comes with MS SQL 7.0, but I think it's a stand alone product that you can get separately to work with other types of databases. Rick -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 11:11 AM To: CF-Talk Subject: Bulk imports into database Hi! I am looking for a way to batch import data into a table using Cold Fusion (or other means) through the Internet. I have 2 columns, Fullname and email. Does anyone know of a way that I could do this? Thanks! Michael Gagnon ~~ 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: Query functions problem
Probably because of how queries are store. They are stored in structure with each key name linking to a field name in the database. In each key is a one dimensional array containing all the records for each field. So if you wanted to delete row number 10 you would do something like this: cfloop collection="#queryname#" item="field" cfset temp=ArrayDeleteAt(queryname.field, 10) /cfloop I've never tried this, but it would make logical sense considering how queries are stored. Rick -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 12:20 PM To: CF-Talk Subject: Query functions problem There's QueryAddrow, Query SetCell, IsQueryetc. WHY ISN'T THERE A DELETEQUERYROW?!! thanx ~~ 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: Bulk imports into database
How many times do I have to say this people. Use DTS if your using sql server. That's what's it's there for! Rick -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 3:07 PM To: CF-Talk Subject: Re: Bulk imports into database Actually, Enterprise Manager is just a front-end to SQL Server, and you'd want to automate the "back end", not the "front end". For SQL Server, take a look at "BULK INSERT" (look in the Books Online). It allows you to take a text file containing your data, and bulk insert that data (duh) into a table you specify. The syntax is a bit trickier than that, but fairly simple. -- Billy Cravens [EMAIL PROTECTED] message has been snipped Peter Theobald wrote: SQL-Server has "Enterprise Manager", which is interactive. I don't know how you would automate using it (one of the reasons why I am a Unix fan not an NT fan, everything on Unix is built to be automated and scripted). At 01:11 PM 12/4/00 -0400, Michael Gagnon wrote: Hi! I am looking for a way to batch import data into a table using Cold Fusion (or other means) through the Internet. I have 2 columns, Fullname and email. ~~ 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: How can I use CF to push data into a statistical package or an Ex cel spreadsheet?
I would suggest using cfcontent to a file on the server then providing a link to it for the client to click on. You could also set the cfcontent tag for download, which would make the excel file and then prompt them to download it in one step. Rick -Original Message- From: Dempsey, Timothy F. [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 3:17 PM To: CF-Talk Subject: How can I use CF to push data into a statistical package or an Ex cel spreadsheet? Folks, I have a CF application that conducts a survey by presenting a varying series of questions to the user and then storing the answers in an Oracle database. I have another CF application for the administrator of the survey that displays on a web page a summary of the answers for each question (e.g. 23 respondents answered A, 47 respondents answered B, etc.). I allow the survey administrator to click on a hyperlink next to each question on the summary web page and that link is supposed to send the question, each given answer, and the number of respondents for each answer over to Excel from which a pie chart can be generated. My question is: How do I take that data and get it into Excel on the client's machine? Any suggestions? Or even suggestion about where to look to research this problem? Or is there another approach any one would care to point out to graphing my survey responses instead of Excel? Thanks, -- Tim Dempsey ~~ 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: getting only unique query results
This may not be related to your problem, but may I suggest writing your query this way: cfquery name="qFoo" datasource="#application.ds#" SELECT name, product_id FROMtblProducts WHEREcategory_id in ',#attributes.theList#' /cfquery Much cleaner, and from what I understand it's faster than writing a bunch of seperate "or" statements. I couldn't say why your getting more records then your expecting without seeing the id's in the database and the list your comparing them to in the "or" statement. Rick -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 3:55 PM To: CF-Talk Subject: getting only unique query results Hey Guys: I have a query that looks likes this: cfquery name="qFoo" datasource="#application.ds#" SELECT name, product_id FROMtblProducts WHEREcategory_id = '' cfloop list="#attributes.theList#" delimiters="," index="theID" OR category_id = '#theID#' /cfloop /cfquery The problem is that it keeps on selecting the products over and over and not just once. I have only 11 records for it to try and select, but it comes back to give me 484. Anyone know why this is happenening??? Thanks, Greg ~~ 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
condition loop
Having a hard time with writing a conditional loop that stops when x = 1. Can somebody help me with the correct syntax? Thanks, Rick ~~ 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
This may be OT but...
It's that time of year. Yes, that's right, annual review time. I was just wondering what you guys experience as far as percentage increases. It's been my experience that the only way to get anything above a 3 percent increase is to switch jobs. Just curious if this is a common thing for the cf community. Rick ~~ 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: Java and CF
Better get moving then. You only have until the end of next year to convert to PHP. Rick -Original Message- From: Zachary Bedell [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 9:39 AM To: CF-Talk Subject: RE: Java and CF -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Allaire has annonced that CF 6 will be entirely written in Java on the back end, with CF Tags actually being translated into JSP Code and then passed to a servlet engine, all on the back-end. My only question: What kind of crack is Allaire smoking, and where can the rest of us get some? Good grief! What would possess an otherwise intelligent programmer to write a server in Java? An app server should be small, concise, FAST, and super optimized for the system it's running on. Java misses the boat on all of those criteria. Am I the only remaining programmer who hasn't jumped on the Java bandwagon? I mean... Java's great for certain tasks -- namely those where speed isn't much of an issue but cross platform functionality is. That's certainly not the case for an application server with thousands of concurrent accesses. There is no WAY a Java server can out perform a *well* *written* C++ server. I wish Allaire would spend their time fixing optimizing the C++ codebase instead of scraping it and rewriting in Java. I can say this for sure: If CF ever goes to a Java backend, I'm moving to PHP... Regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBOifGG6vhLS1aWPxeEQIxUgCfeNvX00zujxBvXIjNp0wmG59Dx4YAn2Bf rQHpED2YoaBv5q2SXO2+GYxE =TK9q -END PGP SIGNATURE- ~~ 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 cfquery inside cfscript?
I've successfully done this using the cf_exec custom tag. Pretty sure the tag is on the allaire developer exchange. Here's an example: CFSET P = "##" CFSET G = "" CFSET L = "" CF_EXEC #G#cfscript#L# while(x EQ 0) { count = count + 1; rahim = 1; if (count EQ 5) { x = 1; cfquery datasource = "#ds#" name = "data" select * from orders /cfquery } } #G#/cfscript#L# /CF_EXEC Rick -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 12:55 PM To: CF-Talk Subject: RE: Using cfquery inside cfscript? Hello everyone. I was wondering if it was possible to do a cfinsert inside a cfscript. No, it isn't. No CF tags may be used within CFSCRIPT. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Get the last 12 months transactions?
Check out the function dateDiff() -Original Message- From: fr me [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 9:59 AM To: CF-Talk Subject: Get the last 12 months transactions? Does anyone know how to test that a date is in the last 12 months? _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.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 ~~ 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: Finding duplicate records
You should be setting up primary keys or unique index's in your database for the fields you don't want duplicates. Then around your insert/update statements us cftry type="database" to catch it when they try and insert duplicate information, then deal with them appropriately. Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 7:55 AM To: CF-Talk Subject: Re: Finding duplicate records I would like to use something like this for a form, we are having lost of problems with duplicate entries. I tried it as shown and it would not let me get past my name because someone else had used the same department. Is there a way to make it check all the fields like an 'and' statement? If this isn't possible is there another way to stop multiple submits? To: [EMAIL PROTECTED] Subject: Re: Finding duplicate records Message-ID: 016201c0550b$9fe57470$a41f88d8@ns2 I got the solution for you, I wrote this and snippetized it because it just so handy. cfset TableName = "Name of table that dublicate values are checked for in" cfset DupeCheckFields = "input db fieldnames to be checked here in a comma delimited list" cfoutput cfset DupeCheckValues = "#input form field names here to be checked in a comma delimited list#" /cfoutput cfset looptracker = 0 cfloop index="dupecheckloop" list="#DupeCheckFields#" cfset looptracker = looptracker + 1 cfquery datasource="#admindsn#" name="CheckDupes" SELECT * FROM #Tablename# WHERE #dupecheckloop# = '#listgetat(dupecheckvalues,looptracker)#' /cfquery cfif CheckDupes.Recordcount GT 0 You have entered a duplicate #listgetat(dupecheckvalues,looptracker)# Please correct this error. cfabort /cfif /cfloop Linda McElroy Web Designer Sears Direct Response ~~ 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: Cold Fusion and ASP
I would suggest using oledb instead of odbc in this case. I think there are some issues with how cf set's up it odbc connections when done through cf admin. If you need to use odbc for your asp apps try setting up your odbc through the system and not use cfadmin to set them up. I have ran into problems using odbc datasource set up this way with cold fusion so only use this method if it's just for your asp connections. Rick -Original Message- From: netman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 29, 2000 9:22 PM To: CF-Talk Subject: Re: Cold Fusion and ASP Thanks, But I am having trouble with people connecting to an access database with ASP when cold fusion is on the box. Is this a known problem, and does it have a fix. Thanks, Robert - Original Message - From: "James McCullough" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, November 29, 2000 10:11 PM Subject: RE: Cold Fusion and ASP Check to make sure that "Maintain database connection" box is unchecked for that datasource. It puts a lock on the database while CF is running if you do. To make sure look in the directory of the database and see if the ".ldb" lock is active(present). If so CF might have the db locked. -Original Message- From: netman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 29, 2000 4:18 PM To: CF-Talk Subject: Cold Fusion and ASP Good Evening, Does anyone know if there is a problem with using ASP to connect to an access database when Cold Fusion is installed on the box. Thanks, Robert ~~ 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 ~~ 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: Dat files
I'm trying to move over a site that was once using a Sybase backend. They sent me a .Dat file and I'm wondering how I can take this file and use it to create a sql database. Anybody have any experience with converting from Sybase to sql using a dat file? Thanks, for anyone who can help. Rick ~~ 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: Dat files
Tried it, but they don't seem to be compatible. Thanks for the suggestion though. Rick -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 28, 2000 11:30 AM To: CF-Talk Subject: RE: Dat files I know SQL Server 6.5 did it's database backups with dat files. If you're running SQL Server 7, go to the MS SQL Server - Switch entry in your start menu and click on SQL Server 6.5. Then do a restore from SQL Server 6.5. That's one option. I say all this, assuming SQL Server 7 won't already do it for you, of course. Not sure if a sybase dat file is compatible with SQL Server 6.5's dat files, but it's worth a shot. ~Simon Simon Horwith Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 28, 2000 11:23 AM To: CF-Talk Subject: OT: Dat files I'm trying to move over a site that was once using a Sybase backend. They sent me a .Dat file and I'm wondering how I can take this file and use it to create a sql database. Anybody have any experience with converting from Sybase to sql using a dat file? Thanks, for anyone who can help. Rick ~~ 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
RE: Converting Access DB to SQL Database
They should have set up a new datasource for the sql database. Then you should have your dsn in your cf apps as a variable in the application.cfm page. So all you would have to do is change what the variable is. As far as upgrading your access database, I've used Microsoft Access 97 Upsizing Tool with good success. There still could be some issues with datatypes/conversions between sql and access so extensive testing afterwords is definitely advised. Good luck! Rick -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 21, 2000 2:36 PM To: CF-Talk Subject: Converting Access DB to SQL Database I am a newbie to cf and I have worked in only cf and Access. I currently have a database that is fairly large that is in access. How can I convert it to SQL and what problems will I have with all my existing queries. My ISP has given me a username and password plus an IP for the SQL server. Do I have to call this information in my queries? I have this site running with access on my PWS, What Kind of Software do I need to test a SQL database on my local machine as well? Any help would be greatly appreciated. Jason Larson [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
Java to cf
I've been handed a site that was written in jhtml using Java, class, and cgi for the backend stuff. The task I've been given is to convert this Java based website into a cf site (we don't support java). Anybody have any suggestions on how this could be done or if it is even feasible considering I know nothing about Java? Just wondering if anyone has ever successfully or unsuccessfully tried to do something like this and what there experience's where. Thanks, Rick ~~ 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: Stucture help (from GetFunctionList)
The only way I know is to loop over the collection: cfloop collection="#structure#" index="key" /cfloop Rick -Original Message- From: Eric Fickes [mailto:[EMAIL PROTECTED]] Sent: Monday, November 20, 2000 9:43 AM To: CF-Talk Subject: Stucture help (from GetFunctionList) This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C05308.88729560 Content-Type: text/plain; charset="iso-8859-1" The GetFunctionList() post got me thinking. The output from that function is a structure, right? Well, here's my structure question. I know that I can use StructCount to find out the number of keys in a structure, but what is I don't know what those keys are? I'm a SOL? Is there any way to display a list the list of keys from a structure, kind of like doing a query.ColumnList? I know about the StructFind, but if I don't have any clue what the keys would be this wouldn't really help unless I become a super good guesser. Eric --_=_NextPart_001_01C05308.88729560 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEStucture help (from GetFunctionList)/TITLE /HEAD BODY PFONT SIZE=3D2The GetFunctionList() post got me thinking.nbsp; The = output from that function is a structure, right?nbsp; Well, here's my = structure question.nbsp; I know that I can use StructCount to find out = the number of keys in a structure, but what is I don't know what those = keys are?nbsp; I'm a SOL?nbsp; Is there any way to display a list the = list of keys from a structure, kind of like doing a = query.ColumnList?nbsp; I know about the StructFind, but if I don't = have any clue what the keys would be this wouldn't really help unless I = become a super good guesser./FONT/P PFONT SIZE=3D2Eric/FONT /P /BODY /HTML --_=_NextPart_001_01C05308.88729560-- ~~ 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
rounding to first decimal
I thought this would be simple. How can round a long integer eg: 2.146752 to the first decimal point? Thanks, Rick 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: rounding to first decimal
That works. Thanks everyone who responded! I also found that numberformat with a mask of 99.9 rounds it correctly also. Don't really know why though. Rick -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 16, 2000 3:06 PM To: CF-Talk Subject: Re: rounding to first decimal On 11/16/00, Rick Lamb penned: I thought this would be simple. How can round a long integer eg: 2.146752 to the first decimal point? That's not an integer. LOL This is the way I do it: cfset number = "2.146752" cfset number = round(2.146752 * 10) / 10 = 2.1 Add another 0 for each decimal you want to round to: cfset number = round(2.146752 * 100) / 100 = 2.15 cfset number = round(2.146752 * 1000) / 1000 = 2.147 -- 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 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 https://secure.houseoffusion.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
javascript to submit a form
This is a multi-part message in MIME format. --=_NextPart_000_005C_01C05012.824E8030 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Can somebody help me with the syntax to submit a form with an onclick even? Thanks, Rick --=_NextPart_000_005C_01C05012.824E8030 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR/HEAD BODY DIVSPAN class=3D214541503-17112000FONT face=3DArial size=3D2Can = somebody help me=20 with the syntax to submit a form with an onclick = even?/FONT/SPAN/DIV DIVSPAN class=3D214541503-17112000FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D214541503-17112000FONT face=3DArial=20 size=3D2Thanks,/FONT/SPAN/DIV DIVSPAN class=3D214541503-17112000FONT face=3DArial=20 size=3D2/FONT/SPANnbsp;/DIV DIVSPAN class=3D214541503-17112000FONT face=3DArial=20 size=3D2Rick/FONT/SPAN/DIV/BODY/HTML --=_NextPart_000_005C_01C05012.824E8030-- ~~ 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
RE: Locking
It makes sense to me that it shouldn't cause any problems, but they still recommend doing it every time, whether for read only or not. The technique that Ben Forta recommends is after setting it to an application variable set it to the request scope for reference throughout the rest of the application which is the technique I've adopted. Rick -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 9:16 AM To: CF-Talk Subject: Locking This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C04F16.E999BB70 Content-Type: text/plain; charset="iso-8859-1" I am setting my datasource value in application.cfm with the following: cflock scope="Application" timeout="30" type="Exclusive" cfif not IsDefined("application.DS") cfset application.DS = 'my_datasource' /cfif /cflock Now in my application whenever I reference that variable (cfquery name="X" datasource="#application.DS#") is it ok not to do a read only lock? Or do I need to lock it each time I call it? The value of DS will never really change. Thanks, Scott --_=_NextPart_001_01C04F16.E999BB70 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META content="MSHTML 5.50.4207.2601" name=GENERATOR/HEAD BODY DIVSPAN class=270081315-15112000FONT face=Arial size=2I am setting my datasource value in application.cfm with the following:/FONT/SPAN/DIV DIVSPAN class=270081315-15112000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=270081315-15112000FONT face=Arial size=2lt;cflock scope="Application" timeout="30" type="Exclusive"gt;BRnbsp; lt;cfif not IsDefined("application.DS")gt;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp ;nbsp;nbsp;nbsp;nbsp; lt;cfset application.DS = 'my_datasource'gt;BRnbsp; lt;/cfifgt;BRlt;/cflockgt;/FONT/SPAN/DIV DIVSPAN class=270081315-15112000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=270081315-15112000FONT face=Arial size=2Now in my application whenever I reference that variable (lt;cfquery name="X" datasource="#application.DS#"gt;) is it ok not to do a read only lock?nbsp; /FONT/SPAN/DIV DIVSPAN class=270081315-15112000FONT face=Arial size=2Or do I need to lock it each time I call it?/FONT/SPAN/DIV DIVSPAN class=270081315-15112000FONT face=Arial size=2The value of DS will never really change./FONT/SPAN/DIV DIVSPAN class=270081315-15112000FONT face=Arial size=2/FONT/SPANnbsp;/DIV DIVSPAN class=270081315-15112000FONT face=Arial size=2Thanks,/FONT/SPAN/DIV DIVFONT face=Arial size=2Scott/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV/BODY/HTML --_=_NextPart_001_01C04F16.E999BB70-- 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: Setting up a webserver
Just go straight to service pack 6a. There is an order you should install the option pack. I think you need to install the option pack before installing sp6a. Rick -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 9:40 AM To: CF-Talk Subject: OT: Setting up a webserver hey, i havent done this in awhile, and i've only done it once. But i'm trying to set up a webserver on nt, this is going to be a local intranet deal. I'm installing the SP's right now, but isn't there some order that they get installed? I thought it went like sp 5, 6 then 3 or something like that... any help is appreciated thanks! Gavin 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: Back Button on Dynamic pages
I think this would work: onload { window.location.reload(true);} Rick -Original Message- From: Nathan Focht [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 11:02 AM To: CF-Talk Subject: Back Button on Dynamic pages This is a multi-part message in MIME format. --=_NextPart_000_0106_01C04EFB.D216C7C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello everyone, I have a large page that people are using the browser back button to = return to and get that ugly 'Expired Page' message. Is there any way to = have the page know that it is a history.back command and do an auto = refresh or the like? Thanks in Advance. Nathan A. Focht http://www.fusionlink.com (912)-398-3548 --=_NextPart_000_0106_01C04EFB.D216C7C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hello everyone,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; I have a large page = that people=20 are using the browser back button to return to and get that ugly = 'Expired Page'=20 message.nbsp; Is there any way to have the page know that it is a = history.back=20 command and do an auto refresh or the like?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks in Advance./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Nathan A. FochtBRA=20 href=3D"http://www.fusionlink.com"http://www.fusionlink.com/ABR(912)= -398-3548/FONT/DIV DIVnbsp;/DIV DIVBRnbsp;/DIV/BODY/HTML --=_NextPart_000_0106_01C04EFB.D216C7C0-- 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: How To Determine Logged In Users
Make them register, then store the info in a client variable or as a cookie on the client. Rick -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 2:51 PM To: CF-Talk Subject: How To Determine Logged In Users Just wondering how I can go about coding so I can determine the names of those members who are currently logged into my website. At the moment I can determine the number of persons logged in and their ip addresses however I am wanting to try and take it to the next step so that I can see who exactly is logged in Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Email: [EMAIL PROTECTED] Developers Of: Website: www.AustralianAccommodation.com Website: www.AccommodationNewZealand.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts 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: List Delimiter Question
Would it be possible to use a different delimiter? If so then just specify the delimiter in your list functions. Otherwise, you could do a replace function to take out submitted coma's and replace them with something else. Rick -Original Message- From: Craig A. Zingerline [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 14, 2000 3:13 PM To: CF-Talk Subject: List Delimiter Question Hello, We have an application where we are creating a list from numerous text fields all with the same name. Currently, if a user enters a comma in one of the text boxes, the program sees this as a delimiter and our program doesn't work. Is there a way that I can ignore commas from being used in the list so we can allow users to put a comma in the field? Thank you for any help. Craig Craig A. Zingerline Advanced Media Productions Web Application Developer [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: Netscape 6 out UGH!!!!
Does any of this really matter? All that they should care about is if there browser conforms the W3C specifications so I can count on things to work how they are suppose to. Not how they are suppose to according to Microsoft or Netscape or any other browser. I thought that's what the whole point of the W3C. I just always thought Microsoft did a better job at conforming to these standards then Netscape. Rick -Original Message- From: Raymond K. Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 14, 2000 3:28 PM To: CF-Talk Subject: RE: Netscape 6 out UGH IE is based off of Mozilla? Did I wake up on another planet today? As far as I know, thats _defintely_ not the case. (Although I prefer IE over Netscape as you do.) === Raymond Camden, Principal Spectra Compliance Engineer for Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda I also hate to tell you that IE and Netscape are based off of the open source Mozilla project which Opera has followed closely with. Just because it's Microsoft doesn't mean you have to hate it. 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: Force Download in Browser
You should supply the mime type in the cfcontent tag. Rick -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 14, 2000 4:14 PM To: CF-Talk Subject: Force Download in Browser This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C04E88.336F47C0 Content-Type: text/plain; charset="iso-8859-1" Hello, Does anyone know how to force the browser to download a file? I'm using the following code, and it works for word documents, but not text files. CFHEADER NAME="Content-Disposition" VALUE="attachment; filename=#get_record.File_Name#" CFCONTENT TYPE="application/octet-stream" FILE="#filePath#\#get_record.File_Name#" DELETEFILE="No" The free drive sites accomplish this... Thanks! - Scott --_=_NextPart_001_01C04E88.336F47C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLEForce Download in Browser/TITLE /HEAD BODY PFONT SIZE=3D2Hello,/FONT /P PFONT SIZE=3D2Does anyone know how to force the browser to download = a file?/FONT BRFONT SIZE=3D2I'm using the following code, and it works for word = documents, but/FONT BRFONT SIZE=3D2not text files./FONT /P PFONT SIZE=3D2lt;CFHEADER NAME=3Dquot;Content-Dispositionquot; = VALUE=3Dquot;attachment; = filename=3D#get_record.File_Name#quot;gt;/FONT BRFONT SIZE=3D2lt;CFCONTENT = TYPE=3Dquot;application/octet-streamquot; = FILE=3Dquot;#filePath#\#get_record.File_Name#quot; = DELETEFILE=3Dquot;Noquot;gt;/FONT /P PFONT SIZE=3D2The free drive sites accomplish this.../FONT /P PFONT SIZE=3D2Thanks!/FONT /P PFONT SIZE=3D2- Scott/FONT /P /BODY /HTML --_=_NextPart_001_01C04E88.336F47C0-- 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: Dump Entire Array Contents?
You can loop from 1 to arrayLen or use a custom tag called objectdump from the developer exchange. There is also cfa_object dump which does a similiar function as the custom tag cf_objectdump. These custom tags are mainly used for looking at complex data structures not for client side viewing. Rick -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 14, 2000 4:56 PM To: CF-Talk Subject: Dump Entire Array Contents? Anyone know of a quick way to dump an entire arrays contents to the screen? jon 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: Force Download in Browser
I disagree. This is the syntax I use with the best success for all types of files: cfheader name="Content-Disposition" value="attachment; filename=#url.file#" cfif isdefined("url.nonsecure") !--- map to gates webdocs directory --- CFIF HTTP_USER_AGENT CONTAINS "MSIE" CFCONTENT TYPE="#mimetype#" FILE="e:\webdocs\#url.thispath#\#url.file#" CFELSE CFCONTENT TYPE="application/unknown" FILE="e:\webdocs\#url.thispath#\#url.file#" /CFIF cfelse !--- map to secure directory --- CFIF HTTP_USER_AGENT CONTAINS "MSIE" CFCONTENT TYPE="#mimetype#" FILE="e:\secureDocs\#url.thispath#\#url.file#" CFELSE CFCONTENT TYPE="application/unknown" FILE="e:\secureDocs\#url.thispath#\#url.file#" /CFIF /cfif The variations between browser types are so the save as dialog shows the correct file name for each type of browser. Notice I also use a directory that is outside of the web directory which is a nice technique for securing files. Works for me, hopefully it will work for you too. Rick -Original Message- From: Maximov, Anton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 14, 2000 5:43 PM To: CF-Talk Subject: RE: Force Download in Browser i don't think u can use cfheader and cfcontent together. the latter one overrides the former. tough luck. a solution would be to set a special download directory and enforce the content type/content-disposition there. see what happens. anton maximov programmer/analyst IT, New Media -Original Message- From: Scott Becker [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 14, 2000 5:14 PM To: CF-Talk Subject: Force Download in Browser This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C04E88.336F47C0 Content-Type: text/plain; charset="iso-8859-1" Hello, Does anyone know how to force the browser to download a file? I'm using the following code, and it works for word documents, but not text files. CFHEADER NAME="Content-Disposition" VALUE="attachment; filename=#get_record.File_Name#" CFCONTENT TYPE="application/octet-stream" FILE="#filePath#\#get_record.File_Name#" DELETEFILE="No" The free drive sites accomplish this... Thanks! - Scott 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: CFLOOP has me stumped again.
First off, there is no point in grouping your sql query by all the fields. This does nothing, and remember that there is a very big difference when you use grouping in sql then when you use grouping in cold fusion. I'll let you look into the sql group, but here is how i would use a cold fusion grouping to get the display you want: CFQUERY NAME="getmodels" DATASOURCE="#dsn#" SELECT ANCAPID, model, make FROMANCAPCrashTests ORDER BY Make, model, ancapid /query cfoutput query="getmodels" group="make" #Make# cfoutput #model# - #ancapid# cfoutput /cfoutput Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Kear Sent: Monday, November 13, 2000 7:37 PM To: CF-Talk Subject: CFLOOP has me stumped again. I'm sorry if this is a very elementary CFLOOP question, but perhaps I've been looking at this one so long now I can't see the wood for the trees so to speak. I have a query that gives me Make, Model and ID of a range of cars. I want to display them on the page as follows: make1 model 1-1 model 1-2 model 1-3 model 1-4 make2 model 2-1 model 2-2 model 2-3 make3 model 3-1 model 3-2 etc In other words grouped by the car manufacturer, with each manufacturer's models in sequence. My SQL query is: CFQUERY NAME="getmodels" DATASOURCE="#dsn#" SELECT ANCAPID, model, make FROMANCAPCrashTests GROUP BY ancapid, model, make ORDER BY Make, model, ancapid /query So I believe the way I display the data is using CFLOOP but I'm dashed if I can work out what I have to do with CFLOOP to give me the result I need. Anyone? please? Cheers, Mike Kear Windsor, NSW, Australia Australian Consumers Assoc http://www.choice.com.au 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]