Web Wiz Forums - Location and gender Pull column data

Print Page | Close Window

Location and gender Pull column data

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=31597
Printed Date: 29 March 2026 at 1:29pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Location and gender Pull column data

Posted By: arge24
Subject: Location and gender Pull column data
Date 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

Replies:

Posted By: WebWiz-Bruce
Date 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?

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: arge24
Date Posted: 07 February 2019 at 3:43pm

yes true only logged user

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: arge24
Date 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()

Posted By: WebWiz-Bruce
Date 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.