我有一个这样的查询
select distinct mydb.getprodsizecolor(idProduct,'%color%') as icolor from products
我从我的asp页面调用它并且它工作正常,
我必须将"%color"存储在一个变量中,例如
desc = '%color%'
但是当我像这样执行查询时,它会出错
select distinct mydb.getprodsizecolor(idProduct,desc) as icolor from products
任何人都可以帮忙吗?
查询应采用字符串格式
query = "select distinct mydb.getprodsizecolor(idProduct,'%color%') as icolor from products"
因此,当您在变量中分配值时,您可以尝试这样做
desc = "'%color%'"
query = "select distinct mydb.getprodsizecolor(idProduct,"&desc&") as icolor from products"