Re: Error while using Java ResultSet in Coldfusion
I figured it out, here is the reason.1) All system class paths to the jars
NEED to be replicated in the coldfusion JVM class paths.
2) all jars which to with the above coldfusion class paths are created NEED
to be located in the wwwroot\WEB-INF\lib directory. coldfusion cannot find
them from anywhere else.
feels good after pulling my hair out for a couple of days.
--Naveen
On Mon, Aug 10, 2009 at 4:55 PM, naveen balla balla.nav...@gmail.comwrote:
I am recently encountering an issue with using Java ResultSets in
Coldfusion. I have a Java class with a method GetAllDepartments() which
connects to an oracle database, runs a query and returns a ResultSet. when i
call this function in CF it throws an error
'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.'
i am providing the code sample below.
java method(i hid the DB operations to keep it short and simple), it
returns a resultset.
public ResultSet GetAllDepartments()
{ //create oracle connection object
OracleConnection con = new OracleConnection();
Connection conobj = con.getOracleConnection();
//call Department DAO to get a ResultSet
DEPARTMENTSDao departmentobj = new DEPARTMENTSDao();
ResultSet rDepartments = null;
try {
rDepartments = departmentobj.loadAll(conobj);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rDepartments;
}
coldfusion code which throws the error. the error occurs while calling the
method GetAllDepartments();
cfscript
obj = CreateObject(java,DepartmentsObject);
rDepartments = obj.GetAllDepartments();
qDepartments =
CreateObject(java,coldfusion.sql.QueryTable).init(rDepartments);
/cfscript
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325327
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
valueList not giving me what i want.. quick look
i know i know this. but it escapes me... just a cfoutput inside my loop gives me exactly the list i want.. but i need the , commas.. cfoutput query=getAce group=title aid: cfoutput#getAce.aid#/cfoutput /cfoutput Mounting Panel aid: 1811922492502512522532542552562572603203213223233243253263273283293303313323332435 Wallmount Brackets aid: 36 this loops through to many times but has commas.. and is wrong.. cfoutput query=getAce group=title aid: cfoutput#valueList(getAce.aid)#/cfoutput /cfoutput Mounting Panel aid: 181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,---you get the idea--- Wallmount Brackets aid: 181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325328 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: valueList not giving me what i want.. quick look
Valuelist returns all the results of the query, so you don't need cfoutput query=: aid: cfoutput#valueList(getAce.aid)#/cfoutput Francois Levesque http://blog.critical-web.com/ On Tue, Aug 11, 2009 at 11:17 AM, Paul Ihrig pih...@gmail.com wrote: i know i know this. but it escapes me... just a cfoutput inside my loop gives me exactly the list i want.. but i need the , commas.. cfoutput query=getAce group=title aid: cfoutput#getAce.aid#/cfoutput /cfoutput Mounting Panel aid: 1811922492502512522532542552562572603203213223233243253263273283293303313323332435 Wallmount Brackets aid: 36 this loops through to many times but has commas.. and is wrong.. cfoutput query=getAce group=title aid: cfoutput#valueList(getAce.aid)#/cfoutput /cfoutput Mounting Panel aid: 181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,---you get the idea--- Wallmount Brackets aid: 181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: valueList not giving me what i want.. quick look
Howabout just: aid: cfoutput#valueList(getAce.aid)#/cfoutput On Tue, Aug 11, 2009 at 11:17 AM, Paul Ihrig pih...@gmail.com wrote: i know i know this. but it escapes me... just a cfoutput inside my loop gives me exactly the list i want.. but i need the , commas.. cfoutput query=getAce group=title aid: cfoutput#getAce.aid#/cfoutput /cfoutput Mounting Panel aid: 1811922492502512522532542552562572603203213223233243253263273283293303313323332435 Wallmount Brackets aid: 36 this loops through to many times but has commas.. and is wrong.. cfoutput query=getAce group=title aid: cfoutput#valueList(getAce.aid)#/cfoutput /cfoutput Mounting Panel aid: 181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,---you get the idea--- Wallmount Brackets aid: 181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFDOCUMENT - output tabular data with table header at the top of each page
Fiddling with CFDOCUMENT continues. And I thought getting CSS to work cross browser was hard enough J What rendering engine does cfdocument use anyways? CFDocument uses iText. 1. Is it possible to output tabular data across multiple pages with clean page breaks and table headers on each page? This is how I accomplished it: cfdocumentsection !--- section header --- cfdocumentitem type=header cfinclude template=includes/workorder_header.cfm /cfdocumentitem !--- section footer --- cfdocumentitem type=footer evalatprint=true cfinclude template=includes/workorder_footer.cfm /cfdocumentitem !--- tabular data --- cfinclude template=includes/workorder.cfm /cfdocumentsection 2. I'm using my own custom headers and footers instead of cfdocumentitem. Is it possible to obtain page numbers outside of cfdocumentitem? Why would you not use cfdocumentitem? I use custom headers/footers in the example above and it works quite nicely...once I figured out the arcane way that it operates. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
decrypt values ms-access
Hi , How can i get the decrypted value inside my ms-access query, b'coz that query result i need to compare with another query which has decrypted values. Rama ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: valueList not giving me what i want.. quick look
i need the group on the out side because i am grouping by a name that gets trimed from many similar names and such. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: valueList not giving me what i want.. quick look
The valuelist returns all the values in that column, regardless of any cfoutput group used. You might want to use a query of query to get the values for that name, and then use valuelist on that new query. Francois Levesque http://blog.critical-web.com/ On Tue, Aug 11, 2009 at 11:46 AM, Paul Ihrig pih...@gmail.com wrote: i need the group on the out side because i am grouping by a name that gets trimed from many similar names and such. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325334 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: valueList not giving me what i want.. quick look
Then something like...? cfoutput query=getAce group=title cfset thisaid = cfoutput cfset thisaid = ListAppend(thisaid, getAce.aid) /cfoutput aid: #thisaid# /cfoutput On Tue, Aug 11, 2009 at 11:49 AM, Francois Levesque cfab...@gmail.comwrote: The valuelist returns all the values in that column, regardless of any cfoutput group used. You might want to use a query of query to get the values for that name, and then use valuelist on that new query. Francois Levesque http://blog.critical-web.com/ On Tue, Aug 11, 2009 at 11:46 AM, Paul Ihrig pih...@gmail.com wrote: i need the group on the out side because i am grouping by a name that gets trimed from many similar names and such. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: valueList not giving me what i want.. quick look
I think Francios meant something like this: cfoutput query=getAce group=title cfquery dbtype=query name=qAids select aid from getAce where title = cfqueryparam value=#getAce.title# cfsqltype=cf_sql_varchar /cfquery aid: #valueList(qAids.aid)# /cfoutput That should give you your comma delimited list of only the aid values that match the current title in the grouping. Dave Phillips -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Tuesday, August 11, 2009 10:54 AM To: cf-talk Subject: Re: valueList not giving me what i want.. quick look Then something like...? cfoutput query=getAce group=title cfset thisaid = cfoutput cfset thisaid = ListAppend(thisaid, getAce.aid) /cfoutput aid: #thisaid# /cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: valueList not giving me what i want.. quick look
you guys are so freaking awesome. haven't tried it, but i can tell it will work back to queryland.. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: valueList not giving me what i want.. quick look
I think that'll do the same thing but I'll guess that mine's faster. :-) On Tue, Aug 11, 2009 at 12:03 PM, Dave Phillips experiencedcfdevelo...@gmail.com wrote: I think Francios meant something like this: cfoutput query=getAce group=title cfquery dbtype=query name=qAids select aid from getAce where title = cfqueryparam value=#getAce.title# cfsqltype=cf_sql_varchar /cfquery aid: #valueList(qAids.aid)# /cfoutput That should give you your comma delimited list of only the aid values that match the current title in the grouping. Dave Phillips -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Tuesday, August 11, 2009 10:54 AM To: cf-talk Subject: Re: valueList not giving me what i want.. quick look Then something like...? cfoutput query=getAce group=title cfset thisaid = cfoutput cfset thisaid = ListAppend(thisaid, getAce.aid) /cfoutput aid: #thisaid# /cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Disaster Recovery Windows ColdFusion8 mulit-home (and Perl)
We are pulling together a disaster recovery plan and plan on running a test of if to insure the would could rebuild one of our Windows 2003 web servers. Anybody provide some pointers, hints or gothca's I maybe overlooking? Is there anything unusual about backing up a ColdFusion multi-home configure server? Are the various xml config files sufficient to restore to a new box? TIA Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
file comparison tools for outputting differences to client?
Anyone using file comparison tools for outputting differences to the client? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325340 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: file comparison tools for outputting differences to client?
What kind of files do you want to compare and are you talking about doing this (displaying the results) on the web? -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Disaster Recovery Windows ColdFusion8 mulit-home (and Perl)
Do you use Verity or ODBC services? If not, you can just restore the folder and the jrunsvc -install command to install each instance as a service. I blogged about this here, http://www.geodesicgrafx.com/blog/index.cfm/2009/7/22/You-learn-something-new-every-day. If you restore IIS (assuming you use IIS) from an XML export, all of the settings for the wsconfig come along for the ride as well. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog Ian Skinner wrote: We are pulling together a disaster recovery plan and plan on running a test of if to insure the would could rebuild one of our Windows 2003 web servers. Anybody provide some pointers, hints or gothca's I maybe overlooking? Is there anything unusual about backing up a ColdFusion multi-home configure server? Are the various xml config files sufficient to restore to a new box? TIA Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: file comparison tools for outputting differences to client?
Basically, the idea is to have a history of file modifications, the user selects two, and then is presented with the comparison on the web. I am not familiar with MS Word, but the user's request mentions it as an example. Thanks for the interest/response. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: file comparison tools for outputting differences to client?
The files being compared could be a html page, pdf, or word documents. I am leaning toward html, thinking it might be easier to implement. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: file comparison tools for outputting differences to client?
Offhand, I don't know of any tools for doing this out of the box. The biggest issue you are going to face is of course having the Diff data to begin with. Is this something you are hoping to implement into some sort of Content Management System? If so, that of course means you'll need to keep a copy of every version of every file for every change they make and have a way to reconcile those differences. If you just need to display version X next to the current version, simply having the previous versions in an archive folder and a table with references to each version would be simple enough. Then you can just display each version of the page in an iFrame. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325345 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: file comparison tools for outputting differences to client?
How about SVN through http://www.assembla.com ? Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Aug 11, 2009, at 1:18 PM, Alan Rother wrote: Offhand, I don't know of any tools for doing this out of the box. The biggest issue you are going to face is of course having the Diff data to begin with. Is this something you are hoping to implement into some sort of Content Management System? If so, that of course means you'll need to keep a copy of every version of every file for every change they make and have a way to reconcile those differences. If you just need to display version X next to the current version, simply having the previous versions in an archive folder and a table with references to each version would be simple enough. Then you can just display each version of the page in an iFrame. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325346 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 comparison tools for outputting differences to client?
If you have to compare PDF and Word documents, then your options will be very limited since not many tools support those file formats. Most compare tools are targeted at HTML and source code. There are tools that are powerful enough to handle MS documents and PDFs, but I don't know of any that would be easy to integrate into a Web site, especially when it comes to displaying the results in a nice format. You might want to check out Microsoft SharePoint, which has a document history feature that supports MS file formats, although that is a complete product/Web application by itself, not a supplement to a Web site. -Mike Chabot On Tue, Aug 11, 2009 at 1:57 PM, Mike Henke henke.m...@gmail.com wrote: The files being compared could be a html page, pdf, or word documents. I am leaning toward html, thinking it might be easier to implement. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IE 8 messing up my tables in a CFWINDOW
Does the problem go away when you switch to MSIE 7 compatibility mode within MSIE 8? -Mike Chabot On Tue, Aug 11, 2009 at 2:41 PM, Scott Spurlockspurlock.sc...@yahoo.com wrote: I'm using ColdFusion.Window.create() in a link to open another window. In the pop-up window (yes, I know it's technically a div and not a pop-up window), I have a table. The contents of this pop-up window display just fine in IE 7 and Firefox 3, but not IE 8. In IE 8, everything before and after the table appears in the browser. Everything between the table tags, though, is ignored. Why? It's a very simple table. And even when I pare the code down to just tabletrtdHello World!/td/tr/table, I still can't get the text to appear. Why is IE 8 messing this up? Thanks, Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IE 8 messing up my tables in a CFWINDOW
I'm using ColdFusion.Window.create() in a link to open another window. In the pop-up window (yes, I know it's technically a div and not a pop-up window), I have a table. The contents of this pop-up window display just fine in IE 7 and Firefox 3, but not IE 8. In IE 8, everything before and after the table appears in the browser. Everything between the table tags, though, is ignored. Why? It's a very simple table. And even when I pare the code down to just tabletrtdHello World!/td/tr/table, I still can't get the text to appear. Why is IE 8 messing this up? Thanks, Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325347 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 comparison tools for outputting differences to client?
Thanks for all the good feedback. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
coldfusion.sql.QueryTable error in CF8
We have been using the code below in cf7 to convert java query recordset to a cf query. It is still working in cf7 but fails with: An exception occurred when instantiating a Java object. The class must not be an interface or an abstract class. the code used is cfset queryTable = CreateObject(java, coldfusion.sql.QueryTable).init( rs ) in this case rs is the java recordset. Any thoughts on what could be wrong? Thanks, Frederick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IE 8 messing up my tables in a CFWINDOW
I must confess -- I didn't even know about that mode. Yes, the problem goes away when I turn on Compatibility View. When Compatibility View is checked, I can see the text/data in the table just fine. When I uncheck Compatibility View, I'm back to a blank screen. --- On Tue, 8/11/09, Mike Chabot mcha...@gmail.com wrote: Does the problem go away when you switch to MSIE 7 compatibility mode within MSIE 8? -Mike Chabot On Tue, Aug 11, 2009 at 2:41 PM, Scott Spurlockspurlock.sc...@yahoo.com wrote: I'm using ColdFusion.Window.create() in a link to open another window. In the pop-up window (yes, I know it's technically a div and not a pop-up window), I have a table. The contents of this pop-up window display just fine in IE 7 and Firefox 3, but not IE 8. In IE 8, everything before and after the table appears in the browser. Everything between the table tags, though, is ignored. Why? It's a very simple table. And even when I pare the code down to just tabletrtdHello World!/td/tr/table, I still can't get the text to appear. Why is IE 8 messing this up? Thanks, Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Disaster Recovery Windows ColdFusion8 mulit-home (and Perl)
Matthew Williams wrote: Do you use Verity or ODBC services? If not, you can just restore the folder and the jrunsvc -install command to install each instance as a service. I blogged about this here, http://www.geodesicgrafx.com/blog/index.cfm/2009/7/22/You-learn-something-new-every-day. If you restore IIS (assuming you use IIS) from an XML export, all of the settings for the wsconfig come along for the ride as well. Would it be too much to ask what your 4 steps look like? Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IE 8 messing up my tables in a CFWINDOW
Try to remove any extraneous tags on the page in the pop-up window, leaving only markup relevant to the layout of the page, ie, table, etc. Remove all html bodyheaddoctype tags. Hope this helps ~Steve From: Scott Spurlock [spurlock.sc...@yahoo.com] Sent: Tuesday, August 11, 2009 3:42 PM To: cf-talk Subject: Re: IE 8 messing up my tables in a CFWINDOW I must confess -- I didn't even know about that mode. Yes, the problem goes away when I turn on Compatibility View. When Compatibility View is checked, I can see the text/data in the table just fine. When I uncheck Compatibility View, I'm back to a blank screen. --- On Tue, 8/11/09, Mike Chabot mcha...@gmail.com wrote: Does the problem go away when you switch to MSIE 7 compatibility mode within MSIE 8? -Mike Chabot On Tue, Aug 11, 2009 at 2:41 PM, Scott Spurlockspurlock.sc...@yahoo.com wrote: I'm using ColdFusion.Window.create() in a link to open another window. In the pop-up window (yes, I know it's technically a div and not a pop-up window), I have a table. The contents of this pop-up window display just fine in IE 7 and Firefox 3, but not IE 8. In IE 8, everything before and after the table appears in the browser. Everything between the table tags, though, is ignored. Why? It's a very simple table. And even when I pare the code down to just tabletrtdHello World!/td/tr/table, I still can't get the text to appear. Why is IE 8 messing this up? Thanks, Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IE 8 messing up my tables in a CFWINDOW
Geez, that was it?!? Brilliant! Problem solved! It's now working in all browsers. Thank you! Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Disaster Recovery Windows ColdFusion8 mulit-home (and Perl)
Easy enough. Step 1 Our windows team restores the data drive (contains ColdFusion install in multi-server configuration, ColdFusion templates, etc. All but the OS, really). This assumes that IIS and such is pre-installed with your standard windows image. Not my department, the box is already there waiting for me on about day 2 of our DR testing. Step 2 Restore previous save of IIS meta data XML (right click within IIS... should be a save option somewhere. Don't have IIS up in front of me at the moment. You'd do this and save it to your data drive before it's backed up, or whatever. Then right click, new site from file to create the site when the DR server is available). Step 3 Run jrun4directory\bin\jrunsvc -install name of the instance in JRun service display nifty description repeat nifty description. This sets it to autostart. You would do this for every instance on the box (including admin). I cannot recall if this starts it on installation I'm thinking not. If you need to specify different JVM configs, you'd do this here. Can't recall off the top of my head the option to do so. Step 4 Since our DNS/IP changes at the hot site, modify the IIS site to point to the correct IP. Since this is an SSL based site, we need to generate a temporary cert for the new DNS name. And, that was it. Usually, I need to go through and install CF from scratch, copy the EAR file in, make sure all the settings are correct, create the IIS site from scratch, etc. This was so much easier this year, I think I can actually get it into an any idiot can do this documented experience... which is actually what the client wants anyway. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog Ian Skinner wrote: Matthew Williams wrote: Do you use Verity or ODBC services? If not, you can just restore the folder and the jrunsvc -install command to install each instance as a service. I blogged about this here, http://www.geodesicgrafx.com/blog/index.cfm/2009/7/22/You-learn-something-new-every-day. If you restore IIS (assuming you use IIS) from an XML export, all of the settings for the wsconfig come along for the ride as well. Would it be too much to ask what your 4 steps look like? Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325356 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.sql.QueryTable error in CF8
This might help you http://forums.adobe.com/message/2136048%3Bjsessionid=AD61965725B7DF6354AF1B7A0CE73145.node0 Thanks Ritha We have been using the code below in cf7 to convert java query recordset to a cf query. It is still working in cf7 but fails with: An exception occurred when instantiating a Java object. The class must not be an interface or an abstract class. the code used is cfset queryTable = CreateObject(java, coldfusion.sql.QueryTable). init( rs ) in this case rs is the java recordset. Any thoughts on what could be wrong? Thanks, Frederick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325357 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
jQuery question
I have a CFC hat accepts a struct as its argument. The struct can
contain 0 or more items, but the struct itself is required.
I want to use jQuery to call this method. But I can't figure out how.
what I'm trying to do is this:
I'm trying to do this as a jquery post...
var command = {name:''};
var url='/cfcs/pools.cfc?method=getPoolListreturnFormat=json';
$.post(url, [command:command], rh_getPoolList, json);
it is successfully calling the CFC - I have a cfmail in it that emails
me a dump of the arguments.
And arguments.command is a string that looks like this: [object object]
Instead of a struct.
Any suggestions?
--
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325358
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: jQuery question
Hey Rick,
Like any other form post, you can't pass complex arguments to the server.
What you could do is pass a JSON string and then deserialize it in the CFC.
-- Josh
-Original Message-
From: Rick Root [mailto:rick.r...@webworksllc.com]
Sent: Tuesday, August 11, 2009 5:09 PM
To: cf-talk
Subject: jQuery question
I have a CFC hat accepts a struct as its argument. The struct can
contain 0 or more items, but the struct itself is required.
I want to use jQuery to call this method. But I can't figure out how.
what I'm trying to do is this:
I'm trying to do this as a jquery post...
var command = {name:''};
var url='/cfcs/pools.cfc?method=getPoolListreturnFormat=json';
$.post(url, [command:command], rh_getPoolList, json);
it is successfully calling the CFC - I have a cfmail in it that emails
me a dump of the arguments.
And arguments.command is a string that looks like this: [object object]
Instead of a struct.
Any suggestions?
--
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325359
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery question
On Tue, Aug 11, 2009 at 8:25 PM, Josh Nathansonp...@oakcitygraphics.com wrote:
Like any other form post, you can't pass complex arguments to the server.
What you could do is pass a JSON string and then deserialize it in the CFC.
Man, I figured since jQuery requires you to code less, it would do
that for me automatically, knowing that it can't pass a complex object
directly.
Okay... so a json string in this case would be something like:
var command = '{name:}';
and then set my argument type to any and deserialize if it's json.
seems to work.
Thanks!
--
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325360
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) sql server 2005 express sp3 installation onto vista os
I'd like to hear people's experience on this, my users/customers reported tons of problem with it while generally positive on XP. I don't have vista box myself, can't test it on my own. thks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325361 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.sql.QueryTable error in CF8
I've had the exact same issue. you need to put all your jars in the WEB-INF/lib directory and set classpaths to them it in the coldfusion administrator, even if they already have classpaths on the system. coldfusion jvm does not share machine classpaths. even the jdbc drivers you are using need to be in the WEB-INF/lib directory. On Tue, Aug 11, 2009 at 7:39 PM, ritha pull saritha...@yahoo.com wrote: This might help you http://forums.adobe.com/message/2136048%3Bjsessionid=AD61965725B7DF6354AF1B7A0CE73145.node0 Thanks Ritha We have been using the code below in cf7 to convert java query recordset to a cf query. It is still working in cf7 but fails with: An exception occurred when instantiating a Java object. The class must not be an interface or an abstract class. the code used is cfset queryTable = CreateObject(java, coldfusion.sql.QueryTable). init( rs ) in this case rs is the java recordset. Any thoughts on what could be wrong? Thanks, Frederick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325362 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) sql server 2005 express sp3 installation onto vista os
Mysql, sql lite, h2, derby = no install All of which have rich SQL dialects and are very capable. Problem solved! G! On Tue, Aug 11, 2009 at 9:47 PM, Don L do...@yahoo.com wrote: I'd like to hear people's experience on this, my users/customers reported tons of problem with it while generally positive on XP. I don't have vista box myself, can't test it on my own. thks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325363 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) sql server 2005 express sp3 installation onto vista os
sql lite is eliminated for it's not a dbms but a c library for a dbm. of the remaining 3, which one is most compatiable with ms sql server 2005 syntax and feature-wise? do they all support quiet installation? do h2 and derby support dll as well? how about creating datasource connection to railo cfml engine? fk ms! it made me so mad (their own os, their own dbms, all fucked up!) Mysql, sql lite, h2, derby = no install All of which have rich SQL dialects and are very capable. Problem solved! G! On Tue, Aug 11, 2009 at 9:47 PM, D I'd like to hear people's experience on this, my users/customers reported tons of problem with it while generally positive on XP. I don't have vista box myself, can't test it on my own. thks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325364 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
.NET or JAVA? Which is a more natural step for a CF Developer
With the economy and market as it is, and with current employment's stability starting to wiggle, I'm being forced to investigate other options. I was curious what the group's thoughts were on the two above technologies and which would be easier/more natural to move into. Not intending to abandon CF at all, but this is a time where flexibility will be key and I'd like to be able to spread a wider net should job seeking become a factor again. Through a couple early searches, there are a few opportunities that list CF as a *PLUS*, while the core competency is either .NET or JAVA. I've looked into .NET a bit, but it seems that for someone with no access to anything on a large scale (Sharepoint, etc.), there's only so far you can go learning .NET in your basement. There's also the factor of .NET not being ONE language, but a combo of several techs rolled into one. I'm curious if .NET, while a web development language, might just look easier to the inexperienced eye? JAVA is a different beast altogether, but seeing as I've been making use of some JAVA in CF7 and CF8 a little here and there, it seems like it would be somewhat familiar at least in the critical getting started phase. Thoughts? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325365 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
