cripto9t
Average Member
USA
881 Posts |
Posted - 12 June 2002 : 11:19:52
|
I'd like to add the users quote from thier profile to messages like thier signatures are added with a check box in post_info. The signature is called with this function in function_inc.asp:
function getSig(fUser_Name) '## Forum_SQL strSql = "SELECT M_SIG " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(Request.Form("UserName"), "SQLString") & "'"
set rsSig = my_Conn.Execute (strSql)
if rsSig.EOF or rsSig.BOF then '## Do Nothing else getSig = rsSig("M_SIG") end if
rsSig.close set rsSig = nothing end function
My question is, can this function be modified to call up "quote" instead of "sig"? If so, how? I've tried several different things with no success.
I currently include the quote on the topic.asp but it can't find the check box from there so I have to leave it out. Am I going in the right direction with this? Any help will be appreciated. Thanks
--------Brian. |
|