CFContent and IE open/save
I'm wondering if anyone else has seen this issue. Use the following code to get files from the server for end users GetFile.cfm cfsilent cfset mimeType = getPageContext().getServletContext().getMimeType(folder filename) cfheader name=Content-Disposition value=Attachment; filename=#filename# cfheader name=Expires value=#Now()# cfheader name=Content-Length value=#fileInfo.size# cfcontent type=#mimeType# file=#folder##filename# deletefile=No It works fine however, I do not see the 'Always ask for this type of file' check box, it's missing. The type of file is noted as is the size in the dialog box. These files come from out side the web root, in an unshared folder with permissions to 'read' for 'Everyone', though I don't grant direct access in anyway to everyone. However if I do a direct link to a file in a folder in the web root or virtual dir on the web server, the 'Always ask for this type of file' check box is present. Ever seen this? Know what it means? I need it to be consistent everywhere so the users of the intranet can uncheck the box. Header info I'm missing? Environment: Server 2008 R2-64bit / IIS7.5 CF9 IE 7.0.5 Thanks for your thoughts, Brent ~| 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:343068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFX_HTTP5 - returns partial string
Dave, Thanks for your reply. In this case CFHTTP won't do it since the connection requires NTLM due to internal security requirements. I've opened a dialog with the developer and he is looking into what it could be. On a side note, we might need some Google mini training out here for one of our server guys. Who should I contact at your office Dave? Thanks for your time, Brent ~| 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:342280 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFX_HTTP5 - returns partial string
I'm not sure if CFX_HTTP5 is used too much in the community, but I figure I'll check. Has anyone had any issues with it returning partial strings on a GET? CFMX7 / 32bit machine: Returning values just fine. CF9 / Win2008 / 64bit machine (with 64bit version of cfx_http5): The tag seems to be cutting off the last 3 or four characters of the return value. As a result my XML won't validate. I can't control the XML it's coming from a google-mini box.I'm not sure if it's the tag or something in CF9 effecting things. I have manually verified the google-mini is returning valid XML. Anyone seen this? Or does it smell like anything you've tangled with in the past, though mybe unrelated? Thanks, Brent ~| 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:342153 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFSTOREDPROC and invalid SQL
Thanks to everyone for their replies. If someone is searching for this in the future the solution seems to be as follows: If you have a stored proc that DOES NOT require params in or out of the stored proc, the string to call looks like this Mixed Case: cfset storedProcVar = SCHEMANAME. PackageName . StoredProcName() / Non Mixed Case: cfset storedProcVar = SCHEMANAME.PACKAGE_NAME.STORED_PROC_NAME() / If you have a stored proc that DOES require params in or out of the stored proc, the string to call looks like this cfset storedProcVar = SCHEMANAME. PackageName . StoredProcName / Non Mixed Case: cfset storedProcVar = SCHEMANAME.PACKAGE_NAME.STORED_PROC_NAME / And then used in: cfstoredproc procedure=#storedProcVar# datasource=#request.LOCAL_DATASOURCE# Not sure if needing/not needing the () is just common sense or not, but I got stuck on it for a bit. ~| 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:338831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFSTOREDPROC and invalid SQL
Hi all,
So I'm very stuck and tired of saying mean things to my computer... so I hope
you are able to see something I'm missing.
In short, in order to trouble shoot a larger stored proc call, I've created a
very simple one to get working first. It just returns a value.
Platforms: Oracle11g / CFMX7 (oracle drivers) / IIS6
The Stored Proc:
CREATE OR REPLACE PROCEDURE FUNDING.OMGItsMixedCase (datetext out varchar2
) is --AUTHID CURRENT_USER IS
BEGIN -- executable part starts here
datetext := to_char(sysdate, '-mm-dd');
END;
/
---
The CF Code to call it:
!--- I know setting the storedProc var works since I can call a different
storedProc on another schema with this method, though it requires nothing
passed in. ie: this code approach works elsewhere ---
cfset storedProc = FUNDING. OMGItsMixedCase()
cfstoredproc procedure=#storedProc# dataSource=databasemonster debug=yes
returncode=yes
cfprocparam type=out cfsqltype=CF_SQL_VARCHAR dbvarname=datetext
/
/cfstoredproc
The error: (nemisis)
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00900: invalid SQL statement
The error occurred in D:\somepath\act_updateProgramFund.cfm: line 50
48 :
49 : cfstoredproc procedure=#storedProc# dataSource=databasemonster
debug=yes returncode=yes
50 :cfprocparam type=out cfsqltype=CF_SQL_VARCHAR dbvarname=datetext
/
51 : /cfstoredproc
52 :
SQL { (param 1) = call P3DEVELOPER.date_text()( (param 2) )}
DATASOURCE oracle1srvr
VENDORERRORCODE 900
SQLSTATE 42000
What's with the param 1 in front of the call? then another param 2??
Thanks for your time and effort,
Brent
~|
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:338769
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFSTOREDPROC and invalid SQL
returncode=yes
What's with the param 1 in front of the call? then another
param 2??
A complete guess from a non-Oracle person, but ... could it be for the return
code?
Ok, I've removed returncode and debug and now have the following.
cfstoredproc procedure=#storedProc# dataSource=bigdatabasemonster
cfprocparam type=out cfsqltype=CF_SQL_VARCHAR dbvarname=datetext
/
/cfstoredproc
Returns:
SQL {call P3DEVELOPER.date_text()( (param 1) )}
All the rest is the same error.
~|
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:338771
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFSTOREDPROC and invalid SQL
I had incorrect information in my error in the previous two posts.
It should read:
The error: (nemisis)
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00900: invalid SQL statement
The error occurred in D:\somepath\act_updateProgramFund.cfm: line 50
48 :
49 : cfstoredproc procedure=#storedProc# dataSource=databasemonster
debug=yes returncode=yes
50 : cfprocparam type=out cfsqltype=CF_SQL_VARCHAR dbvarname=datetext
/
51 : /cfstoredproc
52 :
SQL {call FUNDING.date_text()( (param 1) )}
DATASOURCE oracle1srvr
VENDORERRORCODE 900
SQLSTATE 42000
~|
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:338772
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: send content to head and body in single call module
Dave and Dominic, these ideas worked very well. Thanks for your time. ~| 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:335524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
send content to head and body in single call module
Looking for thoughts on how you solved the following: This is just one possible solution I'm trying to explore: I'd like to call cfm template based modules from a page include (or XML config file) on a per page basis. I may or may not include different modules on each page. The challange is this: If I just do a single include call in line on the page (from the BODY area) to a module, how can I tell it to write js into the script tag in the document HEAD, in addition to placing the XHTML that the module creates in the BODY of the resulting page? All the js script needs to be in the HEAD not littered through the code in the body. (Note: I'm using protoype/ajax and DTD XHTML 1.0 Strict) The XML config approach is an idea I thought might work. You'd just list the modules and it would look for the accordingly named cfm and js, then run each individually (js file with cf code in it processed by the cf engine) and drop the content into the resulting page. You end up with two files (don't like) per module, but it's semi clean. This seems to fit with using the application.cfc framework as well. That leads me to wonder if the CF engine can be told to process js files with cfcode in them through the cf engine. Not to evaluate the js script but to dynamicly build js script without embeding it in my cfm template files. For some reason I'm averse to putting cfm templates in the js scripts folder. Clear as mud? Anyone's thoughts on this are more than welcome. Just curious how others have tackled this challenge. -Brent ~| 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:335429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF CMS Opinions
Hi all, I'm looking at the following CMS systems. I don't need them to be super fancy, they just need to scale well and easy to use for end users. I'm curious about peoples thoughts, experiences, and hard lessons learned with them. I'm not looking for in depth responses, but more for tid bits that can raise awareness to issues that might not crop up until later or, most importantly help me assess these solutions with other people's experiences in mind. CMS's being reviewed: Speck CMS - http://www.speckcms.org/ Sava CMS - http://www.gosava.com/go/sava/ ColdBricks CMS - http://www.coldbricks.com/ FarCry CMS/Framework - http://www.farcrycore.org The CMS will be used to run a govt. public web site with moderate traffic. Thanks for your time and thoughts, Brent ~| 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:36 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 upload suddenly stops working
If you have access to the server, try taking the offending code and reducing it to just the bare bones to get it to work while staying in line with what the original code does. Once you get it to work in an 'uncluttered' manner, you can add everything else back in. Yeah, it's a pain in the butt, but it'll clarify the issue. -2cents. BN ~| 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:322234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: unable to log in via DB auth
Joe, We do something similar over here, though I just grab the AUTH_USER var passed from IE's Integrated Auth. Eitherway though, try this for your CFLOGINUSER cflogin cfloginuser name=#USR# Password=#PWD# roles=#ROLES# /cflogin In short, wrap your CFLOGINUSER with CFLOGIN. It drove me nuts for a few hours then I realized I needed to wrap it. -Brent ~| 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:322241 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 CMS Opinions
@ Jake - Yeah, i was reading the FarDry QuickStart guied and really like what they've got going. I'm planing on installing all of these over the next few weeks and testing them out. So far I like Speck (for super simple) and FarCry for a well thought out way to build a frameworks and CMS, development spped looked pretty quick too. The others have upsides as well, but testing will show what's best. -BN ~| 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:322242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF PDF output
Anyone else had experience with the CF PDF creation totally botching the CSS page layout? I've got a really nice html page created by CF. Looks very nice as a web page, when you send it through the CF PDF creator it looks horrible!! The tables end up with really wide spacing and padding you can't adjust. I've done everything from external css, to css at the top of the page, to css in the tags (yuch!!). I even gave it the middle finger, alas... nothing worked. Thoughts? Thanks, BN ~| 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:321943 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CanvasWiki / Coldspring / ModelGlue
Howdy all, So I've got CanvasWiki from Raymond Camden running. Works great. Now I need to impliment our internal security systems. I've found where to put the code and all, but no matter what I do: * cfsetting debugging = Y * cfdump * cffunction output = Y I can't get any debugging to be output. Aside from what's at the bottom of the page. But sometimes, I just want to see what a query came back with and so on. So I've read over the ColdSprings docs and am about to read over the ModelGlue doc's. I kind of get it... Is there something I'm missing for getting detailed debugging on the various cfc's functions? ex: UserRecord.cfc Thanks for your time and effort, Brent Nicholas ~| 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:321946 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFILE and Ajax file uploads
This is the solution in Prototype.
Original concept provided by Ben Nadel and translated to Prototype by Mahesh
---
index.htm
-
script type=text/javascript src=prototype-1.6.0.2.js/script
script type=text/javascript
Event.observe(window, 'load', function(){
Event.observe('file_upload', 'change', function(){
$('form').writeAttribute({enctype:multipart/form-data,
method:post, action:cffile.cfm, target:RSIFrame});
$('form').insert(new Element(iframe, {id: RSIFrame, name:
RSIFrame, style: width: 0px; height: 0px; border: 0px;, src:
blank.html}));
$('form').submit();
});
});
function showResult(result){
$('file_upload').remove();
$('upload_update').insert(new Element(a, {href: http://localhost/upload/; +
result}).update(Uploaded Image));
}
/script
form id=form
input name=file_upload id=file_upload type=file size=60 /
span id=upload_update/span
/form
For the above script to work across browsers, do not set the form enctype in
the prototype writeAttribute, instead add it to the form, as IE will not do the
upload, if the form is set with the encType through JS.
-
---end---
cffile.cfm---
-
cffile action=upload filefield=file_upload
destination=d:/inetpub/wwwroot/ nameconflict=MAKEUNIQUE
script type=text/javascript
cfoutput
window.parent.showResult('#file.serverfile#');
alert('#file.serverfile#');
/cfoutput
/script
-
---end---
~|
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:312765
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFFILE and Ajax file uploads
Hi all, So I did some googling and searched through the threads here as well. I'm not finding what I need to know. What I'm trying to do: Upload a file to the server via ajax and an iFrame using the tool from: (http://www.webtoolkit.info/ajax-file-upload.html) I've got the code in a test file, and can get the form var in the receiving (cfm) page to output the file var (it results in a path to the file I choose) but it won't upload. Any ideas? Anyone using this and getting it to work? I've zipped my files and posted them here (http://www.cflhd.gov/cffileajax.zip) for you to look at. The code from the AIM toolkit is unchanged except the form tag, I played around with that a bit. CHANGES: added enctype - none prior renamed the file input from 'form[file]' to FILE_LOC changed action to cffile.cfm Really I just need to know what the CFILE tag is expecting. I've used it no problem in the past, but I think I'm not quite understanding something here. (Oh, I know there are sofware packages I can buy and flash solutions.. I don't want either. This is govt...) Thanks for your time and effort. Brent ~| 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:312713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfhttp and Google Search Appliance
Are you searching secured or unsecured content? It's very easy if you are only searching unsecured. In some cases you need cfx_http5 if you are searching secured content. You need to get the ip of the Google box and build a search string based on what you wnat to do. You'll want to review the Google search appliance API to understand the url string. Here are the url params you'll end up using, though some may not be needed for you. We return XML and deal with that prior to presentation. cfparam name=G_q default= cfparam name=G_site default=YourCollection cfparam name=G_restrict default= cfparam name=G_client default=default_frontend cfparam name=G_output default=xml_no_dtd cfparam name=G_as_occt default=any cfparam name=G_filter default=0 cfparam name=G_access default=a cfparam name=G_num default=10 cfparam name=G_start default=0 Does anybody know how to use CFHTTP to talk to the Google Search Appliance? I can't find anything on the Web that mentions this. I am not talking about CSE. Thanks, Jo-Anne ~| 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:310929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
XML / XSL / XSLT and CF
Howdy all, So I'm looking at using XML to define forms and form elemements, along with data. Then use XSL to build the form. (I read a bit about XForm, still getting my brain around it.) I'm looking to do this because the application I need to build has 53 screens, with no less than 30 items per screen. Many of the form items are shared form to form. Anyway, so does anyone have experience with doing this? Thoughts? Advice? Thanks, BN ~| 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:310306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML / XSL / XSLT and CF
Dave, Thanks for the reply. Yes, I was reading about CFORM and setting it to XML (I think?) and that would generate your XForm code. I need to do more research, I just really really really do not want to code all those forms. I'd rather seperate the data from the presentation, while the presentation is dictated by a config file so it will be much more scalable. Thanks! BN So I'm looking at using XML to define forms and form My advice to you is to use CF instead of XSLT to render your forms. Unless you work with XSLT all the time, it's a pain. Even if you do, it's a pain. You can choose to represent your form fields in XML or in a relational schema. 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;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML / XSL / XSLT and CF
Justin / Dave, Thanks for your replies. Yes, I'm seeing from the little bit of research that I'm doing that XSLT might not do what I need it to and introduce a certian level of risk to the project. I am interested in learning more about highly abstracted form generation if any one has any links on this to share. If either of you are able to shed a little more light on the TEXT/pipe technique or the database technique I'd be greatly appreciative. Don't go way out of your way though. I'll keep researching. Thanks! BN XSLT is not a config file though. It's a Turing-complete programming language that will let you transform one XML language to another, or to HTML. CF will also let you do that sort of thing, and it'll generally be a lot easier. Indeed. On the web XSLT is great if you want to pass the XML file/data directly to the browser and have the browser render it in a certain way (using XSLT to convert the XML to HTML output). If you're running it through ColdFusion anyway, it's easier to write CF than deal with XSLT. I wouldn't get too hung up on the idea of representing your forms as XML, either. You can represent reusable form elements just as easily with a relational database. I'll second that also. One project I worked on we just defined the form fields in a pipe-delimited text file that would get read and parsed into a ColdFusion application variable. Then we had a custom tag that we could call and it would generate all of the HTML for each form field in whatever form definition we needed. -Justin Scott ~| 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:310312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX8 - Standard vs. Enterprise
Ok, I've read over everyone's replies and it looks like the limitations on the standard version are not going to impact what we expect to do on our public/extranet. Thanks for everyone's responses. BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304599 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Google XML and CF isDefined
howdy all, so I've got a little bug I'm having a tough time with. I'm new to manipulating XML in CF. It's pretty easy however, but I've run into a problem I'm not sure how to solve. The Google box returns an XML structure that I've processed. But from time to time, I find that the 'T' element (Title) is not returned. And it errors out. I tried: cfloop from=1 to=#ArrayLen(XMLContent.GSP.RES.R)# index=idx cfif isDefined(XMLContent.GSP.RES.R[idx].T) But I get error: Element T is undefined in a Java object of type class coldfusion.xml.XmlNodeMap referenced as If I do: cfif isDefined(XMLContent.GSP.RES.R) It works fine but that's not what I need. Thoughts? Should I place the current index node into a var and then test? BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304601 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Google XML and CF isDefined
Scott - No it's not an invalid char, I've cfdumped the XML. Dave, Yeah as weird as it is the T child was not present, it's a PDF too. I cfdumped the XML and it's just not there. The people who make these files are notorious for putting next to no effort in to creating files. We found that we had to do an advertising campaign about 'How to create a document so you can find it later.' Anyway, your idea worked perfect, I suspected something along those lines but thought I'd get some expert thoughts on this... maybe I'd learn something. Well I did... isDefined doesn't work with arrays.. ;) Thanks!! BN First, I'm very surprised that you're seeing R elements that don't have a child T. Can you confirm that these are actually what you're getting back from your GSA or Mini? Second, you can't test for the existence of array elements with IsDefined. But you can store the array element within a variable, then test for the existence of members of that variable: cfloop ... cfset thisR = XMLContent.GSP.RES.R[idx] cfif IsDefined(thisR.T) /cfloop Don't forget, you can also use XPath expressions from within CF. You might find that an easy alternative to accessing elements directly, although to be honest I haven't tried that myself from within CF while using Google search result XML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304611 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFMX8 - Standard vs. Enterprise
Howdy all, At my last place of work we always used the standard version from 4.5 to MX7, ran seven servers with a common code base in various locations around the world, the database (Oracle 9i) was always in the same building as the server and used the java based thin client db connector (classes12.jar). Anway, now I work somewhere else and we currently run CFMX7-Enterprise for a 300 client intranet and resonably low volume public web site. We also run Oracle 10g, so the built in drivers are nice, however I feel it's total over kill to run enterprise. We're putting in an extranet server, again not with huge utilization. It will also connect to an Oracle 10g db. So I'm wondering, can you still use the java based thin client (classesXX.jar) between CF and Oracle10g without problems? Anoyone have any other thoughts as to why I might want the enterprise vs. standard. I've always found them to be the same minus a few 'nice to haves' that we never missed. The Adobe site says there is a performance difference?? Thanks for your time, BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304520 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX8 - Standard vs. Enterprise
AFAIK Yes, these work fine in 10g. Ok, good. That was my main concern. Another possible reasons for Enterprise even on a low volume server: Multi-home. This allows one to create multiple instances of ColdFusion running on a singe box. Ok, good to know. Thanks! BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304525 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF - XSLT
Slightly OT, but is being run in a CF environment. So I posted a thread earlier about NTLM/WinAuth, CFHTTP and the GoogleMini... that's simply a no-go. So I'm wondering, does anyone know if XSLT will allow you to run templates as it processes each node of the XML structure. For example: For each file path found, run a CF template that will return (Y/N), then display if Y. Thanks, BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP and NTLM with GoogleMini
Russ, Let me rephrase that by saying, I'm hesitant to use something I don't completely understand and can't defend in a govt environment. It's just not worth missing the mortagage payment over. ;) As for CFHTTP, not working with NTLM/WinAuth, it's in the CF Docs. I've tried lots of ideas. As for the Firefox issue, that's outside the scope of the problem. We don't support it for intranets. Yes yes I know... you don't even need to say it... I hate IE too. But they were hell bent on having the browser pick up the logged in user and auto-login to the Intranet. Thanks for peoples thoughts on this, I think I'll need to investigate other methods. BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfhttp post authentication, troubleshooting tips
Gilbert, CFHTTP has a number of responses, have you out put them to see if anything of value shows up? cfoutput cfhttp.errorDetail: cfdump var=#cfhttp.errorDetail# br / cfhttp.responseHeader: cfdump var=#cfhttp.responseHeader# br / cfhttp.header: cfdump var=#cfhttp.header# br / cfhttp.Filecontent: cfdump var=#cfhttp.Filecontent# br / /cfoutput BN I'm trying to insert and update data via CFHTTP for a client. The problem is that I do not have access to the 3rd Party to find out what session variables are being passed. It's an .asp site. Authenticated via https I've charted out which parameters are sent via the form (hidden as well as displayed) and which are sent via the url. But things are not working. The form is not being updated and I'm not getting any errors. I was wondering what troubleshooting tips people had. I'm using CFTRY and CFDUMP But it's not catching everything (evidently). Thx ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP and NTLM with GoogleMini
d00d, that is 'all that and a bag of chips!' I'm rock'n like Dokken! now. Problem solved! Thank you very much...!! http://www.cftagstore.com/tags/cfxhttp5.cfm ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFHTTP and NTLM with GoogleMini
Howdy all. So I know CFHTTP does not support NTLM or Windows Integrated, but that's the situation I'm in. I've got a GoogleMini indexing an intranet that uses Windows Integrated Authentication. The GoogleMini does just fine indexing it and I can search just fine through the form I made *after I login through the authentication* that the GoogleMini enforces. However... I need for CF to use CFHTTP to run the GET request and return the XML response... Since CFHTTP does not support this... I'm stuck. Any ideas to work around this? The bottom line is: the google mini will enforce needing to login, I just want the XML response as a variable I can use in CF. Thanks for your thoughts, BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP and NTLM with GoogleMini
Russ, Thanks for the reply, but I doubt the govt. will let me use it. How about something like this: http://www.luigidragone.com/networking/ntlm.html If it works, you should be able to use that to authenticate... Russ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOLVED: CFMX7
yeah, ok after updating the JVM, applying hot fixes and other sheenanegans It turned out to be the network card on the box running at full duplex vs. half duplex as it should have been. 'grimmace'... Thanks for everyone's replies... BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX7
Any other thoughts on this from anyone? Thanks, BN Also, check out this blog: http://www.talkingtree.com/blog/index. cfm?mode=entryentry=40F4C7EA-45A6 -2844-7D0C4841EA190125 ~Brad Brad, The link you provided was first on a google search, also yes I I checked all of the CF admin setting and they are the same. I'm still reading over the TalkingTree.com article, that's where I learned about the new drivers. I'm just loath to patch one box, but not need to patch another. Breaking the prod box would not make my day at all.. ;) (I'm hell bent on keeping the boxes as close to the same as possible.) I've determined I need to put CFMX7-SP2 on the dev server as well as prod, so I'm going to take a shot in the dark on that one. Thanks for your thoughts, BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296000 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX7
Hi, So I come back from the holidays and my CF Dev server is having issues. I'm getting the following error: Error Executing Database Query. [Macromedia][Oracle JDBC Driver]No more data available to read. I've done a bit of google searching and found that there were Updated DataDirect JDBC drivers (version 3.4) released. However this seems to have been released on 7-22-2005. I've never had these issues until now and we've been on Oracle 10g for about 4 months now. http://kb.adobe.com/selfservice/viewContent.do?externalId=1a3c2ad0 As an aside the production server is set up exactly like the dev server and does not have issues. It seems that anything run more than once has this problem, though if I run the code against the test database (same as the dev server does) on the production server all is fine. If you wait a long time it'll work once as well on the dev box. So that leaves us with just the default Oracle drivers on the CF Dev box. I'm hesitant to put the new drivers on the dev machine, since that will make the machines 'Not the same'. And I have issues with fixing what's not broken on a production box. Anyone have any ideas or thoughts on all or any of this? General Info: CF MX 7.0.2.1.142559 Enterprise Windows Server 2003 / 5.2 java: 1.4.2-09 using built in Oracle drivers Tried the following: Stripped template down to one query on dev box against test DB - still errors Stripped template down to one query on prod box against test DB - no errors Thanks for your time and help, Brent Nicholas ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX7
Also, check out this blog: http://www.talkingtree.com/blog/index.cfm?mode=entryentry=40F4C7EA-45A6 -2844-7D0C4841EA190125 ~Brad Brad, The link you provided was first on a google search, also yes I I checked all of the CF admin setting and they are the same. I'm still reading over the TalkingTree.com article, that's where I learned about the new drivers. I'm just loath to patch one box, but not need to patch another. Breaking the prod box would not make my day at all.. ;) (I'm hell bent on keeping the boxes as close to the same as possible.) I've determined I need to put CFMX7-SP2 on the dev server as well as prod, so I'm going to take a shot in the dark on that one. Thanks for your thoughts, BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLogin losing login data
Howdy all - So I thought I had this login thing worked out, but after an hour of pulling out my hair I'm stumped. In short, I can fill out the login form and submit it. It checks the DB just fine and CF logs you in just fine. It's when you reach the bottom of the act_login.cfm template it fails when the CFLOCATION sends you back where you came from. Here's the code out line. Code included for: Application.cfc and act_Login.cfm (notes for app flow are in *NOTES in the code) First I'll show the Application.cfc so you can see how that's set up. In short it sets you up as a guest that is a record in the db if you are not logged in. (for foriegn key needs.) No matter what I try, when the CFLOCATION tag fires in the act_Login.cfm template, the cfquery name=GetNoAuthGuest in the application.cfc fires. Thus that means cfif GetAuthUser() eq above the query is evaluating to true. ie: login data was lost in the CFLOCATION. In the act_login.cfm file it just takes your data and logs you in or fails. The DESTINATION var is passed in from where you came from as a URL so you can get back there. ie: DESTINATION = http://www.r00t.com/FileShare/index.cfm; Also, the queries have been obscured. Thank you to everyone who can give a minute to look this over, I hope I did a decent job at giving everthing you need to review. -- -- Application.cfc - (brief) -- cfset this.name=ThisIntranet cfset this.sessionmanagement=yes cfset this.SetClientCookies=no cfset this.loginstorage=session cfset this.applicationTimeout=CreateTimeSpan(0,12,0,0) cfset this.sessionTimeout=CreateTimeSpan(0,4,0,0) cffunction name=onSessionStart returntype=void cfif GetAuthUser() eq !--- if no user info is passed from IE's ActiveDirectory connect --- cfif cgi.AUTH_USER eq !--- log user in as guest--- !--- get guest account --- RUNS AS IT SHOULD THE FIRST TIME, BUT RUNS THIS EVEN AFTER LOGIN (CFLOCATION relocation in act_login.cfm) *** cfquery name=GetNoAuthGuest dataSource=#request.DATASOURCE# SELECT DATA FROM TABLE WHERE UPPER(E.LAST_NAME) = 'CFL GUEST' /cfquery cflogin cfloginuser name=#GetNoAuthGuest.DATA# Password=cfl-guest roles=GUEST /cflogin cfelse !--- if user info is passed from IE's ActiveDirectory connect --- CFSET AUTH_USER = ListLast(Replace(Replace(UCASE(cgi.AUTH_USER),\,,,ALL),/,,,ALL)) cfquery name=loginQuery dataSource=#request.DATASOURCE# SELECT DATA FROM TABLE WHERE USER_NAME = '#AUTH_USER#' /cfquery cfif loginQuery.RecordCount neq 0 cflogin cfloginuser name=#loginQuery.DATA# Password=#loginQuery.password# roles=#loginQuery.ROLE# /cflogin cfelse !--- log user in as guest--- !--- get guest account --- cfquery name=GetGuest dataSource=#request.DATASOURCE# SELECT DATA FROM TABLE WHERE UPPER(E.LAST_NAME) = 'CFL GUEST' /cfquery cflogin cfloginuser name=#GetGuest.DATA# Password=cfl-guest roles=GUEST /cflogin /cfif /cfif /cfif /cffunction act_Login.cfm - cfparam name=destination default= cfif J_USERNAME IS OR J_PASSWORD IS cfoutput h2You must enter text in both the User Name and Password fields./h2 /cfoutput cfinclude template=dsp_LoginForm.cfm cfabort cfelse cfquery name=loginQuery dataSource=#request.DATASOURCE# SELECT DATA FROM TABLE WHERE USER = '#J_USERNAME#' AND PASSWORD = '#J_PASSWORD#' /cfquery cfif loginQuery.RecordCount neq 0
Resolved. - Re: CFLogin losing login data
Disregard. I figured it out. BN Howdy all - So I thought I had this login thing worked out, but after an hour of pulling out my hair I'm stumped. In short, I can fill out the login form and submit it. It checks the DB just fine and CF logs you in just fine. It's when you reach the bottom of the act_login.cfm template it fails when the CFLOCATION sends you back where you came from. Here's the code out line. Code included for: Application.cfc and act_Login.cfm (notes for app flow are in *NOTES in the code) First I'll show the Application.cfc so you can see how that's set up. In short it sets you up as a guest that is a record in the db if you are not logged in. (for foriegn key needs.) No matter what I try, when the CFLOCATION tag fires in the act_Login.cfm template, the cfquery name=GetNoAuthGuest in the application.cfc fires. Thus that means cfif GetAuthUser() eq above the query is evaluating to true. ie: login data was lost in the CFLOCATION. In the act_login.cfm file it just takes your data and logs you in or fails. The DESTINATION var is passed in from where you came from as a URL so you can get back there. ie: DESTINATION = http://www.r00t. com/FileShare/index.cfm Also, the queries have been obscured. Thank you to everyone who can give a minute to look this over, I hope I did a decent job at giving everthing you need to review. -- -- Application.cfc - (brief) -- cfset this.name=ThisIntranet cfset this.sessionmanagement=yes cfset this.SetClientCookies=no cfset this.loginstorage=session cfset this.applicationTimeout=CreateTimeSpan(0,12,0,0) cfset this.sessionTimeout=CreateTimeSpan(0,4,0,0) cffunction name=onSessionStart returntype=void cfif GetAuthUser() eq !--- if no user info is passed from IE's ActiveDirectory connect --- cfif cgi.AUTH_USER eq !--- log user in as guest--- !--- get guest account --- RUNS AS IT SHOULD THE FIRST TIME, BUT RUNS THIS EVEN AFTER LOGIN (CFLOCATION relocation in act_login.cfm) *** cfquery name=GetNoAuthGuest dataSource=#request.DATASOURCE# SELECT DATA FROM TABLE WHERE UPPER(E.LAST_NAME) = 'CFL GUEST' /cfquery cflogin cfloginuser name=#GetNoAuthGuest.DATA# Password=cfl-guest roles=GUEST /cflogin cfelse !--- if user info is passed from IE's ActiveDirectory connect --- CFSET AUTH_USER = ListLast(Replace(Replace(UCASE(cgi.AUTH_USER), \,,,ALL),/,,,ALL)) cfquery name=loginQuery dataSource=#request.DATASOURCE# SELECT DATA FROM TABLE WHERE USER_NAME = '#AUTH_USER#' /cfquery cfif loginQuery.RecordCount neq 0 cflogin cfloginuser name=#loginQuery.DATA# Password=#loginQuery. password# roles=#loginQuery.ROLE# /cflogin cfelse !--- log user in as guest--- !--- get guest account --- cfquery name=GetGuest dataSource=#request.DATASOURCE# SELECT DATA FROM TABLE WHERE UPPER(E.LAST_NAME) = 'CFL GUEST' /cfquery cflogin cfloginuser name=#GetGuest.DATA# Password=cfl-guest roles=GUEST /cflogin /cfif /cfif /cfif /cffunction act_Login.cfm - cfparam name=destination default= cfif J_USERNAME IS OR J_PASSWORD IS cfoutput h2You must enter text in both the User Name and Password fields. /h2 /cfoutput cfinclude template=dsp_LoginForm.cfm cfabort cfelse cfquery name=loginQuery dataSource=#request.DATASOURCE# SELECT DATA FROM TABLE WHERE USER = '#J_USERNAME#' AND PASSWORD =
proper variable scope conversion
howdy all - I've got a question about scoping with the 'request' scope. But I suppose it can be applied to conversion of any scope. In the app I have a series of var's that will need to be used in templates, CFC's (user defined and Application.cfc)and custom tags. The var's are all in the 'request' scope. What I'm having issue with is that when they get passed to the next template from a URL or a FORM, they are then placed in those scopes. So I'm wondering if the best practice is to have a code block that runs in the Application.cfc (onRequest) that does the following? cfif isDefined(form.variable_name) cfset request.variable_name = form.variable_name /cfif cfif isDefined(url.variable_name) cfset request.variable_name = url.variable_name /cfif And do this for each variable? It seems a little tedious. And that leads me to wonder if I'm even approaching it correctly. Extra background to how I got here: Outline: I'm using a very loose version of FuseBox (basically just the file structure and fuseactions) App Folder Structure: |---Intranet Base Folder - (Application.cfc sets up the application.dsn, session.ID's user and other top level info) |--- Document Management folder - (Application.cfc (extends the above Application.cfc), runs a folder security check using a request.var) My observations: 1) When I include the app_Globals.cfm file (holds all my cfparam-var's) into the second Application.cfc, the var's can be used in that CFC but not the index.cfm that is the page being run. 2) Obviously if I include the app_Globals.cfm file into the index.cfm file then it works fine, but the call to one of the var's in the second Application.cfc file fails. (expected) 3) I could include the app_Globals.cfm into both pages (application.cfc and index.cfm), but this seems wrong.. My proposed solution: Scope all of the var's in the app_Globals.cfm as 'request.varName' variables, and include into the second Application.cfc file. Thanks for everone's time, Brent Nicholas ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: proper variable scope conversion
Barney - Thanks for your reply. I kind of felt I was doing something a bit 'off'. How would you approach this situation where you need your vars to be avaliable in your Application.cfc and template.cfm's and be able to pass them around page to page? I'm ashamed to say I've never done much scoping, but now that I'm on new projects I have the time to step back and 'do it right'. Of course, I could be just brain dead today and need to have a think over the weekend. :) I know you might be busy, so if you'd prefer to point me at something to read that will give a clear answer, that would be appreciated as well. I did a bit of Google'ing, but didn't find anything that was clear and to the point. Thanks, BN You can do this: structAppend(request, url, false); structAppend(request, form, false); to move everything from URL and FORM into the request scope if you'd like. Of course, that devalues the request scope to a fair degree. cheers, barneyb On 12/1/06, Brent Nicholas [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262455 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: proper variable scope conversion
Barney - Ok, great. Thanks for your time, I appreciate it. BN If you need to have variables shared between requests from the same person, the session scope is probably your best bet. If that's not appropriate for whatever reason, you're stuck doing some kind of copying operations. The latter's not necessarily a bad solution, just has certain drawbacks. At the very least, I'd look to package all the incoming variables into a subscope of request (request.params or something), so they're differentiated from normal request variables. Bottom line, if it works, it can't really be wrong. Might not be as right as other solutions, but perfection is an unattainable goal, particularly in software development. cheers, barneyb On 12/1/06, Brent Nicholas [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ugh... CFLOGIN Help please
James - So if I understand you correctly 1) the act_Login page stores the login information to the session. 2) to get at that information you neeed to fire off the cflogin tag to pull the information into the page for use. I'll give it a shot. Thanks for your time. BN On index.cfm, you need to run a cflogin tag before the getAuthUser() function will work. This is true in any page that you intend to protect with CFLOGIN authentication. On 9/15/06, Brent Nicholas [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ugh... CFLOGIN Help please
This worked perfectly. It's an odd way of doing things, but it worked. Thank you, BN ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253261 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does anybody really understand character encodings?
I'm no expert here, but I'd try to use a regular expression that leaves all the 'known good characters' and removes the unknown. Though you'd really have to look into what is 'known good' if you think it maybe more than A-Z, a-z, 1-0, and punctuation. 2 cents. BN I have some users who enter data into my web application through one of two ways: - copy/paste from microsoft word - XML export from InDesign UTF-16 - XML export from Quark In all 3 of the cases I've described above, the orign software is putting through characters that do not display correctly on the web. The problem I'm having is that some of the characters such as an ellipsis mark or hyphen. When I run into these characters, they display as the wrong character... sometimes a question mark. Othertimes a square box... yet other times sequences of characters that are just totally crazy. My basic understanding of character encoding tells me that I want to reduce all of the characters down to ASCII. I do not know a good way to do this. How can I accept text from each of the above mentioned sources, perhaps others, and somehow *normalize* all of the character data into a set of characters that will display properly on my page every time? Thank you, Jon ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reliability
I think that Terrence Ryan had the best approach to the situation. CFMX is a stable product, we've run about 15 CFMX servers around the world supporting corporate intranets and extranets with a constant load and rarely have problems. Take a look at Terrence's pragmatic approach and try to emulate that. I think you'll find your answer. BN Bit of an odd one this - but does anyone else find CF a little more unreliable than other similar products when using them in day to day use. The only reason I ask is that our CF servers always seem a little more unstable than some of our other servers running things such as ASP.NET or Ruby on Rails. CF just seems to restart itself more than I believe it should. I am the only one? I'm pretty sure our code is fairly sound, and that our servers aren't under too much load. -- Neil Middleton Visit feed-squirrel.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ugh... CFLOGIN Help please
Ok, so I've searched and read the posts on this list about CFLOGIN, I've read Brandon Purcell's power point and read over all the Macromedia documentation. I'm actually using most of their code, though I've rearranged it to make more sense in what I'm doing to prove the concept. In short it works, but seems to loose the session/user once you leave the page that did the login?? Anyone know what I'm doing wrong? I'm sure it's something obvious... I'll get to the nitty gritty here. Code is laid out as follows and all lives in the same directory: -page break--- PageName.cfm -- CODE HERE --end page-- -page break--- Application.cfc -- cfcomponent output=false !--- define application variables --- cfset this.name=CFLHD_Intranet / cfset this.sessionmanagement=true / cfset this.setclientcookies=false / cfset this.loginstorage=session /cfcomponent --end page-- -page break--- index.cfm -- !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; lang=en xml:lang=en head meta http-equiv=content-type content=text/html; charset=utf-8 / titleCFLHD - Intranet/title cfsetting showdebugoutput=Yes /head body cfoutput h2Welcome #GetAuthUser()#!/h2br / #application.applicationname#br / /cfoutput cfif NOT IsDefined(cflogin) test not logged in br / cfelse test logged in br / /cfif cfif GetAuthUser() EQ a href=LoginForm.cfmLogin/a cfelse cfoutput a href=EmployeeDataPage.cfm?emp_id=#GetAuthUser()#Nicholas, Brent/a /cfoutput /cfif /body /html --end page-- -page break--- LoginForm.cfm -- H2Please Log In/H2 cfoutput form action=act_LogIn.cfm method=Post table tr tdusername:/td tdinput type=text name=j_username/td /tr tr tdpassword:/td tdinput type=password name=j_password/td /tr /table br input type=submit value=Log In /form /cfoutput --end page-- -page break--- act_LogIn.cfm -- cflogin applicationtoken=#application.applicationname# cfif cflogin.name IS OR cflogin.password IS cfoutput h2You must enter text in both the User Name and Password fields./h2 /cfoutput cfinclude template=loginform.cfm cfabort cfelse !--- remove for simplicity cfquery name=loginQuery dataSource=#request.DATASOURCE# SELECT ID, ROLE, GROUP_NAME FROM CFL_ADMIN.INTRANET_GROUPS WHERE USER_NAME = '#cflogin.name#' AND PASSWORD = '#cflogin.password#' /cfquery --- cfloginuser name=BNICHOLAS Password=EggARoll roles=ThaMan !--- removed for simplicity cfif loginQuery.ROLE NEQ cfloginuser name=#cflogin.name# Password = #cflogin.password# roles=#loginQuery.ROLE# cfelse cfoutput H2Your login information is not valid.brPlease Try again/H2 /cfoutput cfinclude template=loginform.cfm cfabort /cfif --- /cfif /cflogin cfoutput THIS WORKS FINE, SHOWS USER h2Welcome #GetAuthUser()#!/h2 THOUGH AFTER YOU CLICK THIS YOU'LL LOOSE THE DATA. a href=index.cfm?#session.urltoken#index page/a /cfoutput --end page-- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ugh... CFLOGIN Help please
This may make it easier to address this issue. It's all the files in a folder ready to test. http://www.cflhd.gov/TeleconfDocs/LoginTestingbak.zip Thanks again - BN Ok, so I've searched and read the posts on this list about CFLOGIN, I've read Brandon Purcell's power point and read over all the Macromedia documentation. I'm actually using most of their code, though I've rearranged it to make more sense in what I'm doing to prove the concept. In short it works, but seems to loose the session/user once you leave the page that did the login?? Anyone know what I'm doing wrong? I'm sure it's something obvious... I'll get to the nitty gritty here. Code is laid out as follows and all lives in the same directory: -page break--- PageName.cfm -- CODE HERE --end page-- -page break--- Application.cfc -- cfcomponent output=false !--- define application variables --- cfset this.name=CFLHD_Intranet / cfset this.sessionmanagement=true / cfset this.setclientcookies=false / cfset this.loginstorage=session /cfcomponent --end page-- -page break--- index.cfm -- !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www. w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd html xmlns=http://www.w3.org/1999/xhtml; lang=en xml:lang=en head meta http-equiv=content-type content=text/html; charset=utf-8 / titleCFLHD - Intranet/title cfsetting showdebugoutput=Yes /head body cfoutput h2Welcome #GetAuthUser()#!/h2br / #application.applicationname#br / /cfoutput cfif NOT IsDefined(cflogin) test not logged in br / cfelse test logged in br / /cfif cfif GetAuthUser() EQ a href=LoginForm.cfmLogin/a cfelse cfoutput a href=EmployeeDataPage.cfm?emp_id=#GetAuthUser()#Nicholas, Brent/a /cfoutput /cfif /body /html --end page-- -page break--- LoginForm.cfm -- H2Please Log In/H2 cfoutput form action=act_LogIn.cfm method=Post table tr tdusername:/td tdinput type=text name=j_username/td /tr tr tdpassword:/td tdinput type=password name=j_password/td /tr /table br input type=submit value=Log In /form /cfoutput --end page-- -page break--- act_LogIn.cfm -- cflogin applicationtoken=#application.applicationname# cfif cflogin.name IS OR cflogin.password IS cfoutput h2You must enter text in both the User Name and Password fields. /h2 /cfoutput cfinclude template=loginform.cfm cfabort cfelse !--- remove for simplicity cfquery name=loginQuery dataSource=#request.DATASOURCE# SELECT ID, ROLE, GROUP_NAME FROM CFL_ADMIN.INTRANET_GROUPS WHERE USER_NAME = '#cflogin.name#' AND PASSWORD = '#cflogin.password#' /cfquery --- cfloginuser name=BNICHOLAS Password=EggARoll roles=ThaMan !--- removed for simplicity cfif loginQuery.ROLE NEQ cfloginuser name=#cflogin.name# Password = #cflogin.password# roles=#loginQuery.ROLE# cfelse cfoutput H2Your login information is not valid.brPlease Try again/H2 /cfoutput cfinclude template=loginform.cfm cfabort /cfif --- /cfif /cflogin cfoutput THIS WORKS FINE, SHOWS USER h2Welcome #GetAuthUser()#!/h2 THOUGH AFTER YOU CLICK THIS YOU'LL LOOSE THE DATA. a href=index.cfm?#session.urltoken#index page/a /cfoutput --end page-- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Save the BLOB :)
So the DB peeps here have decided to lay the Oracle BLOB on me... woo hoo. Anyway, I figured out that you have to use CFQUERYPARAM to get the data in. ex:cfqueryparam value=#Binarydecode(TextAreaContent,Base64)# cfsqltype=cf_sql_blob Though I'm not sure if the funtion is correct, it doesn't error out like it would without it. Then I use this to display the content from the DB on the page: #BinaryEncode(DBColumn,Base64)# Only problem I'm having is that the resulting string is missing all of the spaces. Ex: I save the string: Run this test and see if it works all perty. When pulling it out of the DB using the function above I get: Runthistestandseeifitworksallperty. Has anyone dealt with this before? Thanks for your time - BrentNicholas($$).work; ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Save the BLOB :)
So I'm wondering if maybe I should have them change the BLOB to a CLOB? This thought after some research BN So the DB peeps here have decided to lay the Oracle BLOB on me... woo hoo. Anyway, I figured out that you have to use CFQUERYPARAM to get the data in. ex:cfqueryparam value=#Binarydecode(TextAreaContent,Base64)# cfsqltype=cf_sql_blob Though I'm not sure if the funtion is correct, it doesn't error out like it would without it. Then I use this to display the content from the DB on the page: #BinaryEncode(DBColumn,Base64)# Only problem I'm having is that the resulting string is missing all of the spaces. Ex: I save the string: Run this test and see if it works all perty. When pulling it out of the DB using the function above I get: Runthistestandseeifitworksallperty. Has anyone dealt with this before? Thanks for your time - BrentNicholas($$). work; ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CONTAINS nuances
Howdy all - So I've been given the lovely task of parsing out an email of values from a submitted form. Those in the know are already growning... ;) Well in short it all boils down to this right now. How do you do a contains with commas in the values? original form feilds: input name=mover value= Hydrogen Storage type=checkbox input name=mover value=Gas Transport type=checkbox input name=mover value=Power / HVAC , Settle, Gas type=checkbox input name=mover value=Line / Pipe type=checkbox input name=mover value=Some Option not selected 1 type=checkbox input name=mover value=Some Option not selected 2 type=checkbox I am doing the following: CurrentCompareVar = Power / HVAC , Settle, Gas - this came out of a struct I have of each value with a key mover = CurrentCompareAllOptions = Hydrogen Storage, Gas Transport, Power / HVAC , Settle, Gas, Line / Pipe The value for CurrentCompareAllOptions are all of the check boxes that were checked and emailed, thus I have no control over the value names otherwise you wouldn't be reading this and commas would not be in it except to separate values. The CurrentCompareVar came out of a struct of all the values I manually populated from all the checkbox values on the form. I then perform: cfif CurrentCompareAllOptions contains CurrentCompareVar They checked this option. /cfif It does not work. No, error. Just no match. It does work for every CurrentCompareVar except if there are commas in the value. For example if CurrentCompareVar = Hydrogen Storage I get a match. or if CurrentCompareVar = Line / Pipe I get a match. Let me know if more info is needed. Thanks to all who can help. BN ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241092 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Trying Again: CONTAINS issues
Posted earlier, but I couldn't read it on the site. -- Howdy all - So I've been given the lovely task of parsing out an email of values from a submitted form. Those in the know are already growning... ;) Well in short it all boils down to this right now. How do you do a contains with commas in the values? original form feilds: input name=mover value= Hydrogen Storage type=checkbox input name=mover value=Gas Transport type=checkbox input name=mover value=Power / HVAC , Settle, Gas type=checkbox input name=mover value=Line / Pipe type=checkbox input name=mover value=Some Option not selected 1 type=checkbox input name=mover value=Some Option not selected 2 type=checkbox I am doing the following: CurrentCompareVar = Power / HVAC , Settle, Gas - this came out of a struct I have of each value with a key mover = CurrentCompareAllOptions = Hydrogen Storage, Gas Transport, Power / HVAC , Settle, Gas, Line / Pipe The value for CurrentCompareAllOptions are all of the check boxes that were checked and emailed, thus I have no control over the value names otherwise you wouldn't be reading this and commas would not be in it except to separate values. The CurrentCompareVar came out of a struct of all the values I manually populated from all the checkbox values on the form. I then perform: cfif CurrentCompareAllOptions contains CurrentCompareVar They checked this option. /cfif It does not work. No, error. Just no match. It does work for every CurrentCompareVar except if there are commas in the value. For example if CurrentCompareVar = Hydrogen Storage I get a match. or if CurrentCompareVar = Line / Pipe I get a match. Let me know if more info is needed. Thanks to all who can help. BN ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241093 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
