Web Wiz Forums Modifications

Print Page | Close Window

Email Export

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=30533
Printed Date: 28 March 2026 at 8:44am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Email Export

Posted By: george.digifort
Subject: Email Export
Date Posted: 31 October 2012 at 5:50am

Hi Guys,

How can I export all the email addresses from my forum?

I have a form with WebWiz and I want to retrieve all my email addresses is it possible?

Regards,

George

Replies:

Posted By: IanSmithISA
Date Posted: 04 November 2012 at 10:42am

Good morning,

As far as I am aware, there isn't a specific module or set of functions for querying the database.

However the database structure is pretty easy to understand, so running a very simple SQL Query from outside of the forum would get you the data that you want.

I use SQL Server Enterprise Manager whenever I want to query databases hosted on Web servers including the forum database without any problems.

Bye

Ian

-------------
Why does anyone need more than an 80x25 character only VDU?

Posted By: aussiem8
Date Posted: 22 January 2013 at 2:51pm

Here's what I use:

db_server = "your server"
db_name = "your db name"
db_username = "your db user name"
db_userpassword = "your db password"

db_connectstr = "Driver={MySQL ODBC 3.51 Driver};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PASSWORD=" & db_userpassword

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open db_connectstr

db_query = "SELECT * FROM tblAuthor"
Set RS = oConn.Execute(db_query)

if not RS.EOF then
while not RS.EOF
response.write RS("Real_name") & ": (" & RS("Author_email") & ")<br>"
RS.movenext
wend
RS.close
end if

Set RS = nothing
Set oConn = nothing