2 Replies Latest reply on Mar 23, 2010 3:45 PM by mickster0001

    Recordset data 'not retrieving'

    mickster0001

      Hi,

           I'm following a 'Building your first dynamic website' tutorial

      (Tutorial: http://192.150.8.60/devnet/dreamweaver/articles/first_dynamic_site_pt1.html)

      for which all Dreamweaver files are supplied, and when I get to creating a 'Recordset' and selecting the required table

      the table data (which has been supplied/created) doesn't appear.

      (Recordset section: http://192.150.8.60/devnet/dreamweaver/articles/first_dynamic_site_pt2_03.html)

       

      When I click the test button I get a 'MySQL Error 1142 – SELECT command denied to user 'user'@'localhost' for table 'tablename'.

      However when I click the 'define' button, the connections for the site dialogue box appears and when I edit the table and test it through the MySQL Connection dialogue I get a 'Connection successful' message.

      I assume it's to do with permissions, of sorts?

       

      Any guidance greatly appreciated,

       

      Many thanks in advance...