Re: Note passing system?
:o) Hi Peter. I certainly understand where you're coming from. After 3 years of doing some solid CF work, I'm very capable of building most of the stuff that I need. I'm just an advocate of code reuse. If there's something out there that helps me reduce my coding time, I'd like to take advantage of it. I really hate reinventing the wheel. Thanks for the feedback... Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Peter Tilbrook" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:59 AM Subject: RE: Note passing system? As a side note - if you have an idea for your application - do it! Do not expect someone else to have already written the code for you. CF makes coding easy. If you are worried about the code have trusted people try and break it. Spend at least 3 weeks with beta testers on trusted code. You would be amazed at how the feedback either picks up problems or points out, even unobtrusively, better ways to accomplish a task. -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 15:33 To: CF-Talk Subject: RE: Note passing system? I implemented the same thing for the new Friends Plus site. The beauty of the system is that nobpdys email address is released. We could be draconian and introduce full auditing but it has not been necessary yet. The user remain anonymous and their email address is never released unless they give it out. -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 14:57 To: CF-Talk Subject: Re: Note passing system? Not really, Paul. Its more like an internal messaging system. One where I can write a message to another user or perhaps a group of users and have them correspnd back. Again, its not a true email system but one that would allow me to be able to communicate within the scope of my own application. Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Paul Begovich" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 7:35 PM Subject: Re: Note passing system? Sounds like you want a project management tool. We have an internal system here we use to parse out work. Basically the client/project manager submits an item to a form and it appears on the necessary persons desktop based on who they select. They see the item, do the work, mark their time, and reply via the form. It's a great project management tool and it keeps track of correspondence. Building a system like your describing isn't too difficult, it's just time consuming. We have looked into outside utilities to do this, but we've found them lacking. As a development shop we have found that when we need some additional functionality we build it on. The current system we have now has grown out of several developers efforts in the past two years to incompass project managment, billing, contacts, work requests, logging, and a host of other things. A third party too may save you time in the short run, but in the long run, it'll probably lacks the additional functionality you want. I recommend buiding your own system, keeping in mind you want to be able to add additionally functionality in the future. - Paul - Original Message - From: "Rey Bango" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:07 PM Subject: Note passing system? Anyone know of a good CF-based note/messaging system? I'm not talking about an email server but more of a db driven messaging software that will allow me to post a message to a specific suer. When that user comes in, they can check for their own messages and reply accordingly. Again, its not an email system per se. Thanks, Rey Bango... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." ~~ 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: Note passing system?
I'd like to add to that... I also have no problem comming up with the code i need, but code that is available publicaly is likely to have undergone serveral bug fixes, performance enhancements and it might even be better then what i could come up with. Code reuse has it's benefits Regards, Javier -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 4:37 PM To: CF-Talk Subject: Re: Note passing system? :o) Hi Peter. I certainly understand where you're coming from. After 3 years of doing some solid CF work, I'm very capable of building most of the stuff that I need. I'm just an advocate of code reuse. If there's something out there that helps me reduce my coding time, I'd like to take advantage of it. I really hate reinventing the wheel. Thanks for the feedback... Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Peter Tilbrook" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:59 AM Subject: RE: Note passing system? As a side note - if you have an idea for your application - do it! Do not expect someone else to have already written the code for you. CF makes coding easy. If you are worried about the code have trusted people try and break it. Spend at least 3 weeks with beta testers on trusted code. You would be amazed at how the feedback either picks up problems or points out, even unobtrusively, better ways to accomplish a task. -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 15:33 To: CF-Talk Subject: RE: Note passing system? I implemented the same thing for the new Friends Plus site. The beauty of the system is that nobpdys email address is released. We could be draconian and introduce full auditing but it has not been necessary yet. The user remain anonymous and their email address is never released unless they give it out. -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 14:57 To: CF-Talk Subject: Re: Note passing system? Not really, Paul. Its more like an internal messaging system. One where I can write a message to another user or perhaps a group of users and have them correspnd back. Again, its not a true email system but one that would allow me to be able to communicate within the scope of my own application. Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Paul Begovich" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 7:35 PM Subject: Re: Note passing system? Sounds like you want a project management tool. We have an internal system here we use to parse out work. Basically the client/project manager submits an item to a form and it appears on the necessary persons desktop based on who they select. They see the item, do the work, mark their time, and reply via the form. It's a great project management tool and it keeps track of correspondence. Building a system like your describing isn't too difficult, it's just time consuming. We have looked into outside utilities to do this, but we've found them lacking. As a development shop we have found that when we need some additional functionality we build it on. The current system we have now has grown out of several developers efforts in the past two years to incompass project managment, billing, contacts, work requests, logging, and a host of other things. A third party too may save you time in the short run, but in the long run, it'll probably lacks the additional functionality you want. I recommend buiding your own system, keeping in mind you want to be able to add additionally functionality in the future. - Paul - Original Message - From: "Rey Bango" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:07 PM Subject: Note passing system? Anyone know of a good CF-based note/messaging system? I'm not talking about an email server but more of a db driven messaging software that will allow me to post a message to a specific suer. When that user comes in, they can check for their own messages and reply accordingly. Again, its not an email system per se. Thanks, Rey Bango... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." ~~ Structure your ColdFusion code with Fusebox. Get
test
Test ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Order of Display/Page Rendering Question
Any one llike to let me know ,what will happen if would like to make one part of Application in ASP other is in JSP and other is in CF or PHP. Thanks in Advance. ~~ 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: Import data to ACCESS
James, will the export be the same records every time? Or will the client change the data selections from export to export? Tony Gruen sfnetworks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 11:03 PM To: CF-Talk Subject: Re: Import data to ACCESS James Maltby james.m@thoughtbTo: CF-Talk [EMAIL PROTECTED] ubble.net cc: Subject: Import data to ACCESS 03/30/01 03:45 PM Please respond to cf-talk Here's a dudy for y'all - SCENARIO: current client's website - running on NT4, CF 4.01, Access 97 backend - have come back to us with the following request: They have an Orrible 7 database internally from which they want to export tab delimited (or csv) data (deleted, amended and new records) on a regular basis (usually about 200 - 500 records each time) - and they want us to write an application that will "execute" this file on their server. ISSUES: the server does not have Access on it, just the databases required - they will not allow a remote ODBC connection to the Oracle database - the server is v. old (about 2 years old - 1/2 gig RAM - x86 Pentium II 300/400(?) Proc.) SOLUTION: we suggest upgrading the backend to MS SQL - using SPs to import the data - run by CF pages in the admin management system we have written. PROBLEM: they want us to suggest using the current techs. - i.e. using ACCESS databases without having access on the server any suggestions... TIA James ~~ 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: validation
U must need a structure like array in which u will insert the names from DB.On the client side after entering the name ur name will be compared with the names oretrieved from DB. It is ans according to ur Q. "Jones, Becky" bjones@MilesStockbTo: CF-Talk [EMAIL PROTECTED] ridge.com cc: Subject: validation 04/17/01 01:27 AM Please respond to cf-talk i want to have a form where i can insert a new user into my database. and i have that form but i want to be able to validate it before it submits this new user into my database. i want to check to make sure the person doesnt already exist. (it wont be me entering the data, so i dont want to have user input errors if they dont search thru the drop down list before adding a new person...resulting in duplicate people). someone told me to look thru the custom tags and i did...but i really dont see what i am looking for. can anyone give me any ideas or some direction? thanks for all your help, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: Creating Page Breaks to make page printable?
Don't think page break is implemented in Navigator. -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: 17 April 2001 05:34 To: CF-Talk Subject: Re: Creating Page Breaks to make page printable? http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/pageBre akAfter.asp - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 6:20 PM Subject: Re: Creating Page Breaks to make page printable? Does anyone know of a way to force printing breaks of a document? You can do this with style sheets. -- This message sent compliments of db Technology http://www.dbtech.net/ ~~ 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: (Easy SQL)
getdate() for now() getdate(-1) for yesterday and so on - Original Message - From: "Eric Dawson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 9:08 PM Subject: (Easy SQL) I have a member table which contains userid, signup_datetime I want to create a daily summary of registrations. select signup_datetime as justDatenotTime,count(userID) as NewMembers from membertable group by justDatenotTime == * == I know this has to be simple, but I can't find the syntax. How do I drop the time from a datetime field (SQL Server 7/2000/MSDE) so I can group by just the day? ~~ 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'
I had the same problem, it's ain't possible. What I used is to open a window indicating only .jpeg or .gif is allowed and then used a javascript to check what file was inserted in the formfield (before uploading, not after): take a look: script extensions = new Array(".JPG",".GIF",".gif",".jpg") function allowedExt(fileType){ var extension = fileType.substring(fileType.length-4, fileType.length) for (var i = 0; i extensions.length; i++) { if (extension == extensions[i]) { return true break } }alert(errorMsg()); return false } function errorMsg(){ alertTxt = "Please select one of the following file types: \n\r" for (var i = 2; i extensions.length; i++){ alertTxt += extensions[i] + " " { } }return alertTxt } Hope this helps. Bye. Michael Lugassy Interactive Music Ltd. ~~ 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: Inputfilter
it's attached. you can add your own invalid signs/cahrs on one of the lines. Take care, Michael Lugassy Interactive Music Ltd. ~~ 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: Transferring 1-3Kb data
Please someone help out. - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 5:24 PM Subject: Transferring 1-3Kb data We devloped a client program (in visual c++) that stores log files for usage in the client and its features. I need the best way to deliver those small log files (no more then 2Kb for a full week of usage) to our CF production server and then, to zip those files and send them daily to our development server. I will definitly manage the 2 tasks of zipping and transferring the log files but what is the best way to create/get them from the client? I though about 2 alternatives: 1. open a ftp connection to upload the file weekly by each client. 2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not sclable enough, any help would be appriciated! Thanks, Michael Lugassy Interactive Music Ltd http://www.imvamp.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: input type='file'
so we could not do anything about it :( but thank you for reply Michael :) -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 4:26 PM To: CF-Talk Subject: Re: input type='file' I had the same problem, it's ain't possible. What I used is to open a window indicating only .jpeg or .gif is allowed and then used a javascript to check what file was inserted in the formfield (before uploading, not after): take a look: script extensions = new Array(".JPG",".GIF",".gif",".jpg") function allowedExt(fileType){ var extension = fileType.substring(fileType.length-4, fileType.length) for (var i = 0; i extensions.length; i++) { if (extension == extensions[i]) { return true break } }alert(errorMsg()); return false } function errorMsg(){ alertTxt = "Please select one of the following file types: \n\r" for (var i = 2; i extensions.length; i++){ alertTxt += extensions[i] + " " { } }return alertTxt } Hope this helps. Bye. Michael Lugassy Interactive Music Ltd. ~~ 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'
I have a question about your script. Assuming the input looks like so form name="foo" input type="file" name="bar" /form does your script refer to the input as document.foo.bar.value; If so how did you work around the access denied js error that the browser gives me when I try this? - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:25 AM Subject: Re: input type='file' I had the same problem, it's ain't possible. What I used is to open a window indicating only .jpeg or .gif is allowed and then used a javascript to check what file was inserted in the formfield (before uploading, not after): take a look: script extensions = new Array(".JPG",".GIF",".gif",".jpg") function allowedExt(fileType){ var extension = fileType.substring(fileType.length-4, fileType.length) for (var i = 0; i extensions.length; i++) { if (extension == extensions[i]) { return true break } }alert(errorMsg()); return false } function errorMsg(){ alertTxt = "Please select one of the following file types: \n\r" for (var i = 2; i extensions.length; i++){ alertTxt += extensions[i] + " " { } }return alertTxt } Hope this helps. Bye. Michael Lugassy Interactive Music Ltd. ~~ 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: Last row inserted
If u'r using CF (and that's the forum, right?) AND YOU HAVE a colum where you put the date of each INSERT just use this: cfquery name="x" datasource="y" MAXROWS="1" SELECT colum from table ORDER by columthatholds_date DESC/cfquery If u'r not holding the date of the insert, the MAX idea is good. Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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: cfmal with attachments and cfserver memory usage
I had similiar problems and had to buy a dedicated Mail Server (IMAIL is recommened, from IPSWITCH). Anyow, you probarbly know CF is NOT recommended for high-volume "MAILING LIST" like yours. If you can't get your hands on a dedicated mail server (that will help ALOT in performace!!) I suggested this: 1. Don't attach the file(s) using the MIMEATTACH switch on the parent CFMAIL tag, instead, use CFMAILPARAM(s) something like this: CFMAILPARAM FILE="#dir_mapt#\#filename1#" CFMAILPARAM FILE="#dir_mapt#\#filename2#" CFMAILPARAM FILE="#dir_mapt#\#filename3#" 2. Don't use the QUERY attribute with the CFMAIL instead, try to think of using CFLOOP=QUERY (that's not recommened too, but...) with a single CFMAIL each time (you don't need examples for that, right?) 3. give a time interval (of about 5 minutes) between CFLOOP and/or multiple CFMAIL recipintes list. This will give the server "TIME TO RECOVER". hope this tips helps, again - I recommened a dedicated mail software that will run on the same CF machine to handle this tasks. I think you can get IMAIL For 900$ 1 time fee and deliver 100K messages a day without a problem on pentium 100mhz It's MUCH BETTER. Thanks, Michael Lugassy Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Using 90-100% of processor time (911!)
No one asked you what version are you using? It is recommened that you'll upgrade to SP2 (4.5.1) it's free from allaire. We had the same problem with our old 4.5 version. Anyhow, I don't think it's an immediate change, like the others. Please remember what happened BEFORE the first time you rebooted the server (prior to the problem). This reboot will make all the changes take affect. BUT CHECK YOUR VERSION INFO (under admin.) and get back to me. Thanks, Michael Lugassy Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Using 90-100% of processor time (911!)
Not sure if anyone else has mentioned this yet but there is a very rare and random cfmail bug that cause exactly the cpu usage you have described. Once in a blue moon CF 4.5.X blurps out an empty/0K email queue in the C:\CFUSION\MAIL\POOL folder or wherever you installed CF. Look for a 0K file and remove it if you find it. Once you do that and restart the service everything should return to normal. It's extremely rare but it does happen. xing - Original Message - From: "Bonnie Betts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 9:27 PM Subject: Re: CF Using 90-100% of processor time (911!) Question on this thread: Would any of the log files give you a hint as to which pages were accessed when the server started using up resources? Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: "Steven A. del Sol" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:35 PM Subject: Re: CF Using 90-100% of processor time (911!) I believe your problem is that on one of your pages you are timing out. Check to see if you have a page where you are passing a Alpha into a numeric field. It will not necessarily crash if you have a number in the sequence somewhere but it can stall your cfserver for hours. Also, set your timeout's lower and set server to restart on two timeouts. This error can happen with datefields too. Hope you find your problem it took us three weeks going through thousands of line of code to fine one date field not validating, throwing errors and causing the server to have cfserver at 95% to 100% of the memory usage. GOOD LUCK At 12:48 PM 4/16/2001 -0400, you wrote: My server developed a problem today. CFServer.exe is using almost all of the available processing time. I've tried stopping and starting the services and the NT box, but as soon as I start CF again it almost immediately grabs all of the processor time. I'm running NT and CF 4.01. We've had this application up and running for a little over a year now and have only started having this problem today. I'd greatly appreciate any suggestions, since this has my Web site running at a crawl. TIA! Russell Conway HallofSports.com, Inc. 351 West 22nd Street New York, NY 10011 P (646) 638-2500 F (646) 638-3444 http://www.hallofsports.com .. . . where the legends live on ~~ 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
Error Catching Overhead - Performance Data?
Don't want to do more than I need to so I will try to get the answer here first. Has anyone done any performance testing with huge blocks of CF code with and without nested/non-nested CFTRY/CFCATCH code? It would be interesting to see if anyone has experienced any significant difference between the two styles in terms of raw performance. xing ~~ 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: Screen Shot on Win 2K
Actually PrintScreen alone will do also. ALT+print screen takes off the TASKBAR out of the picture. Say chees, Michael Lugassy Interactive Music Ltd. ~~ 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
Always the same Verity error code...
Hello Ladies and Gentlemen, Always the same problem on my web site hosted by Intermedia with a Verity collection Error occurred in tag CFSEARCH Internal Error: VDKSessionNew failed Error Code: -125 Tech support always restarts the Cold Fusion services...until the next crash Any idea to fix this problem? Thanks a lot for your help Rémi van der Deure ~~ 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: Inputfilter
Guess this forums doesn't support attachs. here is the code, wide spread: cfparam name="attributes.scopes" cfparam name="attributes.chars" default="" cfparam name="attributes.tags" default="" cfscript reTags = "" ; if ( attributes.tags eq "ALL" ) reTags = "[^]*" ; else if ( attributes.tags neq "" ) reTags = "/?(#ListChangeDelims(attributes.tags, '|', ',' )#)[^]*" ; charList = '' ; if ( attributes.chars neq "" ) { charList = attributes.chars ; for ( i=Len(attributes.chars)-1; i gte 1; i=i-1 ) charList = Insert( ",", charList, i ) ; } /cfscript cfloop list="#attributes.scopes#" index="scopeName" cfif not findnocase("multipart/form-data",cgi.CONTENT_TYPE) cfscript s = Evaluate( scopeName ) ; for ( field in s ) if ( IsSimpleValue( s[field] ) ) { if ( reTags neq '' ) s[field] = REReplace( s[field], reTags, "", "ALL" ) ; if ( charList neq '' ) s[field] = ReplaceList( s[field], charList, "" ) ; } /cfscript /cfif /cfloop Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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'
form action="something.cfm" method="post" enctype="multipart/form-data" name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);" this is the form heading. - Original Message - From: "Bryan LaPlante" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:44 AM Subject: Re: input type='file' I have a question about your script. Assuming the input looks like so form name="foo" input type="file" name="bar" /form does your script refer to the input as document.foo.bar.value; If so how did you work around the access denied js error that the browser gives me when I try this? - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:25 AM Subject: Re: input type='file' I had the same problem, it's ain't possible. What I used is to open a window indicating only .jpeg or .gif is allowed and then used a javascript to check what file was inserted in the formfield (before uploading, not after): take a look: script extensions = new Array(".JPG",".GIF",".gif",".jpg") function allowedExt(fileType){ var extension = fileType.substring(fileType.length-4, fileType.length) for (var i = 0; i extensions.length; i++) { if (extension == extensions[i]) { return true break } }alert(errorMsg()); return false } function errorMsg(){ alertTxt = "Please select one of the following file types: \n\r" for (var i = 2; i extensions.length; i++){ alertTxt += extensions[i] + " " { } }return alertTxt } Hope this helps. Bye. Michael Lugassy Interactive Music Ltd. ~~ 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'
Take the script, open a new html window and write them in BOLD LETTERS! :) just like we did here: http://www.imvamp.com/userpages/upload/index.cfm Don't :( Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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'
I've never gotten that to work for me. It always complains about object required or access denied when I refer to a client side file upload. It is my understanding that JavaScript can not access the content of the input type due to security issues. I will have to try your method. - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 5:26 AM Subject: Re: input type='file' form action="something.cfm" method="post" enctype="multipart/form-data" name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);" this is the form heading. - Original Message - From: "Bryan LaPlante" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:44 AM Subject: Re: input type='file' I have a question about your script. Assuming the input looks like so form name="foo" input type="file" name="bar" /form does your script refer to the input as document.foo.bar.value; If so how did you work around the access denied js error that the browser gives me when I try this? - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:25 AM Subject: Re: input type='file' I had the same problem, it's ain't possible. What I used is to open a window indicating only .jpeg or .gif is allowed and then used a javascript to check what file was inserted in the formfield (before uploading, not after): take a look: script extensions = new Array(".JPG",".GIF",".gif",".jpg") function allowedExt(fileType){ var extension = fileType.substring(fileType.length-4, fileType.length) for (var i = 0; i extensions.length; i++) { if (extension == extensions[i]) { return true break } }alert(errorMsg()); return false } function errorMsg(){ alertTxt = "Please select one of the following file types: \n\r" for (var i = 2; i extensions.length; i++){ alertTxt += extensions[i] + " " { } }return alertTxt } Hope this helps. Bye. Michael Lugassy Interactive Music Ltd. ~~ 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'
just keep in mind that the form must come AFTER the script. - Original Message - From: "Bryan LaPlante" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 11:36 AM Subject: Re: input type='file' I've never gotten that to work for me. It always complains about object required or access denied when I refer to a client side file upload. It is my understanding that JavaScript can not access the content of the input type due to security issues. I will have to try your method. - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 5:26 AM Subject: Re: input type='file' form action="something.cfm" method="post" enctype="multipart/form-data" name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);" this is the form heading. - Original Message - From: "Bryan LaPlante" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:44 AM Subject: Re: input type='file' I have a question about your script. Assuming the input looks like so form name="foo" input type="file" name="bar" /form does your script refer to the input as document.foo.bar.value; If so how did you work around the access denied js error that the browser gives me when I try this? - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:25 AM Subject: Re: input type='file' I had the same problem, it's ain't possible. What I used is to open a window indicating only .jpeg or .gif is allowed and then used a javascript to check what file was inserted in the formfield (before uploading, not after): take a look: script extensions = new Array(".JPG",".GIF",".gif",".jpg") function allowedExt(fileType){ var extension = fileType.substring(fileType.length-4, fileType.length) for (var i = 0; i extensions.length; i++) { if (extension == extensions[i]) { return true break } }alert(errorMsg()); return false } function errorMsg(){ alertTxt = "Please select one of the following file types: \n\r" for (var i = 2; i extensions.length; i++){ alertTxt += extensions[i] + " " { } }return alertTxt } Hope this helps. Bye. Michael Lugassy Interactive Music Ltd. ~~ 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'
dude, you are a genius. I have never gotten that to work. My hat is off to ya. - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 5:53 AM Subject: Re: input type='file' just keep in mind that the form must come AFTER the script. - Original Message - From: "Bryan LaPlante" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 11:36 AM Subject: Re: input type='file' I've never gotten that to work for me. It always complains about object required or access denied when I refer to a client side file upload. It is my understanding that JavaScript can not access the content of the input type due to security issues. I will have to try your method. - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 5:26 AM Subject: Re: input type='file' form action="something.cfm" method="post" enctype="multipart/form-data" name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);" this is the form heading. - Original Message - From: "Bryan LaPlante" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:44 AM Subject: Re: input type='file' I have a question about your script. Assuming the input looks like so form name="foo" input type="file" name="bar" /form does your script refer to the input as document.foo.bar.value; If so how did you work around the access denied js error that the browser gives me when I try this? - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:25 AM Subject: Re: input type='file' I had the same problem, it's ain't possible. What I used is to open a window indicating only .jpeg or .gif is allowed and then used a javascript to check what file was inserted in the formfield (before uploading, not after): take a look: script extensions = new Array(".JPG",".GIF",".gif",".jpg") function allowedExt(fileType){ var extension = fileType.substring(fileType.length-4, fileType.length) for (var i = 0; i extensions.length; i++) { if (extension == extensions[i]) { return true break } }alert(errorMsg()); return false } function errorMsg(){ alertTxt = "Please select one of the following file types: \n\r" for (var i = 2; i extensions.length; i++){ alertTxt += extensions[i] + " " { } }return alertTxt } Hope this helps. Bye. Michael Lugassy Interactive Music Ltd. ~~ 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: Screen Shot on Win 2K
Works for me. Sounds like maybe you have some video driver software that uses that combination as a hotkey to change display. If so you should be able to change or disable it some where under the display driver. -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 11:30 PM To: CF-Talk Subject: OT: Screen Shot on Win 2K Off Topic: How do you do a screen shot with Win 2000? When I try Shift + Alt + Print Screen it doesn't work like it used to in Win 98. Instead it wants to put the display in High Contrast. Thanks, Rich ~~ 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: Transferring 1-3Kb data
We I don't understand. Why do you need Coldfusion for this? For the client PCs..I think it would be much better to send the files via that same C++ client using FTP? And won't it be a lot easier to implement a log file transfer using a small C++ program running as a service under NT? Alternately you would have to use CFFTP to send the files from the production to the development server, and Schedule a task in the CF Administrator. There are also tags that will Zip the files for you via CF. Sorry I couldn't be more help. -Gel -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Please someone help out. - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] We devloped a client program (in visual c++) that stores log files for usage in the client and its features. I need the best way to deliver those small log files (no more then 2Kb for a full week of usage) to our CF production server and then, to zip those files and send them daily to our development server. I will definitly manage the 2 tasks of zipping and transferring the log files but what is the best way to create/get them from the client? I though about 2 alternatives: 1. open a ftp connection to upload the file weekly by each client. 2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not sclable enough, any help would be appriciated! Thanks, Michael Lugassy Interactive Music Ltd http://www.imvamp.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cookies not being set
I was away from my computer when all the answers came in. Thanks to all that helped. It seems that a javascript redirect is the best work around for now. Thanks again. Mike *** REPLY SEPARATOR *** On 4/16/2001 at 2:33 PM Nick McClure wrote: |CFLocation works on an http error. | |It is 302 Object Moved. | |Cookies work on an http header also. You could get happy and create the |http headers that will do this. It is all possible and I have done them |separately. I do not know if this will actually set the cookie though. I |am |going to try this later today. | |I will let you know how it works. | |At 01:57 PM 4/16/2001 -0400, you wrote: |Or write the redirect header manually: | |http://www.teamallaire.com/tutorials/index.cfm?fuseaction=displaytopicid=01 |3 | |Benjamin S. Rogers |Web Developer, c4.net |Voice: (508) 240-0051 |Fax: (508) 240-0057 | |-Original Message- |From: Adrian Cesana [mailto:[EMAIL PROTECTED]] |Sent: Monday, April 16, 2001 1:41 PM |To: CF-Talk |Subject: RE: cookies not being set | | |You cant use CFCOOKIE AND CFLOCATION on the same page, you may want to |change your CFLOCATION's to a META redirect. | |-Adrian ~~ 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: DNS
You'll probably get a lot better, more useful info from the DNS folks at [EMAIL PROTECTED] You can sign up to the list here: http://isp-lists.isp-planet.com/isp-dns/ Todd Ashworth -- - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 12:02 AM Subject: OT: DNS | i'm planning on migrating from MetaIP to Win2K DNS. has anyone made this | particular migration? any recommendations? has anyone had any trouble with | DNS on Win2K? | | tia. | | | ~~ 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: Transferring 1-3Kb data
Gel., Thanks for answering: 1. isn't a single FTP connection for each users (even for 1 minute) is time consuming and inefficient when there is the chance 100s of users will open unique FTP connections each time? 2. what do you mean by a C++ program running as service? can you give me an example? Bare in mind that our log files create itself on the client machine. the solution I'mt trying to find is to deliver this small log file to the server and store it there. won't getting the file in http (as a formfield) and creating the file myself (CFFILE) is better then a complete FTP session? Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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
CSS
I want to make "flat" select boxes, radio buttons, and checkboxes. What I mean is no shadow and a 1px border of a color. Anyone have any ideas? The browser for this app is always IE 5.x Thanks, Neil ~~ 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
Delimiters
Besides commas and pipes, what are the next best choices for delimiting lists? thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Transferring 1-3Kb data
2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not scalable enough, any help would be appriciated! Why is this not scalable ? ~~ 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
Help with Verity Error...pleeeease
Hello Ladies and Gentlemen, Always the same problem on my web site hosted by Intermedia with a Verity collection Error occurred in tag CFSEARCH Internal Error: VDKSessionNew failed Error Code: -125 Tech support always restarts the Cold Fusion services...until the next crash Any idea to fix this problem? Thanks a lot for your help Rémi van der Deure ~~ 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: CSS
I can not recall if this is possible at the moment, but a good ref for IE technology stuff is on the evil empire's web site at http://msdn.microsoft.com/workshop/c-frame.htm?/workshop/author/defaul t.asp It is actually a good ref for DHTML stuff even if the info is at times slightly jaded. Cheers! 'It looks like a strange Star Trek episode.' -- anonymous quote about Atlanta's blanket of yellow - Douglas Knudsen Leveraged Technologies Group !-- My views. All MINE -- Alltel AIS 678-351-6063 Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 04/17/2001 08:54 AM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: CSS I want to make "flat" select boxes, radio buttons, and checkboxes. What I mean is no shadow and a 1px border of a color. Anyone have any ideas? The browser for this app is always IE 5.x Thanks, Neil ~~ 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: Delimiters
use a series of hard to find types. something like: "~%~" this will guarntee NO ONE will type it. - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 2:54 PM Subject: Delimiters Besides commas and pipes, what are the next best choices for delimiting lists? thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CSS
input type="text" style="border:1px solid blue;" - Original Message - From: "Neil H." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 7:54 AM Subject: CSS I want to make "flat" select boxes, radio buttons, and checkboxes. What I mean is no shadow and a 1px border of a color. Anyone have any ideas? The browser for this app is always IE 5.x Thanks, Neil ~~ 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: CSS
Use something like: input type="text" name="whatever" style="background-color: FF; border: 1 solid FF" Or whatever - the style is the important inline code - or you could css the input tag if you prefer - however "flat" drop down select, radio and check are nearly impossible - you can change the bgcolor of the drop down and the font used in such, but I've never seen a flat radio (etc)... J -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: 17 April 2001 13:55 To: CF-Talk Subject: CSS I want to make "flat" select boxes, radio buttons, and checkboxes. What I mean is no shadow and a 1px border of a color. Anyone have any ideas? The browser for this app is always IE 5.x Thanks, Neil ~~ 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: CSS
Hope it can help... html head titleUntitled Document/title meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" style type="text/css" !-- ..box { border: #99; border-style: solid; border-top-width: thin; border-right-width: thin; border-bottom-width: thin; border-left-width: thin} -- /style /head body bgcolor="#FF" form method="post" action="" input type="text" name="textfield" class="box" /form /body /html ~~ 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: CSS
Go here: http://www.dansteinman.com/dynduo/ Look under Widgets on the left bottom. - Original Message - From: "Neil H." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 8:54 AM Subject: CSS I want to make "flat" select boxes, radio buttons, and checkboxes. What I mean is no shadow and a 1px border of a color. Anyone have any ideas? The browser for this app is always IE 5.x Thanks, Neil ~~ 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: Delimiters
Here is Mr. Watts suggestion which I have used extensively and had no problems with. "I typically use the ASCII bell character, CHR 7, for this. I've never had a problem yet, but maybe I'm just lucky." Dave Watts, CTO, Fig Leaf Software Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -- -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:55 AM To: CF-Talk Subject: Delimiters Besides commas and pipes, what are the next best choices for delimiting lists? thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Transferring 1-3Kb data
I don't know.. CFFILE? If there is no other way... :( - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 3:06 PM Subject: RE: Transferring 1-3Kb data 2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not scalable enough, any help would be appriciated! Why is this not scalable ? ~~ 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 wizard error in Coldfusion Studio
Hi all I just completed the Verity Wizard in Coldfusion Studio 4.5. (File - New - CFML - Verity Wizard) When I do a search it is fine, but as soon as I try to view one of the files it gives me an error: Error Diagnostic Information An error has occurred. HTTP/1.0 404 Object Not Found The url in the url bar is http://127.0.0.1/search/MyApplication_VOpenFile.cfm?serverFilePath=C%3A%5CCF USION%5CVerity%5CCollections%5Cfiles%5Csolve%2Edoc when I receive the error. My Verity collection name is gencol The path to the files is C:\cfusion\verity\collections\files\ I haven't made any modifications to the files generated by the wizard. If someone could help me on this matter I would greatly appreciate it. 1)What could the error be as I have run this wizard a couple of times and always get the same error. 2) Why is the URL presented in such a garbled way - is it for security reasons? 3) I see that the way it is trying to open the file is with a paramater extended to your cfm file. Is there perhaps a way to link directly to the file without appending the paramater to the cfm file? Regards Carlo van Wyk ~~ 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: Delimiters
A while back on this list Dave Watts suggested using a bell (chr(7), or Cntl-G for the more old school) for a delimiter, since it's a non-printable. I've used it ever since and saved myself a lot of headache. [Apologies if I'm crediting the wrong source here] Michael Caulfield -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 7:55 AM To: CF-Talk Subject: Delimiters Besides commas and pipes, what are the next best choices for delimiting lists? thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [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
Verity wizard error in Coldfusion Studio
Hi all I just completed the Verity Wizard in Coldfusion Studio 4.5. (File - New - CFML - Verity Wizard) When I do a search it is fine, but as soon as I try to view one of the files it gives me an error: Error Diagnostic Information An error has occurred. HTTP/1.0 404 Object Not Found The url in the url bar is http://127.0.0.1/search/MyApplication_VOpenFile.cfm?serverFilePath=C%3A%5CCF USION%5CVerity%5CCollections%5Cfiles%5Csolve%2Edoc when I receive the error. My Verity collection name is gencol The path to the files is C:\cfusion\verity\collections\files\ I haven't made any modifications to the files generated by the wizard. If someone could help me on this matter I would greatly appreciate it. 1)What could the error be as I have run this wizard a couple of times and always get the same error. 2) Why is the URL presented in such a garbled way - is it for security reasons? 3) I see that the way it is trying to open the file is with a paramater extended to your cfm file. Is there perhaps a way to link directly to the file without appending the paramater to the cfm file? Regards Carlo van Wyk Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Drop Down Combo Boxes Disappearing in IE
I have a CF page with approximately 40-50 drop down select/combo boxes (query driven dynamically named). On some computers in IE 5.5 the drop downs don't appear when the page loads -- there's only a white space where the drop down should be. Other form elements (text boxes, submit buttons) appear normally. Netscape seems fine but with only limited testing from me. Any ideas? Ricq Pattay ~ [EMAIL PROTECTED] Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities ~~ 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: Note passing system?
As strange as this may sound in light of normal developmental thought processes... I like to re-invent the wheel... each time I do, I get a better, more efficient, and sometimes a much better looking wheel... of course I don't do this all the time, and I may use a function or two that somebody else wrote, but I've always written my own applications. It's why I'm a developer... I love developing... At 02:37 AM 4/17/01 -0400, you wrote: :o) Hi Peter. I certainly understand where you're coming from. After 3 years of doing some solid CF work, I'm very capable of building most of the stuff that I need. I'm just an advocate of code reuse. If there's something out there that helps me reduce my coding time, I'd like to take advantage of it. I really hate reinventing the wheel. Thanks for the feedback... Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Peter Tilbrook" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:59 AM Subject: RE: Note passing system? As a side note - if you have an idea for your application - do it! Do not expect someone else to have already written the code for you. CF makes coding easy. If you are worried about the code have trusted people try and break it. Spend at least 3 weeks with beta testers on trusted code. You would be amazed at how the feedback either picks up problems or points out, even unobtrusively, better ways to accomplish a task. -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 15:33 To: CF-Talk Subject: RE: Note passing system? I implemented the same thing for the new Friends Plus site. The beauty of the system is that nobpdys email address is released. We could be draconian and introduce full auditing but it has not been necessary yet. The user remain anonymous and their email address is never released unless they give it out. -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 14:57 To: CF-Talk Subject: Re: Note passing system? Not really, Paul. Its more like an internal messaging system. One where I can write a message to another user or perhaps a group of users and have them correspnd back. Again, its not a true email system but one that would allow me to be able to communicate within the scope of my own application. Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Paul Begovich" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 7:35 PM Subject: Re: Note passing system? Sounds like you want a project management tool. We have an internal system here we use to parse out work. Basically the client/project manager submits an item to a form and it appears on the necessary persons desktop based on who they select. They see the item, do the work, mark their time, and reply via the form. It's a great project management tool and it keeps track of correspondence. Building a system like your describing isn't too difficult, it's just time consuming. We have looked into outside utilities to do this, but we've found them lacking. As a development shop we have found that when we need some additional functionality we build it on. The current system we have now has grown out of several developers efforts in the past two years to incompass project managment, billing, contacts, work requests, logging, and a host of other things. A third party too may save you time in the short run, but in the long run, it'll probably lacks the additional functionality you want. I recommend buiding your own system, keeping in mind you want to be able to add additionally functionality in the future. - Paul - Original Message - From: "Rey Bango" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:07 PM Subject: Note passing system? Anyone know of a good CF-based note/messaging system? I'm not talking about an email server but more of a db driven messaging software that will allow me to post a message to a specific suer. When that user comes in, they can check for their own messages and reply accordingly. Again, its not an email system per se. Thanks, Rey Bango... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:
order by not working
Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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 wizard error in Coldfusion Studio
Seems that the path you give for viewing document is not good - Original Message - From: Carlo van Wyk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 2:43 PM Subject: Verity wizard error in Coldfusion Studio Hi all I just completed the Verity Wizard in Coldfusion Studio 4.5. (File - New - CFML - Verity Wizard) When I do a search it is fine, but as soon as I try to view one of the files it gives me an error: Error Diagnostic Information An error has occurred. HTTP/1.0 404 Object Not Found The url in the url bar is http://127.0.0.1/search/MyApplication_VOpenFile.cfm?serverFilePath=C%3A%5CCF USION%5CVerity%5CCollections%5Cfiles%5Csolve%2Edoc when I receive the error. My Verity collection name is gencol The path to the files is C:\cfusion\verity\collections\files\ I haven't made any modifications to the files generated by the wizard. If someone could help me on this matter I would greatly appreciate it. 1)What could the error be as I have run this wizard a couple of times and always get the same error. 2) Why is the URL presented in such a garbled way - is it for security reasons? 3) I see that the way it is trying to open the file is with a paramater extended to your cfm file. Is there perhaps a way to link directly to the file without appending the paramater to the cfm file? Regards Carlo van Wyk 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: Transferring 1-3Kb data
Just a thought; why not send log data to the server (formfields/database) to begin with. amount of data is so trivial scalability shouldn't be a problem. (Unless I've totally misunderstood the problem, and you have hundreds of concurrent users) Dave - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:29 AM Subject: Re: Transferring 1-3Kb data I don't know.. CFFILE? If there is no other way... :( - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 3:06 PM Subject: RE: Transferring 1-3Kb data 2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not scalable enough, any help would be appriciated! Why is this not scalable ? ~~ 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: Delimiters
unprintable US-ASCII control characters, chr(30) for example At 01:54 PM 4/17/2001, you wrote: Besides commas and pipes, what are the next best choices for delimiting lists? thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Delimiters
At 03:11 PM 4/17/2001, you wrote: use a series of hard to find types. something like: "~%~" I think a sequence of characters is interpreted as a sequence of different possible delimiters, rather than a single delimiter comprising of a sequence of characters. Might be wrong, but I'm sure I ran into this a few years ago this will guarntee NO ONE will type it. - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 2:54 PM Subject: Delimiters Besides commas and pipes, what are the next best choices for delimiting lists? thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: order by not working
Not exactly sure what you're trying to do but you're telling the SQL Server to sort by the character '4'. You should specify a field name there without the quotes. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "paul ." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 9:52 AM Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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 wizard error in Coldfusion Studio
I have already double checked that and have set it up in different directories as well. Any other suggestions? Regards Carlo -Original Message- From: Capolinea [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 11, 2001 5:01 PM To: CF-Talk Subject: Re: Verity wizard error in Coldfusion Studio Seems that the path you give for viewing document is not good - Original Message - From: Carlo van Wyk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 2:43 PM Subject: Verity wizard error in Coldfusion Studio Hi all I just completed the Verity Wizard in Coldfusion Studio 4.5. (File - New - CFML - Verity Wizard) When I do a search it is fine, but as soon as I try to view one of the files it gives me an error: Error Diagnostic Information An error has occurred. HTTP/1.0 404 Object Not Found The url in the url bar is http://127.0.0.1/search/MyApplication_VOpenFile.cfm?serverFilePath=C%3A%5CCF USION%5CVerity%5CCollections%5Cfiles%5Csolve%2Edoc when I receive the error. My Verity collection name is gencol The path to the files is C:\cfusion\verity\collections\files\ I haven't made any modifications to the files generated by the wizard. If someone could help me on this matter I would greatly appreciate it. 1)What could the error be as I have run this wizard a couple of times and always get the same error. 2) Why is the URL presented in such a garbled way - is it for security reasons? 3) I see that the way it is trying to open the file is with a paramater extended to your cfm file. Is there perhaps a way to link directly to the file without appending the paramater to the cfm file? Regards Carlo van Wyk 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: Note passing system?
To a hammer, every problem seems like a nail -- Right? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Joe Sheble aka Wizaerd [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 9:43 AM To: CF-Talk Subject:Re: Note passing system? As strange as this may sound in light of normal developmental thought processes... I like to re-invent the wheel... each time I do, I get a better, more efficient, and sometimes a much better looking wheel... of course I don't do this all the time, and I may use a function or two that somebody else wrote, but I've always written my own applications. It's why I'm a developer... I love developing... At 02:37 AM 4/17/01 -0400, you wrote: :o) Hi Peter. I certainly understand where you're coming from. After 3 years of doing some solid CF work, I'm very capable of building most of the stuff that I need. I'm just an advocate of code reuse. If there's something out there that helps me reduce my coding time, I'd like to take advantage of it. I really hate reinventing the wheel. Thanks for the feedback... Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Peter Tilbrook" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:59 AM Subject: RE: Note passing system? As a side note - if you have an idea for your application - do it! Do not expect someone else to have already written the code for you. CF makes coding easy. If you are worried about the code have trusted people try and break it. Spend at least 3 weeks with beta testers on trusted code. You would be amazed at how the feedback either picks up problems or points out, even unobtrusively, better ways to accomplish a task. -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 15:33 To: CF-Talk Subject: RE: Note passing system? I implemented the same thing for the new Friends Plus site. The beauty of the system is that nobpdys email address is released. We could be draconian and introduce full auditing but it has not been necessary yet. The user remain anonymous and their email address is never released unless they give it out. -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 14:57 To: CF-Talk Subject: Re: Note passing system? Not really, Paul. Its more like an internal messaging system. One where I can write a message to another user or perhaps a group of users and have them correspnd back. Again, its not a true email system but one that would allow me to be able to communicate within the scope of my own application. Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Paul Begovich" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 7:35 PM Subject: Re: Note passing system? Sounds like you want a project management tool. We have an internal system here we use to parse out work. Basically the client/project manager submits an item to a form and it appears on the necessary persons desktop based on who they select. They see the item, do the work, mark their time, and reply via the form. It's a great project management tool and it keeps track of correspondence. Building a system like your describing isn't too difficult, it's just time consuming. We have looked into outside utilities to do this, but we've found them lacking. As a development shop we have found that when we need some additional functionality we build it on. The current system we have now has grown out of several developers efforts in the past two years to incompass project managment, billing, contacts, work requests, logging, and a host of other things. A third party too may save you time in the short run, but in the long run, it'll probably lacks the additional functionality you want. I recommend buiding your own system, keeping in mind you want to be able to add additionally functionality in the future. - Paul - Original Message - From: "Rey Bango" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:07 PM Subject: Note passing system? Anyone know of a good CF-based note/messaging system? I'm not talking about an email server but more of a db driven messaging software that will allow me to post a message to a specific suer. When that user comes in, they can check for their own messages and reply accordingly. Again, its not an email system per se. Thanks, Rey Bango... Certified Allaire Instructor Member of
RE: order by not working
If you're trying to sort by the 4th item in the columns list, omit the single quotes around 4. Given that you are using the * to select all the columns, I suggest specifying the column name in your order by clause. The next programmer (maybe you) who looks at the code will be glad you did; also, if the column order in the table is changed, you'll get unexpected results. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:53 AM To: CF-Talk Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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: Creating Page Breaks to make page printable?
I did an ASP project a while back that required page breaks on print. After head banging by a lot of people, I came up with the following code. When printed from "most" browsers, it prints in what looks like page breaks because of the way browsers try to not break images. If you tie your text content to an image (that is around 80% of the page height) with a table, the browser will print what looks to the user as page breaks. You might need to adjust the height of the spacer, but I think this is the number that worked in Netscape and IE 3 up. table width="100%" border="0" cellspacing="0" cellpadding="0" tr td width="10"img src="spacer.gif" width="1" height="450"/td tdPage One Content/td /tr /table table width="100%" border="0" cellspacing="0" cellpadding="0" tr td width="10"img src="spacer.gif" width="1" height="450"/td tdPage Two Content/td /tr /table Paul Sizemore Finish Line 3308 N Mitthoeffer Rd Indianapolis, IN 46235 W: 317-899-1022 ext 3516 -Original Message- From: Bill Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 3:07 AM To: CF-Talk Subject: RE: Creating Page Breaks to make page printable? Don't think page break is implemented in Navigator. -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: 17 April 2001 05:34 To: CF-Talk Subject: Re: Creating Page Breaks to make page printable? http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/pageBre akAfter.asp - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 6:20 PM Subject: Re: Creating Page Breaks to make page printable? Does anyone know of a way to force printing breaks of a document? You can do this with style sheets. -- This message sent compliments of db Technology http://www.dbtech.net/ ~~ 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: Transferring 1-3Kb data
Yes. we anticipate hunderds of users simulatniosly. - Original Message - From: "Dave f" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:04 PM Subject: Re: Transferring 1-3Kb data Just a thought; why not send log data to the server (formfields/database) to begin with. amount of data is so trivial scalability shouldn't be a problem. (Unless I've totally misunderstood the problem, and you have hundreds of concurrent users) Dave - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:29 AM Subject: Re: Transferring 1-3Kb data I don't know.. CFFILE? If there is no other way... :( - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 3:06 PM Subject: RE: Transferring 1-3Kb data 2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not scalable enough, any help would be appriciated! Why is this not scalable ? ~~ 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: DNS
I made that migration just a few weeks ago. The zone files from metaIP should transfer almost perfectly with just a few minor modifications. Marcus i'm planning on migrating from MetaIP to Win2K DNS. has anyone made this particular migration? any recommendations? has anyone had any trouble with DNS on Win2K? tia. ~~ 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
check this please
Hi Guys ! this is the SQl select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 'key_issues' DESC -- "key_issues" field has characters and i want the table to be sorted by the key_issues alpahebeticaly . kindly sugest -paul -- On Tue, 17 Apr 2001 09:16:27 Hayes, David wrote: If you're trying to sort by the 4th item in the columns list, omit the single quotes around 4. Given that you are using the * to select all the columns, I suggest specifying the column name in your order by clause. The next programmer (maybe you) who looks at the code will be glad you did; also, if the column order in the table is changed, you'll get unexpected results. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:53 AM To: CF-Talk Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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: Delimiters
chr(7) Justin -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 3:11 PM To: CF-Talk Subject: Re: Delimiters use a series of hard to find types. something like: "~%~" this will guarntee NO ONE will type it. - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 2:54 PM Subject: Delimiters Besides commas and pipes, what are the next best choices for delimiting lists? thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: check this please this orderby not working
-- On Tue, 17 Apr 2001 07:34:07 paul . wrote: Hi Guys ! this is the SQl select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 'key_issues' DESC -- "key_issues" field has characters and i want the table to be sorted by the key_issues alpahebeticaly . kindly sugest -paul -- On Tue, 17 Apr 2001 09:16:27 Hayes, David wrote: If you're trying to sort by the 4th item in the columns list, omit the single quotes around 4. Given that you are using the * to select all the columns, I suggest specifying the column name in your order by clause. The next programmer (maybe you) who looks at the code will be glad you did; also, if the column order in the table is changed, you'll get unexpected results. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:53 AM To: CF-Talk Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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: check this please
remove the quotes around key_issues like: select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY key_issues DESC HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "paul ." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:34 AM Subject: check this please Hi Guys ! this is the SQl select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 'key_issues' DESC -- "key_issues" field has characters and i want the table to be sorted by the key_issues alpahebeticaly . kindly sugest -paul -- On Tue, 17 Apr 2001 09:16:27 Hayes, David wrote: If you're trying to sort by the 4th item in the columns list, omit the single quotes around 4. Given that you are using the * to select all the columns, I suggest specifying the column name in your order by clause. The next programmer (maybe you) who looks at the code will be glad you did; also, if the column order in the table is changed, you'll get unexpected results. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:53 AM To: CF-Talk Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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
New Courseware Survey
In order to better serve our customers and the CF/MM community at-large, Fig Leaf Software has developed a courseware survey where you can indicate which web development topics interest you the most. All responses are anonymous. Please participate by accessing the following url: http://www.figleaf.com/trainingsurvey/ Regards, Steve Drucker CEO Fig Leaf Software ~~ 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: CSS
In IE all this does is put a gray square around the box?! Neil - Original Message - From: "Capolinea" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, March 11, 2001 10:18 AM Subject: Re: CSS Hope it can help... html head titleUntitled Document/title meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" style type="text/css" !-- ..box { border: #99; border-style: solid; border-top-width: thin; border-right-width: thin; border-bottom-width: thin; border-left-width: thin} -- /style /head body bgcolor="#FF" form method="post" action="" input type="text" name="textfield" class="box" /form /body /html ~~ 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: check this please
get off the ' out of "key_issues" - Original Message - From: "paul ." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:34 PM Subject: check this please Hi Guys ! this is the SQl select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 'key_issues' DESC -- "key_issues" field has characters and i want the table to be sorted by the key_issues alpahebeticaly . kindly sugest -paul -- On Tue, 17 Apr 2001 09:16:27 Hayes, David wrote: If you're trying to sort by the 4th item in the columns list, omit the single quotes around 4. Given that you are using the * to select all the columns, I suggest specifying the column name in your order by clause. The next programmer (maybe you) who looks at the code will be glad you did; also, if the column order in the table is changed, you'll get unexpected results. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:53 AM To: CF-Talk Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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: Creating Page Breaks to make page printable?
If you mean a printable version for every page (just like we did on: http://www.imvamp.com/support/documentation/player/monitor/index.html (click on: printable version) you should use a table code that will break the line at about 650 pixels width just specify table width=650 and on every td specify td width=650 this will break lines automaticlly at the end of the words with no need to use BR or special wrapping techniques. just keep the table below 650pixels! and make a clean page. people like it! Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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: check this please
well Howie !. key_issues field is a charecter field.. it throws erroer -paul -- On Tue, 17 Apr 2001 10:43:42 Howie Hamlin wrote: remove the quotes around key_issues like: select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY key_issues DESC HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "paul ." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:34 AM Subject: check this please Hi Guys ! this is the SQl select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 'key_issues' DESC -- "key_issues" field has characters and i want the table to be sorted by the key_issues alpahebeticaly . kindly sugest -paul -- On Tue, 17 Apr 2001 09:16:27 Hayes, David wrote: If you're trying to sort by the 4th item in the columns list, omit the single quotes around 4. Given that you are using the * to select all the columns, I suggest specifying the column name in your order by clause. The next programmer (maybe you) who looks at the code will be glad you did; also, if the column order in the table is changed, you'll get unexpected results. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:53 AM To: CF-Talk Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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: check this please
remove the single quotes around key_issues Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 10:34 AM To: CF-Talk Subject: check this please Hi Guys ! this is the SQl select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 'key_issues' DESC -- "key_issues" field has characters and i want the table to be sorted by the key_issues alpahebeticaly . kindly sugest -paul -- On Tue, 17 Apr 2001 09:16:27 Hayes, David wrote: If you're trying to sort by the 4th item in the columns list, omit the single quotes around 4. Given that you are using the * to select all the columns, I suggest specifying the column name in your order by clause. The next programmer (maybe you) who looks at the code will be glad you did; also, if the column order in the table is changed, you'll get unexpected results. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:53 AM To: CF-Talk Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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
ODD CF error message
This one came in our support logs today: THISTAG.HASENDTAG=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223 335654321 Anyone? Thanks! Shawnea Carter ~~ 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: check this please
take the single quotes out. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 7:34 AM To: CF-Talk Subject: check this please Hi Guys ! this is the SQl select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 'key_issues' DESC -- "key_issues" field has characters and i want the table to be sorted by the key_issues alpahebeticaly . kindly sugest -paul -- On Tue, 17 Apr 2001 09:16:27 Hayes, David wrote: If you're trying to sort by the 4th item in the columns list, omit the single quotes around 4. Given that you are using the * to select all the columns, I suggest specifying the column name in your order by clause. The next programmer (maybe you) who looks at the code will be glad you did; also, if the column order in the table is changed, you'll get unexpected results. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:53 AM To: CF-Talk Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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: check this please
post your error. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 7:57 AM To: CF-Talk Subject: Re: check this please well Howie !. key_issues field is a charecter field.. it throws erroer -paul -- On Tue, 17 Apr 2001 10:43:42 Howie Hamlin wrote: remove the quotes around key_issues like: select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY key_issues DESC HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "paul ." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:34 AM Subject: check this please Hi Guys ! this is the SQl select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 'key_issues' DESC -- "key_issues" field has characters and i want the table to be sorted by the key_issues alpahebeticaly . kindly sugest -paul -- On Tue, 17 Apr 2001 09:16:27 Hayes, David wrote: If you're trying to sort by the 4th item in the columns list, omit the single quotes around 4. Given that you are using the * to select all the columns, I suggest specifying the column name in your order by clause. The next programmer (maybe you) who looks at the code will be glad you did; also, if the column order in the table is changed, you'll get unexpected results. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:53 AM To: CF-Talk Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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: Transferring 1-3Kb data
With a couple of hundred users simultaneously, I dont think this is a job for CF, unless it's just processing the files after they have been uploaded. I think this functionality needs to be built into your application. The application needs to open a connection to the host which is listening for your clients Upload the file, then disconnect. Easier than writing an mp3 decoder... At least in java it would be... jon - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 11:24 AM Subject: Re: Transferring 1-3Kb data Yes. we anticipate hunderds of users simulatniosly. - Original Message - From: "Dave f" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:04 PM Subject: Re: Transferring 1-3Kb data Just a thought; why not send log data to the server (formfields/database) to begin with. amount of data is so trivial scalability shouldn't be a problem. (Unless I've totally misunderstood the problem, and you have hundreds of concurrent users) Dave - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:29 AM Subject: Re: Transferring 1-3Kb data I don't know.. CFFILE? If there is no other way... :( - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 3:06 PM Subject: RE: Transferring 1-3Kb data 2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not scalable enough, any help would be appriciated! Why is this not scalable ? ~~ 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: Creating Page Breaks to make page printable?
I use max table width of 670 with similar success. The advantage of this in addition to printing is that 670 pixel width displays well on any size screen. On 640x480 the user has to scroll the screen right to see everything. On 800x640 the total available screen width is used effectively. On higher resolution screens the used area is still restricted to the 670 pixel center portion of the screen. When printing, the 670 pixels will fit on a portrait page well (680 is to big). 650 pixel table widths will also work fine, but you can get 20 more pixels with the 670 setting. Vertical paginated control of printed pages is a completely different issue. There I am using PDF files -- created and displayed in the browser via an application button -- not the browsers print button. Alternatively one can use CFEXECUTE to run Access or FoxPro report writer on the server and print to a PDF file which is then displayed in the browser and printed accordingly (the latter requires the CF administrator permission to run CFEXECUTE, which is unlikely on hosted shared servers). Don't you just love the fact that these hot-shot tool developers provide us poor little application developers with these half-baked tools. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Michael Lugassy [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:55 AM To: CF-Talk Subject:Re: Creating Page Breaks to make page printable? If you mean a printable version for every page (just like we did on: http://www.imvamp.com/support/documentation/player/monitor/index.html (click on: printable version) you should use a table code that will break the line at about 650 pixels width just specify table width=650 and on every td specify td width=650 this will break lines automaticlly at the end of the words with no need to use BR or special wrapping techniques. just keep the table below 650pixels! and make a clean page. people like it! Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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: (Easy SQL)
Take a look at the convert function. convert(char(8), signup_datetime, 1) as signup_date should give you what you want. -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 2:09 PM To: CF-Talk Subject: (Easy SQL) I have a member table which contains userid, signup_datetime I want to create a daily summary of registrations. select signup_datetime as justDatenotTime,count(userID) as NewMembers from membertable group by justDatenotTime == * == I know this has to be simple, but I can't find the syntax. How do I drop the time from a datetime field (SQL Server 7/2000/MSDE) so I can group by just the day? ~~ 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
great Search Results snippest!
Hi, I just constructed a snippest that will highlight each word on the results page (very much like MSDN results page). SUPPORT MULTIPLE keywords! I just did it in a couple of minutes and HAD TO GIVE IT TO YA to look and use. I will post the optimized version soon... *class="highlight" reffers to the design you want to highlight in my case: style type="text/css" ..highlight{background-color : Yellow;} /style This is the coldfusion code you'll need: cfset a=ArrayNew(1) cfset a=ListToArray(q," ") !---q is the query form field--- cfoutput query="x" !--- match your query/verity switch here--- cfset thisrow="" cfif Arraylen(a) eq 1cfset toary=1 cfset row=""cfelsecfset row="ReplaceNoCase("cfset toary=evaluate(Arraylen(a)-1)/cfif cfloop index="i" from="1" to="#toary#" cfset row=row"ReplaceNoCase(" /cfloop cfset row=row"#chr(34)##SUMMARY##chr(34)#" !--- you can change SUMMARY to whatever you're searching/displaying as results--- cfloop index="i" from="1" to="#Arraylen(a)#" cfset thisrow=thisrow",#chr(34)##a[i]##chr(34)#,#chr(34)#font class=highlight#a[i]#/font#chr(34)#)" /cfloop cfset row=rowthisrow #evaluate(row)# /cfoutput this will work on multiple words! Send me your comments. Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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
Setting up Access Datasources
Here's an interesting question: We recently set up a server cluster that is configured in this fashion: Web1/Web2 Boxes: Win 2K Advanced Server SP1, CF Enterprise 4.5, MDAC 2.5 SQL Box: Win 2K Advanced Server SP1, SQL Server 7.0 NowI can get SQL Server databases to verify on both Web boxes with no problem. I've mapped a drive onto the Web boxes to add Access databases but I cannot get them to verify. Any help with be appreciated. Curtis C. Layton Senior Web Applications Developer Words In Progress Inc. [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
ZIPPING with coldfusion
Could someone point to a good program/object I can use to easily zip a couple of 100s .txt files using CFEXCUTE or CFOBJECT? (Not in Developer's Exchange..) Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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
Accessing UniData
Has anyone ever used CF to access data in a UniData database? Our library circulation system uses UniData (v. 3.3.2i.b2) to store all book and patron data, and I'm wondering if I could set it up to interface with CF. If anyone has any advice I'd really appreciate it. -- Owen Athens County Library Services http://www.athenscounty.lib.oh.us ~~ 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
WAG Equipment/Bandwidth requirements
Does anyone have an estimate, or knows of a source of infomation, that can determine the number of servers (web/db/etc) that one would need based on unique vistors a month? If one wanted to run a site with 300K Unique Vistors per month, how would you estimate the number of servers needed in a cluster and also the bandwidth needed. I know there are a lot of variable like the average amount of data per request etc. But any WAG estimation info would be appreciated. Thanks, Bill ~~ 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: Transferring 1-3Kb data
I'm glad you checked out our product. :) But what is exactly this connection to the host? is it via FTP or HTTP? How is this done with visual c++? - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 5:34 PM Subject: Re: Transferring 1-3Kb data With a couple of hundred users simultaneously, I dont think this is a job for CF, unless it's just processing the files after they have been uploaded. I think this functionality needs to be built into your application. The application needs to open a connection to the host which is listening for your clients Upload the file, then disconnect. Easier than writing an mp3 decoder... At least in java it would be... jon - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 11:24 AM Subject: Re: Transferring 1-3Kb data Yes. we anticipate hunderds of users simulatniosly. - Original Message - From: "Dave f" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:04 PM Subject: Re: Transferring 1-3Kb data Just a thought; why not send log data to the server (formfields/database) to begin with. amount of data is so trivial scalability shouldn't be a problem. (Unless I've totally misunderstood the problem, and you have hundreds of concurrent users) Dave - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:29 AM Subject: Re: Transferring 1-3Kb data I don't know.. CFFILE? If there is no other way... :( - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 3:06 PM Subject: RE: Transferring 1-3Kb data 2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not scalable enough, any help would be appriciated! Why is this not scalable ? ~~ 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: ZIPPING with coldfusion
This one works great, http://www.forta.com/cf/tags/ I use it for my Custom tag wizard http://www.netwebapps.com/mytags/main.cfm - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 11:42 AM Subject: ZIPPING with coldfusion Could someone point to a good program/object I can use to easily zip a couple of 100s .txt files using CFEXCUTE or CFOBJECT? (Not in Developer's Exchange..) Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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: ZIPPING with coldfusion
PKZip command line would work well with CFExecute www.pkware.com I have done it before in perl so I am sure it can be done with CFExecute. At 06:42 PM 4/17/2001 +0200, you wrote: Could someone point to a good program/object I can use to easily zip a couple of 100s .txt files using CFEXCUTE or CFOBJECT? (Not in Developer's Exchange..) Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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 up Access Datasources
alot of times people forget to clear out the username field that is normally populated with the default "admin" just a suggestion... Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Curtis C. Layton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:10 AM To: CF-Talk Subject: Setting up Access Datasources Here's an interesting question: We recently set up a server cluster that is configured in this fashion: Web1/Web2 Boxes: Win 2K Advanced Server SP1, CF Enterprise 4.5, MDAC 2.5 SQL Box: Win 2K Advanced Server SP1, SQL Server 7.0 NowI can get SQL Server databases to verify on both Web boxes with no problem. I've mapped a drive onto the Web boxes to add Access databases but I cannot get them to verify. Any help with be appreciated. Curtis C. Layton Senior Web Applications Developer Words In Progress Inc. [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ZIPPING with coldfusion
This may not be what your looking for, but there is actually a ZIP object exposed by CFStudio, easily scriptable with js or vbs. You can find docs on it in the "scripting the visual tools object model" help file. If you're just looking to do some admin tasks, it might be a good choice. License doesn't cover use outside of studio though. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:42 AM To: CF-Talk Subject: ZIPPING with coldfusion Could someone point to a good program/object I can use to easily zip a couple of 100s .txt files using CFEXCUTE or CFOBJECT? (Not in Developer's Exchange..) Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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: ZIPPING with coldfusion
There's CFX_Zip, if you want "native" tool. Otherwise, most of the popular ZIP compression tools support command-line execution. WinZip, for example, has a CLI add-on at their download site. Steve -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 12:42 PM To: CF-Talk Subject: ZIPPING with coldfusion Could someone point to a good program/object I can use to easily zip a couple of 100s .txt files using CFEXCUTE or CFOBJECT? (Not in Developer's Exchange..) Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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: great Search Results snippest!
This seems to be a bit overcomplex, unless I'm misreading your code. Why not just use Regex? !--- This would be the keywords searched for --- CFSET Searched = "ray camden" CFSET ModSearched = "(" Replace(Searched," ","|","ALL") ")" !--- This would be the results from the DB, normally a query --- CFSET Results = "This is a ray test camden foo." CFOUTPUT #REReplace(Results,"#ModSearched#","SPAN CLASS=""highlight""\1/SPAN","ALL")# /CFOUTPUT === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 12:03 PM To: CF-Talk Subject: great Search Results snippest! Hi, I just constructed a snippest that will highlight each word on the results page (very much like MSDN results page). SUPPORT MULTIPLE keywords! I just did it in a couple of minutes and HAD TO GIVE IT TO YA to look and use. I will post the optimized version soon... *class="highlight" reffers to the design you want to highlight in my case: ~~ 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: Does Studio have Built-in Scripting?
I was looking at the figleaf downloaded slides from the Using VTOM presentation by Mr. Powers and was wondering - what language is the code on 4th slide? Normally I think of Windows Scripting Host as being something like Visual Basic. What is on page 4 appears to be Javascript; and in fact, the example files are all *.js , which is what I know I use for javascript. I am certain that I'm missing something from just reading the slides - perhaps someone can (gently smile) educate me a bit further on this topic... -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ 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
Using Java in CF
A little help please. I am trying to use some javascript on my CF pages. I would like to pass the formname and fieldname to the function, perform an action and return the value: i.e. SCRIPT LANGUAGE = "JavaScript" !-- function changevalue(FormName, FieldName) { var oldvalue; var newvalue; oldvalue = document.FormName.FieldName.value; TAKE ACTION HERE document.FormName.FieldName.value = newvalue; } //-- /SCRIPT The formname and Fieldnames are being passed fine, but how do I use them. now oldvalue is being set EQ to "document.FormName.FieldName.value" not the value of the field , how can I get the value from the form field. If I call the formfield in the function by hardcoding its name I get the function to work fine, but I would like to re-use this without having to change the function each time. Thanks for your help Rodney ~~ 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
Cookies and their expiration
Still pretty new to all this, but am being asked some questions by superiors about CF's use/creation of cookies CF (to maintain state) drops a "cookie" on the client that contains a cfid and cftoken Looking at the cookie (it's properties) in IE, (said superior noted with some surprise) that the expriation is, or appears to be 2037. MY Question: is there a way to cause said cfid/token/cookie to expire sooner (a lot sooner)? I tried several things recommended in the books...but the cookie remained on the browserpersistant little bugger that it is. suggestions? Jon Moneymaker (and yes...that really is my last name) Network Administrator Fleet and Family Support Center, Yorktown, VA ~~ 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: check this please: the error on removing the single '
hi Guys this is what i got by removing the single quote -- DB2 Error Code = -134 [IBM][CLI Driver][DB2/6000] SQL0134N Improper use of a string column, host variable, constant, or function "KEY_ISSUES". SQLSTATE=42907 SQL = "select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY key_issues DESC" Data Source = "QRTREPORTS" -paul -- On Tue, 17 Apr 2001 08:26:18 Dylan Bromby wrote: take the single quotes out. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 7:34 AM To: CF-Talk Subject: check this please Hi Guys ! this is the SQl select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 'key_issues' DESC -- "key_issues" field has characters and i want the table to be sorted by the key_issues alpahebeticaly . kindly sugest -paul -- On Tue, 17 Apr 2001 09:16:27 Hayes, David wrote: If you're trying to sort by the 4th item in the columns list, omit the single quotes around 4. Given that you are using the * to select all the columns, I suggest specifying the column name in your order by clause. The next programmer (maybe you) who looks at the code will be glad you did; also, if the column order in the table is changed, you'll get unexpected results. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:53 AM To: CF-Talk Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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: Does Studio have Built-in Scripting?
No, actually you're not missing anything. Windows scripting host is just what the name implies: a host for various scripting languages to run in. WSH is language neutral and can be used with vbs, js, perlscript, etc. So if you are a javascripter, go wild. -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:08 AM To: CF-Talk Subject: Re: Does Studio have Built-in Scripting? I was looking at the figleaf downloaded slides from the Using VTOM presentation by Mr. Powers and was wondering - what language is the code on 4th slide? Normally I think of Windows Scripting Host as being something like Visual Basic. What is on page 4 appears to be Javascript; and in fact, the example files are all *.js , which is what I know I use for javascript. I am certain that I'm missing something from just reading the slides - perhaps someone can (gently smile) educate me a bit further on this topic... -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ 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: Does Studio have Built-in Scripting?
Windows Script Host actually runs CScript, WScript, JScript, and VBScript, if I'm not mistaken. I haven't used CScript or WScript, and I use JavaScript in my front-end coding, so that was my natural choice to write my tools in. If you have any other questions, feel free to hit me offlist, and I'd be glad to discuss them with you. Jason Powers Fig Leaf Software -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 12:08 PM To: CF-Talk Subject: Re: Does Studio have Built-in Scripting? I was looking at the figleaf downloaded slides from the Using VTOM presentation by Mr. Powers and was wondering - what language is the code on 4th slide? Normally I think of Windows Scripting Host as being something like Visual Basic. What is on page 4 appears to be Javascript; and in fact, the example files are all *.js , which is what I know I use for javascript. I am certain that I'm missing something from just reading the slides - perhaps someone can (gently smile) educate me a bit further on this topic... -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ 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 up Access Datasources
-Original Message- From: Curtis C. Layton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:10 AM To: CF-Talk Subject: Setting up Access Datasources Here's an interesting question: We recently set up a server cluster that is configured in this fashion: Web1/Web2 Boxes: Win 2K Advanced Server SP1, CF Enterprise 4.5, MDAC 2.5 SQL Box: Win 2K Advanced Server SP1, SQL Server 7.0 NowI can get SQL Server databases to verify on both Web boxes with no problem. I've mapped a drive onto the Web boxes to add Access databases but I cannot get them to verify. Any help with be appreciated. Make sure ColdFusion is running under a user account with sufficient rights to your servers. ColdFusion must be running under it's own user account to be able to access network drives. - Andy ~~ 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: Cookies and their expiration
Jon, The reason the cookie last so long is to effectively never expire it. Preferably, you don't want to reassign a user a new CFID/CFTOKEN pair--you want to keep those cookies on their system forever, that way you'd be able to track that particular user over the lifetime of the app. The length of the cookie doesn't reflect the length of the user's session or client variables--that's all independant of each other. However, if you do want to override the setting, you should be able to use the CFCOOKIE tag and manually re-write the CFID/CFTOKEN variables with a shorter lifespan. Just be aware that doing so would cause the server to regenerate a new CFID/CFTOKEN pair for the same browser if they visit your site after the cookie expires. -Dan -Original Message- From: Moneymaker, Jon S (WPNSTA Yorktown) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 12:08 PM To: CF-Talk Subject: Cookies and their expiration Still pretty new to all this, but am being asked some questions by superiors about CF's use/creation of cookies CF (to maintain state) drops a "cookie" on the client that contains a cfid and cftoken Looking at the cookie (it's properties) in IE, (said superior noted with some surprise) that the expriation is, or appears to be 2037. MY Question: is there a way to cause said cfid/token/cookie to expire sooner (a lot sooner)? I tried several things recommended in the books...but the cookie remained on the browserpersistant little bugger that it is. suggestions? Jon Moneymaker (and yes...that really is my last name) Network Administrator Fleet and Family Support Center, Yorktown, VA ~~ 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
escaping ' in SQL
Hi everyone, I have a question about how to pass an SQL statement through a text area box in a form while protecting the SQL statement. Below I have a self-submitting form, that passes the dynamic text through the text-area box and then passes to a query that is to be then displayed. Problem is, that the SQL gets re-parsed when I use the " ' " single tick for a string to a " " " double tick. I have tried htmlcodeFormat() and htmleditformat() with no success. The error I recieve is: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near 'n'. SQL = "select * from d_school_names where charter_school = ''n''" Here is my code: html head /head body bgcolor="#C0C0C0" cfif isdefined("form.submit") !--- Dynamice Query --- !--- cftry --- cfquery name="dynQuery" datasource="xxx" username="" password="" #form.sql# /cfquery !--- Outputting query --- cfset columns = ListtoArray(#dynQuery.ColumnList#) cfset numColumns = arraylen(#columns#) table border="1" cellpadding="1" cellspacing="1" thCurrent Row/th cfloop index="i" from="1" to="#numColumns#" cfoutputth#columns[i]#/th/cfoutput /cfloop cfloop query="dynQuery" tr td cfoutput#dynQuery.currentRow#/cfoutput /td cfloop index="i" from="1" to="#numColumns#" td cfoutput cfif evaluate(columns[i]) EQ "" nbsp; cfelse #evaluate(columns[i])# /cfif /cfoutput /td /cfloop /tr /cfloop /table !--- cfcatch type="Database" You have caused a database error! Please hit your back button and try again. /cfcatch !--- Catching any type of error. --- cfcatch type="Any" You have caused a database error! Please hit your back button and try again. /cfcatch /cftry --- !--- First time through form --- cfelse h3 Please Enter a SQL Statement below/h3 form action="#cgi.script_name#?#cgi.Query_String#" method="post" textarea cols="50" rows="5" name="SQL" /textarea br input type="Submit" name="submit" /form /cfif /body /html Gil Barden ~~ 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: check this please: the error on removing the single '
post the columns and their respective datatypes. i'm not super familiar with DB2 though so i don't know if that's a nuance of that DB. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 9:20 AM To: CF-Talk Subject: RE: check this please: the error on removing the single ' hi Guys this is what i got by removing the single quote -- DB2 Error Code = -134 [IBM][CLI Driver][DB2/6000] SQL0134N Improper use of a string column, host variable, constant, or function "KEY_ISSUES". SQLSTATE=42907 SQL = "select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY key_issues DESC" Data Source = "QRTREPORTS" -paul -- On Tue, 17 Apr 2001 08:26:18 Dylan Bromby wrote: take the single quotes out. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 7:34 AM To: CF-Talk Subject: check this please Hi Guys ! this is the SQl select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 'key_issues' DESC -- "key_issues" field has characters and i want the table to be sorted by the key_issues alpahebeticaly . kindly sugest -paul -- On Tue, 17 Apr 2001 09:16:27 Hayes, David wrote: If you're trying to sort by the 4th item in the columns list, omit the single quotes around 4. Given that you are using the * to select all the columns, I suggest specifying the column name in your order by clause. The next programmer (maybe you) who looks at the code will be glad you did; also, if the column order in the table is changed, you'll get unexpected results. -Original Message- From: paul . [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 8:53 AM To: CF-Talk Subject: order by not working Hi guys am using orderby to sort the fields to get the sort order alphabetically am finding taht is not working please suggest --- select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC the above is the SQL whats wrong -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~ 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: Transferring 1-3Kb data
Not necessarily either although there are tons of ftp libraries out there that could be implemented into the program very easily. A raw tcp or udp connect on whatever port you want would work. You would have to write the server side app that received the file, then write it to the hard drive. I think if I was doing this, I'd code the ftp capabilities into the client and just make the program upload it's log file, if only in the interest of time savings, and programming an industrial size server side daemon in java is not something a can do yet ;-) jon - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 12:57 PM Subject: Re: Transferring 1-3Kb data I'm glad you checked out our product. :) But what is exactly this connection to the host? is it via FTP or HTTP? How is this done with visual c++? - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 5:34 PM Subject: Re: Transferring 1-3Kb data With a couple of hundred users simultaneously, I dont think this is a job for CF, unless it's just processing the files after they have been uploaded. I think this functionality needs to be built into your application. The application needs to open a connection to the host which is listening for your clients Upload the file, then disconnect. Easier than writing an mp3 decoder... At least in java it would be... jon - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 11:24 AM Subject: Re: Transferring 1-3Kb data Yes. we anticipate hunderds of users simulatniosly. - Original Message - From: "Dave f" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:04 PM Subject: Re: Transferring 1-3Kb data Just a thought; why not send log data to the server (formfields/database) to begin with. amount of data is so trivial scalability shouldn't be a problem. (Unless I've totally misunderstood the problem, and you have hundreds of concurrent users) Dave - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:29 AM Subject: Re: Transferring 1-3Kb data I don't know.. CFFILE? If there is no other way... :( - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 3:06 PM Subject: RE: Transferring 1-3Kb data 2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not scalable enough, any help would be appriciated! Why is this not scalable ? ~~ 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 up Access Datasources
Thanks...that might be it...I was messing with the service logins but I'm going to have to talk to our SA to work that one out. Thanks again. - Original Message - From: "Andrew Tyrone" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 12:47 PM Subject: RE: Setting up Access Datasources -Original Message- From: Curtis C. Layton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:10 AM To: CF-Talk Subject: Setting up Access Datasources Here's an interesting question: We recently set up a server cluster that is configured in this fashion: Web1/Web2 Boxes: Win 2K Advanced Server SP1, CF Enterprise 4.5, MDAC 2.5 SQL Box: Win 2K Advanced Server SP1, SQL Server 7.0 NowI can get SQL Server databases to verify on both Web boxes with no problem. I've mapped a drive onto the Web boxes to add Access databases but I cannot get them to verify. Any help with be appreciated. Make sure ColdFusion is running under a user account with sufficient rights to your servers. ColdFusion must be running under it's own user account to be able to access network drives. - Andy ~~ 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