sql

strSQL =  "select 1 as myOrder, * from power where description like '%" & strKeyword(0) & "%' and titel like '%" & strKeyword(0) & "%' and www like '%" & strKeyword(0) & "%'UNION select 2 as myOrder, * from power where description like '%" & strKeyword(0) & "%' or titel like '%" & strKeyword(0) & "%' order by myOrder"

prøv sådan..

//>Rune

strSQL =  "select 1 as myOrder, * from power where description like '%" & strKeyword(0) & "%' and titel like '%" & strKeyword(0) & "%' and www like '%" & strKeyword(0) & "%' UNION select 2 as myOrder, * from power where description like '%" & strKeyword(0) & "%' or titel like '%" & strKeyword(0) & "%' order by myOrder"

Sådan her var det vidst nok!

//>Rune

Jeg har ikke lige prøve, men hvad er der lavet om ??

Dine SQL Functions er alle klasket sammen med resten af syntaxen... Du har fx.

strKeyword(0) & "%'UNION
Det skal være:
strKeyword(0) & "%' UNION

//>Rune

Medions har ret, du mangler en masse blanke.

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 mere 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

hmm, der sker ikke rigtigt mere her, så jeg lukker :-(