Insert Textboxes In The Form
Someone have a script to insert dynamic items in the form?
For example...
In my default form have 5 textboxes... I need to put a button to users to "add new item"... and add textboxes to the form.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Excel Cells To Form Textboxes
if i have an standard excel file and i have data in there in specific cells. Is it possible to have some upload facility that will be able to paste it to specific asp form textboxes? e.g if the data in the excel file was in cell c4, i would want to paste it into textbox4. Is that possible. OR Is it possible to upload an excel file and to put specifc data from different cells directly into an access database. e.g excel file -c4 i would want to paste it to rs("test4")
Need To Perform Form Validation For Negative Numbers And Letters In Textboxes
I have two URLs. Static.htm and dynamic.asp Static.htm Contains a form with two text boxes, called text_1 and text_2 and some other info that is irrelevant for my question. Dynamic.asp Need some code to check that the text boxes only contain values greater than 0 and only numbers. Thus if any of the textboxes for example contain -3 or the letter m I want to cancel the form submission and display some kind of error message. How can I achieve that?
Textboxes
I have two textboxes, nett, vat and gross value.Nett and vat are entered manually, is there a way to say, when nett textbox lostfocus or vat lostfocus then add the two and show the value in the gross value textbox WITHOUT calling the page again as i would have to do in vbscript?
Displaying 2DP In Textboxes
When I retrieve this data into standard text boxes (using ASP/ADO) so that the user can update/file the following problems occur on what I would call price fields: 10 << I want 10.00 11.6 << I want 11.60 12.89 << this is fine My MySQL DB holds prices as decimal(10,3) so I know the decimal data isn't chopped at this point. Before the data is displayed in these boxes I created the below function to parse the data before it is written to the boxes: Code:
Query AND/OR For Textboxes
I have 6 textboxes where if I fill them up I want the query to search if either one of them has results found. I have this but it's not working: Code:
Query AND/OR For Textboxes
I have 6 textboxes where if I fill them up I want the query to search if either one of them has results found. I have this but it's not working: SQL = "SELECT * FROM bible WHERE " SQL = SQL & "text_data LIKE '%" & Keyword & "%' OR " SQL = SQL & "text_data LIKE '%" & Keywordb & "%' OR " SQL = SQL & "text_data LIKE '%" & Keywordc & "%' OR " SQL = SQL & "text_data LIKE '%" & Keywordd & "%' OR " SQL = SQL & "text_data LIKE '%" & Keyworde & "%' OR " SQL = SQL & "text_data LIKE '%" & Keywordf & "%' AND " SQL = SQL & "book_spoke = '" & spoke_number & "'" iCounter = iCounter + 1 (I would like to know the use of the iCounter since I use it from other examples but don't know why it's there.) I've tried this too but this gives every record within "book_spoke = '" & spoke_number & "'" Code:
Textboxes Are Yellow
All of a sudden about 50% of my textboxes are yellow (as opposed to theusual white color). It started when I started on an ASP project, but this could have been coincidental. I have noticed that it shows yellow textboxes on many other webpages.
Disabled Textboxes
The input forms are created using FORMMANGER of MS Visual Interdev 6.0(ASP Code). The forms containing textboxes and bottons (with disable property) are shown correctly in IE5. But when same forms are viewed in IE6 the disabled textboxes and buttons are shown distorted.
Posting Values From Sp In Textboxes...
i need to get the values from the stored procedure below, basically the Name, Description, and is Active values and display them in two textboxes and a checkbox. How can i do this? Or can it be done with this stored procedure? I havent been able to find any good examples on the web... Code:
Insert Form
I am geting this message when INSERTING a form. Microsoft JET Database Engineerror '80004005' Operation must use an updateable query. /admin_pportfolio_bl_insert_processor.asp, line 8 the code on "admin_pportfolio_bl_insert_processor.asp" is Code:
Insert Form Fields
I have about 30 names of workers (and their IDs in hidden fields, that depend on their departments) in one form, beside them there is one dropdown list for each worker, with same items. I want to select item from dropdown list for each worker, that will write item ID in another hidden field... and then I want to submit worker's ID, ID from dropdown list etc....into another .asp page and sql db. If I use next way : <% FOR EACH name IN Request.Form Response.Write("<BR>") Response.Write(Request.Form(name)) NEXT %> I get only values of IDs from dropdown lists. But I need workers' IDs, too.
Multi Form Insert
How would you go about inserting data from two forms into one record? using access/javascript
Using A Form To Insert Into A Table
I am trying to make a page post.asp with a form that simply submits one text value and two hidden values into a table. I already have the function that takes the 3 parameters, modifies them and successfully inserts them into the table: I have included this function in this post.asp page ...
SQL Insert Syntax W/ Form
I can't seem to get this page to work. Its a basic form (with a lot of fields) and I need to insert part of the data into one table and part into another. Here is what is at the top before the <html> tripreportR.asp Code: set The form's action is to post to itself. I can't get the data in and I can't even get the page to show now. Any suggestions, ideas, links, resources would be great!
Multiple Radio Buttons/textboxes – Inserting Into The SQL DB?
I’ve a few radio buttons; few of them have input textboxes and dropdown list. I use Select case to insert values (depend on which radio button that you've selected) into the sql db but it doesn’t work. Then I use if, elseif and else…the value of radio still doesn’t insert into the DB. In this case how can we insert the value(s) into the DB? Code:
Insert <br /> From Textarea Form Submission
I have a text area on a form. I want the user to be able to type in text and where they want a line break to hit the return key in the text area. On the submission I want to replace those carriage returns with html code like <br /> Can this be done?
Pass Hidden Form Field Value To Another Form Field To Insert In Db
I am trying to pass a hidden field value on a form into another field on the form so that it can then be inserted in the database, to enable me then to reference that number at a later date. (The hidden value (1 for example) would then automatically get passed to the other input field.) The code for the text field that allows users to type an number into it for submission to the db is below, but what code do i need within the hidden field to populate this text field below so that users do not have to type the number in? Code:
Check Entered Form Values And Insert Them To Db
I have this page set up at www.kevinhall.org/headcount/headcount.asp what is the easiest way to check where the user has entered a value and submit the row to the db. Maybe i'm going about the form wrong. Each box has its one name but I was hoping i could get around using a request.form on each one and useing the isEmpty. Its so tedious and non efficient there has to be an easier way.. Maybe with .net possibly?
ASP Application Form To Insert Records Into SQL Database
I have a project where i have to use an html asp application form to insert records into an sql database. My problem is finding resources online to practice with to learn, i have basic knowledge of ASP and have attended the microsoft 1 week course on Administering a 2000 SQL Database and i have designed a few small sites so i know html and javascript. I have the database side covered its just the VB code to take the form values and post them to the sql database. I was wondering if anyone could point me in the right direction of sample codes to play around with as i cant seem to find any which relate to this project.
Can't Insert Records From Page With Request.form
I'm trying to insert records into an SQL database coming from a page using the request ..form method. The table "general" has a primary key 'geid .' I get the following error: Cannot insert the value NULL into column 'geid', table 'general'; column does not allow nulls. INSERT fails. ....not sure how to include the 'geid' field into the scheme. strSql = "insert into general (firstname,surname,company) values ('" strSql = StrSql & Request.Form("firstname") & "', '" strSql = StrSql & Request.Form("surname") & "', '" strSql = StrSql & Request.Form("company") & "')" myconn.Execute (StrSql) ....
INSERT Multiple Records From Checkbox Form With Unique Ids
I have an .asp page with a form to copy job responsibilites form one job to another. It is a hotmail type interface with checkboxes besides each responsibility. After submitting, it should copy the selected resp's to a different job. After that it should renumber that job's responsibilities. This is the code I am using now to copy: copySQL4 = "INSERT INTO jambue.RESP(POSCODE,IDCODE1,IDCODE2,RESP_NUM,RESP) SELECT '" & id & "' POSCODE,'" & dept & "' IDCODE1,'" & unit & "' IDCODE2, '999' RESP_NUM, RESP FROM jambue.RESP WHERE (POSCODE = '" & POSCODE & "' AND IDCODE1 = '" & sourceDept & "' AND IDCODE2 = '" & sourceUnit & "') AND RESP_NUM IN (" & Request.Form("chk") & ")" As you can see the value '999' is hardcoded in there as the new Responsibility Number to go with the copied responsibility. I use this because there are no jobs with that many responsibilities. This works fine if I only select one resp. to copy over. But if I select more than one that part still runs fine but I get an error with the below. It says too many rows would be affected. Of course, this must be because there are now at least 2 responsibilites with the same RESP_NUM. Code:
Trying To Insert Multiple Records Into Database When Form Is Submitted
I'm trying to insert mutiple records into my database when the form is submitted.. My form has 4 textfields; serial1, price1, serial2 and price2. I would like to insert serial1 and price1 as one record, then serial2 and price2 as the second record. I know some sort of loop has to be used to achieve this but i'm new to this and I don't know what to do... I tried to do it with dreamweaver but it does not seem possible and the dreamweaver code seems really complicated I've only been able to insert only the first row(serial1,price1).. since I only have 2 fixed rows I guess what I need to do is to get dreamweaver to do it twice in a loop. Code:
Syntax On Passing Variables From Email Form To Insert A Database...
I'm having a problem with passing variables inserting to my database. Here's what I'm doing. I have a page where the user selects a team member (this is fine) Once the team member is selected I have the variables on the form send and email to all supervisors and the member selected (this is fine also) BUT, I'm having problems inserting the emailed information to my access 2000 database after is email. Can someone guide me in the right direction.
Build DB Insert Statement Dynamically - Loop Form Elements
When you submit the form you can see I am trying to get the each row of the form elements into a format such that I can build multiple insert statements. Here is what I am working with: <% Dim x For x = 1 to Request.Form.Count Response.Write Request.Form.Item(x) Next Would I use some type of Mod operator on the value of x to determine my line breaks?
Submit Form Elements To Insert Multiple Records Into A Database
I have a table that contains all of the function permissions within a given application. These functions are different sections of a site and each has its own permissions (READ, WRITE, UPDATE, DELETE) which are controlled by a web frontend and the table records are manipulated to control the permissions. Code:
How To Retrieve Form Values, When Form Elements' Names Are (almost) Unknown?
I have a form that is dynamically generated since it is populated with values retrieved from a database. The form can of course also be submitted, which is where I run into some problems. Since I never know in advance what the length of the form (or for that matter what the different elements' names and values) will be I don't know how to write the code in "receive.asp" to retrieve all values from the form correctly without excess use of "request.....". I shouldn't have to write requests for every single potential element name that is stored in the DB. Please note that the form can sometimes also contain radio buttons and check boxes, even though they are not present in this short example Code:
File Form Type And Request.Form Problem
I have a form as follows: <form action="dropboxsubmit.asp" method="post" enctype="multipart/form-data"> <input type="file" name="FILE1" size="30"> <input type="text" name="def" value="0" size="10"> etc..... and can't get my asp to recognize data in other form input boxes using Request.Form Any thoughts?
Javascript Form Validation - Form Action To Another Page
In 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?
How To Access Variables (form Text Box Values) On Same Form?
I have a form on an ASP page that has 5 text boxes, for data entry. I am trying to get data from the text box, and pass it to a hidden text box on the form. The hidden text box is called "MyDateTime" (a SQL date and time value). I am attempting to concatenate data from two other textboxes (one for date and one for time) to give a string like : "8/8/2004 8:00 AM" I am trying to use the following: Code:
Insert In DB
I have a form which the user fills and submits.i have insert statement there. When i submit the form to itself ,the values get submitted and inserted in DB easily. <form method="post" action="Infoviewagentver212.asp" name="form"> Now when i want the user to hit submit and go to other page i change the above to: <form method="post" action="newpage.asp" name="form"> but here what happens is my values are not getting inserted in the DB?? How do i do this?
INSERT INTO
I'm using ASP + MS SQL. I wrote a simple insert into command but nothing is happening... it gave no error and no information is stored in the db. When I response.write my SQL, I got the following: Code: INSERT INTO [blog_entries](title,user,entry,date) VALUES('test','admin','test','Tuesday, December 25, 2007')
Insert Into
I am very new at this and ding this in context of a course. I am getting an error stating Error Type: Microsoft VBScript compilation (0x800A03EE) Expected ')' Can you please look at this and tell me where I went wrong ? Code:
Insert Into A Db...
Our graphic designer has just finished redeveloping our website. On the site, we use SSL to secure the area where a user enters their personal information to order items from us. (we do not do many transactions - maybe 1 per day...) We are a log home mfg company so they would only order plan books, maybe a video etc... When the user clicks "Submit Order", we want to encrypt each data item (because of new legislation governing customer personal info etc...) and write a record to an access db. From here it will be imported into our Customer DB leads database... I do not use ASP but program in VB 6 and Access 2000. ASP looks similiar in many ways... Does someone have a good ASP script for encrypting data? And, if so, is it fairly strong encryption? Also, is there any trick to writing an "insert" SQL script in ASP or is it exactly the same as I would do in VB or Access? Maybe someone has an "insert" script handy they could pass along including the command to actually execute it?
Insert In SQL ASP
i have got a data base which contain more than one tables one for student one for teacher and one for books i make a fourm to read the input from the user Code:
Insert All At Once
Code: mySQL="INSERT INTO products (sku, youtube, description, details) VALUES ('" &pSku& "','" &pYoutube& "','" &pDescription& "','" & pDetails& "')" call updateDatabase(mySQL, rstemp, "insert1") that's shortly the way i'm inserting new records. using mysql and asp functions. The prob is that inserting only one record every time. if i got data for 3 records how can i make it at once to add 3 new records in some given order into the db
ADO Insert
What is the best way to see if a record has inserted correctly into the datase in ASP? Also, how to tell the user what the error is. I am inserting like this with the ADO command object: Dim sInsert, objCmd set objCmd = Server.CreateObject("ADODB.Command") sInsert = "sp_ADS_Insert_Driver_General_Data " on error resume next With objCmd .ActiveConnection = oConnEnergy .CommandText = sInsert .CommandType = adCmdStoredProc .Execute , , adExecuteNoRecords
DB Insert
Application X has three screens. The user captures information on screen one and then clicks a navigation button to go onto screen two.He does the same on screen three. At the bottom of screen three is a submit button. When this button is clicked the system does some calculations with the information that is supplied and then uploads all the info that was captured on the screens to the database. Should the data be uploaded to the database all on one go when the user clicks the submit button or should it be uploaded after each screen - ie when the user clicks the button on Screen 1 the data is uploaded to the database and then screen two is displayed.
INSERT INTO
I have a database in which I have to on a daily basis enter the information for that day.I would like to update this on a bi-hourly basis to prevent any possible data loss. Using INSERT INTO, I create a new table line. Using UPDATE, I get an error on the inital creation of the table line.I am really unsure how to check to see if that line exists or if there is an easier way around this.
SQL Insert Into
When the following code runs it produces no errors but doesn't give proper results: sql = "INSERT INTO TableName (Line1, Line2, Line3, Line4) VALUES ('" & lines(0) & "', '" & lines(1) & "', '" & lines(2) & "', '" & lines(3) & "')" Response.Write(sql) SET RS = Conn.Execute(sql) lines() contains nothing but strings and is never empty. The Response.Write(sql) shows the proper values going into the proper locations. However, only Lines(0) actually populates the table. Line2, Line3, and Line4 never receive any values despite the SQL showing the proper syntax.
Insert
i have this insert statement that is giving me trouble, the problem is with expiration_date field the error i'm getting is: Syntax error in date in query expression '##'.Code: SQL_Insert = "Insert INTO TableName(ColumnX, ColumnY, ColumnZ, ColumnZZ, ColumnXX, ColunmYY, Expiration_Date) values ('" & _ ColumnX& "', '" & ColumnY & "', '" & ColumnZ & "', '" & ColumnZZ & "', '" & ColumnXX& "', '" & ColunmYY & "', #" & Expiration_Date & "#)"
SQL Insert
I'm using a list in a form in which users can select up to three items. When they submit the form, they are of course being inserted into one field as comma delimited. I can split the data to display, but I was wondering if that data could be inserted to the table as its own record. So, instead of being inserted as one record with three comma delimited choices, I would like three records with one choice in each. Here is a sample of my code: conn.execute=("INSERT INTO Submitted_Information (PreferredGrade, PreferredSubject, Sponsor) Values (" &_ "'" & PreferredGrade + "', " &_ "'" & PreferredSubject + "', " &_ "'" & Sponsor + "')" ) conn.close %> Preferred Grade and Preferred subject can have up to three selections each.
Odd Insert Into MS SQL
I have a column call UserDate and it's properties are this : varchar(50) . I have a function which updates the column with todays date. for some reason, if I manualy give the value to be inserted a value of '10/10/2006' or use date() it inserts a value of 0 if I give a value of 4 to be inserted it works? I have been working on a project for 2 days and this is the last piece to get it to work, can anyone point out where I'm going wrong. P.S I have tried giving the colum a date format but unfotunately the format is american and I need it in english to compare with something else I'm working on.
Insert Into
how do I insert file.filename into the access database when i upload a file it saves to uploads folder see code that doesn't work below file.SaveAs("/johnny/Uploads/" insert into pics1 set rspic = '" & file.filename& "' where author = '" & session("variable") & "'")
SQL INSERT
I have some data I want to put into the database. My question is twofold. What is the best/most efficient way to do this? I've heard of the Execute method, but I can't seem to get it to work. Why won't it let me close the recordset object when I insert a record? Code: [vbs] sqlTxt = "INSERT INTO tablename VALUES ('ShopperID', '" & Date &"', '"& Cust_Name &"', '"& Cust_Password &"')" set rs = server.CreateObject("adodb.recordset") rs.Open sqlTxt,conn [/vbs] Whenever I use rs.Close, it tells me that the operation cant continue while the recordset is closed.
SQL Insert
I am getting syntax errors when trying to insert my form. This is what I am doing: INSERTSQL="INSERT INTO EPR_PTS_ISSUE_TRACKING (Issue_Type, Request, Issue_Title, Issue_Desc, Application, Status, Created_By, Date_Entered) " INSERTSQL=INSERTSQL & "VALUES (" INSERTSQL=INSERTSQL & "'" & Issue_Type & "', " INSERTSQL=INSERTSQL & "'" & RequestNum & "', " INSERTSQL=INSERTSQL & "'" & Issue_Title & "', " INSERTSQL=INSERTSQL & "'" & Issue_Desc & "', " INSERTSQL=INSERTSQL & "'" & txtApplication & "', " INSERTSQL=INSERTSQL & "1, " - The error is between this line INSERTSQL=INSERTSQL & "'" & Created_By & "', " - and this line. INSERTSQL=INSERTSQL & "sysdate,"') " set rs=cn.execute(INSERTSQL)
Get Last Insert?
How can i get the last inserted record in an ASP ACCESS combination? Code:
Merging Upload Form And Email Form
Im having problems with my form, separately both forms work perfectly, but having problem sending the email once submitted, however the upload fuction is working fine. The message im getting is, Request object error 'ASP 0207 : 80004005' Cannot use Request.Form /forminfo.asp, line 42 Cannot use Request.Form collection after calling BinaryRead. Heres the script Code:
|
TRACKER
