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;"
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.
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.
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
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.
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 RelatedI 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 RelatedI 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 Relatedin 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 RelatedI 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.
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.
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.
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 RelatedHave 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 RelatedHow can I generate a unique random number?
View Replies View RelatedVery 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.
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"
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.
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.
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.
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.
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 RelatedI 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 RelatedI 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:
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)
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?
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.
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.
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: ...
Q1)I want a unique cookie to be created for each visitor without needing them to log in or enter any information anywhere. For an example if there's a new visitor to my site, i want a cookie to be created just for him,is this possible?
Q2)with the response.redirect() i want the cookie information to be sent to the 2nd page with so that the 2nd page can retrieve the cookie information with request.querystring()?
After data has been put into a table, how do I then get it to return the unique ID assigned to that record?
View Replies View RelatedI have a web page that submits a form to a database. Each time a form is submitted, I need to assign it a unique case number and insert the case number into the database along with the information entered in the form.
I am able to insert all the data into the database, but am not sure how to generate the case number to insert. Is there a way to do this based on number from the previous entry, like just add 1 to it?
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.