Make Array Of Unique Numbers
For a simple search of a help desk application I've written, I'm querying text fields in two tables. One table is full of help desk calls (ids, where they're from, simple description, etc). The other table is full of messages that are related to a call (updates, reasons for closing, etc.) and has the call id as a foreign key.
I've got some sql queries setup to get a list of all call ids that match a search term. Is there a built in way to sort the results to make sure they're unique? I know I could do it manually in a few lines of code but am always looking for the easiest way.
View Replies
ADVERTISEMENT
how do i create a array rs, not sure if the terminology is correct. but i don't want a obj rs i want a array.
View Replies
View Related
I am trying to write an array of random numbers to a database. The array part is working fine, but when I go to update the dataabse, it inserts the last value of the array into all the fields in the database .....
Dim MyValue,sqlRandom
Dim arrayRandom(8)
for i = 1 to 8
Randomize
MyValue = Int((100 * Rnd) + 1)
arrayRandom(i) = MyValue
response.write "<p> Array Value:" & arrayRandom(i)
sqlRandom = "UPDATE CarParkDetails SET FreeSpaces = '" & arrayRandom(i) & "'"
Conn.execute(sqlRandom)
next
I can't see whats wrong!
View Replies
View Related
I'm working on asp project, access 2000 at backend.I can write arabic text and arabic
numbers in textbox and save them in database.but if i see these records, arabic text and arabic numbers,it is ok,if my computer is arabicenable.
If my computer is not arabic enable then it show arabic number into english numbers.
how can i show arabic numbers instead of english numbers if my computer is not arabic
enable.i'm working on a project i have to complete it.How can i convert english numbers that are coming from database and convert that numbers in arabic for show.
I have use
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
I shall be very thankful to you for this purpose.
View Replies
View Related
I need help with some asp code that would allow me to grab the last record id and add one to it for the new record being inserted.
I am new to asp and have been banging my head up against the wall trying to get this to work. I am currently using Visual FoxPro 6 for my database.
The SQL statement I am trying to use is:
strSQL = "SELECT Max(contact_id) FROM CustomerContact;"
View Replies
View Related
i'm building an ecommerce website and I want to create a unique orderID for each new order. My problem is that I don't want to have a random number but a number where each orderid is one higher then the last order like for example 4850323, 4850324, 4850325....
I tried to do this by using an application variable where 1 is added after every order but
this doesn't garantee a unique number because if IIS is reset it also resets the application variable.
View Replies
View Related
I've a databse of product in which I've unique ProductCode plus a ID that increments by 1 (AutoNumber). both the code and ID are unique and there will be no duplicate but is it worth having both in the databse?
I mean, can I not just use the productCode and forget about the ID? does this makes any difference? as far as I can see I'll have no problem in using the ProductCode. how you'd do it.
View Replies
View Related
Whats the best way to create a Unique ID and insert it into a Access DataBase? the field that holds this is a text field, and is called company ID.
Its a text field because it seems to cause less hassle
View Replies
View Related
I have a list from a database which I have made into a dropdown box, with each option as one line from the list.
At the moment I have several repeat values which I do not want.
I can set up a series of nested if statements and loops to remove the duplicate values but I would expect there to be a function which does this much more easily.My question is:
Is there an easy way of only displaying unique values from a database using ASP and SQL.
View Replies
View Related
This is about a simple form validation in asp using javascript.there is one field called invoice_number which requires an unique invoice number as input. Whenever user inputs duplicate values message should pop up as warning on submit of the form. A sql fetches all the invoice nos. from database into an array using getrows.how do i use the result of getrows in javascript to perform client side validation
View Replies
View Related
I am trying to find a best algorithm to generate unque id(alphanumeric less than 10 character long - not GUID) for entering orders in orders table for an e-commerce site.
View Replies
View Related
I need to implement a email confirmation ASAP, but I need a way to create a unique ID. Can I just use the SessionID? People will click a link in their email, (if it exists), and my site will validate it. ASP.NET has GUIDs, but ASP doesn't. I'm wondering if a SessionID will just do it?
View Replies
View Related
in Database i have table 'timetable' it contain one field 'lect_id' which is primary key of that table. i want to generate unique ID. How can i do that.
View Replies
View Related
I have a tablet structutre that is the following:
id customer error
1 custa 0
2 custb 1
1 custa 3
2 custb 0
1 custa 0
Each id is unique to customer. I have a table with over 100 rows of the above.I need a way to pull that last three occurances of error number 0 for each customer? I was trying to use a subselect but i was having trouble.
View Replies
View Related
I'm trying to obtain the IP of the hosts connected to my webserver.
Code:
<%
on error resume next
'trying to obtain host IP
ip = request.servervariables("remote_addr")
response.write "IP addr: " & ip & " --- "
ip = request.servervariables("remote_host")
response.write "IP host: " & ip
%>
If I use the above script, it shows me the IP of my ISP webproxy, not mine.
View Replies
View Related
I have developed a site for my client,
eg., www.abc.com
I have registered the domain with godaddy and mapped the dnc to my server (Windows 2000)
When i browse that site using that www.abc.com, in one of the pages i found that the session value is lost. This happens only in some machines not same with all. Most of the machines works that site properly. But not the same in some machines. All machines has configured same.
The exact part is
eg.,
customerdata.asp
session("custdata") = request("name")
response.redirect checkout.asp
in checkout.asp
if i give response.write for that session("custdata"), In some machines i m not getting the value.
View Replies
View Related
Is it possible to create a unique visitors hit counter in ASP? I'm struggling to find any tutorials on the net. I found a few that can do a unique visitors on a daily basis but I just need a straight forward unique visitors in general.
View Replies
View Related
Have an asp form created and I need to assign a unique id number to each submission. Can this be done w/o a db?
View Replies
View Related
How can I generate a unique random number?
View Replies
View Related
Very ill today so unable to concentrate and need some help with some fairly simple stuff...
Below is standard code on my page which is recieving variables from Flash and imputting them into a database.
What i need this page to do is to and your help doing it is:
1. Check if the email address exists in the dbase?
2. If it exists then to update the field 'High_score'
3. If it doesnt exists then to create a new record and input as the code below does.
View Replies
View Related
I have an application form that when filled out is being written to a singular HTML file. I want to convert it to generate a unique file name each time a user fills it out.
Secondarily, I want to be able to attach the unique file to the email that is sent to us when it is submitted.
Here are the current snippets of code:
set ObjFS = server.createobject("Scripting.FileSystemObject")
set objTheFile = objFS.OpenTextFile("e:credapp2.html",2,-1)
objTheFile.WriteLine(FileToWrite)
objTheFile.Close
and...
objMail2.AttachFile "e:credapp2.html"
View Replies
View Related
I have found a tutorial to create a hit counter for my webpage which runs off of a database it is all wonderful and everything BUT, whenever I am working on the site and refreshing a thousand times to see what everything looks like, it is counting me too.
Is there any way to code your own counter that counts only unique visitors? I would use a free one, but of course I don't want any links or images on the site, I want to be the only one that can see the stats.
View Replies
View Related
I am trying to create a folder dynamically for an individual user to upload to on my site. However having successfully created a folder dynamically, I cant create a folder by the current users username.
The '<%=username.Fields.Item.Value%>' part was done by dreamweaver and believe that to be the problem.
View Replies
View Related
I'm writing an ASP application in VBscript that will take an exported Goldmine contact record and import it into our on-line system.
The problem is that I want to export the Goldmine unique ID so I can re-import data back into it and make sure it goes to the right account. However, the account numbers in Goldmine are very interesting, here are a few examples:
A4100648391)Q1JV{Ral
A4082964730(__+;7Joa
A4091653262&<SB/{Jas
A4091738208 SVU{Jef
A4082964760$MVPP7Mar
A4093057759$#7)6{Bru
A4101172112(M;I97Mic
A4101172124)6[(Y7Edw
A4102056041&+C J7Joe
As you can see, there is a wide assortment of characters in an account number. The problem is that when I try to import it into the online system it breaks ASP because of these characters. I've tried adding slashes before special characters, but then trying to remove them is impossible because the same slashes could be used in the actual account number.
View Replies
View Related
i'm about to write a shopping cart application and need to know the best way
to assign a unique id to each order.previously i used the sessionid which i've since found out isn't unique.can someone please advise me as to the most reliable way to assign a unique id to a transaction.i'm using classic asp and an access database.
i'd rather not use the session object due to issues with a previous shopping
cart application.
View Replies
View Related
We'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 Related
I have a script that will compact an Access MDB and a copy to a new folder. I would it to give each export a unique file name. I can do this with an absolute file reference but I am struggling to create one using 'Server.MapPath'.
View Replies
View Related
I have a login pages right now that prompts the user for login and password and redirect the authenticated user to a URL (see code sample below).
Now instead of this I would like it to pick a URL (different for each user) listed in my access database (URLredirect) and redirect them to their personalized homepage. How can I solve this problem? Can anyone guide me in the right direction? Code:
View Replies
View Related
I have a table with data in it and i want to generate unique icodes for each user. I have a hex function that generates random code but i get stuck when i want the items to be unique. I want to update all uses that have empty codes. How will i go about this. Code:
str_sql = "update tbluser set [usercat]='" & strcode & "' where usercat=null"
conn.execute(str_sql)
View Replies
View Related
I was thinking about an easy to determine if cookies are set or not in ASP. I began
thinking about how the Session ID is dependent upon a cookie - right?
Well, I disabled cookies in Firefox and then loaded a webpage that displayed
Session.SessionID. Viola, I got one! And then, I reloaded the page. And then, I noticed
that the SessionID incremented by one!
This still isn't yet a one-page method of detecting if cookies are enabled or not (like
BrowserHawk does), but are there any possibilities here?
View Replies
View Related
I am using a GUID in asp e.g
i_GUID=(left(createObject("scriptlet.typelib")).guid,38)
and need to find out how reliable it is and how it generates a unique ID.
an example of the unique ID is {FEE7EECD-2E70-4E95-8EE1-C887B34EBB3E}
can anyone point me in the right direction for documentation on how this is generated.
View Replies
View Related
I have to develop an online quiz on my website. the site is developed in ASP.
i have a access database of the questions, the multiple ans.s and the correct ans. every quest. has an unique id.
i want a way by which any 10 'unique' quests. will be selected from the database everytime an user takes the test.
View Replies
View Related
I am trying to get random, unique pics to display but for some reason, I sometimes get the same pics showing twice.
could someone kindly shed some light on this Code: ...
View Replies
View Related
