WampServer 2.2 DB PhpMyadmin
parametro = "lote"
Sub Operation
Dim cmd As DBCommand
cmd.Initialize
cmd.Name = "select_chicha"
cmd.Parameters = Array As Object(parametro)
reqManager.ExecuteQuery(cmd, 0, "select")
End Sub
Real query.
sql.select_chicha=SELECT `imagen`, `lote`, `nombre`, `gramaje`, `precio`, `leche`, `azucar`,`instantaneo`, `categoria`, DATE_FORMAT((fecha),'%d/%m/%Y') as 'fecha' FROM `ventaskiana` where categoria = "CHICHA" AND nombre != "CHICHA KIANA" order by ? desc
I have perfect connection with db and all other queries, the only thing is that the filtering does not take it correctly.
ACT: Directly from the db, I make the query without any problem changing (?) by (lote), now I do not know if it distorts the text and therefore does not take it.