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.
I am tryin to create a database of users for my system,each user is given a username based on their own name(surname and first name), however if 2 users with the same or similar name enter their details they will be given the same username,for example john drew would return drewj as thier username, so would jack drew, when a new user is entering their details how do i check that the username generated for them does not already exist,i.e i need to compare the username generated for the new user with all usernames already held in the database,if the username does already exist i want to add a digit to the end of the username how is this done using asp?
View Replies View Relatedis this possible? AD being active directory...
View Replies View Relatedhow to create a spreadsheet with info from a database. Is there a way to create the spreadsheet on the users computer instead of on the web server? I want to prevent a whole lot of xls files from being created and stored on the server.
View Replies View RelatedWe are trying to create a basic "signup for demo download" where user enters info, gets an email with user/pass to go and ftp download the demo.
FTP currently is using NT security. Is it possible to create an NT user from ASP? Or is there any other tactic that is more standard?
I want to be able to log in a database any transactions my users perform. For example logging in, requesting a page, downloading a resource, logging out etc.
What is the most practical way to code this? I was thinking of trying to use an include file which would have a function to add a log in the database for each page on the site or when a particular action is performed.
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 RelatedI 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.