i have created an array from recordset containing user names eg. (davidp, davidp, evenf, patricka, rebeccah). which i have sorted in alphabetical order, but i need to
identify duplicates in this array and the number of times it has been duplicated.
I have an array which is made up of a selection of place names, such as "London, London, Lisbon, Paris, London, Madrid, London, Madrid", what I need to do is loop through the array and get it to find out which item is duplicated the most times, and then have this item equal to a variable, such as TopPlace, which in this case would be TopPlace = London, I have no idea how to achieves this, could someone offer me any help on doing this?
View Replies View RelatedI have a array arrNames --
Is there any easy way that I can check that no duplicates exist in the array and if there are duplicates return the name that is a duplicate?
I am pulling some records out of a database which have a Description field containing several words, and storing this information in an array using GetRows().
Then using a for-next loop I am going through these records and using the Split() function to get the first word of the Description and then adding it as an option to a dropdown list.
The problem is I get lots of duplicates in the drop down because lots of the descriptions have the same first word. Using DISTINCT in the SQL statement won't help much because at that stage the descriptions arent the same. Code:
I am returning a list form a db: this could be 1,2,3,4,12,67,1,2,34 so basically I am looking at how to remove the duplicates before doing another select. I saw a thread here with a funciton to do this bu it does not seem to work.
View Replies View RelatedHow to identify with ASP that value is a Numeric or Date or String ?
View Replies View RelatedI have been using css to identify what link (page) the user is on by using body id. The site I am developing has alot of pages, so i am hoping this can be done easily using asp.
Here is an example of what I am after The user clicks on say Testimonials goes to the testimonials page and that link is highlighted.
If I have two different kinds of users on my website say simple posters and moderators, how do I differentiate between the two on my site while they move from page to page. I mean, I cannot append the user type ids with the web address to transfer the value from page to page since anyone wold be able to alter it. If the value is accessed from the DB every time a user requests for a page, then the program will become inefficient, wouldn't it?
View Replies View RelatedWe've created a video application that allows "voting" for videos, to determine prize winners. We want to restrict each computer to one vote per day. What is the best way to do this without requiring the user to log in? A login app is not in the client's budget, nor is it doable from a time standpoint. Is detecting IP address in ASP reliable for the average user? Cookies seem easiest, but they also are easy to wipe out.
View Replies View RelatedI need to write some special logic in my ASP.NET page. If the page is visited by a human visitor, I want to show an advertisement. If the hit is from any search engines, I do not want to show the Ad.
How can I identify if the hit is from a human visitor or search engine? Is there a server variable I can compare with the list of available search engine names?
in one part of my application i have some kind of user and password form. it asks for e-mail and a costumer id (as password), the costumer id must be a number, it's an INT in the SQL table. i tried to use a javascript checking method, but this kind of checking method seems not to work at all in firefox, so i'll do the checking via asp. what i need to know is how to check if a some VAR got anything except numbers in it?
View Replies View Relateddoes anyone know of a way to check if a process is running on the server... using asp ? I basically have an html form and upon submittal of the form ... i would like to redirect to the response page when a certain process is no longer running . the logic is as follows Code:
1) user enters form values and clicks submit button
2) server side asp checks the server for a process "wpuba.exe"
3) if "wpuba.exe" is not running .. redirect to page2.asp
basically I want to wait for the "wpuba.exe" process to terminate before redirecting to the response page.
i have 2 application variables called totalAdminLoggedIn and totalUserLoggedIn
when ever an admin login, I increment the totalAdminLoggedIn value by one
and when a normal user logg in, the totalUserLoggedIn value will be incremented by one.
how can i change the values when the session expire ? i can reduce the value manually when they logoff like:
if session("userCategory")="admin" then
Application("totalAdminLoggedIn")=Application("totalAdminLoggedIN")-1
elseif session("userCategory")="user" then
Application("totalUserLoggedIn")=Application("totalUserLoggedIn")-1
end if
session.contents.remove "userCategory"
but what if the session expires automatically or if they close the window suddenly?
ie. i want to do something like below? Code:
I am doing a webpage which allows different users from various departments to do a search/print information of people within their own department. I have a login page for user to key in the correct password and id before they enter the system. However, in order for the restriction to take place, I will have to ensure that the system recognises the person that is logged into the system.
View Replies View RelatedI am required to prevent duplicate posts........how can i do this?? my database is MS Access and am using ASP.
Have been scratching my head fo quite some time now........cant figure out the logic.
I understand i cant limit it from the database....if possible i'd like to know how to handle the error that it would give with a page with message
or how can i compare the entry from the database before i post it
How to write asp code to remove duplicates in an array.
For Eg: A()=(1,5,10,15,10,20,5)
After removal of duplicates it should be
A()=(1,5,10,15,20).
I have a string value which has the bellow content.
Dim aString as string
aString = "1,2,4,2,2"
where aString is a parameter set dynamically based on the user loggin into the system. Now All I want to do is to eliminate the duplicates. ( In this case I need to keep only one "2" and remove the remaining "2" , so my final string should be "1,2,4" ).
How could I do that. I was thinking of an array, but the issue is, If the "aString" is empty I believe array will return a error. So any other way of doing ?. Or simple asp functions which will eliminate this.
A member logs on and enters a record, if one already exists for that date, then they get a message saying so. If not the record is added and some text is displayed. But it still allows me to enter records even if one already exists! is it because I am storing my dates as strings? Code:
View Replies View RelatedI have an array like this:Code:
arrColour = split("blue,blue,green,red,purple,blue,green,yellow",",")
What I need to be able to do is to remove all items of the value "blue" from the array. I can just run a dictionary function to delete all duplicate values, because some of them need to be retained. I just need to delete all of them of a particular value. how this can be done?
I have declared a multidimensional array as follows. dim parray(100,5). Now this array contains some duplicate values. So how to remove duplicate values in this multidimensional array.
View Replies View Relateda way i can remove recordset rows that have identical entries in a column?
View Replies View RelatedI've got a form that allows the user to search a table for data and if it finds that the data is not there, it should insert what is missing into a new table. But I'm not sure as to how I would check the records before I insert records. Code:
View Replies View RelatedI have two very simple Access tables:
tblNewsletter
==========
ID | Email
tblSaved
==========
ID | Email
There are thousands of records in each. I need to check for duplicate email addresses across the two tables and remove them from tblSaved if they appear in tblNewsletter.
How do I go about doing this?
I have a permission tracking app that I am working on, and I have made the insert page for it. I am having issues on how to prevent duplicates from getting entered.
Currently the interface for the app has a mixture of select boxes, list boxes and checkboxes. The form submits the page to processAIMR.asp and then does the inserting. I am using a loop to insert a new record for each checkbox checked or listbox entry selected. Code:
I have a string like so:
Fruit (apple) (pear) (banana) (pear/orange/apple)
I need a regular expression that will parse it into the following:
apple / pear / banana / orange
i.e. separate them all by a forward slash and remove duplicates.
I dump the entire recordset into an array:
If not rs.EOF Then
aEmp = rs.GetRows()
Contents of the array are in this order:
EmpID,EmpName,Indent,Sub_ID,Lft,Rgt,MgrID, LastName
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
In working with arrays, I have found that I am unable to dimension and array
with a variable that has an integer value but I can redimension one this
way. I haven't see any information that tells me if this is a requirement,
although it appears to be because I get an error if I try it.
Ex.
Dim b
b = 10
Dim a(b) ' this errors out but
Dim a() ' this
Redim a(b) ' works
Code:
I want to create a new array called arrNames2 and copy contents of arrNames to arrNames2.
I then want to loop through my db and add more names (while going through the loop) to arrNames2. What is the best way to do this? Do I have to keep redim the array wehn I add more names?
i want to excute given logic
select * from Product_Table where Product_Code in
ARRAY
i.e i want to select Product_Code from VB array and not from a query
is it possible.
I know I can do this programatically using a loop but I thought there might be
some easier or more effective way.
I am trying to invert an array.
i.e.
array1 = 1,2,3,4,5
but I want to get
array2 = 5,4,3,2,1
Is there something like array2 = invert(array1)?
I have to following code:Code:
dim arrRes(9),getal,som
arrRes=Array(4,4,4,4,4,5,5,5,5,5)
for getal=0 to 9
som=som+arrRes(getal)
next
response.write("Het klasgemiddelde is " &som/10)
I get a type not match error on the second line
I have a page in my admin system where the user can edit products they
have added. The problem I am having is with Related Products. These are
all listed in a multiple list. What I need to do is have those selected
when the product was added, already be highlighted in the multiple list
on the product edit page. Here is my post from another forum.
Code:
For some reason, when I try to run the following array, I'm getting an
error:
dim cat(0)
cat(0)="0407"
cat(1)="0102"
'I will be adding more to this array, but just trying with two for
starts.
for counter = 0 to 1
itno=cat(counter)
'I get an error when it runs through this function
Function rightvar(theVar,lengthNeeded)
Dim sResult
sResult=theVar
if Len(theVar)< lengthNeeded then sResult= String(lengthNeeded -
Len(theVar)," ")& theVar
rightvar=sResult
End Function
Can someone help me understand why?