RE: BLACKSTONE: Software Development Times Article
It has to do with Mach-II blowing all other frameworks away. That is, except Java Server Faces and Struts. Glad you cleared that up. ;) -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE: Software Development Times Article
Excuse me? MM is providing a handful of pre-built gateways to begin with, much less having a consistent interface provided by MM which allows others who are Java knowledgeable to create, package and distribute additional gateways. At which point, yes, it is a very valid argument. The end result will be that developers who are not Java knowledgeable will be able to do things which would otherwise require extensive knowledge of Java. My response was in relation to writing an event gateway; not using an existing one. CF does not make it easier or harder to write an event gateway since you can only write an event gateway in CF. Further, writing an event gateway requires knowledge of Java. Thus, you argument is not valid. If you are going to argue against me then you have to stay in the context of the thread of positions don't make sense. Didn't realize it was in that context... but okay -- since I read the other one where you quoted the context you were speaking within specifically -- the _minor_ revision then is -- if you don't like the way the pre-built gateways work, buy or use one someone else has built, which is still a lot easier than building one yourself if you don't have lots of Java expertise. The fact that CF provides a consistent framework for that means that it will be easier for people who have Java expertise to provide them to people who don't. Even if it's only a linguistic thing, the fact that people are talking about the CF native feature will mean they will be more accessible in all likelyhood - there will be more information about them, etc and likely more people will be looking for them (and on the other side of the supply-demand system building) once it's a part of the common language of native CF features. cfset mystruct.mykey = 0 I use the CF -- CF uses the Java object. This is not the same thing as me using the underlying Java object. What about cfset mystruct.put(foo, bar)? I could, but I don't. So... that doesn't change my statement any. Probably. But very few (if any) are using their own application schemes instead of cfapplication. What does that have to do with cflogin or frameworks? You'd made the comment that MM is historically not good at creating frameworks for people to use in comparison to the CF community. I was just pointing out a notable exception. context, context. :) s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)
I am new to JMS, so be gentle :) Wouldn't it be practical to use a cfmessage tag to set up a listener... something like: cfmessage mode=SetListner MessageType=queue or topic MessageName= QueueName or TopicName Component=path to CFC Method=Function to invoke / Couldn't this be used to implementsomething like: http://www.devx.com/Java/Article/20903/0/page/3 See the link to listing 1 (asynchronous reader) at the bottom of the page. Where: 1) the cfmessage tag sets up the listener and denotes a cfc. to be invoked when the listener fires 2) the CFC method receives the message in the argument named its input parameter processes the message as desired. Certainly there are a lot more details, but this would be the overall approach Practical? Dick On Aug 18, 2004, at 10:11 AM, Matt Liotta wrote: 3) your thoughts on the tradeoffs of a cfmessage tag vs an event gateway One major tradeoff is the ability for CFML to be invoked based on a message. With a cfmessage tag you still need the CFM or CFC making use of it to execute. An event gateway or something of similar design would invoke CFML based on some 3rd party input. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE: Software Development Times Article
At 01:46 PM 8/18/2004, you wrote: It has to do with Mach-II blowing all other frameworks away. That is, except Java Server Faces and Struts. Glad you cleared that up. ;) I'm sorry...I just can't help myself. As I was typing the above response, I could see a red-faced FuseBoxer knee-deep in a nested circuit just blowing a gasket at the insinuation that Struts or JSF could be mentioned in the same breath as FuseBox. I can't begin to imagine what the OnTap, CF/MVC and Tapestry camps are thinking. Cheers!:-) -- Alex -Matt -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:174866This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=808.728.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbusiness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonations and Support] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL date/time issues...
SELECT TO_CHAR(t.startdate,'hh24:mi:ss') AS starttime, TO_CHAR(t.finishdate,'hh24:mi:ss') AS finishtime, LPAD(taskid,5), startdate, finishdate FROM TASK t WHERE TO_DATE('08/21/2004','mm/dd/') = TRUNC(t.startdate) AND TO_DATE('08/21/2004','mm/dd/') = TRUNC(t.finishdate) AND TO_CHAR(TO_DATE('07:00:00','hh:mi:ss'),'hh24:mi:ss') = TO_CHAR(t.startdate,'hh24:mi:ss') AND TO_CHAR(TO_DATE('07:30:00','hh:mi:ss'),'hh24:mi:ss') = TO_CHAR(t.finishdate,'hh24:mi:ss') nevermind I got it On Wed, 18 Aug 2004 13:45:54 -0400, Greg Morphis [EMAIL PROTECTED] wrote: Anyone have any idea how to go about doing this? This is irritating me.. it seems like it should work but isnt. I have a query.. the base query SELECT TO_CHAR(t.startdate,'hh24:mi:ss') AS starttime, TO_CHAR(t.finishdate,'hh24:mi:ss') AS finishtime, taskid, startdate, finishdate FROM TASK t returns STARTTIMEFINISHTIMELPAD(TASKID,5)STARTDATE FINISHDATE 07:00:00 18:00:00309D28/6/2004 7:00:00 AM8/10/2004 6:00:00 PM 09:00:00 14:00:0030A988/1/2004 9:00:00 AM8/5/2004 2:00:00 PM 09:00:00 12:30:0030AB78/2/2004 9:00:00 AM8/5/2004 12:30:00 PM 10:00:00 18:00:0030BEB8/9/2004 10:00:00 AM 8/10/2004 6:00:00 PM 07:00:00 08:00:006E61F8/21/2004 7:00:00 AM 8/22/2004 8:00:00 AM I shrunk the taskid field down to hopefully make it more legible.. What I'm trying to do is pass a date a time return rows that fall within that date/time.. it HAS to check the date and time seperately.. So tacking on the date part... no problem SELECT TO_CHAR(t.startdate,'hh24:mi:ss') AS starttime, TO_CHAR(t.finishdate,'hh24:mi:ss') AS finishtime, LPAD(taskid,5), startdate, finishdate FROM TASK t WHERE TO_DATE('08/21/2004','mm/dd/') = TRUNC(t.startdate) AND TO_DATE('08/21/2004','mm/dd/') = TRUNC(t.finishdate) this returns 1 row as it should.. 07:00:00 08:00:006E61F8/21/2004 7:00:00 AM 8/22/2004 8:00:00 AM but now I have to check a time to make sure it doesnt fall within that range.. to me it seems AND TO_CHAR(TO_DATE('07:00:00','hh:mi:ss'),'hh24:mi:ss') = t.starttime AND TO_CHAR(TO_DATE('07:30:00','hh:mi:ss'),'hh24:mi:ss') = t.finishtime should work.. this returns 07:00:00 and 07:30:00 and it should compare to starttime and finishtime.. but it's not working. Can someone offer assistance? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE: Software Development Times Article
Nothing wrong with Fusebox. Nothing wrong with any framework or methodology... Whatever works for ya. Michael T. Tangorre I'm sorry...I just can't help myself. As I was typing the above response, I could see a red-faced FuseBoxer knee-deep in a nested circuit just blowing a gasket at the insinuation that Struts or JSF could be mentioned in the same breath as FuseBox. I can't begin to imagine what the OnTap, CF/MVC and Tapestry camps are thinking. Cheers!:-) -- Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)
That would mean the app server would have to poll the message queue and then invoke a CFC as needed, which could certainly work. However, then you would still need some other application to respond to 3rd party events and put them on the queue. At that point, if seems easier just to have a gateway that invokes a CFC directly. If you need it asynchronous, then that CFC could then put some message on the queue. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dick Applebaum Sent: Wednesday, August 18, 2004 1:52 PM To: CF-Talk Subject: Re: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article) I am new to JMS, so be gentle :) Wouldn't it be practical to use a cfmessage tag to set up a listener... something like: cfmessage mode=SetListner MessageType=queue or topic MessageName= QueueName or TopicName Component=path to CFC Method=Function to invoke / Couldn't this be used to implementsomething like: http://www.devx.com/Java/Article/20903/0/page/3 See the link to listing 1 (asynchronous reader) at the bottom of the page. Where: 1) the cfmessage tag sets up the listener and denotes a cfc. to be invoked when the listener fires 2) the CFC method receives the message in the argument named its input parameter processes the message as desired. Certainly there are a lot more details, but this would be the overall approach Practical? Dick On Aug 18, 2004, at 10:11 AM, Matt Liotta wrote: 3) your thoughts on the tradeoffs of a cfmessage tag vs an event gateway One major tradeoff is the ability for CFML to be invoked based on a message. With a cfmessage tag you still need the CFM or CFC making use of it to execute. An event gateway or something of similar design would invoke CFML based on some 3rd party input. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE: Software Development Times Article
Didn't realize it was in that context... but okay -- since I read the other one where you quoted the context you were speaking within specifically -- the _minor_ revision then is -- if you don't like the way the pre-built gateways work, buy or use one someone else has built, which is still a lot easier than building one yourself if you don't have lots of Java expertise. The fact that CF provides a consistent framework for that means that it will be easier for people who have Java expertise to provide them to people who don't. Even if it's only a linguistic thing, the fact that people are talking about the CF native feature will mean they will be more accessible in all likelyhood - there will be more information about them, etc and likely more people will be looking for them (and on the other side of the supply-demand system building) once it's a part of the common language of native CF features. That is a fair argument, but I think it is too early to tell whether the event gateway will provide this consistency. Again, the framework it provides could be great, but it could also suck. That is the great thing about community frameworks; if they suck you can avoid them and use something that doesn't. If the framework is built-in then you have little choice to use something else. I could, but I don't. So... that doesn't change my statement any. My point is that the following are all the same: cfset mystruct.foo = bar cfset mystruct[foo] = bar cfset mystruct.put(foo, bar) The first two lines are CFML syntax, while the last line is Java syntax. They all work because a struct is in fact a Java object. Therefore, any of those lines above are uses of a Java object. You'd made the comment that MM is historically not good at creating frameworks for people to use in comparison to the CF community. I was just pointing out a notable exception. I don't consider cfapplication to be a framework. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFSELECT selected parameter
Sorry if this has been discussed but I'm finding that in the following CFSELECT code, the selected=8 parameter has no bearing on the default pulldown that's selected when the page is visited.It appears to basically be broken and a useless parameter.Have others seen this? Or is this a pilot error? cfselect name=selectMon selected=8 required=yes message=Please select a month for Call Date option value=1Jan/option option value=2Feb/option option value=3Mar/option option value=4Apr/option option value=5May/option option value=6Jun/option option value=7Jul/option option value=8Aug/option option value=9Sep/option option value=10Oct/option option value=11Nov/option option value=12Dec/option /cfselect [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLACKSTONE: Software Development Times Article
Why? They're all fine frameworks. No gasket-blowing in sight (unless one considers your random irrational generalizations as blowing a gasket). - Original Message - From: Alexander Sherwood [EMAIL PROTECTED] Date: Wed, 18 Aug 2004 13:53:19 -0400 Subject: RE: BLACKSTONE: Software Development Times Article To: CF-Talk [EMAIL PROTECTED] I'm sorry...I just can't help myself. As I was typing the above response, I could see a red-faced FuseBoxer knee-deep in a nested circuit just blowing a gasket at the insinuation that Struts or JSF could be mentioned in the same breath as FuseBox. I can't begin to imagine what the OnTap, CF/MVC and Tapestry camps are thinking. Cheers!:-) -- Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Access SQL Question
I have a table that I transferred from Access to SQL and had a field setup as auto number. Now I am getting an error message when I try to submit new info to the table in SQL. Here's the error: ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id', table 'mydatabase.user.tblMemo'; column does not allow nulls. INSERT fails. The error occurred while processing an element with a general identifier of (CFINSERT), occupying document position (6:1) to (11:28). Here's the CFInsert code: cfinsert dbname=mydbname username=myusername password=mypassword datasource=mydsn tablename=tblMemo formfields=subject, memo Any help appreciated. Thank you, Donna French [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Need more info
I know why you are getting the results you are getting but I do not have enough information regarding your data to provide a solution yet. If you add t.paidthru in your group by clause then it will get multiple entries (a cross-join), but if you leave it out you will get invalid group by errors. Questions that I have for you are: What fields do you need from the transaction table? Will the paidthru field always be the latest date? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFSELECT selected parameter
I don't use CFSELECT, but when using a regular HTML Select box, the selected keyword would go on the option tag: select name=SelectBox option value=1 selected Option 1 is selected - Original Message - From: CF Coder2 To: CF-Talk Sent: Wednesday, August 18, 2004 1:14 PM Subject: CFSELECT selected parameter Sorry if this has been discussed but I'm finding that in the following CFSELECT code, the selected=8 parameter has no bearing on the default pulldown that's selected when the page is visited.It appears to basically be broken and a useless parameter.Have others seen this? Or is this a pilot error? cfselect name=selectMon selected=8 required=yes message=Please select a month for Call Date option value=1Jan/option option value=2Feb/option option value=3Mar/option option value=4Apr/option option value=5May/option option value=6Jun/option option value=7Jul/option option value=8Aug/option option value=9Sep/option option value=10Oct/option option value=11Nov/option option value=12Dec/option /cfselect [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE: Software Development Times Article
Hmmm...the answer to that is unclear, and depends on your perspective and what features you need most. If you rely heavily on Flash integration, then my guess is the ColdFusion will always be a better choice than BlueDragon. On the other hand, if you're looking for ASP.NET integration (for example), then BlueDragon is the obvious (only) choice. As for lagging big time in the compatibility dept, I'll only point out the Blackstone is finally delivering in 2005 features that were pioneered by BlueDragon and have been in use by our customers since 2002 (standard J2EE WAR/EAR deployment, precompiled CFML templates for source-less deployment, CFIMAGE tag, etc.). Other more recent features, such as CFC serialization, are supported by BlueDragon 6.1 now, but won't be in Blackstone until 2005. So, again, the question of who is leading and who is lagging isn't as clear-cut as you might think. The feature sets of ColdFusion and BlueDragon will never be exactly the same, so the choice will come down to: which features do you need the most? Repeat slowly: choice is good...choice is good...choice is good... Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 1:45 PM To: CF-Talk Subject: RE: BLACKSTONE: Software Development Times Article Hmm, that's an interesting point on flash generation... Did New Atlanta just get left behind big time in the compatability dept? -Original Message- From:Matt Liotta Date:8/18/04 8:59 am To:CF-Talk Subj:RE: BLACKSTONE: Software Development Times Article I don't know what to do with you Tony. You keep posting comments with no basis in facts that don't make much sense anyway. I'd really like to avoid addressing them or falling prey to my desire to respond negatively. Is that what you want? Is there some point to your comments? For the rest of you reading this, I have no financial interest in the success or failure of BlueDragon. Although, I would like to see them succeed. I don't know whether New Atlanta will implement the event gateway. I don't know whether they can. I certainly think they should implement it if for no other reason then to be compatible with ColdFusion. We all want that right? Personally, if I were to guess which functionality would be hard to implement in BlueDragon I wouldn't guess something like the event gateway. I would guess something that produces Flash on the fly. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Access SQL Question
SQL Server manages auto-incremented fields differently than Access does. I believe you have to go into SQL Server Enterprise Manager and modify that field in the table so that SQL Server knows it is an autonumber field. - Original Message - From: Donna French To: CF-Talk Sent: Wednesday, August 18, 2004 1:17 PM Subject: Access SQL Question I have a table that I transferred from Access to SQL and had a field setup as auto number. Now I am getting an error message when I try to submit new info to the table in SQL. Here's the error: ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id', table 'mydatabase.user.tblMemo'; column does not allow nulls. INSERT fails. The error occurred while processing an element with a general identifier of (CFINSERT), occupying document position (6:1) to (11:28). Here's the CFInsert code: cfinsert dbname=mydbname username=myusername password=mypassword datasource=mydsn tablename=tblMemo formfields=subject, memo Any help appreciated. Thank you, Donna French [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blackstone summary
On Aug 18, 2004, at 10:12 AM, Matt Liotta wrote: This brings me to the event gateway, which is supposed to liberate CFML from HTTP. Sure there are tons of reasons why you would want to have a CFML-based web application integrate with protocols other than HTTP. I have integrated CFML-based web applications in the past with a variety of protocols without the support of an event gateway. Certainly it would have been easier and more elegant with an event gateway, but I am not so sure the event gateway is the missing piece. To me, it seems the missing piece is the ability to invoke CFML from other sources than an HTTP request. While the event gateway will provide that, it seems it will also provide more than that. Ahhh... I understand what you are saying -- you want ti invoke a CFM or CFC directly. from outside CFMX without theindirection/overhead of listening for and triggering an event. That's certainly valid! I can think of several places where this approach would be superior. But that doesn't negate the value of an event gateway. That said, it should be possible to implement Both ways of invoking a CFC/CFM--- Isn't what you want an API that provides the same interface that (part of) the event gateway uses to invoke the CFC? If so, I suspect that it would be relatively easy (from a technical standpoint) for Macromedia to provide that API. Whether that is in Macromedia's best interest is a consideration. Because what you are asking for is the ability to incorporate CFML Classes (CFCs, CFMs) into a Java (or other) program. Does that mean thatyour package includes: 1) Your Java app 2) Your CFMs CFCs 3) The CFMX/Blackstone Redistro jar I can see this as being viable as long as the manufacturer (Macromedia in this case) can make acceptable income on 3. Do we really need a whole bunch of infrastructure to allow invocation of CFML from other sources? I don't think we do. The reason I feel that way is because I think it is far too easy for the community and 3rd party companies to provide various protocol adapters. With a simple Java API for the invocation of CFML it would be quite easy for someone with Java experience to write these adapters. Whether Macromedia or someone else supplies event gateways or protocol adapters is of little importance to the average CFML person. In either case, someone with Java expertise must create them and your average CFML developer will just make use of them. True, but... There are are a series of events that occur within the CFMX system, itself. Logically, it seems that it would be easier to process these with an enternal event gateway, rather that attempt to do this from outside the system. The set of applications that monitor things internal to CFMX and application activity come to mind. Consider that you you could write a fantastic performance monitoring/tuning/debugging tool. Certainly you could that external to CFMX, but it would likely be easier with an event gateway (where you could intercept events without consuming them). And, yes, you would need to write some Java code to do this ... unless we have something like cfmessage that allowsus to setup the listener - processor linkage. The real difference is constraints placed on the implementation by the event gateway. We have already heard that the event gateway will invoke CFC methods. What if we don't want CFC methods to be invoked? Will we have to write CFCs that then in turn call CFMs? What if the event gateway framework makes assumptions that aren't true for all protocols thus making it hard or impossible to implement some other protocol Macromedia didn't think about? All of these problems go away if there is a simply Java API for the invocation of CFML. Heck, Macromedia can even supply a bunch of protocol adapters if they want; they just don't need to create a framework and force it on others. Not only that, but if Macromedia didn't spend time on building stuff the community is perfectly capable of doing they might have time to work on other things the community can't deliver. Let's see if we can convince them to do both! Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blackstone summary
To state the obvious, I would urge caution on pre-judging Blackstone before it's released.What has been talked about is just the surface of this release. Regards, Damon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFSELECT selected parameter
This is from the documentation attributes: selected(Optional) -A list of option values to preselect in the selection list. This attribute applies only if list items are generated from a query. The cfform preservedata attribute value can override this value. - Original Message - From: CF Coder2 [EMAIL PROTECTED] Date: Wed, 18 Aug 2004 14:14:33 -0400 Subject: CFSELECT selected parameter To: CF-Talk [EMAIL PROTECTED] Sorry if this has been discussed but I'm finding that in the following CFSELECT code, the selected=8 parameter has no bearing on the default pulldown that's selected when the page is visited.It appears to basically be broken and a useless parameter.Have others seen this? Or is this a pilot error? cfselect name=selectMon selected=8 required=yes message=Please select a month for Call Date option value=1Jan/option option value=2Feb/option option value=3Mar/option option value=4Apr/option option value=5May/option option value=6Jun/option option value=7Jul/option option value=8Aug/option option value=9Sep/option option value=10Oct/option option value=11Nov/option option value=12Dec/option /cfselect [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Blackstone summary
To further that, I have no inside knowledge about Blackstone and my perspective is completely based on public information. While all this is purely speculation at this point it should at least give something for Macromedia to think about, which in the end should benefit us all. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] [EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 2:43 PM To: CF-Talk Subject: Re: Blackstone summary To state the obvious, I would urge caution on pre-judging Blackstone before it's released.What has been talked about is just the surface of this release. Regards, Damon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFSELECT selected parameter
I read 3 different books on CFSELECT and none of them had this little tid-bit about it applying only when items are generated from a query. Thanks for the info Qasim!!That is the answer I needed. cfcoder2 This is from the documentation attributes: selected(Optional) -A list of option values to preselect in the selection list. This attribute applies only if list items are generated from a query. The cfform preservedata attribute value can override this value. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE: Software Development Times Article
That is a fair argument, but I think it is too early to tell whether the event gateway will provide this consistency. In that case, isn't it too early to be having this discussion? Or at least, to expect it to be a meaningful discussion? Again, the framework it provides could be great, but it could also suck. That is the great thing about community frameworks; if they suck you can avoid them and use something that doesn't. If the framework is built-in then you have little choice to use something else. Just because something is built-in doesn't mean you have to use it. There are plenty of CFMX applications using something other than CFLOGIN and IsUserInRole for authentication and authorization, just as there were plenty of CF 5 applications that didn't use CFAUTHENTICATE, etc. 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] [Donations and Support]
Re: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)
I wasn't clear: I didn't mean to replace the event gateway with a cfmessage tag. Rather, use a cf tag construct to setup a listener- processor relationship that the event gateway uses. This would not change the way the event gateway interface JMS. It just allow the user define the interface of JMS to his app without requiring knowledge of Java, Dick On Aug 18, 2004, at 10:59 AM, Matt Liotta wrote: That would mean the app server would have to poll the message queue and then invoke a CFC as needed, which could certainly work. However, then you would still need some other application to respond to 3rd party events and put them on the queue. At that point, if seems easier just to have a gateway that invokes a CFC directly. If you need it asynchronous, then that CFC could then put some message on the queue. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dick Applebaum Sent: Wednesday, August 18, 2004 1:52 PM To: CF-Talk Subject: Re: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article) I am new to JMS, so be gentle :) Wouldn't it be practical to use a cfmessage tag to set up a listener... something like: cfmessage mode=SetListner MessageType=queue or topic MessageName= QueueName or TopicName Component=path to CFC Method=Function to invoke / Couldn't this be used to implement something like: http://www.devx.com/Java/Article/20903/0/page/3 See the link to listing 1 (asynchronous reader) at the bottom of the page. Where: 1) the cfmessage tag sets up the listener and denotes a cfc. to be invoked when the listener fires 2) the CFC method receives the message in the argument named its input parameter processes the message as desired. Certainly there are a lot more details, but this would be the overall approach Practical? Dick On Aug 18, 2004, at 10:11 AM, Matt Liotta wrote: 3) your thoughts on the tradeoffs of a cfmessage tag vs an event gateway One major tradeoff is the ability for CFML to be invoked based on a message. With a cfmessage tag you still need the CFM or CFC making use of it to execute. An event gateway or something of similar design would invoke CFML based on some 3rd party input. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE: Software Development Times Article
In that case, isn't it too early to be having this discussion? Or at least, to expect it to be a meaningful discussion? Not at all! This is the perfect time to air concerns regarding Blackstone as it allows Macromedia time to address them before the product ships if they choose to. They may have already addressed the issue or they may not have thought of it. Better to be safe and discuss it now. Just because something is built-in doesn't mean you have to use it. There are plenty of CFMX applications using something other than CFLOGIN and IsUserInRole for authentication and authorization, just as there were plenty of CF 5 applications that didn't use CFAUTHENTICATE, etc. Maybe, but it also might not be possible to invoke CFC's from alternate protocols without using the event gateway thus requiring you to use it. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLACKSTONE: Software Development Times Article
NDA reminder here for anyone under NDA. Thanks In that case, isn't it too early to be having this discussion? Or at Not at all! This is the perfect time to air concerns regarding Blackstone as [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blackstone summary
On Aug 18, 2004, at 11:43 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: To state the obvious, I would urge caution on pre-judging Blackstone before it's released. What has been talked about is just the surface of this release. Well, the autumnal equinox is Sept 22-23, so Fall 2004 is coming soon... That's when the Blackstone beta is supposed to hit -- maybe a public beta :) Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Memory Issues
I have read articles much like this before.With the other log I am currently outputting, I am using JVMSTAT right now to watch garbage collection and see if I see any similarities.Is there anything else you or someone else knows of that I should be looking for??? -Original Message- From: Peter Farrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 10:44 AM To: CF-Talk Subject: Re: Memory Issues Check this out: http://www-106.ibm.com/developerworks/java/library/j-garbage-collection. html Are you running JRUN with Updater 3? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Query problem
I know why you are getting the results you are getting but I do not have enough information regarding your data to provide a solution yet. If you add t.paidthru in your group by clause then it will get multiple entries (a cross-join), but if you leave it out you will get invalid group by errors. Questions that I have for you are: What fields do you need from the transaction table? Will the paidthru field always be the latest date? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Need more info
Hi Marc, >From the transaction table, I need the the most recent (highest number) transactionID, the paidThru field (which may not always be the latest date, see example snip in previous message), and if you need the memberID (which corresponds to the memberID in the membershipList table). Thanks for your help with this. Mark _ From: Marc Lowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 2:36 PM To: CF-Talk Subject: Need more info I know why you are getting the results you are getting but I do not have enough information regarding your data to provide a solution yet. If you add t.paidthru in your group by clause then it will get multiple entries (a cross-join), but if you leave it out you will get invalid group by errors. Questions that I have for you are: What fields do you need from the transaction table? Will the paidthru field always be the latest date? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOLVED: Re: Log file reader
Thanks for everyone's help on this.With some intense googling and some off-list help, I have found the following to be exactly what I was looking for.With some tweaks, it is going to be wicked sweet! http://tutorial34.easycfm.com/ Ray http://www.crystalvision.org At 01:45 PM 8/18/2004, you wrote: Has anyone ever used/seen/have/etc a script that can read and parse IIS log files? Not exactly this, but there is a tag perfect for parsing, see CF_REExtract here: http://www.cftagstore.com/tags/cfreextract.cfm -- ___ REUSE CODE! Use custom tags; See 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] [Donations and Support]
Re: SOLVED: Re: Log file reader
Ray That looks pretty good. My only comment is: if you have large log files, you may not be able to read them into a variable with cffile. If that is the case, you could easily implement a line reader with cfobject That's what I had to do (with help) to read my iTunes song library. This was discussed in several recent threads. If you need the routine, let me know I will repost it. Dick On Aug 18, 2004, at 12:09 PM, Ray Champagne wrote: Thanks for everyone's help on this. With some intense googling and some off-list help, I have found the following to be exactly what I was looking for. With some tweaks, it is going to be wicked sweet! http://tutorial34.easycfm.com/ Ray http://www.crystalvision.org At 01:45 PM 8/18/2004, you wrote: Has anyone ever used/seen/have/etc a script that can read and parse IIS log files? Not exactly this, but there is a tag perfect for parsing, see CF_REExtract here: http://www.cftagstore.com/tags/cfreextract.cfm -- ___ REUSE CODE! Use custom tags; See 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] [Donations and Support]
RE: Memory Issues
Peter,the Old Generation garbage collection was over 500mb.I have a screen shot and logs with a stack trace dump, but I don't know what to do from here.Will you take a look or can you tell me who can help??? As soon as I restart the service, via command prompt right now so that I can watch gc, the memory immediately explodes again.But These logs and gc graph do show a complete lockup. Christian -Original Message- From: Peter Farrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 10:44 AM To: CF-Talk Subject: Re: Memory Issues Check this out: http://www-106.ibm.com/developerworks/java/library/j-garbage-collection. html Are you running JRUN with Updater 3? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE: Software Development Times Article
You are missing the context of the thread though. Maybe I am. I don't think so, but it's always possible. :) This thread has been very long, and, as most mailing list conversations go, it's covered quite a bit of territory. The original statement was as follows. Which itself was a reply to previous message. As you can see, the poster suggested that a new gateway could be written, so yes it does indeed require knowledge of Java. Since this particular use can is not made easier by CF and requires knowledge of Java then the argument that CF makes it easier is not valid. I disagree. I'm sure ColdFusion (the platform) will provide an infrastructure which makes developing gateways relatively easy. Further, as I stated in my previous post, I think it provides ColdFusion developers, gateway developers, and the ColdFusion community with a common interface and language for describing it. Now, as to your argument as a whole, I don't think it's a mistake to say you've spent a good deal of your time in this thread arguing that ColdFusion gateways offer very little. You've argued that very few applications built in ColdFusion will have a use for gateways because very few J2EE applications utilize JMS. Though I agree that a small percentage of applications will use them, I think most developers will use gateways in their applications at some point. By way of example, a relatively small percentage of my applications use COM interoperability, Web services, or even the cfdirectory tag. Nevertheless, I find those features indispensable. You've also stated that you don't believe the built in gateways will be enough: What is the likelihood of the built-in gateways doing everything you need? In my previous message, I stated that I think the gateways already announced sound like they'll suffice for most of what I've already dreamed up. I hope to be proven wrong because that means I will have found new uses for gateways. :) All in all, you've been arguing that you can already build gateway-like interfaces which invoke ColdFusion pages (ostensibly using Java or another lower level language to detect the event and invoke a ColdFusion page via HTTP?). For these reasons, you've implied (strongly) that gateways are a waste of Macromedia's resources. Do you still think I'm missing the context? -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOLVED: Re: Log file reader
I remember your posts back a few weeks ago discussing this, but I didn't have any reason to keep up with the thread, as I have never used cfobject, but right now things are slow and I am tackling things that have been on the back burner here (hence this low-priority project), so if you don't mind posting again, I could delve into the cfobject tag and expand knowledge.The time is perfect, and knowledge is power! If you just have the name of the thread, I can check the archives, too. Thanks, Ray At 03:23 PM 8/18/2004, you wrote: Ray That looks pretty good. My only comment is: if you have large log files, you may not be able to read them into a variable with cffile. If that is the case, you could easily implement a line reader with cfobject That's what I had to do (with help) to read my iTunes song library. This was discussed in several recent threads. If you need the routine, let me know I will repost it. Dick On Aug 18, 2004, at 12:09 PM, Ray Champagne wrote: Thanks for everyone's help on this.With some intense googling and some off-list help, I have found the following to be exactly what I was looking for.With some tweaks, it is going to be wicked sweet! http://tutorial34.easycfm.com/ Ray http://www.crystalvision.org At 01:45 PM 8/18/2004, you wrote: Has anyone ever used/seen/have/etc a script that can read and parse IIS log files? Not exactly this, but there is a tag perfect for parsing, see CF_REExtract here: http://www.cftagstore.com/tags/cfreextract.cfm -- ___ REUSE CODE! Use custom tags; See 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] [Donations and Support]
Re: SOLVED: Re: Log file reader
Ray, here's the line reader that Joe Rinehart suggested (with a slight mod). Enjoy! Dick Hey Joe Your No Class Reader Works Great! much faster than the other! (almost as fast as a cffile read of the entire file). I simplified the EOF test so I could use a While loop. Thanks Dick Here's the revised code: cfsetting enableCFOutputOnly=yes / cfset lineCount = 0 / cfset timer = GetTickCount() / cfscript filename = /Users/Richard/Music/iTunes/iTunes Music Library.xml; fileReader = createObject(java, java.io.FileReader); fileReader = fileReader.init(filename); lineReader = createObject(java,java.io.LineNumberReader); lineReader = lineReader.init(fileReader); thisLine = true; while (isDefined(thisLine)) { thisLine = lineReader.readLine(); lineCount = LineCount + 1; // do any processing of the line here } /cfscript cfoutput brcount = #lineCount# | #GetTickCount() - timer# /cfoutput cfsetting enableCFOutputOnly=no / I always forget to kill blank lines on this sort of thing -- very important On Jun 16, 2004, at 6:28 AM, Joe Rinehart wrote: Hey Dick, I've done a similar thing, but didn't create the external CFBufferedReader class. Do you see any reason why the following wouldn't provide the same? cfscript filename = c:\cfusionmx\wwwroot\lineNumberReader.cfm; fileReader = createObject(java, java.io.FileReader); fileReader = fileReader.init(filename); lineReader = createObject(java,java.io.LineNumberReader); lineReader = lineReader.init(fileReader); /cfscript cfset eof = false cfloop condition=not eof cfset thisLine = lineReader.readLine() cfif not isDefined(thisLine) cfset eof = true cfelse cfoutput#htmlEditFormat(thisLine)#br/cfoutput /cfif /cfloop (when lineReader instance hits the end of the file, readLine() returns a result that causes thisLine to become undefined in the eyes of CF) -joe _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Memory Issues
Christian Watt wrote: Peter,the Old Generation garbage collection was over 500mb.I have a screen shot and logs with a stack trace dump, but I don't know what to do from here.Will you take a look or can you tell me who can help??? As soon as I restart the service, via command prompt right now so that I can watch gc, the memory immediately explodes again.But These logs and gc graph do show a complete lockup. Christian, It sounds like your young generation is too small then. You may want to play with increasing its size. Also if you have multiple CPU's and they are not too busy you might want to increase -XX:ParallelGCThreads You should also read these articles before playing so you understand what your doing: http://www.petefreitag.com/articles/gctuning/ http://www.petefreitag.com/item/139.cfm __ Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Access SQL Question (Resolved)
Just wanted to say thanks - changed the field in Enterprise Manager. Thank you!!! Donna French -Original Message- From: G [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 1:37 PM To: CF-Talk Subject: Re: Access SQL Question SQL Server manages auto-incremented fields differently than Access does. I believe you have to go into SQL Server Enterprise Manager and modify that field in the table so that SQL Server knows it is an autonumber field. - Original Message - From: Donna French To: CF-Talk Sent: Wednesday, August 18, 2004 1:17 PM Subject: Access SQL Question I have a table that I transferred from Access to SQL and had a field setup as auto number. Now I am getting an error message when I try to submit new info to the table in SQL. Here's the error: ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id', table 'mydatabase.user.tblMemo'; column does not allow nulls. INSERT fails. The error occurred while processing an element with a general identifier of (CFINSERT), occupying document position (6:1) to (11:28). Here's the CFInsert code: cfinsert dbname=mydbname username=myusername password=mypassword datasource=mydsn tablename=tblMemo formfields=subject, memo Any help appreciated. Thank you, Donna French _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Query problem
This should work.. I hope Lets get away from the idea of an aggregate and just use a subquery then SELECT m.memberID, m.firstname, m.lastname, t.transactionID as maxTransactionID, t.paidthru as paidthru FROM members m INNER JOIN trans t ON m.memberID = t.memberID WHERE transactionID = (SELECT MAX(transactionID) from trans where memberID = m.memberID) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE: Software Development Times Article
Not at all! This is the perfect time to air concerns regarding Blackstone as it allows Macromedia time to address them before the product ships if they choose to. They may have already addressed the issue or they may not have thought of it. Better to be safe and discuss it now. I don't see how they can be expected to respond to this. MM has said there will be an event gateway. You're saying it might have been a waste of their time. Do you expect them to remove the feature if enough people say it's not worth the time? In any event, it's hard to predict what will be popular or useful beforehand. I can't count the number of times I've thought something would be a really neat feature, but it turned out to be less useful than I expected. The converse is also true. Maybe, but it also might not be possible to invoke CFC's from alternate protocols without using the event gateway thus requiring you to use it. I don't see how that would be possible, given that you said it should be possible to do this today using non-MM code. 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] [Donations and Support]
Re: Access SQL Question
I have a table that I transferred from Access to SQL and had a field setup as auto number. Now I am getting an error message when I try to submit new info to the table in SQL. Yes You will need to go into SQL enterprise manager and make the col that was auto number in access to Identityyou set the Identity seed (number to start) and Identity increment to how you want it to increment. Mark Holm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Access SQL Question
Is there a way in access where you can delete all the child of a parent e.g. if I am deleting a record which a children and children(s) may or may not have child. Here is db schema id,name,parent 1,test1,0 2,test2,0 3,test3,1 4,test4,3 any help is appreciated [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
unicode with cf5 and mysql
Anyone know the trick to get utf-8 data stored in a database to display properly in cf-5? I can display text in kanji and all the other languages fine, and can store them properly in the mysql database. When I display the data from the database in cf, they are displayed as squares. I have seen posts suggest this: cfprocessingdirective pageencoding=utf-8 cfcontent type=text/html; charset=utf-8 meta http-equiv=Content-Type content=text/html; charset=utf-8 The first line is not apparently supported in cf-5. Lines 2-3 work for displaying text, but not for the data from a query. The data from the query does display properly in php, so the database is ok. I thought cf5 worked with unicode. Is it an ODBC issue? Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Query problem - SOLVED
Marc, YES! - that worked - thank you thank you many times for helping me. mARK _ From: Marc Lowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 4:14 PM To: CF-Talk Subject: Re: SQL Query problem This should work.. I hope Lets get away from the idea of an aggregate and just use a subquery then SELECT m.memberID, m.firstname, m.lastname, t.transactionID as maxTransactionID, t.paidthru as paidthru FROM members m INNER JOIN trans t ON m.memberID = t.memberID WHERE transactionID = (SELECT MAX(transactionID) from trans where memberID = m.memberID) _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Query problem - SOLVED
Marc, YES! - that worked - thank you thank you many times for helping me. mARK _ From: Marc Lowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 4:14 PM To: CF-Talk Subject: Re: SQL Query problem This should work.. I hope Lets get away from the idea of an aggregate and just use a subquery then SELECT m.memberID, m.firstname, m.lastname, t.transactionID as maxTransactionID, t.paidthru as paidthru FROM members m INNER JOIN trans t ON m.memberID = t.memberID WHERE transactionID = (SELECT MAX(transactionID) from trans where memberID = m.memberID) _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFSELECT selected parameter
It appears that the SIZE attribute (with value = 2) is required for the preSelected option to work for the CFSELECT tag. Sorry if this has been discussed but I'm finding that in the following CFSELECT code, the selected=8 parameter has no bearing on the default pulldown that's selected when the page is visited.It appears to basically be broken and a useless parameter.Have others seen this? Or is this a pilot error? cfselect name=selectMon selected=8 required=yes message=Please select a month for Call Date option value=1Jan/option option value=2Feb/option option value=3Mar/option option value=4Apr/option option value=5May/option option value=6Jun/option option value=7Jul/option option value=8Aug/option option value=9Sep/option option value=10Oct/option option value=11Nov/option option value=12Dec/option /cfselect [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blackstone summary
you want ti invoke a CFM or CFC directly. from outside CFMX without theindirection/overhead of listening for and triggering an event. What would much more intersting IMHO would be the contrary: Invoke external functions from CF just like if it was a CF function. Yes, there are CFXs, but having extra libraries of functions that could just be added to the basic library would be great. You could just install a DLL like for a CFX, and all the functions it contains are automatically callable, with no need to include the source. And functions could be developped in any language, including CF. Third parties could be more interested in developing tools since they would only have to give the executable. I duno, but this feature was definitely one of the key factors in the popularity of a language like Clipper, and a hudge advantage over dBase some 10 years ago. Clipper was so popular, because many third party tools were availaible on the marked. -- ___ REUSE CODE! Use custom tags; See 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] [Donations and Support]
cfx_MyHelloColdFusion
Hi - Trying the most basic cfx tag to see if i can get one working. When I try to compile the .java file (copied from ) i get the following errors: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFX_MyHelloColdFusion
Hi - Trying the most basic cfx tag to see if i can get one working. When I try to compile the .java file (copied from ) i get the following errors MyHelloColdFusion.java [11:1] package com.allaire.cfx does not exist import com.allaire.cfx.* ; ^ MyHelloColdFusion.java [13:1] cannot resolve symbol symbol: class CustomTag location: class MyHelloColdFusion public class MyHelloColdFusion implements CustomTag { ^ MyHelloColdFusion.java [14:1] cannot resolve symbol symbol: class Request location: class MyHelloColdFusion public void processRequest( Request request, Response response ) ^ MyHelloColdFusion.java [14:1] cannot resolve symbol symbol: class Response location: class MyHelloColdFusion public void processRequest( Request request, Response response ) ^ 4 errors Errors compiling MyHelloColdFusion. JAVA FILE import com.allaire.cfx.* ; public class MyHelloColdFusion implements CustomTag { public void processRequest( Request request, Response response ) throws Exception { String strName = request.getAttribute( NAME ) ; response.write( Hello, + strName ) ; } } Ok, now i think the last 3 errors occur because of the first error, so lets start there. How can i add the package or what do i need to do to get this working? I'm runningCFMX 6,1,0,63958 on Win2K Server and the version info for Java is: java version 1.4.2_04 Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05) Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode) If anyone can help, thanks! If I can get this one working, I'm hoping to create my first real custom tag :) Thanks Joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfx_MyHelloColdFusion
Joe, Attach the code and the error message please. rish -Original Message- From: joe velez [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 3:56 PM To: CF-Talk Subject: cfx_MyHelloColdFusion Hi - Trying the most basic cfx tag to see if i can get one working. When I try to compile the .java file (copied from ) i get the following errors: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFX_MyHelloColdFusion
Joe, It appears as though you the cfx.jar is not in your class path.This JAR contains all of the interface classes that the ColdFusion Server uses to connect to your Java CFX. For CFMX this can be located in the lib subdirectory of your server installation. For CF 5 you can locate this in the Java subdirectory of your server installation. rish -Original Message- From: joe velez [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 4:01 PM To: CF-Talk Subject: CFX_MyHelloColdFusion Hi - Trying the most basic cfx tag to see if i can get one working. When I try to compile the .java file (copied from ) i get the following errors MyHelloColdFusion.java [11:1] package com.allaire.cfx does not exist import com.allaire.cfx.* ; ^ MyHelloColdFusion.java [13:1] cannot resolve symbol symbol: class CustomTag location: class MyHelloColdFusion public class MyHelloColdFusion implements CustomTag { ^ MyHelloColdFusion.java [14:1] cannot resolve symbol symbol: class Request location: class MyHelloColdFusion public void processRequest( Request request, Response response ) ^ MyHelloColdFusion.java [14:1] cannot resolve symbol symbol: class Response location: class MyHelloColdFusion public void processRequest( Request request, Response response ) ^ 4 errors Errors compiling MyHelloColdFusion. JAVA FILE import com.allaire.cfx.* ; public class MyHelloColdFusion implements CustomTag { public void processRequest( Request request, Response response ) throws Exception { String strName = request.getAttribute( NAME ) ; response.write( Hello, + strName ) ; } } Ok, now i think the last 3 errors occur because of the first error, so lets start there. How can i add the package or what do i need to do to get this working? I'm runningCFMX 6,1,0,63958 on Win2K Server and the version info for Java is: java version 1.4.2_04 Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05) Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode) If anyone can help, thanks! If I can get this one working, I'm hoping to create my first real custom tag :) Thanks Joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfx_MyHelloColdFusion
see this message again .. for some reason the entire message was removed. i added a bunch of dashes to help make it easier to read. i've removed them so i hope reading the errors/code isn't too difficult for you. thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOLVED: Re: Log file reader
So, I have a question after playing around with this (wow is it much faster than the easycfm way!): I read up a little on cfscript, is it really true that there is no way to use SQL queries inside a cfscript block?I am VERY new to cfscript, but I thought that there was a way that has been mentioned in here before.This method is not going to do me much good if I can't parse out and put vals in the DB... Thanks Dick, this is pretty cool... Ray At 03:50 PM 8/18/2004, you wrote: Ray, here's the line reader that Joe Rinehart suggested (with a slight mod). Enjoy! Dick Hey Joe Your No Class Reader Works Great! much faster than the other! (almost as fast as a cffile read of the entire file). I simplified the EOF test so I could use a While loop. Thanks Dick Here's the revised code: cfsetting enableCFOutputOnly=yes / cfset lineCount = 0 / cfset timer = GetTickCount() / cfscript filename = /Users/Richard/Music/iTunes/iTunes Music Library.xml; fileReader = createObject(java, java.io.FileReader); fileReader = fileReader.init(filename); lineReader = createObject(java,java.io.LineNumberReader); lineReader = lineReader.init(fileReader); thisLine = true; while (isDefined(thisLine)) { thisLine = lineReader.readLine(); lineCount = LineCount + 1; // do any processing of the line here } /cfscript cfoutput brcount = #lineCount# | #GetTickCount() - timer# /cfoutput cfsetting enableCFOutputOnly=no / I always forget to kill blank lineson this sort of thing -- very important On Jun 16, 2004, at 6:28 AM, Joe Rinehart wrote: Hey Dick, I've done a similar thing, but didn't create the external CFBufferedReader class. Do you see any reason why the following wouldn't provide the same? cfscript filename = c:\cfusionmx\wwwroot\lineNumberReader.cfm; fileReader = createObject(java, java.io.FileReader); fileReader = fileReader.init(filename); lineReader = createObject(java,java.io.LineNumberReader); lineReader = lineReader.init(fileReader); /cfscript cfset eof = false cfloop condition=not eof cfset thisLine = lineReader.readLine() cfif not isDefined(thisLine) cfset eof = true cfelse cfoutput#htmlEditFormat(thisLine)#br/cfoutput /cfif /cfloop (whenlineReader instance hits the end of the file, readLine() returns a result that causes thisLine to become undefined in the eyes ofCF) -joe _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFX_MyHelloColdFusion
Trying the most basic cfx tag to see if i can get one working. When I try to compile the .java file (copied from ) i get the following errors MyHelloColdFusion.java [11:1] package com.allaire.cfx does not exist import com.allaire.cfx.* ; You will need to add cfx.jar to your classpath, I think. On my machine, running CFMX on JRun, it's in \JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\lib. I don't remember exactly where it is with the standalone version of CFMX. 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] [Donations and Support]
Re: cfx_MyHelloColdFusion
ok - let me play w/ the env. vars... i also get similar errors (same w/o text from Sun One Studio) compling from the command line as: javac -classpath CFusionMX\lib\cfx.jar c:\CFusionMX\wwwroot\WEB-INF\classes\MyHelloColdFusion.java joe Joe, It appears as though you the cfx.jar is not in your class path.This JAR contains all of the interface classes that the ColdFusion Server uses to connect to your Java CFX. For CFMX this can be located in the lib subdirectory of your server installation. For CF 5 you can locate this in the Java subdirectory of your server installation. rish -Original Message- From: joe velez [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 4:01 PM To: CF-Talk Subject: CFX_MyHelloColdFusion Hi - Trying the most basic cfx tag to see if i can get one working. When I try to compile the .java file (copied from ) i get the following errors MyHelloColdFusion.java [11:1] package com.allaire.cfx does not exist import com.allaire.cfx.* ; ^ MyHelloColdFusion.java [13:1] cannot resolve symbol symbol: class CustomTag location: class MyHelloColdFusion public class MyHelloColdFusion implements CustomTag { ^ MyHelloColdFusion.java [14:1] cannot resolve symbol symbol: class Request location: class MyHelloColdFusion public void processRequest( Request request, Response response ) ^ MyHelloColdFusion.java [14:1] cannot resolve symbol symbol: class Response location: class MyHelloColdFusion public void processRequest( Request request, Response response ) ^ 4 errors Errors compiling MyHelloColdFusion. JAVA FILE import com.allaire.cfx.* ; public class MyHelloColdFusion implements CustomTag { public void processRequest( Request request, Response response ) throws Exception { String strName = request.getAttribute( NAME ) ; response.write( Hello, + strName ) ; } } Ok, now i think the last 3 errors occur because of the first error, so lets start there. How can i add the package or what do i need to do to get this working? I'm runningCFMX 6,1,0,63958 on Win2K Server and the version info for Java is: java version 1.4.2_04 Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05) Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode) If anyone can help, thanks! If I can get this one working, I'm hoping to create my first real custom tag :) Thanks Joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfx_MyHelloColdFusion - SOLVED
holy crap!!! the compiling is fixed. i tried this at the command line: javac -classpath CFusionMX\lib\cfx.jar c:\CFusionMX\wwwroot\WEB-INF\classes\MyHelloColdFusion.java when it should be javac -classpath c:\CFusionMX\lib\cfx.jar c:\CFusionMX\wwwroot\WEB-INF\classes\MyHelloColdFusion.java i forgot the drive letter in the classpath .. DOH!!! i may be back :) thanks for responding so quickly! - joe Joe, It appears as though you the cfx.jar is not in your class path.This JAR contains all of the interface classes that the ColdFusion Server uses to connect to your Java CFX. For CFMX this can be located in the lib subdirectory of your server installation. For CF 5 you can locate this in the Java subdirectory of your server installation. rish -Original Message- From: joe velez [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 4:01 PM To: CF-Talk Subject: CFX_MyHelloColdFusion Hi - Trying the most basic cfx tag to see if i can get one working. When I try to compile the .java file (copied from ) i get the following errors MyHelloColdFusion.java [11:1] package com.allaire.cfx does not exist import com.allaire.cfx.* ; ^ MyHelloColdFusion.java [13:1] cannot resolve symbol symbol: class CustomTag location: class MyHelloColdFusion public class MyHelloColdFusion implements CustomTag { ^ MyHelloColdFusion.java [14:1] cannot resolve symbol symbol: class Request location: class MyHelloColdFusion public void processRequest( Request request, Response response ) ^ MyHelloColdFusion.java [14:1] cannot resolve symbol symbol: class Response location: class MyHelloColdFusion public void processRequest( Request request, Response response ) ^ 4 errors Errors compiling MyHelloColdFusion. JAVA FILE import com.allaire.cfx.* ; public class MyHelloColdFusion implements CustomTag { public void processRequest( Request request, Response response ) throws Exception { String strName = request.getAttribute( NAME ) ; response.write( Hello, + strName ) ; } } Ok, now i think the last 3 errors occur because of the first error, so lets start there. How can i add the package or what do i need to do to get this working? I'm runningCFMX 6,1,0,63958 on Win2K Server and the version info for Java is: java version 1.4.2_04 Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05) Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode) If anyone can help, thanks! If I can get this one working, I'm hoping to create my first real custom tag :) Thanks Joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: unicode with cf5 and mysql
Try adding useUnicode=truecharacterEncoding=UTF8 to the connection string field on the datasource's advanced settings page.I don't know if CF5 has such a thing though, so you might not be able to. cheers, barneyb On Wed, 18 Aug 2004 16:37:46 -0400, dan martin [EMAIL PROTECTED] wrote: Anyone know the trick to get utf-8 data stored in a database to display properly in cf-5? I can display text in kanji and all the other languages fine, and can store them properly in the mysql database. When I display the data from the database in cf, they are displayed as squares. I have seen posts suggest this: cfprocessingdirective pageencoding=utf-8 cfcontent type=text/html; charset=utf-8 meta http-equiv=Content-Type content=text/html; charset=utf-8 The first line is not apparently supported in cf-5. Lines 2-3 work for displaying text, but not for the data from a query. The data from the query does display properly in php, so the database is ok. I thought cf5 worked with unicode. Is it an ODBC issue? Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Fusebox Conf interviews 5: Steve Nelson on Fusedocs
In this Fusebox Conference interview Hal Helms interviews Steve Nelson on Fusedocs. But first some news. - Michael Smith, TeraTech, Inc http://www.teratech.com/ * Conference and training news * Only 30 days left before the conference! * Only one slot left for an attendee to present their FB application in the Fusebox showcase - email me ASAP if you want to do this. * Place orders for books before 8/27/04 to receive them at the event * Optional Intermediate Fusebox and Mach-II classes are filling up - register now to guarantee your place at http://www.teratech.com/training/ * Schedule of sessions is up at http://www.cfconf.org/fusebox2004/schedule.cfm * New hands on session Building your first FB application by Jeff Peters * New session on Strategies for Successful Development by Maxim Porges * Synthis (makers of Adalon) is a sponsor * Now back to the interviews Hal: So, Steve, I understand you're talking on Fusedocs. Steve: Yes, I think Fusedocs may be the most underused aspect of FLiP. Hal: Well, no one likes documentation. Steve: I started off not liking it either. I couldn't see the point of it, other than for posterity. It's like those admonitions to eat your vegetables or be nice. It's hard to argue against, but it's even harder to take seriously. Hal: I remember we used to have long, passionate arguments about this. Steve: Yes, when you first came up with these crazy things called Fusedocs, I thought, There's Crazy Hal again. Hal: It's nice to be held in high regard by one's peers... Steve: But one day, I had a realization. You weren't talking about documenting your code; you were talking about coding your documentation! Hal: Exactly right, Steve. Steve: A lot of people use Fusedocs simply to document the existing app, which is OK, but writing them BEFORE the app gets written is where the power is. Hal: I think everyone's probably tired of hearing my story about my friend from Boston who got a contract to develop a large, ecommerce site. Steve: The one that had to be done in one month? Hal: That's the one. When he asked me for help, I thought it was impossible, especially since I was working on a huge project under a very tight deadline, but we were able to do it using FLiP. We wrote the Fusedocs and sent them off overseas. The coding took 48 hours and the job was successful. Steve: That's what SecretAgents.com is based on: a well-architected application that can be distributed to many developers, wherever they live. And the secret behind SecretAgents is Fusedocing before you write the app. Hal: Well, gee, now that we've told everyone about Fusedocs, why should anyone come to the conference? Steve: Because just knowing ABOUT them won't do anyone any good. And there are a LOT of ways to screw Fusedocs up so that they just cost extra time, but don't help out much. Hal: Ah! So you're going to show people how to write good Fusedocs? Steve: Yes, how to write Fusedocs that can enormously affect the speed and quality of code that's written. I've got some great tools for helping with Fusedocs. And Sandy Clark wrote tag completion files that plug into HomeSite, Studio, or Dreamweaver to make writing Fusedocs really easy. Hal: Maybe you can take this occasion of your talk to finally agree with me on all the other stuff we've argued about? Sort of make a clean breast of it in front of all the Fuseboxers? Steve: Yeah, that's gonna happen. Everybody come to the conference so they can see me reduce Hal to tears with the power of my argument! Hal: I've often been reduced to tears in my attempts to follow your arguments. There's only so much illogic a man can take. Steve: Well, one thing we can agree on: Fusedocs rock when they're done right. Hal: Amen, brother. --- Fusebox Conference is organized by TeraTech who received four CFDJ awards. If you need ColdFusion project help, mentoring or training then ask the experts at http://www.teratech.com/ Best Consulting - TeraTech Finalist Training - TeraTech Finalist Community site - CFConf Finalist Web Dev Tool - CFXGraphicsServer --- This year's conference has 12 nationally known speakers including Hal Helms, John Quarto-vonTivadar, Jeff Peters, Sandra Clark, Michael Smith, Steve Nelson, Brian Kotek, Rey Muradaz, Matt Liotta, John Paul Ashenfelter Fusebox Washington DC area 9/18 - 9/19/04: * Learn Fusebox, Mach-II and more! * Network with your peers and top national speakers * Have fun exploring what is new in Fusebox Tracks: * Advanced Topics * Basic Topics * Optional classes on intro to Fusebox, Intermediate Fusebox and Mach-II Pricing schedule - register today to save! * Just $149 Early Bird Price from 1/1/04 - 7/31/04 * Ok$199 Regular Price 8/1/04 - 9/10/04 * Opps $249 Late Registration 9/11/04 - 9/17/04 * Onsite $300 Register today http://www.cfconf.com/Fusebox2004/ -- Michael Smith, TeraTech Inc -
Re: CFX_MyHelloColdFusion
joe velez wrote: When I try to compile the .java file (copied from ) i get the following errors MyHelloColdFusion.java [11:1] package com.allaire.cfx does not exist you need to add cfx.jar to your classpath when you compile, eg: javac -classpath c:\CFusionMX\lib\cfx.jar MyHelloColdFusion.java Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Dynamic Debug?
Hi Gonz, Thanks for your tip. Was struggling with this. Debugging would show on one website and not another. I tried your tip below and it works beautifully. Dharmesh -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 4:14 PM To: CF-Talk Subject: RE: Dynamic Debug? Ahhh... yes. Thank You. I discovered that one needs to remove all IP addresses from the CFadministrator in order for the showdebutoutput=Yes/No setting to be effective. Thanks again, Gonz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Dreamweaver Find RE
I'm trying to use the Find and Replace feature of Dreamweaver using Regular Expressions.Either I'm doing something wrong or DW is totally brain dead when it comes to trying to use RE for this purpose.If this is the wrong forum, politely tell me where to go. I'm trying to find take a list of words (1-3) and place a repeated string before it and one after it and one in between a second instance... So I Find:(^.*$) and try to Replace with:option value=$1$1/option I can't get past the Find not working.I can't get DW to find ^.* or .*$, or any string with $ in it.Yet RE $ is end of line symbol. What am I doing wrong?(And yes I have the Use Regular Expressions checkbox checked in the Find/Replace dialog box. I'm using DW MX 2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Web Form Data Security
How secure is a web form built with CF that (when submitted) INSERTS the data into a database with respect to someone hacking and accessing data from that database?Is it possible for an expert to place SQL code into text fields that will extract data in any way? How can I guerantee that this won't happen?i.e. how can I filter/test the form data such that attempts such as this will be prevented? What do you do to prevent hacking via a web form that posts data into a db? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Web Form Data Security
Use cfqueryparam... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOLVED: Re: Log file reader
Thank Joe Rinehart -- he created the code. As to executing a query within cfscript Know you can't --- but you can fudge it create a function (or CFC that issues the query based on a string passed toit.The string contains the SQL statements). within the script tag invoke the function which returns the record set Howie Hamlin had a thread on this earlier today. BTW, It is generally thought to be a good idea to generalize this approach and put all your db calls into CFCs ( code reusability).I have even seen recommendations that you write these CFCs like like OOP objects with getters and setters for each field in the db.I don't know if that level of implementation is warranted on most projects. But I do find it useful to gather all my queries into a CFC (or CFCs) where a function has a default columnlist and action that can be overridden when the function is called. Dick On Aug 18, 2004, at 2:03 PM, Ray Champagne wrote: So, I have a question after playing around with this (wow is it much faster than the easycfm way!): I read up a little on cfscript, is it really true that there is no way to use SQL queries inside a cfscript block? I am VERY new to cfscript, but I thought that there was a way that has been mentioned in here before. This method is not going to do me much good if I can't parse out and put vals in the DB... Thanks Dick, this is pretty cool... Ray At 03:50 PM 8/18/2004, you wrote: Ray, here's the line reader that Joe Rinehart suggested (with a slight mod). Enjoy! Dick Hey Joe Your No Class Reader Works Great! much faster than the other! (almost as fast as a cffile read of the entire file). I simplified the EOF test so I could use a While loop. Thanks Dick Here's the revised code: cfsetting enableCFOutputOnly=yes / cfset lineCount = 0 / cfset timer = GetTickCount() / cfscript filename = /Users/Richard/Music/iTunes/iTunes Music Library.xml; fileReader = createObject(java, java.io.FileReader); fileReader = fileReader.init(filename); lineReader = createObject(java,java.io.LineNumberReader); lineReader = lineReader.init(fileReader); thisLine = true; while (isDefined(thisLine)) { thisLine = lineReader.readLine(); lineCount = LineCount + 1; // do any processing of the line here } /cfscript cfoutput brcount = #lineCount# | #GetTickCount() - timer# /cfoutput cfsetting enableCFOutputOnly=no / I always forget to kill blank lines on this sort of thing -- very important On Jun 16, 2004, at 6:28 AM, Joe Rinehart wrote: Hey Dick, I've done a similar thing, but didn't create the external CFBufferedReader class. Do you see any reason why the following wouldn't provide the same? cfscript filename = c:\cfusionmx\wwwroot\lineNumberReader.cfm; fileReader = createObject(java, java.io.FileReader); fileReader = fileReader.init(filename); lineReader = createObject(java,java.io.LineNumberReader); lineReader = lineReader.init(fileReader); /cfscript cfset eof = false cfloop condition=not eof cfset thisLine = lineReader.readLine() cfif not isDefined(thisLine) cfset eof = true cfelse cfoutput#htmlEditFormat(thisLine)#br/cfoutput /cfif /cfloop (when lineReader instance hits the end of the file, readLine() returns a result that causes thisLine to become undefined in the eyes of CF) -joe _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver Find RE
I know this is true of HS+, so I assume it of Dreamweaver: First, $ represents end of file, not end of line, so use whatever literal linebreak your system or setup uses. Second, backreferences are done using backslashes instead of dollar signs, so use \1 instead of $1. Finally, the regex you wrote (if it worked) would add the option tags to every line in the file.I'm not sure if that was your intent. --Ben CF Coder2 wrote: I'm trying to use the Find and Replace feature of Dreamweaver using Regular Expressions.Either I'm doing something wrong or DW is totally brain dead when it comes to trying to use RE for this purpose.If this is the wrong forum, politely tell me where to go. I'm trying to find take a list of words (1-3) and place a repeated string before it and one after it and one in between a second instance... So I Find:(^.*$) and try to Replace with:option value=$1$1/option I can't get past the Find not working.I can't get DW to find ^.* or .*$, or any string with $ in it.Yet RE $ is end of line symbol. What am I doing wrong?(And yes I have the Use Regular Expressions checkbox checked in the Find/Replace dialog box. I'm using DW MX 2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFCHART Macromedia page broke
...all i want is a normal bar graph with the bars different colors.. is that too much to ask ??? can you not use colorlist in type=bar? http://examples.macromedia.com/coldfusion/cfchart/? this example is no help... its broke ... sigh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Form Data Security
cfqueryparam On Aug 18, 2004, at 2:40 PM, CF Coder2 wrote: How secure is a web form built with CF that (when submitted) INSERTS the data into a database with respect to someone hacking and accessing data from that database? Is it possible for an expert to place SQL code into text fields that will extract data in any way? How can I guerantee that this won't happen? i.e. how can I filter/test the form data such that attempts such as this will be prevented? What do you do to prevent hacking via a web form that posts data into a db? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOLVED: Re: Log file reader
I will try that tomorrow - time to bust into a few 'adult beverages' tonight.My wife and I bought our first house today... Thanks (and thanks to Joe too), Ray At 05:44 PM 8/18/04, you wrote: Thank Joe Rinehart -- he created the code. As to executing a query within cfscript Know you can't --- but you can fudge it create a function (or CFC that issues the query based on a string passed toit.The string contains the SQL statements). within the script tag invoke the function which returns the record set Howie Hamlin had a thread on this earlier today. BTW, It is generally thought to be a good idea to generalize this approach and put all your db calls into CFCs ( code reusability).I have even seen recommendations that you write these CFCs like like OOP objects with getters and setters for each field in the db.I don't know if that level of implementation is warranted on most projects. But I do find it useful to gather all my queries into a CFC (or CFCs) where a function has a default columnlist and action that can be overridden when the function is called. Dick On Aug 18, 2004, at 2:03 PM, Ray Champagne wrote: So, I have a question after playing around with this (wow is it much faster than the easycfm way!): I read up a little on cfscript, is it really true that there is no way to use SQL queries inside a cfscript block?I am VERY new to cfscript, but I thought that there was a way that has been mentioned in here before.This method is not going to do me much good if I can't parse out and put vals in the DB... Thanks Dick, this is pretty cool... Ray At 03:50 PM 8/18/2004, you wrote: Ray, here's the line reader that Joe Rinehart suggested (with a slight mod). Enjoy! Dick Hey Joe Your No Class Reader Works Great! much faster than the other! (almost as fast as a cffile read of the entire file). I simplified the EOF test so I could use a While loop. Thanks Dick Here's the revised code: cfsetting enableCFOutputOnly=yes / cfset lineCount = 0 / cfset timer = GetTickCount() / cfscript filename = /Users/Richard/Music/iTunes/iTunes Music Library.xml; fileReader = createObject(java, java.io.FileReader); fileReader = fileReader.init(filename); lineReader = createObject(java,java.io.LineNumberReader); lineReader = lineReader.init(fileReader); thisLine = true; while (isDefined(thisLine)) { thisLine = lineReader.readLine(); lineCount = LineCount + 1; // do any processing of the line here } /cfscript cfoutput brcount = #lineCount# | #GetTickCount() - timer# /cfoutput cfsetting enableCFOutputOnly=no / I always forget to kill blank lineson this sort of thing -- very important On Jun 16, 2004, at 6:28 AM, Joe Rinehart wrote: Hey Dick, I've done a similar thing, but didn't create the external CFBufferedReader class. Do you see any reason why the following wouldn't provide the same? cfscript filename = c:\cfusionmx\wwwroot\lineNumberReader.cfm; fileReader = createObject(java, java.io.FileReader); fileReader = fileReader.init(filename); lineReader = createObject(java,java.io.LineNumberReader); lineReader = lineReader.init(fileReader); /cfscript cfset eof = false cfloop condition=not eof cfset thisLine = lineReader.readLine() cfif not isDefined(thisLine) cfset eof = true cfelse cfoutput#htmlEditFormat(thisLine)#br/cfoutput /cfif /cfloop (whenlineReader instance hits the end of the file, readLine() returns a result that causes thisLine to become undefined in the eyes ofCF) -joe _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver Find RE
I know this is true of HS+, so I assume it of Dreamweaver: First, $ represents end of file, not end of line, so use whatever literal linebreak your system or setup uses. That's odd since the Help built in to DW states $ is end of line Second, backreferences are done using backslashes instead of dollar signs, so use \1 instead of $1. I was used to using \1 but in the DW help it says... Use parentheses to set off groupings within the regular _expression_ to be referred to later. Then use $1, $2, $3, and so on in the Replace With field to refer to the first, second, third, and later parenthetical groupings. Note: In the Search For text box, to refer to a parenthetical grouping earlier in the regular _expression_, use \1, \2, \3, and so on instead of $1, $2, $3. I'm actually stalling on the Find portion even before I actually try to replace anything. Finally, the regex you wrote (if it worked) would add the option tags to every line in the file.I'm not sure if that was your intent. Yes that is what I wanted.I have a stack of column text I want to wrap in the before and after strings in my example.DW lets you find and replace line by line so I was going to step forward 20-30 lines then cancel. --Ben CF Coder2 wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFUPDATE-ing without a form?
Dear list, Is there any way to CFUPDATE without using a form?I'd like to pass the data as variables in the URL. TIA, CK. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Form Data Security
cfqueryparam So is that adequate? What other best practices are there to ensure nothing can happen? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFUPDATE-ing without a form?
Copy the data from the url scope to the form scope first: cfset structAppend(form, url) _ From: Chris Kavanagh [mailto:[EMAIL PROTECTED] Sent: Thursday, 19 August 2004 9:54 a.m. To: CF-Talk Subject: CFUPDATE-ing without a form? Dear list, Is there any way to CFUPDATE without using a form?I'd like to pass the data as variables in the URL. TIA, CK. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFUPDATE-ing without a form?
CFUPDATE expects the variables that it will be using to be in the form scope. Just hand set the variables to that scope: CFSET form.name=michael CFUPDATE will treat name as if it came in on a form and make use of it. _ From: Chris Kavanagh [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 5:54 PM To: CF-Talk Subject: CFUPDATE-ing without a form? Dear list, Is there any way to CFUPDATE without using a form?I'd like to pass the data as variables in the URL. TIA, CK. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfx_odbc
has anyone used the cfx_odbc tag before? i have the dll, but cant find how to use it. i know there is an ACTION parameter, and believe CREATE and DELETE are possible values. please provide a simple example if u can. thanks it should be like cfx_odbc action='' ..im also interested in a similar tag, but written in java for linux. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Form Data Security
CFQUERYPARAM will protect your database from SQL injection attacks. If you need other things (such as XSS protection), then you'll have to add some more code, usually as part of your validation code. cheers, barneyb On Wed, 18 Aug 2004 17:58:08 -0400, CF Coder2 [EMAIL PROTECTED] wrote: cfqueryparam So is that adequate? What other best practices are there to ensure nothing can happen? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFCHART Macromedia page broke
OK... -get the values for each bar -make some 1 pixel coloured GIFs -alternate bar colours -use a set thickness for each bar (by using the width attribute of the image tag to show the bar) -use the values you calculated for each bar to stretch the pixel image to the appropriate height (using height attribute) This is all assume your bars are vertical and not horizontalif horizontal switch width for height ;-) This is a super simple way of creating a bar chart...been around for ever..and hey...it still works like a charm HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Ewok To: CF-Talk Sent: Wednesday, August 18, 2004 2:53 PM Subject: CFCHART Macromedia page broke ...all i want is a normal bar graph with the bars different colors.. is that too much to ask ??? can you not use colorlist in type=bar? http://examples.macromedia.com/coldfusion/cfchart/? this example is no help... its broke ... sigh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOLVED: CFUPDATE-ing without a form?
Wow.Many, many thanks to Michael and Matthew and their very quick responses! Best, CK. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Form Data Security
So is that adequate? yes.You are invulnerable to sql injection if you use it on all of your inputs.As in from-the-planet-Krypton invulnerable. What other best practices are there to ensure nothing can happen? Unplug your web server from the internet and turn it off. No, seriously, there is no way you can be absoultely secure.You can do your due diligence but you will never be safe from *everything* a determined attacker will throw at you. Some other things you can do are scrub your url parms for funny stuff. In the most recent discussion on this Jochem mentioned that simply plugging in htmleditformat() around your vars will proof them agaist cross-site scripting.I toss this into Application.cfm. cfif Len(Trim(cgi.query_string)) gt 0 cfset variables.QueryDelim = ? cfelse cfset variables.QueryDelim = /cfif cfset variables.thisURLVar=cgi.script_namevariables.QueryDelimurldecode(cgi.query_string) CF_CodeCleaner input=#variables.thisurlvar# r_output=myURL cfif CompareNoCase(variables.thisURLVar,variables.myURL) cfheader statuscode=500 statustext=Server Error cfabort /cfif This uses a custom tag you can get out of the DevEx and may be overkill. Still, it only eats about 10ms per page view and brings a beatific albeit somewhat vacant look into my eyes. You can also test for a valid referer on your forms, but those can be easily faked by anyone who is serious.The only way to put that one to bed is to use those graphical thingies on a form where a human user has read it and type in the letters in the graphic.I forget what they are called. Is it Friday yet?Gawd what a day... -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Access SQL Question
Is this what you want? DELETE FROMmyTable WHEREparent = 3 Or do you want to be able to recursively delete descendents (i.e. children, cgrandchildren.) at all levels? _ From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Thursday, 19 August 2004 8:32 a.m. To: CF-Talk Subject: Access SQL Question Is there a way in access where you can delete all the child of a parent e.g. if I am deleting a record which a children and children(s) may or may not have child. Here is db schema id,name,parent 1,test1,0 2,test2,0 3,test3,1 4,test4,3 any help is appreciated _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Form Data Security
Where can I learn about XSS protection?I'm sure google can give me zillions of references but if you can recommend one or two that would be great. CFQUERYPARAM will protect your database from SQL injection attacks. If you need other things (such as XSS protection), then you'll have to add some more code, usually as part of your validation code. cheers, barneyb [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Form Data Security
See Matt's post.; )I don't know of any place offhand to get more info. Depending on your application, XSS may or may not be a concern.It usually is, but the magnitude of the problem varies widely, from a couple fields on one form, to every field on every form.And don't discount URL fields either, they're just as important. cheers, barneyb On Wed, 18 Aug 2004 18:27:13 -0400, CF Coder2 [EMAIL PROTECTED] wrote: Where can I learn about XSS protection?I'm sure google can give me zillions of references but if you can recommend one or two that would be great. CFQUERYPARAM will protect your database from SQL injection attacks. If you need other things (such as XSS protection), then you'll have to add some more code, usually as part of your validation code. cheers, barneyb -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver Find RE
FWIW, my 6.1 version of DW sometimes can't even find plain text words I know are right there on the page. If I close and re-open it, I can find those same words. I chalk it up to an annoying bug. Bottom line: you might try another editor to test your regex in as well. - Regards, Bob Haroche O n P o i n tS o l u t i o n s www.OnPointSolutions.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Count Online Users Conundrum
My apologies -- this will give you their total session time.To work out if they've been inactive for more than 15 minutes you'll have to do a time check comparing the last active timestamp and the current time using now(). Hi Tim, Thanks.I ran your script and sure enough, right now, it says there are 99 users when it probably should be something like 20.I'm not sure if I'm understanding you completely -- I'm thinking that I need to add to the following snippet that already exists: cfloop collection=#Application.UsersInfo# item=itmUser cflock name=session-lock-#itmUser# timeout=15 cfif structkeyexists(Application.UsersInfo, itmUser) cfif DateDiff(n, Application.UsersInfo[itmUser], Now()) GT 15 cfset StructDelete(Application.UsersInfo, itmUser) /cfif /cfif /cflock /cfloop So I'd include another CFIF statement: cfif DateDiff(n, LAST ACTIVE, Now()) GT 15 cfset StructDelete(Application.UsersInfo, itmUser) /cfif The problem is figuring out this last active number -- am I missing something simple? Again, thanks for all your help... - Sung [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Form Data Security
Thanks Matt and the others! This was helpful. I'm not sure what the point of wrapping vars in HTMLEditFormat.The Ref Man is almost useless in stating it's value...returns an HTML-escaped string...so?Why does that help.I'll have to think on that. I'll have to read up on XSS though.Haven't a clue what that is. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLACKSTONE: Software Development Times Article
LOL tony u can speak 4 me anytime, gives me more time to go fishin! cfset goodFlyFishingDay = weather EQ rain AND clouds EQ overcast AND season NEQ winter -- Original Message -- From: Tony Weeg [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 18 Aug 2004 09:38:08 -0400 you know what man, i dont want, wait a minute, YOU CANT DO ANYTHING WITH ME, you dont have that option, friend, sorry. now, mike d, he could throw him off the list, sure... im not here to get into a pissing match with you matt, i just tend to be the voice of the soft spoken crowd. the crowd that is sick of your sentiments, sick of your cynicism and just generally sick of your pessimistic arrogance... matt, i respect your intelligence, i respect your message, you are way off the scales on the iq chart im sure, butyour delivery sucks. if your personality was half of what your intelligence was, man, im sure you could be president.i hope this doesnt offend you, its not intended to do so, this list isnt the forum for this, and i dont have the time for it, but please, dont take offense, learn a lesson in people skills, it will GET YOU VERY FAR!! tony. On Wed, 18 Aug 2004 15:10:32 +0200, Micha Schopman [EMAIL PROTECTED] wrote: Personally, the moment BlueDragon came out I thought.. those guys actually give us what the community always wanted. BlueDragon just filled up that spot which has always been on the request list of many developers. And also personally, I don't think I will ever use Flash forms, or auto-generated forms by ColdFusion, you always have to do a lot of work to let it fit into the application. The chances that I use the event gateway are way much higher, but as someone already said, it depends on the model and since we haven't seen any model or code it is hard to discuss about it or to form an opinion about it. Personally, for me the selling points in Blackstone are the reporting features, the cfdocument tag, and the compiled deployment of files. If you are a basic ColdFusion user, flashy forms are nice, but for me, as I use and code in _javascript_ extensivily, Flash forms are unsufficient and cause to much overhead in the bigger picture. I now this is a feature Macromedia has to push, because of the rich internet model strategy combined with Flex etc., but I am kinda resistant to those nich things which seem to cost me more time than they promise. Customer A; I don't like the blue spot Customer B; I miss this and this functionality .. .. I guess I ended up starting FlashMX, developing the missing parts, and still it doesn't react or isn't as fast as ordinary markup with _javascript_. :) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Form Data Security
XSS is cross site scripting, which is where a malicious user injects some code that will be displayed on your site (and consequently assumed to come from you by your users).Comments on blogs are an example.If I drop a SCRIPT tag into a blog comment that launches a popup window to porn site X, that's an example of XSS. So I submit scriptwindow.open('http://www.google.com')/script' as a comment.Next time someone views the page, a window will pop up, because that string was insert into the body of the page with all the other comments.Running it through HTMLEditFormat(), however, would yield this string lt;scriptgt;window.open('http://www.google.com')lt;/scriptgt; which, when inserted into the body of the comments page, will render as the text I submitted.No more unauthorized popup. It gets trickier if you want to allow some HTML (like B, I, U, A and IMG) tags, but nothing else. cheers, barneyb On Wed, 18 Aug 2004 20:07:24 -0400, CF Coder2 [EMAIL PROTECTED] wrote: Thanks Matt and the others! This was helpful. I'm not sure what the point of wrapping vars in HTMLEditFormat.The Ref Man is almost useless in stating it's value...returns an HTML-escaped string...so?Why does that help.I'll have to think on that. I'll have to read up on XSS though.Haven't a clue what that is. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Form Data Security
Thanks, Barney! Now it makes sense! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF @ MAX 2004
Most of us on the CF Engineering QA teams are planning on heading to New Orleans Nov 1-4. We view this as one of our most important events of the year, as the ability to talk to, mingle, make decisions and hear from you our customers is critical to our success. And of course, there are some sweet ColdFusion education sessions planned you want to check out: http://www.macromedia.com/macromedia/events/max/agenda/by_track.html Flights are cheaper if booked in advance, etc, so just a ping to remind you to not miss this one.Last year we had some great discussion over pints, and in meeting rooms, and after sessions, and over meals, and this year should top them all with BLACKSTONE around the corner. I sincerely hope to see you there.You're the reason we do-what-we-do. PS: There's one session under the Mobile and Devices Track that might interesting... Regards, Damon Cooper Director of Engineering Macromedia [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
setting a default value in my SELECT tag
Dear list, I'm sure there is a simple answer to this basic question.Sorry for being such a noob: I'm working on my first application!I hope to become a useful member of the CF community one day.But first you will have to put up with my stupid questions for a while. Stupid question the second: I have a select element in a form.The options are populated from a database.It looks a bit like this: CFQUERY name=get_projects datasource=datasource SELECT projectname FROM projects /CFQUERY ... SELECT name=project CFOUTPUT query=get_projects OPTION#projectname#/OPTION /CFOUTPUT /SELECT It works beautifully so far, giving me a list of all the projects in my database.But I'd like it to default to a certain value from another query.So I added some more code: CFQUERY name=get_details datasource=datasource SELECT projectname FROM projects WHERE ID=[a certain value] /CFQUERY CFOUTPUT query=get_details SELECT name=project value=#projectname# /CFOUTPUT CFOUTPUT query=get_projects OPTION#projectname#/OPTION /CFOUTPUT /SELECT But it just doesn't work: it won't default to the value from the new query.Am I being a total moron? TIA, CK. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: blackstone, what would be sweet
what else would be sweet is auto queryparams ;) oh yeah a select all option on the damn extention manager they also should buy out MM exporter too build that into their products too and.. make a cf_smile tag 4 matt ;) (run in java of course) -- Original Message -- From: S. Isaac Dealey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 17 Aug 2004 18:41:24 -0400 yeah i know bout those as its one of the ways i do it heres more bout what i was thinkin in the dw property panel when u add a form box have a few extra options like maybe some checkboxes such as allow letters only allow numbers only allow html content no html content certainly wouldnt be that hard to add but in my mind would be a huge time saver Ahh but then you're getting off into Dreamweaver, not necessarily CF. In which case -- I'd venture that if you know enough about DW extensions, you could write these tools yourself in that medium also. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
form validation problems
I've recently revisited some form validation issues, and once again it's driving me batty. Here is what I have so far... here's the main part of the form from dsp_register.cfm at the top I set a default value for variables.msg and form fields cfparam name=form.team_name default= cfparam name=form.company_name default= cfparam name=form.address_1 default= cfparam name=form.email default= cfparam name=variables.msg default= cfif isdefined(client.form_variables) cfwddx action="" input=#client.form_variables# output=formTemp cfloop index=formItem list=#StructKeyList(formTemp)# cfset StructInsert(form,formItem,evaluate(formTemp. formItem), true) /cfloop /cfif cfif variables.msg is not p#variables.msg#/p /cfif form name=npcregister method=post enablecab=No action="" class=center div class=rugbyform Team Name:br / input type=text name=team_name value=#form.team_name# size=34 /br / Company Name:br / input type=text name=company_name value=#form.company_name# size=34 /br / Address 1:br / input type=text name=address_1 value=#form.address_1# size=34 /br / Email:br / input type=text name=email size=34 /br /br / Charge my Chamber account input type=radio name=payment value=charge chamber class=radio /br / I will forward payment to Box 237, Gore input type=radio name=payment value=forward payment class=radio /br /br / input type=submit name=submit id=submit value=Submit class=button / input type=reset name=reset id=reset value=Reset class=button / /div /form it then gets sent to the XFA.submitRegister for validation (using act_validateRegisterInfo.cfm) which is as follows: cfwddx action="" input=#form# output=client.form_variables usetimezoneinfo=No cfif form.team_name IS cfset variables.msg=variables.msg liYou must enter your team name/li /cfif cfif form.company_name IS cfset variables.msg=variables.msg liYou must enter your company name/li /cfif cfif form.address_1 IS cfset variables.msg=variables.msg liYou must enter a valid address/li /cfif cfif variables.msg IS NOT cfset variables.msg=h1ENTRY ERROR/h1The following error(s) were detected:ul#variables.msg#/ul cflocation URL=""> /cfif Which by rights should send the user back to the form if one of the above fields is empty, and above the form it should list the errors. However, when a field is left empty such ss company_name, it will send me back and it will display the values I had previously entered (using cfwddx) that were ok...but it WONT show me the variables.msg for those invalid entries (variables.msg is always ) What am I doing wrong? All I want to do is output the relevant error messages in a list when the user is returned to the form and keep previously entered form data. Help! Or is there another more efficient way of achieving this? I've heard of cf_reuseform but know nothing about it. All help greatly appreciated. TIA Regards Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFCHART Macromedia page broke
OK umm... no lol no really, i've made plnty of polls just that way horizontal and vertical... her has to be cfchart since they have the ability to change the graph type bar, line, pie etc.. i've got it all working now it was the seriesplacement attribute. i set that to cluster and voila although... I dont like the flat look, and the 3D look is too deep. cfgraph had the depth attribute... is there nothing I can do to change the depth of cfchart graphs? - Original Message - From: Bryan Stevenson To: CF-Talk Sent: Wednesday, August 18, 2004 6:03 PM Subject: Re: CFCHART Macromedia page broke OK... -get the values for each bar -make some 1 pixel coloured GIFs -alternate bar colours -use a set thickness for each bar (by using the width attribute of the image tag to show the bar) -use the values you calculated for each bar to stretch the pixel image to the appropriate height (using height attribute) This is all assume your bars are vertical and not horizontalif horizontal switch width for height ;-) This is a super simple way of creating a bar chart...been around for ever..and hey...it still works like a charm HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Ewok To: CF-Talk Sent: Wednesday, August 18, 2004 2:53 PM Subject: CFCHART Macromedia page broke ...all i want is a normal bar graph with the bars different colors.. is that too much to ask ??? can you not use colorlist in type=bar? http://examples.macromedia.com/coldfusion/cfchart/? this example is no help... its broke ... sigh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: setting a default value in my SELECT tag
try this on for size SELECT name=project CFOUTPUT query=get_projects OPTION value=#ID#cfif ID is get_details.ID selected/cfif#projectname#/OPTION /CFOUTPUT /SELECT - Original Message - From: Chris Kavanagh To: CF-Talk Sent: Wednesday, August 18, 2004 8:33 PM Subject: setting a default value in my SELECT tag Dear list, I'm sure there is a simple answer to this basic question.Sorry for being such a noob: I'm working on my first application!I hope to become a useful member of the CF community one day.But first you will have to put up with my stupid questions for a while. Stupid question the second: I have a select element in a form.The options are populated from a database.It looks a bit like this: CFQUERY name=get_projects datasource=datasource SELECT projectname FROM projects /CFQUERY ... SELECT name=project CFOUTPUT query=get_projects OPTION#projectname#/OPTION /CFOUTPUT /SELECT It works beautifully so far, giving me a list of all the projects in my database.But I'd like it to default to a certain value from another query.So I added some more code: CFQUERY name=get_details datasource=datasource SELECT projectname FROM projects WHERE ID=[a certain value] /CFQUERY CFOUTPUT query=get_details SELECT name=project value=#projectname# /CFOUTPUT CFOUTPUT query=get_projects OPTION#projectname#/OPTION /CFOUTPUT /SELECT But it just doesn't work: it won't default to the value from the new query.Am I being a total moron? TIA, CK. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFCHART Macromedia page broke
oh, well i guess that was an earlier problem but either way its fixed as well as the original :) still need to adjust the depth though if at all possible - Original Message - From: Ewok To: CF-Talk Sent: Wednesday, August 18, 2004 8:50 PM Subject: Re: CFCHART Macromedia page broke OK umm... no lol no really, i've made plnty of polls just that way horizontal and vertical... her has to be cfchart since they have the ability to change the graph type bar, line, pie etc.. i've got it all working now it was the seriesplacement attribute. i set that to cluster and voila although... I dont like the flat look, and the 3D look is too deep. cfgraph had the depth attribute... is there nothing I can do to change the depth of cfchart graphs? - Original Message - From: Bryan Stevenson To: CF-Talk Sent: Wednesday, August 18, 2004 6:03 PM Subject: Re: CFCHART Macromedia page broke OK... -get the values for each bar -make some 1 pixel coloured GIFs -alternate bar colours -use a set thickness for each bar (by using the width attribute of the image tag to show the bar) -use the values you calculated for each bar to stretch the pixel image to the appropriate height (using height attribute) This is all assume your bars are vertical and not horizontalif horizontal switch width for height ;-) This is a super simple way of creating a bar chart...been around for ever..and hey...it still works like a charm HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Ewok To: CF-Talk Sent: Wednesday, August 18, 2004 2:53 PM Subject: CFCHART Macromedia page broke ...all i want is a normal bar graph with the bars different colors.. is that too much to ask ??? can you not use colorlist in type=bar? http://examples.macromedia.com/coldfusion/cfchart/? this example is no help... its broke ... sigh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOLVED: setting a default value in my SELECT tag
Dear Ewok, Thank you, you're a genius.I was just fumbling around the edges of that solution, but my way involved all kinds of CFSETs and stuff: using the scope is much more elegant. My first app is working quite nicely but I bet the code is flabby.I will probably look back on it and cringe one day. Thanks again. CK. On 19 Aug 2004, at 1:55 am, Ewok wrote: try this on for size SELECT name=project CFOUTPUT query=get_projects OPTION value=#ID#cfif ID is get_details.ID selected/cfif#projectname#/OPTION /CFOUTPUT /SELECT - Original Message - From: Chris Kavanagh To: CF-Talk Sent: Wednesday, August 18, 2004 8:33 PM Subject: setting a default value in my SELECT tag Dear list, I'm sure there is a simple answer to this basic question. Sorry for being such a noob: I'm working on my first application! I hope to become a useful member of the CF community one day. But first you will have to put up with my stupid questions for a while. Stupid question the second: I have a select element in a form. The options are populated from a database. It looks a bit like this: CFQUERY name=get_projects datasource=datasource SELECT projectname FROM projects /CFQUERY ... SELECT name=project CFOUTPUT query=get_projects OPTION#projectname#/OPTION /CFOUTPUT /SELECT It works beautifully so far, giving me a list of all the projects in my database. But I'd like it to default to a certain value from another query. So I added some more code: CFQUERY name=get_details datasource=datasource SELECT projectname FROM projects WHERE ID=[a certain value] /CFQUERY CFOUTPUT query=get_details SELECT name=project value=#projectname# /CFOUTPUT CFOUTPUT query=get_projects OPTION#projectname#/OPTION /CFOUTPUT /SELECT But it just doesn't work: it won't default to the value from the new query. Am I being a total moron? TIA, CK. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: setting a default value in my SELECT tag
You have to put some logic within the ouput tags that looks something line this CFOUTPUT query=get_projects OPTION#projectname# ciif ID EQ acertainvalue SELECTED/cfif/OPTION /CFOUTPUT On Aug 18, 2004, at 5:55 PM, Ewok wrote: try this on for size SELECT name=project CFOUTPUT query=get_projects OPTION value=#ID#cfif ID is get_details.ID selected/cfif#projectname#/OPTION /CFOUTPUT /SELECT - Original Message - From: Chris Kavanagh To: CF-Talk Sent: Wednesday, August 18, 2004 8:33 PM Subject: setting a default value in my SELECT tag Dear list, I'm sure there is a simple answer to this basic question. Sorry for being such a noob: I'm working on my first application! I hope to become a useful member of the CF community one day. But first you will have to put up with my stupid questions for a while. Stupid question the second: I have a select element in a form. The options are populated from a database. It looks a bit like this: CFQUERY name=get_projects datasource=datasource SELECT projectname FROM projects /CFQUERY ... SELECT name=project CFOUTPUT query=get_projects OPTION#projectname#/OPTION /CFOUTPUT /SELECT It works beautifully so far, giving me a list of all the projects in my database. But I'd like it to default to a certain value from another query. So I added some more code: CFQUERY name=get_details datasource=datasource SELECT projectname FROM projects WHERE ID=[a certain value] /CFQUERY CFOUTPUT query=get_details SELECT name=project value=#projectname# /CFOUTPUT CFOUTPUT query=get_projects OPTION#projectname#/OPTION /CFOUTPUT /SELECT But it just doesn't work: it won't default to the value from the new query. Am I being a total moron? TIA, CK. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOLVED: setting a default value in my SELECT tag
we all cringe at our first app(s) .. or atleast I hope WE do : ) glad to help and good luck! - Original Message - From: Chris Kavanagh To: CF-Talk Sent: Wednesday, August 18, 2004 9:05 PM Subject: SOLVED: setting a default value in my SELECT tag Dear Ewok, Thank you, you're a genius.I was just fumbling around the edges of that solution, but my way involved all kinds of CFSETs and stuff: using the scope is much more elegant. My first app is working quite nicely but I bet the code is flabby.I will probably look back on it and cringe one day. Thanks again. CK. On 19 Aug 2004, at 1:55 am, Ewok wrote: try this on for size SELECT name=project CFOUTPUT query=get_projects OPTION value=#ID#cfif ID is get_details.ID selected/cfif#projectname#/OPTION /CFOUTPUT /SELECT - Original Message - From: Chris Kavanagh To: CF-Talk Sent: Wednesday, August 18, 2004 8:33 PM Subject: setting a default value in my SELECT tag Dear list, I'm sure there is a simple answer to this basic question.Sorry for being such a noob: I'm working on my first application!I hope to become a useful member of the CF community one day.But first you will have to put up with my stupid questions for a while. Stupid question the second: I have a select element in a form.The options are populated from a database.It looks a bit like this: CFQUERY name=get_projects datasource=datasource SELECT projectname FROM projects /CFQUERY ... SELECT name=project CFOUTPUT query=get_projects OPTION#projectname#/OPTION /CFOUTPUT /SELECT It works beautifully so far, giving me a list of all the projects in my database.But I'd like it to default to a certain value from another query.So I added some more code: CFQUERY name=get_details datasource=datasource SELECT projectname FROM projects WHERE ID=[a certain value] /CFQUERY CFOUTPUT query=get_details SELECT name=project value=#projectname# /CFOUTPUT CFOUTPUT query=get_projects OPTION#projectname#/OPTION /CFOUTPUT /SELECT But it just doesn't work: it won't default to the value from the new query.Am I being a total moron? TIA, CK. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: blackstone, what would be sweet
what else would be sweet is auto queryparams ;) oh yeah a select all option on the damn extention manager they also should buy out MM exporter too build that into their products too and.. make a cf_smile tag 4 matt ;) (run in java of course) Ha! ... You scoff, but the onTap framework has auto queryparams... #request.tapi.sql.structToFilters(attributes)# attributes is the default, so it could also be request.tapi.sql.structToFilters() and it uses the old FB trick of copying form and url variables into the attributes scope (actually it's just a local structure, but the syntax is the same) to let you call a base template as a custom tag. This function is then used as the default set of filters for the sql.select() functions (several of them actually) so if you don't specify your own filters, it automatically filters on any variables passed in the form and url scope. Any filters without matching columns in the table are ignored. It's real handy for creating sortable list pages. Saves a lot of time that I would otherwise be manually copying lists of column names into the where clause of my queries. I'll see what I can do about the cf_smile tag. :P s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF @ MAX 2004
nice. i see you added blackstone event gateways as a session with jordahl.good stuff. also, great app to manage the schedule.much better than the old way to manage the schedule:choices to replace with, good idea! tw -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Lightweight CMS
All, I'm trying to help out a family member who is not at all Web savvy. They need to put together a Web site and I don't mind helping them set it up (I'm even donating the server space... aren't I nice?), but I don't want to deal with the many minor updates they're almost certainly going to be doing. Can anyone suggest an easy to use, free, Access-compatible CMS of some sort? Thanks! Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Lightweight CMS
Jake- You might try http://www.interactivetools.com/products/htmlarea/ I use it in my application, and acutally customized the Insert Hyperlink and Insert Image features (www.unrivaledwebhosting.com/demo/admin/ l: demo P: demo if you care to glance) The above link is free and easy to implement. - Joe All, I'm trying to help out a family member who is not at all Web savvy. They need to put together a Web site and I don't mind helping them set it up (I'm even donating the server space... aren't I nice?), but I don't want to deal with the many minor updates they're almost certainly going to be doing. Can anyone suggest an easy to use, free, Access-compatible CMS of some sort? Thanks! Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLACKSTONE: Software Development Times Article
LOL tony u can speak 4 me anytime, gives me more time to go fishin! cfset goodFlyFishingDay = weather EQ rain AND clouds EQ overcast AND season NEQ winter Syntax is a bit odd... not sure it will work that way, try this: cfset overcast = ran clouds cfif weather eq overcast and season neq winter cfset goodFlyFishingDay = true cfelse cfset goodFlyFishingDay = false /cfif :) s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]