Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raisor
Starting Member
28 Posts |
 Posted - 2004-07-29 : 10:47:04
|
| Hello everyone,I'm currently trying out the SQL for Threaded Discussion Forums from SQL TEAM and it's AWESOME! (http://www.sqlteam.com/item.asp?ItemID=1353)Only one problem I'm encountering, when displaying the results on my ASP page ofcourse the SPACE is not displayed or anything. Now I could use a replace function in ASP (I think?????) but preferably I would like to have it all in my SQL statement.....can someone guide me in the right direction? How can I have the SPROC print out & nbsp ; 'sTHANKSThe following is the Stored procedure....SELECT Subject = convert(varchar, SPACE(2 * (PostLevel - 1) ) + Subject),PostID,ThreadID,ParentID,PostLevel,SortOrder,PostDate = convert(varchar(19), PostDate, 120)FROM Posts ORDER BY ThreadID, SortOrder |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-07-29 : 10:57:40
|
| USE REPLACE (In SQL)[CODE]SELECT REPLACE(FieldName, ' ', '& nbsp ;')[/CODE]Duane. |
 |
|
|
|
|
|
|
|
SPACE to & nbsp ; - SQL for Threaded Discussion