Updating avatar path SQL command?
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=12924
Printed Date: 03 April 2026 at 10:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Updating avatar path SQL command?
Posted By: PrivateEye
Subject: Updating avatar path SQL command?
Date Posted: 10 December 2004 at 5:55pm
In "forum/includes/select_avatar.asp" file, path of avatars is "forum/inclides/avatar_name.jpg" it works fine when users are registering or editing their profiles but on "forum/forum_posts.asp" page the avatar is not displayed under the username because the path for the avatar, on this page, becomes "forum/forum/includes/select_avatar.asp" and the database entry for all my members is "forum/avatars/avatar_name.jpg" in the "Avatar" field of tblAuthor table. How can I issue an SQL-Update command so that all the enteries with "forum/avatars/avatar_name.jpg" in "Avatar" field are changed with "avatars/avatar_name.jpg". Please help.
-------------
The Judgement Day
|
Replies:
Posted By: ljamal
Date Posted: 10 December 2004 at 11:11pm
why not just change the forum_post.asp to remoe the first instasnce of "forum/"?
-------------
L. Jamal Walton
http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming
|
Posted By: PrivateEye
Date Posted: 12 December 2004 at 1:35pm
wel I think it cannot be implemented because the avatar is displayed
with this variable strAuthorAvatar and it reads value from the database
which is "forum/forum/includes/select_avatar.asp" any other solution ??
-------------
The Judgement Day
|
Posted By: dj air
Date Posted: 12 December 2004 at 4:14pm
the following code should take the first "forum/"
strAuthorAvatar = Trim(Mid(strAuthorAvatar,7,255))
|
if you place that on the forum_posts just under where the veriable is set from the database for each post it should be ok.
|
|