Re: passing multiple CF vaules to a javascript variable
onClick didn't understand a CF variable like: "#linkStyle#". It wants _javascript_. I don't know how to make the _javascript_ variable I create from the CF variable return each of the different values in the onClick event. I get: > menu item one: ...> > menu item two: ...> > menu item two: ...> How can I make the _javascript_ variable I create from the CF variable loop through the values properly? Thanks for trying to help with this problem. > But by the time the code gets to the browser, #linkStyle# will have > been replaced by exactly what you show us here > menu item one: ...> > menu item two: ...> > menu item two: ...> > > "view source" from your browser might help clear things up for you. > > Or like Dick, I don't understand :( > > - Original Message - > From: Joy Holman > To: CF-Talk > Sent: Tuesday, April 13, 2004 4:12 PM > Subject: Re: passing multiple CF vaules to a _javascript_ variable > > > Would this information help explain what I need? > > Here's where the styles comes in: > I have a CSS stylesheet with these values: > #FellSvc{display:none;} > #MinorRts{display:none;} > #AmnInf{display:none;} > #AnteSter{display:none;} > > In the db table, I have a column for the same styles from the > stylesheet. Let's say the column name is "linkStyle" (like Dick's > example). Another column in the db table has the text for the menu > link that displays on the page. > > When a user clicks on a menu link (generated by the CF code prior to > the user interaction), an assoicated DIV with an ID equal to the > stylename displays its content because the onClick event tells the > matching style in the stylesheet to change "display=none" to > "display=block". > > Using Dick's example, just change the end to something like this: > >Now, iterating over the query: > > > > > > > #linkName# > > > > Now, that doesn't work because #linkStyle# is CF and onClick needs js. > > I don't know how to loop through this onClick variable to get the > range of values to be produced - one for each iteration of the results, > like: > menu item one: ...> > menu item two: ...> > menu item two: ...> > etc. > > Does that help? > > I need to be gone for a few hours, but I'll check back. > Thank you and Dick so much for sticking with me on this!!! > > > It sounds like you need to combine the results from the 2 queries > into > > a single query objectOR write a more complex query to join all > the > > tables involved to produce a single recordset. > > > > Bryan Stevenson B.Comm. > > VP & Director of E-Commerce Development > > Electric Edge Systems Group Inc. > > t. 250.920.8830 > > e. [EMAIL PROTECTED] > > > > - > > Macromedia Associate Partner > > www.macromedia.com > > - > > Vancouver Island ColdFusion Users Group > > Founder & Director > > www.cfug-vancouverisland.com > > > - Original Message - > > > From: Joy Holman > > > To: CF-Talk > > > Sent: Tuesday, April 13, 2004 11:55 AM > > > Subject: Re: passing multiple CF vaules to a _javascript_ variable > > > > > > > The rendered output is a menu of links. One query column > > > returns the text for a link, another query column returns the target > > > for the link. The style name column is used in an onClick event to > set > > a CSS style to display content when clicked. > > > > > The style name doesn't display on screen. > > > > > I'm able to generate all the values I need except for all the > > > stylename values. If I only had one result from the query, it would > > > work fine. But I can't get the style name value to change as > > additional menu items are generated from the query results. Maybe > what > > I need is help with _javascript_. > > > > > I don't know how to explain it any better. I guess that's a drawback > > > of not being able to talk in real time. Thanks for your efforts. > I'll > > keep at it. > > > > > event. > > > > > From the query results, I create the js: target() which returns > > > > > the value of the stylename field. How do I loop over the > > > > > stylename values so that I get one value per onClick event which > > > > > is generates multiple times based on the number of records in > > > > > the query? > > > > > >I am sorry... > > > > > > > >I can't understand what you are trying to do. > > > > > > > >It is a simple matter to include the value of a column from the > query > > > > > >in a line of text generated within the output
RE: OT ? Emulation
On Unix: Wget. PHP has it's own version of CFHTTP using the CURLlib. Certainly Perl has something - or more than one option- as well. -Nate -Original Message- From: Nick Baker [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 1:13 PM To: CF-Talk Subject: OT ? Emulation Well maybe heresy, instead of OT ;-) Does anyone know of good non-CF scripts, Perl, CGI, etc. that perform the same function as ? Thanks, Nick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to streamline a request that uses many cfquery statements?
how long do these reports take to process? hehe - Original Message - From: Steve Nelson To: CF-Talk Sent: Tuesday, April 13, 2004 8:56 PM Subject: RE: How to streamline a request that uses many cfquery statements? Maybe I'm wrong, but I think even if you use a stored procedure it's going to process in series. I doubt it's going to give you a huge performance boost. I posted a handful of tests on my blog (http://steve.secretagents.com ) last week comparing cfquery to cfstoredproc. Another option is to process the report before the user accesses it. Like have a scheduled process that runs in the middle of the night, or every hour or every 1 minute and saves the output to a static file. That would be very easy to do with cfschedule, but has the downside of potentially being out of sync with the live data. Of course, there are tricks to get around that. If you're interested in hearing them let me know. Steve Nelson _ From: Earl, George [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:40 AM To: CF-Talk Subject: How to streamline a request that uses many cfquery statements? This feels like a dumb question, but here goes . . . Am I correct that in a CF template that has, say, 15 cfquery statements the cfquery statements are submitted one at a time with each subsequent cfquery not submitted until the previous cfquery returns? I.e., if all 15 queries have to run and there is no logic in the markup that arranges or rearranges the order in which the queries run do they run one at a time in sequence from top to bottom? Is there a way to have multiple queries running from the same cf template at the same time? We produce a report that is essentially three reports bundled into one and displayed one after the other. Currently we run 15 queries (3*5) to create this report and it takes 3 - 3 1/2 minutes for the queries to complete. Logically it seems that we could run the three report processes concurrently and independently and then assemble them into the final report when the answer sets come back which should dramatically speed up the process. Is there a way to do this with CF? (We're using Oracle 8i, CF5, migrating to CFMX 6.1, on Windows 2000 Advanced Server.) Thanks! George [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to streamline a request that uses many cfquery statements?
Maybe I'm wrong, but I think even if you use a stored procedure it's going to process in series. I doubt it's going to give you a huge performance boost. I posted a handful of tests on my blog (http://steve.secretagents.com ) last week comparing cfquery to cfstoredproc. Another option is to process the report before the user accesses it. Like have a scheduled process that runs in the middle of the night, or every hour or every 1 minute and saves the output to a static file. That would be very easy to do with cfschedule, but has the downside of potentially being out of sync with the live data. Of course, there are tricks to get around that. If you're interested in hearing them let me know. Steve Nelson _ From: Earl, George [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:40 AM To: CF-Talk Subject: How to streamline a request that uses many cfquery statements? This feels like a dumb question, but here goes . . . Am I correct that in a CF template that has, say, 15 cfquery statements the cfquery statements are submitted one at a time with each subsequent cfquery not submitted until the previous cfquery returns? I.e., if all 15 queries have to run and there is no logic in the markup that arranges or rearranges the order in which the queries run do they run one at a time in sequence from top to bottom? Is there a way to have multiple queries running from the same cf template at the same time? We produce a report that is essentially three reports bundled into one and displayed one after the other. Currently we run 15 queries (3*5) to create this report and it takes 3 - 3 1/2 minutes for the queries to complete. Logically it seems that we could run the three report processes concurrently and independently and then assemble them into the final report when the answer sets come back which should dramatically speed up the process. Is there a way to do this with CF? (We're using Oracle 8i, CF5, migrating to CFMX 6.1, on Windows 2000 Advanced Server.) Thanks! George [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: Flash Remoting vs Web Services vs XML
I tend to like Flash Remoting and I think it has been proven to be a bit faster than consuming web services. And since the code in the CFC is the same for flash remoting as it is for web service's you should be cool on the CFMX side of things. Flash works really nicely with CFMX and remoting is super fast. The net connection debugger is a great tool for seeing what is going back and forth to the server. I recommend Colin Moock's book 'Flash Remoting' the definitive guide. I just moved from CFMX programming only to actionscript 2.0 - it was a huge shock to the system since I hadn't done much scripting before and did not understand OOP. But after struggling for a while (especially with the scope chain) I really like the way remoting and CFMX work together. Combine that with databinding and dataholders, its pretty cool. You should search the archives of the flash coders and/or flashnewbies lists (http://chattyfig.figleaf.com/ - maybe subscribe) to see if the answer to this has been covered. There was also an article on MM specifically about when to use what technology (remoting,web services, xml). Brook At 03:14 PM 4/13/2004, you wrote: >Are you asking how the above options compare? > >If so, then a Google search on term "'flash remoting' 'web services'" pulls >up existing assets on choosing between server-specific binary and >server-independent XML/SOAP. (There are other discussions, too, but they're >mixed in with other hits on those two query phrases.) > >... or is it that you already read Steven Webster's article at DevNet (the >top hit on the above term), and have an additional question? or...? > > > ... am having a bit of a hard time deciding which route > > to pursue > >Well, it's trite of me, but one reliable approach is to keep things as >simple as possible to solve the problem. You're already using ColdFusion so >I'm assuming you can produce web services for consumption. Is there a >reason why you couldn't go this way, and would instead be considering the >tighter connectivity of the remoting approach...? > >(There are RIA mailing lists out there, but they tend to be focused on user >experience rather than plumbing type, but I may not yet understand what is >being sought.) > >Hmm, or maybe it's "What's an easy way to approach creating data-driven UIs >in the Macromedia Flash authoring environment?" If so, then there's a >portal which seems tuned to this need: >http://www.macromedia.com/devnet/mx/flash/data_integration.html > >Or...? > >jd > > >John Dowdell, Macromedia Developer Support, San Francisco >(Best to reply on-list, to avoid my mighty spam filters!) >Technotes: http://www.macromedia.com/support/search/ >Column: http://www.macromedia.com/desdev/jd_forum/ >Technical daily diary: http://www.macromedia.com/go/blog_jd > >-- >[Todays Threads] >[This Message] >[Subscription] >[Fast > Unsubscribe] [User Settings] > >-- > >[] > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: Flash Remoting vs Web Services vs XML
Are you asking how the above options compare? If so, then a Google search on term "'flash remoting' 'web services'" pulls up existing assets on choosing between server-specific binary and server-independent XML/SOAP. (There are other discussions, too, but they're mixed in with other hits on those two query phrases.) ... or is it that you already read Steven Webster's article at DevNet (the top hit on the above term), and have an additional question? or...? > ... am having a bit of a hard time deciding which route > to pursue Well, it's trite of me, but one reliable approach is to keep things as simple as possible to solve the problem. You're already using ColdFusion so I'm assuming you can produce web services for consumption. Is there a reason why you couldn't go this way, and would instead be considering the tighter connectivity of the remoting approach...? (There are RIA mailing lists out there, but they tend to be focused on user experience rather than plumbing type, but I may not yet understand what is being sought.) Hmm, or maybe it's "What's an easy way to approach creating data-driven UIs in the Macromedia Flash authoring environment?" If so, then there's a portal which seems tuned to this need: http://www.macromedia.com/devnet/mx/flash/data_integration.html Or...? jd John Dowdell, Macromedia Developer Support, San Francisco (Best to reply on-list, to avoid my mighty spam filters!) Technotes: http://www.macromedia.com/support/search/ Column: http://www.macromedia.com/desdev/jd_forum/ Technical daily diary: http://www.macromedia.com/go/blog_jd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT ? Emulation
AFAIK, you can do the equivalent of CFHTTP with ASP (3rd-party add-on), PHP, and Perl -- wouldn't surprisme if jsp also has the capability, You should be able to google for: cfhttp equivalent -- I found php fopen() that way HTH Dick On Apr 13, 2004, at 11:13 AM, Nick Baker wrote: > Well maybe heresy, instead of OT ;-) > > Does anyone know of good non-CF scripts, Perl, CGI, etc. that perform > the > same function as ? > > Thanks, > > Nick > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX6.1 updater
I thought I heard about a new service pack for CF too, but a few weeks about Ben had this to say, "The next planned version of ColdFusion is codenamed "Blackstone", and version numbers, pricing, etc., have yet to be discussed at all. But, and this is my own opinion here, I doubt that there will be another maintenance release for CFMX any time soon. CFMX needed updates, which is why we released service packs and then v6.1, But 6.1 has proven to be reliable and solid and arguably one of the best ColdFusion's ever, and so a maintenance release is unlikely. Bottom line, use 6.1 now, and stay tuned for announcements from MM." - Ben Forta February 23 CF-Talk - Subject: Re: Question regarding CFMX 6.2 Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 3:37 PM To: CF-Talk Subject: Re: CFMX6.1 updater AIT said: > Hey does anyone have any idea when an updater for CFMX6.1 might be > out? I seem to recall somebody commenting that an updater was 'under consideration'. Probably your best bet is http://www.macromedia.com/go/wish/ Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: Flash Remoting vs Web Services vs XML
On Apr 13, 2004, at 1:46 PM, Chris Alvarado wrote: > I don't really know much about Flex other than the few articles I have > read and the little bit of sample code I have seen. The problems I > have > with going the Flex route are as follows: > > 1) this project is extremely time sensitive. > > - thus the web service route seems more feasible. I already know how > to > program a web service using CF (CFCs) and consuming a web service with > Flash is supposed to be pretty straight forward. Learning Flex (the > way > I take it) and integrating CF would be quite a bit more time consuming > than simply using AS to handle data returned by CF. You can do it almost exactly the same with FlexFlash -- you have action script and remoting But, on a time sensitive project, you are wise to go with familiar, established approaches -- rather than trying to learn & implement a release 1.0 product. > 2) the interfaces that the design team has come up with for this > project > are VERY detailed and do have quite a bit of animation Flash may be preferable for this reason too! > > I guess the biggest challenge at the moment is making these decisions. > At the moment the choice seems pretty simple as I stated above. Web > Services + Flash, as I already know how to develop Web Services so all > that would be needed it so learn how to consume said web services with > Flash. However, the last thing I want to do is head down the wrong > path. > Id like to explore all the options out there and I agree, Flex seems > like a very viable option if this application had been designed to > harness it from the get go. > > It does sound as if web services are in order for this project, at this time. You should be able to get all you need for interfacing Flash with web services from Chapter 9 of the server geek book. At some later time, when the pressure's off, you may wish to investigate the alternative of Flash Remoting -- binary data interchange rather than XML -- possible better performance & lower bandwidth. HTH Dick > > -chris.alvarado > > [ application developer ] > > 4 Guys Interactive, Inc. > > 281.807.4344 x1716 > > > >_ > > From: Dick Applebaum [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 13, 2004 3:06 PM > To: CF-Talk > Subject: Re: SOT: Flash Remoting vs Web Services vs XML > > Have you considered Flex (or as I like to call it FlexFlash) > > In my very limited experience Flex programming of RIAs is much easier > than Flash programming unless you are into heavy animation, visual > effects, etc. > > You can get all you need for development with the Flex evaluation CD. > > Then you can install flex to run in conjunction with CFMX -- which is > the best of both worlds (server-side power and client-side RIA) > > The big barrier may be the price of Flex but I understand that > this > may be negotiable. > > Your timeframe may also be a consideration -- there have been hints > that the next release of CFMX (BlackGuard, BlackHart, BlackMagic, > BlackBeauty, BlackStone, whatever) will include Flex capabilities. > > The way it (current CFMX Flex) appears to work is this: > > 1) You create CF templates with imbedded (or included) Flex source > containing special XML (MXXML) and ActionScript (similar to > _javascript_). > > The CF template gets compiled to Java Byte code > > The Flash portion of the template gets compiled to a SWF > > Both are served to the requestor; > > Here are the headers for a very simple CFMX Flex program (a Menu Tree) > > "GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753 > "GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753 > "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244 > "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244 > "GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257 > "GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257 > "GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528 > "GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528 > "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656 > "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656 > > It appears as if there are separate requests generated for: > > 1) the cf template > 2) flex js > 3) flex history > 4) a swf containing the Flex portion of the CF template (mxml.swf) > 5) a generic swf > > This is quite a fewf connections for a simple program, but I am told > that as complexity increases, there should be fewer connections than > with a typical html page. > > FlexFlash and Flash remoting tend to change the way you program -- not > always for the better > > 1) rather then populate the initial page with initial data as with > CF/HTML it is cleaner to do the following with FR: >--download the RIA client >--the client, when loaded, makes the request for initial data. > 2) from a programming standpoint it is easy to ignore the overhead of > exchanging large XML
Re: passing multiple CF vaules to a javascript variable
On Apr 13, 2004, at 1:07 PM, Joy Holman wrote: > Here's where the styles comes in: > I have a CSS stylesheet with these values: > #FellSvc{display:none;} > #MinorRts{display:none;} > #AmnInf{display:none;} > #AnteSter{display:none;} > > In the db table, I have a column for the same styles from the > stylesheet. Let's say the column name is "linkStyle" (like your > example). Another column in the db table has the text for the menu > link that displays on the page. > > When a user clicks on a menu link (generated by the CF code prior to > the user interaction), an assoicated DIV with an ID equal to the > stylename displays its content because the onClick event tells the > matching style in the stylesheet to change "display=none" to > "display=block". > > Using your example, just change the end to something like this: > >Now, iterating over the query: > > > > > > > #linkName# > > > > Now, that doesn't work because #linkStyle# is CF and onClick needs js. but #linkStyle# is just the name of a CF variable, a container, if you will (this one just cones from the db). that container can contain anything you want it to, for example: ' myFunction( ) { alert("Hi"); } ' /> so in your example, the columns in the current row of the query contain: columnName Content -- --- linkName Apple linkURL www.apple.com linkStyle MinorRts if column named linkStyle in the current row of the database contains MinorRts then outputting: #linkName# will yield: Apple As I understand it, that is exactly what you want. The next row will have different values so the next link will reflect this HTH Dick > I don't know how to loop through this onClick variable to get the > range of values to be produced - one for each iteration of the > results, like: > menu item one: ...> > menu item two: ...> > menu item two: ...> > etc. > > Does that help? > > >I realize that you are trying to create a list of links -- what I > can't > >understand is where the dynamic data is supposed to come from > > > >I would write something like: > > > > > > SELECT linkName, linkURL, linkStyle FROM linkTable > > > > > >yields a query containing: > > > >linkName linkURL linkStyle > >-- -- -- > >Apple www.apple.com colorful > >Macromedia www.macromedia.com flashy > >Microsoft www.microsoft.com opportunistic > > > >Now, iterating over the query: > > > > > > #linkName# > > > > > > > >yields: > > > > Apple > > Macromedia > > Microsoft > > > >I know this is not exactly what you want, but using the same > technique, > >can you show me what you want? > > > >Dick > > > > > >On Apr 13, 2004, at 11:55 AM, Joy Holman wrote: > > > >> > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: Spammed from post to cf-talk
At 01:36 PM 4/13/2004, Dick wrote: >I just got spammed with the subject line of a post I made to cf-talk. > >Where should I forward the spam msg to add the abuser to the filter? Chances are, you got spammed directly. Spammers have been farming this list for emails it seems - I just got another spam on this list-specific email for Viagra etc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: Flash Remoting vs Web Services vs XML
I don't really know much about Flex other than the few articles I have read and the little bit of sample code I have seen. The problems I have with going the Flex route are as follows: 1) this project is extremely time sensitive. - thus the web service route seems more feasible. I already know how to program a web service using CF (CFCs) and consuming a web service with Flash is supposed to be pretty straight forward. Learning Flex (the way I take it) and integrating CF would be quite a bit more time consuming than simply using AS to handle data returned by CF. 2) the interfaces that the design team has come up with for this project are VERY detailed and do have quite a bit of animation I guess the biggest challenge at the moment is making these decisions. At the moment the choice seems pretty simple as I stated above. Web Services + Flash, as I already know how to develop Web Services so all that would be needed it so learn how to consume said web services with Flash. However, the last thing I want to do is head down the wrong path. Id like to explore all the options out there and I agree, Flex seems like a very viable option if this application had been designed to harness it from the get go. -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. 281.807.4344 x1716 _ From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 3:06 PM To: CF-Talk Subject: Re: SOT: Flash Remoting vs Web Services vs XML Have you considered Flex (or as I like to call it FlexFlash) In my very limited experience Flex programming of RIAs is much easier than Flash programming unless you are into heavy animation, visual effects, etc. You can get all you need for development with the Flex evaluation CD. Then you can install flex to run in conjunction with CFMX -- which is the best of both worlds (server-side power and client-side RIA) The big barrier may be the price of Flex but I understand that this may be negotiable. Your timeframe may also be a consideration -- there have been hints that the next release of CFMX (BlackGuard, BlackHart, BlackMagic, BlackBeauty, BlackStone, whatever) will include Flex capabilities. The way it (current CFMX Flex) appears to work is this: 1) You create CF templates with imbedded (or included) Flex source containing special XML (MXXML) and ActionScript (similar to _javascript_). The CF template gets compiled to Java Byte code The Flash portion of the template gets compiled to a SWF Both are served to the requestor; Here are the headers for a very simple CFMX Flex program (a Menu Tree) "GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753 "GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753 "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244 "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244 "GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257 "GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257 "GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528 "GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528 "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656 "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656 It appears as if there are separate requests generated for: 1) the cf template 2) flex js 3) flex history 4) a swf containing the Flex portion of the CF template (mxml.swf) 5) a generic swf This is quite a fewf connections for a simple program, but I am told that as complexity increases, there should be fewer connections than with a typical html page. FlexFlash and Flash remoting tend to change the way you program -- not always for the better 1) rather then populate the initial page with initial data as with CF/HTML it is cleaner to do the following with FR: --download the RIA client --the client, when loaded, makes the request for initial data. 2) from a programming standpoint it is easy to ignore the overhead of exchanging large XML packets between host and client 3) if you give a lot of capability to the client (updating records on the client with out contacting the host) you can add orders of magnitude of complexity to the host (lockouts, deadlocks, synchronization) and to the RIA client -- what happens if the browser crashes after you've made 20 minutes of updates? 4) Multiple browser windows with a Flash RIA clients, each consume client resources even when inactive. They compete with each other and other desktop apps. So, everything you've learned with CF still applies -- Flash can improve the UI, and the UE (User Experience) -- but, better to be a little skeptical HTH Dick On Apr 13, 2004, at 12:06 PM, Chris Alvarado wrote:) > Hello all, > > I am starting a new project that will require some fairly heavy Flash > / > CF integration including but not limited to: visual display of data > stored in a database, insertion of data into a database supplied in > Flash forms, a complete security model that requires not only >
Re: passing multiple CF vaules to a javascript variable
But by the time the code gets to the browser, #linkStyle# will have been replaced by exactly what you show us here menu item one: ...> menu item two: ...> menu item two: ...> "view source" from your browser might help clear things up for you. Or like Dick, I don't understand :( - Original Message - From: Joy Holman To: CF-Talk Sent: Tuesday, April 13, 2004 4:12 PM Subject: Re: passing multiple CF vaules to a _javascript_ variable Would this information help explain what I need? Here's where the styles comes in: I have a CSS stylesheet with these values: #FellSvc{display:none;} #MinorRts{display:none;} #AmnInf{display:none;} #AnteSter{display:none;} In the db table, I have a column for the same styles from the stylesheet. Let's say the column name is "linkStyle" (like Dick's example). Another column in the db table has the text for the menu link that displays on the page. When a user clicks on a menu link (generated by the CF code prior to the user interaction), an assoicated DIV with an ID equal to the stylename displays its content because the onClick event tells the matching style in the stylesheet to change "display=none" to "display=block". Using Dick's example, just change the end to something like this: >Now, iterating over the query: > > > > Now, that doesn't work because #linkStyle# is CF and onClick needs js. I don't know how to loop through this onClick variable to get the range of values to be produced - one for each iteration of the results, like: menu item one: ...> menu item two: ...> menu item two: ...> etc. Does that help? I need to be gone for a few hours, but I'll check back. Thank you and Dick so much for sticking with me on this!!! > It sounds like you need to combine the results from the 2 queries into > a single query objectOR write a more complex query to join all the > tables involved to produce a single recordset. > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > - Original Message - > From: Joy Holman > To: CF-Talk > Sent: Tuesday, April 13, 2004 11:55 AM > Subject: Re: passing multiple CF vaules to a _javascript_ variable > > > The rendered output is a menu of links. One query column > returns the text for a link, another query column returns the target > for the link. The style name column is used in an onClick event to set > a CSS style to display content when clicked. > > The style name doesn't display on screen. > > I'm able to generate all the values I need except for all the > stylename values. If I only had one result from the query, it would > work fine. But I can't get the style name value to change as > additional menu items are generated from the query results. Maybe what > I need is help with _javascript_. > > I don't know how to explain it any better. I guess that's a drawback > of not being able to talk in real time. Thanks for your efforts. I'll > keep at it. > > event. > > From the query results, I create the js: target() which returns > > the value of the stylename field. How do I loop over the > > stylename values so that I get one value per onClick event which > > is generates multiple times based on the number of records in > > the query? > > >I am sorry... > > > >I can't understand what you are trying to do. > > > >It is a simple matter to include the value of a column from the query > > >in a line of text generated within the output tags... > > > >But you are already doing that... > > > > > >Maybe this would help me to help you: > > > >1) show me a few lines of the rendered output that you desire--- no > CF > >tags, just the rendered output. > > > >2) put an asterisk or something in front of each value in the > rendered > >output that you want to dynamically create with your CF code, > > > >3) Run your query and display the output of enough rows showing the > >columns & their values that contain the dynamic data > > > > > >HTH > > > >Dick > > > >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote: > > > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to streamline a request that uses many cfquery statements ?
> > Sounds like you should be doing some stored procedures. > > I assume that you both mean that the CF template would call > one stored procedure that on the database (Oracle) we could > have break out the queries in subsets that would run in > concurrent processes? To the best of my knowledge, stored procedures by themselves will not allow you to perform asynchronous queries. That's why Jochem suggested a multithreaded custom tag. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to streamline a request that uses many cfquery statements ?
Earl, George said: > I said: >> Logically it seems that we could run the three >> > report processes concurrently and independently and then >> assemble them into the final report when the answer sets come >> back which should dramatically speed up the process. > > Jochem said: >> Not necessarily. If the db-server is continuously stressed out >> concurrent queries will not help. There even is a considerable >> chance they will hurt, for instance through trashing the buffers. > > Point taken. It was one of our database people who asked if CF would > allow us to run queries concurrently, so I hope he would have your > concerns in mind. Sounds like they are really looking for something outside the database as they have exhausted the possibilities inside it. That would leave you with a Java/C custom tag. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Put a link in a textarea
I liked the ActivateURL (certainly saves some work) so I guess I will display the text in an iframe or div. Thanks for all your help. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 4:25 PM To: CF-Talk Subject: Re: Put a link in a textarea Ooopsmy badyes that UDF is only intended for outside of form tags. Now that said it seems a bit odd to be displaying a record in a form?? If it's in a form then it's meant to be edited not "used" (i.e. user following links etc.)but then again...what do I know about your application ;-) I'm not 100% surebut about 99.9% sure that you can't do what you're after (and obviously I think you shouldn't do it anyway...hehe). Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Rollo, Jeff To: CF-Talk Sent: Tuesday, April 13, 2004 1:06 PM Subject: RE: Put a link in a textarea At first glance, it looks like it puts an But if this is displayed in a textarea, it would just display the text with a link. Or am I wrong here. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 3:51 PM To: CF-Talk Subject: Re: Put a link in a textarea Yep...go to www.cflib.org and grab the UDF named ActivateURL.works like a charm ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: CF-Talk Sent: Tuesday, April 13, 2004 12:50 PM Subject: Put a link in a textarea Is there a way that a user can enter a URL in a textarea and have the link actually display and work as a hyperlink? For example: class="noborder"> blah blah blah http://www.houseoffusion.com/ blah blah blah _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX6.1 updater
AIT said: > Hey does anyone have any idea when an updater for CFMX6.1 might be > out? I seem to recall somebody commenting that an updater was 'under consideration'. Probably your best bet is http://www.macromedia.com/go/wish/ Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Put a link in a textarea
Ooopsmy badyes that UDF is only intended for outside of form tags. Now that said it seems a bit odd to be displaying a record in a form?? If it's in a form then it's meant to be edited not "used" (i.e. user following links etc.)but then again...what do I know about your application ;-) I'm not 100% surebut about 99.9% sure that you can't do what you're after (and obviously I think you shouldn't do it anyway...hehe). Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Rollo, Jeff To: CF-Talk Sent: Tuesday, April 13, 2004 1:06 PM Subject: RE: Put a link in a textarea At first glance, it looks like it puts an But if this is displayed in a textarea, it would just display the text with a link. Or am I wrong here. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 3:51 PM To: CF-Talk Subject: Re: Put a link in a textarea Yep...go to www.cflib.org and grab the UDF named ActivateURL.works like a charm ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: CF-Talk Sent: Tuesday, April 13, 2004 12:50 PM Subject: Put a link in a textarea Is there a way that a user can enter a URL in a textarea and have the link actually display and work as a hyperlink? For example: class="noborder"> blah blah blah http://www.houseoffusion.com/ blah blah blah _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Put a link in a textarea
You cannot display anything in the actual except for text. You can use an IFRAME if you want to display the HTML equivalent. The ActivateURL takes text that someone types in and turns the links into active links by surrounding the text with . John Burns -Original Message- From: Rollo, Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 4:06 PM To: CF-Talk Subject: RE: Put a link in a textarea At first glance, it looks like it puts an link. But if this is displayed in a textarea, it would just display the text with a hyper link. Or am I wrong here. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 3:51 PM To: CF-Talk Subject: Re: Put a link in a textarea Yep...go to www.cflib.org and grab the UDF named ActivateURL.works like a charm ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: CF-Talk Sent: Tuesday, April 13, 2004 12:50 PM Subject: Put a link in a textarea Is there a way that a user can enter a URL in a textarea and have the link actually display and work as a hyperlink? For example: class="noborder"> blah blah blah http://www.houseoffusion.com/ blah blah blah _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Would this information help explain what I need? Here's where the styles comes in: I have a CSS stylesheet with these values: #FellSvc{display:none;} #MinorRts{display:none;} #AmnInf{display:none;} #AnteSter{display:none;} In the db table, I have a column for the same styles from the stylesheet. Let's say the column name is "linkStyle" (like Dick's example). Another column in the db table has the text for the menu link that displays on the page. When a user clicks on a menu link (generated by the CF code prior to the user interaction), an assoicated DIV with an ID equal to the stylename displays its content because the onClick event tells the matching style in the stylesheet to change "display=none" to "display=block". Using Dick's example, just change the end to something like this: >Now, iterating over the query: > > > > Now, that doesn't work because #linkStyle# is CF and onClick needs js. I don't know how to loop through this onClick variable to get the range of values to be produced - one for each iteration of the results, like: menu item one: ...> menu item two: ...> menu item two: ...> etc. Does that help? I need to be gone for a few hours, but I'll check back. Thank you and Dick so much for sticking with me on this!!! > It sounds like you need to combine the results from the 2 queries into > a single query objectOR write a more complex query to join all the > tables involved to produce a single recordset. > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > - Original Message - > From: Joy Holman > To: CF-Talk > Sent: Tuesday, April 13, 2004 11:55 AM > Subject: Re: passing multiple CF vaules to a _javascript_ variable > > > The rendered output is a menu of links. One query column > returns the text for a link, another query column returns the target > for the link. The style name column is used in an onClick event to set > a CSS style to display content when clicked. > > The style name doesn't display on screen. > > I'm able to generate all the values I need except for all the > stylename values. If I only had one result from the query, it would > work fine. But I can't get the style name value to change as > additional menu items are generated from the query results. Maybe what > I need is help with _javascript_. > > I don't know how to explain it any better. I guess that's a drawback > of not being able to talk in real time. Thanks for your efforts. I'll > keep at it. > > event. > > From the query results, I create the js: target() which returns > > the value of the stylename field. How do I loop over the > > stylename values so that I get one value per onClick event which > > is generates multiple times based on the number of records in > > the query? > > >I am sorry... > > > >I can't understand what you are trying to do. > > > >It is a simple matter to include the value of a column from the query > > >in a line of text generated within the output tags... > > > >But you are already doing that... > > > > > >Maybe this would help me to help you: > > > >1) show me a few lines of the rendered output that you desire--- no > CF > >tags, just the rendered output. > > > >2) put an asterisk or something in front of each value in the > rendered > >output that you want to dynamically create with your CF code, > > > >3) Run your query and display the output of enough rows showing the > >columns & their values that contain the dynamic data > > > > > >HTH > > > >Dick > > > >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote: > > > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Here's where the styles comes in: I have a CSS stylesheet with these values: #FellSvc{display:none;} #MinorRts{display:none;} #AmnInf{display:none;} #AnteSter{display:none;} In the db table, I have a column for the same styles from the stylesheet. Let's say the column name is "linkStyle" (like your example). Another column in the db table has the text for the menu link that displays on the page. When a user clicks on a menu link (generated by the CF code prior to the user interaction), an assoicated DIV with an ID equal to the stylename displays its content because the onClick event tells the matching style in the stylesheet to change "display=none" to "display=block". Using your example, just change the end to something like this: >Now, iterating over the query: > > > > Now, that doesn't work because #linkStyle# is CF and onClick needs js. I don't know how to loop through this onClick variable to get the range of values to be produced - one for each iteration of the results, like: menu item one: ...> menu item two: ...> menu item two: ...> etc. Does that help? >I realize that you are trying to create a list of links -- what I can't >understand is where the dynamic data is supposed to come from > >I would write something like: > > > SELECT linkName, linkURL, linkStyle FROM linkTable > > >yields a query containing: > >linkName linkURL linkStyle >-- -- -- >Apple www.apple.com colorful >Macromedia www.macromedia.com flashy >Microsoft www.microsoft.com opportunistic > >Now, iterating over the query: > > > #linkName# > > > >yields: > > Apple > Macromedia > Microsoft > >I know this is not exactly what you want, but using the same technique, >can you show me what you want? > >Dick > > >On Apr 13, 2004, at 11:55 AM, Joy Holman wrote: > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Put a link in a textarea
At first glance, it looks like it puts an But if this is displayed in a textarea, it would just display the text with a link. Or am I wrong here. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 3:51 PM To: CF-Talk Subject: Re: Put a link in a textarea Yep...go to www.cflib.org and grab the UDF named ActivateURL.works like a charm ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: CF-Talk Sent: Tuesday, April 13, 2004 12:50 PM Subject: Put a link in a textarea Is there a way that a user can enter a URL in a textarea and have the link actually display and work as a hyperlink? For example: class="noborder"> blah blah blah http://www.houseoffusion.com/ blah blah blah _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Import a Text file to MYSQL
Using CF to convert the file into an INSERT statement would be quite slow, I'd imagine, though you could probably restore some of the performance by buffering (using a StringBuffer, for example). LOAD DATA INFILE is going to be as fast as you can do it. I've never used it for more than a few thousand records, but it was blazing fast, and all the load is on the DB (not CF), which is very nice. I'm not going to say that it won't be a burden on the server, but it'll be relatively small for that many records. And if you're replacing the all the data (as opposed to adding new data), make sure you use TRUNCATE TABLE rather than DELETE. It drops and recreates the table, rather than deleting each row, so it's enormously faster when you've got a big table and you need to delete all the rows. Cheers, barneyb > -Original Message- > From: Mickael [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 13, 2004 12:32 PM > To: CF-Talk > Subject: Re: Import a Text file to MYSQL > > Hi Barney, > > I have over 1 million records to import daily would that not > be very taxing on the server? > - Original Message - > From: Barney Boisvert > To: CF-Talk > Sent: Tuesday, April 13, 2004 3:16 PM > Subject: RE: Import a Text file to MYSQL > > > You can use LOAD DATA INFILE if you have sufficient > privileges on the server > and the file format is acceptable. If not, it's pretty > simple to do some > text manipulation and convert text into a multi-line INSERT > statement: > > INSERT INTO tabl > (col1, col2, col3) > VALUES > ('11', '12', '13'), > ('21', '22', '23'), > ('31', '32', '33'), > . > ('n1', 'n2', 'n3) > > Basically, it goes like this: replace all "'" with "\'", > add "('" to the > start of every line, add "')" to the end, replace "," with > "','", prepend > the INSERT VALUES stuff, and then remove the trailing comma. > > Cheers, > barneyb > > > -Original Message- > > From: Mickael [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, April 13, 2004 12:06 PM > > To: CF-Talk > > Subject: Import a Text file to MYSQL > > > > Hello All, > > > > Can you import a text file to MYSQL with CF. I would like to > > take a text file that is exported to Access then Drop/Create > > the table with CF in MYSQL then import the file in its > > entirety to create the table. > > > > This sounds simple enough in theory, how can this be done in > > CF and MYSQL I don't really have any experience with MYSQL > > > > Thanks in advance > > > > Mike > > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: Flash Remoting vs Web Services vs XML
Have you considered Flex (or as I like to call it FlexFlash) In my very limited experience Flex programming of RIAs is much easier than Flash programming unless you are into heavy animation, visual effects, etc. You can get all you need for development with the Flex evaluation CD. Then you can install flex to run in conjunction with CFMX -- which is the best of both worlds (server-side power and client-side RIA) The big barrier may be the price of Flex but I understand that this may be negotiable. Your timeframe may also be a consideration -- there have been hints that the next release of CFMX (BlackGuard, BlackHart, BlackMagic, BlackBeauty, BlackStone, whatever) will include Flex capabilities. The way it (current CFMX Flex) appears to work is this: 1) You create CF templates with imbedded (or included) Flex source containing special XML (MXXML) and ActionScript (similar to _javascript_). The CF template gets compiled to Java Byte code The Flash portion of the template gets compiled to a SWF Both are served to the requestor; Here are the headers for a very simple CFMX Flex program (a Menu Tree) "GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753 "GET /cfusion/flex/CFFlexTree.cfm HTTP/1.1" 200 1753 "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244 "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 1244 "GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257 "GET /cfusion/flex-internal/history/history.html HTTP/1.1" 200 1257 "GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528 "GET /cfusion/Flex/244813253.mxml.swf HTTP/1.1" 200 116528 "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656 "GET /cfusion/flex-internal?action="" HTTP/1.1" 200 2656 It appears as if there are separate requests generated for: 1) the cf template 2) flex js 3) flex history 4) a swf containing the Flex portion of the CF template (mxml.swf) 5) a generic swf This is quite a fewf connections for a simple program, but I am told that as complexity increases, there should be fewer connections than with a typical html page. FlexFlash and Flash remoting tend to change the way you program -- not always for the better 1) rather then populate the initial page with initial data as with CF/HTML it is cleaner to do the following with FR: --download the RIA client --the client, when loaded, makes the request for initial data. 2) from a programming standpoint it is easy to ignore the overhead of exchanging large XML packets between host and client 3) if you give a lot of capability to the client (updating records on the client with out contacting the host) you can add orders of magnitude of complexity to the host (lockouts, deadlocks, synchronization) and to the RIA client -- what happens if the browser crashes after you've made 20 minutes of updates? 4) Multiple browser windows with a Flash RIA clients, each consume client resources even when inactive. They compete with each other and other desktop apps. So, everything you've learned with CF still applies -- Flash can improve the UI, and the UE (User Experience) -- but, better to be a little skeptical HTH Dick On Apr 13, 2004, at 12:06 PM, Chris Alvarado wrote:) > Hello all, > > I am starting a new project that will require some fairly heavy Flash > / > CF integration including but not limited to: visual display of data > stored in a database, insertion of data into a database supplied in > Flash forms, a complete security model that requires not only > authentication but user level access restrictions (role based model). > I > just ready the article on Macromedia DevNet about the various options > for developing RIAs (Remoting, Web Services, XML) and am having a bit > of > a hard time deciding which route to pursue. Are there any RIA specific > mailing lists etc that anyone can recommend. Additionally can anyone > here point me in the right direction? I am a complete rookie when it > comes to Flash but have nearly 7years of CF experience so the CF > concepts are easy to grasp for me, im just sort of a bit inundated > with > the Flash portion. If anyone has any suggestions on where to get > started > they would be greatly appreciated. I picked up "Macromedia Flash MX > Profession 2004 for Server Geeks" and it seems like an excellent book, > but if anyone has any other suggestions that would fit well within the > project described above I would really appreciate it. > > Thanks everyone, > > Looking forward to seeing any feedback. > > -chris.alvarado > > [ application developer ] > > 4 Guys Interactive, Inc. > > 281.807.4344 x1716 > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Put a link in a textarea
Yep...go to www.cflib.org and grab the UDF named ActivateURL.works like a charm ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: CF-Talk Sent: Tuesday, April 13, 2004 12:50 PM Subject: Put a link in a textarea Is there a way that a user can enter a URL in a textarea and have the link actually display and work as a hyperlink? For example: blah blah blah http://www.houseoffusion.com/ blah blah blah [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Put a link in a textarea
Is there a way that a user can enter a URL in a textarea and have the link actually display and work as a hyperlink? For example: blah blah blah http://www.houseoffusion.com/ blah blah blah [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX6.1 updater
Hey does anyone have any idea when an updater for CFMX6.1 might be out? I just had to re-image my web server and re-install. Now most of my time is being spent dling and installing HotFixes and Security updates for ColdFusion. An updater would be really helpful about now as I am up to 14 hotfix/security updates with more to go. Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Could you give me some pseudo code to work with? I guess this is exactly where I'm stuck. I've only got the one table and one query. Everything I need is in there. I just can't figure out how to make the value needed on the onClick event be unique for each event generated by the outputting of the query results. I don't know how to loop through the that variable's values correctly. I appreciate your help. Joy Holman > It sounds like you need to combine the results from the 2 queries into > a single query objectOR write a more complex query to join all the > tables involved to produce a single recordset. > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > - Original Message - > From: Joy Holman > To: CF-Talk > Sent: Tuesday, April 13, 2004 11:55 AM > Subject: Re: passing multiple CF vaules to a _javascript_ variable > > > The rendered output is a menu of links. One query column > returns the text for a link, another query column returns the target > for the link. The style name column is used in an onClick event to set > a CSS style to display content when clicked. > > The style name doesn't display on screen. > > I'm able to generate all the values I need except for all the > stylename values. If I only had one result from the query, it would > work fine. But I can't get the style name value to change as > additional menu items are generated from the query results. Maybe what > I need is help with _javascript_. > > I don't know how to explain it any better. I guess that's a drawback > of not being able to talk in real time. Thanks for your efforts. I'll > keep at it. > > event. > > From the query results, I create the js: target() which returns > > the value of the stylename field. How do I loop over the > > stylename values so that I get one value per onClick event which > > is generates multiple times based on the number of records in > > the query? > > >I am sorry... > > > >I can't understand what you are trying to do. > > > >It is a simple matter to include the value of a column from the query > > >in a line of text generated within the output tags... > > > >But you are already doing that... > > > > > >Maybe this would help me to help you: > > > >1) show me a few lines of the rendered output that you desire--- no > CF > >tags, just the rendered output. > > > >2) put an asterisk or something in front of each value in the > rendered > >output that you want to dynamically create with your CF code, > > > >3) Run your query and display the output of enough rows showing the > >columns & their values that contain the dynamic data > > > > > >HTH > > > >Dick > > > >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote: > > > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT ? Emulation
Well maybe heresy, instead of OT ;-) Does anyone know of good non-CF scripts, Perl, CGI, etc. that perform the same function as ? Thanks, Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Import a Text file to MYSQL
Hi Barney, I have over 1 million records to import daily would that not be very taxing on the server? - Original Message - From: Barney Boisvert To: CF-Talk Sent: Tuesday, April 13, 2004 3:16 PM Subject: RE: Import a Text file to MYSQL You can use LOAD DATA INFILE if you have sufficient privileges on the server and the file format is acceptable. If not, it's pretty simple to do some text manipulation and convert text into a multi-line INSERT statement: INSERT INTO tabl (col1, col2, col3) VALUES ('11', '12', '13'), ('21', '22', '23'), ('31', '32', '33'), . ('n1', 'n2', 'n3) Basically, it goes like this: replace all "'" with "\'", add "('" to the start of every line, add "')" to the end, replace "," with "','", prepend the INSERT VALUES stuff, and then remove the trailing comma. Cheers, barneyb > -Original Message- > From: Mickael [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 13, 2004 12:06 PM > To: CF-Talk > Subject: Import a Text file to MYSQL > > Hello All, > > Can you import a text file to MYSQL with CF. I would like to > take a text file that is exported to Access then Drop/Create > the table with CF in MYSQL then import the file in its > entirety to create the table. > > This sounds simple enough in theory, how can this be done in > CF and MYSQL I don't really have any experience with MYSQL > > Thanks in advance > > Mike > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: Spammed from post to cf-talk
I just got spammed with the subject line of a post I made to cf-talk. Where should I forward the spam msg to add the abuser to the filter? TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to streamline a request that uses many cfquery statements ?
I asked: > Is there a way to have multiple queries running from the same > cf template at the same time? Pascal said: > Stored Procedures? Deanna said: > Sounds like you should be doing some stored procedures. I assume that you both mean that the CF template would call one stored procedure that on the database (Oracle) we could have break out the queries in subsets that would run in concurrent processes? Jochem said: > Write a multi-threaded Java/C customtag. Whoo-boy, that would be fun - we are just starting to wrap our heads around the migration from CF 5 to CFMX . . . I said: > Logically it seems that we could run the three > > report processes concurrently and independently and then assemble > > them into the final report when the answer sets come back which > > should dramatically speed up the process. Jochem said: > Not necessarily. If the db-server is continuously stressed out > concurrent queries will not help. There even is a considerable chance > they will hurt, for instance through trashing the buffers. Point taken. It was one of our database people who asked if CF would allow us to run queries concurrently, so I hope he would have your concerns in mind. Thanks all! George [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Recipe Application
Issac Rosa wrote: > Does anyone know of a good recipe application? No specific > requirements, so open to all suggestions. > Hmm... I can't resist. No requirements? That sounds like a recipe for disaster. :D sorry, that was terrible. -nathan strutz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
I realize that you are trying to create a list of links -- what I can't understand is where the dynamic data is supposed to come from I would write something like: SELECT linkName, linkURL, linkStyle FROM linkTable yields a query containing: linkName linkURL linkStyle -- -- -- Apple www.apple.com colorful Macromedia www.macromedia.com flashy Microsoft www.microsoft.com opportunistic Now, iterating over the query: #linkName# yields: Apple Macromedia Microsoft I know this is not exactly what you want, but using the same technique, can you show me what you want? Dick On Apr 13, 2004, at 11:55 AM, Joy Holman wrote: > The rendered output is a menu of links. One query column > returns the text for a link, another query column returns the target > for the link. The style name column is used in an onClick event to set > a CSS style to display content when clicked. > > The style name doesn't display on screen. > > I'm able to generate all the values I need except for all the > stylename values. If I only had one result from the query, it would > work fine. But I can't get the style name value to change as > additional menu items are generated from the query results. Maybe what > I need is help with _javascript_. > > I don't know how to explain it any better. I guess that's a drawback > of not being able to talk in real time. Thanks for your efforts. I'll > keep at it. > > event. > > From the query results, I create the js: target() which returns > > the value of the stylename field. How do I loop over the > > stylename values so that I get one value per onClick event which > > is generates multiple times based on the number of records in > > the query? > > >I am sorry... > > > >I can't understand what you are trying to do. > > > >It is a simple matter to include the value of a column from the query > >in a line of text generated within the output tags... > > > >But you are already doing that... > > > > > >Maybe this would help me to help you: > > > >1) show me a few lines of the rendered output that you desire--- no > CF > >tags, just the rendered output. > > > >2) put an asterisk or something in front of each value in the > rendered > >output that you want to dynamically create with your CF code, > > > >3) Run your query and display the output of enough rows showing the > >columns & their values that contain the dynamic data > > > > > >HTH > > > >Dick > > > >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote: > > > >> > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Import a Text file to MYSQL
You can use LOAD DATA INFILE if you have sufficient privileges on the server and the file format is acceptable. If not, it's pretty simple to do some text manipulation and convert text into a multi-line INSERT statement: INSERT INTO tabl (col1, col2, col3) VALUES ('11', '12', '13'), ('21', '22', '23'), ('31', '32', '33'), . ('n1', 'n2', 'n3) Basically, it goes like this: replace all "'" with "\'", add "('" to the start of every line, add "')" to the end, replace "," with "','", prepend the INSERT VALUES stuff, and then remove the trailing comma. Cheers, barneyb > -Original Message- > From: Mickael [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 13, 2004 12:06 PM > To: CF-Talk > Subject: Import a Text file to MYSQL > > Hello All, > > Can you import a text file to MYSQL with CF. I would like to > take a text file that is exported to Access then Drop/Create > the table with CF in MYSQL then import the file in its > entirety to create the table. > > This sounds simple enough in theory, how can this be done in > CF and MYSQL I don't really have any experience with MYSQL > > Thanks in advance > > Mike > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Import a Text file to MYSQL
Hello All, Can you import a text file to MYSQL with CF. I would like to take a text file that is exported to Access then Drop/Create the table with CF in MYSQL then import the file in its entirety to create the table. This sounds simple enough in theory, how can this be done in CF and MYSQL I don't really have any experience with MYSQL Thanks in advance Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: Flash Remoting vs Web Services vs XML
Hello all, I am starting a new project that will require some fairly heavy Flash / CF integration including but not limited to: visual display of data stored in a database, insertion of data into a database supplied in Flash forms, a complete security model that requires not only authentication but user level access restrictions (role based model). I just ready the article on Macromedia DevNet about the various options for developing RIAs (Remoting, Web Services, XML) and am having a bit of a hard time deciding which route to pursue. Are there any RIA specific mailing lists etc that anyone can recommend. Additionally can anyone here point me in the right direction? I am a complete rookie when it comes to Flash but have nearly 7years of CF experience so the CF concepts are easy to grasp for me, im just sort of a bit inundated with the Flash portion. If anyone has any suggestions on where to get started they would be greatly appreciated. I picked up "Macromedia Flash MX Profession 2004 for Server Geeks" and it seems like an excellent book, but if anyone has any other suggestions that would fit well within the project described above I would really appreciate it. Thanks everyone, Looking forward to seeing any feedback. -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. 281.807.4344 x1716 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: email folder
C:\CFusionMX\Mail -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 2:54 PM To: CF-Talk Subject: email folder hey where is the email folder for cfmx? the one where spooled messages go before sending. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
It sounds like you need to combine the results from the 2 queries into a single query objectOR write a more complex query to join all the tables involved to produce a single recordset. Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Joy Holman To: CF-Talk Sent: Tuesday, April 13, 2004 11:55 AM Subject: Re: passing multiple CF vaules to a _javascript_ variable The rendered output is a menu of links. One query column returns the text for a link, another query column returns the target for the link. The style name column is used in an onClick event to set a CSS style to display content when clicked. The style name doesn't display on screen. I'm able to generate all the values I need except for all the stylename values. If I only had one result from the query, it would work fine. But I can't get the style name value to change as additional menu items are generated from the query results. Maybe what I need is help with _javascript_. I don't know how to explain it any better. I guess that's a drawback of not being able to talk in real time. Thanks for your efforts. I'll keep at it. event. From the query results, I create the js: target() which returns the value of the stylename field. How do I loop over the stylename values so that I get one value per onClick event which is generates multiple times based on the number of records in the query? >I am sorry... > >I can't understand what you are trying to do. > >It is a simple matter to include the value of a column from the query >in a line of text generated within the output tags... > >But you are already doing that... > > >Maybe this would help me to help you: > >1) show me a few lines of the rendered output that you desire--- no CF >tags, just the rendered output. > >2) put an asterisk or something in front of each value in the rendered >output that you want to dynamically create with your CF code, > >3) Run your query and display the output of enough rows showing the >columns & their values that contain the dynamic data > > >HTH > >Dick > >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote: > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web + v5.0
I'm in the same boat, I have no association with CFDJ. -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 1:36 PM To: CF-Talk Subject: RE: Web + v5.0 I didn't receive the Web + thing, and I'm not subscribed to anything with my address except Macromedia. So maybe your CFDJ theory is correct. John -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 1:12 PM To: CF-Talk Subject: Re: Web + v5.0 Tony Weeg wrote: > I wonder who gave our info away??? Maybe if more of us had clicked on those ads in the cf-talk mails, Michael wouldn't have had to sell our info. :) Seriously, it's a good question. I can't imagine Macromedia would have. Is everyone who's received this Web+ CD subscribed to the CF Developer's Journal? I wouldn't put it past Sys-Con. Scott -- --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
email folder
hey where is the email folder for cfmx? the one where spooled messages go before sending. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
The rendered output is a menu of links. One query column returns the text for a link, another query column returns the target for the link. The style name column is used in an onClick event to set a CSS style to display content when clicked. The style name doesn't display on screen. I'm able to generate all the values I need except for all the stylename values. If I only had one result from the query, it would work fine. But I can't get the style name value to change as additional menu items are generated from the query results. Maybe what I need is help with _javascript_. I don't know how to explain it any better. I guess that's a drawback of not being able to talk in real time. Thanks for your efforts. I'll keep at it. event. >From the query results, I create the js: target() which returns the value of the stylename field. How do I loop over the stylename values so that I get one value per onClick event which is generates multiple times based on the number of records in the query? >I am sorry... > >I can't understand what you are trying to do. > >It is a simple matter to include the value of a column from the query >in a line of text generated within the output tags... > >But you are already doing that... > > >Maybe this would help me to help you: > >1) show me a few lines of the rendered output that you desire--- no CF >tags, just the rendered output. > >2) put an asterisk or something in front of each value in the rendered >output that you want to dynamically create with your CF code, > >3) Run your query and display the output of enough rows showing the >columns & their values that contain the dynamic data > > >HTH > >Dick > >On Apr 13, 2004, at 10:16 AM, Joy Holman wrote: > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access 2003 ODBC
- Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 13, 2004 10:29 AM Subject: RE: Access 2003 ODBC > If you have the latest version of Jet on your server, it can read > Access 2000 and 2003 files, without requiring any additional > installation. Jet used to be bundled with MDAC, but it's now available > separately (although you'll still want the latest version of MDAC too, > typically): > http://msdn.microsoft.com/data/downloads/updates/default.aspx#jet Just found that Access 2003 (and Access 2002? didn't know there was a 2002) by default use the same file format as Access 2000. http://www.microsoft.com/office/access/prodinfo/overview.mspx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access 2003 ODBC
- Original Message - From: "Claude Schneegans" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 13, 2004 11:31 AM Subject: Re: Access 2003 ODBC > >>would probably find it more convenient to use Access 2003 on the > >>server. > > As far as CF is concerned, there is NO Access on the server: only an > Access file and an ODBC driver. Yeah, we know that. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How many class files do YOU have?
A 6.1 thing? What version are you running? Brook At 11:08 AM 4/13/2004, you wrote: >Brook, > > >We don't have the option of compiling them to memory as I think that is only >a 6.1 thing. Regarding the template cache size. It is based on the number >of files that you think will be in use at one time. In our case not all >24,000 cf files will be used all the time so we set it to some reasonable >percentage of those files. 75 - 80%. In your case you could probably do >all of them with no ill effects. > > >Mark > >-Original Message- >From: Brook Davies [mailto:[EMAIL PROTECTED] >Sent: Tuesday, April 13, 2004 10:33 AM >To: CF-Talk >Subject: RE: How many class files do YOU have? > >I thought Brandon said that with that many class files you would be better >off not storing the class files to the HD and compiling them to memory at >run time instead? Also, is the template cache setting the number of cfm >templates or expected resulting class files? > >Bradon also wrote: >"I have some info on my blog http://bpurcell.org but to fix this bump up >the -XX:MaxPermSize value in your jvm.config to 192 or 256 it should get >rid of the problem." > >Can I bump it up to 512? > >Also, do these numbers look okay? > >Description: JAR Launcher >Version: 4.00..63824 >Handle count: 721 >Threads: 50 >Page fault count: 405529 >Peak working set size: 1,118,192.00 KB >Working set size: 1,113,800.00 KB >Peak page file usage: 1,115,992.00 KB >Page file usage: 1,110,392.00 KB >Total memory usage: 2,224,192.00 KB >Command line: C:\CFusionMX\runtime\bin\jrun.exe > >Brook > >At 09:55 AM 4/13/2004, you wrote: > > >Brook, > >Well I was curious about your question so i went ahead and took a look at > >how many class files we have. We also create cfm files on the fly for new > >accounts etc. On checking we have 25,759 class files in the cfclasses > >directory. All the suggestions below are accurate. Be sure to set your > >template cache as high as is reasonable with the memory you have. Also the > >jvm settings mentioned are very important. These things should all make a > >huge difference in your performance. > > > > > >Mark > > > >-Original Message- > >From: Brook Davies [mailto:[EMAIL PROTECTED] > >Sent: Friday, April 09, 2004 12:25 PM > >To: CF-Talk > >Subject: How many class files do YOU have? > > > >I repoted to this list awhile ago about really long start up times for one > >of my apps on the first run. It seems that this problem has been resolved > >by defragging the HD? The C:\CFusionMX\wwwroot\WEB-INF\cfclasses folder had > >a lot of fragmented files as well as other areas on the HD. Does that make > >sense? > > > >Anyhow, I have 6,591 class files in my class folder taking up about 80 > >megs. So, I am curious now how many class files ya'll have on your servers? > > > >And another question related to disk usage; what are the guidelines for a > >paging file and is it needed if you have lots of physical ram? The reason I > >ask is because I wonder if a fragmented HD, and a page file on that disk > >might cause problems. I've had some JavaOutOfMemory errors, so I am looking > >for answers everywhere :) > > > >Brook > > _ > > > >-- > >[Todays Threads] > >[This Message] > >[Subscription] > >[Fast > > > Unsubscribe] [User Settings] > > > >-- > > > >[] > > > _ > >-- >[Todays Threads] >[This Message] >[Subscription] >[Fast > Unsubscribe] [User Settings] > >-- > >[] > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
I am sorry... I can't understand what you are trying to do. It is a simple matter to include the value of a column from the query in a line of text generated within the output tags... But you are already doing that... Maybe this would help me to help you: 1) show me a few lines of the rendered output that you desire--- no CF tags, just the rendered output. 2) put an asterisk or something in front of each value in the rendered output that you want to dynamically create with your CF code, 3) Run your query and display the output of enough rows showing the columns & their values that contain the dynamic data HTH Dick On Apr 13, 2004, at 10:16 AM, Joy Holman wrote: > "menu_bmarkLink" is the name of the column in the query that contains > the style > >name > > >You use a SELECT * > > > >This is usually a bad habit as it makes the SQL engine do extra work > & > >degrades performance -- in this case, it also causes confusion.' > > > >What is the name of the column in the query that contains the style > >name? > > > >Dick > >On Apr 13, 2004, at 9:53 AM, Joy Holman wrote: > > > >> > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
MX 6.1 on a Linux box. See my initial post in this thread for more info. At 11:55 AM 4/13/2004, you wrote: >What version of CF u using? We had this happen with CF5 on >Solaris...every once and a while it went nuts and ran items 5 times >every few seconds! > >It's been months on 6.1 without incident though... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How many class files do YOU have?
Brook, We don't have the option of compiling them to memory as I think that is only a 6.1 thing. Regarding the template cache size. It is based on the number of files that you think will be in use at one time. In our case not all 24,000 cf files will be used all the time so we set it to some reasonable percentage of those files. 75 - 80%. In your case you could probably do all of them with no ill effects. Mark -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 10:33 AM To: CF-Talk Subject: RE: How many class files do YOU have? I thought Brandon said that with that many class files you would be better off not storing the class files to the HD and compiling them to memory at run time instead? Also, is the template cache setting the number of cfm templates or expected resulting class files? Bradon also wrote: "I have some info on my blog http://bpurcell.org but to fix this bump up the -XX:MaxPermSize value in your jvm.config to 192 or 256 it should get rid of the problem." Can I bump it up to 512? Also, do these numbers look okay? Description: JAR Launcher Version: 4.00..63824 Handle count: 721 Threads: 50 Page fault count: 405529 Peak working set size: 1,118,192.00 KB Working set size: 1,113,800.00 KB Peak page file usage: 1,115,992.00 KB Page file usage: 1,110,392.00 KB Total memory usage: 2,224,192.00 KB Command line: C:\CFusionMX\runtime\bin\jrun.exe Brook At 09:55 AM 4/13/2004, you wrote: >Brook, >Well I was curious about your question so i went ahead and took a look at >how many class files we have. We also create cfm files on the fly for new >accounts etc. On checking we have 25,759 class files in the cfclasses >directory. All the suggestions below are accurate. Be sure to set your >template cache as high as is reasonable with the memory you have. Also the >jvm settings mentioned are very important. These things should all make a >huge difference in your performance. > > >Mark > >-Original Message- >From: Brook Davies [mailto:[EMAIL PROTECTED] >Sent: Friday, April 09, 2004 12:25 PM >To: CF-Talk >Subject: How many class files do YOU have? > >I repoted to this list awhile ago about really long start up times for one >of my apps on the first run. It seems that this problem has been resolved >by defragging the HD? The C:\CFusionMX\wwwroot\WEB-INF\cfclasses folder had >a lot of fragmented files as well as other areas on the HD. Does that make >sense? > >Anyhow, I have 6,591 class files in my class folder taking up about 80 >megs. So, I am curious now how many class files ya'll have on your servers? > >And another question related to disk usage; what are the guidelines for a >paging file and is it needed if you have lots of physical ram? The reason I >ask is because I wonder if a fragmented HD, and a page file on that disk >might cause problems. I've had some JavaOutOfMemory errors, so I am looking >for answers everywhere :) > >Brook > _ > >-- >[Todays Threads] >[This Message] >[Subscription] >[Fast > Unsubscribe] [User Settings] > >-- > >[] > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
What version of CF u using? We had this happen with CF5 on Solaris...every once and a while it went nuts and ran items 5 times every few seconds! It's been months on 6.1 without incident though... Stace _ From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 1:52 PM To: CF-Talk Subject: RE: MX: Scheduler firing off too often At 11:46 AM 4/13/2004, you wrote: >You can also turn on schedule task logging in the admin. In the end, though, my problem still stands - what if the scheduler is firing off a task multiple times when it should only fire it off once, at any given time? What should I look for/at as far as correcting this behavior. FYI the task in question has been firing off every three minutes, once, for the past couple or three hours without issue, but I'm not going to count on that behavior continuing. --Scott _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
At 11:46 AM 4/13/2004, you wrote: >You can also turn on schedule task logging in the admin. In the end, though, my problem still stands - what if the scheduler is firing off a task multiple times when it should only fire it off once, at any given time? What should I look for/at as far as correcting this behavior. FYI the task in question has been firing off every three minutes, once, for the past couple or three hours without issue, but I'm not going to count on that behavior continuing. --Scott [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
You can also turn on schedule task logging in the admin. Stace _ From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 12:29 PM To: CF-Talk Subject: RE: MX: Scheduler firing off too often At 09:35 AM 4/13/2004, you wrote: >In that email, that you are sending to your self, you may also want to add a >few CGI vars to see where and what is calling that cfm page. One time >Google some how found a .cfm page that I had scheduler set to run once a >week and every time Google spidered the site it would run that page. That's a damn fine idea. Thanks! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Email Not Being Sent from Local Server (CF5)
You will need to upgrade to ColdFusion MX 6.1, where SMTP authentication was added as a feature. You can't do it with CF 5. -- Tom Jordahl Macromedia Server Development -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 3:32 PM To: CF-Talk Subject: Re: Email Not Being Sent from Local Server (CF5) Chris Montgomery wrote: > Friday, April 9, 2004, 2:09:34 PM, Jochem van Dieten wrote: >> >> mail.log > > Ok, so this is saying that authentication is required. I didn't have > this problem when I was running Win2k, but anywayif I check the > box for " Verify Mail Server Connection" in CF Admin, I get the > message "ColdFusion connected to your server. Verification completed > without error." I don't understand what's happening. Verification only does a HELO, it doesn't actually try to send a message. > Also, how does > one provide authentication data for the mail server...I am not seeing > a way to enter that anywhere. With the username and password attributes of cfmail. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: track cferrors
You could create a small error-tracking system that stores the errors in a database and then make a place where you can view them. When an error occurs, insert the error into the DB and redirect the user to an error page with a message. (if that fits your application) John Burns -Original Message- From: Robert Redpath [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 1:35 PM To: CF-Talk Subject: track cferrors How do you guys track cferrors? I do not have access to the cf administrator so I use a form which emails me the errors from the error template. But I am looking for a better way to view the errors since the solution I use requires the user to back page 2x to get out of an error (I have a _javascript_ back button that goes back to the original page but most users instinctively hit the back button) and sometimes the errors don't get mailed with all the error codes. Here is what I use: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Null Pointer from CFQUERY
Is it the double dots in etrade..Bank that is causing your problem? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Alisa Thomson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 12:25 PM To: CF-Talk Subject: Null Pointer from CFQUERY I am testing out an application that we want to migrate to CFMX (currently CF5). I am getting a NullPointerException from one of my queries when I use jConnect 5.5 (Sybase 12.5) instead of the Sybase driver that ships with CFMX. We want to use jConnect because all of our Java apps use that and we ran into other issues with the driver that ships with CFMX. Here is the query: SELECT FirstNme FROM etrade..Bank WHERE BankId = 'WF' As you can see, there are no variables in the query so the NullPointerException is not caused by an undefined var. The FROM clause is referencing a view that actually references another view in another database. We have other queries set up this same way that work fine under jConnect 5.5. The stacktrace just says: java.lang.NullPointerException no other information. Anyone have any ideas? Thanks in advance. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web + v5.0
I didn't receive the Web + thing, and I'm not subscribed to anything with my address except Macromedia. So maybe your CFDJ theory is correct. John -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 1:12 PM To: CF-Talk Subject: Re: Web + v5.0 Tony Weeg wrote: > I wonder who gave our info away??? Maybe if more of us had clicked on those ads in the cf-talk mails, Michael wouldn't have had to sell our info. :) Seriously, it's a good question. I can't imagine Macromedia would have. Is everyone who's received this Web+ CD subscribed to the CF Developer's Journal? I wouldn't put it past Sys-Con. Scott -- --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
track cferrors
How do you guys track cferrors? I do not have access to the cf administrator so I use a form which emails me the errors from the error template. But I am looking for a better way to view the errors since the solution I use requires the user to back page 2x to get out of an error (I have a _javascript_ back button that goes back to the original page but most users instinctively hit the back button) and sometimes the errors don't get mailed with all the error codes. Here is what I use: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access 2003 ODBC
>>would probably find it more convenient to use Access 2003 on the server. As far as CF is concerned, there is NO Access on the server: only an Access file and an ODBC driver. The Access application is not used. The file can be Access 95, 97 2000 or 2003, it does not really make a big difference. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How many class files do YOU have?
I thought Brandon said that with that many class files you would be better off not storing the class files to the HD and compiling them to memory at run time instead? Also, is the template cache setting the number of cfm templates or expected resulting class files? Bradon also wrote: "I have some info on my blog http://bpurcell.org but to fix this bump up the -XX:MaxPermSize value in your jvm.config to 192 or 256 it should get rid of the problem." Can I bump it up to 512? Also, do these numbers look okay? Description: JAR Launcher Version: 4.00..63824 Handle count: 721 Threads: 50 Page fault count: 405529 Peak working set size: 1,118,192.00 KB Working set size: 1,113,800.00 KB Peak page file usage: 1,115,992.00 KB Page file usage: 1,110,392.00 KB Total memory usage: 2,224,192.00 KB Command line: C:\CFusionMX\runtime\bin\jrun.exe Brook At 09:55 AM 4/13/2004, you wrote: >Brook, >Well I was curious about your question so i went ahead and took a look at >how many class files we have. We also create cfm files on the fly for new >accounts etc. On checking we have 25,759 class files in the cfclasses >directory. All the suggestions below are accurate. Be sure to set your >template cache as high as is reasonable with the memory you have. Also the >jvm settings mentioned are very important. These things should all make a >huge difference in your performance. > > >Mark > >-Original Message- >From: Brook Davies [mailto:[EMAIL PROTECTED] >Sent: Friday, April 09, 2004 12:25 PM >To: CF-Talk >Subject: How many class files do YOU have? > >I repoted to this list awhile ago about really long start up times for one >of my apps on the first run. It seems that this problem has been resolved >by defragging the HD? The C:\CFusionMX\wwwroot\WEB-INF\cfclasses folder had >a lot of fragmented files as well as other areas on the HD. Does that make >sense? > >Anyhow, I have 6,591 class files in my class folder taking up about 80 >megs. So, I am curious now how many class files ya'll have on your servers? > >And another question related to disk usage; what are the guidelines for a >paging file and is it needed if you have lots of physical ram? The reason I >ask is because I wonder if a fragmented HD, and a page file on that disk >might cause problems. I've had some JavaOutOfMemory errors, so I am looking >for answers everywhere :) > >Brook > _ > >-- >[Todays Threads] >[This Message] >[Subscription] >[Fast > Unsubscribe] [User Settings] > >-- > >[] > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Null Pointer from CFQUERY
I am testing out an application that we want to migrate to CFMX (currently CF5). I am getting a NullPointerException from one of my queries when I use jConnect 5.5 (Sybase 12.5) instead of the Sybase driver that ships with CFMX. We want to use jConnect because all of our Java apps use that and we ran into other issues with the driver that ships with CFMX. Here is the query: SELECT FirstNme FROM etrade..Bank WHERE BankId = 'WF' As you can see, there are no variables in the query so the NullPointerException is not caused by an undefined var. The FROM clause is referencing a view that actually references another view in another database. We have other queries set up this same way that work fine under jConnect 5.5. The stacktrace just says: java.lang.NullPointerException no other information. Anyone have any ideas? Thanks in advance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
Have a different problem now, actually I have a question. If the user makes changes to the document, is it possible to save the changes directly back to the database when the user selects the File->Save option from the menu or ctrl-s. DATASOURCE="db" USER="dbUserName" PASSWORD="dbPassword" SQL="select filename FROM dbo.Attachment WHERE id = '#url.id#'" OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName#"> The above code opens the document in a new browser [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
"menu_bmarkLink" is the name of the column in the query that contains the style >name >You use a SELECT * > >This is usually a bad habit as it makes the SQL engine do extra work & >degrades performance -- in this case, it also causes confusion.' > >What is the name of the column in the query that contains the style >name? > >Dick >On Apr 13, 2004, at 9:53 AM, Joy Holman wrote: > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
Have a different problem now, actually I have a question. If the user makes changes to the document, is it possible to save the changes directly back to the database when the user selects the File->Save option from the menu or ctrl-s. DATASOURCE="db" USER="dbUserName" PASSWORD="dbPassword" SQL="select filename FROM dbo.Attachment WHERE id = '#url.id#'" OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.FileName#"> The above code loads the document in a browser. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
I finally got it to work. I went to the ODBC section under Administrative Tools re-configured the settings explicting selecting my database under the "change the default database to" section of the DSN Configuration. I don't know why it didn't select it in the first place, but it don't matter now, it just works. Thank you all for your help cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web + v5.0
Tony Weeg wrote: > I wonder who gave our info away??? Maybe if more of us had clicked on those ads in the cf-talk mails, Michael wouldn't have had to sell our info. :) Seriously, it's a good question. I can't imagine Macromedia would have. Is everyone who's received this Web+ CD subscribed to the CF Developer's Journal? I wouldn't put it past Sys-Con. Scott -- --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Yes, I want to output the stylenames as the html code is generated. Sorry, I added the list after sending the previous code. (Actually, I don't care if I have a list of the stylenames or not; I just want to get one of the style name values from the query into each of the onClick events.) The format of the list is defaulted to commas. Here's the code with the CF list. SELECT * from qa_menu order by menu_sortText
"#q_menu.menu_nonBmarkLink#">"##Ans" Basically, if the href value is an external URL, ignore the rest of the if statement. If the href value is a bookmark link, have the href go to a specific position on the page, (#Ans), and using CSS display the previously hidden content of the style names in the onClick. I've substituted style name values where the js goes, like so: "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">< cfelse>"##Ans" Thanks. Joy >where do you want to loop thru the style name? > >1) when creating the html/js with CF/ > >2) when the user initiates the js onClick? > >if 1) above, where & what format is the list of styles? > >Dick > > > >On Apr 13, 2004, at 9:23 AM, Joy Holman wrote: > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Yes, I want to output the stylenames as the html code is generated. Sorry, I added the list after sending the previous code. (Actually, I don't care if I have a list of the stylenames or not; I just want to get one of the style name values from the query into each of the onClick events.) The format of the list is defaulted to commas. Here's the code with the CF list. SELECT * from qa_menu order by menu_sortText
"#q_menu.menu_nonBmarkLink#">"##Ans" Basically, if the href value is an external URL, ignore the rest of the if statement. If the href value is a bookmark link, have the href go to a specific position on the page, (#Ans), and using CSS display the previously hidden content of the style names in the onClick. I've substituted style name values where the js goes, like so: "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">< cfelse>"##Ans" I'd really like this to work. I think I could use this code a lot. Thanks again. Joy > I didn't see any code and without it I'm afraid I'm not getting you. > I can say that what I posted will work...it shows you the "how" to get > the vars into JS...it's up to you to pass the correct vars based on > your code (nested loops etc.) ;-) > > If you can re-post the code I'm sure the lights will come on ;-) > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > - Original Message - > From: Joy Holman > To: CF-Talk > Sent: Tuesday, April 13, 2004 9:23 AM > Subject: Re: passing multiple CF vaules to a _javascript_ variable > > > I've got my code in the first post of this thread. Based on the > > code you've written, it looks like I would get all the values in > > one onClick event. I need to generate one value per onClick. Each > > onClick is within an that holds other query results, so I > > can't just loop through the stylename variable within one > > onClick. Am I making any sense? > > Thanks for your help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
You use a SELECT * This is usually a bad habit as it makes the SQL engine do extra work & degrades performance -- in this case, it also causes confusion.' What is the name of the column in the query that contains the style name? Dick On Apr 13, 2004, at 9:53 AM, Joy Holman wrote: > Yes, I want to output the stylenames as the html code is generated. > Sorry, I added the list after sending the previous code. (Actually, I > don't care if I have a list of the stylenames or not; I just want to > get one of the style name values from the query into each of the > onClick events.) The format of the list is defaulted to commas. > Here's the code with the CF list. > > > SELECT * from qa_menu > order by menu_sortText > > > > >
>
> > > > > > > "">"#q_menu.menu_nonBmarkLink#">"##Ans" > > > > > > Basically, if the href value is an external URL, ignore the rest of > the if statement. If the href value is a bookmark link, have the href > go to a specific position on the page, (#Ans), and using CSS display > the previously hidden content of the style names in the onClick. > > I've substituted style name values where the js goes, like so: > > "#q_menu.menu_nonBmarkLink#">"##Ans" > > > > > neq"">"#q_menu.menu_nonBmarkLink#">"##Ans" > > > > > neq"">"#q_menu.menu_nonBmarkLink#">< cfelse>"##Ans" > > > > I'd really like this to work. I think I could use this code a lot. > Thanks again. > Joy > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
I finally figured out why I was getting the error. I went to the ODBC Administrator under Administrative Tools and re-configured the dsn. For some reason my database was not selected under the "change the default database to" section. I set it to "db" tested the connection successfully and it all works. Thank you all for your help. Best Regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
If you find that the page is being run by something other than CFSCHEDULE try something like this Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:29 AM To: CF-Talk Subject: RE: MX: Scheduler firing off too often At 09:35 AM 4/13/2004, you wrote: >In that email, that you are sending to your self, you may also want to add a >few CGI vars to see where and what is calling that cfm page. One time >Google some how found a .cfm page that I had scheduler set to run once a >week and every time Google spidered the site it would run that page. That's a damn fine idea. Thanks! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web + v5.0
I have to say that I'm amazed every time I find one of these smaller web application servers/scripting languages. Don't we have enough? PLEASE? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 12:46 PM To: CF-Talk Subject: RE: Web + v5.0 not to mention the freakin thing uses #'s -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 12:34 PM To: CF-Talk Subject: RE: Web + v5.0 oddly enough I hadnt until I checked my mail today, I got a cd today to mario. someone must have gotten ahold of our addresses/titles/etc, and sent this out..i bet we arent the only ones on this list to have gotten their promo cd. I wonder who gave our info away??? tony -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:53 AM To: CF-Talk Subject: OT: Web + v5.0 Has anyone heard of this product: Web + v5.0 -- It is supposed to be easier to use and less expensive than CF. Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
I didn't see any code and without it I'm afraid I'm not getting you. I can say that what I posted will work...it shows you the "how" to get the vars into JS...it's up to you to pass the correct vars based on your code (nested loops etc.) ;-) If you can re-post the code I'm sure the lights will come on ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Joy Holman To: CF-Talk Sent: Tuesday, April 13, 2004 9:23 AM Subject: Re: passing multiple CF vaules to a _javascript_ variable I've got my code in the first post of this thread. Based on the code you've written, it looks like I would get all the values in one onClick event. I need to generate one value per onClick. Each onClick is within an that holds other query results, so I can't just loop through the stylename variable within one onClick. Am I making any sense? Thanks for your help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How many class files do YOU have?
Brook, Well I was curious about your question so i went ahead and took a look at how many class files we have. We also create cfm files on the fly for new accounts etc. On checking we have 25,759 class files in the cfclasses directory. All the suggestions below are accurate. Be sure to set your template cache as high as is reasonable with the memory you have. Also the jvm settings mentioned are very important. These things should all make a huge difference in your performance. Mark -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 12:25 PM To: CF-Talk Subject: How many class files do YOU have? I repoted to this list awhile ago about really long start up times for one of my apps on the first run. It seems that this problem has been resolved by defragging the HD? The C:\CFusionMX\wwwroot\WEB-INF\cfclasses folder had a lot of fragmented files as well as other areas on the HD. Does that make sense? Anyhow, I have 6,591 class files in my class folder taking up about 80 megs. So, I am curious now how many class files ya'll have on your servers? And another question related to disk usage; what are the guidelines for a paging file and is it needed if you have lots of physical ram? The reason I ask is because I wonder if a fragmented HD, and a page file on that disk might cause problems. I've had some JavaOutOfMemory errors, so I am looking for answers everywhere :) Brook _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Yes, I want to output the stylenames as the html code is generated. Sorry, I added the list after sending the previous code. (Actually, I don't care if I have a list of the stylenames or not; I just want to get one of the style name values from the query into each of the onClick events.) The format of the list is defaulted to commas. Here's the code with the CF list. SELECT * from qa_menu order by menu_sortText
"#q_menu.menu_nonBmarkLink#">"##Ans" Basically, if the href value is an external URL, ignore the rest of the if statement. If the href value is a bookmark link, have the href go to a specific position on the page, (#Ans), and using CSS display the previously hidden content of the style names in the onClick. I've substituted style name values where the js goes, like so: "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">"##Ans" "#q_menu.menu_nonBmarkLink#">< cfelse>"##Ans" I'd really like this to work. I think I could use this code a lot. Thanks again. Joy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web + v5.0
not to mention the freakin thing uses #'s -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 12:34 PM To: CF-Talk Subject: RE: Web + v5.0 oddly enough I hadnt until I checked my mail today, I got a cd today to mario. someone must have gotten ahold of our addresses/titles/etc, and sent this out..i bet we arent the only ones on this list to have gotten their promo cd. I wonder who gave our info away??? tony -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:53 AM To: CF-Talk Subject: OT: Web + v5.0 Has anyone heard of this product: Web + v5.0 -- It is supposed to be easier to use and less expensive than CF. Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX JRun Services on Windows 2000
Thanks again. I had tried the full display name, but I neglected the quotes before. -adam > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 13, 2004 04:04 PM > To: 'CF-Talk' > Subject: RE: CFMX JRun Services on Windows 2000 > > > ok, now how can I get rid of the default 'cfusion' instance. > > When I try "jrunsvc -remove cfusion", it says the specified > > service does nto exist. > > I think the default service name is "Macromedia JRun CFusion Server". > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web + v5.0
oddly enough I hadnt until I checked my mail today, I got a cd today to mario. someone must have gotten ahold of our addresses/titles/etc, and sent this out..i bet we arent the only ones on this list to have gotten their promo cd. I wonder who gave our info away??? tony -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:53 AM To: CF-Talk Subject: OT: Web + v5.0 Has anyone heard of this product: Web + v5.0 -- It is supposed to be easier to use and less expensive than CF. Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
where do you want to loop thru the style name? 1) when creating the html/js with CF/ 2) when the user initiates the js onClick? if 1) above, where & what format is the list of styles? Dick On Apr 13, 2004, at 9:23 AM, Joy Holman wrote: > I've got my code in the first post of this thread. Based on the > > code you've written, it looks like I would get all the values in > > one onClick event. I need to generate one value per onClick. Each > > onClick is within an that holds other query results, so I > > can't just loop through the stylename variable within one > > onClick. Am I making any sense? > > Thanks for your help. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
At 09:35 AM 4/13/2004, you wrote: >In that email, that you are sending to your self, you may also want to add a >few CGI vars to see where and what is calling that cfm page. One time >Google some how found a .cfm page that I had scheduler set to run once a >week and every time Google spidered the site it would run that page. That's a damn fine idea. Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Access 2003 ODBC
> Thanks. That helps, but it's still not clear whether that > means you can or cannot use an Access 2003 with the last > version of the Jet engine. There's no reason to 'upgrade' > to Access 2003, just that someone with Access 2003 installed > on their workstations would probably find it more convenient > to use Access 2003 on the server. There's no need to have any version of Access on the server. If you have the latest version of Jet on your server, it can read Access 2000 and 2003 files, without requiring any additional installation. Jet used to be bundled with MDAC, but it's now available separately (although you'll still want the latest version of MDAC too, typically): http://msdn.microsoft.com/data/downloads/updates/default.aspx#jet Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
I've got my code in the first post of this thread. Based on the code you've written, it looks like I would get all the values in one onClick event. I need to generate one value per onClick. Each onClick is within an that holds other query results, so I can't just loop through the stylename variable within one onClick. Am I making any sense? Thanks for your help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access 2003 ODBC
- Original Message - From: "Samuel R. Neff" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 12, 2004 8:07 PM Subject: RE: Access 2003 ODBC > Access 2000 is the last major release of the Jet engine, so the data portion > of the database, what you're using through CF, is exactly the same for > Access 2000 and Access 2003. There's no point in upgrading for just a data > back-end. > > The Jet team was disbanded soon after Access 2000 was released, most of them > going to the MSDE group. MS is interested in migrating everyone to > MSDE/MSSQL and blindly ignoring the fact that you need a DBA to use these > options. > > HTH, Thanks. That helps, but it's still not clear whether that means you can or cannot use an Access 2003 with the last version of the Jet engine. There's no reason to 'upgrade' to Access 2003, just that someone with Access 2003 installed on their workstations would probably find it more convenient to use Access 2003 on the server. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PDF Report Generation from ColdFusion
People already responded to you. There are many custom tags out there to convert to PDF. I believe the macromedia exchance has html2pdf which will convert a page you output using CF to PDF. John Burns -Original Message- From: Ruben Ghosal [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:58 AM To: CF-Talk Subject: PDF Report Generation from ColdFusion I posted this message earlier. Does anybody know how to create a report in PDF format from an existing ColdFusion report? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfx_getImage error! Don't know what's causing it
>Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.CallComments_attachment'. Table CallComments_attachment doesn't exist in the database? Or it isn't owned by "dbo"? -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:52 AM To: CF-Talk Subject: Re: cfx_getImage error! Don't know what's causing it I changed the code a select statement a bit. I appended 'dbo.' before the table name. DATASOURCE="db" USER="dbUserName" PASSWORD="dbPassword" SQL="select filename FROM dbo.Attachment WHERE id = '#url.id#'" OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil eName#"> This was the error I was getting before I made the above change: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 And this is what I get now: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.CallComments_attachment'. pcbErrorMsg = 97 Notice the difference in the pcbErrorMsg value. Does that tell you anything? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Some sample code would really help here as JS is picky about syntax. That said... I'll assume you're popping open a window ;-) here's some psuedo-code > Then have a _javascript_ function in the HEAD block that takes 2 arguments. So all you're doing is setting the values of the arguments passed to the function with CF vars. Hope that helps Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Joy Holman To: CF-Talk Sent: Tuesday, April 13, 2004 8:44 AM Subject: Re: passing multiple CF vaules to a _javascript_ variable I'm placing the query results of several fields into an HTML list. The href of each generated link includes an onClick event. Because of that, I need to create a _javascript_ variable that holds the values of the style name field from the query. I don't know how to populate the style name variable for each list item. Thanks for your interest and your assistance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Disappearing/reappearing application variables...
Yep, it's a brand new CFMX install, with three separate sites with 3 separate application names. Someone was complaining about a "JRun connection closed" error a couple days ago and I'm beginning to wonder if the server's hanging, then restarting itself, which would then cause my application vars to reset. But when I view the logs, the only log file I can find that says anything about ColdFusion starting/stopping is the server.log, and the only record it has of "ColdFusion started" was 5 days ago when the server was first installed...is this the correct place for checking CFMX service starts/restarts to check my theory, or is there somewhere else I can look? Tyler S _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:13 AM To: CF-Talk Subject: Re: Disappearing/reappearing application variables... Are there any other application.cfm on this server instnace. If so do they all have different application names? -Adam > -Original Message- > From: Tangorre, Michael [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 13, 2004 02:43 PM > To: 'CF-Talk' > Subject: RE: Disappearing/reappearing application variables... > > > Is there any reason application variables would disappear > > before the application timeout set in Application.cfm file? > > If the application timeout in the CF Administrator is less than what it is > set in your cfapplication tag. Did you check the admin setting? > > Mike > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX JRun Services on Windows 2000
> ok, now how can I get rid of the default 'cfusion' instance. > When I try "jrunsvc -remove cfusion", it says the specified > service does nto exist. I think the default service name is "Macromedia JRun CFusion Server". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
PDF Report Generation from ColdFusion
I posted this message earlier. Does anybody know how to create a report in PDF format from an existing ColdFusion report? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfx_getImage error! Don't know what's causing it
Any chance attachment is a reserved keyword? Maybe you should do select [filename] from dbo.[Attachment] where id = '01057870' I don't know if that would make any difference, but I know I've had trouble in the past with using reserved words. John Burns -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:52 AM To: CF-Talk Subject: Re: cfx_getImage error! Don't know what's causing it I changed the code a select statement a bit. I appended 'dbo.' before the table name. DATASOURCE="db" USER="dbUserName" PASSWORD="dbPassword" SQL="select filename FROM dbo.Attachment WHERE id = '#url.id#'" OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil eName#"> This was the error I was getting before I made the above change: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 And this is what I get now: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.CallComments_attachment'. pcbErrorMsg = 97 Notice the difference in the pcbErrorMsg value. Does that tell you anything? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Web + v5.0
Has anyone heard of this product: Web + v5.0 -- It is supposed to be easier to use and less expensive than CF. Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
I changed the code a select statement a bit. I appended 'dbo.' before the table name. DATASOURCE="db" USER="dbUserName" PASSWORD="dbPassword" SQL="select filename FROM dbo.Attachment WHERE id = '#url.id#'" OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil eName#"> This was the error I was getting before I made the above change: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 And this is what I get now: SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.CallComments_attachment'. pcbErrorMsg = 97 Notice the difference in the pcbErrorMsg value. Does that tell you anything? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
I'm placing the query results of several fields into an HTML list. The href of each generated link includes an onClick event. Because of that, I need to create a _javascript_ variable that holds the values of the style name field from the query. I don't know how to populate the style name variable for each list item. Thanks for your interest and your assistance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: flash remoting books
I recommend Tom's book, as well. I worked on the ColdFusion section, so I know it's comprehensive. :) Christian On Apr 12, 2004, at 11:49 AM, Dave Carabetta wrote: > > > >Sorry for the crosspost all . . . > > > > I know that Tom Muck's book "Flash Remoting: The Definitive Guide" has > gotten solid reviews. I looked at it in a bookstore once and it seemed > pretty comprehensive. I just don't do much with remoting, so I can't > give > you any "real world" feedback. > > http://www.amazon.com/exec/obidos/ASIN/059600401X/104-8416979-6521558 > > Regards, > Dave. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
In that email, that you are sending to your self, you may also want to add a few CGI vars to see where and what is calling that cfm page. One time Google some how found a .cfm page that I had scheduler set to run once a week and every time Google spidered the site it would run that page. HTTP_REFERER: #CGI.HTTP_REFERER# HTTP_USER_AGENT: #CGI.HTTP_USER_AGENT# REMOTE_ADDR: #CGI.REMOTE_ADDR# Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:48 AM To: CF-Talk Subject: Re: MX: Scheduler firing off too often Ack, should have said "Linux" instead of "Windows" there. At 08:45 AM 4/13/2004, you wrote: >Hey folks - > >I've got an MX box (Windows) with a oddly behaving scheduler. I've got a >single task in the list, that fires off once every three minutes. I've got >the task aborting early, but not before it sends me a quickie time-stamped >email. Every once in a while, I'll get two or three emails with the same >time (sans seconds) on it. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
yes it does. I've double checked it. I don't have the source for the dll (.cpp file). I was using the getImage.dll on another project and thought I can reuse it. Tell me, does the .cpp file specify the dsn name? Because if it does then I'll get this error because the dsn name used in that project is different from the dsn name I'm using on this project. Do you have the .cpp files for this dll? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX JRun Services on Windows 2000
ok, now how can I get rid of the default 'cfusion' instance. When I try "jrunsvc -remove cfusion", it says the specified service does nto exist. -adam > -Original Message- > From: Adrocknaphobia [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 13, 2004 03:06 PM > To: 'CF-Talk' > Subject: SOLVED: CFMX JRun Services on Windows 2000 > > Thanks, that did the trick. > -adam > > > -Original Message- > > From: Dave Watts [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, April 13, 2004 02:56 PM > > To: 'CF-Talk' > > Subject: RE: CFMX JRun Services on Windows 2000 > > > > > Is there anyway to add these instance as services like the > > > default cfusion one that is created during the initial > > > install of the server? > > > > You need to register them as services by running jrunsvc.exe from the > > command line with the appropriate parameters. > > > > jrunsvc -install "cfusion2" "cfusion2" (or something like that). > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > phone: 202-797-5496 > > fax: 202-797-5444 > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getImage error! Don't know what's causing it
this is what is dumped in the Stack Trace: coldfusion.tagext.DerivedNativeCFXException: Error occurred in tag CFX_GETIMAGE at coldfusion.tagext.NativeCfx.processRequest(Native Method) at coldfusion.tagext.CfxTag.doStartTag(CfxTag.java:110) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at cfviewattachment2ecfm50240.runPage(E:\inetpub\wwwroot\tempDocumentsFolder\viewattachment.cfm:8) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfx_getImage error! Don't know what's causing it
>[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. This error says the table "Attachment" doesn't exist in the database. Does it exist in your DATASOURCE="db"? -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:33 AM To: CF-Talk Subject: cfx_getImage error! Don't know what's causing it Hello Everybody, I'm really hoping that someone will help me. A lot of people have used the cfx_getImage tag to open up office documents (word,excel, blah). I thought I'll use it to do the same. The documents are stored on the database table as binary objects. I registered the cfx tag in the administrator. I'm calling it on the page like this: select * from Attachment where id = '#url.id#' DATASOURCE="db" USER="dbUserName" PASSWORD="dbPassword" SQL="select filename FROM Attachment WHERE id = '#url.id#'" OUTPUT="E:\inetpub\wwwroot\tempDocumentsFolder\#getAttachmentDetails.Fil eName#"> I get this error message: The error occurred in E:\inetpub\wwwroot\viewattachment.cfm: line 8 6 : 7 : DATASOURCE="db" 8 : USER="dbUserName" 9 : PASSWORD="dbPassword" 10 : SQL="select filename FROM Attachment WHERE id = '#url.id#'" (USER="dbUserName" is in bold) SQL:select filename FROM Attachment WHERE id = '01057870' SQLExecDirect Failed szSqlState = S0002 pfNativeError = 208 szErrorMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Attachment'. pcbErrorMsg = 93 Does anybody know why I'm getting this error? I would really appreciate your help Regards, cfcoder __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Stay in Domain...?
Well, the easiest way would be to just make all of your links relative. Then, no matter what name they come in on, everything works. If you have to provide full domain names, just use cgi.http_host to get the current domain name/host that the user came in on. John Burns -Original Message- From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:09 AM To: CF-Talk Subject: Stay in Domain...? Ok I have one for you... I have this site that I am working on... http://65.218.34.47 and it is going to be somewhat template based for our users. Basically we have Division leaders that will get one of these sites to help with recruiting new people. Each site will be personalized for the Division things like menus, schedules, testimonials and a few other things will be dynamic information. What I would like to do also is have it to where if the recruiting division has their own domain name like www.recruitme.com and I have the domain pointing to our servers, how can I make the site stay in the domain when the main site is www.ugaonline.com . Does this make sense?... We will have about 130 recruiting divisions that will all have their own domain name. But we have only one website. I would like anyone with the domain name to stay in their domain when someone is referred from their site instead of being redirected like I have done in the past. Is there a way to do this... I was planning on reading the host header and using ColdFusion to determine the incoming site and display the recruiting districts information dynamically using the domain name as unique variable. Any ideas... thanks.. Neal Bailey Internet Marketing Manager E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web Services and CFMX6.1 -- Why doesn't it work?
Ryan -- yes, I do have that vdir on both production and test... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web Services and CFMX6.1 -- Why doesn't it work?
Thanks for all your help, guys. I tried the snippet on my production server, and sure enough, it runs just fine. So I guess it is my server config. What could it be, though? I don't understand what inside CF could cause this, when all evidence points to the file being exactly where it should be. The Mappings on both production and test are identical... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]