Web Wiz Support and Community Forums : SOME Data not being read from SQL https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 03:30:36 +0000 Tue, 07 Mar 2006 01:21:17 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18629 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SOME Data not being read from SQL : no i havent tried re-running the...]]> https://forums.webwiz.net/some-data-not-being-read-from-sql_topic18629_post100802.html#100802 Author: dunpeal
Subject: 18629
Posted: 07 March 2006 at 1:21am

no i havent tried re-running the script, i will give it a try.
when i query the db in enterprise manager it shows the correct information, so the db seems to be storing the info properly, i checked the computer clock locally and thats fine as well.
 
not trying ot modify anything, just doing testing.
if i your popup_profile.asp file and before the info is stored from the recorset to the local variables i do a response.write, it wont give me an error but at the same time it wont respond with anything...but only for those items that i described in the original post.
 
but if i just create  a test asp file from scratch, create a recordset to pull that same data, it works just fine, all the data comes through.
 
ill try what you suggested and will post back.
]]> Tue, 07 Mar 2006 01:21:17 +0000 https://forums.webwiz.net/some-data-not-being-read-from-sql_topic18629_post100802.html#100802 <![CDATA[SOME Data not being read from SQL : Did you simply try to re-run the...]]> https://forums.webwiz.net/some-data-not-being-read-from-sql_topic18629_post100800.html#100800 Author: michael
Subject: 18629
Posted: 07 March 2006 at 12:12am

Did you simply try to re-run the database script, especially the Stored Procedures? I have not seen this problem before myself so I could only assume that either some scripts are messed up or as it appears to be pertaining to dates, your computer clock is "off".]]> Tue, 07 Mar 2006 00:12:39 +0000 https://forums.webwiz.net/some-data-not-being-read-from-sql_topic18629_post100800.html#100800 <![CDATA[SOME Data not being read from SQL : i downloaded and installed v7.97...]]> https://forums.webwiz.net/some-data-not-being-read-from-sql_topic18629_post100787.html#100787 Author: dunpeal
Subject: 18629
Posted: 06 March 2006 at 4:59pm

i downloaded and installed v7.97 on a test box box yesterday and while configuring and playing around with all the features i noticed that some of data was either not being pulled from the SQL DB or was mysteriously disapearing.
 
i browsed these forums, but was not able to find anything relevant, thus this post.
 
if i was to pull up someones profile it would say that the join date is 1899, but the last visit was the current date. the database shows the join date as yesterday (that when i created these tests accounts)
 
it shows the number of posts as 0...for everyone, even for those that do have posts.
 
it seems also any field that is a boolean is disapearing as well, which is causing problems.
 
it always shows the account status as Not Active
 
on the profile settings, where it asks if you want to display the signature.  it always defaults to no, even after selecting yes and typing something in the signature field and clicking update, it still defaults to no, but does save the signature itself.  if i look at the database the show signature field is set to true, so it should be showing the signature in posts and defaulting to yes in settins.
 
i though maybe it was a problem with the database, so i just wrote a simple test file which queries the author databse and displays the information, and it was all coming through and coming through correctly.  i dought its the forum code, since so many people are using it and i havent been able to find another post related to this, so i am stuck and hope someone can help.
 
has anyone seen these problems, any solutions?
 
Thanks
 
 
]]> Mon, 06 Mar 2006 16:59:34 +0000 https://forums.webwiz.net/some-data-not-being-read-from-sql_topic18629_post100787.html#100787