If $SQL[$z][1] = "a" Or "b" Or "c" Or "d" Or"e" Or "f" then

[butterfly]

It seems because I do not have proper education in this field i make big beginner mistakes

 

my 2d array has 40.000 items from 2 tables which needs to combined and all works flawless

 

but i want to filter out for lets say 25 pre defined names , which i prefer to type out

i am trying to do the follow but it does not work

If $SQL[$z][1] = "abb" Or "bbb" Or "cbb" Or "dbb" Or "ebb" Or "fbb"  then
        If $CSQL[$z][5] = "T" Then
                     $lineskip = True
(code)
MsgBox(0, "", $z & "True")
elseif
If $CSQL[$z][5] = "F" Then
$lineskip = False
(code)
MsgBox(0, "", $z & "False" )
endif

How to make this work? and what is best practice? a tiny bit of background would also help me a lot

I am very sorry for such a horrible starters question

Edited February 19, 2014 by butterfly

[water]

Either something like this or use Switch for multiple values:

If $SQL[$z][1] = "abb" Or $SQL[$z][1] = "bbb" Or $SQL[$z][1] = "cbb" Or $SQL[$z][1] = "dbb" Or $SQL[$z][1] = "ebb" Or $SQL[$z][1] = "fbb" Then
    If $CSQL[$z][5] = "T" Then
        $lineskip = True
        ; (code)
        MsgBox(0, "", $z & "True")
    ElseIf $CSQL[$z][5] = "F" Then
        $lineskip = False
        ; (code)
        MsgBox(0, "", $z & "False")
    EndIf
EndIf

[JLogan3o13]

Someone will undoubtedly be along to tell me my regex-fu sucks (which it does), but I would think you could do something like this if you are only trying to match a few patterns:

#include <Array.au3>

Local $SQL[6][2]
    $SQL[0][0] = "5"
    $SQL[0][1] = ""
    $SQL[1][0] = "Line 1"
    $SQL[1][1] = "aaa"
    $SQL[2][0] = "Line 2"
    $SQL[2][1] = "bbb"
    $SQL[3][0] = "Line 3"
    $SQL[3][1] = "fff"
    $SQL[4][0] = "Line 4"
    $SQL[4][1] = "ggg"
    $SQL[5][0] = "Line 5"
    $SQL[5][1] = "hhh"


For $i = 1 To $SQL[0][0]
    If StringRegExp($SQL[$i][1], "abb|bbb|cbb|dbb|ebb|fbb") Then
        MsgBox(0, $SQL[$i][0], "Matches pattern, do something here.")
    Else
        MsgBox(0, $SQL[$i][0], "Doesn't match pattern, do something else")
    EndIf
Next

[bogQ]

or something like this

$string = '|abb|bbb|cbb|dbb|ebb|fbb|'
If StringInStr($string, '|' & $SQL[$z][1] & '|') Then
    If $CSQL[$z][5] = "T" Then
        $lineskip = True
        ; (code)
        MsgBox(0, "", $z & "True")
    ElseIf $CSQL[$z][5] = "F" Then
        $lineskip = False
        ; (code)
        MsgBox(0, "", $z & "False")
    EndIf
EndIf

[water]

A Switch example:

Switch $SQL[$z][1]
    Case "abb", "bbb", "cbb", "dbb", "ebb", "fbb"
        If $CSQL[$z][5] = "T" Then
            $lineskip = True
            ; (code)
            MsgBox(0, "", $z & "True")
        ElseIf $CSQL[$z][5] = "F" Then
            $lineskip = False
            ; (code)
            MsgBox(0, "", $z & "False")
        EndIf
    Case Else
        MsgBox(0, "", "Not Found")
EndSwitch

[butterfly]

Thank you very much, for the mulitple solutions, I was thinking of making an array while i was on the bike doing groceries, But i like the solution of water for now (I do not need more then 10 names)

thank you very much again

[water]

[jchd]

 

my 2d array has 40.000 items from 2 tables which needs to combined and all works flawless

but i want to filter out for lets say 25 pre defined names , which i prefer to type out

This attracts two sideways remarks which may not be valid but who knows?

First you can join tables in SQL queries even if tables come from two DBs, in which case you can attach the second one to the first (you may be using that already).

Second, rather than filtering out unwanted data from a large dataset you can specify where conditions to avoid getting them in the resultset. Again this may not be valuable in your specific use case.

[kylomas]

butterfly,

An example of what jchd is alluding to.  Better to let the DB engine do the work for you...

expandcollapse popup

#include <sqlite.au3>

;---------------------------------------------------------------------------------------
; initialize SQLite, open DB and declare some common variables
;---------------------------------------------------------------------------------------

_SQLite_Startup()

If @error Then
    ConsoleWrite('error loading sqlite.dll' & @LF)
    Exit
EndIf

Local $hDB = _SQLite_Open(':memory:')

If @error Then
    ConsoleWrite('Unable to open DB' & @LF)
    _exit()
EndIf

OnAutoItExitRegister("_exit")

Local $ret, $rows, $nbrows, $nbcols, $sqlstr

;---------------------------------------------------------------------------------------
; create two tables and load some data
;---------------------------------------------------------------------------------------

$ret = _SQLite_Exec($hDB, 'create table if not exists T1 (Col1, Col2, Col3, Col4); create table if not exists T2 (Col1,Col2);')
If $ret <> $SQLITE_OK Then
    MsgBox(0, 'ERROR', 'Create table error')
    _exit()
EndIf

$sqlstr = _
        'insert into T1 values("abb","","","");' & _
        'insert into T1 values("bbb","","","");' & _
        'insert into T1 values("cbb","","","");' & _
        'insert into T1 values("dbb","","","");' & _
        'insert into T1 values("ebb","","","");' & _
        'insert into T1 values("fbb","","","");' & _
        'insert into T2 values("abb","T");' & _
        'insert into T2 values("bbb","T");' & _
        'insert into T2 values("cbb","F");' & _
        'insert into T2 values("dbb","T");' & _
        'insert into T2 values("ebb","T");' & _
        'insert into T2 values("fbb","F");'

$ret = _SQLite_Exec($hDB, $sqlstr)

If $ret <> $SQLITE_OK Then
    MsgBox(0, 'ERROR', 'Insert table error')
    _exit()
EndIf

;  the "where...in" clause uses the DB engine to filter the data.

$sqlstr = ' select T1.Col1, T2.Col2 from T1, T2 ' & _
        '      where T1.Col1 = T2.Col1 and T1.Col1 in ("cbb","dbb");'

$ret = _SQLite_GetTable2d($hDB, $sqlstr, $rows, $nbrows, $nbcols)

If @error Then
    ConsoleWrite("!>  Error getting Data" & @LF)
    _exit()
EndIf

_ArrayDisplay($rows)

Func _exit()
    _SQLite_Close()
    _SQLite_Shutdown()
    Exit
EndFunc   ;==>_exit

kylomas