Repeat Region - Form Fields
I am displaying multiple records returned in a resultset using a Do While loop. I've set the form field names like the following:
<select name="fieldnameA<%=ID%>"...
where <%=ID%> is a hidden field on the page that holds the id value for each record.
I want to append that number to the end of each form field
So, "fieldnameA" would be fieldnameA1 or fieldnameA2, etc.
I thought this would work, but the field names remain the same for every record...i.e. fieldnameA just repeats and the hidden field value isn't appended to the end of the field name.
Is there a way to append the value of the hidden field to the end of the form fields? So, the form field names are different for each new record displayed?
View Replies
ADVERTISEMENT
I have information pulled from a database and it works ok. However, I have several records in each repeat region and I want to add the values in these fields together.
So in the first record I have
cont1 = value from database (1000)
cont2 = value from database (2000)
cont3 = value from database (1000)
Second Record
cont1 = value from database (2000)
cont2 = value from database (1000)
cont3 = value from database (1000)
Total For that line is = (8000)
View Replies
View Related
Not sure if this is possible, I have a memofield that contains a data string
(e.g. name1, name2, name3, name4 .... name 30) I would like to represent the
data in a table so that each name is on a different row eg
Name1
Name2
Name3
Name4
etc
Name30
View Replies
View Related
how do I achieve this?
Today's News
Date
Title of current news
Short DescriptionTitle of 2nd newsTitle of 3rd news Note:
I want the current inserted news to be on top with short description and the previous news just to display the title only.
View Replies
View Related
I have some fields in the database that are not used in certain records, the problem being of course the it displays these feilds in the webpage and then the size of the webpage gets rather big, full of empty spaces .its just to fields in particular I need to apply this to?
View Replies
View Related
I am on the last part of my ecommerce site but I've hit a problem I can't seem to figure out. I have an asp page with an Orders table that lists the OrderID and the customer name and what they have bought.
Then if you click on the ID number you go to a details page that lists their name, credit card details, address etc. Also I want to show all the items that they have purchased but so far it only enters the first item they've purchase. I have tried making just the products a repeat region but I get an error when I do that.
View Replies
View Related
I would like to retreive a list of records from my database using repeat region but I need 2 records in 1 line.
Any idea on how to do this?
View Replies
View Related
Anone know of free code available to create a vertical repeating region? (I've found code for a horizontal repeating region.). I want to display my data from an Access table vertically, not horizontally.
View Replies
View Related
I have a database that displays its records on a webpage, The information displayed on the webpage is included in a repeat region so that the related records repeat down the page.
I want to add the totals of the displayed records at the end of the page. How do i do this. Im assuming that it goes outside the repeat region? Does anyone have any code or a walk through of how this is done?
View Replies
View Related
i am not sure if i am on the right section to place this thread, but my code is in .asp and i am using a access database and i wanted to link a text to another text in a seperate page that contains a repeat region that its pulling from the access database.
this lists like 7 records at a time and i was using the anchor method to link the text from the home page to the text in one of the fields that is in the repeat region and was not succesfull, It would take me to the page but would not go to that specific recordset that i have placed the anchor.
View Replies
View Related
I have a single access database file with several tables, two of which are tblPanels and tblAssignedPanels. The table tblPanels has a panel ID number and a name for the panel. In the table tblAssignedPanels, there is a record ID, the panel ID of the panel that has been assigned, and the user ID of the user account the panel has been assigned to.
Then, there is a third table (tblManuals) that has a manual ID, the ID of the panel the manual is for, and the path to the manual on the server. What I would like to do is have a repeat region that lists all the panel names (from tblPanels) that are assigned to the currently logged in user based on userID (assigned panels found in tblAssignedPanels), and makes each a link using the path in tblManuals.
View Replies
View Related
Currently, my repeat region is showing all of my repeated records that are being brought in from my database. I would like to display these records in a confirmation page, but I am having problems having them display in my confirmation page.
I tried to assign a hidden value to the repeat region, but I am getting no data to come across. Below is the code that I'm using: Code:
View Replies
View Related
I need to calculate a total based on fields in a repeat region, these values are stored in an SQL db, all are numeric and written in ASP.fields are
TOTAL_COST VAT GRANDTOTAL (Page selects records based on
field parameter and displays in a repeat region)
At bottom of page need to show total sum like
TOTAL_COST(sum of above)
VAT(sum of above)
GRANDTOTAL(sum of above)
View Replies
View Related
Ok now i am not sure if what i am trying to achive is done by css or asp code. what i am trying to do is when data is outputed on a page that has a repeat region set to a table. How do i get the rows to show in diffrent colours, eg. 1st row the baground is blue than second is green than third is blue again and so on.
View Replies
View Related
I have a dynamic driven web page which get's a select value from the menu choice.
I querry the database recordset and pull back the correct values.
I want to display them in a grid fashion. I want to limit how many items per page are show in each grid and then I'll use the standard DW behaviors to move to next page, etc.
The challenge I have is making the repeat region go left to right instead of repeating down.
View Replies
View Related
I have a page which on default will display 5 rows per page. I would the user to be able to select from a listbox (on the recordset page)and change the number of rows displayed on the page.
I have tried a page with a listbox on and submitting to itself. But on re-load the listbox returns to its default value.
View Replies
View Related
I've created an ASP/VB page completely with DWMX2004, very minimal code tweaking, using mostly the tools available in DW.
Created a Table with a bunch of columns pulling info from MS Access DB, and set a Repeat Region on that table.. I also have Add/Update/Delete pages, etc..
I've been trying to figure out how to add a dropdown box (or maybe several) to Sort on various columns..
like above the Name column, i'd like to be able to sort by Name.. then Zipcode, State, etc..
Maybe if I could Sort the table by clicking on the column Headings, that would be even better..
I have a table with 3 rows and 5 colums.. top row is where my column Headings are.. then a spacer row, and then the info pulled from DB.. i've set the repeat region just on the bottom Row..
View Replies
View Related
I have an ASP page that users print off onto headed paper, question is how
do I force a new page when the length of the data varies from at times less
than a page to many pages at other times?
I know this can be done with CSS but not too sure how to implement it.
View Replies
View Related
I have two fields that I want repeated in an ASP page. One column is a list of job duties, and the other column is a list of corresponding values that goes with each job duty. All of the values are coming in, but my job duties are not listing. Only the first job duty is being listed. I'm sure that I have my loop incorrect. Can someone give me a hint as to what I need to do? ....
View Replies
View Related
I have an INSERT statement with information being pulled(upload.form) from the form. Example, text field named SubmitIssue1 will populate field SubmitIssue field in the database. SubmitDate1 will populate field SubmitDate1, and so on. However, what I am trying to accomplish is to expand the form to allow the user the ability to add another instance of an issue where they will use the SubmitIssue2 text area.
I want to pull their name and email address from the top of the form and use it as well as this new information in the SubmitIssue2 textbox to create a new record. The information from SubmitIssue2 will populate the SubmitIssue field. HOW CAN THIS BE DONE? Please help with some examples of how this would look. Code:
View Replies
View Related
Would anyone be able to give some guideance in ASP code as to how I would repeat a section of input fields in a form based upon the number of guests that are attending an event?
Basically, what needs to happen is if 3 guests are attending, I need the Name, address, city, state fields to repeat so they can be filled in with information.
Then all of the information from the whole form is submitted which returns an email to the administrator of the event.
View Replies
View Related
I have an asp page which has a number of form fields on it (about 50). 2/3rds of these fields are used to store username (windows username) and date (todays date). I want these fields to be locked so the user cannot enter any info into them. The infor will be grabbed from the current user and the current date.
However, I only want these fields to be populated only when the left most field is changed. Once the fields have been populated the username and date fields will change with however is logged in and the new date.
View Replies
View Related
I have a form that will be filled out by users, what I would like to do is when the user selects a state from a dropdown list i want to have the City field show select options based on their state. I know this can be done but I dont remember how.
View Replies
View Related
I need to loop through all submitted form fields and place them all into 1 variable but i have no idea how. Here's what I have so far:
for each item in request.form
myVariable = "formfieldname:" & item & "formfieldvalue:" & request(item)
next
response.write(myVariable)
The problem with that is that response.write(myVariable) only prints the last field in the form.
I know that if I move the response.write(myVariable) INSIDE of the loop it will print correctly but I am not trying to print the form fields BUT I AM TRYING to store them in ONE variable.
For example:
myVariable = formfield1name:formfield1value:formfield2name:formfield2value:formfield3name:f ormfield3value:ETC ETC
View Replies
View Related
Code to email form data via ASP. Forced to use CDOSYS by 2003 server at host. It sends an email fine, but the form data is missing. Where my going wrong? Could it be the html file's form actuating the .asp file? Could it be an enctype issue? Or bad ASP syntax... Code:
View Replies
View Related
Can someone tell me how I can take a bunch of form fields using Request.Form, and put them in a array. And then, how do I send that in and INSERT sql.
View Replies
View Related
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.
View Replies
View Related
how can I send the whole form using the script below, without listing every NAME of the form. Basically I wondered if you can just put a certain code in that will send all the fields of the form without putting each NAME of the fields down indiv individualy??
My forms Name is 'conf', so I was wondering if there was a code like SENDWHOLEFORM="conf", (I know it obviously won't be that, but just to put the point across!)
<%
DIM strNAME, Mailer
strFirstName = Upload.Form("NAME")
Set JMail = Server.CreateObject("JMail.SMTPMail")
JMail.ServerAddress = "10.2.3.2"
JMail.AddRecipient "me@me.com"
JMail.Sender = "me@me.com"
JMail.Subject = "Submitted Item to sell"
JMail.Body = "Name: " & strNAME
JMail.Execute
Set JMail= Nothing
%>
View Replies
View Related
I have about 30 worker names (and their IDs in hidden fields) in one form, beside each worker I have a dropdown list with same items. When I select an item from dropdown list its ID is written in another hidden field. I want to submit values from hidden fields into another .asp page and sql db. If I use :
<%
FOR EACH name IN Request.Form
Response.Write("<BR>")
Response.Write(Request.Form(name))
NEXT
%>
I get only values from dropdown lists IDs. how to loop through all fields and get IDs of workers, too.
View Replies
View Related
I have the following asp code:
response.write "<td align=left colspan=2 class=text>" & _
"<input type=text name=ProjectDescription STYLE='width:465px' value=' " & ProjectDescription &" '>" & _
"</input></td>"
The problem I have is when ProjectDescription contains a ' the data gets truncated. How can I resolve this.
i.e. ProjectDescription=doesn't
View Replies
View Related
I have created an email form in which all fields must be completed. If all the fields are not completed "submit" causes a refresh using response.redirect, Problem is allthe fields that were previously filled in are empty.How do I keep the values of the fields on refresh?
View Replies
View Related
I have a form submitted with a form field called contents. This could have loads of text in. What i need to do is scan this field for words that match the text in a database record called PAC_WORD. This could match 3 or 4 of the words put. Basically for each word picked up I want to write " This item found is not allowed
View Replies
View Related
I have a asp page that has a form that I have to submit to a third party website.if their is a way to create form values using asp to submit the secure data without having it in a hidden field where it can be seen when viewing page source?
Currently I have my asp code writing out hidden form fields using the response.write when the page loads then after everything is loaded JavaScript submits the form.
View Replies
View Related
