Re: NullPointers error problem

2008-09-11 Thread Stefano Borali
Matt, thanks you so much! I was waiting to end testing your suggestion (as i would to the Geneve's CERN) to thanks you. Stefano Matt Quackenbush ha scritto: There is a known bug with the MySQL drivers. In your CF Administrator, click to edit your datasource and do the following: 1)

variables.instance vs cfproperty in beans

2008-09-11 Thread Richard White
hi i have posted this question on model glue google groups but was wondering if you guys could help me with this question as well: we are creating beans and have noticed in tutorials that some people use cfset variables.instance = structnew() and then start placing all the variables inside this

RE: variables.instance vs cfproperty in beans

2008-09-11 Thread Dave Watts
we are creating beans and have noticed in tutorials that some people use cfset variables.instance = structnew() and then start placing all the variables inside this variables.instance structure. however if we build up the cfc through the cfeclipse cfc builder then it creates all

Re: variables.instance vs cfproperty in beans

2008-09-11 Thread Richard White
thanks alot dave, just to clarify, will any variables defined with the cfproperty tag automatically be private to the cfcomponent,just like function arguments are private just to that function? thanks we are creating beans and have noticed in tutorials that some The CFPROPERTY tag doesn't

Re: BUMP Re: Odd null pointer error

2008-09-11 Thread Bryan Stevenson
On Wed, 2008-09-10 at 19:25 -0400, Dan O'Keefe wrote: Bryan, What version of mySQL are you using? Dan 5 - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED]

Re: BUMP Re: Odd null pointer error

2008-09-11 Thread Bryan Stevenson
On Wed, 2008-09-10 at 22:39 -0500, Matt Quackenbush wrote: On Wed, Sep 10, 2008 at 4:42 PM, Bryan Stevenson wrote: If it persists I will have no choice but to drop MySQL and port the DB to MS SQL Server. That would be a very wise move, in my opinion. :-) Yeah I've always liked MS

Re: NullPointers error problem

2008-09-11 Thread Bryan Stevenson
Matt Quackenbush ha scritto: There is a known bug with the MySQL drivers. In your CF Administrator, click to edit your datasource and do the following: 1) uncheck the maintain connection, and 2) add the number zero in the validation query box That should fix your issue. FYII

Re: BUMP Re: Odd null pointer error

2008-09-11 Thread Bryan Stevenson
i haven't been following this thread very closely but have you tried the latest mysql jdbc connector from mysql as other? http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.6.zip/from/pick Hey Paul, Not sure what's on this VPS (I didn't set it up). If the issue

RE: variables.instance vs cfproperty in beans

2008-09-11 Thread Dave Watts
just to clarify, will any variables defined with the cfproperty tag automatically be private to the cfcomponent,just like function arguments are private just to that function? No. The CFPROPERTY tag doesn't define variables, it documents them. If you have a CFPROPERTY tag, it will show

Re: variables.instance vs cfproperty in beans

2008-09-11 Thread Richard White
ok got ya, thanks dave richard just to clarify, will any variables defined with the cfproperty tag automatically be private to the cfcomponent,just like function arguments are private just to that function? No. The CFPROPERTY tag doesn't define variables, it documents them. If you have a

Function Argument Order

2008-09-11 Thread Robert Nurse
Hi All, I've got a function that takes four (4) arguments. Two of which are not required. They both have default values set up in their cfargument... tags. When I call the function without one/both of them, I get an error. I vaguely remember a way to make the call in such a way as to tell

Re: Function Argument Order

2008-09-11 Thread Charlie Griefer
On Thu, Sep 11, 2008 at 11:15 AM, Robert Nurse [EMAIL PROTECTED] wrote: Hi All, I've got a function that takes four (4) arguments. Two of which are not required. They both have default values set up in their cfargument... tags. When I call the function without one/both of them, I get an

Re: Outdated Adobe Performance-Tuning Info

2008-09-11 Thread Jamie Jackson
On 9/10/08, Jamie Jackson [EMAIL PROTECTED] wrote: On 9/10/08, Mark Kruger [EMAIL PROTECTED] wrote: Also, if you are running JRUN multi-server the settings for the simultaneous threads available to JRUN is very important. It is set to 50 by default... But needs to be adjusted

(ot) SQL Join With LIKE in Join Criteria

2008-09-11 Thread Dawson, Michael
I am joining two table based on a partial match of data. The data is for our school's terms/semesters and the courses for those terms. My query works fine, as far as I can tell. I just want to make sure someone else doesn't see anything wrong with my solution. One table has values such as:

RE: Outdated Adobe Performance-Tuning Info

2008-09-11 Thread Mark Kruger
Jamie... Sorry... I missed your question (doh!) Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2008 1:39 PM To: CF-Talk Subject:

Re: (ot) SQL Join With LIKE in Join Criteria

2008-09-11 Thread Jeff Becker
Very interesting Michael. A good solution based on the environment your working with. I'm no DBA, but I do have a feeling this is an example where proper normalization would help out significantly. In terms of performance, I have no idea if you'll have a problem, but I believe anytime a LIKE

Re: variables.instance vs cfproperty in beans

2008-09-11 Thread denstar
On Thu, Sep 11, 2008 at 10:10 AM, Dave Watts [EMAIL PROTECTED] wrote: just to clarify, will any variables defined with the cfproperty tag automatically be private to the cfcomponent,just like function arguments are private just to that function? No. The CFPROPERTY tag doesn't define

RE: variables.instance vs cfproperty in beans

2008-09-11 Thread Dave Watts
Doesn't CFPROPERTY do something for web-services? Help with the stub generation or something? That's the only reason besides documentation that I can come up with. And it might still just be documentation. That is, in fact, still just documentation. It affects WSDL generation without

RE: (ot) SQL Join With LIKE in Join Criteria

2008-09-11 Thread Dawson, Michael
Thanks for the reply. Actually, this is properly normalized, rather, as normalized as it can get. The courseId uniquely identifies a course in our Blackboard system. So far, I haven't seen any performance issues. I even had to add a couple other joins to get enrollment and user details. Still,

Re: (ot) SQL Join With LIKE in Join Criteria

2008-09-11 Thread Qing Xia
Hmm so long as the data in the 2nd table is consistent, you are safe. If one day, the 2nd table has data like Bad_Data_2008FA_bad, then your solution will break. This solution, I think, at its best, is temporary. A more permenant solution will be to have a REF table where the value of table

RE: (ot) SQL Join With LIKE in Join Criteria

2008-09-11 Thread Dawson, Michael
Thanks for the reply. The source data is stored in a normalized structure. I have to put it together to import into Blackboard, our course management system, as unique course IDs. The primary data is stored in tables created by Blackboard. Therefore, I can't do anything with it. I only get

Re: redirecting cfmail to a different destination using CF

2008-09-11 Thread Beru
Thanks for your suggestion Mark... Needless to say that I can't waste my time chasing our messy developpers (not my job), I was just looking for a simple solution to override all 'to' fields of mail going out of our dev server... On Wed, Sep 10, 2008 at 16:38, Mark Kruger [EMAIL PROTECTED] wrote:

Re: redirecting cfmail to a different destination using CF

2008-09-11 Thread Beru
Denstar, I might be interested in this subethasmtp, how do you use it? So if this is not a real smtp daemon, I guess you can define it as your mail server in CF admin, but what happens to your mail once submitted to subethasmtp? On Wed, Sep 10, 2008 at 22:41, denstar [EMAIL PROTECTED] wrote: On

CF and Access

2008-09-11 Thread Aaron Rouse
I have this small project that I inherited that uses MS Access for its data source. I am trying to run an update query via a cfquery but keep getting an error. I can open up Access and paste the query in there and it runs fine which leads me to believe there is nothing wrong with the query

Re: variables.instance vs cfproperty in beans

2008-09-11 Thread Gerald Guido
It affects WSDL generation without affecting the actual functionality of the CFC. And WSDL is just documentation, for SOAP clients instead of people. Good to know. I was wondering why, given the self documenting nature of CFC's, that CFProperty warranted tag status. Dave, you are a freakin

Re: CF and Access

2008-09-11 Thread Mike Little
at a rough guess, i suspect that you cannot use an explicit cf function such as datediff in the query. I have this small project that I inherited that uses MS Access for its data source. I am trying to run an update query via a cfquery but keep getting an error. I can open up Access and paste

Re: CF and Access

2008-09-11 Thread Matt Quackenbush
No problem with using DateDiff() as he is using it, since it is not surrounded by #. It has been a bazillion years since I've used Access, but as I recall, that particular error message has something to do with a lack of quotes (e.g. 'foo') on a field that the driver wants them on. Maybe the

Does CF8 or CF8.1 have some sort of screen capture function?

2008-09-11 Thread Don L
A screen, be it, simple text or multmedia content or a mix of them, does the current CF version have anything like CFscreenCapture something? I don't think CFimage would do what I'm asking here. TIA. ~| Adobe® ColdFusion® 8

Re: Does CF8 or CF8.1 have some sort of screen capture function?

2008-09-11 Thread James Holmes
No. Who's screen are you trying to capture? The server's or the client's? On Fri, Sep 12, 2008 at 11:26 AM, Don L [EMAIL PROTECTED] wrote: A screen, be it, simple text or multmedia content or a mix of them, does the current CF version have anything like CFscreenCapture something? I don't

RE: Does CF8 or CF8.1 have some sort of screen capture function?

2008-09-11 Thread Andrew Scott
The answer is what are you trying to achieve, if you mean by capturing the screen the answer is no. ColdFusion is server side, screen capture is client side. If you mean could you turn an html page into a PDF to print, the answer is yes. If you need to print ColdFusion has a cfprint that could

RE: Does CF8 or CF8.1 have some sort of screen capture function?

2008-09-11 Thread Dave Watts
A screen, be it, simple text or multmedia content or a mix of them, does the current CF version have anything like CFscreenCapture something? I don't think CFimage would do what I'm asking here. You can use CFHTTP, then write it to a PDF with CFDOCUMENT. This is covered in Adobe's

Re: CF and Access

2008-09-11 Thread Aaron Rouse
Yeah, the function is an Access function, just has the same name as CF. I thought maybe the Yes/No column was throwing it off initially and tried a cfqueryparam on that one but it helped none. I did not play with the date though and will see if maybe that is the root of it. On Thu, Sep 11, 2008

Re: CF and Access

2008-09-11 Thread Claude Schneegans
I thought maybe the Yes/No column was throwing it This is also my guess. Yes may be recognized by Access when the query is submitted directly, but it is not standard SQL and the JDBC driver will interpret it as a column name. Try INT_PARTRETURNED = 1 instead (don't include instead in the query

Re: Does CF8 or CF8.1 have some sort of screen capture function?

2008-09-11 Thread Azadi Saryev
be aware, though, that it will not capture 'multimedia' content like flash. sometime ago i have posted sample code for this either on this list or maybe over on adobe cf forums... will try to dig up the link for you... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dave Watts wrote: A

Re: CF and Access

2008-09-11 Thread Matt Quackenbush
Aaaah. Just noticed the Yes in the query. Have you tried cf_sql_bit (cfqueryparam) with a value of 1 instead of the Yes? On Thu, Sep 11, 2008 at 10:09 PM, Aaron Rouse wrote: Yeah, the function is an Access function, just has the same name as CF. I thought maybe the Yes/No column was

Re: Does CF8 or CF8.1 have some sort of screen capture function?

2008-09-11 Thread Azadi Saryev
found the link: http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1catid=7threadid=1357313 and reading it remembered that i did find this thing: http://stylizedweb.com/2008/04/26/website-screenshots-services/ hth Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Azadi

Problem

2008-09-11 Thread David Pyle
I hope this is an acceptable question. If not, would you please redirect me to a place i can get help.   I have a new Dell Quad core, with Java, Flash, Shockwave and IE7 running under Windows XP Pro.   I am unable to get streaming data on my etrade charting software or on cnbcplus.com.   I can

Re: Problem

2008-09-11 Thread Phillip M. Vector
I'm sorry, but this is a discussion about ColdFusion. While it's not on topic, I'd basically say to talk to Dell. If they refuse, then talk to a lawyer. But you have as much luck getting help here as you may posting on a google chat. :) Does Dell run a forum? David Pyle wrote: I hope this