cfquery and json

2012-01-10 Thread Tom Small
Hi I am new to coldfusion 9 and extjs 4 and like to know how to pass a cfquery to a mysql table, and then covert the data to json to populate a grid.. Would appreciate some help on this matter also if there are any tutorials for newbies. Thanks

Re: cfquery and json

2012-01-10 Thread John M Bliss
Start here and let us know if you have any trouble: http://www.cfscreencast.com/2007/12/6/retrieving-data-from-mysql-using-cfquery/ http://www.coldfusion-ria.com/Blog/index.cfm/2009/12/14/ExtJS-30-Editor-Grid-with-ColdFusion (I didn't see an ExtJS 4 example on Google. Perhaps 3 will work for

Re: cfquery and json

2012-01-10 Thread Tom Small
Thanks for your assistance ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Extjs4

2012-01-10 Thread Tom Small
Hi, I have built a grid panel via extjs4 and want to link the data store to a mysql table, which is stored locally on my machine. Is there any examples for newbie that will walk me through how to achieve this? thanks Tom

extjs4 designer

2012-01-10 Thread Tom Small
Hi, I have built a grid panel via extjs designer and want to link the data store to a mysql table, which is stored locally on my machine. Is there any examples for newbie that will walk me through how to achieve this? thanks Tom

Convert php to cfm

2012-01-10 Thread Tom Small
Hi, I need to convert php to coldfusion. Would appreciate some help, thanks ?php #First we include our credentials file # FileName=connect.php $hostname = localhost; $database = nimsoftslmdev; $username = root; $password = xxx; #And now we connect to the database //connection String

RE: Convert php to cfm

2012-01-10 Thread Edward Chanter
This seems like a pretty straightforward conversion. Create the datasource in the CF admin to point to MySQL and then simply write a cfquery with the same basic syntax as is used in the PHP. Specify maxrows=200 and then cfoutput it via json to your datastore. I might be missing something but it

Re: Convert php to cfm

2012-01-10 Thread Andrew Scott
Wow, and I wonder at times why PHP is so popular... Not being a Guru at PHP what you are trying to convert here is very simple, and this is not tested but as close to being right as I can think. cfquery name=result datasource= username=#username# passwqord=#password# SELECT nimid, level,

Re: Convert php to cfm

2012-01-10 Thread Phillip Vector
On Tue, Jan 10, 2012 at 8:01 AM, Andrew Scott andr...@andyscott.id.au wrote: Wow, and I wonder at times why PHP is so popular... Because it is cheaper to run it.. Nevermind the fact that you are paying developers allot more (as in, it takes more time) to code in PHP. :) Note the Sarcasm of

RE: Convert php to cfm

2012-01-10 Thread Edward Chanter
-Original Message- Wow, and I wonder at times why PHP is so popular... My thought too, this is a great example of why I love CF over PHP :) ~| Order the Adobe Coldfusion Anthology now!

Re: Convert php to cfm

2012-01-10 Thread Tom Small
Hi Andrew, thanks for your help and advice ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Rialo or Open Blue Dragon

2012-01-10 Thread Larry Lyons
here's the link to the tomcat based installers for Railo and OBD. Both of these install on IIS. More information here: http://www.viviotech.net/company/installers.cfm but I've installed the OBD one on several servers and found no problems. One of the easiest installs I've done. hth, larry

Troubleshooting slow web service calls

2012-01-10 Thread fun and learning
I have a web service created in coldfusion, and consumed from a coldfusion page. The problem is that the web service call is very fast in development environment, where as its very very slow in production environment. What is the best way to go about troubleshooting what is causing the problem?

Re: Troubleshooting slow web service calls

2012-01-10 Thread Michael Stemle
I would approach this by writing a test against the webservice, and then throwing a little bit of benchmarking code into the procedures you call. That should give you some sort of idea as to which parts of the procedure are running slower than expected. On Tue, Jan 10, 2012 at 15:39, fun and

anyone using ckeditor? I will PAY you for your help!

2012-01-10 Thread Torrent Girl
Hi All I have had a year long headache with ckeditor and it changing my CF code. I got around the issue for a while by using a straight text area to enter code in the DB. Now other users will be using the system and I need to get the text editor to work. I STILL have not been able to figure

Re: anyone using ckeditor? I will PAY you for your help!

2012-01-10 Thread Mike Kear
Are you trying to enter CF code into the editor and expect it to come through intact? There is quite a community of tech-savvy users on the CKEditor forum - have you checked there? It includes some CF people. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion

Re: anyone using ckeditor? I will PAY you for your help!

2012-01-10 Thread Russ Michaels
both ckeditor and TinyMCE have filters to disallow.remove dangerous tags and content. If you are using the editor to edit CFML code, then it would get changed. So you need to change the default settings. The easiest way would be to just set it to allow everything, or set the disallow list to

Re: anyone using ckeditor? I will PAY you for your help!

2012-01-10 Thread Dean Lawrence
You should take a look at the protectedSource method in the config settings (http://docs.cksource.com/ckeditor_api/symbols/CKEDITOR.config.html#.protectedSource). This allows you to use regular expressions to specify which tags should not be affected by the editor. On Tue, Jan 10, 2012 at 7:51