>>Why not just run the server on your local machine for development? Absolutely. I don't see any advantage working on files on the server. One would not work on the files on the production server (I hope!). So you need to work on a miror of the application, and still have to update the production server when everything is debugged, so why not your own desk top?
>>Again, wouldn't it be easy to access the BD on your local machine. Actually, the only advantage I see to use RDS is to be able to view the database structure from your CF editor, and generate intelligent SQL code adapted to CF. But again, the SQL builder does not really take advantage of this and the facility to build queries in DW clearly has been designed by some one you never really used CF. - when you want to create an INSERT or UPDATE query, you need to create a record set (SELECT) first... why? - it not only generates the update query, but also the form to get values from user... in the SAME template, this is just ridiculous. What if I don't want the form? - it generates inefficient and stupid code for any VALUE like <CFIF NOT isDefined ("form.columnName") OR form.columnName EQ ""> #form.columnName# <CFELSE> null </CFIF> A much more efficient thing to do would be to omit the column name and let the database take care of the null. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm