RE: Boxes instead of
Are you sure it's a regular straight down double quote? It might be one of those lovely Word left or right qoutes, I know I've had a problem with them in the past. If it is the problem, strip it out and use the regular kind, I'm sure no one will notice :O) Ade -Original Message- From: Neil H. To: CF-Talk Sent: 7/13/02 3:33 AM Subject: Re: Boxes instead of HTMLEDITFORMAT did not work :( Neil - Original Message - From: Jim Vosika [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 12, 2002 4:04 PM Subject: RE: Boxes instead of Would #htmleditformat(yourVariable)# fix it maybe? Jim Vosika Http://tinyclick.com Free URL Shortening! -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:04 PM To: CF-Talk Subject: Boxes instead of I have a strange problem in CFMX. When querying data and that data includes a displayed is a box instead of the . Anyone else see this and know how to correct it? THanks, Neil __ 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
Issue: How to Create a CSV file from a CF QUERY
Hello All: Could someone please send me some example code or a custom tag for creating a CSV file from a CF QUERY? I need to be able to have a user be able to download or email information to him or her on a request. I need to have a page that will allow a user to extract information from a SQL7 table in CSV format and they should either be able to download this live data when they click a link or be able to enter there email address and the cfm will query the live information in the table produce a csv file and then email the user the information as an attachment. That latter would be preferred. Thanks in advance, James Blaha 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 but important re Verisign taking over the world of Secondary Domain Name Services!
Matt Liotta wrote: That's assuming the remaining 10% don't get a clue! I expect that the DNS of my ISP will be *in* the remaining 10% :( Guess I can always set up my own DNS in that case... Jochem __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Boxes instead of
I agree with Ade, I've had this problem several times before and it is always an 8-bit character issue, be it curly quotes or an em-dash or a curly apostrophe. There easy to miss too, the problem is only on HTML output, so looking in the DB won't really help. John on 7/13/02 2:53 AM, Adrian Lynch at [EMAIL PROTECTED] most eloquently stated: Are you sure it's a regular straight down double quote? It might be one of those lovely Word left or right qoutes, I know I've had a problem with them in the past. If it is the problem, strip it out and use the regular kind, I'm sure no one will notice :O) Ade -Original Message- From: Neil H. To: CF-Talk Sent: 7/13/02 3:33 AM Subject: Re: Boxes instead of HTMLEDITFORMAT did not work :( Neil - Original Message - From: Jim Vosika [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 12, 2002 4:04 PM Subject: RE: Boxes instead of Would #htmleditformat(yourVariable)# fix it maybe? Jim Vosika Http://tinyclick.com Free URL Shortening! -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:04 PM To: CF-Talk Subject: Boxes instead of I have a strange problem in CFMX. When querying data and that data includes a displayed is a box instead of the . Anyone else see this and know how to correct it? THanks, Neil __ 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: CFMX / Client Variables
At 06:57 PM 7/12/2002 -0400, you wrote: I hadn't really started messing around with client variables until just recently. So... I have this WDDX packet inside a client variable and storage is in a database rather than cookie or registry based. I know I've read a lot of things that basically said, becareful with cflocation and client variables, but honestly -- I have an app that uses client variables and I have a the value of a createUUID() inside a wddx packet ... and, it's not changing - even after doing a cflocation, I'm not losing my client variables. Am I lulling myself into a false sense of security here or ... is this fixed in cfmx? or ..? I think that you are confusing client variables with cookie variables. Cookies are on client side, and cflocation is server side. If you use cflocation on a page that sets / changes cookies, then the cookies code will never be sent to the browser and therefore will never be set. So, my question is.. are you storing client variables as cookies? If you are not, then you will have no problems. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Phone: 1-203-379-0773 -- My CFMX Book: http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com __ 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
Avoiding another trip to the database
Hello, I'm new to CF and trying to figure this out. I have a dynamic select on a form where a user can choose an address type. ie. default, ship to, bill to.. etc. based on a query to the address table. When the user selects an address type, I would like to populate street, city, st and zip form input values from the address table based on the users selection BUT I don't want to reload the form. Is this possible using javascript with the query array? I think it should be but I'm stumped. Thanks, Dave Fafard __ 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: Querying 1 million records
I think the answers are yes and no. ColdFusion should have no problems querying against 1 million records. If you want to query from one DB and insert into another DB, I have to wonder if ColdFusion is the best tool for the job. If you are on SQL Server, look into using DTS. I am sure that Oracle / Sybase have a similar functionality. At 06:16 PM 7/12/2002 -0700, you wrote: Im going to have to deal with some large amounts of data, queries that select 1 million records. Is this something CF should be able to handle? (CF5 on win2000 with 512 RAM) One thing I want to do is query one DB and insert recs to another DB, approx. 1 million recs. Thanks for any advice, Jeff __ 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: CFMX / Client Variables (SOLVED)
Well, regardless if I am talking about Client Var or Cookies... the CFServer still has to assign you a CFTOKEN/CFID pair value in the form of a cookie (or, URLTOKEN) for Client Vars to stick. If you read below, I mention that storage is in a db, rather than cookie or registry. I have all the info I need now... everything's working for me, I just wanted to know what all the issues were and as long as I'm giving the application time to assign the browser the cftoken/cfid pair before I start bouncing them all over the server, I'm fine. My app works fine, I haven't had any problems. Thanks, ~Todd At 08:56 AM 7/13/2002 -0400, you wrote: At 06:57 PM 7/12/2002 -0400, you wrote: I hadn't really started messing around with client variables until just recently. So... I have this WDDX packet inside a client variable and storage is in a database rather than cookie or registry based. I know I've read a lot of things that basically said, becareful with cflocation and client variables, but honestly -- I have an app that uses client variables and I have a the value of a createUUID() inside a wddx packet ... and, it's not changing - even after doing a cflocation, I'm not losing my client variables. Am I lulling myself into a false sense of security here or ... is this fixed in cfmx? or ..? I think that you are confusing client variables with cookie variables. Cookies are on client side, and cflocation is server side. If you use cflocation on a page that sets / changes cookies, then the cookies code will never be sent to the browser and therefore will never be set. So, my question is.. are you storing client variables as cookies? If you are not, then you will have no problems. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Phone: 1-203-379-0773 -- My CFMX Book: http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com __ 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: Avoiding another trip to the database
Look into fusionscript. http://www.fusionscript.com HTH, Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 7:54 AM To: CF-Talk Subject: Avoiding another trip to the database Hello, I'm new to CF and trying to figure this out. I have a dynamic select on a form where a user can choose an address type. ie. default, ship to, bill to.. etc. based on a query to the address table. When the user selects an address type, I would like to populate street, city, st and zip form input values from the address table based on the users selection BUT I don't want to reload the form. Is this possible using javascript with the query array? I think it should be but I'm stumped. Thanks, Dave Fafard __ 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
Best way to implement multiple username/password for same datasou rce?
We access DB2 on OS/390 using DB2 Connect v5.2 and v7.2. Our DB2 Connect guys will install only one datasource for each DB2 database. This was not a problem when we had only one application accessing each database - we just put the application username/password in CF Administrator. Now we have multiple applications, each with its own username/password, that need to share the same datasources so we cannot put the username/password in CF Administrator. One solution is to specify the appropriate username/password in each application's Application.cfm file, but of course this exposes the username/password and is a security breach. How can we get around this? If we have multiple applications, each of which needs to use the same datasource, but each with its own username/password for access to the datasource, how can we pass the appropriate username/password while not exposing them? We're running CF 5.0 on Win2000 Advanced Server, IIS 5.0. Thanks! George [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Avoiding another trip to the database
Here is one I use, maybe you can gain some insight into it SCRIPT LANGUAGE=javascript !-- CFOUTPUT var NEW_ADDRESS_INDEX = #get_cust_shipping_info.recordCount# + 1; /CFOUTPUT var cust_shipping = new Array() cfoutput query=get_cust_shipping_info cust_shipping[#currentrow#] = new cust_ship_obj(#custNum#,#id#,#loc_desc#,#f_name#,#l_name#,#address_ 1#,#city#,#state#,#zip_code#,#phone_1#,#ext_1#,#email#,#isDefaul t#); /cfoutput CFOUTPUT cust_shipping[NEW_ADDRESS_INDEX] = new cust_ship_obj(#get_cust_shipping_info.custNum#,, ,,); /CFOUTPUT function cust_ship_obj(custNum,id,loc_desc,f_name,l_name,address_1,city,state,zip_code, phone_1,ext_1,email,isDefault){ this.custNum = custNum; this.id = id; this.loc_desc = loc_desc; this.f_name = f_name; this.l_name = l_name; this.address_1 = address_1; this.city = city; this.state = state; this.zip_code = zip_code; this.phone_1 = phone_1; this.ext_1 = ext_1; this.email = email; this.isDefault = isDefault; } function get_cust_info(id){ var selected_address = document.forms[0].choose[document.forms[0].choose.selectedIndex].value; if ( ( selected_address == new ) || ( selected_address == none ) ) var i = NEW_ADDRESS_INDEX; else{ for (var i = 1; i = cust_shipping.length - 1; i++) { if (cust_shipping[i].id == selected_address) { break; } } } document.forms[0].id.value = cust_shipping[i].id; document.forms[0].loc_desc.value = cust_shipping[i].loc_desc; document.forms[0].f_name.value = cust_shipping[i].f_name; document.forms[0].l_name.value = cust_shipping[i].l_name; document.forms[0].address_1.value = cust_shipping[i].address_1; document.forms[0].city.value = cust_shipping[i].city; document.forms[0].state.value = cust_shipping[i].state; document.forms[0].zip_code.value = cust_shipping[i].zip_code; document.forms[0].phone_1.value = cust_shipping[i].phone_1; document.forms[0].ext_1.value = cust_shipping[i].ext_1; document.forms[0].email.value = cust_shipping[i].email; } /script Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: David Fafard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 13, 2002 5:53 AM Subject: Avoiding another trip to the database Hello, I'm new to CF and trying to figure this out. I have a dynamic select on a form where a user can choose an address type. ie. default, ship to, bill to.. etc. based on a query to the address table. When the user selects an address type, I would like to populate street, city, st and zip form input values from the address table based on the users selection BUT I don't want to reload the form. Is this possible using javascript with the query array? I think it should be but I'm stumped. Thanks, Dave Fafard __ 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: Issue: How to Create a CSV file from a CF QUERY
This was posted here some time ago. Sorry I don't remember who :-( CFQUERY NAME=GetDocs... SELECT '' + RTRIM(FieldA) + '' + ',' + '' + RTRIM(FieldB) + '' + ',' + '' + RTRIM(FieldC) + '' 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# __ 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: Avoiding another trip to the database
Thanks, This looks like it will work for me! Dave - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 13, 2002 11:14 AM Subject: Re: Avoiding another trip to the database Here is one I use, maybe you can gain some insight into it SCRIPT LANGUAGE=javascript !-- CFOUTPUT var NEW_ADDRESS_INDEX = #get_cust_shipping_info.recordCount# + 1; /CFOUTPUT var cust_shipping = new Array() cfoutput query=get_cust_shipping_info cust_shipping[#currentrow#] = new cust_ship_obj(#custNum#,#id#,#loc_desc#,#f_name#,#l_name#,#addres s_ 1#,#city#,#state#,#zip_code#,#phone_1#,#ext_1#,#email#,#isDefa ul t#); /cfoutput CFOUTPUT cust_shipping[NEW_ADDRESS_INDEX] = new cust_ship_obj(#get_cust_shipping_info.custNum#,, ,,); /CFOUTPUT function cust_ship_obj(custNum,id,loc_desc,f_name,l_name,address_1,city,state,zip_cod e, phone_1,ext_1,email,isDefault){ this.custNum = custNum; this.id = id; this.loc_desc = loc_desc; this.f_name = f_name; this.l_name = l_name; this.address_1 = address_1; this.city = city; this.state = state; this.zip_code = zip_code; this.phone_1 = phone_1; this.ext_1 = ext_1; this.email = email; this.isDefault = isDefault; } function get_cust_info(id){ var selected_address = document.forms[0].choose[document.forms[0].choose.selectedIndex].value; if ( ( selected_address == new ) || ( selected_address == none ) ) var i = NEW_ADDRESS_INDEX; else{ for (var i = 1; i = cust_shipping.length - 1; i++) { if (cust_shipping[i].id == selected_address) { break; } } } document.forms[0].id.value = cust_shipping[i].id; document.forms[0].loc_desc.value = cust_shipping[i].loc_desc; document.forms[0].f_name.value = cust_shipping[i].f_name; document.forms[0].l_name.value = cust_shipping[i].l_name; document.forms[0].address_1.value = cust_shipping[i].address_1; document.forms[0].city.value = cust_shipping[i].city; document.forms[0].state.value = cust_shipping[i].state; document.forms[0].zip_code.value = cust_shipping[i].zip_code; document.forms[0].phone_1.value = cust_shipping[i].phone_1; document.forms[0].ext_1.value = cust_shipping[i].ext_1; document.forms[0].email.value = cust_shipping[i].email; } /script Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: David Fafard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 13, 2002 5:53 AM Subject: Avoiding another trip to the database Hello, I'm new to CF and trying to figure this out. I have a dynamic select on a form where a user can choose an address type. ie. default, ship to, bill to.. etc. based on a query to the address table. When the user selects an address type, I would like to populate street, city, st and zip form input values from the address table based on the users selection BUT I don't want to reload the form. Is this possible using javascript with the query array? I think it should be but I'm stumped. Thanks, Dave Fafard __ 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: Best way to implement multiple username/password for same dat asou rce?
We access DB2 on OS/390 using DB2 Connect v5.2 and v7.2. Our DB2 Connect guys will install only one datasource for each DB2 database. This was not a problem when we had only one application accessing each database - we just put the application username/password in CF Administrator. Now we have multiple applications, each with its own username/password, that need to share the same datasources so we cannot put the username/password in CF Administrator. One solution is to specify the appropriate username/password in each application's Application.cfm file, but of course this exposes the username/password and is a security breach. How can we get around this? If we have multiple applications, each of which needs to use the same datasource, but each with its own username/password for access to the datasource, how can we pass the appropriate username/password while not exposing them? We're running CF 5.0 on Win2000 Advanced Server, IIS 5.0. I'm not sure exactly who you're concerned about exposing them to. If you're concerned about exposing them to end-users, that's not a likely thing anyway, since an end-user won't be able to read the source of Application.cfm. If, on the other hand, you're more concerned about exposing them to other developers on the server, well, you're probably already exposing them, since any developer will be able to get that information with a tiny bit of work unless you're using Advanced Security. However, you do have some options to make life more difficult for nosy developers, although they'll probably make your life more difficult as well. You could store this information in an encrypted file, and use a third-party package to perform the unencryption; there are many different ways you could implement something like this. Of course, the same base problem would remain - somewhere on the machine, you'd have a key to perform the unencryption, and the nosy developer would just have to find the key. So, if this is something that you're really concerned about, you'd want to not store the data persistently on the machine at all; this would essentially require you to provide the data when needed from outside the machine. For example, within Windows itself, you can configure the security account manager to require a password before startup - you'd have to enter this password to allow the machine to boot. The WebSite web server software has a similar option for protecting SSL keys. You could build something like this, but it would be a decent amount of work and may cause availability problems. However, if you're more interested in this approach, contact me offlist and we can talk about it - I can always drive up to Woodlawn. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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
Okay, this is just bizarre...
I have a program that process text order files from various Internet marketplaces (half.com, Amazon, etc.) and since last night, the script that processes the Half.com files was bombing out and causing the server to restart: Fatal,1776,07/13/02,13:43:23,,Unknown error threshold reached. Restarting service. Information,1796,07/13/02,13:43:26,,The ColdFusion Application Server started. There is no error logged in the application.log file (CF5) and the error presented to the calling page is: Request canceled or ignored by server Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Fine. After determining that the code has not changed (hasn't changed in months), I started to look at the files that I was processing. Each file is first prepped because the column names in the file have spaces (!) then are written to a temp file which is then called by CFHTTP to read it in as a query object. I suspected the first file, so I renamed the first two so they wouldn't be picked up and the script ran fine. Renamed the second to the last back and the script ran fine. Renamed the first back and the script bomb. Ok, problem file found. Looking at the data (names changed to protect the innocent.) It looks ok, nothing odd. Oh wait, one section looks like this: ORDER ID,INVOICE ID,SHIPPING METHOD,CREATE DATE,SHIP_TO NAME,ADDRESS1,ADDRESS2,CITY,STATE,ZIP,COUNTRY,TITLE,CONTRIBUTOR,FORMAT,PRICE,CODE,ITEM ID,SELLER NOTES,SHIP_TO_FIRSTNAME,SHIP_TO_LASTNAME,STOREINVID 243518165308,211950252252,Media Mail,07/12/2002 23:32,First Name,123 S. 123st St.,Apt. BBB-205,Springfield,IL,98032,USA,The Best Of The Rubble Collection Vol. 1...,Various Artists,CD,11.55,604388442126,195979304,Seller SKU: mem-604388442126-2; Product Codes: UPC:604388442126,First,Name,mem-604388442126-2 See those three periods? ...? I took those out. Saved the file and the script ran fine... HTF can three periods restart my cf server? 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 __ 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: Storing Queries in Application Scope
Using the duplicate() arent you actually creating a DEEP DUPLICATE of the structure. So you have the query in APPLICATION scope and then in REQUEST scope... taking up MEMORY? Why cant this just be done in the Request Scope and avoid LOCKING and Structure duplicates? cfquery=Request.MyNewQuery datasource=MyDB Select Field1, Field2 .. from MyTable /cfquery Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 11:34 AM To: CF-Talk Subject: Re: Storing Queries in Application Scope No reason at all. Depending on your ColdFusion version: 1) You may want to investigate the use of ColdFusions built in query cacheing as well 2) Remember to lock all access to application scope variables. I'm told that locking isn't necessary in CFMX although I expect it will be a while yet before we can consider CF 5 the acception rather than the rule. Speaking of which, if you're using application variables to store queries ( which I assume won't change often ), then you may really want to use a construct like this: cflock scope=application type=readonly timeout=10 cfset request.queryname = duplicate(application.queryname) /cflock select name=yadda cfoutput query=request.queryname option value=#request.queryname.column# #request.queryname.column2#/option /cfoutput /select The reason for this is that you generally want to limit the amount of code within the cflock whether it's exclusive or read-only, because an exclusive lock will still have to wait for all read-only locks to complete before it can begin to process its code, and if your app is chock full of cflock scope=application cfoutput query=application.myreallylargequeryicachedintheapplicationscope ... .5kb of code designed to display something from my query ... /cfoutput/cflock Then your application is going to have a tough time creating exclusive locks to set those application variables... Also, when you set a query into the application scope in an exclusive lock, don't lock around the cfquery or cfstoredproc tags ... draw the query locally, then use duplicate() to copy it to the application scope, similar to or rather inverse of the example above. You may already know a lot of this, but I think the refresher is always good. And hopefully this information may be helpful to some of the other less experienced list members as well. :) hth Isaac Dealey www.turnkey.to 954-776-0046 __ 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: Storing Queries in Application Scope
doing it that way requires trips to the database for every request. the whole point of using the application scope is to avoid this - especially for large lookup type queries. -Original Message- From: Joe Bastian [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 2:51 PM To: CF-Talk Subject: RE: Storing Queries in Application Scope Using the duplicate() arent you actually creating a DEEP DUPLICATE of the structure. So you have the query in APPLICATION scope and then in REQUEST scope... taking up MEMORY? Why cant this just be done in the Request Scope and avoid LOCKING and Structure duplicates? cfquery=Request.MyNewQuery datasource=MyDB Select Field1, Field2 .. from MyTable /cfquery Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 11:34 AM To: CF-Talk Subject: Re: Storing Queries in Application Scope No reason at all. Depending on your ColdFusion version: 1) You may want to investigate the use of ColdFusions built in query cacheing as well 2) Remember to lock all access to application scope variables. I'm told that locking isn't necessary in CFMX although I expect it will be a while yet before we can consider CF 5 the acception rather than the rule. Speaking of which, if you're using application variables to store queries ( which I assume won't change often ), then you may really want to use a construct like this: cflock scope=application type=readonly timeout=10 cfset request.queryname = duplicate(application.queryname) /cflock select name=yadda cfoutput query=request.queryname option value=#request.queryname.column# #request.queryname.column2#/option /cfoutput /select The reason for this is that you generally want to limit the amount of code within the cflock whether it's exclusive or read-only, because an exclusive lock will still have to wait for all read-only locks to complete before it can begin to process its code, and if your app is chock full of cflock scope=application cfoutput query=application.myreallylargequeryicachedintheapplicationscope ... .5kb of code designed to display something from my query ... /cfoutput/cflock Then your application is going to have a tough time creating exclusive locks to set those application variables... Also, when you set a query into the application scope in an exclusive lock, don't lock around the cfquery or cfstoredproc tags ... draw the query locally, then use duplicate() to copy it to the application scope, similar to or rather inverse of the example above. You may already know a lot of this, but I think the refresher is always good. And hopefully this information may be helpful to some of the other less experienced list members as well. :) hth Isaac Dealey www.turnkey.to 954-776-0046 __ 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: Okay, this is just bizarre...
See those three periods? ...? I took those out. Saved the file and the script ran fine... HTF can three periods restart my cf server? Hi Tony, I realize this is an insane stretch, but the only thing that pops into my mind is CFMX dot-notation sensitivity -- possibly trying to set or evaluate a query column or column name ... You could always read in the data and parse it into a query manually, although it's bound to be slower than having cfhttp manually create the query. Maybe you could massage the data when you're massaging the column names so that any elipses are separated by spaces... __ 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: Storing Queries in Application Scope
Hi Joe, Yes, your assertion is absolutely correct: using duplicate to copy data between the application and request scopes does mean having 2 ( or more ) coppies of the same data taking up space in different places in memory ( though my understanding is that the request scope variable memory is freed up when the page finished processing ). It typically can be done in the request scope if you only need it on a given page, if you don't have any problems going to the database on every page that needs the data, or if you can use cached queries. The advantage to storing this information in the application scope is that it's persistent across multiple users, so you may only have to go to the database once for several dozen or hundred or so page views (even in a cflock, retreiving a query from the application scope is almost invariably faster than retreiving the data from a database), and it provides more control over the data and when it's refreshed or otherwise modified than cached queries. All that being said, it's not always the solution of choice. :) Right tool for the right job, ya know. :) Isaac www.turnkey.to 954-776-0046 Original Message --- Using the duplicate() arent you actually creating a DEEP DUPLICATE of the structure. So you have the query in APPLICATION scope and then in REQUEST scope... taking up MEMORY? Why cant this just be done in the Request Scope and avoid LOCKING and Structure duplicates? cfquery=Request.MyNewQuery datasource=MyDB Select Field1, Field2 .. from MyTable /cfquery __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Storing Queries in Application Scope
Hi Issac, Your are right as well..Right tool for the right Job. I wonder if it would be a better solution to NOT Duplicate the Structure like cflock type=readonly timeout=20 cfset Request.MyReqQuery=Application.MyQuery Note: No Duplicate or StructCopy /cflock There by only making referrence to Application scope like a POINTER since the data doesnt need to manipulated and only stored/displayed. Wouldnt this save memory space.. since u are not really creating a DEEP Copy into the 2nd structure(Request)? Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:30 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope Hi Joe, Yes, your assertion is absolutely correct: using duplicate to copy data between the application and request scopes does mean having 2 ( or more ) coppies of the same data taking up space in different places in memory ( though my understanding is that the request scope variable memory is freed up when the page finished processing ). It typically can be done in the request scope if you only need it on a given page, if you don't have any problems going to the database on every page that needs the data, or if you can use cached queries. The advantage to storing this information in the application scope is that it's persistent across multiple users, so you may only have to go to the database once for several dozen or hundred or so page views (even in a cflock, retreiving a query from the application scope is almost invariably faster than retreiving the data from a database), and it provides more control over the data and when it's refreshed or otherwise modified than cached queries. All that being said, it's not always the solution of choice. :) Right tool for the right job, ya know. :) Isaac www.turnkey.to 954-776-0046 Original Message --- Using the duplicate() arent you actually creating a DEEP DUPLICATE of the structure. So you have the query in APPLICATION scope and then in REQUEST scope... taking up MEMORY? Why cant this just be done in the Request Scope and avoid LOCKING and Structure duplicates? cfquery=Request.MyNewQuery datasource=MyDB Select Field1, Field2 .. from MyTable /cfquery __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Turn on Internal Web afterwards?
Anyone know how to turn on the Internal web server after u have installed for IIS? Stacy Young System Integration Specialist, Architecture Surefire Commerce http://www.sfcommerce.com http://www.sfcommerce.com/ (p) 514-380-2700 ext: 3234 (f) 514-380-2760 AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ 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: Printing
You know what though, I need to print to a clients printer, so I assume I will be talking JavaScript and the window.print method. I will need to print a number of letters with the dynamic name and address, similar to a mail merge. Dan -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:01 PM To: CF-Talk Subject: RE: Printing copy file.txt lpt1 is it is local or if you have captured the printer in dos to lpt1 if it is networked. I do that exact thing using cffile then exexecute. It sends it through the server to a printer that everyone works on. Joshua Tipton -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 2:58 PM To: CF-Talk Subject: Printing What is the easiest way to send a text document to a printer from CFML. I would imagine writing the file out with CFFILE and somehow initiating a DOS command such as: copy file.txt PRN Dan - Dan O'Keefe TriPoint Technologies 954.501.3115 __ 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
Counter Function
I want to do an insert into a db of a query row incremented by one? I know how to retrieve the MAX row from the db, but how do I write the function that adds 1 to the value. For example, query MAX returns a value of 1000. Then I want to CFSET newvalue = 1000 + 1 Thanks, Mark __ 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: Turn on Internal Web afterwards?
Stacy, I probably don't fully understand what you are asking here so if this answer is lame that is why. If you mean how do you start the WorldWide Web Publishing Service after installing it the default setting is usually Automatic Start, you can see this in NT or Win2K services. If you are talking of starting individual web sites inside the IIS MMC. Open the IIS MMC you can get there via Start Programs Option Pack 4 if NT or Start Control Panel Admin Tools Internet Services Manager in Win 2k. Once in look for Default Web Site if this or any others there show Stopped right click and chose Start. Hth and is not way OT for you. Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 2:25 PM To: CF-Talk Subject: Turn on Internal Web afterwards? Anyone know how to turn on the Internal web server after u have installed for IIS? Stacy Young System Integration Specialist, Architecture Surefire Commerce http://www.sfcommerce.com http://www.sfcommerce.com/ (p) 514-380-2700 ext: 3234 (f) 514-380-2760 AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ 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: Turn on Internal Web afterwards?
Sorry Mike I wasn't very clear on the original message. I want to startup the cfmx internal web server evne though I've installed for IIS...I'm figuring it must be a config file somewhere... -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 5:53 PM To: CF-Talk Subject: RE: Turn on Internal Web afterwards? Stacy, I probably don't fully understand what you are asking here so if this answer is lame that is why. If you mean how do you start the WorldWide Web Publishing Service after installing it the default setting is usually Automatic Start, you can see this in NT or Win2K services. If you are talking of starting individual web sites inside the IIS MMC. Open the IIS MMC you can get there via Start Programs Option Pack 4 if NT or Start Control Panel Admin Tools Internet Services Manager in Win 2k. Once in look for Default Web Site if this or any others there show Stopped right click and chose Start. Hth and is not way OT for you. Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 2:25 PM To: CF-Talk Subject: Turn on Internal Web afterwards? Anyone know how to turn on the Internal web server after u have installed for IIS? Stacy Young System Integration Specialist, Architecture Surefire Commerce http://www.sfcommerce.com http://www.sfcommerce.com/ (p) 514-380-2700 ext: 3234 (f) 514-380-2760 AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. __ 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: Okay, this is just bizarre...
Lets see you parsing code. Maybe that is the issue. Also what OS are you using? On Sat, 13 Jul 2002, Tony Schreiber wrote: I have a program that process text order files from various Internet marketplaces (half.com, Amazon, etc.) and since last night, the script that processes the Half.com files was bombing out and causing the server to restart: Fatal,1776,07/13/02,13:43:23,,Unknown error threshold reached. Restarting service. Information,1796,07/13/02,13:43:26,,The ColdFusion Application Server started. There is no error logged in the application.log file (CF5) and the error presented to the calling page is: Request canceled or ignored by server Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Fine. After determining that the code has not changed (hasn't changed in months), I started to look at the files that I was processing. Each file is first prepped because the column names in the file have spaces (!) then are written to a temp file which is then called by CFHTTP to read it in as a query object. I suspected the first file, so I renamed the first two so they wouldn't be picked up and the script ran fine. Renamed the second to the last back and the script ran fine. Renamed the first back and the script bomb. Ok, problem file found. Looking at the data (names changed to protect the innocent.) It looks ok, nothing odd. Oh wait, one section looks like this: ORDER ID,INVOICE ID,SHIPPING METHOD,CREATE DATE,SHIP_TO NAME,ADDRESS1,ADDRESS2,CITY,STATE,ZIP,COUNTRY,TITLE,CONTRIBUTOR,FORMAT,PRICE,CODE,ITEM ID,SELLER NOTES,SHIP_TO_FIRSTNAME,SHIP_TO_LASTNAME,STOREINVID 243518165308,211950252252,Media Mail,07/12/2002 23:32,First Name,123 S. 123st St.,Apt. BBB-205,Springfield,IL,98032,USA,The Best Of The Rubble Collection Vol. 1...,Various Artists,CD,11.55,604388442126,195979304,Seller SKU: mem-604388442126-2; Product Codes: UPC:604388442126,First,Name,mem-604388442126-2 See those three periods? ...? I took those out. Saved the file and the script ran fine... HTF can three periods restart my cf server? 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 __ 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: Counter Function
try ... IncrementValue() On Sat, 13 Jul 2002, Mark Leder wrote: I want to do an insert into a db of a query row incremented by one? I know how to retrieve the MAX row from the db, but how do I write the function that adds 1 to the value. For example, query MAX returns a value of 1000. Then I want to CFSET newvalue = 1000 + 1 Thanks, Mark __ 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: Counter Function
Mark, here's an example of how we do it, this contains info specific to the app we are using it in. cfif len(getmaxID.Max_ID) cfset caller.Max_ID = getmaxID.Max_ID + 1 cfelse cfset caller.Max_ID = 1 /cfif !--- [EMAIL PROTECTED] Inserts UID pulled created from the getmaxid result set and incremented--- cfquery name=qaddhistory datasource=#request.DSN# update #request.TBCR#.TBCOO4 set INT_VALUE = #caller.Max_ID#, LAST_USERID = '#Trim(UCase(Session.UUID))#', LAST_TIME = CURRENT TIMESTAMP /cfquery Hth. Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 2:42 PM To: CF-Talk Subject: Counter Function I want to do an insert into a db of a query row incremented by one? I know how to retrieve the MAX row from the db, but how do I write the function that adds 1 to the value. For example, query MAX returns a value of 1000. Then I want to CFSET newvalue = 1000 + 1 Thanks, Mark __ 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: Counter Function
Mark, First - let the DB do the work for you. If you are using access, MS SQL or MySQL there is a column type with a property that does this for you. In the case of access its called autonumber (or counter if you are doing DDL), in the case of Mssql it's an identity property that you set in EM (or w/ ddl it's ...myColumn int identity(1,1) ), and with MySQL I believe it's called an autoincrement (not sure on that one). When you do the insert you insert into all the columns EXCEPT the identity column - then you can retrieve it for as the PK value of your new record. Here's an MSSQL example: Create table myTable (tb_id int identity(1,1), col1 char(10), col2 char(20) col3 smalldatetime) cfquery name=Put datasource=mydsn Insert into myTable (col1, col2, col3) values ('hello', 'world', getdate()) SELECT @@Identity AS new_id /cfquery Your database now contains 1, hello, world, 07/12/2002 The value of #Put.New_id# is 1 If you don't have an option of this special type of column property then you are going to do as you expected. cfquery name=getNewID datasource=myDsn SELECT MAX(tb_id) + 1 AS new_id /cfquery cfquery name=Put datasource=mydsn Insert into myTable (tb_id, col1, col2, col3) values (#getNewId.new_id#, 'hello', 'world', getdate()) /cfquery hope this helps. good luck -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:42 PM To: CF-Talk Subject: Counter Function I want to do an insert into a db of a query row incremented by one? I know how to retrieve the MAX row from the db, but how do I write the function that adds 1 to the value. For example, query MAX returns a value of 1000. Then I want to CFSET newvalue = 1000 + 1 Thanks, Mark __ 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: RE: Storing Queries in Application Scope
This wouldn't work. If you're just doing a declarative, then you're only making a reference to the application query. Which means that you're still accessing the application query even if you're using the request scope. -Original Message- From: Joe Bastian [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 3:09 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope Hi Issac, Your are right as well..Right tool for the right Job. I wonder if it would be a better solution to NOT Duplicate the Structure like cflock type=readonly timeout=20 cfset Request.MyReqQuery=Application.MyQuery Note: No Duplicate or StructCopy /cflock There by only making referrence to Application scope like a POINTER since the data doesnt need to manipulated and only stored/displayed. Wouldnt this save memory space.. since u are not really creating a DEEP Copy into the 2nd structure(Request)? Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:30 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope Hi Joe, Yes, your assertion is absolutely correct: using duplicate to copy data between the application and request scopes does mean having 2 ( or more ) coppies of the same data taking up space in different places in memory ( though my understanding is that the request scope variable memory is freed up when the page finished processing ). It typically can be done in the request scope if you only need it on a given page, if you don't have any problems going to the database on every page that needs the data, or if you can use cached queries. The advantage to storing this information in the application scope is that it's persistent across multiple users, so you may only have to go to the database once for several dozen or hundred or so page views (even in a cflock, retreiving a query from the application scope is almost invariably faster than retreiving the data from a database), and it provides more control over the data and when it's refreshed or otherwise modified than cached queries. All that being said, it's not always the solution of choice. :) Right tool for the right job, ya know. :) Isaac www.turnkey.to 954-776-0046 Original Message --- Using the duplicate() arent you actually creating a DEEP DUPLICATE of the structure. So you have the query in APPLICATION scope and then in REQUEST scope... taking up MEMORY? Why cant this just be done in the Request Scope and avoid LOCKING and Structure duplicates? cfquery=Request.MyNewQuery datasource=MyDB Select Field1, Field2 .. from MyTable /cfquery __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
skip rows
On my page layout I would like every other row in the table to be a blank row. Does anyone have any idea how to do this. I am working with mod 2 trying to figure it out. Joshua Tipton __ 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: Storing Queries in Application Scope
Yes... the point is to avoid locking every where else.. -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 6:16 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope This wouldn't work. If you're just doing a declarative, then you're only making a reference to the application query. Which means that you're still accessing the application query even if you're using the request scope. -Original Message- From: Joe Bastian [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 3:09 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope Hi Issac, Your are right as well..Right tool for the right Job. I wonder if it would be a better solution to NOT Duplicate the Structure like cflock type=readonly timeout=20 cfset Request.MyReqQuery=Application.MyQuery Note: No Duplicate or StructCopy /cflock There by only making referrence to Application scope like a POINTER since the data doesnt need to manipulated and only stored/displayed. Wouldnt this save memory space.. since u are not really creating a DEEP Copy into the 2nd structure(Request)? Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:30 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope Hi Joe, Yes, your assertion is absolutely correct: using duplicate to copy data between the application and request scopes does mean having 2 ( or more ) coppies of the same data taking up space in different places in memory ( though my understanding is that the request scope variable memory is freed up when the page finished processing ). It typically can be done in the request scope if you only need it on a given page, if you don't have any problems going to the database on every page that needs the data, or if you can use cached queries. The advantage to storing this information in the application scope is that it's persistent across multiple users, so you may only have to go to the database once for several dozen or hundred or so page views (even in a cflock, retreiving a query from the application scope is almost invariably faster than retreiving the data from a database), and it provides more control over the data and when it's refreshed or otherwise modified than cached queries. All that being said, it's not always the solution of choice. :) Right tool for the right job, ya know. :) Isaac www.turnkey.to 954-776-0046 Original Message --- Using the duplicate() arent you actually creating a DEEP DUPLICATE of the structure. So you have the query in APPLICATION scope and then in REQUEST scope... taking up MEMORY? Why cant this just be done in the Request Scope and avoid LOCKING and Structure duplicates? cfquery=Request.MyNewQuery datasource=MyDB Select Field1, Field2 .. from MyTable /cfquery __ 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: skip rows
I am assuming your cfoutputting a cfquery in this example. cfif currentRow MOD 2 tr class or bgcolor goes here some query vars here /tr cfelse tr class or bgcolor goes here blank /tr /cfif The first iteration, currentRow will equal 1, and 1/2 leaves a remainder of 1, which is interpreted as TRUE. Basically odd rows will execute first part of if statement and even rows the second. ) hope that helps, John Ensign Programmer t: 303.839.5292 The Binary Lab inc. _ _ _ _ _ /_///| //_//_|\/_ / /_/ /_/ Denver, CO /_/// |// // | / /_ / / /_/ www.thebinarylab.com -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:19 PM To: CF-Talk Subject: skip rows On my page layout I would like every other row in the table to be a blank row. Does anyone have any idea how to do this. I am working with mod 2 trying to figure it out. Joshua Tipton __ 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: Okay, this is just bizarre...
See those three periods? ...? I took those out. Saved the file and the script ran fine... HTF can three periods restart my cf server? Hi Tony, I realize this is an insane stretch, but the only thing that pops into my mind is CFMX dot-notation sensitivity -- possibly trying to set or evaluate a query column or column name ... You could always read in the data and parse it into a query manually, although it's bound to be slower than having cfhttp manually create the query. Maybe you could massage the data when you're massaging the column names so that any elipses are separated by spaces... I'm running CF5. But even then, the dots were even within a text qualified value with the 's around it... 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 __ 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: Okay, this is just bizarre...
I'm not parsing it, I'm letting CFHTTP turn it into a query and referencing the values that way. I've learned that CFHTTP is extremely particular about the files it accepts for a query. But this in the data between double quotes! I have to assume that it's CFHTTP that chokes because the code writes the temp file just before the CFHTTP call and I can see that when it bombs the temp file just appears. But I have the CFHTTP call in a CFTRY block (because I email myself if there's a problem since this is a regularly scheduled unattended process) and nothing happens. But since the no error is written to the log and the server restarts, I shouldn't expect a throw either. ;p Lets see you parsing code. Maybe that is the issue. Also what OS are you using? On Sat, 13 Jul 2002, Tony Schreiber wrote: I have a program that process text order files from various Internet marketplaces (half.com, Amazon, etc.) and since last night, the script that processes the Half.com files was bombing out and causing the server to restart: Fatal,1776,07/13/02,13:43:23,,Unknown error threshold reached. Restarting service. Information,1796,07/13/02,13:43:26,,The ColdFusion Application Server started. There is no error logged in the application.log file (CF5) and the error presented to the calling page is: Request canceled or ignored by server Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Fine. After determining that the code has not changed (hasn't changed in months), I started to look at the files that I was processing. Each file is first prepped because the column names in the file have spaces (!) then are written to a temp file which is then called by CFHTTP to read it in as a query object. I suspected the first file, so I renamed the first two so they wouldn't be picked up and the script ran fine. Renamed the second to the last back and the script ran fine. Renamed the first back and the script bomb. Ok, problem file found. Looking at the data (names changed to protect the innocent.) It looks ok, nothing odd. Oh wait, one section looks like this: ORDER ID,INVOICE ID,SHIPPING METHOD,CREATE DATE,SHIP_TO NAME,ADDRESS1,ADDRESS2,CITY,STATE,ZIP,COUNTRY,TITLE,CONTRIBUTOR,FORMAT,PRICE,CODE,ITEM ID,SELLER NOTES,SHIP_TO_FIRSTNAME,SHIP_TO_LASTNAME,STOREINVID 243518165308,211950252252,Media Mail,07/12/2002 23:32,First Name,123 S. 123st St.,Apt. BBB-205,Springfield,IL,98032,USA,The Best Of The Rubble Collection Vol. 1...,Various Artists,CD,11.55,604388442126,195979304,Seller SKU: mem-604388442126-2; Product Codes: UPC:604388442126,First,Name,mem-604388442126-2 See those three periods? ...? I took those out. Saved the file and the script ran fine... HTF can three periods restart my cf server? 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 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX / Client Variables (SOLVED)
At 09:15 AM 7/13/2002 -0400, you wrote: Well, regardless if I am talking about Client Var or Cookies... the CFServer still has to assign you a CFTOKEN/CFID pair value in the form of a cookie (or, URLTOKEN) for Client Vars to stick. Very good point. If you read below, I mention that storage is in a db, rather than cookie or registry. Yes, I missed that originally. I have all the info I need now.. Very good! ;) -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Phone: 1-203-379-0773 -- My CFMX Book: http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com __ 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: RE: RE: Storing Queries in Application Scope
Hi Joe, The reason for using the duplicate() function to copy data between the request and application scopes is that creating a pointer to an application scope query in the request scope, i.e. cflock scope=application ... cset request.myquery = application.myquery /cflock defeats the purpose of locking the application scope, since using the pointer created in this example is still using the application scope directly and thus creates the potential for server instability as a result of application scope race conditions. You can test this in CF 5 : in the CF Administrator turn on require locking for the application scope, then use the above example and reference the query outside the lock -- CF Server responds with an error message indicating that the query contains variables in the application scope and therefore cannot be referenced without an active lock. In some cases it's better to simply reference individual variables in a cflock since you can't manipulate the pointer to a simple value directly in ColdFusion. If you need the entire contents of a query however, it's often more efficient to go ahead and use the extra memory in the request scope and let the CF Server's garbage collection handle freeing that memory up after it finishes parsing the page. Admittedly, I tend to err on the side of using more memory rather than going to the db more often, etc... The reason I do this is because memory is generally less expensive and easier to install than more processor speed, etc. Especially lately -- anyone else notice the fire-sales on RAM this year? :) Isaac www.turnkey.to 954-776-0046 Original Message --- Hi Issac, Your are right as well..Right tool for the right Job. I wonder if it would be a better solution to NOT Duplicate the Structure like cflock type=readonly timeout=20 cfset Request.MyReqQuery=Application.MyQuery Note: No Duplicate or StructCopy /cflock There by only making referrence to Application scope like a POINTER since the data doesnt need to manipulated and only stored/displayed. Wouldnt this save memory space.. since u are not really creating a DEEP Copy into the 2nd structure(Request)? Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Okay, this is just bizarre...
Yea, I knew it was an insane stretch. :) Isaac www.turnkey.to 954-776-0046 Original Message --- See those three periods? ...? I took those out. Saved the file and the script ran fine... HTF can three periods restart my cf server? Hi Tony, I realize this is an insane stretch, but the only thing that pops into my mind is CFMX dot-notation sensitivity -- possibly trying to set or evaluate a query column or column name ... You could always read in the data and parse it into a query manually, although it's bound to be slower than having cfhttp manually create the query. Maybe you could massage the data when you're massaging the column names so that any elipses are separated by spaces... I'm running CF5. But even then, the dots were even within a text qualified value with the 's around it... __ 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: RE: Printing
Hi Dan, Unfortunately afaik the closest JavaScript will let you get to actually printing a file is opening the print dialog box and then the user would have to hit the okay button to actually print the document... I believe Flash MX may have a way to go directly to the printer, so you should be able to create a very simple flash movie with a single text area which you could populate with data from the flashVars param ( up to 64k ) and then go directly to the printer. You can probably even get the Flash movie to fit 100% height and 100% width so the text would expand to fill the browser window... :) Isaac www.turnkey.to 954-776-0046 Original Message --- You know what though, I need to print to a clients printer, so I assume I will be talking JavaScript and the window.print method. I will need to print a number of letters with the dynamic name and address, similar to a mail merge. Dan -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:01 PM To: CF-Talk Subject: RE: Printing copy file.txt lpt1 is it is local or if you have captured the printer in dos to lpt1 if it is networked. I do that exact thing using cffile then exexecute. It sends it through the server to a printer that everyone works on. Joshua Tipton -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 2:58 PM To: CF-Talk Subject: Printing What is the easiest way to send a text document to a printer from CFML. I would imagine writing the file out with CFFILE and somehow initiating a DOS command such as: copy file.txt PRN Dan - Dan O'Keefe TriPoint Technologies 954.501.3115 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Storing Queries in Application Scope
You'd still need to lock with the method you suggested. -Original Message- From: Joe Bastian [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:37 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope Yes... the point is to avoid locking every where else.. -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 6:16 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope This wouldn't work. If you're just doing a declarative, then you're only making a reference to the application query. Which means that you're still accessing the application query even if you're using the request scope. -Original Message- From: Joe Bastian [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 3:09 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope Hi Issac, Your are right as well..Right tool for the right Job. I wonder if it would be a better solution to NOT Duplicate the Structure like cflock type=readonly timeout=20 cfset Request.MyReqQuery=Application.MyQuery Note: No Duplicate or StructCopy /cflock There by only making referrence to Application scope like a POINTER since the data doesnt need to manipulated and only stored/displayed. Wouldnt this save memory space.. since u are not really creating a DEEP Copy into the 2nd structure(Request)? Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:30 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope Hi Joe, Yes, your assertion is absolutely correct: using duplicate to copy data between the application and request scopes does mean having 2 ( or more ) coppies of the same data taking up space in different places in memory ( though my understanding is that the request scope variable memory is freed up when the page finished processing ). It typically can be done in the request scope if you only need it on a given page, if you don't have any problems going to the database on every page that needs the data, or if you can use cached queries. The advantage to storing this information in the application scope is that it's persistent across multiple users, so you may only have to go to the database once for several dozen or hundred or so page views (even in a cflock, retreiving a query from the application scope is almost invariably faster than retreiving the data from a database), and it provides more control over the data and when it's refreshed or otherwise modified than cached queries. All that being said, it's not always the solution of choice. :) Right tool for the right job, ya know. :) Isaac www.turnkey.to 954-776-0046 Original Message --- Using the duplicate() arent you actually creating a DEEP DUPLICATE of the structure. So you have the query in APPLICATION scope and then in REQUEST scope... taking up MEMORY? Why cant this just be done in the Request Scope and avoid LOCKING and Structure duplicates? cfquery=Request.MyNewQuery datasource=MyDB Select Field1, Field2 .. from MyTable /cfquery __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: skip rows
Hi Josh, It sounds like you just want to insert another row after each row in your query ... table cfloop query=myquery trtd#mydata#/td/tr cfif currentrow lt recordcount trtdnbsp;/td/tr /cfif /cfloop /table This would insert a blank row between all the data rows ( and not have a trailing blank row on the end )... unless I misunderstood the question. :) Isaac www.turnkey.to 954-776-0046 Original Message --- On my page layout I would like every other row in the table to be a blank row. Does anyone have any idea how to do this. I am working with mod 2 trying to figure it out. Joshua Tipton __ 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: Okay, this is just bizarre...
Lets see your code. On Sat, 13 Jul 2002, Tony Schreiber wrote: I'm not parsing it, I'm letting CFHTTP turn it into a query and referencing the values that way. I've learned that CFHTTP is extremely particular about the files it accepts for a query. But this in the data between double quotes! I have to assume that it's CFHTTP that chokes because the code writes the temp file just before the CFHTTP call and I can see that when it bombs the temp file just appears. But I have the CFHTTP call in a CFTRY block (because I email myself if there's a problem since this is a regularly scheduled unattended process) and nothing happens. But since the no error is written to the log and the server restarts, I shouldn't expect a throw either. ;p Lets see you parsing code. Maybe that is the issue. Also what OS are you using? On Sat, 13 Jul 2002, Tony Schreiber wrote: I have a program that process text order files from various Internet marketplaces (half.com, Amazon, etc.) and since last night, the script that processes the Half.com files was bombing out and causing the server to restart: Fatal,1776,07/13/02,13:43:23,,Unknown error threshold reached. Restarting service. Information,1796,07/13/02,13:43:26,,The ColdFusion Application Server started. There is no error logged in the application.log file (CF5) and the error presented to the calling page is: Request canceled or ignored by server Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Fine. After determining that the code has not changed (hasn't changed in months), I started to look at the files that I was processing. Each file is first prepped because the column names in the file have spaces (!) then are written to a temp file which is then called by CFHTTP to read it in as a query object. I suspected the first file, so I renamed the first two so they wouldn't be picked up and the script ran fine. Renamed the second to the last back and the script ran fine. Renamed the first back and the script bomb. Ok, problem file found. Looking at the data (names changed to protect the innocent.) It looks ok, nothing odd. Oh wait, one section looks like this: ORDER ID,INVOICE ID,SHIPPING METHOD,CREATE DATE,SHIP_TO NAME,ADDRESS1,ADDRESS2,CITY,STATE,ZIP,COUNTRY,TITLE,CONTRIBUTOR,FORMAT,PRICE,CODE,ITEM ID,SELLER NOTES,SHIP_TO_FIRSTNAME,SHIP_TO_LASTNAME,STOREINVID 243518165308,211950252252,Media Mail,07/12/2002 23:32,First Name,123 S. 123st St.,Apt. BBB-205,Springfield,IL,98032,USA,The Best Of The Rubble Collection Vol. 1...,Various Artists,CD,11.55,604388442126,195979304,Seller SKU: mem-604388442126-2; Product Codes: UPC:604388442126,First,Name,mem-604388442126-2 See those three periods? ...? I took those out. Saved the file and the script ran fine... HTF can three periods restart my cf server? 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 __ 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
Problem with Java Applets in CF Server 5
Hi I just rebuilt a laptop and it is running Win2k pro. I installed CF5, JDK 1.4 and Apache 2. I had to configure them to work together (with an unsupported module), and all seems to work at the CF level, but I am unable to use the File Selector Java Applets in the CF administrator (for configuring DSNs and so on). I receive an applet window with the following error (and no files are displayed): Server Error IO error on server communication I suspect this is a file/directory location, but am not sure, Any help appreciated. James Milks Noncubicle Corporation / LostHockey.com http://www.noncubicle.com http://www.losthockey.com __ 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: Problem with Java Applets in CF Server 5
James, htdocs folder, there's a folder out of place. I don't remember what it's called, but I think it has something like a folder called /Main/ and it just has ide.cfm or something in it. Move that into your /CFIDE/ folder and it'll be fixed. ~Todd At 07:56 PM 7/13/2002 -0400, you wrote: Hi I just rebuilt a laptop and it is running Win2k pro. I installed CF5, JDK 1.4 and Apache 2. I had to configure them to work together (with an unsupported module), and all seems to work at the CF level, but I am unable to use the File Selector Java Applets in the CF administrator (for configuring DSNs and so on). I receive an applet window with the following error (and no files are displayed): Server Error IO error on server communication I suspect this is a file/directory location, but am not sure, Any help appreciated. James Milks Noncubicle Corporation / LostHockey.com http://www.noncubicle.com http://www.losthockey.com __ 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: Problem with Java Applets in CF Server 5
Wow! Works great. This list never ceases to amaze me. Thanks James -Original Message- From: Todd [mailto:[EMAIL PROTECTED]] Sent: July 13, 2002 7:56 PM To: CF-Talk Subject: Re: Problem with Java Applets in CF Server 5 James, htdocs folder, there's a folder out of place. I don't remember what it's called, but I think it has something like a folder called /Main/ and it just has ide.cfm or something in it. Move that into your /CFIDE/ folder and it'll be fixed. ~Todd At 07:56 PM 7/13/2002 -0400, you wrote: Hi I just rebuilt a laptop and it is running Win2k pro. I installed CF5, JDK 1.4 and Apache 2. I had to configure them to work together (with an unsupported module), and all seems to work at the CF level, but I am unable to use the File Selector Java Applets in the CF administrator (for configuring DSNs and so on). I receive an applet window with the following error (and no files are displayed): Server Error IO error on server communication I suspect this is a file/directory location, but am not sure, Any help appreciated. James Milks Noncubicle Corporation / LostHockey.com http://www.noncubicle.com http://www.losthockey.com __ 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: Okay, this is just bizarre...
Oh speaking of which ... I saw a strange problem recently with cfhttp where a guy couldn't save data to a file with cfhttp apparently because he left off the /cfhttp end tag... again... it's a big stretch. But I figured I'd share that just in case. :) Isaac www.turnkey.to 954-776-0046 __ 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: RE: Printing
There's an excellent print server product in the Dev Exchange on Macromedia. We just used it to print to remote, networked printers at a big event and it worked like a dream. Search for print server and you should find it. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:08 PM To: CF-Talk Subject: RE: RE: Printing Hi Dan, Unfortunately afaik the closest JavaScript will let you get to actually printing a file is opening the print dialog box and then the user would have to hit the okay button to actually print the document... I believe Flash MX may have a way to go directly to the printer, so you should be able to create a very simple flash movie with a single text area which you could populate with data from the flashVars param ( up to 64k ) and then go directly to the printer. You can probably even get the Flash movie to fit 100% height and 100% width so the text would expand to fill the browser window... :) Isaac www.turnkey.to 954-776-0046 Original Message --- You know what though, I need to print to a clients printer, so I assume I will be talking JavaScript and the window.print method. I will need to print a number of letters with the dynamic name and address, similar to a mail merge. Dan -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:01 PM To: CF-Talk Subject: RE: Printing copy file.txt lpt1 is it is local or if you have captured the printer in dos to lpt1 if it is networked. I do that exact thing using cffile then exexecute. It sends it through the server to a printer that everyone works on. Joshua Tipton -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 2:58 PM To: CF-Talk Subject: Printing What is the easiest way to send a text document to a printer from CFML. I would imagine writing the file out with CFFILE and somehow initiating a DOS command such as: copy file.txt PRN Dan - Dan O'Keefe TriPoint Technologies 954.501.3115 __ 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: Counter Function
Thanks for the great suggestions :o) Thanks, Mark -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 5:59 PM To: CF-Talk Subject: RE: Counter Function Mark, First - let the DB do the work for you. If you are using access, MS SQL or MySQL there is a column type with a property that does this for you. In the case of access its called autonumber (or counter if you are doing DDL), in the case of Mssql it's an identity property that you set in EM (or w/ ddl it's ...myColumn int identity(1,1) ), and with MySQL I believe it's called an autoincrement (not sure on that one). When you do the insert you insert into all the columns EXCEPT the identity column - then you can retrieve it for as the PK value of your new record. Here's an MSSQL example: Create table myTable (tb_id int identity(1,1), col1 char(10), col2 char(20) col3 smalldatetime) cfquery name=Put datasource=mydsn Insert into myTable (col1, col2, col3) values ('hello', 'world', getdate()) SELECT @@Identity AS new_id /cfquery Your database now contains 1, hello, world, 07/12/2002 The value of #Put.New_id# is 1 If you don't have an option of this special type of column property then you are going to do as you expected. cfquery name=getNewID datasource=myDsn SELECT MAX(tb_id) + 1 AS new_id /cfquery cfquery name=Put datasource=mydsn Insert into myTable (tb_id, col1, col2, col3) values (#getNewId.new_id#, 'hello', 'world', getdate()) /cfquery hope this helps. good luck -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:42 PM To: CF-Talk Subject: Counter Function I want to do an insert into a db of a query row incremented by one? I know how to retrieve the MAX row from the db, but how do I write the function that adds 1 to the value. For example, query MAX returns a value of 1000. Then I want to CFSET newvalue = 1000 + 1 Thanks, Mark __ 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: RE: Printing
No good searching by print server... Regards, Eric J Hoffman Head Tech Geek DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 9:07 PM To: CF-Talk Subject: RE: RE: Printing There's an excellent print server product in the Dev Exchange on Macromedia. We just used it to print to remote, networked printers at a big event and it worked like a dream. Search for print server and you should find it. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:08 PM To: CF-Talk Subject: RE: RE: Printing Hi Dan, Unfortunately afaik the closest JavaScript will let you get to actually printing a file is opening the print dialog box and then the user would have to hit the okay button to actually print the document... I believe Flash MX may have a way to go directly to the printer, so you should be able to create a very simple flash movie with a single text area which you could populate with data from the flashVars param ( up to 64k ) and then go directly to the printer. You can probably even get the Flash movie to fit 100% height and 100% width so the text would expand to fill the browser window... :) Isaac www.turnkey.to 954-776-0046 Original Message --- You know what though, I need to print to a clients printer, so I assume I will be talking JavaScript and the window.print method. I will need to print a number of letters with the dynamic name and address, similar to a mail merge. Dan -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:01 PM To: CF-Talk Subject: RE: Printing copy file.txt lpt1 is it is local or if you have captured the printer in dos to lpt1 if it is networked. I do that exact thing using cffile then exexecute. It sends it through the server to a printer that everyone works on. Joshua Tipton -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 2:58 PM To: CF-Talk Subject: Printing What is the easiest way to send a text document to a printer from CFML. I would imagine writing the file out with CFFILE and somehow initiating a DOS command such as: copy file.txt PRN Dan - Dan O'Keefe TriPoint Technologies 954.501.3115 __ 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: RE: Printing
Sorry, here's the link: http://devex.macromedia.com/developer/gallery/info.cfm?ID=7417CA2C-0EC4-11D 6-83FA00508B94F85Amethod=Full It was 'printserver'. Someday they'll put a real search engine up there... -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 8:06 PM To: CF-Talk Subject: RE: RE: Printing No good searching by print server... Regards, Eric J Hoffman Head Tech Geek DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 9:07 PM To: CF-Talk Subject: RE: RE: Printing There's an excellent print server product in the Dev Exchange on Macromedia. We just used it to print to remote, networked printers at a big event and it worked like a dream. Search for print server and you should find it. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:08 PM To: CF-Talk Subject: RE: RE: Printing Hi Dan, Unfortunately afaik the closest JavaScript will let you get to actually printing a file is opening the print dialog box and then the user would have to hit the okay button to actually print the document... I believe Flash MX may have a way to go directly to the printer, so you should be able to create a very simple flash movie with a single text area which you could populate with data from the flashVars param ( up to 64k ) and then go directly to the printer. You can probably even get the Flash movie to fit 100% height and 100% width so the text would expand to fill the browser window... :) Isaac www.turnkey.to 954-776-0046 Original Message --- You know what though, I need to print to a clients printer, so I assume I will be talking JavaScript and the window.print method. I will need to print a number of letters with the dynamic name and address, similar to a mail merge. Dan -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:01 PM To: CF-Talk Subject: RE: Printing copy file.txt lpt1 is it is local or if you have captured the printer in dos to lpt1 if it is networked. I do that exact thing using cffile then exexecute. It sends it through the server to a printer that everyone works on. Joshua Tipton -Original Message- From: Dan O'Keefe [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 2:58 PM To: CF-Talk Subject: Printing What is the easiest way to send a text document to a printer from CFML. I would imagine writing the file out with CFFILE and somehow initiating a DOS command such as: copy file.txt PRN Dan - Dan O'Keefe TriPoint Technologies 954.501.3115 __ 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