sql fejl ??
Det jeg synes er mærkeligt er at,den virker på en ACCESS DB, men på mySQL giver den en fejl ????
I får lige lidt kode her:
strTest = TRIM(Request.Form("Keyword"))
strKeyword = split(Trim(Request.Form("Keyword")), " ")
Select Case UBound(strKeyword)
Case "0"
Response.Write "1 ord"
strSQL = "select 1 as myorder, * from power where description like '%" & strTest & "%' and titel like '%" & strTest & "%' and www like '%" & strTest & "%' UNION select 2 as myorder, * from power where description like '%" & strTest & "%' and titel like '%" & strTest & "%' AND 1 NOT IN (select 1 as myorder from power where description like '%" & strTest & "%' and titel like '%" & strTest & "%' and www like '%" & strTest & "%')UNION select 3 as myOrder, * from power where titel like '%" & strTest & "%' and www like '%" & strTest & "%' UNION select 4 as myOrder, * from power where titel like '%" & strTest & "%' and description like '%" & strTest & "%'order by myOrder"
Case "1"
Response.Write "2 ord"
strSQL = "select 1 as myOrder, * from power where description like '%" & strTest & "%' and titel like '%" & strTest & "%' UNION select 2 as myOrder, * from power where description like '%" & strTest & "%' UNION select 3 as myOrder, * from power where description like '%" & strKeyword(0) & "%' and description like '%" & strKeyword(1) & "%'UNION select 4 as myOrder, * from power where description like '%" & strKeyword(0) & "%' OR description like '%" & strKeyword(1) & "%' order by myOrder"
Case "2"
Response.Write "3 ord"
strSQL = "select 1 as myOrder, * from power where description like '%" & strTest & "%' UNION select 2 as myOrder, * from power where description like '%" & strKeyword(0) & "%' and description like '%" & strKeyword(1) & "%' and description like '%" & strKeyword(2) & "%' UNION select 3 as myOrder, * from power where description like '%" & strKeyword(0) & "%' and description like '%" & strKeyword(1) & "%' order by myOrder" '3 ord i søgningen
Case Else
Response.Write "3 ord"
strSQL = "select 1 as myOrder, * from power where description like '%" & strTest & "%' UNION select 2 as myOrder, * from power where description like '%" & strKeyword(0) & "%' order by myOrder" 'mere end 3 ord i søgningen
End Select
Fejlen:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 3.51 Driver][mysqld-3.23.54-nt]You have an error in your SQL syntax near '* from power where description like '%asp%' and titel like '%asp%' and www like ' at line 1
/mySQL/search/search.asp, line 107
