Read & Concatenate "n" Number Of Form Elements Into Database
I want to set up a simple database for my mom to enter her recipes into. I am going to use Access and ASP. In the database, I will have five fields (Recipe_ID, Recipe_Title, Recipe_Ingredients, Recipe_Instructions, and Recipe_Image). When my mom goes to enter a recipe, I want to ask the form to ask my mom how many Ingredients?
She will then specify "n" number of ingredients which will cause the page to display "n" number of text boxes. I can figure this part out myself. When the form is submitted, I want a script that will read and concatenate the ingredients, wrapping <li> tags around each one. The challenge for me is the reading of an undetermined number of form elements?
View Replies
ADVERTISEMENT
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:
View Replies
View Related
Does anyone know how to get the number of input tags contained in a div tag? I am trying to build a dynamic list of checkboxes from a database and I don't know how many checkboxes i have until the form is built to do some validation.
Probably using client-side javascript - something like
var obj = document.all.tags("div").item(0)
var mydiv = obj.id.indexOf("chk0100")
But I am not sure how to specify the name of the input tag.
I dont know what the above statement does.
View Replies
View Related
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:
View Replies
View Related
Is there any way to extract the form elements' value without submitting the form. I want the value of the form element be used in the script written in the same page without submitting the form.
View Replies
View Related
Here is my input box which has the employee id.
<input type=hidden name=empid value=40578>
In my SQL query, I would like to call the value of "empid" textbox in my SQL Query. How can I do this? Code:
View Replies
View Related
My client wants File Uploading in ASP that i can do but the requirement says that i should have one FORM FILE FIELD first to browse the file to upload.
and the moment i click the browse button of first FILE FIELD, a second FILE FIElD is generated beneath it and when the user clicks on the second Browse button it generates the third and this process goes on. Untill the user clicks the upload button to upload all the files.
I know this sounds stupid as it is much easy to provide 5 Form File fields and if user wants more then another five is added on another page, but ti is clients requirement .
I dont know how to dynamically Generate Form FILE FIELD for browsing file to upload AT RUN TIME .
View Replies
View Related
I have a problem with reading data from a form element(s). Instead of using a Type=Submit, I have chosen to use a hyper-link to call a select case structure which adds, edits or deletes a record depending on the contents of the action property.
here is a couple of lines showing two text box's in my form, directly following is the href that passes data to the select statement.
<td><input type="text" name="Desc" id="descid" size="55" /></td> <td><input type="text" name="Units" id="Text1" size="4" /></td> </form>
<td align=right><a href="<%= SCRIPT_NAME %>?action=add&jdate=<%= dDate %>"><img src="Web-add.bmp" alt="Add" width="63" height="25" border="0" /></a></td>
I would like to include the values from the form elements in the action string but have so far drawn blanks. I have attached the full form code.
View Replies
View Related
I asked a question earlier about creating dynamic pages.
I want to know if its possible to create dynamic form elements based on a condition equating to true.
e.g. as you could have dynamic texts when a condition is true.
Could i have dynamic form elements when a condition is true
e.g. response.write(create radio button)
or create combo box etc
or how is it done ?
View Replies
View Related
How can I check to see if a form element exists on a form that has been submited? I have a load of checkboxes called box1 box2 box3 etc. I want to create a loop which gets the value of the box (checked or not), but there is an unknown amount of boxes so I want a loop:
Do While (box(i) exists)
check value
i=i+1
Loop
how do I do this?
View Replies
View Related
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?
View Replies
View Related
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
View Replies
View Related
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
View Replies
View Related
i recently just uploaded an access database only to find that it has read only persmission, so any adding, updating, deleting etc.. doesn't work anymore. the file became read only when i uploaded it. How do i change the read/write access to this file online?
View Replies
View Related
Im just not sure how to go about it because im new to asp. I want to write an ASP script that will read a money amount from an SQL database and when money is taken through a payment it will change the value in the database.
View Replies
View Related
i was getting error as follow while inserting record in database using objrs.AddNewstatement.
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
i have setup a virtual directory. i tried the steps u suggested in both WWWroot folder and my Virtual directory .still i m getting the same error.
View Replies
View Related
I need to be able to find a record by a unique code from a ms access database,take the value of the price field in that record,then store the value in a JavaScript variable.
These variables are being used for calculations.
So can I change the hard coded JavaScript code
e.g.
var price1=(229); // 229 being $229 the price for item1
to
var price1=(item1); // item1 = 229 - value read from database and stored in variable price1.
View Replies
View Related
Is there a way to read in information from a form? I need to read it in then test it and then submit it into a table. Is this possible without JavaScript? I have done this with javascript but having problems with submission.
View Replies
View Related
Actually, I do not know why i can not add records to my access database table by using asp code, I get an error that tells me that the database file or object is read only file even though the file is not readable only from its proprties, I need some helpful information to solve this problem.
View Replies
View Related
how to connect to a mdb database and read from it. But how can i make a simple textarea that takes inout and writes it.
all i want is a textarea with submit so i can write to my database only with a couple of words i dont have any code so fare apart from read the data and connect.
View Replies
View Related
Trying to update 2 fields. my database is read only..
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
/sendd.asp, line 16
this is line 16: rsAddComments.AddNew
is this something to do with my server directory permissions?
code .....
View Replies
View Related
I have a database that was originally in Excel. After modifying it, I have saved it with .txt and another one with .csv format. DB.txt (Text (Tabl delimited)(*.txt)
DB.csv (Text Comma Separated Value) (*.csv). What is the command/statement in oppening database record for these formats?
View Replies
View Related
can any one help me to read the datas from the excel sheet and match it with the database.i will be thankful to you if u provide me a sample code.
View Replies
View Related
My database is working perfectly and I am still getting the following error:
Microsoft JET Database Engineerror '80040e09'
Cannot update. Database or object is read-only. /raven/aspBoardFunctions.asp, line 144
I called my new webspace provider and they said you should be able to change permissions with my ftp program. I looked and viewing permissions is the only thing I find. Any suggestions? Code:
View Replies
View Related
I have an asp app that connects to an Access database. It works properly at my work on XP with IIS5.1 running.
I zipped up the asp pages and the Access database and emailed it to my home, which is XP and runs IIS5.1. When I recreate my work environmnet at home and try to update the database I get the following error when the code hits my AddNew method.
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
I've tried going into Access/Security/Tools/User and Group Permissions and setting all the tables to be able to update. I've even created new ODBC drivers, but neither has worked. The database is not set to read-only.
View Replies
View Related
I am trying to add a record to a database. I keep on getting the error message:
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/client_add_db.asp, line 31
Line 31 is rst.AddNew
I have checked the attributes in the folder - it is not set to read only. For some reason the folder that the DB is in will not let me make the folder NOT read only - I have even tried the attrib command as recommended by ms in the cmd but that will still not change the dir to not be read-only although that did make the db not read-only.
View Replies
View Related
I wanna read binary data from database with ADODB.Stream object. So I wrote code..
---------
<%
query = "SELECT * FROM Categories"
adoDB.DefaultDatabase = "Northwind"
adoRs.Open query, adoDB, 1
Set rec = Server.CreateObject("ADODB.Record")
'read [Picture] column.
rec = adoRs(3)
------------
And the 'rec' TypeName() is 'Byte()'
But I can't get it to ADODB.Stream. How Can I do? Or Can I read binary column to another way?
View Replies
View Related
Everytime I try to use the rs.update command I get this:
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
View Replies
View Related
I was on here recently about error 500 messages (which I managed to sort by replacing the forum).However I am still getting error 500 messages with two sites. Both are trying to update information in the database. It displays info correctly, just doesn';t update. But everything is ok afaik and it works fine on my pws.
The errors are as follows (from different pages):
error type 1
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
error type 2
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
View Replies
View Related
String a=Test
String b=test@test.com
How cn I concatenate this to get
String c ="""Test"" <test@test.com>"
View Replies
View Related
I want to know the number of records in my database when performing a query by sql. I am getting -1 as number of records.
<%
connectme="DSN=hotel"
sqltemp="SELECT Count([All Rooms].Engaged) AS CountOfFREEROOM FROM [All Rooms] GROUP BY [All Rooms].Engaged HAVING ((([All Rooms].Engaged)=False));"
set rstemp=Server.CreateObject("adodb.Recordset")
rstemp.open sqltemp, connectme, adopenstatic
howmanyrecs=rstemp.recordcount
response.write howmanyrecs & " records in<br>" & sqltemp
rstemp.close
set rstemp=nothing
%>
my project is on an online hotel reservation. I want to have the number of rooms available each time the page loads.
View Replies
View Related
I'm using the script below to limit a visitor at my site to only be able to post a form 5 times. I believe the reason I've received more e-mails is because the visitor closes their browser then opens a new one and they can post two times each time they do this.
<%
count = Request("count")
if count = "" Then
count = 0
Else
count = count + 1
End If
%>
<%
If count < 5 Then
%>
<a name="step5"></a><input type="submit" name="Submit" value="Submit">
<%
Else
%>
This form has been submitted 5 times. Please contact me for more information.
Can somebody show me how I can do this so it will only work twice within a 24 hour period even if the visitor closes their browser and opens a new one? I would think cookies be the answer to this but what happens if the visitor has cookies turned off? If this would be a good solution can somebody please help me out? I'm not familiar with cookies.
View Replies
View Related
How do I concatenate this string value? datatype is text.Code:
chkboxvalue = RS("feild1") & RS("field2")
<%
Response.write"<tr bgcolor=silver >"
Response.write "<td><input type=""checkbox"" name="" chkboxvalue "" value=""chkboxvalue""></td>"
Response.write "<td>" & RS("field1") & "</td>"
Response.write"<td>" & RS("field2") & "</td>"
Response.write"</tr>"
%>
I am getting an error:
Microsoft VBScript runtime error '800a000d'
View Replies
View Related
