|
skynet104
VP-CART New User
94 Posts |
 Posted - October 22 2009 : 14:46:44
|
Before when using version 5.0 I just to have my shopquery.asp modified with the following code, in order to have the search eliminate the commans and spaces or when the first and last name were inverted, however in 6.5 i don't really know how to apply this code, here is the code:
on error resume next
firsttime="TRUE"
SQL = "SELECT * FROM Products "
if Request("wname") <>"" then
wname = request("wname")
fname = mid(wname,1,instr(wname," ")-1)
lname = mid(wname,instr(wname," ") + 1,len(wname))
else
fname = ucase(Request("fname"))
response.write("fname=" & fname & "] <br>")
lname = ucase(Request("lname"))
response.write("lname=" & lname & "] <br>")
end if
sql = "select * from products where hide=0 and cname like '" & lname & "%' and rtrim(cname) like '%" & fname & "'"
'sql = sql & " ORDER BY " & xSortProducts
'response.write ("sql=" & sql & "<br>")
'response.end
end sub
'
SUB AddSQL (strname,strvalue, SQL)
dim fieldtype
strname=Ucase(strname)
CheckValidField strname, rc, fieldtype
if rc>0 then
exit sub
end if
if Fieldtype ="Number" or FieldType="Currency" then
end if
Any Ideas? |
|
All Forums
Customize Search
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
