Re: Which NoSQL?
The biggest reason for breaking the existing convention is that it makes the thing a nightmare to maintain right now and has a lot of overhead. It's not an unacceptable level of overhead, but I feel changing its structure will improve it significantly. Though the point Maureen makes is a good one. I don't have access to SQL 12 yet (budgets in educational institutions being what they are), but I probably will after the first of the year so maybe I'll just put this project off till then and look at that feature to see if it meets my needs. Hi Kris, One thing to consider is the flexibility that SQL 12 has regarding XML data structures. You can store all kinds of things in it dynamically and retrieve that data, search on it, etc. Of course, it warps the minds of those of us brought up in the EF Codd approach to relational database theory, more than a little bit. But it does work well. That said, is there a reason a newer design wouldn't be able to follow the prior developer's precedent? --Ben ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Which NoSQL?
I realize I'm a little behind the curve on this. In my defense this is the first time since becoming a full time developer that I've dealt with data that didn't come from spreadsheets, so I've not really had a reason to look very far into NoSQL other than just far enough to understand what it was. I've played with Mongo a little on my personal web server (which runs PHP but not CF so that I can keep those skills fresh while I spend my days working with CF), but I've not had any serious projects involving unstructured data. The project I have now involves replacing an existing web app. Currently the application follows its initial design, circa 2003, well before it's original designer (my predecessor) had heard of NoSQL. The app works with data by creating new tables for each data structure it needs. After being in use for 10 years we have somewhere around 1000 tables. Clearly this is an app that begs for a NoSQL solution. Which brings me to my question. What's the best NoSQL database for use with ColdFusion? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357017 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Getting a datasource list
I have a small app I've been using for a number of years on my local machine's developer CF install to interface with my databases without having to remote to the SQL server. You wouldn't believe how much time it's saved me. Last week I upgraded this installation to CF10 to match what's on my production server (yeah, yeah, I should have upgraded both at the same time, I know). Anyway, the upgrade broke my app. Specifically, it can't pull a list of my data sources anymore. It seems the coldfusion.server.ServiceFactory java class I've always used to pull the list of datasources is no longer present in CF10. Google has failed me in finding an equivalent that does. Do any of you know how I can get this working again? For now I'm hardcoding the datasources I need into a select, but I really want to get back the functionality I had before. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfqueryparam problem
I have this query in a remote accessible cfc: cfquery datasource=staff name=rq SELECT * FROM intervention WHERE studentId = cfqueryparam value=#arguments.id# cfsqltype=cf_sql_integer AND year=cfqueryparam value=#arguments.year# cfsqltype=cf_sql_integer /cfquery At issue is the second cfqueryparam. The arguments are passed in by a get request. When I pass in 2012 I get this error: [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. Trying to pass it in as an integer gets the same error. The odd thing is that any other value passed in works right, but 2012 throws an error every time. Any suggestions? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348002 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfqueryparam problem
That got it. Thanks, I was going nuts trying to figure it out. Try this. http://www.coldfusionjedi.com/index. cfm?mode=entryentry=7D417738-DF64-B270-3056B422E2F6FCAB Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348004 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFSpreadsheet and formulas
I have a workbook that I read with CFSpreadsheet, update some of the data, and then write out to a new file. The problem that I'm running into is that there are several formulas on the spreadsheet that don't recalculate when the new file is saved. Even when the file is opened the formulas won't recalculate until you retype one of them. Has anyone else run into a problem like this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334470 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Wierd error from bots
I just switched over from an old Application.cfm to a new Application.cfc a couple weeks ago. Ever since I did I keep getting an error that says An exception occured while invoking an event handler method from Application.cfc. The method name is: onRequestStart. I only get this error when bots hit this site (so far) but I can't for the life of me figure out what's causing it. It's always on line 35, which is: cfif isSimpleValue(evaluate(formelement)) AND refindNoCase(sqlregex,#Evaluate(formelement)#) formelement is the index of a loop through URL elements and sqlregex is a regex expression that matches SQL strings. Also it's only bots that get the error. Real users never run into a problem. This section of the code is part of an extra layer of protection against SQL injections. It's copies almost verbatum from my old Application.cfm, so I can't figure out for the life of me why all the sudden I'm getting these errors. Can anyone help out? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: HTML 5, has anyone done anything more than played with it
I've seen a couple of Javascript libraries that create support for the semantic tags (header, footer etc), but support for canvas, video and audio won't be mainstream unitl IE9 comes out (I'm not a M$ fanboy, but it is the most widely used browser). It won't even be mainstream then. There's still an awful lot of people out there running XP who won't be able to upgrade to IE9. Plus remember that at least 15% of web traffic (a hair over by my stats actually) is still on IE6. It's going to be years before IE9 peaks over the 50% mark, and that assumes that Firefox/Chrome/Opera haven't gotten to half market share by that point, which they may at the rate they're growing. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334206 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflayout accordion collapsed initially
Hi I am using cflayout accordion with only one item which I want collapsed on page load. I've eventually put this code in: body onload=ColdFusion.Layout.collapseAccordion('accordionLayout', 'panel01') This works in FF and Chrome but NOT in IE8, which 1) does NOT open collapsed and 2) gives a javascript error Message: Exception thrown and not caught Line: 90 Char: 1 Code: 0 URI: http://127.0.0.1:8500/CFIDE/scripts/ajax/package/cfajax.js So my questions are 1. Is using the onLoad function the best way to have the accordion closed on page load 2. How do I get it to work in IE? And with no errors? Hope someone can help - this is driving me nuts Ta Seamus I ran into this exact problem yesterday. I found that the only way to make it work right was to use the CF ajaxonload function like so: cfset ajaxonload=ColdFusion.Layout.collapseAccordion('accordionLayout','panel01') For some reason IE runs any onloads you define through javascript before it gets the accordion loaded, as I found out when I added an alert to my function to collapse an accordion. Annoying, yes? Anyway the ajaxonload function works the way you'd expect it to. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflayout accordion collapsed initially
cfset ajaxonload=ColdFusion.Layout. collapseAccordion('accordionLayout','panel01') Geh, must be early. Make that: cfset ajaxonload(ColdFusion.Layout.collapseAccordion('accordionLayout','panel01') ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334035 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 Windows vs Linux
As others have said the big difference is that Linux is case sensative. I have a friend who switched her web server over to Debian from Windows several years back. Her husband is a massive Linux geek and handled setting it up for her so she had no learning curve with the switch but she did a lot of grumbling about having to rewrite a bunch of code because of the case sensativity. As for Linux itself it's a whole lot easier to make that switch these days than it used to be. There's still a learning curve but there are a whole lot more user friendly GUIs than what there were even just a couple years ago. In some distros you can get away with never looking at the shell if you really wanted to, but that's not recommended. The shell makes your life easier once you learn it even with all those spiffy GUIs. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFMenu Woes
I just launched a new website that uses a cfmenu. The layout is designed for at least a 1024x768 resolution. What we're running into is that the cfmenu javascript doesn't always function correctly in IE7 at resolutions of 800x600 or below. When the user sets their resolution to 1024x768 and refreshes the page, the menus suddenly start working. Has anyone else seen issues like this with cfmenu? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333779 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Web Programming Cert
I'm thinking that this might be a good deal http://www.oreillyschool.com/certificates/web-programming.php It mostly looks good, but there's a Perl class in there. Don't get me wrong, I know Perl, I like Perl, and I write a whole lot of scripts for my own personal use in Perl. I even cut my web development teeth on a chat room written in Perl, but who uses it for web programming anymore? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:57 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
What's wrong with this QoQ?
This is driving me batty. Every time I try to run this code I get a QoQ syntax error and I'm not seeing where the error is. cfloop from=1 to=3 index=i cfquery name=section dbtype=query SELECT * FROM questions WHERE section = #i# /cfquery /cfloop In case it's not immediately obvious, section is an int with possible values ranging 1-3. I've double checked that it actually is in the questions query. Other variations I've tried are: WHERE section = '#i#' WHERE section = 1 WHERE section = '1' WHERE section = 'WHY WON'T YOU WORK!!!' (ok, so I didn't try that one). It seems no matter what I put in the where statement it throws a QoQ error. If I leave the where statement off completely it works fine, but that's pretty useless in this situation. What am I doing wrong? ~| 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:333262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's wrong with this QoQ?
It appears section is a reserved word. Your WHERE clause should work if you use: WHERE [section] = #i# On Thu, Apr 29, 2010 at 2:25 PM, Kris Sisk ks...@gckschools.com wrote: Thanks. I didn't think to check for reserved words. That was the problem. ~| 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:333267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion.ajax.submitform
You're passing an undefined variable rather than the form's id with your link. Try this: a href=javascript:submitForm('myform'); ~| 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:332694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Builder Released!
You guys are a bunch of whiners. I don't know if I'll buy ColdFusion Builder yet, but if I do...$300 is cheap, for any software. What do you guys want?! Free? How much work do you do for free? Don't buy it...fine, but don't whine about $300. $300 cheap for any software? What kind of Kool Aid have you been drinking? Don't get me wrong. ColdFusion Builder is a great IDE and I'll probably shell out the $300 for it (or get my company to buy it). The issue is that we're already shelling out at least $1200 to Adobe for a product that has free products as its chief competition. It would have been wise, given that price tag versus the price tag of PHP (or even Railo) to give us a free, or at least inexpensive, IDE. As is, I'm feeling shafted. I almost certainly won't use Flash Builder so I fell like I'm being forced to buy a $250 IDE that I won't use to get a $50 IDE that I will. That said, I'm on my way to my boss' office to ask if we've got the money in the budget for it now. Most likely it won't happen due to the budget cuts we're facing, and working for public schools certainly doesn't give me the kind of financial flexibility I'd need to buy a $300 IDE any time soon. ~| 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:331996 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFScript query service problem
I'm trying to use the query service and I'm running into the issue that no matter what I put into the object it throws an error when I try to execute it. The specific error I'm seeing is Attribute validation error for tag CFQUERY. It does not allow the attribute 1. The code I'm feeding into it right now is: q=new query(); q.setDatasource(Datasource); q.setSQL(SELECT * FROM links); result=q.execute(); Anyone have any idea why this would be happening? My code pretty well matches every example I can find of how to use this service so I'm pretty stumped. ~| 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:331500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Set session variable via AJAX
I have a dropdown with an onchange that calls a CFC via cfajaxproxy and I'm trying to set a session variable in that CFC. For some reason this session variable isn't taking. Here's the code I'm working with (excess code removed): cfajaxproxy cfc=components.Translate jsclassname=translate/ script type=text/javascript function buildTrans(lang,n) { var trans=new translate(); excess code removed newString=trans.Translate(language, lang, data); } /script And the function: cffunction name=Translate access=remote returnFormat=JSON cfargument name=SrcLang type=string required=true/ cfargument name=DestLang type=string required=true/ cfargument name=transString type=string required=true/ cfset session.language=arguments.DestLang/ Excess code removed cfreturn returnString /cffunction This whole thing is intended to facilitate machine translation of our site. The session variable in question is supposed to specify what language the user wants so that they don't have to call the translation manually on each page. The problem is that session.language isn't defined when I call another page. Is there another way to do this? ~| 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:331023 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 and Linux
Does anyone know the solution of this? Also, what would be the recommended chmod to use? seems like 777 is the only one that will allow me to write to the folder I'm not sure about your accents and whatnot. Being embarrassingly unilingual I don't use them very much. But your chmod should be 666 for read/write access. 777 is read/write/execute permission for everyone, so unless you're outputting scripts that you want to be able to run, 666 is the better chmod. ~| 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:328844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Flash forms problem
I just upgrade to CF 8 and the upgrade did not go well. I ended up having to configure the connectors in IIS6 manually. I've gotten everything working again except for flash forms. They start to load fine, but some things don't. Notably, any text or html cfformitems don't load at all and any cfselects are blank. Can anyone help me out? Google seems to be failing me. ~| 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:324307 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Reading xls with Java HSSFWorkbook object
I'm trying to read a spreadsheet using the HSSFWorkbook object. First off, I know that it would probably be better to save it to a csv first, but some of the people this is going to be used by would probably loose their minds if they tried to save into anything other than an xls from Excel. Ironically, this extremely computer illiterate bunch are literacy teachers, but I digress. Anyway, here's the problem I have. I'm trying to run the sheet through loops to read the whole thing. The problem is that when I try to call getRow or getCell from within a loop with the loop index as the argument, it throws an error. Specifically, it throws The selected method getRow was not found. Either there are no methods with the specified method name and argument types, or the method getRow is overloaded with arguments types that ColdFusion can't decipher reliably. Since it works fine if I pass a number instead of a variable, I'm assuming the method is overloaded. Frankly, I'm stuck. Here's my code (this is just a test script, the final product will use the spreadsheet to populate a database). code cfscript infile=createObject('java','java.io.FileInputStream').init(D:\inetpub\wwwroot\non-live code\test.xls); fs=createObject('java','org.apache.poi.poifs.filesystem.POIFSFileSystem').init(infile); wb=createObject('java','org.apache.poi.hssf.usermodel.HSSFWorkbook').init(fs); sheet=wb.getSheetAt(0); noRows=sheet.getLastRowNum(); writeOutput('table'); for (i=0;i LTE noRows;i=i+1){ writeOutput('tr'); row=sheet.getRow(i); noCols=row.getLastCellNum(); for (j=0;j LTE noCols;j=j+1) { writeOutput('td'); try { cell=row.getCell(j); value=cell.getStringCellValue(); } catch (Any expt) { value=; } writeOutput(value); writeOutput('/td'); } writeOutput('/tr'); } writeOutput('/table'); /cfscript /code ~| 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:319638 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reading xls with Java HSSFWorkbook object
Ok, now I feel silly. After hours of fighting this, I did this: row=sheet.getRow(JavaCast('int',#i#); instead of this: row=sheet.getRow(JavaCast('int',i); And the same on the cell definition and presto. It's working. ~| 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:319642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4