so im trying to build something that searches a SQLite database. there are multiple search fields and i'd like to support the sql wild card "%"
the method im using is making this very very long - probably can be done much shorter/efficient
if $field1 <> "" and $field2 = "" and $field3 = "" and $field4 = "" then _SQLite_QuerySingleRow(-1, "SELECT field2,field3,field4 WHERE field1='" & $field1_input & "'", $aRow) endif
that in itself will take several lines considering all the combinations and even more so when I consider the wildcards which changes the conditions AND sqlquery also (LIKE "%field_input")
there's gotta be an efficient way to do this...
thanks in advance