RE: Printing PDF's using ColdFusion?
We're using ActivePDF to do the merging of multiple PDFs into one - works a dream! Keith -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 05:08 To: CF-Talk Subject: RE: Printing PDF's using ColdFusion? I've bought into a libary from www.amyuni.com that installs like the driver from Adobe, except you can create PDFs in the blind without user intervention. It works great and is quite fast. I have implemented it to create numerous PDF files from a lan-based FoxPro application running eiter locally or on the Server that get stored on the server and are then called up by the user using the Adobe Reader. I am also still in the process of merging it with CF directly to create and print PDF files. They have numerous examples on its use with FoxPro and ASP (no examples on using it with CF). Single client licenses cost $120 and can be used just like Adobe's Writer, an unrestricted developers version cost $800. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Craig Perry [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 10:51 PM To: CF-Talk Subject: Printing PDF's using ColdFusion? I was wondering if anybody knew how to print PDF's (or other files) using ColdFusion by bringing up the print dialog automatically? The end result is that I want the user to click a button which prints the PDF associated with the button. Also, how about PDF manipulation through ColdFusion? Best case scenario: merging multiple PDF's into one PDF and then automatically printing that new PDF. Any ideas? Thanks. Craig ~~ 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: Printing PDF's using ColdFusion?
Keith, I have been advised to use active pdf. I have download the trials but haven't really found the website very useful. Can you offer any advice/links please? -- Gavin Lilley Internet / Intranet Developer http://halesowen.ac.uk -Original Message- From: Keith Thornburn [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 08:57 To: CF-Talk Subject: RE: Printing PDF's using ColdFusion? We're using ActivePDF to do the merging of multiple PDFs into one - works a dream! Keith -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 05:08 To: CF-Talk Subject: RE: Printing PDF's using ColdFusion? I've bought into a libary from www.amyuni.com that installs like the driver from Adobe, except you can create PDFs in the blind without user intervention. It works great and is quite fast. I have implemented it to create numerous PDF files from a lan-based FoxPro application running eiter locally or on the Server that get stored on the server and are then called up by the user using the Adobe Reader. I am also still in the process of merging it with CF directly to create and print PDF files. They have numerous examples on its use with FoxPro and ASP (no examples on using it with CF). Single client licenses cost $120 and can be used just like Adobe's Writer, an unrestricted developers version cost $800. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Craig Perry [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 10:51 PM To: CF-Talk Subject: Printing PDF's using ColdFusion? I was wondering if anybody knew how to print PDF's (or other files) using ColdFusion by bringing up the print dialog automatically? The end result is that I want the user to click a button which prints the PDF associated with the button. Also, how about PDF manipulation through ColdFusion? Best case scenario: merging multiple PDF's into one PDF and then automatically printing that new PDF. Any ideas? Thanks. Craig ~~ 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 substring?
is there any substring function for CF? 1) Open CF Documentation 2) Click on "Functions" 3) Click on "String Functions" 4) Look down list Total time taken - less than 30 seconds Alternatively 1) Send email to CF-Talk 2) Wait 5 minutes for response 3) Not learn how to lookup functions To be honest (and I may be being harsh here), but if you worked for me, you'd be on a written warning or out of the door Anyone too lazy to do 30 seconds of checking in the docs just wouldn't work for me! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Performance Tests
So if I need to loop over the contents of one column of a large query, which would be faster: cfloop query="big_query" ...do stuff with #column1#... /cfloop cfloop list="#ValueList(big_query.column1)#" index="i" do stuff with #i#... /cfloop cfset myarray=ListToArray(ValueList(big_query.column1)) cfloop index="i" from="1" to="#ArrayLen(myarray)#" do stuff with myarray[#i#]... /cfloop this needs to be a cfloop since I'm using tags in it. Looping over lists, and list functions are always slower than referring directly to an array or a query There is another alternative; If you're not doing a CFOutput cfscript for (i=1; i lte big_query.recordCount; i=i+1) { do stuff with big_query.Column1[i]; } /cfscript or if you need CFOutput cfloop index="i" from=1 to="#big_query.recordCount#" do stuff with big_query.Column1[i] /cfloop Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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 substring?
Who says he's a professional developer, or that anyone even pays him to write code? Damned glad to see you'd know how to handle the situation, though. Jim - Original Message - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 2:41 AM Subject: RE: CF substring? is there any substring function for CF? 1) Open CF Documentation 2) Click on "Functions" 3) Click on "String Functions" 4) Look down list Total time taken - less than 30 seconds Alternatively 1) Send email to CF-Talk 2) Wait 5 minutes for response 3) Not learn how to lookup functions To be honest (and I may be being harsh here), but if you worked for me, you'd be on a written warning or out of the door Anyone too lazy to do 30 seconds of checking in the docs just wouldn't work for me! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Accessing field names dynamically
This does it for me cfloop list="#queryname.columnlist#" index="fieldname" tdcfoutput#fieldname#/cfoutput/td /cfloop Nick -Original Message- From: Lockie Martin [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 2:36 AM To: CF-Talk Subject: Accessing field names dynamically This question comes into the category of I've seen it somewhere! I have a crosstab query in Access and as you will be aware the column headings in that kind of query come from the data and of course will be variable in name and number. Is there any way of accessing the field names for the columns from the query. Perhaps looping through them to present them on the screen. I know I have seen it somewhere! Thanks in advance --- Lockie Martin [EMAIL PROTECTED] http://www.keystone-solutions.com/ http://marquee/ http://www.keystone-support.net PER [EMAIL PROTECTED] MSN [EMAIL PROTECTED] ICQ 19741013 +64-9-357 0408 x339 (work) +64-2-174 3910 (cell) +64-9-357 0414 (work fax) ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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 substring?
Who says he's a professional developer, or that anyone even pays him to write code? Damned glad to see you'd know how to handle the situation, though. It's still easier to look into documentation for something that simple than to ask a list which can take 5-10 minutes (at a minimum to respond) We have actually got rid of a developer who never looked in books or on-line documentation and asked for help about everything A typical question was "How do I change the background color on a page?" when they were meant to know HTML I can understand asking questions which aren't readily available in the documentation within a few minutes of searching, but asking questions like this is just plain lazy Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
Hints'n'Tips page - any tags I can download?
Before I start to develop an app from scratch, I thought I'd ask if anyone know of a custom tag or app that 's already done, that might give me all or most of what I need ... I have a hints and tips page, where I collect common questions and add the answers. So it's just a FAQ page. But there will quite often be several valid answers to a question, and I'd like to be able to have them all on the site. Some of the answers have illustrations to go with them, and some can be quite long - several paragraphs. And I'd like them to be searchable, so that means either verity collection or database. So ... as I said, I can set up a complete app myself, but it would be a whole lot better and quicker to get done if there was something already done, or even someone else's app I could pick ideas from. Cheers, Mike Kear Windsor, NSW, Australia AFP Webworks. ~~ 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 substring?
Go for you life Philip! I agree whole heartedly with your approach, I had to ask someone to "leave" when after two weeks of "coding" for us, someone noticed he was simply creating folders within folders and moving files in and out of them... Another thing folks should use is the Ben Forta Bible, both Old and New testaments (blue and green, simple and advanced), take it home, sleep with it as a pillow and try to absorb the information while they sleep! James -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 10:39 To: CF-Talk Subject: RE: CF substring? Who says he's a professional developer, or that anyone even pays him to write code? Damned glad to see you'd know how to handle the situation, though. It's still easier to look into documentation for something that simple than to ask a list which can take 5-10 minutes (at a minimum to respond) We have actually got rid of a developer who never looked in books or on-line documentation and asked for help about everything A typical question was "How do I change the background color on a page?" when they were meant to know HTML I can understand asking questions which aren't readily available in the documentation within a few minutes of searching, but asking questions like this is just plain lazy Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
Browsing in the browser
Does anyone know of a good applet/script that would allow me to browse for a local file then use that file as a MIME attachment using CFMAIL? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ~~ 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 substring?
I agree..it's much better to find out for yourself by looking in books/ help files, etcif you have no joy then ask fellow developers. However... I think that we may be being a bit harsh - As Jim says we don't know how good people are who post questions here. We also don't know how much time he has spent looking for the answer (all be it in the wrong places). What seems obvious to some of us may seem impossible to others. I know that as a SQL programmer a lot of the SQL questions I get asked by CF developers (and see on this forum!) are trivial but I answer them all the same (and basic SQL knowledge is, or should be, a requirement for CF developers) as should anyone who knows the answer as one day we'll be asking questions that are trivial to others and I'd want them answering! I also think that the prospect of giving someone a written warning for asking trivial questions is entering a whole world of pain.but good luck to you! Andy -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 10:39 To: CF-Talk Subject: RE: CF substring? Who says he's a professional developer, or that anyone even pays him to write code? Damned glad to see you'd know how to handle the situation, though. It's still easier to look into documentation for something that simple than to ask a list which can take 5-10 minutes (at a minimum to respond) We have actually got rid of a developer who never looked in books or on-line documentation and asked for help about everything A typical question was "How do I change the background color on a page?" when they were meant to know HTML I can understand asking questions which aren't readily available in the documentation within a few minutes of searching, but asking questions like this is just plain lazy Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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 substring?
I agree..it's much better to find out for yourself by looking in books/ help files, etcif you have no joy then ask fellow developers. True - people learn by doing things themselves - anyone who learns by parrot fashion just isn't learning (IMO)... I think that we may be being a bit harsh - As Jim says we don't know how good people are who post questions here. We also don't know how much time he has spent looking for the answer (all be it in the wrong places). What seems obvious to some of us may seem impossible to others. I know that as a SQL programmer a lot of the SQL questions I get asked by CF developers (and see on this forum!) are trivial but I answer them all the same (and basic SQL knowledge is, or should be, a requirement for CF developers) as should anyone who knows the answer as one day we'll be asking questions that are trivial to others and I'd want them answering! Very true, the reason why some of us are here is to help others - but that question was on a par with "How do I select all rows from a table?" It wasn't just trivial, it was basic... I also think that the prospect of giving someone a written warning for asking trivial questions is entering a whole world of pain.but good luck to you! We actually gave someone a verbal warning a week or so ago because they weren't bothing to use on-line references or books and just asking everyone else around them (thus wasting the other person's time) - they now are the most attentive mailing list reader for Generator, which is their current task As I put on my original message, it wasn't exactly difficult to find - I've asked junior developers to do the same while I watch (and time) them - it just proves how easy finding most information is... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Browsing in the browser
Does anyone know of a good applet/script that would allow me to browse for a local file then use that file as a MIME attachment using CFMAIL? You can do it via HTML forms form action="myPage.cfm" method="post" ENCTYPE="multipart/form-data" input type="file" name="myFile" input type="submit" /form Then CFFile Action="Upload" to put the file where you want Watch out though as NT file system isn't immediate - if you try to use the file as soon as you've CFFile'd it, it probably won't be there yet - it can take several seconds before NT makes it "visible" Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Browsing in the browser
Thanks Philip, but I need to actually attach the file to an CF generated e-mail, it's to enable users to attach error messages or screen prints as an attachment. It's to form part of a web based problem logging interface with Tivoli Problem Management. Tivoli requires the document attached to an SMTP mail. Clients may be located in a physical location where they have e-mail connectivity but not access to the Tivoli server for dumping files on. I've tried adapting the applet which CF administrator uses to browse for datasources but it only browses the server and not the clients PC. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 11:31 To: CF-Talk Subject: RE: Browsing in the browser Does anyone know of a good applet/script that would allow me to browse for a local file then use that file as a MIME attachment using CFMAIL? You can do it via HTML forms form action="myPage.cfm" method="post" ENCTYPE="multipart/form-data" input type="file" name="myFile" input type="submit" /form Then CFFile Action="Upload" to put the file where you want Watch out though as NT file system isn't immediate - if you try to use the file as soon as you've CFFile'd it, it probably won't be there yet - it can take several seconds before NT makes it "visible" Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Browsing in the browser
Actually, I think I can use your code to get what I'm after, Ignore the burble below. Thanks for your help! -Original Message- From: Wilson, Craig [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 11:47 To: CF-Talk Subject: RE: Browsing in the browser Thanks Philip, but I need to actually attach the file to an CF generated e-mail, it's to enable users to attach error messages or screen prints as an attachment. It's to form part of a web based problem logging interface with Tivoli Problem Management. Tivoli requires the document attached to an SMTP mail. Clients may be located in a physical location where they have e-mail connectivity but not access to the Tivoli server for dumping files on. I've tried adapting the applet which CF administrator uses to browse for datasources but it only browses the server and not the clients PC. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 11:31 To: CF-Talk Subject: RE: Browsing in the browser Does anyone know of a good applet/script that would allow me to browse for a local file then use that file as a MIME attachment using CFMAIL? You can do it via HTML forms form action="myPage.cfm" method="post" ENCTYPE="multipart/form-data" input type="file" name="myFile" input type="submit" /form Then CFFile Action="Upload" to put the file where you want Watch out though as NT file system isn't immediate - if you try to use the file as soon as you've CFFile'd it, it probably won't be there yet - it can take several seconds before NT makes it "visible" Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Accessing field names dynamically
To which you could add: cfoutput cfloop list="#queryname.columnlist#" index="fieldname" trtd#fieldname#:/td td#evaluate('queryname.#fieldname#')#/td/tr /cfloop /cfoutput This does it for me cfloop list="#queryname.columnlist#" index="fieldname" tdcfoutput#fieldname#/cfoutput/td /cfloop Nick -Original Message- From: Lockie Martin [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 2:36 AM To: CF-Talk Subject: Accessing field names dynamically This question comes into the category of I've seen it somewhere! I have a crosstab query in Access and as you will be aware the column headings in that kind of query come from the data and of course will be variable in name and number. Is there any way of accessing the field names for the columns from the query. Perhaps looping through them to present them on the screen. I know I have seen it somewhere! Thanks in advance --- Lockie Martin [EMAIL PROTECTED] http://www.keystone-solutions.com/ http://marquee/ http://www.keystone-support.net PER [EMAIL PROTECTED] MSN [EMAIL PROTECTED] ICQ 19741013 +64-9-357 0408 x339 (work) +64-2-174 3910 (cell) +64-9-357 0414 (work fax) ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: parsing form submission into an html file?
Have yout ried one of the spiffy HTML WYSIWYG controls? They take the text people enter and convert it to HTML code, and then store it in a database table etc. via a standard cf variable. You can take that variable and do whatever you want with it. An example is here www.carigamer.com/default.cfm?page=news/submitnews.cfm The one I'm using on that page is a free LITE version from www.iautomated.com There are several others with different functionalities and price points. THis particular version only works in IE5.0 and up unfortunately. But over 90% of the vistiors to my website use IE 5 and up so I'll keep it there for now :) If you use a different browser you'll see a plain vanilla Textarea -Gel -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] does anyone know of a way to create an html file from a form submission, or to insert the form fields into a template and save the result as an html file? I can't find anything on the net, and cffile seems to not be what I need. - -- Jon Tillman http://www.eruditum.org finger [EMAIL PROTECTED] to annoy the MPAA ~~ 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
CFHTTP and creating csv recordset problems...
Not a problem I have had as yet... There is a documented feature of CFHTTP that allows you to load up a comma-delimited file into memory via CFHTTP. This is useful if (and this is the case) you can't use CFFile to load up a comma-delimited file (CFX_File has a max size of 64KB for a read) and you can't set up a csv datasource in the CF Administrator. Using CFHTTP you can load up a comma-delimited file into a recordset like this: cfhttp url="http://www.myurl.com/mytextfile.csv" method="GET" name="data" columns="title,keywords,mytext,x" /cfhttp and this then loads the cfhttp.filecontent as a query, and you can reference that query via: cfoutput cfquery name="data" b#title#/bbr#keywords#br#mytext# /cfquery /cfoutput "Hooray" you might think! This means that if someone disables the CFFile tag, you can still load up data from a comma-delimited list! Problem: The documentation says that if you don't specify the columns, CF ignores the first line of the page and uses those values as the column names. I run this with column names, and it ignores the first line anwyay and just goes to the second line. It also seems to ignore the last line. I have tried several things like adding a line break and/or carriage return at the start and end. I have tried testing on just one record... It seems to think that the first line has the wrong number of comma-delimited fields and so it won't put it into the recordset. However, I have checked the missing records, and they have the same number of fields as every other one (it's a database export - from a database I don't have any access to, so I need an export - so it should do!). If you've got this far, then you've done well. If you can think of anything else then please tell me. If you know of any problems, then let me know! Paul Paul Johnston PJ Net Solutions Ltd E: [EMAIL PROTECTED] M: 07866 573013 ~~ 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
input type=file
After using the following code to browse for a file (thanks Philip), form action="myPage.cfm" method="post" ENCTYPE="multipart/form-data" input type="file" name="myFile" input type="submit" /form I want to use the variable #FORM.MYFILE# to form part of a CFMAIL command using mimeattach : cfmail to="smtp.address" subject="Submit Problem" mimeattach="#form.myfile#" from="#client.mailbox#"In #form.field1#, #form.field2#/cfmail For some reason (in my example I used a text file), it renders the contents of the text document on the action page in full and doesn't interpret the file name as a string which is what I would hope it would do. Can anyone help? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ~~ 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 think you need to use: mimeattach="'#form.myfile#'" That should work. Martin. - LEGAL DISCLAIMER -- This message and any attachments to it is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorised use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by its intended recipient is strictly prohibited by the sender. If you have received it in error, please return it to the sender and destroy the message and/or copies in your possession. The views or opinions expressed in this email are that of the individual and not necessarily those of A.B.C (Systems and Development) Limited or any of it's subsidiaries. -Original Message- From: Wilson, Craig [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 12:55 To: CF-Talk Subject: input type="file" After using the following code to browse for a file (thanks Philip), form action="myPage.cfm" method="post" ENCTYPE="multipart/form-data" input type="file" name="myFile" input type="submit" /form I want to use the variable #FORM.MYFILE# to form part of a CFMAIL command using mimeattach : cfmail to="smtp.address" subject="Submit Problem" mimeattach="#form.myfile#" from="#client.mailbox#"In #form.field1#, #form.field2#/cfmail For some reason (in my example I used a text file), it renders the contents of the text document on the action page in full and doesn't interpret the file name as a string which is what I would hope it would do. Can anyone help? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ~~ 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
You need to first use the CFFILE tag to save the file to disk, before you can attach it to an email message. DC - Original Message - From: "Wilson, Craig" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 07:55 Subject: input type="file" After using the following code to browse for a file (thanks Philip), form action="myPage.cfm" method="post" ENCTYPE="multipart/form-data" input type="file" name="myFile" input type="submit" /form I want to use the variable #FORM.MYFILE# to form part of a CFMAIL command using mimeattach : cfmail to="smtp.address" subject="Submit Problem" mimeattach="#form.myfile#" from="#client.mailbox#"In #form.field1#, #form.field2#/cfmail For some reason (in my example I used a text file), it renders the contents of the text document on the action page in full and doesn't interpret the file name as a string which is what I would hope it would do. Can anyone help? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ~~ 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: Is Web Printing Without margin header and footer possible?? (Urge nt)
Perhaps the easier, but more time consuming, method would be to include a 'print' button which then prints a formatted .txt or .pdf file of the same content on the page. I know you can do this via Flash with ActionScript. Not a terribly elegant concept, I know, but hey, it would work with near 100% cross-browser compatibility. Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 www.OFAH.org i need to handle a lot of web printing, printing of many different forms for company use. Are there any ways whereby i can create a print button, after user trigger the print button, it will print the html document but it will not print the margin header and footer such as the web url, page no etc. I do not want any of those to be printed. But how should i do it ?? Currently i am using Script X. It will handle the printing part , without printing the margin headers and footers. But Script X does not seem to work on Japanese Version OS. Does anyone know how to resolve this ??? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
browsing directories on client
I am building a little program which will browse a novel directory which is mapped to all network computers as drive l: in an Win NT environment. I would like to be able to browse the clients files - allowing them to open files and navigate the directory structure. Can this be done? -- Gavin Lilley Internet / Intranet Developer http://halesowen.ac.uk ~~ 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: browsing directories on client
Like this for instance ? (URL.path must start and end with '\'). cfset docroot="e:\wibble" CFDIRECTORY DIRECTORY="#DocRoot##URL.path#" NAME="dir" table CFoutput QUERY="dir" cfif #dir.Type# is "Dir" cfif #dir.Name# is "." cfelseif #dir.Name# is ".." cfelse tr tda href="fileview.cfm?path=#URL.path##Name#/dept=#dept#"#Name#/a/tdtd width="5"nbsp;/td tdDirectorytd /tr /cfif cfelse tr cfset mysize=Ceiling(Size/1024) tda href="#WwwPath##URL.path##Name#"#Name#/a/tdtd width="5"nbsp;/td td#mysize#k/td /tr /cfif /cfoutput -Original Message- From: Gavin Lilley [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 2:01 PM To: CF-Talk Subject: browsing directories on client I am building a little program which will browse a novel directory which is mapped to all network computers as drive l: in an Win NT environment. I would like to be able to browse the clients files - allowing them to open files and navigate the directory structure. Can this be done? -- Gavin Lilley Internet / Intranet Developer http://halesowen.ac.uk ~~ 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
find and replace
Hi! I'm wondering if there is anyone who can help here. For some strange reason our live server is outputting a dateformat of #dateformat(dt, 'dd/mm/yy')# as 03/09/01 it should be 09/03/01. Our development server on the other hand is outputting correctly 09/03/01. I,ve checked the settings on both servers and I cannot figure out the problem. If anyone has an idea that would be great. Or else is there a way in CF to break it apart after it has been converted to a string, cfset dtAsString = ToString(qry_checkSamplerStatus.dt) and output the individualy. Thanx 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: find and replace
Check where the data goes in... cHANCES ARE ITS NOT BEING STORED IN THE DB PROPERLY... -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:10 To: CF-Talk Subject: find and replace Hi! I'm wondering if there is anyone who can help here. For some strange reason our live server is outputting a dateformat of #dateformat(dt, 'dd/mm/yy')# as 03/09/01 it should be 09/03/01. Our development server on the other hand is outputting correctly 09/03/01. I,ve checked the settings on both servers and I cannot figure out the problem. If anyone has an idea that would be great. Or else is there a way in CF to break it apart after it has been converted to a string, cfset dtAsString = ToString(qry_checkSamplerStatus.dt) and output the individualy. Thanx 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: find and replace
If this is how it is on your live server: #dateformat(dt, 'dd/mm/yy')# as 03/09/01, then the way it is formatting is correct. Change the format to DateFormat(dt,"mm/dd/yy") and it should be correct. Otherwise, I would output your date without formatting and see what it looks like. Then I would play with the formatting to get the desired results. HTH -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: browsing directories on client
I am building a little program which will browse a novel directory which is mapped to all network computers as drive l: in an Win NT environment. I would like to be able to browse the clients files - allowing them to open files and navigate the directory structure. Can this be done? This would have to be done with some sort of client-side technologies like ActiveX CF is server-side and as such (obviously) can't see the client's machine I don't know ActiveX enough, so I can't point you in the right direction... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: find and replace
For some strange reason our live server is outputting a dateformat of #dateformat(dt, 'dd/mm/yy')# as 03/09/01 it should be 09/03/01. Our development server on the other hand is outputting correctly 09/03/01. I,ve checked the settings on both servers and I cannot figure out the problem. If anyone has an idea that would be great. Or else is there a way in CF to break it apart after it has been converted to a string, cfset dtAsString = ToString(qry_checkSamplerStatus.dt) and output the individualy. Check on the nationalisation of the 2 servers - odds on one is in US and one is in UK Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
Sorry Martin, it just renders the output still, but in quotes. -Original Message- From: Martin Sutton Sent: 09 March 2001 13:23 To: CF-Talk Subject: RE: input type="file" I think you need to use: mimeattach="'#form.myfile#'" That should work. Martin. - LEGAL DISCLAIMER -- This message and any attachments to it is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorised use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by its intended recipient is strictly prohibited by the sender. If you have received it in error, please return it to the sender and destroy the message and/or copies in your possession. The views or opinions expressed in this email are that of the individual and not necessarily those of A.B.C (Systems and Development) Limited or any of it's subsidiaries. -Original Message- From: Wilson, Craig [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 12:55 To: CF-Talk Subject: input type="file" After using the following code to browse for a file (thanks Philip), form action="myPage.cfm" method="post" ENCTYPE="multipart/form-data" input type="file" name="myFile" input type="submit" /form I want to use the variable #FORM.MYFILE# to form part of a CFMAIL command using mimeattach : cfmail to="smtp.address" subject="Submit Problem" mimeattach="#form.myfile#" from="#client.mailbox#"In #form.field1#, #form.field2#/cfmail For some reason (in my example I used a text file), it renders the contents of the text document on the action page in full and doesn't interpret the file name as a string which is what I would hope it would do. Can anyone help? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ~~ 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
You have to upload the file first. You can then attach it using CFMAILPARAM FILE="yourfilelocation" - Original Message - From: "Wilson, Craig" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 8:23 AM Subject: RE: input type="file" Sorry Martin, it just renders the output still, but in quotes. -Original Message- From: Martin Sutton Sent: 09 March 2001 13:23 To: CF-Talk Subject: RE: input type="file" I think you need to use: mimeattach="'#form.myfile#'" That should work. Martin. -- -- - LEGAL DISCLAIMER -- This message and any attachments to it is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorised use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by its intended recipient is strictly prohibited by the sender. If you have received it in error, please return it to the sender and destroy the message and/or copies in your possession. The views or opinions expressed in this email are that of the individual and not necessarily those of A.B.C (Systems and Development) Limited or any of it's subsidiaries. -Original Message- From: Wilson, Craig [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 12:55 To: CF-Talk Subject: input type="file" After using the following code to browse for a file (thanks Philip), form action="myPage.cfm" method="post" ENCTYPE="multipart/form-data" input type="file" name="myFile" input type="submit" /form I want to use the variable #FORM.MYFILE# to form part of a CFMAIL command using mimeattach : cfmail to="smtp.address" subject="Submit Problem" mimeattach="#form.myfile#" from="#client.mailbox#"In #form.field1#, #form.field2#/cfmail For some reason (in my example I used a text file), it renders the contents of the text document on the action page in full and doesn't interpret the file name as a string which is what I would hope it would do. Can anyone help? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ~~ 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
If you want to capture the name of the file in an input type="file", you have to write a javascript event that fires on the input field... copying the filename to a hidden field. This *can* happen before you perform the upload. I do not know if you will ultimately be able to do the cfmail mime-attach, though. You might have to do the upload first. Here's an example: function copy2hidden(filefield) { //filefield parameter is the file html element if (filefield.value.length != 0) { // filefiled must have content //alert(filefield.value) document.forms["uploadfile_pickfile"].fullfilename.value = filefield.value; // set hidden field with name of file //alert(document.forms["uploadfile_pickfile"].fullfilename.value) } } form name="uploadfile_pickfile" action="..." method="post" input type="file" name="file" value="" onClick="loadfilelist(destination.value)" readonly="1" /form |-Original Message- |From: Wilson, Craig [mailto:[EMAIL PROTECTED]] |Sent: Friday, March 09, 2001 7:55 AM |To: CF-Talk |Subject: input type="file" | | |After using the following code to browse for a file (thanks Philip), | |form action="myPage.cfm" method="post" ENCTYPE="multipart/form-data" |input type="file" name="myFile" |input type="submit" |/form | |I want to use the variable #FORM.MYFILE# to form part of a |CFMAIL command |using mimeattach : | |cfmailto="smtp.address" | subject="Submit Problem" | mimeattach="#form.myfile#" | from="#client.mailbox#"In #form.field1#, |#form.field2#/cfmail | | |For some reason (in my example I used a text file), it renders |the contents |of the text document on the action page in full and doesn't |interpret the |file name as a string which is what I would hope it would do. | |Can anyone help? | | | | |*** |*** | |The opinions expressed in this E-mail are those of the |individual and |not necessarily the company. This E-mail and any files |transmitted |with it are confidential and solely for the use of the |intended recipients | |*** |*** | | ~~ 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: find and replace
UK In the uk we present dates as d/m/y - (which makes sense, as it goes from least significant to most significant) rather than US which goes Medium, Small, Large (m/d/y) for some unexplicable and confusing reason (at least to all UK residents...) -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:18 To: CF-Talk Subject: Re: find and replace If this is how it is on your live server: #dateformat(dt, 'dd/mm/yy')# as 03/09/01, then the way it is formatting is correct. Change the format to DateFormat(dt,"mm/dd/yy") and it should be correct. Otherwise, I would output your date without formatting and see what it looks like. Then I would play with the formatting to get the desired results. HTH -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: find and replace
Yes - probably - I think the error is that that createdate()(or similar) is not being used when inputing to the database - the output as shown will output correctly regardless of server locale... -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:21 To: CF-Talk Subject: RE: find and replace For some strange reason our live server is outputting a dateformat of #dateformat(dt, 'dd/mm/yy')# as 03/09/01 it should be 09/03/01. Our development server on the other hand is outputting correctly 09/03/01. I,ve checked the settings on both servers and I cannot figure out the problem. If anyone has an idea that would be great. Or else is there a way in CF to break it apart after it has been converted to a string, cfset dtAsString = ToString(qry_checkSamplerStatus.dt) and output the individualy. Check on the nationalisation of the 2 servers - odds on one is in US and one is in UK Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
Buffersize
Does anyone know if CF has a function such as BufferSize in the Admin or anywhere so when CF Server begins to fill up the buffer's memory that we can Halt the process and throw an exception error. I know on a Query you can set MaxRows but the client chooses not to go that route but to see if CF has the BufferSize function such as PERL and stuff. Thanks! ~~ 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
dynamic query construction
I am building an application that will allow an end-viewer to search a staff directory based upon either partial or full last name (a text field), or department (a dynamically populated select menu). I am trying to initiate and post the results of this dynamic query using end-viewer input from a form that exists on the same page as the query. Though new to ColdFusion, I believe I am close to having the query constructed properly. In fact, I don't get an error message when running the page (http://134.29.247.12/facultyStaffDirectory/index.cfm) AND performing a SEARCH. Unfortunately, I get no results from the SEARCH either. I am not sure how to re-initiate a query with data from a form that exists on the same page as the query. And I am stumped... all help is very much appreciated. Gary H-S !--- query that dynamically fills select menu with department names --- CFQUERY NAME="qGetDept" DATASOURCE="facultyStaffDirectory" SELECT DepartmentName FROM tblRefDepartments ORDER BY DepartmentName /CFQUERY !---form that allows for search based on partial or full input of lastname, and builds dynamic select menu from results of qGetDept query --- form method="post" action="index.cfm" name="search" table width="640" border="0" cellspacing="0" cellpadding="2" !--- text field that allows for partial or full input of lastname --- tr td width="64"img src="transparent.gif" width="1" height="1"img src="transparent.gif" width="64" height="1" alt=" "/td td width="576" div align="right"font face="Arial, Helvetica, sans-serif" size="2"Search by blast name/b:/font input type="text" name="Lastname" size="25" maxlength="130" input type="submit" name="submit1" value="search" /div /td /tr !--- text field that builds dynamic select menu from results of qGetDept query --- tr td width="64"img src="transparent.gif" width="1" height="1"img src="transparent.gif" width="64" height="1" alt=" "/td td width="576" div align="right"font face="Arial, Helvetica, sans-serif" size="2"Search by bdepartment/program/b:/font select name="DepartmentName" option value="1" SELECTEDchoose.../option cfoutput query="qGetDept" option value="2"#qGetDept.DepartmentName#/option /cfoutput /select input type="submit" name="submit2" value="search" /div /td /tr /table /form br table width="640" border="0" cellspacing="0" cellpadding="1" tr td width="64"img src="transparent.gif" width="64" height="1" alt=" " /td td width="576" table cellpadding="0" cellspacing="0" border="0" width="576" tr bgcolor="#432684" td width="205" height="24"bfont face="Arial" size="2" color="#FF"Name/font/b/td td width="240" height="24"bfont face="Arial" size="2" color="#FF"Title/font/b/td td width="70" height="24"bfont face="Arial" size="2" color="#FF"Phone/font/b/td td width="61" height="24"bfont face="Arial" size="2" color="#FF"Office/font/b/td /tr /table /td /tr /table !--- the query that makes this whole page go... in theory, anyway --- CFQUERY NAME="qGetListing" DATASOURCE="facultyStaffDirectory" SELECT Lastname, Firstname, Title, Phone, Location, DepartmentName FROMtblNames WHERE 0 = 0 CFIF IsDefined("FORM.Lastname") CFIF FORM.Lastname IS NOT " " AND Lastname LIKE '#FORM.Lastname#%' /CFIF /CFIF CFIF IsDefined("FORM.DepartmentName") CFIF FORM.DepartmentName IS NOT " " AND DepartmentName = '#FORM.DepartmentName#' /CFIF /CFIF ORDER BY Lastname, Firstname /CFQUERY table width="640" border="0" cellspacing="0" cellpadding="1" tr td width="64"img src="transparent.gif" width="64" height="1" alt=" " /td td width="576" table cellpadding="0" cellspacing="0" border="0" width="576" cfoutput query="qGetListing" tr cfif qGetListing.currentrow mod 2 eq 0 bgcolor="DFDFDF" cfelse bgcolor="FF" /cfif td width="205" height="20"font face="Arial" size="1"#qGetListing.Lastname#, #qGetListing.Firstname#/font/td td width="240" height="20"font face="Arial" size="1"#qGetListing.Title#/font/td td width="70" height="20"font face="Arial" size="1"#qGetListing..Phone#/font/td td width="61" height="20"font face="Arial" size="1"#qGetListing..Location#/font/td /tr /cfoutput /table /td /tr /table br table width="640" border="0" cellspacing="0" cellpadding="0" tr td width="64"img src="transparent.gif" width="1" height="1"img src="transparent.gif" width="64" height="1" alt=" "/td td width="576" font face="Arial, Helvetica, sans-serif" size="1"# of names: cfoutput#qGetListing.RecordCount#/cfoutput/font /td /tr /table ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Combinations (Weekend Recreation)
(25 choose 5) x (20 choose 5) x (15 choose 5) x (10 choose 5) / 5! ways of ordering the piles. = 25!/(5!^6) = 5,194,672,859,376 as a formula n!/(p!(s!^s)) n = number of cards p = number of piles s = number of cards in piles From: [EMAIL PROTECTED] (paul smith) Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: OT: Combinations (Weekend Recreation) Date: Sat, 03 Mar 2001 14:55:27 -0800 I seem to recall a mathematics buff lurks here. I have 25 numbers: 1 thru 25 I want to create 5 GROUPS where each contains 5 SETS of 5 numbers, and where EACH group contains ALL 25 numbers. For example, one such group is; 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 where SET 1 is: 1 2 3 4 5, SET 2 is: 6 7 8 9 10, etc How many GROUPS are there where no 2 numbers are in any SET more than once? What are these GROUPs? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamic query construction
I haven't looked at your code in detail, but as a first step, I would turn on debugging, see exactly what query is being generated by your code and what form values are being returned, and then try running that query directly in your db tool. Actually one issue on my quick scan is: cfoutput query="qGetDept" option value="2"#qGetDept.DepartmentName#/option /cfoutput This form field will only return 1 or 2, which seems like it probably won't match on department name in this code: CFIF FORM.DepartmentName IS NOT " " AND DepartmentName = '#FORM.DepartmentName#' /CFIF -Original Message- From: Gary Hayden-Sofio [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 8:50 AM To: CF-Talk Subject: dynamic query construction I am building an application that will allow an end-viewer to search a staff directory based upon either partial or full last name (a text field), or department (a dynamically populated select menu). I am trying to initiate and post the results of this dynamic query using end-viewer input from a form that exists on the same page as the query. Though new to ColdFusion, I believe I am close to having the query constructed properly. In fact, I don't get an error message when running the page (http://134.29.247.12/facultyStaffDirectory/index.cfm) AND performing a SEARCH. Unfortunately, I get no results from the SEARCH either. I am not sure how to re-initiate a query with data from a form that exists on the same page as the query. And I am stumped... all help is very much appreciated. Gary H-S !--- query that dynamically fills select menu with department names --- CFQUERY NAME="qGetDept" DATASOURCE="facultyStaffDirectory" SELECT DepartmentName FROM tblRefDepartments ORDER BY DepartmentName /CFQUERY !---form that allows for search based on partial or full input of lastname, and builds dynamic select menu from results of qGetDept query --- form method="post" action="index.cfm" name="search" table width="640" border="0" cellspacing="0" cellpadding="2" !--- text field that allows for partial or full input of lastname --- tr td width="64"img src="transparent.gif" width="1" height="1"img src="transparent.gif" width="64" height="1" alt=" "/td td width="576" div align="right"font face="Arial, Helvetica, sans-serif" size="2"Search by blast name/b:/font input type="text" name="Lastname" size="25" maxlength="130" input type="submit" name="submit1" value="search" /div /td /tr !--- text field that builds dynamic select menu from results of qGetDept query --- tr td width="64"img src="transparent.gif" width="1" height="1"img src="transparent.gif" width="64" height="1" alt=" "/td td width="576" div align="right"font face="Arial, Helvetica, sans-serif" size="2"Search by bdepartment/program/b:/font select name="DepartmentName" option value="1" SELECTEDchoose.../option cfoutput query="qGetDept" option value="2"#qGetDept.DepartmentName#/option /cfoutput /select input type="submit" name="submit2" value="search" /div /td /tr /table /form br table width="640" border="0" cellspacing="0" cellpadding="1" tr td width="64"img src="transparent.gif" width="64" height="1" alt=" " /td td width="576" table cellpadding="0" cellspacing="0" border="0" width="576" tr bgcolor="#432684" td width="205" height="24"bfont face="Arial" size="2" color="#FF"Name/font/b/td td width="240" height="24"bfont face="Arial" size="2" color="#FF"Title/font/b/td td width="70" height="24"bfont face="Arial" size="2" color="#FF"Phone/font/b/td td width="61" height="24"bfont face="Arial" size="2" color="#FF"Office/font/b/td /tr /table /td /tr /table !--- the query that makes this whole page go... in theory, anyway --- CFQUERY NAME="qGetListing" DATASOURCE="facultyStaffDirectory" SELECT Lastname, Firstname, Title, Phone, Location, DepartmentName FROMtblNames WHERE 0 = 0 CFIF IsDefined("FORM.Lastname") CFIF FORM.Lastname IS NOT " " AND Lastname LIKE '#FORM.Lastname#%' /CFIF /CFIF CFIF IsDefined("FORM.DepartmentName") CFIF FORM.DepartmentName IS NOT " " AND DepartmentName = '#FORM.DepartmentName#' /CFIF /CFIF ORDER BY Lastname, Firstname /CFQUERY table width="640" border="0" cellspacing="0" cellpadding="1" tr td width="64"img src="transparent.gif" width="64" height="1" alt=" " /td td width="576" table cellpadding="0" cellspacing="0" border="0" width="576" cfoutput query="qGetListing" tr cfif qGetListing.currentrow mod 2 eq 0 bgcolor="DFDFDF" cfelse bgcolor="FF" /cfif td width="205" height="20"font face="Arial" size="1"#qGetListing.Lastname#, #qGetListing.Firstname#/font/td td width="240" height="20"font face="Arial" size="1"#qGetListing.Title#/font/td td width="70" height="20"font face="Arial" size="1"#qGetListing..Phone#/font/td td width="61" height="20"font face="Arial" size="1"#qGetListing..Location#/font/td /tr /cfoutput /table /td /tr /table br table width="640" border="0" cellspacing="0" cellpadding="0" tr td width="64"img src="transparent.gif"
RE: CFObjects vs. FuseBox vs. Good CFML Code and SmartObjects
Thank you for the real world opinions on the fusebox, it does seem to be something worth trying again, but has anybody out there ever used CFObjects and/or SmartObjects? With all this Java hoopla and Object Oriented programming we all like to use, why don't I hear anything about those two CF methods? Perhaps the reason for their relative unpopularity is that CFML is almost as far from an object-oriented language as you can get. If you want object-oriented web development, you'd probably prefer Java. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: find and replace
In the uk we present dates as d/m/y - (which makes sense, as it goes from least significant to most significant) rather than US which goes Medium, Small, Large (m/d/y) for some unexplicable and confusing reason (at least to all UK residents...) Whilst I agree with you in part, I can hear the spears being beaten against the shields already... -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ 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 and highlighting keywords
Goal: To have the Verity search result pages display highlighted search query keywords. Progress: I have set up Verity to search a collection of .cfm content pages, display search results as links, and drill down to the content of the pages. Everything's working great. Next Step: I want to add functionality so that the keywords on the drill-down pages are highlighted in a different color. Initially, I thought about using cfhttp and then doing a ReplaceNoCase on the resulting cfhttp.FileContent structure. But the content files are on my Web server file system so why incur the overhead of cfhttp?. The next thought was to use cffile to load the content .cfm into a variable for the search and replace. I am having trouble getting a .cfm MIME type content page loaded into a variable. The content pages consist of .cfm's because they have server side includes on them. Am I on the right track in trying to load the content page into a variable? Is there another approach? Thanks in advance for any help on this. Paul Paul Fraser Senior Web Designer argir.com technology solutions 612.370.4242 ~~ 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: Protecting an admin page
on 3/8/01 9:47 PM, Hubert Earl at [EMAIL PROTECTED] wrote: I have an admin page which can be accessed thru a login page. However, as it now stands, if someone were to learn bookmark that page, he or she could return to it via the bookmark, rather than via the login page. How can I ensure that someone could only access the admin page via the login page? You can set up a very simple security either using cookies or a session variable after the member successfuly logs in. If everyone has the same password you can have something like this on the page that the login form points to: cfif FORM.Password IS NOT "letMeIn" cflocation url="login.cfm" cfelse cfcookie name="login" value="yes" script window.location = "admin/index.cfm" /cfscript /cfif The reason for the script tag is that you can't set a cookie while you use cflocation. Have the login template and the action template outside the directory where the application.cfm page that will test for the existence of the cookie or session variable otherwise you would get a loop going. In the application.cfm page you can test for the existence of the cookie or session variable and if it does not exist send them back to the login page with cflocation something like: cfif NOT IsDefined("COOKIE.Login") cflocation url="../login.cfm" /cfif You can do the same with a session variable. If you don't want to use the application.cfm page you just have the above cookie test on every page that you want secured. If everyone uses the same password to get in its easy. If different passwords are required you need to set up a database or have a text file that you can look for password matches. Sebastian ~~ 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: cfhttpparam results in a popup window
How is the user activating the search of the other site? If it's a link (or a form post), you can set the target to a new window. In the page that loads in the new window, you could include some javascript like opener.location.href = "successpage.cfm". -Original Message- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 9:11 PM To: CF-Talk Subject: cfhttpparam results in a popup window Here's what I want to do but I'm having no luck doing this. I have a page which searches another website and returns its results in my own website (gotta love that cfhttp) now unfortunately the design for this site (the site I am searching) doesn't fit in my website at all, so I want to return the results in a popup window. This hasn't proven to be easy, in fact after messing with it, I'm pretty much lost. Basically 2 things have to happen. The results are returned in a popup window and then you're taken to a "success" page, or something like a success page (haven't decided on it's content but it's a page none the less) Any solution is appreciated. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to fast big query result on browser
Hi there, I have one problem, I made a select box, the option items come from a query result, due to 20, 000 records, so the browser is very slow for that template, even I already cached query on server. If any one has a good sulotion? thx. ~~ 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 substring?
By the same token, I once worked for a company where the director (manager, whatever I forget his exact title) of the web development department wanted to get rid of someone who wouldn't ask questions. He'd easily spend 6-8 hours on a problem without making any progress or headway. I guess the trick is knowing when to ask questions. At 10:39 AM 03/09/2001 +, you wrote: Who says he's a professional developer, or that anyone even pays him to write code? Damned glad to see you'd know how to handle the situation, though. It's still easier to look into documentation for something that simple than to ask a list which can take 5-10 minutes (at a minimum to respond) We have actually got rid of a developer who never looked in books or on-line documentation and asked for help about everything A typical question was "How do I change the background color on a page?" when they were meant to know HTML I can understand asking questions which aren't readily available in the documentation within a few minutes of searching, but asking questions like this is just plain lazy Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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 and highlighting keywords
There is a cool way to do this very thing using a custom tag called CF_HIGHLIGHT - you can get it from TAGs at dev.allaire or I can send you a copy James -Original Message- From: Paul Fraser [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 15:11 To: CF-Talk Subject: Verity and highlighting keywords Goal: To have the Verity search result pages display highlighted search query keywords. Progress: I have set up Verity to search a collection of .cfm content pages, display search results as links, and drill down to the content of the pages. Everything's working great. Next Step: I want to add functionality so that the keywords on the drill-down pages are highlighted in a different color. Initially, I thought about using cfhttp and then doing a ReplaceNoCase on the resulting cfhttp.FileContent structure. But the content files are on my Web server file system so why incur the overhead of cfhttp?. The next thought was to use cffile to load the content .cfm into a variable for the search and replace. I am having trouble getting a .cfm MIME type content page loaded into a variable. The content pages consist of .cfm's because they have server side includes on them. Am I on the right track in trying to load the content page into a variable? Is there another approach? Thanks in advance for any help on this. Paul Paul Fraser Senior Web Designer argir.com technology solutions 612.370.4242 ~~ 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 substring?
I see where your coming from. I suppose (if the person worked for me) it would have to depend on this persons skillset, and what type of questions they were asking (or not asking). At 11:14 AM 03/09/2001 +, you wrote: I agree..it's much better to find out for yourself by looking in books/ help files, etcif you have no joy then ask fellow developers. However... I think that we may be being a bit harsh - As Jim says we don't know how good people are who post questions here. We also don't know how much time he has spent looking for the answer (all be it in the wrong places). What seems obvious to some of us may seem impossible to others. I know that as a SQL programmer a lot of the SQL questions I get asked by CF developers (and see on this forum!) are trivial but I answer them all the same (and basic SQL knowledge is, or should be, a requirement for CF developers) as should anyone who knows the answer as one day we'll be asking questions that are trivial to others and I'd want them answering! I also think that the prospect of giving someone a written warning for asking trivial questions is entering a whole world of pain.but good luck to you! Andy -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 10:39 To: CF-Talk Subject: RE: CF substring? Who says he's a professional developer, or that anyone even pays him to write code? Damned glad to see you'd know how to handle the situation, though. It's still easier to look into documentation for something that simple than to ask a list which can take 5-10 minutes (at a minimum to respond) We have actually got rid of a developer who never looked in books or on-line documentation and asked for help about everything A typical question was "How do I change the background color on a page?" when they were meant to know HTML I can understand asking questions which aren't readily available in the documentation within a few minutes of searching, but asking questions like this is just plain lazy Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: find and replace
I am doing it like this cfset form.dt=#createDate(displayYear,displayMonth,displayDay)# -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:36 To: CF-Talk Subject: RE: find and replace Yes - probably - I think the error is that that createdate()(or similar) is not being used when inputing to the database - the output as shown will output correctly regardless of server locale... -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:21 To: CF-Talk Subject: RE: find and replace For some strange reason our live server is outputting a dateformat of #dateformat(dt, 'dd/mm/yy')# as 03/09/01 it should be 09/03/01. Our development server on the other hand is outputting correctly 09/03/01. I,ve checked the settings on both servers and I cannot figure out the problem. If anyone has an idea that would be great. Or else is there a way in CF to break it apart after it has been converted to a string, cfset dtAsString = ToString(qry_checkSamplerStatus.dt) and output the individualy. Check on the nationalisation of the 2 servers - odds on one is in US and one is in UK Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to fast big query result on browser
How many options are you putting in your select box? -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 12:30 PM To: CF-Talk Subject: How to fast big query result on browser Hi there, I have one problem, I made a select box, the option items come from a query result, due to 20, 000 records, so the browser is very slow for that template, even I already cached query on server. If any one has a good sulotion? thx. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Combinations (Weekend Recreation)
Nope! This does not consider that no 2 of the 25 numbers are in a SET more than once. This brings the number of cases down substantially. I was surprised that I was able to find only 4 solutions: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 6 11 16 21 2 7 12 17 22 3 8 13 18 23 4 9 14 19 24 5 10 15 20 25 1 7 13 19 25 2 8 14 20 21 3 9 15 16 22 4 10 11 17 23 5 6 12 18 24 1 8 15 17 24 2 9 11 18 25 3 10 12 19 21 4 6 13 20 22 5 7 14 16 23 best, paul At 08:50 AM 3/9/01 -0600, you wrote: (25 choose 5) x (20 choose 5) x (15 choose 5) x (10 choose 5) / 5! ways of ordering the piles. = 25!/(5!^6) = 5,194,672,859,376 as a formula n!/(p!(s!^s)) n = number of cards p = number of piles s = number of cards in piles From: [EMAIL PROTECTED] (paul smith) Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: OT: Combinations (Weekend Recreation) Date: Sat, 03 Mar 2001 14:55:27 -0800 I seem to recall a mathematics buff lurks here. I have 25 numbers: 1 thru 25 I want to create 5 GROUPS where each contains 5 SETS of 5 numbers, and where EACH group contains ALL 25 numbers. For example, one such group is; 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 where SET 1 is: 1 2 3 4 5, SET 2 is: 6 7 8 9 10, etc How many GROUPS are there where no 2 numbers are in any SET more than once? What are these GROUPs? best, paul ~~ 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
Post vs Hyperlink
Is there a disadvantage to using form post over hyperlinks. I am referring to situations where you can just as easily do a hyperlink and pass a value through the url. My mind tells me that having navigation on an entire site will be a slower site. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF substring?
By the same token, I once worked for a company where the director (manager, whatever I forget his exact title) of the web development department wanted to get rid of someone who wouldn't ask questions. He'd easily spend 6-8 hours on a problem without making any progress or headway. I guess the trick is knowing when to ask questions. True - but there's not asking as you're working on something so involving that you're just buried, and not asking as it's too simple a question and you're embarrased Or there's asking as it's too damn complicated or asking because you can't be bothered to look it up... We have people who would rather sort something out themselves as a matter of pride - but usually only on things which are hellishly difficult - if any got stuck and didn't check on some mundane question, then we'd have a go about that... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to fast big query result on browser
I have one problem, I made a select box, the option items come from a query result, due to 20, 000 records, so the browser is very slow for that template, even I already cached query on server. If any one has a good sulotion? Don't do it in one page! Break it into sections and either provide links to those sections or ask one after another Expecting people to find a single entry in 20,000 is nigh on impossible Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: HDD for sale
Can anyone on this list find a use for an IBM Ultrastar 18LZX in their server? Bought as a spare and is no longer needed, brand new, still in box, never used. Spec. 9.17Gb 10,000 rpm Ultra3 (U160) SCSI If anyone wants it mail your offers to me (any serious offer considered). -- James Smith [EMAIL PROTECTED] Brainbench transcript ID: 822462 http://www.brainbench.com/transcript.jsp?pid=822462 ~~ 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
cfencode.exe (CFCrypt utility)
I'm trying to encrypt a CF template by using the cfencode.exe utility originally found in the CFUSION/BIN directory. When I run the utility with what I think is the proper syntax, all I get back is the message telling me what the proper format should be. Help! At command line I run: cfencode template.cfm/v "2" The syntax is supposed to be: cfencode infile [outfile][/r][/q][/h "header info..."]/ v "2" [ ] are optional params and /v "2" is a "mandatory" param indicating the version. Thanks in advance for your assistance. Paul Paul Fraser Senior Web Designer argir.com technology solutions 612.370.4242 ~~ 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: find and replace
Ok if I just output qry_checkSamplerStatus.dt cfoutput query="dt#dt#/cfoutput I get 2001-03-09 00:00:00 If I try cfset condertdt = dateFormat(qry_checkSamplerStatus.dt, ' - - ') I get September - Monday - 2001 cfset dt = dateformat(qry_checkSamplerStatus.dt, ' - - ') I get Monday - September - 2001 or else if I try 2001 - September - Monday -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:33 To: CF-Talk Subject: RE: find and replace UK In the uk we present dates as d/m/y - (which makes sense, as it goes from least significant to most significant) rather than US which goes Medium, Small, Large (m/d/y) for some unexplicable and confusing reason (at least to all UK residents...) -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:18 To: CF-Talk Subject: Re: find and replace If this is how it is on your live server: #dateformat(dt, 'dd/mm/yy')# as 03/09/01, then the way it is formatting is correct. Change the format to DateFormat(dt,"mm/dd/yy") and it should be correct. Otherwise, I would output your date without formatting and see what it looks like. Then I would play with the formatting to get the desired results. HTH -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to fast big query result on browser
about 21,000 options - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 10:32 AM Subject: RE: How to fast big query result on browser How many options are you putting in your select box? -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 12:30 PM To: CF-Talk Subject: How to fast big query result on browser Hi there, I have one problem, I made a select box, the option items come from a query result, due to 20, 000 records, so the browser is very slow for that template, even I already cached query on server. If any one has a good sulotion? thx. ~~ 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 substring?
I see where your coming from. I suppose (if the person worked for me) it would have to depend on this persons skillset, and what type of questions they were asking (or not asking). My complaint was on the level of the question - it takes 30 seconds to look-up the question that was asked... that would just be unacceptable... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: find and replace
Ok this is whats happening, If I try cfoutput query="qry_checkSamplerStatus"#dt#/cfoutput I get dvelopment server 09/03/01 00:00:00 if I try cfset dt = qry_checkSamplerStatus.dt cfset convertdt = dateformat(dt, " - - ") I get Monday - September - 2001 else if I try cfset dt = dateformat(qry_checkSamplerStatus.dt, ' - - ') I get cfoutput#dt#/cfoutput 2001 - September - Monday else if I try cfset dt = dateformat(qry_checkSamplerStatus.dt, ' - - ') cfoutput#dt#/cfoutput Monday - September - 2001 else if I try cfset dt = dateformat(qry_checkSamplerStatus.dt, ' - - ') cfoutput#dt#/cfoutput September - Monday - 2001 weird or what, I am never going to get the correct date unless I do the first option -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:33 To: CF-Talk Subject: RE: find and replace UK In the uk we present dates as d/m/y - (which makes sense, as it goes from least significant to most significant) rather than US which goes Medium, Small, Large (m/d/y) for some unexplicable and confusing reason (at least to all UK residents...) -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:18 To: CF-Talk Subject: Re: find and replace If this is how it is on your live server: #dateformat(dt, 'dd/mm/yy')# as 03/09/01, then the way it is formatting is correct. Change the format to DateFormat(dt,"mm/dd/yy") and it should be correct. Otherwise, I would output your date without formatting and see what it looks like. Then I would play with the formatting to get the desired results. HTH -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Post vs Hyperlink
Is there a disadvantage to using form post over hyperlinks. I am referring to situations where you can just as easily do a hyperlink and pass a value through the url. My mind tells me that having navigation on an entire site will be a slower site. If you're posting on every page there are a few of issues I can see 1) It relies on JavaScript to jump between pages 2) People can't bookmark pages (as it's a form post) 3) Search Engines will just look at the front page and stop Speed is not an issue as they're both HTTP requests Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: cfencode.exe (CFCrypt utility)
In the INFILE attribute you have to supply the path to the file unless you moved the exe to your site directory. -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfencode.exe (CFCrypt utility)
try putting a space between template.cfm and /v -Original Message- From: Paul Fraser [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 15:42 To: CF-Talk Subject: cfencode.exe (CFCrypt utility) I'm trying to encrypt a CF template by using the cfencode.exe utility originally found in the CFUSION/BIN directory. When I run the utility with what I think is the proper syntax, all I get back is the message telling me what the proper format should be. Help! At command line I run: cfencode template.cfm/v "2" The syntax is supposed to be: cfencode infile [outfile][/r][/q][/h "header info..."]/ v "2" [ ] are optional params and /v "2" is a "mandatory" param indicating the version. Thanks in advance for your assistance. Paul Paul Fraser Senior Web Designer argir.com technology solutions 612.370.4242 ~~ 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: cfencode.exe (CFCrypt utility)
You need to do the following: have template.cfm in the same folder as cfencode then write: cfencode template.cfm /v "2" With the spaces James (this will overwrite the original file) -Original Message- From: Paul Fraser [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 15:42 To: CF-Talk Subject: cfencode.exe (CFCrypt utility) I'm trying to encrypt a CF template by using the cfencode.exe utility originally found in the CFUSION/BIN directory. When I run the utility with what I think is the proper syntax, all I get back is the message telling me what the proper format should be. Help! At command line I run: cfencode template.cfm/v "2" The syntax is supposed to be: cfencode infile [outfile][/r][/q][/h "header info..."]/ v "2" [ ] are optional params and /v "2" is a "mandatory" param indicating the version. Thanks in advance for your assistance. Paul Paul Fraser Senior Web Designer argir.com technology solutions 612.370.4242 ~~ 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: cfencode.exe (CFCrypt utility)
I'm trying to encrypt a CF template by using the cfencode.exe utility originally found in the CFUSION/BIN directory. When I run the utility with what I think is the proper syntax, all I get back is the message telling me what the proper format should be. Help! At command line I run: cfencode template.cfm/v "2" The syntax is supposed to be: cfencode infile [outfile][/r][/q][/h "header info..."]/ v "2" [ ] are optional params and /v "2" is a "mandatory" param indicating the version. A couple of things; I always tend to put in an output file - just out of paranoia sake put a space between the .cfm and /v - it's minor, but it may make a difference Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to fast big query result on browser
George, How is anyone going to use a select box with 21,000 options? Don't you think that's too many for someone to look through when making a selection in a select box? You should try getting some parameters from the user first and pass those to the query so you don't have so many options in one box. Have them enter the category, or maybe some sort of alphabetical search, but do something that will narrow down the query results. IMHO, you would never want to have more than 500 options in a select box (as an absolute limit). Jason Jason Aden Allaire Certified Developer [EMAIL PROTECTED] www.wwstudios.com -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 1:52 PM To: CF-Talk Subject: Re: How to fast big query result on browser about 21,000 options - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 10:32 AM Subject: RE: How to fast big query result on browser How many options are you putting in your select box? -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 12:30 PM To: CF-Talk Subject: How to fast big query result on browser Hi there, I have one problem, I made a select box, the option items come from a query result, due to 20, 000 records, so the browser is very slow for that template, even I already cached query on server. If any one has a good sulotion? thx. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to fast big query result on browser
DONT... good god man, 21 thousand options... you should really find a way of breaking that down... 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: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 1:52 PM To: CF-Talk Subject: Re: How to fast big query result on browser about 21,000 options - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 10:32 AM Subject: RE: How to fast big query result on browser How many options are you putting in your select box? -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 12:30 PM To: CF-Talk Subject: How to fast big query result on browser Hi there, I have one problem, I made a select box, the option items come from a query result, due to 20, 000 records, so the browser is very slow for that template, even I already cached query on server. If any one has a good sulotion? thx. ~~ 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: cfencode.exe (CFCrypt utility)
You have to use an absolute path to the template... c:/cfusion/bin/cfencode.exe c:/inetpub/wwwroot/site/template.cfm /v "2" Hope that helps, Robert -Original Message- From: Paul Fraser [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 9:42 AM To: CF-Talk Subject: cfencode.exe (CFCrypt utility) I'm trying to encrypt a CF template by using the cfencode.exe utility originally found in the CFUSION/BIN directory. When I run the utility with what I think is the proper syntax, all I get back is the message telling me what the proper format should be. Help! At command line I run: cfencode template.cfm/v "2" The syntax is supposed to be: cfencode infile [outfile][/r][/q][/h "header info..."]/ v "2" [ ] are optional params and /v "2" is a "mandatory" param indicating the version. Thanks in advance for your assistance. Paul Paul Fraser Senior Web Designer argir.com technology solutions 612.370.4242 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to fast big query result on browser
That's just too many to ask someone to sort through even it it was hellishly slow to load in a browser. I think the best solution is to drill down to the chosen selection from a smaller number of options in a prior form... about 21,000 options - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 10:32 AM Subject: RE: How to fast big query result on browser How many options are you putting in your select box? -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 12:30 PM To: CF-Talk Subject: How to fast big query result on browser Hi there, I have one problem, I made a select box, the option items come from a query result, due to 20, 000 records, so the browser is very slow for that template, even I already cached query on server. If any one has a good sulotion? thx. ~~ 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: Post vs Hyperlink
Is there a disadvantage to using form post over hyperlinks. I am referring to situations where you can just as easily do a hyperlink and pass a value through the url. My mind tells me that having navigation on an entire site will be a slower site. Never done any testing, but I very much doubt if there would be any difference in the speed of navigation. The browser will make a request that is processed by the server and display the page that's returned, whether you're posting form variables or clicking on a hyperlink. The server doesn't care if it sees any variables passed to it as form. scoped or url. scoped. However, I would have thought it would be quicker to code URL query strings in your .cfm templates than several lines of hidden form inputs each time. Plus closing FORM tags create a small area of whitespace beneath them. That could mess up your front-end design. On the whole, for navigation, use hyperlinks. Use forms when you're requesting information from the user and for "Click here to pay for your goods" type links. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ 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: find and replace
your date (09/03/01) is in fact september 3 2001. So you can format it the way you want, you will always get september 3rd 2001. If you want today's date... you need to have 03/09/2001 in your database. If you want a european date format, you will then have to reformat it using #DateFormat(dt,'dd/mm/yy')# You are inserting the wrong date in your database. If this is a user entry field, you can either use a CFINPUT and validate a eurodate, or you will have to reconstruct the date element before doing your insert. O- - Original Message - From: "John McCosker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 11:00 AM Subject: RE: find and replace Ok this is whats happening, If I try cfoutput query="qry_checkSamplerStatus"#dt#/cfoutput I get dvelopment server 09/03/01 00:00:00 if I try cfset dt = qry_checkSamplerStatus.dt cfset convertdt = dateformat(dt, " - - ") I get Monday - September - 2001 else if I try cfset dt = dateformat(qry_checkSamplerStatus.dt, ' - - ') I get cfoutput#dt#/cfoutput 2001 - September - Monday else if I try cfset dt = dateformat(qry_checkSamplerStatus.dt, ' - - ') cfoutput#dt#/cfoutput Monday - September - 2001 else if I try cfset dt = dateformat(qry_checkSamplerStatus.dt, ' - - ') cfoutput#dt#/cfoutput September - Monday - 2001 weird or what, I am never going to get the correct date unless I do the first option -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:33 To: CF-Talk Subject: RE: find and replace UK In the uk we present dates as d/m/y - (which makes sense, as it goes from least significant to most significant) rather than US which goes Medium, Small, Large (m/d/y) for some unexplicable and confusing reason (at least to all UK residents...) -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:18 To: CF-Talk Subject: Re: find and replace If this is how it is on your live server: #dateformat(dt, 'dd/mm/yy')# as 03/09/01, then the way it is formatting is correct. Change the format to DateFormat(dt,"mm/dd/yy") and it should be correct. Otherwise, I would output your date without formatting and see what it looks like. Then I would play with the formatting to get the desired results. HTH -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Dreamweaver UltraDev 4
I am reading the white paper on Dreamweaver UltraDev 4. So far, so good I like what I am reading. Are there any pitfalls that I shold be aware of if I decide to purchase this package? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Intellectual Property Agreement
Does anyone out there have an example of a one page "intellectual property" agreement that you use with clients? I had one, but I lost my hard drive and found that I no longer had a hard copy of it, so I need to come up with a new one. Thanks, Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to fast big query result on browser
I agree with Jason. I think many users would walk away from a site that asked them to use a selectbox with 21k items in it. Just think how long that would take just to read each option Crikey!! Are there any relationships with any other data? One thing to try if it's feasible is group the 21k items to another group of items, sort of like: Project Module Module Module Module Module Project Module Module etc... That way the user first selects a "Project" which then limits the next selectbox to just those items that belong under that particular project. I don't know if your data is or can be arranged like that but it's one idea. If so there is a handy tag, I've used a few times in the DevEx. called TwoSelectsRelated.. Very handy. J. John Wilker Web Applications Consultant Allaire Certified ColdFusion Developer Office: 909-943-8428 www.billtracker.org http://www.billtracker.org -Original Message- From: Jason Aden [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 8:16 AM To: CF-Talk Subject: RE: How to fast big query result on browser George, How is anyone going to use a select box with 21,000 options? Don't you think that's too many for someone to look through when making a selection in a select box? You should try getting some parameters from the user first and pass those to the query so you don't have so many options in one box. Have them enter the category, or maybe some sort of alphabetical search, but do something that will narrow down the query results. IMHO, you would never want to have more than 500 options in a select box (as an absolute limit). Jason Jason Aden Allaire Certified Developer [EMAIL PROTECTED] www.wwstudios.com -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 1:52 PM To: CF-Talk Subject: Re: How to fast big query result on browser about 21,000 options - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 10:32 AM Subject: RE: How to fast big query result on browser How many options are you putting in your select box? -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 12:30 PM To: CF-Talk Subject: How to fast big query result on browser Hi there, I have one problem, I made a select box, the option items come from a query result, due to 20, 000 records, so the browser is very slow for that template, even I already cached query on server. If any one has a good sulotion? thx. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL, what am I doing wrong?
Hi All, I am using CF 4.5.1 and can not get CFMAIL to function. I can get a verified connection thru the Admin system but can not get a .cfm file to interact with mail. I continue to get the following error: The tag has an invalid attribute combination: the most likely attribute combination is Required attributes: 'FROM,GROUP,QUERY,SUBJECT,TO'. Optional attributes: 'BCC,CC,GROUPCASESENSITIVE,MAILERID,MAXROWS,MIMEATTACH,PORT,SERVER,STARTROW,TIMEOUT,TYPE'. Other possible combinations are Required attributes: 'FROM,QUERY,SUBJECT,TO'. Optional attributes: 'BCC,CC,MAILERID,MAXROWS,MIMEATTACH,PORT,SERVER,STARTROW,TIMEOUT,TYPE'. Required attributes: 'FROM,GROUP,SUBJECT,TO'. Optional attributes: 'BCC,CC,GROUPCASESENSITIVE,MAILERID,MAXROWS,MIMEATTACH,PORT,SERVER,TIMEOUT,TYPE'. Required attributes: 'FROM,SUBJECT,TO'. Optional attributes: 'BCC,CC,MAILERID,MIMEATTACH,PORT,SERVER,TIMEOUT,TYPE'. The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (9:1) to (9:129). The specific sequence of files included or I have tried everyone of the combinations above with no luck. Has anyone run across this problem? Thanks! BKelly Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Performance Tests
Thanks, but I solved it completely differently by re-coding my original query. I was looping thru the query to run a separate query and sticking the results of the second query in a structure (since I needed a list of associated values for each record in the main query). This was mega-slow, since there are now 850+ records in the main query, which means 850+ small queries. I finally realized I could do the same thing using "order by" and "cfoutput group". I don't know why it took me so long!!! I was banging my head against the wall trying to come up with a clever way to replicate the Sybase LIST() function in MS SQL (which may be impossible given my DB design). Now the big query takes about 200ms longer, but I've cut out about 10 seconds not doing the many small queries. Thanks - Eric -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 1:44 AM To: CF-Talk Subject: RE: Performance Tests So if I need to loop over the contents of one column of a large query, which would be faster: cfloop query="big_query" ...do stuff with #column1#... /cfloop cfloop list="#ValueList(big_query.column1)#" index="i" do stuff with #i#... /cfloop cfset myarray=ListToArray(ValueList(big_query.column1)) cfloop index="i" from="1" to="#ArrayLen(myarray)#" do stuff with myarray[#i#]... /cfloop this needs to be a cfloop since I'm using tags in it. Looping over lists, and list functions are always slower than referring directly to an array or a query There is another alternative; If you're not doing a CFOutput cfscript for (i=1; i lte big_query.recordCount; i=i+1) { do stuff with big_query.Column1[i]; } /cfscript or if you need CFOutput cfloop index="i" from=1 to="#big_query.recordCount#" do stuff with big_query.Column1[i] /cfloop Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: Intellectual Property Agreement
you can buy agreement templates from www.weblaw.co.uk (they're not cheap but it could be worth it in the long run) and i'd also advise having a lawyer check them over when you've finished anyway, very complicated bits of law copyright and intellectual law, especially with the new patent laws in the US and elsewhere Regards Stew -- From: David Hannum Reply To: [EMAIL PROTECTED] Sent: Friday, March 9, 2001 4:30 pm To: CF-Talk Subject: OT: Intellectual Property Agreement Does anyone out there have an example of a one page "intellectual property" agreement that you use with clients? I had one, but I lost my hard drive and found that I no longer had a hard copy of it, so I need to come up with a new one. Thanks, Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Dreamweaver UltraDev 4
Crappy code generationhope you like CFSCRIPT. UD4 uses CFSCRIPT alot. I like CFSCRIPT but for some of the cases the UD4 uses it for I wouldn't. Kevin - Original Message - From: "James Taavon" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 10:43 AM Subject: OT: Dreamweaver UltraDev 4 I am reading the white paper on Dreamweaver UltraDev 4. So far, so good I like what I am reading. Are there any pitfalls that I shold be aware of if I decide to purchase this package? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL, what am I doing wrong?
I've seen it only a hand full of times, on pages I've worked on. I'd try to start with the bare minimum and see if it works then add attributes as you need them. i.e. to, from, subject. If those work then just add what ever else you need and go from there. J. John Wilker Web Applications Consultant Allaire Certified ColdFusion Developer Office: 909-943-8428 www.billtracker.org http://www.billtracker.org -Original Message- From: Bryon Kelly [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 8:53 AM To: CF-Talk Subject: CFMAIL, what am I doing wrong? Hi All, I am using CF 4.5.1 and can not get CFMAIL to function. I can get a verified connection thru the Admin system but can not get a .cfm file to interact with mail. I continue to get the following error: The tag has an invalid attribute combination: the most likely attribute combination is Required attributes: 'FROM,GROUP,QUERY,SUBJECT,TO'. Optional attributes: 'BCC,CC,GROUPCASESENSITIVE,MAILERID,MAXROWS,MIMEATTACH,PORT,SERVER,STARTROW, TIMEOUT,TYPE'. Other possible combinations are Required attributes: 'FROM,QUERY,SUBJECT,TO'. Optional attributes: 'BCC,CC,MAILERID,MAXROWS,MIMEATTACH,PORT,SERVER,STARTROW,TIMEOUT,TYPE'. Required attributes: 'FROM,GROUP,SUBJECT,TO'. Optional attributes: 'BCC,CC,GROUPCASESENSITIVE,MAILERID,MAXROWS,MIMEATTACH,PORT,SERVER,TIMEOUT,T YPE'. Required attributes: 'FROM,SUBJECT,TO'. Optional attributes: 'BCC,CC,MAILERID,MIMEATTACH,PORT,SERVER,TIMEOUT,TYPE'. The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (9:1) to (9:129). The specific sequence of files included or I have tried everyone of the combinations above with no luck. Has anyone run across this problem? Thanks! BKelly 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: Dreamweaver UltraDev 4
You should also look here: http://www.macromedia.com/go/udforcfml There is currently a special promotion. Regards, 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 Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "James Taavon" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 11:43 AM Subject: OT: Dreamweaver UltraDev 4 I am reading the white paper on Dreamweaver UltraDev 4. So far, so good I like what I am reading. Are there any pitfalls that I shold be aware of if I decide to purchase this package? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamic Left-hand side of an assignment? Was: query a query.
Have you tried the SetVariable( name, value ) function? you can either do cfscript SetVariable( "qryGet_current_#param#_values", QueryNew(qryGet_current_NT_values.columnlist) ); /cfscript or cfset dummy = SetVariable( "qryGet_current_#param#_values", QueryNew(qryGet_current_NT_values.columnlist) ) Hope that helps Alistair Davidson Senior Developer Rocom New Media www.rocomx.net -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 17:04 To: CF-Talk Subject: Dynamic Left-hand side of an assignment? Was: query a query. OK, that's what I've tried but now I'm having problems with creating the query name on the fly and making assignments to it. I get an error about left-hand side assignment when I try something like this: cfset "qryGet_current_" param "_values" = QueryNew(qryGet_current_NT_values.columnlist) or cfset qryGet_current_#param#_values = QueryNew(qryGet_current_NT_values.columnlist) I tried using evaluate but you can't use function calls on the LHS of an assignment. Is it possible to refer to the LHS of an assignment dynamically? Thanks, Kevin For anyone who's curious I ended up with code that will look something like !--- Test for the existence of a row that contains a parameter in the list --- cfloop index="param" list="#param_list#" !--- Loop through each row in the query --- cfoutput query="qryGet_current_NT_values" cfif qryGet_current_NT_values.parametername EQ param !--- If cfif NOT IsDefined("qryGet_current_#param#_values") cfset strQueryName="qryGet_current_#param#_values" cfset "qryGet_current_" param "_values" = QueryNew(qryGet_current_NT_values.columnlist) /cfif !--- make some rows in the query --- CFSET newRow = QueryAddRow(MyQuery, qryGet_current_NT_values.RecordCount) !--- set the cells in the query --- CFSET temp = QuerySetCell(evaluate("strQueryName"), "parametername", qryGet_current_NT_values.parametername) CFSET temp = QuerySetCell(evaluate("strQueryName"), "instance", qryGet_current_NT_values.instance) CFSET temp = QuerySetCell(evaluate("strQueryName"), "severity", qryGet_current_NT_values.severity) /cfif /cfoutput /cfloop -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 5:57 PM To: CF-Talk Subject: RE: Anyone know of a custom tag to query a query ? I don't know of a custom tag, but if you use Query functions, you can fake it. Use QueryNew(myCFQUERY.columnlist) to create a new query object. Then iterate through your CFQUERY and check for whichever values you want. You can get clever by using valueList on your CFQUERY object to create lookup lists; you could then get a listposition from the lookup list, and use that as the startRow attribute for a CFOUTPUT of your created query object. grin At least, it sounds like it should work. It's hard to suggest the best solution without knowing the amount of data involved. Dave -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 4:33 PM To: CF-Talk Subject: Anyone know of a custom tag to query a query ? Hi, I know this will be included in CF 5.0 but unfortunately that won't be around soon enough. Before I haul off and try to write something to do this, does anybody know of a custom tag that will query a query? I've browsed through Allaire's tag gallery and while there are a number of tags that will manipulate queries there's nothing that gets a subset of data from an existing query. I'd written a lot code that performed lots of small single queries which made the data more accessible to me in terms of variable granularity, i.e. one query name per small query but due to bad performance our DBA recommended that I reduce the number of queries by being less specific and parse the data on the CF side. Thanks, Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL, what am I doing wrong?
Show us the code Regards, 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 Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Bryon Kelly" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 11:52 AM Subject: CFMAIL, what am I doing wrong? Hi All, I am using CF 4.5.1 and can not get CFMAIL to function. I can get a verified connection thru the Admin system but can not get a .cfm file to interact with mail. I continue to get the following error: CFSNIP I have tried everyone of the combinations above with no luck. Has anyone run across this problem? Thanks! BKelly 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: Dynamic Left-hand side of an assignment? Was: query a query.
I just checked the archives and came across what I now call the "setvariable debate". That really turned into a whopper of a philospical thread (literally). Thanks, Kevin -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 12:04 PM To: CF-Talk Subject: Dynamic Left-hand side of an assignment? Was: query a query. OK, that's what I've tried but now I'm having problems with creating the query name on the fly and making assignments to it. I get an error about left-hand side assignment when I try something like this: cfset "qryGet_current_" param "_values" = QueryNew(qryGet_current_NT_values.columnlist) or cfset qryGet_current_#param#_values = QueryNew(qryGet_current_NT_values.columnlist) I tried using evaluate but you can't use function calls on the LHS of an assignment. Is it possible to refer to the LHS of an assignment dynamically? Thanks, Kevin For anyone who's curious I ended up with code that will look something like !--- Test for the existence of a row that contains a parameter in the list --- cfloop index="param" list="#param_list#" !--- Loop through each row in the query --- cfoutput query="qryGet_current_NT_values" cfif qryGet_current_NT_values.parametername EQ param !--- If cfif NOT IsDefined("qryGet_current_#param#_values") cfset strQueryName="qryGet_current_#param#_values" cfset "qryGet_current_" param "_values" = QueryNew(qryGet_current_NT_values.columnlist) /cfif !--- make some rows in the query --- CFSET newRow = QueryAddRow(MyQuery, qryGet_current_NT_values.RecordCount) !--- set the cells in the query --- CFSET temp = QuerySetCell(evaluate("strQueryName"), "parametername", qryGet_current_NT_values.parametername) CFSET temp = QuerySetCell(evaluate("strQueryName"), "instance", qryGet_current_NT_values.instance) CFSET temp = QuerySetCell(evaluate("strQueryName"), "severity", qryGet_current_NT_values.severity) /cfif /cfoutput /cfloop -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 5:57 PM To: CF-Talk Subject: RE: Anyone know of a custom tag to query a query ? I don't know of a custom tag, but if you use Query functions, you can fake it. Use QueryNew(myCFQUERY.columnlist) to create a new query object. Then iterate through your CFQUERY and check for whichever values you want. You can get clever by using valueList on your CFQUERY object to create lookup lists; you could then get a listposition from the lookup list, and use that as the startRow attribute for a CFOUTPUT of your created query object. grin At least, it sounds like it should work. It's hard to suggest the best solution without knowing the amount of data involved. Dave -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 4:33 PM To: CF-Talk Subject: Anyone know of a custom tag to query a query ? Hi, I know this will be included in CF 5.0 but unfortunately that won't be around soon enough. Before I haul off and try to write something to do this, does anybody know of a custom tag that will query a query? I've browsed through Allaire's tag gallery and while there are a number of tags that will manipulate queries there's nothing that gets a subset of data from an existing query. I'd written a lot code that performed lots of small single queries which made the data more accessible to me in terms of variable granularity, i.e. one query name per small query but due to bad performance our DBA recommended that I reduce the number of queries by being less specific and parse the data on the CF side. Thanks, Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL, what am I doing wrong?
Let's see your code! - Original Message - From: "Bryon Kelly" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 10:52 AM Subject: CFMAIL, what am I doing wrong? Hi All, I am using CF 4.5.1 and can not get CFMAIL to function. I can get a verified connection thru the Admin system but can not get a .cfm file to interact with mail. I continue to get the following error: The tag has an invalid attribute combination: the most likely attribute combination is Required attributes: 'FROM,GROUP,QUERY,SUBJECT,TO'. Optional attributes: 'BCC,CC,GROUPCASESENSITIVE,MAILERID,MAXROWS,MIMEATTACH,PORT,SERVER,STARTROW, TIMEOUT,TYPE'. Other possible combinations are Required attributes: 'FROM,QUERY,SUBJECT,TO'. Optional attributes: 'BCC,CC,MAILERID,MAXROWS,MIMEATTACH,PORT,SERVER,STARTROW,TIMEOUT,TYPE'. Required attributes: 'FROM,GROUP,SUBJECT,TO'. Optional attributes: 'BCC,CC,GROUPCASESENSITIVE,MAILERID,MAXROWS,MIMEATTACH,PORT,SERVER,TIMEOUT,T YPE'. Required attributes: 'FROM,SUBJECT,TO'. Optional attributes: 'BCC,CC,MAILERID,MIMEATTACH,PORT,SERVER,TIMEOUT,TYPE'. The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (9:1) to (9:129). The specific sequence of files included or I have tried everyone of the combinations above with no luck. Has anyone run across this problem? Thanks! BKelly 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:OT: Dreamweaver UltraDev 4
Just saw a demo at the ANYCFUG meeting last night. It looks like UltraDev is CF's answer to MS Visual Interdev. It sets up simple database functions (insert, delete, edit, move to first, last, next, prev). Does not, on its own, handle relationships between tables(like the query window in CF) fields. You must do it either in CF or in UD interface window. All background code is visible, simple to follow and annotated. When possible, it uses CFSCRIPT. Has the same type interface as DreamWeaver. Would have to get used to the language and easily relate to the "user friendly" window interface screens (how come I know in my head and hands what to do but can not understand what information these interfaces want for their text fields???) Supposedly UD will import CF apps easily as well as custom tags, etc. Macromedia exhange has extensions - basically code contributed by programmers - to expand UD's versatility. It is not the answer to robust development,but it looks like it can help minimize building simple administrative screens. That's all I know for now. Except that it is currently on sale for under $600. Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:OT: Dreamweaver UltraDev 4 Author: [EMAIL PROTECTED] Date: 3/9/01 11:43 AM I am reading the white paper on Dreamweaver UltraDev 4. So far, so good I like what I am reading. Are there any pitfalls that I shold be aware of if I decide to purchase this package? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to fast big query result on browser
TwoSelectsRelated may get you started, but it is JavaScript - with 21k items, you're going to run into a lot of issues; your HTML file will be huge and the JS is going to pinch a lot of memory and rendering processes for the browser... not going to be a fun UI no matter how you slice it on the client side. I'd consider pagination or providing a drill-down mechanism (if you have relational data as John mentioned) if not a search or index function by the first letter or something... BTW, I'll guarantee that a select or related select with that many options WILL blow up on a sMacintosh. T. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 9:41 AM To: CF-Talk Subject: RE: How to fast big query result on browser I agree with Jason. I think many users would walk away from a site that asked them to use a selectbox with 21k items in it. Just think how long that would take just to read each option Crikey!! Are there any relationships with any other data? One thing to try if it's feasible is group the 21k items to another group of items, sort of like: Project Module Module Module Module Module Project Module Module etc... That way the user first selects a "Project" which then limits the next selectbox to just those items that belong under that particular project. I don't know if your data is or can be arranged like that but it's one idea. If so there is a handy tag, I've used a few times in the DevEx. called TwoSelectsRelated.. Very handy. J. John Wilker Web Applications Consultant Allaire Certified ColdFusion Developer Office: 909-943-8428 www.billtracker.org http://www.billtracker.org -Original Message- From: Jason Aden [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 8:16 AM To: CF-Talk Subject: RE: How to fast big query result on browser George, How is anyone going to use a select box with 21,000 options? Don't you think that's too many for someone to look through when making a selection in a select box? You should try getting some parameters from the user first and pass those to the query so you don't have so many options in one box. Have them enter the category, or maybe some sort of alphabetical search, but do something that will narrow down the query results. IMHO, you would never want to have more than 500 options in a select box (as an absolute limit). Jason Jason Aden Allaire Certified Developer [EMAIL PROTECTED] www.wwstudios.com -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 1:52 PM To: CF-Talk Subject: Re: How to fast big query result on browser about 21,000 options - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 10:32 AM Subject: RE: How to fast big query result on browser How many options are you putting in your select box? -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 12:30 PM To: CF-Talk Subject: How to fast big query result on browser Hi there, I have one problem, I made a select box, the option items come from a query result, due to 20, 000 records, so the browser is very slow for that template, even I already cached query on server. If any one has a good sulotion? thx. ~~ 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: Intellectual Property Agreement
Try www.nolo.com (Good, fast, and inexpensive) best, paul At 05:23 PM 3/9/01 +, you wrote: you can buy agreement templates from www.weblaw.co.uk (they're not cheap but it could be worth it in the long run) and i'd also advise having a lawyer check them over when you've finished anyway, very complicated bits of law copyright and intellectual law, especially with the new patent laws in the US and elsewhere ~~ 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 pre in cfoutput
Hi. I have a memo field in Access which I'm pulling out using cfoutput query="myquery"pre class="bodytext"#newsMessage#/pre/cfoutput It's inside a table, but looks awful as it's not wrapping. I need to use pre because of the linebreaks and spacing in the Memo field - but how can I wrap it normally? Thanks Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.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: CF Application
http://www.surveymill.com/ David Clay wrote: Does anyone know of a software application that was built in CF to conduct surveys online. Your help would be greatly appreciated. Dave Clay Internet Facilitator Trus Joist, A Weyerhaeuser Business 5995 Greenwood Plaza Blvd, Suite 100 Greenwood Village, CO 80111 303.770.8506 303.770.8506 ~~ 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
CF - rs6000 - AS 400
hello all, has anyone any experience with attaching to DB2 on an RS2000 or an as400? I had heard of a product for the AS400, but I can't remember the name. have a good weekend Stew ~~ 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 Application
http://www.activefeedback.com/af/ Todd Ashworth -- Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] - Original Message - From: "David Clay" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 12:40 PM Subject: CF Application | Does anyone know of a software application that was built in CF to conduct surveys online. | | Your help would be greatly appreciated. | | Dave Clay | Internet Facilitator | Trus Joist, A Weyerhaeuser Business | 5995 Greenwood Plaza Blvd, Suite 100 | Greenwood Village, CO 80111 | 303.770.8506 | 303.770.8506 | | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dynamic numberformat and color in cfgrid
I was able to deal with the format from within the SELECT in the cfquery, but still don't know about the dynamic coloring. (I hope I don't have to use swing JTable :-) laszlo Laszlo Nadai wrote: Sorry for the confusing subject, I want to manipulate both the color and the format laszlo Laszlo Nadai wrote: I have a cfgrid on a cfquery. How can I dynamically change let's say the numberformat. In other words, for certain rows I want 2 after decimals, for other ones I want 4. Thanks, laszlo ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using pre in cfoutput
I have a memo field in Access which I'm pulling out using cfoutput query="myquery"pre class="bodytext"#newsMessage#/pre/cfoutput It's inside a table, but looks awful as it's not wrapping. I need to use pre because of the linebreaks and spacing in the Memo field - but how can I wrap it normally? Yeesh - Avoid PRE unless you REALLY want it in that format Form simple carriage return layout either use ParagraphFormat() or (if you're not happy with that) Replace(myField,Chr(13),"br","all") Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
CFCOOKIE
Can you EXPIRE a cookie and SET it again from the same page? Thanks,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: Using pre in cfoutput
Yeesh - Avoid PRE unless you REALLY want it in that format Form simple carriage return layout either use ParagraphFormat() or (if you're not happy with that) Replace(myField,Chr(13),"br","all") Arghprogrammer's block again. Forgot about ParagraphFormat. Cheers, Will ~~ 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 - rs6000 - AS 400
There is a product called screensurfer I think that might work for you. - Original Message - From: "Joshua Tipton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 12:22 PM Subject: RE: CF - rs6000 - AS 400 Client access of as 400?? -Original Message- From: Stewart McGowan [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 1:13 PM To: CF-Talk Subject: CF - rs6000 - AS 400 hello all, has anyone any experience with attaching to DB2 on an RS2000 or an as400? I had heard of a product for the AS400, but I can't remember the name. have a good weekend Stew ~~ 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: Dreamweaver UltraDev 4
James, I think most people who use UD also rely on CF Studio to hand code. The two go well together but you wouldn't want to rely on UD exclusively. I really like UD, but there are a few issues: 1) It's a script based tool. That means that unless you know cfscript it can be very hard to debug the code it generates. 2) In some instances UD can rewrite your CF. For example, UD will move a CFOUTPUT tag out of the Head. 3) UD doesn't always parse CF correctly. For instance, there's an extension at macromedia that lets UD understand CFINCLUDE and show the content on the page while you're working. But if you build a simple CFELSE statement to include a file if it exists, otherwise include a default file, UD won't understand it and will show both files included in design mode. For visually designing relatively simple CF pages though, UD is great. The live data mode lets you see the results of a query on your page while you design it -- I think that makes it worth the price of purchase alone. Post your question to the macromedia.ultradev group and you'll get some responses from people who have spent a bit more time with the issues than I have. Regards, Marc Garrett "James Taavon" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am reading the white paper on Dreamweaver UltraDev 4. So far, so good I like what I am reading. Are there any pitfalls that I shold be aware of if I decide to purchase this package? ~~ 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
Useful tool for looking at code
Web Monkey has reported a very interesting tool called "Code Lifter" that allows you to grab hidden JS, PL and CSS files from a web page. Very useful for bug fixing. http://www.codelifter.com/index.html Dave Adams CFUG Ottawa ~~ 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: CFCOOKIE
Can you EXPIRE a cookie and SET it again from the same page? Remember that CF doesn't send cookie requests to the browser until it's finished (or in CF5, Flushed), so it effectively takes the last setting on the page as the one you want... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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: CFCOOKIE
yep... CFCOOKIE NAME="id" VALUE="" EXPIRES="NOW" CFCOOKIE NAME="id" VALUE="xxx" or this should work too... (i believe) CFSET cookie.id = "" CFSET cookie.id = "xxx" 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: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 1:24 PM To: CF-Talk Subject: CFCOOKIE Can you EXPIRE a cookie and SET it again from the same page? Thanks,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: stored procedure and resultset
David: Did you use that in Oracle before? The reason I asked is that in ColdFusion knowledge base, for article # 8353, it said that --- Oracle stored procedures do not return result sets in the traditional sense. Consequently, it is not possible to generate a query in ColdFusion using an Oracle stored procedure. --- I should do some test, however, I am busying with design spec, just check with you. Thanks. Mei -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 5:42 PM To: CF-Talk Subject: RE: stored procedure and resultset Yes. Look at CFSTOREDPROC and CFPROCRESULT; basically, you include one CFPROCRESULT tag for each result set in the stored procedure. Then you've got named CFQUERY objects you can work with. -Original Message- From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 3:43 PM To: CF-Talk Subject: stored procedure and resultset Can we loop all the recordsets in the stored procedures with CF 4.5 and Oracle 8.1? I have done this with ASP and SQL Server 7.0: E.g. create procedure sp_Money select * from tbl1 where fname = "mei"; select * from tbl2 where targetSalary = "1,000,000"; then, after execute the stored procedure, we can loop it as: objRec = NextRecordset; ( not exactly syntax, but the idea is there...) do while not objRec.eof --- objRec will be all the records return from the first select...; objRec = NextRecordset; --- this time, objRec will be all the records from the second select... CAN we do that? Any information is greatly appreciated. Mei ~~ 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