Results 1 to 3 of 3

Thread: sql command

  1. #1
    Join Date
    Jul 2008
    Posts
    6

    Unanswered: sql command

    Code:
    Dim sql As String = "select * from tblContentMaster where MenuItemIDRef = 5"
          Try
             dr = SqlHelper.ExecuteReader(connectionString, CommandType.Text, sql)

    Hi there...can anybody help me to convert these line of code to MySQL. I am having troubling in the last line... Thanks in advance

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    in mysql, the sql is exactly the same
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    what error message are you getting
    have you checked to make sure that MenuItemIDRef is numeric
    have your tries the SQL in say MySQL query browser to make sure the SQL is valid
    if all those pan pout then its something to do with the way your are calling the SQL which is down to the application language which looks like one of the .NET languages.. so y'd be best off asking the question there
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •