Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Python > Python -- CGI -- Take SQL database, make it download in CSV

Reply
Thread Tools

Python -- CGI -- Take SQL database, make it download in CSV

 
 
totalgeekdom@gmail.com
Guest
Posts: n/a
 
      10-31-2005
I currently have a cgi-bin which I use to authenticate users against a
SQL database, which holds info about them, and their login info.

I would like to have the 'admin' section take part of the table and put
it in CSV and allow them to download it, somehow making it so that the
'members' cannot download it.

How it authenticates an admin --
Check User/pass
if correct:
check if-member:
print html-for-members
check if-admin:
print html-for-admins
if incorrect:
print "enter correct creds"


So I would like to have a link in the html-for-admins, that could
re-auth them, and if it's correct allow a download of a csv file of
most of the sql table (I'd like to exclude the md5's )

Does anyone have any ideas on how to do this?

Alex

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
read and write csv file using csv module jliu66 Python 0 10-19-2007 03:12 PM
how to make to transmit the parameters of a cgi between these various pages I would like to use param but I do not see how to make john.swilting Perl Misc 1 03-27-2007 09:46 AM
How to move data from a CSV file to a JTable, and from a JTable to a CSV file ? Tintin92 Java 1 02-14-2007 06:51 PM
Re: csv writerow creates double spaced excel csv files Skip Montanaro Python 0 02-13-2004 08:50 PM
csv writerow creates double spaced excel csv files Michal Mikolajczyk Python 0 02-13-2004 08:38 PM



Advertisments