Input Data In The Table List
I use while-loop the show the table content in web page. e.g (bookingno,
booking date,customer no)
However, the client need me insert one column (confirmdate ) and allow the
user input and update the date .
I use while-loop the show the table content in web page. e.g (bookingno,
booking date,customer no)
However, the client need me insert one column (confirmdate ) and allow the
user input and update the date .
I want to have a form like a table of record. If I let user input number of record to be insert in advance, how can I make a form that having number of rows of input? For example:
Number of records : 5
Then I need a input form like a table with the column and 5 row like Excel format.
The form:
Title Row : No. | Dept ID | Emp ID | Base Salary |
Input Row1 : 1 | | | |
Input Row2 : 1 | | | |
Input Row3 : 1 | | | |
Input Row4 : 1 | | | |
Input Row5 : 1 | | | |
I'm thinking all my input will be array. Then when user submit I'll split it and insert to DB. Code:
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
I already know how to create a drop down list that reads from a database. However, how can i make a drop down list that reads from a table but it automatically selects a specific row instead of the first row?
View Replies View RelatedI have drop-down list with product categories and next to it I've got a table with list of products. I've managed to make them to read the data from the data base. In drop-down list i have names of 6 categories and in the table i have names of all my products I've got in the data Base, but i couldn't make the table showing only those products depending on which category name has been selected in the drop-down list.
View Replies View RelatedAssume there is a table called Item:
and fields Itemcode Customercode
now a customer may have one or many items(itemcode)
Now the issues are, Customercode can be zero or a code value.
NOw i want to put a do while loop to get all the records as comma seperated format
TempItemcodest=0
select * from Itemtable where customercode=customervalue
Do while not Rs.eof
TempItemcodest=TempItemcodest & "," & rs.fields("Itemcode")
rs.movenext
loop
TempItemcodest=TempItemcodest & "0"
so i am adding a zero at the begging and end to have the commas seperated properly.
is there any better way to do this?
I currently have a set of documents in a directory that i need to list in a html table. Is there any way to generate the table with the documents listed instead of having to update the table manually everytime a new document is added to the list.
View Replies View RelatedAnyone have any advice on getting a recordset of all tablenames in a database? I have an access database that I am constantly adding tables to.
I want to have code that will lookup all tables and populate a selectbox with the tablenames so that I can click to look at each table individually.
I would like to know if it is possible to fill in an access table through a select list inside an APS 3 web page. If yes, how ?
View Replies View RelatedI'm creating an online shop which has an area showing the top ten best selling products. I'd like to generate the list of the best selling products from my OrdersDetail table (which is table showing listing purchases made on the site), ordered by the most popular at the top and the least popular at the bottom.
I thought if I could use the SQL DISTINCT command this would create a list of products without duplicates, then if I could COUNT them I'd generate a list of the most popular products in the OrdersDetails table. This nearly works but the list won't ORDER BY the COUNT column (I get an error). This is my code so far:
SELECT DISTINCT ProductDescription, COUNT(ProductDescription) AS bestSellers
FROM OrdersDetail
GROUP BY ProductDescription
I have a sql server 2000 table with a comma delimited list of ids. there is a seperate lookup table with a desc for each id.
I need for this data to be retuned in the same order in which the data was entered into the database. right now it is returning ordered by the id from the lutable.
I would like to send the same email to every email address that I have in a table.Only complication is that some records have an email address and some don't (some people dont have email addresses.
I had a go and made an array and used the len(email)>0 idea, so that if no email address, skip sending and email. Guess just after some standard code, nothing fancy. The site is on a commercial server running win 2000 .
I have an .asp page that contains a drop down menu, that when a selection is made, reformats the page to one of 22 different .asp pages. When clicked, the drop-down disappears and the options from it are formatted as a list on the left hand side of the page.
I need to format this so the list is in 3 columns, with the secection bold. I think I need about 4 if..then statements, but I've never done this before...here's the specific code, the code for the drop-down is first, then the code for the "quick link" list: Code:
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedI have 4 ASP pages on my site & a DB for each page has a
form pointing at its DB, I thought this would be the
simplest way. You can add & submit data and you get the
confirmation page, but I am seeing no data in my DB's.
Each DB has a CHMOD of 777. Here's the link to what I am
doing most of the test just read "SOME TEXT" Code:
Hi. I maintain an asp website with many input text boxes. I need to
check all the data that is typed in for special chars. What is the
best way to do this? I need something that will always run, regardless
of browser settings (disabling of javascript, etc
I think u don't seem to understand my question. I'm not talking about ur coding. what do type in the url address to open ur htm page? is it D:messageform.htm or something using http:// ?
View Replies View RelatedI have a problem to keep the input value from user still keep. The condition when User input , let me say" Employee Code","Employee Name","Level", then the user input all the 3 field, but when the user submit the employee code not unique/already had by another record,then the problem is after that Employee Name and level input value empty again. Then How to keep the input value....with that condition.....i have no idea....
View Replies View RelatedI'm just wondering which code will be best to achieve this?
Say I have a column table called SIZE with data:
A, B, C, D, E, F, G
User can enter any value between A-G.
So if user choose size B-E and I want to display a drop down menu listing values in between A-E ie: B, C, D, E
Can someone tell me if it is possible to store the contents of a TEXT AREA
field in HIDDEN FIELD in another page after the initial form containing the
textarea is submittted....
I need to do this to seamlessly present the submitted data in an attractive
format while hiding his submitted data in the hidden field...but I am not
sure if there are restrictions of eg 255 characters for a hidden field?
I have sent form data through email using .asp before but I have never done it when you are using a form that has createelements involved. I have a form w/ 3 inputs, two text inputs and one select combo box. if i click an add user button it will appear with another row of 2 text boxes and a combo box, and you can repeat up to as many as you need. I am trying to figure out how to mail all of those values to someone. Is there an easy way. Below I will attach the code that I use to name the fields when they are generated maybe it will help....
<SCRIPT language="javascript">
counter = 1
function addRow(id){
var tbody = document.getElementById(id).getElementsByTagName("TBODY")[0];
var row = document.createElement("TR");
row.setAttribute("id","tr"+counter);
var td2 = document.createElement("TD");
var input2 = document.createElement("INPUT");
input2.setAttribute("type","text");
input2.setAttribute("name","pName"+counter);
input2.setAttribute("id","name"+counter);
td2.appendChild(input2);
var td3 = document.createElement("TD");
var input3 = document.createElement("INPUT");
input3.setAttribute("type","text");
input3.setAttribute("name","userName"+counter);
input3.setAttribute("id","prc"+counter);
td3.appendChild(input3);
var td4 = document.createElement("TD");
var input4 = document.createElement("select");
input4.name = "Role"+counter;
input4.id = "Role"+counter;
option = document.createElement("OPTION");
option.value ="Admin";
option.text = "Admin";
input4.add(option);
option = document.createElement("OPTION");
option.value ="Read";
option.text = "Read";
input4.add(option);
option = document.createElement("OPTION");
option.value ="Read/Write";
option.text = "Read/Write";
input4.add(option);
td4.appendChild(input4);
row.appendChild(td2);
row.appendChild(td3);
row.appendChild(td4);
tbody.appendChild(row);
counter++;
}
</SCRIPT>
I'm using the detailsview to perform edit and insert of new records via an
object datasource.
If an error occurs on the insert, I want to preserve the data the operator
tried to input, along with my error messages. Currently, it appears that the
detailsview is trying to rebind after the error, to the empty/null detail
item(on insert it is null), and thus I lose all the operator's input. Can
someone suggest the proper way for me to achieve the persistence I'm looking
for?
anyone know any homepage that might help me to list the data out in a page. i wanna do it like in 2pages that one is going to be the one who maintain data. another one is to list all the data out from server
View Replies View RelatedThis is just a test before i apply to my system. I have a student:
Table: Pelajar
pelCode : 1001 (datatype: Number)
pelName : Michael Lee (datatype: Text)
countryCode : US (datatype: Text)
Table: Negara
countryCode : US (datatype: Text)
countryName : United States (datatype: Text)
i want to display this student's country name in the dropdown list as a selected country name and at the same time, populate all country names in the dropdown list. but, i can't make it. i saw the selected country name is country name that at the 1st row of table Negara ......
I am trying to align this piece to the data table.Here is the code. Please take a look at the word doc2 and tell me what am I doing wrong.
<%
Do Until objRS.EOF
Response.Write("<a href='Page2.asp?tnum=" & objRS("Ticket_Number") & "'>" & objRS("Ticket_Number") & "</a><br>")
i have field company_name and what im trying to do is
A
Abrahams Company Alexs company AZ''x Company
Adams company Adrians Company
B
Bills company
Bobs Compay
I want the names spread over 3 columns and by alphebet category. can yous ee by the example what i mean? and is this easy to achieve?
I have a little code to add multiple items to a shopping cart based
page. This code works perfect, but it adds all of the info to the
same input fields every time it loops. I need it to change the input
names each time it loops. Here is the code:
How do i add data from table to cookie? I mean, I have an excel style table at website that is read from database via query, and what I want to do is add information, that is at the same line with the "apply" button, to a cookie for further use?
View Replies View RelatedI would like to display the data in a table like first 50 records in a column and next 50 records in another columns.
View Replies View Relatedsql = "SELECT [R.oriAddress], [R.oriCity], [R.oriPostcode], [R.oriState], [R.oriCountry], " & _
"[R.mobileNo], [R.homeNo], [R.resDate], [R.resTime], [R.surveyDate], [R.surveyTime1], " & _
"[R.surveyTime2], [R.moveDate], [R.moveTime1], [R.moveTime2], [R.destAddress], [R.destCity], " & _
"[R.destPostcode], [R.destState], [R.destCountry], [R.resType], [R.resStatus], [R.staffCode], " & _
"[S.staffCode], [S.staffName], [C.custName], [C.custIC] " & _
"FROM (Reservation R " & _
"INNER JOIN Customer C " & _
"ON R.custCode = C.custCode) INNER JOIN Staff S " & _
"ON R.staffCode = S.staffCode " & _
"WHERE R.resCode = " & id
i used sql code above to display data in a table. basically, the flow is like this. when there is a new reservation, a staff will be assigned to handle that reservation from the beginning until the end. before this, i just display a staffCode that retrieved from Reservation table.
then, i made changes to display staffName and removed staffCode from the table (based on requirement). but, because previously, there are some reservations that have been assigned to staff, i do not have any problem to view all data in the table.
but, when i click other reservations that have not assigned to any staff, an error page came out. the default value for staffCode in the Reservation table is null. because this null value, i've got an error page. is there any steps i can use to solve it?
I have created an empty table(.mdb) with 2 columns
Order(AutoNumber) and BuildingID(text)
and i use :
cn.execute "Insert into [Temp](BuildingID) values ("&Buildingid&") "
to insert buildingID into the table
however all buildingid start with 0 with be omitted,
eg. buildingid = "00003333" after insert into the table become "3333"
i have checked that response.write len(buildingid) = 8
What is the problems?
Right i got the login page working, on my main page i have a big table in the middle with a few small tables either side of it, one of the smaller tables has a form where you can search a database, is it possible to have the results of the search appear in the main table? and is it difficult?
View Replies View RelatedI have a table outputting results as follows:
Time | Location 1 | Location 2 | Location 3
9-10 | Room 1 | No | No
9-10 | No | Room 2 | No
9-10 | No | No | Room 3
However I would ideally want it as
Time | Location 1 | Location 2 | Location 3
9-10 | Room 1 | Room 2 | Room 3
Any help on this would be great.