RE: How to use DLLs in CF
Well CFX is one way. Another is to use CFObject. But in that case you need to pass registration key(unique identifier) in your operating system. Which you can get it by typing REGEDIT in RUN box and finding the registration key by giving name of DLL. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: 09 December 2002 05:52 To: CF-Talk Subject: RE: How to use DLLs in CF You have to register the DLL as a cfx custom tag in the ColdFusion Adminsitrator. In CF 5 it's in the left-side menu under Server Extensions CFX Tags Then press the button labelled register c++ cfx, provide a name for the tag in the form on the following page, enter the path to the dll and press the submit changes button. At that point, you make your library calls with the tag name you registered, i.e. cfx_mylibrary ... I'm not certain, but I think the dll has to comply to COM for this to work -- which is unfortunate since MS has recently deprecated COM in favor of dot-net. I'm not at all sure but I thought you had to link the CFX libraries to the DLL for it to work in this way. Never tried it tho' so I could be wrong. Real programming makes my brain hurt. ;^) If it does work with any DLL please consider posting the success (or failure) story to the list. I'd be interested in hearing it. Yea, I've only ever done it with DLL's which were intended to be used as cfx tags, but linking the cfx library to the dll is what the cf admin step is for. But since I've never tried it with any other kind of dll and I've never written COM in C++ myself, I can't really say much about it beyond the cf admin. :) But my suspicion is it has to be a dll specifically written for COM. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
SOT: Why am I getting this every hour?
!doctype html public -//w3c//dtd html 4.0 transitional//en html For the last day or so, I've been getting Cf-List every hour, instead of the once a day delivery I'm used to.nbsp; Every edition I've received hourly is Volume 1 : Number 169.nbsp; How can I change this?nbsp; Why did it change on me to begin with?nbsp; Thanks. pPaul Campano brnbsp; brnbsp; pCF-Talk wrote: blockquote TYPE=CITECF-Talk-listnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Sun, 8 Dec 2002nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Volume 1 : Number 169 pIn this issue: pnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; RE: Batch INSERT for Oracle? brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; RE: fireworks thumbnail generator brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; How to use DLLs in CF brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; RE: fireworks thumbnail generator brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; RE: fireworks thumbnail generator p-- pDate: Sun, 8 Dec 2002 22:35:23 -0500 brFrom: Joe Eugene lt;[EMAIL PROTECTED] brSubject: RE: Batch INSERT for Oracle? brMessage-ID: lt;[EMAIL PROTECTED] pIs your query object from the same DataSource(Oracle)? brIf so.. why cant you just do... brinsert into TableName(field1, fields2) brselect field1,field2 from Tablename.. pIf its a different datasource.. u dont have an option.. pJoe p-Original Message- brFrom: Stacy Young [a href=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/a] brSent: Sunday, December 08, 2002 6:09 PM brTo: CF-Talk brSubject: Batch INSERT for Oracle? pAnyone know if this is possible? I've got a query object in cf I'd like to brdump to Oracle in one shot rather than looping over the items and performing brindividual inserts. pThanks! pAVIS IMPORTANT: br--- brLes informations contenues dans le present document et ses pieces jointes brsont strictement confidentielles et reservees a l'usage de la (des) brpersonne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez bravise que toute divulgation, distribution, copie, ou autre utilisation de brces informations est strictement prohibee.nbsp; Si vous avez recu ce document brpar erreur, veuillez s'il vous plait communiquer immediatement avec brl'expediteur et detruire ce document sans en faire de copie sous quelque brforme. pWARNING: br--- brThe information contained in this document and attachments is confidential brand intended only for the person(s) named above.nbsp; If you are not the brintended recipient you are hereby notified that any disclosure, copying, brdistribution, or any other use of the information is strictly prohibited. brIf you have received this document by mistake, please notify the sender brimmediately and destroy this document and attachments without making any brcopy of any kind. p~| brArchives: a href=http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4;http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4/a brSubscription: a href=http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4;http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeamp;forumid=4/a brFAQ: a href=http://www.thenetprofits.co.uk/coldfusion/faq;http://www.thenetprofits.co.uk/coldfusion/faq/a brThis list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. p-- pDate: Sun, 8 Dec 2002 22:39:57 -0500 brFrom: Mike Chambers lt;[EMAIL PROTECTED] brSubject: RE: fireworks thumbnail generator brMessage-ID: lt;00b501c29f34$a88e9eb0$0500a8c0@mesha31p pfyi, there is a updated version of this extension at the Macromedia brExchange: pa href=http://www.macromedia.com/exchange/dreamweaver/;http://www.macromedia.com/exchange/dreamweaver//a pit offers a lot more customization. pif you can't find it, shoot me an email and ill find the exact link for bryou. pmike chambers p[EMAIL PROTECTED] p -Original Message- br From: Mark A. Kruger - CFG [a href=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/a] br Sent: Sunday, December 08, 2002 10:02 PM br To: CF-Talk br Subject: RE: fireworks thumbnail generator br br br Tony, br br Go to commands--create web photo albumn in dreamweaver.nbsp; Follow the br wizard Dorothy lt;g. br br -Mark br br -Original Message- br From: Tony Weeg [a href=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/a] br Sent: Sunday, December 08, 2002 8:49 PM br To: CF-Talk br Subject: ot: fireworks thumbnail generator br br br hi all. br br good sunday evening to y'all. br does anyone know if/how fireworks can br take a directory of images, create thumbnails br and make some simple table with a set amount of br columns per row, that would link to all of those br images? i have 60 some images from my families br thanksgiving day and i need to show everyone br but i dont have the
Client Variable problem
I've got a customer that keeps getting this message on a site with client variables enabled. [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'. Any clues as to what would be causing this? I know that it's trying to write the same cfid or cftoken to the client storage database, but why wouldn't it be updating it instead of trying to insert it? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Client Variable problem - continued
OK, as I wrote before, I've got a customer that keeps getting this message on a site with client variables enabled. [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'. I went in and checked, and LastVisit was showing 11/25. I have client variables set to purge after 2 days so I don't know why that was even in there still. Now, my sequence of events is: 1) Check to see if client.initialize_session exists. If not, set it to now(). 2) If it does exist, check to see if it was set longer than X minutes ago (a hard coded app_timeout variable). If it is older than X minutes, loop through and delete all client variables. If it is within the app_timeout limit, refresh it to now(). Basically my version of sessiontimeout. 3) I check if client.rollcount is defined. If not, I set it to 1, set the cfid=#client.cfid#cftoken=#client.cftoken# querystring and a test cookie. If it is defined, I check for the cookie I set when I defined it and get rid of the cfid/cftoken in the querystring. All fine and dandy. I tried doing stuff like... cfcookie name=cfid value= expires=now cfcookie name=cftoken value= expires=now ..when I set the initial client.initialize_session, but just couldn't get rid of his cfid and cftoken cookie. The only way I could kill his cookies was to do the cfcookie thing above BEFORE the cfapplication tag. That refreshed his cookies and everything is fine. But since there is no way to programatically check if any client variables exist BEFORE the cfapplication tag, I'm not sure of how I would make sure everyone starts with a fresh set of cookies at the beginning of a session. So, my questions are: 1) What is it that would cause CF to try and insert a new record in the clientstorage database rather than updating the record that obviously exists? 2) How can I programatically delete the record from the database, especially if I don't know the client datasource name or if it's stored in the registry? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Java in CF (CFMX) - MM Drivers
Better late than never ;-) All the drivers are from DataDirect/Merant except for the mySQL driver. I believe a third-party JDBC driver would be managed just like one of the drivers included with CFMX, but I have to verify that. Phil -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 07, 2002 11:01 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers Anybody from MM Product Team can explain this? on November 24, 2002 5:24 PM Product Teams reply 2 weeks later on the Thread!. Talked to Sean and figured out this already. Anyways since you mentioned it, Are all CFMX Native Drivers DataDirect Drivers(Oracle,DB2 UDB). If you configure a Type IV Native Datasource in CMFX... Does CFMX manage connection pooling? Single Connection.. Multiple Statements? How does this work? Thanks Joe -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 4:49 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers It's throwing that error because you're trying to access the JDBC drivers in an unlicensed fashion. The DataDirect drivers are licensed for use with ColdFusion, which includes support for JSP as well as CFML, not the scenario you're describing. Phil Costa Sr. Product Manager, ColdFusion Macromedia -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 24, 2002 5:24 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers I got this partially resolved... Sean helped out.. Thanks Sean. It was a classpath problem. However after i load the drivers(macromedia.jdbc.MacromediaDriver) which is in the lib directory of your installation(eg. G:\CFusionMX\lib\macromedia_drivers.jar) and give it the connection url.. Connection con = DriverManager.getConnection(jdbc:macromedia:sqlserver://SqlServerName:1433 ,userid,Pwd); I get an Exception.. macromedia.jdbc.MacromediaDriver$InvalidLicenseException: An Enterprise license is needed to use the Macromedia JDBC Drivers on the DB2, Oracle, Sybase and Info rmix servers. I am running CFMX Enterprise version(6,0,0,48097). I have the same connection working fine in JSP Pages under CFMX. Are CFMX Enterprise drivers protected from usage in Java Applications(Console/Swing)? Anybody from MM Product Team can explain this? Joe -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 4:11 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers I can use the CFMX MM DB drivers in a JSP page..No problem. however.. i need to use it in a Java Application..tried to load the Driver.. Class.forName(macromedia.jdbc.MacromediaDriver) Keep getting ClassNotFound Error.. I put the macromedia_driver.jar in the class path.. still not loading.. Do i need to import something? What am i missing? Joe PS:Old Thread. I am just catching up on this Thread.. Isnt the idea to comply with J2EE Architecture? Model-View-Controller model etc.. Why would some want to write in-line Java..? Anyways... On Fri, 22 Nov 2002 09:09:16 -0500 Phil Costa [EMAIL PROTECTED] wrote: The decision to disallow inline java code was definitely not a cut and dry one. One reason was definitely to enforce a cleaner separation of syntax; the other, which I hadn't mentioned, was to remove some additional complexity from the parsing/compiling process. Because of the differences between typing and syntax, parsing a page that had both Java and CFML/CFScript would have been a bear. Phil -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 2:37 AM To: CF-Talk Subject: Re: Java in CF (CFMX) Thursday, November 21, 2002, 11:54:58 PM, you wrote: MT Jon Hall wrote: The case for allowing inline Java is simple, CF developers can use Java without having to know everything about Java. Methods and classes are easy to get. Compiling, classpath's, and understanding the lengths Java goes to, to abstract everything, etc. is not. MT Knowing just a little about a language as deep/complex as Java can MT be dangerous in a number of ways... MT It's very easy to run into errors in java if you don't understand MT how it all works (ex. trying to instantiate an interface). One of MT the overriding strengths of CF is that it offers a great deal of MT power in an easy to use/learn style. This sort of thing, IMO, goes MT against that strength. MT Mixing CFML and Java can very quickly lead to code that is horribly MT organized and difficult to follow/maintain. Obviously, anal coders MT will keep things nice and neat, but others will be mashing CFML, MT CFScript, Java, and SQL together haphazardly. MT Then there's the compatibility thing... Java lists != CF lists. MT Java arrays != CF arrays. Etc. Again, this can lead to confusion MT and cause all kinds of
Updating two fields
Hi, I need to update two fields in my database. For example, I have two fields called data1 and data2. THe below code updates only data1 field. Whats the correct syntax to also update data2 field at the same time? cfquery name=Update datasource=db dbtype=ODBC UPDATE tblField SET data1='Yes' WHERE strUsername='test' /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Updating two fields
here ya go. cfquery name=Update datasource=db dbtype=ODBC UPDATE tblField SET data1='Yes', data2='something' WHERE strUsername='test' /cfquery :) ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:22 AM To: CF-Talk Subject: Updating two fields Hi, I need to update two fields in my database. For example, I have two fields called data1 and data2. THe below code updates only data1 field. Whats the correct syntax to also update data2 field at the same time? cfquery name=Update datasource=db dbtype=ODBC UPDATE tblField SET data1='Yes' WHERE strUsername='test' /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Updating two fields
cfquery name=Update datasource=db dbtype=ODBC UPDATE tblField SET data1='Yes' , data2='Yes' WHERE strUsername='test' /cfquery WG From: FlashGuy [mailto:[EMAIL PROTECTED]] Hi, I need to update two fields in my database. For example, I have two fields called data1 and data2. THe below code updates only data1 field. Whats the correct syntax to also update data2 field at the same time? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Updating two fields
cfquery name=Update datasource=db dbtype=ODBC UPDATE tblField SET data1='Yes', data2='no' WHERE strUsername='test' /cfquery -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 8:22 AM To: CF-Talk Subject: Updating two fields Hi, I need to update two fields in my database. For example, I have two fields called data1 and data2. THe below code updates only data1 field. Whats the correct syntax to also update data2 field at the same time? cfquery name=Update datasource=db dbtype=ODBC UPDATE tblField SET data1='Yes' WHERE strUsername='test' /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Updating two fields
cfquery name=Update datasource=db dbtype=ODBC UPDATE tblField SET data1='Yes', data2='No' WHERE strUsername='test' /cfquery HTH Clint - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 09, 2002 8:22 AM Subject: Updating two fields Hi, I need to update two fields in my database. For example, I have two fields called data1 and data2. THe below code updates only data1 field. Whats the correct syntax to also update data2 field at the same time? cfquery name=Update datasource=db dbtype=ODBC UPDATE tblField SET data1='Yes' WHERE strUsername='test' /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Updating two fields
Quoting FlashGuy [EMAIL PROTECTED]: I need to update two fields in my database. For example, I have two fields called data1 and data2. THe below code updates only data1 field. Whats the correct syntax to also update data2 field at the same time? http://livedocs.macromedia.com/cfmxdocs/Developing_ColdFusion_MX_Applications_with_CFML/updateData4.jsp#1114106 http://www.mysql.com/doc/en/UPDATE.html Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Updating two fields
Good Morning, Simply use a comma to separate the next database fields/value pair and continue your list cfquery name=Update datasource=db dbtype=ODBC UPDATE tblField SET data1='Yes', data2='anothervalue' WHERE strUsername='test' /cfquery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: MS Word/CFOBJECT Help
Here is some actual code that I currently use- it's not pretty, but it does the job for CF. I'll be happy to try to answer any questions for you. Matt Small cftry cfobject action=CONNECT class=Word.Application name=objWord type=COM cfcatch cfobject action=CREATE class=Word.Application name=objWord type=COM /cfcatch /cftry cftry cfscript objDoc = objWord.Documents; newDoc = objDoc.open(#path_documents#\announcerscoresheet_#form.show#.htm); po = newDoc.PageSetup; po.Orientation = 1; po.TopMargin = 36; po.BottomMargin = 36; po.LeftMargin = 36; po.RightMargin = 36; objSecs = newDoc.Sections; objSec1 = objSecs.Item(1); objSec1Headers = objSec1.Headers; objSec1Header1 = objSec1Headers.Item(1); objRange = objSec1Header1.Range; // Set the paragraph format // Values for alignment are {0=Left,1=Center,2=Right,3=Justify} objParaFormat = objRange.ParagraphFormat; objParaFormat.Alignment = 2; // Set a right-tab at 6 inches // Tab positions are in points, where 72 points = 1 inch // Arguments to the TabStops.Add function: //Position: 6 inches * 72 points/inch = 432 points //Alignment: values include {0=Left,1=Center,2=Right} objTabStops = objParaFormat.TabStops; objTabStops.ClearAll(); objTabStops.Add(432,2); objRange.Select(); objSelection = objWord.Selection; objFont = objSelection.Font; objFont.Name = Arial; objFont.Size = 10; // Insert the page number // Page number is field type 33 // Story is unit type 6 objRange.Collapse(0); objFields = objRange.Fields; objFields.Add(objRange,33); /cfscript cflock name=printout type=exclusive timeout=300 cfscript switch (form.printer) { case 1: {objWord.ActivePrinter = #printer_princess#; break;} case 2: {objWord.ActivePrinter = #printer_lana#; break;} case 3: {objWord.ActivePrinter = #printer_3#; break;} case 4: {objWord.ActivePrinter = #printer_4#; break;} case 5: {objWord.ActivePrinter = #printer_5#; break;}} newDoc.PrintOut(); /cfscript /cflock cfscript newDoc.Close(); /cfscript cfcatch cfscript newDoc.Close(); objWord.Quit(); /cfscript cfrethrow /cfcatch /cftry Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847
RE: Client Variable problem - continued
Are you using cf5? If so, have you applied all the hotfixes? I remember one of them relates to this specific issue. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: 09 December 2002 13:40 To: CF-Talk Subject: Client Variable problem - continued OK, as I wrote before, I've got a customer that keeps getting this message on a site with client variables enabled. [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'. I went in and checked, and LastVisit was showing 11/25. I have client variables set to purge after 2 days so I don't know why that was even in there still. Now, my sequence of events is: 1) Check to see if client.initialize_session exists. If not, set it to now(). 2) If it does exist, check to see if it was set longer than X minutes ago (a hard coded app_timeout variable). If it is older than X minutes, loop through and delete all client variables. If it is within the app_timeout limit, refresh it to now(). Basically my version of sessiontimeout. 3) I check if client.rollcount is defined. If not, I set it to 1, set the cfid=#client.cfid#cftoken=#client.cftoken# querystring and a test cookie. If it is defined, I check for the cookie I set when I defined it and get rid of the cfid/cftoken in the querystring. All fine and dandy. I tried doing stuff like... cfcookie name=cfid value= expires=now cfcookie name=cftoken value= expires=now .when I set the initial client.initialize_session, but just couldn't get rid of his cfid and cftoken cookie. The only way I could kill his cookies was to do the cfcookie thing above BEFORE the cfapplication tag. That refreshed his cookies and everything is fine. But since there is no way to programatically check if any client variables exist BEFORE the cfapplication tag, I'm not sure of how I would make sure everyone starts with a fresh set of cookies at the beginning of a session. So, my questions are: 1) What is it that would cause CF to try and insert a new record in the clientstorage database rather than updating the record that obviously exists? 2) How can I programatically delete the record from the database, especially if I don't know the client datasource name or if it's stored in the registry? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
OT: MM partner solution guide
Hi list, I haven't found the newest Partner Solution Guide from Allaire/Macromedia on the MM-web-site. Can someone give me a URL to download it ? Thanks. Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
csv file question
hi all. I am finishing up a downloadable csv file for a client and was wondering if there is any way known to make a column in a csv file span two above it? like we do with tables, but in a csv file? thanks. ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Java in CF (CFMX) - MM Drivers
Phil/MM Product Team All the drivers are from DataDirect/Merant except for the mySQL driver. Are you sure about the above? What Java Type IV driver is provided with CFMX for DB2 UDB? This? http://www.datadirect-technologies.com/products/jdbc/jdbcrelhighlights.asp The above driver supports DB2 UDB for AS400(iSeries) for V5R4 and V5R1 OS Versions. I havent been able to configure this connection with CFMX..(got a Native JTOpen connection working) and i dont think AS400 DB2 UDB is supported Can you give some documentation on exactly what drivers CMFX uses(Author/Versions)? It would be very helpful to see some documentation on implementation of CFQUERY and how connection pooling works in CFMX. Thanks Joe On Mon, 9 Dec 2002 08:43:38 -0500 Phil Costa [EMAIL PROTECTED] wrote: Better late than never ;-) All the drivers are from DataDirect/Merant except for the mySQL driver. I believe a third-party JDBC driver would be managed just like one of the drivers included with CFMX, but I have to verify that. Phil -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 07, 2002 11:01 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers Anybody from MM Product Team can explain this? on November 24, 2002 5:24 PM Product Teams reply 2 weeks later on the Thread!. Talked to Sean and figured out this already. Anyways since you mentioned it, Are all CFMX Native Drivers DataDirect Drivers(Oracle,DB2 UDB). If you configure a Type IV Native Datasource in CMFX... Does CFMX manage connection pooling? Single Connection.. Multiple Statements? How does this work? Thanks Joe -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 4:49 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers It's throwing that error because you're trying to access the JDBC drivers in an unlicensed fashion. The DataDirect drivers are licensed for use with ColdFusion, which includes support for JSP as well as CFML, not the scenario you're describing. Phil Costa Sr. Product Manager, ColdFusion Macromedia -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 24, 2002 5:24 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers I got this partially resolved... Sean helped out.. Thanks Sean. It was a classpath problem. However after i load the drivers(macromedia.jdbc.MacromediaDriver) which is in the lib directory of your installation(eg. G:\CFusionMX\lib\macromedia_drivers.jar) and give it the connection url.. Connection con = DriverManager.getConnection(jdbc:macromedia:sqlserver://SqlServerName:1433 ,userid,Pwd); I get an Exception.. macromedia.jdbc.MacromediaDriver$InvalidLicenseException: An Enterprise license is needed to use the Macromedia JDBC Drivers on the DB2, Oracle, Sybase and Info rmix servers. I am running CFMX Enterprise version(6,0,0,48097). I have the same connection working fine in JSP Pages under CFMX. Are CFMX Enterprise drivers protected from usage in Java Applications(Console/Swing)? Anybody from MM Product Team can explain this? Joe -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 4:11 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers I can use the CFMX MM DB drivers in a JSP page..No problem. however.. i need to use it in a Java Application..tried to load the Driver.. Class.forName(macromedia.jdbc.MacromediaDriver) Keep getting ClassNotFound Error.. I put the macromedia_driver.jar in the class path.. still not loading.. Do i need to import something? What am i missing? Joe PS:Old Thread. I am just catching up on this Thread.. Isnt the idea to comply with J2EE Architecture? Model-View-Controller model etc.. Why would some want to write in-line Java..? Anyways... On Fri, 22 Nov 2002 09:09:16 -0500 Phil Costa wrote: The decision to disallow inline java code was definitely not a cut and dry one. One reason was definitely to enforce a cleaner separation of syntax; the other, which I hadn't mentioned, was to remove some additional complexity from the parsing/compiling process. Because of the differences between typing and syntax, parsing a page that had both Java and CFML/CFScript would have been a bear. Phil -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 2:37 AM To: CF-Talk Subject: Re: Java in CF (CFMX) Thursday, November 21, 2002, 11:54:58 PM, you wrote: MT Jon Hall wrote: The case for allowing inline Java is simple, CF developers can use Java without having to know everything about Java. Methods and classes are easy to get. Compiling, classpath's, and understanding the lengths Java goes to, to
Using cfoutput in Emails
I have used cfmail for quite some time, but I had a quick question. Is it possible to display parameters in the subject line? For instance if I wanted the subject line to be: Departure-IS Notification: Bugs Bunny, PHX, 12/14/02 Now, the first part after notification is just something that I type, but everything after that would be like cfoutput#QueryName.FieldName#/cfoutput Can I do this? Thank you, Aimee Clark Web Developer Stinson Morrison Hecker LLP 816-691-3461 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Using cfoutput in Emails
I don't think you need the CFoutputs since you're within the cfmail tag. The ## should suffice. Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 12/9/2002 10:58:58 AM I have used cfmail for quite some time, but I had a quick question. Is it possible to display parameters in the subject line? For instance if I wanted the subject line to be: Departure-IS Notification: Bugs Bunny, PHX, 12/14/02 Now, the first part after notification is just something that I type, but everything after that would be like cfoutput#QueryName.FieldName#/cfoutput Can I do this? Thank you, Aimee Clark Web Developer Stinson Morrison Hecker LLP 816-691-3461 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Using cfoutput in Emails
Defnitely.. u can do anything you want~!. BTW.. Why dont you take a minute or two and try this...! Have you tried any code? Got any errors? Joe On Mon, 9 Dec 2002 09:58:58 -0600 Clark, Aimee [EMAIL PROTECTED] wrote: I have used cfmail for quite some time, but I had a quick question. Is it possible to display parameters in the subject line? For instance if I wanted the subject line to be: Departure-IS Notification: Bugs Bunny, PHX, 12/14/02 Now, the first part after notification is just something that I type, but everything after that would be like #QueryName.FieldName# Can I do this? Thank you, Aimee Clark Web Developer Stinson Morrison Hecker LLP 816-691-3461 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Using cfoutput in Emails
Just surround your variable with #'s subject=this is the subject : #variable# Being that the subject attribute is part if a CF tag the variable will be evaluated by CF (assuming the variable exists of course). -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com We create websites that make you a hero. -Original Message- From: Clark, Aimee [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:59 AM To: CF-Talk Subject: Using cfoutput in Emails I have used cfmail for quite some time, but I had a quick question. Is it possible to display parameters in the subject line? For instance if I wanted the subject line to be: Departure-IS Notification: Bugs Bunny, PHX, 12/14/02 Now, the first part after notification is just something that I type, but everything after that would be like cfoutput#QueryName.FieldName#/cfoutput Can I do this? Thank you, Aimee Clark Web Developer Stinson Morrison Hecker LLP 816-691-3461 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Using cfoutput in Emails
IIRC, yes. Just pound them in the subject string. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Clark, Aimee [mailto:[EMAIL PROTECTED]] : Sent: Monday, December 09, 2002 10:59 AM : To: CF-Talk : Subject: Using cfoutput in Emails : : : I have used cfmail for quite some time, but I had a quick question. Is it : possible to display parameters in the subject line? For instance : if I wanted : the subject line to be: : : Departure-IS Notification: Bugs Bunny, PHX, 12/14/02 : : Now, the first part after notification is just something that I type, but : everything after that would be like : cfoutput#QueryName.FieldName#/cfoutput : : Can I do this? : : Thank you, : : Aimee Clark : Web Developer : Stinson Morrison Hecker LLP : 816-691-3461 : [EMAIL PROTECTED] : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CFC output
Does anyone have an example of a CFComponent with a function that returns HTML formatted output. Trying to write a function that performs a query based on specific arguments then outputs a select box based upon the query results as well as some of the other arguments. I'd like to make it a web service but not sure if possible. (Documentation for this stuff seems kinda limited on MM, though I might just be looking in the wrong places.) Cutter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
CF Error: The request has exceeded the allowable time limit
I keep getting the following errors for no apparent reason The request has exceeded the allowable time limit Tag: CFQUERY ..or... The request has exceeded the allowable time limit Tag: CFOUTPUT It isn't taking along time or doing anything special. Almost seems more like a connction issue from my machine to the server. How can I fix this or catch it? Thanks, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
CFTABLE to variable
I need to write some preformatted text in columns and rows. It seems like a perfect application for CFTABLE, but I need to write to a variable instead of CFOUTPUTting the data. Is there a way to get the results of CFTABLE to a variable without using CFSAVECONTENT? (I need to stay backward-compatible to CF4.5) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
CFCONTENT Problem with PDF Files
Hello, I am trying to send a PDF to the user so it loads in their browser window. The code I am using is: cfheader name=Content-type value=application/pdf cfcontent deletefile=no file=C:/Inetpub/wwwroot/cfmxdemo/itworks.pdf type=application/pdf Note: I also tried a content-type of x-application/pdf but that didn't work either. IE 5.5 SP2 just loads the PDF as plain text but Netscape 7.0 works fine and opens the Acrobat Plugin in the browser. I also tried using CFFILE to readBinary the file from the server but wasn't able to output/open the file because the binary stored in the variable could not be converted to a string. Here is the code I tried to get that to work: cffile file=C:\Inetpub\wwwroot\cfmxdemo\itworks.pdf action=readBinary variable=test cfoutput#variables.test#/cfoutput Has anyone had any luck with CFCONTENT and PDF files, especially in IE 5.5 SP2? My environment is: Windows 2000 Professional SP3, ColdFusion MX 6,0,0,48097 (Developer version), IIS 5.0. Thanks in advance. Tim Haak [EMAIL PROTECTED]
RE: CFC output
You should not directly output from the method, but should instead return a string with your output. If you are generating a complex result, which it sounds like you are, you would probably want to use cfsavecontent... cfsavecontent variable=result b#title#/bbr #foo# /cfsavecontent cfreturn result === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:46 AM To: CF-Talk Subject: CFC output Does anyone have an example of a CFComponent with a function that returns HTML formatted output. Trying to write a function that performs a query based on specific arguments then outputs a select box based upon the query results as well as some of the other arguments. I'd like to make it a web service but not sure if possible. (Documentation for this stuff seems kinda limited on MM, though I might just be looking in the wrong places.) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Inserting a record once (but sometimes writes it twice)...
Hello CF'ers... I have a page that inserts twice sometimes and does it correct (insert only once) every once in a while. I am absolutely clueless as to why. The page does have a few loops but on of the inserts is not in one and it still inserts twice. I put tests info on the screen to show me where it is and what it is doing, and it showed that it only ran the query one for each record. Here is the code..(Access 2000 DB, Windows 2000 server, CF 5) cfif myorder is 0 cfoutputHow many times do I insert into Order plus myorder is #myorder#br/cfoutput cfquery name=ins_first_ord datasource=#dsn# dbtype=ODBCinsert into order_tbl(order_cust,order_date,order_tax, order_shipping, order_total, order_comment, order_payment) values(#seslogin#,'#dt#',#form.thetax#, #form.theship#, #form.grand_total#, '#form.comments#', #form.payment#)/cfquery cfoutputShow me query 1 for orderbr insert into order_tbl(order_cust,order_date,order_tax, order_shipping, order_total, order_comment, order_payment) values(#seslogin#,'#dt#',#form.thetax#, #form.theship#, #form.grand_total#, '#form.comments#', #form.payment#)br/cfoutput !---get the key from the order record--- cfquery name=get_ord_key datasource=#dsn# dbtype=ODBCselect max(order_key) as orderkey from order_tbl where order_cust = #seslogin# and order_date = ###dt###/cfquery !---insert into cart_tbl--- cfset myorder = 1 /cfif cfloop index=item from=1 to=#cntr# cfoutputHow many times do I insert into Cart plus item is #item#br/cfoutput cfquery name=ins_cart datasource=#dsn# dbtype=ODBCinsert into cart_tbl(cart_item,cart_qty,cart_price,cart_cust,cart_order,cart_date) values(#thecart[item][5]#, #thecart[item][4]#, #replace(thecart[item][3], $, , ALL)#, #seslogin#, #get_ord_key.orderkey#, '#dt#')/cfquery cfoutputShow me the queries for the cartbr insert into cart_tbl(cart_item,cart_qty,cart_price,cart_cust,cart_order,cart_date) values(#thecart[item][5]#, #thecart[item][4]#, #replace(thecart[item][3], $, , ALL)#, #seslogin#, #get_ord_key.orderkey#, '#dt#')br/cfoutput !---clear inventory from item tbl--- cfquery name=get_the_qty datasource=#dsn# dbtype=ODBCselect item_qty_avail from item_tbl where item_key = #thecart[item][5]#/cfquery cfset new_qty = get_the_qty.item_qty_avail - thecart[item][4] cfif get_the_qty.item_qty_avail is not 0 cfquery name=del_from_item datasource=#dsn# dbtype=ODBCupdate item_tbl set item_qty_avail = #new_qty# where item_key = #thecart[item][5]#/cfquery /cfif /cfloop Here is the output How many times do I insert into Order plus myorder is 0 Show me query 1 for order insert into order_tbl(order_cust,order_date,order_tax, order_shipping, order_total, order_comment, order_payment) values(4,'12/04/02',19.60, 20.00, 284.5352, 'None', 1) How many times do I insert into Cart plus item is 1 Show me the queries for the cart insert into cart_tbl(cart_item,cart_qty,cart_price,cart_cust,cart_order,cart_date) values(2, 1, 132.99, 4, 1, '12/04/02') How many times do I insert into Cart plus item is 2 Show me the queries for the cart insert into cart_tbl(cart_item,cart_qty,cart_price,cart_cust,cart_order,cart_date) values(1, 1, 99.95, 4, 1, '12/04/02') How many times do I insert into Cart plus item is 3 Show me the queries for the cart insert into cart_tbl(cart_item,cart_qty,cart_price,cart_cust,cart_order,cart_date) values(5, 1, 12.00, 4, 1, '12/04/02') Does anyone have any ideas? Thanks Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFTABLE to variable
Simply write your own cfsavecontent. It's very easy in CF4.5. Just make a custom tag that takes thisTag.generatedContent, saves it to a variable, sets it to , and returns the content to caller.something. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:46 AM To: CF-Talk Subject: CFTABLE to variable I need to write some preformatted text in columns and rows. It seems like a perfect application for CFTABLE, but I need to write to a variable instead of CFOUTPUTting the data. Is there a way to get the results of CFTABLE to a variable without using CFSAVECONTENT? (I need to stay backward-compatible to CF4.5) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFC output
CFC's, and especially web services, are generally considered to be used for data access or business logic, not for any type of display. However, if you are dead set on doing this, then you can just put your HTML inside the CFFUNCTION just like you would with a custom tag. You can specify output=yes in the function declaration and then you don't need to use cfoutput in your function, or you can leave output attribute off and use cfoutput in your function. Note that there is currently a bug in CFMX where html generated from a CFC is not displayed when the CFC is stored in a shared scope variable (application/session). If you want to use a web service for this, then wrap all the output inside cfsavecontent and return it as a string. HTH, Sam At 11:46 AM 12/9/2002, you wrote: Does anyone have an example of a CFComponent with a function that returns HTML formatted output. Trying to write a function that performs a query based on specific arguments then outputs a select box based upon the query results as well as some of the other arguments. I'd like to make it a web service but not sure if possible. (Documentation for this stuff seems kinda limited on MM, though I might just be looking in the wrong places.) Cutter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CFC output
It is certainly not a rule or a best practice to avoid directly outputting from a CFC method. There are plenty of good reasons for doing so and making blanket statements like yours only lead to confusion. For example... WriteOutput(someCFC.someMethod()); Where someMethod() returns a string of HTML as you specified is significantly more expensive than the following. someCFC.someMethod(); Where someMethod() directly outputs the HTML. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:05 PM To: CF-Talk Subject: RE: CFC output You should not directly output from the method, but should instead return a string with your output. If you are generating a complex result, which it sounds like you are, you would probably want to use cfsavecontent... cfsavecontent variable=result b#title#/bbr #foo# /cfsavecontent cfreturn result === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:46 AM To: CF-Talk Subject: CFC output Does anyone have an example of a CFComponent with a function that returns HTML formatted output. Trying to write a function that performs a query based on specific arguments then outputs a select box based upon the query results as well as some of the other arguments. I'd like to make it a web service but not sure if possible. (Documentation for this stuff seems kinda limited on MM, though I might just be looking in the wrong places.) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFC output
CFCs are nothing more than a language construct to encapsulate CFML. To suggest that it is wrong to use CFCs for something other than data access or business logic is wrong. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:16 PM To: CF-Talk Subject: Re: CFC output CFC's, and especially web services, are generally considered to be used for data access or business logic, not for any type of display. However, if you are dead set on doing this, then you can just put your HTML inside the CFFUNCTION just like you would with a custom tag. You can specify output=yes in the function declaration and then you don't need to use cfoutput in your function, or you can leave output attribute off and use cfoutput in your function. Note that there is currently a bug in CFMX where html generated from a CFC is not displayed when the CFC is stored in a shared scope variable (application/session). If you want to use a web service for this, then wrap all the output inside cfsavecontent and return it as a string. HTH, Sam At 11:46 AM 12/9/2002, you wrote: Does anyone have an example of a CFComponent with a function that returns HTML formatted output. Trying to write a function that performs a query based on specific arguments then outputs a select box based upon the query results as well as some of the other arguments. I'd like to make it a web service but not sure if possible. (Documentation for this stuff seems kinda limited on MM, though I might just be looking in the wrong places.) Cutter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFC output
I disagree. It's certainly not the 'end of the world', but using direct output from a method automatically means you won't be able to use the result remotely via Flash (or as a WS). Again - this isn't horrible - but it's something you should bear in mind. (And don't forget the lovely bug with CFCs stored in app/session scopes - which will be fixed of course.) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:16 AM To: CF-Talk Subject: RE: CFC output It is certainly not a rule or a best practice to avoid directly outputting from a CFC method. There are plenty of good reasons for doing so and making blanket statements like yours only lead to confusion. For example... WriteOutput(someCFC.someMethod()); Where someMethod() returns a string of HTML as you specified is significantly more expensive than the following. someCFC.someMethod(); Where someMethod() directly outputs the HTML. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:05 PM To: CF-Talk Subject: RE: CFC output You should not directly output from the method, but should instead return a string with your output. If you are generating a complex result, which it sounds like you are, you would probably want to use cfsavecontent... cfsavecontent variable=result b#title#/bbr #foo# /cfsavecontent cfreturn result == = Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:46 AM To: CF-Talk Subject: CFC output Does anyone have an example of a CFComponent with a function that returns HTML formatted output. Trying to write a function that performs a query based on specific arguments then outputs a select box based upon the query results as well as some of the other arguments. I'd like to make it a web service but not sure if possible. (Documentation for this stuff seems kinda limited on MM, though I might just be looking in the wrong places.) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFC output
I agree with Matt. Objects can exist at several levels. For example, all the Swing GUI elements are objects. So there is no problem with using an object to show text, draw a button etc. The trick is to make sure your object don't cross your tiers in a n-tier app. In a model1 app (as SUN call it [1] ) is would be fine to output your html from a cfc, where in a model2 App it wouldn't... WG [1] http://java.sun.com/blueprints/guidelines/designing_enterprise_applications_ 2e/web-tier/web-tier5.html section 4.4.1 Structuring the Web Tier I disagree. It's certainly not the 'end of the world', but using direct output from a method automatically means you won't be able to use the result remotely via Flash (or as a WS). Again - this isn't horrible - but it's something you should bear in mind. (And don't forget the lovely bug with CFCs stored in app/session scopes - which will be fixed of course.) It is certainly not a rule or a best practice to avoid directly outputting from a CFC method. There are plenty of good reasons for doing so and making blanket statements like yours only lead to confusion. For example... WriteOutput(someCFC.someMethod()); ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFC output
Always nice to have different opinions. At 12:23 PM 12/9/2002, you wrote: CFCs are nothing more than a language construct to encapsulate CFML. To suggest that it is wrong to use CFCs for something other than data access or business logic is wrong. Matt Liotta ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CFC output
Yes, but if your CFC is supposed to output HTML why would you want to call it from Flash? There are many different valid uses of CFCs and calling their functionality from Flash is only one of them and certainly isn't a requirement. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:38 PM To: CF-Talk Subject: RE: CFC output I disagree. It's certainly not the 'end of the world', but using direct output from a method automatically means you won't be able to use the result remotely via Flash (or as a WS). Again - this isn't horrible - but it's something you should bear in mind. (And don't forget the lovely bug with CFCs stored in app/session scopes - which will be fixed of course.) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:16 AM To: CF-Talk Subject: RE: CFC output It is certainly not a rule or a best practice to avoid directly outputting from a CFC method. There are plenty of good reasons for doing so and making blanket statements like yours only lead to confusion. For example... WriteOutput(someCFC.someMethod()); Where someMethod() returns a string of HTML as you specified is significantly more expensive than the following. someCFC.someMethod(); Where someMethod() directly outputs the HTML. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:05 PM To: CF-Talk Subject: RE: CFC output You should not directly output from the method, but should instead return a string with your output. If you are generating a complex result, which it sounds like you are, you would probably want to use cfsavecontent... cfsavecontent variable=result b#title#/bbr #foo# /cfsavecontent cfreturn result == = Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:46 AM To: CF-Talk Subject: CFC output Does anyone have an example of a CFComponent with a function that returns HTML formatted output. Trying to write a function that performs a query based on specific arguments then outputs a select box based upon the query results as well as some of the other arguments. I'd like to make it a web service but not sure if possible. (Documentation for this stuff seems kinda limited on MM, though I might just be looking in the wrong places.) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CF Error: The request has exceeded the allowable time limit
The request has exceeded the allowable time limit Tag: CFQUERY .or... The request has exceeded the allowable time limit Tag: CFOUTPUT It isn't taking along time or doing anything special. Almost seems more like a connction issue from my machine to the server. How can I fix this or catch it? - This means that the page you are requesting is exceeding the timeout set in the CF Administrator. You can do a couple things to resolve this: 1) Up the timeout setting in the CF Administrator 2) Assuming CF 5 and below, append RequestTimeout=xx to the URL where xx is the number of seconds to allow the page to process (which overrides the CF Admin setting). (If CFMX, the RequestTimeout setting must be made via the tag.) However, I think it goes without saying that you should look at what's going on on that page and see if you can clean the code up to improve performance (look at long running queries, looping over large recordsets, etc.). Regards, Dave. ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: csv file question
Tony: CSV is simply a text-based format for representing data. It doesn't allow for the representation of formatting. CSV is simply: Record1Data1,Record1Data2 Record2Data1,Record2Date2 etc. If you intend to send the CSV file to the web user with an Excel Mime-Type (i.e., have it open in Excel automatically), you might consider dumping the data into an HTML table instead of CSV. Later versions of Excel (don't remember when it started) are able to interpret HTML tables directly. Just set the Mime-Type to Excel and CFOUTPUT the HTML table as normal. Using HTML, you could set ROWSPAN, COLSPAN, background colors, etc. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:12 AM To: CF-Talk Subject: csv file question hi all. I am finishing up a downloadable csv file for a client and was wondering if there is any way known to make a column in a csv file span two above it? like we do with tables, but in a csv file? thanks. ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Java in CF (CFMX) - MM Drivers
We recently moved from SQL7.0 with the included MX (DataDirect/Merant) JDBC drivers, to SQL2000 with MS provided JDBC drivers and it was (aside from microsofts non-standard jdbc uri) simple. In other words believe a third-party JDBC driver would be managed just like one of the drivers included with CFMX, is true. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:44 AM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers Better late than never ;-) All the drivers are from DataDirect/Merant except for the mySQL driver. I believe a third-party JDBC driver would be managed just like one of the drivers included with CFMX, but I have to verify that. Phil -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 07, 2002 11:01 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers Anybody from MM Product Team can explain this? on November 24, 2002 5:24 PM Product Teams reply 2 weeks later on the Thread!. Talked to Sean and figured out this already. Anyways since you mentioned it, Are all CFMX Native Drivers DataDirect Drivers(Oracle,DB2 UDB). If you configure a Type IV Native Datasource in CMFX... Does CFMX manage connection pooling? Single Connection.. Multiple Statements? How does this work? Thanks Joe -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 4:49 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers It's throwing that error because you're trying to access the JDBC drivers in an unlicensed fashion. The DataDirect drivers are licensed for use with ColdFusion, which includes support for JSP as well as CFML, not the scenario you're describing. Phil Costa Sr. Product Manager, ColdFusion Macromedia -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 24, 2002 5:24 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers I got this partially resolved... Sean helped out.. Thanks Sean. It was a classpath problem. However after i load the drivers(macromedia.jdbc.MacromediaDriver) which is in the lib directory of your installation(eg. G:\CFusionMX\lib\macromedia_drivers.jar) and give it the connection url.. Connection con = DriverManager.getConnection(jdbc:macromedia:sqlserver://SqlServerName:1433 ,userid,Pwd); I get an Exception.. macromedia.jdbc.MacromediaDriver$InvalidLicenseException: An Enterprise license is needed to use the Macromedia JDBC Drivers on the DB2, Oracle, Sybase and Info rmix servers. I am running CFMX Enterprise version(6,0,0,48097). I have the same connection working fine in JSP Pages under CFMX. Are CFMX Enterprise drivers protected from usage in Java Applications(Console/Swing)? Anybody from MM Product Team can explain this? Joe -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 4:11 PM To: CF-Talk Subject: RE: Java in CF (CFMX) - MM Drivers I can use the CFMX MM DB drivers in a JSP page..No problem. however.. i need to use it in a Java Application..tried to load the Driver.. Class.forName(macromedia.jdbc.MacromediaDriver) Keep getting ClassNotFound Error.. I put the macromedia_driver.jar in the class path.. still not loading.. Do i need to import something? What am i missing? Joe PS:Old Thread. I am just catching up on this Thread.. Isnt the idea to comply with J2EE Architecture? Model-View-Controller model etc.. Why would some want to write in-line Java..? Anyways... On Fri, 22 Nov 2002 09:09:16 -0500 Phil Costa [EMAIL PROTECTED] wrote: The decision to disallow inline java code was definitely not a cut and dry one. One reason was definitely to enforce a cleaner separation of syntax; the other, which I hadn't mentioned, was to remove some additional complexity from the parsing/compiling process. Because of the differences between typing and syntax, parsing a page that had both Java and CFML/CFScript would have been a bear. Phil -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 2:37 AM To: CF-Talk Subject: Re: Java in CF (CFMX) Thursday, November 21, 2002, 11:54:58 PM, you wrote: MT Jon Hall wrote: The case for allowing inline Java is simple, CF developers can use Java without having to know everything about Java. Methods and classes are easy to get. Compiling, classpath's, and understanding the lengths Java goes to, to abstract everything, etc. is not. MT Knowing just a little about a language as deep/complex as Java can MT be dangerous in a number of ways... MT It's very easy to run into errors in java if you don't understand MT how it all works (ex. trying to instantiate an interface). One of MT the overriding strengths of CF is that it offers a great
RE: csv file question
thanks mosh. I just told the client, no it cant do that, and thanks ;) ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:35 PM To: CF-Talk Subject: RE: csv file question Tony: CSV is simply a text-based format for representing data. It doesn't allow for the representation of formatting. CSV is simply: Record1Data1,Record1Data2 Record2Data1,Record2Date2 etc. If you intend to send the CSV file to the web user with an Excel Mime-Type (i.e., have it open in Excel automatically), you might consider dumping the data into an HTML table instead of CSV. Later versions of Excel (don't remember when it started) are able to interpret HTML tables directly. Just set the Mime-Type to Excel and CFOUTPUT the HTML table as normal. Using HTML, you could set ROWSPAN, COLSPAN, background colors, etc. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:12 AM To: CF-Talk Subject: csv file question hi all. I am finishing up a downloadable csv file for a client and was wondering if there is any way known to make a column in a csv file span two above it? like we do with tables, but in a csv file? thanks. ..tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFC output
I never said it was a requirement - but rather something you should remember. In other words, not outputting and using cfreturn will work in more ways then direct outputting, I'd always rather use that just in case I do add a Flash layer to my site. As it stands, we should probably just agree to disagree. ;) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:49 AM To: CF-Talk Subject: RE: CFC output Yes, but if your CFC is supposed to output HTML why would you want to call it from Flash? There are many different valid uses of CFCs and calling their functionality from Flash is only one of them and certainly isn't a requirement. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Client Variable Problem
I am having a very odd problem with client variables and would appreciate any suggestions on additional things to look at or try. SYMPTOM: CFID increments with each subsequent page request (refresh). INDEX.CFM html head title/title /head body cfset client.test = test Hi there cfoutput#client.test#/cfoutput. /body /html APPLICATION.CFM !--- application.cfm --- cfapplication name=OESv2_STAGING clientmanagement=Yes VERSION INFO: CF 5.0.0.0, Windows 2000 SP3, IIS 5 CLIENT VARIABLE STORAGE: Uses ODBC datasource named ClientVariables_Staging which points to physical SQL 2000 database of the same name. CFDATA and CFGLOBAL tables created by CF5 Administrator upon instantiation of the ClientVariable storage. OTHER INFORMATION: There are two websites on this server, PEv2 and OESv2. Both use client variable storage. PEv2 does NOT manifest the problem. The websites use HOST HEADERS and do not have physical IP addresses. The client browsers allow cookies and have no problem with PEv2.Upon viewing OESv2 and hitting refresh, the CFID increments. For example, link to the OESv2 index.cfm page and cfid:cftoken are [CFID:CFTOKEN] [CFID:CFTOKEN] 1605:9626140. Hit refresh and these values change to [CFID:CFTOKEN] 1606:14486147. STEPS TAKEN TO TRY TO SOLVE PROBLEM: * recreated client storage database, defined new datasource, remapped client storage in CF5 Administrator * created new IIS virtual for the site, trimmed down source to bare minimum to try to isolate problem * restarted the CF5 services numerous times Any suggestions anyone has are appreciated! Thank you, Grant Szabo - This mail sent through IMP: http://horde.org/imp/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
FW: ObjectWatch Newsletter 42: J2EE versus .NET
Found this on another list, has obvious implications for CFMX in the enterprise. Thought I would share. M -Original Message- From: brian leroux [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 5:19 PM To: [EMAIL PROTECTED] Subject: FW: ObjectWatch Newsletter 42: J2EE versus .NET; The Latest Benchmark I found this article so relevant to the current situation and quite well written. Thought I'd share for those not on the objectwatch list. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: December 4, 2002 8:59 AM To: Objectwatch_Newsletter Subject: ObjectWatch Newsletter 42: J2EE versus .NET; The Latest Benchmark *** ObjectWatch Newsletter Number 42 December 3, 2002 This Issue: J2EE versus .NET; The Latest Benchmark For printing, we suggest the HTML version of this newsletter at http://www.objectwatch.com/issue_42.htm, which is usually available a few days after the emailed version. *** Sponsor Advertisement == As the ObjectWatch Newsletter grows to more than 17,000 subscribers, so grows the cost of producing this newsletter. To partially defray some of these production costs, we have decided to accept one sponsoring text advertisement per issue, approximately the size of this notice. We hope our readers understand this need, and join us in showing appreciation for our sponsor. If your company would be interested in participating in this sponsorship opportunity, contact [EMAIL PROTECTED] *** Feel free to forward this newsletter, but don't make any changes. Thanks. There are now over 17,000 subscribers to this newsletter and over 68,000 readers! For your own free email subscription, send mail to [EMAIL PROTECTED] saying: subscribe your-name, your-email For example, subscribe William Shakespeare,[EMAIL PROTECTED] To unsubscribe, send mail to [EMAIL PROTECTED] saying unsubscribe your-name, your e-mail *** CONTENTS - Quotation of the Month: J2EE Web Service Standards - Main Article: J2EE versus .NET; The Latest Benchmark - ObjectWatch Services - Letters from Very Important People: OASIS Chair responds to the ObjectWatch Newsletter #41 - Services from ObjectWatch - About ObjectWatch - Recent Issues of the ObjectWatch Newsletter *** QUOTATION OF THE MONTH: J2EE WEB SERVICE STANDARDS Many observers assume that J2EE includes support for Web services, but an examination of the 600-plus pages of the J2EE specification reveals that Web services is never specifically mentioned. Those who wish to architect solutions that include both J2EE and Web Services will have to look outside the specification for guidance. The Software Developers Web Services Report, November 2002, by Warren Keuffel The winner of the Quotation of the Month Contest is Jon R. Gribskov who gets a choice of a personally autographed copy of Roger Sessions's book, COM+ and the Battle for the Middle Tier, Roger Sessions's upcoming book, Software Fortresses; Modeling Enterprise Architectures, or the ObjectWatch BBQ apron. Send in your nominations for Quotation of the Month to [EMAIL PROTECTED], and you too can get a personally autographed book/apron! *** MAIN ARTICLE: J2EE VERSUS .NET; THE LATEST BENCHMARK Speed, to put it simply, is superfluous. Easy to say, sitting at Starbucks, surveying the diurnal drift to Dell, IBM, and other destinations downstream. Were I sitting in one of those malodorous automobiles waggling their way like overweight fish down Highway 183, I might not share this view. But I am not. I am comfortably sipping my doppio macchiato. And from this vantage point, it is clear. Nobody at Starbucks cares about speed. I don't even care about speed. There are many things I do care about: the height of the foam, the temperature of the espresso, the availability of my favorite chair. But whether it takes my personal barista, KC, one minute or five to make my doppio? Not an issue. I'll be sitting in the sun over there, thank you, just yell when it is ready. Not only do I not care about speed when drinking doppios, I don't care about it when building fortresses. Software fortresses, that is. How fast a software fortress processes a request is almost never an issue. Most competent fortress architects can design a system that is fast enough. There are many other problems that might conspire to debilitate a software fortress, but speed is rarely one of them. For those readers not up to speed (no pun intended) on the idea of software fortresses, you might want to checkout The Software
RE: Client Variable problem - continued
Hi Bud, Regarding 2) you are indeed storing cvars in a SQL Server db - you got a sql error and not a registry error :) I had a db corruption problem last week that allowed a duplicate to exist in my db, and gave me the same errmsg you got. Sounds like you do to... Since it ought to be impossible to insert two identical pk's... Unless the dba used simple indexes, or fouled up the creation of the composite-field pk for that table. Once I deleted the duplicate all was fine. I did it via my enterprise mgr (mysqlfront and mysql) and it helped a lot that my error msg specified the specific key that was messing me up. Not your answer, but maybe it's a start? --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:40 AM To: CF-Talk Subject: Client Variable problem - continued OK, as I wrote before, I've got a customer that keeps getting this message on a site with client variables enabled. [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'. I went in and checked, and LastVisit was showing 11/25. I have client variables set to purge after 2 days so I don't know why that was even in there still. Now, my sequence of events is: 1) Check to see if client.initialize_session exists. If not, set it to now(). 2) If it does exist, check to see if it was set longer than X minutes ago (a hard coded app_timeout variable). If it is older than X minutes, loop through and delete all client variables. If it is within the app_timeout limit, refresh it to now(). Basically my version of sessiontimeout. 3) I check if client.rollcount is defined. If not, I set it to 1, set the cfid=#client.cfid#cftoken=#client.cftoken# querystring and a test cookie. If it is defined, I check for the cookie I set when I defined it and get rid of the cfid/cftoken in the querystring. All fine and dandy. I tried doing stuff like... cfcookie name=cfid value= expires=now cfcookie name=cftoken value= expires=now .when I set the initial client.initialize_session, but just couldn't get rid of his cfid and cftoken cookie. The only way I could kill his cookies was to do the cfcookie thing above BEFORE the cfapplication tag. That refreshed his cookies and everything is fine. But since there is no way to programatically check if any client variables exist BEFORE the cfapplication tag, I'm not sure of how I would make sure everyone starts with a fresh set of cookies at the beginning of a session. So, my questions are: 1) What is it that would cause CF to try and insert a new record in the clientstorage database rather than updating the record that obviously exists? 2) How can I programatically delete the record from the database, especially if I don't know the client datasource name or if it's stored in the registry? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Client Variable Problem
I saw this happen on netscape browsers on CF4.5 when SETCLIENTCOOKIES=YES was placed in application.cfm, as opposed to leaving the statement out entirely. I'd look to your application.cfm. Try and put in more than the bare minimum you have now and see what happens. Maybe: cfapplication name=mytest sessionmanagement=No clientmanagement=Yes applicationtimeout=#CreateTimeSpan(0,2,0,0)# --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:22 AM To: CF-Talk Subject: Client Variable Problem I am having a very odd problem with client variables and would appreciate any suggestions on additional things to look at or try. SYMPTOM: CFID increments with each subsequent page request (refresh). INDEX.CFM html head title/title /head body cfset client.test = test Hi there cfoutput#client.test#/cfoutput. /body /html APPLICATION.CFM !--- application.cfm --- cfapplication name=OESv2_STAGING clientmanagement=Yes VERSION INFO: CF 5.0.0.0, Windows 2000 SP3, IIS 5 CLIENT VARIABLE STORAGE: Uses ODBC datasource named ClientVariables_Staging which points to physical SQL 2000 database of the same name. CFDATA and CFGLOBAL tables created by CF5 Administrator upon instantiation of the ClientVariable storage. OTHER INFORMATION: There are two websites on this server, PEv2 and OESv2. Both use client variable storage. PEv2 does NOT manifest the problem. The websites use HOST HEADERS and do not have physical IP addresses. The client browsers allow cookies and have no problem with PEv2.Upon viewing OESv2 and hitting refresh, the CFID increments. For example, link to the OESv2 index.cfm page and cfid:cftoken are [CFID:CFTOKEN] [CFID:CFTOKEN] 1605:9626140. Hit refresh and these values change to [CFID:CFTOKEN] 1606:14486147. STEPS TAKEN TO TRY TO SOLVE PROBLEM: * recreated client storage database, defined new datasource, remapped client storage in CF5 Administrator * created new IIS virtual for the site, trimmed down source to bare minimum to try to isolate problem * restarted the CF5 services numerous times Any suggestions anyone has are appreciated! Thank you, Grant Szabo - This mail sent through IMP: http://horde.org/imp/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFCONTENT Problem with PDF Files
I have - I use it quite a bit with cfx_treebeard. I used cfcontent type=application/pdf ... instead of cfheader. Works for me. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Tim Haak [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 8:52 AM To: CF-Talk Subject: CFCONTENT Problem with PDF Files Hello, I am trying to send a PDF to the user so it loads in their browser window. The code I am using is: cfheader name=Content-type value=application/pdf cfcontent deletefile=no file=C:/Inetpub/wwwroot/cfmxdemo/itworks.pdf type=application/pdf Note: I also tried a content-type of x-application/pdf but that didn't work either. IE 5.5 SP2 just loads the PDF as plain text but Netscape 7.0 works fine and opens the Acrobat Plugin in the browser. I also tried using CFFILE to readBinary the file from the server but wasn't able to output/open the file because the binary stored in the variable could not be converted to a string. Here is the code I tried to get that to work: cffile file=C:\Inetpub\wwwroot\cfmxdemo\itworks.pdf action=readBinary variable=test cfoutput#variables.test#/cfoutput Has anyone had any luck with CFCONTENT and PDF files, especially in IE 5.5 SP2? My environment is: Windows 2000 Professional SP3, ColdFusion MX 6,0,0,48097 (Developer version), IIS 5.0. Thanks in advance. Tim Haak [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFC output
If the HTML is meant to display in a browser then sending it to a Flash front-end would be quite silly since Flash supports rendering very little HTML. It would make more sense to create specific CFCs or specific methods for each type of display you are interested in. Then you don't have to worry about adding additional display types in future causing problems for existing display types. Attempting to create generic objects that can handle current requirements as well as unanticipated future requirements is one of the easiest ways to destroy a software project. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:19 PM To: CF-Talk Subject: RE: CFC output I never said it was a requirement - but rather something you should remember. In other words, not outputting and using cfreturn will work in more ways then direct outputting, I'd always rather use that just in case I do add a Flash layer to my site. As it stands, we should probably just agree to disagree. ;) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:49 AM To: CF-Talk Subject: RE: CFC output Yes, but if your CFC is supposed to output HTML why would you want to call it from Flash? There are many different valid uses of CFCs and calling their functionality from Flash is only one of them and certainly isn't a requirement. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Client Variable Problem
Thanks Matt -- I tried that, still having same problem unfortunately. I am racking my brain and I can't figure out what is going on here. The only thing that seems to make any sense is that there may be an issue with the fact that I am multihoming two sites on the server, both using host headers instead of physical IP's. I am going to see if I can't put another static on that box and map it to OESv2 and see if that solves the problem. This is just a guess though. Incidentally, this problem doesn't happen on CFMX where we have both sites multihomed using a single IP. It only happens on the CF5 box. -Grant Szabo Quoting Matt Robertson [EMAIL PROTECTED]: I saw this happen on netscape browsers on CF4.5 when SETCLIENTCOOKIES=YES was placed in application.cfm, as opposed to leaving the statement out entirely. I'd look to your application.cfm. Try and put in more than the bare minimum you have now and see what happens. Maybe: cfapplication name=mytest sessionmanagement=No clientmanagement=Yes applicationtimeout=#CreateTimeSpan(0,2,0,0)# --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:22 AM To: CF-Talk Subject: Client Variable Problem I am having a very odd problem with client variables and would appreciate any suggestions on additional things to look at or try. SYMPTOM: CFID increments with each subsequent page request (refresh). INDEX.CFM html head title/title /head body cfset client.test = test Hi there cfoutput#client.test#/cfoutput. /body /html APPLICATION.CFM !--- application.cfm --- cfapplication name=OESv2_STAGING clientmanagement=Yes VERSION INFO: CF 5.0.0.0, Windows 2000 SP3, IIS 5 CLIENT VARIABLE STORAGE: Uses ODBC datasource named ClientVariables_Staging which points to physical SQL 2000 database of the same name. CFDATA and CFGLOBAL tables created by CF5 Administrator upon instantiation of the ClientVariable storage. OTHER INFORMATION: There are two websites on this server, PEv2 and OESv2. Both use client variable storage. PEv2 does NOT manifest the problem. The websites use HOST HEADERS and do not have physical IP addresses. The client browsers allow cookies and have no problem with PEv2.Upon viewing OESv2 and hitting refresh, the CFID increments. For example, link to the OESv2 index.cfm page and cfid:cftoken are [CFID:CFTOKEN] [CFID:CFTOKEN] 1605:9626140. Hit refresh and these values change to [CFID:CFTOKEN] 1606:14486147. STEPS TAKEN TO TRY TO SOLVE PROBLEM: * recreated client storage database, defined new datasource, remapped client storage in CF5 Administrator * created new IIS virtual for the site, trimmed down source to bare minimum to try to isolate problem * restarted the CF5 services numerous times Any suggestions anyone has are appreciated! Thank you, Grant Szabo - This mail sent through IMP: http://horde.org/imp/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT: Website testing application
I've been tasked with finding an application that will automatically test a website with multiple browsers. Does such a monster exist? Thanks :-) Eric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Lists vs. Arrays vs. Structures
Michael Dinowitz wrote: I think that a new array search function might be in order here. Something to look through an array for a value and return its index. I'm not sure what you are really trying to accomplish here. I agree with matt, are you working on the maketree tag in cf? lets talk examples... do you modify the array, ( ie inserting or deleting array members other than from the end?) if not then u could index the array using structures cfscript item_array=ArrayNew(1); item_struct=StructNew(); /cfscript cfloop query=qry_items cfscript x=arraylen(item_array); item_array[x]=qry_item.item; item_struct[qry_item.item]=x; /cfscript /cfloop find where dog is in the array = item_struct[dog] or item_struct.dog this method is so fast scaling the dataset makes almost no difference in speed now you can always find the position of x in the array using the struct, this of course doesn't handle very well adding elements to the aray ideally I would try to eliminate arrays all together... esp when u consider that have 2 values in a struct, the key and the value z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Macromedia Contribute
Just got a snazzy tri-fold in the mail today about Macromedia Contribute. It looks great, too bad it doesn't run on the web. Wouldn't it be nice to make Contribute a Java application that could be integrated into an existing web-application to give this kind of power/control to us developers so that we could hand it out to whoever needs to use it - and have it be web-based so as not to have to maintain software installations on multiple users' machines? Just a thought. At $99 it's a good deal, but it would be more useful if it would run on the web. My $0.02 Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Connection Reset by Peer following Warm Restore
After running a T-SQL Script that among other things: Restores the database from a prior state, Drops and Re-Adds the User that is used for the DSN, The first attempt to connect to view a page that uses that DSN returns the following error: Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error I have tried to proactively avoid this error by stopping/restarting various services including (CFMX, CFMX ODBC Server/Agent, MSSQLServer), without success. Typically after one or so page refreshes this problem corrects itself, but I would like to avoid this. Any insights? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Help please!
I have the following query cfpop action=getall name=GetMessages server=#server_ip# username=#Session.MM_User# password=#Session.MM_Pwd# And im doing a query of a query in order to order it by latest first cfquery name=OutputMessages dbtype=query SELECT * FROM GetMessages ORDER BY UID DESC /cfquery And this worked fine till 10 mins ago, but now I get this error Query Manipulation Error Code = 0 Invalid SQL Both when there are messages and when there arent! Can anyone shed any light on this? Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Macromedia Contribute
Personally, my answer to that is an emphatic NO. Thats my job to build a system that my customers can use to do that. If Macromedia becomes an end-user solutions provider it undercuts my business. Contribute is fine as a generic and rather basic solution. It has a fine niche and, speaking for myself, I hope it stays there. --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --- -- Original Message -- from: Joshua Miller [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 9 Dec 2002 14:34:47 -0500 Just got a snazzy tri-fold in the mail today about Macromedia Contribute. It looks great, too bad it doesn't run on the web. Wouldn't it be nice to make Contribute a Java application that could be integrated into an existing web-application to give this kind of power/control to us developers so that we could hand it out to whoever needs to use it - and have it be web-based so as not to have to maintain software installations on multiple users' machines? Just a thought. At $99 it's a good deal, but it would be more useful if it would run on the web. My $0.02 Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Verity's vspider on Solaris.
Hi folks, I'm starting to loose my mind on this one so suggestions/clues are more then welcome... Solaris 2.6 Coldfusion 5 I'm trying to get Verity's vspider up and running but for some reason it keeps failing. I've set -loglevel to trace but those logfiles don't show anything more usefull either (other than the error msgs below). Here's the script/result/error: /home/scripts /opt/coldfusion/verity/_ssol26/bin/vspider -cmdfile spider_script_en - Verity, Inc. Version 3.7 (_solaris, Nov 15 1998) Info 2002/12/09 17:00:51 (ind006000) Message database loaded from [/opt/coldfusion/verity/_ssol26/bin/ind.msg]. Info 2002/12/09 17:00:51 (ind012207) Last indexing job was interrupted 5 time(s). Running in auto-restart mode. FATAL 2002/12/09 17:00:51 (ind002000) Couldn't create VDK session [-10]. IndExcept from /users/qk2v220/BLD11/src/spider/ind/indvdk.cxx:434 vspider done Looking up the error codes VdkError_BadArgStruct (-10) Invalid argument structure. http://www-2.cv.ihk.dk/cfdocs/Advanced_ColdFusion_Administration/verityutils9.html But the odd thing is is that if I run the exact same script on another Solaris machine it works like a charm. As far as I can tell it doesn't have anything todo with the script itself, even with a basic set of options it keeps failing. I'm starting to think this is more of a install/config related problem but i'm far from smart enough when it comes to Solaris to figure out what could wrong. Any help is appreciated! Joachim http://www.developer.be/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Help please!
Ryan a couple of things, are you locking the cfpop code where you are reading Session vars or move them to the request scope if you do not want to lock them and secondly what do you get if you cfdump the query recordset prior to the Query of a Query? Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:44 AM To: CF-Talk Subject: Help please! I have the following query cfpop action=getall name=GetMessages server=#server_ip# username=#Session.MM_User# password=#Session.MM_Pwd# And im doing a query of a query in order to order it by latest first cfquery name=OutputMessages dbtype=query SELECT * FROM GetMessages ORDER BY UID DESC /cfquery And this worked fine till 10 mins ago, but now I get this error Query Manipulation Error Code = 0 Invalid SQL Both when there are messages and when there arent! Can anyone shed any light on this? Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Lists vs. Arrays vs. Structures
You can see the code here: http://www.houseoffusion.com/_library/maketree.txt Your example will fail as there can be more than one item with the same 'parent', which is what we're looking for. No matter what, we have to do a search and the list search functions seem to be the fastest of the searches around, even though the list items have to be parsed. For those wondering what's going on, when dealing with a query that has to be turned into a tree, you have to first find the 'root' item, then all of its children, then the next root item, etc. itemidparentidname 10 root 21 1st child of root 32 1st sub child 42 2nd sub child 51 2nd child of root 65 1st child of 2nd We would have to first look at root and get its children. Item 2 is its first child. Does item 2 have any children? If so, we get those children on down. When item 2 or it's children are finished, we go onto the next chold of the root. That is item 5. We do the same thing for 5, getting all of its children. Michael Dinowitz wrote: I think that a new array search function might be in order here. Something to look through an array for a value and return its index. I'm not sure what you are really trying to accomplish here. I agree with matt, are you working on the maketree tag in cf? lets talk examples... do you modify the array, ( ie inserting or deleting array members other than from the end?) if not then u could index the array using structures cfscript item_array=ArrayNew(1); item_struct=StructNew(); /cfscript cfloop query=qry_items cfscript x=arraylen(item_array); item_array[x]=qry_item.item; item_struct[qry_item.item]=x; /cfscript /cfloop find where dog is in the array = item_struct[dog] or item_struct.dog this method is so fast scaling the dataset makes almost no difference in speed now you can always find the position of x in the array using the struct, this of course doesn't handle very well adding elements to the aray ideally I would try to eliminate arrays all together... esp when u consider that have 2 values in a struct, the key and the value z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Macromedia Contribute
Actually, I don't see any difference other than where it runs. If you can integrate it into your application and give your customer this power from anywhere they've got a web connection then that's an added service that's tied into their application and thus tied into you. If they can buy it for $99 at Staples and run it at home then why do they need to pay you for a content management system? Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:54 PM To: CF-Talk Subject: Re: Macromedia Contribute Personally, my answer to that is an emphatic NO. Thats my job to build a system that my customers can use to do that. If Macromedia becomes an end-user solutions provider it undercuts my business. Contribute is fine as a generic and rather basic solution. It has a fine niche and, speaking for myself, I hope it stays there. --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --- -- Original Message -- from: Joshua Miller [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 9 Dec 2002 14:34:47 -0500 Just got a snazzy tri-fold in the mail today about Macromedia Contribute. It looks great, too bad it doesn't run on the web. Wouldn't it be nice to make Contribute a Java application that could be integrated into an existing web-application to give this kind of power/control to us developers so that we could hand it out to whoever needs to use it - and have it be web-based so as not to have to maintain software installations on multiple users' machines? Just a thought. At $99 it's a good deal, but it would be more useful if it would run on the web. My $0.02 Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-9044 ext. 254 *** * * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] *** * * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Help please!
Is there a reason you're sorting by UID? Why not use Date or MessageNumber instead? Maybe that will clear up the problem. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:44 PM To: CF-Talk Subject: Help please! I have the following query cfpop action=getall name=GetMessages server=#server_ip# username=#Session.MM_User# password=#Session.MM_Pwd# And im doing a query of a query in order to order it by latest first cfquery name=OutputMessages dbtype=query SELECT * FROM GetMessages ORDER BY UID DESC /cfquery And this worked fine till 10 mins ago, but now I get this error Query Manipulation Error Code = 0 Invalid SQL Both when there are messages and when there arent! Can anyone shed any light on this? Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Macromedia Contribute
I have to agree with Matt - it undercuts my business. But on the other hand I do have clients that spend very good money with me on large feature and graphic updates.. So where the dozens of faxes and emails which come through, the tracking and billing of these whordes of changes, delay the client and I from making more important changes - I have a duty to my clients to help them run efficiently. Point is in some cases - this will free up some time and allow you to create more important changes. While allowing clients text only changes, most often than not - an enthusiastic client, whom sees delay changes = happy web surfers - they commit to larger and more frequent updates and therefore increase my profits. But - I hope it does stay on the desktop - because once it hits the web - all those web based forms and intuitive back end solutions come under fire.. Not sure any of us would enjoy that. my 02 cents jay miller Matt Robertson wrote: Personally, my answer to that is an emphatic NO. Thats my job to build a system that my customers can use to do that. If Macromedia becomes an end-user solutions provider it undercuts my business. Contribute is fine as a generic and rather basic solution. It has a fine niche and, speaking for myself, I hope it stays there. --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com http://mysecretbase.com - Retail http://foohbar.org http://foohbar.org - ColdFusion Tools --- -- Original Message -- from: Joshua Miller mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] date: Mon, 9 Dec 2002 14:34:47 -0500 Just got a snazzy tri-fold in the mail today about Macromedia Contribute. It looks great, too bad it doesn't run on the web. Wouldn't it be nice to make Contribute a Java application that could be integrated into an existing web-application to give this kind of power/control to us developers so that we could hand it out to whoever needs to use it - and have it be web-based so as not to have to maintain software installations on multiple users' machines? Just a thought. At $99 it's a good deal, but it would be more useful if it would run on the web. My $0.02 Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net http://www.garrisonenterprises.net/ http://www.garrisonenterprises.net/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
CF 5 Page Filing massively... Ideas?
Everyone, We have had a challenge for the last 2 months with no ability to track it down and solve it. We are running CF 5 on Win2K with Dual P3 @ 1Ghz and 1Gig of Ram. We normally only use about 400-500 meg of ram, but once to twice per week right now we are filling up memory to 2.5ish gig and massively pagefiling. Database is on another server with same hardware config. We can't restart the CF service when this happens, and the only way to deal with it is to reboot the box. Part of me thinks the problems is overall load on the box -- average of 8000 to 1 unique visitors on the site per day and this doesn't include 500ish members on the system hammering it. Are there any tools to know what is using up the pagefile memory on Win2k? Any ideas what could be causing CF to eat up that much memory? Thanks, Jeremy Jeremy Bruck, VP of Technology ::MfgQuote 2690 Cumberland Parkway SE Suite 510 Atlanta, GA 30339 TEL: 678.556.2929 FAX: 678.556.2980 www.mfgquote.com [EMAIL PROTECTED]
RE: Verity's vspider on Solaris.
I have 0 experience with solaris. But my guess is your collection is corrupt I would go in stop the k2 service...delete the collection...start service and recreate collection. Then try spidering it again. hope that helps sean -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:50 PM To: CF-Talk Subject: Verity's vspider on Solaris. Hi folks, I'm starting to loose my mind on this one so suggestions/clues are more then welcome... Solaris 2.6 Coldfusion 5 I'm trying to get Verity's vspider up and running but for some reason it keeps failing. I've set -loglevel to trace but those logfiles don't show anything more usefull either (other than the error msgs below). Here's the script/result/error: /home/scripts /opt/coldfusion/verity/_ssol26/bin/vspider -cmdfile spider_script_en - Verity, Inc. Version 3.7 (_solaris, Nov 15 1998) Info 2002/12/09 17:00:51 (ind006000) Message database loaded from [/opt/coldfusion/verity/_ssol26/bin/ind.msg]. Info 2002/12/09 17:00:51 (ind012207) Last indexing job was interrupted 5 time(s). Running in auto-restart mode. FATAL 2002/12/09 17:00:51 (ind002000) Couldn't create VDK session [-10]. IndExcept from /users/qk2v220/BLD11/src/spider/ind/indvdk.cxx:434 vspider done Looking up the error codes VdkError_BadArgStruct (-10) Invalid argument structure. http://www-2.cv.ihk.dk/cfdocs/Advanced_ColdFusion_Administration/verityutils 9.html But the odd thing is is that if I run the exact same script on another Solaris machine it works like a charm. As far as I can tell it doesn't have anything todo with the script itself, even with a basic set of options it keeps failing. I'm starting to think this is more of a install/config related problem but i'm far from smart enough when it comes to Solaris to figure out what could wrong. Any help is appreciated! Joachim http://www.developer.be/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Macromedia Contribute
then why do they need to pay you for a content management system? Perhaps so he can continue to pay his kids tuition bill, the mortgage or buy groceries? :) Ken ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CF 5 Page Filing massively... Ideas?
In this circumstance, I would use a load test tool against a stage/test environment that mirrors the production environment to try and determine what the cause was. There are free load test tools out there. Suzanne -Original Message- From: Jeremy Bruck - MfgQuote, Inc. [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:24 PM To: CF-Talk Subject: CF 5 Page Filing massively... Ideas? Everyone, We have had a challenge for the last 2 months with no ability to track it down and solve it. We are running CF 5 on Win2K with Dual P3 @ 1Ghz and 1Gig of Ram. We normally only use about 400-500 meg of ram, but once to twice per week right now we are filling up memory to 2.5ish gig and massively pagefiling. Database is on another server with same hardware config. We can't restart the CF service when this happens, and the only way to deal with it is to reboot the box. Part of me thinks the problems is overall load on the box -- average of 8000 to 1 unique visitors on the site per day and this doesn't include 500ish members on the system hammering it. Are there any tools to know what is using up the pagefile memory on Win2k? Any ideas what could be causing CF to eat up that much memory? Thanks, Jeremy Jeremy Bruck, VP of Technology ::MfgQuote 2690 Cumberland Parkway SE Suite 510 Atlanta, GA 30339 TEL: 678.556.2929 FAX: 678.556.2980 www.mfgquote.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Macromedia Contribute
Contribute is very closely inner-twined with Dreamweaver--reuses a lot of the code base. If it were written in Java, it would have to be totally written from scratch. I'm also not sure you could do all the things Contribute does if it was written in Java--particularly the integration with outside applications like Flash and Office. Sam At 02:34 PM 12/9/2002, you wrote: Just got a snazzy tri-fold in the mail today about Macromedia Contribute. It looks great, too bad it doesn't run on the web. Wouldn't it be nice to make Contribute a Java application that could be integrated into an existing web-application to give this kind of power/control to us developers so that we could hand it out to whoever needs to use it - and have it be web-based so as not to have to maintain software installations on multiple users' machines? Just a thought. At $99 it's a good deal, but it would be more useful if it would run on the web. My $0.02 Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-9044 ext. 254 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CF 5 Page Filing massively... Ideas?
Jeremy, I would take a look at the ColdFusion error logs, particularly Application and Server in that order. See if you are getting error messages and if so what are the most regular ones. If you are seeing the string thread or threading in either log that can be a sign of memory corruption. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Jeremy Bruck - MfgQuote, Inc. [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:24 PM To: CF-Talk Subject: CF 5 Page Filing massively... Ideas? Everyone, We have had a challenge for the last 2 months with no ability to track it down and solve it. We are running CF 5 on Win2K with Dual P3 @ 1Ghz and 1Gig of Ram. We normally only use about 400-500 meg of ram, but once to twice per week right now we are filling up memory to 2.5ish gig and massively pagefiling. Database is on another server with same hardware config. We can't restart the CF service when this happens, and the only way to deal with it is to reboot the box. Part of me thinks the problems is overall load on the box -- average of 8000 to 1 unique visitors on the site per day and this doesn't include 500ish members on the system hammering it. Are there any tools to know what is using up the pagefile memory on Win2k? Any ideas what could be causing CF to eat up that much memory? Thanks, Jeremy Jeremy Bruck, VP of Technology ::MfgQuote 2690 Cumberland Parkway SE Suite 510 Atlanta, GA 30339 TEL: 678.556.2929 FAX: 678.556.2980 www.mfgquote.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Lists vs. Arrays vs. Structures
If I understand you correctly, you are representing a hierarchical relationship in a tabular manner. If there is another way you can store this information I would suggest it highly as there are many data structures much better suited for storage of hierarchical information. For example, a tree would give you O(log N) vs. your current O(N) performance. As you can see, if N is large it makes a big difference. Now then, assuming you are stuck on your tabular data structure I would suggest some changes to it. Right now you have the following. itemidparentidname 10root 211st child of root 321st sub child 422nd sub child 512nd child of root 651st child of 2nd Instead of relating a child to its parent via a primary key, I would suggest creating a hash string to represent the relationship, which might look like the following. itemId hashname 1 001 root 2 001002 1st child of root 3 001002003 1st sub child 4 001002004 2nd sub child 5 001005 2nd child of root 6 001005006 1st child of 2nd Above I have used a simple hash formula, which represents the itemId using a 3 digit fixed notation. I then create a hash string for each item by appending the item's hash to that of its parent's. This allows you to just sort the whole table based on a single column and everything is done for you. The above has formula is only an example and is limited to 999 unique items. You would need to create a hash formula best suited for the number of unique items you need to support. However, resist the temptation to make individual item's hash too long as deeply nest items would have very long strings. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:08 PM To: CF-Talk Subject: Re: Lists vs. Arrays vs. Structures You can see the code here: http://www.houseoffusion.com/_library/maketree.txt Your example will fail as there can be more than one item with the same 'parent', which is what we're looking for. No matter what, we have to do a search and the list search functions seem to be the fastest of the searches around, even though the list items have to be parsed. For those wondering what's going on, when dealing with a query that has to be turned into a tree, you have to first find the 'root' item, then all of its children, then the next root item, etc. itemidparentidname 10 root 21 1st child of root 32 1st sub child 42 2nd sub child 51 2nd child of root 65 1st child of 2nd We would have to first look at root and get its children. Item 2 is its first child. Does item 2 have any children? If so, we get those children on down. When item 2 or it's children are finished, we go onto the next chold of the root. That is item 5. We do the same thing for 5, getting all of its children. Michael Dinowitz wrote: I think that a new array search function might be in order here. Something to look through an array for a value and return its index. I'm not sure what you are really trying to accomplish here. I agree with matt, are you working on the maketree tag in cf? lets talk examples... do you modify the array, ( ie inserting or deleting array members other than from the end?) if not then u could index the array using structures cfscript item_array=ArrayNew(1); item_struct=StructNew(); /cfscript cfloop query=qry_items cfscript x=arraylen(item_array); item_array[x]=qry_item.item; item_struct[qry_item.item]=x; /cfscript /cfloop find where dog is in the array = item_struct[dog] or item_struct.dog this method is so fast scaling the dataset makes almost no difference in speed now you can always find the position of x in the array using the struct, this of course doesn't handle very well adding elements to the aray ideally I would try to eliminate arrays all together... esp when u consider that have 2 values in a struct, the key and the value z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Macromedia Contribute
Yes, exactly. For a customer who has a largely *static* site and wants to do modest stuff, Contribute is a fine solution and I would recommend it to clients who are locked into a big static solution for whatever reason. To answer Joshua's question regarding why do they need to pay me for a content management system? Well, they have to pay somebody, don't they? Ignoring all of the added value I can provide within an integrated system -- as opposed to one where I have to work around a solution that attempts to be standalone rather than a component, as Contribute does -- I want the person who gets paid to be me... not the next guy... and I certainly don't want to be put out of business by my tool supplier. Of course we have to adapt to changing landscapes etc. etc. However this sort of channel conflict is an old story oft repeated. When the supplier goes into the end-user solutions business -- even if they're only sticking their big toe into the market ***at the moment*** -- its bad news for the VAR, developer etc. --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --- -- Original Message -- from: Jason Miller [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 09 Dec 2002 15:18:42 -0800 I have to agree with Matt - it undercuts my business. But on the other hand I do have clients that spend very good money with me on large feature and graphic updates.. So where the dozens of faxes and emails which come through, the tracking and billing of these whordes of changes, delay the client and I from making more important changes - I have a duty to my clients to help them run efficiently. Point is in some cases - this will free up some time and allow you to create more important changes. While allowing clients text only changes, most often than not - an enthusiastic client, whom sees delay changes = happy web surfers - they commit to larger and more frequent updates and therefore increase my profits. But - I hope it does stay on the desktop - because once it hits the web - all those web based forms and intuitive back end solutions come under fire.. Not sure any of us would enjoy that. my 02 cents jay miller Matt Robertson wrote: Personally, my answer to that is an emphatic NO. Thats my job to build a system that my customers can use to do that. If Macromedia becomes an end-user solutions provider it undercuts my business. Contribute is fine as a generic and rather basic solution. It has a fine niche and, speaking for myself, I hope it stays there. --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com http://mysecretbase.com - Retail http://foohbar.org http://foohbar.org - ColdFusion Tools --- -- Original Message -- from: Joshua Miller mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] date: Mon, 9 Dec 2002 14:34:47 -0500 Just got a snazzy tri-fold in the mail today about Macromedia Contribute. It looks great, too bad it doesn't run on the web. Wouldn't it be nice to make Contribute a Java application that could be integrated into an existing web-application to give this kind of power/control to us developers so that we could hand it out to whoever needs to use it - and have it be web-based so as not to have to maintain software installations on multiple users' machines? Just a thought. At $99 it's a good deal, but it would be more useful if it would run on the web. My $0.02 Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net http://www.garrisonenterprises.net/ http://www.garrisonenterprises.net/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * ~| Archives:
Re: Lists vs. Arrays vs. Structures
Michael Dinowitz wrote: You can see the code here: http://www.houseoffusion.com/_library/maketree.txt Your example will fail as there can be more than one item with the same 'parent', which is what we're looking for. No matter what, we have to do a search and the list search functions seem to be the fastest of the searches around, even though the list items have to be parsed. ok gotta run, times short in a second but off the top of my head i would loop over the query first and then make each parentid a structure containing the items cfscript item_struct=StructNew(); /cfscript cfloop query=qry_items cfscript if (NOT structkeyExists(item_struct,qry_items.parentId) ) item_struct[qry_items.parentId]=structnew(); item_struct[qry_items.parentId][qry_items.itemid]=qry_items.currentrow; /cfscript /cfloop now everything is grouped by parentid now we know that the items in item_struct[0] are the first level, you could then loop over the collection cfloop collection=#item_struct[0]# item=child cfscript if ( structkeyExists(item_struct,child) ) // yes there are children add to the to be processed list else // no it's just a member with no children /cfscript /cfloop and so on... sorry time ran out z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
CFMX - Mail Spooling Issue!
Hi all: Has anyone seen behavior like this? I have a script on localhost that pulls e-mails from an Access database, then loops over and sends a message to each e-mail address (over 500 addresses) using 127.0.0.1. The e-mail gets sent fine and all is good, but days later when I reboot my computer for whatever reason, when the computer comes back up I noticed that many more e-mails had just been sent (I know this because I start getting a bunch of bouncebacks for the invalid addresses). This leads me to believe that when I actually run the script, not all the e-mails get sent and it hangs for some reason (maybe?), and then when I reboot, it retriggers something and the rest of the mails get sent out? Does the CFMX mail component choke when there's a lot of messages in the CFMX\Mail\Spool folder? I know CFMX never stopped working so it doesn't completely hose, but maybe the mail part is? I don't know. Anyone have any clues? --D ### David Notik Digital202, LLC Imagination gone digital. Web: http://www.digital202.com/ www.digital202.com E-mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Office: (206) 575-1717 Mobile: (206) 351-3948 ### ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Macromedia Contribute
Wouldn't it be nice to make Contribute a Java application that could be integrated into an existing web-application to give this kind of power/control to us developers so that we could hand it out to whoever needs to use it - and have it be web-based so as not to have to maintain software installations on multiple users' machines? Just a thought. At $99 it's a good deal, but it would be more useful if it would run on the web. Actually we have such an application, ActivEdit (http://www.cfdev.com/activedit/) in the latest version it includes a Java Applet WYSIWYG Editor, and it starts at $99 as well. Granted it doesn't have all the features that contribute has. But I think your overestimating how well Java Applets work across the board. There are big issues when it comes to getting Java Applets working on Mac (mainly the LiveConnect API isn't implemented fully on Mac OSX browsers). Applets do work quite well on Windows, and reasonably well on Linux however. I can relate to Macromedia Contribute undercutting many of their customers, I don't think its helping their popularity with the development community. However customers that don't want to be tied to desktop software, and installation issues I think will still go for a web based WYSIWYG editor/content manager. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CF 5 Page Filing massively... Ideas?
Couple questions: The swap file is set to what size? 2.5Gig? Is the pagefile.sys (swap) on a separate partition? When was the last time you defragged? -Original Message- From: Jeremy Bruck - MfgQuote, Inc. [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:24 PM To: CF-Talk Subject: CF 5 Page Filing massively... Ideas? Everyone, We have had a challenge for the last 2 months with no ability to track it down and solve it. We are running CF 5 on Win2K with Dual P3 @ 1Ghz and 1Gig of Ram. We normally only use about 400-500 meg of ram, but once to twice per week right now we are filling up memory to 2.5ish gig and massively pagefiling. Database is on another server with same hardware config. We can't restart the CF service when this happens, and the only way to deal with it is to reboot the box. Part of me thinks the problems is overall load on the box -- average of 8000 to 1 unique visitors on the site per day and this doesn't include 500ish members on the system hammering it. Are there any tools to know what is using up the pagefile memory on Win2k? Any ideas what could be causing CF to eat up that much memory? Thanks, Jeremy Jeremy Bruck, VP of Technology ::MfgQuote 2690 Cumberland Parkway SE Suite 510 Atlanta, GA 30339 TEL: 678.556.2929 FAX: 678.556.2980 www.mfgquote.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Macromedia Contribute
Depends on who we are talking about. Some business will be excited about Contribute. Others will understand or find out the hard way that they really need a CMS. Of course many are still finding out the hard way that CMS is an often abused term and that home grown systems aren't going to meet their future needs. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:11 PM To: CF-Talk Subject: RE: Macromedia Contribute Actually, I don't see any difference other than where it runs. If you can integrate it into your application and give your customer this power from anywhere they've got a web connection then that's an added service that's tied into their application and thus tied into you. If they can buy it for $99 at Staples and run it at home then why do they need to pay you for a content management system? Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:54 PM To: CF-Talk Subject: Re: Macromedia Contribute Personally, my answer to that is an emphatic NO. Thats my job to build a system that my customers can use to do that. If Macromedia becomes an end-user solutions provider it undercuts my business. Contribute is fine as a generic and rather basic solution. It has a fine niche and, speaking for myself, I hope it stays there. --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --- -- Original Message -- from: Joshua Miller [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 9 Dec 2002 14:34:47 -0500 Just got a snazzy tri-fold in the mail today about Macromedia Contribute. It looks great, too bad it doesn't run on the web. Wouldn't it be nice to make Contribute a Java application that could be integrated into an existing web-application to give this kind of power/control to us developers so that we could hand it out to whoever needs to use it - and have it be web-based so as not to have to maintain software installations on multiple users' machines? Just a thought. At $99 it's a good deal, but it would be more useful if it would run on the web. My $0.02 Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-9044 ext. 254 *** * * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] *** * * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Macromedia Contribute
Speaking of, does anyone know what it's using to connect to the server (ie RPC)? I got it to try out and I managed to get it working fine to my home server, but it does not work with any of the servers at work (all of which are Solaris). The only thing I can think of is that it's using some daemon that has been disabled during security stripping of servers at work that I didn't do to my server at home. My feelings on it so far are really I could care less. I use CFStudio RDS and it's just as easy for me to open a file through that as it is through Contribute (then again, I'm not one for WYSIWYG). Contribute opens up new security issues (for example I can turn off RDS on the server, but now I'll have to turn off whatever this uses as well). We don't really have access control or separate people designing content and functionality (and when we do, the content portion doesn't change as it's only graphics - everything else is database driven). Cathy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CFC output
I agree with u Matt but I think he's trying to say that any logic used to derive those html results are set in stone if the function is used to output html...Unless the function is solely used to format data which was generated from other function call(s). Stace -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:45 PM To: CF-Talk Subject: RE: CFC output If the HTML is meant to display in a browser then sending it to a Flash front-end would be quite silly since Flash supports rendering very little HTML. It would make more sense to create specific CFCs or specific methods for each type of display you are interested in. Then you don't have to worry about adding additional display types in future causing problems for existing display types. Attempting to create generic objects that can handle current requirements as well as unanticipated future requirements is one of the easiest ways to destroy a software project. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:19 PM To: CF-Talk Subject: RE: CFC output I never said it was a requirement - but rather something you should remember. In other words, not outputting and using cfreturn will work in more ways then direct outputting, I'd always rather use that just in case I do add a Flash layer to my site. As it stands, we should probably just agree to disagree. ;) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:49 AM To: CF-Talk Subject: RE: CFC output Yes, but if your CFC is supposed to output HTML why would you want to call it from Flash? There are many different valid uses of CFCs and calling their functionality from Flash is only one of them and certainly isn't a requirement. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: MS Word/CFOBJECT Help
Hi Matt, Thanks so much for the code! I'll try it out at work tomorrow and let you know how it works!! Peter Bagnato -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:31 AM To: CF-Talk Subject: RE: MS Word/CFOBJECT Help Importance: High Here is some actual code that I currently use- it's not pretty, but it does the job for CF. I'll be happy to try to answer any questions for you. Matt Small cftry cfobject action=CONNECT class=Word.Application name=objWord type=COM cfcatch cfobject action=CREATE class=Word.Application name=objWord type=COM /cfcatch /cftry cftry cfscript objDoc = objWord.Documents; newDoc = objDoc.open(#path_documents#\announcerscoresheet_#form.show#.htm); po = newDoc.PageSetup; po.Orientation = 1; po.TopMargin = 36; po.BottomMargin = 36; po.LeftMargin = 36; po.RightMargin = 36; objSecs = newDoc.Sections; objSec1 = objSecs.Item(1); objSec1Headers = objSec1.Headers; objSec1Header1 = objSec1Headers.Item(1); objRange = objSec1Header1.Range; // Set the paragraph format // Values for alignment are {0=Left,1=Center,2=Right,3=Justify} objParaFormat = objRange.ParagraphFormat; objParaFormat.Alignment = 2; // Set a right-tab at 6 inches // Tab positions are in points, where 72 points = 1 inch // Arguments to the TabStops.Add function: //Position: 6 inches * 72 points/inch = 432 points //Alignment: values include {0=Left,1=Center,2=Right} objTabStops = objParaFormat.TabStops; objTabStops.ClearAll(); objTabStops.Add(432,2); objRange.Select(); objSelection = objWord.Selection; objFont = objSelection.Font; objFont.Name = Arial; objFont.Size = 10; // Insert the page number // Page number is field type 33 // Story is unit type 6 objRange.Collapse(0); objFields = objRange.Fields; objFields.Add(objRange,33); /cfscript cflock name=printout type=exclusive timeout=300 cfscript switch (form.printer) { case 1: {objWord.ActivePrinter = #printer_princess#; break;} case 2: {objWord.ActivePrinter = #printer_lana#; break;} case 3: {objWord.ActivePrinter = #printer_3#; break;} case 4: {objWord.ActivePrinter = #printer_4#; break;} case 5: {objWord.ActivePrinter = #printer_5#; break;}} newDoc.PrintOut(); /cfscript /cflock cfscript newDoc.Close(); /cfscript cfcatch cfscript newDoc.Close(); objWord.Quit();
RE: CFC output
The logic used to derive those results should be decoupled from the display. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 4:06 PM To: CF-Talk Subject: RE: CFC output I agree with u Matt but I think he's trying to say that any logic used to derive those html results are set in stone if the function is used to output html...Unless the function is solely used to format data which was generated from other function call(s). Stace -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:45 PM To: CF-Talk Subject: RE: CFC output If the HTML is meant to display in a browser then sending it to a Flash front-end would be quite silly since Flash supports rendering very little HTML. It would make more sense to create specific CFCs or specific methods for each type of display you are interested in. Then you don't have to worry about adding additional display types in future causing problems for existing display types. Attempting to create generic objects that can handle current requirements as well as unanticipated future requirements is one of the easiest ways to destroy a software project. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:19 PM To: CF-Talk Subject: RE: CFC output I never said it was a requirement - but rather something you should remember. In other words, not outputting and using cfreturn will work in more ways then direct outputting, I'd always rather use that just in case I do add a Flash layer to my site. As it stands, we should probably just agree to disagree. ;) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:49 AM To: CF-Talk Subject: RE: CFC output Yes, but if your CFC is supposed to output HTML why would you want to call it from Flash? There are many different valid uses of CFCs and calling their functionality from Flash is only one of them and certainly isn't a requirement. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Macromedia Contribute
It uses FTP, which any security conscious admin would disable. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:58 PM To: CF-Talk Subject: Re: Macromedia Contribute Speaking of, does anyone know what it's using to connect to the server (ie RPC)? I got it to try out and I managed to get it working fine to my home server, but it does not work with any of the servers at work (all of which are Solaris). The only thing I can think of is that it's using some daemon that has been disabled during security stripping of servers at work that I didn't do to my server at home. My feelings on it so far are really I could care less. I use CFStudio RDS and it's just as easy for me to open a file through that as it is through Contribute (then again, I'm not one for WYSIWYG). Contribute opens up new security issues (for example I can turn off RDS on the server, but now I'll have to turn off whatever this uses as well). We don't really have access control or separate people designing content and functionality (and when we do, the content portion doesn't change as it's only graphics - everything else is database driven). Cathy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Error in logs
Hi, We're seeing the CF Process hang in CFMX (new install) after implementing this article: http://www.macromedia.com/desdev/mx/coldfusion/articles/ntdomain_1.html. There is this message in the server log: An unexpected exception has been detected in native code outside the VM. Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC=0x2b522b3b Function name=(N/A) Library=C:\CFusionMX\runtime\bin\WindowsLogin.dll. Has anyone seen this? TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CFC output
Think we should listen to Matt on this one ... 3 letters for dealing with cfcs: MVC (Model - View - Controller) ... learn it, live it, love it. Kevin Bridges -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:09 PM To: CF-Talk Subject: RE: CFC output The logic used to derive those results should be decoupled from the display. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Large file uploads
I have the same issue. I don't like the answer of RAM because I am running on a gigahertz with 768MB of ram. While uploading the 10MB file, the CPU maxed out at 100% for 2 minutes. My physical memory usage is only have the capacity. Anyone have any suggestions? Perhaps there is something that I am missing? Anyone tried any alternatives and found a more efficient solution? Thanks, Suz I did change my page file to another drive with more space and increased it and found a significant increase in performance, but 2 minutes is still too long for the CPU to spike. The page memory does not max out either. anyone worked out ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CFMX - Mail Spooling Issue!
Is your mail server running on the same machine as the script? Is your mail server set to do open relays? What mail server do you have set in CF Administrator? Is your mail server sending mail only from your script, or relaying for someone else? I am not really clear on what you are asking here, , I guess you can see that, huh? = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: David Notik [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 09, 2002 2:49 PM Subject: CFMX - Mail Spooling Issue! | Hi all: | | Has anyone seen behavior like this? | | I have a script on localhost that pulls e-mails from an Access database, | then loops over and sends a message to each e-mail address (over 500 | addresses) using 127.0.0.1. The e-mail gets sent fine and all is good, | but days later when I reboot my computer for whatever reason, when the | computer comes back up I noticed that many more e-mails had just been | sent (I know this because I start getting a bunch of bouncebacks for the | invalid addresses). | | This leads me to believe that when I actually run the script, not all | the e-mails get sent and it hangs for some reason (maybe?), and then | when I reboot, it retriggers something and the rest of the mails get | sent out? | | Does the CFMX mail component choke when there's a lot of messages in the | CFMX\Mail\Spool folder? I know CFMX never stopped working so it doesn't | completely hose, but maybe the mail part is? | | I don't know. Anyone have any clues? | | --D | | ### | David Notik | Digital202, LLC | Imagination gone digital. | Web: http://www.digital202.com/ www.digital202.com | E-mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] | Office: (206) 575-1717 | Mobile: (206) 351-3948 | ### | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Large file uploads
I would suggest using a servlet to handle file uploads as you can stream the file to disk. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Suzanne Capener [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:25 PM To: CF-Talk Subject: Large file uploads I have the same issue. I don't like the answer of RAM because I am running on a gigahertz with 768MB of ram. While uploading the 10MB file, the CPU maxed out at 100% for 2 minutes. My physical memory usage is only have the capacity. Anyone have any suggestions? Perhaps there is something that I am missing? Anyone tried any alternatives and found a more efficient solution? Thanks, Suz I did change my page file to another drive with more space and increased it and found a significant increase in performance, but 2 minutes is still too long for the CPU to spike. The page memory does not max out either. anyone worked out ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Macromedia Contribute
Point is in some cases - this will free up some time and allow you to create more important changes. While allowing clients text only changes, most often than not - an enthusiastic client, whom sees delay changes = happy web surfers - they commit to larger and more frequent updates and therefore increase my profits. Matt Brown here. I am the community manager for CT and Dreamweaver. I think you sum up the product really well in this paragraph. CT is designed to take away the simple and silly things that need changing, not the big updates and design changes. What our target customers tell us is that they are going to do more with the web if they can have more input for the contributors. OTOH, CT is not a CMS really, it doesn't do strict approvals, it does not do time based publishing, it does not put data into a database, it really only works with static pages. I think there is a good niche for it in many many workflows, but not all. I also think that it is going to get you more work not less over time because people are going to really want to do more once they can do some... _ Matt Brown Dreamweaver and Contribute Community Manager Macromedia (415) 706-6543 [EMAIL PROTECTED] The Dreamweaver Blog: http://shorterlink.com/?KB8LAL Developer Resource Kit Volume 2: http://www.macromedia.com/software/drk/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
access odbc connection
Here's the deal. We need to connect to an access database that resides on another server. I know to use the UNC path, and to make sure the ColdFusion service has rights to open the database on the other machine. There is no username and password for the database. The issue is that CF cannot verify the data source. I can set it up in Windows 2000 server and I can connect to it using SQLCon32. What else do I need to do in order to make CF verify the connection? TIA Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com http://www.comspecinternational.com/ phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com http://www.empower-xl.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Large file uploads
Can you recommend any servlets that work well and are free? Dave -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 4:34 PM To: CF-Talk Subject: RE: Large file uploads I would suggest using a servlet to handle file uploads as you can stream the file to disk. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Suzanne Capener [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:25 PM To: CF-Talk Subject: Large file uploads I have the same issue. I don't like the answer of RAM because I am running on a gigahertz with 768MB of ram. While uploading the 10MB file, the CPU maxed out at 100% for 2 minutes. My physical memory usage is only have the capacity. Anyone have any suggestions? Perhaps there is something that I am missing? Anyone tried any alternatives and found a more efficient solution? Thanks, Suz I did change my page file to another drive with more space and increased it and found a significant increase in performance, but 2 minutes is still too long for the CPU to spike. The page memory does not max out either. anyone worked out ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CF 5 Page Filing massively... Ideas?
Jeremy, I suggest that you learn how to use the 'perfmon.exe' application. Using perfmon you should be able to pinpoint what is going wrong (M$ only). In my experience it is likely to be a combination of CF and something uncooperative. Of course as Mike suggested below, always check your application and server logs. Then there is all the locking discussion...(check the archives). Then there is the 'review your code' idea... If you are experiencing a problem that is severely impacting your business, I would suggest to hire a consultant so as to fix your problem. Hope this helps a little, Jared Clinton. -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 10 December 2002 6:38 AM To: CF-Talk Subject: RE: CF 5 Page Filing massively... Ideas? Jeremy, I would take a look at the ColdFusion error logs, particularly Application and Server in that order. See if you are getting error messages and if so what are the most regular ones. If you are seeing the string thread or threading in either log that can be a sign of memory corruption. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Jeremy Bruck - MfgQuote, Inc. [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:24 PM To: CF-Talk Subject: CF 5 Page Filing massively... Ideas? Everyone, We have had a challenge for the last 2 months with no ability to track it down and solve it. We are running CF 5 on Win2K with Dual P3 @ 1Ghz and 1Gig of Ram. We normally only use about 400-500 meg of ram, but once to twice per week right now we are filling up memory to 2.5ish gig and massively pagefiling. Database is on another server with same hardware config. We can't restart the CF service when this happens, and the only way to deal with it is to reboot the box. Part of me thinks the problems is overall load on the box -- average of 8000 to 1 unique visitors on the site per day and this doesn't include 500ish members on the system hammering it. Are there any tools to know what is using up the pagefile memory on Win2k? Any ideas what could be causing CF to eat up that much memory? Thanks, Jeremy Jeremy Bruck, VP of Technology ::MfgQuote 2690 Cumberland Parkway SE Suite 510 Atlanta, GA 30339 TEL: 678.556.2929 FAX: 678.556.2980 www.mfgquote.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: access odbc connection
I believe you have to map the drive rather than use a unc. I might be wrong though. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Steve Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:58 PM To: CF-Talk Subject: access odbc connection Here's the deal. We need to connect to an access database that resides on another server. I know to use the UNC path, and to make sure the ColdFusion service has rights to open the database on the other machine. There is no username and password for the database. The issue is that CF cannot verify the data source. I can set it up in Windows 2000 server and I can connect to it using SQLCon32. What else do I need to do in order to make CF verify the connection? TIA Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com http://www.comspecinternational.com/ phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com http://www.empower-xl.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Large file uploads
Can't say I can. However like always, if there is enough demand I will be happy to create and write an article on it. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:02 PM To: CF-Talk Subject: RE: Large file uploads Can you recommend any servlets that work well and are free? Dave -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 4:34 PM To: CF-Talk Subject: RE: Large file uploads I would suggest using a servlet to handle file uploads as you can stream the file to disk. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Suzanne Capener [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:25 PM To: CF-Talk Subject: Large file uploads I have the same issue. I don't like the answer of RAM because I am running on a gigahertz with 768MB of ram. While uploading the 10MB file, the CPU maxed out at 100% for 2 minutes. My physical memory usage is only have the capacity. Anyone have any suggestions? Perhaps there is something that I am missing? Anyone tried any alternatives and found a more efficient solution? Thanks, Suz I did change my page file to another drive with more space and increased it and found a significant increase in performance, but 2 minutes is still too long for the CPU to spike. The page memory does not max out either. anyone worked out ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CF 5 Page Filing massively... Ideas?
I would look for queries that could potentially return a very large number of rows. Since queries are completely loaded into memory as part of cfquery, it doesn't take much to grab tons of RAM that way. -Original Message- From: Jeremy Bruck - MfgQuote, Inc. [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:24 PM To: CF-Talk Subject: CF 5 Page Filing massively... Ideas? Everyone, We have had a challenge for the last 2 months with no ability to track it down and solve it. We are running CF 5 on Win2K with Dual P3 @ 1Ghz and 1Gig of Ram. We normally only use about 400-500 meg of ram, but once to twice per week right now we are filling up memory to 2.5ish gig and massively pagefiling. Database is on another server with same hardware config. We can't restart the CF service when this happens, and the only way to deal with it is to reboot the box. Part of me thinks the problems is overall load on the box -- average of 8000 to 1 unique visitors on the site per day and this doesn't include 500ish members on the system hammering it. Are there any tools to know what is using up the pagefile memory on Win2k? Any ideas what could be causing CF to eat up that much memory? Thanks, Jeremy Jeremy Bruck, VP of Technology ::MfgQuote 2690 Cumberland Parkway SE Suite 510 Atlanta, GA 30339 TEL: 678.556.2929 FAX: 678.556.2980 www.mfgquote.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFC output
Does this back up what I said though? If you break away the display from the logic used to generate it, wouldn't the display be left to the calling template and not the CFC? Ie, for the method, um, whatever, the method would return a string and the caller would handle outputting, or perhaps saving it to a file, whatever, the point is that the CFC wouldn't output, it would just return the result. The caller would handle the result. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Kevin Bridges [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:23 PM To: CF-Talk Subject: RE: CFC output Think we should listen to Matt on this one ... 3 letters for dealing with cfcs: MVC (Model - View - Controller) ... learn it, live it, love it. Kevin Bridges -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:09 PM To: CF-Talk Subject: RE: CFC output The logic used to derive those results should be decoupled from the display. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: access odbc connection
CF will only read local drives. I'm positive you have to use the UNC path. -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:05 PM To: CF-Talk Subject: RE: access odbc connection I believe you have to map the drive rather than use a unc. I might be wrong though. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Steve Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:58 PM To: CF-Talk Subject: access odbc connection Here's the deal. We need to connect to an access database that resides on another server. I know to use the UNC path, and to make sure the ColdFusion service has rights to open the database on the other machine. There is no username and password for the database. The issue is that CF cannot verify the data source. I can set it up in Windows 2000 server and I can connect to it using SQLCon32. What else do I need to do in order to make CF verify the connection? TIA Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com http://www.comspecinternational.com/ phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com http://www.empower-xl.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Macromedia Contribute
I'm thinking that Contribute offers a great opportunity for install/configuration/training, with a good upsell for a full-featured, custom CMS in some cases - either immediately or down the road. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:48 PM To: CF-Talk Subject: RE: Macromedia Contribute Depends on who we are talking about. Some business will be excited about Contribute. Others will understand or find out the hard way that they really need a CMS. Of course many are still finding out the hard way that CMS is an often abused term and that home grown systems aren't going to meet their future needs. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:11 PM To: CF-Talk Subject: RE: Macromedia Contribute Actually, I don't see any difference other than where it runs. If you can integrate it into your application and give your customer this power from anywhere they've got a web connection then that's an added service that's tied into their application and thus tied into you. If they can buy it for $99 at Staples and run it at home then why do they need to pay you for a content management system? Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:54 PM To: CF-Talk Subject: Re: Macromedia Contribute Personally, my answer to that is an emphatic NO. Thats my job to build a system that my customers can use to do that. If Macromedia becomes an end-user solutions provider it undercuts my business. Contribute is fine as a generic and rather basic solution. It has a fine niche and, speaking for myself, I hope it stays there. --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --- -- Original Message -- from: Joshua Miller [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 9 Dec 2002 14:34:47 -0500 Just got a snazzy tri-fold in the mail today about Macromedia Contribute. It looks great, too bad it doesn't run on the web. Wouldn't it be nice to make Contribute a Java application that could be integrated into an existing web-application to give this kind of power/control to us developers so that we could hand it out to whoever needs to use it - and have it be web-based so as not to have to maintain software installations on multiple users' machines? Just a thought. At $99 it's a good deal, but it would be more useful if it would run on the web. My $0.02 Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-9044 ext. 254 *** * * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] *** * * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to
Warning: Page has Expired
I have no doubt that this is a no brainer but I can't seem to find the answer. I've tried setting the expiration in the meta tag but it doesn't seem to give me the result I want. I want a page to expire if it is either refreshed or if someone tries to hit the back button to see the page. How would I go about that? I would like to invoke that standard page that we've all seen before with Warning: Page has Expired. Thanks -Jason
RE: access odbc connection
Yes, but I mean map the remote drive to a local drive letter. (sorry, but I might not be using the correct terminology). \\othercomputer\c$ is mapped to j: locally(cfserver). So the cfserver would have a mapped drive, j:, which is actually c: on the other computer. Can someone verify this is the proper way to accomplish what Steve is trying to do? I searched the macromedia forums but couldn't find it. I could have sworn I saw this somewhere though. I'll try locally and email shortly. -Original Message- From: Steve Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 4:15 PM To: CF-Talk Subject: RE: access odbc connection CF will only read local drives. I'm positive you have to use the UNC path. -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:05 PM To: CF-Talk Subject: RE: access odbc connection I believe you have to map the drive rather than use a unc. I might be wrong though. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Steve Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:58 PM To: CF-Talk Subject: access odbc connection Here's the deal. We need to connect to an access database that resides on another server. I know to use the UNC path, and to make sure the ColdFusion service has rights to open the database on the other machine. There is no username and password for the database. The issue is that CF cannot verify the data source. I can set it up in Windows 2000 server and I can connect to it using SQLCon32. What else do I need to do in order to make CF verify the connection? TIA Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com http://www.comspecinternational.com/ phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com http://www.empower-xl.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Warning: Page has Expired
AFAIK: To get the page has expired message, you have to have posted information from a form submission. But why would you want to? Jared Clinton. -Original Message- From: Stevens, Jason [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 10 December 2002 8:16 AM To: CF-Talk Subject: Warning: Page has Expired I have no doubt that this is a no brainer but I can't seem to find the answer. I've tried setting the expiration in the meta tag but it doesn't seem to give me the result I want. I want a page to expire if it is either refreshed or if someone tries to hit the back button to see the page. How would I go about that? I would like to invoke that standard page that we've all seen before with Warning: Page has Expired. Thanks -Jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Macromedia Contribute
This is exactly my point - I've seen ActivEdit before and it's a fabulous product, and this is what I had assumed Contribute is - just a desktop-only version. And yes, you're right, JAVA Applets probably aren't the best method. I have yet to find a product like ActivEdit that works well on say a MAC running Mozilla (granted I haven't used your 3.0 product). I was merely stating that it would be nice to see our software vendor make a plugin solution for this niche. Although, perhaps not so nice for the folks at CFDev ;) From my experience, albeit not as much as many of you on the list, when I toss in a product like the SiteObjects editor into a customer's site, they love it. They can make the small, text-based changes that they want to make, I don't have to deal with minor text modifications or even adding photographs or links and they save money. It's not really a matter of taking money out of your pocket unless you live by small static HTML changes - if you do then I see your concern, but a desktop application that can be used without your knowledge, input or assistance would scare me more than something web-based that you setup and implement for them (like ActivEdit). From my experience, when you give customers tools to make their lives easier and that save them time and money, they come back to you for the dynamic stuff that we all love to build. Anyway, my original post was more of a cry for something like ActivEdit that would be official Macromedia Software that would work across multiple browsers and platforms. I guess I should just look into ActivEdit and keep my mouth shut about Macromedia making their own. Again, I'm still lost as to how anyone would lose money because of Contribute any more than they would with something like FrontPage or Dreamweaver or ActivEdit for that matter. If someone wants to maintain a static HTML site with an extremely litmited toolset more power to them. That's sort of like being worried by pen manufacturers because you're a writer - true some people will write themselves, but if they want professional quality then they'll need to consult a professional. Anyway, this is pretty OT at this point and probably belongs on another list. Sorry for starting an OT thread. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:56 PM To: CF-Talk Subject: RE: Macromedia Contribute Wouldn't it be nice to make Contribute a Java application that could be integrated into an existing web-application to give this kind of power/control to us developers so that we could hand it out to whoever needs to use it - and have it be web-based so as not to have to maintain software installations on multiple users' machines? Just a thought. At $99 it's a good deal, but it would be more useful if it would run on the web. Actually we have such an application, ActivEdit (http://www.cfdev.com/activedit/) in the latest version it includes a Java Applet WYSIWYG Editor, and it starts at $99 as well. Granted it doesn't have all the features that contribute has. But I think your overestimating how well Java Applets work across the board. There are big issues when it comes to getting Java Applets working on Mac (mainly the LiveConnect API isn't implemented fully on Mac OSX browsers). Applets do work quite well on Windows, and reasonably well on Linux however. I can relate to Macromedia Contribute undercutting many of their customers, I don't think its helping their popularity with the development community. However customers that don't want to be tied to desktop software, and installation issues I think will still go for a web based WYSIWYG editor/content manager. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to
RE: access odbc connection
CF administrator doesn't read network drives even if they are mapped locally. -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:21 PM To: CF-Talk Subject: RE: access odbc connection Yes, but I mean map the remote drive to a local drive letter. (sorry, but I might not be using the correct terminology). \\othercomputer\c$ is mapped to j: locally(cfserver). So the cfserver would have a mapped drive, j:, which is actually c: on the other computer. Can someone verify this is the proper way to accomplish what Steve is trying to do? I searched the macromedia forums but couldn't find it. I could have sworn I saw this somewhere though. I'll try locally and email shortly. -Original Message- From: Steve Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 4:15 PM To: CF-Talk Subject: RE: access odbc connection CF will only read local drives. I'm positive you have to use the UNC path. -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:05 PM To: CF-Talk Subject: RE: access odbc connection I believe you have to map the drive rather than use a unc. I might be wrong though. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Steve Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:58 PM To: CF-Talk Subject: access odbc connection Here's the deal. We need to connect to an access database that resides on another server. I know to use the UNC path, and to make sure the ColdFusion service has rights to open the database on the other machine. There is no username and password for the database. The issue is that CF cannot verify the data source. I can set it up in Windows 2000 server and I can connect to it using SQLCon32. What else do I need to do in order to make CF verify the connection? TIA Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com http://www.comspecinternational.com/ phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com http://www.empower-xl.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Warning: Page has Expired
This is what I use, seems to work pretty well. I put it into an include file and use it in the header of all the pages I serve up that require cache control. I belive this was from someone else on the list from not too long ago: !--- Client side cache prevention --- !--- Setup our expire times for Netscape and Internet Explorer --- cfoutput !--- Internet Explorer Date Formate: (Fri, 30 Oct 1998 14:19:41 GMT) --- cfset MSIEtimestamp='#dateformat(now(),DDD)#,#dateformat(now(),DD)# #dateformat(now(),Mmm)# #timeformat(now(),HH:MM:SS)#' !--- Netscape Date Formate: Netscape (Wednesday, Apr 26 2000 17:45:25 PM) --- cfset NETSCAPEtimestamp='#dateformat(now(),)#,#dateformat(now(),MMM)# #dateformat(now(),dd)# #dateformat(now(),YYY)# #timeformat(now(),HH:MM:SS tt)#' /cfoutput !--- Tell HTTP Header to force expire of page - nocache --- cfif HTTP_USER_AGENT contains MSIE cfheader name=Expires value=cfoutput#MSIEtimestamp#/cfoutput cfheader name=Pragma value=no-cache cfheader name=cache-control value=no-cache, no-store, must-revalidate cfhtmlhead text='meta http-equiv=Expires content=0' cfelse cfheader name=Expires value=cfoutput#NETSCAPEtimestamp#/cfoutput cfheader name=Pragma value=no-cache cfheader name=cache-control value=no-cache, no-store, must-revalidate cfhtmlhead text='meta http-equiv=Expires content=0' /cfif Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Jared Clinton [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:24 PM To: CF-Talk Subject: RE: Warning: Page has Expired AFAIK: To get the page has expired message, you have to have posted information from a form submission. But why would you want to? Jared Clinton. -Original Message- From: Stevens, Jason [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 10 December 2002 8:16 AM To: CF-Talk Subject: Warning: Page has Expired I have no doubt that this is a no brainer but I can't seem to find the answer. I've tried setting the expiration in the meta tag but it doesn't seem to give me the result I want. I want a page to expire if it is either refreshed or if someone tries to hit the back button to see the page. How would I go about that? I would like to invoke that standard page that we've all seen before with Warning: Page has Expired. Thanks -Jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: access odbc connection
Got it. -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:21 PM To: CF-Talk Subject: RE: access odbc connection Yes, but I mean map the remote drive to a local drive letter. (sorry, but I might not be using the correct terminology). \\othercomputer\c$ is mapped to j: locally(cfserver). So the cfserver would have a mapped drive, j:, which is actually c: on the other computer. Can someone verify this is the proper way to accomplish what Steve is trying to do? I searched the macromedia forums but couldn't find it. I could have sworn I saw this somewhere though. I'll try locally and email shortly. -Original Message- From: Steve Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 4:15 PM To: CF-Talk Subject: RE: access odbc connection CF will only read local drives. I'm positive you have to use the UNC path. -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:05 PM To: CF-Talk Subject: RE: access odbc connection I believe you have to map the drive rather than use a unc. I might be wrong though. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Steve Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:58 PM To: CF-Talk Subject: access odbc connection Here's the deal. We need to connect to an access database that resides on another server. I know to use the UNC path, and to make sure the ColdFusion service has rights to open the database on the other machine. There is no username and password for the database. The issue is that CF cannot verify the data source. I can set it up in Windows 2000 server and I can connect to it using SQLCon32. What else do I need to do in order to make CF verify the connection? TIA Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com http://www.comspecinternational.com/ phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com http://www.empower-xl.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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