Pass Data Between Tables
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...
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Pass Data
In 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")
Pass Data To MS Access Database
I'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.
Grab Data From A Text Box And Pass It On!
Ok 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....
Displaying All Data From 2 Tables
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:
Comparing Data Between Two Tables
I 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:
Retreiving Data From Multiple Tables
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:
Creating Tables And Copying Data From One DB To Another?
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!
Adding Data To 2 Tables At The Same Time
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?
Creating Dynamic Tables In Dreamweaver To Display Tables
I 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.
"Back" Button Issue On ASP Generated Data Tables
Imagine 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:
Continue "DATA-TABLES"
Now 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:
Pass %%
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%%"
Trying Pass A Value Through The URL
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:
Pass More Than One Value.
Dose 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.
Pass Value
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
How Do I Pass Parameters Through The URL?
I 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.
Possible To Pass Cookie Value From VB To ASP?
I 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) %> ....
IIS 5 Will Not Pass Emails Or SSL
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.
Pass Variable
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:
Pass To Two Frames
I 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.
Pass Date
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??
Pass Variable Value
I want to pass 2 auguments to this command like below, but the red line of following java script (server side) doesn't work, which means it doesn't took siteid and whosent vaule. <% siteid = Request.QueryString("SiteID"); whosent= Request.QueryString("WhoSent"); objShell = Server.CreateObject("WScript.Shell"); objShell.Run("cmd /c call rsh host -l username lockunlockRSL.sh siteid whosent", 1, 1); %> Does anyone know how to pass 2 varible siteid and whosent value to this command if not use batch file?
Pass Value Without Form?
A fill in a form which is "request.asp", then submit to "department A" to wait for approvement. for "request.asp", i use simple method "request.form()" to pass value to another page. ques. 1:when "staff A" want to pass the form to "department A", how should i do this? store the form's data in database? then system automatically retrieve the data and trigger an email to "department A"? this look like similar to email notification, is it? any sample coding?please take note that "department A" should able to add new remarks inthe form, a new problem. how can i do it? (cos need to add new textarea/textfield) after "department A" add remarks into the form then submit to another department which is "department B"."department B" will check and add comment to this form then keep record of this form. i'm using sql server as database.
Pass Prameter
I have a page that calls a multiple frames page (ASP). I need to send parameters from the first to the multi frames page. If sending to a simple page, it works. If sending to multiple frames page, it does not.
Pass Two Variables
I have this statement that passes a variable to another page. how can i incorporate another variable called teamId. I want to pass two variables at the same time.Code: Response.Write " <TD width=100 style=border-style:none; border-width:medium; bgcolor=" & BGColor & "><p align=center><font size=2><B><A HREF=Schedule.asp?LeagueID=" & rst.fields("Leaguetype").value & ">" _ & rst.Fields("Tournament_Description").Value & "</B></font></TD>" & VbCrLf Could anyone provide a link to a site where they go over different types of methods to pass variables?
Pass Requests
I woudl like to know why querystrings and numbers are used to pass requests ? E.g. in this forum, sitepoints; to display asp pages, they used forumdisplay.php?f=148 whats wrong in using forumdisplay.php?f=asp ?
Pass Logout Value
I was wondering if there's a piece of code that will do the following:- When the user closes the database, I want to pass the current date and time into a field in the database!
Pass Newsid
below is my code retriveing news from table...and pronting with link..now i want to pass newsid along with this links..collecting news one place and passing it to another place how to do ? used array to display only 10 words of news string. Code:
Trying To Pass A Variable Through The Url.....
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:
Pass 2 Or More Variables
tell how to make this work Response.Write "<a href=""orderdetails.asp?transid=" & objPagingRS("Transaction_Id") & """>" i want to pass 2 more variables like orderid and customerid through this querystring
Functions Pass By
I have a function called GetRS which takes in a SQL string and returns a recordset object. Does this mean that a copy of the recordset is returned or is it passed by reference?Obviously this could have a large impact on performance for large recordsets.
Pass Parameter
I am passing a text parameter with querystring like ..asp?parameter How do I pass a parameter which itself contains the "=" character?Eg if parameter ="a=b" then the code will interpret is as a parameter named "a" with a value "b", where as I need "a=b" being the value.
Pass Values From Asp
i am opening an excel file in the same explorer window as the form. i am storing values entered in excel in database. while saving the field in the db i need to save a field from the form also.how can i get a form value inside the vba code or to put it like thishow can i refer the form value inside excel?i m simply opening a template of excel file.
Pass Values
I have a link www.example.com/survey.asp?usr=[username]&pwd=[password] survey.asp is going to be a redirection that redirects to one of these random links; www.example.com/survey1.asp?usr=[username]&pwd=[password] www.example.com/survey2.asp?usr=[username]&pwd=[password] www.example.com/survey3.asp?usr=[username]&pwd=[password] www.example.com/survey4.asp?usr=[username]&pwd=[password] I need to pass what ever is in the [username] and in the [password] fields too.As the [username] and [password] would be unique for each url (as I will be emailing 1000's out which will be email-merged) for example if the original url is; www.example.com/survey.asp?usr=abcd&pwd=1234 then it may redirect to: www.example.com/survey1.asp?usr=abcd&pwd=1234
Pass The Auto Gen Id
I have a form which submits it's data to a hidden page(submit.asp).Submit.asp retrieves the data and submits to the db.Immediately once it has submitted data,it will then retrieve the auto generated id for the data just submitted.(hope this will work) Once I have retrievd the auto gen id, I want to then pass this id to *another page*. I don't want to then create the table on the submit.asp page as there is a huge amount of code there already-want to keep things clean. How do I pass the value to another asp page?Is it something like response.redirect and how do I attach the id?
Pass Variable In URL
I need to pass a variable in a URL to set up a dynamic page where the content shown is based on the recordet queried on the value passed in the URL.So when the user pulls down a menu list and clicks on Todler Clothes, I need it to go to URL store.asp and pass the choice of Tolder clothes in the URL variable. Then I need to have my recordset query (WA Querry Builder) use that variable to pull the correct items from the db.How do I add the variable to the URL and what is the ASP statement to get it.
Pass Parameter
I am using Crystal v7. Main report and subreport are both based on the same stored procedure. How do I pass parameters to display the report and subreport in the Crystal viewer. I can display regular (non-sub) reports fine.
Pass Value To Javascript
i need to modify one website. in this website we use activex control to get data from local computer. after selecting that data on the basis of selection i need to run query and get value. i need to use this value in javascript which is called when i click button. i faced problem because i am not getting this value in javascript. which i need to get it from database on the base of userselection. we use simple button in stead of submit. so is there any way i can get this value in javascript. when i click the button.
Pass Db Fields
i am having trouble with this project i was thrown in to. I have a list of records that just display a club name and a phone number on a single page. what im trying to do is when i click on the club name, is to have it link to another page that then pulls all of the rest of the information from that specific line of the access database. i can get the cub name and phone number page to display the correct fields, but im having difficulty passing the club name to the other page so the database knows which line of information to pull.
Pass Variable
How can I pass the variable in two button situation see below code <html> <body> <form action="" method="post"> <input type="text" name="name"> <input type="button" value="Add" onclick="this.form.action='add.asp?name=<%=name%>';this.form.submit();"><br> <input type="button" value="Delete" onclick="this.form.action='delete.asp';this.form.submit();"> </form> </body> </html> As a result, I got to the next page , but showing error.
How To Pass Parameter To Script
I am trying to pass some paramters from a VBScript function to a script that writes the parameters to a text file. I have not been able to do it. Code:
How To Pass Url Variable Between Pages
If an affiliate sends a visitor to my site I want to be able to carry that 'partner' variable throughout my pages and eventually onto the registration page so that they may get credit for the member registration. I am not a coder and can't find an easy way to do this could someone help. I am an expert interpreter and rearranged but not a writer of the code. BG INFO: asp.net AFF URL FORMAT: www.mysite.com/index.html?partner=20051111987623
Pass Email From Form
I am kind of confused. How do I pass an email address from a text field in a form using ASP code?
Pass Null Into Function
Code: Function FixString(s) If Not IsNull(FixString(s)) then Fixstring = Replace(s, "'", "''") end if End Function error: Microsoft VBScript runtime error '800a001c' Out of stack space: 'FixString'
Redirect And Pass Variables
Looking to generate a number (done) then pass this onto the next page automatically.... but also pass on other values this way. Response.Redirect("noktest.asp?ID=vID") works but this does not in terms of passing vID but does not actually pass the variable value but just "vID" Response.Redirect("noktest.asp?ID=vID AND name=<%=rs("SurName")%>) Also tried the follwing which does not rediect at all Dim vNOK vNOK = "noktest.asp?name=<%=rs("SurName")%>) " Response.Redirect("vNOK")
Pass Selected Values
I have a Multi select box which I have populated with a list of choices. Is it possible to have a second Multi select box which is initially empty, yet when the user selects values from the first Multi Select box, they appear in the second multi select box? I'm sure I can easily do this by just posting the selection to a new page but I'd like to dynamically display the selected values on the same page.
|
TRACKER
