RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Matt Liotta
 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

2004-08-18 Thread S . Isaac Dealey
 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)

2004-08-18 Thread Dick Applebaum
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

2004-08-18 Thread Alexander Sherwood
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...

2004-08-18 Thread Greg Morphis
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

2004-08-18 Thread Tangorre, Michael
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)

2004-08-18 Thread Matt Liotta
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

2004-08-18 Thread Matt Liotta
 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

2004-08-18 Thread CF Coder2
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

2004-08-18 Thread Brian Kotek
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

2004-08-18 Thread Donna French
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

2004-08-18 Thread Marc Lowe
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

2004-08-18 Thread G
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

2004-08-18 Thread Vince Bonfanti
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

2004-08-18 Thread G
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

2004-08-18 Thread Dick Applebaum
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

2004-08-18 Thread dcooper
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

2004-08-18 Thread Qasim Rasheed
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

2004-08-18 Thread Matt Liotta
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

2004-08-18 Thread CF Coder2
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

2004-08-18 Thread Dave Watts
 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)

2004-08-18 Thread Dick Applebaum
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

2004-08-18 Thread Matt Liotta
 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

2004-08-18 Thread dcooper
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

2004-08-18 Thread Dick Applebaum
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

2004-08-18 Thread Christian Watt
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

2004-08-18 Thread Marc Lowe
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

2004-08-18 Thread Mark Leder
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

2004-08-18 Thread Ray Champagne
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

2004-08-18 Thread Dick Applebaum
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

2004-08-18 Thread Christian Watt
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

2004-08-18 Thread Benjamin S. Rogers
 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

2004-08-18 Thread Ray Champagne
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

2004-08-18 Thread Dick Applebaum
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

2004-08-18 Thread Pete Freitag
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)

2004-08-18 Thread Donna French
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

2004-08-18 Thread Marc Lowe
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

2004-08-18 Thread Dave Watts
 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

2004-08-18 Thread Mark Holm
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

2004-08-18 Thread Qasim Rasheed
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

2004-08-18 Thread dan martin
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

2004-08-18 Thread Mark Leder
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

2004-08-18 Thread Mark Leder
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

2004-08-18 Thread Don
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

2004-08-18 Thread Claude Schneegans
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

2004-08-18 Thread joe velez
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

2004-08-18 Thread joe velez
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

2004-08-18 Thread Guy Rish
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

2004-08-18 Thread Guy Rish
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

2004-08-18 Thread joe velez
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

2004-08-18 Thread Ray Champagne
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

2004-08-18 Thread Dave Watts
 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

2004-08-18 Thread joe velez
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

2004-08-18 Thread joe velez
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

2004-08-18 Thread Barney Boisvert
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

2004-08-18 Thread Michael Smith
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

2004-08-18 Thread Pete Freitag
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?

2004-08-18 Thread Dharmesh Goel
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

2004-08-18 Thread CF Coder2
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

2004-08-18 Thread CF Coder2
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

2004-08-18 Thread Paul Vernon
Use cfqueryparam...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: SOLVED: Re: Log file reader

2004-08-18 Thread Dick Applebaum
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

2004-08-18 Thread Ben Doom
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

2004-08-18 Thread Ewok
...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

2004-08-18 Thread Dick Applebaum
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

2004-08-18 Thread Ray Champagne
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

2004-08-18 Thread CF Coder2
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?

2004-08-18 Thread Chris Kavanagh
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

2004-08-18 Thread CF Coder2
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?

2004-08-18 Thread Matthew Walker
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?

2004-08-18 Thread Michael Dinowitz
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

2004-08-18 Thread joe velez
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

2004-08-18 Thread Barney Boisvert
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

2004-08-18 Thread Bryan Stevenson
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?

2004-08-18 Thread Chris Kavanagh
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

2004-08-18 Thread Matt Robertson
 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

2004-08-18 Thread Matthew Walker
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

2004-08-18 Thread CF Coder2
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

2004-08-18 Thread Barney Boisvert
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

2004-08-18 Thread Bob Haroche
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

2004-08-18 Thread Sung Woo
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

2004-08-18 Thread CF Coder2
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

2004-08-18 Thread dave
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

2004-08-18 Thread Barney Boisvert
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

2004-08-18 Thread CF Coder2
Thanks, Barney! Now it makes sense!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




CF @ MAX 2004

2004-08-18 Thread dcooper
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

2004-08-18 Thread Chris Kavanagh
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

2004-08-18 Thread dave
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

2004-08-18 Thread Mark Henderson
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

2004-08-18 Thread Ewok
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

2004-08-18 Thread Ewok
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

2004-08-18 Thread Ewok
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

2004-08-18 Thread Chris Kavanagh
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

2004-08-18 Thread Dick Applebaum
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

2004-08-18 Thread Ewok
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

2004-08-18 Thread S . Isaac Dealey
 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

2004-08-18 Thread Tony Weeg
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

2004-08-18 Thread Jake
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

2004-08-18 Thread joe velez
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

2004-08-18 Thread S . Isaac Dealey
 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]




<    1   2   3   >