Sending Data From One Table To Another
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
ADVERTISEMENT
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 ....
View Replies
View Related
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 Related
i used a check box in a loop:
<input type="checkbox" name="Inv" id="Inv" value="<%= rstMain("TR_ID")
%>">
n transfered the value to the next page...wats the best way to transfer
the data to a 3rd page
View Replies
View Related
How can I through asp figure out if a page is opend through a regular link
or from form post method like this :
<form action="something.asp" method=post>
//code...
<input type="submit" value="Ok">
</form>
View Replies
View Related
Does anyone know how i could send bulk info from a database to an email? Like an order confirmation for more than one product? or where i could find some info?
View Replies
View Related
I've been asked to take data from a form and then send it to a vbscript. The client
has made a vbscript that performs a calculation (i haven't been told a great deal
about it yet) and now they wish to put it online, so that when a user enters
data into a form, it sends the data to the relevant fields in the vbscript.
I don't know a great deal about Visual Basic, so if anyone could explain how i might be able to go about this ..
View Replies
View Related
Im doing an asp.net-application where we have an external asp-form in a iframe on the mainpage. On submit, the form sends its data through method="get" to a page with a frameset (i couldnt get the data through POST).
In the framsetpage, the data is receieved in the frameset and then sent to the lower frame through querystrings. The lower frame is also an external asp-page.
My problem is this, the .NET-platform is using utf-8 and some other way of URL-decode things then the old platform did. So for example the swedish letter 'Ö' is in .NET URLdecode '%c3%96' and in the old asp-way '%D6'. The asp-page has no idea what '%c3%96' means so the formdata is a bit corrupted on arrival.
What i was wondering is if there are any ways of convert the new way of urldecode strings to the old way? Preferably in C# since thats the site's main programming language.
View Replies
View Related
I have a SelectBoxes.asp page that is working with multiple selection
dropdown boxes to extract data and total the selection prices.
Tom & Bob were kind enough to give me a big help getting this page
working and it's working just fine, no problems with this page.
However I then would like this data e-mailed using jmail (my host insists
on this method) and that is the function of the sendEMail2.asp page.
This is failing and only giving me a HTTP 500 - Internal server error and
I'm at a loss as to what's wrong. Code:
View Replies
View Related
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>
View Replies
View Related
I have a form page with a drop down menu of article types that can be submitted. On my processor page where I enter the article, I want to be able to send an email to the person who is responsible for those article types, letting them know a new article has been submitted. I have a table set up in my access database, with an article type and email associated with that which I would like to send an email to.
On my processor page, i would like a SQL statement something to the effect of:
SELECT * FROM table_artemail WHERE art_type = request.form(art_type)
but i can not seem to get it to work.
Also, when I get that working, i plan on using cdonts to send the email. can I just create a variable called "mailto" and have a statement such as: Code:
View Replies
View Related
I have a form that is being sent over to an asp page. About 5% of the time, the form fields are blank when the ASP page is reading them. But when the user hit the submit button, they were not blank, because I have client-side validation that will not allow the submit to occur if any of the fields are blank. When this occurs, all the fields in the request.form object are blank?
View Replies
View Related
I have a member registration form that when the user clicks the submit button the form info is sent to a file name validate.asp.
The file validate.asp checks all the information to see if it correct and now I would like to have the data that was submitted added to an access database named members into a table that I named reginfo (registration info) and I have tried numerous ways to do this and spent countless hours browsing through websites but cant seem to get it to work. Code:
View Replies
View Related
I’m attempting to insert some basic information (name, address, details) to the sql database and send a notification email (at the same time).
Right now, I can insert the information to the DB after I click submit, but how can I also receive an email? Please give some ideas how to do it.
View Replies
View Related
I'm trying to "post" a form in asp to a script off the main site.
I suppose I could do a response.redirect to the script, but am wondering if there is a more direct way to do it. Something like the XMLHttp obj in js.
View Replies
View Related
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>")
View Replies
View Related
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 Related
I 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 Related
sql = "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?
View Replies
View Related
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?
View Replies
View Related
I 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.
View Replies
View Related
Is it better to use the Recordset methods or make an SQL query string and use conn.Execute() if I want to add to a table? I figure the first might be safer, but it seems weird to someone who learnt on PHP... I'm using SQL Server if that matters.
View Replies
View Related
I have coded a form which enters data into a access table however I want the same recordset when clicked to go to another table in the same database then when clicked again to go to another table within that database...is this possible?
View Replies
View Related
If i created three different type of table. Inside these tables, they might have the same key field's name. Example:
Table A - ExecNo, Month, Year, CustCode
Table B - ExecNo, Month Year, DestCode
as u can see that these two tables have almost the same key field but they r actually keeping different data. how can i list these different data out in an asp page? it is because i am having the problem whereby.
where the table want to display data from table B, it actually misplace by table A . how can i write the sql function to differentiate both of them.
View Replies
View Related
I have a table that's holding 'open data' until it needs to be moved to another table where it is then 'closed'. I think I have my SQL statement correct to do this, but I keep getting the error below.
Quote: Originally Posted by Error Message
[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
I have verified that I have the same number of fields in each table, but I think the problem is both tables have an Autonumber field and obviously you cannot move one autonumber field overtop another one. What is the easist way to exclude my autonumber field from being inserted into my other table without having to call every single field by name in the SQL statement? Code:
View Replies
View Related
I am wanting to add three fields that adds the totals from a column. Here is my current code that writes out my data from my table: Code:
View Replies
View Related
I have a txt file and i would want to import many data fron txt and put in a table fo access...
For example
txt_var1 in table prova filed filed_var1
txt_var2 in table prova filed filed_var2
assuming my txt file is named test.txt and my mdb prova.mdb and table tabella1
View Replies
View Related
In an asp page, there is a table defined.
I need help in:
1. populating letters in the bottommost row randomly
2. On selecting any letter in the bottommost row, and pressing any column in the top rows (Row1 Col1), the letter should be displayed in the desired location (Row 1 Col1)
View Replies
View Related
Is it posible in ASP to hide a table that brings no data when you query a data base and if you have two tables that brings different information?. If it's posible, can you guys help me with this one please?. The table that I would like to hide is the one that brings no data.
View Replies
View Related
I want to display data like the following:
<table>
<tr>
<td>1 to 10 records</td><td>11 to 20 records</td><td>21 to 30 records</td>
</tr>
<tr>
<td>31 to 40 records</td><td>41 to 50 records</td><td>51 to 60 records</td>
</tr>
</table>
I tried with rowcount it is displaying in a row ancontinully with if conditions also. how to do this or any example script.
View Replies
View Related
I'm involved in this localization project, and part of the process is
taking the english content out of the pages and storing them in the db
as key/value pairs (which we call tokens).
Would be any performance problem if all of the tokens were stored in
one table, for each language. Say there’s 1000 Tokens, and there’s 50
languages supported, then that would be 50000 entries. It's hard to
guess how long each string will be... Ok, that’s not very big, but
what if we were to load that up in the application scope, so it would
be easily accessible (maybe in a dictionary object for each locale).
Do you forsee any problems in that? Or does ASP offer some other
caching mechanism for this?
View Replies
View Related
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 .
View Replies
View Related
i have Products table and how can i put them into a combo box??
View Replies
View Related