I develop a .asp app that reads its data from an Access DB "A", and I have a desktop app with a FoxPro DB "B".
How can I insert data from a table in DB "A" to a table in DB "B". Im new to asp and I really know only the basic's, so who can guide me to a tutorial or where can I dowload an example...
I'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
View Replies View RelatedIn ASP, when we pass data between pages, we usually pass by query string. If
we pass data by query string, that means we need to use submit button, not
by regular button, and the form will pass to the server since it's GET or
POST request. But if just form-to-form communication, why we need to send
the form to the server?
<form action="process.asp" method="get">
//form controls
<input type="submit">
</form>
For example, http://www.myserver.com?id=100&name=joe
Form.QueryString("id")
Form.QueryString("name")
I have a form with a textarea and a submit button and that button will call an asp file and this file will query the database. My question is how do I pass the data to the html form so that it will be displayed in the textarea?
View Replies View RelatedI'm new to this and I'm trying to take data collected from this nice form I created, and pass it to a MS Access database. To simplify my learning, I created a database name test.mdb. It has one table, customers. The table has 3 fields, name, address, and phone. There are 3 form fields that have the same names as the table field names.
View Replies View RelatedOk i have a shopping cart got everything pretty much going but it didn't allow for quantities to be updated. So in my cart view i decided to add a quantity box so u could enter a new value and then click update to update that item.
However i don't know how to grab the value from the txt box.
I have the code working for all the db updates cause i tested it by hard coding it in. I just cant grab the value and pass it on from the txt box....
How to pass data back and forth between ASP and JSP page?
Let's say I have Java objects, how to pass the data back to ASP page?? Or
ASP has data, how to pass the data to JSP page??
im currently working on a login system, and its the first time i have had to use an inner join. basically i have 2 tables, an attendance table and a member table. the attendance table contains the following: Code:
View Replies View RelatedI have two tables. Table1 contains the names of training classes being offered and Table2 has the names of the people who are going to attend. The code below lists the classes being offered and a links to add, remove, and view other employees that are attending that class.
I only want the remove button to appear if you have already signed up for the class. I also only want the remove button to appear if the username cookie equals the username of the person that is signed up for the class which means the employee that wants to be removed from the class has to do it. My insert code (not shown) puts the username in the cookie into the Table2.
I tried using this code to accomplish what I wanted above but it does not display the remove button if the person is signed up and trying to remove themself. Code:
if i wanna list data from 2 tables at the same time, is that possible. i have 2 tables: itemsorderd and orders, which both have OrderID.
now i want to list the 2 fields from itemsorder which are Quantity and ProductID, as well as all the fields from orders, which contains the shipping details. how can i do that in a single SQL statement ? also if i wanna delete all these datas associated with the OrderID, how can i do that ?
if there is two tables. for example
Table 1: IC No, Name
Table 2: IC, No, Address
IC No are primary keys
There will be only one user maintaining the Table 1 then another user maintaining address only in table 2. So the second user need to retrieve the data from table 1 on the IC No. how should i do it? is it using session?
I have 3 tables, product, industry and plist. product has productID and product, industry has industryID and industry, plist has productID foreign key with productID on product table and industryID foreign key with industryID on industry table.
In the plist table I am storing the productID and the industryID's that relate to that productID..
industryID productID
1 4
1 7
1 9
1 10
etc.
What I want in my ASP page is to return the actual products that each industry serves. So for the above example my script should return the products in the product table that relate to the productID's 4, 7, 9, 10, when I search it by industryID 1. I hope this is making sense. Code:
I want to create another Database using ASP, this I can do. However, what is the easiest way to copy tables from one DB to this new DB?
I dont really want to have to write the SQL to create each table and then to use a 'select into' code for table, especially as I have around 15 tables to do!
i have 2 tables;
table01:
fields are
field01,field02,field03,field04,field05
and another table
table02:
fields are
field01,field02
when someone submits the form, i want to add the infos supplied by the user to be added to these 2 tables.
field01 & field02 shall be added to tables 1 & 2;
&
field03,field04 & field05 to table01 only
i tried using this code:
myquery = "INSERT INTO table01 (field01,field02,field03,field04,field05) VALUES ('" & f1 & "','" & f2 & "','" & f3 & "','" & f4 & "','" & f5 & "')"
myquery2 = "INSERT INTO table02 (field01,field02) VALUES ('" & f1 & "','" & f2 & "')"
adocon.execute myquery,myquery2
but this one only adds to the first table.
can someone tell me how to fix the problem?
I have 3 tables (MS Access) and I would like to display the content of all three tables alphabetically on a .asp page I have no problem displaying a list from each of the individual tables, but I am stumped when I try to display a combined listing..
View Replies View RelatedI'm trying to pass a piece of data i get from a query using a different form's passed values. This is how I get the data into the new form and how I try to pass it to the next asp page query.
<td valign=TOP width="168"><form action="HouseDetail.asp" method="post" name="MLS" id="MLS"><input name="MLS" type="hidden" value='<%=oRs("ML_Number")%>'><input name="Submit2" type="submit" value="Get Details"/></form></td>
The value='<%=oRS(ML_Number")%>' generates a real value like '2403943' - and the field I'm trying to use this value in the qry is expecting a number. But even passing the number without the single ' at both ends generates the same error message. Code:
I have two tables Property & Landlord. I have a form and when it is filled in and submitted the information should be sent to the two tables, but i cant seem to get my head around this problem.
View Replies View RelatedImagine an asp-script that retrieves data from a database and returns an HTML with table of the retrieved data, allowing user to edit some values and delete rows. The issue occurred after deleting a row. Lets say the initial table was: Code:
View Replies View RelatedI know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
View Replies View RelatedNow I did the following and got this error massage:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/New Folder/1form.asp, line 305
Response.Write "<td><input class="formpagetablefield" type="text" name="tradeid" size="6" Value="& trim(rsTable("tradeid"))%"></td>
I dont't know if the code below will work. Can someone tell me if it is correct in principle: Code:
I would like to pass the value %%LAST_NAME%% to another asp document.... I
wanted to pass this value by doing a response.redirect, but, it truncates the
double percentage signs
I know it works on a SUBMIT
example:
<form>
<input type=text name="lname" value="%%LAST_NAME%%">
</form>
but, I would like to skip the submit and do a response.redirect...
even if I create a variable using 'server.urlencode' it still truncates the %%
example: response.redirect "newfile.asp?lname=%%LAST_NAME%%"
I'm trying to add a variable to the url that is going to be sent but when it is sent my additions are removed! I've tried numberous variations of action="caldelete.asp?curid=<%=iRecord%>" and every time it removes everything! What am I doing wrong? Code:
View Replies View RelatedDose anyone know how to pass more than one value in a Go to Detail Page? The code I have so far is this... Code:
<A HREF="advertiser-basic-keyword-detail.asp?<%= MM_keepForm & MM_joinChar(MM_keepForm) & "TimberSpecies=" & Recordset1.Fields.Item("TimberSpecies").Value %>">Edit</A>
The code above passes the value of the "TimberSpecies" to the next page. I would also like to pass the value of the "CategoryTitle" to the next page at the same time.
The "CategoryTitle" is also in Recordset1.
How can i pass value from drop down list in 1 page to another pagei used onsubmit when i click the value in the drop down list and use request in another page to get the data.but why it still cannot works
View Replies View RelatedI’ve used java script in my asp page for the new windows utility and also for link to .js extension (get calendar). Ok let see what I’ve done…. Within elseif : (see asp comment within coding page).
IM – date – open
IM – date – close
IM – date – all
What is a problem now, I try to test for calendar function (java script) in “– IM – date – all “.
I can retrieve date from javascript file -> ‘date-picker.js’ and insert date into these two textbox, but when I want to send/pass these two values (click button continue) to next asp page called byDateIMA.asp, browser told me that ‘error on page’. I’ve no idea about this problem. Hope anyone can help to solve this problem.
I'm trying to make my site as dymanic as possible. Code:
View Replies View RelatedI have a simple form with a textbox, a combobox and a submit button. I want to also be able to pass the "values" of the textbox and the combobox in the URL. How do I do that? DO I need to set that up in the function? I know this must be simple becuase I can not find any information on how to do it.
View Replies View RelatedI want to pass the value of the cookie created in VB to ASP. This doesn't work. Any idea?
<script language=vbscript>
document.cookie="mycookie" ' also tried with
document.cookie="name=mycookie"
</script>
<%
z=request.cookies("mycookie")
response.write(z)
%>
....
Has anyone had or heard of IIS not passing emails or SSL connections, thereby disconnecting or making the server useless?
I had a virus that seems to have done this.
I am using this code to display a dropdown list of employees
How do i pass the selected name to another page, all i need to pass is emp_id? Code:
how do you go about passing a name on after a login->doLogin->MembersArea so that you can print Welcome username?
View Replies View RelatedI want to pass the value to two frames and two pages after hitting the
submit button If my form I have this:
<form method="get" action="search2.asp" target="fSearch2">
I want to pass crPN to below as well
action="search3.asp" target="fSearch3"
I am having a little problem figuring this out.
i'm trying to pass a Request.QueryString("date") in an SQL statement like this:
sql = "SELECT COUNT(*) AS sum FROM logs_main WHERE Termination='OK' AND CallDate >"& Request.QueryString("date") &""
When i explicity write CallDate >'2006/12/01' it is OK
But when i use the above code ,where e.g date value is 2006/12/01, then it doesn't work.
How can i pass a date in an sql query??