I have a string of ASP code that writes a new database entry into my SQL server table. Is there a function that I can run directly after the database entry code, that can tell me if the data was successfully entered? Eg of current code:
SQLCode = "INSERT INTO GarProductList VALUES (" & "'" & App_Name & "'" & ", " & "'" & Option_Number & "'" & ")"
response.write "SQL Code is: " & SQLCode & "<br>"
Set objRS = MyConn.Execute (SQLCode)
<< perhaps call certain function here to verify SQL table was updated? >>
If database update successful -> function should return 1 If database update fails -> function should return 0 ... or something like that. In any case, some exception response should be returned.
Does anyone know how I can use asp to access a specific entry in a microsoft access database table without having to run a search of the entire database? I figure this can be done with the primary key, but I'm not sure how to do it. I've looked for tutorials, but none seem to deal with this.
I am having considerable difficulty figuring out how to delete more than one entry in my online database at a time. I thought I had it Sub Delete() SET Conn = SERVER.CREATEOBJECT("ADODB.Connection") Conn.OPEN "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/db/database.mdb") sqlWhere = "" aSelected = request.form("Select") sqlWhere = "ProspectId IN ('" & aSelected & "')" sql = "Delete * from tblProspect where " & sqlWhere Conn.Execute sql Conn.Close Set Conn = Nothing RESPONSE.REDIRECT("prospects.asp") End Sub
How do I change a blank database entry, so when I retrieve it blank I output a string say <i>N/A</i> into a table? Currently I have an if/elseif/else like this.Code:
if tf.name = "ID" then Response.write(bla bla) else if tf.value = null then Response.write(bla bla) else Response.write(bla bla) end if
*Note, where the word null is, I have also used the string "" and it still does not work.
Is it possible to log a successful/unsuccessful download in ASP? I've got a download logging system but I'm wondering if its possible to find out if a download was disconnected or not?
When a file is uploaded, notifications go out to Admins. Currently Admins have the ability to have 3 email addresses that the notification can be sent to.
Now lets say they only have 1 email address for a contact. When I run the code below, it cycles through to everyone that needs to be contacted and sends email to all 3 addresses.....BUT #2 & #3 are empty and then in my SMTP folder I receive a bunch of files in the badmail folder.
I need to correct this so that I can eliminate having to go and purge on a daily basis.
Now I am sure that there is a better way of doing this... I inherited this and am looking for some help with correcting this....
Let's say I have a dynamic list/menu, which gets its values from a database table, for example a list of contact people where the value is an ID number and the label is the name. However, if the value the user wants is not in the list I would like to place a hyperlink which will...
(1) open a small window, with an ASP form to allow the user to add a new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about. I don't like the idea of forcing the user to leave the current screen, go to some other form, add the entry they need to the lookup table, then come back; this seems like a logical approach, but just wondering how to make it work.
This seems like a common enough situation; anyone have any code samples or suggestions about how to do this?
What i have is a form that puts data into a DB. But what i need is for the page to display the reference a field in the row the data has just been entered.Does anyone know how to do this?
I have a booking page that the user enters 2 addresses date and time etc what I need is the option for the user to select multiple date entries for the same journey or maybe multiple days ie they want to travel the same journey every Monday or every weekday etc.
i m making a page on login basis, i hve an access datbse, after login user will enter a code which is already store in datbase, then form checks if this code is in databse if found then it will show some other records in databse, otherwse disply msg, user enter data in fields, after completing data cursor must go to code agian for another record, this data entry is in bulk, mean 200 recrds or more in one session, so may be i use batch procdure, then form save the records, same time a link on pge to edit this record, or if no code availble , operator can add new records
I'm building a data entry and search tool. I've created a basic search facility and it seems to work ok but I don't know the code to create 'data entry' buttons. I want something that looks the same as the search facility but the submit button creates an entry in the databaseCan anyone give my the relevant commandscode?
I have an ASP page that allows the user to input specific fields which in turn update a database. I have managed to get this working although I have one more question.
Can I format the fields so they are not all in a line. Maybe two per line. THis was the user can see all the fields at once without scrolling right and left. Code:
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
If I write an entry into this DB, Name and EMail, the ID is auto increment. How can I detect what ID has been created ? I want a user to submit details to me, they get the ID as a ticket number ?
i have a question and comment page for students to comment on tests. each question is set with an auto-ID number.
I have the comments saved to access database but it only holds one comment, or record to the question with the ID number. Everytime someone makes a new comment, the other comment is lost and it only shows one comment. I use the <%=objRS("comment")%> and it will show that one comment, but I need away to show all comments to each individual question. Is there someway I can alter the database (comment table) or that <%=("comment")%> command to show all coments by the question id number?
used to other languages and using ASP for a particular project. Is there a way in which I can remove the first element from an array and then return the array with remaining elements intact?
I need to write an ASP page that will allow a user to paste in data from an Excel spreadsheet. The data will only be in one column. I'm not a web programmer and would like some advice on the best way to do this.
I have a page working using a text area and some JavaScript to parse the data entries using the split function. This seems to work ok but I wondered if anyone could suggest a better way?
I have successfully created a master detail page for this database, now I want to create an form to update the database.
When I created the form and tried to view it, I got this error
Error Type: ADODB.Command (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /dlrc_resources/book_list/book_entry.asp, line 113
I have a form to enter details about companies into a access DB, it all works fine the way it is set up except this one small problem.
The same company details can be entered again by mistake and take a new record set. Now what I need to know is how to stop this from happening, do I use ASP code to check the DB (if so could someone tell me how it is done) or do I set this up in the Access DB itself.
What I want to happen is if the same company details are entered then the user gets a warning telling them that that company has already been entered.
Linkpoint central does this with their payment gateway as a securty measure... you cannot post a sale request unless it comes from a specific address, that you specify in their management console. (which im pretty sure its checks the referer page.)
Is it at all possible to display only one of possible duplicate records from a database in a recordset. The field that needs to be recognised as a possible duplicate is a column for names but then needs to show the one with the highest score only.Fields are name and total (numerical). Currently I have only a basic recorset which is all that was needed until now:
We are creating a multi-region ASP application which will be using SQL Server 2000. As our users exist in multiple location i.e. UK, US, Australia how can we distinguish that the date the user is entering is captured correctly i.e. no confusion with DD/MM/YYYY format.
I guess to remove database ambiguity I am going to use the format YYYYMMDD format but how do I know in the first place when the user entered 01/06/2006 that the user meant 1st June 2006 or 6th Jan 2006.
I have a database with multiple records which are often updated. I am trying to display the latest entry in a certain way (with css div styles) and then list the rest of the entries another, less elaborate way.
Is there a good / preferred way to do this? Right now I have it so that it SELECTS TOP 1, displays that in a certain DIV, and then SELECTS * - however what is wrong with this is that it displays the first record twice.
I have a form in which a textbox is filled using a pop-up page. This pop-up page has a selection of values created dynamically from an access table. I need to know how to get the values selected from the pop-up back to the main form. Can anyone guide me in the right direction.
Ive got an asp website which has a news function. Its pulling through info and a pic ref to a url on the server that in turn puts it onto a page.
My problem is that i only want to show this picture if there is a record in that news item (some news items willnot require a pic) - at the moment its coming up as a broken picture link. Is there a way of showing it only if that record in the table is filled in? Code:
HOw can I prevent my users from entering more the a certain number of characters into a field? Could I get a similar example as I have a limitted knowdlege.
have form on asp page with an email address field, when the user enters their email address I want it to populate another field automatically on the same page, some kind of OnBlur event. Have worked extensively with dropdown OnChange events but cant get my head around this one.
I have a table layed out in SQL 2000 like the following:
Username Date Hours Period john 1/1 10 1 john 1/2 20 1
How simple is it for me to build a data entry form in ASP that would display this with input boxs for the hours field. The problem is I need it to span left to right on th eweb page.
I have asp project where large volume of data entry would be done. I am trying to find out if there is any tool that can allow me to build asp application where the forms would be like excel spreadsheet.
I have a created a cost reporting system which shows a level-breakdown report. There are three levels in the report the lowest level holds the cost items that are entered by the user these records also have an Entry Date. The level above that is a Sum of the lowest level and the top level is the Sum of the second level. I created the solution using three queries in Access. I then use the queries in ASP to generate the report. But now I need to use the Entry Date at the lowest level to re-generate the report with values from the StartDate to the EntryDate (which is entered by the user).
Question is, can I do this using the construction I use, or do I have to pull my queries to the ASP code and include the dynamic EntryDate? How do I solve this?
I don't know what they're called, but you know the form: The page displays a "code", usually on a similar color background (dark gray), and the text is all squiggly.
It's an attempt to foil the bots that go out and process forms. The user has to type in the code they see, when the graphic itself should be unreadable by character recognition engines.
So, how are the graphics generated, and how do you implement this?
