J
|
Jane 12/11/2006 |
Steve, Sub ListOnLoad() '** Custom code **** ' put your custom code here str = "select FieldName1, FieldName2 from [Reps]where UserName='" & Session("UserID") &"'" Set rsTemp = server.CreateObject("ADODB.Recordset") rsTemp.open str, dbConnection Response.write "Representative Name " &rsTemp("FieldName1") &" " Response.write "Email address " &rsTemp("FieldName2") &" " End Sub
|
S
|
SDDivine author 12/11/2006 |
Steve, here is a sample code: where FieldName1, FieldName2 are your actual field names of Representative Name and Email address fields. UserName is your actual field name where user name is stored.
|
J
|
Jane 12/12/2006 |
Steve, Sub ListOnLoad() '** Custom code **** ' put your custom code here str = "select [REPNAME], [R-email] from [reps] where [R-Login]='" & Session("UserID") &"'" Set rsTemp = server.CreateObject("ADODB.Recordset") rsTemp.open str, dbConnection Response.write "Representative Name " &rsTemp("REPNAME") &" " Response.write "Email address " &rsTemp("R-email") &" " End Sub |
S
|
SDDivine author 12/20/2006 |
ANOTHER QUESTION PLEASE.... Steve, this error occurs because you use incorrect characters in the field names in your SQL query. Use [] brackets for these field names: |
J
|
Jane 12/21/2006 |
Steve, Response.write "<FONT style="FONT-FAMILY: courier; COLOR: #cc3300;">Representative Name " &rsTemp("REPNAME") &"</FONT> Response.write "<FONT style="FONT-FAMILY: Arial; COLOR: #333333;">Email address " &rsTemp("R-email") &"</FONT> "
|
S
|
SDDivine author 12/25/2006 |
THANK YOU VERY MUCH! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=14071&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> |