Re: Problem with JSON Grid | ColdExt
Well... I tried the same pages in IE7 and there it is showing two browser errors. 1. 'Ext.ux.grid.Search' is null or not an object 2. Could not complete the operation due to Error 80020101 please help me with this, I am running real short on deadlines! -- From: "Arsalan Tariq Keen" Sent: Tuesday, October 20, 2009 8:38 AM To: "cf-talk" Subject: Re: Problem with JSON Grid | ColdExt > > I guess I got too carried away with FireBug :) it helped me clear out many > bugs in my application. Now my grid is showing the content I wanted with > the > WHERE clause in CFQUERY. However, one problem persists. When I use the > gridsearch plugin, the grid does not showup at all and firebug is also > giving no error. The page with grid is autoLoaded inside of a window, > however when I load the same page directly in the browser window, the grid > is displayed fine. Any suggestions? > > > -- > From: "Raymond Camden" > Sent: Tuesday, October 20, 2009 3:36 AM > To: "cf-talk" > Subject: Re: Problem with JSON Grid | ColdExt > >> >> Sounds like the library didn't load. But it worked before so I'm not >> sure about that. What do you see in the XHR requests? You should see >> one to fetch your data. Try right click/open in new tab and see if you >> notice a CF error. >> >> >> On Mon, Oct 19, 2009 at 2:33 PM, Arsalan Tariq Keen >> wrote: >>> >>> Camden... >>> >>> firebug is saying... >>> "Ext.ux.grid is undefined >>> http://127.0.0.1:/ext/ext-all.js >>> Line 32" >>> >>> >>> any clues? >>> >>> >>> -- >>> From: "Raymond Camden" >>> Sent: Monday, October 19, 2009 5:30 PM >>> To: "cf-talk" >>> Subject: Re: Problem with JSON Grid | ColdExt >>> http://www.insideria.com/2009/06/quick-video-example-of-firebug.html Enjoy. On Mon, Oct 19, 2009 at 12:52 AM, Arsalan Tariq Keen wrote: > > Hmmm... Camden, can you guide me about using Firebug... actually I am > a > newbie to Ajax and I am using IE7, I guess firebug would work with > FireFox. > > -- > From: "Raymond Camden" > Sent: Monday, October 19, 2009 9:57 AM > To: "cf-talk" > Subject: Re: Problem with JSON Grid | ColdExt > >> >> What did Firebug tell you? >> >> On Sun, Oct 18, 2009 at 9:59 PM, Arsalan Tariq Keen >> wrote: >>> >>> Dear CFers, >>> >>> I am having trouble with the JSON gridpanel using ColdExt. The >>> problem >>> is... when I feed the grid with JSON generated from CFQUERY with a >>> simple >>> SELECT statement without any conditions, it runs fine, however if I >>> add >>> a >>> WERE clause then the grid fails to populate even though JSON is >>> generated. Below is given my CFML code. Can anyone help me with >>> this >>> I need urgent support... I m falling short of time for my deadlines >>> >>> Also, this gridpanel is displayed within a ExtJS window, so if I use >>> the >>> gridSearch plugin with it, than the grid doesn't display at all >>> instead >>> a >>> Javascript error is given by the browser. >>> >> >> > > >>> >>> >> >> > > ~| 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:327352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with JSON Grid | ColdExt
I guess I got too carried away with FireBug :) it helped me clear out many bugs in my application. Now my grid is showing the content I wanted with the WHERE clause in CFQUERY. However, one problem persists. When I use the gridsearch plugin, the grid does not showup at all and firebug is also giving no error. The page with grid is autoLoaded inside of a window, however when I load the same page directly in the browser window, the grid is displayed fine. Any suggestions? -- From: "Raymond Camden" Sent: Tuesday, October 20, 2009 3:36 AM To: "cf-talk" Subject: Re: Problem with JSON Grid | ColdExt > > Sounds like the library didn't load. But it worked before so I'm not > sure about that. What do you see in the XHR requests? You should see > one to fetch your data. Try right click/open in new tab and see if you > notice a CF error. > > > On Mon, Oct 19, 2009 at 2:33 PM, Arsalan Tariq Keen > wrote: >> >> Camden... >> >> firebug is saying... >> "Ext.ux.grid is undefined >> http://127.0.0.1:/ext/ext-all.js >> Line 32" >> >> >> any clues? >> >> >> -- >> From: "Raymond Camden" >> Sent: Monday, October 19, 2009 5:30 PM >> To: "cf-talk" >> Subject: Re: Problem with JSON Grid | ColdExt >> >>> >>> http://www.insideria.com/2009/06/quick-video-example-of-firebug.html >>> >>> Enjoy. >>> >>> On Mon, Oct 19, 2009 at 12:52 AM, Arsalan Tariq Keen >>> wrote: Hmmm... Camden, can you guide me about using Firebug... actually I am a newbie to Ajax and I am using IE7, I guess firebug would work with FireFox. -- From: "Raymond Camden" Sent: Monday, October 19, 2009 9:57 AM To: "cf-talk" Subject: Re: Problem with JSON Grid | ColdExt > > What did Firebug tell you? > > On Sun, Oct 18, 2009 at 9:59 PM, Arsalan Tariq Keen > wrote: >> >> Dear CFers, >> >> I am having trouble with the JSON gridpanel using ColdExt. The >> problem >> is... when I feed the grid with JSON generated from CFQUERY with a >> simple >> SELECT statement without any conditions, it runs fine, however if I >> add >> a >> WERE clause then the grid fails to populate even though JSON is >> generated. Below is given my CFML code. Can anyone help me with >> this >> I need urgent support... I m falling short of time for my deadlines >> >> Also, this gridpanel is displayed within a ExtJS window, so if I use >> the >> gridSearch plugin with it, than the grid doesn't display at all >> instead >> a >> Javascript error is given by the browser. >> > > >>> >>> >> >> > > ~| 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:327351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Variable scope
Best of luck! Just know there are options in case you get stuck. Projects like the one you are describing can have some interesting curve balls. Just watch out for them. They can sting! ;-) On Mon, Oct 19, 2009 at 6:57 PM, Brian Bradley wrote: > > We have been using windows iis, etc. since 1999 and are trying to take more > control since we now have so many bs membership types. It is a crazy > project that was just handed to me. I think that I am just going to have to > bite the bullet and use cookies to house the information and pass it on > since there are going to be so many active applications. Was hoping somehow > there was something I was missing about the different variable scopes. > > > ~| 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:327350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Variable scope
We have been using windows iis, etc. since 1999 and are trying to take more control since we now have so many bs membership types. It is a crazy project that was just handed to me. I think that I am just going to have to bite the bullet and use cookies to house the information and pass it on since there are going to be so many active applications. Was hoping somehow there was something I was missing about the different variable scopes. ~| 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:327349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Variable scope
Wow! That makes quite the difference on how you might want to approach this. You have a lot of files to manage, which easily promotes something a little more senior/enterprise based. Knowing this you may want to consider going one of the below routes instead of shoehorning in the bit of code I recommended. One is looking into utilizing windows authentication. If you are using IIS on windows then this could be quite easy. I would google this and see what you find. Does anyone know of a good article they can recommend on this one? If that does not work for you something like a document management system that has an API might be what you need. Here is one that you can research against to get a better idea on what you might need. There are others out there of course. http://www.xythos.com/ -Pat On Mon, Oct 19, 2009 at 6:05 PM, Brian Bradley wrote: > > The thing is, it is a HGE site - 30,000+ documents so some of it is > secured and some of it isn't. I figured it would be best at the directory > (we are running Windows server) level to just decide which directories get > application files that have security and which don't. There are too many to > map and I am afraid of server resources if I had to. Also, we are in a > position where we can't reorganize the ancient directory structure since we > then would have to worry about 30,000+ documents with links breaking. Glad > this was put on me with a two month window. ARGHH! > > ~| 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:327348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cflock within Application.cfc?
> Cannot lock SESSION scope. > Cannot use cflock to lock the application or session shared scopes > without these scopes being established through the use of the > cfapplication tag. To use the session scope you need to enable > session management. Application and/or Session variables must also be > enabled in the ColdFusion Administrator. Hmmm... well that's strange... My first instinct is to say that you've somehow accidentally attempted to lock the session scope inside of the onApplicationStart() method or possibly in the soft-constructor of the Application.cfc (which is how it appeared in your pseudo-code). But I had assumed that what you really meant was that the lock was in the onSessionStart() method (but you just weren't showing the cffunction tags for it). That would be the only way that I could see this actually working on your live server, and I thought I remembered you saying you'd pulled down a known-good copy that matched what's on the live server. Anyway, that's the only other thing that springs to mind for me is that onSessionStart() doesn't execute until after onApplicationStart() and the session scope doesn't exist until that method executes (which I'm sure you know). If you'd like some help off-list, feel free to email me the Application.cfc you've got and I'll test it here and see if I see anything else peculiar with it. p.s. Adobe ought to update that error message. It's still using the error message from CF5, before Application.cfc was introduced and most of us don't use the cfapplication tag to establish our scopes anymore. ;) -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| 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:327347 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Variable scope
The thing is, it is a HGE site - 30,000+ documents so some of it is secured and some of it isn't. I figured it would be best at the directory (we are running Windows server) level to just decide which directories get application files that have security and which don't. There are too many to map and I am afraid of server resources if I had to. Also, we are in a position where we can't reorganize the ancient directory structure since we then would have to worry about 30,000+ documents with links breaking. Glad this was put on me with a two month window. ARGHH! ~| 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:327346 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Tool for Users to build their own Queries
> > Honestly > though if she really is a "Data Analyst" and her job is working with data > and databases for a living, she is likely to already have a favorite Oracle > toolset. > Not necessarily. I work with a slew of Data Analyst's as we do a lot of research, and the vast majority of the data crunching is done via SPSS. Most of the time the data is feed to SPSS using Excel or Access. We dump out the raw data to Access (Actually most of that is automated using MSSQL) and then they do their thing with it. Most of these people (mostly Ph.D's mind you) know very little about data bases out side of Access. Nor is there any need for them to. They are researchers, all they care about is what the data means. G! On Mon, Oct 19, 2009 at 1:39 PM, Cameron Childress wrote: > > As Dan suggested, you can suggest Oracle SQL Developer to her. Honestly > though if she really is a "Data Analyst" and her job is working with data > and databases for a living, she is likely to already have a favorite Oracle > toolset. > > YMMV > > -Cameron > > On Mon, Oct 19, 2009 at 11:29 AM, Dave Hatz >wrote: > > > Cameron, > > Thanks for the info on setting up the user account. My programmers and I > > use TOAD for all our Oracle Data access. I am not sure if she will have > > the > > budget to go out and buy TOAD. Do you know of any other tools on the > > market > > that she might be able to use? > > > > > ~| 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:327345 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Tool for Users to build their own Queries
There is a freeware version of Toad that should let her do basic data extraction. http://www.toadsoft.com/lic_agree.html On Mon, Oct 19, 2009 at 8:29 AM, Dave Hatz wrote: > > Cameron, > Thanks for the info on setting up the user account. My programmers and I > use TOAD for all our Oracle Data access. I am not sure if she will have the > budget to go out and buy TOAD. Do you know of any other tools on the market > that she might be able to use? > > D ~| 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:327344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Variable scope
I think I have the findNoCase arguments mixed up :P. Switch them. If you are using CF 7+ then application.cfc should be available to use. -Pat On Mon, Oct 19, 2009 at 3:21 PM, Patrick Santora wrote: > Alan's right. Coldfusion sits on top of the directories, so you can head > the user off at the pass before showing off anything that may be within that > folder. In your case you may want to consider trapping whether or not the > user has access by pushing in some security logic into the onRequestStart > method that should be available through application.cfc (assuming you are > using application.cfc and your version of CF can handle it). There you can > do something like this (not tested): > > Reference to application.cfc example: > http://www.bennadel.com/blog/726-ColdFusion-Application-cfc-Tutorial-And-Application-cfc-Reference.htm > > > findNoCase( arguments.targetPath, "{directory}" )> > > > > I'm sure there are other ways, but something like this should work fine and > you would only need one application scope. > > -Pat > > > On Mon, Oct 19, 2009 at 3:01 PM, Alan Rother wrote: > >> >> Why are you using so many application.cfm files? You really only need one, >> from what you've described. >> >> On Mon, Oct 19, 2009 at 2:34 PM, Brian Bradley wrote: >> >> > >> > In the one off of the root - I name it login_app and it has a session >> > variable named loggedIn. In the contact folder (for example) the name >> of >> > that application is contact_app and it is looking for the loggedIn >> variable. >> > If loggedIn exists, it lets the user access the pages in that >> directory, if >> > it does not, it will redirect them to the logon page. I am getting that >> > loggedIn cannot be defined since it isn't technically part of the >> > contact_app application. I can still pull the value up in the contact >> > folder from a file just not from the application file. I thought that >> the >> > directory structure plays a role and I can use variables as long as it >> goes >> > from the root through the subdirectories, but I guess I am wrong. I >> just am >> > hoping to avoid cookies if possible. Thanks. >> > >> > >> >> ~| 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:327343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Variable scope
Alan's right. Coldfusion sits on top of the directories, so you can head the user off at the pass before showing off anything that may be within that folder. In your case you may want to consider trapping whether or not the user has access by pushing in some security logic into the onRequestStart method that should be available through application.cfc (assuming you are using application.cfc and your version of CF can handle it). There you can do something like this (not tested): Reference to application.cfc example: http://www.bennadel.com/blog/726-ColdFusion-Application-cfc-Tutorial-And-Application-cfc-Reference.htm I'm sure there are other ways, but something like this should work fine and you would only need one application scope. -Pat On Mon, Oct 19, 2009 at 3:01 PM, Alan Rother wrote: > > Why are you using so many application.cfm files? You really only need one, > from what you've described. > > On Mon, Oct 19, 2009 at 2:34 PM, Brian Bradley wrote: > > > > > In the one off of the root - I name it login_app and it has a session > > variable named loggedIn. In the contact folder (for example) the name of > > that application is contact_app and it is looking for the loggedIn > variable. > > If loggedIn exists, it lets the user access the pages in that directory, > if > > it does not, it will redirect them to the logon page. I am getting that > > loggedIn cannot be defined since it isn't technically part of the > > contact_app application. I can still pull the value up in the contact > > folder from a file just not from the application file. I thought that > the > > directory structure plays a role and I can use variables as long as it > goes > > from the root through the subdirectories, but I guess I am wrong. I just > am > > hoping to avoid cookies if possible. Thanks. > > > > > > ~| 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:327342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Variable scope
Why are you using so many application.cfm files? You really only need one, from what you've described. On Mon, Oct 19, 2009 at 2:34 PM, Brian Bradley wrote: > > In the one off of the root - I name it login_app and it has a session > variable named loggedIn. In the contact folder (for example) the name of > that application is contact_app and it is looking for the loggedIn variable. > If loggedIn exists, it lets the user access the pages in that directory, if > it does not, it will redirect them to the logon page. I am getting that > loggedIn cannot be defined since it isn't technically part of the > contact_app application. I can still pull the value up in the contact > folder from a file just not from the application file. I thought that the > directory structure plays a role and I can use variables as long as it goes > from the root through the subdirectories, but I guess I am wrong. I just am > hoping to avoid cookies if possible. Thanks. > > ~| 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:327341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Variable scope
In the one off of the root - I name it login_app and it has a session variable named loggedIn. In the contact folder (for example) the name of that application is contact_app and it is looking for the loggedIn variable. If loggedIn exists, it lets the user access the pages in that directory, if it does not, it will redirect them to the logon page. I am getting that loggedIn cannot be defined since it isn't technically part of the contact_app application. I can still pull the value up in the contact folder from a file just not from the application file. I thought that the directory structure plays a role and I can use variables as long as it goes from the root through the subdirectories, but I guess I am wrong. I just am hoping to avoid cookies if possible. Thanks. ~| 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:327340 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with JSON Grid | ColdExt
Sounds like the library didn't load. But it worked before so I'm not sure about that. What do you see in the XHR requests? You should see one to fetch your data. Try right click/open in new tab and see if you notice a CF error. On Mon, Oct 19, 2009 at 2:33 PM, Arsalan Tariq Keen wrote: > > Camden... > > firebug is saying... > "Ext.ux.grid is undefined > http://127.0.0.1:/ext/ext-all.js > Line 32" > > > any clues? > > > -- > From: "Raymond Camden" > Sent: Monday, October 19, 2009 5:30 PM > To: "cf-talk" > Subject: Re: Problem with JSON Grid | ColdExt > >> >> http://www.insideria.com/2009/06/quick-video-example-of-firebug.html >> >> Enjoy. >> >> On Mon, Oct 19, 2009 at 12:52 AM, Arsalan Tariq Keen >> wrote: >>> >>> Hmmm... Camden, can you guide me about using Firebug... actually I am a >>> newbie to Ajax and I am using IE7, I guess firebug would work with >>> FireFox. >>> >>> -- >>> From: "Raymond Camden" >>> Sent: Monday, October 19, 2009 9:57 AM >>> To: "cf-talk" >>> Subject: Re: Problem with JSON Grid | ColdExt >>> What did Firebug tell you? On Sun, Oct 18, 2009 at 9:59 PM, Arsalan Tariq Keen wrote: > > Dear CFers, > > I am having trouble with the JSON gridpanel using ColdExt. The problem > is... when I feed the grid with JSON generated from CFQUERY with a > simple > SELECT statement without any conditions, it runs fine, however if I add > a > WERE clause then the grid fails to populate even though JSON is > generated. Below is given my CFML code. Can anyone help me with > this > I need urgent support... I m falling short of time for my deadlines > > Also, this gridpanel is displayed within a ExtJS window, so if I use > the > gridSearch plugin with it, than the grid doesn't display at all instead > a > Javascript error is given by the browser. > >>> >>> >> >> > > ~| 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:327339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Variable scope
Does each folder have a different application scope? If so, then unless each application scope has the same name then different session containers will be used within each application. Can you supply us with some more clarity about your setup on a per application level? -Pat On Mon, Oct 19, 2009 at 1:16 PM, Brian Bradley wrote: > > I am writing a security structure and have a session variable that is being > set basically saying loggedIn="y" at the root of the site. In subfolders I > have other application files looking for that variable but not able to find > it. I know that I can write a cookie but was wondering if anyone had any > other ideas on how to get a variable that can be across applications without > setting a cookie (afraid too many users don't allow for cookies)? > > ~| 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:327338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Variable scope
I am writing a security structure and have a session variable that is being set basically saying loggedIn="y" at the root of the site. In subfolders I have other application files looking for that variable but not able to find it. I know that I can write a cookie but was wondering if anyone had any other ideas on how to get a variable that can be across applications without setting a cookie (afraid too many users don't allow for cookies)? ~| 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:327337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam DECREASES performance?
I ran into this old thread while researching cfqueryparam and performance issues. Stephen, Your idea about 2 seperate datasources for unicode and non-unicode queries is useful for some queries. But it does not solve issues with queries where unicode and non-unicode fields are used in same query. In our database, all config/generic tables/fields are varchar. Whereas only fields that can possibly have unicode characters are nvarchar. Now when these tables/fields need to be joined or otherwise used in a single query, I cannot use cfqueryparam (or use cfqueryparam with 'String Format' checked in CFAdmin datasource definition and cause performance issues). The right solution would be for CF to have a datatype called cf_sql_Nvarchar for when you want to specify the datatype as unicode. Have anyone else run into this issue? How have you resolved this? > > Stephen Dupre wrote: > > > The most common reason for this performance problem is: > > > 1) migration from CF5 (unicode datasource setting gets set to > 'true' > > - table scan against varchar - known issue - see #2) > > > 2) having "Enable Unicode for data sources configured for > non-Latin > > characters" ON. > > > isn't that a bit contradictory? why would somebody who needs unicode > turn on unicode but *not* use "N" datatypes? > > Paul, > > Good question. The answer is in point #1. > > >> 1) migration from CF5 (unicode datasource setting gets set to > 'true' - table scan against varchar - known issue - see #2) << > > The CF5->MX MIGRATION that builds the neo-query.xml is supposed to > turn off UNICODE by default. It sets the value to "false". > > Problem is ... the SQL Server driver setting takes either 1 or 0 and > ignores "false"... (bug we can't fix). > > And the default for the unicode param (sendStringParametersAsUnicode) > is 1 (ON). Keep this in mind. > > So what you have with CF5 migrations is > 1) a datasource checkbox for unicode in the CF admin that shows > "UNCHECKED" because the value ('false') doesn't match 1 or 0. > 2) the DEFAULT from the driver getting you (because it doesn't > understand "false") turning unicode ON behind your back. This forces > that implicit conversion of any VARCHAR column query (where > firstname='fred') and throws out indexes. > > The performance sucks and you can't figure it out from the CF end. > > When I hear an immediate performance issue on a migrated (CF5->MX) app > with SQL Server, that's the #1 cause. Most people get around it by > creating another datasource during their investigation and > inadvertantly seeing the problem go away because new datasources have > this unicode setting un-checked (and set to 0). > > In another case, if you have ONE unicode column in the app (NTEXT), > you might use ONE datasource and turn this "unicode" setting "ON" in > the SQL Server datasource but it'll mess up 95% of your other queries > with VARCHARS. (including client variable lookups). You have to be > acutely aware of your datasources with SQL Server and use 2 of them if > you have some mixed unicode/non-unicode queries/INSERTS. > > SQL Server datatype precedence screws you here too. (NVARCHAR higher > than VARCHAR) > > So the moral is: Create 2 datasources with SQL Server JDBC and call > one "_Unicode" and one "_non-unicode" so no one trips over this > problem (or at least they'll ask why you did this before using them). > For client vars, and 95% of your queries, use the non-unicode > datasource. Use the unicode one only when you're absolutely sure the > column is NVARCHAR, NTEXT, etc. > > Stephen Dupre > Adobe Systems, Inc ~| 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:327336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with JSON Grid | ColdExt
Camden... firebug is saying... "Ext.ux.grid is undefined http://127.0.0.1:/ext/ext-all.js Line 32" any clues? -- From: "Raymond Camden" Sent: Monday, October 19, 2009 5:30 PM To: "cf-talk" Subject: Re: Problem with JSON Grid | ColdExt > > http://www.insideria.com/2009/06/quick-video-example-of-firebug.html > > Enjoy. > > On Mon, Oct 19, 2009 at 12:52 AM, Arsalan Tariq Keen > wrote: >> >> Hmmm... Camden, can you guide me about using Firebug... actually I am a >> newbie to Ajax and I am using IE7, I guess firebug would work with >> FireFox. >> >> -- >> From: "Raymond Camden" >> Sent: Monday, October 19, 2009 9:57 AM >> To: "cf-talk" >> Subject: Re: Problem with JSON Grid | ColdExt >> >>> >>> What did Firebug tell you? >>> >>> On Sun, Oct 18, 2009 at 9:59 PM, Arsalan Tariq Keen >>> wrote: Dear CFers, I am having trouble with the JSON gridpanel using ColdExt. The problem is... when I feed the grid with JSON generated from CFQUERY with a simple SELECT statement without any conditions, it runs fine, however if I add a WERE clause then the grid fails to populate even though JSON is generated. Below is given my CFML code. Can anyone help me with this I need urgent support... I m falling short of time for my deadlines Also, this gridpanel is displayed within a ExtJS window, so if I use the gridSearch plugin with it, than the grid doesn't display at all instead a Javascript error is given by the browser. >>> >>> >> >> > > ~| 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:327335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with JSON Grid | ColdExt
Camden... firebug is saying... "Ext.ux.grid is undefined http://127.0.0.1:/ext/ext-all.js Line 32" any clues? -- From: "Raymond Camden" Sent: Monday, October 19, 2009 5:30 PM To: "cf-talk" Subject: Re: Problem with JSON Grid | ColdExt > > http://www.insideria.com/2009/06/quick-video-example-of-firebug.html > > Enjoy. > > On Mon, Oct 19, 2009 at 12:52 AM, Arsalan Tariq Keen > wrote: >> >> Hmmm... Camden, can you guide me about using Firebug... actually I am a >> newbie to Ajax and I am using IE7, I guess firebug would work with >> FireFox. >> >> -- >> From: "Raymond Camden" >> Sent: Monday, October 19, 2009 9:57 AM >> To: "cf-talk" >> Subject: Re: Problem with JSON Grid | ColdExt >> >>> >>> What did Firebug tell you? >>> >>> On Sun, Oct 18, 2009 at 9:59 PM, Arsalan Tariq Keen >>> wrote: Dear CFers, I am having trouble with the JSON gridpanel using ColdExt. The problem is... when I feed the grid with JSON generated from CFQUERY with a simple SELECT statement without any conditions, it runs fine, however if I add a WERE clause then the grid fails to populate even though JSON is generated. Below is given my CFML code. Can anyone help me with this I need urgent support... I m falling short of time for my deadlines Also, this gridpanel is displayed within a ExtJS window, so if I use the gridSearch plugin with it, than the grid doesn't display at all instead a Javascript error is given by the browser. >>> >>> >> >> > > ~| 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:327334 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Another quick update to CFJS
Hey folks, I've made another quick update to the DateFormat function in CFJS. You can read about it on my blog if you like (http://cjordan.us/index.cfm/CFJS). It's at version 1.1.12, and as always is available from http://cfjs.riaforge.org. Cheers! Chris ~| 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:327333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending XML Post via cfhttp
my guess is that you ran out of ideas, thanks anyway for your efforts. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Francois Levesque To: cf-talk Sent: Mon, October 19, 2009 1:36:50 PM Subject: Re: Sending XML Post via cfhttp Oops, forgive the brain fart. XML is a complex value, you need to convert it to a string first. All you need to do is wrap your xml variable with toString() and it should work. Francois Lévesque on the road On 2009-10-19, at 8:31, Anene Isioma Wealth wrote: > > even worse, after removing the cfsave tag, i get this error: > > Complex object types cannot be converted to simple values. > The expression has requested a variable or an intermediate > expression result as a simple value, however, the result cannot be > converted to a simple value. Simple values are strings, numbers, > boolean values, and date/time values. Queries, arrays, and COM > objects are examples of complex values. > The most likely cause of the error is that you are trying to use a > complex value as a simple one. For example, you might be trying to > use a query variable in a tag. This was possible in > ColdFusion 2.0 but creates an error in later versions. > Sincerely, > Chuka I.W. Anene > Chief Software Eng./CEO > Quorium Solutions > www.quorium.org > 07029609185,07032696113 > > > > > > From: Francois Levesque > To: cf-talk > Sent: Mon, October 19, 2009 1:23:54 PM > Subject: Re: Sending XML Post via cfhttp > > > You shouldn't have a cfsavecontent in there. Just use the xml variable > (declared in your cfxml tag) in your cfhttp call. > > Francois L�vesque on the road > > On 2009-10-19, at 8:22, Chuka Anene wrote: > >> >> >> "> >> >> >> >> >> >> 1.0 >> >> SMS >> >> >> >> Quorium >> Anene >> >> >> Q-sms Inc. >> Testing XMl Post >> 1 >> longSMS >> >> >> 2347032696113 >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> This above code gives this error: >> >> An error occured while Parsing an XML document. >> >> Premature end of file. >> >> >> Does anyone have any ideas? >> >> > > > > ~| 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:327332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cflock within Application.cfc?
Thanks, I meant to post the actual error but I guess I forgot. Here it is: Cannot lock SESSION scope. Cannot use cflock to lock the application or session shared scopes without these scopes being established through the use of the cfapplication tag. To use the session scope you need to enable session management. Application and/or Session variables must also be enabled in the ColdFusion Administrator. I do also have session variables enabled in ColdFusion Administrator. Thanks again, - Andrew. >[...] But I didn't see what >error message you're getting from the code. I think you just said it's >failing. Maybe something else will occur to one of us if we know what >error message it's giving you. ~| 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:327331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Tool for Users to build their own Queries
Remember to giver her only SELECT access though and find out what kind of queries she is doing. If she is doing a lot of heavy load/poorly written queries that slow down your server, you might be better off with shipping her a weekly DB backup or something so she can run her queries locally without effecting the production site. Judah On Mon, Oct 19, 2009 at 11:00 AM, Dave Hatz wrote: > > Cameron, > I totally agree with you. I told her the same thing, I mentioned TOAD to her > and she said "is that part of MS Access"? So, I think she has a title with > no clue as to what she is doing, but I get paid to keep her butt happy. > Thanks for you input Cameron, much appreciated. > > And Dan, thanks for the info on SQL Developer, exactly what I can give her, > it looks almost like MS Access :) > > Thanks guys > D ~| 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:327330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Tool for Users to build their own Queries
Cameron, I totally agree with you. I told her the same thing, I mentioned TOAD to her and she said "is that part of MS Access"? So, I think she has a title with no clue as to what she is doing, but I get paid to keep her butt happy. Thanks for you input Cameron, much appreciated. And Dan, thanks for the info on SQL Developer, exactly what I can give her, it looks almost like MS Access :) Thanks guys Dave ~| 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:327329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Tool for Users to build their own Queries
As Dan suggested, you can suggest Oracle SQL Developer to her. Honestly though if she really is a "Data Analyst" and her job is working with data and databases for a living, she is likely to already have a favorite Oracle toolset. YMMV -Cameron On Mon, Oct 19, 2009 at 11:29 AM, Dave Hatz wrote: > Cameron, > Thanks for the info on setting up the user account. My programmers and I > use TOAD for all our Oracle Data access. I am not sure if she will have > the > budget to go out and buy TOAD. Do you know of any other tools on the > market > that she might be able to use? > ~| 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:327328 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cflock within Application.cfc?
Hey Andrew, that sounds like a real tough problem... probably one of those issues that will seem simple in hindsight. :) You covered all the bases that spring to mind for me immediately. But I didn't see what error message you're getting from the code. I think you just said it's failing. Maybe something else will occur to one of us if we know what error message it's giving you. -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| 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:327327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Tool for Users to build their own Queries
I had a situation like this where the client need to generate some numbers for ordering. I did this with MySQL and MS Access so you should (in theory) be able to do this with Oracle. I created a read only account and had them install the MyODBC driver on their machine, Then I had them create a new table in Access then > New > Link Table > ODBC DataBase > Machine Data source > New And then created a data source pointing the MySQL server using the MySQL ODBC Driver and Access pulled in all the tables. >From there they could build and run queries, generate reports, export to Excel etc using a tool that they already knew. It was pretty slick actually. HTH G! On Mon, Oct 19, 2009 at 10:43 AM, Dave Hatz wrote: > > We have a client that has a data analyst on staff and would like access to > some of our tables to build her own data sets. Can I get recommendations > from the CF community on what my choices would be for this? We are running > Oracle Database for their application. > > Thanks, > Dave > > ~| 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:327326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cflock within Application.cfc?
Hi. I've used code like this vastly simplified Application.cfc example for a couple years now, in CF7 and CF8: this.name = "My Application"; this.sessionManagement = true; I can't figure out what else I have changed, but suddenly last week it stopped working on my development server. I've checked this on a number of servers, and the code above just doesn't work (including on a server where the actual live code is running fine). My actual live code cfincludes a page in Application.cfc that actually tries to lock the session scope. I just pulled a known working configuration from svn and updated my development server with that, restarted ColdFusion, and THAT won't work either. This is a standalone 32-bit ColdFusion 8 instance on IIS 6. I'm wondering what in the world I'm missing. Maybe someone else can point out something stupid I'm doing wrong. Thanks, - Andrew. ~| 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:327325 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Tool for Users to build their own Queries
Oracle SQL Developer is a pretty nice program for free. Thank You Dan Vega danv...@gmail.com http://www.danvega.org/ On Mon, Oct 19, 2009 at 11:29 AM, Dave Hatz wrote: > > Cameron, > Thanks for the info on setting up the user account. My programmers and I > use TOAD for all our Oracle Data access. I am not sure if she will have > the > budget to go out and buy TOAD. Do you know of any other tools on the > market > that she might be able to use? > > Dave > > > ~| 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:327324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Tool for Users to build their own Queries
Cameron, Thanks for the info on setting up the user account. My programmers and I use TOAD for all our Oracle Data access. I am not sure if she will have the budget to go out and buy TOAD. Do you know of any other tools on the market that she might be able to use? Dave ~| 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:327323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flash File in Oracle - Retrieving...
As another test, try writing the file out to the server and using cfcontent to serve it instead (then delete it). mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/19 Kim Hoopingarner : > > Anyone have input to this thread? Help... > > Thanks! > > ~| 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:327322 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Tool for Users to build their own Queries
On Mon, Oct 19, 2009 at 10:43 AM, Dave Hatz wrote: > We have a client that has a data analyst on staff and would like access to > some of our tables to build her own data sets. Can I get recommendations > from the CF community on what my choices would be for this? We are running > Oracle Database for their application. > I'd start with creating an Oracle account, restricting it to the minimum access required for the tables in question, and allowing her to use whatever DB tools she normally would. -Cameron ~| 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:327321 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
(ot) Tool for Users to build their own Queries
We have a client that has a data analyst on staff and would like access to some of our tables to build her own data sets. Can I get recommendations from the CF community on what my choices would be for this? We are running Oracle Database for their application. Thanks, Dave ~| 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:327320 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flash File in Oracle - Retrieving...
Anyone have input to this thread? Help... Thanks! ~| 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:327319 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending XML Post via cfhttp
Oh well, it didn't work for me here. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Francois Levesque To: cf-talk Sent: Mon, October 19, 2009 1:57:41 PM Subject: Re: Sending XML Post via cfhttp This doesn't work? I was able to output the string to the screen, so cfhttp should know what to do with it. 1.0 SMS Quorium Anene Q-sms Inc. Testing XMl Post 1 longSMS 2347032696113 Francois Levesque http://blog.critical-web.com/ On Mon, Oct 19, 2009 at 8:48 AM, Anene Isioma Wealth < anene.quor...@yahoo.com> wrote: > > same error bro: > > Error Occurred While Processing Request > Complex object types cannot be converted to simple values. > The expression has requested a variable or an intermediate expression > result as a simple value, however, the result cannot be converted to a > simple value. Simple values are strings, numbers, boolean values, and > date/time values. Queries, arrays, and COM objects are examples of complex > values. > The most likely cause of the error is that you are trying to use a complex > value as a simple one. For example, you might be trying to use a query > variable in a tag. This was possible in ColdFusion 2.0 but creates an > error in later versions. >Sincerely, > Chuka I.W. Anene > Chief Software Eng./CEO > Quorium Solutions > www.quorium.org > 07029609185,07032696113 > > > > > > From: Francois Levesque > To: cf-talk > Sent: Mon, October 19, 2009 1:36:50 PM > Subject: Re: Sending XML Post via cfhttp > > > Oops, forgive the brain fart. XML is a complex value, you need to > convert it to a string first. All you need to do is wrap your xml > variable with toString() and it should work. > > Francois Lévesque on the road > > On 2009-10-19, at 8:31, Anene Isioma Wealth > wrote: > > > > > even worse, after removing the cfsave tag, i get this error: > > > > Complex object types cannot be converted to simple values. > > The expression has requested a variable or an intermediate > > expression result as a simple value, however, the result cannot be > > converted to a simple value. Simple values are strings, numbers, > > boolean values, and date/time values. Queries, arrays, and COM > > objects are examples of complex values. > > The most likely cause of the error is that you are trying to use a > > complex value as a simple one. For example, you might be trying to > > use a query variable in a tag. This was possible in > > ColdFusion 2.0 but creates an error in later versions. > > Sincerely, > > Chuka I.W. Anene > > Chief Software Eng./CEO > > Quorium Solutions > > www.quorium.org > > 07029609185,07032696113 > > > > > > > > > > > > From: Francois Levesque > > To: cf-talk > > Sent: Mon, October 19, 2009 1:23:54 PM > > Subject: Re: Sending XML Post via cfhttp > > > > > > You shouldn't have a cfsavecontent in there. Just use the xml variable > > (declared in your cfxml tag) in your cfhttp call. > > > > Francois L�vesque on the road > > > > On 2009-10-19, at 8:22, Chuka Anene wrote: > > > >> > >> > >> "> > >> > >> > >> > >> > >> > >> 1.0 > >> > >> SMS > >> > >> > >> > >> Quorium > >> Anene > >> > >> > >> Q-sms Inc. > >> Testing XMl Post > >> 1 > >> longSMS > >> > >> > >> 2347032696113 > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> This above code gives this error: > >> > >> An error occured while Parsing an XML document. > >> > >> Premature end of file. > >> > >> > >> Does anyone have any ideas? > >> > >> > > > > > > > > > > > > ~| 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:327318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending XML Post via cfhttp
This doesn't work? I was able to output the string to the screen, so cfhttp should know what to do with it. http://www.infobip.com/AddOn/SMSService/XML/XMLInput.aspx";> 1.0 SMS Quorium Anene Q-sms Inc. Testing XMl Post 1 longSMS 2347032696113 Francois Levesque http://blog.critical-web.com/ On Mon, Oct 19, 2009 at 8:48 AM, Anene Isioma Wealth < anene.quor...@yahoo.com> wrote: > > same error bro: > > Error Occurred While Processing Request > Complex object types cannot be converted to simple values. > The expression has requested a variable or an intermediate expression > result as a simple value, however, the result cannot be converted to a > simple value. Simple values are strings, numbers, boolean values, and > date/time values. Queries, arrays, and COM objects are examples of complex > values. > The most likely cause of the error is that you are trying to use a complex > value as a simple one. For example, you might be trying to use a query > variable in a tag. This was possible in ColdFusion 2.0 but creates an > error in later versions. >Sincerely, > Chuka I.W. Anene > Chief Software Eng./CEO > Quorium Solutions > www.quorium.org > 07029609185,07032696113 > > > > > > From: Francois Levesque > To: cf-talk > Sent: Mon, October 19, 2009 1:36:50 PM > Subject: Re: Sending XML Post via cfhttp > > > Oops, forgive the brain fart. XML is a complex value, you need to > convert it to a string first. All you need to do is wrap your xml > variable with toString() and it should work. > > Francois Lévesque on the road > > On 2009-10-19, at 8:31, Anene Isioma Wealth > wrote: > > > > > even worse, after removing the cfsave tag, i get this error: > > > > Complex object types cannot be converted to simple values. > > The expression has requested a variable or an intermediate > > expression result as a simple value, however, the result cannot be > > converted to a simple value. Simple values are strings, numbers, > > boolean values, and date/time values. Queries, arrays, and COM > > objects are examples of complex values. > > The most likely cause of the error is that you are trying to use a > > complex value as a simple one. For example, you might be trying to > > use a query variable in a tag. This was possible in > > ColdFusion 2.0 but creates an error in later versions. > > Sincerely, > > Chuka I.W. Anene > > Chief Software Eng./CEO > > Quorium Solutions > > www.quorium.org > > 07029609185,07032696113 > > > > > > > > > > > > From: Francois Levesque > > To: cf-talk > > Sent: Mon, October 19, 2009 1:23:54 PM > > Subject: Re: Sending XML Post via cfhttp > > > > > > You shouldn't have a cfsavecontent in there. Just use the xml variable > > (declared in your cfxml tag) in your cfhttp call. > > > > Francois L�vesque on the road > > > > On 2009-10-19, at 8:22, Chuka Anene wrote: > > > >> > >> > >> "> > >> > >> > >> > >> > >> > >> 1.0 > >> > >> SMS > >> > >> > >> > >> Quorium > >> Anene > >> > >> > >> Q-sms Inc. > >> Testing XMl Post > >> 1 > >> longSMS > >> > >> > >> 2347032696113 > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> This above code gives this error: > >> > >> An error occured while Parsing an XML document. > >> > >> Premature end of file. > >> > >> > >> Does anyone have any ideas? > >> > >> > > > > > > > > > > > > ~| 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:327317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sending XML Post via cfhttp
same error bro: Error Occurred While Processing Request Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a tag. This was possible in ColdFusion 2.0 but creates an error in later versions. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Francois Levesque To: cf-talk Sent: Mon, October 19, 2009 1:36:50 PM Subject: Re: Sending XML Post via cfhttp Oops, forgive the brain fart. XML is a complex value, you need to convert it to a string first. All you need to do is wrap your xml variable with toString() and it should work. Francois Lévesque on the road On 2009-10-19, at 8:31, Anene Isioma Wealth wrote: > > even worse, after removing the cfsave tag, i get this error: > > Complex object types cannot be converted to simple values. > The expression has requested a variable or an intermediate > expression result as a simple value, however, the result cannot be > converted to a simple value. Simple values are strings, numbers, > boolean values, and date/time values. Queries, arrays, and COM > objects are examples of complex values. > The most likely cause of the error is that you are trying to use a > complex value as a simple one. For example, you might be trying to > use a query variable in a tag. This was possible in > ColdFusion 2.0 but creates an error in later versions. > Sincerely, > Chuka I.W. Anene > Chief Software Eng./CEO > Quorium Solutions > www.quorium.org > 07029609185,07032696113 > > > > > > From: Francois Levesque > To: cf-talk > Sent: Mon, October 19, 2009 1:23:54 PM > Subject: Re: Sending XML Post via cfhttp > > > You shouldn't have a cfsavecontent in there. Just use the xml variable > (declared in your cfxml tag) in your cfhttp call. > > Francois L�vesque on the road > > On 2009-10-19, at 8:22, Chuka Anene wrote: > >> >> >> "> >> >> >> >> >> >> 1.0 >> >> SMS >> >> >> >> Quorium >> Anene >> >> >> Q-sms Inc. >> Testing XMl Post >> 1 >> longSMS >> >> >> 2347032696113 >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> This above code gives this error: >> >> An error occured while Parsing an XML document. >> >> Premature end of file. >> >> >> Does anyone have any ideas? >> >> > > > > ~| 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:327316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending XML Post via cfhttp
Oops, forgive the brain fart. XML is a complex value, you need to convert it to a string first. All you need to do is wrap your xml variable with toString() and it should work. Francois Lévesque on the road On 2009-10-19, at 8:31, Anene Isioma Wealth wrote: > > even worse, after removing the cfsave tag, i get this error: > > Complex object types cannot be converted to simple values. > The expression has requested a variable or an intermediate > expression result as a simple value, however, the result cannot be > converted to a simple value. Simple values are strings, numbers, > boolean values, and date/time values. Queries, arrays, and COM > objects are examples of complex values. > The most likely cause of the error is that you are trying to use a > complex value as a simple one. For example, you might be trying to > use a query variable in a tag. This was possible in > ColdFusion 2.0 but creates an error in later versions. > Sincerely, > Chuka I.W. Anene > Chief Software Eng./CEO > Quorium Solutions > www.quorium.org > 07029609185,07032696113 > > > > > > From: Francois Levesque > To: cf-talk > Sent: Mon, October 19, 2009 1:23:54 PM > Subject: Re: Sending XML Post via cfhttp > > > You shouldn't have a cfsavecontent in there. Just use the xml variable > (declared in your cfxml tag) in your cfhttp call. > > Francois L�vesque on the road > > On 2009-10-19, at 8:22, Chuka Anene wrote: > >> >> >> "> >> >> >> >> >> >> 1.0 >> >> SMS >> >> >> >> Quorium >> Anene >> >> >> Q-sms Inc. >> Testing XMl Post >> 1 >> longSMS >> >> >> 2347032696113 >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> This above code gives this error: >> >> An error occured while Parsing an XML document. >> >> Premature end of file. >> >> >> Does anyone have any ideas? >> >> > > > > ~| 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:327315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending XML Post via cfhttp
even worse, after removing the cfsave tag, i get this error: Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a tag. This was possible in ColdFusion 2.0 but creates an error in later versions. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Francois Levesque To: cf-talk Sent: Mon, October 19, 2009 1:23:54 PM Subject: Re: Sending XML Post via cfhttp You shouldn't have a cfsavecontent in there. Just use the xml variable (declared in your cfxml tag) in your cfhttp call. Francois Lévesque on the road On 2009-10-19, at 8:22, Chuka Anene wrote: > > > "> > > > > > > 1.0 > > SMS > > > >Quorium >Anene > > >Q-sms Inc. >Testing XMl Post >1 >longSMS > > >2347032696113 > > > > > > > > > > > > > > > This above code gives this error: > > An error occured while Parsing an XML document. > > Premature end of file. > > > Does anyone have any ideas? > > ~| 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:327314 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Webservice exceptions
Hi all, I'm having some issues with server to server data exchange over webservices both running CF8 Ent. Sometimes I get this message: AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: coldfusion.xml.rpc.CFCInvocationException: [java.lang.NullPointerException : null] faultActor: faultNode: faultDetail: { http://xml.apache.org/axis/}stackTrace:coldfusion.xml.rpc.CFCInvocationException: [java.lang.NullPointerException : null] at coldfusion.xml.rpc.CFComponentSkeleton.__createCFCInvocationException(CFComponentSkeleton.java:723) at coldfusion.xml.rpc.CFComponentSkeleton.__invoke(CFComponentSkeleton.java:670) at api.webservers._1_5_0.I18n.getStringByID(. It's not constant, but comes up every now and then and a little bit more with calls that are contain a lot of string data (text columns in the DB) Any idea what might cause it? I already do a try and catch and refresh the XmlRpcService with the ServiceFactory like this -- Michael van Leest E: mvanle...@gmail.com W: http://michaelvanleest.com Yahoo! IM: mvanleest...@yahoo.com MSN IM: mvanlees...@hotmail.com GTalk: mvanle...@gmail.com Skype:mvanleest AIM:mikefromnl ~| 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:327313 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending XML Post via cfhttp
You shouldn't have a cfsavecontent in there. Just use the xml variable (declared in your cfxml tag) in your cfhttp call. Francois Lévesque on the road On 2009-10-19, at 8:22, Chuka Anene wrote: > > http://www.infobip.com/AddOn/SMSService/XML/XMLInput.aspx > "> > > > > > > 1.0 > > SMS > > > >Quorium >Anene > > >Q-sms Inc. >Testing XMl Post >1 >longSMS > > >2347032696113 > > > > > > > > > > > > > > > This above code gives this error: > > An error occured while Parsing an XML document. > > Premature end of file. > > > Does anyone have any ideas? > > ~| 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:327312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sending XML Post via cfhttp
http://www.infobip.com/AddOn/SMSService/XML/XMLInput.aspx";> 1.0 SMS Quorium Anene Q-sms Inc. Testing XMl Post 1 longSMS 2347032696113 This above code gives this error: An error occured while Parsing an XML document. Premature end of file. Does anyone have any ideas? ~| 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:327311 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with JSON Grid | ColdExt
http://www.insideria.com/2009/06/quick-video-example-of-firebug.html Enjoy. On Mon, Oct 19, 2009 at 12:52 AM, Arsalan Tariq Keen wrote: > > Hmmm... Camden, can you guide me about using Firebug... actually I am a > newbie to Ajax and I am using IE7, I guess firebug would work with FireFox. > > -- > From: "Raymond Camden" > Sent: Monday, October 19, 2009 9:57 AM > To: "cf-talk" > Subject: Re: Problem with JSON Grid | ColdExt > >> >> What did Firebug tell you? >> >> On Sun, Oct 18, 2009 at 9:59 PM, Arsalan Tariq Keen >> wrote: >>> >>> Dear CFers, >>> >>> I am having trouble with the JSON gridpanel using ColdExt. The problem >>> is... when I feed the grid with JSON generated from CFQUERY with a simple >>> SELECT statement without any conditions, it runs fine, however if I add a >>> WERE clause then the grid fails to populate even though JSON is >>> generated. Below is given my CFML code. Can anyone help me with this >>> I need urgent support... I m falling short of time for my deadlines >>> >>> Also, this gridpanel is displayed within a ExtJS window, so if I use the >>> gridSearch plugin with it, than the grid doesn't display at all instead a >>> Javascript error is given by the browser. >>> >> >> > > ~| 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:327310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: special/reserved characters
A very quick summary... Use cfqueryparam tags to insert user-provided data into the database. Use the appropriate function (HtmlEditFormat, XmlFormat, UrlEncodedFormat, JsStringFormat) to output user-provided data. These will (should) deal with escaping all reserved characters. If in doubt, use security scanning software to run some thorough tests against your site and verify it is ok before you put it Live. ~| 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:327309 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Space problem with cfpdf
We are using cfpdf with action="processddx". It is working fine. But... at the same time it creates temporary files in: "C:\Documents and Settings\\Local Settings\Temp\" (this is on the dev server) On production they end up in "C:\WINDOWS\Temp\" They look something like this: DESTINATIONFILE#.tmp (# being a number) These files don't get deleted and I have not found a way to specify the temp folder. If I could specify the temp folder we could more easily have a script that deletes the *.tmp files. Anybody had this issue? (the production server has space issues on the c: drive) ~| 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:327308 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4