[Tutor] PLZ REPLY SOON

[Shalini R]

Hi sir,
 I'm new to python & postgres as I've created a form in html & a
table in postgres. There is a field in form which will take multiple
value the problem which i'm facing is i'm getting single value but
when i want multiple values to be inserted to postgres table it is
not happening
the dtml script is 

<dtml-var standard_html_header>
<form action="callscript">
<table border="1">
<tr><td>Eno</td></tr>
<tr><td>EmpName<td><input type="text"
name="txtEmpName"></td></td></tr>
<tr><td>Facility you want <td><html:multibox property="arrFacility">
<input type="checkbox" name="arrFacility"  value="HRA">HRA</br>
<input type="checkbox" name="arrFacility" value="Travel">Travel</br>
<input type="checkbox" name="arrFacility" value="Food">Food</br>
<input type="checkbox" name="arrFacility"
value="Accomodation">Accomodation</br>

</td></td></tr>


<tr><td>State <td><SELECT  size=4 single  NAME="txtState">
<OPTION value="Delhi">Delhi
<OPTION value="Harayana">Harayana
<OPTION value="UP">UP
<OPTION value="Kerala">Kerala
<OPTION value="J&K">J&K
</SELECT></td></tr>



</table>
<input type="submit" name="submit" value="submit">
</form>

<dtml-var standard_html_footer>

--------------
python script
 

import psycopg
import sys
def add(REQUEST):
        try:
                con=psycopg.connect("dbname=mission2007 user=
postgres")
                cur=con.cursor()
                d=[]
                d.append(REQUEST.get("txtEmpName"))
                d.append(REQUEST.get("arrFacility"))
                d.append(REQUEST.get("txtState"))
                sql1="select max(eno) from empdetail"
                cur.execute(sql1)
                eno=cur.fetchone()
                sql="insert into empdetail (empname,facility,state)
values('"+REQUEST.get("txtEmpName")+"','"+REQUEST.get("arrFacility")+"
','"+REQUEST.get("txtState")+"')"
                return sql
                cur.execute(sql)
                con.commit()
                cur.close()
                con.close()
                return "You had successfully entered data"