Yes, it is decreasing speed. but than what is the solution.
for example, in my form ,
I have a textbox in which user will enter client name and then press search.
so I wil get the records on that name like
lcValue = thisform.textsearch.value
select * from client where client!firstname = lcValue
so, in above case it becomes case sensitive. that user has to enter search string in same case in what he entered.
to solve this i am doing this
lcValue = upper(thisform.textsearch.value)
select * from client where upper(firstname) = lcValue
if , not upper should use above then what is the other solution in above case.
Thankuo
johnstill
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement