I have wriiten a Python Script, which runs through a
Webserver. The script generates a form, where the user
feeds data and submits the form. The values submitted
by the user, populates a MySql database.
The problem is:
After submitting the values, the database gets
updated, but an error is generated which is quoted
below, as seen in the browser:
------------------------------------------------
CGI Error
The specified CGI application misbehaved by not
returning a complete set of HTTP headers. The headers
it did return are:
-----------------------------------------------
The Python code is as below:
--------------------------------------------
#!c:\python23\python
import cgi
import sys,os
import string
import MySQLdb
db=MySQLdb.connect(host="localhost",user="root",passwd="",db="power")
cursor=db.cursor()
print "<html>"
print "<head>"
print "</head>"
print "<body>"
s=os.environ['QUERY_STRING']
q=cgi.parse_qs(s)
sname=q['txtname'].pop()
scapacity=q['capacity'].pop()
sstate=q['txtstate'].pop()
sregion=q['region'].pop()
sfre1=q['frequency1'].pop()
sfre2=q['frequency2'].pop()
sfre3=q['frequency3'].pop()
sfre4=q['frequency4'].pop()
cursor.execute("insert into
station(name,region,capacity,state,fre1,fre2,fre3,fre4)
values(%s,%s,%s,%s,%s,%s,%s,%s)",
(sname,sregion,scapacity,sstate,sfre1,sfre2,sfre3,sfre4))
print "</body>"
print "</html>"
-------------------------------------------------
Can any one help me on this??
Ajay Singh
________________________________________________________________________
Yahoo! India Matrimony: Find your partner online.
http://yahoo.shaadi.com/india-matrimony/
_______________________________________________
ilugd mailinglist -- [EMAIL PROTECTED]
http://frodo.hserus.net/mailman/listinfo/ilugd
Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi
http://www.mail-archive.com/[EMAIL PROTECTED]/
