Re: Stack overflow in self nested custom tag

2010-03-08 Thread Chris Velevitch

On Tue, Mar 9, 2010 at 18:18, Barney Boisvert  wrote:
>
> I haven't tested this, but I'd imagine that the CURRENT tag is on the
> tag stack (as it is with exceptions).  Since getBaseTagData operates
> on names rather than offsets/indexes, it's going to match the current
> tag, and then return it's own data.  So lvData is pointing at one of
> it's own scopes, which then has to be copied into lvData, and well you
> can see the problem.
>
> However, getBaseTagData accepts an optional second parameter for how
> many matches it should find before returning, simply moving the ", 2"
> to the right by one parenthesis will probably solve your problem.
> Again, I haven't actually tested, but that's what I'd try first.

That worked. Thanks.


Chris
--
Chris Velevitch
Manager - Adobe Platform Users Group, Sydney
m: 0415 469 095
www.apugs.org.au

Adobe Platform Users Group, Sydney
March 2010: ColdFusion Application Architecture for the Impatient and
Using jQuery when Flash is Overkill
Date: 29nd Mar 6pm for 6:30 start
Details and RVSP on http://groups.adobe.com/posts/148c9056

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331456
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Stack overflow in self nested custom tag

2010-03-08 Thread Barney Boisvert

I haven't tested this, but I'd imagine that the CURRENT tag is on the
tag stack (as it is with exceptions).  Since getBaseTagData operates
on names rather than offsets/indexes, it's going to match the current
tag, and then return it's own data.  So lvData is pointing at one of
it's own scopes, which then has to be copied into lvData, and well you
can see the problem.

However, getBaseTagData accepts an optional second parameter for how
many matches it should find before returning, simply moving the ", 2"
to the right by one parenthesis will probably solve your problem.
Again, I haven't actually tested, but that's what I'd try first.

cheers,
barneyb

On Mon, Mar 8, 2010 at 11:12 PM, Chris Velevitch
 wrote:
>
> I'm using CF7.02 and I'm trying to create a custom tag that will be
> self nested, like:-
>
>     
>          
>               
>               
>          
>     
>
> And in , I'm trying to get the data of the parent tag and
> assigning to a variable in the current tags state:-
>
>     
>
> But the assignment creates a stack overflow and I don't understand why?
>
>
>
> Chris
> --
> Chris Velevitch
> Manager - Adobe Platform Users Group, Sydney
> m: 0415 469 095
> www.apugs.org.au
>
> Adobe Platform Users Group, Sydney
> March 2010: ColdFusion Application Architecture for the Impatient and
> Using jQuery when Flash is Overkill
> Date: 29nd Mar 6pm for 6:30 start
> Details and RVSP on http://groups.adobe.com/posts/148c9056a4
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331455
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Stack overflow in self nested custom tag

2010-03-08 Thread Chris Velevitch

I'm using CF7.02 and I'm trying to create a custom tag that will be
self nested, like:-

 
  
   
   
  
 

And in , I'm trying to get the data of the parent tag and
assigning to a variable in the current tags state:-

 

But the assignment creates a stack overflow and I don't understand why?



Chris
--
Chris Velevitch
Manager - Adobe Platform Users Group, Sydney
m: 0415 469 095
www.apugs.org.au

Adobe Platform Users Group, Sydney
March 2010: ColdFusion Application Architecture for the Impatient and
Using jQuery when Flash is Overkill
Date: 29nd Mar 6pm for 6:30 start
Details and RVSP on http://groups.adobe.com/posts/148c9056a4

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331454
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: iText and CF issues

2010-03-08 Thread Paul Hastings

On 3/9/2010 2:18 AM, Eric Roberts wrote:
> We were just having a talk about sending null via a java function and
> apprently that wasn't possible until cf7...we are running 6.1

write up a small java class to return a NULL? i recall this being discussed way 
back when in the forums or here

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331453
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF AES Encryption/Decryption on BBj

2010-03-08 Thread megan cytron

>Maybe someone else here is good at it, and could post base64/hex
>representations of the stuff.
>

Yeah, I'm hitting a dead end. The guy provided the hex encoded string 
(313233343536373839313233343536370010) to be 
encrypted... I understand how it was created (1234567891234567 + 15 zeroes of 
padding + 10--the hex value of 16, the total number of padding bytes). But I 
can't figure out how to pass this straight into the CF encrypt tag, since it 
isn't plain text. Am I missing something obvious?


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331452
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: iText and CF issues

2010-03-08 Thread Eric Roberts

We were just having a talk about sending null via a java function and
apprently that wasn't possible until cf7...we are running 6.1

Eric

On Mon, Mar 8, 2010 at 1:31 PM, Paul Hastings wrote:

>
> On 3/9/2010 12:11 AM, Eric Roberts wrote:
> > bRet = pdfForm.setFieldProperty("text1", "flags", 68, JavaCast("null",
> ""));
>
> just glancing thru your code:
>
> - have you tried "setflags", etc.?
> - if you set it to only RO does it work?
> - have you tried w/the constant values or javaCast flags?
>
> bRet = pdfForm.setFieldProperty("text1",
>
> "flags", << off the top of my head, can't recall if it's F or FF
> entries
> that need to be set, setflags vs setfflags, etc.
>
> textField.FF_READ_ONLY, << or javacast("64","int")
>
> JavaCast("null", ""));
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331451
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: iText and CF issues

2010-03-08 Thread Paul Hastings

On 3/9/2010 12:11 AM, Eric Roberts wrote:
> bRet = pdfForm.setFieldProperty("text1", "flags", 68, JavaCast("null", ""));

just glancing thru your code:

- have you tried "setflags", etc.?
- if you set it to only RO does it work?
- have you tried w/the constant values or javaCast flags?

bRet = pdfForm.setFieldProperty("text1",

"flags", << off the top of my head, can't recall if it's F or FF entries 
that need to be set, setflags vs setfflags, etc.

textField.FF_READ_ONLY, << or javacast("64","int")

JavaCast("null", ""));



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331450
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: RIAForge download problems (CFFM)

2010-03-08 Thread Mike Kear

Its 0527 here in Sydney so that's close enough, Ray.

Always remember that it's 2am SOMEWHERE!

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


On Tue, Mar 9, 2010 at 5:23 AM, Raymond Camden  wrote:
>
> As just a general FYI, RIAForge is going down in 7 minutes for an
> update. If I were a good provider, I'd do it at like 2AM. But I have
> this unnatural desire to actually sleep at times. ;)
>
> On Mon, Mar 8, 2010 at 11:28 AM, Raymond Camden  wrote:
>> Sorry that this hasn't been fixed yet. :( I am doing an Apache update
>> later today - not specifically for this issue - but I'll hopefully be
>> able to look more later this month.
>>
>>
>> On Mon, Mar 8, 2010 at 10:38 AM, Mike Kear  wrote:
>>>
>>> Thanks Gabriel,   looks like I'm not the only one having this same
>>> issue.  I'll communicate with Ray about it, although I'm not sure I
>>> can contribute much above what he knows about the problem already.
>>>
>>>
>> --
>> ===
>> Raymond Camden, ColdFusion Jedi Master
>>
>> Email    : r...@camdenfamily.com
>> Blog      : www.coldfusionjedi.com
>> AOL IM : cfjedimaster
>>
>> Keep up to date with the community: http://www.coldfusionbloggers.org
>>
>
>
>
> --
> ===
> Raymond Camden, ColdFusion Jedi Master
>
> Email    : r...@camdenfamily.com
> Blog      : www.coldfusionjedi.com
> AOL IM : cfjedimaster
>
> Keep up to date with the community: http://www.coldfusionblogg
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331449
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: RIAForge download problems (CFFM)

2010-03-08 Thread Raymond Camden

As just a general FYI, RIAForge is going down in 7 minutes for an
update. If I were a good provider, I'd do it at like 2AM. But I have
this unnatural desire to actually sleep at times. ;)

On Mon, Mar 8, 2010 at 11:28 AM, Raymond Camden  wrote:
> Sorry that this hasn't been fixed yet. :( I am doing an Apache update
> later today - not specifically for this issue - but I'll hopefully be
> able to look more later this month.
>
>
> On Mon, Mar 8, 2010 at 10:38 AM, Mike Kear  wrote:
>>
>> Thanks Gabriel,   looks like I'm not the only one having this same
>> issue.  I'll communicate with Ray about it, although I'm not sure I
>> can contribute much above what he knows about the problem already.
>>
>>
> --
> ===
> Raymond Camden, ColdFusion Jedi Master
>
> Email    : r...@camdenfamily.com
> Blog      : www.coldfusionjedi.com
> AOL IM : cfjedimaster
>
> Keep up to date with the community: http://www.coldfusionbloggers.org
>



-- 
===
Raymond Camden, ColdFusion Jedi Master

Email: r...@camdenfamily.com
Blog  : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionblogg

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331448
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: RIAForge download problems (CFFM)

2010-03-08 Thread Raymond Camden

Sorry that this hasn't been fixed yet. :( I am doing an Apache update
later today - not specifically for this issue - but I'll hopefully be
able to look more later this month.


On Mon, Mar 8, 2010 at 10:38 AM, Mike Kear  wrote:
>
> Thanks Gabriel,   looks like I'm not the only one having this same
> issue.  I'll communicate with Ray about it, although I'm not sure I
> can contribute much above what he knows about the problem already.
>
>
-- 
===
Raymond Camden, ColdFusion Jedi Master

Email: r...@camdenfamily.com
Blog  : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.o

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331447
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


iText and CF issues

2010-03-08 Thread Eric Roberts

This was forwarded to me by one of my coworkers...I wonder if anyone has
some experience and possible insight onthe issue here...

Below is the content of what we are currently trying to do with iText.



*PROBLEM:* Read an existing PDF, populate form field values and change form
fields to Read-Only.

*SOLUTION:* According to several references, it looks like it should be
possible to use the setFieldProperty method of AcroFields Class.

*RESULTS:* Currently, form field values are updated correctly, but we are
not able to change the Read-only property.



*REPORTING ENVIRONMENT*

ColdFusion: 7.x (using JVM 1.4x)

iText: 2.1.7

Acrobat PDF:  v6+ Files



*CODE REFERENCES*

Read-Only Example:
http://www.itextpdf.com/examples/index.php?page=example&id=161

AcroFields Reference:
http://tom.tharrisx.homedns.org/sm3rdpartyref/itext-docs-2.0.4/com/lowagie/text/pdf/AcroFields.html



*ColdFusion Source Code*



//--

// FILENAME: iText_demo.cfm

// PURPOSE: Populate form fields and make a field Read Only using iText
v2.1.7 library.

//

// CREATED: 03/05/2010

//--



fullPathToInputFile = expandpath("testTemplate.pdf");  // full path to PDF
you want to modify



// full path to the PDF we will output. Using creatUUID() to create

// a unique file name so we can delete it afterwards

tempFilename = "#createUUID()#.pdf";

fullPathToOutputFile = expandpath(tempFilename);



ipaths = arrayNew(1);

arrayAppend(ipaths,"C:\CFusionMX7\jlib\iText-2.1.7.jar");

myloader = createObject("component", "javaloader.JavaLoader").init(ipaths);



// Step 1: Read in the source pdf

reader = myloader.create("com.lowagie.text.pdf.PdfReader").init(
fullPathToInputFile );

PageSize = myloader.create("com.lowagie.text.PageSize");

document =
myloader.create("com.lowagie.text.Document").init(PageSize.LETTER);



// Step 2: Create an output stream for the destination file

outStream = createObject("java", "java.io.FileOutputStream").init(
fullPathToOutputFile );



// Step 3: Open a stamper for generating the new pdf file

stamper = myloader.create("com.lowagie.text.pdf.PdfStamper").init( reader,
outStream );



PdfAnnotation = myloader.create("com.lowagie.text.pdf.PdfAnnotation");

TextField = myloader.create("com.lowagie.text.pdf.TextField");

AcroFields = myloader.create("com.lowagie.text.pdf.AcroFields");



pdfForm = stamper.getAcroFields(); // get the form fields



// Set value of PDF form fields

bRet = pdfForm.setField("text1", "Some text for 'text1' field");

WriteOutput("setField - bRet: #bRet#,
value[#pdfForm.getField('text1')#]");

// Results: bRet is consistently “YES” and field is updated correctly…



bRet = pdfForm.setField("text2", "Some text for 'text2' field");

WriteOutput("setField - bRet: #bRet#,
value[#pdfForm.getField('text2')#]");

// Results: bRet is consistently “YES” and field is updated correctly…



bRet = pdfForm.setField("text3", "Some text for 'text3' field");

WriteOutput("setField - bRet: #bRet#,
value[#pdfForm.getField('text3')#]");

// Results: bRet is consistently “YES” and field is updated correctly…



WriteOutput("PdfAnnotation.FLAGS_PRINT: #PdfAnnotation.FLAGS_PRINT#");

WriteOutput("PdfAnnotation.FLAGS_READONLY:
#PdfAnnotation.FLAGS_READONLY#");



// 68 = FLAGS_PRINT | FLAGS_READONLY

bRet = pdfForm.setFieldProperty("text1", "flags", 68, JavaCast("null", ""));

WriteOutput("setFieldProperty of text1 to Read Only - bRet: #bRet#");



// Results: bRet is consistently “NO” and no property change occurs.





/*

com.lowagie.text.pdf.PdfAnnotation

public static final intFLAGS_HIDDEN 2

public static final intFLAGS_INVISIBLE  1

public static final intFLAGS_LOCKED 128

public static final intFLAGS_NOROTATE   16

public static final intFLAGS_NOVIEW 32

public static final intFLAGS_NOZOOM 8

public static final intFLAGS_PRINT   4

public static final intFLAGS_READONLY   64

public static final intFLAGS_TOGGLENOVIEW   256

public static final intMARKUP_HIGHLIGHT 0

public static final intMARKUP_SQUIGGLY  3

public static final intMARKUP_STRIKEOUT 2

public static final intMARKUP_UNDERLINE 1

*/



stamper.close(); // close the stamper and output our new PDF

reader.close();// close the reader

http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331446
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: RIAForge download problems (CFFM)

2010-03-08 Thread Mike Kear

Thanks Gabriel,   looks like I'm not the only one having this same
issue.  I'll communicate with Ray about it, although I'm not sure I
can contribute much above what he knows about the problem already.


Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month




On Tue, Mar 9, 2010 at 3:17 AM, Dorioo  wrote:
>
> http://www.coldfusionjedi.com/index.cfm/2010/1/29/Trouble-downloading-from-RIAForge-Read-this
>
> - Gabriel
>

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331445
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: RIAForge download problems (CFFM)

2010-03-08 Thread Dorioo

http://www.coldfusionjedi.com/index.cfm/2010/1/29/Trouble-downloading-from-RIAForge-Read-this

- Gabriel


On Mon, Mar 8, 2010 at 11:15 AM, Mike Kear  wrote:
>
> Thanks to Eric Cobb for sending me the file.   So I dont need anyone
> else to send it, thanks anyway.
>
> But is there a problem with RIAForge's downloading?    I managed to
> download the copy that Eric emailed to my gmail address first time ok,
> so the problem wouldnt seem to be with my system at all. (although
> it's always a possibility of course).
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> On Tue, Mar 9, 2010 at 3:00 AM, Mike Kear  wrote:
>> I am trying to download the latest version of Rick Root's excellent
>> CFFM project (the site assets library module) and every time I do I
>> end up with an invalid zip file.   So far I've downloaded it 4 times,
>> and Chrome says the file is 3.2MB but the finished files on my HDD are
>> 2.125MB,  2.307MB, 1.619MB and 1.707MB.  In other words, the zip files
>> are not completely downloading.
>>
>> Is anyone else having problems downloading from RIAForge?
>>
>> Can anyone send me a copy of CFFM v 1.31 by email please?
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331444
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: RIAForge download problems (CFFM)

2010-03-08 Thread Alan Rother

Looks good to me. Copied to my site. Try getting it here.

http://www.rotherfamily.net/cffm-1.31.zip

=]
-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331443
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: RIAForge download problems (CFFM)

2010-03-08 Thread Mike Kear

Thanks to Eric Cobb for sending me the file.   So I dont need anyone
else to send it, thanks anyway.

But is there a problem with RIAForge's downloading?I managed to
download the copy that Eric emailed to my gmail address first time ok,
so the problem wouldnt seem to be with my system at all. (although
it's always a possibility of course).

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month



On Tue, Mar 9, 2010 at 3:00 AM, Mike Kear  wrote:
> I am trying to download the latest version of Rick Root's excellent
> CFFM project (the site assets library module) and every time I do I
> end up with an invalid zip file.   So far I've downloaded it 4 times,
> and Chrome says the file is 3.2MB but the finished files on my HDD are
> 2.125MB,  2.307MB, 1.619MB and 1.707MB.  In other words, the zip files
> are not completely downloading.
>
> Is anyone else having problems downloading from RIAForge?
>
> Can anyone send me a copy of CFFM v 1.31 by email please?

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331442
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RIAForge download problems (CFFM)

2010-03-08 Thread Mike Kear

I am trying to download the latest version of Rick Root's excellent
CFFM project (the site assets library module) and every time I do I
end up with an invalid zip file.   So far I've downloaded it 4 times,
and Chrome says the file is 3.2MB but the finished files on my HDD are
2.125MB,  2.307MB, 1.619MB and 1.707MB.  In other words, the zip files
are not completely downloading.

Is anyone else having problems downloading from RIAForge?

Can anyone send me a copy of CFFM v 1.31 by email please?

-- 
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331441
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Transfer Object Behaviour

2010-03-08 Thread Dorioo

TQL will go to the database each time so no performance benefit.

- Gabriel

On Mon, Mar 8, 2010 at 10:37 AM, sandeep saini  wrote:
>
> Thanks Gabriel,
>
> I will probably using TQL to construct a query and then paas it to Transfer 
> object to do the rest. Somewhat like this(code taken from 
> http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/171)-
>
> ***
> 
> SELECT Book.Name    , Bookshelf.Name  FROM library.Book as Book    JOIN 
> library.Bookshelf as Bookshelf   WHERE Bookshelf.BookshelfID = :id  ORDER BY 
> Bookshelf.Name
> 
> 
> 
> 
> ***
>
> So, (in my reporting scnerios as described above) will I get performance 
> benefits using transfer this way? Will that cached data be used or will 
> tansfer go to DB to get all data again.
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331440
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Transfer Object Behaviour

2010-03-08 Thread sandeep saini

Thanks Gabriel,

I will probably using TQL to construct a query and then paas it to Transfer 
object to do the rest. Somewhat like this(code taken from 
http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/171)-

***
  
SELECT Book.Name, Bookshelf.Name  FROM library.Book as BookJOIN 
library.Bookshelf as Bookshelf   WHERE Bookshelf.BookshelfID = :id  ORDER BY 
Bookshelf.Name




***

So, (in my reporting scnerios as described above) will I get performance 
benefits using transfer this way? Will that cached data be used or will tansfer 
go to DB to get all data again. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331439
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Transfer Object Behaviour

2010-03-08 Thread Dorioo

If by "changing the criteria slightly", you're working with a query,
then, no, transfer is not caching partial query results and you're
getting little benefit from using transfer.

If instead you're doing something like getting a query of ids and then
getting transfer objects for those ids, then yes, existing objects
would be in the cache and then new ones would be created and cached.

- Gabriel

On Mon, Mar 8, 2010 at 9:21 AM, sandeep saini  wrote:
>
> Thanks guys.
>
> One more related question- I have Emp Name and State in the cach for Emp IDs 
> 111,112 and 113. Not I run other query in which I want to get all the 
> data(Emp Name and States for 111,112,113 and 114 Emp Ids).
>
> Q- Will transfer get all these four records from DB again OR this time will 
> it fetch just record related to Emp Id 114 from DB and rest from cach(like 
> hibernate does...i believe)?
>
> Why I am asking- I am working on a report website. I will get some records 
> based on some criteria. Now I change the criteria slightly(e.g. initially I 
> was getting data for IN state. Now I included NY as well).I want that this 
> time just the records for NY be selected from Db and rest(for IN) from cach. 
> So that performance of the application is better.
>
> Thanks
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331438
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Transfer Object Behaviour

2010-03-08 Thread sandeep saini

Thanks guys.

One more related question- I have Emp Name and State in the cach for Emp IDs 
111,112 and 113. Not I run other query in which I want to get all the data(Emp 
Name and States for 111,112,113 and 114 Emp Ids).

Q- Will transfer get all these four records from DB again OR this time will it 
fetch just record related to Emp Id 114 from DB and rest from cach(like 
hibernate does...i believe)?

Why I am asking- I am working on a report website. I will get some records 
based on some criteria. Now I change the criteria slightly(e.g. initially I was 
getting data for IN state. Now I included NY as well).I want that this time 
just the records for NY be selected from Db and rest(for IN) from cach. So that 
performance of the application is better.

Thanks 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331437
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm