Re: Calling a CFC from perl
On Monday, Jan 20, 2003, at 08:10 US/Pacific, Brad Howerter wrote: cfcomponent output=false cffunction name=hi returnType=string output=no access=remote cfreturn 'hello, world' /cffunction /cfcomponent And here's how I'm trying to access it: cfscript ws = CreateObject(webservice, http://webftc18/com/woodward/example.cfc?wsdl;); mystring = ws.hi(); writeoutput(mystring); /cfscript This looks reasonable. I tried your code and it worked just fine. The only thing I can think of is the WSDL URL you used. If the WS is on the same machine, you could use 'localhost': http://localhost/com/woodward/example.cfc?wsdl You can test the component is accessible by typing these URLs into your browser: http://localhost/com/woodward/example.cfc http://localhost/com/woodward/example.cfc?wsdl http://webftc18/com/woodward/example.cfc http://webftc18/com/woodward/example.cfc?wsdl If all of these come up, but changing webftc18 to localhost in your CF code doesn't work, I don't know what to suggest. Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Instant Messaging using CF
Hi there, my client wants a custom IM application for his website. I downloaded a free IM app from macromedias website, the only thing is finding a way to get the application window to pop-up on User B's computer when user A on a different computer tries to IM them. Can this even be done using ColdFusion and if so could anyone lead me in the right direction. Thanks, This is an interesting question. The problem arises because the very thing the web is good (i.e. stateless, and therefore scalable connections), makes it difficult to use a service like IM (which by it nature is a stateful app.) Once a browser makes a request from a website, it gets the current page content and displays it, and then disconnects (well its meant to, MS IExplorer ignores this sometimes). [assuming no Java Applets etc.] So how do you get around this? There are a few options : a) request a page every x seconds - the usually why to do this is to use JavaScript, in a frame or iframe, to call page.cfm to check for any messages b) Have a frame containing a page that is cfflushed every time a message is posted... (Don't like this myself, keeps a connection open) c) Use a technology like Java Applet / ActiveX - that can manages state in a different manner d) get your clients to use a IM system like AOL etc. and use CF to send message to them, that way. (Look at Bens Book J2ee/MX for an example using Jabber www.jabber.org) As you can see there is no right way. All have their pro's and con's. Just like all the great questions in life .. WG ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
XML Primer Request (basic)
And if it is CFMX that you're working with, along with the pdf I'd heavily suggest this page : http://localhost:8500/cfdocs/Developing_ColdFusion_MX_Applications_with_CFML/XML7.html in your docs ,.. (of course depending on how you installed it) It's often over missed, but since its giving you a formalized table of what function to use, it's been a great asset to me when working on a xml project I'm in the middle of.. Robby (first actual post, lol) ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfchartseries in CF 5 ?
Hi list, is there an equivalent to cfchartseries (CFMX) in CF 5 to display several independent graphs in only one graph-set ? 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfchartseries in CF 5 ?
No -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: dinsdag 21 januari 2003 13:37 To: CF-Talk Subject: cfchartseries in CF 5 ? Hi list, is there an equivalent to cfchartseries (CFMX) in CF 5 to display several independent graphs in only one graph-set ? 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Updating database
Hi, I have this code that updated my MySQL database successfully. I'm testing this out on another PC with just Access. WHen I try to update the database I get the following error? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. Below is my query for my MySQL database. Is the syntax different for MS Access? cfquery name=update_alias DATASOURCE=alias dbtype=ODBC INSERT alias SET env_var=#ListGetAt(Line,1,'|')#, destination=#ListGetAt(Line,2,'|')# /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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Updating database
Try using single quotes instead of double quotes... This should then work for both access and mySQL HTH -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 12:49 To: CF-Talk Subject: Updating database Hi, I have this code that updated my MySQL database successfully. I'm testing this out on another PC with just Access. WHen I try to update the database I get the following error? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. Below is my query for my MySQL database. Is the syntax different for MS Access? cfquery name=update_alias DATASOURCE=alias dbtype=ODBC INSERT alias SET env_var=#ListGetAt(Line,1,'|')#, destination=#ListGetAt(Line,2,'|')# /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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Updating database
cfquery name=update_alias DATASOURCE=alias dbtype=ODBC INSERT INTO alias (env_var,destination) VALUES('#ListGetAt(Line,1,|)#','#ListGetAt(Line,2,|)#') /cfquery -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: dinsdag 21 januari 2003 13:49 To: CF-Talk Subject: Updating database Hi, I have this code that updated my MySQL database successfully. I'm testing this out on another PC with just Access. WHen I try to update the database I get the following error? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. Below is my query for my MySQL database. Is the syntax different for MS Access? cfquery name=update_alias DATASOURCE=alias dbtype=ODBC INSERT alias SET env_var=#ListGetAt(Line,1,'|')#, destination=#ListGetAt(Line,2,'|')# /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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Database queries
The second is ok. Avoids problems if you switch to another driver (I speak from experience) -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: dinsdag 21 januari 2003 13:51 To: CF-Talk Subject: Database queries Do I require the type on my queries? cfquery name=update DATASOURCE=database dbtype=ODBC -or- cfquery name=update DATASOURCE=database --- 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Database queries
From the docs : New in ColdFusion MX: The connectString, dbName, dbServer, provider, providerDSN, and sql attributes, and all values of the dbtype attribute except query, are deprecated. Do not use them. They do not work, and might cause an error, in releases later than ColdFusion 5. WG -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 12:51 To: CF-Talk Subject: Database queries Do I require the type on my queries? cfquery name=update DATASOURCE=database dbtype=ODBC -or- cfquery name=update DATASOURCE=database --- 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Updating database
That worked. Thanks I tried to incorporate the same type of code to the example below but I also get an error on this. MySQL: - cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect=#ListGetAt(commalist,1,'|')# /cfquery Access: -- cfquery name=Update DATASOURCE=prefs dbtype=ODBC UPDATE tblProfiles (strSelect) VALUES('#ListGetAt(commalist,1,'|')#') /cfquery On Tue, 21 Jan 2003 13:53:41 +0100, Pascal Peters wrote: cfquery name=update_alias DATASOURCE=alias dbtype=ODBC INSERT INTO alias (env_var,destination) VALUES('#ListGetAt(Line,1,|)#','#ListGetAt(Line,2,|)#') /cfquery -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: dinsdag 21 januari 2003 13:49 To: CF-Talk Subject: Updating database Hi, I have this code that updated my MySQL database successfully. I'm testing this out on another PC with just Access. WHen I try to update the database I get the following error? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. Below is my query for my MySQL database. Is the syntax different for MS Access? cfquery name=update_alias DATASOURCE=alias dbtype=ODBC INSERT alias SET env_var=#ListGetAt(Line,1,'|')#, destination=#ListGetAt(Line,2,'|')# /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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating database
FlashGuy wrote: Access: -- cfquery name=Update DATASOURCE=prefs dbtype=ODBC UPDATE tblProfiles (strSelect) VALUES('#ListGetAt(commalist,1,'|')#') /cfquery You are mixing insert and update syntax, correct syntax should be: INSERT INTO table (field [, field]) VALUES (value [, value]) UPDATE table SETfield = value [, field = value] 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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Deleting a row from a query?
How funny the certified Macromedia instuctor can't suggest a query of query, Go get a fuction? are you kidding? I'm your not my instuctor. Being able to solve a problem quickly and simply should be the goal here. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Deleting a row from a query?
please decipher the message below into something meaningful. thank you. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 7:19 AM To: CF-Talk Subject: Deleting a row from a query? How funny the certified Macromedia instuctor can't suggest a query of query, Go get a fuction? are you kidding? I'm your not my instuctor. Being able to solve a problem quickly and simply should be the goal here. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Instant Messaging using CF
I will add one additional option to WG's list here: Flash Communication Server. Your two options for persistent connections (which is what you need to send an event from the server to the client without the client polling every n seconds) are Java applets and Flash Communication Server. If your client is willing to spend some money, look into Flashcom. If not, consider an applet, or one of WG's suggestions below. WG is right, though, in that the model the web is based on (request/response and the stateless nature of HTTP) is not conducive to this type of application, hence the need for some other technology. Christian On Tuesday, January 21, 2003, at 06:01 AM, webguy wrote: Hi there, my client wants a custom IM application for his website. I downloaded a free IM app from macromedias website, the only thing is finding a way to get the application window to pop-up on User B's computer when user A on a different computer tries to IM them. Can this even be done using ColdFusion and if so could anyone lead me in the right direction. Thanks, This is an interesting question. The problem arises because the very thing the web is good (i.e. stateless, and therefore scalable connections), makes it difficult to use a service like IM (which by it nature is a stateful app.) Once a browser makes a request from a website, it gets the current page content and displays it, and then disconnects (well its meant to, MS IExplorer ignores this sometimes). [assuming no Java Applets etc.] So how do you get around this? There are a few options : a) request a page every x seconds - the usually why to do this is to use JavaScript, in a frame or iframe, to call page.cfm to check for any messages b) Have a frame containing a page that is cfflushed every time a message is posted... (Don't like this myself, keeps a connection open) c) Use a technology like Java Applet / ActiveX - that can manages state in a different manner d) get your clients to use a IM system like AOL etc. and use CF to send message to them, that way. (Look at Bens Book J2ee/MX for an example using Jabber www.jabber.org) As you can see there is no right way. All have their pro's and con's. Just like all the great questions in life .. WG ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating database
Why do I need an INSERT command? I just want to update my table field. This worked fine in MySQL. On Tue, 21 Jan 2003 14:24:04 +0100, Jochem van Dieten wrote: FlashGuy wrote: Access: -- cfquery name=Update DATASOURCE=prefs dbtype=ODBC UPDATE tblProfiles (strSelect) VALUES('#ListGetAt(commalist,1,'|')#') /cfquery You are mixing insert and update syntax, correct syntax should be: INSERT INTO table (field [, field]) VALUES (value [, value]) UPDATE table SETfield = value [, field = value] 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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating database
I'll be surprised if it worked in MySQL. It's not even a valid SQL Statement. The statement you want is: UPDATE tablename SET (field) = (value) WHERE primaryKey = something RTM: http://www.mysql.com/doc/en/UPDATE.html ~Todd At 08:34 AM 1/21/2003 -0500, you wrote: Why do I need an INSERT command? I just want to update my table field. This worked fine in MySQL. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating database
FlashGuy wrote: Why do I need an INSERT command? You don't, I'm just given a complete reference. This worked fine in MySQL. Then MySQL is broken. 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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deleting a row from a query?
At 08:18 AM 1/21/2003, you wrote: How funny the certified Macromedia instuctor can't suggest a query of query, Go get a fuction? are you kidding? I'm your not my instuctor. Being able to solve a problem quickly and simply should be the goal here. I really don't think that's a fair complaint. Many people gave you answers on how to delete a row from a query (many of which didn't work as I recall) and after several posts one person came up with the idea of using QoQ. This is not an area where people traditionally use QoQ so I think it took a little bit of a conceptual jump to come up with the idea, and I applaud whoever it was that came up with it first. FYI, the QueryTable object does have an undocumented deleteRow function, but it's not implemented (throws an error, this feature not implemented). If this is a feature you need, ask MM to add in support for deleteRow (which would be much faster than QoQ). Also, I don't think you necessarily have to be a great programmer to be an instructor (instructors out there can correct me if I'm wrong). I think you pretty much need to know the material you're teaching backwards and forwards, but if it's outside the material then it's not fair game. I took a MM sponsored JSP course a few years ago. The instructor seemed fine, but in one example we were displaying dollar figures without standard U.S. number formatting. I asked her how to format numbers in Java and she spent a half hour looking through the API to figure it out. Finally she gave up. To her credit, she did have the answer the next day, but number formatting is such a common thing it appeared to me that she probably didn't have much practical experience if it took her so long to answer what appeared to be a simple question. My $0.02. Sam ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Deleting a row from a query?
what are you talking about? did I miss something :-) -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 12:19 To: CF-Talk Subject: Deleting a row from a query? How funny the certified Macromedia instuctor can't suggest a query of query, Go get a fuction? are you kidding? I'm your not my instuctor. Being able to solve a problem quickly and simply should be the goal here. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating database
I never received any errors when the code was run? On Tue, 21 Jan 2003 08:38:04 -0500, Todd wrote: I'll be surprised if it worked in MySQL. It's not even a valid SQL Statement. The statement you want is: UPDATE tablename SET (field) = (value) WHERE primaryKey = something RTM: http://www.mysql.com/doc/en/UPDATE.html ~Todd At 08:34 AM 1/21/2003 -0500, you wrote: Why do I need an INSERT command? I just want to update my table field. This worked fine in MySQL. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating database
Then, MySQL is definitely broken. Did you report this to the MySQL dev team as a bug? At 08:48 AM 1/21/2003 -0500, you wrote: I never received any errors when the code was run? On Tue, 21 Jan 2003 08:38:04 -0500, Todd wrote: I'll be surprised if it worked in MySQL. It's not even a valid SQL Statement. The statement you want is: UPDATE tablename SET (field) = (value) WHERE primaryKey = something RTM: http://www.mysql.com/doc/en/UPDATE.html ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MS SQL 2000 :: How to print table data
How can I print out all table data - fieldname/datatypes of a specific database in MS SQL 2000? Is there a stored procedure I should use? Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating database
No. I guess I should. On Tue, 21 Jan 2003 08:50:39 -0500, Todd wrote: Then, MySQL is definitely broken. Did you report this to the MySQL dev team as a bug? At 08:48 AM 1/21/2003 -0500, you wrote: I never received any errors when the code was run? On Tue, 21 Jan 2003 08:38:04 -0500, Todd wrote: I'll be surprised if it worked in MySQL. It's not even a valid SQL Statement. The statement you want is: UPDATE tablename SET (field) = (value) WHERE primaryKey = something RTM: http://www.mysql.com/doc/en/UPDATE.html ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS SQL 2000 :: How to print table data
in query analyzer use sp_help tablename (without the quotes). hth. mike -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 8:52 AM To: CF-Talk Subject: MS SQL 2000 :: How to print table data How can I print out all table data - fieldname/datatypes of a specific database in MS SQL 2000? Is there a stored procedure I should use? Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
reconnecting to MySQL
I recently migrated my CF sites from NT/Access to a Linux/MySQL box running Chilisoft. Everything runs alot faster, but I get this error when the user is idle for too long: [TCX][MyODBC]Lost connection to MySQL server during query Can someone suggest a painless way to reconnect to MySQL in this case? TIA ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC's and people management
I'm working on a site for a school district's adult ed program. They are requiring no less than 4 different access areas with multiple levels of control. After a little research I'm expanding upon a roles based security model that I originally read about on the MM site (CFC best practices: Component functions and function invocation by Anthony McClure, http://www.macromedia.com/desdev/mx/coldfusion/articles/cfc_practices.html). A very basic outline is given, and the sample includes (ohboy) an Access db, but with fairly minor modification it can be put together into a viable roles based security model. Cutter Gyrus wrote: Hi all, I'm planning an MX revamp to our bespoke CMS, and I'm wondering about restructuring the way people are handled, using CFC's. In my current system there are users who can login to the admin functions. This works fine, most of the time. Only, when you get clients who have login accounts to access a client-only area, I've often found myself having to create client accounts for users, so they can login to the client-only area as well to see the content they're managing. (BTW, this is all based on having a frontend and a backend, two separate CF applications. Obviously this issue would be ironed out if there's one site that can be administered from within - something I'm planning on trying.) It gets more complex when it comes to having company contacts - some of whom will be users - and maybe a more general category of people (one site I've built associated content items with one or more people, if there's an article about a specific person, or if the item is a review of an album, it links to the people table to specify the artists). I'm wondering whether I should just have one top-level people table / person.cfc that models and manages absolutely any types of people in the site. Then you'd maybe have subset tables / subtype CFC's like administrators, users, contacts, etc. In some cases there might be another level, e.g. person administrator developer, depending on whether developers would need much extra information about them storing. I'm only starting out with CFC's, so I'm just wondering whether this is a valid, effective way to start thinking about remodelling my CMS. Would I just end up with too many table joins accessing all those subset tables? Or would the fact that this will be done in CFC's reduce this problem by only having any less-than-easy SQL joins in one central place? Any comments/thoughts welcome, Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://norlonto.net PGP key available ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS SQL 2000 :: How to print table data
I find the easiest and quickest way is togo to SQL manager and open the table in design view. Click on the Print Screen button. paste pic onto word doc. Use format Picture to trim the extra space from the pic. I like the visual of this way- I get all the design info in a quick easy to read format. I also like grouping tables this way- I can often get several related tables on one page. Hope this helps. J -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 8:52 AM To: CF-Talk Subject: MS SQL 2000 :: How to print table data How can I print out all table data - fieldname/datatypes of a specific database in MS SQL 2000? Is there a stored procedure I should use? Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Integrating C#
Have the C# program return the variables as XML to be used by your CF app (C# has a lot of built in XML support) Cutter Brad Roberts wrote: I've got an application written in C# that I need to integrate into our CF app. The C# app makes a HTTP request, grabs a WDDX packet (a query with about 15,000 records), does some intense calculations, and returns just a few variables. Unfortunately, I know nothing about C#, and the programmer who does, knows nothing about CF. Any suggestions? -Brad ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Integrating C#
You can go web service route, but I'd just like to comment, xml web services, are not always the best solution. Web services xml have a performance overhead, especially Serializing / de-serializing to xml. Sometimes it is better a custom interfaces, or other remote method such as DCOM, corba, RMI... Web services and XML are not a panacea. They are pretty cool though :-) app. The C# app makes a HTTP request, grabs a WDDX packet (a query with about 15,000 records), does some intense calculations, and returns just a few variables. Also you chould get the c# app. to post to a cfm template. WG ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFSchedule question
How do I schedule a one time task with cfschedule. I get I can set the start and end date to the same one or is there a better way? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deleting a row from a query?
The question was How can I delete a row from a query? Answer, a query is a struct of associative arrays, find the array row and delete rows for each of the struct keys. Simon quite rightly pointed out that there is a UDF to do this on cflib, as I also had previously mentioned. How funny the certified Macromedia instuctor can't suggest a query of query, Simon was pointing out that the code I wrote off the top of my head to answer the question is already available on the cflib site, as I also had previously suggested. I didn't suggest Query of Query, because I don't and won't use it, nor will I recommend its use. CF isn't a database engine and QofQ is invariably horribly abused when the query should and can be done by the Database server. Given Jason's later comment regarding XML and size of file, I would still NOT use QofQ, but this my personal opinion and is something for Jason to test out. If you knew that Query of Query was an answer, how come you didn't answer? Go get a fuction? are you kidding? What's wrong with that? Its a quick simple solution. No re-inventing the wheel I'm your not my instuctor. Pardon? Being able to solve a problem quickly and simply should be the goal here. I think you'll find that most problems are solved here quicker than if you had to work it out on your own. Stephen ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Integrating C#
Hi Brad, I've got an application written in C# that I need to integrate into our CF app. The C# app makes a HTTP request, grabs a WDDX packet (a query with about 15,000 records), does some intense calculations, and returns just a few variables. Unfortunately, I know nothing about C#, and the programmer who does, knows nothing about CF. -- if the applications live on the same machine, and the C# guy can understand wddx, why not have the C# app write out a text file that contains a wddx packet w/ your variables.. It sounds like the C# app isn't something that will be run very frequently (ie: a) requesting via HTTP, b) 15,000 records, c) wddx) == lots of time) or at least it shouldn't be. :) AJ Aaron Johnson http://cephas.net/blog/ [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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF to MS Word or PDF - setting Margins and page size?
Has anyone worked with creating an MS Word or PDF doc where you control the margins? I have a site that will need to generate a 100 page document in book format - with a predefined paper size, margin settings and page numbering - especially opposing page margins : Left pages right margin of 1.25 inches left margin of 0.5 inches Right pages left margin 1.25 inches right margin 0.5 inches Paper size 5.25 x 7 Page Numbering Starting on page 3 number pages 1,2,3,etc... ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
TEST: is the list down?
no messages in quite some time now very unusual. ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TEST: is the list down?
Belay my last...operator difficulty... geez, I need another pot of coffee -Original Message- From: Moneymaker, Jon S CONT (WPNSTA Yorktown) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 9:47 AM To: CF-Talk Subject: TEST: is the list down? no messages in quite some time now very unusual. ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC's and people management
- Original Message - From: Cutter (CF_Talk) [EMAIL PROTECTED] I'm working on a site for a school district's adult ed program. They are requiring no less than 4 different access areas with multiple levels of control. After a little research I'm expanding upon a roles based security model that I originally read about on the MM site (CFC best practices: Component functions and function invocation by Anthony McClure, http://www.macromedia.com/desdev/mx/coldfusion/articles/cfc_practices.html). A very basic outline is given, and the sample includes (ohboy) an Access db, but with fairly minor modification it can be put together into a viable roles based security model. --- I'll check this out, but my post was less about user security models than about modelling people in a more general fashion using CFC's. So if there are company contacts, it's not necessarily so that every contact will have a login account. But some administrators might be contacts. So it seemed like it might be a good idea to have a top-level person CFC, which would contain stuff like name, email, personal info, etc., that would be common to all people on the site, then have a contact CFC and a administrator CFC, which both extend person. Another example is a personal project, http://norlonto.net, which has a table of people associated with content items. Relationships are formed between the content and people tables to specify interview subjects, authors of books reviewed, directors of films reviewed, etc. Then you can list all the content on the site associated with specific people: http://norlonto.net/index.cfm?action=browse.people Now, some of the contributors are interviewed on the site, or have their book reviewed. Without CFC's, and admittedly without as much planning as could have been done, the resulting code to manage the updating and synchronisation of contributors who also have a people record has become quite brain-curdling. This is what got me thinking about changing the template I use so that there is a top-level people DB table/CFC, with specific types of people - users, administrators, contacts, writers, directors, etc. - branching off with subtype CFC's. Anyone done anything similar? Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://norlonto.net PGP key available ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
What am I doing WRONG!?!?!
I'm no stranger to writing CF code and updataing a database is a snap, however I'm dumbfounded by this bug. Here is the setup Compaq server with CFMX running (upgraded from CF5) 1GIG or ram and 40gig of free space. The server processes istn even hitting 2% utilization yet. Ok here is the problem: I have a form to insert / update records to a database (Access) I know I would much rather use SQL but that id a different story, anyways I created a news form very simple feilds are title, date, and article, the tables defined in the database are as follows. ID = AutoNumber NewsTitle =text, 50 NewsDate = text, 50 NewsArticle =Memo Really Simple right... Well for some reason I cannot get the news article to show up it will update and I can insert a new record but when I do a CFDUMP of the query it says [empty string] under the NewsArticle feild is. But when I download the database from the server to view it, the table has the data in the feild. whats even more confusing is that the two other feild display and update fine. Here is the insert statment: cfinsert dbtype=ODBC datasource=srcs tablename=TeamNews formfields=NewsDate,NewsTitle,NewsArticle Here is the Update statment: cfquery datasource=srcs dbtype=ODBC UPDATE TeamNews SET NewsDate = '#NewsDate#', NewsTitle = '#NewsTitle#', NewsArticle = '#NewsArticle#' WHERE ID = #Update#; /cfquery Thanks in advance Ernie Pena U. T. MD Anderson ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF to MS Word or PDF - setting Margins and page size?
Hi Rafael, From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] Has anyone worked with creating an MS Word or PDF doc where you control the margins? I have a site that will need to generate a 100 page document in book format - with a predefined paper size, margin settings and page numbering - especially opposing page margins : I would suggest you look at xsl-fo http://www.xml.com/pub/a/2002/03/20/xsl-fo.html (this is a link to an overview rather than a xsl-fo engine) this does XML - PDF via XSL-fo (XSL formatting objects). FOP is best know XML-PDF formatter. Other options include a COM www.activePDF.com or using a command line tool. BTW if you are using the DOCBOOK format, there are probably more options out there, including Word DOCs to Docbook etc. WG ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Com Question
I'm having a problem where CFMX takes too long to release a COM object from memory. Being a single threaded-object it gets stuck in my error trap from a few seconds to a couple of minutes unitil it's released. It's a third party object and cannot change it's threading model. Will setting the object to Nothing as in ASP or VB help? Thanks, Frank ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
UPS Live Feed Problem
I've been using CF_UPSPrice to pull live UPS fees for shipping on a site for a couple years and recently anyone choosing Ground Commercial has been getting an error message back - does anyone know what happened with that method of shipping? ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Com Question
Not usually. FYI COM in MX is based on j-integra www.intrinsyc.com/products/j-integra/ As a matter of interest, try wrapping the COM in a cfc and see if that improves things. It has help some other memory release issues with cfhttp / cfftp. If it works, please let us know! WG -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 15:08 To: CF-Talk Subject: CFMX Com Question I'm having a problem where CFMX takes too long to release a COM object from memory. Being a single threaded-object it gets stuck in my error trap from a few seconds to a couple of minutes unitil it's released. It's a third party object and cannot change it's threading model. Will setting the object to Nothing as in ASP or VB help? Thanks, Frank ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMail Controlling Whitespace (was Best Practice) ARRGH!
hmm it got cut off, anyway heres the rest (if it doesnt get stripped out again) cfmail to=#to# from= subject=#inquiry# ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reconnecting to MySQL
On Tuesday 21 Jan 2003 14:05 pm, Rahmin Pavlovic wrote: [TCX][MyODBC]Lost connection to MySQL server during query Can someone suggest a painless way to reconnect to MySQL in this case? Wrap the call in a try/catch block that retrys till it works. -- Tom C Space Core Directive 68250: [CENSORED- Impossible without at least one live chicken and a rabbi] ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What am I doing WRONG!?!?!
check your ODBC drivers. make sure you have the latest ones... especially since you upgraded to MX where JDBC is now an issue. hth, mike -Original Message- From: Ernie Pena [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 10:01 AM To: CF-Talk Subject: What am I doing WRONG!?!?! I'm no stranger to writing CF code and updataing a database is a snap, however I'm dumbfounded by this bug. Here is the setup Compaq server with CFMX running (upgraded from CF5) 1GIG or ram and 40gig of free space. The server processes istn even hitting 2% utilization yet. Ok here is the problem: I have a form to insert / update records to a database (Access) I know I would much rather use SQL but that id a different story, anyways I created a news form very simple feilds are title, date, and article, the tables defined in the database are as follows. ID = AutoNumber NewsTitle =text, 50 NewsDate = text, 50 NewsArticle =Memo Really Simple right... Well for some reason I cannot get the news article to show up it will update and I can insert a new record but when I do a CFDUMP of the query it says [empty string] under the NewsArticle feild is. But when I download the database from the server to view it, the table has the data in the feild. whats even more confusing is that the two other feild display and update fine. Here is the insert statment: cfinsert dbtype=ODBC datasource=srcs tablename=TeamNews formfields=NewsDate,NewsTitle,NewsArticle Here is the Update statment: cfquery datasource=srcs dbtype=ODBC UPDATE TeamNews SET NewsDate = '#NewsDate#', NewsTitle = '#NewsTitle#', NewsArticle = '#NewsArticle#' WHERE ID = #Update#; /cfquery Thanks in advance Ernie Pena U. T. MD Anderson ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What am I doing WRONG!?!?!
It is most likely long text retrieval option in the data source setup. Go into cf administrator and edit the data source. I had this issue the 1st time I upgraded a Cf5 box to MX, none of them access data sources would retrieve memo text fields. Fortunately, it only takes 2 seconds to fix. -Original Message- From: Ernie Pena [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 15:01 To: CF-Talk Subject: What am I doing WRONG!?!?! I'm no stranger to writing CF code and updataing a database is a snap, however I'm dumbfounded by this bug. Here is the setup Compaq server with CFMX running (upgraded from CF5) 1GIG or ram and 40gig of free space. The server processes istn even hitting 2% utilization yet. Ok here is the problem: I have a form to insert / update records to a database (Access) I know I would much rather use SQL but that id a different story, anyways I created a news form very simple feilds are title, date, and article, the tables defined in the database are as follows. ID = AutoNumber NewsTitle =text, 50 NewsDate = text, 50 NewsArticle =Memo Really Simple right... Well for some reason I cannot get the news article to show up it will update and I can insert a new record but when I do a CFDUMP of the query it says [empty string] under the NewsArticle feild is. But when I download the database from the server to view it, the table has the data in the feild. whats even more confusing is that the two other feild display and update fine. Here is the insert statment: cfinsert dbtype=ODBC datasource=srcs tablename=TeamNews formfields=NewsDate,NewsTitle,NewsArticle Here is the Update statment: cfquery datasource=srcs dbtype=ODBC UPDATE TeamNews SET NewsDate = '#NewsDate#', NewsTitle = '#NewsTitle#', NewsArticle = '#NewsArticle#' WHERE ID = #Update#; /cfquery Thanks in advance Ernie Pena U. T. MD Anderson ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
QofQ Joins
Is it possible to do an outer join in a query of queries? I can't find any good documentation that explains QofQ's capabilities/limitations. It seems to support inner joins, but I haven't come up with an outer join syntax that doesn't throw an error. Thanks, - Sean ~~ Sean Daniels Director of Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What am I doing WRONG!?!?!
WHOOHOO!!! that did the trick Thanks a bunch! EP! - Original Message - From: Craig Dudley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 9:41 AM Subject: RE: What am I doing WRONG!?!?! It is most likely long text retrieval option in the data source setup. Go into cf administrator and edit the data source. I had this issue the 1st time I upgraded a Cf5 box to MX, none of them access data sources would retrieve memo text fields. Fortunately, it only takes 2 seconds to fix. -Original Message- From: Ernie Pena [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 15:01 To: CF-Talk Subject: What am I doing WRONG!?!?! I'm no stranger to writing CF code and updataing a database is a snap, however I'm dumbfounded by this bug. Here is the setup Compaq server with CFMX running (upgraded from CF5) 1GIG or ram and 40gig of free space. The server processes istn even hitting 2% utilization yet. Ok here is the problem: I have a form to insert / update records to a database (Access) I know I would much rather use SQL but that id a different story, anyways I created a news form very simple feilds are title, date, and article, the tables defined in the database are as follows. ID = AutoNumber NewsTitle =text, 50 NewsDate = text, 50 NewsArticle =Memo Really Simple right... Well for some reason I cannot get the news article to show up it will update and I can insert a new record but when I do a CFDUMP of the query it says [empty string] under the NewsArticle feild is. But when I download the database from the server to view it, the table has the data in the feild. whats even more confusing is that the two other feild display and update fine. Here is the insert statment: cfinsert dbtype=ODBC datasource=srcs tablename=TeamNews formfields=NewsDate,NewsTitle,NewsArticle Here is the Update statment: cfquery datasource=srcs dbtype=ODBC UPDATE TeamNews SET NewsDate = '#NewsDate#', NewsTitle = '#NewsTitle#', NewsArticle = '#NewsArticle#' WHERE ID = #Update#; /cfquery Thanks in advance Ernie Pena U. T. MD Anderson ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QofQ Joins
ColdFusion does not support OUTER JOIN or INNER JOIN syntax, as the following example shows it does however support INNER JOINs between two tables : SELECT product_ID, shipping_ID FROM product, shipping WHERE product.product_ID = shipping.shipping_ID -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 15:52 To: CF-Talk Subject: QofQ Joins Is it possible to do an outer join in a query of queries? I can't find any good documentation that explains QofQ's capabilities/limitations. It seems to support inner joins, but I haven't come up with an outer join syntax that doesn't throw an error. Thanks, - Sean ~~ Sean Daniels Director of Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Selecting First/Last Record in query
How to I get the first or last record in a query? T ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QofQ Joins
I'm pretty sure that an outer join expects to find two 'tables' to work with. The QofQ returns a singular result set (probably viewed by CF as a single table). So, in theory, an outer join wouldn't work on a OofQ. thanx Denny -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 8:52 AM To: CF-Talk Subject: QofQ Joins Is it possible to do an outer join in a query of queries? I can't find any good documentation that explains QofQ's capabilities/limitations. It seems to support inner joins, but I haven't come up with an outer join syntax that doesn't throw an error. Thanks, - Sean ~~ Sean Daniels Director of Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Selecting First/Last Record in query
count the number of records / array : then reference them using Array Syntax or using a row count procedure. job done. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 16:01 To: CF-Talk Subject: Selecting First/Last Record in query How to I get the first or last record in a query? T ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Selecting First/Last Record in query
For the first: Select TOP 1 * From Table For the last: Select MAX (FieldName) AS Alias From Table - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 10:01 AM Subject: Selecting First/Last Record in query How to I get the first or last record in a query? T ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QofQ Joins
-- Original Message -- From: Robertson-Ravo, Neil (RX) Neil.Robertson- ColdFusion does not support OUTER JOIN or INNER JOIN syntax, as the following example shows it does however support INNER JOINs between two tables : SELECT product_ID, shipping_ID FROM product, shipping WHERE product.product_ID = shipping.shipping_ID Are you talking about only within Query of Queries (as Sean asked) or in general. Your example looks like a regular (non-QofQ) query, and I can tell you that ColdFusion DOES support Outer Join and Inner Join syntax (for at least SQL Server and Oracle, if nothing else), because I use it all the time (particularly in Oracle). I don't think you can use any joins within a QofQ, because I don't think you can query 2 separate queries. (However, I'm not certain of that, having never tried it.) Scott Brady http://www.scottbrady.net/ ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Selecting First/Last Record in query
from sql, or once it has already been returned to cf? from sql: select min(whateverColumn) from foo where foo = foo from cf: a bit trickier, however, I would start with query.recordCount as a number that will be important to you, and something that would help you. I know the query is returned as a structure, you could get the first position of the structure, and then the position of the structure that is equal to query.recordCount hthx ...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: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:01 AM To: CF-Talk Subject: Selecting First/Last Record in query How to I get the first or last record in a query? T ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Selecting First/Last Record in query - Solved
At 12:01 PM 01/21/03 -0400, Thane Sherrington wrote: How to I get the first or last record in a query? I got it. I used the SQL First and Last functions. They appear to do what I want. T ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QofQ Joins
only with Query of Queries.ColdFusion doesn't give a stuff what SQL you use as long as its valid for the DB or ODBC (etc) driver. -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 16:08 To: CF-Talk Subject: RE: QofQ Joins -- Original Message -- From: Robertson-Ravo, Neil (RX) Neil.Robertson- ColdFusion does not support OUTER JOIN or INNER JOIN syntax, as the following example shows it does however support INNER JOINs between two tables : SELECT product_ID, shipping_ID FROM product, shipping WHERE product.product_ID = shipping.shipping_ID Are you talking about only within Query of Queries (as Sean asked) or in general. Your example looks like a regular (non-QofQ) query, and I can tell you that ColdFusion DOES support Outer Join and Inner Join syntax (for at least SQL Server and Oracle, if nothing else), because I use it all the time (particularly in Oracle). I don't think you can use any joins within a QofQ, because I don't think you can query 2 separate queries. (However, I'm not certain of that, having never tried it.) Scott Brady http://www.scottbrady.net/ ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QofQ Joins
SELECT product_ID, shipping_ID FROM product, shipping WHERE product.product_ID = shipping.shipping_ID This is a commonly referred to as JOIN between tables -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 16:08 To: CF-Talk Subject: RE: QofQ Joins -- Original Message -- From: Robertson-Ravo, Neil (RX) Neil.Robertson- ColdFusion does not support OUTER JOIN or INNER JOIN syntax, as the following example shows it does however support INNER JOINs between two tables : SELECT product_ID, shipping_ID FROM product, shipping WHERE product.product_ID = shipping.shipping_ID Are you talking about only within Query of Queries (as Sean asked) or in general. Your example looks like a regular (non-QofQ) query, and I can tell you that ColdFusion DOES support Outer Join and Inner Join syntax (for at least SQL Server and Oracle, if nothing else), because I use it all the time (particularly in Oracle). I don't think you can use any joins within a QofQ, because I don't think you can query 2 separate queries. (However, I'm not certain of that, having never tried it.) Scott Brady http://www.scottbrady.net/ ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
DHTML menu and select boxes
I've created a dhtml menu system using Fireworks but the dropdown menu doesn't appear on top of a form select box. Is this not possible? I know you can change settings in Flash and Java applets. Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Selecting First/Last Record in query
Or you can do it the CF way: first record: #myQuery.ColumnName# (outside of a loop) OR #myQuery.ColumnName[1]# last record: #myQuery.ColumnName[myQuery.RecordCount]# Tyler - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 11:05 AM Subject: Re: Selecting First/Last Record in query For the first: Select TOP 1 * From Table For the last: Select MAX (FieldName) AS Alias From Table - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 10:01 AM Subject: Selecting First/Last Record in query How to I get the first or last record in a query? T ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Selecting First/Last Record in query
You can access the query as a array as follows: First Record : #myquery.myfield[1]#, #myquery.myfield2[1]#, etc... Last Record : #myquery.myfield[myquery.recordcount]#, etc... HTH, Jeff Garza - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 9:01 AM Subject: Selecting First/Last Record in query How to I get the first or last record in a query? T ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reconnecting to MySQL
[TCX][MyODBC]Lost connection to MySQL server during query Can someone suggest a painless way to reconnect to MySQL in this case? Wrap the call in a try/catch block that retrys till it works. Ugh, so I'd have to do that for all my queries? Lame. I was hoping for something more along the lines of CFQUERY TIMEOUT=NEVER, or something nice-n-simple like that.. Hm, so I'd have to wrap the query itself in something like? CFLOOP CONDITION=notQ CFSET notQ=false CFTRY CFQUERY/ CFCATCH TYPE=ANY CFSET notQ=true /CFCATCH /CFTRY /CFLOOP Hrmph. There isn't a more elegant way to regain lost connections to MySQL? ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DHTML menu and select boxes
it is my understanding that the form elements will always appear on top.. i have not found a way around this... so i switched to flash menus :-) mike -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:15 AM To: CF-Talk Subject: DHTML menu and select boxes I've created a dhtml menu system using Fireworks but the dropdown menu doesn't appear on top of a form select box. Is this not possible? I know you can change settings in Flash and Java applets. Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QofQ Joins
-- Original Message -- From: Robertson-Ravo, Neil (RX) This is a commonly referred to as JOIN between tables Yeah, but I've never seen it in action with QoQ, so I wasn't sure if that's what you were demonstrating. Thanks for clarifying. Scott Brady http://www.scottbrady.net/ ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DHTML menu and select boxes
yep. that's what I thought, I guess it's back to Flash :) Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:22 AM To: CF-Talk Subject: RE: DHTML menu and select boxes it is my understanding that the form elements will always appear on top.. i have not found a way around this... so i switched to flash menus :-) mike -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:15 AM To: CF-Talk Subject: DHTML menu and select boxes I've created a dhtml menu system using Fireworks but the dropdown menu doesn't appear on top of a form select box. Is this not possible? I know you can change settings in Flash and Java applets. Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DHTML menu and select boxes
Form elements always rise to the top.. You have to do something tricky like make the form field disappear and/or replace it with a screenshot of the form field - just when the menu is over it.. Or redesign your HTML - Original Message - From: Bosky, Dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 11:14 AM Subject: DHTML menu and select boxes I've created a dhtml menu system using Fireworks but the dropdown menu doesn't appear on top of a form select box. Is this not possible? I know you can change settings in Flash and Java applets. Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QofQ Joins
:-) it does work in QoQ -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 16:22 To: CF-Talk Subject: RE: QofQ Joins -- Original Message -- From: Robertson-Ravo, Neil (RX) This is a commonly referred to as JOIN between tables Yeah, but I've never seen it in action with QoQ, so I wasn't sure if that's what you were demonstrating. Thanks for clarifying. Scott Brady http://www.scottbrady.net/ ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Selecting First/Last Record in query
Just the first and last? you chould do it in sql select TOP 1 * from whatever order by x select TOP 1 * from whatever order by x desc WG -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 16:01 To: CF-Talk Subject: Selecting First/Last Record in query How to I get the first or last record in a query? T ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Flash Data Grid
I'm curious about the flash data grid (is that what it's called?). Does any one have any examples of one of these grids? Could it be a practical replacement for cfgrid? Brook Davies maracasmedia inc ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DHTML menu and select boxes
The only dhtml menu that I have seen that has gotten around this cross-browser seamlessly is Milonic (http://milonic.com) . Their faq explains the poblem bugt is out of date as they've fixed it using some sleight of hand. Cheers, --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com - Original Message - From: Bosky, Dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 8:14 AM Subject: DHTML menu and select boxes I've created a dhtml menu system using Fireworks but the dropdown menu doesn't appear on top of a form select box. Is this not possible? I know you can change settings in Flash and Java applets. Thank You, Dave Bosky ~Sr. Multimedia Web Designer ~HTC Web Services ~[EMAIL PROTECTED] ~office: 843.369.8613 HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reconnecting to MySQL
I don't have any problems with lost connections and mySQL. Do you have the datasource set to maintain connections under the CF Administrator? Even if you don't, you shouldn't be losing the connection during the query. I'd suggest that you have a network issue, if your db is on a seperate server to your web site/CF Server and keep losing the connection during a query. Stephen [TCX][MyODBC]Lost connection to MySQL server during query Can someone suggest a painless way to reconnect to MySQL in this case? Wrap the call in a try/catch block that retrys till it works. Ugh, so I'd have to do that for all my queries? Lame. I was hoping for something more along the lines of CFQUERY TIMEOUT=NEVER, or something nice-n-simple like that.. Hm, so I'd have to wrap the query itself in something like? CFLOOP CONDITION=notQ CFSET notQ=false CFTRY CFQUERY/ CFCATCH TYPE=ANY CFSET notQ=true /CFCATCH /CFTRY /CFLOOP Hrmph. There isn't a more elegant way to regain lost connections to MySQL? ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DHTML menu and select boxes
On Tuesday 21 Jan 2003 16:14 pm, Bosky, Dave wrote: I've created a dhtml menu system using Fireworks but the dropdown menu doesn't appear on top of a form select box. Is this not possible? I know you can change settings in Flash and Java applets. Have you tried setting the z-index of your menu, by placing it in a div with an appropriate style ? -- Tom C Life is wasted on the living. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reconnecting to MySQL
On Tuesday 21 Jan 2003 16:18 pm, Rahmin Pavlovic wrote: Hrmph. There isn't a more elegant way to regain lost connections to MySQL? Well, you could find out why MySQL is dropping the link ? Are you using maintain connections ? Is the timout on that longer than the timeout in MySQL, or something betwen coldfusion and MySQL, like tcpwrappers ? -- Tom C If a language doesn't affect the way you think about programming, it's not worth knowing. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DHTML menu and select boxes
This is a know 'bug' and the ways I have seen it fixed before is to disable the form box when the menu is activatedwhat you are seeing is expected behaviour and not a bug per say -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 16:43 To: CF-Talk Subject: Re: DHTML menu and select boxes On Tuesday 21 Jan 2003 16:14 pm, Bosky, Dave wrote: I've created a dhtml menu system using Fireworks but the dropdown menu doesn't appear on top of a form select box. Is this not possible? I know you can change settings in Flash and Java applets. Have you tried setting the z-index of your menu, by placing it in a div with an appropriate style ? -- Tom C Life is wasted on the living. ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reconnecting to MySQL
Are you inserting large blobs by any chance? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:44 AM To: CF-Talk Subject: Re: reconnecting to MySQL On Tuesday 21 Jan 2003 16:18 pm, Rahmin Pavlovic wrote: Hrmph. There isn't a more elegant way to regain lost connections to MySQL? Well, you could find out why MySQL is dropping the link ? Are you using maintain connections ? Is the timout on that longer than the timeout in MySQL, or something betwen coldfusion and MySQL, like tcpwrappers ? -- Tom C If a language doesn't affect the way you think about programming, it's not worth knowing. ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Goodbye cruel world
At 02:11 PM 1/20/2003 -0500, you wrote: I forgot about that. I did have several problems when using norton securities, then I switched to zone alarm (which was a mistake) then finally found that sygates personal firewall worked the best. Defiantly leave the virus protection on though. 5000 files is a lot though to do at 1 time Don't know if this is a help, but at my house we just got a hardware firewall for $79 and it defaults to shutting all the ports. I have got viruses since then from web pages, but nothing that actually fired off and did anything and no one has got through to my machine. _ 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Goodbye cruel world
At 05:53 PM 1/20/2003 -0500, you wrote: I'm using a cable service. I'm getting Norton anti-virus put on here. I don't know if I'll have to reinitialize my computer yet but will figure it out I guess :) Bad thread there Mike. Hope it is not a worm or a trojan as you suspect. If you do have Norton on, you can set it to not do real time virus protection on particular folders. I would say that you should exempt the Dreamweaver folder and that might help... _ 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Goodbye cruel world
Mike, what intrigues me is that the problem started and grew over time. That is pretty weird. Most software problems are there or not. (Sometimes only in some rare circumstances, but generally problems don't get worse with regular use.) If you would like to contact me off line. I can see if I can get you some help. At 11:05 PM 1/18/2003 -0500, you wrote: Well there it goes again. It is waiting for the server and I have not synchronized yet. Oops lost my connection. Well this is what it has been like for a week now. I have to say that I am trying to do it again and have reconnected. I am currently staying connected longer than I have for the last few days. I am not sure if this is truly fixed yet. Seems to be still trying to determine the files to update which is almost every file on the site. Oh crud its waiting for the server again. I bet it times out. Yep it timed out and now is trying to reconnect. This is way too frustrating. -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 18, 2003 10:57 PM To: CF-Talk Subject: Re: Goodbye cruel world u done with that alcohol downers then? my girl is driving me nuts! can i have them;) - Original Message - From: Mike Miessen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 18, 2003 10:53 PM Subject: RE: Goodbye cruel world Neva mind I found the link. Well I installed it and it is at this point in time connected and I am trying to synchronize my local with the site. Seems I am now connected. I hope this lasts. -Original Message- From: Mike Miessen [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 18, 2003 10:38 PM To: CF-Talk Subject: RE: Goodbye cruel world No could you pass the link ? -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 18, 2003 10:24 PM To: CF-Talk Subject: RE: Goodbye cruel world Did you install the DWMX 6.1 update? - Original Message - From: Mike Miessen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 18, 2003 9:05 PM Subject: Goodbye cruel world I got DWMX and set it up on my computer and started building my site. I worked for 2 or so months and then it started not being able to connect to my site more and more and disconnect after a few seconds for no apparent reason. I now can no longer get it to connect to my site. I even tried to reinstall it and all that. Nothing has worked. I'm about to pull my hair out or worse. I have not updated my site for a week. Please send alcohol and downers as I have thought of a way to put myself out of this misery. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Goodbye cruel world
I use BlackICE with no complaints...its really secure. -Original Message- From: Matt Brown [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 16:30 To: CF-Talk Subject: Re: Goodbye cruel world At 02:11 PM 1/20/2003 -0500, you wrote: I forgot about that. I did have several problems when using norton securities, then I switched to zone alarm (which was a mistake) then finally found that sygates personal firewall worked the best. Defiantly leave the virus protection on though. 5000 files is a lot though to do at 1 time Don't know if this is a help, but at my house we just got a hardware firewall for $79 and it defaults to shutting all the ports. I have got viruses since then from web pages, but nothing that actually fired off and did anything and no one has got through to my machine. _ 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DHTML menu and select boxes
On Tuesday 21 Jan 2003 16:44 pm, Robertson-Ravo, Neil (RX) wrote: This is a know 'bug' and the ways I have seen it fixed before is to disable the form box when the menu is activatedwhat you are seeing is expected behaviour and not a bug per say . Have you tried setting the z-index of your menu, by placing it in a div with an appropriate style ? :nods I over came it when hide/show'ing DHTML layers in a different frame. The layers would also move up to a specific place in the browser window (as opposed to staying in place in the document), so sometimes would overlap with form elements. I was able to cure this by settting a z-index value (either very large, or -1, I can't remember exactly). -- Tom C If a listener nods his head while you're explaining your program, wake him up. ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Com Question
If WG's CFC recommendation doesn't fix the problem, then you can create a new VB COM object that is just a lightweight wrapper for your other COM object, but which provides a release() method to set the object to nothing. Of course your COM object will still be in memory, but at least the single-threaded one will be released and yours will take up less space. Not perfect, or even close, but it's something. Any chance there's an equivalent Java based third party object to do the same thing? Sam At 10:07 AM 1/21/2003, you wrote: I'm having a problem where CFMX takes too long to release a COM object from memory. Being a single threaded-object it gets stuck in my error trap from a few seconds to a couple of minutes unitil it's released. It's a third party object and cannot change it's threading model. Will setting the object to Nothing as in ASP or VB help? Thanks, Frank ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Goodbye cruel world
On Tuesday 21 Jan 2003 16:53 pm, Robertson-Ravo, Neil (RX) wrote: I use BlackICE with no complaints...its really secure. Software firewalls, on Windows, are pointless: http://tooleaky.zensoft.com/ (exec. summ. : any process on Windows can script IE, and IE you will have allowed outbound, so any process has outbound access, without fear of filtering) -- Tom C Junior Encyclopedia of Space #4: HOTELS: A place were humans are parked for the night. SEE ALSO: BACON, LETTUCE AND TOMATO SANDWICH ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reconnecting to MySQL
Are you inserting large blobs by any chance? I'm not, but I do think the problem is somewhere in the CF administrator since the mySQL server is on the same machine. Maybe the CF server is on a remote machine, but either way I'm looking into this. Thanks for the tips. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Web Page -- PDF -- Labels?
Sorry to re-cycle what has to be a newbie question but google didn't turn up anything particularly helpful. My client wants to be able to print labels from her browser. The application is built with CF 5 and Access. I think the notion of printing web pages for use as labels is pretty dubious because of all the variables out of my control. But how about sending the label display to be generated as a pdf and then making that available for printing? Has someone done something like this before? Any custom tags that might prove helpful? Even if there's nothing on point re labels, I'd be interested in recommendations for the pdf creation. Thanks! - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
replacement for obsolete function
Does CFMX have an alternative function to cfusion_settings_refresh()? Thanks, 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: replacement for obsolete function
Steve Dworman wrote: Does CFMX have an alternative function to cfusion_settings_refresh()? No. But many of the things that required the use of cfusion_settings_refresh() do not require any action at all anymore. And you can restart some of the subservices, i.e. restart just the MailSpoolService. 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Flash Data Grid
you can view a couple of examples here: http://www.markme.com/mesh/drk/dg_1.html mike chambers [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:36 AM To: CF-Talk Subject: Flash Data Grid I'm curious about the flash data grid (is that what it's called?). Does any one have any examples of one of these grids? Could it be a practical replacement for cfgrid? Brook Davies maracasmedia inc ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Training
Does anyone know of any good training options for Cold Fusion location in Central/Northern NY? (already checked out Ikon/CESC...they offer next to nothing)... Thanks! Scott ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Web Page -- PDF -- Labels?
There is Avery label tag on macromedia.com that should do what u want. WG -Original Message- From: Bob Haroche [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 17:13 To: CF-Talk Subject: Web Page -- PDF -- Labels? Sorry to re-cycle what has to be a newbie question but google didn't turn up anything particularly helpful. My client wants to be able to print labels from her browser. The application is built with CF 5 and Access. I think the notion of printing web pages for use as labels is pretty dubious because of all the variables out of my control. But how about sending the label display to be generated as a pdf and then making that available for printing? Has someone done something like this before? Any custom tags that might prove helpful? Even if there's nothing on point re labels, I'd be interested in recommendations for the pdf creation. Thanks! - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL 2000 sp3
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 http://www.microsoft.com/sql/downloads/2000/sp3.asp z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+LYPM1lRHdy8ASusRAofVAJ0Zz+wl/Rqa3wOuqXKE4oX+JLxWfACgrT/c xyQnPU3Jnbs3sMDvdb9M7Rk= =7GJK -END PGP SIGNATURE- ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QofQ Joins
Is it possible to do an outer join in a query of queries? I can't find any good documentation that explains QofQ's capabilities/limitations. It seems to support inner joins, but I haven't come up with an outer join syntax that doesn't throw an error. I found this article to be extremely helpful when dealing with QoQs (watch for wrapping): http://www.daemon.com.au/index.cfm?objectid=64307CBB-D0B7-4CD6-F9A4C292986B884F Number 9 in his list should answer your question for you. Incidentally, I found Daemon's entire Tips and Tricks section of their site to be quite helpful. Regards, Dave. ~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Goodbye cruel world
I would not say Software firewalls, on Windows, are pointless by any means. Maybe for outbound filtering but, this is assuming that someone has already taken control of a process in windows. If someone (or a virus) has done that, the fight is already lost. Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:06 AM To: CF-Talk Subject: Re: Goodbye cruel world On Tuesday 21 Jan 2003 16:53 pm, Robertson-Ravo, Neil (RX) wrote: I use BlackICE with no complaints...its really secure. Software firewalls, on Windows, are pointless: http://tooleaky.zensoft.com/ (exec. summ. : any process on Windows can script IE, and IE you will have allowed outbound, so any process has outbound access, without fear of filtering) -- Tom C Junior Encyclopedia of Space #4: HOTELS: A place were humans are parked for the night. SEE ALSO: BACON, LETTUCE AND TOMATO SANDWICH ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
multi homed sever, 443 will not display
We've just migrated our production web server to a new box. We have several virtual sites set up in iis. The default web site will display via both port 80 and 443, however the virtual sites will only display over post 80. We are getting a network connection refused when trying to access the virtual sites via ssl. We have recreated the sites several times, but still can't get them to work. We have changed the cachRealPath attributes in the c:/cfusionmx/runtime/servers/default/SERVER-INF/jrun.xml to false. Any ideas/help would be greatly appreciated. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Application.cfm
Do I have to include application.cfm in all my cfm pages, or is that automatically done for you? Scott ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application.cfm
Do I have to include application.cfm in all my cfm pages, or is that automatically done for you? Its done automatically for you. Just make sure that if you're on *nix that application.cfm is name with a capital A, otherwise it won't be included. Stephen ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application.cfm
If an Application.cfm file exists it will automatically be loaded prior to loading the called .cfm page, even if the file called is within a subdirectory (unless the subdirectory has it's own Application.cfm) Cutter Scott Wilhelm wrote: Do I have to include application.cfm in all my cfm pages, or is that automatically done for you? Scott ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application.cfm
your coldfusion templates will look for an application.cfm file recursively up the directory tree automatically. If your template is in c:\inetpub\wwwroot\mydirectory\ ColdFusion will search in c:\inetpub\wwwroot\mydirectory\, then c:\inetpub\wwwroot\, then c:\inetpub\, then c:\ HTH, Jeff - Original Message - From: Scott Wilhelm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 10:42 AM Subject: Application.cfm Do I have to include application.cfm in all my cfm pages, or is that automatically done for you? Scott ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application.cfm
Application.cfm is read on the load of each and every CFM page within the same directory as the Application.cfm page, and below that directory. Upon running a CFM page, CF looks for an application.cfm page in the same dir. If it doesn't find one, it traverses up to the next level of dir and looks for one there. It will keep going up dirs until it finds one. Nothing adverse will happen if you DON'T have one. However, if you need to load specific info into each page, that is a way you can do it. It is NOT recommended that you use the application.cfm for things like general calculations, etc. Only things that are required -- and keep it to a minimum. Otherwise, you're simply loading things on each CFM page load that aren't really needed... which can, of course, cause a performance hit. It all depends on what you're loading, and how. | -Original Message- | From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, January 21, 2003 9:42 AM | To: CF-Talk | Subject: Application.cfm | | | Do I have to include application.cfm in all my cfm pages, or | is that automatically done for you? | | Scott | ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: multi homed sever, 443 will not display
After a little research, it seems that at least one user has run into the same problem. Unfortunately, it appears that it was not resolved. Perhaps a rollback to updater 1? ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: multi homed sever, 443 will not display
Matt, Each SSL Certificate must be applied to a separate IP address. You cannot do virtuals that each have their own cert. How will the web server know which certificate to serve without looking at the header (which it cannot access until it establishes a secure socket). -Mark -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:45 AM To: CF-Talk Subject: multi homed sever, 443 will not display We've just migrated our production web server to a new box. We have several virtual sites set up in iis. The default web site will display via both port 80 and 443, however the virtual sites will only display over post 80. We are getting a network connection refused when trying to access the virtual sites via ssl. We have recreated the sites several times, but still can't get them to work. We have changed the cachRealPath attributes in the c:/cfusionmx/runtime/servers/default/SERVER-INF/jrun.xml to false. Any ideas/help would be greatly appreciated. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4