from:"cf"

Hello everybody,

I have used the Employee.java example on the adobe livedocs 
(http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Java_7.html).
 Pleae Scroll down to the section titled Creating and using a simple Java 
class. I am running ColdFusion 7 server installation, developer version 
running on windows xp professional.
Server Product  ColdFusion MX
Version 7,0,2,142559  
Edition Developer

I complied the file Employee.java, and place the resulting Employee.class file 
in a directory in the C:\CFusionMX7\wwwroot\WEB-INF\classes folder. Is this 
right? The article on livedocs states that Save the following Java source code 
in the file Employee.java, compile it, and place the resulting Employee.class 
file in a directory that is specified in the classpath. How can I see the 
classpath? Is this the CLASSPATH environment variable or the CF Classpath?

Any help would be most appreciated.

Regards
John 

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

Re: 500 Event Handler Exception error when I try to create a java object

This is how I am trying to create the object.

cfset objEmp = createObject(java,Employee) /
cfdump var=#objEmp#

This is when it throws the exception.

 Hello everybody,
 
 I have used the Employee.java example on the adobe livedocs 
 (http://livedocs.adobe.com/coldfusion/8/htmldocs/help.
 html?content=Java_7.html). Pleae Scroll down to the section titled 
 Creating and using a simple Java class. I am running ColdFusion 7 
 server installation, developer version running on windows xp 
 professional.
 Server ProductColdFusion MX
 Version   7,0,2,142559  
 Edition   Developer
 
 I complied the file Employee.java, and place the resulting Employee.
 class file in a directory in the 
 C:\CFusionMX7\wwwroot\WEB-INF\classes folder. Is this right? The 
 article on livedocs states that Save the following Java source code 
 in the file Employee.java, compile it, and place the resulting 
 Employee.class file in a directory that is specified in the classpath. 
 How can I see the classpath? Is this the CLASSPATH environment 
 variable or the CF Classpath?
 
 Any help would be most appreciated.
 
 Regards
 John 


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

Re: FreeTTS API implementation doesn't work in ColdFusion7

Hi Isaac,

Thanks for your reply. I actually found this little helloworld freeTTS example 
online: 
http://processing.org/discourse/yabb_beta/YaBB.cgi?board=Sound;action=display;num=1204335245

I want to write a simple HelloWorld example in ColdFusion. I've got all the jar 
files I need.

cmudict04.jar
cmulex.jar
cmutimelex.jar
cmu_time_awb.jar
cmu_us_kal.jar
en_us.jar
freetts.jar
jsapi.jar 

would you be albe to show me how to do this in ColdFusion please?

cfset Voice = createObject(java,com.sun.speech.freetts.Voice) /
cfset VoiceManager = 
createObject(java,com.sun.speech.freetts.VoiceManager) /

 cfset voiceInstance = Voice
cfset voiceName[1] = kevin16
cfset VoiceMgrInstance = VoiceManager.getInstance()
cfset voiceInstance = VoiceMgrInstance.getVoice(voiceName)
cfdump var=#voiceInstance#

Your help on this matter is greatly appreciated.

Regards,
John

 cfset BootstrapClassLoader = createObject(java, coldfusion.bootstrap.Boot
 strapClassLoader).SystemClassLoader.newInstance(com.sun.speech.freetts.Voic
 eManager)
 
 cfset VoiceManager = createObject(java, coldfusion.runtime.java.JavaProxy
 ).init(BootstrapClassLoader)
 cfset Application.VoiceManagerInstance6 = VoiceManager.Instance

I'm not the most knowledgeable expert with regard to Java, but this just
looks to me like it was written by someone with Java experience, who
didn't bother to even test anything in ColdFusion and instead simply
assumed (wrongly) that everything in CF would work exactly the way he's
used to things working in Java... blech... 

Random guess (I haven't tried this), replace the entire 3 lines with
this: 

VMInstance = CreateObject(java,com.sun.speech.freetts.VoiceManager);

Then set Application.VoiceManager6 to that. 

The extra classes he created look to me like classes that are probably
instantiated automatically by CreateObject(), so using CreateObject to
instantiate them would be (I believe) just doubling up on those classes
and actually slowing them down, since you would be reflecting the
reflection. That's just a guess, but that's what it looks like to me.


 

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 781.769.0723

http://onTap.riaforge.org/blog 

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

Re: 500 Event Handler Exception error when I try to create a java object

500 Event Handler Exception. That's all it says. I've turned on debugging but 
it doesn't display any debugging information either.

 On Thursday 15 Jan 2009, cf coder wrote:
  This is when it throws the exception.
 
 What exception ?
 
 -- 
 Tom Chiverton
 Helping to appropriately transform market-growth
 
 
 
 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 together with a list of those non members who 
 are referred to as partners.  We use the word partner to refer to a 
 member of the LLP, or an employee or consultant with equivalent 
 standing and qualifications. 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:317991
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Using JCaptcha and FreeTTS to embed captcha and audio for the visually impaired

2009-01-13 Thread cf coder

We have decided to use a differnt API for the captcha. Regarding the speech,
FreeTTS is the API that we want to use.

I have been looking at this example which shows how to call it in ColdFusion
(Please look at the second example titled: FreeTTS CFC):
http://www.cfide.org/Text_to_Speech_Example_page.cfm

Unfortuanately you can't copy it as it is an image. I've typed in the first 3
lines of code:

cfset BootstrapClassLoader = createObject(java,
coldfusion.bootstrap.BootstrapClassLoader).SystemClassLoader.newInstance(com.sun.speech.freetts.VoiceManager)

cfset VoiceManager = createObject(java,
coldfusion.runtime.java.JavaProxy).init(BootstrapClassLoader)
cfset Application.VoiceManagerInstance6 = VoiceManager.Instance

I've copied the freetts.jar file which you can donwload from here
(http://downloads.sourceforge.net/freetts/freetts-1.2.1-bin.zip?modtime=1110396608big_mirror=0),
to my lib folder (C:\ColdFusionMX\lib) and it is in the coldfusion class-path.

When I run the above code, I get an error:

The selected method newInstance was not found.
Either there are no methods with the specified method name and argument types,
or the method newInstance is overloaded with arguments types that ColdFusion
can't decipher reliably. If this is a Java object and you verified that the
method exists, you may need to use the javacast function to reduce ambiguity.

Does anyone know why this is?

Regards,
John

I am hoping someone could provide me with some help in implementing
this on my
application. I am running ColdFusion 7 on a Windows Server. I have
been asked to display
a image and audio captcha in my form. I've visited both the JCpatcha
and FreeTTS
websites.

I would recommend that you avoid implementing CAPTCHAs at all. That's
probably not the answer you're looking for, but they're terrible
solutions from an accessibility perspective. Instead, you might look
at something like CFFormProtect (http://cfformprotect.riaforge.org/),
which lets you block spammers just as effectively without the
accessibility problems of CAPTCHAs.

Your client may have specifically requested a CAPTCHA, but ideally
the
developer should recommend alternative solutions when those solutions
are clearly superior.

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

FreeTTS API implementation doesn't work in ColdFusion7

2009-01-13 Thread cf coder

Hello everybody, 

I want to use the FreeTTS API to allow people with disabilies to have a better 
experience. I have been looking at this example which shows how to call it in 
ColdFusion (Please look at the second example titled: FreeTTS CFC):
http://www.cfide.org/Text_to_Speech_Example_page.cfm

Unfortuanately you can't copy it as it is an image. I've typed in the first 3 
lines of code:

cfset BootstrapClassLoader = createObject(java, 
coldfusion.bootstrap.BootstrapClassLoader).SystemClassLoader.newInstance(com.sun.speech.freetts.VoiceManager)

cfset VoiceManager = createObject(java, 
coldfusion.runtime.java.JavaProxy).init(BootstrapClassLoader)
cfset Application.VoiceManagerInstance6 = VoiceManager.Instance

I've copied the freetts.jar file which you can donwload from here 
(http://downloads.sourceforge.net/freetts/freetts-1.2.1-bin.zip?modtime=1110396608big_mirror=0),
 to my lib folder (C:\ColdFusionMX\lib) and it is in the coldfusion class-path.

When I run the above code, I get an error:

The selected method newInstance was not found.
Either there are no methods with the specified method name and argument types, 
or the method newInstance is overloaded with arguments types that ColdFusion 
can't decipher reliably. If this is a Java object and you verified that the 
method exists, you may need to use the javacast function to reduce ambiguity. 

Does anyone know why this is?

Regards,
John 

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

Using JCaptcha and FreeTTS to embed captcha and audio for the visually impaired

2009-01-12 Thread cf coder

Hi everybody,

I am hoping someone could provide me with some help in implementing this on my 
application. I am running ColdFusion 7 on a Windows Server. I have been asked 
to display a image and audio captcha in my form. I've visited both the JCpatcha 
)http://jcaptcha.sourceforge.net/) and FreeTTS 
(http://freetts.sourceforge.net/docs/index.php) websites.

I have not been able to find any help online on how to set up the jar files in 
coldfusion. My Java knowledge is very very basic. Would anyone be kind enough 
to show me or at least point me to the right direction?

I look forward to hearing from you

Regards,
John 

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

Re: Using JCaptcha and FreeTTS to embed captcha and audio for the visually impaired

2009-01-12 Thread cf coder

Hi Sam,

Thank you for your post. I have copied the files FreeTTS.jar file to my 
standalone ColdFusion installation folder: C:\CFusionMX7\lib\freetts.jar. I 
restarted ColdFusion and the jar file is now showing up in the class-path which 
is good. I can dump the methods in the FreeTTS class like this:
cfset freettsObj = CreateObject(java, com.sun.speech.freetts.FreeTTS)/
cfdump var=#freettsObj#cfabort

Please follow this link to see the list of classes and packages. 
http://freetts.sourceforge.net/javadoc/index.html

I'm getting somewhere but I don't know how to invokve the textToSpeech() method 
of the FreeTTS class. Basically, I want to pass a string to this function (the 
text that the captch randomly generates) and to convert this text to 
speeach/voice. When I get an error when I try to call this method in my code: 
cfset freettsObj.textToSpeech(randomStr) /

The system has attempted to use an undefined value, which usually indicates a 
programming error, either in your code or some system code.

Null Pointers are another name for undefined values. 

Any ideas?



 Hi everybody,
application specific jar files usually go in 

webapps/application_name/web-inf/lib

Sam 

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

(ot) Java-Hibernate-problem: Optimistic concurrency control problem, I need a second opinion !

2009-01-04 Thread cf-talk

Hi list,

in our freshly build Java B2B-Shop-Customer-System (build from scratch, based
on Hibernate. Spring etc.) we have
four adresses in the MS-SQL-DB (MS-SQL-2000): contact_address,
company_address, delivery_address, billing_address.

In the end-customer's registration process the following happens (in case the
customer says that the delivery_address + billing address is being
assembled out of the contact/-delivery_addresses and doesn't have to fill it
seperately):

a) contact_address is stored first - ok
b) company_address is stored first - ok
c) delivery_adress is stored from the data of the company_adress
d) billing_adress is stored from the data of the company_address

My Java-developer is trying to tell me, that this is not possible. He
mentioned the following: in part c) Hibernate recognizes, that the
object which is the most recent is older than the stored version in
the DB. The same happens when it comes to part d).
And he mentions that this is a Optimistic Concurrency Control problem.
(see: http://en.wikipedia.org/wiki/Optimistic_concurrency_control )
I told him that with ColdFusion, PHP and other scripting languages
this shouldn't be a problem, since you can store the data in server or
clientside variables/parameters. He replied, that this isn't possible with
Hibernate. This irritates me, since it would be a major problem, if
we have to change the business logic of this shop-feature feature from
ground up.

Any ideas ? Does anybody know of another good (Java)-forum where I can post
this question ? Thanks !!

Uwe





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

Re: ColdFusion + SVNkit

2008-12-18 Thread cf rotts

Ray,

I would like to compare the CFC I wrote to one written by a ColdFusion Jedi.

ro...@uwf.edu


Same here. I wrote a CFC wrapper for it intending to use it for
RIAForge, but ran into an issue. So it's flawed, but it's something,
and I can post it if you want it.



 Has anyone used the SVNkit (http://svnkit.com/) and can advise me how
 to interface ColdFusion (to obtain log messages from Subversion)?


 do you still need an answer on this, if so I have some code that may get you 
 going.






-- 
===
Raymond Camden, VP of Software Dev, Broadchoice

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

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

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

re: CF / Javascript question

2008-12-17 Thread CF Developer


Why not place a checkbox on the page (after the textarea) 
indicating: 

[ ] I have read the prescribed text.

If the box is checked, fire off a JS to enable the Continue button, else keep 
it disabled.

Just a thought!



From: Jenny Gavin-Wear 
jenn...@fasttrackonline.co.uk
Sent: Wednesday, December 17, 2008 6:54 AM
To: cf-talk cf-talk@houseoffusion.com
Subject: CF / Javascript question 

Hi all,

In a registration procedure, I need to do a verification that the person
registering has read a large piece of text.

The way I thought about doing is is with a scrolling div area which enables
a continue to next page option when the user has scrolled to the bottom of
the text.

How could I best go about this using CF and/or javascript, please?

Grateful for any ideas ...

Jenny



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

Re: cfqueryparam and LIKE operator error

2008-12-17 Thread CF Developer


It is as Dave suggested, you can not use CFQUERYPARAM as part 
of the actual SQL query.
You are writting the WHERE clause as a variable, remove the queryparam from 
that since you are declaring the variable.



From: JediHomer jediho...@gmail.com
Sent: Wednesday, December 17, 2008 3:17 AM
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: cfqueryparam and LIKE operator error 

Try wrapping the QueryParams...

i.e.

Change (P.product_code LIKE value=%tents%)

to (P.product_code LIKE (value=%tents%))

HTH

2008/12/16 Mike Little :
 hi guys,

 getting an error using the following syntax...

 WHERE ((P.product_code LIKE ) OR (PD.product_title LIKE ) OR 
 (PD.product_description LIKE ))

 the error i get is...

 You have an error in your SQL syntax; check the manual that corresponds to 
 your MySQL server version for the right syntax to use near ') OR 
 (PD.product_title ' at line 9

 this was working fine till i added the cfqueryparams.

 mike

 



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

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

PDF Compression Tag/SW

2008-11-25 Thread cf-talk

Hi list,
we have a coldfusion application
producing .pdf-files with the cffile-tag.
Our problem right now is, that each file
is 500-600 KByte (app. 2000 pdf-files).
The customer complained that the file size
is too large for sending those files to customers.
Is there any coldfusion-tag or other CF/non CF
solutions to descrease/compress the file size ?

Thank you in advance.

Uwe



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

Re: CF Job Market

2008-11-06 Thread CF Developer

I hope neither of you are making that a stereotype. I have 10 years as a CF 
developer, and EVERYTHING I do is OO, and I have a fundamental understanding of 
it, and use the usual OO frameworks like Mach-ii, ColdSpring, and Transfer 
(although I have developed OO apps without a front controller, too), and even 
built my own (closed, sorry) framework to solve specialized problems that the 
standard frameworks didn't. I have architected high-traffic, high-volume and 
high-revenue enterprise applications. Would you see 10 years on my resume and 
throw it out? I hope not.

I didn't post this looking for work, as I have a fulltime job (parttime 
freelance OK). I just wanted to respond to this thread. 

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

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

SQL help..

2008-10-29 Thread cf coder

Hello there,

I do appreciate this isn't the right forum for posting this question but I have 
posted my question in the SQL forum but I haven't heard anything back. It's a 
very straightforward query... at least I hope it is for someone with good sql 
skills.

I was hoping someone could help here. I have a table called 'phone_numbers' 
with two columns, one called 'person_name' and the other called 'number'. A 
person can have more than one number and I want the query to return all 
person's that have more than 3 numbers.

Jamie   1
Jamie   2
Jamie   3
Jamie   4
Allan   5
Vicki   6
Marilyn 7
Paul8
Scott   9
Scott   10
Scott   11
Scott   12

So in the above example, the query would return Jamie and Scott. How do I get 
this data?

Regards,
John 

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

Re: SQL help..

2008-10-29 Thread cf coder

I'm really greatful to you for the post.
Just answered this on the SQL list:
http://www.houseoffusion.com/groups/sql/thread.cfm/threadid:855 

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

Re: Why won't this query run in MySQL 5?

2008-09-08 Thread CF Developer

Try the following: (I think MySQL 5 uses the ( ) within the inner join
statements when using multiple conditions ) ** I could be wrong but can't
hurt to try

CFQUERY Name=Get_Client Datasource=#DSN#
Select  C.*, FG.*, E.*
fromclients C
inner join  family_groups FG, employers E on ( C.Family_ID =
FG.Family_ID and C.Employer_ID = E.Employer_ID )
where   C.Family_ID =
   (Select Family_ID
from   clients
where  Client_ID = '#Session.Client_ID#')
and C.Employer_ID =
   (Select Employer_ID
from   clients
where  Client_ID = '#Session.Client_ID#')
and C.Client_ID = '#URL.Client_ID#'

/CFQUERY


On Mon, Sep 8, 2008 at 8:26 AM, Will Tomlinson [EMAIL PROTECTED] wrote:

  Hi, all...
 
  I've just moved a website from a server running MySQL 4.1 to
  a server running MySQL 5 and now this query is giving me problems.
 

 I think the problem is in your uppercase CFQUERY tags.  Heehhehe...:)

 Seriously though, I've encountered the same kind of problems between MySQL
 versions. Sorry I can't help with your syntax problem. Just letting you know
 this isn't uncommon.

 Will

 

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

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

Re: cfinvoke webservice

2008-08-25 Thread CF Developer

are you sure the method that you are calling exists in the CFC file?

On 8/25/08, Bosky, Dave [EMAIL PROTECTED] wrote:

 Trying to invoke a webservice using CF but it keeps failing due to some
 error. Is there a common problem related to this error msg?

 Cannot perform web service invocation myMethodName.
 The fault returned when invoking the web service operation is:

 AxisFault
 faultCode: {http://xml.apache.org/axis/}HTTP
 faultSubcode:
 faultString: (500)Internal Server Error
 faultActor:
 faultNode:
 faultDetail: {}:return code:  500

 Thanks,

 Dave

 **
 HTC Disclaimer:  The information contained in this message may be
 privileged and confidential and protected from disclosure. If the reader of
 this message is not the intended recipient, or an employee or agent
 responsible for delivering this message to the intended recipient, you are
 hereby notified that any dissemination, distribution or copying of this
 communication is strictly prohibited.  If you have received this
 communication in error, please notify us immediately by replying to the
 message and deleting it from your computer.  Thank you.
 **


 

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

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

ColdFusion and Flex jobs

2008-08-20 Thread cf recruiter

http://cfrecruiter.blogspot.com/ 

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

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

ReFind - help with regex (ColdfusionMX 7)

2008-08-12 Thread cf coder

Hello everybody,

I need your help with regular expressions. I want to loop through a directory 
in my codebase and return a list of href tags. The href value for ex must be in 
this format. #request.udf.geturl(NUMERIC VALUE,STRING)#

a href=#request.udf.geturl(111,pagename)# class=btn title=FreeFREE/a

Here's what I have for now:

cfset thisPath = ExpandPath( \view)
cfdirectory action=list directory=#thisPath# name=viewDir recurse=true 
filter=dsp_*.cfm /

Processing #viewDir.recordcount# files.. br/

cfloop query=viewDir
#viewDir.name#
cffile action=read file=#viewDir.directory#\#viewDir.name# 
variable=contents charset=utf-8
!--- Regex goes here! ---
/cfloop

Can someone do me a big favour and send me the regular expression to match the 
string in the way I have mentioned? Many thanks in advance.

Regards,

John 

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

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

Re: ReFind - help with regex (ColdfusionMX 7)

2008-08-12 Thread cf coder

Is someone willing to help me with my problem? I would very much appreciate 
your help.

Regards,
J

 Hello everybody,
 
 I need your help with regular expressions. I want to loop through a 
 directory in my codebase and return a list of href tags. The href 
 value for ex must be in this format. #request.udf.geturl(NUMERIC VALUE,
 STRING)#
 
 a href=#request.udf.geturl(111,pagename)# class=btn 
 title=FreeFREE/a
 
 Here's what I have for now:
 
 cfset thisPath = ExpandPath( \view)
 cfdirectory action=list directory=#thisPath# name=viewDir 
 recurse=true filter=dsp_*.cfm /
 
 Processing #viewDir.recordcount# files.. br/
 
 cfloop query=viewDir
   #viewDir.name#
   cffile action=read file=#viewDir.directory#\#viewDir.name# 
 variable=contents charset=utf-8
 !--- Regex goes here! ---
 /cfloop
 
 Can someone do me a big favour and send me the regular expression to 
 match the string in the way I have mentioned? Many thanks in advance.
 
 Regards,
 
 John 


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

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

Re: ReFind - help with regex (ColdfusionMX 7)

2008-08-12 Thread cf coder

Hi Will,

I sincerely apologise to you and to anyone else who got the impression that I 
was someone who jsut wanted a quick solution. I began working on this yesterday 
evening, I have spent all of today trying out different things but have not had 
any luck yet.

This is what I've managed so far:

 cfset tmp = ReFind('(a href=(.+?).*?)(.+?)(\/a)', contents, 1, true) /

I think I'm right in saying that I don't have to match the a href, I'm only 
interested in #request.udf.geturl(NUMERIC VALUE,STRING)#


 Is someone willing to help me with my problem? I would very much 
 appreciate your help.
 
 Regards,
 J
 
 I'll tell you what I do in situations like this. I read info/books 
 about Regexs and try to solve it myself. 
 
 I may work on a problem for hours without finding a solution. 
 
 Then, if I can't figure it out, I'll post the non-working code I've 
 been working on to the list. Other folks on the list know I've at 
 least ATTEMPTED to solve my own problem and may be more inspired to 
 help out. If you simply want someone else to write code for you, 
 you're on the wrong list 
 
 Shoot, Regexs are just too cool not to learn anyway.  :)
 
 Will 


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

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

(ot) Stupid HTML Question

Okay, I must be having a brain fart today - I'm trying to get a cell in a
table to NOT wrap.  I actually want the text that doesn't fit to be hidden.
What am I missing? (btw, I'm coding only for IE for an internal app).  I've
done this before, just can't remember what I did.  I want the second cell to
NOT wrap.  Here's some test code:

table border=1 cellspacing=0 cellpadding=0 width=150
style=table-layout: fixed; 
col width=50/ 
col width=50/ 
col width=50/ 
tr 
tdnbsp;/td 
tdTest Test Test Test Test Test Test Test Test Test Test Test Test Test
Test Test Test Test Test Test Test Test Test /td
tdnbsp;/td 
/tr 
/table

What am I missing?

Dave Phillips


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309507
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) Stupid HTML Question

Wim,

This didn't work for me.  I still get the following:

http://www.zarts.com/test.cfm

Dave

-Original Message-
From: Wim Lemmens [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 8:04 AM
To: CF-Talk
Subject: Re: (ot) Stupid HTML Question

td style=width: 100px; overflow: hidden; nowrapTest Test Test Test Test
Test Test Test Test Test Test Test Test Test
Test Test Test Test Test Test Test Test Test /td

On Wed, Jul 23, 2008 at 3:00 PM, Experienced CF Developer 
[EMAIL PROTECTED] wrote:

 Okay, I must be having a brain fart today - I'm trying to get a cell in a
 table to NOT wrap.  I actually want the text that doesn't fit to be
hidden.
 What am I missing? (btw, I'm coding only for IE for an internal app).
I've
 done this before, just can't remember what I did.  I want the second cell
 to
 NOT wrap.  Here's some test code:

 table border=1 cellspacing=0 cellpadding=0 width=150
 style=table-layout: fixed;
 col width=50/
 col width=50/
 col width=50/
 tr
 tdnbsp;/td
 tdTest Test Test Test Test Test Test Test Test Test Test Test Test Test
 Test Test Test Test Test Test Test Test Test /td
 tdnbsp;/td
 /tr
 /table

 What am I missing?

 Dave Phillips


 



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309513
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) Stupid HTML Question

This did exactly what I want.  Thanks!  That's not how I did it before
because I didn't even know about this tag. LOL.  But hey, I'm not
complaining. :)

Thanks!

Dave

-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 8:13 AM
To: CF-Talk
Subject: RE: (ot) Stupid HTML Question

You could also wrap the contents in the nobrwill not wrap/nobr tag.


Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .
-Original Message-
From: Experienced CF Developer [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 9:00 AM
To: CF-Talk
Subject: (ot) Stupid HTML Question

Okay, I must be having a brain fart today - I'm trying to get a cell in a
table to NOT wrap.  I actually want the text that doesn't fit to be hidden.
What am I missing? (btw, I'm coding only for IE for an internal app).  I've
done this before, just can't remember what I did.  I want the second cell to
NOT wrap.  Here's some test code:


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


__ NOD32 3290 (20080723) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com






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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309514
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) Stupid HTML Question

Wim,

The nobr tag did what I wanted.  The code below did not work as you would
think it should (I had already tried those options myself).  If you look at
the page at http://www.zarts.com/test.cfm you will see the code you gave me
below but you will also see that the cell still wraps.

Thanks though!

Dave

-Original Message-
From: Wim Lemmens [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 8:52 AM
To: CF-Talk
Subject: Re: (ot) Stupid HTML Question

That's what you wanted, no?

You say I actually want the text that doesn't fit to be hidden.
That's what you get.

Please explain correctly what you want.

Wim.

On Wed, Jul 23, 2008 at 3:49 PM, Experienced CF Developer 
[EMAIL PROTECTED] wrote:

 Wim,

 This didn't work for me.  I still get the following:

 http://www.zarts.com/test.cfm

 Dave

 -Original Message-
 From: Wim Lemmens [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, July 23, 2008 8:04 AM
 To: CF-Talk
 Subject: Re: (ot) Stupid HTML Question

 td style=width: 100px; overflow: hidden; nowrapTest Test Test Test
Test
 Test Test Test Test Test Test Test Test Test
 Test Test Test Test Test Test Test Test Test /td

 On Wed, Jul 23, 2008 at 3:00 PM, Experienced CF Developer 
 [EMAIL PROTECTED] wrote:

  Okay, I must be having a brain fart today - I'm trying to get a cell in
a
  table to NOT wrap.  I actually want the text that doesn't fit to be
 hidden.
  What am I missing? (btw, I'm coding only for IE for an internal app).
 I've
  done this before, just can't remember what I did.  I want the second
cell
  to
  NOT wrap.  Here's some test code:
 
  table border=1 cellspacing=0 cellpadding=0 width=150
  style=table-layout: fixed;
  col width=50/
  col width=50/
  col width=50/
  tr
  tdnbsp;/td
  tdTest Test Test Test Test Test Test Test Test Test Test Test Test
Test
  Test Test Test Test Test Test Test Test Test /td
  tdnbsp;/td
  /tr
  /table
 
  What am I missing?
 
  Dave Phillips
 
 
 



 



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309517
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) Stupid HTML Question

Ah, that's it.  I'm only developing for IE for an internal app.

Dave

-Original Message-
From: Wim Lemmens [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 9:00 AM
To: CF-Talk
Subject: Re: (ot) Stupid HTML Question

I only checked in FireFox. There it works correctly.
IE messes it up...

On Wed, Jul 23, 2008 at 3:56 PM, Experienced CF Developer 
[EMAIL PROTECTED] wrote:

 Wim,

 The nobr tag did what I wanted.  The code below did not work as you
would
 think it should (I had already tried those options myself).  If you look
at
 the page at http://www.zarts.com/test.cfm you will see the code you gave
 me
 below but you will also see that the cell still wraps.

 Thanks though!

 Dave

 -Original Message-
 From: Wim Lemmens [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, July 23, 2008 8:52 AM
 To: CF-Talk
 Subject: Re: (ot) Stupid HTML Question

 That's what you wanted, no?

 You say I actually want the text that doesn't fit to be hidden.
 That's what you get.

 Please explain correctly what you want.

 Wim.

 On Wed, Jul 23, 2008 at 3:49 PM, Experienced CF Developer 
 [EMAIL PROTECTED] wrote:

  Wim,

  This didn't work for me.  I still get the following:

  http://www.zarts.com/test.cfm

  Dave

  -Original Message-
  From: Wim Lemmens [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, July 23, 2008 8:04 AM
  To: CF-Talk
  Subject: Re: (ot) Stupid HTML Question

  td style=width: 100px; overflow: hidden; nowrapTest Test Test Test
 Test
  Test Test Test Test Test Test Test Test Test
  Test Test Test Test Test Test Test Test Test /td

  On Wed, Jul 23, 2008 at 3:00 PM, Experienced CF Developer 
  [EMAIL PROTECTED] wrote:

   Okay, I must be having a brain fart today - I'm trying to get a cell
in
 a
   table to NOT wrap.  I actually want the text that doesn't fit to be
  hidden.
   What am I missing? (btw, I'm coding only for IE for an internal app).
  I've
   done this before, just can't remember what I did.  I want the second
 cell
   to
   NOT wrap.  Here's some test code:

   table border=1 cellspacing=0 cellpadding=0 width=150
   style=table-layout: fixed;
   col width=50/
   col width=50/
   col width=50/
   tr
   tdnbsp;/td
   tdTest Test Test Test Test Test Test Test Test Test Test Test Test
 Test
   Test Test Test Test Test Test Test Test Test /td
   tdnbsp;/td
   /tr
   /table

   What am I missing?

   Dave Phillips

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

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

RE: Consuming a Web Service with CF8

Steve,

Try hitting it with CFHTTP and see what you get:

cfhttp url=https://devurl.asmx?method=ZNAPing;/cfhttp
cfdump var=#cfhttp#

See what you get.  Maybe it's not written as a 'real' web service and simply 
just returns xml?

Dave
-Original Message-
From: Steve Sequenzia [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 1:41 PM
To: CF-Talk
Subject: Consuming a Web Service with CF8

Just to get this out of the way. I am pretty much brand new to web services so 
please excuse my lack of knowledge.

I have been working on a real small web app that allows the customer to input 
an invoice then it kicks out a csv of the invoices. My problem is that the 
vendor just added an additional step that requires that I check the invoice 
against a web service that will tell me if it is valid.

The vendor gave me a basic document that lays out the web services. There are 2 
web services one is just a ping and the other actually checks the invoice. I 
cannot get either of them to work and I am not sure why. Here is the info for 
the ping web service that they sent:

ZNAPing

Purpose:This web service was created to give an external customer an 
opportunity to verify availability of the ZNA Claims Web Services before 
calling in with actual request.

Signature:string ZNAPing( void );

Input:NONE

Result:string.

Note:Successful return will contain an XML fragment with the following 
information

ZNAPingResult
timeStamp9/24/2004 8:24:58 AM/timeStamp
Version0.61/Version
/ZNAPingResult

Client can parse this string to extract some information - timeStamp element 
contains date and time of the call, Version element Ã¢â¬â contains the 
version of the web services.


I have been trying to consume it using cfinvoke like this:

cfinvoke webservice = https://devurl.asmx; 
method = ZNAPing
returnVariable = getBack
username=username
password=password

cfoutput#getBack#/cfoutput

I am getting this error when I run it:

 Unable to parse WSDL as an XML document.
Parsing error: Fatal Error: URI=null Line=69: The element type p must be 
terminated by the matching end-tag 

Again, I am very new to web services so I am sure I am doing something wrong. 
If anyone could help point me in the right direction that would be very helpful.

Thanks in advance for any help.




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

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

RE: DataSource Events like Before Commit?

Joseph,

I don't think what you are trying to do is possible.  Can you give us some
more details of what you are trying to accomplish to see if we can help you
come up with an alternative solution?

Sincerely,

Dave Phillips

-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 22, 2008 4:50 AM
To: CF-Talk
Subject: DataSource Events like Before Commit?

Dear ColdFusion Users,

Is there a way that I can attach to a datasource through an event like
before_commit or before_update?

So, if I have a cfquery tag, and I would ColdFusion to automatically, before
ColdFusion executes the code found in the cfquery I would like it to
automatically execute another query for example to set the user id to the
database? In this way I do not need to make any modification to the existing
code except that of creating new code to do something before executing my
main query?
   
Thanks in advance for your assistance.

Regards,
Joseph. 



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

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

RE: DataSource Events like Before Commit?

Joseph,

I think Gert's suggestion earlier could work for you.  You could design a
trigger to fire the stored procedure prior to any Inserts or Updates.  Check
out this page on oracle site for some direction:

http://tinyurl.com/5sjhlg

I haven't done anything with triggers myself.  But if you want to avoid
re-coding your CFML, I think this is your route to go.

Of course, this will only work for you if the only thing changing your
tables is your CF app.  Any manual changes to the database, or any other
application accessing the same database would fire the triggers as well,
unless you can figure out a way to make them fire only when your app
accesses the database.

Hope this helps,

Dave Phillips

-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 22, 2008 6:51 AM
To: CF-Talk
Subject: Re: DataSource Events like Before Commit?

Thanks for your reply. Let me explain our scenario.

We have a number of cfquery tags that insert, update and delete data from
our Oracle database. Basically, before each query is run I need to execute a
stored procedure. This stored procedure sets the userid (the user currently
logged in) in the database for auditing purposes. We have hundreds of
queries and it is not good from a design perspective to rewrite each query
to call the same central piece of code before each query gets executed. 

So my original query should be:
  Original Query:
   cfquery
  DML Operation
   /cfquery

New requirement should be:
   cftransaction
 cfstoredproc   
Set the user id 
 /cfstoredproc   
 cfquery
DML Operation
 /cfquery 
   /cftransaction

As shown above, I need to call the cfstoredproc before each query is
executed. Personally, I would prefer if I keep my original design and before
the original query is run the ColdFusion engine automatically injects the
new call in a transaction to set the clientid.

Do you have any suggestions?

Joseph,

I don't think what you are trying to do is possible.  Can you give us some
more details of what you are trying to accomplish to see if we can help you
come up with an alternative solution?

Sincerely,

Dave Phillips

Dear ColdFusion Users,

Is there a way that I can attach to a datasource through an event like
before_commit or before_update?

So, if I have a cfquery tag, and I would ColdFusion to automatically,
before
ColdFusion executes the code found in the cfquery I would like it to
automatically execute another query for example to set the user id to the
database? In this way I do not need to make any modification to the
existing
code except that of creating new code to do something before executing my
main query?
   
Thanks in advance for your assistance.

Regards,
Joseph. 



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

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

RE: DataSource Events like Before Commit?

Got it.  Now I understand better.  You want to pass the userid of your
'logged in user' to track the change in the database instead of using the
user id that the datasource is logged in as.

I don't see any way for you to do this without changing your code.  Maybe
someone else can come up with something, but I just don't see any way around
it.  Whether you change it to implement the idea you had below or do it some
other way, bottom line is, you will need to change your code to make Oracle
aware of each individual user's ID.

You might still be able to find a way to use the triggers, but I still think
you'll need a code change.

Sorry, no help.

Dave
-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 22, 2008 7:28 AM
To: CF-Talk
Subject: Re: DataSource Events like Before Commit?

Thanks again for your reply.

Unfortunately, I need to pass the userid prior to executing each query as
otherwise the auditing function would not know the userid. We have triggers
on tables but triggers need the read the userid apriori.

ColdFusion does not allow us to build our connection string dynamically or
to dynamically inject connection string variables (such as the userid), as
is the case with VB.NET and C#. This is why I am looking for an alternative.

Joseph,

I think Gert's suggestion earlier could work for you.  You could design a
trigger to fire the stored procedure prior to any Inserts or Updates.
Check
out this page on oracle site for some direction:

http://tinyurl.com/5sjhlg

I haven't done anything with triggers myself.  But if you want to avoid
re-coding your CFML, I think this is your route to go.

Of course, this will only work for you if the only thing changing your
tables is your CF app.  Any manual changes to the database, or any other
application accessing the same database would fire the triggers as well,
unless you can figure out a way to make them fire only when your app
accesses the database.

Hope this helps,

Dave Phillips

Thanks for your reply. Let me explain our scenario.

We have a number of cfquery tags that insert, update and delete data from
our Oracle database. Basically, before each query is run I need to execute
a
stored procedure. This stored procedure sets the userid (the user currently
logged in) in the database for auditing purposes. We have hundreds of
queries and it is not good from a design perspective to rewrite each query
to call the same central piece of code before each query gets executed. 

So my original query should be:
  Original Query:
   cfquery
  DML Operation
   /cfquery

New requirement should be:
   cftransaction
 cfstoredproc   
   Set the user id 
 /cfstoredproc   
 cfquery
   DML Operation
 /cfquery 
   /cftransaction

As shown above, I need to call the cfstoredproc before each query is
executed. Personally, I would prefer if I keep my original design and
before
the original query is run the ColdFusion engine automatically injects the
new call in a transaction to set the clientid.

Do you have any suggestions?

before
ColdFusion executes the code found in the cfquery I would like it to
automatically execute another query for example to set the user id to the
database? In this way I do not need to make any modification to the
existing
code except that of creating new code to do something before executing my
main query?
   
Thanks in advance for your assistance.

Regards,
Joseph. 



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

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

RE: DataSource Events like Before Commit?

Joseph,

I did some googling and found that Oracle has 'proxy user authentication'.
See this Ask Tom article (someone wanting to do the same thing as you are,
but in java):

http://tinyurl.com/6qe8xk

Although I don't know if you can do it with the ColdFusion setup directly,
but maybe you can access some underlying java component to do it.  Hopefully
this might give you another alternative.  Let me know how it turns out.

Dave 

-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 22, 2008 7:57 AM
To: CF-Talk
Subject: Re: DataSource Events like Before Commit?

Exactly!

You perfectly understood my concern. If ColdFusion supported dynamic
connection parameter injection or proxy authentication then we can identify
the connection pool users but there is no straightforward solution to this.
Through pooling we are connected through one db user which for security
complaince (PCI) we need to remove this hole while keeping the benefits of
pooling. Triggers can help certainly help us for auditing but again at db
level I do not want have the same user showing up in my logs. 

Got it.  Now I understand better.  You want to pass the userid of your
'logged in user' to track the change in the database instead of using the
user id that the datasource is logged in as.

I don't see any way for you to do this without changing your code.  Maybe
someone else can come up with something, but I just don't see any way
around
it.  Whether you change it to implement the idea you had below or do it
some
other way, bottom line is, you will need to change your code to make Oracle
aware of each individual user's ID.

You might still be able to find a way to use the triggers, but I still
think
you'll need a code change.

Sorry, no help.

Dave
Thanks again for your reply.

Unfortunately, I need to pass the userid prior to executing each query as
otherwise the auditing function would not know the userid. We have triggers
on tables but triggers need the read the userid apriori.

ColdFusion does not allow us to build our connection string dynamically or
to dynamically inject connection string variables (such as the userid), as
is the case with VB.NET and C#. This is why I am looking for an
alternative.

Joseph,

I think Gert's suggestion earlier could work for you.  You could design a
trigger to fire the stored procedure prior to any Inserts or Updates.
Check
a
before 



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

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

RE: (ot) URL Hack Attempt Leaves Me Scractching My Head... For Mark Kruger

Okay, stupidly, I clicked on rent.com (? Used to avoid perpetuation) to
see what Brian was talking about and now I see the reference to a .js file
on one of the pages.  I didn't just infect my pc with something, did I?

I surely hope that we are not perpetuating some virus with these e-mails.  

Also, Brian, IMHO, I think your comment would have been more appropriate to
make off-list.

Sincerely,

Dave Phillips


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

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

RE: ('1,1') * 1 = 39448

Looked like it could be a ColdFusion date value to me.  So I did a
dateFormat() on that and came up with 01/01/2008:

cfset nValue = 1,1 * 1
cfoutput#dateFormat(nValue,mm/dd/)#brbr/cfoutput

It's assuming 1,1 is the current month and year.  I did the same for
5,23 * 1 and got 05/23/2008.

What's really fun is if you do 1,1 * 2..

Go ahead... see what you get.  10/15/2116

Now go figure THAT one out!

Dave Phillips

-Original Message-
From: Bert Dawson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 22, 2008 5:08 PM
To: CF-Talk
Subject: ('1,1') * 1 = 39448

I tracked down a defect to a piece of code which basically did the
following:

total = form.quantity * form.itemamount

In some cases, form.quantity is commong through as *1,1* which is presumably
due to an HTML issue with duplicate form fields with the same name.

But rather than getting a CF error cos 1,1 isn't a number, it evaluates to
39448!

i.e.
cfoutput'1,1' * 1 = #'1,1' * 1#/cfoutput
produces:
   '1,1' * 1 = 39448

I'm not worried about the original problem with the form.quantity coming
though as *1,1* rather than the expected *1* since I can fix that, but i'm
curious as to any reason for this odd result.

It looks like (x,y) * 1 is the same as (y,x) * 1
In other words
cfoutput#'5,23' * 1# = #'23,5' * 1# = 39591/cfoutput

As i say, i'm not worried about fixing the defect, but i'm just curious if
there is an underlying explanation for the apparently wierd behaviour. Or is
it just a bug in the way CF does the conversion?

Cheers
Bert

p.s. FWIW here's a snippet which will create a 101 square grid of all the
combinations:

table border=1
cfloop from=0 to=100 index=i
tr
cfloop from=0 to=100 index=j
td nowrap=true#wtf(i,j)#/td
/cfloop
/tr
/cfloop
/table

cfscript
function wtf(a,b) {
var x = '#a#,#b#';
try {
return '#x#*1 = '  x*1;
}
catch(Any E) {
return '#x#*1 pukes';
}
}
/cfscript




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

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

RE: Mystery Character

Robert,

Can't see the character, but check out http://www.asciitable.com and see if
you can find it there.

Dave

-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 21, 2008 3:17 PM
To: CF-Talk
Subject: Mystery Character

Does anyone know the character code for this character: .

My Mac users are uploading files with this character and it does not work in
a URL string... I'd kill it but I don't know what character it is. Using .
in a regex replace does not work. 



Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .





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

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

RE: Mystery Character

Doesn't asc('x') do that?  Or am I missing something?

Dave

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 21, 2008 3:53 PM
To: CF-Talk
Subject: RE: Mystery Character

I've ran into things like this before.  Is there a CF function (or even
a way in Java) to take a character and return the ASCII code for it?
(Or whatever is appropriate, I don't know if ASCII is really the right
term)

~Brad

-Original Message-
From: morgan l [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 21, 2008 3:49 PM
To: CF-Talk
Subject: Re: Mystery Character

Try here:
http://www.miniguidez.com/macosx/keystrokesguide/specialcharacters/speci
alcharacters.html
It lists decimal and hex values for corresponding mac keystrokes.

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

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

RE: Mystery Character

Actually, I just looked it up:

http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt121.htm

According to this page, starting in MX 6, asc() supports values up to 65536,
so it should work for you.

Output your character value to the screen with asc(sFunkyCharacter) and
you'll find out the value of it.

Another thing you could do, if you really wanted to, was check all asc()
values if each character in your string and if they exceed 255, then leave
them out.  That will ensure it works properly on Windows File System (which
I'm assuming is the issue you are having).

Dave

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 21, 2008 3:53 PM
To: CF-Talk
Subject: RE: Mystery Character

I've ran into things like this before.  Is there a CF function (or even
a way in Java) to take a character and return the ASCII code for it?
(Or whatever is appropriate, I don't know if ASCII is really the right
term)

~Brad

-Original Message-
From: morgan l [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 21, 2008 3:49 PM
To: CF-Talk
Subject: Re: Mystery Character

Try here:
http://www.miniguidez.com/macosx/keystrokesguide/specialcharacters/speci
alcharacters.html
It lists decimal and hex values for corresponding mac keystrokes.



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

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

RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...