RE: Select list values
Jerry worked a treat Thanks Mike Peters NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz Mike Try this as your last option: OPTION value= CFIF AppMenuID eq Selected/CFIF[None selected]/OPTION Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com -Original Message- From: Office [mailto:[EMAIL PROTECTED]] Sent: 28 March 2002 22:42 To: CF-Talk Subject: Select list values I'm populating an SQL7 table with possible numeric values AppMenuID using a look up list from a web form. The field can also be left null. It puts the correct value or null into the table but the form dosn't show that null has been selected for the record next time I come back. How do I get this to work. Thanks for any tips Mike Peters NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz SELECT name=AppMenuID size=1 OPTION CFIF AppMenuID IS 1Selected/CFIF value=1Messages/OPTION OPTION CFIF AppMenuID IS 4Selected/CFIF value=4My Groups/OPTION OPTION CFIF AppMenuID IS 2Selected/CFIF value=2Personal/OPTION OPTION CFIF AppMenuID IS 3Selected/CFIF value=3Submit/OPTION OPTION CFIF AppMenuID IS 5Selected/CFIF value=5Tasks/OPTION OPTION CFIF AppMenuID IS NullSelected/CFIF value=[None selected]/OPTION /SELECT -- __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Efficient database inserts
Thanks for the feedback you've confirmed what i thought but i just wanted to get some expert opinions! Kola -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 29 March 2002 07:47 To: CF-Talk Subject: Re: Efficient database inserts Kola Any SP will give you a performance boost, but it will not be that recognizable with something that does not get updated often. It is alot faster to simply have sql save the new info than it is to check what fields to update prior. Rule of thumb is to let your sql backend do its work and not your CF application as sql out-performs CF hands down. Success is a journey, not a destination!! Doug Brown - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 11:27 PM Subject: Efficient database inserts Hi I often have an application which allows a user to edit a record. Even if the user only updates one field all fields are resaved in the database. Its occured to me that this may be inefficient. I wondered if I could store the fields in hidden form fields, check on the update page which fields have changed and only update the fields that have. I also wondered if this would be best done in a stored proc on the datebase side but I imagine that the stored proc would have to call the record, compare the new field values and then update the neccesary field which be more of a performance hit. Does anyone know if this is worth doing or are any performance gains going to be negligble. Also this seems like a feature that databases may already utilise on a low level but i'm not sure. Comments anyone? Thanks KOla __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dynamic queries in stored procedures
Hi Could anyone tell me the best way to execute dynamic queries using stored procedures? Thanks Kola __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Talk-list V1 #224
Thank you for the email. I am out of the office until Monday April 1st. I will receive your email when I return and respond to you at that time. If you have questions while I am out, please feel free to contact Janelle Schneider in our Client Services Department. She can be reached by email at [EMAIL PROTECTED] or by phone at 206-548-9295 x10. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Talk-list V1 #223
Oh no you won't! *baps the colon person with the muffin pan* Oh no you won't! Oh no you won't! *BAP BAP BAP BAP* -Gel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:23 PM To: CF-Talk Subject: RE: CF-Talk-list V1 #223 Thank you for the email. I am out of the office until Monday April 1st. I will receive your email when I return and respond to you at that time. If you have questions while I am out, please feel free to contact Janelle Schneider in our Client Services Department. She can be reached by email at [EMAIL PROTECTED] or by phone at 206-548-9295 x10. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS 5 WWW-Server and writing of logfiles
could you write an isapi filter to do the logging and associate with both websites? I do know that logging functionality is exposed in ISAPI. I'm not sure whether you'd write a filter for that, or an ISAPI extension. 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
calling 5 articles minus the latest one
Hi, I want to call the latest 5 articles minus the latest entry. Here's my code snippet on calling the latest 5 articles. cfquery maxrows=5 datasource=gmu name=mag select id, type, title, snippets, date, url from local_gisnews where type = 'mag' Order by date desc /cfquery NYon __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email)
Once again, you don't have to use evaluate. You can grab the columns by using #queryname.columnList#, and then to get a particular column, just do: #query[col]#. This is how DUMP is able to display queries. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 5:46 PM To: CF-Talk Subject: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email) -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 4:40 PM To: CF-Talk Subject: RE: Checking an email I build up a query where everything is applied dynamically. cfquery name=alphas datasource=#dsn# SELECT #alpha# FROM #table# ORDER BY #alpha# /cfquery Works great and returns what I want. If I use this I can loop over the query and output the contents. cfloop query=alphas cfoutput#Evaluate(alpha)#/cfoutputbr /cfloop I could use this to build a list as well but would rather use the intrinsic functions but I can't figure out what to pass to valueList. Any ideas? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamic queries in stored procedures
the only way to do it is to use the EXEC function. DECLARE @tempvar varchar(200) DECLARE @ColumnName varchar(100) SET @ColumnName = 'MyColumn' SET @tempvar = 'SELECT * FROM ' + @ColumnName EXEC(@tempvar) Just remember that with you have to make sure that you cast non-string variable to variable. DECLARE @tempvar varchar(200) DECLARE @Amount int SET @Amount = 20 SET @tempvar = 'SELECT * FROM ThisColumn WHERE Amount = ' + CAST(@Amount AS varchar(10)) If not SQL Server thinks you're trying to add a string and a number together and will throw an error. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 4:18 AM To: CF-Talk Subject: Dynamic queries in stored procedures Hi Could anyone tell me the best way to execute dynamic queries using stored procedures? Thanks Kola __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email)
On 3/28/02, Shawn McKee penned: I build up a query where everything is applied dynamically. cfquery name=alphas datasource=#dsn# SELECT #alpha# FROM #table# ORDER BY #alpha# /cfquery Works great and returns what I want. If I use this I can loop over the query and output the contents. cfloop query=alphas cfoutput#Evaluate(alpha)#/cfoutputbr /cfloop I could use this to build a list as well but would rather use the intrinsic functions but I can't figure out what to pass to valueList. Any ideas? Ho about? cfquery name=alphas datasource=#dsn# SELECT #alpha# as myColumn FROM #table# order by #alpha# /cfquery CFOUTPUT#valuelist(alphas.myColumn)#/CFOUTPUT -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfset/cfstoredproc
Sorry I didn't respond immediately- I went home sick yesterday afternoon. The 2nd example shows the correct person but everyone comes up with the 1st persons answers. When I do a regular output each person comes up with the correct answers--once I add cfset each person receives the answers for the 1st person! I originally did a join (there are 6 tables making the actual table- 2 of which are one to many)and used CFPROCRESULT to get the answers. Again getting the output format wasn't working correctly when using the cfset- once I did a cfset it would only give me one page for the results- showing the first person's name/answers-when I looped it I got many pages- each page had the 1st persons name/answers. I then did my stored procedure with 2 queries one pulls all the one to one info and then the second one that pulls the one to many info. I use several CFPROCRESULT tags to display the info. Again it displays fine until I add in the cfset tags. (But when I do the exact thing as 2 separate cfqueries and use the cfset it works like a charm!) I find this very bizarre. I have them (cfquery/cfproc) literally set up the same- they both work fine with a regular cfoutput- add the cfset and suddenly the stored procedure doesn't put out the info that needs to loop (ie: the answers)... Can someone do a small demo and see if they get the same results? Thanks J ps. my first cfoutput in my code did use the id as a group-I just forgot to put that in: CFOUTPUT QUERY=QOne GROUP=ID -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 1:48 PM To: CF-Talk Subject: RE: cfset/cfstoredproc Janine, I don't think I'm following your example. What's wrong with the second example? also, why do you need 2 queries? Why not a join? a join would give you columns of name , answer name, answer, name, answer name, answer ORder by name and make sure there is a PK ... then do this: cfoutput query=myQuery group=name #name# (or Cfset theName = name if you like) cfoutput group=PK ... Use the PK to ensure all records are iterated #answer# (or cfset Answer1 = answer) /cfoutput /cfoutput Still... I'm not sure I know exactly what the problem is from the example below. -Mark * your example * This is somewhat of a repost from the other day but haven't gotten any feedback- since I don't think I worded my problem very well. I am moving some of my work from cfquery to storedprocedures- the problem is the formatting when I use cfset with a stored procedures- they don't react the same way as a cfquery does... I need the info to show as such Mark: 1. A 2. B 3. A Mary 1. A 2. A 3. D John 1. C 2. A 3. B To achieve this with cfquery I did this: CFOUTPUT QUERY=QOne CFSET NAME= One.FIRSTNAME CFLOOP QUERY =QTwo CFSET One=QTwo.Answer[1] CFSET Two=QTwo.Answer[2] CFSET Three=QTwo.Answer[3] /CFLOOP /CFOUTPUT If I do the same with a stored procedure I end up with Mark: 1. A 2. B 3. A Mary 1. A 2. B 3. A John 1. A 2. B 3. A I can't use just a regular output like Ben Forta shows in this CF5 book-I've tried all his solutions but they all deal with regular outputs(which works fine with the cfquery and cfstored proc)- I need to use a cfset statement because each answer needs its own name. Has anyone run across this? What's the best solution? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 2 Selects killing me
its about 9000 records total. Is that to much? The 2 selects I use already has about 1000... [EMAIL PROTECTED] 03/28/02 05:52PM Can you view the source? Is it possible that you are querying too many records and the browser can't handle all of the javascript that the tag is generating? I've killed a browser or two in this manner before :) Check the recordcount... jon - Original Message - From: Michael Ross [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 4:31 PM Subject: 2 Selects killing me I am trying to use the 2 selects and it not working the page just won't load. So I know I don't have any bugs just that my query isn't running right and I am not populating the selects right here is my query. Basically I have a table with lots of records. Using the first select box I want to to show only the cpt codes from the 1st boxes list of locations. the fees table has a idnumber, the locationid, the cpt code and some other data. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Internationalization
We are makers of SiteDirector a commerce application and are getting ready to move it towards internationalization (if that is the correct term). We have many customers who are requesting if SiteDirector supports other languages, currency and so forth. Well it doesn't.. but we want it to! To be honest, I am fairly clueless on where to start, but willing to learn. Does anyone out there know of any good resources to view/read on what steps need to take place .. (ie languages, currency ..and other concerns?). Any help or pointing in the right direction will be most appreciated! Thank you Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Internationalization
I think the term you are looking for is ..localisation or localization (US). -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: 29 March 2002 14:04 To: CF-Talk Subject: Internationalization We are makers of SiteDirector a commerce application and are getting ready to move it towards internationalization (if that is the correct term). We have many customers who are requesting if SiteDirector supports other languages, currency and so forth. Well it doesn't.. but we want it to! To be honest, I am fairly clueless on where to start, but willing to learn. Does anyone out there know of any good resources to view/read on what steps need to take place .. (ie languages, currency ..and other concerns?). Any help or pointing in the right direction will be most appreciated! Thank you Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
HTML comments and tag completion
All, Can anyone tell me how to disable the CF Studio tag completion for HTML comments? !-- Every time I try to type in a CF comment ( !--- ) it closes it with a -- before I enter the third -. And although Studio color codes the comment as if it had been closed correctly, CF Server treats the rest of the page like a CF comment. When I check out the Tag Completion section of the Settings in Studio, !-- and !--- are not listed. Any ideas anyone? I don't want to turn off tag completion entirely, just disable it for the !--- and !-- tags. Please CC: [EMAIL PROTECTED] in your response, as I am subscribed to the digest version of this list. Thanks in advance! v/r, Jeff Brown http://www.secret-plans.com/ FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamic queries in stored procedures
I use the COALESCE function with success. CREATE PROCEDURE XXX @Opt int, @City varchar (26) = NULL, @item_descp varchar (35)= NULL, @commodity_code char (4) = NULL AS SELECT ALL FROM dbo.tbl_XXX WHERE item_id like '%' + COALESCE(@item_id,item_id) + '%' AND item_descp like '%' +COALESCE(@item_descp,item_descp) + '%' AND commodity_code like '%' + COALESCE(@commodity_code,commodity_code) +'%' ORDER BY CASE WHEN @Opt = 1 THEN item_id WHEN @Opt = 2 THEN item_descp WHEN @Opt = 3 THEN commodity_code END Thanks, Dave Bosky -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 8:19 AM To: CF-Talk Subject: RE: Dynamic queries in stored procedures the only way to do it is to use the EXEC function. DECLARE @tempvar varchar(200) DECLARE @ColumnName varchar(100) SET @ColumnName = 'MyColumn' SET @tempvar = 'SELECT * FROM ' + @ColumnName EXEC(@tempvar) Just remember that with you have to make sure that you cast non-string variable to variable. DECLARE @tempvar varchar(200) DECLARE @Amount int SET @Amount = 20 SET @tempvar = 'SELECT * FROM ThisColumn WHERE Amount = ' + CAST(@Amount AS varchar(10)) If not SQL Server thinks you're trying to add a string and a number together and will throw an error. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 4:18 AM To: CF-Talk Subject: Dynamic queries in stored procedures Hi Could anyone tell me the best way to execute dynamic queries using stored procedures? Thanks Kola __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML comments and tag completion
Go into OPTIONS / SETTINGS ... then under the editor, view the AutoCompletion settings .. you can modify them there! Good Luck Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder All, Can anyone tell me how to disable the CF Studio tag completion for HTML comments? !-- Every time I try to type in a CF comment ( !--- ) it closes it with a -- before I enter the third -. And although Studio color codes the comment as if it had been closed correctly, CF Server treats the rest of the page like a CF comment. When I check out the Tag Completion section of the Settings in Studio, !-- and !--- are not listed. Any ideas anyone? I don't want to turn off tag completion entirely, just disable it for the !--- and !-- tags. Please CC: [EMAIL PROTECTED] in your response, as I am subscribed to the digest version of this list. Thanks in advance! v/r, Jeff Brown http://www.secret-plans.com/ FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML comments and tag completion
got it, thanks! right in front of my nose... -jab -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:33 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: HTML comments and tag completion Go into OPTIONS / SETTINGS ... then under the editor, view the AutoCompletion settings .. you can modify them there! Good Luck Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder All, Can anyone tell me how to disable the CF Studio tag completion for HTML comments? !-- Every time I try to type in a CF comment ( !--- ) it closes it with a -- before I enter the third -. And although Studio color codes the comment as if it had been closed correctly, CF Server treats the rest of the page like a CF comment. When I check out the Tag Completion section of the Settings in Studio, !-- and !--- are not listed. Any ideas anyone? I don't want to turn off tag completion entirely, just disable it for the !--- and !-- tags. Please CC: [EMAIL PROTECTED] in your response, as I am subscribed to the digest version of this list. Thanks in advance! v/r, Jeff Brown http://www.secret-plans.com/ FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML comments and tag completion
Create your own short cut keys for CF HTML comments. That way auto complete won't get in the way and you don't have to type them. Justin -Original Message- From: Jeff Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 8:31 AM To: CF-Talk Subject: HTML comments and tag completion All, Can anyone tell me how to disable the CF Studio tag completion for HTML comments? !-- Every time I try to type in a CF comment ( !--- ) it closes it with a -- before I enter the third -. And although Studio color codes the comment as if it had been closed correctly, CF Server treats the rest of the page like a CF comment. When I check out the Tag Completion section of the Settings in Studio, !-- and !--- are not listed. Any ideas anyone? I don't want to turn off tag completion entirely, just disable it for the !--- and !-- tags. Please CC: [EMAIL PROTECTED] in your response, as I am subscribed to the digest version of this list. Thanks in advance! v/r, Jeff Brown http://www.secret-plans.com/ FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML comments and tag completion
why not se a keyboard shortcut for your cf comment (mine is ctrl shift m) you can change them in the customize box. You won't need to type the comment anymore HTH Simon - Original Message - From: Jeff Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 29, 2002 2:31 PM Subject: HTML comments and tag completion All, Can anyone tell me how to disable the CF Studio tag completion for HTML comments? !-- Every time I try to type in a CF comment ( !--- ) it closes it with a -- before I enter the third -. And although Studio color codes the comment as if it had been closed correctly, CF Server treats the rest of the page like a CF comment. When I check out the Tag Completion section of the Settings in Studio, !-- and !--- are not listed. Any ideas anyone? I don't want to turn off tag completion entirely, just disable it for the !--- and !-- tags. Please CC: [EMAIL PROTECTED] in your response, as I am subscribed to the digest version of this list. Thanks in advance! v/r, Jeff Brown http://www.secret-plans.com/ FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Zipping Files
Does anyone have code or an example of zipping files? Thx, Duane __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamic queries in stored procedures
i have never used this function before. can you elaborate on what exactly it does. the BOL doesn't really give a clear definition. By the way all: i know you can do the last example in my previous post without using the EXEC function. i was just doing it to show how you would use the case function. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:32 AM To: CF-Talk Subject: RE: Dynamic queries in stored procedures I use the COALESCE function with success. CREATE PROCEDURE XXX @Opt int, @City varchar (26) = NULL, @item_descp varchar (35)= NULL, @commodity_code char (4) = NULL AS SELECT ALL FROM dbo.tbl_XXX WHERE item_id like '%' + COALESCE(@item_id,item_id) + '%' AND item_descp like '%' +COALESCE(@item_descp,item_descp) + '%' AND commodity_code like '%' + COALESCE(@commodity_code,commodity_code) +'%' ORDER BY CASE WHEN @Opt = 1 THEN item_id WHEN @Opt = 2 THEN item_descp WHEN @Opt = 3 THEN commodity_code END Thanks, Dave Bosky -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 8:19 AM To: CF-Talk Subject: RE: Dynamic queries in stored procedures the only way to do it is to use the EXEC function. DECLARE @tempvar varchar(200) DECLARE @ColumnName varchar(100) SET @ColumnName = 'MyColumn' SET @tempvar = 'SELECT * FROM ' + @ColumnName EXEC(@tempvar) Just remember that with you have to make sure that you cast non-string variable to variable. DECLARE @tempvar varchar(200) DECLARE @Amount int SET @Amount = 20 SET @tempvar = 'SELECT * FROM ThisColumn WHERE Amount = ' + CAST(@Amount AS varchar(10)) If not SQL Server thinks you're trying to add a string and a number together and will throw an error. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 4:18 AM To: CF-Talk Subject: Dynamic queries in stored procedures Hi Could anyone tell me the best way to execute dynamic queries using stored procedures? Thanks Kola __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: calling 5 articles minus the latest one
I think it would be like: cfquery datasource=gmu name=mag select TOP 5 id, type, title, snippets, date, url from local_gisnews where type = 'mag' AND ID MAX(ID) Order by date desc /cfquery You could also just select the TOP 6 records and skip the first one in the CF code. Nyon [EMAIL PROTECTED] 03/29/02 08:27AM Hi, I want to call the latest 5 articles minus the latest entry. Here's my code snippet on calling the latest 5 articles. cfquery maxrows=5 datasource=gmu name=mag select id, type, title, snippets, date, url from local_gisnews where type = 'mag' Order by date desc /cfquery NYon __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamic queries in stored procedures
It returns the first non null value. When a value is provided its used as a parameter otherwise the current column value is used, which causes all rows to be returned for That operation. Thanks, Dave Bosky -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:33 AM To: CF-Talk Subject: RE: Dynamic queries in stored procedures i have never used this function before. can you elaborate on what exactly it does. the BOL doesn't really give a clear definition. By the way all: i know you can do the last example in my previous post without using the EXEC function. i was just doing it to show how you would use the case function. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:32 AM To: CF-Talk Subject: RE: Dynamic queries in stored procedures I use the COALESCE function with success. CREATE PROCEDURE XXX @Opt int, @City varchar (26) = NULL, @item_descp varchar (35)= NULL, @commodity_code char (4) = NULL AS SELECT ALL FROM dbo.tbl_XXX WHERE item_id like '%' + COALESCE(@item_id,item_id) + '%' AND item_descp like '%' +COALESCE(@item_descp,item_descp) + '%' AND commodity_code like '%' + COALESCE(@commodity_code,commodity_code) +'%' ORDER BY CASE WHEN @Opt = 1 THEN item_id WHEN @Opt = 2 THEN item_descp WHEN @Opt = 3 THEN commodity_code END Thanks, Dave Bosky -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 8:19 AM To: CF-Talk Subject: RE: Dynamic queries in stored procedures the only way to do it is to use the EXEC function. DECLARE @tempvar varchar(200) DECLARE @ColumnName varchar(100) SET @ColumnName = 'MyColumn' SET @tempvar = 'SELECT * FROM ' + @ColumnName EXEC(@tempvar) Just remember that with you have to make sure that you cast non-string variable to variable. DECLARE @tempvar varchar(200) DECLARE @Amount int SET @Amount = 20 SET @tempvar = 'SELECT * FROM ThisColumn WHERE Amount = ' + CAST(@Amount AS varchar(10)) If not SQL Server thinks you're trying to add a string and a number together and will throw an error. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 4:18 AM To: CF-Talk Subject: Dynamic queries in stored procedures Hi Could anyone tell me the best way to execute dynamic queries using stored procedures? Thanks Kola __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email)
Is it me or is evaluate used fr too much? :-) __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Zipping Files
You could grab cfx_consolecommand and run pkzip old school style. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:38 AM To: CF-Talk Subject: Zipping Files Does anyone have code or an example of zipping files? Thx, Duane __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Zipping Files
We've been using a command line .exe from winzip that does a great job. We have scheduled jobs that look like this: CFEXECUTE NAME=C:\progra~1\winzip\wzzip.exe arguments=c:\directory\filenametobewritten.zip c:\directory\filenametobezipped.txt /CFEXECUTE Works like a charm! At 09:54 AM 3/29/02 -0500, you wrote: You could grab cfx_consolecommand and run pkzip old school style. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:38 AM To: CF-Talk Subject: Zipping Files Does anyone have code or an example of zipping files? Thx, Duane __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email)
There are a few things in code that should make you stop. For example, if you type application, session, or server, stop and think, Did I use cflock? If you type evalute, stop and think, Do I really need it? Just my two and half cents. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Neil Clark =TMM= [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:43 AM To: CF-Talk Subject: RE: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email) Is it me or is evaluate used fr too much? :-) __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Internationalization
Ben Forta's Advanced ColdFusion 5 has a chapter dedicated to this. BTW talking about localization, CF Studio 5 is supposed to display Unicode. Does anybody know how to enable it? Thanks Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 29, 2002 9:04 AM Subject: Internationalization We are makers of SiteDirector a commerce application and are getting ready to move it towards internationalization (if that is the correct term). We have many customers who are requesting if SiteDirector supports other languages, currency and so forth. Well it doesn't.. but we want it to! To be honest, I am fairly clueless on where to start, but willing to learn. Does anyone out there know of any good resources to view/read on what steps need to take place .. (ie languages, currency ..and other concerns?). Any help or pointing in the right direction will be most appreciated! Thank you Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Win 2k patch question
Is there an easy way to tell what patches have been applied to a Win 2k server? I want to make sure I have everything I need on it but know of the best way to check. TIA -- Phillip Broussard Tracker Marine Group 417-873-5957 -- __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: Like vs. =
While I know that like is always slower, consider this: WHERE left(description,1) = 'A' OR WHERE description LIKE 'A%' Which would be faster? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Win 2k patch question
Click on Start, then go to the upper part of the menu and click on Windows Update... That will take you to Microsoft ... then click on the left menu item Product Updates it will do a scan of your system and tell you what you need! Good Luck Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: Phillip Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 29, 2002 9:19 AM Subject: OT: Win 2k patch question Is there an easy way to tell what patches have been applied to a Win 2k server? I want to make sure I have everything I need on it but know of the best way to check. TIA -- Phillip Broussard Tracker Marine Group 417-873-5957 -- __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Win 2k patch question
I'm no expert on networking, but I do the windows update. It checks to see if there are any MS updates that I don't have and prompts me to download them. I don't know if it's the best way but it sure is easy. - Matt Small -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:19 AM To: CF-Talk Subject: OT: Win 2k patch question Is there an easy way to tell what patches have been applied to a Win 2k server? I want to make sure I have everything I need on it but know of the best way to check. TIA -- Phillip Broussard Tracker Marine Group 417-873-5957 -- __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Win 2k patch question
Best bet is to run hfnetchk... http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/ tools/hfnetchk.asp (Watch out for the wrap...) This tool will go out and compare all the security patches available with the ones installed on your machine. You can then use qchain to do a one time install of all the hotfixes you are missing (traditionally, each hotfix typically required a reboot... With qchain, you can install them all and reboot once). I've found that for server security, Windows Update doesn't cut it. My .02 Jeff Garza -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 8:20 AM To: CF-Talk Subject: Re: Win 2k patch question Click on Start, then go to the upper part of the menu and click on Windows Update... That will take you to Microsoft ... then click on the left menu item Product Updates it will do a scan of your system and tell you what you need! Good Luck Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: Phillip Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 29, 2002 9:19 AM Subject: OT: Win 2k patch question Is there an easy way to tell what patches have been applied to a Win 2k server? I want to make sure I have everything I need on it but know of the best way to check. TIA -- Phillip Broussard Tracker Marine Group 417-873-5957 -- __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Creating a CSV File
I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)#_FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##rtrim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#chr(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34)#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editdate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(GetDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr(34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)##rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)#,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Win 2k patch question
Is there an easy way to tell what patches have been applied to a Win 2k server? I want to make sure I have everything I need on it but know of the best way to check. Use HFNetChk, a free command-line tool available from Microsoft. Look for it at http://www.microsoft.com/technet/security/. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DHTML Layers
Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email)
Yep, You're wise words of EVERYTIME I TYPE SESSION... etc... is always with me... As for evaluate; never use it much as you rightly put - Did I really need it! N __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating a CSV File
Store your information in a variable until you reach a certain number of records and then append it to the file. You will have a significantly reduced number of writes to the disk which is causing your slow response. Something like this: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cfset theoutput = #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput /cfif /cfoutput - Matt Small -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:31 AM To: CF-Talk Subject: Creating a CSV File I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDoc s.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
qForms v2.0 Survey...
Sorry for the cross posts on this subject, but I know there some people on this list using qForms who aren't subscribed to the other lists. I'm working on v2 of the qForms API. In the coming month, I'll be posting a number of different survey/questions to the qForms Mailing List. If you're interested in contributing to the future direction of qForms, or would simply like to have some input into it's direction, please sign up for the mailing list at: http://groups.yahoo.com/group/qformsapi You can also sign up directly from your e-mail client, with the following addresses: Post message: [EMAIL PROTECTED] Subscribe:[EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] If you've never used qForms, or thought you didn't have a need for it, I highly recommend you check it out. If you just take an hour or so to play around with it in the next few days, I think you'll see just how much time it'll save you. Once again, sorry for the cross post. Sincerely, Dan G. Switzer, II __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email)
I can't think of a time when I've ever used evaluate in Cold Fusion. - Matt Small -Original Message- From: Neil Clark =TMM= [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:44 AM To: CF-Talk Subject: RE: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email) Yep, You're wise words of EVERYTIME I TYPE SESSION... etc... is always with me... As for evaluate; never use it much as you rightly put - Did I really need it! N __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF not writing client cookie
for some strange reason CF is not writing the client cookie to the user. I have setclientcookie=yes in the cfapplication tag. what could be wrong? Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating a CSV File
Sorry, I forgot a couple of things ... cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfset theoutput = cfoutput query=GetDocs cfset theoutput = theoutput #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput cfset theoutput = /cfif /cfoutput-Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:02 AM To: CF-Talk Subject: RE: Creating a CSV File Store your information in a variable until you reach a certain number of records and then append it to the file. You will have a significantly reduced number of writes to the disk which is causing your slow response. Something like this: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cfset theoutput = #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput /cfif /cfoutput - Matt Small -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:31 AM To: CF-Talk Subject: Creating a CSV File I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDoc s.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email)
There _are_ times when you need it, of course. The #1 way I see people using evaluate when they don't need it is to get dynamic form names. Ie, looping through form fields not know at design time. In this scenario, you should simply use the Form scope like a structure: cfloop item=field collection=#form# cfoutputForm.#field# is #Form[field]#br/cfoutput /cfloop === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:03 AM To: CF-Talk Subject: RE: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email) I can't think of a time when I've ever used evaluate in Cold Fusion. - Matt Small __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Evaluating Variables from a stupid person who doesn't change subj ect (was RE: Checking an email)
Well, Fusetalk uses it EVERYWHERE.. apparently it is necessary. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Layers
You need to set the z-index property on your layers. Sounds like you're using Netscape for this, as in IE the select boxes are system object and thus override everything else on the screen. -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 8:45 AM To: CF-Talk Subject: DHTML Layers Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Creating a CSV File
I have had similar experience with lack of speed when creating CSVs. You can accomplish this with only one call to cffile. You can just keep appending to a variable: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)#_FIRST.csv cfset l_Output = cfset l_NewLine = chr(13) chr(10) cfoutput query=GetDocs cfset l_Output = l_Output #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##rtrim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#chr(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34)#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editdate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(GetDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr(34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)##rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)#,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)##l_NewLine# /cfoutput cffile action=write file=#csvfile# output=#l_Output# Gieseman, Athelene [EMAIL PROTECTED] 03/29/02 10:31AM I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)#_FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##rtrim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#chr(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34)#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editdate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(GetDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr(34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)##rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)#,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Layers
Rick: Unfortunately, this is a known issue with DHTML. If I remember correctly, it has something to do with browser DOM (Document Object Model). As far as I know, there is no current work around... Anyone have any additional information / updates to this? Thanks, Christian -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:45 AM To: CF-Talk Subject: DHTML Layers Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating a CSV File
I love this list! Thank you so much. Athelene -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:06 AM To: CF-Talk Subject: RE: Creating a CSV File Sorry, I forgot a couple of things ... cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfset theoutput = cfoutput query=GetDocs cfset theoutput = theoutput #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput cfset theoutput = /cfif /cfoutput-Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:02 AM To: CF-Talk Subject: RE: Creating a CSV File Store your information in a variable until you reach a certain number of records and then append it to the file. You will have a significantly reduced number of writes to the disk which is causing your slow response. Something like this: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cfset theoutput = #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput /cfif /cfoutput - Matt Small -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:31 AM To: CF-Talk Subject: Creating a CSV File I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDoc s.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Layers + Flash!
This is not possible with regular DHTML layers but, I have come up with a solution, but I don't have an example for you. Try putting a flash movie in the layer. It will go over the form fields. It will even (in IE) allow transparency. You can even see the webpage behind/through the menu. Now, to do it right, you'll need a full dhtml/flash/cf solution for menus. I haven't seen one yet. Currently, I'm waiting on my new employer to buy Flash MX. When I get, it I plan on developing one. If anyone has beat me to this, let me know. I would like to see what you came up with. Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:45 AM To: CF-Talk Subject: DHTML Layers Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating a CSV File
A faster technique would be to select each line directly in the SQL query. Like here: CFQUERY NAME=GetDocs... SELECT '' + RTRIM(CATEGORY) + '' + ',' + '' + RTRIM(newc2) + '' + ',' + ... '' + RTRIM(C_Alias) + '' AS line FROM table /CFQUERY !--- create the file content CFSET filecontent = ValueList(GetDocs.line,#CHR(13)##CHR(10)#) !--- and save it --- cffile action=APPEND file=#csvfile# output=#filecontent# the query will not select lines with NULL fields if you use MS SQL server. In that case you should use the COALESCE function for each field that might be null: COALESCE(field,'') Also you may need to convert numeric or date type fields to nvarchar. HTH Marian -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:31 AM To: CF-Talk Subject: Creating a CSV File I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTH OR)#_FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim( GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr( 34)##rtrim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34 )#,#chr(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)## chr(34)#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs .editdate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##r trim(GetDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)# ,#chr(34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr (34)##rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##ch r(34)#,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Win 2k patch question
You can also go to start control panel add\remove to see a list of installed patches. Another way is to go to windowsupdate.microsoft.com and let the site check your settings to see what you need. (There's also a security rollup patch you can install) Lucius -Original Message- From: Dave Watts To: CF-Talk Sent: 3/29/02 10:39 AM Subject: RE: Win 2k patch question Is there an easy way to tell what patches have been applied to a Win 2k server? I want to make sure I have everything I need on it but know of the best way to check. Use HFNetChk, a free command-line tool available from Microsoft. Look for it at http://www.microsoft.com/technet/security/. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating a CSV File
That's a really nice technique. - Matt Small -Original Message- From: Marian Dumitrascu [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:09 AM To: CF-Talk Subject: RE: Creating a CSV File A faster technique would be to select each line directly in the SQL query. Like here: CFQUERY NAME=GetDocs... SELECT '' + RTRIM(CATEGORY) + '' + ',' + '' + RTRIM(newc2) + '' + ',' + ... '' + RTRIM(C_Alias) + '' AS line FROM table /CFQUERY !--- create the file content CFSET filecontent = ValueList(GetDocs.line,#CHR(13)##CHR(10)#) !--- and save it --- cffile action=APPEND file=#csvfile# output=#filecontent# the query will not select lines with NULL fields if you use MS SQL server. In that case you should use the COALESCE function for each field that might be null: COALESCE(field,'') Also you may need to convert numeric or date type fields to nvarchar. HTH Marian -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:31 AM To: CF-Talk Subject: Creating a CSV File I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTH OR)#_FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim( GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr( 34)##rtrim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34 )#,#chr(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)## chr(34)#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs .editdate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##r trim(GetDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)# ,#chr(34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr (34)##rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##ch r(34)#,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Layers
The layering problem is happening in IE. Thanks for the suggestions guys. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/29/02 10:58AM You need to set the z-index property on your layers. Sounds like you're using Netscape for this, as in IE the select boxes are system object and thus override everything else on the screen. -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 8:45 AM To: CF-Talk Subject: DHTML Layers Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Creating update statements on the fly
HI,
I wanted to create a Update statement on the fly. For creating a Select
statement on the fly I have used
Select * from tablename
Where 0=0
cfif isDefined(attributes.String1)
and String1 = attributes.String1
/cfif
How can I achieve this for update statement as I couldn't figure out
where to put Set statement and the last line with out coma(',') in my
statement.
Thanks in advance.
Sudheer Chakka.
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle version of TOP
SELECT ... FROM ... WHERE rownum 10 -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:56 AM To: CF-Talk Subject: Re: Oracle version of TOP LANCASTER, STEVEN M. (JSC-OL) (BAR) wrote: My Oracle Guy says you can do a where CURRVAL is and NEXTVAL is.. no that's sequences, oracles auto_id system z __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DHTML Layers
Currently, only the gecko rendering engine works around this. The problem arises from the fact that most browsers use their parent operating system to draw form elements. These in essence are drawn on top of the web page and aren't considered to be part of the web page. Gecko creates the form elements itself, so it does have control over the placement. Unfortunately, Gecko isn't quite as popular as IE..yet. Sorry to rain on your parade. Marlon - Original Message - From: Christian Abad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 29, 2002 10:02 AM Subject: RE: DHTML Layers Rick: Unfortunately, this is a known issue with DHTML. If I remember correctly, it has something to do with browser DOM (Document Object Model). As far as I know, there is no current work around... Anyone have any additional information / updates to this? Thanks, Christian -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:45 AM To: CF-Talk Subject: DHTML Layers Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Layers + Flash!
I would love to do the dynamic menus in flash. I never thought to put the flash into a layer. Interesting idea. See though drop down menus could create some very cool effects, especially since you can animate of the menu. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/29/02 11:07AM This is not possible with regular DHTML layers but, I have come up with a solution, but I don't have an example for you. Try putting a flash movie in the layer. It will go over the form fields. It will even (in IE) allow transparency. You can even see the webpage behind/through the menu. Now, to do it right, you'll need a full dhtml/flash/cf solution for menus. I haven't seen one yet. Currently, I'm waiting on my new employer to buy Flash MX. When I get, it I plan on developing one. If anyone has beat me to this, let me know. I would like to see what you came up with. Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:45 AM To: CF-Talk Subject: DHTML Layers Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
update to cf not writing cookies
i test this by creating two test pages on the first i create a cookie with cfcookie and a link to the next page. on the second page i cfoutput the cookie. it seems that the cf server is not creating cookie at all. what could this be? Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: update to cf not writing cookies
oi Tony!! do you have an application.cfm that enables client management? -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Friday, March 29, 2002, 11:12:52 AM, you wrote: Tso i test this by creating two test pages Tso on the first i create a cookie with cfcookie and a link to the next page. Tso on the second page i cfoutput the cookie. Tso it seems that the cf server is not creating cookie at all. what could this Tso be? Tso Anthony Petruzzi Tso Webmaster Tso 954-321-4703 Tso http://www.sheriff.org Tso __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: update to cf not writing cookies
You mentioned that you are linking to the next page.. is it an actual link or a cflocation? If you are using cflocation, change that to a meta refresh ... the cookie needs to be set on the clients browser and cflocation transfers them on to the next page on the serverside which never hits the clients browser to set the cookie. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 29, 2002 10:12 AM Subject: update to cf not writing cookies i test this by creating two test pages on the first i create a cookie with cfcookie and a link to the next page. on the second page i cfoutput the cookie. it seems that the cf server is not creating cookie at all. what could this be? Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: IE and view source
All of a sudden, my view source option in IE 6.0 doesn't do anything anymore. It used to show me the source in notepad, which is exactly what I want. Now it doesn't do anything. Even if I right click and view source, it doesn't do anything. Anybody have any ideas how to fix this? Thanks, Matt Small __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DHTML Layers + Flash!
I've tried this before, and yes you could see the form elements, but you could not select them because Flash was on top and had the focus. We're you able to overcome this? If so, that would be too cool. Marlon - Original Message - From: Rick Walters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 29, 2002 10:16 AM Subject: RE: DHTML Layers + Flash! I would love to do the dynamic menus in flash. I never thought to put the flash into a layer. Interesting idea. See though drop down menus could create some very cool effects, especially since you can animate of the menu. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/29/02 11:07AM This is not possible with regular DHTML layers but, I have come up with a solution, but I don't have an example for you. Try putting a flash movie in the layer. It will go over the form fields. It will even (in IE) allow transparency. You can even see the webpage behind/through the menu. Now, to do it right, you'll need a full dhtml/flash/cf solution for menus. I haven't seen one yet. Currently, I'm waiting on my new employer to buy Flash MX. When I get, it I plan on developing one. If anyone has beat me to this, let me know. I would like to see what you came up with. Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:45 AM To: CF-Talk Subject: DHTML Layers Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Creating update statements on the fly
There's always the ASP way...
!--- build the query ---
cfset sql=update tablename set
cfif condition1...
cfset sql=#sql# columname=value
/cfif
cfif condition2...
cfset sql=#sql# where columname = 1
/cfif
cfquery name=myquery datasource=#dsn#
#sql#
/cfquery
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
[EMAIL PROTECTED] 03/29/02 11:10AM
HI,
I wanted to create a Update statement on the fly. For creating a
Select
statement on the fly I have used
Select * from tablename
Where 0=0
cfif isDefined(attributes.String1)
and String1 = attributes.String1
/cfif
How can I achieve this for update statement as I couldn't figure
out
where to put Set statement and the last line with out coma(',') in my
statement.
Thanks in advance.
Sudheer Chakka.
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: update to cf not writing cookies
the hunt continues. i found out that if i use netscape, the cookies are set, but if i use ie the cookie son't get set. i turned all of my security down to low to see if that helps and it didn't. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:23 AM To: CF-Talk Subject: Re: update to cf not writing cookies oi Tony!! do you have an application.cfm that enables client management? -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Friday, March 29, 2002, 11:12:52 AM, you wrote: Tso i test this by creating two test pages Tso on the first i create a cookie with cfcookie and a link to the next page. Tso on the second page i cfoutput the cookie. Tso it seems that the cf server is not creating cookie at all. what could this Tso be? Tso Anthony Petruzzi Tso Webmaster Tso 954-321-4703 Tso http://www.sheriff.org Tso __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IE and view source
Had this problem before .. you need to clear your cache and temp files ... it is probably loaded Wy up! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: Matthew R. Small [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 29, 2002 10:32 AM Subject: OT: IE and view source All of a sudden, my view source option in IE 6.0 doesn't do anything anymore. It used to show me the source in notepad, which is exactly what I want. Now it doesn't do anything. Even if I right click and view source, it doesn't do anything. Anybody have any ideas how to fix this? Thanks, Matt Small __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CDONTS and ReplyTo
Try cfset objNewMail.To = [EMAIL PROTECTED] - Original Message - From: Dave Jones To: CF-Talk Sent: Thursday, March 28, 2002 11:29 AM Subject: CDONTS and ReplyTo Can someone tell me how to set the Reply-To header when using CDONTS in ColdFusion? These assignments do NOT work: cfset objNewMail.ReplyTo = [EMAIL PROTECTED] cfset objNewMail.Reply_To = [EMAIL PROTECTED] cfset objNewMail.Value(Reply-To) = [EMAIL PROTECTED] Thanks, Dave Jones NetEffect __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF IIS - Directories with '.com'
My understanding is that IIS takes the first extension in the file path, and uses that to decide who/what gets to interpret the file. So with a path including .com, it will work just as you have seen. If you had a path called test.htm or test.cfm, I think you'd see the same results. If there is a way around this in IIS, I'd love to learn about it, too. No help, Jerry Johnson [EMAIL PROTECTED] 03/28/02 04:52PM I've run up against IIS's wonderful inability to correctly parse virtual paths before, but this one has me stumped. If I have a folder test.com on my web server (a domain name for a client's site we are working on), any CF files that are under the directory with the .com in the name are all passed back as source (with Content-Type: application/octet-stream). If I rename the directory to just test (that is, remove the .com) then the script executes as planned. I can only assume that IIS isn't bothering to see if test.com is a directory and is instead assuming it is an executable file with a .com extension. I've tried poking around in the options ([dis]allowing scripts executables, checking to see if the file exists, etc) but nothing seems to fix it. We don't have this problem with our Apache server. I can't be the only one who has ever run up against this, but searching for .com on the web is like drinking from a firehose. Anyone have any pointers for how to fix it? (No, I don't want to rename all of my directories to remove the .com.) Thanks, -R __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating a CSV File
I'm using a stored procedure which puts the results into GetDocs. I'm getting an error on: getdocs.currentrecord It says it's not a valid column. Do I somehow need to setup something to determine the current record? Or is it not providing that since it's coming from a stored procedure? Athelene -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:06 AM To: CF-Talk Subject: RE: Creating a CSV File Sorry, I forgot a couple of things ... cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfset theoutput = cfoutput query=GetDocs cfset theoutput = theoutput #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput cfset theoutput = /cfif /cfoutput-Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:02 AM To: CF-Talk Subject: RE: Creating a CSV File Store your information in a variable until you reach a certain number of records and then append it to the file. You will have a significantly reduced number of writes to the disk which is causing your slow response. Something like this: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cfset theoutput = #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput /cfif /cfoutput - Matt Small -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:31 AM To: CF-Talk Subject: Creating a CSV File I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDoc s.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: IE and view source
oi Matthew!! usually means your browser cache is full. -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Friday, March 29, 2002, 11:32:55 AM, you wrote: MRS All of a sudden, my view source option in IE 6.0 doesn't do anything MRS anymore. It used to show me the source in notepad, which is exactly MRS what I want. Now it doesn't do anything. Even if I right click and MRS view source, it doesn't do anything. Anybody have any ideas how to fix MRS this? MRS Thanks, MRS Matt Small MRS __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Layers + Flash!
http://www.jhansen.net/demo/dhtmlflash.html Here is a very crude demo. It shows a flash movie in a layer over a select box. The real challenge is how to make the movie size dynamic. Which you can't do. If you made one dynamic movie for each menu item, you could stack them up and not have to worry about the canvas size. So, let's say you loop over a flash menu object/custom tag, pass it text=link text and link=file.html or showmenulayer(name), and you have yourself one killer menu system. I have had this idea for a while, just haven't taken the time to develop it yet. Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:17 AM To: CF-Talk Subject: RE: DHTML Layers + Flash! I would love to do the dynamic menus in flash. I never thought to put the flash into a layer. Interesting idea. See though drop down menus could create some very cool effects, especially since you can animate of the menu. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/29/02 11:07AM This is not possible with regular DHTML layers but, I have come up with a solution, but I don't have an example for you. Try putting a flash movie in the layer. It will go over the form fields. It will even (in IE) allow transparency. You can even see the webpage behind/through the menu. Now, to do it right, you'll need a full dhtml/flash/cf solution for menus. I haven't seen one yet. Currently, I'm waiting on my new employer to buy Flash MX. When I get, it I plan on developing one. If anyone has beat me to this, let me know. I would like to see what you came up with. Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:45 AM To: CF-Talk Subject: DHTML Layers Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity Index type=path
I have been using Verity on a couple websites and have been pretty pleased thus far. However, I recently encountered a problem when trying to index a large directory. (This is the Verity that comes with CF4.5 - not the new CF5 version). I have a directory with 5740 files in it - all Microsoft Word 97 documents. When I create a new collection and use CFINDEX to index the documents, it doesn't add all 5740 documents and it isn't even consistent. Sometimes it will add 5728, 5732, 5735, 5736 - never all 5740. I'm using the following CFINDEX code: cfindexcollection=pnpworking2 action=update type=path key=e:\inetpub\wwwroot\websitename\documents\pnp\working\ extensions=.doc,.xls,.ppt,.pdf I'm confirming the number of files added, by searching for a keyword and outputting #search.RECORDSSEARCHED#. I have also tried using the CF Administrator to index the directory and get the SAME results. If I start with a new collection and use CFDIRECTORY to get a listing of the files in the directory and then loop over them one by one adding them to the collection using CFINDEX and type=file, the server times out before finishing - I've let it run for 30 minutes. In other places I use Verity, I don't have more than 1000 files in a single directory, and I do not have this problem. Questions: 1. Is there a limit to the number of files Verity can index in a single directory? 2. Maybe all the files are getting indexed, but the .RECORDSSEARCHED is incorrect? 3. I considered that it may be an issue where Verity can't access a document if its in use by another process, but I made a copy of the directory and moved it somewhere else on the server and am still having the same problem. Are there other possible services that could access these files (preventing Verity from indexing them) I need to be aware of? (Platform NT4Sp6a/IIS4/CF4.5.1SP2) Thanks for any help you can provide, Jackson Moore [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verity Index type=path
I've run into this problem, too, and have ended up breaking the big directories into 1 or more smaller ones, with 1000 files each, and then creating a separate index for each one. A pain, I know, but it's been the only thing that worked for us. On the bright side, if you organize the directories by subject, you can allow folks to search only one index at a time... Ian -Original Message- From: Jackson Moore [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 8:40 AM To: CF-Talk Subject: Verity Index type=path I have been using Verity on a couple websites and have been pretty pleased thus far. However, I recently encountered a problem when trying to index a large directory. (This is the Verity that comes with CF4.5 - not the new CF5 version). I have a directory with 5740 files in it - all Microsoft Word 97 documents. When I create a new collection and use CFINDEX to index the documents, it doesn't add all 5740 documents and it isn't even consistent. Sometimes it will add 5728, 5732, 5735, 5736 - never all 5740. I'm using the following CFINDEX code: cfindexcollection=pnpworking2 action=update type=path key=e:\inetpub\wwwroot\websitename\documents\pnp\working\ extensions=.doc,.xls,.ppt,.pdf I'm confirming the number of files added, by searching for a keyword and outputting #search.RECORDSSEARCHED#. I have also tried using the CF Administrator to index the directory and get the SAME results. If I start with a new collection and use CFDIRECTORY to get a listing of the files in the directory and then loop over them one by one adding them to the collection using CFINDEX and type=file, the server times out before finishing - I've let it run for 30 minutes. In other places I use Verity, I don't have more than 1000 files in a single directory, and I do not have this problem. Questions: 1. Is there a limit to the number of files Verity can index in a single directory? 2. Maybe all the files are getting indexed, but the .RECORDSSEARCHED is incorrect? 3. I considered that it may be an issue where Verity can't access a document if its in use by another process, but I made a copy of the directory and moved it somewhere else on the server and am still having the same problem. Are there other possible services that could access these files (preventing Verity from indexing them) I need to be aware of? (Platform NT4Sp6a/IIS4/CF4.5.1SP2) Thanks for any help you can provide, Jackson Moore [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Vinny A DiDonato/AMER/TRS/AEXP is out of the office.
I will be out of the office from 03/29/2002 until 04/08/2002. If this message is urgent, please email Joe Jokela ([EMAIL PROTECTED]) or Mike Earls ([EMAIL PROTECTED]). Otherwise, I will respond to your message when I return. Thank you, -Vinny DiDonato Webmaster, American Express Publishing http://www.amexpub.com 212.382.5861 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating a CSV File
Took a wild guess that it might need to be currentrow instead of currentrecord. Seems to be running now. THX. -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:32 AM To: CF-Talk Subject: RE: Creating a CSV File I'm using a stored procedure which puts the results into GetDocs. I'm getting an error on: getdocs.currentrecord It says it's not a valid column. Do I somehow need to setup something to determine the current record? Or is it not providing that since it's coming from a stored procedure? Athelene -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:06 AM To: CF-Talk Subject: RE: Creating a CSV File Sorry, I forgot a couple of things ... cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfset theoutput = cfoutput query=GetDocs cfset theoutput = theoutput #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput cfset theoutput = /cfif /cfoutput-Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:02 AM To: CF-Talk Subject: RE: Creating a CSV File Store your information in a variable until you reach a certain number of records and then append it to the file. You will have a significantly reduced number of writes to the disk which is causing your slow response. Something like this: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cfset theoutput = #chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDocs.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# cfif getdocs.currentrecord mod 10 eq 0 cffile ... output = theoutput /cfif /cfoutput - Matt Small -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 10:31 AM To: CF-Talk Subject: Creating a CSV File I have created a CF page which uses CFFILE to read data from a table and create a .csv file from that data. It works. The problem is that it is very slow. Is there anything I can do to create this file without having to open, append and close the file for each line? Or is there some other reason it is taking so long? I'll have about a half a million records for all the various csv's I need to create next week. Any suggestions would be very much appreciated! The code is as follows: cfset csvfile=//kcweb/firmdaily/isweb/hbimport/#rtrim(GetAuthors.AUTHOR)# _FIR ST.csv cfoutput query=GetDocs cffile action=APPEND file=#csvfile# output=#chr(34)##rtrim(GetDocs.DOCNUM)##chr(34)#,#chr(34)##rtrim(GetDoc s.VE RSION)##chr(34)#,#chr(34)##rtrim(GetDocs.FULLPATH)##chr(34)#,#chr(34)##r trim (GetDocs.DEPT)##chr(34)#,#chr(34)##rtrim(GetDocs.CATEGORY)##chr(34)#,#ch r(34 )##rtrim(GetDocs.newc1)##chr(34)#,#chr(34)##rtrim(GetDocs.newc2)##chr(34 )#,# chr(34)##rtrim(GetDocs.operator)##chr(34)#,#chr(34)##rtrim(GetDocs.editd ate) ##chr(34)#,#chr(34)##rtrim(GetDocs.edittime)##chr(34)#,#chr(34)##rtrim(G etDo cs.author)##chr(34)#,#chr(34)##rtrim(GetDocs.createdate)##chr(34)#,#chr( 34)# #rtrim(GetDocs.createtime)##chr(34)#,#rtrim(GetDocs.docname)#,#chr(34)## rtri m(GetDocs.comments)##chr(34)#,#chr(34)##rtrim(GetDocs.T_Alias)##chr(34)# ,#ch r(34)##rtrim(GetDocs.C_Alias)##chr(34)# addnewline=Yes /cfoutput __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ:
RE: Verity Index type=path
Thanks for the response - that really bites. Your solution will be difficult to implement since documents are being added to this directory all the time (web based upload). I guess I will need to count up the number of files in the directory, and when it reaches 1000 (or some cutoff), create a new directory and new verity collection? This seems like such a hack. Under normal operating situations, the files are added one at a time using CFINDEX type=file, but I wanted to build an administration tool that would purge and re-build the collection in case it got corrupted. I thought Verity was supposed to be able to support 64,000 documents per collection in the Pro version of CF4.5. We anticipate a ceiling of about 30,000 docs when all are online so I didn't anticipate a Verity problem. Anyone else with a solution/workaround/hack/suggestion? Jackson Moore [EMAIL PROTECTED] --- Original Message --- From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Cc: Sent: Fri, 29 Mar 2002 08:44:52 -0800 Subject: RE: Verity Index type=path I've run into this problem, too, and have ended up breaking the big directories into 1 or more smaller ones, with 1000 files each, and then creating a separate index for each one. A pain, I know, but it's been the only thing that worked for us. On the bright side, if you organize the directories by subject, you can allow folks to search only one index at a time... Ian -Original Message- From: Jackson Moore [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 8:40 AM To: CF-Talk Subject: Verity Index type=path I have been using Verity on a couple websites and have been pretty pleased thus far. However, I recently encountered a problem when trying to index a large directory. (This is the Verity that comes with CF4.5 - not the new CF5 version). I have a directory with 5740 files in it - all Microsoft Word 97 documents. When I create a new collection and use CFINDEX to index the documents, it doesn't add all 5740 documents and it isn't even consistent. Sometimes it will add 5728, 5732, 5735, 5736 - never all 5740. I'm using the following CFINDEX code: cfindex collection=pnpworking2 action=update type=path key=e:\inetpub\wwwroot\websitename\documents\pnp\working\ extensions=.doc,.xls,.ppt,.pdf I'm confirming the number of files added, by searching for a keyword and outputting #search.RECORDSSEARCHED#. I have also tried using the CF Administrator to index the directory and get the SAME results. If I start with a new collection and use CFDIRECTORY to get a listing of the files in the directory and then loop over them one by one adding them to the collection using CFINDEX and type=file, the server times out before finishing - I've let it run for 30 minutes. In other places I use Verity, I don't have more than 1000 files in a single directory, and I do not have this problem. Questions: 1. Is there a limit to the number of files Verity can index in a single directory? 2. Maybe all the files are getting indexed, but the .RECORDSSEARCHED is incorrect? 3. I considered that it may be an issue where Verity can't access a document if its in use by another process, but I made a copy of the directory and moved it somewhere else on the server and am still having the same problem. Are there other possible services that could access these files (preventing Verity from indexing them) I need to be aware of? (Platform NT4Sp6a/IIS4/CF4.5.1SP2) Thanks for any help you can provide, Jackson Moore [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SOT: Like vs. =
On 3/29/02, Tony Schreiber penned: While I know that like is always slower, consider this: WHERE left(description,1) = 'A' OR WHERE description LIKE 'A%' Which would be faster? The first one would be faster. But only because it wouldn't return any records. ;) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Win 2k patch question
Is there an easy way to tell what patches have been applied to a Win 2k server? I want to make sure I have everything I need on it but know of the best way to check. Use HFNetChk, a free command-line tool available from Microsoft. Look for it at http://www.microsoft.com/technet/security/. I concur. I do checks on both Windows Update and with HFNetChk, and find that HFNetChk will come back with critical patches that don't ever get listed on the Windows Update site. It's a great little tool, and extremely easy to run. Regards, Dave. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF not writing client cookie
On 3/29/02, [EMAIL PROTECTED] penned: for some strange reason CF is not writing the client cookie to the user. I have setclientcookie=yes in the cfapplication tag. what could be wrong? First, it's setclientcookies with an S, but I presume that is just a typo. If you are using a cflocation tag on the pages, the cookies won't be set (is that true with client cookies?). But it should be set on the next page, as long as the cfapplication tag is still loading in that page through application.cfm or whatnot. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SOT: Like vs. =
Got to ask, Why wouldn't it return any records? Jerry Johnson [EMAIL PROTECTED] 03/29/02 11:59AM On 3/29/02, Tony Schreiber penned: While I know that like is always slower, consider this: WHERE left(description,1) = 'A' OR WHERE description LIKE 'A%' Which would be faster? The first one would be faster. But only because it wouldn't return any records. ;) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
HAPPY EASTER!!!
I am working from 6am this morning until tomorrow about 4pm, but I am taking Sunday off (Day Off WOOO HOO!!). Everybody have a Happy Easter!!! Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: DHTML Layers
Whoops, misread your question. I had thought you meant that select boxes were rendering underneath other form elements. Anyhow, you can use Flash as other people suggested. Java applets also render above everything else. I know that in IE5.5 and above, there's a way to create special menus that also override everything. Too bad MS's site is such a bear to find information in, or else I'd send you a link. - Original Message - From: Rick Walters [EMAIL PROTECTED] Date: Friday, March 29, 2002 9:12 am Subject: RE: DHTML Layers The layering problem is happening in IE. Thanks for the suggestions guys. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/29/02 10:58AM You need to set the z-index property on your layers. Sounds like you're using Netscape for this, as in IE the select boxes are system object and thus override everything else on the screen. -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 8:45 AM To: CF-Talk Subject: DHTML Layers Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SOT: Like vs. =
Not necessarily. Using a scalar function on the column name renders indexes useless. On the other hand, doing a like clause where the value is something like a% and not %a% will use the index (if there is one) on that column. - Original Message - From: Bud [EMAIL PROTECTED] Date: Friday, March 29, 2002 9:59 am Subject: Re: SOT: Like vs. = On 3/29/02, Tony Schreiber penned: While I know that like is always slower, consider this: WHERE left(description,1) = 'A' OR WHERE description LIKE 'A%' Which would be faster? The first one would be faster. But only because it wouldn't return any records. ;) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
REPOST: Re: CDONTS and ReplyTo
Actually, why don't you just use an ASP page to send your mail via CDONTS rather than going thru the CF Server? It should be more efficient since CDONTS is intrinsic to IIS. My 2 cents. Your page would then be similar to this: '-Send Email dim objMail Set objMail = Server.CreateObject(CDONTS.NewMail) If err.number0 then% bError Occured: /bBR Error Number=%=err.number%br Error Descr%=err.description%br Help Context=%=err.helpcontext%br Help Path=%=err.helppath%br Native Error=%=err.nativeerror%br Source=%=err.source%brP % Else objMail.BodyFormat = 0 objMail.MailFormat = 0 objMail.From = strEmail objMail.To = strToEmail objMail.Subject = Contact Form from strName objMail.Body = strContents objMail.Send Set objMail = Nothing End If % - Original Message - From: Dave Jones To: CF-Talk Sent: Thursday, March 28, 2002 11:29 AM Subject: CDONTS and ReplyTo Can someone tell me how to set the Reply-To header when using CDONTS in ColdFusion? These assignments do NOT work: cfset objNewMail.ReplyTo = [EMAIL PROTECTED] cfset objNewMail.Reply_To = [EMAIL PROTECTED] cfset objNewMail.Value(Reply-To) = [EMAIL PROTECTED] Thanks, Dave Jones NetEffect __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: REPOST: Re: CDONTS and ReplyTo
i don't know if that's entirely correct. is ASP more efficient at creating/manipulating objects than CF? that's all the calls do, at the base level. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 12:30 PM To: CF-Talk Subject: REPOST: Re: CDONTS and ReplyTo Actually, why don't you just use an ASP page to send your mail via CDONTS rather than going thru the CF Server? It should be more efficient since CDONTS is intrinsic to IIS. My 2 cents. Your page would then be similar to this: '-Send Email dim objMail Set objMail = Server.CreateObject(CDONTS.NewMail) If err.number0 then% bError Occured: /bBR Error Number=%=err.number%br Error Descr%=err.description%br Help Context=%=err.helpcontext%br Help Path=%=err.helppath%br Native Error=%=err.nativeerror%br Source=%=err.source%brP % Else objMail.BodyFormat = 0 objMail.MailFormat = 0 objMail.From = strEmail objMail.To = strToEmail objMail.Subject = Contact Form from strName objMail.Body = strContents objMail.Send Set objMail = Nothing End If % - Original Message - From: Dave Jones To: CF-Talk Sent: Thursday, March 28, 2002 11:29 AM Subject: CDONTS and ReplyTo Can someone tell me how to set the Reply-To header when using CDONTS in ColdFusion? These assignments do NOT work: cfset objNewMail.ReplyTo = [EMAIL PROTECTED] cfset objNewMail.Reply_To = [EMAIL PROTECTED] cfset objNewMail.Value(Reply-To) = [EMAIL PROTECTED] Thanks, Dave Jones NetEffect __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: REPOST: Re: CDONTS and ReplyTo
i don't know if that's entirely correct. is ASP more efficient at creating/manipulating objects than CF? that's all the calls do, at the base level. In general, it's certainly easier to work with COM interfaces in ASP compared to CF, with all the clunkiness in CFOBJECT. 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SOT: Like vs. =
If you mean because I was using a CF-looking function, that's only because I was to lazy to look up the string function in oracle. ;) On 3/29/02, Tony Schreiber penned: While I know that like is always slower, consider this: WHERE left(description,1) = 'A' OR WHERE description LIKE 'A%' Which would be faster? The first one would be faster. But only because it wouldn't return any records. ;) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SOT: Like vs. =
Bud wrote: On 3/29/02, Tony Schreiber penned: While I know that like is always slower, consider this: WHERE left(description,1) = 'A' OR WHERE description LIKE 'A%' Which would be faster? The first one would be faster. But only because it wouldn't return any records. ;) Apart from the fact that it does return records in some databases, the amount of records returned is absolutely irrelevant in most databases (when the number isn't huge). What matters is the type of query execution plan you get (index scan vs. full table scan) vs. the best possible plan and the amount of calculations that are required for each step. What you need to ask yourself in optimizing queries is what would be the most efficient way for the database to handle the query. Would that be an index scan or a full table scan. Can I create the circumstances in which an index scan is faster? Can I create the circumstances in which a table scan is faster? For instance, with long rows or a clustered table an index scan is usually faster because it requires less (expensive) trips to the harddisk to get the data. But if the rows you want to get are so well dispersed through the table and are so short that when reading only the blocks you want the entire table is read anyway a full table scan is faster. Unless ofcourse you have created an index on left(description,1) in which case the left function doesn't have to be executed at each row and the index becomes faster again. Reading up on the performance tuning docs of your database is an absolute necessity to answer these questions. There is no one-line answer to the question that was asked the way it was asked. Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SOT: Like vs. =
turn on debugging test and find out. On Fri, 29 Mar 2002, Tony Schreiber wrote: While I know that like is always slower, consider this: WHERE left(description,1) = 'A' OR WHERE description LIKE 'A%' Which would be faster? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: REPOST: Re: CDONTS and ReplyTo
i agree. asp is designed as a COM wrapper. however, i wasn't asking ease of coding. i was asking efficiency of the scripting engine in regards to instantiating/manipulating objects. i'd lean toward ASP being more effient in that regard, as well (after all, it was designed to do that). i was just asking if anyone had empirical evidence. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 12:47 PM To: CF-Talk Subject: RE: REPOST: Re: CDONTS and ReplyTo i don't know if that's entirely correct. is ASP more efficient at creating/manipulating objects than CF? that's all the calls do, at the base level. In general, it's certainly easier to work with COM interfaces in ASP compared to CF, with all the clunkiness in CFOBJECT. 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Process locking file
I have a file on an NT/4 server that I can't delete. I get an error saying that the file is locked by a process. I know I can reboot the server and delete the file but I really need to know what process is locking it. Is there a way to find out what process is locking the file? Thanks, Howie __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: IE and view source
I strongly suggest that you go to http://www.luckymojo.com/mojocatspells.html and purchase the following: ESSENCE OF BEND-OVER SPELL KIT: $22.00 To dominate, subjugate, and rule your lover, boss, family member, or rival. (or computer...) 1 Black Crucifix candle ($3.00 value) Essence of Bend-Over Bath Crystals ($2.50 value) Essence of Bend-Over Dressing Oil ($4.00 value) Essence of Bend-Over Incense ($2.50 value) Essence of Bend-Over Sachet Powder ($2.50 value) Packet of John the Conqueror Root Chips ($2.00 value) Packet of Calamus Root Chips ($2.00 value) Packet of Licorice Root Chips ($2.00 value) Purple Cloth Bag ($1.50 value) Complete instructions for use You might also want to consider a: FEAR NOT TO WALK OVER EVIL SPELL KIT: $34.00 Protection against the work of enemies. 9 White offertory candles ($4.50 value) Fear Not to Walk Over Evil Powder ($2.50 value) Fear Not to Walk Over Evil Incense ($2.50 value) Fear Not to Walk Over Evil Crystals ($2.50 value) Hot Foot Powder ($2.50 value) 13-Herb Bath ($2.00 value) Devil's Shoe Strings Curio ($2.00 value) Fear Not to Walk Over Evil Mojo Bag fixed with metal Skull Charm and Fear Not to Walk Over Evil Oil ($15.00 value) Complete instructions for use And, if that doesn't work, you'll definitely need: STEADY WORK SPELL KIT: $26.50 Used to get a good job, receive a raise or promotion, and prevent being laid off. 1 White Crucifix candle ($3.00 value) 2 Blue offertory candles ($1.00 value) Steady Work Bath Crystals ($2.50 value) Steady Work Incense ($2.50 value) Steady Work Sachet Powder ($2.50 value) Steady Work Mojo Bag fixed with metal Clock charm and Steady Work Dressing Oil ($15.00 value) Complete instructions for use At 11:32 AM 3/29/2002 -0500, you wrote: All of a sudden, my view source option in IE 6.0 doesn't do anything anymore. It used to show me the source in notepad, which is exactly what I want. Now it doesn't do anything. Even if I right click and view source, it doesn't do anything. Anybody have any ideas how to fix this? Thanks, Matt Small __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Like vs. =
Ran a little test, I was curious as well. This was run against a table with 10,000 records. Code is at the bottom. LIKE avg time: 52ms LEFT avg time: 55ms Using cfqueryparam for the passed in value: LIKE avg time: 5ms LEFT avg time: 34ms Matthew P. Smith Web Developer, Object Oriented ---!--- set our list to loop through --- CFSET AlphabetList = A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z cfset tickOne = getTickCount() !--- loop thourgh the alphabet list 100 times --- cfloop from=1 to=100 index=i cfloop list=#AlphabetList# index=i cfquery datasource=gots SELECT * FROMtbl_smsTitles WHERE app_full_name LIKE '#i#%' /cfquery /cfloop /cfloop cfset tickTwo = getTickCount() !--- compute and output the time it took --- cfset totalTime = int((tickTwo - tickOne)/2600) cfoutputLIKE:#totalTime#br/cfoutput cfset tickOne = getTickCount() cfloop from=1 to=100 index=i cfloop list=#AlphabetList# index=i cfquery datasource=gots SELECT * FROMtbl_smsTitles WHERE left(app_full_name,1) = '#i#' /cfquery /cfloop /cfloop cfset tickTwo = getTickCount() cfset totalTime = int((tickTwo - tickOne)/2600) cfoutputLEFT:#totalTime#br/cfoutput USING CFQUERYPARAM:br cfset tickOne = getTickCount() cfloop from=1 to=100 index=i cfloop list=#AlphabetList# index=i cfquery datasource=gots SELECT * FROMtbl_smsTitles WHERE app_full_name LIKE 'cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#i#%' /cfquery /cfloop /cfloop cfset tickTwo = getTickCount() cfset totalTime = int((tickTwo - tickOne)/2600) cfoutputLIKE:#totalTime#br/cfoutput cfset tickOne = getTickCount() cfloop from=1 to=100 index=i cfloop list=#AlphabetList# index=i cfquery datasource=gots SELECT * FROMtbl_smsTitles WHERE left(app_full_name,1) = 'cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#i#' /cfquery /cfloop /cfloop cfset tickTwo = getTickCount() cfset totalTime = int((tickTwo - tickOne)/2600) cfoutputLEFT:#totalTime#br/cfoutput -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:16 AM To: CF-Talk Subject: SOT: Like vs. = While I know that like is always slower, consider this: WHERE left(description,1) = 'A' OR WHERE description LIKE 'A%' Which would be faster? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Internationalization
don't bother its busted. BTW talking about localization, CF Studio 5 is supposed to display Unicode. Does anybody know how to enable it? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 3/14/2002 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity:Error during SetCurrentDirectory?
Hi all, I'm getting the error message Error during SetCurrentDirectory When I use this CFINDEX code: cfindex action=refresh type=Path collection=Portent recurse=Yes extensions=.pdf,.htm,.html urlpath=http://pebbles/portent_2_14_02; key=C:\inetpub\wwwroot\Portent_02_14_02 Helll?! Ian Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CDONTS and ReplyTo header
Try cfset objNewMail.To = [EMAIL PROTECTED] Dina, Thanks for the reply, but I believe this sets the To: address of the email (i.e. the address to which the email is sent). I'm trying to find a way to set the Reply-To header so that any replies to the mailing are directed to the Reply-To value rather than the From: value. Dave - Original Message - From: Dave Jones To: CF-Talk Sent: Thursday, March 28, 2002 11:29 AM Subject: CDONTS and ReplyTo Can someone tell me how to set the Reply-To header when using CDONTS in ColdFusion? These assignments do NOT work: cfset objNewMail.ReplyTo = [EMAIL PROTECTED] cfset objNewMail.Reply_To = [EMAIL PROTECTED] cfset objNewMail.Value(Reply-To) = [EMAIL PROTECTED] Thanks, Dave Jones NetEffect __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 2 Selects killing me
Well it works it just takes about 5 minutes to loadliterally and quite a few seconds when I select from the first box. What can I do to speed it up? [EMAIL PROTECTED] 03/28/02 05:52PM Can you view the source? Is it possible that you are querying too many records and the browser can't handle all of the javascript that the tag is generating? I've killed a browser or two in this manner before :) Check the recordcount... jon - Original Message - From: Michael Ross [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 4:31 PM Subject: 2 Selects killing me I am trying to use the 2 selects and it not working the page just won't load. So I know I don't have any bugs just that my query isn't running right and I am not populating the selects right here is my query. Basically I have a table with lots of records. Using the first select box I want to to show only the cpt codes from the 1st boxes list of locations. the fees table has a idnumber, the locationid, the cpt code and some other data. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Internationalization
Thanks. I kind of figured this out after looking through all the options. I was wondering why on MM site under CF Studio 5 enhancements still lists Unicode as a new feature? Are they aware of the problem? thanks Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Paul Hastings [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 29, 2002 1:45 PM Subject: Re: Internationalization don't bother its busted. BTW talking about localization, CF Studio 5 is supposed to display Unicode. Does anybody know how to enable it? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 3/14/2002 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Zipping Files
How did you get the annoying press any key to continue prompt to go away? Duane -Original Message- From: Jim Gurfein [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:57 AM To: CF-Talk Subject: RE: Zipping Files We've been using a command line .exe from winzip that does a great job. We have scheduled jobs that look like this: CFEXECUTE NAME=C:\progra~1\winzip\wzzip.exe arguments=c:\directory\filenametobewritten.zip c:\directory\filenametobezipped.txt /CFEXECUTE Works like a charm! At 09:54 AM 3/29/02 -0500, you wrote: You could grab cfx_consolecommand and run pkzip old school style. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:38 AM To: CF-Talk Subject: Zipping Files Does anyone have code or an example of zipping files? Thx, Duane __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Internationalization
I think the term you are looking for is ..localisation or localization (US). no, its internationalization (I18N). basically prepping/adapting your app to work in more than 1 locale. ms being ms refers to this as globalization (which to me actually sounds cooler). localizaton (L10N) prepping/adapting your app to work with a specific locale. in answer to the original question: how longs a piece of string? this isn't something you're going to get answered in an email --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 3/14/2002 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
