(no subject)

[Robert Mann]

The sql statement returns record in mysql but not valentine

put "SELECT Year_Model FROM yearmodelsize WHERE yearmodelsize.BID='" &
gbrandid & "' and yearmodelsize.stock_specs_complete='no' ORDER BY
Year_Model DESC" into theSQL

 

yet this one work with both

put "SELECT yrmodsize FROM stockvalving WHERE stockvalving.brand='" & gbrand
& "'ORDER BY yrmodsize DESC;" into theSQL2

 

could it be that valentina does not like _  ?

 

Thanks

Rob