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 To Make A Dynamic Array

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

Writing Array Of Random Numbers To A Database

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

English Numbers Into Arabic Numbers

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

Unique ID

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

Following Unique ID

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

Which Unique

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

What Is The Best Way To Creat Unique ID

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

Unique Values

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

Unique Entry

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

Best Algorithum For Unique ID

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

Unique String

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

Generate Unique ID

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

Unique Records

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

Unique Host IP

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

An Unique Strange ASP Session

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

Unique Visitors Hit Counter?

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

Form With Unique Id (no Database)

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

Unique Random Number

How can I generate a unique random number?

View Replies View Related

Creating Unique Users

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

Generate Unique File Name

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

Unique Visitor Hit Counter

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

How Can I Create A Unique Folder Using Asp?

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

Export The Goldmine Unique ID

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

Unique ID For Shopping Cart

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

Identify A Unique Visitor

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

Create Unique File Name

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

Unique URL Redirect From Database

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

Generating Unique Codes

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

Unique Way To Detect If Cookies Are Set - Opinions?

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 (Global Unique ID) In Asp And Need To Know How It Works

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

To Retreive 'unique' Random Records

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

Display Random, Unique Pics

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







Copyrights 2005-15 www.BigResource.com, All rights reserved