Need help with displaying Affiliate name on screen

Afternoon fellow 'carters

I am trying to set up a site for use with the affiliate feature but I want the Affilate company name to display when an affilate link is clicked.

The idea being if someone just arrives on out site it's says one message but if it's an affiliate link it will add their name to the end. I have been using the code below which is a modified version of how I display a logged in customers name on the screen on my main site but having trouble pinning down the fields needed for this to work.

<% if session("IDAffiliate")<>"0" then %>
<% response.write "<h2>&nbsp;&nbsp;In partnership with Landmarq Technologies Limited & " & session("pcSFCompany") & "</h2>" %>
<% else %>
<% response.write "<h2>&nbsp;&nbsp;In partnership with Landmarq Technologies Limited</h2>" %>
 <% end if %>

The IDAffiliate should be able to pick which affiliate is being used and then the company name gets displayed but I cannot get the company name to display or get it to properly detect the difference between a regular vist and an affiliate vist.

Any help on this would be great I'm pretty sure im on the right track but it's the fields tat need tweaking.

Thanks in advance for any replies :)

Hi Hamish,

Thanks for the pointers :)

I thought I might but did not have much luck intially will give it another whirl, I was using newaffa.asp as a reference point to get the table names.

My suggestion is

I solved it (sort of )

I was not winning with the whole sql query thing (need to learn more on that front) but had a flash on inspiration that allows me a touch more flexability albeit with a touch more work.

In my header I now have

      <% if session("idAffiliate")>1 then %>
      <%
      Server.Execute("aff/"&session("idAffiliate")&".asp")
      %>
      <% else %>
        <% response.write "<h2>&nbsp;&nbsp;</h2>" %>  
  <% end if %>

(on the line with &nbsp;&nbsp; you can have a message shown when there is no affiliate set)

Then in my subdir aff/ i have files simply named 2.asp, 3.asp etc . . . which might contain

<% response.write "<h2>In partnership with XYZ Computers</h2>" %>

or

<% response.write "<h2><span style=""vertical-align: bottom;"">In partnership with&nbsp;&nbsp;<img style=""vertical-align: bottom;"" src=images/login.gif></span></h2>" %>

So when an affilate link is parsed the idaffilate becomes the filename and can display either a simple line of text or text/image or anything I fancy in the called .asp file. It work just fine and save a lot of extra database calls on every page load.

If anyone wants to use this code please feel free to help yourself the only thing I found is that if you want to test different affiliates you have to clear the cookies and restart IE or clear private data and select cookies in Firefox other wise the first affiliate used will override all subsequent affiliates. There is meant to be an option in the settings to change this behaviour but could not see it on 3.51