Print Page | Close Window

Edit posts/quote other user not working

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=8979
Printed Date: 08 April 2026 at 7:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Edit posts/quote other user not working
Posted By: AliasInsider
Subject: Edit posts/quote other user not working
Date Posted: 16 January 2004 at 1:02pm

I'm using the SQL version - everything was working fine until my webhost moved my SQL db to a new server. The site was screwed up for a couple weeks, but they finally got everything working. One of the guys there told me he got my forum working again by using a DSN, but I get no replies from them, so I thought I'd see if anyone here could offer advice.

Since I got back up & running, I can do pretty much everything except when users go to "edit posts" they've already made, the input field is completely blank (so they can't edit anything cause there is nothing there). Also, when you go to "quote" something from someone else's post, the code for quotes ("[quote]") is there, but there is no text between the delimiters. Also, been having problems with Private Messages (can send them, but when I go to open/delete them the page just sits there forever and never works).

Anyone have any advice other than continue to nag my dumb webhost? They suck, and I have a feeling I'll never get a straight answer. :(

Thanks!




Replies:
Posted By: WebWiz-Bruce
Date Posted: 16 January 2004 at 1:13pm
The forum is designed to use a DNS-less OLE connection to the SQL server.

When I was making the forum I did find that if a DSN or other driver was used there is problems like you mention that I couldn't find a way to over come.

Your only solution is to get your hosts to sort out the SQL srever problem so that you can connect to it using the forums default SQL OLE DSN-less driver.


-------------
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: AliasInsider
Date Posted: 16 January 2004 at 3:53pm
Thank you, boRg! I was afraid that was the answer, but I'll fight it out with them some more~


Posted By: JohnKn
Date Posted: 04 May 2004 at 2:17pm
I just did an upgrade to SQL as well and ran into the same problem, however I worked out a solution without having to change the connection string. The connection string I'm using is:

strCon = "Driver={SQL Server};Server={serverName};Database=dbName;trusted_connecti on=true;"
On to the fix...If you move strMessage = rsCommon("Message") from line 153 to line 132 in edit_post.asp (ww version 7.6a), just after you open the record set, it  should solve the problem, it did for me. For whatever reason ASP is losing the value of the variable if it comes later.

It also seems to be a problem only with the standard text editor, if you have the WYSIWYG editor turned on it correctly reads the post into the edit field without having to modify the code since it gets the value in a different manner.

I hope this helps.

John




Posted By: ljamal
Date Posted: 04 May 2004 at 2:50pm
Could this have to do with the order the text is retrieved for the database? I recall there being a problem if a text field from a recordset was stored to variable without the text field being the last field called in the SQL statement.

.... or something like that.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net