Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Email Export
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Email Export

 Post Reply Post Reply
Author
george.digifort View Drop Down
Newbie
Newbie


Joined: 31 October 2012
Location: Australia
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote george.digifort Quote  Post ReplyReply Direct Link To This Post Topic: Email Export
    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
Back to Top
IanSmithISA View Drop Down
Groupie
Groupie


Joined: 21 October 2010
Location: Worcester
Status: Offline
Points: 127
Post Options Post Options   Thanks (0) Thanks(0)   Quote IanSmithISA Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
aussiem8 View Drop Down
Groupie
Groupie


Joined: 23 February 2012
Status: Offline
Points: 55
Post Options Post Options   Thanks (0) Thanks(0)   Quote aussiem8 Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.