Return The Unique ID For Inputted Data
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
ADVERTISEMENT
Problem With Len Statement When No Data Is Inputted
I'm having trouble with this Len statement. I want it to check to see if a user entered more than 3 characters in the input field. This works, except if the user doesn't enter anything... which I'm assuming is 0. Code:
View Replies View RelatedAssign A Unique Number To Data
I 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?
Return All Post Data
Is there a way to see all the post data that is sent an .asp page. I am working on a page that is being returned from another application and I would like to know what data I can work with.
View Replies View RelatedFind And Return Data From A Just Submitted Record.
I have a page where a user can submit a record for a new "applicant". After the user clicks Submit, I would like to send the user to a new page containg the "Applicant Number" which the user will need.
The applicant number is simply the autonumbering of the record in the table which is in a SQL Server db. How do I capture the record number(primary key) of the newly entered record in the table and send it to my new page?
Searching By User Inputted Date Range
Im trying to create a search form that will return records from the present date (which the user cannot change) to a date 3, 7, 14, 30 days in the past.
Here is my existing SQL code, please note im using Access 2000:
SELECT *
FROM Candidates
WHERE candLocation Like 'varoffice' AND candDept Like 'vardept' AND candTypeRole Like 'varrole' AND (candName Like '%varSearch%' OR candEmail Like '%varSearch%' OR candThreeComp Like '%varSearch%' OR candTypeJob Like '%varSearch%' OR candAddress Like '%varSearch%' OR candCity Like '%varSearch%')
ORDER BY candDate DESC
There are a few other conditions in there too. now I am thinking i need to add something like this: Code:
Request.Form Doesn't Return Form Data
I have some ASP server-side code that works perfectly when the client is running on Windows (IE, Netscape, Firefox, etc.) but doesn't work at all when the client is running on Macintosh (IE, Omniweb, Safari, etc.) This is the client-side Javascript code:
View Replies View RelatedUnique 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;"
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.
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.
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
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.
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 RelatedBest 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 RelatedUnique 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 RelatedGenerate 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 RelatedUnique 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.
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.
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.
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 RelatedForm 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 RelatedUnique Random Number
How can I generate a unique random number?
View Replies View RelatedCreating 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.
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"
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.
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.
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.
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.
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 RelatedCreate 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 RelatedUnique 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:
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)
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?