Unsupported Screen Size: The viewport size is too small for the theme to render properly.

how do I create Queries

forums › forums › SQLyog › Using SQLyog › how do I create Queries

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • July 13, 2003 at 6:09 pm #8099
      JohnA
      Member

      HI,

      Hoping someone can help a total newcomer to the world of MySql.

      Previously working in MS Access and using database in Dreamweaver (ASP pages).

      Now having to update to MySql because of multiple connection problems.

      So far I have managed to transfer all data with the help of SQLyog. Have set primary keys and InnoDB for all tables.

      Problem: With the Access Db I had used queries from which the recordsets were derived. What do I do in MySql ? I can copy the query Sql from access into a query window, run the query and it works. I save the query but unable to get at it in Dreamweaver. I can use the tables in Dreamweaver to create a recordset etc but not the query. Please can you point me in the right direction.

      Thanks in advance

      JohnA

    • July 14, 2003 at 3:32 am #14683
      CalEvans
      Member

      Hi John,

      It doesn't work that way with MySQL. In ASP, you use ADO to execute the SQL directly. The result should be your resultset that you work with.

      Sorry Not sure how to relate this to Dreamweaver.

      HTH,

      =C=

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.