date:20040818

On Tuesday 17 Aug 2004 17:57 pm, Burns, John D wrote:
 They want to be able to download the database, take it to a conference
 offline, manipulate the data some and then re-upload the database and
 have CF use the data.I know there are other worries then with people

You could use MySQL, and then the windows people access it through ODBC (in 
Access), then when they get back, just copy the db files back.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: BLACKSTONE: Software Development Times Article

On Tuesday 17 Aug 2004 15:31 pm, Matt Liotta wrote:
 Compare this with an event gateway, which is still undefined, 

cough
Speak for yourself.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: BLACKSTONE: Software Development Times Article

 Matt, don't you realize that the event gateway IS external Java
 invocation of CFCs?I remember you complaining about not being able
 to to this without really digging really deep and that it really
 wasn't recommened due to its fragile and tricky nature. Isn't nice
 that MM has provided a public, documented and fully supported API for
 interacting with CFMX via extenal Java code?
 
I don't believe the event gateway and Java invocation of CFCs is the same
thing. There should be an easy way to call CFCs from Java and my
understanding is that Blackstone will have it. The event gateway it seems
will be at a higher level constraining you to a framework Macromedia
designed.

 Sure, the event gateway is not the most wiz-bang feature in store, but
 decoupling CFMX from the HTTP protocol (not the browser) and making
 that lower level interaction simple and accessible is a very important
 change.
 
If you have Java invocation of CFCs then you don't have to be tied to the
HTTP protocol anyway. Again, the event gateway is not required for all the
use cases people keep mentioning.

 Think about this... don't like the way CFMX handles webservices?
 Thinks its buggy and a pain to use?Just don't want to use Axis
 because you have a better idea? Write your own event gateway for
 webservices and that utilizes some other SOAP engine.Want to
 implement SOAP via SMTP which CF doesn't really do?Write your own
 gateway.
 
Again, with Java invocation of CFCs you could do just that. What about the
event gateway makes it better?

 Come on Matt.Java's great, but why bother with it if you don't have
 to... especially if you can do it easier in CF?
 
Again, if the built-in event gateways don't do what you want you still need
to use Java to build them, so that isn't really an argument.

-Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Thane Sherrington

At 03:53 PM 8/17/2004, Joe Rinehart wrote:
I think you left off my favorite:

CFWRITEMYAPPLICATIONFORME

I start every program with:

CFSetErrorsOff
CFDoWhatIMeant

T
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: BLACKSTONE: Software Development Times Article

 Blackstone will ship with a number of out-of-the-box gateways that
 connect to a number of protocols - meaning ColdFusion developers don't
 need to write them. That in itself is a win.
 
Agreed, but Macromedia could have supplied protocol handlers without
building an event gateway. Instead, they went and built a framework that
constrains what an event gateway is and can do. That could be a really good
thing or it could be a really bad thing. Time will tell, but so far
frameworks have always been done better in the community.

 Blackstone also provides an easy-to-use basic framework for such
 gateways to run inside, wired into the CF Admin. Ease of management is
 another win.

What is managed exactly? If it is anything like the web service management
you find now then no thanks.

-Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Tony Weeg

is the underlying factor here some problem with how BD wont be able to
piggyback the event gateway or use it or steal it?

must be something like this, or else i dont think matt's panties would
be in a bunch like this...they only tend to get into this sorta snag
when something like this is happening...

On Wed, 18 Aug 2004 08:24:06 -0400, Matt Liotta [EMAIL PROTECTED] wrote:
  Blackstone will ship with a number of out-of-the-box gateways that
  connect to a number of protocols - meaning ColdFusion developers don't
  need to write them. That in itself is a win.
  
 Agreed, but Macromedia could have supplied protocol handlers without
 building an event gateway. Instead, they went and built a framework that
 constrains what an event gateway is and can do. That could be a really good
 thing or it could be a really bad thing. Time will tell, but so far
 frameworks have always been done better in the community.
 
  Blackstone also provides an easy-to-use basic framework for such
  gateways to run inside, wired into the CF Admin. Ease of management is
  another win.
 
 What is managed exactly? If it is anything like the web service management
 you find now then no thanks.
 
 -Matt
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

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

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 On Behalf Of Tony Weeg
 Sent: Wednesday, August 18, 2004 8:46 AM
 To: CF-Talk
 Subject: Re: BLACKSTONE: Software Development Times Article
 
 is the underlying factor here some problem with how BD wont be able to
 piggyback the event gateway or use it or steal it?
 
 must be something like this, or else i dont think matt's panties would
 be in a bunch like this...they only tend to get into this sorta snag
 when something like this is happening...
 
 
 
 On Wed, 18 Aug 2004 08:24:06 -0400, Matt Liotta [EMAIL PROTECTED] wrote:
   Blackstone will ship with a number of out-of-the-box gateways that
   connect to a number of protocols - meaning ColdFusion developers don't
   need to write them. That in itself is a win.
  
  Agreed, but Macromedia could have supplied protocol handlers without
  building an event gateway. Instead, they went and built a framework that
  constrains what an event gateway is and can do. That could be a really
 good
  thing or it could be a really bad thing. Time will tell, but so far
  frameworks have always been done better in the community.
 
   Blackstone also provides an easy-to-use basic framework for such
   gateways to run inside, wired into the CF Admin. Ease of management is
   another win.
  
  What is managed exactly? If it is anything like the web service
 management
  you find now then no thanks.
 
  -Matt
 
 
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: wwokey hole was Re: cf tree menu

On Monday 16 Aug 2004 16:38 pm, S. Isaac Dealey wrote:
  Wookey Hole Road, WELLS. BA5 1AF
 I love that your office is in a place called Wookey Hole. :)

I've still not managed to come up with some sort of of Star Wars joke about 
it... :-)

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Count Online Users Conundrum

2004-08-18 Thread Sung Woo

Hi Ryan,

Here are my results:

4
12
14
10
11
15
8
5
3
8
10
12
10
7
4
13
14
14
14
13
15
7
6
3
12
0
6
11
5
6
11
4
4
12
6
11
4
4
11
6
14
13
15
10
9
9
3
15
9
6
2
12
9
10
13
8
11
5
3
13
3
3
3
2
2
4
2
2
5
2
2
12
3
2
4
9
2
15
4
7
2
9
6
10
1
5
14
1
1
13
8
11
14
14
1
1
15
6
9
4
8
5
7
1
1
1
1
6
1
12
0
0
0
0
0
0
8
0
5
0
0
7
0
0
4
10
6
8
4
14
9
10
3
13
15
7
12
9
8
7
5
7
15
8
10
11
8
13
13

This is as of 9AM today.Seems like the values are good right now (all unde 15 minutes).Thanks for the script -- I'll run it again later at night and post the results.

- Sung

I think you have a situation where the sessions are staying active long
after the user logs off.Run that loop and let me know what you get
back.Your problem will probably be obvious then. 

Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Count Online Users Conundrum

2004-08-18 Thread Sung Woo

Ray, is there any way I could streamline the locks?This is in the application.cfm page, so it's being hit quite often, and I'd like it to be as efficient as possible.Thanks!

- Sung

Not that it helps much, but that is some pretty awful code. The locks
are too much and the code generating cfid seems quite wack.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Consuming CFC web methods in VB.NET

2004-08-18 Thread Adam Haskell

I've always contended that sending anything over a webservice other
than simple values is going to get you in trouble. Even in CF - CF
communications I think sending anything other than text is asking for
trouble. I recomend using one of the many functions on cflib.org to
convert the complex objects to xml.
http://www.cflib.org/udf.cfm?ID=648

Antother option would be to generate a WDDX packet and return that but
you'll need something like
http://www.topxml.com/code/default.asp?p=3id=v20020829124758ms=20l=dotnetsw=categ
 to deal with WDDX in .Net I think.

Adam H

On Wed, 18 Aug 2004 10:20:00 +0100, Craig Dudley [EMAIL PROTECTED] wrote:
 ..NET just doesn't understand the return type, it probably could if you
 wrote some sort of QueryBean handler but I'd try returning a more simple
 data type, maybe you could encode the query into an xml packet and
 return that? Or try and array?
 
 -Original Message-
 From: Steven Brownlee [mailto:[EMAIL PROTECTED]
 Sent: 18 August 2004 10:07
 To: CF-Talk
 Subject: Consuming CFC web methods in VB.NET
 
 This is my last stab at this problem. No other message boards have been
 able to help me.
 
 First, the code...
 
 getPlaylist.cfc
 
 cffunction access=remote name=getNewPlaylist output=no
 returntype=query
 cfargument name=clientID type=string required=yes
 
 cfquery ... name=IMPlaylist
  removed for space saving...
 /cfquery
 
 cfif IMPlaylist.recordCount gt 0
 cfoutput query=IMPlaylist
 cfquery datasource=clp_dyn_signs dbtype=odbc username=...
 password=...
 .. Removed for space saving
 /cfquery
 /cfoutput
 cfreturn IMPlaylist
 /cfif
 
 /cffunction
 
 
 frmMain.vb
 
 Dim MyService As getPlaylist.getPlaylistService = New
 getPlaylist.getPlaylistService
 Dim MyResult As getPlaylist.QueryBean
 
 Try
MyResult = MyService.getNewPlaylist(xmlParser.ClientID)
 Catch ex As Exception
Me.txtHistory.Text += Error calling playListExists function ( 
 ex.Message  ) + vbCrLf
Log.AppendLog(Error calling playListExists function (  ex.Message
  ))
 End Try
 
 
 Now the getPlaylist.cfc works fine from the Flash Remoting application
 that was built for this client, but when trying to get the query into
 VB.NET, the following error is returned
 
 org.apache.axis.AxisFault : ; nested exception is:
 coldfusion.xml.rpc.CFCInvocationException:
 [coldfusion.runtime.UDFMethod$InvalidReturnTypeException : The value
 returned from function getNewPlaylist() is not of type query.][]; nested
 exception is:
 coldfusion.xml.rpc.CFCInvocationException: [org.apache.axis.AxisFault :
 ; nested exception is:
 coldfusion.xml.rpc.CFCInvocationException:
 [coldfusion.runtime.UDFMethod$InvalidReturnTypeException : The value
 returned from function getNewPlaylist() is not of type query.][])
 
 
 It does return a query (or QueryBean as XML sees it) and everything is
 types correctly in the .NET code.I also put in a test function that
 just returned some dummy text to see if I was able to properly invoke
 functions of a CFC web method and it worked fine.Just seems to be
 choking on sending back a query.
 
 I know this is a convoluted question, so if anyone has had experience
 using CFC methods in .NET, I'd appreciate any help.
 
 Steven Brownlee
 [EMAIL PROTECTED]
_
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Micha Schopman

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: BLACKSTONE: Software Development Times Article

 Think about this... don't like the way CFMX handles
 webservices?
 Thinks its buggy and a pain to use?Just don't want to
 use Axis
 because you have a better idea? Write your own event
 gateway for
 webservices and that utilizes some other SOAP engine.
 Want to
 implement SOAP via SMTP which CF doesn't really do?
 Write your own
 gateway.

 Again, with Java invocation of CFCs you could do just
 that. What about the
 event gateway makes it better?

Like all things CF, it's more accessible to people who aren't Java
experts.

After all, a structure is just a Java object. So what makes CF
structures any better than using the underlying Java object (which is
also available to us)?

As to the cf-admin -- I haven't needed webservices for anything I've
worked on yet, but as a rule, I prefer things to not be in the
CF-Admin... If I could get DSN-less connections with CFMX, I'd be all
over it.

Frameworks designed better in the community: yes and no. Although I
haven't used cflogin yet, I'm not about to rewrite the application
framework.

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: blackstone, what would be sweet

 Hrm...for some reason I just connected scripts to SQL
 injection and
 HTML to insertion of, well, tags (including script).

 I was probably misunderstanding the context...but I think
 you
 understood what I meant :).

 -joe

Yea, I figured it out about half-way through composing my last reply.
:)

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: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Tony Weeg

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.

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: BLACKSTONE: Software Development Times Article

 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.

And with that... Tony single handedly silenced the list.LOL
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Consuming CFC web methods in VB.NET

2004-08-18 Thread Dave Watts

 This is my last stab at this problem. No other message boards have 
 been able to help me.

 ...
 
 cffunction access=remote name=getNewPlaylist output=no
 returntype=query ...

You won't be able to consume CF query objects from .NET, I don't think.
There's no SOAP-specific or XML Schema-specific definition of a query
object. You can use something else instead, though.

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: Count Online Users Conundrum

2004-08-18 Thread Tim Blair

Sung,

 What happens is that at the end of the day (I run an intranet where
there
 are about 200 peak users), around midnight, it still shows 80 or so
users
 online!What do you think could be causing this?

Does the code you run to report on the user sessions run the code you
posted first?By this I mean does it run through and clear any old
sessions out before reporting how many are still there?

What the code you posted does (badly) is record a timestamp of when a
new session is started, for each user session (although the CFID is by
no means guaranteed to be unique), and then deleting any over 15
minutes.So every session will remain there for 15 minutes (or until
the first page call that runs the skimmer code after the 15 minute limit
has expired) and then be deleted.If the user is still using the
system, they will simply be added back in the next time they access a
page, with a new 15 minute count.

Therefore, at the end of the day, if there are no page calls made
between 5:30 and midnight, all sessions will still be held in memory,
because the skimmer hasn't been run.I would say that's why you're
still leeing lots of users on line at midnight.

I'd like to ask what you're actually attempting to do with this code.
If it's to see how many people are using the system within the last 15
minutes and how long they've been using the application for, then this
code certainly doesn't do that, or at most does a very bad job of it.
What you'll need to do is add *two* timestamps to each user -- one for
when they first accessed the system, and one when they last requested a
page.Your 15 minute check should then use the difference between
these values to determine whether the user has been inactive for 15
minutes.

As for Ray's comment of but that is some pretty awful code I
completely agree.I've attempted to go through it somewhat below
code-block by code-block -- not changing any of the existing
functionality, but just cleaning it up -- with explanations of what I've
done and why.

 cflock timeout=15 scope=APPLICATION type=EXCLUSIVE
cfif NOT isDefined(Application.UsersInfo)
cfset Application.UsersInfo = StructNew()
/cfif
 /cflock

Since CFMX (I'm assuming you're using MX?), you don't have to worry
about locking shared scopes for reading only, so there's no need to lock
everything as you have done.Put another cfif around so you only lock
when absolutely necessary.Keeping the original cfif in there just
makes sure that should two requests happen fairly closely, that only one
initialises the new structure.

cfif NOT isDefined(Application.UsersInfo)
 cflock timeout=15 scope=APPLICATION type=EXCLUSIVE
cfif NOT isDefined(Application.UsersInfo)
cfset Application.UsersInfo = StructNew()
/cfif
 /cflock
/cfif

 cflock name=#CreateUUID()# timeout=15 type=EXCLUSIVE
 cfset user_cfid = Evaluate(CFID)
 cfset user_time = Now()
 /cflock

This is a totally pointless lock.You're not writing to (or even
reading from) any shared scope.Additionally, you're using a randomly
generated lock ID so even if you were writing to a shared scope there's
nothing to stop two requests happening simultaneously, because they are
guaranteed to have different lock IDs!

Secondly, I'm not sure why you're using an evaluate() call where you
are, it doesn't do anything except add another function call.The
user's CFID is available anywhere and won't change so there's no need to
reference that as anything different.The user_time variable is only
actually used once, so why not just replace it with the now() call?In
effect, you don't need this section at all.

 cflock scope=APPLICATION type=EXCLUSIVE timeout=15
cfif NOT StructKeyExists(Application.UsersInfo, user_cfid)
cfset temp = StructInsert(Application.UsersInfo, user_cfid,
user_time)
/cfif
 /cflock

Again, as in the first section, there's no need to lock for a read, so
add another cfif statement around the outside of this section.
Replace the user_cfid with CFID and the user_time with now() as
described above.Finally, you don't have to assign the result of the
structinsert() call -- it just means another variable clogging up memory
during the page request:

cfif NOT StructKeyExists(Application.UsersInfo, CFID)
 cflock scope=APPLICATION type=EXCLUSIVE timeout=15
cfif NOT StructKeyExists(Application.UsersInfo, CFID)
cfset StructInsert(Application.UsersInfo, CFID, now())
/cfif
 /cflock
/cfif

 cflock scope=APPLICATION type=EXCLUSIVE timeout=15
cfloop collection=#Application.UsersInfo# item=itmUser
cfif
 Evaluate(DateDiff(n, StructFind(Application.UsersInfo, itmUser),
Now())) GT 15

cfset StructDelete(Application.UsersInfo, itmUser)
/cfif
/cfloop
 /cflock

Now this is the sort of block where everyone's opinions will diverge
somewhat.Some will say lock outside the loop, other will say only lock
when deleting.Only locking when deleting will make the code cleaner,
but *may* leave you open to race conditions where two instances of the
script are running at the same time and try to read and delete from the
same

SQL Query problem

This is giving me fits.In a membership listing, each member could have
many transactions (one to many relationship). I want to retrieve each member
ID, and their corresponding most recent (MAX) transactionID.The memberID
joins the two tables.

I've tried several ways without success. The statement below below returns
ALL the transaction records for any given individual member, not just the
most recent transactionID.What am I doing wrong?

SELECT M.firstName, M.middleName, M.lastName, M.email, M.company, M.city,
M.zip, M.memberID, M.memberLevelID
FROM #REQUEST.prefix#_Members_List M
WHERE M.memberID =
	(SELECT MAX(T.transactionID) AS transactionID, T.paidThru,
T.transactionDate,T.memberID) 
	FROM #REQUEST.prefix#_Members_TransactionLog T 
	WHERE T.memberID = M.memberID) AND 
	
...more filters ...

GROUP BY M.memberID, M.firstName, M.middleName, M.lastName, M.email,
M.company, M.city, M.zip, M.memberLevelID, T.paidThru, T.transactionDate,
T.memberID 

ORDER BY M.lastName
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Datasource info from CF5

2004-08-18 Thread Hays, Duncan

Still using CF5 here and in the CF admin page that lists our native
datasources I would also like to see the host string or server variable so
that we can know at a glance what db the DSN is connecting to. Does anyone
know the name of the query that is generating this list? Or some other way
to get this info?

Thanks

Duncan Hays
Peace Corps
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: BLACKSTONE: Software Development Times Article

At 09:56 AM 8/18/2004, you wrote:
 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.

And with that... Tony single handedly silenced the list.LOL

Nope.

If the gateway doesn't support FuseBox 4.5 circuits and the FLiP process (not to mention .qry and .dsp files), then MACR should go with Mach-II listeners.

Mach-II is really the best choice to build the forthcoming remote Java -- CFC invocation event-based gateway, by far.

--
True
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: SQL Query problem

At 10:00 AM 8/18/2004, you wrote:
This is giving me fits.In a membership listing, each member could have
many transactions (one to many relationship). I want to retrieve each member
ID, and their corresponding most recent (MAX) transactionID.The memberID
joins the two tables.

I've tried several ways without success. The statement below below returns
ALL the transaction records for any given individual member, not just the
most recent transactionID.What am I doing wrong?

SELECT M.firstName, M.middleName, M.lastName, M.email, M.company, M.city,
M.zip, M.memberID, M.memberLevelID
FROM #REQUEST.prefix#_Members_List M
WHERE M.memberID =

Looks like you're trying to join a MemberID on a TransactionID?

(SELECT MAX(T.transactionID) AS transactionID, T.paidThru,
T.transactionDate,T.memberID) 
FROM #REQUEST.prefix#_Members_TransactionLog T 
WHERE T.memberID = M.memberID) AND 

...more filters ...

GROUP BY M.memberID, M.firstName, M.middleName, M.lastName, M.email,
M.company, M.city, M.zip, M.memberLevelID, T.paidThru, T.transactionDate,
T.memberID
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Charlie Griefer

I'm more silenced at the notion of Tony representing the soft spoken:)

(but while there is a short silence, I'm going to throw in a soft spoken 
request that this thread move to community?)

Alexander Sherwood wrote:

At 09:56 AM 8/18/2004, you wrote:


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.


And with that... Tony single handedly silenced the list.LOL
 



Nope.

If the gateway doesn't support FuseBox 4.5 circuits and the FLiP process (not to mention .qry and .dsp files), then MACR should go with Mach-II listeners.

Mach-II is really the best choice to build the forthcoming remote Java -- CFC invocation event-based gateway, by far.

--
True 



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: One More Stupid Query Question

2004-08-18 Thread Damien McKenna

On Aug 17, 2004, at 11:42 PM, Les Mizzell wrote:
 SELECT * FROM news_pr
 Where Headline like '%#var1#%'
 or BodyText like '%#var2#%'
 or tagline like '%#var3#%'
 and pr_status='Active'
 and Year(pr_date) = #FORM.pubDATE#
 order by pr_date desc

Make sure you are cleaning those variables before you run the query, 
you don't want someone sticking in ';drop table users; in there.
-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
Nothing endures but change. - Heraclitus
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: wwokey hole was Re: cf tree menu

 On Monday 16 Aug 2004 16:38 pm, S. Isaac Dealey wrote:
  Wookey Hole Road, WELLS. BA5 1AF
 I love that your office is in a place called Wookey
 Hole. :)

 I've still not managed to come up with some sort of of
 Star Wars joke about
 it... :-)

Oh come on, they had a Wookey (it's not spelled right, oh well) in the
cock-pit of the Millenium Falcon... didn't that qualify then as a
wookey hole? They need protection. Good thing the Falcon had shields.
:P

Yes, they're attrocious, but they _are_ Star Wars jokes. :)

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: SQL Query problem

MemberID from the members table corresponds to the memberID in the
transaction table.So I must be writing the join wrong?

_

From: Alexander Sherwood [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 18, 2004 10:02 AM
To: CF-Talk
Subject: Re: SQL Query problem

At 10:00 AM 8/18/2004, you wrote:
This is giving me fits.In a membership listing, each member could have
many transactions (one to many relationship). I want to retrieve each
member
ID, and their corresponding most recent (MAX) transactionID.The memberID
joins the two tables.

I've tried several ways without success. The statement below below returns
ALL the transaction records for any given individual member, not just the
most recent transactionID.What am I doing wrong?

SELECT M.firstName, M.middleName, M.lastName, M.email, M.company, M.city,
M.zip, M.memberID, M.memberLevelID
FROM #REQUEST.prefix#_Members_List M
WHERE M.memberID =

Looks like you're trying to join a MemberID on a TransactionID?

(SELECT MAX(T.transactionID) AS transactionID, T.paidThru,
T.transactionDate,T.memberID) 
FROM #REQUEST.prefix#_Members_TransactionLog T 
WHERE T.memberID = M.memberID) AND 

...more filters ...

GROUP BY M.memberID, M.firstName, M.middleName, M.lastName, M.email,
M.company, M.city, M.zip, M.memberLevelID, T.paidThru, T.transactionDate,
T.memberID 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: One More Stupid Query Question

2004-08-18 Thread Jochem van Dieten

Les Mizzell wrote:
 
 SELECT * FROM news_pr
 Where Headline like '%#var1#%'
 or BodyText like '%#var2#%'
 or tagline like '%#var3#%'
 and pr_status='Active'
 and Year(pr_date) = #FORM.pubDATE#
 order by pr_date desc
 
 
 However, if I enter 1998 in the form, it's still returning results 
 from other years...
 
 So, what's wrong with this?

What happens if var2 is empty?

Also, please use cfqueryparam.

Jochem
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Count Online Users Conundrum

2004-08-18 Thread Sung Woo

Hi Tim,

Thanks so much for the breakdown.I got the code from easycfm.com and didn't think to really analyze it.I'll make the changes you suggested and let you know if I run into anything.Thanks again!

- Sung

Sung,

 What happens is that at the end of the day (I run an intranet where
there
 are about 200 peak users), around midnight, it still shows 80 or so
users
 online!What do you think could be causing this?

Does the code you run to report on the user sessions run the code you
posted first?By this I mean does it run through and clear any old
sessions out before reporting how many are still there?

What the code you posted does (badly) is record a timestamp of when a
new session is started, for each user session (although the CFID is by
no means guaranteed to be unique), and then deleting any over 15
minutes.So every session will remain there for 15 minutes (or until
the first page call that runs the skimmer code after the 15 minute limit
has expired) and then be deleted.If the user is still using the
system, they will simply be added back in the next time they access a
page, with a new 15 minute count.

Therefore, at the end of the day, if there are no page calls made
between 5:30 and midnight, all sessions will still be held in memory,
because the skimmer hasn't been run.I would say that's why you're
still leeing lots of users on line at midnight.

I'd like to ask what you're actually attempting to do with this code.
If it's to see how many people are using the system within the last 15
minutes and how long they've been using the application for, then this
code certainly doesn't do that, or at most does a very bad job of it.
What you'll need to do is add *two* timestamps to each user -- one for
when they first accessed the system, and one when they last requested a
page.Your 15 minute check should then use the difference between
these values to determine whether the user has been inactive for 15
minutes.

As for Ray's comment of but that is some pretty awful code I
completely agree.I've attempted to go through it somewhat below
code-block by code-block -- not changing any of the existing
functionality, but just cleaning it up -- with explanations of what I've
done and why.

 cflock timeout=15 scope=APPLICATION type=EXCLUSIVE
cfif NOT isDefined(Application.UsersInfo)
cfset Application.UsersInfo = StructNew()
/cfif
 /cflock

Since CFMX (I'm assuming you're using MX?), you don't have to worry
about locking shared scopes for reading only, so there's no need to lock
everything as you have done.Put another cfif around so you only lock
when absolutely necessary.Keeping the original cfif in there just
makes sure that should two requests happen fairly closely, that only one
initialises the new structure.

cfif NOT isDefined(Application.UsersInfo)
 cflock timeout=15 scope=APPLICATION type=EXCLUSIVE
cfif NOT isDefined(Application.UsersInfo)
cfset Application.UsersInfo = StructNew()
/cfif
 /cflock
/cfif

 cflock name=#CreateUUID()# timeout=15 type=EXCLUSIVE
 cfset user_cfid = Evaluate(CFID)
 cfset user_time = Now()
 /cflock

This is a totally pointless lock.You're not writing to (or even
reading from) any shared scope.Additionally, you're using a randomly
generated lock ID so even if you were writing to a shared scope there's
nothing to stop two requests happening simultaneously, because they are
guaranteed to have different lock IDs!

Secondly, I'm not sure why you're using an evaluate() call where you
are, it doesn't do anything except add another function call.The
user's CFID is available anywhere and won't change so there's no need to
reference that as anything different.The user_time variable is only
actually used once, so why not just replace it with the now() call?In
effect, you don't need this section at all.

 cflock scope=APPLICATION type=EXCLUSIVE timeout=15
cfif NOT StructKeyExists(Application.UsersInfo, user_cfid)
cfset temp = StructInsert(Application.UsersInfo, user_cfid,
user_time)
/cfif
 /cflock

Again, as in the first section, there's no need to lock for a read, so
add another cfif statement around the outside of this section.
Replace the user_cfid with CFID and the user_time with now() as
described above.Finally, you don't have to assign the result of the
structinsert() call -- it just means another variable clogging up memory
during the page request:

cfif NOT StructKeyExists(Application.UsersInfo, CFID)
 cflock scope=APPLICATION type=EXCLUSIVE timeout=15
cfif NOT StructKeyExists(Application.UsersInfo, CFID)
cfset StructInsert(Application.UsersInfo, CFID, now())
/cfif
 /cflock
/cfif

 cflock scope=APPLICATION type=EXCLUSIVE timeout=15
cfloop collection=#Application.UsersInfo# item=itmUser
cfif
 Evaluate(DateDiff(n, StructFind(Application.UsersInfo, itmUser),
Now())) GT 15

cfset StructDelete(Application.UsersInfo, itmUser)
/cfif
/cfloop
 /cflock

Now this is the sort of block where everyone's opinions will diverge
somewhat.Some will say lock outside the loop, other will say only lock
when

Query from within a cfscript

I'm trying to do a CFQuery from within a cfscript and it's not working.I'm using the latest CFMX 6.1 and I'm basing my code off of this article:

http://www.macromedia.com/devnet/mx/coldfusion/extreme/cftags_cfscript.html

However, when I call my function I the following error:

Variable CFQUERY is undefined.

Any ideas?

Thanks,

-- 
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion applications
 Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Query from within a cfscript

Post the code.

 Any ideas?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: BLACKSTONE: Software Development Times Article

 If the gateway doesn't support FuseBox 4.5 circuits and
 the FLiP process (not to mention .qry and .dsp files),
 then MACR should go with Mach-II listeners.

 Mach-II is really the best choice to build the forthcoming
 remote Java -- CFC invocation event-based gateway, by
 far.

Ummm... no...

Macromedia should do nothing to support any framework whether it's FB,
Mach-II, the onTap framework or anything else. They should build
ColdFusion to support (gasp!) ColdFusion and let us figure out how to
translate that into something we can use in our independent
frameworks.

The best choice to build the forthcoming remote Java -- CFC
invocation event-based gateway by far is Java and CFC's.

I'm pretty sure Macromedia sees it this way as well.

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: Query from within a cfscript

2004-08-18 Thread Greg Stewart

Hi,
Could you post your code? 

In the meantime, here is how I went about it:
http://gregs.tcias.co.uk/cold_fusion/outputting_queries_with_cfscript.php

I based it on the same example but opted for placing the query in a
CFC and invoking it using CreateObject();

Hope this helps a little
G

On Wed, 18 Aug 2004 10:20:36 -0400, Howie Hamlin [EMAIL PROTECTED] wrote:
 I'm trying to do a CFQuery from within a cfscript and it's not working.I'm using the latest CFMX 6.1 and I'm basing my code off of this article:
 
 http://www.macromedia.com/devnet/mx/coldfusion/extreme/cftags_cfscript.html
 
 However, when I call my function I the following error:
 
 Variable CFQUERY is undefined.
 
 Any ideas?
 
 Thanks,
 
 --
 Howie Hamlin - inFusion Project Manager
 On-Line Data Solutions, Inc. - www.CoolFusion.com
 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
 PrismAV - Virus scanning for ColdFusion applications
  Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Query from within a cfscript

Here is the code (it's supposed to log to a table):

CFSCRIPT

function CSLog(CustomerID,Category,SubCategory,I0,I1,I2,I3,I4,Description){
try{
SQLString = Insert into Log (Category,SubCategory,I0,I1,I2,I3,I4,Description,When) Values 
(#Arguments.Category#,#Arguments.SubCategory#,'#Arguments.I0#','#Arguments.I1#',#Arguments.I2#',#Arguments.I3#',#Arguments.I4#',#Arguments.Description#',#CreateODBCDateTime(now())#);
DATASOURCE = C12391;
LogQ=CFQUERY(SQLString: SQLString, DATASOURCE: DATASOURCE);
}
catch(Any excpt)
{
WriteOutput(Exception: #excpt.Message#);
 }
}

/CFSCRIPT

And, here is my test template:

cfinclude template=log.cfm
cfset dummy=CSLog(1,1,1,'I0','I1','I2','I3','I4','Description')

Thanks,

Howie



- Original Message - 
From: Tangorre, Michael 
To: CF-Talk 
Sent: Wednesday, August 18, 2004 10:29 AM
Subject: RE: Query from within a cfscript

Post the code.

 Any ideas?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Count Online Users Conundrum

2004-08-18 Thread Tim Blair

One thing:

 What you'll need to do is add *two* timestamps to each user -- one for
 when they first accessed the system, and one when they last requested
a
 page.Your 15 minute check should then use the difference between
 these values to determine whether the user has been inactive for 15
 minutes.

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().

Tim.

--
---
Badpen Tech - CF and web-tech: http://tech.badpen.com/
---
RAWNET LTD - Internet, New Media and ebusiness Gurus.
WE'VE MOVED - for our new address, please visit our
website at http://www.rawnet.com/ or call us any time
on 0800 294 24 24.
---
This message may contain information which is legally
privileged and/or confidential.If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Query from within a cfscript

Yes, this helps somewhat but I'd really like to get the whole thing wrapped up in one function call.All the code is supposed to do is write information to a logging table so it should really be simple.

Thanks,

Howie
- Original Message - 
From: Greg Stewart 
To: CF-Talk 
Sent: Wednesday, August 18, 2004 10:29 AM
Subject: Re: Query from within a cfscript

Hi,
Could you post your code? 

In the meantime, here is how I went about it:
http://gregs.tcias.co.uk/cold_fusion/outputting_queries_with_cfscript.php

I based it on the same example but opted for placing the query in a
CFC and invoking it using CreateObject();

Hope this helps a little
G
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: BLACKSTONE: Software Development Times Article

On Wednesday 18 Aug 2004 14:34 pm, S. Isaac Dealey wrote:
 CF-Admin... If I could get DSN-less connections with CFMX, I'd be all
 over it.

Umm, you can, with the service factory java objects...

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Brian Kotek

What are you talking about? If you're being serious, this doesn't make
any sense at all. If you're joking, it's not funny.

- Original Message -
From: Alexander Sherwood [EMAIL PROTECTED]
Date: Wed, 18 Aug 2004 10:00:05 -0400
Subject: RE: BLACKSTONE: Software Development Times Article
To: CF-Talk [EMAIL PROTECTED]

At 09:56 AM 8/18/2004, you wrote:
 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.

And with that... Tony single handedly silenced the list.LOL

Nope.

If the gateway doesn't support FuseBox 4.5 circuits and the FLiP
process (not to mention .qry and .dsp files), then MACR should go with
Mach-II listeners.

Mach-II is really the best choice to build the forthcoming remote Java
-- CFC invocation event-based gateway, by far.

--
True
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Query from within a cfscript

2004-08-18 Thread Adrian Lynch

Have you got a function of your own called CFQuery()?

Ade

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: 18 August 2004 15:31
To: CF-Talk
Subject: Re: Query from within a cfscript

Here is the code (it's supposed to log to a table):

CFSCRIPT

function CSLog(CustomerID,Category,SubCategory,I0,I1,I2,I3,I4,Description){
try{
SQLString = Insert into Log
(Category,SubCategory,I0,I1,I2,I3,I4,Description,When) Values

(#Arguments.Category#,#Arguments.SubCategory#,'#Arguments.I0#','#Arguments.I
1#',#Arguments.I2#',#Arguments.I3#',#Arguments.I4#',#Arguments.Description#'
,#CreateODBCDateTime(now())#);
DATASOURCE = C12391;
LogQ=CFQUERY(SQLString: SQLString, DATASOURCE: DATASOURCE);
}
catch(Any excpt)
{
WriteOutput(Exception: #excpt.Message#);
 }
}

/CFSCRIPT

And, here is my test template:

cfinclude template=log.cfm
cfset dummy=CSLog(1,1,1,'I0','I1','I2','I3','I4','Description')

Thanks,

Howie



- Original Message -
From: Tangorre, Michael
To: CF-Talk
Sent: Wednesday, August 18, 2004 10:29 AM
Subject: RE: Query from within a cfscript

Post the code.

 Any ideas?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: BLACKSTONE: Software Development Times Article

 Like all things CF, it's more accessible to people who aren't Java
 experts.
 
Writing an event gateway requires knowledge of Java therefore yours is not a
valid argument.

 After all, a structure is just a Java object. So what makes CF
 structures any better than using the underlying Java object (which is
 also available to us)?
 
You are using the underlying Java object.

 Frameworks designed better in the community: yes and no. Although I
 haven't used cflogin yet, I'm not about to rewrite the application
 framework.
 
I bet more people are using their own authentication schemes than cflogin.

-Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Query from within a cfscript

No, I'm basing my code from this article:

http://www.macromedia.com/devnet/mx/coldfusion/extreme/cftags_cfscript.html

The sample code in the article seems to call a CFQuery from within a CFSCRIPT block:

CFSCRIPT
SQLString = Select * From LoginInfo where 
UserID='BobZ' and Password = 'Ads10';
DATASOURCE = CompanyInfo;
checkUser=CFQUERY(SQLString: SQLString,
DATASOURCE: DATASOURCE);
if (checkUser.recordCount neq 0) {
 CFOUTPUT(Welcome Back,   checkUser.UserID);
} else {
 CFOUTPUT(Your UserName is Wrong.. try again!);
 CFLOCATION(theURL:login.cfm);
}
/CFSCRIPTThanks,Howie- Original Message - 
From: Adrian Lynch 
To: CF-Talk 
Sent: Wednesday, August 18, 2004 10:41 AM
Subject: RE: Query from within a cfscript

Have you got a function of your own called CFQuery()?

Ade
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

CF DB connections are timing out

2004-08-18 Thread Phill B

Some thing is causing CF to redline on DB connections. What would be
the best way to track the problem down?
-- 
Phillip B.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Query from within a cfscript

2004-08-18 Thread Adrian Lynch

I didn't read the article, but it seems the dude has a cfquery function.
Sorry I deleted your original email but what error are you getting?

Ade

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: 18 August 2004 15:43
To: CF-Talk
Subject: Re: Query from within a cfscript

No, I'm basing my code from this article:

http://www.macromedia.com/devnet/mx/coldfusion/extreme/cftags_cfscript.html

The sample code in the article seems to call a CFQuery from within a
CFSCRIPT block:

CFSCRIPT
SQLString = Select * From LoginInfo where
UserID='BobZ' and Password = 'Ads10';
DATASOURCE = CompanyInfo;
checkUser=CFQUERY(SQLString: SQLString,
DATASOURCE: DATASOURCE);
if (checkUser.recordCount neq 0) {
 CFOUTPUT(Welcome Back,   checkUser.UserID);
} else {
 CFOUTPUT(Your UserName is Wrong.. try again!);
 CFLOCATION(theURL:login.cfm);
}
/CFSCRIPTThanks,Howie- Original Message -
From: Adrian Lynch
To: CF-Talk
Sent: Wednesday, August 18, 2004 10:41 AM
Subject: RE: Query from within a cfscript

Have you got a function of your own called CFQuery()?

Ade
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Doug White

I particularly like the feature in Blackstone of being able to incorporate PGP
encryption for better security of personal information collected on e-commerce
applications, but the document and reporting functionality is awesome as well.
Event management is probably a feature set that I would rarely use, but I guess
it does not hurt anything that it is available if wanted or needed.

As for BD, I think the perception is that MM is mainly targeting the high end
user, while the low end and middle is where most of us operate.For this area
BD fills a vacant spot.. It does have most of the functionality we use from day
to day, but it is not the end-all

Of course, we all realize that not all web sites are requiring rich media, flash
glitz, etc, and, in fact are much simpler in concept and layout.Of course, CSS
is being more widely used, and that alone helps a lot with load times, and site
appearance without having to copy and pase duplicate code all over the place.
CSS makes it easier to completely change the appearance of a site making it very
useful in development of multiople sites whose layout may be similar but still
have an individually desinged look and feel.

Many of the higher priority items which are so often overlooked is the ease of
use, user friendly navigation throughout the site.When every site you visit
have a different concept of navigation, use of popups, popunders, etc, seems to
turn a lot of visitors off and shortens both their visit time but their visit
frequency.

I personally have much admiraton for the develoeprs who do the sites for music
and artistic sites, because just like with their live performances flashy and
glitzy is what it is all about.On the other hand, many web sites, just by
their nature can be actually harmed by the addition of complicated flash, and
weird navigation schemes, and even more admiration must be given tothe developer
who can tell the difference and use it in theor approach to marketing their
skills.

==
Our Anti-spam solution works!!
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
http://www.forta.com/cf/isp/isp.cfm?isp_id=1069
==

- Original Message - 
From: Micha Schopman
To: CF-Talk
Sent: Wednesday, August 18, 2004 8:10 AM
Subject: RE: BLACKSTONE: Software Development Times Article

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.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SQL Query problem

At 10:14 AM 8/18/2004, you wrote:
MemberID from the members table corresponds to the memberID in the
transaction table.So I must be writing the join wrong?

Seems that way. Post the whole query, just as you have it the code.

--
Alex
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Query from within a cfscript

2004-08-18 Thread Greg Stewart

True but you still need to cerate a function called cfquery, here is
the code from the article:

cffunction name=CFQUERY access=public returntype=query
cfargument name=SQLString type=string required=yes
cfargument name=Datasource type=string required=yes
cfargument name=dbType type=string default=		
cfquery name=RecordSet datasource=#arguments.Datasource# 
 dbtype=#arguments.dbType#
	#preserveSingleQuotes(arguments.SQLString)#
 /cfquery
 cfreturn RecordSet
/cffunction

You'll need to have that somewhere in your template or application.cfm

Cheers
G

On Wed, 18 Aug 2004 10:43:01 -0400, Howie Hamlin [EMAIL PROTECTED] wrote:
 No, I'm basing my code from this article:
 
 http://www.macromedia.com/devnet/mx/coldfusion/extreme/cftags_cfscript.html
 
 The sample code in the article seems to call a CFQuery from within a CFSCRIPT block:
 
 CFSCRIPT
SQLString = Select * From LoginInfo where
UserID='BobZ' and Password = 'Ads10';
DATASOURCE = CompanyInfo;
checkUser=CFQUERY(SQLString: SQLString,
DATASOURCE: DATASOURCE);
if (checkUser.recordCount neq 0) {
CFOUTPUT(Welcome Back,   checkUser.UserID);
} else {
CFOUTPUT(Your UserName is Wrong.. try again!);
CFLOCATION(theURL:login.cfm);
}
 /CFSCRIPTThanks,Howie- Original Message -
From: Adrian Lynch
To: CF-Talk
Sent: Wednesday, August 18, 2004 10:41 AM
Subject: RE: Query from within a cfscript
 
Have you got a function of your own called CFQuery()?
 
Ade
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Query from within a cfscript

I'm getting:

Variable CFQUERY is undefined. 

Thanks,

Howie
- Original Message - 
From: Adrian Lynch 
To: CF-Talk 
Sent: Wednesday, August 18, 2004 10:54 AM
Subject: RE: Query from within a cfscript

I didn't read the article, but it seems the dude has a cfquery function.
Sorry I deleted your original email but what error are you getting?

Ade
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Query from within a cfscript

Well, paint me stupid.

Thanks,

Howie
- Original Message - 
From: Greg Stewart 
To: CF-Talk 
Sent: Wednesday, August 18, 2004 10:53 AM
Subject: Re: Query from within a cfscript

True but you still need to cerate a function called cfquery, here is
the code from the article:

cffunction name=CFQUERY access=public returntype=query
 cfargument name=SQLString type=string required=yes
 cfargument name=Datasource type=string required=yes
 cfargument name=dbType type=string default= 
 cfquery name=RecordSet datasource=#arguments.Datasource# 
dbtype=#arguments.dbType#
#preserveSingleQuotes(arguments.SQLString)#
/cfquery
cfreturn RecordSet
/cffunction

You'll need to have that somewhere in your template or application.cfm

Cheers
G
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: BLACKSTONE: Software Development Times Article

2004-08-18 Thread Gavin Brook

I've been following this thread and I wanted to share my thoughts...

 
I've been developing for many years now and I'm a firm believer in using the
right technology for the right job. Arguing about whether to use a
Macromedia supplied tag or to write something in Java is a personal choice.
If the Macromedia supplied tags will do the job and do it well, then that
maybe that's the best route. If more advanced functionality is needed then
then maybe Java, or other appropriate technology. Choosing the right
technology depends on a number of factors, including available resources,
money, time, skills,etc.

 
Macromedia, New Atlanta, etc are in business to make money. The best way to
do that is to sell products to as many people as possible. To do that these
products have to appeal to as many people as possible. I agree with Doug.
Macromedia, by building in higher level, easier to use features, they appeal
to more high-end users. It should also be bore in mind that one of the key
features of Blackstone is that there will be something for everyone. From
the advanced developer who's been using ColdFusion or Java for years, down
to the beginner who's just started writing applications. 

 
Personally I'm looking forward to trying Blackstone out. There's so many
things I'd like to try, and from the very brief details around I can think
of several uses for the features that have been mentioned. As to whether
they will fit in with my applications, that will be seen when the full
documentation or product is ready for testing.

 
Gavin

-Original Message-
From: Doug White [mailto:[EMAIL PROTECTED] 
Sent: 18 August 2004 15:49
To: CF-Talk
Subject: Re: BLACKSTONE: Software Development Times Article

I particularly like the feature in Blackstone of being able to incorporate
PGP
encryption for better security of personal information collected on
e-commerce
applications, but the document and reporting functionality is awesome as
well.
Event management is probably a feature set that I would rarely use, but I
guess
it does not hurt anything that it is available if wanted or needed.

As for BD, I think the perception is that MM is mainly targeting the high
end
user, while the low end and middle is where most of us operate.For this
area
BD fills a vacant spot.. It does have most of the functionality we use from
day
to day, but it is not the end-all

Of course, we all realize that not all web sites are requiring rich media,
flash
glitz, etc, and, in fact are much simpler in concept and layout.Of course,
CSS
is being more widely used, and that alone helps a lot with load times, and
site
appearance without having to copy and pase duplicate code all over the
place.
CSS makes it easier to completely change the appearance of a site making it
very
useful in development of multiople sites whose layout may be similar but
still
have an individually desinged look and feel.

Many of the higher priority items which are so often overlooked is the ease
of
use, user friendly navigation throughout the site.When every site you
visit
have a different concept of navigation, use of popups, popunders, etc, seems
to
turn a lot of visitors off and shortens both their visit time but their
visit
frequency.

I personally have much admiraton for the develoeprs who do the sites for
music
and artistic sites, because just like with their live performances flashy
and
glitzy is what it is all about.On the other hand, many web sites, just by
their nature can be actually harmed by the addition of complicated flash,
and
weird navigation schemes, and even more admiration must be given tothe
developer
who can tell the difference and use it in theor approach to marketing their
skills.

==
Our Anti-spam solution works!!
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
http://www.forta.com/cf/isp/isp.cfm?isp_id=1069
==

- Original Message - 
From: Micha Schopman
To: CF-Talk
Sent: Wednesday, August 18, 2004 8:10 AM
Subject: RE: BLACKSTONE: Software Development Times Article

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. 
_
 [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 Vince Bonfanti

Hi Tony,

First, Matt Liotta does not represent nor speak for New Atlanta. If you have
a problem with New Atlanta or BlueDragon, you should contact me; if you have
a problem with Matt you should take it up with him and leave New Atlanta and
BlueDragon out of it.

Second, based on the information that's available publicly so far, there's
nothing to technically prevent us from implementing an event gateway in
BlueDragon, if we choose to do so. Indeed, we've already got a working
prototype of a CFMESSAGE tag that gives you access to JMS (on Java) and
Message Queuing (on .NET) that will likely be delivered in BlueDragon 6.2
later this year, well before the Blackstone release. (The CFMESSAGE tag is
something we were working on before we ever heard of the Blackstone event
gateway).

Regarding the other new Blackstone features, we already have a working
prototype of the CFDOCUMENT tag--we're just waiting for the final
documentation to be published by Macromedia--and have a strategy in place to
support the new reporting features. From what we've seen so far,
implementing most of the Blackstone features in BlueDragon will be fairly
trivial (nothing at all on the scale of implementing CFCs or Web Services,
for example).

Now that we also have the BlueDragon infrastructure in place (on both Java
and .NET), adding new features can be done fairly rapidly.

Regards,

Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com

P.S. Thanks for your feedback on the installer issues you had with the
BlueDragon.NET Technology Preview release. Based on your comments, we've
fixed the issues with overwriting the .cfm extension mappings in IIS;
these fixes will be in the BD.NET public beta to be released in a few weeks.

P.P.S. I believe it was Picasso who said, All artists borrow, great artists
steal.



	From: Tony Weeg [mailto:[EMAIL PROTECTED] 
	Sent: Wednesday, August 18, 2004 8:46 AM
	To: CF-Talk
	Subject: Re: BLACKSTONE: Software Development Times Article
	
	
	is the underlying factor here some problem with how BD wont be able
to
	piggyback the event gateway or use it or steal it?
	
	must be something like this, or else i dont think matt's panties
would
	be in a bunch like this...they only tend to get into this sorta snag
	when something like this is happening...
	
	On Wed, 18 Aug 2004 08:24:06 -0400, Matt Liotta [EMAIL PROTECTED]
wrote:
	  Blackstone will ship with a number of out-of-the-box gateways
that
	  connect to a number of protocols - meaning ColdFusion developers
don't
	  need to write them. That in itself is a win.
	  
	 Agreed, but Macromedia could have supplied protocol handlers
without
	 building an event gateway. Instead, they went and built a
framework that
	 constrains what an event gateway is and can do. That could be a
really good
	 thing or it could be a really bad thing. Time will tell, but so
far
	 frameworks have always been done better in the community.
	 
	  Blackstone also provides an easy-to-use basic framework for such
	  gateways to run inside, wired into the CF Admin. Ease of
management is
	  another win.
	 
	 What is managed exactly? If it is anything like the web service
management
	 you find now then no thanks.
	 
	 -Matt
	
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SQL Query problem

OK, you asked for it :o)-- the select statement was my latest try at
retrieving just the highest numbered transaction ID and corresponding data
for each member.FYI - the filtering statements are only invoked after
someone does a new search from a form.The inital results, which is what I
am after, uses the cfcase value = all fields.The default URL.sortorder
is M.lastname and URL.sortDir is ASC.

 
Thanks for helping me with this.

 
===

 
cfquery name=qmemberList datasource=#REQUEST.dsnSQL#
username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD#
CACHEDWITHIN=#CreateTimeSpan(0,0,15,0)#

 
SELECT M.firstName, M.middleName, M.lastName, M.email, M.company, M.city,
M.zip, M.memberID, M.memberLevelID 
FROM #REQUEST.prefix#_Members_List M 
WHERE M.memberID =
 (SELECT TOP 1 T.transactionID, T.paidThru, T.transactionDate, T.memberID 
 FROM #REQUEST.prefix#_Members_TransactionLog T) AND 

 
!--- If the user provided a filter string,---
cfswitch _expression_=#SESSION.memberList.fieldSelect#
 cfcase value=All Fields
(M.firstName cfif #SESSION.memberList.searchModifier# IS
containingLIKE '%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#' /cfif 

 OR M.lastName cfif #SESSION.memberList.searchModifier# IS
containingLIKE '%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#'/cfif

 OR M.email cfif #SESSION.memberList.searchModifier# IS containingLIKE
'%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#'/cfif
 
 OR M.company cfif #SESSION.memberList.searchModifier# IS containingLIKE
'%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#'/cfif
 
 OR M.city cfif #SESSION.memberList.searchModifier# IS containingLIKE
'%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#'/cfif

 OR M.zip cfif #SESSION.memberList.searchModifier# IS containingLIKE
'%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#'/cfif) 
 /cfcase 

 cfcase value=First Name
AND M.firstname cfif #SESSION.memberList.searchModifier# IS
containingLIKE '%#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#' /cfif
 /cfcase
 cfcase value=Last Name
AND M.lastname cfif #SESSION.memberList.searchModifier# IS
containingLIKE '%#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#' /cfif
 /cfcase
 cfcase value=Email address
AND M.email cfif #SESSION.memberList.searchModifier# IS containingLIKE
'%#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#' /cfif
 /cfcase

 cfcase value=company
 AND M.company cfif #SESSION.memberList.searchModifier# IS
containingLIKE '%#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#' /cfif
 /cfcase
 cfcase value=city
 AND M.city cfif #SESSION.memberList.searchModifier# IS containingLIKE
'%#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#' /cfif
 /cfcase
 cfcase value=zip
 AND M.zip cfif #SESSION.memberList.searchModifier# IS containingLIKE
'%#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#' /cfif
 /cfcase

 
/cfswitch

 
!--- Filter on Criteria C (member status) if provided (querySwitch
13)---
cfif SESSION.memberList.FilterC NEQ All
 AND '#SESSION.memberList.FilterC#' = M.memberLevelID
/cfif

!---

RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

At 11:05 AM 8/18/2004, you wrote:

This is good news, Vince.

Thank's for the update and keeping the greater CF community in mind.

Keep up the good work.

--
Alex Sherwood

Now that we also have the BlueDragon infrastructure in place (on both Java
and .NET), adding new features can be done fairly rapidly.

Regards,

Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com

P.S. Thanks for your feedback on the installer issues you had with the
BlueDragon.NET Technology Preview release. Based on your comments, we've
fixed the issues with overwriting the .cfm extension mappings in IIS;
these fixes will be in the BD.NET public beta to be released in a few weeks.

P.P.S. I believe it was Picasso who said, All artists borrow, great artists
steal.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: BLACKSTONE: Software Development Times Article

At 10:36 AM 8/18/2004, you wrote:
What are you talking about? If you're being serious, this doesn't make
any sense at all. If you're joking, it's not funny.

I'm serious. I just ported the Mach-II framework to a nice, compact 12K executable for my Commodore-64. Now I can connect my 64 (and my old Commodore PET, soon) to my Pentium box via the gateway.

Decoupling CFMX from the jaws of HTTP has opended new doors for legacy integration. And FB4 makes this possible.

--
Alex

- Original Message -
From: Alexander Sherwood [EMAIL PROTECTED]
Date: Wed, 18 Aug 2004 10:00:05 -0400
Subject: RE: BLACKSTONE: Software Development Times Article
To: CF-Talk [EMAIL PROTECTED]

At 09:56 AM 8/18/2004, you wrote:
 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.

And with that... Tony single handedly silenced the list.LOL

Nope.

If the gateway doesn't support FuseBox 4.5 circuits and the FLiP
process (not to mention .qry and .dsp files), then MACR should go with
Mach-II listeners.

Mach-II is really the best choice to build the forthcoming remote Java
-- CFC invocation event-based gateway, by far.

--
True

--
[http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:174807This 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] 

--
http://www.houseoffusion.com/banners/view.cfm?bannerid=38
abb6223.jpg

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Memory Issues

2004-08-18 Thread Peter Farrell

Christian, What's your max memory heap size?Is it over 1.8 GB?

.pjf
maepub
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SQL Query problem

At 11:08 AM 8/18/2004, you wrote:
OK, you asked for it :o)-- the select statement was my latest try at
retrieving just the highest numbered transaction ID and corresponding data
for each member.FYI - the filtering statements are only invoked after
someone does a new search from a form.The inital results, which is what I
am after, uses the cfcase value = all fields.The default URL.sortorder
is M.lastname and URL.sortDir is ASC.


Thanks for helping me with this.

Can you post the actual, parsed SQL that is being executed against your DB?

This will be a little easier to troubleshoot with all of the variables and such filled in...

Thanks!

--
Ale
 [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

  Like all things CF, it's more accessible to people who aren't Java
  experts.
  
 Writing an event gateway requires knowledge of Java therefore yours is not

 a valid argument.

Declaring that it's not a valid argument does not make it so. As many people
have already stated, there will be several built in gateways. ColdFusion
developers will be able to start using these from day one with no knowledge
of Java.

I've only had the past week or two to think of ways to utilize gateways. The
gateways that have already been announced sound like they will suffice for
the uses I've been able to come up with.

However, I'm sure that, as new possibilities occur to me, I may find I need
other gateways. At which point, I'm sure I'll be able to download or
purchase gateways from third parties. If all else fails, I can hire a Java
programmer to write the gateway and then program to it from within
ColdFusion.

None of these options require any knowledge of Java on my part. Granted, the
third option, hiring a Java programmer, doesn't offer ColdFusion developers
much more than what is capable today.

Nevertheless, the gateway architecture will provide a de facto standard for
integrating gateways with ColdFusion. I think that alone is a good thing
because it gives developers, writers and teachers something to focus on and
simplifies the language for discussing gateways and their use from within
ColdFusion.

-ben
 [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 Adrian Lynch

Hey Vince, I don't suppose you have a list or a link to a bunch of BD
hosting companies?

I would have emailed you personally but I figured it would be cool for
everyone else to see your answer! :OD

Ade never spoken to Vince before in my life Lynch

-Original Message-
From: Alexander Sherwood [mailto:[EMAIL PROTECTED]
Sent: 18 August 2004 16:15
To: CF-Talk
Subject: RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE:
Software Development Times Article)

At 11:05 AM 8/18/2004, you wrote:

This is good news, Vince.

Thank's for the update and keeping the greater CF community in mind.

Keep up the good work.

--
Alex Sherwood

Now that we also have the BlueDragon infrastructure in place (on both
Java
and .NET), adding new features can be done fairly rapidly.

Regards,

Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com

P.S. Thanks for your feedback on the installer issues you had with the
BlueDragon.NET Technology Preview release. Based on your comments, we've
fixed the issues with overwriting the .cfm extension mappings in IIS;
these fixes will be in the BD.NET public beta to be released in a few
weeks.

P.P.S. I believe it was Picasso who said, All artists borrow, great
artists
steal.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Memory Issues

2004-08-18 Thread Peter Farrell

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: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

2004-08-18 Thread Vince Bonfanti

Hi Adrian,

Glad you asked! Here's a list of BlueDragon-certified hosting providers:

http://www.newatlanta.com/products/bluedragon/partners/hosting.cfm

Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com



	From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
	Sent: Wednesday, August 18, 2004 11:43 AM
	To: CF-Talk
	Subject: RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE:
Software Development Times Article)
	
	
	Hey Vince, I don't suppose you have a list or a link to a bunch of
BD
	hosting companies?
	
	I would have emailed you personally but I figured it would be cool
for
	everyone else to see your answer! :OD
	
	Ade never spoken to Vince before in my life Lynch
	
	-Original Message-
	From: Alexander Sherwood [mailto:[EMAIL PROTECTED]
	Sent: 18 August 2004 16:15
	To: CF-Talk
	Subject: RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE:
	Software Development Times Article)
	
	At 11:05 AM 8/18/2004, you wrote:
	
	This is good news, Vince.
	
	Thank's for the update and keeping the greater CF community in mind.
	
	Keep up the good work.
	
	--
	Alex Sherwood
	
	Now that we also have the BlueDragon infrastructure in place (on
both
	Java
	and .NET), adding new features can be done fairly rapidly.
	
	Regards,
	
	Vince Bonfanti
	New Atlanta Communications, LLC
	http://www.newatlanta.com
	
	P.S. Thanks for your feedback on the installer issues you had with
the
	BlueDragon.NET Technology Preview release. Based on your comments,
we've
	fixed the issues with overwriting the .cfm extension mappings in
IIS;
	these fixes will be in the BD.NET public beta to be released in a
few
	weeks.
	
	P.P.S. I believe it was Picasso who said, All artists borrow,
great
	artists
	steal.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Log file reader

2004-08-18 Thread Ray Champagne

Has anyone ever used/seen/have/etc a script that can read and parse IIS log 
files?I want to write a custom stats package for my company, but figured 
why reinvent the wheel - this script would be out there somewhere.I am 
pretty flexible, I just am lazy and don't want to write the code to 
parse.I will take the parsed files and convert to a DB table when I am 
done, I guess.

I tried the dev exchange and cflib, but found nothing that suits what i need.

anyone?

THX,

Ray

=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it
from your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at 603.433.9559.
Thank you.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Event Gateway on BlueDragon, etc.

At 11:44 AM 8/18/2004, you wrote:\

Quick question, Vince.

On the BD product page, a graphic neare the bottom asks How can I leverage Fusebox with BlueDragon?

Is this a teaser for some FB-specific tags in BD, or more geared towards showing how FB works within the standard CFML tag/function set?

Thanks!

--
Alex

Hi Adrian,

Glad you asked! Here's a list of BlueDragon-certified hosting providers:

http://www.newatlanta.com/products/bluedragon/partners/hosting.cfm

Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Consuming CFC web methods in VB.NET

I have open-sourced a CFC that includesfunctions that convert a cf
query or cf array to/from a thinArray ( a special-format, delimited
list ).The thinArray can then be transmitted to/from a web service as
a single string within an XML (WDDX) packet.It has the additional
advantage of reducing bandwidth (XML tag overhead from about 256% to
9%)

You would need to write the equivalent functions on the net side in
whatever language you choose.But that should not be too difficult as
you could just re-implement thelogic in the CFC -- it is almost
trivial:

Rob Rohan has implemented _javascript_ thinArray processing in his
Neuromancer package at:

http://www.rohanclan.com/products/neuromancer/

The thinArray CFC (cfBAM.cfc) is part of the package.The
documentation is in comments at the start of the CFC.

Dick

On Aug 18, 2004, at 6:09 AM, Adam Haskell wrote:

 I've always contended that sending anything over a webservice other
than simple values is going to get you in trouble. Even in CF - CF
communications I think sending anything other than text is asking for
trouble. I recomend using one of the many functions on cflib.org to
convert the complex objects to xml.
http://www.cflib.org/udf.cfm?ID=648

Antother option would be to generate a WDDX packet and return that but
you'll need something like

 http://www.topxml.com/code/default.asp? 
 p=3id=v20020829124758ms=20l=dotnetsw=categ
to deal with WDDX in .Net I think.

Adam H

On Wed, 18 Aug 2004 10:20:00 +0100, Craig Dudley
 [EMAIL PROTECTED] wrote:
 ..NET just doesn't understand the return type, it probably could if
 you
 wrote some sort of QueryBean handler but I'd try returning a more
 simple
 data type, maybe you could encode the query into an xml packet and
 return that? Or try and array?

 -Original Message-
 From: Steven Brownlee [mailto:[EMAIL PROTECTED]
 Sent: 18 August 2004 10:07
 To: CF-Talk
 Subject: Consuming CFC web methods in VB.NET

 This is my last stab at this problem. No other message boards have
 been
 able to help me.

 First, the code...

 getPlaylist.cfc
 
 cffunction access=remote name=getNewPlaylist output=no
 returntype=query
 cfargument name=clientID type=string required=yes

 cfquery ... name=IMPlaylist
  removed for space saving...
 /cfquery

 cfif IMPlaylist.recordCount gt 0
 cfoutput query=IMPlaylist
 cfquery datasource=clp_dyn_signs dbtype=odbc username=...
 password=...
   .. Removed for space saving
 /cfquery
 /cfoutput
 cfreturn IMPlaylist
 /cfif

 /cffunction
 

 frmMain.vb
 
 Dim MyService As getPlaylist.getPlaylistService = New
 getPlaylist.getPlaylistService
 Dim MyResult As getPlaylist.QueryBean

 Try
   MyResult = MyService.getNewPlaylist(xmlParser.ClientID)
 Catch ex As Exception
   Me.txtHistory.Text += Error calling playListExists function ( 
 ex.Message  ) + vbCrLf
   Log.AppendLog(Error calling playListExists function ( 
 ex.Message
  ))
 End Try
 

 Now the getPlaylist.cfc works fine from the Flash Remoting
 application
 that was built for this client, but when trying to get the query
 into
 VB.NET, the following error is returned
 
 org.apache.axis.AxisFault : ; nested exception is:
 coldfusion.xml.rpc.CFCInvocationException:
 [coldfusion.runtime.UDFMethod$InvalidReturnTypeException : The value
 returned from function getNewPlaylist() is not of type query.][];
 nested
 exception is:
 coldfusion.xml.rpc.CFCInvocationException:
 [org.apache.axis.AxisFault :
 ; nested exception is:
 coldfusion.xml.rpc.CFCInvocationException:
 [coldfusion.runtime.UDFMethod$InvalidReturnTypeException : The value
 returned from function getNewPlaylist() is not of type query.][])
 

 It does return a query (or QueryBean as XML sees it) and everything
 is
 types correctly in the .NET code.  I also put in a test function
 that
 just returned some dummy text to see if I was able to properly
 invoke
 functions of a CFC web method and it worked fine.  Just seems to be
 choking on sending back a query.

 I know this is a convoluted question, so if anyone has had
 experience
 using CFC methods in .NET, I'd appreciate any help.

 Steven Brownlee
 [EMAIL PROTECTED]
  _



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Consuming CFC web methods in VB.NET

At 11:57 AM 8/18/2004, you wrote:

http://www.rohanclan.com/products/neuromancer/

Dick - I gotta ask: is Nueromancer a DD name?

--
Alex
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SQL Query problem

OK, a couple of things:
1) Below is the complete code for the query page.

 
2) Go to www.markleder.com/query.cfm
There are two results screenshots:
Shot 1 = the results from this query
Shot 2 = a detail zoom for one of the members (this is included for
clarification), in this case, I'm getting duplicates, I only want to show
the most resent transactionID (eg, transaction date), not paid thru date.
The most recent transaction ID is the one with the paid thru as 7/31/2004,
not 12/31/2004.So, on Shot 1, the query results should show the paid
through for this individual as 7/31/2004, not 12/31/2004 as what is occuring
now

 
HTH

 
===

 
cfprocessingdirective pageencoding=utf-8
!--- If user is returning from adding, editing or deleting subscribers,
remove the cached query ---
cfif URL.kc EQ 1
 cfobjectcache action="">
/cfif

 
cfset VARIABLES.todaysDate = #CreateODBCDate(Now())#
cfparam name=URL.process default=
cfparam name=SESSION.memberList.fieldSelect type=string default=All
Fields
cfparam name=SESSION.memberList.searchModifier type=string
default=containing
cfparam name=SESSION.memberList.ffText type=string default=
cfparam name=SESSION.memberList.DateFrom type=string default=
cfparam name=SESSION.memberList.DateThru type=string default=
cfparam name=SESSION.memberList.filterC default=All!--- Member Status
---
cfparam name=URL.sortOrder type=string default=M.lastName
cfparam name=URL.sortDir type=string default=ASC

 
!--- If the user is submitting the search form, ---
!--- we'll make their submission be the criteria for rest of session ---
cfif IsDefined(FORM.fieldnames)!---ffText---
cfset SESSION.memberList.ffText = FORM.ffText
cfset SESSION.memberList.fieldSelect = FORM.fieldSelect
cfset SESSION.memberList.searchModifier = FORM.searchModifier
 cfset SESSION.memberList.DateFrom= FORM.DateFrom
 cfset SESSION.memberList.DateThru = FORM.DateThru
cfset SESSION.memberList.filterC = FORM.filterC
 cfset SESSION.memberList.sortOrder= URL.sortOrder
 cfset SESSION.memberList.sortDir= URL.sortDir
/cfif

 
cfquery name=qmemberList datasource=#REQUEST.dsnSQL#
username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD#
CACHEDWITHIN=#CreateTimeSpan(0,0,15,0)#

 
SELECT M.firstName, M.middleName, M.lastName, M.email, M.company, M.city,
M.zip, M.memberID, M.memberLevelID 
FROM #REQUEST.prefix#_Members_List M 
WHERE M.memberID =
 (SELECT TOP 1 T.transactionID, T.paidThru, T.transactionDate, T.memberID 
 FROM #REQUEST.prefix#_Members_TransactionLog T) AND 

 
!--- If the user provided a filter string,---
cfswitch _expression_=#SESSION.memberList.fieldSelect#
 cfcase value=All Fields
(M.firstName cfif #SESSION.memberList.searchModifier# IS
containingLIKE '%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#' /cfif 

 OR M.lastName cfif #SESSION.memberList.searchModifier# IS
containingLIKE '%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#'/cfif

 OR M.email cfif #SESSION.memberList.searchModifier# IS containingLIKE
'%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#'/cfif
 
 OR M.company cfif #SESSION.memberList.searchModifier# IS containingLIKE
'%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#'/cfif
 
 OR M.city cfif #SESSION.memberList.searchModifier# IS containingLIKE
'%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#'/cfif

 OR M.zip cfif #SESSION.memberList.searchModifier# IS containingLIKE
'%#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#'/cfif) 
 /cfcase 

 cfcase value=First Name
AND M.firstname cfif #SESSION.memberList.searchModifier# IS
containingLIKE '%#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE '#SESSION.memberList.ffText#%'
cfelseif #SESSION.memberList.searchModifier# IS equal to=
'#SESSION.memberList.ffText#' /cfif
 /cfcase
 cfcase value=Last Name
AND M.lastname cfif #SESSION.memberList.searchModifier# IS
containingLIKE '%#SESSION.memberList.ffText#%' 
cfelseif #SESSION.memberList.searchModifier# IS beginning
withLIKE

Re: keeping form data during server-side validation

2004-08-18 Thread Patricia Lee

I see a cflocation in your code for the action page.

When you cflocate back to the form page you lose your form variables. 
This is why they don't display for you.The cfparam, in this case, will
stop any errors, but it won't magically keep your values.

The easiest (but not only) way to do what you want is to have only one
page, with the form posting to itself.Pseudo-Code and additional
explanation follows.

*** pseudo code ***

cfparam name=errorMessage default=
cfif not structisempty(form)

... process action elements here ...

cfif user name already exists
 cfset message = Message
/cfif

/cfif

cfif len(trim(message)) GT 0
Display Message Here, Above the form
/cfif
.. display form here...

*** END pseudo code ***

Then you could either follow previous advice and cfparam all your
formfields, or you could embed some conditional logic in your formfields
directly.

cfparam name=form.UserFirstName default=
input name=UserFirstName type=text
value=#form.UserFirstName#
size=15 maxlength=25

or

input name=UserFirstName type=text
size=15 maxlength=25
cfif isdefined(form.userfirstname)
value=#form.userFirstName#
/cfif


-P
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: BLACKSTONE: Software Development Times Article

 Declaring that it's not a valid argument does not make it so. As many
 people
 have already stated, there will be several built in gateways. ColdFusion
 developers will be able to start using these from day one with no
 knowledge
 of Java.
 
You are missing the context of the thread though. The original statement was
as follows.

 Think about this... don't like the way CFMX handles webservices? 
 Thinks its buggy and a pain to use?Just don't want to use Axis 
 because you have a better idea? Write your own event gateway for 
 webservices and that utilizes some other SOAP engine.Want to 
 implement SOAP via SMTP which CF doesn't really do?Write your own 
 gateway.

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.

-Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SQL Query problem

At 12:05 PM 8/18/2004, you wrote:
OK, a couple of things:
1) Below is the complete code for the query page.

SorryI meant the actual SQL code that gets passed to the DB. CF will display the actual, parsed SQL code in the debugging output.

Could you post this?

Thanks!

--
Alex
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: keeping form data during server-side validation

2004-08-18 Thread Barney Boisvert

If you're CFLOCATIONing back to the form page, then you'll lose the
submitted values.To repopulate the form, you'll either have to
submit the form to itself, include the form in the action page (with
CFINCLUDE), or set the form data to some persistant scope (session or
client), and then read it out of the session scope into the form after
the CFLOCATION.

I'd recommend the middle option (including the form), becuase it
allows you to separate processing from the form itself, but doen't
make you deal with the extra persistant storage.

cheers,
barneyb

On Tue, 17 Aug 2004 21:59:38 -0400, Roberto Perez [EMAIL PROTECTED] wrote:
 At 06:36 AM 8/17/04, Barney Boisvert wrote:
 The simplest approach is to use a CFPARAM for every form field at the
 top of your form, and then use the VALUE attribute of the INPUT tag to
 load the value.
 
 Hi all,
 
 I still can't get the desired results, so I'm posting some code so that
 someone can tell me what I'm missing. Basically I could have a form.cfm
 and an action.cfm page, or I could process both form and actions on the
 same page. I'm using the first option (2 separate pages), following one of
 the examples posted before:
 
 - - - - Form page (registrationForm.cfm) - - - - - -
 
 cfparam name=form.UserFirstName default=
 cfparam name=form.UserLastName default=
 
 cfoutput
 form action="" method=POST
 name=registration_form id=registration_form
 input name=UserFirstName type=text value=#form.UserFirstName#
 size=15 maxlength=25
 input type=text name=UserLastName value=#form.UserLastName#
 size=15 maxlength=35
 input type=text name=UserID maxlength=20 size=15
 input type=submit name=register value=Submit
 /form
 /cfoutput
 
 - - - - - - - - - - - - - - - - - - - - - - - - - -
 
 - - - - Action page (registrationAction.cfm) - - - -
 
 cfif NOT isDefined(form.register)
 cfset back2registration=registrationForm.cfm?warning= 
 URLEncodedFormat(Invalid information entered. Please complete this
 registration form)
 cflocation url="">
 /cfif
 
 cfif IsDefined(FORM.register)
 cftransaction
cfquery name=checkUser datasource=dicUsers_dsn
SELECT user_tb.UserID FROM user_tb WHERE user_tb.UserID='#FORM.UserID#'
/cfquery
 
cfif checkUser.RecordCount GTE 1
cfset back2registration =registrationForm.cfm?message= 
 URLEncodedFormat(Username already exists. Please choose a different one)
cflocation url=''
cfelse
(create the username here before someone else takes it. Code not
 included)
/cfif
/cftransaction
 /cfif
 
 - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 
 As it is now, when the visitor is sent back because the username already
 exists, the First Name and Last Name fields in the form are not
 self-populated with the previously entered information, and the visitor has
 to re-enter all of it (the real form has much more information to be
 re-entered).
 
 So, what am I missing here?
 
 Thanks in advance,
 
 Roberto
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: BLACKSTONE: Software Development Times Article

 On Wednesday 18 Aug 2004 14:34 pm, S. Isaac Dealey wrote:
 CF-Admin... If I could get DSN-less connections with
 CFMX, I'd be all
 over it.

 Umm, you can, with the service factory java objects...

And use that for cfquery how? ... I know that I can connect to
datasources without using a DSN by hacking the Java, and I know that I
can create new DSN's on the fly using the serviceFactory -- neither of
those are what I want. I want to be able to connect to a database on
the fly to use cfquery against it without needing a dsn. Hell, the
2nd url in my sig is an article about accessing datasources through
the serviceFactory.

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)

On Aug 18, 2004, at 8:05 AM, Vince Bonfanti wrote:

Second, based on the information that's available publicly so far, 
 there's
nothing to technically prevent us from implementing an event gateway 
 in
BlueDragon, if we choose to do so. Indeed, we've already got a working
prototype of a CFMESSAGE tag that gives you access to JMS (on Java) 
 and
Message Queuing (on .NET) that will likely be delivered in BlueDragon 
 6.2
later this year, well before the Blackstone release. (The CFMESSAGE 
 tag is
something we were working on before we ever heard of the Blackstone 
 event
gateway).


Vince

I am interested in the fact that you are providing access to JMS with a 
CF tag as opposed to an event gateway.

When I first investigated the subject, based on Sean Corfields posts  
blog it occurred to me that a slick way to provide this access would be 
a cfmessage tag -- even used that name.Sean almost (but not 
totally) convinced me that a gateway was a better approach.

Intuitively, I think that a cfmessage tage would be easier for a 
developer to use/understand -- but if a JMS event gateway is procvided 
with Blackstone, that is probably a wash.

I am interested in hearing:

1) will the cfmessage tag implement all features of JMS senders
receivers (syncrhonous and asynchronous).
2) will cfmessage allow manipulation of messages without consuming them 
-- say, as an an admin function to change priorities, etc, or just 
examine messages in the system (a great debugging aid, too)
3) your thoughts on the tradeoffs of a cfmessage tag vs an event gateway

TIA

Dick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SQL Query problem

Will this work ?

 
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the
keyword 'WHERE'.

The error occurred in
C:\Inetpub\REIAColumbus\admin\members\searchFunction\searchOneOfTwo.cfm:
line 198
Called from C:\Inetpub\REIAColumbus\admin\members\main.cfm: line 29
Called from
C:\Inetpub\REIAColumbus\admin\members\searchFunction\searchOneOfTwo.cfm:
line 198
Called from C:\Inetpub\REIAColumbus\admin\members\main.cfm: line 29

 
196 :AND T.transactionDate =
#CreateODBCDate(SESSION.memberList.DateThru)#
197 :/cfif
198 : /cfif
199 : 
200 : GROUP BY M.memberID, M.firstName, M.middleName, M.lastName, M.email,
M.company, M.city, M.zip, M.memberLevelID, T.paidThru, T.transactionDate,
T.memberID 

 
SQL SELECT M.firstName, M.middleName, M.lastName, M.email, M.company,
M.city, M.zip, M.memberID, M.memberLevelID FROM reiacolumbus_Members_List M
WHERE M.memberID = (SELECT TOP 1 T.transactionID, T.paidThru,
T.transactionDate, T.memberID FROM reiacolumbus_Members_TransactionLog T)
AND WHERE (M.firstName LIKE '%%' OR M.lastName LIKE '%%' OR M.email LIKE
'%%' OR M.company LIKE '%%' OR M.city LIKE '%%' OR M.zip LIKE '%%' ) GROUP
BY M.memberID, M.firstName, M.middleName, M.lastName, M.email, M.company,
M.city, M.zip, M.memberLevelID, T.paidThru, T.transactionDate, T.memberID
DATASOURCEdedb49 
VENDORERRORCODE156 
SQLSTATEHY000 

_

From: Alexander Sherwood [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 18, 2004 12:15 PM
To: CF-Talk
Subject: RE: SQL Query problem

At 12:05 PM 8/18/2004, you wrote:
OK, a couple of things:
1) Below is the complete code for the query page.

SorryI meant the actual SQL code that gets passed to the DB. CF will
display the actual, parsed SQL code in the debugging output.

Could you post this?

Thanks!

--
Alex 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Consuming CFC web methods in VB.NET

It's Rob's creation -- so it prolly is.

When I first encountered it. i saw it as necromancer --a whole 'nother 
game :)

Dick

On Aug 18, 2004, at 9:00 AM, Alexander Sherwood wrote:

 At 11:57 AM 8/18/2004, you wrote:

http://www.rohanclan.com/products/neuromancer/

Dick - I gotta ask: is Nueromancer a DD name?

--
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 Damien McKenna

On Aug 18, 2004, at 11:05 AM, Vince Bonfanti wrote:
 Now that we also have the BlueDragon infrastructure in place (on 
 both Java
 and .NET), adding new features can be done fairly rapidly.

Let the good times roll!
-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
Nothing endures but change. - Heraclitus
 [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 Vince Bonfanti

Hi Dick,

Regarding your first two questions, details of the CFMESSAGE tag will be
announced when we release the BD 6.2 public beta (this is a fancy way of
saying, I don't know yet).

Regarding ...tradeoffs of a cfmessage tag vs an event gateway..., three
answers:

1. We started work on the CFMESSAGE tag before ever hearing of the event
gateway, so it's not as if we made a decision to do one instead of the
other.

2. We really don't know all that much about the event gateway, since
Macromedia have released little if any technical details publicly; so it's a
bit difficult for me to comment on just yet.

3. Implementing a CFMESSAGE tag doesn't preclude implementing an event
gateway (and vice-versa). If after seeing details of the event gateway we
think it's something useful that people will want, then we'll implement it
in BD; if not, then we won't. That's mainly going to depend on whether you
(CFML developers in general, and BlueDragon customers in particular) tell us
the event gateway is something you need or want. While the general
descriptions we've heard of the event gateway sound pretty cool, it's not
clear to me that it's something most CFML developers will be able to make
use of effectively (certainly, my personal opinion is there are other more
compelling features in Blackstone). Our attitude right now is neutral--we'll
wait and see after it's delivered and respond appropriately.

Vince



	From: Dick Applebaum [mailto:[EMAIL PROTECTED] 
	Sent: Wednesday, August 18, 2004 12:34 PM
	To: CF-Talk
	Subject: Re: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE:
Software Development Times Article)
	
	
	On Aug 18, 2004, at 8:05 AM, Vince Bonfanti wrote:
	
	Second, based on the information that's available publicly so
far, 
	 there's
	nothing to technically prevent us from implementing an event
gateway 
	 in
	BlueDragon, if we choose to do so. Indeed, we've already got a
working
	prototype of a CFMESSAGE tag that gives you access to JMS (on
Java) 
	 and
	Message Queuing (on .NET) that will likely be delivered in
BlueDragon 
	 6.2
	later this year, well before the Blackstone release. (The
CFMESSAGE 
	 tag is
	something we were working on before we ever heard of the
Blackstone 
	 event
	gateway).
	
	
	Vince
	
	I am interested in the fact that you are providing access to JMS
with a 
	CF tag as opposed to an event gateway.
	
	When I first investigated the subject, based on Sean Corfields posts
 
	blog it occurred to me that a slick way to provide this access would
be 
	a cfmessage tag -- even used that name.Sean almost (but not 
	totally) convinced me that a gateway was a better approach.
	
	Intuitively, I think that a cfmessage tage would be easier for a 
	developer to use/understand -- but if a JMS event gateway is
procvided 
	with Blackstone, that is probably a wash.
	
	I am interested in hearing:
	
	1) will the cfmessage tag implement all features of JMS senders
	receivers (syncrhonous and asynchronous).
	2) will cfmessage allow manipulation of messages without consuming
them 
	-- say, as an an admin function to change priorities, etc, or just 
	examine messages in the system (a great debugging aid, too)
	3) your thoughts on the tradeoffs of a cfmessage tag vs an event
gateway
	
	TIA
	
	Dick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: SQL Query problem

2004-08-18 Thread Marc Lowe

I left a lot of your query out but you should be able to look at this and see the biggest differences.

SELECT m.memberID, m.firstname, m.lastname,
 MAX(t.transactionID) as maxID
FROM members m
 INNER JOIN trans t ON t.memberID = m.memberID
GROUP BY m.memberID, m.firstname, m.lastname

Hope that helps,
Marc
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: BLACKSTONE: Software Development Times Article

On Wednesday 18 Aug 2004 17:28 pm, S. Isaac Dealey wrote:
 And use that for cfquery how? ... I know that I can connect to

Well, either write your own cf_query, or a cfquery object/UDF to behave like 
cfquery did back when CF support DSN-less nativly (4.5 ?)... all you are 
doing with hacking the java is what CF would have to do behind the scenes 
anyway.

 2nd url in my sig is an article about accessing datasources through

I ignore urls in sigs, or ones longer than 4 lines.
Yes, I know about mine - 'company policy' :-(

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

SQL date/time issues...

2004-08-18 Thread Greg Morphis

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 

STARTTIME	FINISHTIME	LPAD(TASKID,5)	STARTDATE	FINISHDATE
07:00:00	18:00:00	309D2	8/6/2004 7:00:00 AM	8/10/2004 6:00:00 PM
09:00:00	14:00:00	30A98	8/1/2004 9:00:00 AM	8/5/2004 2:00:00 PM
09:00:00	12:30:00	30AB7	8/2/2004 9:00:00 AM	8/5/2004 12:30:00 PM
10:00:00	18:00:00	30BEB	8/9/2004 10:00:00 AM	8/10/2004 6:00:00 PM
07:00:00	08:00:00	6E61F	8/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:00	6E61F	8/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: SQL Query problem

All the time you spent searching different solutions you could have
fixed the table strcuture and rewrote the code 5x over. Suck it up Gel
:-) Take the high road.

Michael T. Tangorre
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SQL Query problem

Sorry about that. Wrong list!!!
That was suppose to go to cf-community. :-)

Michael T. Tangorre

 All the time you spent searching different solutions you 
 could have fixed the table strcuture and rewrote the code 5x 
 over. Suck it up Gel
 :-) Take the high road.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SUSPECT: RE: slow Java call - Determining physical length of string - Pt 2

2004-08-18 Thread Dirk Sieber

We're starting to run into that as well...some of the numbers seem to be
quite off - just when we thought we had a solution.Anyone have any
other ideas on how we can accomplish this?This doesn't have to be
cross-platform - any way to call a native Windows function to get the
correct size?

 
Thanks,
Dirk

	-Original Message-
	From: Craig Dudley [mailto:[EMAIL PROTECTED] 
	Sent: Tuesday, August 17, 2004 2:37 AM
	To: CF-Talk
	Subject: SUSPECT: RE: slow Java call - Determining physical
length of string - Pt 2
	
	
	I had a play with this myself, and found that the pixel width
retruned
	by the funtion is a LONG way out of the actual length of the
string
	rendered in a browser.
	
	e.g.
	
	cfscript 
	font_obj =
createobject(java,java.awt.Font).init('Arial',1,8);
	font_metrics_obj =
	
createobject(java,java.awt.Toolkit).getDefaultToolkit().getFontMetri
	cs(font_obj);
	Pixel_Width = font_metrics_obj.stringWidth('the pixel width is
miles
	out?');
	/cfscript
	
	cfoutput
	#Pixel_Width#
	br
	img src="" width=cfoutput#Pixel_Width#/cfoutput
height=1
	alt= border=0
	br
	div align=left style=font-family:Arial;font-size:8pt;the
pixel
	width is miles out?/div
	/cfoutput
	
	You'll need a test gif of course.
	
	Still, I'm not sure why, maybe java just renders fonts entirely
	differently to browsers. I tried several fonts and many font
sizes, none
	of them are even close, or did I miss something?
	
	Craig.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SQL Query problem

??? puzzled

_

From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 18, 2004 12:58 PM
To: CF-Talk
Subject: RE: SQL Query problem

All the time you spent searching different solutions you could have
fixed the table strcuture and rewrote the code 5x over. Suck it up Gel
:-) Take the high road.

Michael T. Tangorre 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SQL Query problem

I'll give this a try and let you know.Thanks for your response.

_

From: Marc Lowe [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 18, 2004 12:54 PM
To: CF-Talk
Subject: Re: SQL Query problem

I left a lot of your query out but you should be able to look at this and
see the biggest differences.

SELECT m.memberID, m.firstname, m.lastname,
 MAX(t.transactionID) as maxID
FROM members m
INNER JOIN trans t ON t.memberID = m.memberID
GROUP BY m.memberID, m.firstname, m.lastname

Hope that helps,
Marc 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE: Software Development Times Article)

 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: Event Gateway on BlueDragon, etc.

2004-08-18 Thread Daniel Ganter

We've customers running Fusebox3, Fusebox4 and Mach-ii applications on BlueDragon (including the technology preview .NET version of BlueDragon).

This area will highlight the benefits of using BlueDragon with the various Fusebox versions.

Apologies for the confusion.

Regards,
Dan

Daniel Ganter
New Atlanta Communications, LLC
http://www.newatlanta.com

 On the BD product page, a graphic neare the bottom asks How can I 
 leverage Fusebox with BlueDragon?
 
 Is this a teaser for some FB-specific tags in BD, or more geared 
 towards showing how FB works within the standard CFML tag/function 
 set?
 
 Thanks!
 
 --
 Alex
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Blackstone summary

The recent Blackstone thread on CF-Talk did what long threads often do on
mailing lists; it went off in various tangents making it hard to understand
what was being argued and what each person's respective position was. In
light of that, I figured I would summarize my position to avoid being
misinterpreted.

Blackstone has many new features that are going to impact the CFML community
in a variety of ways. Some of these features have been disclosed and I
suspect still others have not been. Some features will provide new
capabilities and others will change how we work. New capabilities are always
interesting, but features that change how we work can both be liberating and
scary at the same time. Sometimes changing how we work might even be a bad
idea. I think it is important, healthy, and interesting to debate the merits
of Blackstone's new features as well as their implementation even though at
this point many of us aren't aware of the implementation.

With that in mind, I think the new cfdocument tag and rich forms
functionality is of huge value to the CFML community. The fact that the
cfdocument tag will allow you to create a PDF file using HTML as input is
quite valuable. While we have long had the ability to produce PDF documents
using a variety of technologies both commercial and open source, it appears
cfdocument will provide not only a more accessible route, but will also
avoid the 3rd party technology analysis and integration required currently.

Rich forms I believe are even more important since forms are used in almost
every web application. Again, we can do rich forms today using _javascript_,
DHTML, Flash, Java, or a combination of the various technologies. However,
the amount of worked required to successfully implement rich forms that work
across browsers is pretty high. W3C has answered with XForms, but browser
support doesn't exist and the knowledge level required is quite a bit higher
than HTML forms. Macromedia has done us a huge service with their
implementation of rich forms. Not only have they kept the knowledge level
low by providing tags that work very similar to HTML forms, but they have
also embraced XForms at the same time. This allows us to easily create rich
forms that work with today's browsers via Flash as well as support future
browsers that implement XForms. Further, it should be relatively easy to
conditionally serve different forms based on the user agent ensuring the
forms to be accessible as well.

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.

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.

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.

-Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Log file reader

2004-08-18 Thread Jim Davis

You'd probably be better off looking for a CF-able Java or COM object.

MS has a nice COM-based tool here:

http://www.microsoft.com/downloads/details.aspx?displaylang=en
http://www.microsoft.com/downloads/details.aspx?displaylang=enfamilyid=8cd
e4028-e247-45be-bab9-ac851fc166a4
familyid=8cde4028-e247-45be-bab9-ac851fc166a4

Jim Davis
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Memory Issues

2004-08-18 Thread Christian Watt

No, right now I have it set at 750mb.Although I have had it just over
a gig, but it does not matter how high I set it, eventually it still
surpasses that limit and locks up.

 
Christian

	-Original Message-
	From: Peter Farrell [mailto:[EMAIL PROTECTED] 
	Sent: Wednesday, August 18, 2004 10:19 AM
	To: CF-Talk
	Subject: Re: Memory Issues
	
	
	Christian, What's your max memory heap size?Is it over 1.8 GB?
	
	.pjf
	maepub 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: BLACKSTONE: Software Development Times Article

 Like all things CF, it's more accessible to people who
 aren't Java experts.

 Writing an event gateway requires knowledge of Java
 therefore yours is not a valid argument.

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.

 After all, a structure is just a Java object.
 So what makes CF structures any better than
 using the underlying Java object (which is
 also available to us)?

 You are using the underlying Java object.

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.

 Frameworks designed better in the community:
 yes and no. Although I
 haven't used cflogin yet, I'm not about to rewrite the
 application
 framework.

 I bet more people are using their own authentication
 schemes than cflogin.

Probably. But very few (if any) are using their own application
schemes instead of cfapplication.

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)

Good answers!

Looking forward to the public beta!

Dick

On Aug 18, 2004, at 9:50 AM, Vince Bonfanti wrote:

 Hi Dick,

Regarding your first two questions, details of the CFMESSAGE tag will 
 be
announced when we release the BD 6.2 public beta (this is a fancy way 
 of
saying, I don't know yet).

Regarding ...tradeoffs of a cfmessage tag vs an event gateway..., 
 three
answers:

  1. We started work on the CFMESSAGE tag before ever hearing of the 
 event
gateway, so it's not as if we made a decision to do one instead of the
other.

  2. We really don't know all that much about the event gateway, since
Macromedia have released little if any technical details publicly; so 
 it's a
bit difficult for me to comment on just yet.

  3. Implementing a CFMESSAGE tag doesn't preclude implementing an 
 event
gateway (and vice-versa). If after seeing details of the event 
 gateway we
think it's something useful that people will want, then we'll 
 implement it
in BD; if not, then we won't. That's mainly going to depend on 
 whether you
(CFML developers in general, and BlueDragon customers in particular) 
 tell us
the event gateway is something you need or want. While the general
descriptions we've heard of the event gateway sound pretty cool, it's 
 not
clear to me that it's something most CFML developers will be able to 
 make
use of effectively (certainly, my personal opinion is there are other 
 more
compelling features in Blackstone). Our attitude right now is 
 neutral--we'll
wait and see after it's delivered and respond appropriately.

Vince



From: Dick Applebaum [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 12:34 PM
To: CF-Talk
Subject: Re: Event Gateway on BlueDragon, etc. ( was:BLACKSTONE:
Software Development Times Article)


On Aug 18, 2004, at 8:05 AM, Vince Bonfanti wrote:

  Second, based on the information that's available publicly so
far,
 there's
  nothing to technically prevent us from implementing an event
gateway
 in
  BlueDragon, if we choose to do so. Indeed, we've already got a
working
  prototype of a CFMESSAGE tag that gives you access to JMS (on
Java)
 and
  Message Queuing (on .NET) that will likely be delivered in
BlueDragon
 6.2
  later this year, well before the Blackstone release. (The
CFMESSAGE
 tag is
  something we were working on before we ever heard of the
Blackstone
 event
  gateway).


Vince

I am interested in the fact that you are providing access to JMS
with a
CF tag as opposed to an event gateway.

When I first investigated the subject, based on Sean Corfields posts

blog it occurred to me that a slick way to provide this access would
be
a cfmessage tag -- even used that name.  Sean almost (but not
totally) convinced me that a gateway was a better approach.

Intuitively, I think that a cfmessage tage would be easier for a
developer to use/understand -- but if a JMS event gateway is
procvided
with Blackstone, that is probably a wash.

I am interested in hearing:

1) will the cfmessage tag implement all features of JMS senders  
receivers (syncrhonous and asynchronous).
2) will cfmessage allow manipulation of messages without consuming
them
-- say, as an an admin function to change priorities, etc, or just
examine messages in the system (a great debugging aid, too)
3) your thoughts on the tradeoffs of a cfmessage tag vs an event
gateway

TIA

Dick

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

DSN-less Queries was Re: BLACKSTONE: Software Development Times Article

 On Wednesday 18 Aug 2004 17:28 pm, S. Isaac Dealey wrote:
 And use that for cfquery how? ... I know that I can
 connect to

 Well, either write your own cf_query, or a cfquery
 object/UDF to behave like
 cfquery did back when CF support DSN-less nativly (4.5
 ?)... all you are
 doing with hacking the java is what CF would have to do
 behind the scenes anyway.

Except that I have yet to find a way to instantiate a cfquery object
using a Java Resultset that works consistently and efficiently (or at
all really), without _manually_ converting it row by row and column by
column. Which is completely unreasonable as a tool for development...
unless the plan is to cache the results of _every_ query which just
opens up a whole other huge can o' worms. Believe me, I've thought
about it. There's no good way to do it without some very special, very
magic, very proprietary info I don't have.

 2nd url in my sig is an article about accessing
 datasources through

 I ignore urls in sigs, or ones longer than 4 lines.
 Yes, I know about mine - 'company policy' :-(

Hrmph... mine doesn't seem all that bad to me... 3 urls, 2 slogans, my
phone nubmer and my name  company name... 7 lines yes... but 2 of
those are blank for the sake of making it easier to read.

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: SQL Query problem

Still didn't work, returning multiple transactions for any given individual.
I clipped this from the results (there should only be one individual and the
paid thru should be 7/31/2004, which is the newest (highest) transactionID

 
memberlevelID | email | firstname | lastname | paidthru
M | [EMAIL PROTECTED] | Andy Granger | 07/31/2004 
M | [EMAIL PROTECTED] | Andy Granger | 12/31/2004 

Here's how I posted it:

 
SELECT M.memberID, M.firstName, M.middleName, M.lastName, M.email,
M.company, M.city, M.zip, M.memberLevelID, MAX(T.transactionID) as maxID,
T.paidThru 
FROM #REQUEST.prefix#_Members_List M 
INNER JOIN #REQUEST.prefix#_Members_TransactionLog T ON t.memberID =
m.memberID

 
WHERE ...

 
GROUP BY M.memberID, M.firstName, M.middleName, M.lastName, M.email,
M.company, M.city, M.zip, M.memberLevelID, T.paidThru 

 
Thanks for hanging in there with me on this one...

_

From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 18, 2004 1:09 PM
To: CF-Talk
Subject: RE: SQL Query problem

I'll give this a try and let you know.Thanks for your response.

_

From: Marc Lowe [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 18, 2004 12:54 PM
To: CF-Talk
Subject: Re: SQL Query problem

I left a lot of your query out but you should be able to look at this and
see the biggest differences.

SELECT m.memberID, m.firstname, m.lastname,
 MAX(t.transactionID) as maxID
FROM members m
INNER JOIN trans t ON t.memberID = m.memberID
GROUP BY m.memberID, m.firstname, m.lastname

Hope that helps,
Marc 
_ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: BLACKSTONE: Software Development Times Article

 Excuse me? MM is providing a handful of pre-built gateways to begin
 with, much less having a consistent interface provided by MM which
 allows others who are Java knowledgeable to create, package and
 distribute additional gateways. At which point, yes, it is a very
 valid argument. The end result will be that developers who are not
 Java knowledgeable will be able to do things which would otherwise
 require extensive knowledge of Java.
 
My response was in relation to writing an event gateway; not using an
existing one. CF does not make it easier or harder to write an event gateway
since you can only write an event gateway in CF. Further, writing an event
gateway requires knowledge of Java. Thus, you argument is not valid. If you
are going to argue against me then you have to stay in the context of the
thread of positions don't make sense.

 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)?

 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?

-Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: BLACKSTONE: Software Development Times Article