sql command

reetha · #1 (**permalink**) 07-22-08, 01:33

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

r937 · #2 (**permalink**) 07-22-08, 07:30

in mysql, the sql is exactly the same

healdem · #3 (**permalink**) 07-22-08, 07:52

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

Internet Services

Web Development

Digital Marketing

Consumer Tech