RE: Beginning Flex

2009-02-26 Thread Will Swain

I've just started working through Flex 3 in Action, which looks good so far.
The From the Source books are usually good too.

You might also want to delve into AS - I've been reading Essential
ActionScript 3.0.

BTW, playing around last night I discovered if you have Adobe media player,
you can watch all the flex in a week vids offline, as well as all the adobe
tv stuff. Lot's of Flex sessions from Max on there.

Cheers

Will

 

-Original Message-
From: Jen Perkins [mailto:snarkmeis...@gmail.com] 
Sent: 26 February 2009 00:55
To: cf-talk
Subject: RE: Beginning Flex


Thanks everyone!  I'm running through the Flex in a week videos now (thanks
a bunch, Will!) and planning on buying a book or two on Amazon.
Unfortunately I don't think in-person training will work at this time (small
company, small budget, bad economy...plus, surprisingly few training options
in the bay area, apparently).

Can anyone recommend a good book for n00bs?  I'm thinking of picking up the
Flex for Dummies; I love the format of those books.  Any other strong
recommendations?

Jen Perkins
Adobe Certified ColdFusion Developer
Senior Developer, iArchitects
http://www.iarchitects.com

iArchitects :: Your Internet Solutions Team Architecting Internet Solutions
since 1999

-Original Message-
From: Will Swain [mailto:w...@hothorse.com]
Sent: Wednesday, February 25, 2009 2:01 PM
To: cf-talk
Subject: RE: Beginning Flex


Before shelling out for lynda check out the Flex in a week videos:

http://www.adobe.com/devnet/flex/videotraining/

And the adobe tv videos: http://tv.adobe.com/#pd+Flex

The lynda training does seem to be very good, and it's probably still worth
paying for, but I'd suggest running through those Adobe videos first - why
look a gift horse in the mouth?

Cheers

Will 

-Original Message-
From: Alan Rother [mailto:alan.rot...@gmail.com] 
Sent: 25 February 2009 19:51
To: cf-talk
Subject: Re: Beginning Flex


I'm with Dave and Gerald... As a Lifelong CF developer moving into Flex was
extremely odd. Lynda.com has EXCELLENT training videos, but alot of your
questions aren't really going to be answered there. I would recommend either
paid instructor led training or joining your local Flex/Flash/Adobe User
Group and try to pick some brains there. These mailing lists can be helpful,
but it doesn't compare to the one on one interaction you need to get you
over many of the early hurdles you will likely encounter in learning Flex.

http://www.lynda.com
http://groups.adobe.com


=]


On Wed, Feb 25, 2009 at 12:43 PM, Gerald Guido
gerald.gu...@gmail.comwrote:


  I'm just.lost.  Can y'all pretend I am a total idiot  explain this 
  to
 me
 with very small words, pretty please?

 Can do ;)

 get started with Flex

 I would HIGHLY recommend the Lynda.com  Flex 3 Essential Training and 
 Beyond the Basics (BTB) series.
 http://www.lynda.com/home/DisplayCourse.aspx?lpk2=438
 http://www.lynda.com/home/DisplayCourse.aspx?lpk2=437

 I am in the middle of Flex Essential Training right now and it will 
 get you up to speed quickly using (to the best of my knowledge) best 
 practices. I have been going through Lynda's CF8 BTB and it is spot 
 on. High quality stuff delivered in manageable chunks. All I can say 
 is that I wish I had known about it when I started off using CFC's and
learning OO CF.

 For $25 per month you really can't beat the online training library in 
 terms of bang for the buck (Provided you have a high speed 
 connection).

 HTH

 G!

 On Wed, Feb 25, 2009 at 2:12 PM, Jen Perkins snarkmeis...@gmail.com
 wrote:

  I'm just.lost.  Can y'all pretend I am a total idiot  explain this 
  to me with very small words, pretty please?
 



 --
 Gerald Guido
 http://www.myinternetisbroken.com


 To invent, you need a good imagination and a pile of junk.
 -- Thomas A. Edison


 







~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319855
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Query of Queries Functions

2009-02-26 Thread Ron Gruner

Is there a way to do SQL Updates and Deletes on record sets organized as Query 
of Queries?  It seems that only SELECT works.  I'm using CF8. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319856
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Query of Queries Functions

2009-02-26 Thread Matt Williams

On Thu, Feb 26, 2009 at 5:56 AM, Ron Gruner webmas...@gruner.com wrote:

 Is there a way to do SQL Updates and Deletes on record sets organized as 
 Query of Queries?  It seems that only SELECT works.  I'm using CF8.


A query of queries does not make a connection to the actual database.
It is only a way to further filter previously retrieved record sets.
So no, you cannot do updates or deletes.


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

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319857
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Query of Queries Functions

2009-02-26 Thread Ron Gruner

Thanks Matt.  Is there some other way to build a small and temporary database 
that resides in RAM and can be manipulated with all, or most, SQL functions?  I 
suppose Structures is the best approach but they're new for me. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319858
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Query of Queries Functions

2009-02-26 Thread Matt Williams

On Thu, Feb 26, 2009 at 6:35 AM, Ron Gruner webmas...@gruner.com wrote:

 Thanks Matt.  Is there some other way to build a small and temporary database 
 that resides in RAM and can be manipulated with all, or most, SQL functions?  
 I suppose Structures is the best approach but they're new for me.


Yes, you could do structures or an array of structures. If temporary
is all you need and not actual database persistence, you can work with
the query result set also. You can manipulate data in that with
QuerySetCell. You can also add rows and columsn with QueryAddRow and
QueryAddColumn. Check the docs for actual usage and examples.


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

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319859
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


How to Form variables from: request.servletEvent.getValue('fieldName')

2009-02-26 Thread cfcom

I need to pass the variables from a third party application form to my own
cfmail. The third party app states them as (3fname, lname, address, state,
city, zip, email')

The form variables are accessible in the request scope or in the
request.serlvetEvent.getValue('fieldName')

Would they be accessible if you used this way?
#request.serlvetEvent.getValue('fname')#
#request.serlvetEvent.getValue('lname')#


CFIF IsDefined(form.submit)

cfinsert datasource=myName_dsn tablename=myTableName 
formfields=sender_firstname, sender_lastname, sender_email,
sender_address, sender_city, sender_state, sender_zip,
sender_time, sender_date, sender_ip, sender_msgType


CFQUERY NAME=GetRecipients datasource=myName_dsn   
SELECT * 
FROM recipients
/CFQUERY

cfloop query=GetRecipients
   
cfmail to=#GetRecipients.recip_email#  
from=#form.sender_email# 
subject=MySubject


  Dear #GetRecipients.recip_firstname# #GetRecipients.recip_lastname# ,


  This is my written note. 

  Yours truly,
  
  
  #sender_firstname# #sender_lastname#
  #sender_address#
  #sender_city#, #sender_state# #sender_zip#
  #sender_email#
/cfmail
/cfloop



2. I need to pass the ', is there a specific method I need to use to call up
the sava form variables in my own cfmail?

All of your form variables are accessible in the request scope or in the
request.serlvetEvent.getValue('fieldName')




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319860
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Query of Queries Functions

2009-02-26 Thread Ron Gruner

There's no obvious way to delete a QofQ row.  Am I missing something?  Thanks 
again. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319861
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Query of Queries Functions

2009-02-26 Thread Dawson, Michael

Although you can't DELETE a record from a QoQ, you can SELECT all other
records and save them into the same QoQ variable.

In other words, instead of removing the unwanted records, just select
all of the wanted records.

Thanks,
Mike

-Original Message-
From: Ron Gruner [mailto:webmas...@gruner.com] 
Sent: Thursday, February 26, 2009 8:23 AM
To: cf-talk
Subject: Re: Query of Queries Functions


There's no obvious way to delete a QofQ row.  Am I missing something?
Thanks again. 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319862
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Query of Queries Functions

2009-02-26 Thread Ron Gruner

Cool.  The help is really appreciated.  What a great resource. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319863
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Session Variable not being set - variable created during processing

2009-02-26 Thread Fawzi Amadu

I am trying to assign the value generated for the variable filename to a 
session variable, but when I process the page, Coldfusion reports that:

The form field SESSION.consumerProductExtraImg.Img1 did not contain a file. 
yet I had uploaded files.

What am I doing wrong? TIA

cfset numberoffields = 8

cfform action=process_UpLoadExtraConsumerProductImages.cfm 
enctype=multipart/form-data
  cfloop index=i from=1 to=#variables.numberoffields# step=1 
  cfset filename = #SESSION.consumerProduct.Cnsmr_ProductID#  #i#
cfinput type=File name=cfoutput#variables.filename#/cfoutput /br 
/
!--- Set the respective file name for the uploaded image ---
cfset SESSION.consumerProductExtraImg[Img  i] = #filename#
  /cfloop 
cfinput type=Submit name=upload value=upload /
/cfform 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319864
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: ajax and special characters

2009-02-26 Thread Richard White

thanks to both of you for your comments we will look into these

in relation to the client side - when we want to send data to coldfusion do you 
only use the escape function in Javascript or do you use some other means?

thanks

In addition to Cutter's points about JSON encoding, look into the
URLEncodedFormat and URLDecode.

If, when making your Ajax calls, you pass the returnFormat = JSON 
attribute to your CFC method, then CF will automatically encode the result
when creating the JSON output. When passing a JSON value to ColdFusion,
inside your CFC method you can use the DeserializeJson() method to decode
the value.

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer

Co-Author of Learning Ext JS
http://www.packtpub.com/learning-ext-js/book
_
http://blog.cutterscrossing.com

Richard White wrote:
 hi
 
 we are developing an Ajax based system using JavaScript and Coldfusion.
 
 we have only just started to realise the need for escaping / encoding
special characters. how do you guys deal with this, e.g:
there may be  to understand this.
 
 thanks
 
 richard
 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319865
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Cfchart and cfdocument

2009-02-26 Thread bachinmd

The problem I have is that when I move the code to my live server, it doesn't
show the graph, I just get the little red arrow symbol. It works fine in the
dev enviroment

The only difference is my production environment is running https

My guess is that. Therefore, there's a difference between the two
environment, but I can find no documentation on the matter.

Does anyone have any thoughts on this? 
-- 
View this message in context: 
http://www.nabble.com/Cfchart-and-cfdocument-tp8098p8098.html
Sent from the Cold Fusion - Technical mailing list archive at Nabble.com.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319866
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Session Variable not being set - variable created during processing

2009-02-26 Thread William Seiter

Where are you setting this variable '
SESSION.consumerProduct.Cnsmr_ProductID ' prior to this block of code?

William


-Original Message-
From: Fawzi Amadu [mailto:abd...@gmail.com] 
Sent: Thursday, February 26, 2009 6:43 AM
To: cf-talk
Subject: Session Variable not being set - variable created during processing


I am trying to assign the value generated for the variable filename to a
session variable, but when I process the page, Coldfusion reports that:

The form field SESSION.consumerProductExtraImg.Img1 did not contain a
file. yet I had uploaded files.

What am I doing wrong? TIA

cfset numberoffields = 8

cfform action=process_UpLoadExtraConsumerProductImages.cfm
enctype=multipart/form-data
  cfloop index=i from=1 to=#variables.numberoffields# step=1 
  cfset filename = #SESSION.consumerProduct.Cnsmr_ProductID#  #i#
cfinput type=File name=cfoutput#variables.filename#/cfoutput
/br /
!--- Set the respective file name for the uploaded image ---
cfset SESSION.consumerProductExtraImg[Img  i] = #filename#
  /cfloop 
cfinput type=Submit name=upload value=upload /
/cfform 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319867
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Convert Image to Binary

2009-02-26 Thread Priya Koya

cfset thisDir = expandPath(.)

cffile action=upload fileField=image destination=#thisDir# 
result=fileUpload
nameconflict=overwrite
cfdump var=#thisDir# 
cfimage action=read source=#fileUpload.serverfile# 
name=myImage
cffile action=readBinary file=#image# 
variable=FinalImage
br/variablecfdump var=#FinalImage#
!--- cfset Image_Binary = #toBinary(toBase64(FinalMergedDisclosure))#
cfdump var=#Image_Binary# ---
cfquery name=Query4 datasource=Platform result=result_1
update table1 set Logo='#FinalImage#' where Name='John'
/cfquery

I am getting an error: ByteArray objects cannot be converted to strings. 
I tried with tostring etc.. but didnt work 
Datatype for this column is varBinary(MAX). 

Any sugestions

Thanks,
Priya. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319868
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Convert Image to Binary

2009-02-26 Thread Priya Koya

Hi All,

I am trying to store the image file into sql database in a binary form. I can 
sucessfully browse image, read it and display in the browser but unable to 
convert it into binary.

This is wat I did

cfset thisDir = expandPath(.)

cffile action=upload fileField=image destination=#thisDir# 
result=fileUpload
nameconflict=overwrite
cfdump var=#thisDir# 
cfimage action=read source=#fileUpload.serverfile# 
name=myImage
cffile action=readBinary file=#image# 
variable=FinalImage
br/variablecfdump var=#FinalImage#
!--- cfset Image_Binary = #toBinary(toBase64(FinalMergedDisclosure))#
cfdump var=#Image_Binary# ---
cfquery name=Query4 datasource=Platform result=result_1
update table1 set Logo='#FinalImage#' where Name='John'
/cfquery
but I am unable to save into the database and when I am trying to save it pops 
up say:
ByteArray objects cannot be converted to strings. 

I tried using toString etc..
Datatype for this column is varBinary(MAX).

Thanks,
Priya



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319869
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: How to Form variables from: request.servletEvent.getValue('fieldName')

2009-02-26 Thread Dave Watts

 I need to pass the variables from a third party application form to my own
 cfmail. The third party app states them as (3fname, lname, address, state,
 city, zip, email')

 The form variables are accessible in the request scope or in the
 request.serlvetEvent.getValue('fieldName')

I'm not sure exactly what you mean. Is this third-party form posting
to the URL of one of your CF pages? If so, you'll just get a bunch of
form variables - no need to use request.yaddaYaddaYadda.

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!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319870
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: How to Form variables from: request.servletEvent.getValue('fieldName')

2009-02-26 Thread cfcom

It would start from a Sava Form, 
Pass variables to my CF actions 
Then do a confirmation page back with in Sava Framework

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: 2009-02-26 12:35
To: cf-talk
Subject: Re: How to Form variables from:
request.servletEvent.getValue('fieldName')


 I need to pass the variables from a third party application form to my own
 cfmail. The third party app states them as (3fname, lname, address, state,
 city, zip, email')

 The form variables are accessible in the request scope or in the
 request.serlvetEvent.getValue('fieldName')

I'm not sure exactly what you mean. Is this third-party form posting
to the URL of one of your CF pages? If so, you'll just get a bunch of
form variables - no need to use request.yaddaYaddaYadda.

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!



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319871
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Convert Image to Binary

2009-02-26 Thread Claude Schneegans

 Any sugestions

Yes, store only the image characteristics like file name, size, title, 
etc in the database,
and use the system file management to handle the image storage.
It is generally more efficient than increasing the size of the database 
for nothing.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319872
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Disable ScriptProtect on a per page basis.

2009-02-26 Thread Dean Lawrence

Does anyone know if this is possible? I know you can do it at the server and 
application level, but I couldn't find anything that would allow me to 
selectively turn it off for a single administrative page. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319873
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Disable ScriptProtect on a per page basis.

2009-02-26 Thread Dave Watts

 Does anyone know if this is possible? I know you can do it at the server and 
 application level,
 but I couldn't find anything that would allow me to selectively turn it off 
 for a single
 administrative page.

You can make any changes to an application on a single page. If you're
using CFAPPLICATION within Application.cfm, just use CFAPPLICATION
again within the page in question. If you're using Application.cfc,
just put conditional logic within Application.cfc to check for the
page in question, then set the Application property accordingly.

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!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319874
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Disable ScriptProtect on a per page basis.

2009-02-26 Thread Dean Lawrence

Dave,

Won't this alter the setting for the entire application? Or is this not part of 
the application scope? I guess I just assumed it was. But since it is being 
defined using this.scriptprotect, does this mean that is is evaluated on every 
page request?

Thanks,

Dean

 You can make any changes to an application on a single page. If 
 you're
 using CFAPPLICATION within Application.cfm, just use CFAPPLICATION
 again within the page in question. If you're using Application.cfc,
 just put conditional logic within Application.cfc to check for the
 page in question, then set the Application property accordingly.
 
 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! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319875
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Disable ScriptProtect on a per page basis.

2009-02-26 Thread Dave Watts

 Won't this alter the setting for the entire application? Or is this not part 
 of the application
 scope? I guess I just assumed it was. But since it is being defined using 
 this.scriptprotect,
 does this mean that is is evaluated on every page request?

Application properties, like this.scriptProtect, are evaluated on each
page request. This is kind of counterintuitive, but it's the way it
works. Application properties are not the same as Application
variables.

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!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319876
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Convert Image to Binary

2009-02-26 Thread Paul Kukiel

Managing images on disk is a better way but if you must use the data base
make sure you are using

cfqueryparam scfqltype=CF_SQL_BLOB
vale=#toBase64(FinalMergedDisclosure)# /

Which should work for you.


On Thu, Feb 26, 2009 at 11:14 AM, Priya Koya priya23...@gmail.com wrote:


 cfset thisDir = expandPath(.)

cffile action=upload fileField=image destination=#thisDir#
 result=fileUpload
nameconflict=overwrite
cfdump var=#thisDir#
cfimage action=read source=#fileUpload.serverfile#
 name=myImage
cffile action=readBinary file=#image#
 variable=FinalImage
 br/variablecfdump var=#FinalImage#
 !--- cfset Image_Binary = #toBinary(toBase64(FinalMergedDisclosure))#
 cfdump var=#Image_Binary# ---
 cfquery name=Query4 datasource=Platform result=result_1
 update table1 set Logo='#FinalImage#' where Name='John'
 /cfquery

 I am getting an error: ByteArray objects cannot be converted to strings.
 I tried with tostring etc.. but didnt work
 Datatype for this column is varBinary(MAX).

 Any sugestions

 Thanks,
 Priya.

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319877
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Disable ScriptProtect on a per page basis.

2009-02-26 Thread Dean Lawrence

Great! Thanks for the clarification Dave.
 
 Application properties, like this.scriptProtect, are evaluated on 
 each
 page request. This is kind of counterintuitive, but it's the way it
 works. Application properties are not the same as Application
 variables.
 
 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! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319878
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Inner, Left and Right joins returning the same records AKA Tough SQL relationship part deux

2009-02-26 Thread Ian Skinner

This is a follow on request to yesterday's post: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319832.

To review I have two tables something like this.

TableA
year  use_no  county  rec_type
2009  1   1   X
2009  3   1   X
2009  4   1   Y
2009  5   2   X
2009  6   2   X
2009  7   2   Y
2009  10 2   Y

TableB
year  use_no  dup_set
2009  1   A
2009  2   A
2009  7   B
2009  8   B
2009  9   B

The year and use_no fields combine to be the unique key for both tables 
and records that share the same key in each table are related to each 
other.  TableB records sets of records that are considered duplicates 
and all the records of a set are related by sharing the same dup_set key 
value.

The goal of my task is to create report that counts the number of 
records in TableA grouped by county and rec_type and counts the number 
of records if all the duplicate records recorded in TableB are taken 
into account.  So using the above simplified data, the report would 
produce results something like this.

county  rec_type  records  records_with_dups
1   X 23
1   Y 11
2   X 22
2   Y 24

With some tinkering I have gotten part of the way there.  The following 
set of table joins will produce a record set of records that are 
duplicated and how many duplicates their are.

SELECT
  p.year,
  p.use_no,
  count(*) AS duplicates

FROM
tableA p INNER JOIN
  tableB e ON (p.use_no = e.use_no AND p.year = e.year and 
e.duplicate_set is not null) INNER JOIN
tableB d ON (e.duplicate_set = d.duplicate_set AND e.year = d.year)

GROUP BY
  p.year,
  p.use_no

This returns results something like:
year  use_no  duplicates
2009  1   2
2009  7   3

Now if I can just combine this back into the rest of the tableA data so 
I can get something that looks like this, I would be good to go.

year  use_no duplicates
2009  1   2
2009  3   1
2009  4   1
2009  5   1
2009  6   1
2009  7   3
2009  10  1

I tried a UNION but I got this result.  Note that records from the 
duplicate set are duplicated.

year  use_no duplicates
2009  1   2
2009  1   1
2009  3   1
2009  4   1
2009  5   1
2009  6   1
2009  7   3
2009  7   1
2009  10  1


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319879
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFTOOLTIP Not Working

2009-02-26 Thread Ron Gruner

cftooltip has stopped working on my local test server (IIS, CF8) after a year 
but the same pages work fine on the production server.  Nothing's changed that 
I can think of and all other JS and Spry functions continue to work fine both 
locally and remotely.  What would cause just cftooltip to not work? 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319880
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


re: Inner, Left and Right joins returning the same records AKA Tough SQL relationship part deux

2009-02-26 Thread Jason Fisher

Not quite I sure I follow (sorry, almost out the door here), but I think 
you just want your aggregate to an entry for every A regardless of B, 
right?  Try making your joins LEFT, and I think you'll have it:

...
FROM
tableA p LEFT OUTER JOIN
  tableB e ON (p.use_no = e.use_no AND p.year = e.year and 
e.duplicate_set is not null) LEFT OUTER JOIN
tableB d ON (e.duplicate_set = d.duplicate_set AND e.year = 
d.year)
...

That should get your aggregate COUNT() to still return 1 where there is 
only the one record in TableA, like 2009 3.

Cheers,
Jason
 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319881
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Session Variable not being set - variable created during processing

2009-02-26 Thread Fawzi Amadu

Hi,
That variable (SESSION.consumerProduct.Cnsmr_ProductID) is being set when the 
session first starts and the customers enters initial details. So it is on a 
different page, that links to the page with the code I posted.

Where are you setting this variable '
SESSION.consumerProduct.Cnsmr_ProductID ' prior to this block of code?

William


I am trying to assign the value generated for the variable filename to a
session variable, but when I process the page, Coldfusion reports that:

The form field SESSION.consumerProductExtraImg.Img1 did not contain a
file. yet I had uploaded files.

What am I doing wrong? TIA

cfset numberoffields = 8

cfform action=process_UpLoadExtraConsumerProductImages.cfm
enctype=multipart/form-data
  cfloop index=i from=1 to=#variables.numberoffields# step=1 
  cfset filename = #SESSION.consumerProduct.Cnsmr_ProductID#  #i#
cfinput type=File name=cfoutput#variables.filename#/cfoutput
/br /
   !--- Set the respective file name for the uploaded image ---
   cfset SESSION.consumerProductExtraImg[Img  i] = #filename#
  /cfloop 
cfinput type=Submit name=upload value=upload /
/cfform 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319882
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Session Variable not being set - variable created during processing

2009-02-26 Thread Fawzi Amadu

Where are you setting this variable '
SESSION.consumerProduct.Cnsmr_ProductID ' prior to this block of code?

William


I am trying to assign the value generated for the variable filename to a
session variable, but when I process the page, Coldfusion reports that:

The form field SESSION.consumerProductExtraImg.Img1 did not contain a
file. yet I had uploaded files.

What am I doing wrong? TIA

cfset numberoffields = 8

cfform action=process_UpLoadExtraConsumerProductImages.cfm
enctype=multipart/form-data
  cfloop index=i from=1 to=#variables.numberoffields# step=1 
  cfset filename = #SESSION.consumerProduct.Cnsmr_ProductID#  #i#
cfinput type=File name=cfoutput#variables.filename#/cfoutput
/br /
   !--- Set the respective file name for the uploaded image ---
   cfset SESSION.consumerProductExtraImg[Img  i] = #filename#
  /cfloop 
cfinput type=Submit name=upload value=upload /
/cfform 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319883
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFTOOLTIP Not Working

2009-02-26 Thread Cutter (CFRelated)

Are you seeing any errors in Firebug when the page loads, or during the 
mouseover action?

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer

Co-Author of Learning Ext JS
http://www.packtpub.com/learning-ext-js/book
_
http://blog.cutterscrossing.com

Ron Gruner wrote:
 cftooltip has stopped working on my local test server (IIS, CF8) after a 
 year but the same pages work fine on the production server.  Nothing's 
 changed that I can think of and all other JS and Spry functions continue to 
 work fine both locally and remotely.  What would cause just cftooltip to 
 not work? 
 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319884
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFTOOLTIP Not Working

2009-02-26 Thread Ron Gruner

No errors either during load or mouse over.  I'm wondering if some recent IIS 
security upgrade is blocking it... 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319885
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Convert Image to Binary

2009-02-26 Thread James Holmes

That would mean you're entering base64 text into a binary field.

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



2009/2/27 Paul Kukiel pkuk...@gmail.com:

 Managing images on disk is a better way but if you must use the data base
 make sure you are using

 cfqueryparam scfqltype=CF_SQL_BLOB
 vale=#toBase64(FinalMergedDisclosure)# /

 Which should work for you.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319886
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: How to Form variables from: request.servletEvent.getValue('fieldName')

2009-02-26 Thread James Holmes

That still isn't answering the question. Is your Sava form going to
perform a POST to your CF page or not?

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



2009/2/27 cfcom cf...@aceligent.com:

 It would start from a Sava Form,
 Pass variables to my CF actions
 Then do a confirmation page back with in Sava Framework

 -Original Message-
 From: Dave Watts [mailto:dwa...@figleaf.com]
 Sent: 2009-02-26 12:35
 To: cf-talk
 Subject: Re: How to Form variables from:
 request.servletEvent.getValue('fieldName')


 I need to pass the variables from a third party application form to my own
 cfmail. The third party app states them as (3fname, lname, address, state,
 city, zip, email')

 The form variables are accessible in the request scope or in the
 request.serlvetEvent.getValue('fieldName')

 I'm not sure exactly what you mean. Is this third-party form posting
 to the URL of one of your CF pages? If so, you'll just get a bunch of
 form variables - no need to use request.yaddaYaddaYadda.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319887
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


connecting to sql server datasource in CF8

2009-02-26 Thread Mike Little

hey guys, i have recently installed coldfusion 8. everything going sweet except 
creating a datasource to connnect to a remote ms sql server.

i get the following...

Connection verification failed for data source: xyz123
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish 
connection

this worked fine in seven. i have used the exact settings used for the existing 
connection. i have also made sure all relevant ports are open.

any help would be appreciated.
mike 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319888
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: connecting to sql server datasource in CF8

2009-02-26 Thread Priya Koya

Did you check with th TCP/IP enadled, port number and you should not use
windows password but the database password.



On Thu, Feb 26, 2009 at 9:37 PM, Mike Little m...@nzsolutions.co.nz wrote:


 hey guys, i have recently installed coldfusion 8. everything going sweet
 except creating a datasource to connnect to a remote ms sql server.

 i get the following...

 Connection verification failed for data source: xyz123
 java.sql.SQLException: Timed out trying to establish connection
 The root cause was that: java.sql.SQLException: Timed out trying to
 establish connection

 this worked fine in seven. i have used the exact settings used for the
 existing connection. i have also made sure all relevant ports are open.

 any help would be appreciated.
 mike

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319889
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: connecting to sql server datasource in CF8

2009-02-26 Thread Mike Little

i am not totally following your question, but if it helps - i can connect to 
the db with enterprise manager.

Did you check with th TCP/IP enadled, port number and you should not use
windows password but the database password.



On Thu, Feb 26, 2009 at 9:37 PM, Mike Little m...@nzsolutions.co.nz wrote:

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319890
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: connecting to sql server datasource in CF8

2009-02-26 Thread Priya Koya

Try this setup:

http://www.fusioncube.net/index.php/coldfusion-sql-server-express

On Thu, Feb 26, 2009 at 9:37 PM, Mike Little m...@nzsolutions.co.nz wrote:


 hey guys, i have recently installed coldfusion 8. everything going sweet
 except creating a datasource to connnect to a remote ms sql server.

 i get the following...

 Connection verification failed for data source: xyz123
 java.sql.SQLException: Timed out trying to establish connection
 The root cause was that: java.sql.SQLException: Timed out trying to
 establish connection

 this worked fine in seven. i have used the exact settings used for the
 existing connection. i have also made sure all relevant ports are open.

 any help would be appreciated.
 mike

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319891
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Convert Image to Binary

2009-02-26 Thread Paul Kukiel

cffile action=readbinary file=/store/image.jpg variable=fileContents
cfqueryparam cfsqltype=cf_sql_blob value=#fileContents# /

Is all you need when the datatype is image or varbinary on MSSQL you
don't need the tobase64 that will teach me for responding to fast.
Thanks james

You also need to check : -- Enable binary large object retrieval
(BLOB).  in CF admin.

On Thu, Feb 26, 2009 at 9:14 PM, James Holmes james.hol...@gmail.com wrote:

 That would mean you're entering base64 text into a binary field.

 mxAjax / CFAjax docs and other useful articles:
 http://www.bifrost.com.au/blog/



 2009/2/27 Paul Kukiel pkuk...@gmail.com:
 
  Managing images on disk is a better way but if you must use the data base
  make sure you are using
 
  cfqueryparam scfqltype=CF_SQL_BLOB
  vale=#toBase64(FinalMergedDisclosure)# /
 
  Which should work for you.

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319892
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Inner, Left and Right joins returning the same records AKA Tough SQL relationship part deux

2009-02-26 Thread C S

FROM
tableA p LEFT OUTER JOIN
  tableB e ON (p.use_no = e.use_no AND p.year = e.year and 
e.duplicate_set is not null) LEFT OUTER JOIN
tableB d ON (e.duplicate_set = d.duplicate_set AND e.year = 
d.year)


Yes, I think that would work.  There is probably a more elegant method, but you 
could try joining back to the counts to get both totals. 

SELECT  m.county, m.rec_type, m.records, dup.records_with_dupes
FROM
(
SELECT  county, rec_type, count(*) as records
FROMtableA 
GROUP BY county, rec_type
)

m LEFT JOIN 

(
SELECT  p.county, p.rec_type, count(*) AS records_with_dupes
FROMtableA p 
LEFT JOIN tableB e ON 
(p.use_no = e.use_no AND p.year = e.year and e.dup_set 
is not null) 
LEFT JOIN tableB d ON 
(e.dup_set = d.dup_set AND e.year = d.year) 
GROUP BY p.county, p.rec_type
)

dup ON m.county = dup.county AND m.rec_type = dup.rec_type 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319893
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: UPS - XML Rates: Connection Failure

2009-02-26 Thread Dave Watts

 To ensure that the name resolution works, would you
 suggest just opening the URL in a browser on the
 server??

Yes, that would work.

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!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319894
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 Multi Server Config Help

2009-02-26 Thread Dave Watts

 Dave, what would you recommend?
 Clean up old mappings  Establish a naming
 convention for the new stuff to avoid conflicts  when
 complete, clean house and remove old mappings

All of those sound good. Any documentation process you can use going
forward to keep track of settings would probably be helpful.

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!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319895
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Server slowly dying - Possibly a memory leak --- CF7, MS SQL Server 2005 Express

2009-02-26 Thread Dave Watts

  Have you considered migrating SQL Server to a
  dedicated machine?

 I'd like to avoid that for cost reasons. I've been running
 the site nobosh.com on the one sever for over a year
 without issue, only recently due to product updates and
 increased traffic has the server started to have
 issues.

Well, if you have more traffic, and performance goes down, that's a
sign that you may need to invest in more hardware. That said, you
might want to monitor CPU usage and maybe even disk usage during slow
performance times; if either of those go up significantly, you may see
a benefit by moving your database to a dedicated database server.

 Good point, the memory usage for JRUN and MSSQL
 is reaching a plateau. I haven't increased the maximum
 heap size for CF, what do you recommend?

If you're not reaching the maxinum heap size now, I wouldn't recommend
increasing it at all. The default setting for max heap size in CF 8 is
512MB. You're not anywhere near that, so I wouldn't worry about this.

I don't think your problems have anything to do with memory consumption.

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!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319896
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: How to Form variables from: request.servletEvent.getValue('fieldName')

2009-02-26 Thread cfcom

Yes, it would post to myCF then return to Sava 

-Original Message-
From: James Holmes [mailto:james.hol...@gmail.com] 
Sent: 2009-02-26 21:17
To: cf-talk
Subject: Re: How to Form variables from:
request.servletEvent.getValue('fieldName')


That still isn't answering the question. Is your Sava form going to
perform a POST to your CF page or not?

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



2009/2/27 cfcom cf...@aceligent.com:

 It would start from a Sava Form,
 Pass variables to my CF actions
 Then do a confirmation page back with in Sava Framework

 -Original Message-
 From: Dave Watts [mailto:dwa...@figleaf.com]
 Sent: 2009-02-26 12:35
 To: cf-talk
 Subject: Re: How to Form variables from:
 request.servletEvent.getValue('fieldName')


 I need to pass the variables from a third party application form to my
own
 cfmail. The third party app states them as (3fname, lname, address,
state,
 city, zip, email')

 The form variables are accessible in the request scope or in the
 request.serlvetEvent.getValue('fieldName')

 I'm not sure exactly what you mean. Is this third-party form posting
 to the URL of one of your CF pages? If so, you'll just get a bunch of
 form variables - no need to use request.yaddaYaddaYadda.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319897
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Three Stars Media is a Scam

2009-02-26 Thread John Brown

I know that these are tough times, but please be aware of this. If you get a 
job opportunity from a company called Three Stars Media in Orlando, Florida, do 
not pursue it! They are a scam company which is the latest incarnation of a 
string of fraudulant companies that were created by an owner who was convicted 
of fraud and child abuse. Don't beieve me? follow these links and judge for 
yourself:

http://www.youtube.com/watch?v=_hfuC7IbVdE

http://www.phishbucket.org/main/content/view/3596/

http://en.wikipedia.org/wiki/User:Spelunkster/Scammer

http://www.aboutus.org/User:snagalot/ThreeStarsTeam.com


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4178
Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11


Re: Three Stars Media is a Scam Company

2009-02-26 Thread Jeffry Houser

 In case you hadn't heard, truth is no longer a defense in libel cases.  
If your post is with malign intent you can still be guilty. 

http://techdirt.com/articles/20090224/0147393882.shtml

John Brown wrote:
 I know that these are tough times, but please be aware of this. If you get a 
 job opportunity from Three Stars Media of Orlando, Florida, do not pursue it! 
 They are a scam company which is the latest incarnation of a string of 
 fraudulant companies that were created by an oowner who was convicted of 
 fraud and child abuse. Don't beieve me? follow these links and judge for 
 yourself:

 http://www.youtube.com/watch?v=_hfuC7IbVdE

 http://www.phishbucket.org/main/content/view/3596/

 http://en.wikipedia.org/wiki/User:Spelunkster/Scammer

 http://www.aboutus.org/User:snagalot/ThreeStarsTeam.com


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4179
Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11


Re: Three Stars Media is a Scam

2009-02-26 Thread Phillip Vector

Please.. Stop with the spam. None of the links you put up show any
kind of proof of your accusations. You are making yourself look
somewhat foolish and IMHO, you should stop now.

On Thu, Feb 26, 2009 at 2:32 PM, John Brown johnb4...@yahoo.com wrote:

 I know that these are tough times, but please be aware of this. If you get a 
 job opportunity from a company called Three Stars Media in Orlando, Florida, 
 do not pursue it! They are a scam company which is the latest incarnation of 
 a string of fraudulant companies that were created by an owner who was 
 convicted of fraud and child abuse. Don't beieve me? follow these links and 
 judge for yourself:

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4180
Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11