I've got a lot of referer variables in my dbase and I'd like to have a query that groups them just by the domain. Everything up to the 3rd "/" should do it. So far, I'm using:
SELECT COUNT(id) AS clicktotal, ref
FROM clicklogs
GROUP BY ref
This only lists everything by the actual referring url. Is there a way to only have it group by the domain within the referring url?
We have two sites hosted on different servers and we have many pages on
domain A which has many links(asp programs) to domain B.
My question is if domain B server is in trouble, what is the best way to
have all domain pages redirect to domain A? Right now I just have redirect
code in each program on domain B to redirect to a maintenance page on domain
A.
Can I just write on program to solve this issue?
if it's possible to catch the url that the user is visiting after leaving our site. I mean, I use HTTP_REFERER to see from which url the visits are coming from, I want to know if there is some way to catch which url they visit after leaving our site.
View Replies View RelatedI have an ASP project that I want to return grouped records from a SQL database.
The data fields are, for example:
Company = TEST, Portfolio = port1
Company = TEST2, Portfolio = port2
Company = TEST, Portfolio = port3
Company and Portfolio would be the fields in a table named "data".
What I need to do is display the results grouped by company.
For Example:
TEST -- port1 -- port3
TEST2 -- port2
I have not been able to get anywhere with this and hope someone can help. The only thing that got me remotely close was "GROUP BY" but it only works with one field. I need to return all of the data fields.
I pull the data out from the sql db. There are quite a few records the same, but diff. ID. I would like to group them. How to do it?
For example: Here is what in the DB
01. English 101 - this is a night class
02. English 101 - this is a night class
0.3 English 101 - this is a night class
I would like it displays only - English 101 this is a night class.
I am making a small ASP script to track users from an email marketing campaign. Basically the email is sent to subscribers, then when they click on an offer they are sent to a third party provider. Right now we can track how many users open the email, and how many visit the site, but we would like to track conversions.
The third party will only provide stats via referer. Is there an easy way in ASP to set a referer to a custom url during the redirection?
i am using the http referer and i get null value from some computers
and the correct value from other computers,
all the computers are using the same code!!
I want to know how to find out who is sending visitors to my site. So i obviusly need to find out who a visitors referer is.
I took a guess and thought that this is what I should use:
request.ServerVariables("HTTP_REFERER")
But that does not return anything. Any ideas guys?
I built a site half a year ago with form that submits to page that processes the info and then returns the user back to the page they came from using HTTP_REFERER.
There's one guy -- using an identical set-up to our main testing platform -- who kept getting the "URL required" error when doing this. For some reason, on his system alone, HTTP_REFERER was not collecting any referring URL. Is it common for HTTP_REFERER to wuss out like this? What causes it?
I have a question about the Max Referer length. By default this is 256. I am not fully sure I understand this property. It this a header that is sent back to the Server by a client and is it part of the URL.
While testing our Secure IIS I ahd the error come up I increased the value to 1080 and the error did not repeat!. But through my search the Max Referer lenght is always 256. SO I am trying to get feel for what the Referer really is, is it part of the HTTP 1.1 protocol?
I have a CMS with access restriction to every page (the user must log on first). If a user tries to access a page while not logged on then they are redirected to the log on page.
In this case I want the log on page to send the user to the page they were trying to access, after they log back on.
Because the page restriction is the first bit of vbscript on every page, non-logged on users are redirected before the rest of the page loads, so using Request.Servervariables("HTTP_REFERER") does not work (I think this is the problem).
I'm trying to use <% rReferer =REQUEST.SERVERVARIABLES("HTTP_REFERER")%>
and capture the referer URL in the variable 'rReferer'.
All I get is the URL of the very page I'm inserting this code into, that is, it refers itself. "sigh"! Yes, I'm clicking from another web page to test it. Am I coding this properly?
I am stumped as to how to do what appears to be a very simple thing.
Want to display the results of a query containing fields ID and Item,
grouped by the ID. I only want 1 instance of the ID to appear on the
page as a header for each group. There are 10 IDs in the query
results. Thought I could use <% Response.Write (rsName("Item")) WHERE
ID=1 %>, but doesn't work. How else could I accomplish this?
I am building an intranet web page using ASP that searches an Access DB. In the Database I have a field that contains dublicate words. For Ex.
[ SUBJECTS][ORG_LEVEL_1]
-------------------------------------
[Abuse ][Womens Abuse Society ]
[Abuse ][Childrens Abuse Center ]
[Baseball ][Newmarket Baseaball ***.]
When I do a search, My current Script shows the results just as it is shown there, what I would like is for it to show like this.
[Abuse ][Womens Abuse Society ]
[Childrens Abuse Center ]
[BaseBall ][Newmarket Baseball ***. ]
I have the following query:
SELECT sponsor, COUNT(sponsor) * 2 AS total FROM Referrals GROUP BY sponsor
Works great, returns the sponsor and the total * 2 of their referrals because that's how much they make per referral. My problem is I need to pull more information from that table yet still maintain my grouping by sponsor. Every time I try to add another field, or even * like
SELECT *, sponsor, COUNT(sponsor) * 2 AS total FROM Referrals GROUP BY sponsor
it wants me to group on all of the fields and I only want to group on the sponsor. I'm not smart enough to know how to nest these or group part of it, etc. Hope I'm making sense.
I have a list in a database that I have categorised using a category field. I now want to retrieve all records but grouped by categories.
how do i get my asp to loop through each category creating a recordset for each one rather than hard code a new recordset for each category i would rather it did it dynamically if thats possible ?
so eg
category travel
1 - B&B's records (recid 1)
2- rail info (recid 2)
category local info
1 - swimming baths (recid 3)
2 - museum info (recid 4)
is there a possibility that i can use this statement
referer = Request.ServerVariables("HTTP_REFERER") in a .html page??
I need to redirect after processing to the previous script (referer). However I dont wish to redirect including the querystring. Just the referer's script name.
View Replies View Relatedi'm trying to create a report in asp... and i want to group by months... for example
April
location1 $20,333
location2 $20,333
location2 $20,333
May
location1 $30,333
location2 $20,333
location2 $70,333
June
location1 $30,333
location2 $20,333
location2 $70,333
and i am pulling the date field... and example what that looks like it...
4/20/2004 12:00:00 AM
5/20/2004 12:00:00 AM
6/20/2004 12:00:00 AM
I have a Table (Table-name:Problem_List) and Column (Column-name:Title). There are many records in this table with the same (or similar) titles. What i'm trying to achieve, is a list of this column, but instead of 2000 rows, I need the similar names counted list like this...
Blocker : (100)
Serious : (34)
Warning : (430)
etc.
Running: SQL 2000 on IIS6, using ASP
I am writing a report using ASP and am having trouble displaying the data in the way i want. I'm collecting turnovers for various companies and each of the companies has a county code. e.g. Yorkshire is defined as number 2.
I need to group the companies together by county and need to display a totals line for those members only and then on the following lines I want the next county and its companies.
I can group the counties together but the totals line I'm displaying appears after each companies rather than after the group of companies for a given county.
I use a do while loop to check that there is data in the database for each company. I tried putting the totals line outside the loop and that only shows 1 totals line for ALL companies.
I know that the sql 'group by' function exists but it's not working the way I want it to.
Brief background:
I'm making a report that displays, among other things,
-Project Name
-Project Number
-Project Manager
-Fiscal year total spending
My problem is, I cannot figure out how to group all my data together based on Project Number and Manager. Each project has several records for Fiscal Year total spending but the same information for project name, number, and manager.
For example, Project 1 called Test has Manager A and 19 enteries for Fiscal Year total spending (i.e. it's the past 19 year's worth of data).
The report includes a header section that lists the project name, project number, and manager. Below the header information is a list of the Fiscal year info. Code:
I have a FAQ section on this website I'm developing that is *supposed* to pull data from three different tables: tblFAQ, tblAssignedPanels, and tblPanels.
In tblFAQ, there are 4 columns: faqID, panelID, question, and answer. The panelID links the FAQ with the associated panel in tblPanels based on the same field (panelID). tblPanels also holds the name of the panel that is associated w/ the ID. Code:
Is there any way to prevent an IE 6 browser from sending up the REFERER HTTP header? (Either as an IIS Server setting, change to asp files, or even a setting in the IE browser).
This is wasting WAN bandwidth in our Intranet application - we have fairly low network bandwidth. The referer is inevitably somewhere else in our own ASP application, and is usually has a really nasty long QString attached ... (and no, really dont want to run stats about how users navigate our app)..
I have been trying like mad to get this script and this form to work. i'm at the point where the error message i get upon hitting the "SUBMIT" button is simply Form could not be processed due to the following errors:
No referer. Code:
I have been playing around with two different ASP scripts,
1 - To display data from a table in columns
2 - To put the data in to categories.
1 - Columns
Code:
I was wondering how some websites produce the paged numbers when displaying search results, so that if more than say 50 pages exist they group them.
For example:
Pages: 1 2 3 4 5 6 7 8 9 10 (10-20) 20-30)
Then when clicked say '10-20' the following would show:
(0-10) 11 12 13 14 15 16 17 18 19 20 (20-30)
Get the idea??
This looks a lot easier than a list of say 300 pages.
I am able to get the value for "request.ServerVariables("http_referer")". However, I try to use this value in a "response.redirect" and the value disappears. Why is this happening. Example:
-------------------------------------------------------------------------
If Not Session("whatEver") = True Then
Dim httpVar, EncodeHttpVar
httpVar = Request.ServerVariables("HTTP_REFERER")
EncodeHttpVar = Server.URLEncode(httpVar)
Response.Redirect "https://www.blah-blah/extranet/index.html?referer=" & EncodeHttpVar
End If
-------------------------------------------------------------------------
What am I doing wrong.
I'm trying to get the all the information from a URL but after the domain name eg.
Quote:
http://www.domain.com/search.asp?id=123abc
I want to get the information that is in bold
I have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".
I have the code correct for grouping by location. That code looks like this: Code:
How do I do this? When someone comes to www.mywebsite.com/12345 it
redirects them to www.mywebsite.com/details.asp?id=12345
I'm having a domain change foisted upon me and the test I did resulted
in every last ASP and
ASP.Net script stopping cold. Nothing but plain old html worked.
Is there a FAQ or some other document available that outlines what has
to be done when the
IIS server machine is disconnected from one domain controller and
reconnected to a totally different one? If not, does anyone here know
what would have to be changed to make the ASP code play nice in the new
domain?A relevant bit of info, they're also changing the name of the
administrator account. I don't know if that would contribute to the
death of ASP* on the system, but it might.
I need Asp Domain Search .. like Whois.. or any type .. asp,asp.net or PHP .. no matter of language .. but i need complete domain Search ..
View Replies View Related