2. ASPRunnerPro General questions
  3. Logos
This topic is locked

Logos

 		10/8/2007 8:13:27 AM
ASPRunnerPro General questions
B
 beebee author

Is it possible to place a logo on the screen dependent on the clients logon details. We have several clients who log on to get information and if we could customise the screen to them it would be great.
Please try to keep it simple if it is possible <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=6445&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' /> my programming isn't great.
Thanks
Chris
Sergey Kornilov admin 10/9/2007

Chris,
you can try to put the following code to include/footer.asp file

<%

set rstmp = Server.CreateObject("ADODB.Recordset")

rstmp.Open "select LogoFile from LoginTable where UserID = '" & Session("UserID") & "'", dbConnection

if not rstmp.eof then

response.write "<img src='" & rstmp("LogoFile") & "'>"

end if

rstmp.close

set rstmp = nothing
%>


Replace text in bold with the actual table and field names.
B
 		beebee author 2/25/2008

Hi
Big delay....
I tried the above code - having chnaged the table and field names and get the following error:-
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/asp/include/footer.asp, line 3
The Code is:-
<%

set rstmp = Server.CreateObject("ADODB.Recordset")

rstmp.Open "select LogoFile from USERS where UserName = '" & Session("UserID") & "'", dbConnection

if not rstmp.eof then

response.write "<img src='" & rstmp("Boarding.jpg") & "'>"

end if

rstmp.close

set rstmp = nothing

%>
Any ideas please??
Thanks
Chris
J
 		Jane 2/28/2008

Chris,
answered in your personal email.