I've created a web form that will post to an Access database. All of
the form fields correctly save to the database upon submit using:
<td><font face="MS Gothic">Site:</td><td><INPUT TYPE="TEXT"
NAME="Site"></td>
Below is what I have for one of the drop-down menus. Could anyone help
with how to add the VB code to this so that the selected menu item
will submit to the database as well? Code:
I have a form that I would like to create. My primary concern is 2 drop-down menus. The contents of the second drop down menu depend on the selection of the first drop-down menu.
For example: In the first drop-down menu, I want to select a department, and after a department is selected, I want to be able to select one of that department's employees from the second drop-down menu. Of course the content of the employee menu will depend on which department was selected.
I've been experimenting a little bit with my Access database, but how I design that really depends on suggestions I get here, so let me know what you think.
EDIT: I should also mention that the contents need to be read from the Access database, rather than storing everything in a javascript array. In this way, I can have Human Resources add new departments and employees via a web form so that I don't have to manually edit code every day.
I'm trying to access and iterate through POST variables. I'm thinking of something similar to PHP, where on a submit it creates a POST object, which is an associative array of all the variables. Is ASP the same way? Is there any way to see what is in the array and have access to it's contents without knowing the contents beforehand?
The reason I ask is because I have about 100 check boxes, and the user only checks a number of them - each check box is named differently. I want to, on the post page, to find out which ones were checked, short of putting an if else or select to check all 100 of them. Is there an easier way? I tried printing out the post: Response.Write(Request.Form()), and all that gave me was the querystring .
I am trying to have a web page list the contents of my database table. I have been trying for ever and cannot find what I am doing wrong.
Here is my code: (I hope it is not a mess I am new too this)I have included comments to walk myself through this. Code:
I have been provided with a DSN, user name and password for one of my
clients sites.
I'm not an ASP developer and need to view all the contents of this database.
I usually work in PHP but only have ASP available on this server.
I want to open the database and simply output all the contents into a HTML
page.
Can anyone recommend, pop up /hover menu that populates data from the database? At the moment we are using http://dhtmlcentral.com/projects/coolmenus/ but it seems to take a while to load. I'm just wondering if there is more efficient script available.
View Replies View RelatedI have a dropdown menu (HTML's form->select) i have options in it, and I need as soon as one of the options is chosen (onChange)to update my database's (mdb) field
like this:
mdbVar("some_field")=1
mdbVar.update
that simple, but i cant figureout how to connect the onChange to this code.
what is code for populating a list menu with data from a database. also the default(first) option in the list should be "ALL".
View Replies View RelatedI need to create a drop down list that will auto Generate numbers from 1-60.
So when they select the drop down list, it will display 1 thought to 60.
Let's say I have a dynamic list/menu, which gets its values from a
database table, for example a list of contact people where the value is
an ID number and the label is the name. However, if the value the user
wants is not in the list I would like to place a hyperlink which
will...
(1) open a small window, with an ASP form to allow the user to add a
new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it
the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about.
I don't like the idea of forcing the user to leave the current screen,
go to some other form, add the entry they need to the lookup table,
then come back; this seems like a logical approach, but just wondering
how to make it work.
This seems like a common enough situation; anyone have any code samples
or suggestions about how to do this?
how to create asp spry type horizontal menu that is populated from a mssql database. Only able to find help for asp.net, need help for strait asp.
View Replies View RelatedI am having an Excel where I maintain my data. I want to extract details from a website based on the data that I have in my Excel(i.e login to that website,post the data to the Website and get the details from the page n update it in my excel). How can I do this?
View Replies View RelatedThis thread is not so much a big problem, but more to receive comments on my approach. You may have some other tips or advices of where to go or where absolutely not to go with my attempts. Code:
View Replies View RelatedIs there a way to 'force' a submit on a form with out actually allowing the
user to press a button ? For example...
step1: A from is filled out by a user, then they click the submit button.
step2: The form is 'post'ed to an ASP page which writes the values to a
database. So far No problems. But..
step3: Now I want to 'post' these values again to another page without any
user interaction.
My ideas were:
1) I know you can get the form values from Request.Form("myVar"), so I
thought of making a 'dummy' form and setting the 'values' of the form
variables to these Request.Form("myVar") valiables, but I don't know how to
'submit' them to another page again.
2) Is there some type of 'submit' command in ASP?
does frame support pop out menu? Thanks....
View Replies View RelatedCan any one help with code for form menu in which sub menu appear on selecting the main menu. This is one field of an access database to be submitted by user.. Now I have code only for selecting from main menu. Code:
View Replies View Relatedi have a series of .asp pages that i am dividing into model, view, control logic. my view collects a whole bunch of data and posts it to the controller. im wondering if there is a way to somehow "re-post" this same data to my model page.
in short, is .asp capable of taking data posted to a page and re-post that same data to another page?
I have a vars called param1 to param10. I need to iterate through them in a loop to see if theyre empty and set them to spaces if they are. i.e
for a = 1 to 10
newparam = "param" & a
if newparam = "" then
newparam = " "
end if
next
but I want the contents of newparam i.e param1, param2 etc... to be evaluated and not newparam and then param1, param2 etc.. to be set to " " .
I have a select element in a form on a page with some options. When i submit thet form and the target asp page is executed, i want to find retrieve all the values in that select element on the page...?
thru request.form("sel") i am able to retrieve only the vaue selected by the user.
I have the following code:
for each SesVar in Session.Contents
if( Session.Contents(SesVar) <> "" ) then
The problem is that most of the time this works okay, but sometimes the code
crashes on the compare.
I am wanting to do this but am not able to do it.
I have two fields: first name and last name and then submit button.
When i hit submit button ,according to the name entered in the first field ,some results are displayed from database.
Now when i hit submit ,the contents of my fields are cleared and i dont want that...i want the name to be still displayed in the textboxes...
How do i do this?
I dont want to basically clear the form contents on submit.
I am currently working on ASP. Users will input their contents into a textarea. The problem is that when they input and I retrieve them from the database, they will use the textarea space that was allocated to them and display exactly it is.
For example the text area given is 500px and i only give the display part of 250px. Despite that, it will fill up and scrollbars will appear on my bottom of the webpage and have to scroll to the right.
how i can display all text with the break lines in between yet still confined to the space of 250px.
I want to read a classic HTML Form using the ASP Request object on the server. This is a common approach. But how can I read all the contents of a listbox (the <select> tag)
View Replies View RelatedDoes anyone know of any issues interacting with asp pages from within Flash when you use Control>TestMovie ? i.e. When using a send and load, Flash seems to want to open my asp file (and return the contents in Flash) rather than run it and return a name/value pair as I'm expecting.
View Replies View RelatedI have successfully been able to load text from an SQL-DB into a <textarea>.Now I need to save the edited text back to the DB But I can't seem to extract the value from the <textarea> into a vbscript-variable.
When the user clicks the submit button under the textarea I need the text to be saved into a variable, how?
Code:
<FORM METHOD=POST ID="Form1">
<TEXTAREA NAME="text1" ID="text2"><%Response.Write(Recordset("text"))%>
</TEXTAREA><br><br>
<P><INPUT TYPE="submit" VALUE="submit2" ID="submit3" NAME="submit4">
</FORM>
what is the best way to protect a folder of files on an asp site so that only people who have logged into the site are allowed to view the files?
would it be best to put them inside a cgi-bin and then have a page with links to the files, or is there a better option?
I'm trying to figure out if there is an easy way to combine the contents of two arrays into one array. Order does not matter, I just want them all together. I'm sort of new to working with arrays, so I don't know if there is a really basic way to do this.
View Replies View RelatedI am creating a website which has a form for registration. I am not using any database or server side coding. The form details should be sent through an email to me. I tried the action = "emailto:me@myaddress.com" but it only fires my outlook when the submit button is clicked.if it could be done the way I want?
View Replies View RelatedIs there a way to export the DataTable contents to an XML file.
View Replies View RelatedI have worked in PHP / MySQL. But never worked in ASP/MSSQL. At the moment, i ma stuck with a problem. Hope someone here can figure it out.I have a list of countries in a Page. When the user MOUSE Over any Country, through Javascript, a small layer <DIV> appear that shows some data about that country. Up till now that XML File is filed MANUALLY.
Now that Data is changing frequently. What we want is that to do the same thing described above through database. Like when the user mouse over any country, that will load XML and connect the Database, extract info and then show in the same DIV layer. Or alternatively, there might be some sript, that will RUN AUTOMATICALLY daily or weekly and update all the countries data XML files. please guide me how to achieve this in ASP + MSSQL + XML + Javascriptor any combination of these.
I am developing a website and in particular, a shopping cart for the company I work for and I have everything working fine. This website is written in ASP. When you add a product to the database, it adds it along with a UserID based on a Session variable.
Everything is working fine regarding the user functionality of updating particular product quantity and options. However I am having trouble finding any information on how to send the contents of that recordset via email, when the user decides he is ready to send it. I have no trouble sending forms and such via CDOSYS and ASP but how can I send the contents of an entire recordset?
I'm trying to compare fields in two recordsets. I'm having fun with apparently empty fields. In order to avoid displaying meaningless messages, I need to know what is in these fields - e.g. is it a space, a null, an empty string, or what?
I'm not much of a programmer - how do you display the contents of the field using asp, for example, to return the ascii character code? Or is there a simple way to check for non-printing character codes?
this is an asp/ javascript question.Say I have a variable in asp.
dim myVariable = "hello big boy"
How can I get JavaScript to read the contents of that variable?can I use it straight away?
<script language="javascript">
document.write(myVariable);
</script>
Or is it more complicated than that?