From the past I have been adding records with a form with 2 pages.
One with the form and the other a add.asp page to actually take the values from that form and add to Access database.
Just for example I had the form on:
p1.asp and when they click submit it goes to
p1add.asp and adds it, but is there a way to add it with just p1.asp?
after i add record from this page, when it link to the next page.. everything is blank, but the record has be added. how can i display the newest record with the old one after i click the add button?
code ...
I want to add records to my table with an insert query. My access database has an autonumber which creates a unique Id for every record. If I add a record will the auto number be a problem or will it increment itself on its own?
View Replies View RelatedI'm trying to write an on-line db update. The user can select a table from a list which is passed to an asp page that displays a the full table (fields and all records) and at
the bottom I've added another row to the table which contains an input field for each column so that the user can add a record. Code:
Ive got a tool that is taking sugestions and updates from users and then generating a unique id based on the date and ID Autonumber field from an access db. I am using the addnew method b/c it is the way i know to immediately retrieve the id.. The problem is im trying to add the id back into the record on the same call. Is this possible?
My code is as follows but i seem to be getting duplicate records with unique id's.. But the thing that seems strange to me is that both records have their own unique id. If this were the case i would think that the first record would not have the unique id b/c it is not generated until after the first update call? Code:
i have a access DB, and a asp page to add the records to the database, i work on visual interdev, i get error when i run the code as:
ADODB.Recordset (0x800A0CB3)
object.provider is not compatible of performing requested operation.
/project/addprocess.asp, line 37 'points to rs.addnew line
my entire code is Code:
I'm using Access and have 2 field called DateAdded and EventDate and both are formated at Date/Time (shortdate). When I try to add a record I think it is bombing at the dates. I can insert a record if I don't call that portion. I tried FormatDateTime(date,2) But it still doesn't work.
View Replies View Relatedi cant add a record to my access database! i think the code is right which i used asp script but then only blank record was added! It added a record but then no data in it! Code:
View Replies View RelatedI'm trying to add a record to an access database using asp. I create the database, the input form where i put the information, the asp code where i process the information and last the asp code to view the record added but when i press the submit button it show me a Downloading box for a downloaing process.
View Replies View RelatedI have an ASP page with a table that fills with records from a loop. Every
row gets a link to another ASP page with data from the row. The link is
written as <a href=newpage.asp?value1=xx&value2=yy .... and so on.
Now I try to let the user specify a number that should be sent to the other
page. But I do not want to clutter up every row with each an input field,
so I thought instead I would place it above all the data rows. When the user
clicks on the link, I want to include the input field to the querysting. The
problem here is that I cannot figure out how to refer to the name of the
input field.
I want a user to select ADD from a dropdown menu and then the asp brings up a form allowing the user to add fields into the DB .....
View Replies View RelatedI have a form with a drop down menu for day month and year. What I would like to code is - If a date isn't selected by the user then todays date would automatically be posted.
View Replies View RelatedI want to have a poll on a message board and add options by users clicking a button. The code looks something like this...
<INPUT TYPE=BUTTON VALUE="Add" ONCLICK="Add();">
<INPUT TYPE=BUTTON VALUE="Delete" ONCLICK="Delete();">
function Add()
{
// alter the action and submit the form
document.topicform.action = location.href + "1" ;
document.topicform.submit();
}
function Delete()
{
// alter the action and submit the form
document.topicform.action = "deleteformbutton.asp";
document.topicform.submit();
}
As you can see I'm not really sure how I should go about processing the actual form. Each time the user decides to add another form button I want it to keep the value of the old button. Anyone got any ideas?
I have added a regular html form to my asp script and it has turned off my buttons on the other forms.What do I need to change? or what could be causing this?
View Replies View RelatedI am trying to total the value of some form fields I am referecing the form
field with an inner loop, I am having a little trouble because the amount of
fields returned is always different, how can I roll-up the total of the form
fields (request.form("subtotal_"& i)) to get one final figure? Code:
I am trying to test a form at home which is for registration purposes. I dont have a server connection yet. Im wondering if it is possible to check whether the form is working offline or whether my code just isnt working! ?
I should also say that my html files, asp files and database are in the same folder. Code:
How to send ASP form Mail without adding @ domain name.
View Replies View RelatedExcept for extremely basic ASP programming that I did two years ago and have forgotten I have not touched coding since!
I've taken a look at a couple of tutorials but they all baffle me!
Can anyone tell me how I can just create a simple html form with input fields of FirstName, LastName, Email and Phone amd when the user hits submit it is recorded in an access database?
I can do the HTML part fine. And I believe I've set up access ok although Ive never used it before.
Also, if the server that the database will go on is a Microsoft one i suspect that is ok? Im not sure if all i have to do is upload the database and it will work? or do i need to talk to my hosting company to set up some kind of odbc thing that ive heard about?
My database will just be called clients.mdb and the table is called Customers.
Basically i have a form on a HTML page which someone fills out with a few IDs, then i have a .asp file which is meant to add the info to a database.
However it just wont work, the field names in the database are correct. - i hope the if statement is correct too. Code:
I have a simple script I found that increments a number in a text file. I was wondering if anyone has a routine that will commify the number. Code:
View Replies View RelatedI have a user based service where each user has their own information, user settings, etc. I want to be able to add tables in my user settings and allow the users to enter in their IM Service (AIM, Yahoo, MSN, etc) and their screen name/user name.
That is the easy part.
What I do not understand or cannot figure out is how to link this information to the icons for each service they enter that will open up the appropriate service with their correct IM name, etc.
Basically I want to provide a way for my members to IM another member when they pull up that users information, or associated information, etc. Basically I need the script to make the Icon execute the correct IM service if the user clicking on it has the service installed as well. The majority of my members use AIM.
Where can I find information on how to install this kind of script and associate it with the users information and an icon?
We have a facility on our intranet where users can log problems, comments &
suggestions about the site to a DB.
I'm building a page that lists the outstanding entries, and allows use to
mark any number of entries as being 'done'
That is, we have a number of rows, with the last field in each row being a
checkbox to indicate the entry has been dealt with. At the end, there is an
Update button which submits the form.
The question is.. how to handle this...?
The best solution I have thought of so far is to use the record ID as the ID
for each checkbox. Then to Split() the resulting Request.Form into an array,
loop through the array picking out the record IDs.
It's not a bad solution, but I figured this must be a fairly common
procedure and that somebody might have a slicker way of doing it...
I am trying query the data from db and populate in the web form's textbox field. so far I cannot put that record into the text field box. anyone has idea on that, below is my sample code:
View Replies View RelatedI'm new to ASP so I'm using DWMX as a crutch. It created the db connection and recordset code for me and all I want to do is have the page update the db with the result of a variable.
In plain English, I'm trying to update a field called Score in the table quizOne with the results of the variable score where the username field matches the session variable MM_Username. The recordset is called update_score.
Based on other tutorials and forums, I tried this: ....
In my SQL Database, I have some records that display a single zero '0' in a field called ORACLE_ANAL. However, on my dreamweaver Form, when a record is selected, i wish to have the single zero '0' displayed as Four zeros '0000'. Is there some code I could use to have the 0 diplayed as 0000 on the dreamweaver form.
View Replies View RelatedI have a server using a webapp built on classic ASP, and I use a library that creates/manipulates a datagrid-style display on the page.
I am displaying a large chart with sufficient data that it will likely be paged, and there are several columns that are toggles (using checkboxes for these, with the entire column having the same checkbox NAME, but different values depending on the record).
I have a piece of script that for loops through the records present on the page (determined by a collection of hidden form values), and then I need to check if the collection formed by a given column contains that value, something like the following (pseudo-code):
How would I get the max record + 1 to auto-populate in the GMVINC form field? I have a feeling that my query is not correct. Code:
View Replies View RelatedI have an ASP page in a table style (heading and data). At the beginn of each month (actually only the first day) there is no data in my database and so-with nothing to show up on the ASP page. If I would like to open the ASP page over the net IE is telling me that it cannot find my page. Is it possible that, even if there are no records to show, at least the heading is shown on the Internet?
View Replies View RelatedI’ve been racking my brains trying to figure out why when I call a record set back with a SELECT * it only brings back some of the fields. It use to be connecting to an access 2000 DB and worked fine but I’ve converted it over to SQL. I’ve installed SQL server DEV edition and imported the data. The desktop is running XP.
Has anyone got any ideas why it only picks some of the fields in the record set and not others? O I’ve tried timeout = 0 on the connection already..
how to Update Record On Page Load. I have one feild in my database that I want to subtract 1 from each time the page is loaded.
View Replies View Relatedwondering if you can do this in asp
<title>
<%
Response.Write Recordset (Title)
%>
</title>
I have a script that makes a printer friendly version of the ASP Webpage, however when I use the printer friendly version of the page I dont get any information thats included in the orginal recordset of the page. How do I get the information accross to my printer friendly version of the page. Do i put the record set in the print.asp page? Code:
View Replies View RelatedIn my prototype asp page (with no javascript and no password validation, I have a registration form with the following action:
<form name="form" method="post" action="RegDetails.asp">
This works fine, the form details are collected by RegDetails.asp
I am attempting to include javascript server side validation for the pasword, which obviously requires password and password2 fields (to be verified). I have used the script available at:
http://javascript.internet.com/forms/val-pass.html
It works fine in a new blank page with the form action:
<form name=myForm onSubmit="return validatePwd()">
The final stage in this javascript demo form displays an alert box:
else {
alert('Nice job.');
return true;
When I change the first line of my original form to:
<form name=myForm onSubmit="return validatePwd()">
how do I get my original action of - action="RegDetails.asp" instead of this alert box?