def build_query( cnx, TableName, qfields,\
form ) :
###########
q = "Select * from " + TableName
if len( qfields ) > 0 :
q = q + " where "
order = None
for h in qfields :
if order is not None :
q = q + " and "
else :
order = " order by " + h
val = form[ h ]
if h[ -3: ] = "num" :
q = q + h + " " + val
else :
# Faster than a wildcard
# search when indexed ?
q = q + h + " > '" + val\
+ "' and " + h +"\
<'" + val[ :-1 ] +\
chr( ord( val[ -1 ] )\
+ 1 ) + "'"
q = q + order
return q
Copyright © 1994 - 2018 Linux Journal. All rights reserved.