vb.net Code:
Dim sqlqry2 As String = "SELECT * FROM RSSFeeds ORDER BY NewsID DESC LIMIT " & RSSReturnValue Dim conn2 As Data.OleDb.OleDbConnection = New Data.OleDb.OleDbConnection(My.Settings.DatabaseConnectionString) Dim cmd2 As Data.OleDb.OleDbCommand = New Data.OleDb.OleDbCommand(sqlqry2, conn2) conn2.Open()
My error is "Syntax error in ORDER BY clause."
mysql2 = "SELECT * FROM RSSFeeds ORDER BY NewsID DESC LIMIT 150"
It works on my webserver but not VB how come?




Reply With Quote