Please would you help me to resolv this problem. That is that some search im Database after you chose a group of letters: <<< <form action="anzeige_sort_kunden" method="post"> <TR> <td width="30"> </TD> <TD >alphabetisch</TD> <TD><SELECT NAME="alphabet" SIZE="1" TITLE="Alphabet" STYLE="width:140"> <option value="alle">alle Firmen</option> <option value="A_D">beginnend mit A-D</option> <option value="E_H">beginnend mit E-H</option> <option value="I_L">beginnend mit I-L</option> <option value="M_P">beginnend mit M-P</option> <option value="Q_T">beginnend mit Q-T</option> <option value="U_Z">beginnend mit U-Z</option> </SELECT></TD> </TR>
I have this in web.
And in the ZMethod i have this: select * from iekunde <!--#if "alphabet!='alle'" --> where (substring(firma,1,1)=substring(<!--#var alphabet -->,1,1) or substring(firma,1,1) > substring(<!--#var alphabet -->,1,1)) and (substring(firma,1,1)=substring(<!--#var alphabet -->,3,1) or substring(firma,1,1) < substring(<!--#var alphabet -->,3,1)) <!--#/if --> And the error is this: Error Type: Error Error Value: Error processing select * from iekunde where (substring(firma,1,1)=substring(UuZ,1,1) or substring(firma,1,1) > substring(UuZ,1,1)) and (substring(firma,1,1)=substring(UuZ,3,1) or substring(firma,1,1) < substring(UuZ,3,1)) Invalid column name 'UuZ'. Invalid column name 'UuZ'. Invalid column name 'UuZ'. Invalid column name 'UuZ'. That mean that the operator ">" can only compare two number. So that my question: How can convert substring(UuZ,1,1) ( i mean a string) in a number im zope Method. So can i do: substring(firma,1,1) > substring(UuZ,1,1) or substring(firma,1,1) < substring(UuZ,1,1)) when the two member are comparable(number) Bruno