Prevent Repeating Records
Is there anything I can do in the Select Query statement?
View Replies
ADVERTISEMENT
Is There An Easy Way To Prevent Duplicate Records Being Added To A Access DB
I am adding simple records to a fairly simple access database with the following code
rsEntry.Fields("Player1") = ShortName(Player1)
rsEntry.Fields("Player2") = ShortName(Player2)
'Write the updated recordset to the database
rsEntry.Update
rsEntry.Close
adoCon.Close
Set rsEntry = Nothing
Set adoCon = Nothing
How can I SIMPLY :-) prevent duplicate records from being added? I know I can set the index property on the fields but that mean handling the errors - not sure how to do this.
OR I could write the code to seach the DB before update - which may be the only way :-(
Is there a simple way?
Non-repeating Value
how should i retrieve the repeating value in the text box to be the values in the combo box?
example:
text box values : A A A B B A C C
combo box values : A B C
how can write so that even though it is a repeating value but only display those key values
Repeating Events
beeing from swedeni´ve the text in swedish. But I hope u understand.
I´ve a calendar
http://www45.brinkster.com/ovaasp/cal.asp
Now I want to list events, so each event gets to the correct date (i.e in the correct
table-cel)
I´ve managed to list in the wat I want
http://www45.brinkster.com/ovaasp/list.asp
But when I trying to put the events in the calendar, I can´t get the repeating events
correct . U can see for yourselfs http://www45.brinkster.com/ovaasp/error_jun.asp
if you check next month + button "forward"
Eken Cup, i Solna should be writen to 3 - 7th jun
Repeating Lists
help me with making a repeating "dynamic list/menu" . i use dreamweaver and when i put a "repeat region" on a "dynamic list/menu" the page just keeps loading forever. do i need to change the default coding dreamweaver makes...iv been trying to figure this out for literally weeks, and im about to give up. I know it can be done becuase iv seen it done.
View Replies View RelatedRepeating Region Layout
I have a repeating region set up in Dreamweaver for products. At the minute, when processed the records come out like this (one after the other)
x
x
x
x
x
However, I want to have three in a row (until end of table)
x x x
x x x
x x
Is there anyway to accomplish this?
Having Problem With Repeating Rows
What the hects going on on my page? Why are there so many blank backgrounds?
View Replies View RelatedRepeating Region Without Dreamweaver
Can someone show me how to repeat records from a table without using Dreamweaver. Everything I find on google about repeating regions relates to Dreamweaver.
What I'm wanting to do is pull everything from a table in my DB. Then I will be putting those fields in a table on my page. Let's say the table is 2 rows and 4 columns. The first row is a header. The second row is where the returned recordset fields will go (in each of the 4 columns in the second row. Now, let's say there are 6 records in the DB table which have been returned by the recordset. I want those six records to be placed into the table on the asp page. How do I repeat the second row?
GUID Values Repeating
I have been creating new GUID's through this block of code
set typ = server.createobject("Scriptlet.TypeLib")
guid = TRIM(MID(cstr(typ.GUID),2,36))
Response.Cookies("guid") = guid
Response.Cookies("guid").path = "/"
Response.Cookies("guid").expires = now() + 1
set typ = nothing
Lateley, some visitors to the website are actually receiving the same guid.How is this possible? Is there a process that may be used to reset the guid delevery sysem?
Adding A Layer To A Repeating Recordset
I have a repeating table set up to display the results of a recordset. What I want to do is "attach" a layer on the side of it and have it be a different color with different text in it based on one of the results in the recordset.
I.e. say I have a field called "reponses", if it's value in one table is 1 I want a green layer with the word "yes" in it positioned next the table, in the next table if it's value is 2 I want a red layer with the word "no". Is something like this even possible?
Control Repeating Random Question
I have random questions that appear with each click and it works fine accept that I can't get it to NOT repeat the same question twice in a row. Code: ....
View Replies View RelatedPassing Value With Nested Repeating Region
I am passing values from Supplier_Details.asp to Supplier_Products.asp, when I click to view the details of the supplier I want, their values goe to the other page ( supplier_product)that I want all his products to be displayed.
so far I can pass values and could be displayed, no problem but when it comes to displaying all the products, it;s then where I am stuck, with the previous tutorials ( nested repeat region) I can get it working and I tried to have that example working for all this, so far it;s not, so is it possible to do it ? Code:
Dynamically Creating Repeating Tables With ASP And CSS
I am generating a series of tables in CSS. The tables should repeat
themselves for a number of times governed by a counter that is
calculated at runtime by the ASP code. The problem is that I have used
top margins to position the tables in the ASP page.
So the tables when repeated super-impose on the tables that are
already placed at that margin position. Can someone suggest me a
better way out to resolve this?
Prevent Printing
Is there a way to prevent the user from printing a page? I have a form that I would like to make it impossible or very difficult to print out.
View Replies View RelatedPrevent Error
I am a webdesigner.We have recently taken over a site created in ASP. The site remains on the original server, but my company does the updates on the site.I do not touch the ASP at all, as I not familiar with it other then I know ASP automatically becomes html when you view it from the browser and u can save the file from there.Anyways, I edit the pages as required, new text, new photos, new links, and create new pages (any new pages I create in html if not tied to the database). I save the pages with a .asp extension and upload. This does not seem to mess anything up.
The person who hosts the site, is upset that someone else is editing the site, so he's really not easy to work with. Anyways, after uploading files, everything works fine, and then a day later, all of a sudden, any .ASP pgs you click on give the following error or similar pasted below. What I'd like to know is if these errors are because of me..and if so, how do I prevent it.
Prevent Excel
I've got an intranet application that presents a list of files in sort of a 'central repository' web page. Each file is an href in the form
<a href=file://server/share/path/filename.ext>.
When the user clicks on an excel file,it is opening within the browser,which unforntuntely confuses the heck out of them because the usual Print/Print Preview menu options are not available. I would like the user to be presented with the typical Open/Save dialog when clicking on this link.
Is there any way that I can force the browser to do the same thing as 'Save Target As', without modifying the user mime configuration in IE (another common suggestion), or hosting the files on the web server?
Prevent The Duplicate Value
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.
Prevent Resizing Of <TD>
I need a help to prevent resizing of <TDwhen i post inside this <TDhtml text of other web page.
View Replies View RelatedPrevent Caching
If you look around on the web for advice on cache-control and using 'Option Explicit' you get a paradox. Both features are supposed to be the first piece of ASP code on the page. Well they can't BOTH be first can they?
View Replies View RelatedPrevent Flooding
What would the logic be to prevent flooding? On my forum they have a timer, so if the user has submitted a post, it starts the timer, and after 30 seconds it will allow him to post again.
When the user comments, record the date in a session (StartTime) and when the user tries again, DateDiff in seconds to see if the Now() time is more than 30 seconds after the StartTime. If it is, clear the session.
Prevent Same Session Var
i tried to open Window B using window.open() from Main Window. And from Window B i open another new Window C which fires up session("topic")="something"
So i tried to open another window link from Main Window, and the session("topic") value is still the same. how can i overcome it? Beacuse im using same session("Topic") var for all the sql query statement. so if 1 window is opening and another different session window start, it will overwrite it each other.
Prevent Posting
How can I prevent posting of a form from any other site but the site the form lives on?
View Replies View RelatedASP Repeating Form Fields In An Email Form
Would anyone be able to give some guideance in ASP code as to how I would repeat a section of input fields in a form based upon the number of guests that are attending an event?
Basically, what needs to happen is if 3 guests are attending, I need the Name, address, city, state fields to repeat so they can be filled in with information.
Then all of the information from the whole form is submitted which returns an email to the administrator of the event.
Prevent Any Type Of Error...
How can you prevent the database error from displaying on
screen? Can you redirect users to a more friendly error
screen that is custom created. Using ASP/SQL Server. For
instance, if the database cannot be found, instead of
displaying,
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or access
denied.
/myConn.asp, line 7
Can you make it to where you could display something like
this:
"I'm sorry, a database error has occured, please try your
request later, click hyperlink for list of possibilities."
Prevent File Download
Currently i am doing a file management project where user are able to create folder and upload files to it. The file ownner would be able to set permission (from database linking to the file path) if a user able to download it or not.
*each file info will be stored into a table e.g. fileid, filename, path, access.
Now i am facing a problem where if a user does not have permission to click on the link to download, the user can guess the path and the file name and directly type the path on the address bar to download the file.
Prevent Resubmitting The Same Form More Than Once
I have a form which when submitted will validate the fields and then add the record to a database. If a mandatory field is not completed, there is an instruction to return to the form and complete the mandatory fields and then submit.
The problem I have is preventing the user from resubmitting the same form once it has been added to the database. I cannot deactivate the submit button, because if they need to return to complete mandatory fields, the submit button is still required.
I have read the article "Programming Forms To Submit Only Once" from 15seconds.com and this looks exactly what I need......
To prevent the same form from being submitted more than once we must:
Initialize the data structures.
Create a mechanism to give each form a unique identification.
Find a way to store a list of already submitted forms.
When processing a form submit, we just have to check if its ID is on the list.
I am having problems when adding the recommended code to my form and my process form pages.
Prevent Unwanted Comma
This may not be possible on the server side, so apologies if this is the
wrong group for this post.My form consists of an unknown number of pairs of text boxes. They are named textbox_a and textbox_b. I then split the comma separated list
that gets posted:
textbox_a = split(Request.Form("textbox_a"),",")
for i = ubound(textbox_a)
...insert into db
then do the same for textbox_b
If anyone puts a comma into one of the text boxes, this will result in
unmatched pairs. How can I deal with the comma, or prevent it?
Prevent Image Saving
Well i am developing an application in which few pages display just images ... (*.jpg)
format ...
now what happens is that i dont want to allow the user to SAVE these images onto their
disks ... when a user RIGHT CLICKS on the images menu pops us which gives option SAVE
PICTURE AS ...
well so is there anyway i can prevent that ... i thought of following way ...
(1) If I can override the RIGHT CLICK event handler and replace it with my own custom code
in which i may just display a Messagebox say ... "you cannot save this picture" ...but the
problem is that i dont know how to override this event ...
i am using ASP with VBSCRIPT and i dont know anyother scripting language .... so plz help
someone as soon as possible ...
any other method is WELCOME but keep it in VBSCRIPT ...
Prevent Multiple Logins
I want to prevent multiple logins in my web application. For eg:If a user "userA" logs into the application,some other user with same userid "userA" should not be allowed to login as long as previously logged in "userA" is active.
Is there any solution? One method I thought was when user logs into application,
I set a flag in table.If user logs out of application from the logout button explicitly provided in application, I reset the flag for that userid.But if user closes the application from browser(close) , I am unable to find a way to reset a flag.
Prevent Resubmit After Logout
How to prevent resubmit after logout?After logout, I hit back button, then the browser ask whether I want to resend the data? How to prevent this?
View Replies View RelatedPrevent Displaying Chinese
due to my 'Language for non-Unicode Setting' in Regional Settings,my ASP page keeps outputing the date format as Chinese Simplified characters when issuing say, <%=Now()%>. In addition, my client script also interpret it as Chinese characters, which I don't want it to behave this way.
However, I can't remove my 'Chinese (PRC)' settings in control panel as I need it for other Chinese version software. Does anyone knows how can I display the date in my ASP page in normal English? I did try out the META tag Content Type and put in several charset to try out, but seems like it doesn't work at all.
Prevent The Forms From Clearing
I assume it has to do with cache control, but how do I prevent the form from clearing when a user hits the back button? The form I am referring to is my registration page. After the registration is submitted, they are taken to an error handling page. If an error comes up, they are required to hit the back button and correct the mistake.
It seems like for the most part it retains all of the information in the fields, but occasionally it clears it out. How can I prevent this?
Prevent Unauthorized Downloads
I have a file that SHOULD only be made accessable to registered users. They must login to get to the download page. The problem I have is that once a user logs in an gets to that page they can potentially share the web link to that file with anyone and that unregistered user can bypass logging in.
I was thinking something along the lines of download.com where when you click download, the actual files location only appears for a split second, pops up the download box, then it switches to another webaddress?