Avatar billede loukas Mester
25. januar 2003 - 14:09 Der er 8 kommentarer og
1 løsning

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
Avatar billede stigc Nybegynder
25. januar 2003 - 14:16 #1
udskriv SQL'en, så vi kan sen den som mySQL får den.
Avatar billede stigc Nybegynder
25. januar 2003 - 14:18 #2
UNION er først implementeret i version 4.0, så hvis den er ældre, er det nok her problemet er.
Avatar billede loukas Mester
25. januar 2003 - 14:28 #3
ok, du får lige sql'en.
Og så tjekker jeg min version af mySQL
PS: jeg er ny med mySQL

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"
Avatar billede stigc Nybegynder
25. januar 2003 - 14:30 #4
Jeg vil gerne have SQL'en når den er udfyldt. Lige inden du "Executer" den :)
Avatar billede stigc Nybegynder
25. januar 2003 - 14:32 #5
Du bruger forresten også sub select, hvilket først er med i den helt nye version af mySQL.

http://www.mysql.com/press/release_2003_05.html
Avatar billede loukas Mester
25. januar 2003 - 14:33 #6
Hmmm, OK jeg har hentet og installeret den her:
MySQL 3.23 -- Production release (recommended)

De næste hedder:
MySQL 4.0 -- Gamma release (use this for new development)
MySQL 4.1 -- Alpha release (use this for previewing and testing new features)

Kan du fortælle mig hvad jeg skal bruge ???
Avatar billede loukas Mester
25. januar 2003 - 14:34 #7
OK, altså:
MySQL 4.1 -- Alpha release (use this for previewing and testing new features)
Avatar billede loukas Mester
25. januar 2003 - 14:37 #8
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 '%søgeord%' and titel like '%søgeord%' and www like '%søgeord%')UNION select 3 as myOrder, * from power where titel like '%søgeord%' and www like '%søgeord%' UNION select 4 as myOrder, * from power where titel like '%søgeord%' and description like '%søgeord%'order by myOrder
Avatar billede loukas Mester
22. november 2003 - 22:49 #9
w
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester