when i want to insert my data into my table but i encounter the following error
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E2F) Violation of PRIMARY KEY constraint 'PK_sDetail'. Cannot insert duplicate key in object 'sDetail'. /fsearch/InsertTable.asp, line 153
For example, now my 1st page is a search page, i use it to search for all records that has the same Business_unit, so it goes to a second page where a table of the records is shown.
Now this page has a link to a 3rd page, where i wan an exact duplicate of the second page, is it feasible, is there anyway to display the exact saem table on the 3rd page?
My table in the database may contain duplicate records, which means except the primary key (auto_increment) field is unique, all or almost of all the fields are with the same content. How can I select them to display and delete them?
I have a problem with Insert statement. Though My SQL Statement executed once only, there are 2 records entered in DB. I am using ASP and SQL Server. Does anybody know the solution?
I have a fairly complicated web site with multiple sub-folders running on W2k server (IIS5?).
I would like to duplicate this to another web site on the same server for testing. For instance, the current root web of the server is located atF:Web. The production site is F:WebMyApp.I want to create another siteat F:WebMyAppTest.
The only thing that prevents me from just copying everything from one to the other is the links and includes of the pages, such as:
I then need to go thru every source file, and change /MyApp to /MyAppTest.Is there a way to accomplish this via IIS, or by changing the way I reference the includes and link?
I have a form with home address & business address fields.When a user goes to this form, the fields pull the information that is stored in the database,then they can update their information.
What I would like to do is have a checkbox/radio button/button that allows the user to specify that the business address is the same as the home address and replace all the business addy fields to the same value as the home addy.
So when you click/select this button, the business address fills in (if empty) or changes (if it has values) to the same values as home.Then when the form is submitted, these changes are written as normal.Is this possible and if so, can someone point me to an example?
My database has the "email" field set to not accept duplicates. If someone tries to enter a duplicate email, I get an error message. Is there a way to just redirect them back to the registration page if their email address is duplicate?
i have a form by asp and database by MS access.so i want to prevent the duplicate value in empID because when i add a new employee with the same id ASP gives me this error.
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. /employee/admin/addemp1.asp, line 48
so i want the employee to get a message like this empID already exist or somthing like this.
I have set up a page specifically for printing, however, I would like to be able to choose certain items on the page that are to be ignored by the printer. For example, the web version of the page may have instructions on how to print, although the version that is printed off does not.
I have multiple list box added to the asp page using <select> tag I have added items in the list box using recrdset from Education table Education table={educationid, educationname} User can choose more than items from the list box. These items gets added in the user table in field "edu" seprated by commas. When User wants to edit his information ...i want that the items in the list box should be automatically selected which are present in "edu" field.
does anyone knows how i can layout items retrieved from db such as example from this online shop site . most items retrieeved from db such as Accesss are always in vertical layout.
I have this login that i created. On the sign in process i need to make sure that no one has already signed up using that certain email or that unique cnumber.
Ive tried this line: Set objRS = verify.execute("SELECT id FROM logmein WHERE email='" & email & "'") or ("', cnumber= '" & cnumber & "';")
than this: Set objRS = verify.execute("SELECT id FROM logmein WHERE email='" & email & "'", "' & or & '", "' cnumber= '" & cnumber & "';")
I am doing a wed site online shopping system for my school project, which requires some asp coding using vb script. I am new to asp and have no knowledge whatsoever on how to code what i need. Could someone please provide me with help, or coding on how to add item details into a basket record, once the user clicks the add to basket link.
I am doing a wed site online shopping system for my school project, which requires some asp coding using vb script. I am new to asp and have no knowledge whatsoever on how to code what i need.provide me with help, or coding on how to add item details into a basket record, once the user clicks the add to basket link.
currently i have an online shopping website that display 12 categories of different items of up to 12 types. well my boss wants related items to be displayed in each of the different items . i am not sure how to start this. is there any special code for it. please advise.you may visit www.mellon.com.sg/shop to view .
I have a basket which people add stuff to that they want to buy. i want a code that allows them to delete the item too. how the basket works is. thy choose a item from stock page and then it adds to a basket table.
I have a multi-dimensional array that I want to delete items from. To do this I display a form and the user clicks some tick boxes. Then on the delete page I check which tick boxes were ticked, say 2,4,7 and 8 (or whatever) and then rebuild the array minus records 2,4,7 and 8 and so on.
Sounds simple enough, but I'm having a real nightmare getting it to work. So my questions is how are others doing this, as my way is obviously very shoddy! I've been looking for examples on the internet, but I've not managed to find one.
I am doing a wed site online shopping system for my school project, which requires some asp coding using vb script. I am new toasp and have no knowledge whatsoever on how to code what i need.
how to add item details into a basket record, once the user clicks the add to basket link.
This is my scenario. On the left of the screen, I have a list of news items, which are updated by the user and inserted into a database, and then they are dynamically displayed on screen from the database. Now what I want is that if a user clicks a hyperlink from the left of the screen on a news item, the relevant text is displayed on the right. What I did up till now was that if I point on a news Item to the left of the screen, I know which item in the recordset it is since I created a counter.
I would like to tap in to all the brilliant minds out there through the means of this question. Is it possible to have a function in asp that returns a collection of items?
If so could you please direct me to some code that may provide some insight to how its done. I've tried using my limited coding capacity but no success.
I'm trying to make a sorting feature for my site which will allow the user to click a drop down menu, click the item they only want displayed, click a button, and then the results will only display that particular item.
I also would like the drop down menu to auto-fill because there are about 20 different categories available. is there and easy way to do this?
I am trying to do a simple INSERT into SQL. I've done it tons of times before with the same code, but this time is is placing duplicate entries in the table. Any ideas why this would be happening? Here is my ASP code doing the form processing:
<% set conn=server.createobject("adodb.connection") conn.Open "Driver={SQL Server}; Server=SERVERNAME; Database=DATABASENAME; UID=USER; PWD=PASSWORD" set rs = Server.CreateObject("ADODB.RecordSet")
i want to hide duplicate values of a column in a asp form, lets suppose i have a field schoolname, and studentname, so it is possible a school have so many studnets, so i dont want to show school name infront of each student name, how can i hide it,
Yes different users can post images with the same name and they should be renamed as you state.
However you can not upload an image with the same name if you have already done so and give msgbox that duplicate image name pls check image name and image size is not larger then 13kb.
I'm connecting to an MS Access database using ASP. Within my database I have duplicate records (more specifically records with the same serial no.). When I search by the serial number only the first record is displayed. I would like to display all records containing the given serial no.
The table is full of records; many are duplicates.
What would be the correct syntax to show ONLY those records appearing more than once?
A. Please do not use Stored Procedures B. Please do not use User Defined Functions C. Please do not use Variables D. Please do not use Temporary Tables E. Please do not use Views