Constantly execute (refresh?) page, for cfpop?

2007-10-08 Thread George Linderman
Hey guys,

I'm trying to make a little app that will get my email from the pop server, and 
then send as an SMS the subject and sender. I can see that I can do that with 
the cfpop and cfmail tag, but then I realized that the tags will only 
execute when someone refreshes the page, or goes to it. However, I'd like this 
to check every 5 minutes, and then send the emails to my cell. If I'm at my 
computer, refreshing the page, then it obviously defeats the purpose.

In other words, how do I write an app...very simple one, with only cfmail and 
cfpop tags, that will execute every 5 minutes? 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290516
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF Coding Standards

2007-10-08 Thread Daniel Kim
thank you all for the feedback. this is my first time i am in a position
where i have oversight over the development in a team, so i'm thankful for
the insight from you who have this experience.

the bulk of a proposed coding standards dealt with topics such as making
moves toward more web standards compliant markup code, not using IE only
DOM references, proper scoping of variables, especially in CFCs, some basic
guidelines for more efficient SQL, etc.

the issue i was running into was that there wasn't any consistency, even
from the code developed by individual developers. often, i came across
things like long sql statements in cfquerys and stored procs on one line, or
the random use of capitalization of variable names in a single file. i've
always been of the mind that these stylistic details should follow the
general rule of being consistent and readable, but have found that just
broadly stating it isn't necessarily clear to everyone what that is and
prompts the question of what that specifically means.

i debated back and forth with myself as to whether to put these in a coding
standards doc, or to address these on an individual basis. i decided that
the most pragmatic route was to put them in the doc, so that even if they
were not complied with, they could be used as an example of code that was
consistent and readable.

i've seen some of these discussions before in the cf community, and i'm of
the opinion that these stylistic choices shouldn't be in a community best
practices or standards doc, but was wondering if others have found them
helpful in the context of a team with members of varying skill sets.


On 10/7/07, Dave Watts [EMAIL PROTECTED] wrote:

   Consistency is important, the minutiae of capitalization
  and whitespace is not.
 
  I don't agree with this, as standards go the whitespace (tab
  obsession) is very important.
 
  Take this example (might not come out right on email.
 
  Select*
  From  Table
  Where X = 1
  And   Y = 1
 
  And this
 
  Select*
  From  Table
  Where X = 1 and Y = 1
 
  These are different standards, if you get used to reading the
  first, you easily miss the second part of the where in the second.

 Perhaps, but neither is superior to the other. Pick one and go with it -
 that's Sean's point. That's consistency.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!


 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290515
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: SOT: How do you version control with your CF code?

2007-10-08 Thread Eric Roberts
Are they via a stored procedure (or can they be made into one)?

Eric

-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED] 
Sent: Sunday, October 07, 2007 9:36 PM
To: CF-Talk
Subject: Re: SOT: How do you version control with your CF code?

Cool, unfortunately we could not do that 100% here because some of the
PL/SQL scripts we run during creation will not run via a CFQUERY tag.

On 10/7/07, Dale Fraser [EMAIL PROTECTED] wrote:

 We have an upgrader.

 So there is code that says something like

 cfif version lte 1.4.1
 Create table
 Drop table
 Alter table
 Insert some default values for new tables
 /cfif

 cfif version lte 1.4.2
 Create table
 Drop table
 Alter table
 Insert some default values for new tables
 /cfif

 So if I check out the code at 1.4.1 and run the upgrade, it will create
 all
 the databases for me.

 It obviously doesn't handle getting data back to that format, but this is
 an
 unlikely scenario.

 What it gives you is a history of changes to your databases, and a means
 to
 restore (excluding data) all code and schemas to a version.

 The history bit is really handy. When did that table get that extra
 column?
 It will be in the upgrader.

 It's a bit more work than making changes in the designer, but worth it.

 In the scenario you described, the client is on 1.5 you check that out,
 run
 the upgrade, have an empty working system. Make your fix, deploy to
 client,
 done as that clients data is in the 1.5 format, no need for the database
 backup.

 Regards
 Dale Fraser

 http://learncf.com

 -Original Message-
 From: Aaron Rouse [mailto:[EMAIL PROTECTED]
 Sent: Monday, 8 October 2007 12:06 PM
 To: CF-Talk
 Subject: Re: SOT: How do you version control with your CF code?

 Could you explain that with a little more detail.  What code(language) is
 going to track all of the table/column changes and track any data
 manipulation that is needed between versions of the database structure?
 Also if you are creating a database of that era, say version 1.5, does
 this
 mean it is going to drop the database of the version 2.0 era in order to
 have a place to put the 1.5 era?

 On 10/7/07, Dale Fraser [EMAIL PROTECTED] wrote:
 
  Control the databases through code.
 
  Then if you check out your code at 1.3.2
 
  It should be able to create databases of that era.
 
  Regards
  Dale Fraser
 
  http://learncf.com
 
  -Original Message-
  From: Aaron Rouse [mailto:[EMAIL PROTECTED]
  Sent: Monday, 8 October 2007 11:23 AM
  To: CF-Talk
  Subject: Re: SOT: How do you version control with your CF code?
 
  What do you do when client needs a fix on version 1.5 which has
  significant
  database differences when compared to version 2.0 that you are currently
  working on?  We just maintain a separate copy of the DB for the versions
  for
  cases like that but just curious on  how others do it.
 
  On 10/7/07, J.J. Merrick [EMAIL PROTECTED] wrote:
  
   Rick,
  
  
  
   3. Branch and tagging. me: ::working on version 2.0:: client: I need
   to you fix something that is broken on the live server! me: ok::
   switch to the trunk which is version 1.5, fix, deploy, switch back to
   v2.0 branch no mess and no thought
  
 
 
 
 
 



 



~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290514
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Constantly execute (refresh?) page, for cfpop?

2007-10-08 Thread gary gilbert
Hi George,

You could create the page as normal and set up a scheduled event in the
administrator to run it every 5 minutes.

-- 
Gary Gilbert
http://www.garyrgilbert.com/blog


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290518
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: FCKeditor in CF app - styles display on front end but not in editor window

2007-10-08 Thread Bhakti Pingale
Hi,

I would like to know the exact scenario when this happens. May be if you
can attach the piece of code, we will be able to debug when this
behavior is seen.

Thanks,
Bhakti
Adobe ColdFusion Team.

-Original Message-
From: Nick Gleason [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 05, 2007 6:03 AM
To: CF-Talk
Subject: FCKeditor in CF app - styles display on front end but not in
editor window

Hi folks.  We've been using FCKeditor successfully for quite a while in
our
CF-based software, but we have recently run into an odd issue related to
styles display in the editor window.
 
Our system has custom styles which display in the FCKeditor Styles
drop
down menu.  Suddenly, on some of our deployments, the styles listed in
the
Styles drop down menu are no longer displaying correctly.  That is, they
all
simply display as 10pt plain text, rather than displaying in the style
that
they define.
 
The funny thing is that the styles display correctly on the front end.
that
is, when they are applied to text in the editor, the text displays
correctly
on the front end.  So, it's simply a back end display issue in the
editor
window.  
 
Any FCKeditor / CF gurus out there who can troubleshoot the details of
how
external styles are integrated into FCKeditor?  We'd love to hear your
thoughts.
 
Best,
 
Nick






~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290517
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: SHA Hashing...

2007-10-08 Thread James Smith
Thanks guys, nothing is ever as simple as it should be is it ;-) anyway I
managed to find a couple of cf custom tags to do the job in the end, thanks
for clarifying the situation for me.

--
Jay 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.4/1056 - Release Date: 07/10/2007
18:12
 


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290520
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Graphing date ranges...

2007-10-08 Thread James Smith
I have a cfchart displaying dates along the X axis, is there any way to get
ColdFusion to treat these as a scale so that a 7 day gap in the data would
stretch the graph out to interpolate the missing days?

CFChart does have an xAxisType attribute but to set it to scale the data
must be numeric and I really want to keep the data displaying as formatted
dates.

--
Jay

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.4/1056 - Release Date: 07/10/2007
18:12
 


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290519
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Constantly execute (refresh?) page, for cfpop?

2007-10-08 Thread Adkins, Randy
take a look at CFSchedule or the Scheduled Tasks in the CF Administrator.
 



From: George Linderman [mailto:[EMAIL PROTECTED]
Sent: Mon 10/8/2007 3:15 AM
To: CF-Talk
Subject: Constantly execute (refresh?) page, for cfpop?



Hey guys,

I'm trying to make a little app that will get my email from the pop server, and 
then send as an SMS the subject and sender. I can see that I can do that with 
the cfpop and cfmail tag, but then I realized that the tags will only 
execute when someone refreshes the page, or goes to it. However, I'd like this 
to check every 5 minutes, and then send the emails to my cell. If I'm at my 
computer, refreshing the page, then it obviously defeats the purpose.

In other words, how do I write an app...very simple one, with only cfmail and 
cfpop tags, that will execute every 5 minutes?



~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290521
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CFAJAXPROXY Help!

2007-10-08 Thread Dale Fraser
That didn't work either.

I changed it to do a cfc binding and that all works.

Regards
Dale Fraser

http://learncf.com

-Original Message-
From: Rakshith N [mailto:[EMAIL PROTECTED] 
Sent: Monday, 8 October 2007 8:20 PM
To: CF-Talk
Subject: RE: CFAJAXPROXY Help!

You may want to call ColdFusion.Grid.refresh('gridname') to refresh the
grid in the onsuccess handler.

Rakshith

http://www.rakshith.net/blog/
 

-Original Message-
From: Dale Fraser [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 05, 2007 9:40 AM
To: CF-Talk
Subject: CFAJAXPROXY Help!

I have this line.

 

cfajaxproxy
bind=cfc:Battery.deleteTask({batteryForm:[EMAIL PROTECTED],{batteryForm:
batt
[EMAIL PROTECTED]) onsuccess=alert('success') / 

 

Which effectively says when I click the button btnDelete call deleteTask
method in Battery.cfc and onsuccess show an alert. It should work, in
fact
the docs show this as an example.

 

But what happens, is I get the alert 'success' when the page loads and
nothing on success of the delete.

 

I know that it is succeeding as I can run the method manually and it
works,
and from my page it also works as if I click the refresh button in the
grid
(after deleting a record) my record is gone. So i'm probably doing
something
silly, but am lost.

 

What I want is actually not an alert, but for the grid to refresh, the
alert
is just there to help me figure out whats going wrong.

 

Regards

Dale Fraser

 

http://learncf.com

 







~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290524
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CFAJAXPROXY Help!

2007-10-08 Thread Rakshith N
You may want to call ColdFusion.Grid.refresh('gridname') to refresh the
grid in the onsuccess handler.

Rakshith

http://www.rakshith.net/blog/
 

-Original Message-
From: Dale Fraser [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 05, 2007 9:40 AM
To: CF-Talk
Subject: CFAJAXPROXY Help!

I have this line.

 

cfajaxproxy
bind=cfc:Battery.deleteTask({batteryForm:[EMAIL PROTECTED],{batteryForm:
batt
[EMAIL PROTECTED]) onsuccess=alert('success') / 

 

Which effectively says when I click the button btnDelete call deleteTask
method in Battery.cfc and onsuccess show an alert. It should work, in
fact
the docs show this as an example.

 

But what happens, is I get the alert 'success' when the page loads and
nothing on success of the delete.

 

I know that it is succeeding as I can run the method manually and it
works,
and from my page it also works as if I click the refresh button in the
grid
(after deleting a record) my record is gone. So i'm probably doing
something
silly, but am lost.

 

What I want is actually not an alert, but for the grid to refresh, the
alert
is just there to help me figure out whats going wrong.

 

Regards

Dale Fraser

 

http://learncf.com

 





~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290523
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Constantly execute (refresh?) page, for lt;cfpopgt;?

2007-10-08 Thread George Linderman
Hey Gary,

I don't have access to the administrator, due to the fact I'm using shared 
hosting from hostmysite.I'll contact them though, and see if they can set it up.

Aside from that, even if just for the sake of knowing...is there any other way 
of doing this?


Thanks!

Hi George,

You could create the page as normal and set up a scheduled event in the
administrator to run it every 5 minutes.

-- 
Gary Gilbert
http://www.garyrgilbert.com/blog 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290522
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


AOP in ColdSpring and ModelGlue

2007-10-08 Thread Robert Rawlins - Think Blue
Hello Chaps,

 

I've been working with both CS and MG for a while now and we're getting on
famously together, It took me a while to feel comfortable with relinquishing
that control over to the frameworks, but once done I can genuinely feel the
development benefits, it's quite amazing.

 

This past weekend I've made my first ventures into studying the benefits of
the AOP concepts which are available to me in CS, and they have gotten me
quite excited to say the least, however trying to find some good working
examples of how to apply them within a MG/CS application is becoming quite
tricky and I'm struggling to figure this stuff out, so thought I'd come
looking for a little help.

 

For the sake of argument and example, let's take a simple task like
validating some data which is being passed to a service object. I'll give
some basic mocked examples of my controller and advice object that I have at
the moment.

 

Controller:

 

cffunction name=registerUser access=public output=false
returntype=any

  cfarguments name=Event type=any required=true hint=I'm the
event /

 

!--- Create New User ---

cfset var NewUser =
VARIABLES.Instance.UserService.create(ARGUMENTS.Event.getValue(name)) /

 

  cfreturn ARGUMENTS.Event /

/cffunction

 

Now obviously that's very stripped down version of my controller method, but
for the sake of argument let keep it as simple as possible. Now, I need to
validate that 'name' variable to ensure that it doesn't have any numbers in
it, if it does then I want to throw the user back to the form page with an
error message. Take a look at my basic advice object below:

 

Advice Object:

 

!--- Advice Method ---

cffunction name=invokeMethod access=public returntype=any hint=I
supply the advice to the method call

  cfargument name=methodInvocation
type=coldspring.aop.MethodInvocation required=false /

 

!--- Create Temporary Local Structure ---

cfset var LOCAL = structNew() /

 

!--- Validate Data ---

cfif refind([0-9], arguments.methodInvocation.getArguments().Name)

  !--- Data Not Valid ---

cfelse

  !--- Data Valid ---

/cfif

  

  !--- Return Out ---

  cfreturn /

/cffunction

 

Now this is where I become a little confused, see, in the old days I would
validate the data inside my controller, and if the data failed validation I
would add a result of 'failed' and update the viewstate with an error
message, then use the events xml definition to pass the user back to the
form if the result of 'failed' was present.

 

However, from what I can see here I have no access to the event object from
my advice object, so I'm not able to add results or update the view state,
All I can do is simply return a value, is that correct? How do I use the
advice object to control the user back to the form with an error message?
I'm feeling a little confused about it.

 

Thanks for any 'advice' guys, I really appreciate your time.

 

Rob



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290526
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SOT: How do you version control with your CF code?

2007-10-08 Thread Aaron Rouse
True but it all depends on what your applications are used for.  The bulk of
what I end up doing is doing work for an internal group at a large
corporation where the applications are used by one client and not sent to
multiple places implying multiple versions could exist in production.

On 10/7/07, Dale Fraser [EMAIL PROTECTED] wrote:

 Of course, the best solution would be to keep everyone on the same
 version.

 I have found that this can actually generate work and revenue.

 Ie

 Application = $100k + $10k per year. Includes all updates and is NOT
 optional.

 Then you get 10 customers you have $100 k recurring revenue, like one new
 sale a year for just doing upgrades, if you get your processes right, the
 upgrades can almost be automated or at very least trivial, so $10k per
 year
 is good money.

 Regards
 Dale Fraser

 http://learncf.com


 -Original Message-
 From: Aaron Rouse [mailto:[EMAIL PROTECTED]
 Sent: Monday, 8 October 2007 2:00 PM
 To: CF-Talk
 Subject: Re: SOT: How do you version control with your CF code?

 That sounds like it would be a great solution if the need to go back to
 different points in the database were needed.

 Our needs have always been just to go back to one certain point and really
 it has always been to go to that point with the data intact to then
 diagnose
 the problem.  Typically the users never provide enough details to easily
 recreate the problem via creation of all new test data.  To revert back to
 different versions of the database we could always just export that
 versions
 via the modeling tools we design the databases within since they have
 versioning in them but honestly never tried it since not had the need.

 On 10/7/07, Zaphod Beeblebrox [EMAIL PROTECTED] wrote:
 
  This is where something like Rails migrations would be a great thing
  for a CF framework to copy.  All of your database changes are kept in
  ruby files that describe table creation, column additions, table
  deletions, and if so needed, raw sql statements to create functions or
  stored procs.  Every ruby migration file is a migration point and has
  two methods 'up' and 'down', anything you do in the up method must be
  reflected as an opposite action in the down method.  So if you're at
  migration 18 and you want to go back to version 16, rake db:migrate
  VERSION=16 will do all the necessary changes for you.
 
 
 
  On 10/7/07, Aaron Rouse [EMAIL PROTECTED] wrote:
   Could you explain that with a little more detail.  What code(language)
  is
   going to track all of the table/column changes and track any data
   manipulation that is needed between versions of the database
 structure?
   Also if you are creating a database of that era, say version 1.5, does
  this
   mean it is going to drop the database of the version 2.0 era in order
 to
   have a place to put the 1.5 era?
  
   On 10/7/07, Dale Fraser [EMAIL PROTECTED] wrote:
   
Control the databases through code.
   
Then if you check out your code at 1.3.2
   
It should be able to create databases of that era.
   
Regards
Dale Fraser
   
http://learncf.com
   
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Monday, 8 October 2007 11:23 AM
To: CF-Talk
Subject: Re: SOT: How do you version control with your CF code?
   
What do you do when client needs a fix on version 1.5 which has
significant
database differences when compared to version 2.0 that you are
  currently
working on?  We just maintain a separate copy of the DB for the
  versions
for
cases like that but just curious on  how others do it.
   
On 10/7/07, J.J. Merrick [EMAIL PROTECTED] wrote:

 Rick,



 3. Branch and tagging. me: ::working on version 2.0:: client: I
  need
 to you fix something that is broken on the live server! me: ok::
 switch to the trunk which is version 1.5, fix, deploy, switch back
  to
 v2.0 branch no mess and no thought

   
   
   
   
   
  
  
 
 



 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290525
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SOT: How do you version control with your CF code?

2007-10-08 Thread Graham Pearson
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
 
This is the same thing which I do. I have 1 VM Session that has my
Testing software installed on it that I can play with which allows me
to not mess up my actual workstation. I have 1 VM Session running
OpenSuse that houses the Subversion and MySQL Databases for all of my
Development. I have 1 VM Session running Windows 2000 Pro that has CF7
Installed on JRUN and Apache. My Actual workstation has Eclipse, mysql
gui tools along with other eclipse plugins so I can connect to these
VM Sessions.

When I am doing development, I will fireup the OpenSuse and Windows 2K
VMWare Sessions and then also Eclipse. The windows vmware session has
a mapped drive to my local host and when I am ready to test some code,
I would then simply copy the code to the windows vmware session and
browse it within a browser. When I am satisfied with my changes, I
would then commit them to SVN which goes to the OpenSuse VMWare
Session. When I am done making changes, I shutdown the VMWare Sessions
and zip up the directory to burn to a DVD.



Rick Faircloth wrote:
 I'm very interested in the VMWare approach to testing Subverison,
 Eclipse, CFEclipse, etc.

 However, after looking over the selections in the Virtual Appliance
 Marketplace on vmware.com, I don't see anything that fits what I'm
 looking for.

 I've never used VMWare before and I'm trying to be careful about what
 I do to my development workstation.  I'd like to start keeping all my
 trial software running in a VM that I can delete at any time without
 affecting my current development setup.  I get very worried that something
 with which I'm unfamiliar is going to render my workstation useless.
 I just re-installed my system from the ground up twice due to hard drive
 failures and I don't want anything happening to my system again.

 From looking at the description of the appliances, I guess it's always
 going to be true for the free appliances, that the OS involved will be
 of the open source, free variety, such as Ubuntu, etc.?  It seems it would
 have to be to keep it free?  Correct?

 If that's the case, how would I set up a VM that mirrors my current
 production
 environment, but with the add-ons of Eclipse, CFEclipse, Subversion, etc.?
 Seems I would need a separate Win XP license, then a copy of CF8
Developer's
 edition, at a minimum.

 Am I missing something or looking at this the wrong way?

 Suggestions?  Advice?

 Thanks,

 Rick



 -Original Message-
 From: John Mason [mailto:[EMAIL PROTECTED]
 Sent: Saturday, October 06, 2007 9:18 AM
 To: CF-Talk
 Subject: RE: SOT: How do you version control with your CF code?

 I second the recommendation for SVN as a centralized versioning system
but
 you shouldn't pay too much attention to all the people claiming it is
hard
 to set up. It may be tedious when you do it for the first time, but not
 hard, you just have to follow the manual.

 But if for some reason you do find it hard or would like to cut through the
 setup time for doing SVN, Trac, CruiseControl and any other tools you need
 to setup. I would recommend looking at the Virtual Application Marketplace
 at Vmware (http://www.vmware.com/appliances/) which has server images where
 people have set all this up for you. You simply just download and run the
 image locally.

 John Mason
 [EMAIL PROTECTED]
 770.337.8363
 
 www.FusionLink.com - ColdFusion and Flex hosting
 Now offering ColdFusion 8 Enterprise hosting
 FREE Subversion hosting

 -Original Message-
 From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
 Sent: Saturday, October 06, 2007 5:50 AM
 To: CF-Talk
 Subject: Re: SOT: How do you version control with your CF code?

 J W wrote:
 I am looking to have better version control at our company and am
 wonder how YOU deal with this. What is your setup?

 Local development against a local CF and local resources. Full working copy
 of a SVN repository. Code gets tagged in the repo and then a build server
 will use an Ant script to pull in drivers, externals and configuration
files
 and generate several EAR files, both a compiled and a source version for
 each CF version supported. Source versions go to the test environment and
 when approved the compiled version goes to the staging environment
where the
 customer will approve it for final deployment.


 I second the recommendation for SVN as a centralized versioning system but
 you shouldn't pay too much attention to all the people claiming it is hard
 to set up. It may be tedious when you do it for the first time, but not
 hard, you just have to follow the manual. And be warned about all the blogs
 and wiki's too: I'm sure their authors write them with the best intentions,
 but few of them add something that is not in the manual, most of them are
 outdated and none of them cover important issues such as the proper way to
 secure and backup your repository. And don't even think about using that
 one-click installer, version 1.2.3 is ancient and binary 

RE: Graphing date ranges...

2007-10-08 Thread Robert Rawlins - Think Blue
Hey pal,

If you're looking to fill in the holes where there is no data for a
particular date the best way to do this is with a Calendar table in your
database, you can then select the desired date range from this and LEFT
OUTTER JOIN it to your table with your statistics data, that way It'll
return a row for every date in the range, regardless of whether you have
data for that date or not, so you get no gaps.

It's more of a SQL type thing so you might be better off asking there, and
looking around for some help building and populating a Calendar table, it's
not an overly complicated task, but a calendar table will really help you
out for this and many other tasks too, I'd highly recommend one.

Let me know if you need any more help Jay,

Rob

-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 10:44
To: CF-Talk
Subject: Graphing date ranges...

I have a cfchart displaying dates along the X axis, is there any way to get
ColdFusion to treat these as a scale so that a 7 day gap in the data would
stretch the graph out to interpolate the missing days?

CFChart does have an xAxisType attribute but to set it to scale the data
must be numeric and I really want to keep the data displaying as formatted
dates.

--
Jay

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.4/1056 - Release Date: 07/10/2007
18:12
 




~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290527
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF Coding Standards

2007-10-08 Thread Tom Chiverton
On Saturday 06 Oct 2007, [EMAIL PROTECTED] wrote:
 With posting them on the Wiki, in hopes we all could adapt to them 

*Nobody* else['s company] is going to mold themselves around you/your 
companies coding standards.
These sort of standards tend to vary a lot across development teams.

-- 
Tom Chiverton
Helping to augmentatively orchestrate eligible e-services
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office.  Any reference to a partner in 
relation to Halliwells LLP means a member of Halliwells LLP.  Regulated by The 
Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290529
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF Coding Standards

2007-10-08 Thread Aaron Rouse
I can understand the point of needing to be consistent but I have worked on
some projects where the consistent style was extremely hard to follow
because the person who did everything originally feared whitespace so no
tabs very littles spaces and very little new lines.  Although now days a lot
of programs would make things easy in going in there and dividing things up
to some extent, still was a pain at the time.

On 10/7/07, Dave Watts [EMAIL PROTECTED] wrote:

   Consistency is important, the minutiae of capitalization
  and whitespace is not.
 
  I don't agree with this, as standards go the whitespace (tab
  obsession) is very important.
 
  Take this example (might not come out right on email.
 
  Select*
  From  Table
  Where X = 1
  And   Y = 1
 
  And this
 
  Select*
  From  Table
  Where X = 1 and Y = 1
 
  These are different standards, if you get used to reading the
  first, you easily miss the second part of the where in the second.

 Perhaps, but neither is superior to the other. Pick one and go with it -
 that's Sean's point. That's consistency.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!


 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290530
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Graphing date ranges...

2007-10-08 Thread James Smith
I did think about something like this but the problem is that when you chart
data with missing data the line just stops and starts over the missing info,
it doesn't interpolate the gaps.  This means if it gets data like...

2007/10/01 - 15
2007/10/02 - null
2007/10/03 - 17
2007/10/04 - null
2007/10/05 - null
2007/10/06 - 12

The chart would then show nothing at all because it will try to render 3
disconnected dots which will not display anything.

--
Jay

-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 11:45
To: CF-Talk
Subject: RE: Graphing date ranges...

Hey pal,

If you're looking to fill in the holes where there is no data for a
particular date the best way to do this is with a Calendar table in your
database, you can then select the desired date range from this and LEFT
OUTTER JOIN it to your table with your statistics data, that way It'll
return a row for every date in the range, regardless of whether you have
data for that date or not, so you get no gaps.

It's more of a SQL type thing so you might be better off asking there, and
looking around for some help building and populating a Calendar table, it's
not an overly complicated task, but a calendar table will really help you
out for this and many other tasks too, I'd highly recommend one.

Let me know if you need any more help Jay,

Rob

-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 10:44
To: CF-Talk
Subject: Graphing date ranges...

I have a cfchart displaying dates along the X axis, is there any way to get
ColdFusion to treat these as a scale so that a 7 day gap in the data would
stretch the graph out to interpolate the missing days?

CFChart does have an xAxisType attribute but to set it to scale the data
must be numeric and I really want to keep the data displaying as formatted
dates.

--
Jay

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.4/1056 - Release Date: 07/10/2007
18:12
 






~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290532
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SOT: How do you version control with your CF code?

2007-10-08 Thread J.J. Merrick
It actually would simplify that situation. I find running a subversion
server very simple to do.

SVN works on a revision system so that everytime you check in a piece
of code it ups the revision number by one. If you want to go back to a
certain revision on 1 file just right click on the file, do revert and
look at the timeline and choose which change you want.

Your process does work for you but that seems like a lot of work to
accomplish the same goal.

J.J.


On 10/7/07, Rick Faircloth [EMAIL PROTECTED] wrote:
 Thanks for the feedback, J.J.

 Here's what I currently do...

 1.  Backup -- I currently have a production server here at my
 studio in my home, hosting my own sites.  I'm in the process of
 moving things over to a new VPS at AHPHosting with CF 8.
 For backup, I do two things... one, which is a type of versioning,
 is to simply save the entire folder with all assets, code, etc.,
 with a date appended and then continue working on the project.
 That gives me a backup to move back to in case something goes wrong
 with the current project and is just too much to undo.  Also,
 I have true backup of all project files/data to my FTP server.
 Which also, sends a copy of backed up files to my web server for
 redundancy.  So I have 3 copies of everything at all times on different
 computers.

 2. Versioning -- while I would like more granular versioning, appending
 the date/time to a complete project folder provides a type of versioning.
 What I would really like is to be able to undo a particular action while
 leaving other, perhaps later changes, intact.  Say, I've made 10 changes.
 I'd like to go back to change 4 and revert that, but leave 5-10 untouched.
 That would be really helpful.  Anything like that in Subversion?

 3.  Brand and tagging -- seems like what I do works similarly.  If something
 is wrong with the deployed project.  I just correct that (on the server...).
 Then back to work on updates on the development box.

 4.  Deployment of latest version -- copy the latest completed version to the
 server and overwrite the files.

 How would Subversion improve upon that?

 I use Homesite 5.5, btw

 Rick



 -Original Message-
 From: J.J. Merrick [mailto:[EMAIL PROTECTED]
 Sent: Sunday, October 07, 2007 8:59 PM
 To: CF-Talk
 Subject: Re: SOT: How do you version control with your CF code?

 Rick,

 I am a single developer and I always use subversion. It provides the
 following for me:

 1. Ease of backup. - I have a dev server here at my house that I use
 as a repository and i use mozy pro to back that up online. I never
 have to worry about my dev laptop dying and losing precious code.

 2. Versioning. I have countless times reverted a file when I have done
 something stupid and it is so nice to not ever have to worry about
 that.

 3. Branch and tagging. me: ::working on version 2.0:: client: I need
 to you fix something that is broken on the live server! me: ok::
 switch to the trunk which is version 1.5, fix, deploy, switch back to
 v2.0 branch no mess and no thought

 4. Deployment: Deploying is a no brainer when you use SVN.

 J.J.

 On 10/7/07, Rick Faircloth [EMAIL PROTECTED] wrote:
  Now, I can see how the versioning would be helpful, but other than that,
  how would this extensive management system be beneficial to a solo
  developer?
  Or is it overkill?
 
  Rick
 
  -Original Message-
  From: Eric Roberts [mailto:[EMAIL PROTECTED]
  Sent: Sunday, October 07, 2007 11:53 AM
  To: CF-Talk
  Subject: RE: SOT: How do you version control with your CF code?
 
  Summing it up...
 
  You have a repository that contains your current code.  Both the
 development
  and live environments are checked out from the repository. When you
  complete changes to a page, you commit the page.  You then update the live
  environment with the new code.  Everyone  who has checked out he code
  should, at the start of each day...and potentially several times
 throughout
  the day...run an update to pull current code from the repository to ensure
  they have the current version of the page they are working on.  I
 generally
  do an update before I start working on a page.  Now lets say you and I are
  working on the same page and we both commit the page.  Subversion will
  detect this and notify that there is a conflict.  It will then (depending
 on
  the setting and how the code conflicts) either merge the files
 automatically
  if there are no conflicts between the code...ie you changed line 5 and I
  changed line 20 and everything else is the same...or notify that last
  committer that there is a conflict and prompt you to manually do a diff
 and
  reconcile the code.  SVN also handles branches and tags.
 
  As far as all these checkouts, commits, updates, etc...
 
  There are several tools that can be used.  You can do this via a
  command-line interface.  You can use a third party tool like TortoiseSVN
  (another open source and free tool that is awesome...it interfaces with
  windows 

Re: Constantly execute (refresh?) page, for lt;cfpopgt;?

2007-10-08 Thread Casey Dougall
On 10/8/07, George Linderman [EMAIL PROTECTED] wrote:

 Hey Gary,

 I don't have access to the administrator, due to the fact I'm using shared
 hosting from hostmysite.I'll contact them though, and see if they can set
 it up.

 Aside from that, even if just for the sake of knowing...is there any other
 way of doing this?



Looks like this thread might have gotten chopped because I only see this one
post from you George... But have you tried the following?
META HTTP-EQUIV=Refresh CONTENT=10;
URL=http://domain.com/url/?#variable#;


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290534
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF Coding Standards

2007-10-08 Thread Casey Dougall
On 10/8/07, Dale Fraser [EMAIL PROTECTED] wrote:

  Consistency is important, the minutiae of capitalization and whitespace
 is
 not.

 I don't agree with this, as standards go the whitespace (tab obsession) is
 very important.

 Take this example (might not come out right on email.

 Select  *
 FromTable
 Where   X = 1
 And Y = 1

 And this

 Select  *
 FromTable
 Where   X = 1 and Y = 1

 These are different standards, if you get used to reading the first, you
 easily miss the second part of the where in the second.

 Regards
 Dale Fraser

 http://learncf.com


If you are using cfqueryparam it would be kinda stupid putting statements on
one line.

cfquery
SELECT  X, Y
FROMTable
WHEREX = cfqueryparam cfsqltype=cf_sql_integer maxlength=3
value=1 AND Y = cfqueryparam cfsqltype=cf_sql_integer
maxlength=3 value=1
/cfquery


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290533
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Graphing date ranges...

2007-10-08 Thread Robert Rawlins - Think Blue
Hey James,

You can use CASE statements in the SQL to handle the NULL values and replace
them with 0 which means the points still get plotted at the bottom of the
graph and look as its supposed to.

I've used this method before on my application solve the same problem so it
defiantly works and is a nice efficient way to solve the problem.

Rob
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 12:46
To: CF-Talk
Subject: RE: Graphing date ranges...

I did think about something like this but the problem is that when you chart
data with missing data the line just stops and starts over the missing info,
it doesn't interpolate the gaps.  This means if it gets data like...

2007/10/01 - 15
2007/10/02 - null
2007/10/03 - 17
2007/10/04 - null
2007/10/05 - null
2007/10/06 - 12

The chart would then show nothing at all because it will try to render 3
disconnected dots which will not display anything.

--
Jay

-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 11:45
To: CF-Talk
Subject: RE: Graphing date ranges...

Hey pal,

If you're looking to fill in the holes where there is no data for a
particular date the best way to do this is with a Calendar table in your
database, you can then select the desired date range from this and LEFT
OUTTER JOIN it to your table with your statistics data, that way It'll
return a row for every date in the range, regardless of whether you have
data for that date or not, so you get no gaps.

It's more of a SQL type thing so you might be better off asking there, and
looking around for some help building and populating a Calendar table, it's
not an overly complicated task, but a calendar table will really help you
out for this and many other tasks too, I'd highly recommend one.

Let me know if you need any more help Jay,

Rob

-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 10:44
To: CF-Talk
Subject: Graphing date ranges...

I have a cfchart displaying dates along the X axis, is there any way to get
ColdFusion to treat these as a scale so that a 7 day gap in the data would
stretch the graph out to interpolate the missing days?

CFChart does have an xAxisType attribute but to set it to scale the data
must be numeric and I really want to keep the data displaying as formatted
dates.

--
Jay

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.4/1056 - Release Date: 07/10/2007
18:12
 








~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290535
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Constantly execute (refresh?) page, for lt;cfpopgt;?

2007-10-08 Thread gary gilbert
George,

You can also use the cfschedule tag without having to have access to the
administrator. Though it is possible to disable this tag via the
administrator sandbox/ resource security page.

Either way you will have to check with your hosting provider.



-- 
Gary Gilbert
http://www.garyrgilbert.com/blog


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290536
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF Coding Standards

2007-10-08 Thread gary gilbert
Any coding standard that works toward readability and maintainability of
code is a good thing, but going overboard in any one direction makes the job
harder.

I also think the over use of new lines doesn't help with readability either

cfargument name=sfirstName
type=string
required=true
hint=first name of person
/

or

cfargument name=sfirstName type=string required=true hint=first name
of person /

The first is a superfluous use of carriage returns in my opinion and does
nothing to improve readability.

-- 
Gary Gilbert
http://www.garyrgilbert.com/blog


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290537
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Graphing date ranges...

2007-10-08 Thread James Smith
Problem is I need the line to be interpolated not dropped to 0 so for
example for the data

2007/10/01 - 15
2007/10/02 - null
2007/10/03 - 17

I need the line to go through 16 on the 2nd not drop to zero and come back
up again.

--
Jay

-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 13:00
To: CF-Talk
Subject: RE: Graphing date ranges...

Hey James,

You can use CASE statements in the SQL to handle the NULL values and replace
them with 0 which means the points still get plotted at the bottom of the
graph and look as its supposed to.

I've used this method before on my application solve the same problem so it
defiantly works and is a nice efficient way to solve the problem.

Rob
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 12:46
To: CF-Talk
Subject: RE: Graphing date ranges...

I did think about something like this but the problem is that when you chart
data with missing data the line just stops and starts over the missing info,
it doesn't interpolate the gaps.  This means if it gets data like...

2007/10/01 - 15
2007/10/02 - null
2007/10/03 - 17
2007/10/04 - null
2007/10/05 - null
2007/10/06 - 12

The chart would then show nothing at all because it will try to render 3
disconnected dots which will not display anything.

--
Jay

-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 11:45
To: CF-Talk
Subject: RE: Graphing date ranges...

Hey pal,

If you're looking to fill in the holes where there is no data for a
particular date the best way to do this is with a Calendar table in your
database, you can then select the desired date range from this and LEFT
OUTTER JOIN it to your table with your statistics data, that way It'll
return a row for every date in the range, regardless of whether you have
data for that date or not, so you get no gaps.

It's more of a SQL type thing so you might be better off asking there, and
looking around for some help building and populating a Calendar table, it's
not an overly complicated task, but a calendar table will really help you
out for this and many other tasks too, I'd highly recommend one.

Let me know if you need any more help Jay,

Rob

-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 10:44
To: CF-Talk
Subject: Graphing date ranges...

I have a cfchart displaying dates along the X axis, is there any way to get
ColdFusion to treat these as a scale so that a 7 day gap in the data would
stretch the graph out to interpolate the missing days?

CFChart does have an xAxisType attribute but to set it to scale the data
must be numeric and I really want to keep the data displaying as formatted
dates.

--
Jay

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.4/1056 - Release Date: 07/10/2007
18:12
 










~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290538
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Authenticate with Windows Active Directory, Windows Server 2003?

2007-10-08 Thread Tom Hines
What is the Coldfustion Script, CF version MX7 to Authenticate with Windows 
Active Directory, Windows Server 2003?


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290540
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: AOP in ColdSpring and ModelGlue

2007-10-08 Thread Brian Kotek
The fact that you're using Model-Glue should make no difference at all. If
it is, then you're thinking about it the wrong way. I see a few problems
with what you've said:

   - AOP is really meant to eliminate duplication by encapsulating a
   generic, common process so that it can be reused across many method calls or
   components. I'm not sure validation really qualifies, since it is so
   specific to the particular object or data being validated. Usual suspects
   for AOP include logging, security, and data formatting. So I'm not sure if
   what you're doing really lends itself to AOP in the first place, since I
   don't see how your code is reusable. The example you gave is hardcoding a
   call to getName() which already means this advice is really not going to
   work with other kinds of data.
   - You're right that the advice has no access to the Model-Glue event
   object. It shouldn't. You have access to whatever arguments were passed into
   the original method, and access to any return value from that method. So if
   your UserService returns an object or a struct indicating success or
   failure, along with error messages, you can manipulate that before it gets
   returned back to the controller.

Basically, if you can imagine dropping Model-Glue and having a web service
call your Service (and your advice), and having it work and return data that
the web service could use, then you're at the right conceptual level.
Whenever this won't work (for example, you're wanting the advice to have
access to the Model-Glue event object, which obviously would be extremely
difficult if the client was a web service instead of Model-Glue), it means
you aren't keeping your application layers properly encapsulated.

Hope that helps.

Brian

On 10/8/07, Robert Rawlins - Think Blue [EMAIL PROTECTED]
wrote:


 Now this is where I become a little confused, see, in the old days I would
 validate the data inside my controller, and if the data failed validation
 I
 would add a result of 'failed' and update the viewstate with an error
 message, then use the events xml definition to pass the user back to the
 form if the result of 'failed' was present.


 However, from what I can see here I have no access to the event object
 from
 my advice object, so I'm not able to add results or update the view state,
 All I can do is simply return a value, is that correct? How do I use the
 advice object to control the user back to the form with an error message?
 I'm feeling a little confused about it.



 Thanks for any 'advice' guys, I really appreciate your time.



 Rob



 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290539
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Authenticate with Windows Active Directory, Windows Server 2003?

2007-10-08 Thread Ryan, Terrence
cfntauthenticate

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Tom Hines [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 08, 2007 11:10 AM
To: CF-Talk
Subject: Authenticate with Windows Active Directory, Windows Server 2003?

What is the Coldfustion Script, CF version MX7 to Authenticate with Windows 
Active Directory, Windows Server 2003?




~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290541
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Authenticate with Windows Active Directory, Windows Server 2003?

2007-10-08 Thread Aaron Rouse
If for some reason that would not work then could always just use CFLDAP

On 10/8/07, Ryan, Terrence [EMAIL PROTECTED] wrote:

 cfntauthenticate

 Terrence Ryan
 I.T. Director
 Wharton Computing and Information Technology
 E-mail: [EMAIL PROTECTED]


 -Original Message-
 From: Tom Hines [mailto:[EMAIL PROTECTED]
 Sent: Monday, October 08, 2007 11:10 AM
 To: CF-Talk
 Subject: Authenticate with Windows Active Directory, Windows Server 2003?

 What is the Coldfustion Script, CF version MX7 to Authenticate with
 Windows Active Directory, Windows Server 2003?




 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290542
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Setting a value for CFTEXTAREA (richtext) via Javascript

2007-10-08 Thread Igor Ilyinsky
Is anyone really familiar with the way CF8 implements FCK? I'm trying to set
the innerHTML value for a richtext field via javascript, and am having no
luck finding the property. CF8 provides a nifty ColdFusion.getElementValue()
function, but no setElementValue function :( . I'm able to get the ID of the
field (document.MyFormName.MyFormField.id) but am not aware of a way to dup
out the properties of the object. I'd prefer not to have to go through the
trouble of binding, and just set it directly in my JS function. Any help
here is appreciated.

 

- Igor





~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290543
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Graphing date ranges...

2007-10-08 Thread Dawson, Michael
I second that suggestion.

http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:277365

M!ke 

-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED] 
Sent: Monday, October 08, 2007 5:45 AM
To: CF-Talk
Subject: RE: Graphing date ranges...

Hey pal,

If you're looking to fill in the holes where there is no data for a
particular date the best way to do this is with a Calendar table in your
database, you can then select the desired date range from this and LEFT
OUTTER JOIN it to your table with your statistics data, that way It'll
return a row for every date in the range, regardless of whether you have
data for that date or not, so you get no gaps.

It's more of a SQL type thing so you might be better off asking there,
and looking around for some help building and populating a Calendar
table, it's not an overly complicated task, but a calendar table will
really help you out for this and many other tasks too, I'd highly
recommend one.

Let me know if you need any more help Jay,

Rob

-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]
Sent: 08 October 2007 10:44
To: CF-Talk
Subject: Graphing date ranges...

I have a cfchart displaying dates along the X axis, is there any way to
get ColdFusion to treat these as a scale so that a 7 day gap in the data
would stretch the graph out to interpolate the missing days?

CFChart does have an xAxisType attribute but to set it to scale the
data must be numeric and I really want to keep the data displaying as
formatted dates.

--
Jay

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290545
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: AOP in ColdSpring and ModelGlue

2007-10-08 Thread Robert Rawlins - Think Blue
Hello Brian,

Thanks a great deal for the detailed reply, it does help make things a
little clearer. You're right to say that my example was hardcoded values and
this would most defiantly be difficult to validate using AOP, however in a
real working example I have a nice little validation service adapted from
Javier Julios data Validator component which allows me to define data
validation rules for variables by name, so the advice object would be
passing the variable 'name' off to the validation service and the service
would then find the correct rules for that variable and test it against them
accordingly. So in my case, being able validate variables on the fly using
AOP is certainly plausible.

Like you say the general principle of this process should be identical
regardless of whether I'm using MG or not, however the problem that arises
with MG is that the only way I can currently see this working is to adapt my
controllers so they contain a conditional which watches for returned values
from the proxy, and if there is one then act upon it by pushing the user
back to the form, however this seems to totally eliminate the benefits of an
AOP approach to the concerns as the whole point of AOP is to eliminate code
which doesn't concern the business logic.

If we're using something like before or after advice then this isn't a
problem as its effectively non responsive and has no control over the work
flow, however when trying to apply this 'about' advice, I can't see how it
can be done without defeating its own purpose of having to watch for
returned values. Unless of course we can give the advice object access to
the event object.

Thanks again mate,

Rob

-Original Message-
From: Brian Kotek [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 15:10
To: CF-Talk
Subject: Re: AOP in ColdSpring and ModelGlue

The fact that you're using Model-Glue should make no difference at all. If
it is, then you're thinking about it the wrong way. I see a few problems
with what you've said:

   - AOP is really meant to eliminate duplication by encapsulating a
   generic, common process so that it can be reused across many method calls
or
   components. I'm not sure validation really qualifies, since it is so
   specific to the particular object or data being validated. Usual suspects
   for AOP include logging, security, and data formatting. So I'm not sure
if
   what you're doing really lends itself to AOP in the first place, since I
   don't see how your code is reusable. The example you gave is hardcoding a
   call to getName() which already means this advice is really not going to
   work with other kinds of data.
   - You're right that the advice has no access to the Model-Glue event
   object. It shouldn't. You have access to whatever arguments were passed
into
   the original method, and access to any return value from that method. So
if
   your UserService returns an object or a struct indicating success or
   failure, along with error messages, you can manipulate that before it
gets
   returned back to the controller.

Basically, if you can imagine dropping Model-Glue and having a web service
call your Service (and your advice), and having it work and return data that
the web service could use, then you're at the right conceptual level.
Whenever this won't work (for example, you're wanting the advice to have
access to the Model-Glue event object, which obviously would be extremely
difficult if the client was a web service instead of Model-Glue), it means
you aren't keeping your application layers properly encapsulated.

Hope that helps.

Brian

On 10/8/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED]
wrote:


 Now this is where I become a little confused, see, in the old days I would
 validate the data inside my controller, and if the data failed validation
 I
 would add a result of 'failed' and update the viewstate with an error
 message, then use the events xml definition to pass the user back to the
 form if the result of 'failed' was present.


 However, from what I can see here I have no access to the event object
 from
 my advice object, so I'm not able to add results or update the view state,
 All I can do is simply return a value, is that correct? How do I use the
 advice object to control the user back to the form with an error message?
 I'm feeling a little confused about it.



 Thanks for any 'advice' guys, I really appreciate your time.



 Rob



 



~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290544
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Authenticate with Windows Active Directory, Windows Server 2003?

2007-10-08 Thread Tom Hines
If for some reason that would not work then could always just use CFLDAP


Ok, thanks. I googled that command and found this example. This one uses a 
cgi script so I guess I can just rewrite it to use coldfusion scripts.
..
Example
The following example uses the auth and status fields to determine whether the 
user is authenticated and the failure cause. It consists of three files that 
you put in the same directory:

A main cfntauthexample.cfm page that displays the name if the user is 
authenticated and contains a logout link. 
A login form page that is displayed if the user is not logged in. 
The Application.cfm page, which contains all the login, authentication, and 
logout processing code. 
For a full description of login processing, see ColdFusion MX Developer's 
Guide. For information on how this example works, see the comments in the code.

Save the following page as cfntauthenticateexample.cfm. To run the example, 
request this page in your browser or IDE.

!--- The Application.cfm page, which is processed each time a user
   requests this page, ensures that you log in first. ---
cfoutput
   h3Welcome #GetAuthUser()#/h3
   !--- A link to log out the user. ---
   a href=#CGI.script_name#?logout=YesLog Out/a 
/cfoutput
Save the following page as loginform.cfm:

!--- A simple login form that posts back to the page whose request initiated
   the login. ---
H2Please Log In/H2
cfform action=#CGI.script_name#
   !--- j_username and j_password are special names that populate cflogin tag
  variables. ---
   User Name: cfinput type=text name=j_username value=cfqa_user1
  required=Yesbr
   Password: cfinput type=password name=j_password value=cfqa_user1
  required=Yesbr
   Domain: cfinput type=text name=domain value=rnd required=Yesbr
   input type=submit value=Log In
/cfform
Save the following page as Application.cfm:

!--- If this page is executing in response to the user clicking a logout link,
  log out the user. The cflogin tag code will then run. ---
cfif IsDefined(URL.logout) AND URL.logout
   cflogout
/cfif

!--- The cflogin body code runs only if a user is not logged in. ---
cflogin
   !--- cflogin variable exists only if login credentials are available. ---
   cfif NOT IsDefined(cflogin)
  !--- Show a login form that posts back to the page whose request
  initiated the login, and do not process the rest of this page. ---
  cfinclude template=loginform.cfm
  cfabort
   cfelse
  !--- Trim any leading or trailing spaces from the username and password 
  submitted by the form. ---
  cfset theusername=trim(form.j_username)
  cfset thepassword=trim(form.j_password)
  cfset thedomain=trim(form.domain)
  cfntauthenticate username=#theusername# password=#thepassword#
 domain=#thedomain# result=authresult listgroups=yes
  !--- authresult.auth is True if the user is authenticated. ---
  cfif authresult.auth
 !--- Log user in to ColdFusion and set roles to the user's Groups. 
---
 cfloginuser name=#theusername# password=#thepassword#
roles=#authresult.groups#
  cfelse
 !--- The user was not authenticated. 
   Display an error message and the login form. ---
 cfoutput
cfif authresult.status IS AuthenticationFailure
   !--- The user is valid, but not the password. ---
   H2The password for #theusername# is not correctbr
  Please Try again/H2
cfelse
   !--- There is one other status value, invalid user name. ---
   H2The user name #theusername# is not validbr
  Please Try again/H2
/cfif
 /cfoutput
 cfinclude template=loginform.cfm
 cfabort
  /cfif
   /cfif
/cflogin


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290546
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Eclipse to DW WAS: RE: SOT: How do you version control with your CF code?

2007-10-08 Thread Dawson, Michael
Ingo, thanks for the reply.  I didn't mean to criticize Aptana's plugin
so harshly.  I noticed there was a recent update.  I'll install that
update and then go back through and make some notes on the issues I
found.

I have a hot project to finish in the next day or two, so it may be a
couple of days.

Thanks!

-Original Message-
From: Ingo Muschenetz [mailto:[EMAIL PROTECTED] 
Sent: Sunday, October 07, 2007 10:44 AM
To: CF-Talk
Subject: Re: Eclipse to DW WAS: RE: SOT: How do you version control with
your CF code?

Hi Mike,

I'm the project lead on Aptana, and I noticed you had mentioned our
atribute support was horrible in HTML. If you have time, it'd be very
helpful for us to hear specifics. We already show you which browsers
support which attributes and I thought we had pretty good HTML editing
support already, but in our latest beta version (milestone 10), we've
spent a lot of time trying to get the typing experience really polished
above and beyond other existing products. Anyway, any feedback you can
give would me much appreciated.

Thanks,
Ingo 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290548
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Authenticate with Windows Active Directory, Windows Server 2003?

2007-10-08 Thread Dawson, Michael
As previously suggested, I would also use CFLDAP.  You can pull back
lots of other information in addition to authenticating a user.

M!ke 

-Original Message-
From: Tom Hines [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 08, 2007 10:10 AM
To: CF-Talk
Subject: Authenticate with Windows Active Directory, Windows Server
2003?

What is the Coldfustion Script, CF version MX7 to Authenticate with
Windows Active Directory, Windows Server 2003?




~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290547
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: AOP in ColdSpring and ModelGlue

2007-10-08 Thread Matt Williams
My understanding of AOP is that it really shouldn't affect the process
flow of a request. Partly because it would be messy for it to have
access to the request (event, or whatever). And partly because it just
isn't what AOP is for.

As Brian mentioned, things like logging are more appropriate. I have
also used it for a notification type of service where if certain data
changes, I fire off an email. The advice is not changing any data, but
simply comparing old with new and acting upon that comparison.

AOP seems to make more sense for behind the scenes type of stuff, not
validation where a request will be changed based on the results of
that validation.
-- 
Matt Williams


On 10/8/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED] wrote:
 Hello Brian,

 Thanks a great deal for the detailed reply, it does help make things a
 little clearer. You're right to say that my example was hardcoded values and
 this would most defiantly be difficult to validate using AOP, however in a
 real working example I have a nice little validation service adapted from
 Javier Julios data Validator component which allows me to define data
 validation rules for variables by name, so the advice object would be
 passing the variable 'name' off to the validation service and the service
 would then find the correct rules for that variable and test it against them
 accordingly. So in my case, being able validate variables on the fly using
 AOP is certainly plausible.

 Like you say the general principle of this process should be identical
 regardless of whether I'm using MG or not, however the problem that arises
 with MG is that the only way I can currently see this working is to adapt my
 controllers so they contain a conditional which watches for returned values
 from the proxy, and if there is one then act upon it by pushing the user
 back to the form, however this seems to totally eliminate the benefits of an
 AOP approach to the concerns as the whole point of AOP is to eliminate code
 which doesn't concern the business logic.

 If we're using something like before or after advice then this isn't a
 problem as its effectively non responsive and has no control over the work
 flow, however when trying to apply this 'about' advice, I can't see how it
 can be done without defeating its own purpose of having to watch for
 returned values. Unless of course we can give the advice object access to
 the event object.

 Thanks again mate,

 Rob

 -Original Message-
 From: Brian Kotek [mailto:[EMAIL PROTECTED]
 Sent: 08 October 2007 15:10
 To: CF-Talk
 Subject: Re: AOP in ColdSpring and ModelGlue

 The fact that you're using Model-Glue should make no difference at all. If
 it is, then you're thinking about it the wrong way. I see a few problems
 with what you've said:

- AOP is really meant to eliminate duplication by encapsulating a
generic, common process so that it can be reused across many method calls
 or
components. I'm not sure validation really qualifies, since it is so
specific to the particular object or data being validated. Usual suspects
for AOP include logging, security, and data formatting. So I'm not sure
 if
what you're doing really lends itself to AOP in the first place, since I
don't see how your code is reusable. The example you gave is hardcoding a
call to getName() which already means this advice is really not going to
work with other kinds of data.
- You're right that the advice has no access to the Model-Glue event
object. It shouldn't. You have access to whatever arguments were passed
 into
the original method, and access to any return value from that method. So
 if
your UserService returns an object or a struct indicating success or
failure, along with error messages, you can manipulate that before it
 gets
returned back to the controller.

 Basically, if you can imagine dropping Model-Glue and having a web service
 call your Service (and your advice), and having it work and return data that
 the web service could use, then you're at the right conceptual level.
 Whenever this won't work (for example, you're wanting the advice to have
 access to the Model-Glue event object, which obviously would be extremely
 difficult if the client was a web service instead of Model-Glue), it means
 you aren't keeping your application layers properly encapsulated.

 Hope that helps.

 Brian

 On 10/8/07, Robert Rawlins - Think Blue
 [EMAIL PROTECTED]
 wrote:
 
 
  Now this is where I become a little confused, see, in the old days I would
  validate the data inside my controller, and if the data failed validation
  I
  would add a result of 'failed' and update the viewstate with an error
  message, then use the events xml definition to pass the user back to the
  form if the result of 'failed' was present.
 
 
  However, from what I can see here I have no access to the event object
  from
  my advice object, so I'm not able to add results or update the view state,
  

Re: Coldspring AOP on Transient Business Object, bad combo?

2007-10-08 Thread Tom Chiverton
On Friday 05 Oct 2007, [EMAIL PROTECTED] wrote:
 OK I was wrong on this because I was actually missing a crucial detail: the
 proxy factory deletes the temp CFC as soon as it is instantiated. This is
 so you don't end up with a ton of generated CFCs on the disk. So it would
 (in fact, it has to) regenerate the file to disk each time. 

Each time *the bean factory is created* is the important qualifier there.

-- 
Tom Chiverton
Helping to conveniently implement magnetic networks
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office.  Any reference to a partner in 
relation to Halliwells LLP means a member of Halliwells LLP.  Regulated by The 
Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290549
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Authenticate with Windows Active Directory, Windows Server 2003?

2007-10-08 Thread Aaron Rouse
Perhaps I should have typed if that would not work for someones needs  We
have ran into a few times where it just was not right for the job at hand
and actually have since just always used our objects that wrap the CFLDAP
calls.

On 10/8/07, Tom Hines [EMAIL PROTECTED] wrote:

 If for some reason that would not work then could always just use CFLDAP
 
 
 Ok, thanks. I googled that command and found this example. This one uses
 a cgi script so I guess I can just rewrite it to use coldfusion scripts.
 ..
 Example
 The following example uses the auth and status fields to determine whether
 the user is authenticated and the failure cause. It consists of three files
 that you put in the same directory:

 A main cfntauthexample.cfm page that displays the name if the user is
 authenticated and contains a logout link.
 A login form page that is displayed if the user is not logged in.
 The Application.cfm page, which contains all the login, authentication,
 and logout processing code.
 For a full description of login processing, see ColdFusion MX Developer's
 Guide. For information on how this example works, see the comments in the
 code.

 Save the following page as cfntauthenticateexample.cfm. To run the
 example, request this page in your browser or IDE.

 !--- The Application.cfm page, which is processed each time a user
requests this page, ensures that you log in first. ---
 cfoutput
h3Welcome #GetAuthUser()#/h3
!--- A link to log out the user. ---
a href=#CGI.script_name#?logout=YesLog Out/a
 /cfoutput
 Save the following page as loginform.cfm:

 !--- A simple login form that posts back to the page whose request
 initiated
the login. ---
 H2Please Log In/H2
 cfform action=#CGI.script_name#
!--- j_username and j_password are special names that populate cflogin
 tag
   variables. ---
User Name: cfinput type=text name=j_username value=cfqa_user1
   required=Yesbr
Password: cfinput type=password name=j_password value=cfqa_user1
   required=Yesbr
Domain: cfinput type=text name=domain value=rnd
 required=Yesbr
input type=submit value=Log In
 /cfform
 Save the following page as Application.cfm:

 !--- If this page is executing in response to the user clicking a logout
 link,
   log out the user. The cflogin tag code will then run. ---
 cfif IsDefined(URL.logout) AND URL.logout
cflogout
 /cfif

 !--- The cflogin body code runs only if a user is not logged in. ---
 cflogin
!--- cflogin variable exists only if login credentials are available.
 ---
cfif NOT IsDefined(cflogin)
   !--- Show a login form that posts back to the page whose request
   initiated the login, and do not process the rest of this page. ---
   cfinclude template=loginform.cfm
   cfabort
cfelse
   !--- Trim any leading or trailing spaces from the username and
 password
   submitted by the form. ---
   cfset theusername=trim(form.j_username)
   cfset thepassword=trim(form.j_password)
   cfset thedomain=trim(form.domain)
   cfntauthenticate username=#theusername# password=#thepassword#
  domain=#thedomain# result=authresult listgroups=yes
   !--- authresult.auth is True if the user is authenticated. ---
   cfif authresult.auth
  !--- Log user in to ColdFusion and set roles to the user's
 Groups. ---
  cfloginuser name=#theusername# password=#thepassword#
 roles=#authresult.groups#
   cfelse
  !--- The user was not authenticated.
Display an error message and the login form. ---
  cfoutput
 cfif authresult.status IS AuthenticationFailure
!--- The user is valid, but not the password. ---
H2The password for #theusername# is not correctbr
   Please Try again/H2
 cfelse
!--- There is one other status value, invalid user name.
 ---
H2The user name #theusername# is not validbr
   Please Try again/H2
 /cfif
  /cfoutput
  cfinclude template=loginform.cfm
  cfabort
   /cfif
/cfif
 /cflogin


 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290551
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Debuggin Flash Forms

2007-10-08 Thread Rick Root
So, I've got this page with a somewhat complex flash form on it... no
actionscript or anything.. just a lot of elements, a tab navigator,
etc...

Seems to have stopped working after the CF8 upgrade.

No errors are generated in the application.log or exception.log, I
just get no form

Anyone got any suggestions here?  Kinda hard to debug problems with no errors :)

-- 
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290553
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: AOP in ColdSpring and ModelGlue

2007-10-08 Thread Brian Kotek
On 10/8/07, Robert Rawlins - Think Blue [EMAIL PROTECTED]
wrote:

 Hello Brian,

 Thanks a great deal for the detailed reply, it does help make things a
 little clearer. You're right to say that my example was hardcoded values
 and
 this would most defiantly be difficult to validate using AOP, however in a
 real working example I have a nice little validation service adapted from
 Javier Julios data Validator component which allows me to define data
 validation rules for variables by name, so the advice object would be
 passing the variable 'name' off to the validation service and the service
 would then find the correct rules for that variable and test it against
 them
 accordingly. So in my case, being able validate variables on the fly using
 AOP is certainly plausible.


It sounds possible, but doesn't this essentially mean every variable name in
your system has to be unique? What if I have a customer with a name and a
user with a name? It seems like an odd way to perform validation, unless I'm
misreading. I'm also still not convinced that just because it is possible
means it's a good idea. It seems like validation is something you really
want explicitly attached to the business object being validated, since these
are really business rules. In other words, under what condition would you
*not* want to validate a business object? Maybe it's just because I perform
validation quite differently and I might be missing some underlying benefit
of what you're proposing. (I have a Validator composed into my business
objects, which handle validation using either database metadata or XML
validation rules.)

Like you say the general principle of this process should be identical
 regardless of whether I'm using MG or not, however the problem that arises
 with MG is that the only way I can currently see this working is to adapt
 my
 controllers so they contain a conditional which watches for returned
 values
 from the proxy, and if there is one then act upon it by pushing the user
 back to the form, however this seems to totally eliminate the benefits of
 an
 AOP approach to the concerns as the whole point of AOP is to eliminate
 code
 which doesn't concern the business logic.

 If we're using something like before or after advice then this isn't a
 problem as its effectively non responsive and has no control over the work
 flow, however when trying to apply this 'about' advice, I can't see how it
 can be done without defeating its own purpose of having to watch for
 returned values. Unless of course we can give the advice object access to
 the event object.


Well you could always try to pass the event into the Proxy as an argument,
but I think that would be a bad idea. I suppose my take might be:

   1. Pass data into the AOP Proxy
   2. AOP Proxy calls runs the validation rules on the incoming data.
   3. If data is valid, pass the data on into the target Service object
   and let it do it's work
   4. Proxy creates an instance of a Result object and populates it with
   errors array, messages, or whatever data you will need for later processing
   5. Proxy returns the Result object to the caller (in this case the MG
   Controleller)
   6. MG Controller can call something like result.isSuccess() to
   determine what results it needs to add to the event queue.

Would something like that work for you?


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290552
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: AOP in ColdSpring and ModelGlue

2007-10-08 Thread Robert Rawlins - Think Blue
Thanks Matt,

I generally agree with you that it works best when not interrupting the
application flow, i.e logging, however, It seems that everyone is quite
happy to utilize AOP to implement security concerns, and obviously
validating and confirming security credentials or authenticating a user is
really no different to validating a piece of data, either can return true or
false and need to be acted upon accordingly, or are they referring to
something different when they discuss 'security'?

Thanks guys,

Rob

-Original Message-
From: Matt Williams [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 16:04
To: CF-Talk
Subject: Re: AOP in ColdSpring and ModelGlue

My understanding of AOP is that it really shouldn't affect the process
flow of a request. Partly because it would be messy for it to have
access to the request (event, or whatever). And partly because it just
isn't what AOP is for.

As Brian mentioned, things like logging are more appropriate. I have
also used it for a notification type of service where if certain data
changes, I fire off an email. The advice is not changing any data, but
simply comparing old with new and acting upon that comparison.

AOP seems to make more sense for behind the scenes type of stuff, not
validation where a request will be changed based on the results of
that validation.
-- 
Matt Williams


On 10/8/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED] wrote:
 Hello Brian,

 Thanks a great deal for the detailed reply, it does help make things a
 little clearer. You're right to say that my example was hardcoded values
and
 this would most defiantly be difficult to validate using AOP, however in a
 real working example I have a nice little validation service adapted from
 Javier Julios data Validator component which allows me to define data
 validation rules for variables by name, so the advice object would be
 passing the variable 'name' off to the validation service and the service
 would then find the correct rules for that variable and test it against
them
 accordingly. So in my case, being able validate variables on the fly using
 AOP is certainly plausible.

 Like you say the general principle of this process should be identical
 regardless of whether I'm using MG or not, however the problem that arises
 with MG is that the only way I can currently see this working is to adapt
my
 controllers so they contain a conditional which watches for returned
values
 from the proxy, and if there is one then act upon it by pushing the user
 back to the form, however this seems to totally eliminate the benefits of
an
 AOP approach to the concerns as the whole point of AOP is to eliminate
code
 which doesn't concern the business logic.

 If we're using something like before or after advice then this isn't a
 problem as its effectively non responsive and has no control over the work
 flow, however when trying to apply this 'about' advice, I can't see how it
 can be done without defeating its own purpose of having to watch for
 returned values. Unless of course we can give the advice object access to
 the event object.

 Thanks again mate,

 Rob

 -Original Message-
 From: Brian Kotek [mailto:[EMAIL PROTECTED]
 Sent: 08 October 2007 15:10
 To: CF-Talk
 Subject: Re: AOP in ColdSpring and ModelGlue

 The fact that you're using Model-Glue should make no difference at all. If
 it is, then you're thinking about it the wrong way. I see a few problems
 with what you've said:

- AOP is really meant to eliminate duplication by encapsulating a
generic, common process so that it can be reused across many method
calls
 or
components. I'm not sure validation really qualifies, since it is so
specific to the particular object or data being validated. Usual
suspects
for AOP include logging, security, and data formatting. So I'm not sure
 if
what you're doing really lends itself to AOP in the first place, since
I
don't see how your code is reusable. The example you gave is hardcoding
a
call to getName() which already means this advice is really not going
to
work with other kinds of data.
- You're right that the advice has no access to the Model-Glue event
object. It shouldn't. You have access to whatever arguments were passed
 into
the original method, and access to any return value from that method.
So
 if
your UserService returns an object or a struct indicating success or
failure, along with error messages, you can manipulate that before it
 gets
returned back to the controller.

 Basically, if you can imagine dropping Model-Glue and having a web service
 call your Service (and your advice), and having it work and return data
that
 the web service could use, then you're at the right conceptual level.
 Whenever this won't work (for example, you're wanting the advice to have
 access to the Model-Glue event object, which obviously would be extremely
 difficult if the client was a web service instead of Model-Glue), it means
 

Re: Debuggin Flash Forms

2007-10-08 Thread Rick Root
I seem to be having a problem with all flash forms on my server.

https://www.it.dev.duke.edu/public/search.cfm

-- 
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290555
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: AOP in ColdSpring and ModelGlue

2007-10-08 Thread Brian Kotek
On 10/8/07, Robert Rawlins - Think Blue [EMAIL PROTECTED]
wrote:

 Thanks Matt,

 I generally agree with you that it works best when not interrupting the
 application flow, i.e logging, however, It seems that everyone is quite
 happy to utilize AOP to implement security concerns, and obviously
 validating and confirming security credentials or authenticating a user is
 really no different to validating a piece of data, either can return true
 or
 false and need to be acted upon accordingly, or are they referring to
 something different when they discuss 'security'?


In general, a Security Advice would throw an exception if the authentication
fails. It would then be up to the client code to handle the exception.


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290558
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF Coding Standards

2007-10-08 Thread Claude Schneegans
 The first is a superfluous use of carriage returns in my opinion and does
nothing to improve readability.


The idea is that if a line is too long, it will be broken in your editor 
anyway, so better break it yourself at some logical points,
indent it, and make it more readable, ie:

cfargument name=sfirstName
type=string
required=true
hint=first name of person
/

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290556
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: AOP in ColdSpring and ModelGlue

2007-10-08 Thread Robert Rawlins - Think Blue
Thanks Brian,

Yeah I see your point about validation being a business concern, however,
like you say because it is something that concerns all elements of the
application, then does that not make it a cross cutting one?

I've just done a little bit of hunting around on the web and there seems to
be lots of articles for using SPRING (the JAVA father of CS) to implement a
standard of data validation across the entire application, so it would seem
the principle has been explored before.

Now I agree that you should really be validating every business object,
however I'm thinking about building this proxy layer between the controller
and the model, and all data coming from the controller is generally user
generated, from a form or url, and in my mind this is perhaps the best place
to validate the data, before it actually gets into the business objects
rather than once its arrived.

Now the way in which I envisage the validation working would impose a
certain amount of naming convention amongst my application, however this can
work well for me, for instance, I have Users, Guests, Tech Support Staff,
Suppliers, News Letter Subscribes etc ... now all of those objects have a
First Name, Last Name, Email Address etc... so It makes good business sense
to apply the same rule to all those objects, so they all have their
variables named identically, i.e. FirstName, then I need only define one
valuation rule, in one location for the variable named 'FirstName' and know
that it is safely applied to all of my objects, and the data being passed
into them. Does that make sense? This is a new concept that I knocked up
over the weekend for me so it's still a little sketchy.

Rob

-Original Message-
From: Brian Kotek [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 16:10
To: CF-Talk
Subject: Re: AOP in ColdSpring and ModelGlue

On 10/8/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED]
wrote:

 Hello Brian,

 Thanks a great deal for the detailed reply, it does help make things a
 little clearer. You're right to say that my example was hardcoded values
 and
 this would most defiantly be difficult to validate using AOP, however in a
 real working example I have a nice little validation service adapted from
 Javier Julios data Validator component which allows me to define data
 validation rules for variables by name, so the advice object would be
 passing the variable 'name' off to the validation service and the service
 would then find the correct rules for that variable and test it against
 them
 accordingly. So in my case, being able validate variables on the fly using
 AOP is certainly plausible.


It sounds possible, but doesn't this essentially mean every variable name in
your system has to be unique? What if I have a customer with a name and a
user with a name? It seems like an odd way to perform validation, unless I'm
misreading. I'm also still not convinced that just because it is possible
means it's a good idea. It seems like validation is something you really
want explicitly attached to the business object being validated, since these
are really business rules. In other words, under what condition would you
*not* want to validate a business object? Maybe it's just because I perform
validation quite differently and I might be missing some underlying benefit
of what you're proposing. (I have a Validator composed into my business
objects, which handle validation using either database metadata or XML
validation rules.)

Like you say the general principle of this process should be identical
 regardless of whether I'm using MG or not, however the problem that arises
 with MG is that the only way I can currently see this working is to adapt
 my
 controllers so they contain a conditional which watches for returned
 values
 from the proxy, and if there is one then act upon it by pushing the user
 back to the form, however this seems to totally eliminate the benefits of
 an
 AOP approach to the concerns as the whole point of AOP is to eliminate
 code
 which doesn't concern the business logic.

 If we're using something like before or after advice then this isn't a
 problem as its effectively non responsive and has no control over the work
 flow, however when trying to apply this 'about' advice, I can't see how it
 can be done without defeating its own purpose of having to watch for
 returned values. Unless of course we can give the advice object access to
 the event object.


Well you could always try to pass the event into the Proxy as an argument,
but I think that would be a bad idea. I suppose my take might be:

   1. Pass data into the AOP Proxy
   2. AOP Proxy calls runs the validation rules on the incoming data.
   3. If data is valid, pass the data on into the target Service object
   and let it do it's work
   4. Proxy creates an instance of a Result object and populates it with
   errors array, messages, or whatever data you will need for later
processing
   5. Proxy returns the Result object to the caller (in 

Re: CF Coding Standards

2007-10-08 Thread Tom Chiverton
 I also think the over use of new lines doesn't help with readability either

 cfargument name=sfirstName
 type=string
 required=true
 hint=first name of person
 /

Where as I find newline+indent really helps:
cfargument name=sfirstName
type=string
required=true
hint=first name of person/


-- 
Tom Chiverton
Helping to efficiently initiate magnetic niches
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office.  Any reference to a partner in 
relation to Halliwells LLP means a member of Halliwells LLP.  Regulated by The 
Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290559
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Debuggin Flash Forms

2007-10-08 Thread Cutter (CFRelated)
Hey Rick,

What seems to be the problem? I'm getting the Flash form on your link 
just fine. No submit, but you didn't seem to have included one either.

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

Rick Root wrote:
 I seem to be having a problem with all flash forms on my server.
 
 https://www.it.dev.duke.edu/public/search.cfm
 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290560
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF Coding Standards

2007-10-08 Thread Aaron Rouse
If I put attributes like that on a new line, I always try to make a note to
line up the first letters like how you have posted.  Sometimes I get
adventurous and line them all up meaning they are lined up with the n on
name.

On 10/8/07, Tom Chiverton [EMAIL PROTECTED] wrote:

  I also think the over use of new lines doesn't help with readability
 either
 
  cfargument name=sfirstName
  type=string
  required=true
  hint=first name of person
  /

 Where as I find newline+indent really helps:
 cfargument name=sfirstName
 type=string
 required=true
 hint=first name of person/


 --
 Tom Chiverton
 Helping to efficiently initiate magnetic niches
 on: http://thefalken.livejournal.com

 

 This email is sent for and on behalf of Halliwells LLP.

 Halliwells LLP is a limited liability partnership registered in England
 and Wales under registered number OC307980 whose registered office address
 is at St James's Court Brown Street Manchester M2 2JF.  A list of members is
 available for inspection at the registered office.  Any reference to a
 partner in relation to Halliwells LLP means a member of Halliwells
 LLP.  Regulated by The Solicitors Regulation Authority.

 CONFIDENTIALITY

 This email is intended only for the use of the addressee named above and
 may be confidential or legally privileged.  If you are not the addressee you
 must not read it and must not use any information contained in nor copy it
 nor inform any person other than Halliwells LLP or the addressee of its
 existence or contents.  If you have received this email in error please
 delete it and notify Halliwells LLP IT Department on 0870 365 8008.

 For more information about Halliwells LLP visit www.halliwells.com.

 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290561
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF8, JBoss and Apache

2007-10-08 Thread austen rustrum
Maureen,

Will the mod_jrun.so work with JBoss?  I tried following the instructions in 
the URL below for configuring Apache, but it doesn't seem that the same tools 
are installed when you build the EAR version of ColdFusion.  I don't have a web 
server configuration tool at least.  Did you get these tools when installing 
ColdFusion as an EAR?

Thanks,
Austen

 Hi - Not familiar with jboss, but as with any other container why 
 wouldn't
 you load up mod_jrun.so and mount jrun's port in your apache conf?
 http://livedocs.adobe.
 com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.
 htm?context=ColdFusion_Documentationfile=0049.htm
 
 I don't do windows, but seems to me you might be better off mapping 
 the
 drive. Easier on you anyway.
 
 I hope this helps, just a little.
 -- 
 Maureen Barger CIT Information Systems
 120 Maple Ave. Cornell University
 [EMAIL PROTECTED]
 
 
 On Fri, October 5, 2007 16:36, austen rustrum wrote:
  I'm looking for some advice here...  I currently have CF8 installed 
 as an
  (extracted) EAR on JBoss 4.2.1.GA.  This is running on a server that 
 is
  separate from my web server, which is Apache 2.2.4.  Also, my 
 application
  code is hosted on network drive where it is (or will be, anyhow) 
 shared
  between multiple CF instances.  Whether or not this is an ideal
  infrastructure or not, it is a constraint imposed upon me by my IT
  department, so I am looking for solutions within this framework, not 
 an
  alternative setup.  Here are my questions:
 
  1) How should I setup Apache so I can access my pages like so
  http://mydomain/index.cfm?  Do I need to use the mod_proxy or 
 something
  similar?  I admit, I'm an IIS weenie, so I don't have much 
 experience
  here.  JBoss is running on port 8080 if that matters...
 
  2) Is it possible to host my application code on a separate network 
 drive?
   How do I configure JBoss or CF to handle that?  Do I just need to 
 add a
  mapping?  Again, my experience in J2EE deployments of CF is very 
 limited.
 
  Thanks!
  Austen
 
 


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290563
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: AOP in ColdSpring and ModelGlue

2007-10-08 Thread Brian Kotek
On 10/8/07, Robert Rawlins - Think Blue [EMAIL PROTECTED]
wrote:

 Now I agree that you should really be validating every business object,
 however I'm thinking about building this proxy layer between the
 controller
 and the model, and all data coming from the controller is generally user
 generated, from a form or url, and in my mind this is perhaps the best
 place
 to validate the data, before it actually gets into the business objects
 rather than once its arrived.


I think this is where your approach will break down. I would disagree that
the best place to validate the data is before it gets to the business
object. In fact, for anything other than the most trivial validation, this
can get very convoluted. Because what you really want to validate isn't the
data itself, it's the state of the business object. So it's easy to
pre-validate data based on very simple rules like this must not be empty
or this must be numeric. But any complex property of the object requires
actually using the business logic in the object itself to determine whether
something is valid or not. What if I want to validate that the user's user
name is unique (via a call to a data access object that is composed into the
User object)? What if I want to validate that an Order is only valid if the
associated customer has no outstanding invoices (order has a customer via
composition)? Unless you're going to duplicate (or move) the logic to do
this out of the actual business object, which I think would probably be a
bad idea, trying to validate the data *before* it gets to the business
object in question seems to rapidly hit a dead end. This is especially true
if you are going the route of rich business objects that actually have
behavior instead of being nothing but dumb beans (properties with getters
and setters).

All that said, it still doesn't mean you couldn't do this with AOP. It just
means I would look at having the advice get the object from the service and
then pass it into a validator. When I do validation, I usually do something
like this from within my business object: getValidator().validate(this),
which means the validator has a reference to the actual object itself and
can call methods on it to validate it, rather than relying on nothing but
the instance data which has no behavior at all. It's fairly easy to define
rules that all validators can use (along with custom rules for specific
situations), but again, I personally wouldn't try doing it with AOP.


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290564
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Isssues with cfselect

2007-10-08 Thread Steve Sequenzia
I cannot seem to figure this out.

I have a table called dirs. It has columns named: dirID, dirPath and 
parentDirID.

The parentDirID handles the hierarchy.

All I need to do is have a cfselect that lists all the dirPaths but defaults to 
the parentDirID of the selected dir.

Here is the code:

cfquery name=getAll datasource=pcap

SELECT dirID, dirPath
FROM dirs
WHERE status = '1'
ORDER BY dirPath

/cfquery

cfquery name=getCurrent datasource=pcap

SELECT parentDirID
FROM dirs
WHERE dirID = '#url.dirID#'

/cfquery

cfform

cfselect name=parentID query=getAll display=dirPath value=dirID 
selected=#getCurrent.parentDirID#/cfselect

/cfform

I know I have done stuff like this before but I think it is getting confused 
(or I am getting confused) because it is in the same table.

Any help on this would be great.

Thanks. 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290562
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CF Coding Standards

2007-10-08 Thread Robert Rawlins - Think Blue
Hehe, it's funny how people have different trends isn't it, I can't stand
having my code lined and indented like this, it makes me feel giddy when I'm
looking at it. I have other odd traits though, like capitalizing my scopes
like VARIABLES and ARGUMENTS, I find that now if I'm looking through
someone's code and they haven't don't it, their scopes almost appear
invisible to me.

Rob

-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 17:00
To: CF-Talk
Subject: Re: CF Coding Standards

If I put attributes like that on a new line, I always try to make a note to
line up the first letters like how you have posted.  Sometimes I get
adventurous and line them all up meaning they are lined up with the n on
name.

On 10/8/07, Tom Chiverton [EMAIL PROTECTED] wrote:

  I also think the over use of new lines doesn't help with readability
 either
 
  cfargument name=sfirstName
  type=string
  required=true
  hint=first name of person
  /

 Where as I find newline+indent really helps:
 cfargument name=sfirstName
 type=string
 required=true
 hint=first name of person/


 --
 Tom Chiverton
 Helping to efficiently initiate magnetic niches
 on: http://thefalken.livejournal.com

 

 This email is sent for and on behalf of Halliwells LLP.

 Halliwells LLP is a limited liability partnership registered in England
 and Wales under registered number OC307980 whose registered office address
 is at St James's Court Brown Street Manchester M2 2JF.  A list of members
is
 available for inspection at the registered office.  Any reference to a
 partner in relation to Halliwells LLP means a member of Halliwells
 LLP.  Regulated by The Solicitors Regulation Authority.

 CONFIDENTIALITY

 This email is intended only for the use of the addressee named above and
 may be confidential or legally privileged.  If you are not the addressee
you
 must not read it and must not use any information contained in nor copy it
 nor inform any person other than Halliwells LLP or the addressee of its
 existence or contents.  If you have received this email in error please
 delete it and notify Halliwells LLP IT Department on 0870 365 8008.

 For more information about Halliwells LLP visit www.halliwells.com.

 



~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290565
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Null Values

2007-10-08 Thread Richard White
Hi, i am getting data out of a database. i need to be able to check if a value 
returned  in a query is null.

i am trying to use the following code but it is not working

cfif questionTextVariables.minTextLimit is null

it seems a bit strange that the word null is not going blue to indicate that it 
is a recognised word.

thanks for the help

richard 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290566
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Null Values

2007-10-08 Thread Charlie Griefer
CF doesn't recognize the concept of a null value.  it converts null
values into empty strings.

cfif questionTextVariables.minTextLimit is 

from a database perspective, there's absolutely a difference between
NULL (no value exists) and empty string (a string of zero length
exists).  However, CF does not make that distinction :(


On 10/8/07, Richard White [EMAIL PROTECTED] wrote:
 Hi, i am getting data out of a database. i need to be able to check if a 
 value returned  in a query is null.

 i am trying to use the following code but it is not working

 cfif questionTextVariables.minTextLimit is null

 it seems a bit strange that the word null is not going blue to indicate that 
 it is a recognised word.

 thanks for the help

 richard

 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290567
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: AOP in ColdSpring and ModelGlue

2007-10-08 Thread Robert Rawlins - Think Blue
Ah I see!,

I hadn't considered the ramifications of the more complex validation, like
you say, those that involve cross checks between objects and database calls,
these would certainly be more difficult to implement using AOP or a generic
class. I understand your thinking here completely. 

I have just started reading an article about a Validation framework built in
JAVA which uses Spring and AOP, the idea being that you can implement a
blanket validation process for these more 'trivial' tasks and data
comparisons using AOP, which helps save development time, and then in the
underlying model and business logic you can manually build these more
complex validation checks.

I think that building a system which allows space for both may work well, as
it leverages the power of the framework to free up time doing the more
trivial tasks and at least ensures a basic level of volition across the
entire application, yet allows you to then extend that with non AOP business
logic validation for the more complex data?

Thanks again Brian, I hadn't considered those more complex validation
problems,

Rob

-Original Message-
From: Brian Kotek [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2007 17:05
To: CF-Talk
Subject: Re: AOP in ColdSpring and ModelGlue

On 10/8/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED]
wrote:

 Now I agree that you should really be validating every business object,
 however I'm thinking about building this proxy layer between the
 controller
 and the model, and all data coming from the controller is generally user
 generated, from a form or url, and in my mind this is perhaps the best
 place
 to validate the data, before it actually gets into the business objects
 rather than once its arrived.


I think this is where your approach will break down. I would disagree that
the best place to validate the data is before it gets to the business
object. In fact, for anything other than the most trivial validation, this
can get very convoluted. Because what you really want to validate isn't the
data itself, it's the state of the business object. So it's easy to
pre-validate data based on very simple rules like this must not be empty
or this must be numeric. But any complex property of the object requires
actually using the business logic in the object itself to determine whether
something is valid or not. What if I want to validate that the user's user
name is unique (via a call to a data access object that is composed into the
User object)? What if I want to validate that an Order is only valid if the
associated customer has no outstanding invoices (order has a customer via
composition)? Unless you're going to duplicate (or move) the logic to do
this out of the actual business object, which I think would probably be a
bad idea, trying to validate the data *before* it gets to the business
object in question seems to rapidly hit a dead end. This is especially true
if you are going the route of rich business objects that actually have
behavior instead of being nothing but dumb beans (properties with getters
and setters).

All that said, it still doesn't mean you couldn't do this with AOP. It just
means I would look at having the advice get the object from the service and
then pass it into a validator. When I do validation, I usually do something
like this from within my business object: getValidator().validate(this),
which means the validator has a reference to the actual object itself and
can call methods on it to validate it, rather than relying on nothing but
the instance data which has no behavior at all. It's fairly easy to define
rules that all validators can use (along with custom rules for specific
situations), but again, I personally wouldn't try doing it with AOP.




~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290568
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF Coding Standards

2007-10-08 Thread Sean Corfield
On 10/8/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED] wrote:
 Hehe, it's funny how people have different trends isn't it, I can't stand
 having my code lined and indented like this, it makes me feel giddy when I'm
 looking at it. I have other odd traits though, like capitalizing my scopes
 like VARIABLES and ARGUMENTS, I find that now if I'm looking through
 someone's code and they haven't don't it, their scopes almost appear
 invisible to me.

This thread is a great example of why specifics of whitespace,
indentation and the minutiae of naming is such a waste of time,
compared to readability and maintainability at a grander scale.

In many ways, the meat is in the Mach-II Coding Guidelines on
LiveDocs rather than the general ColdFusion Coding Guidelines:

http://livedocs.adobe.com/wtg/public/machiidevguide/index.html

Although it focuses on Mach-II, much of the advice about application
structure applies to other frameworks (and to non-framework code that
uses CFCs).
-- 
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290569
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CF Coding Standards

2007-10-08 Thread Dawson, Michael
I like the method of lining up the attributes AND equal signs.  I
beginning to switch to this format for long tag definitions.

cfargument name = sfirstName
type = string
required = true
hint = first name of person


M!ke

-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 08, 2007 10:48 AM
To: CF-Talk
Subject: Re: CF Coding Standards

 I also think the over use of new lines doesn't help with readability 
 either

 cfargument name=sfirstName
 type=string
 required=true
 hint=first name of person
 /

Where as I find newline+indent really helps:
cfargument name=sfirstName
type=string
required=true
hint=first name of person/


--
Tom Chiverton

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290570
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF8, JBoss and Apache

2007-10-08 Thread austen rustrum
Thanks, Larry.  I did take a look at this, but the directions didn't seem to 
work quite right for the version of Apache that I am using.  It is a good 
starting point though.

Thanks,
Austen

 While I'm no expert, having just started with JBoss, I found a set of 
 blog postings by Steve Brownlee on setting up CF on Jboss and Apache. 
 http://www.fusioncube.net/?p=111
 
 hth,
 
 larry
 
 
  I'm looking for some advice here...  I currently have CF8 installed 
 as 
  an (extracted) EAR on JBoss 4.2.1.GA.  This is running on a server 
  that is separate from my web server, which is Apache 2.2.4.  Also, 
 my 
  application code is hosted on network drive where it is (or will be, 
 
  anyhow) shared between multiple CF instances.  Whether or not this 
 is 
  an ideal infrastructure or not, it is a constraint imposed upon me 
 by 
  my IT department, so I am looking for solutions within this 
 framework, 
  not an alternative setup.  Here are my questions:
  
  1) How should I setup Apache so I can access my pages like so 
  http://mydomain/index.cfm?  Do I need to use the mod_proxy or 
  something similar?  I admit, I'm an IIS weenie, so I don't have much 
 
  experience here.  JBoss is running on port 8080 if that matters...
  
  2) Is it possible to host my application code on a separate network 
 
  drive?  How do I configure JBoss or CF to handle that?  Do I just 
 need 
  to add a mapping?  Again, my experience in J2EE deployments of CF is 
 
  very limited.
  
  Thanks!
  Austen 


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290572
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Null Values

2007-10-08 Thread Richard White
perfect, thanks very much charlie :)

in relation to the issue of null values being different to empty strings in the 
database, am i right by saying the only way to get round this would be to 
create a stored procedure that ran sql code to test for a null value or empty 
string then pass back a result to cf telling it whether it is null or an empty 
string?

thanks 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290571
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF8, JBoss and Apache

2007-10-08 Thread austen rustrum
Assuming I have a drive mapped, what additional steps would I have to take?  Is 
this something that I have to configure in JBoss or Apache or both?  Is this 
something I would do in the web.xml file or something similar?  

Thanks,
Austen

As long as it is mapped...there shouldn't be a problem...other that
potential slowdowns from network traffic.

Eric

I'm looking for some advice here...  I currently have CF8 installed as an
(extracted) EAR on JBoss 4.2.1.GA.  This is running on a server that is
separate from my web server, which is Apache 2.2.4.  Also, my application
code is hosted on network drive where it is (or will be, anyhow) shared
between multiple CF instances.  Whether or not this is an ideal
infrastructure or not, it is a constraint imposed upon me by my IT
department, so I am looking for solutions within this framework, not an
alternative setup.  Here are my questions:

1) How should I setup Apache so I can access my pages like so
http://mydomain/index.cfm?  Do I need to use the mod_proxy or something
similar?  I admit, I'm an IIS weenie, so I don't have much experience here.
JBoss is running on port 8080 if that matters...

2) Is it possible to host my application code on a separate network drive?
How do I configure JBoss or CF to handle that?  Do I just need to add a
mapping?  Again, my experience in J2EE deployments of CF is very limited.

Thanks!
Austen 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290574
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: File extension does not match MIME type

2007-10-08 Thread Darren Houle
 What are you doing at the mo ?
 
 cfcontent type=application/x-shockwave-flash reset=true
 cfheader name=content-disposition value=attachment; filename=a.
 swf
 
 ?


Actually no, what I was doing was running the following code from a .cfm page:

cfreport template=#url.reportName#.cfr format=flashpaper

So the extension of the requested page was .cfm but the MIME type of the actual 
content returned was application/x-shockwave-flash

What I ultimately wound up doing to solve this problem was having cfreport 
create a file and then cflocate to it:

cfset currentDir = getDirectoryFromPath(getCurrentTemplatePath())
cfdirectory directory=#currentDir# name=fileList filter=report_*.swf
cfloop query=fileList
cffile action=delete file=#currentDir##fileList.name#
/cfloop
cfset filename = report_#GetTickCount()#.swf
cfreport
 template=#url.reportName#.cfr
 format=flashpaper
 filename=#currentDir##filename#
cflocation addtoken=no url=#filename#

This way the cfreport tag creates an actual file that I can cflocate to, 
therefore the user winds up pulling back a .swf file with a MIME type of 
application/x-shockwave-flash.  Since the file extension and MIME now match, no 
more security warnings. 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290573
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Null Values

2007-10-08 Thread Qasim Rasheed
Instead of Stored procedure, you can simply do this

CASE WHEN col is NULL THEN 'YOURINDICATORFORNULL'
ELSE col
END AS col

HTH

On 10/8/07, Richard White [EMAIL PROTECTED] wrote:

 perfect, thanks very much charlie :)

 in relation to the issue of null values being different to empty strings
 in the database, am i right by saying the only way to get round this would
 be to create a stored procedure that ran sql code to test for a null value
 or empty string then pass back a result to cf telling it whether it is null
 or an empty string?

 thanks

 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290576
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Debuggin Flash Forms

2007-10-08 Thread Rick Root
Neat, it comes up in Firefox.

the problem is that it doesn't come up in Internet Explorer 7.  I
don't know why.

I do get a javascript error in IE, but I assume it's because the flash
object isn't loaded.

rick

On 10/8/07, Cutter (CFRelated) [EMAIL PROTECTED] wrote:
 Hey Rick,

 What seems to be the problem? I'm getting the Flash form on your link
 just fine. No submit, but you didn't seem to have included one either.

 Steve Cutter Blades
 Adobe Certified Professional
 Advanced Macromedia ColdFusion MX 7 Developer
 _
 http://blog.cutterscrossing.com

 Rick Root wrote:
  I seem to be having a problem with all flash forms on my server.
 
  https://www.it.dev.duke.edu/public/search.cfm
 

 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290575
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Null Values

2007-10-08 Thread Charlie Griefer
if you really need to distinguish between the 2 at the CF level (-if-)...

you could just the coalesce() function...

SELECT
column1,
coalesce(column2, NULL, 'nothing here'), -- the column which holds
the potentially NULL value
column3
FROM
table
(etc...)

in this case, if the record has an empty string for 'column2', you'll
get an empty string.
if the record has a NULL value for 'column2', you'll get the string
'nothing here' (which, of course, you can change to suit your needs)

On 10/8/07, Richard White [EMAIL PROTECTED] wrote:
 perfect, thanks very much charlie :)

 in relation to the issue of null values being different to empty strings in 
 the database, am i right by saying the only way to get round this would be to 
 create a stored procedure that ran sql code to test for a null value or empty 
 string then pass back a result to cf telling it whether it is null or an 
 empty string?

 thanks

 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290577
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF Coding Standards

2007-10-08 Thread Charlie Griefer
i don't normally line up the attribute/value pairs by the = sign, but
i do like to break out longer tags (tags with many attributes) as
follows:

the major difference between this and what others have posted so far
is putting the first attribute (in this case, 'name') on its own line.

cfargument
 name=firstName
 type=string
 required=true
/

On 10/8/07, Dawson, Michael [EMAIL PROTECTED] wrote:
 I like the method of lining up the attributes AND equal signs.  I
 beginning to switch to this format for long tag definitions.

 cfargument name = sfirstName
 type = string
 required = true
 hint = first name of person



-- 
Charlie Griefer


...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed.

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290578
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Null Values

2007-10-08 Thread Richard White
Thanks for all your help and detailed suggestions it is now very clear :)

thanks again 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290582
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Null Values

2007-10-08 Thread Charlie Griefer
heh.  i suggested coalesce() over isnull() just to keep it portable.

but agreed that isnull() is more readable than both the CASE and
coalesce() suggestions :)

On 10/8/07, Rick Root [EMAIL PROTECTED] wrote:
 Depending on your database, you could also use ISNULL() or IFNULL()
 functions - much simpler than the case statement, but less portable.

 For example, in Microsoft SQL Server:

 http://msdn2.microsoft.com/en-us/library/ms184325.aspx

 The case statement below would look like this instead:

 ISNULL(col,'YOURINDICATORFORNULL) AS col

 Rick

 On 10/8/07, Qasim Rasheed [EMAIL PROTECTED] wrote:
  Instead of Stored procedure, you can simply do this
 
  CASE WHEN col is NULL THEN 'YOURINDICATORFORNULL'
  ELSE col
  END AS col
 
  HTH
 
  On 10/8/07, Richard White [EMAIL PROTECTED] wrote:
  
   perfect, thanks very much charlie :)
  
   in relation to the issue of null values being different to empty strings
   in the database, am i right by saying the only way to get round this would
   be to create a stored procedure that ran sql code to test for a null value
   or empty string then pass back a result to cf telling it whether it is 
   null
   or an empty string?
  
   thanks
  
  
 
 

 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290581
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Null Values

2007-10-08 Thread Janet MacKay
Depending on your database, you could also use ISNULL() or IFNULL()
functions - much simpler than the case statement, but less portable.

If portability is a concern, use COALESCE() as Charlie mentioned. Its a more 
generic version of ISNULL() 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290580
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Null Values

2007-10-08 Thread Rick Root
Depending on your database, you could also use ISNULL() or IFNULL()
functions - much simpler than the case statement, but less portable.

For example, in Microsoft SQL Server:

http://msdn2.microsoft.com/en-us/library/ms184325.aspx

The case statement below would look like this instead:

ISNULL(col,'YOURINDICATORFORNULL) AS col

Rick

On 10/8/07, Qasim Rasheed [EMAIL PROTECTED] wrote:
 Instead of Stored procedure, you can simply do this

 CASE WHEN col is NULL THEN 'YOURINDICATORFORNULL'
 ELSE col
 END AS col

 HTH

 On 10/8/07, Richard White [EMAIL PROTECTED] wrote:
 
  perfect, thanks very much charlie :)
 
  in relation to the issue of null values being different to empty strings
  in the database, am i right by saying the only way to get round this would
  be to create a stored procedure that ran sql code to test for a null value
  or empty string then pass back a result to cf telling it whether it is null
  or an empty string?
 
  thanks
 
 

 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290579
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Null Values

2007-10-08 Thread Janet MacKay
but agreed that isnull() is more readable than both the CASE and
coalesce() suggestions :)

Yes, I'll grant you IsNull() does have the more descriptive (or intuitive) 
name. 

ISNULL(col,'YOURINDICATORFORNULL) AS col
COALESCE(col,'YOURINDICATORFORNULL) AS col 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290583
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Null Values

2007-10-08 Thread Jochem van Dieten
Charlie Griefer wrote:
 heh.  i suggested coalesce() over isnull() just to keep it portable.
 
 but agreed that isnull() is more readable than both the CASE and
 coalesce() suggestions :)

Really? And how about when you want to check 3 arguments?

Jochem

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290584
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Null Values

2007-10-08 Thread Charlie Griefer
On 10/8/07, Jochem van Dieten [EMAIL PROTECTED] wrote:
 Charlie Griefer wrote:
  heh.  i suggested coalesce() over isnull() just to keep it portable.
 
  but agreed that isnull() is more readable than both the CASE and
  coalesce() suggestions :)

 Really? And how about when you want to check 3 arguments?

generally speaking, i find isNull() to be a bit more descriptive as to
what it actually does than coalesce().  In this particular instance,
both would work, and if i knew that portability was not (and likely
would not become) an issue, i'd go with isnull() because it's more
descriptive.

if there were 3 (or more) arguments, i'd find coalesce() to be more
readable than nested isNull() statements.

i was referring specifically to the issue that was presented (as well
as the responses to that particular issue) :)

-- 
Charlie Griefer


...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed.

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290585
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Null Values

2007-10-08 Thread Vince Bonfanti
FYI, that code does work in BlueDragon 7.0, which can distinguish between nulls 
and empty strings, and supports the null keyword:

http://blog.newatlanta.com/index.cfm?mode=entryentry=5C2377F1-534E-5920-D87611A2FB9BE5EC

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

 Hi, i am getting data out of a database. i need to be able to check if 
 a value returned  in a query is null.
 
 i am trying to use the following code but it is not working
 
 cfif questionTextVariables.minTextLimit is null
 
 it seems a bit strange that the word null is not going blue to 
 indicate that it is a recognised word.
 
 thanks for the help
 
 richard 


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290586
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF Coding Standards

2007-10-08 Thread Rick Root
Personally, I will break out attributes of a cf tag to a one per
line type arrangement only if there are a lot of attributes.

For example, I never do it for cfargument but have been known to do it
for other tags - especially if some of the attribute values are long..
like in cffile with full paths in the arguments.

I'll also break out parameters of function calls if there are a lot of
parameters...

For example, at this very moment, I just wrote this code:

cfif spouse_exists and arguments.clear_spouse and arguments.recurse
cfset retVal2 = saveClearanceRequest(
arguments.userid,
eInfo.spouse.entityid,
arguments.proposed_assignment,
arguments.proposed_major_gift_area,
arguments.reason_for_request,
arguments.additional_information,
arguments.clear_spouse,
false)
cfset retVal.request_id_2 = retVal2.request_id
cfset retVal.request_content_2 = retVal2.request_content
/cfif
cfreturn retVal   

rick

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290588
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Null Values

2007-10-08 Thread Rick Root
Vince - just out of curiousity, if I've got a bunch of code doing this:

cfif foo eq 

and in some cases it's empty string and others it's null - would that
code FAIL to wkr as expected under Bluedragon because null neq ?

Rick

On 10/8/07, Vince Bonfanti [EMAIL PROTECTED] wrote:
 FYI, that code does work in BlueDragon 7.0, which can distinguish between 
 nulls and empty strings, and supports the null keyword:

 http://blog.newatlanta.com/index.cfm?mode=entryentry=5C2377F1-534E-5920-D87611A2FB9BE5EC

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

  Hi, i am getting data out of a database. i need to be able to check if
  a value returned  in a query is null.
 
  i am trying to use the following code but it is not working
 
  cfif questionTextVariables.minTextLimit is null
 
  it seems a bit strange that the word null is not going blue to
  indicate that it is a recognised word.
 
  thanks for the help
 
  richard


 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290587
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Digests not working for me

2007-10-08 Thread Rebecca Younes
Neither the 8 hour nor the 1 hour digests are working for me. I can get the 
immediate emails. 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290589
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Announce: New RIAForge project - picasaCFC

2007-10-08 Thread Andy Matthews
Hey everyone...
 
Just wanted to announce my first open source project, picasaCFC:
http://picasacfc.riaforge.org/
 
While working on a project for my dad, I wanted to come up with the absolute
simplest method by which my dad, a non-technophile, could upload pictures to
his golf organization website. I decided that Picasa (and their web albums)
would be the easiest way of doing this since they already use Picasas. I
looked around for CFC which could access Picasa and found that most of them
didn't do quite what I wanted. So, since my hosting company recently
upgraded to ColdFusion 8, I took this chance to write some CF8 specific
code. The result is picasaCFC.
 
There are pure data methods in this CFC which return simple arrays and
structures. There are also pure HTML methods which allow the use the HTML
sent by Picasa. I'd appreciate any feedback you can meet out.
 
Again, here's the URL to the project:
http://picasacfc.riaforge.org/
 

 
Andy Matthews
Senior ColdFusion Developer

Office:  877.707.5467 x747
Direct:  615.627.9747
Fax:  615.467.6249
[EMAIL PROTECTED]
www.dealerskins.com http://www.dealerskins.com/ 
 


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290590
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF Coding Standards

2007-10-08 Thread Matt Williams
On 10/8/07, Rick Root [EMAIL PROTECTED] wrote:
 cfif spouse_exists and arguments.clear_spouse and arguments.recurse

Man, sometimes I wish I could clear my spouse's arguments too. Her
arguments make me want to recurse too.

-- 
Matt Williams
It's the question that drives us.

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290591
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: I'm completely Stumped - All I want to do is ...

2007-10-08 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I'm trying to capture and pass the elex,y variables that are being passed in
the span tag that looks like ... I never knew you could the id of a span tag
as a variables.  Hmm.
(without the greater and less than)

span id=span_elex nbsp; /span, span id=span_eley nbsp; /span

Are you just wanting to capture the x,y whenever a user clicks? Are you
trying to create a heat map overlay? 

All,  Sorry for the repeat post. I've searched all day for a solution and
can't find anything.
I want to capture the coordinates from this sample and pass them for use in
a cf scope.

I'm stumped!

http://dunnbypaul.net/js_mouse/

If I could only get the x and y coordinates in a form in the action param
and pass them URL scope then use ...

cfset RIGHT = #ListFirst(CGI.QUERY_STRING)# cfset DOWN =
#ListLast(CGI.QUERY_STRING)# 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290592
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Null Values

2007-10-08 Thread Vince Bonfanti
Vince - just out of curiousity, if I've got a bunch of code doing this:

cfif foo eq 

and in some cases it's empty string and others it's null - would that
code FAIL to wkr as expected under Bluedragon because null neq ?


That code will work exactly as expected under BlueDragon 7.0. For backwards 
compatibility, BD treats null database values as empty strings just as CF does; 
but BD gives you the additional option of explicity checking for a null value. 
So you can do this (I hope this formatting comes out right):

cfif foo eq  !--- database null or empty string ---
  cfif foo eq null 
 pfoo is a database null
  cfelse
 pfoo is an empty string
  /cfif
/cfif

I'm not sure you'd every write code exactly like that, but it illustrates the 
point.

Vince 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290593
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: I'm completely Stumped - All I want to do is ...

2007-10-08 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Thanks Dave, What I'm using is an absolute div with a thick black border
that sits on top of an uploaded image.  I trying to capture the x and y 
coordinates (elex,y) after the user positions this draggable div, I'm using 
that coordinate information to crop the image that appears beneath this 
movable div.  I want to use this as a framing functionality.  Then the 
backend takes the images height and width and the position of
the frame and crops the image to the correct size and then moves
onto the next stage in the process which is importing the perfectly
sized image into a Flash movie.  It's a consolation prize for
contestants that entered a photo related contest. We had over 50,000
entries so it was pretty successful.

Thanks

D


 All,  Sorry for the repeat post. I've searched all day for a 

Presumably, they're clicking on something, right? Otherwise, you'd only be
able to capture the mouse coordinates at the moment they click on your
submit button (or whatever).

If you want the user to click on an image, and you want to capture the
coordinates of where they clicked on the image, you can just use INPUT
TYPE=IMAGE as your submit button - it will automatically return
coordinates within the form data.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information! 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290594
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF Coding Standards

2007-10-08 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
I agree with William except on point ...

William, I'm sure you're idea is in the spirit of improvement and sharing, but
putting Jr. developers on the hot seat and allow senior developers to
show off a little is one of the reasons I don't like working in large
development teams with this kind of environment.  

There's nothing worse than a knowledgable developer that wields his knowledge
for the benefit of their own ego at the expense of others.  It should be more 
of a mentoring environment. It's true, that a developers knowledge is their
greatest stregnth, but the use of that knowledge is the greater test the 
person's character. 

My 2 cents.

You are the lead, you see a problem with not only the current code but
future code put together.  You are introducing standards to the group.  This
is not at all a bad thing. You will probably be heralded in the future for
your attempts now, however despised you might be for it now.

I would suggest doing 'spot checks' on other people's code, or 'peer
reviews' on their code so that you can verify that the standards are being
kept to.

You might even do this as a 'group' event.  Where the group of developers
gets together and puts 1 programmer on the 'hot' seat.  The programmer will
'run through' his/her code and explain what it is doing and why it is there.
You could critique the code based on ample commenting and standards
adherence, and you can have the group come up with plausible solutions for
'heavy' code or code that is 'muddled'.  This would be a great exercise to
help the 'junior' coders get better as well as the 'senior' coders to hone
their skills and 'show off' a little.  To get everyone off on the right foot
you might even make the first few 'sessions' regarding a custom tag or UDF
that you can download from the exchange.  Send it out to everyone and have
everyone 'change it' based on their programming skills but to your new
standards.  Then you can run through the original example and open it up for
discussion.

Just an idea...

Can you tell I am 'dying' to get out of my '1 guy' shop and join a bigger
team?

William

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
I recently started a position as a technical lead at a new company. Most of
the development is done on a few intranet/extranet sites, so the code (much
of it spaghetti) is touched by a lot of different developers.

I've recently set up a wiki that contains coding standards, and used a lot
of the LiveDocs recommendations (with a References section indicating
sources). I've gone the route of placing these standards under some general
categories, such as Security, Performance, and Stylistic.

The Stylistic category defines things such as capitalization and
indentation. It may have been a bad idea, but with this category, we came to
a lot of these standards based on the consensus of the group - most of whom
maintain the coding style of the CFWACK, e.g., title casing function names,
uppercasing CF operators, etc.

Wondering if any of you would think it is beneficial (or too draconian) to
have these stylistic standards in place, even if it isn't an individual's
preference, to promote readability, consistency and prevent constant
reformatting (annoying when doing diffs), especially in an environment where
different developers are touching a lot of the same code?




http://webapper.net/index.cfm?fuseaction=Fuseblog.ShowCommentsArticleID=200 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290595
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF8 and debugging

2007-10-08 Thread Phill B
Is there a way to display the files that were ran during application
startup in the order the were hit and not by execution time?

-- 
Phil

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290596
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Announce: New RIAForge project - picasaCFC

2007-10-08 Thread Jason Durham
Thanks for sharing!

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 08, 2007 1:23 PM
To: CF-Talk
Subject: Announce: New RIAForge project - picasaCFC

Hey everyone...
 
Just wanted to announce my first open source project, picasaCFC:
http://picasacfc.riaforge.org/
 
While working on a project for my dad, I wanted to come up with the absolute
simplest method by which my dad, a non-technophile, could upload pictures to
his golf organization website. I decided that Picasa (and their web albums)
would be the easiest way of doing this since they already use Picasas. I
looked around for CFC which could access Picasa and found that most of them
didn't do quite what I wanted. So, since my hosting company recently
upgraded to ColdFusion 8, I took this chance to write some CF8 specific
code. The result is picasaCFC.
 
There are pure data methods in this CFC which return simple arrays and
structures. There are also pure HTML methods which allow the use the HTML
sent by Picasa. I'd appreciate any feedback you can meet out.
 
Again, here's the URL to the project:
http://picasacfc.riaforge.org/
 

 
Andy Matthews
Senior ColdFusion Developer

Office:  877.707.5467 x747
Direct:  615.627.9747
Fax:  615.467.6249
[EMAIL PROTECTED]
www.dealerskins.com http://www.dealerskins.com/ 
 




~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290597
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: AOP in ColdSpring and ModelGlue

2007-10-08 Thread Brian Kotek
I'm working on a validation system for Transfer (but the idea would probably
port to other kinds of objects) that has a generic Validator class to handle
common needs like required fields, field length, type, etc. But you can then
define custom validation methods as well, which a subclass of Validator
would implement and which would be specific to a particular kind of object
(say, Order). The Validator will run the common and custom methods based on
an XML file which defines the validation rules. As a bonus, I am trying to
make it also able to generate client-side JavaScript (with an extensible
implementation so that it can handle any JavaScript library such as jQuery,
prototype, etc.) from the same XML. Which will allow you to define the rules
once and have them applied on the client and on the server. If I can get it
working acceptably I'll probably blog about it and/or post it to RIAForge.

On 10/8/07, Robert Rawlins - Think Blue [EMAIL PROTECTED]
wrote:

 Ah I see!,

 I hadn't considered the ramifications of the more complex validation, like
 you say, those that involve cross checks between objects and database
 calls,
 these would certainly be more difficult to implement using AOP or a
 generic
 class. I understand your thinking here completely.

 I have just started reading an article about a Validation framework built
 in
 JAVA which uses Spring and AOP, the idea being that you can implement a
 blanket validation process for these more 'trivial' tasks and data
 comparisons using AOP, which helps save development time, and then in the
 underlying model and business logic you can manually build these more
 complex validation checks.

 I think that building a system which allows space for both may work well,
 as
 it leverages the power of the framework to free up time doing the more
 trivial tasks and at least ensures a basic level of volition across the
 entire application, yet allows you to then extend that with non AOP
 business
 logic validation for the more complex data?

 Thanks again Brian, I hadn't considered those more complex validation
 problems,

 Rob




~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290598
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CF8 and debugging

2007-10-08 Thread Dawson, Michael
Write the hits to a log file.

Or, send them via email using getTickCount() in the subject line.  Then,
sort the mail by subject.

M!ke 

-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 08, 2007 1:41 PM
To: CF-Talk
Subject: CF8 and debugging

Is there a way to display the files that were ran during application
startup in the order the were hit and not by execution time?

--
Phil



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290599
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: FCKeditor in CF app - styles display on front end but not in editor window

2007-10-08 Thread Nick Gleason
Bhakti,

Many thanks!  We were finally able to track the issue down on our own.  The
issue turned out to be a path name in the FCKConfig.EditorAreaCSS = 
setting in the fckconfig.js file.  The odd thing is that it worked for a
long time with the wrong path in there.  But, not the path is correct and
all the instances are again functioning correctly.

Best,

Nick

.
..
 

 -Original Message-
 From: Bhakti Pingale [mailto:[EMAIL PROTECTED] 
 Sent: Monday, October 08, 2007 3:28 AM
 To: CF-Talk
 Subject: RE: FCKeditor in CF app - styles display on front 
 end but not in editor window
 
 Hi,
 
 I would like to know the exact scenario when this happens. 
 May be if you can attach the piece of code, we will be able 
 to debug when this behavior is seen.
 
 Thanks,
 Bhakti
 Adobe ColdFusion Team.
 
 -Original Message-
 From: Nick Gleason [mailto:[EMAIL PROTECTED]
 Sent: Friday, October 05, 2007 6:03 AM
 To: CF-Talk
 Subject: FCKeditor in CF app - styles display on front end 
 but not in editor window
 
 Hi folks.  We've been using FCKeditor successfully for quite 
 a while in our CF-based software, but we have recently run 
 into an odd issue related to styles display in the editor window.
  
 Our system has custom styles which display in the FCKeditor Styles
 drop
 down menu.  Suddenly, on some of our deployments, the styles 
 listed in the Styles drop down menu are no longer displaying 
 correctly.  That is, they all simply display as 10pt plain 
 text, rather than displaying in the style that they define.
  
 The funny thing is that the styles display correctly on the front end.
 that
 is, when they are applied to text in the editor, the text 
 displays correctly on the front end.  So, it's simply a back 
 end display issue in the editor window.  
  
 Any FCKeditor / CF gurus out there who can troubleshoot the 
 details of how external styles are integrated into FCKeditor? 
  We'd love to hear your thoughts.
  
 Best,
  
 Nick
 
 
 
 
 
 
 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290600
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF8 and debugging

2007-10-08 Thread Raymond Camden
The debug templates are in an open source coldfusion file. You can
modify the core one, or write your own. That's how ColdFire was
developed.

On 10/8/07, Dawson, Michael [EMAIL PROTECTED] wrote:
 Write the hits to a log file.

 Or, send them via email using getTickCount() in the subject line.  Then,
 sort the mail by subject.

 M!ke

 -Original Message-
 From: Phill B [mailto:[EMAIL PROTECTED]
 Sent: Monday, October 08, 2007 1:41 PM
 To: CF-Talk
 Subject: CF8 and debugging

 Is there a way to display the files that were ran during application
 startup in the order the were hit and not by execution time?

 --
 Phil



 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290601
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Coldspring AOP on Transient Business Object, bad combo?

2007-10-08 Thread Brian Kotek
No, it's each time the Proxy object is created (the proxy is written to disk
as a temp file, then instantiated, and finally the temp file is deleted).

On 10/8/07, Tom Chiverton [EMAIL PROTECTED] wrote:

 On Friday 05 Oct 2007, [EMAIL PROTECTED] wrote:
  OK I was wrong on this because I was actually missing a crucial detail:
 the
  proxy factory deletes the temp CFC as soon as it is instantiated. This
 is
  so you don't end up with a ton of generated CFCs on the disk. So it
 would
  (in fact, it has to) regenerate the file to disk each time.

 Each time *the bean factory is created* is the important qualifier there.

 --
 Tom Chiverton
 Helping to conveniently implement magnetic networks
 on: http://thefalken.livejournal.com




~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290602
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Coldspring AOP on Transient Business Object, bad combo?

2007-10-08 Thread Brian Kotek
Which again shows why AOP is targeted at singletons not transient objects.

On 10/8/07, Brian Kotek [EMAIL PROTECTED] wrote:

 No, it's each time the Proxy object is created (the proxy is written to
 disk as a temp file, then instantiated, and finally the temp file is
 deleted).

 On 10/8/07, Tom Chiverton [EMAIL PROTECTED] wrote:
 
  On Friday 05 Oct 2007, [EMAIL PROTECTED] wrote:
   OK I was wrong on this because I was actually missing a crucial
  detail: the
   proxy factory deletes the temp CFC as soon as it is instantiated. This
  is
   so you don't end up with a ton of generated CFCs on the disk. So it
  would
   (in fact, it has to) regenerate the file to disk each time.
 
  Each time *the bean factory is created* is the important qualifier
  there.
 
  --
  Tom Chiverton
  Helping to conveniently implement magnetic networks
  on: http://thefalken.livejournal.com
 
 



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290603
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Debuggin Flash Forms

2007-10-08 Thread Dave Watts
 So, I've got this page with a somewhat complex flash form on 
 it... no actionscript or anything.. just a lot of elements, a 
 tab navigator, etc...
 
 Seems to have stopped working after the CF8 upgrade.
 
 No errors are generated in the application.log or 
 exception.log, I just get no form

This gives me a 404:
https://www.it.dev.duke.edu/CFIDE/

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290605
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CF8, JBoss and Apache

2007-10-08 Thread Dave Watts
 Will the mod_jrun.so work with JBoss?  I tried following the 
 instructions in the URL below for configuring Apache, but it 
 doesn't seem that the same tools are installed when you build 
 the EAR version of ColdFusion.  I don't have a web server 
 configuration tool at least.  Did you get these tools when 
 installing ColdFusion as an EAR?

No, mod_jrun.so won't work with JBoss. You don't get JRun's web server
configuration tools if you're deploying to another J2EE server. You don't
get them in an EAR or WAR because connecting to an external web server is
the job of the J2EE server, not the applications you deploy to that server.

If you want to deploy to JBoss, you will have to use whatever JBoss provides
to connect to an external web server. You may then have to customize that to
deal with CF-specific extensions - or you may not, I honestly don't know.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290604
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF8, JBoss and Apache

2007-10-08 Thread Larry Lyons
Glad to help. keep us appraised on how it goes. I'm still experimenting with 
this.

larry

 Thanks, Larry.  I did take a look at this, but the directions didn't 
 seem to work quite right for the version of Apache that I am using.  
 It is a good starting point though.
 
 Thanks,
 Austen
 
  While I'm no expert, having just started with JBoss, I found a set 
 of 
  blog posting 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290606
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Need an active Javascript discussion group

2007-10-08 Thread coldfusion . developer
Does anyone know a good site with activity like here on houseoffusion.com?

Thanks

D

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290607
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Need an active Javascript discussion group

2007-10-08 Thread Aaron Rouse
I used to be on one via yahoo called something like JS-Jive that had a lot
of activity but have not been on it in a very long time so it might be dead
or gone now days.

On 10/8/07, [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:

 Does anyone know a good site with activity like here on houseoffusion.com?

 Thanks

 D

 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290608
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Rollback db changes in CFCUnit/CFUnit tests

2007-10-08 Thread Janet MacKay
+1 to dbunit.  You also have the option of wrapping each unit test in a
transaction and then rolling it back at the end.

Jaime Metcher

Yes, that works too.  In this case dbUnit's restore capability is a better fit. 
I got a good quickstart to dbUnit thanks to Rich's script and I'm really liking 
it so far :)  

Thanks for the suggestion guys.

Janet 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290609
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Need an active Javascript discussion group

2007-10-08 Thread Charlie Griefer
http://www.houseoffusion.com/groups/javascript/

but doesn't seem to be too much activity :(

tell you what?  i'll subscribe if you subscribe.  see if we can change that :)

On 10/8/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 Does anyone know a good site with activity like here on houseoffusion.com?

 Thanks

 D

 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290610
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Need an active Javascript discussion group

2007-10-08 Thread Cutter (CFRelated)
Javascript mailing list
[EMAIL PROTECTED]
http://lists.evolt.org/mailman/listinfo/javascript

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

[EMAIL PROTECTED] wrote:
 Does anyone know a good site with activity like here on houseoffusion.com?
 
 Thanks
 
 D
 
 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290611
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


SQL Select Question

2007-10-08 Thread Dennis Powers
I am having a total mental block with this select query and I am hoping
someone might be able to unstick my thought process;

I have a table Looking something like this (abbreviated for the list)

ImageID  GameID

ImageID is a unique ID number and there can be multiple images for each
GameID.  What I am trying to do is create a query where I can select 6
random imageID's each for a different GameID. Or another way, get one image
from the many for six different gameID's

Any help would be greatly appreciated.



Best Regards,

Dennis Powers
UXB Internet - A website design and Hosting Company
690 Wolcott Road
P.O. Box 6029
Wolcott, CT  06716
Tel: (203)879-2844
http://www.uxbinternet.com/
http://www.uxb.net/ 




~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290612
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SQL Select Question

2007-10-08 Thread Greg Morphis
What RDBMS? That would help mucho...



On 10/8/07, Dennis Powers [EMAIL PROTECTED] wrote:
 I am having a total mental block with this select query and I am hoping
 someone might be able to unstick my thought process;

 I have a table Looking something like this (abbreviated for the list)

 ImageID  GameID

 ImageID is a unique ID number and there can be multiple images for each
 GameID.  What I am trying to do is create a query where I can select 6
 random imageID's each for a different GameID. Or another way, get one image
 from the many for six different gameID's

 Any help would be greatly appreciated.



 Best Regards,

 Dennis Powers
 UXB Internet - A website design and Hosting Company
 690 Wolcott Road
 P.O. Box 6029
 Wolcott, CT  06716
 Tel: (203)879-2844
 http://www.uxbinternet.com/
 http://www.uxb.net/




 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290613
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


  1   2   >