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

    Recordset data 'not retrieving'



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


      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:


      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...