i have a table which has many field, they go across and are named as a1a2a3a4a5a6-a16 the next row will be b1b2b3b4b5b6-b16 the last row is g1g2g3g4g5g6-g16 and so on.
now in the first column i.e which would be a1 b1 c1 d1 e1 f1 g1, the user enters a part number what i want to do is prevent him or her entering the same part no.
twice if this the case the two filds with same part no should be cleared.i.e if user enter p45 in a1 then p45 in d1 then both a1 and d1 should be cleared would be better if the later was only cleared but any method would do. Code:
I have an ASP form which only includes an option list. The list is dynamically created but includes a default value, which is an instruction "Select a group".
The code is shown at bottom. I want to ensure the user does not submit the form with the default value selected. Code:
My application is written in .NET (C#) with the inline Edit mode from DataGrid. When a SAVE button is pressed it will perform a action on the database either to add, edit or delete data that a user has entered.
When the refresh button is pressed at the top of the page the same exact data is re-submitted again resulting duplicate transaction in the database. Is there anyway of stopping this happening? From client-side script, how can we detect that the "Refresh" button is click?
My problem is this: This database has a field called "b_name" which contains the first, middle (if any) and last names of registered users. The table also has corrosponding other demographics pertaining to each registered user.
I've used the code below to parse the full names in "b_name" in the original table and put the names in another new table which has 3 fields, "FirstName" "MiddleName" & "LastName".
My problem is the fact that the way the names are stored in the original table and the parsed names in the new table do not correspond. Code:
I want to take the contents of many fields of various datatypes (varchars and text) and combine them into a single "junk" field that I will perform SQL Server free text searching upon, e.g.:
tblArticles Title Subtitle ArticleText
CombinedField [Title, Subtitle, and Article text smashed together]
Is it possible to create a query or T-SQL stored proc that would do this? Is SQL Server DTS a better approach? It needs to be built for each row in the table, and it needs to happen regularly.
What i am trying to do is Update data in a table with data in another table but i want to update 2 fields in the destination table with data from 1 field in another table.
These are the table i have and their fields:
*CUPFirstRound* - Table1 GameId GameDate Home Away HomeScore AwayScore Winner
There are 8 rows in this table, thereofre the GameID's go from 1 to 8 Code:
I have announcements down the left hand column of a site and want to display contact info if it is available - if it is entered into the database. So I only want to display a space plus the data if there is data in the field. Code:
I am creating a form that has 5 steps/pages. Each page contains about 20 fields. But I don't want to write them until they submit on the last page. I figured out that I can use hidden fields to carry the data from the previous forms forward. If should bascially work like this:
But the problem I am having is when I submit page 4 page 5 won't load. No error, it just won'tload. It seems to be overburdened. Is there a max on the number of fields it can pass? Is there a better way to go about doing this that someone can suggest? Or a suggestion that someone can make to fix this problem?
I have been thinking about storing some data, which my users upload, in text files rather than database, since often I do not know how much information users submit for things like item description or images URL paths.
This information may be very short or very long. MS SQL Server requires a maximum field length to be set. Thus, if user enters 5 characters into 5000 character field, a lot of space will be wasted. On the other hand, the database reference would point to the text files to read users' data and display it on page.
how do i get data from a user on one page and display the result on the other page actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
I am inserting data into Access when user logs on: .............. SQL = "INSERT INTO tblLog (fldUserName,fldTimeIn,fldSID) VALUES ('" & u & "',#" & session("Date") & "#,'" & session.SessionID & "')" con.Execute(SQL) ..................... in here it inserts the date :01/09/2003
But when logging out : ............. SQL="UPDATE tblLog SET fldOffline=1,fldProper=1 WHERE fldUserName= '" & session("admin") & "' AND fldTimeIn=#" & session("date") & "# AND fldOffline=0" con.execute(SQL) ............... it doesn't update the record.If I eliminate the date query here,it updates there is no syntax error is there?
I am storing user entered form data from an ASP page in a MSSQL 2000 database. I would like to give my administrators a way to download a tab file with the entries. Is writing an ASP page the best way to do this? And if so, how can I convert database records into a file that will download through the browser?
I am developing an ASP application where the user may spend large amounts of time manipulating data on a worksheet. An amount of time that will certainly exceed the security mandated session timeout intervel of 15 minutes.
So the user pushes save after the session has timed out and is thrown to the user login window -- all according to standards. How can I either detect the timeout before the submit or preserve the user entered data despite the redirect?
I need to allow user to save dataset to their computer in Microsoft Money format. I searched internet for help on this but found nothing helpful. I also chatted with MS Online Concierge to no avail.
If you could, please provide pointers to steps how to accomplish this. If you will provide the steps yourself, please be very explicit in what you provide.
Error Type: Microsoft JET Database Engine (0x80004005) The Microsoft Jet database engine cannot open the file 'c:inetpubwwwrootannoneil\_databaseannoneil_AN D.mdb'. It is already opened exclusively by another user, or you need permission to view its data. /annoneil/artist.asp, line 96
The code was working fine a few days ago but now I cannot figure this out.
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.
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?
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.
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?
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.
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.
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."
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.
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.
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?
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.