Web Wiz - Solar Powered Eco Hosting

  New Posts New Posts RSS Feed - Location and gender Pull column data
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Location and gender Pull column data

 Post Reply Post Reply
Author
arge24 View Drop Down
Newbie
Newbie


Joined: 07 February 2019
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote arge24 Quote  Post ReplyReply Direct Link To This Post Topic: Location and gender Pull column data
    Posted: 07 February 2019 at 3:10pm
hello

Location and gender 
 I want to show it on the main page. default.asp

How can I do that? Please, help me. 

database : MSSQL used.

web wiz version : 11
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9526
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 07 February 2019 at 3:36pm
Is this for the logged in member of for other members that are displayed on the forum homepage?
Back to Top
arge24 View Drop Down
Newbie
Newbie


Joined: 07 February 2019
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote arge24 Quote  Post ReplyReply Direct Link To This Post Posted: 07 February 2019 at 3:43pm
yes true only  logged user
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9526
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 08 February 2019 at 11:10am
I have checked and this data is not loaded in when the users logs in so there is no easy way to show this data.

You would need to write code that checks if the user is logged in and then queries the database for the data to display.
Back to Top
arge24 View Drop Down
Newbie
Newbie


Joined: 07 February 2019
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote arge24 Quote  Post ReplyReply Direct Link To This Post Posted: 08 February 2019 at 12:25pm
i code write and  gender default.asp i see no problem  but  latest topic error

page down error  

code download : https://ufile.io/7jsom

Error : 


Support Error Code:- err_SQLServer_get_latest_topic_data
File Name:- latest_topics_inc.asp
Forum Version:- 11.08

Code: 
<%
Dim strGender


'Initalise the strSQL variable with an SQL statement to query the database get the thread details
        strSQL = "SELECT " & strDbTable & "Author.* " & _
"FROM " & strDbTable & "Author" & strDBNoLock &  ";"


'Query the database
rsCommon.Open strSQL, adoCon

If NOT rsCommon.EOF Then
'Read in authors detals from the database

strGender = rsCommon("Gender")


End If

'Reset server objects
rsCommon.Close
Call closeDatabase()

%>



Edited by arge24 - 08 February 2019 at 12:31pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9526
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 11 February 2019 at 2:41pm
You are closing the database:

Call closeDatabase()

If 'SQLServer_get_latest_topic_data' is run after your custom code it may be failing as you have close the database connection.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.01
Copyright ©2001-2018 Web Wiz Ltd.


Become a Fan on Facebook Follow us on Twitter Connect with us on LinkedIn Community Forums Web Wiz Blogs Web Wiz News
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-2019 Web Wiz Ltd. All rights reserved.