Re: Use the compiled java class in CFM page

2008-11-26 Thread Paul Hastings
Jibu S wrote:
> Object Instantiation Exception.
> Class not found: SimpleMath

either use mark's javaLoader or put the class on cf's classpath.


~|
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:316007
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Use the compiled java class in CFM page

2008-11-26 Thread Jibu S
Hello

I created a java file
 
public class SimpleMath {   
   public int addNumbers(int num1, int num2){   
   return num1 + num2;   
}
}
from 
(http://www.builderau.com.au/program/coldfusion/soa/ColdFusion-s-Java-connection/0,339028378,339186184,00.htm)


and i Compile the code using jdk1.1.8

and i call the class file in cfm page as




but it occur a error

Object Instantiation Exception.
Class not found: SimpleMath


The class file and the cfm file are same folder

How can i call the java class object in cfm page ?

Please hellp me ...

Thanks


~|
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:316006
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 help with CF / Java problem...

2008-11-26 Thread Paul Hastings
John Skrotzki wrote:
> jre 1.6 instead of the jre 1.4 that CF MX 7 runs on.  I don't know how to
> recompile it and wondering if anybody would be able to do it...

get yourself the latest version of eclipse, make sure you have the same JRE 
installed on your w/s (we're all at 1.6xx here). once you startup a new java 
project, i think eclipse will try to suggest the JRE version that fits your 
source but from a very quick glance from a journeyman java person there doesn't 
seem to be anything 1.6 specific.

the other alternative is to translate this all to cf plus java. it's mostly 
core 
java + commons + log4j all of which are available to cf7.



~|
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:316005
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: lists vs structs

2008-11-26 Thread Azadi Saryev
i am sorry, it may be too early and i may not have had enough coffee
yet, but...

[q]
toadd -- elements from list2 to be added to list1
todelete -- elements from list1 to be deleted (those that are not
present in list2)
[/q]

looks to me like a long way around a simple ... :)

you are basically making your list1 looks exactly like list2: deleting
elements from it that are not in list2 and adding missing elements that
are in list2...

maybe after another cup of coffee i will see it differently...

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Brian Dumbledore wrote:
> I didn't want to extend the years old discussion on this thread, 
> http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:19468
>
> I was looking for a custom tag which given two lists list1,list2 will give me 
> back a struct with two lists 'toadd' and 'todelete'. 
>
> toadd -- elements from list2 to be added to list1
> todelete -- elements from list1 to be deleted (those that are not present in 
> list2)
>
> I wrote two versions, one based on lists and the other based on struct, in 
> all cases (even smaller sizes), struct version outperforms list version. 
>
> Anyone care to comment? Both versions given below:
>
> STRUCT VERSION:
> 
> 
> 
> 
>  default="result">
> 
> 
> 
>  delimiters="#attributes.delimiter#">
>   
> 
> 
>
>  delimiters="#attributes.delimiter#">
>   
> 
> 
>
> 
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
>structinsert(caller[attributes.returnvariable],"toadd","#structkeylist(toadd,attributes.delimiter)#")>
>structinsert(caller[attributes.returnvariable],"todelete","#structkeylist(todelete,attributes.delimiter)#")>
> 
>
> LIST VERSION:
>
> 
> 
> 
>  default="result">
> 
> 
>   
>   
>delimiters="#attributes.delimiter#">
>listfind(attributes.list1,idx,"#attributes.delimiter#") and not 
> listfind(toadd,idx,"#attributes.delimiter#")>
>listappend(toadd,idx,"#attributes.delimiter#")>
>   
>   
>delimiters="#attributes.delimiter#">
>listfind(attributes.list2,idx,"#attributes.delimiter#") and not 
> listfind(todelete,idx,"#attributes.delimiter#")>
>listappend(todelete,idx,"#attributes.delimiter#")>
>   
>   
>structinsert(caller[attributes.returnvariable],"toadd","#toadd#")>
>structinsert(caller[attributes.returnvariable],"todelete","#todelete#")>
> 
>
>   

~|
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:316004
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Need help with CF / Java problem...

2008-11-26 Thread John Skrotzki
I want to use a java class for extracting email sections from .eml file.  Found 
some code that will do it perfectly but it is compiled for use with the jre 1.6 
instead of the jre 1.4 that CF MX 7 runs on.  I don't know how to recompile it 
and wondering if anybody would be able to do it...

Here is the website with the code: ( download link near bottom )

http://miles.dk/2008/04/10/messenger/

any help getting this so it can be used in cf ( createObject TYPE Java ) would 
be awesome and I am sure others might find this code helpful.

Thanks...

John Skrotzki 

~|
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:316003
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CFHTTP connection failure error

2008-11-26 Thread brad
Has DNS changed since you last rebooted your CF server?  Java (and
therefore CF) caches DNS lookups FOREVER or until CF reboots-- whichever
comes first.

I'm not following why you need a host file entry to access these sites. 
If DNS is not your problem then it seems that there are some firewall
restrictions limiting the access your CF server has to the outside
world, or the remote server is refusing connections from your CF server
for some reason.

What if you open up telnet ON YOUR CF SERVER and connect to port 80 of
the remote server and issue a get HTTP command?  If that works, CFHTTP
*should* work as the only difference at that point should just be the
headers.

~Brad

    Original Message 
 Subject: CFHTTP connection failure error
 From: Hitesh Patel <[EMAIL PROTECTED]>
 Date: Wed, November 26, 2008 4:06 pm
 To: cf-talk 
 
 I am writing to describe CFHTTP issue.
 There is a WINDOWS 2003, IIS 6.0 and ColdFusion 8 is on the server. 
 
 Right now if I have to make any CFHTTP call from the server to my
client URL (assume client URL is hosted to anywhere in the world) I must
need to add that remote URL entry in server HOSTS file...it's really a
panic because I have to do this for my every NEW client URL.
 
 CASE 1 (Client URL is NOT mapped in the server's HOSTS file)
 1) I can't access client REMOTE URL from the server using IE browser
but can access any other site for example http://www.google.com in the
IE browser.
 
 2) I can ping client remote URL and that was OK.
 
 3) When I try to connection to client remote URL using CFHTTP I get an
error like "Connection Failure : Status code unavailable".
 
 CASE 2 (Client URL is mapped in the server's HOSTS file)
 EVERYTHING IS OK.
 
 Now, I have added following code within CFHTTP but no luck!
 
 
 
 My CF code template is as below:
 ===
 
 
 
 
 
 
 
 
 
 
 #content#
 
 #cfcatch.Message##cfcatch.Detail#
 
 
 
 == CF template ends
 
 Can anybody advise me as I DO NOT WANT TO DO MAPPING in HOSTS file at
all? 
 I mean CFHTTP should function properly without HOSTS files mapping.
 
 Thanks a lot in advance. 
 
 

~|
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:316002
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CFHTTP connection failure error

2008-11-26 Thread Jeff Langevin
Never seen that one before.  But here's a shot in the dark.  Any chance you're 
trying to connect to a secure url (https)?  There is a known issue where cfhttp 
does not support certain implementations and therefore the certificate gets 
rejected.  You could try using CFHTTP5 at the tag store.  They have a free eval 
version so you can at least test to see if it fixes the problem.

http://www.cftagstore.com/tags/cfxhttp5.cfm

--Jeff


From: Hitesh Patel [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2008 5:06 PM
To: cf-talk
Subject: CFHTTP connection failure error

I am writing to describe CFHTTP issue.
There is a WINDOWS 2003, IIS 6.0 and ColdFusion 8 is on the server.

Right now if I have to make any CFHTTP call from the server to my client URL 
(assume client URL is hosted to anywhere in the world) I must need to add that 
remote URL entry in server HOSTS file...it's really a panic because I have to 
do this for my every NEW client URL.

CASE 1 (Client URL is NOT mapped in the server's HOSTS file)
1) I can't access client REMOTE URL from the server using IE browser but can 
access any other site for example http://www.google.com in the IE browser.

2) I can ping client remote URL and that was OK.

3) When I try to connection to client remote URL using CFHTTP I get an error 
like "Connection Failure : Status code unavailable".

CASE 2 (Client URL is mapped in the server's HOSTS file)
EVERYTHING IS OK.

Now, I have added following code within CFHTTP but no luck!



My CF code template is as below:
===










#content#

#cfcatch.Message##cfcatch.Detail#



== CF template ends

Can anybody advise me as I DO NOT WANT TO DO MAPPING in HOSTS file at all?
I mean CFHTTP should function properly without HOSTS files mapping.

Thanks a lot in advance.



~|
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:316001
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFHTTP connection failure error

2008-11-26 Thread Hitesh Patel
I am writing to describe CFHTTP issue.
There is a WINDOWS 2003, IIS 6.0 and ColdFusion 8 is on the server. 

Right now if I have to make any CFHTTP call from the server to my client URL 
(assume client URL is hosted to anywhere in the world) I must need to add that 
remote URL entry in server HOSTS file...it's really a panic because I have to 
do this for my every NEW client URL.

CASE 1 (Client URL is NOT mapped in the server's HOSTS file)
1) I can't access client REMOTE URL from the server using IE browser but can 
access any other site for example http://www.google.com in the IE browser.

2) I can ping client remote URL and that was OK.

3) When I try to connection to client remote URL using CFHTTP I get an error 
like "Connection Failure : Status code unavailable".

CASE 2 (Client URL is mapped in the server's HOSTS file)
EVERYTHING IS OK.

Now, I have added following code within CFHTTP but no luck!



My CF code template is as below:
===










#content#

#cfcatch.Message##cfcatch.Detail#



== CF template ends

Can anybody advise me as I DO NOT WANT TO DO MAPPING in HOSTS file at all? 
I mean CFHTTP should function properly without HOSTS files mapping.

Thanks a lot in advance. 

~|
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:316000
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: OT- Godaddy Website hosting problem

2008-11-26 Thread Mike Chabot
What server is your CF code on, the hosted server or your own server?
What do you mean by "points to?"
I would suspect that this question has nothing to do with GoDaddy and
it more an issue of having two different URLs since a session variable
is set for a specific domain on a specific server. If you change URLs
or jump servers, then your session doesn't follow.

-Mike Chabot

On Wed, Nov 26, 2008 at 3:22 PM, Dave Hatz <[EMAIL PROTECTED]> wrote:
> We have a client that has hosted a web site on Godaddy, 
> http://www.pearlciuminternational.com   It points to a web site on one of our 
> servers, http://www.pearlcium.com/pearl.  The URL doesn't change to our URL 
> when typing in http://www.pearlciuminternal.com, it keeps the URL that is 
> hosted by Godaddy, so it doesn't look like a redirect.  The problem we are 
> having, is we are using session variables within our pages, but they are not 
> working in IE.  When you click on one of the links, the session variables are 
> gone.  In FF works great, but IE it chokes.
>
> Can someone explain why this is happening or what we can do to fix this on 
> our end?  We are running CF7.02 Enterprise on Windows 2003 Server.
>
> Thanks,
> Dave

~|
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:315999
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: lists vs structs

2008-11-26 Thread Mark Mandel
Building Structs will probably always perform faster than lists for
this type of thing, as Strings are immutable, and therefore have to be
recreated every time you change them.

Mark

On Thu, Nov 27, 2008 at 7:29 AM, Brian Dumbledore <[EMAIL PROTECTED]> wrote:
> I didn't want to extend the years old discussion on this thread, 
> http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:19468
>
> I was looking for a custom tag which given two lists list1,list2 will give me 
> back a struct with two lists 'toadd' and 'todelete'.
>
> toadd -- elements from list2 to be added to list1
> todelete -- elements from list1 to be deleted (those that are not present in 
> list2)
>
> I wrote two versions, one based on lists and the other based on struct, in 
> all cases (even smaller sizes), struct version outperforms list version.
>
> Anyone care to comment? Both versions given below:
>
> STRUCT VERSION:
> 
> 
> 
> 
>  default="result">
> 
> 
> 
>  delimiters="#attributes.delimiter#">
>
> 
> 
>
>  delimiters="#attributes.delimiter#">
>
> 
> 
>
> 
>
>
>
>
>
>
>
>
>
>
>
>
> structinsert(caller[attributes.returnvariable],"toadd","#structkeylist(toadd,attributes.delimiter)#")>
> structinsert(caller[attributes.returnvariable],"todelete","#structkeylist(todelete,attributes.delimiter)#")>
> 
>
> LIST VERSION:
>
> 
> 
> 
>  default="result">
> 
> 
>
>
> delimiters="#attributes.delimiter#">
> listfind(attributes.list1,idx,"#attributes.delimiter#") and not 
> listfind(toadd,idx,"#attributes.delimiter#")>
> listappend(toadd,idx,"#attributes.delimiter#")>
>
>
> delimiters="#attributes.delimiter#">
> listfind(attributes.list2,idx,"#attributes.delimiter#") and not 
> listfind(todelete,idx,"#attributes.delimiter#")>
> listappend(todelete,idx,"#attributes.delimiter#")>
>
>
> structinsert(caller[attributes.returnvariable],"toadd","#toadd#")>
> structinsert(caller[attributes.returnvariable],"todelete","#todelete#")>
> 
>
>
>
>
> 

~|
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:315998
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


lists vs structs

2008-11-26 Thread Brian Dumbledore
I didn't want to extend the years old discussion on this thread, 
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:19468

I was looking for a custom tag which given two lists list1,list2 will give me 
back a struct with two lists 'toadd' and 'todelete'. 

toadd -- elements from list2 to be added to list1
todelete -- elements from list1 to be deleted (those that are not present in 
list2)

I wrote two versions, one based on lists and the other based on struct, in all 
cases (even smaller sizes), struct version outperforms list version. 

Anyone care to comment? Both versions given below:

STRUCT VERSION:



































LIST VERSION:


























~|
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:315997
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


OT- Godaddy Website hosting problem

2008-11-26 Thread Dave Hatz
We have a client that has hosted a web site on Godaddy, 
http://www.pearlciuminternational.com   It points to a web site on one of our 
servers, http://www.pearlcium.com/pearl.  The URL doesn't change to our URL 
when typing in http://www.pearlciuminternal.com, it keeps the URL that is 
hosted by Godaddy, so it doesn't look like a redirect.  The problem we are 
having, is we are using session variables within our pages, but they are not 
working in IE.  When you click on one of the links, the session variables are 
gone.  In FF works great, but IE it chokes.

Can someone explain why this is happening or what we can do to fix this on our 
end?  We are running CF7.02 Enterprise on Windows 2003 Server.

Thanks,
Dave 

~|
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:315996
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


IE 'Invalid Procedure Call' using CFGRID

2008-11-26 Thread Mark Pitts
This seems to be an IE only issue.

The problem occurs after loading multiple cfgrids inside of cflayout. I am not 
sure if the cflayout have anything to do with the problem.

In my case, I have 3 cfgrids defined inside of cflayout type="vbox". The vbox 
cflayout is defined inside of the center position of a cflayout type="border". 
Because this is the landing page for my site, the user is often sent back here, 
each time reloading the 3 cfgrids. It takes approximately 4 to 5 visits of this 
page before I start to see the problem. At this point all cfgrids in my site 
popup the same error.

Looking at the stack inside of visual studio the error points to "F.cssText=G". 
The only information I found about this problem is here 
http://extjs.com/forum/showthread.php?t=52930. 

I spent a few hours trying to build grids directly using the ext-js libraries 
(I found a reference this custom class CFJSONReader 
(http://extjs.com/forum/showthread.php?t=21408&highlight=cfjsonreader), but am 
having too many problems trying to get the ext.data.HttpProxy to work with the 
CF bundled ext JS 1.0.1)

Unfortunately, I have had to revert back to a pseudo grid constructed of HTML 
Tables.

Cheers!

www.edgewater.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:315995
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: single quote issue

2008-11-26 Thread Brian Dumbledore
Claude,

The cfquery is posted above, everything is the same except the missing comma 
before #val and instead of http://ad.doubleclick.net/clk;207172674;29440083;f

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


Re: cfajax broken in CF 8.0.1?

2008-11-26 Thread Mike Chabot
View source in the page, look for a path to a JavaScript file near the
top of the HTML that has "cfide" in it. Copy/paste that into the
browser address to see if the included file is found. Here is an
example:

/CFIDE/scripts/ajax/package/cfajax.js

-Mike Chabot

On Wed, Nov 26, 2008 at 11:40 AM, Chris Hampton
<[EMAIL PROTECTED]> wrote:
> Tom,
>
> Nothing in the logs is jumping out at me.  I've checked the IIS logs, 
> eventgateway.log, exception.log and server.log and nothing looks out of the 
> ordinary.
>
>> On Wednesday 26 Nov 2008, Chris Hampton wrote:
>> > And I get "ColdFusion is not defined" in the FF Error Console.  I
>> have
>> > verified that the CFIDE files are correct and even re-applied the
>> update.
>> > I'm at a loss at this point.
>>
>> Do the web or application server logs show anything ?
>>
>> --
>> Tom Chiverton
>> Helping to elementarily empower attention-grabbing out-of-the-box
>> eyeballs
>>
>>
>>
>> 
>>
>> 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 Halliwells LLP, 3 Hardman Square, Spinningfields,
>> Manchester, M3 3EB.  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 2500.
>>
>> For more information about Halliwells LLP visit www.halliwells.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:315993
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: PDF Compression Tag/SW

2008-11-26 Thread Bastian Schmid
Hello maya,

thanks for that hint!
But unfortunately I don't know where to set this properties. Such an attribute 
is neither within the cfdocument nor the cfpdf tag.

regards 

~|
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:315992
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cfajax broken in CF 8.0.1?

2008-11-26 Thread Huff, Jerome P.
This is a mapping problem with CF not knowing where to find the CFIDE
directory.

 

-Original Message-
From: Chris Hampton [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 26, 2008 11:41 AM
To: cf-talk
Subject: Re: cfajax broken in CF 8.0.1?

Tom,

Nothing in the logs is jumping out at me.  I've checked the IIS logs,
eventgateway.log, exception.log and server.log and nothing looks out of
the ordinary.

> On Wednesday 26 Nov 2008, Chris Hampton wrote:
> > And I get "ColdFusion is not defined" in the FF Error Console.  I 
> have
> > verified that the CFIDE files are correct and even re-applied the 
> update. 
> > I'm at a loss at this point.
> 
> Do the web or application server logs show anything ?
> 
> -- 
> Tom Chiverton
> Helping to elementarily empower attention-grabbing out-of-the-box 
> eyeballs
> 
> 
> 
> 
> 
> 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 Halliwells LLP, 3 Hardman Square, Spinningfields,

> Manchester, M3 3EB.  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 2500.
> 
> For more information about Halliwells LLP visit www.halliwells.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:315991
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Coldfusion 8 related drop down in the flash cfform

2008-11-26 Thread erik tom
>> I am trying to create a related drop down using flash remoting but it does
>> not work. here is my code
>>
>
>Be less vague than "it does not work".
>
>-- 
>I have failed as much as I have succeeded. But I love my life. I love my
>wife. And I wish you my kind of success.

The second drop down does not get populated 

~|
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:315990
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Coldfusion 8 related drop down in the flash cfform

2008-11-26 Thread Charlie Griefer
On Wed, Nov 26, 2008 at 8:41 AM, erik tom <[EMAIL PROTECTED]> wrote:

> I am trying to create a related drop down using flash remoting but it does
> not work. here is my code
>

Be less vague than "it does not work".

-- 
I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
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:315989
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Coldfusion 8 related drop down in the flash cfform

2008-11-26 Thread erik tom
I am trying to create a related drop down using flash remoting but it does not 
work. here is my code 


  
  

//create connection
var connection:mx.remoting.Connection = 
mx.remoting.NetServices.createGatewayConnection("http://#cgi.HTTP_HOST#/ColdFusion8/gateway";);
//declare service
var myService:mx.remoting.NetServiceProxy;


var responseHandler = {};

//put the controls in scope to avoid calling _root
var accessType = accessType;
   
responseHandler.onResult = function( results: Object ):Void {
//when results are back, populate the cfselect
accessType.labelField = "description";
accessType.dataProvider = results;
  
}

responseHandler.onStatus = function( stat: Object ):Void {
//if there is any error, show an alert
alert(stat.description);
}

//get service
myService = connection.getService("flashRemotingResponder", responseHandler 
);
//make call
myService.accessType(accessL.selectedItem.AccessTypeID);






  


My cfc is here 

  
  
  
select distinct 
a.accessLevel,a.description,a.accessTypeID from accessLevel a
inner join AccessType  al on 
al.accessTypeID=a.accessTypeID
where a.accessTypeID = #arguments.accessTypeID#
order by a.accessTypeID
  




Please help 

~|
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:315988
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfajax broken in CF 8.0.1?

2008-11-26 Thread Chris Hampton
Tom,

Nothing in the logs is jumping out at me.  I've checked the IIS logs, 
eventgateway.log, exception.log and server.log and nothing looks out of the 
ordinary.

> On Wednesday 26 Nov 2008, Chris Hampton wrote:
> > And I get "ColdFusion is not defined" in the FF Error Console.  I 
> have
> > verified that the CFIDE files are correct and even re-applied the 
> update. 
> > I'm at a loss at this point.
> 
> Do the web or application server logs show anything ?
> 
> -- 
> Tom Chiverton
> Helping to elementarily empower attention-grabbing out-of-the-box 
> eyeballs
> 
> 
> 
> 
> 
> 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 Halliwells LLP, 3 Hardman Square, Spinningfields, 
> Manchester, M3 3EB.  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 2500.
> 
> For more information about Halliwells LLP visit www.halliwells.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:315987
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: problem with sum of resuts of two queries

2008-11-26 Thread Dawson, Michael
You could also use QoQ to add them together, but it's not near as simple
as just adding the two values.

Mike 

-Original Message-
From: John M Bliss <[EMAIL PROTECTED]>
Sent: Wednesday, 26 November, 2008 09:46
To: cf-talk 
Subject: Re: problem with sum of resuts of two queries

Second relatively basic thing I learned about CFML syntax in as many
days!
I've used this language for more than a decade and I didn't know you
could omit the Evaluate()!

What else don't I know?  :-)

~|
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:315986
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Prevent direct access to XML data file?

2008-11-26 Thread Tom Chiverton
On Wednesday 26 Nov 2008, James Holmes wrote:
> I'm tempted to buy it just to break it and demonstrate how futile the
> process is.

I can think of a way to do it, maybe.
for every href=/dir/file.ext convert to href=/secure/token where token is a 
time-limited token tied to the original file, uniq. to each request. You can 
do that in an output filter in the web server or a front-end proxy.
When /secure/token is requested, if the token is still within it's limit, send 
back the original content (don't redirect, obv.) else fail.

Yes, you could still get it by screen scraping, but it'd be more work - at the 
end of the day that's all you can really do if the file has to be accessible.

-- 
Tom Chiverton
Helping to preemptively incubate synergistic models





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 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  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 2500.

For more information about Halliwells LLP visit www.halliwells.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:315985
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Domain permissions

2008-11-26 Thread Richard Meredith-Hardy
Dave

Thankyou for this, we'll try it.  (Sorry for late reply.)

Richard

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED] 
> Sent: 24 November 2008 16:10
> To: cf-talk
> Subject: Re: Domain permissions
> 
> > We've got a problem where the CF8 Services don't start 
> automatically 
> > after a server reboot.  Error is
> >
> > Event Type: Error
> > Event Source:   Service Control Manager
> > Event Category: None
> > Event ID:   7000
> > Date:   21/11/2008
> > Time:   10:43:24
> > User:   N/A
> > Computer:   INTRANET01
> > Description:
> > The Cold Fusion Application Server service failed to start 
> due to the 
> > following error:
> > The account name is invalid or does not exist, or the password is 
> > invalid for the account name specified.
> >
> > The thing is, I think these settings are correct, there's 
> no problem 
> > starting it manually.
> >
> > The whole system is running in a domain account (or is 
> supposed to be) 
> > I think what I want is a crib sheet to the whole setting up of 
> > permissions Etc. on Win server 2003 R2 / iis / CF8 / MSSQL 
> 2005 to run 
> > under a domain account.
> >
> > Does anyone have such a thing, or know where one is?
> 
> I'm not aware of any formal document that covers this in 
> detail. In this case, I don't think it's a permissions 
> problem anyway, since the service does start successfully 
> with the same credentials if you start it manually. I think 
> that the service is being started before the machine can talk 
> to the domain controller. I would recommend that you use the 
> DependOnService key to make it start later.
> 
> http://support.microsoft.com/kb/193888
> 
> 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:315980
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: problem with sum of resuts of two queries

2008-11-26 Thread Tom Chiverton
On Wednesday 26 Nov 2008, alex poyaoan wrote:
> like 
> #total1.expr1#+#total2.expr2#
> 

In addition to the other ways, you could also

#total#

-- 
Tom Chiverton
Helping to efficiently optimize design-patterns





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 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  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 2500.

For more information about Halliwells LLP visit www.halliwells.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:315984
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfajax broken in CF 8.0.1?

2008-11-26 Thread Tom Chiverton
On Wednesday 26 Nov 2008, Chris Hampton wrote:
> And I get "ColdFusion is not defined" in the FF Error Console.  I have
> verified that the CFIDE files are correct and even re-applied the update. 
> I'm at a loss at this point.

Do the web or application server logs show anything ?

-- 
Tom Chiverton
Helping to elementarily empower attention-grabbing out-of-the-box eyeballs





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 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  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 2500.

For more information about Halliwells LLP visit www.halliwells.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:315983
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfajax broken in CF 8.0.1?

2008-11-26 Thread Chris Hampton
Mike,

I created a page with:




http://localhost:8500/My_stuff/AjaxUI/Book/hello1.cfm', 
{x:100,y:100,height:300,width:400,modal:false,closable:false, 
draggable:true,resizable:true,center:true,initshow:true, 
minheight:200,minwidth:200})">


And I get "ColdFusion is not defined" in the FF Error Console.  I have verified 
that the CFIDE files are correct and even re-applied the update.  I'm at a loss 
at this point.

>If you create a sample test page that has nothing but a single AJAX
>feature on it, like a cfwindow tag, does that single test page work?
>On a complex page remember that a single JavaScript error can break
>all the JavaScript on the page.
>Is the CFIDE folder in a standard location that the updater could
>find? If not, then you might have to make sure the directory that your
>Web site is using has the latest cfide files in it.
>
>-Mike Chabot
>
>
>>>-Mike Chabot 

~|
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:315982
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: single quote issue

2008-11-26 Thread Tom Chiverton
On Wednesday 26 Nov 2008, Brian Dumbledore wrote:
> k cfqueryparam works. it saved all my singlequotes properly.

Always use cfqueryparam around any user supplied input in your cfquery tags.
*Always*.

-- 
Tom Chiverton
Helping to widespreadedly target market-driven platforms





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 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  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 2500.

For more information about Halliwells LLP visit www.halliwells.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:315981
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: problem with sum of resuts of two queries

2008-11-26 Thread John M Bliss
I didn't get the memo.  :-)

On Wed, Nov 26, 2008 at 9:27 AM, Ian Skinner <[EMAIL PROTECTED]> wrote:

> John M Bliss wrote:
> > [whew]  :-)
> >
> > On Wed, Nov 26, 2008 at 9:04 AM, Dave Watts <[EMAIL PROTECTED]> wrote:
> >
> >> I think that's new CF8 syntax.
> >>
> >> Dave Watts, CTO, Fig Leaf Software
> >>
> >> On Wed, Nov 26, 2008 at 8:40 AM, Andy Matthews <
> [EMAIL PROTECTED]
> >>
> >>> That's because you need both to be inside pound signs:
> >>>
> >>> #total1.expr1 + total2.expr2#
>
> If you are talking about the ability to add two numbers in an output
> like #this + that#, I have been doing that since at
> least CF 5, but IIRC you could not do this in the 4.5 or earlier.
>
>
>
>
> 

~|
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:315979
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: problem with sum of resuts of two queries

2008-11-26 Thread Ian Skinner
John M Bliss wrote:
> [whew]  :-)
>
> On Wed, Nov 26, 2008 at 9:04 AM, Dave Watts <[EMAIL PROTECTED]> wrote:
>   
>> I think that's new CF8 syntax.
>>
>> Dave Watts, CTO, Fig Leaf Software
>>
>> On Wed, Nov 26, 2008 at 8:40 AM, Andy Matthews <[EMAIL PROTECTED]
>> 
>>> That's because you need both to be inside pound signs:
>>>
>>> #total1.expr1 + total2.expr2#

If you are talking about the ability to add two numbers in an output 
like #this + that#, I have been doing that since at 
least CF 5, but IIRC you could not do this in the 4.5 or earlier.




~|
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:315978
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: problem with sum of resuts of two queries

2008-11-26 Thread John M Bliss
[whew]  :-)

On Wed, Nov 26, 2008 at 9:04 AM, Dave Watts <[EMAIL PROTECTED]> wrote:

> I think that's new CF8 syntax.
>
> Dave Watts, CTO, Fig Leaf Software
>
> -Original Message-
> From: John M Bliss <[EMAIL PROTECTED]>
> Sent: Wednesday, 26 November, 2008 09:46
> To: cf-talk 
> Subject: Re: problem with sum of resuts of two queries
>
> Second relatively basic thing I learned about CFML syntax in as many days!
> I've used this language for more than a decade and I didn't know you could
> omit the Evaluate()!
>
> What else don't I know?  :-)
>
> On Wed, Nov 26, 2008 at 8:40 AM, Andy Matthews <[EMAIL PROTECTED]
> >wrote:
>
> > That's because you need both to be inside pound signs:
> >
> > #total1.expr1 + total2.expr2#
> >
> >
> >
> > -Original Message-
> > From: alex poyaoan [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, November 26, 2008 8:35 AM
> > To: cf-talk
> > Subject: problem with sum of resuts of two queries
> >
> > HI everybody just wondering if there is a way i could sum the results of
> > two
> > queries and display it inside of cfoutput.. the queries are below
> >
> > 
> > SELECT  COUNT(id1) AS Expr1
> > FROMtable2
> > 
> >
> > 
> > SELECT  COUNT(id1) AS Expr1
> > FROMtable1
> > 
> >
> > like 
> > #total1.expr1#+#total2.expr2#
> > 
> >
> > but the above doesn't work
> >
> > thanks
> >
> >
> >
> >
>
>
>
> 

~|
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:315977
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: single quote issue

2008-11-26 Thread Claude Schneegans
 >>I see only 10 single quotes in the db. what is the workaround 

If you have only half of the single quotes in the db, it means that they 
have not been escaped
when transmitted to the query. One out of two is then interpreted as the 
escape code.
DO NOT use preserveSingleQuotes, the purpose of this function is not 
to... well preserve single quotes,
but to prevent CF from escaping them.
Can you post the code of your CFQURY? For some reason, the built-in 
automatic quote escaping has been by passed.

~|
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:315976
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: problem with sum of resuts of two queries

2008-11-26 Thread Dave Watts
I think that's new CF8 syntax.

Dave Watts, CTO, Fig Leaf Software 

-Original Message-
From: John M Bliss <[EMAIL PROTECTED]>
Sent: Wednesday, 26 November, 2008 09:46
To: cf-talk 
Subject: Re: problem with sum of resuts of two queries

Second relatively basic thing I learned about CFML syntax in as many days!
I've used this language for more than a decade and I didn't know you could
omit the Evaluate()!

What else don't I know?  :-)

On Wed, Nov 26, 2008 at 8:40 AM, Andy Matthews <[EMAIL PROTECTED]>wrote:

> That's because you need both to be inside pound signs:
>
> #total1.expr1 + total2.expr2#
>
>
>
> -Original Message-
> From: alex poyaoan [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 26, 2008 8:35 AM
> To: cf-talk
> Subject: problem with sum of resuts of two queries
>
> HI everybody just wondering if there is a way i could sum the results of
> two
> queries and display it inside of cfoutput.. the queries are below
>
> 
> SELECT  COUNT(id1) AS Expr1
> FROMtable2
> 
>
> 
> SELECT  COUNT(id1) AS Expr1
> FROMtable1
> 
>
> like 
> #total1.expr1#+#total2.expr2#
> 
>
> but the above doesn't work
>
> thanks
>
>
>
> 



~|
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:315975
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfdirectory directory to a another server

2008-11-26 Thread Dan O'Keefe
On Tue, Nov 25, 2008 at 7:16 PM, Dave Watts <[EMAIL PROTECTED]> wrote:

> > That was my conclusion as well - only way it can work is if a domain is
> > involved.
>
> It is possible, however, to use credentials that aren't valid locally
> to connect to a remote server:
>
> net use * \\server\share password /user:username
>

Interesting, that does make a successful connection. I logged into the CF
server with the CFService account and used the following:

net use z: \\192.168.1.160\share1 12345678 /user:CFService /persistent:yes

It creates the Drive Z, which I am using in the CFDirectory command but
still no results.

Dan


~|
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:315974
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: single quote issue

2008-11-26 Thread Seb Duggan
On 26 Nov 2008, at 14:33, Brian Dumbledore wrote:

> Ok Preservesinglequotes() didn't work. Got an error saying "invalid  
> construct '[' at.."
> All I did was to replace '#form[fn & "_" ocid]#' with
> '#preservesinglequotes(form[fn & "_" ocid])#'.

If that's what you've typed, there's a missing &:

'#preservesinglequotes(form[fn & "_" & ocid])#'


~|
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:315973
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: single quote issue

2008-11-26 Thread Brian Dumbledore
k cfqueryparam works. it saved all my singlequotes properly. But 
preservesinglequotes doesn't work. I still get the invalid construct '[' error.
Thanks for you time guys! 

~|
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:315972
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Prevent direct access to XML data file?

2008-11-26 Thread James Holmes
"The most comprehensive method gives you unbreakable protection
technology based on a cryptographic signing and link expiration."

I'm tempted to buy it just to break it and demonstrate how futile the
process is.

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


2008/11/26 Tom Chiverton:
> On Tuesday 25 Nov 2008, Dave Watts wrote:
>> > There's a list on their site. One of them claims to rewrite all the links
>> > on your site to have unique time bomb'ed URIs...
>> Yeah, that sounds like a great idea. No, wait, it doesn't.
>
> Aye. Book marking must be fun :-)

~|
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:315971
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: problem with sum of resuts of two queries

2008-11-26 Thread alex poyaoan
thanks all for the quick reply it worked


> HI everybody just wondering if there is a way i could sum the results 
> of two queries and display it inside of cfoutput.. the queries are 
> below 
> 
> 
> SELECT  COUNT(id1) AS Expr1
> FROM  table2 
> 
> 
> 
> SELECT  COUNT(id1) AS Expr1
> FROM  table1
> 
> 
> like  
> #total1.expr1#+#total2.expr2#
> 
> 
> but the above doesn't work
> 
> thanks 


~|
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:315970
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: problem with sum of resuts of two queries

2008-11-26 Thread John M Bliss
Second relatively basic thing I learned about CFML syntax in as many days!
I've used this language for more than a decade and I didn't know you could
omit the Evaluate()!

What else don't I know?  :-)

On Wed, Nov 26, 2008 at 8:40 AM, Andy Matthews <[EMAIL PROTECTED]>wrote:

> That's because you need both to be inside pound signs:
>
> #total1.expr1 + total2.expr2#
>
>
>
> -Original Message-
> From: alex poyaoan [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 26, 2008 8:35 AM
> To: cf-talk
> Subject: problem with sum of resuts of two queries
>
> HI everybody just wondering if there is a way i could sum the results of
> two
> queries and display it inside of cfoutput.. the queries are below
>
> 
> SELECT  COUNT(id1) AS Expr1
> FROMtable2
> 
>
> 
> SELECT  COUNT(id1) AS Expr1
> FROMtable1
> 
>
> like 
> #total1.expr1#+#total2.expr2#
> 
>
> but the above doesn't work
>
> thanks
>
>
>
> 

~|
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:315969
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: single quote issue

2008-11-26 Thread Brian Dumbledore
There is a comma missiing there.. typo somewhere down the line. That is the 
issue. that might make cfqueryparam work the way I want to. Plz ignore my prev 
post. 

~|
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:315968
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: problem with sum of resuts of two queries

2008-11-26 Thread Andy Matthews
That's because you need both to be inside pound signs:

#total1.expr1 + total2.expr2#



-Original Message-
From: alex poyaoan [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 26, 2008 8:35 AM
To: cf-talk
Subject: problem with sum of resuts of two queries

HI everybody just wondering if there is a way i could sum the results of two
queries and display it inside of cfoutput.. the queries are below 


SELECT  COUNT(id1) AS Expr1
FROMtable2 



SELECT  COUNT(id1) AS Expr1
FROMtable1


like  
#total1.expr1#+#total2.expr2#


but the above doesn't work

thanks 



~|
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:315967
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: problem with sum of resuts of two queries

2008-11-26 Thread Jason Fisher
 
 #evaluate(total1.expr1 + total2.expr2)#


That's the quick and dirty!


~|
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:315966
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: problem with sum of resuts of two queries

2008-11-26 Thread John M Bliss
#Evaluate(total1.Expr1 + total2.Expr1)#

On Wed, Nov 26, 2008 at 8:34 AM, alex poyaoan <[EMAIL PROTECTED]> wrote:

> HI everybody just wondering if there is a way i could sum the results of
> two queries and display it inside of cfoutput.. the queries are below
>
> 
> SELECT  COUNT(id1) AS Expr1
> FROMtable2
> 
>
> 
> SELECT  COUNT(id1) AS Expr1
> FROMtable1
> 
>
> like 
> #total1.expr1#+#total2.expr2#
> 
>
> but the above doesn't work
>
> thanks
>
> 

~|
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:315965
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


problem with sum of resuts of two queries

2008-11-26 Thread alex poyaoan
HI everybody just wondering if there is a way i could sum the results of two 
queries and display it inside of cfoutput.. the queries are below 


SELECT  COUNT(id1) AS Expr1
FROMtable2 



SELECT  COUNT(id1) AS Expr1
FROMtable1


like  
#total1.expr1#+#total2.expr2#


but the above doesn't work

thanks 

~|
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:315964
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: single quote issue

2008-11-26 Thread Brian Dumbledore
Ok Preservesinglequotes() didn't work. Got an error saying "invalid construct 
'[' at.."
All I did was to replace '#form[fn & "_" ocid]#' with 
'#preservesinglequotes(form[fn & "_" ocid])#'.

Then I tried cfqueryparam, got a 'could not prepare statement' error. But that 
could be because of the weird way the query is formed. Will anyone plz make 
comments on this query ?



insert into tblccontractinfo 
(contract_id,oc_id,#fldnames#)



 UNION ALL 
select #getkey.mkey#, #ocid# #val(form[fn & "_" & ocid])#,

  

What I am doing is, I am using a single insert query instead of multiple 
inserts, by doing a insert into select,
where my select is actually a 'union all' of multiple selects (based on the 
form input).

THE QUERY WORKS when I just use '#form[fn & "_" & ocid]#' instead of 
cfqueryparam or preservesinglequotes. But the only issue is, when I have say 
ten singlequotes one after the other in my form field, I see only five in the 
db after the insert.

What should I do ??




~|
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:315963
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Making a Recently Viewed list

2008-11-26 Thread Peter Boughton
I can't actually figure out what you're getting stuck on... actually re-reading 
your examples ... well, I'm afraid they look like nonsense.

So, I figured I'd write a simple Recently Viewed component, which should give 
you what you need to get all this working. :)

It's NOT perfect code (and is entirely untested), but should at least give you 
a base to work from.


To use it, do this:

---












---



And the actual recently_viewed.cfc code is this:
---
































































































   SELECT ProductID , ProductName , ThumbNail
   FROM AllProducts
   WHERE ProductID = 












---


~|
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:315962
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Making a Recently Viewed list

2008-11-26 Thread Seb Duggan
Should be possible without doing another query. Simply work with your  
list of recent product ids:












Product ID: #AllProducts.ProductID[i]#
Product Name: #AllProducts.ProductName[i]#
ThumbNail: #AllProducts.ThumbNail[i]#



(Code not tested, but should work fine).



Seb Duggan
Web & ColdFusion Developer

e:  [EMAIL PROTECTED]
t:  07786 333184
w:  http://sebduggan.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:315961
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Wrong results in query

2008-11-26 Thread John M Bliss
You're welcome.  As long as you only have one table in your FROM clause, you
don't need to use table.column anywhere in your query.  You can just use
column.  Makes for easier-to-read and easier-to-debug SQL.  Have a nice day!

On Wed, Nov 26, 2008 at 7:38 AM, Jason Congerton <[EMAIL PROTECTED]
> wrote:

> Hi John
>
> Worked a treat! Correct results are now being returned. Thank you
>
> 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:315960
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: File listing in Linux (Railo) Server

2008-11-26 Thread Tom Chiverton
On Wednesday 26 Nov 2008, Jibu S wrote:
> yes the mode is NULL in Railo

Oh well.

> But i want to list  the file permission as -rwxrwxrwx (0777)

Nothing springs to mind except cfexecuting 'ls' and parsing the answer, or 
seeing if there is a standard Java way to get at it.

-- 
Tom Chiverton
Helping to adaptively integrate plug-and-play real-time design-patterns





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 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  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 2500.

For more information about Halliwells LLP visit www.halliwells.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:315959
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Wrong results in query

2008-11-26 Thread Jason Congerton
Hi John

Worked a treat! Correct results are now being returned. Thank you

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:315958
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Wrong results in query

2008-11-26 Thread John M Bliss
I think you can significantly simplify your WHERE clause be losing some
"vacancies." and some parens.  Try:

WHERE
archive = 
AND vdivisionID =

AND vtype = 

AND
(
postitle LIKE  OR
freetext LIKE  OR
actlocation LIKE 
OR
vacdescrip LIKE 
OR
benefits LIKE 
)


On Wed, Nov 26, 2008 at 7:10 AM, Jason Congerton <[EMAIL PROTECTED]
> wrote:

> Hi
>
> The query below returns the wrong results when the #keywords# criteria is
> used.
>
> The query should return no more than 220 live vacancies, as all over
> vacancies have been archived. However, if you put in the #keywords# criteria
> other than all, the archive = no is completely ignored and 840 vacancies are
> returned.
>
> Please see query below, i think my brackets are in the right places. Not
> sure on this one??
>
>
> 
> SELECT vacancies.vacid, vacancies.archive, vacancies.vdivisionid,
> vacancies.vtype, vacancies.postitle, vacancies.freetext,
> vacancies.actlocation, vacancies.vacdescrip, vacancies.benefits,
> vacancies.vuserid, vacancies.salary, vacancies.advertdate,
> vacancies.archivedate, vacancies.mailout, vacancies.sitesend,
> vacancies.viewcount, vacancies.applycount, vacancies.searchcount,
> vacancies.rate, vacancies.jobsend, vacancies.internal, vacancies.vreference,
> vacancies.vcontactEmail
> FROM vacancies
> WHERE (((vacancies.archive) =  value="no">)
> AND ((vdivisionID) =
> )
> AND ((vtype) =  cfsqltype="cf_sql_clob" value="#vtype#">)
> 
> AND ((vacancies.postitle) LIKE  value="%#Keywords#%">))
> OR (((vacancies.freetext) LIKE  value="%#keyWords#%">)
> OR ((vacancies.actlocation) LIKE  value="%#keyWords#%">)
> OR ((vacancies.vacdescrip) LIKE  value="%#keyWords#%">)
> OR ((vacancies.benefits) LIKE  value="%keywords%">))
> ORDER BY advertdate DESC
> 
>
>
> 

~|
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:315957
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Wrong results in query

2008-11-26 Thread Jason Congerton
Hi

The query below returns the wrong results when the #keywords# criteria is used.

The query should return no more than 220 live vacancies, as all over vacancies 
have been archived. However, if you put in the #keywords# criteria other than 
all, the archive = no is completely ignored and 840 vacancies are returned.

Please see query below, i think my brackets are in the right places. Not sure 
on this one??



SELECT vacancies.vacid, vacancies.archive, vacancies.vdivisionid, 
vacancies.vtype, vacancies.postitle, vacancies.freetext, vacancies.actlocation, 
vacancies.vacdescrip, vacancies.benefits, vacancies.vuserid, vacancies.salary, 
vacancies.advertdate, vacancies.archivedate, vacancies.mailout, 
vacancies.sitesend, vacancies.viewcount, vacancies.applycount, 
vacancies.searchcount, vacancies.rate, vacancies.jobsend, vacancies.internal, 
vacancies.vreference, vacancies.vcontactEmail
FROM vacancies
WHERE (((vacancies.archive) = ) 
AND ((vdivisionID) = 
)
AND ((vtype) = )

AND ((vacancies.postitle) LIKE )) 
OR (((vacancies.freetext) LIKE ) 
OR ((vacancies.actlocation) LIKE )
OR ((vacancies.vacdescrip) LIKE ) 
OR ((vacancies.benefits) LIKE ))
ORDER BY advertdate DESC



~|
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:315956
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Making a Recently Viewed list

2008-11-26 Thread Andrew Scott
I would not store this in a cookie, a DB is more than enough to do this.

My reasoning behind this is that, what if the product numbers change? Would
that increase the cookie storage, nope it may chop of any text that will no
longer fit in the cookie. And even though you haven't mentioned it, how long
is the last review list? Would this ever change in the number to store, if
so a cookie is not ideal. A standard cfquery to a DB is sufficent enough.

Please dont use this stuff in cookies, that is not what a cookie should be
used for.

What happens if I delete the cookie, then  this info is gone forever. And if
it is not important to have the cookie deleted, then why dont you just store
it in a session variable to begin with.

Sorry but I cringe when people use the cookie for information like this, and
should be frowned upon. Who taught you this method?

On Wed, Nov 26, 2008 at 9:53 AM, K Simanonok <[EMAIL PROTECTED]> wrote:

> I am trying to build a 'Recently Viewed' feature for an ecommerce site to
> display thumbnail images and product names with links on them in the reverse
> order that customers click on them; in other words, the product they last
> viewed should appear at the top of the list.  I am having problems using
> either a Structure or Array to do this, although either should work.  But
> neither seems to work according to the documentation and I am stymied.  Here
> is how it might work, if it did work, using arrays.
>
> Every time a customer lands on a new Product page the ProductID of the
> product is appended to a list in a cookie named RECENTLYVIEWED, so that
> COOKIE.RECENTLYREVIEWED might have a value something like
> "647,73,123,621,733,818,290" from oldest to newest product viewed
>
> All the product data are in a cached query named AllProducts so that
> numerous subqueries like this one RecentlyViewed to get the rest of the data
> do not require another hit to the database:
>
> 
>   SELECT
>  ProductID,
>  ProductName,
>  ThumbNail
>   FROM AllProducts
>   WHERE ProductID IN (#COOKIE.RECENTLYVIEWED#)
> 
>
> Unfortunately the query doesn't output the records in the same order
> specified in the IN clause or it would be too easy; consequently the data
> have to be put into the correct order somehow.  Logically I would first
> initialize three arrays:
>
> 
> 
> 
>
> Then loop over the output of the RecentlyViewed query to set an array like
> this: (except it doesn't work)
>
> 
>
>"#RecentlyViewed.ProductID[hh]#">
>"#RecentlyViewed.ProductName[hh]#">
>"#RecentlyViewed.ThumbNail[hh]#">
>
> 
>
> This SHOULD produce an array with values like so: (except it doesn't work)
>
> AryProductID[647] = 647
> AryProductName[647] = 'Lemon Cake'
> AryThumbNail[647] = 'LemonCake.jpg'
>
> AryProductID[73] = 73
> AryProductName[73] = 'Cranberry Muffins'
> AryThumbNail[73] = 'CranMuffins.jpg'
>
> AryProductID[123] = 123
> AryProductName[123] = 'Blueberry Muffins'
> AryThumbNail[123] = 'BlueMuffins.jpg'
>
> etc.
>
> With arrays coded by the ProductID I should be able to use the
> COOKIE.RECENTLYVIEWED list of ProductIDs to output everything in its proper
> order like so by the use of Reverse(COOKIE.RECENTLYVIEWED): (except it
> doesn't work)
>
> 
>
>   
>
>  #AryProductID[ii]# (using the ProductID to construct a dynamic URL to
> the product, I know it's redundant and unnecessary in this particular case
> but it's just for illustration)
>  #AryProductName[ii]# (to display the product name on the customer's
> Recently Viewed list)
>  #AryThumbNail[ii]# (to display the product image with the product name
> on the customer's Recently Viewed list
>
>   
>
> 
>
> I don't care if I have to use Arrays, Structures, or anything else to get
> the data displayed the way I want, this is just an example of one way it
> might be done if ColdFusion actually worked the way it is documented to
> 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:315952
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: image function rounded rectangle?

2008-11-26 Thread Raymond Camden
You also want to consider this utility CFC Ben Nadel, myself, and
others have worked on:

http://imageutils.riaforge.org/

It contains a large number of 'utility' functions and includes rounded
corners (last time I checked ;).


On Sun, Nov 23, 2008 at 10:52 AM, Tony <[EMAIL PROTECTED]> wrote:
> sure is :) but durrrnit i guess i didnt put the cf8 part of the search
> in there, just looked
> for rounded rectangle images ...
>
> thanks!
>
> -- tony
>

~|
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:315955
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Making a Recently Viewed list

2008-11-26 Thread Andrew Scott
I would use an associated array, or better known in the cf world as a
structured array. For example

lastReviewed[Count].productId = productId

So if an item is reviewed then just add the structure to the end of the
array, then you can either use a reverse length of array down to zero to
display the information. This method would also allow for the data not to be
stored into the DB.

If you need it to persist across a user session, then you can just create a
table with the userID, productId and or date/time. Depending on the
cicrumstances, the incrementation of the autoid would be sufficent to do a
query with a sort desc on the table index id. Or via the date and time,
eitherway I do not believe you have allowed yourself enough time to
investiage the problem.




On Wed, Nov 26, 2008 at 10:47 PM, K Simanonok <[EMAIL PROTECTED]> wrote:

> >Reverse will reverse the whole string, not order of the list.
> >
> >Do something like this:
> >
> > 
> > 
> >
>
> Thank you, that is a very good suggestion but it is not the nut of the
> problem because I am not even there yet.  The bigger obstacle is getting
> either a Structure or Array to actually work.  What makes sense, is logical,
> and follows the examples in the documentation only generates error messages.
>  How can I get the data from the query into a form where I can address them
> by the actual ProductID in the COOKIE.RECENTLYVIEWED?
>
> 

~|
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:315954
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 decimal to fractions

2008-11-26 Thread Keith McGee
Thank you Seb this worked great. 

~|
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:315953
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Making a Recently Viewed list

2008-11-26 Thread K Simanonok
>Reverse will reverse the whole string, not order of the list.
>
>Do something like this:
>
> 
> 
>

Thank you, that is a very good suggestion but it is not the nut of the problem 
because I am not even there yet.  The bigger obstacle is getting either a 
Structure or Array to actually work.  What makes sense, is logical, and follows 
the examples in the documentation only generates error messages.  How can I get 
the data from the query into a form where I can address them by the actual 
ProductID in the COOKIE.RECENTLYVIEWED? 

~|
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:315951
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: File listing in Linux (Railo) Server

2008-11-26 Thread Jibu S
Hi

yes the mode is NULL in Railo

when i user 

   
(FileSetAccessMode used in linux)
the permission had change .

But i want to list  the file permission as -rwxrwxrwx (0777)







~|
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:315950
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: File listing in Linux (Railo) Server

2008-11-26 Thread Tom Chiverton
On Wednesday 26 Nov 2008, Jibu S wrote:
> but i dont get the permission (or mode) of the files in that format.

According to 
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags-pt0_01.html
 
the mode column is empty.
What do you get under Railo ?

-- 
Tom Chiverton
Helping to centrally syndicate viral clicks-and-mortar materials





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 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  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 2500.

For more information about Halliwells LLP visit www.halliwells.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:315949
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Read an uploaded file.

2008-11-26 Thread Tom Chiverton
On Tuesday 25 Nov 2008, Ian Skinner wrote:
> http request?  Looking at the  tag I have
> used for years, it is geared to saving the uploaded file to the server.
> But I don't need this.  It would require me to write the file to the
> server, read the file to get its content, and then delete the file as I
> do not want it hanging around the server.  It could be simpler if I
> could just get the data from the request and use it from there.

I needed to do the same thing recently, and plumbed for reading the file back 
in with cffile and then deleting it on the very next line.
Hopefully, the file will still be in the O/S or hardware cache (Linux ext3 
only saves writes every few seconds) and it shouldn't be a problem.

-- 
Tom Chiverton
Helping to quickly engage web-enabled sexy e-commerce





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 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  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 2500.

For more information about Halliwells LLP visit www.halliwells.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:315948
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


File listing in Linux (Railo) Server

2008-11-26 Thread Jibu S
Hi

I am using the code for listing files in a directory


(use full in widows)

I am using linux(Railo) server

i want to list the files in the directory as

File   SizePermission
   --
test.txt   4 kb-rw-r--r-- (0644)
index.html 80 kb   -rwxrwxrwx (0777)

file name and size are available from the filesDetails ()
but i dont get the permission (or mode) of the files in that format.

Thanks


~|
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:315947
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Prevent direct access to XML data file?

2008-11-26 Thread Tom Chiverton
On Tuesday 25 Nov 2008, Dave Watts wrote:
> > There's a list on their site. One of them claims to rewrite all the links
> > on your site to have unique time bomb'ed URIs...
> Yeah, that sounds like a great idea. No, wait, it doesn't.

Aye. Book marking must be fun :-)

-- 
Tom Chiverton
Helping to centrally exploit networks





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 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  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 2500.

For more information about Halliwells LLP visit www.halliwells.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:315946
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: DOS is ugly

2008-11-26 Thread Tom Chiverton
On Tuesday 25 Nov 2008, Dave Watts wrote:
> various ways. I like mine Unix green-on-black, for example. You can

I thought I was the only one !
Obviously I can't be seen to agree with you so I'm going orange-on-black with 
a blinking square cursor :-)

-- 
Tom Chiverton
Helping to dramatically lead magnetic intuitive wireless fourth-generation 
information





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 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  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 2500.

For more information about Halliwells LLP visit www.halliwells.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:315945
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4