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.
View RepliesI 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
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.
I use the below code to pass a value to use in the next page. How can i pass 2 of them in the same way ?
oRs("N_GEN") = 2
oRs("COD_NOTAIO") = 00001
<a href='delete_atto.asp?n_gen="& oRs("N_GEN") & "'>"%>
i tired
<a href='delete_atto.asp?n_gen="& oRs("N_GEN") & ", codice_notaio="& oRs("COD_NOTAIO") & "'>"%>
but i got a error.
ERROR: invalid input syntax for integer: "2, codice_notaio=00001"
Any idea?
We are integrating 3rd party s/w which would process online
transactions.
this product would require that we pass some sensitive information over
the web, using FORM-POST-Hidden fields method. On viewing source this
page we are able to see this info. To overcome this - steps followed.
PageA.asp - collect information, exists on our server
PageB.asp - request info from PageA.asp, append sensitive information,
automatically POST to client server - this code exists on our server.
The issue arises that while connecting from PageB.asp to client server,
there is a little delay which shows the hidden page.
I have created a form. I have a log in page and a view registration page. When a user logs in I have to display only their information on the registration page. But when an admin logs in...
they can view all the records in the database. I am not sure how to do this. Can anyone help me? I have included that code that I have now. Right now...when the users log in they see everythings. Code:
I am working with an application that passes information about an object to a Query and then populates a window with the information about it.... for example
If i had an object that was say a Box, and an attributes of that box were
box.ID = "1456"
box.Shape = "Square"
box.Name = "Boxer"
on the Click event i would choose to click the box, and pass the box.ID number through a query, (SQL preferably) and pass that value to an HTML table that had
Box Name: Boxer
Box Shape: Square
Is it possible to pass Dictionary object keys and values to another page? If so, how?
I know how to store the items, but specifically, how do I pass the values and retrieve them on another page
i have a drop-down menu with a list of products.when i select any one
product i open a popup displaying hte product categories in it.i then
enter the no. of items i want.and finally when i click to the submit
button i want to display a summary of selected item in the parent
form.to make it more elaborate:
i have 3 items in a drop-down menu and each item has further 10
different types of products.
something like u have an item soap. and then 10 different brands of
soap.so all my products are in the drop down menu in the parent form.
item 1
item 2
item 3
item 4
when i select item 1 i get a popup menu which has say 20 types of item1
from the database.i generate textboxes beside each label so that user
can enter his quantity. Code:
how to create an array of checkboxes that were selected from a form on one page and pass them into hidden fields in a form on the next page? I have this massive project I've been working on and am having trouble with this.
View Replies View RelatedI'm using DWMX and Access DB.
i have setup a form on a normal http page which collects name address etc and is then passed to a https page to collect credit card details, on clicking submit on the https page the credit card details are inserted in db on secure server along with one field that was passed from the http page (the user id).
this all works ok, however i then need to pass the remaining orignal form values back to another http page that then inserts these values to another DB. ok you may be asking why.... the first forms allows the user to correct information already held on file before upgrading their listing, i then need them to pay for the upgrade before inserting the amended data in the orignal database... How..
i m designing a online test application. my reqt is on pressing next button my selected value gets stored in the database and next ques ll appear and on pressing prev button it should display me previous question with already selected value.
how can i do this?
how can i pass selected value of radio button through query string as my radiobuttons are getting cerated dynamically.so every time its name will be different. Code:
1. I have a form, with a textbox and a button. I have to enter a value in the text box and then i have to click the button, which opens a popup window. Here i want to pass the value of the text box which is entered in the parent window to popup window.
I have to use that value in the popup window's form_load event in the Code behind, and i have to take the values from the database using the value which i have entered in the parent window. Code:
I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:
To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:
i need to convert the escape values which are by mistake updated in DB.
example:
this is a sample text string
is updated in DB as
this%20is%20a%20sample%20text%20string
here %20 is the space.
like wise there are many entries for :,'
is there way that i can update all this in a update statement?
or use asp to to update the records?
I have a variable SET which has the value Of 1, 2, 3, .., N.
SET=val1, val2, val3, val4, ..., valN
What is the commend or procedure to extract individual values, val1, val2, ...
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.
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")
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??
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?
How to pass a collection from a VB Component to an ASP page? I have no clue
the syntax of all. Code:
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.