error in my SQL string LIVE

[jarv]

My SQL code works on my local development machine but not on my LIVE?!

rs.Source = "SELECT `Colour`, tblProductOptions.ID AS ProdOptionsID, tblCustomerOrders.OrderNumber, tblCustomerOrders.qty, tblCustomerOrders.productCode, tblCustomerOrders.option1, tblCustomerOrders.option2, tblProductOptions.Stock FROM tblProductOptions INNER JOIN tblCustomerOrders ON tblProductOptions.ProductID = tblCustomerOrders.productCode WHERE tblCustomerOrders.OrderNumber =" & OldOrderNumber & " AND tblCustomerOrders.option2 LIKE `Colour` AND tblCustomerOrders.option1 LIKE `Size`"


Can someone please help

[abduraooft]

Did you get any error message (or did you turn the error reporting ON at your server) ?

[jarv]

sorry, the way the website is setup, error reporting is not working?!
it's doing my head in!

[Old Pedant]

Show more code.

Show about 20 lines before and 10 lines after the line you showed us.