{"id":334,"date":"2012-01-23T22:49:32","date_gmt":"2012-01-24T03:49:32","guid":{"rendered":"http:\/\/www.cfchimp.com\/wordpress\/?p=334"},"modified":"2024-12-05T19:46:11","modified_gmt":"2024-12-06T00:46:11","slug":"rds-query-viewer-not-working","status":"publish","type":"post","link":"https:\/\/csimmons.dev\/blog\/2012\/01\/rds-query-viewer-not-working\/","title":{"rendered":"RDS Query Viewer not working: How to fix the ColdFusion Builder error: ‘\/YOURPROJECTFOLDER\/.rdsTempFiles\/RDS Query Viewer’ does not exist"},"content":{"rendered":"

I have had this issue for a while and it finally made me crazy enough to try to figure it out. It appears that this error occurs when the “RDS Query Viewer” file does not exist in the .rdsTempFiles folder within your project.<\/p>\n

On Mac<\/strong><\/p>\n

    \n
  1. Open Terminal<\/li>\n
  2. Navigate to the directory where your project is located. For example type: cd \/Applications\/ColdFusion9\/wwwroot\/YOURPROJECTFOLDER<\/em> and hit <enter><\/li>\n
  3. If the “.rdsTempFiles” directory does not exist type: mkdir .rdsTempFiles<\/em> and hit <enter><\/li>\n
  4. If the “RDS Query Viewer” file does not exist type: touch “.rdsTempFiles\/RDS Query Viewer”<\/em> and hit <enter>. BE SURE TO SURROUND THE COMMAND WITH THE DOUBLE QUOTES BECAUSE THE FILE NAME HAS SPACES.<\/li>\n
  5. Refresh the “RDS Query Viewer” view. RDS Query View should work now.<\/li>\n<\/ol>\n

    On Windows<\/strong><\/p>\n

      \n
    1. Open DOS<\/li>\n
    2. Navigate to the directory where your project is located. For example type: cd C:\\ColdFusion9\\wwwroot\\YOURPROJECTFOLDER <\/em>and hit <enter><\/li>\n
    3. If the “.rdsTempFiles” directory does not exist type: mkdir .rdsTempFiles\\rdsTempFiles<\/em> and hit <enter><\/li>\n
    4. If the “RDS Query Viewer” file does not exist type: fsutil file createnew “RDS Query Viewer” 0<\/em> and hit <enter>. BE SURE TO SURROUND THE COMMAND WITH THE DOUBLE QUOTES BECAUSE THE FILE NAME HAS SPACES.<\/li>\n
    5. Refresh the “RDS Query Viewer” view. RDS Query View should work now.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      I have had this issue for a while and it finally made me crazy enough to try to figure it out. It appears that this error occurs when the “RDS Query Viewer” file does not exist in the .rdsTempFiles folder within your project. On Mac Open Terminal Navigate to the directory where your project is … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_cloudinary_featured_overwrite":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[68],"tags":[32,48],"class_list":["post-334","post","type-post","status-publish","format-standard","hentry","category-developer","tag-cfbuilder-coldfusion","tag-coldfusion"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pbVg43-5o","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts\/334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/comments?post=334"}],"version-history":[{"count":0,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts\/334\/revisions"}],"wp:attachment":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/media?parent=334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/categories?post=334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/tags?post=334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}