60 Affiliate codes from one form. (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

mfalk -> 60 Affiliate codes from one form. (4/30/2003 10:00:07)

Hi, thank god for this place..lol.

We' re giving an affiliate, which is an association an affiliate number, and a form to fill out that goes to our database.

The affiliate number will be say L1000100. The affiliate is an association with 60 companies as members. Each with their own website. I want to identify each individual company. I can make it so they all are identified by the affiliate number, but i need then to give each of the 60 companies their own four digit number to identify where the order comes from.

How do i do this? My quick and simple thought was a simple blank field saying, enter your discount or association code here and give them each their own 4 digit number. Is there a way to identify each one and where it is coming from automatically? Would it be possible to create a field that is filled in in a hidden field automatically based on a link?

thanks in advance. (does anyone else have the " we need it today" thing going on when everyone else has been workign it for weeks? lol..).

so little time, so many " all you have to do is" ' s...

Mark



BeTheBall -> RE: 60 Affiliate codes from one form. (4/30/2003 10:48:05)

Huh?

Mark, I read and reread your post several times, but am not sure what you are asking. What is the purpose of your site and database? From what I do understand, it sounds like you just need a simple db table titled " Companies" or whatever. And then have fields such as Comp_Name and Affil_Number. Since your affiliate number would be a unique ID, it should be your primary key.

quote:

How do i do this? My quick and simple thought was a simple blank field saying, enter your discount or association code here and give them each their own 4 digit number. Is there a way to identify each one and where it is coming from automatically? Would it be possible to create a field that is filled in in a hidden field automatically based on a link?


All of the above things are possible, but without a better understanding of what you are doing it is impossible to tell you how.



mfalk -> RE: 60 Affiliate codes from one form. (4/30/2003 10:50:22)

its an order database. what i need is something that identifies where the person is coming from. the main id would be the affiliate number. the affiliate gives their members unique numbers. i want to identify those unique numbers when they place a request.

Mark



BeTheBall -> RE: 60 Affiliate codes from one form. (4/30/2003 10:58:12)

So do you know what the unique IDs are or does the client have to supply them? Are they constant? In other words does each client always have the same ID or does it change?



mfalk -> RE: 60 Affiliate codes from one form. (4/30/2003 11:21:08)

our client gives them each their own identifier.

my database is already setup. are you saying i should have a second table or database for this purpose? I want to identify them in the current database if i can. the form that is used updates my current database. Im looking to add a field if possible that will be filled in automatically when soemone come on from a particular site, probably from a unique link that would identify who they are.

if possible.

mark



BeTheBall -> RE: 60 Affiliate codes from one form. (4/30/2003 11:28:53)

OK, I think I am getting closer to understanding your situation. My question is still this: Do you know the unique identifiers? Are they already in your DB? You mentioned in your initial post that each company has its own website. Are you hoping to have your site recognize the user based on the website they came from? Does each company have a link to your site on theirs? If so, the link could be changed to something like http://yoursite/yourpage.asp?UniqueID=" UniqueID. So if Company A' s ID is 1458, the link from their site to yours would be http://yoursite/yourpage.asp?ID=1458.

Am I on the right track?



mfalk -> RE: 60 Affiliate codes from one form. (4/30/2003 11:30:50)

on the money...so how do i show the request is from 1458?

i appreciate your help with this. you da man.

Mark



mfalk -> RE: 60 Affiliate codes from one form. (4/30/2003 11:32:28)

oh, and no, these identifiers are not in the database. I want them to be filled out from the link. such as the 1458. if i comes from that site, with that link, i want that field to indicate where it came from.




BeTheBall -> RE: 60 Affiliate codes from one form. (4/30/2003 11:46:36)

I have had about half a bottle of Coke, but am still not quite with it. Back to the issue of the identifiers. Is company A' s number always going to be the same, such as 1458? Second, tell me about the page they are linking to. When a user clicks the link from their site to yours, what is on the page they are directed to? I still don' t understand the whole process. I understand there are 60 companies. Are they your only clients? I guess I need kind of a step by step overview of what needs to happen.



mfalk -> RE: 60 Affiliate codes from one form. (4/30/2003 11:51:40)

sorry for the confusion.

we have an affiliate. they have their own identifier. not even worried aboutt aht part. a person clicks on a link on a site, goes directly to our order request page and fills out name, address, and about twenty other fields. I want to say, hmmm...john came from 1458. they come from another site, directly to our quote page (asp). that quote page sends the info to our database. when that page is filled out, i want it to automatically fill in a field showing where they came from.

thanks again...i' ll buy the next coke.

mark



BeTheBall -> RE: 60 Affiliate codes from one form. (4/30/2003 13:20:11)

Now I think I know what you want to do, unfortunately, I think we' ll need some of the " real" experts to tell us how. You want to capture the URL of the referring website. I know this can be done, but not quite sure how. I am not sure how this relates to the 4-digit code you mentioned, but what I would do is post a new question in this forum phrased like this:

" I have a page on my site that contains an order form. There are approximately 60 websites that have links to this page. I need to capture the referring site' s URL and submit it to my DB with the other fields in my order form. How can I do this?"

I am guessing rdouglass or Spooky will know how to do this. My site is on an intranet and I have never had a need to capture the referrer.



mfalk -> RE: 60 Affiliate codes from one form. (4/30/2003 13:24:33)

actually no. sorry. i think maybe i overstated or explained.

simply put. i want to identify someone placing a request taht comes from a particular site. giving the site a unique number that would automatically be placed in a hidden field on my form.

thanks..

Mark



BeTheBall -> RE: 60 Affiliate codes from one form. (4/30/2003 15:00:04)

I' m sorry Mark, but you' ve lost me. A user, on another website clicks a link that takes them to your order (quote) form, right? Then, you want to know what site they came from? or, at least, what company they are with. I don' t see how you can get that information automatically without capturing the referring address or by having them provide that information in the quote form.

I apologize if I am just not " getting it" .



Spooky -> RE: 60 Affiliate codes from one form. (4/30/2003 16:10:29)

If the user was coming directly to the order form from a link, they would use :

orderpage.asp?AffID=1234

Then, on order page you would use :
<input type=hidden name=AffID value=" <%=Request(" AffID" )%>" >

However, what if they dont use a link? how do you know where they are coming from or if they are valid?




mfalk -> RE: 60 Affiliate codes from one form. (4/30/2003 16:18:56)

Spooky, thanks, thats pretty much what i needed and thought it was something along those lines but couldnt figure it out so figured id ask.

well, we will give them their own order page for the association. if an order comes from that page, it will identify it is from the association by an affiliate number in a hidden field. it is up to the associations clients who have the web sites the link will come from to put the link on the page. When it is clicked, it will come to that associations order page, show the affiliate number we give that page, and then with what you gave me, show which of their clients the request was received from. the page is not a standard page for anyone to order from.

make any sense? lol..

i' ll let you know how it works...thanks again..

mark




mfalk -> RE: 60 Affiliate codes from one form. (4/30/2003 16:19:42)

be the ball thanks for your time and help. apologies if it was unclear..hope i havent wasted too much of your time today...its appreciated.

mark



mfalk -> RE: 60 Affiliate codes from one form. (4/30/2003 16:44:28)

Spooky, works like a charm. can i use a sessioni variable if i want them to look through our entire site after coming from the link and hwen they finally get to the order page, still have that affid number?

thanks again!!

mark



Spooky -> RE: 60 Affiliate codes from one form. (4/30/2003 17:02:24)

When they arrive at the page, record it as a session :

<%Session(" AffID" ) = request.Querystring(" AffID" )%>

Then use the syntax <%=Session(" AffID" )%> to write it in the hidden field



BeTheBall -> RE: 60 Affiliate codes from one form. (4/30/2003 21:43:13)

quote:

be the ball thanks for your time and help. apologies if it was unclear..hope i havent wasted too much of your time today...its appreciated.


Not a problem. Wish I could have been more help, but I knew if Spooky or rdouglass got a hold of it you' d be set. They have helped me more times than I can count.



mfalk -> RE: 60 Affiliate codes from one form. (5/1/2003 9:36:24)

Thanks Spooky,

The only thing is it didnt work. I put the session string on my index page, and when i go back to the order page, it doesnt pick it up and place it in the affid field. I even tried to rename the index as an asp and that didnt work either...hmmm...

any suggestions?

Mark



mfalk -> RE: 60 Affiliate codes from one form. (5/1/2003 13:08:08)

sorry, i was hilucinating (again). it works fine. I had it backwards....put it on the wrong page..(slapping self in forehead).

thanks again for your help.

Mark



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.125