Drop Down Selection On Intranet Sets Default Value In Database

I'm working on a project, trying to create an HR hiring intranet page. Basically, here is problem. I have a table in a database called "Title Access" that lists titles, and has software, email, and user rights associated with each title. For example, Network Administrator will get Office, Dreamweaver, be part of the IT and Admin groups.

Now, here is the issue: Whenever the user types in the name, pay rate, hire date, and title on the intranet page then clicks "submit", I want the database to create a new user in the "employee" table with that name, and populate the access rights in that table with the rights associated with the title. Thus, the "employee" table will now include "John Doe", and will have Office, Dreamweaver, IT, Admin checked off. Is there any way to do this????????????

View Replies


ADVERTISEMENT

Displaying A Drop Down Selection With ASP

I have the following drop down menu on a html page and when submitting
i would like to call out on asp what someone has selected.

<select size="1" name="type">
<option value="Prospect">Prospect</option>
<option value="Suspect">Suspect</option>
<option value="Qualified">Qualified</option>
<option value="Proposed">Proposed</option>
<option value="Closed">Closed</option>
<option value="Lost">Lost</option>
</select></b></p>

I also have regular fields on the html page which works great when
submitting but for some reason i can't get the dropdown selection to
display Code:

View Replies View Related

Drop Down List Selection As Parameter To A SP

I working on an ASP page that has a drop down list that gets its contents from a SQL table.

Can anyone show me how to use the selected item from the drop down list and use it as a parameter in calling SQL stored procedure (this procedure simply updates a table so there are no result sets).

I have designed my page to include a submit button and was wondering if it is possible to call the procedure as soon as the submit button is clicked. I get really confused with whether to use a server side or client side script.

View Replies View Related

Add The Default ALL In Drop Down List

i want to add the deafault "ALL " in the list, how to add? and when i select ALL , it would print out all data in Name field.

<%
sVar = Request.QueryString("Name") 'request from Name field
If Not Request("Name") = "" Then
strSQL = "SELECT Name,TagName,MinTLV FROM Folder where Name='" & sVar &"'"
rs.Open strSQL, conn
%>

View Replies View Related

Multi Drop Down Filtering Selection Issues

I was trying to set up 3 menue drop downs for filtered relational selections of 1st-(Buildings), 2nd (Departments) followed by (Projects). I foillowed all the links and can not see how to get a onchange to work as relational menue. This would have been best. But 3 days later I am tight for time so I was attempting to just setup of the time being 3 seperate drop downs with submit. I can only get the departments to work. The building and projects will not filter as the departments. Code:

View Replies View Related

Populating Text Fields Based On Drop Down Box Selection

I am working on a small application for senior users, so I want to limit the option for incorrect input whatsoever. I have a drop down box that is populated from a query and I want to make it so that when an option is selected, the pertinent text fields are populated based on the selection.

All the info I need is already being extracted from the query so its just a matter of displaying the right info based on the selection. I have been looking for examples of code but they all seem to use javascript. I am not too strong in javascript so I kinda avoided those. if there is a pure asp example, that would be fine!

View Replies View Related

Javascript Language Paging Larger Database Record Sets

I am fimliar with asp javascript and not asp VB.

i can display the results ok, but if i return 100 records from my table i would like it to display 5 records per page. i have looked at asp recordset paging on several sites, however cannot find any scripts that work with ASP JAVASCRIPT....

View Replies View Related

Insert Multiple Selection From Listbox To Database

after a lot of searches to see if i can get such a code on the net, i've finally come to ask my questions here bcoz i can see bits of code here n there on net but not what i really want.

i have a form with a listbox(lstduty) on it. i have been able to populate it with data(dutyName)from table 'duty' from a sql server 2000 database.

now when a user makes multiple selection and click the 'add' button, i want to be able to add it to another table in the database as below: Code:

View Replies View Related

Dynamic Drop Down To Database

I have this code which works fine except the information in the second box is not submitted to the database. Code:

View Replies View Related

Multiple Drop Down Boxes Querying A Database

This is the solution needed to have Multiple Drop Down Boxes querying a Database(s) that will not wash out you other textboxes and objects on the select. Copy the code, change the connection to get you data and fly. Code:

View Replies View Related

Drop Down Menu Auto Genrate From Database

I 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.

View Replies View Related

Record Sets

Is there a way for me to determing if a column exists in the table? ex. I
have RS("var"), where RS is a recordset. My code is dynamic but some tables
will have "var" while some won't.

View Replies View Related

2 Record Sets

Is it possible to have an ASP form where there are 2 form fields, each mapped to a separate Access Table? Say for example

Dim rsOne
Dim rsTwo

rsOne mapped to tblOne in Access File Mydb.mdb
rsTwo mapped to tblTwo in Access File Mydb.mdb

View Replies View Related

Joining 2 Result Sets

i want to left join result sets together coming from two different databases based on a common field storenumber. They are separate databases as per management design.

Basically it should match rows based on the store number, those who don't have matches should display only the storenumber and no other info like: Code:

Store Q1 Q2 Q3 Q4
1 x x x x
2 x x x x
3 <--No data in 3, just display storenumber
4 x x x x

View Replies View Related

Comparing Two Record Sets

how can i compare 2 record sets. In one RS i have excel file and other RS i have SQL server and when i get the results from both i want to compare them as one of you guys suggested me to write a loop that cycles through the record sets Comparing any fields.

View Replies View Related

Comparing Record Sets To Cookies

What would be the most efficient way to check to see if a cookie matches a record in a DB table?

If the user's cookie matches a record in a table of executives, then I want to display a breadcrumb menu item just for that executive.
This does not have to be super-secure or anything, I just want to keep honest people honest.

If the information they submit in a cookie is also present in a table of executives, then I want them to see a comprehensive menu set. If they are not in the table, then I want them to see a reduced menu set.

How to go about comparing a cookie with multiple values or keys with a record in a table?

View Replies View Related

Record Sets - Selecting All Results

im a passing 3 fields from a form to use a search criteria against an access database table, i have set the fields a numeric values, what should i use to allow all records to be shown for a invidual value rather than a selected value.

Ie the form would pass

Location_id as 22

so the result page would see Request.form("Location_id")

sql would then see

where location_id = var1

var = 22

but i want to get the sql to say

where location_id >=0

what do i need to do

View Replies View Related

Passing Multiple Sets Of Variables Into SQL

Before I created this thread, I've searched Google and used the search feature of this forum numerous times on how to do this, but couldn't find much.

Basically, I'm trying to pass multiple sets of values from the search form to the ASP into an SQL statement (Access Database).

I can only make it display different prices of a certain music type, eg all prices of rock. But it doesn't output all types of music for certain prices, eg viewing Classic and Rock records with prices of 8.99 and 10.99 only.

I've used the REPLACE command I've found and got around that problem of syntax with numeric/alpha data. Code:

View Replies View Related

Replacing 1 Set Of Double Quotes With 2 Sets

How can I replace 1 set of double quotes (") with 2 sets ("")
I tried this but it didn't work: myText = replace(myText,""","""")

View Replies View Related

Code Pages, Cookies & Character Sets

I'm a little perplexed. <%@Codepage="65001" %> changes how IIS/ASP will handle interpreting query string variables - i.e. it will read the querystring as being utf-8 encoded.

However, I'm finding that it *doesn't* change how Response.Cookies or
Request.Cookies get read/written.

I've been testing with a little jscript asp page with the lines

if (String (Request.QueryString ("abc")) != "undefined")
Response.Cookies("abc") = Request.QueryString ("abc");
Response.Write (Request.QueryString ("abc"));

to take a value from the query string and pass it back out as a cookie. The test value I was using was r%c3%a9sume (resume with an accented e). When the code page is set to utf-8, it will properly interpret the urlencoded query as a utf-8 string. It will output the right bytes with Response.Write.

But watching the headers produced by the request, it comes out encoded in latin-1.
Set-Cookie: abc=r%E9sume; path=/

I checked the cookie rfc on w3c.org, and oddly it doesn't say much about how to encode/interpret cookie NAME=VALUEs. The only comment on character set in the spec is that a cookie *comment* has to be utf-8 encoded.

I couldn't find anything on the MSDN documentation that addressed cookie character sets either.

View Replies View Related

Displaying French Canadian Character Sets

I have an ASP page that displays data from a SQL database. It includes some Canadian names/address which contain the special accent characters...my ASP page doesn't display them properly. I have included the tag

<META HTTP-EQUIV="content-type" CONTENT="text/html; charset=ISO-8859-1">

but they don't show up correctly...what else do I need?

Update: Turns out the source of our data gave us the old IBM codes, not the newer codes...for example, they gave us 144 instead of 201, and using the charset of 8859-1 won't allow 144 to be displayed. When replaced with 201, the character displays just fine.

View Replies View Related

Use Value In Query String To Produce Multiple Record Sets

I have taken over a website that was done in Frontpage and I am trying to move away from it. I am having problems with page 1 where I have a link that passes a single value to page 2 in the query string.

On page 2 I want to use that value in the query string to produce mulitple record sets. This actually works when using the fpblib.inc. Is there a way of doing this without having to use Frontpage coding.

View Replies View Related

Display Drop Down Options Based On The Selected Item From Another Drop Down

The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:

View Replies View Related

SSL On Intranet

I am developing a system that needs really security,but on INTRANET.Do I need SSL??
If yes how will I use SSL in ASP??

View Replies View Related

Intranet Example?

Please recommand any intranet examples with the good navigation and interface design?

View Replies View Related

Intranet And ASP

I have got a little experience with web design, and have produced a basic website for a local charity run advice centre.They have a variety of forms, some in PDF format, some hard copies, which at present they fill in by hand then post out. We have been talking about moving towards a paperless office for them and a way to automated form filling. My best shot was to look into creating an Intranet for them and using ASP we could be able to fill the forms in on the PC then print out.
Are there any specific things that need doing to the server to run an Intranet, and as I said earlier, I'm new to ASP so I wanted to know if anybody has any Ideas or templates that would be useful to help me with this project?

View Replies View Related

Asp Intranet

There are 3 pcs on a network in the office and I am designing some stuff using an access db and asp pages. Instead of everyone using my pc, they want to be able to logon and work off it from their pc. I just type in http://localhost/mysystem and I can access it but I don't know what url they need to type in to access the pages?

View Replies View Related

Intranet

I have a comments form on Intranet.And I want the information written by users on this page send to my e-mail address,and the user doesn't have to write his/her mail address on this form.We are on same domain.The free scripts use smtp but no need while sending mails over Intranet

View Replies View Related

Building An Intranet With ASP.NET

My work has decided to give me the job of building them an intranet. Being pretty new to .NET and ASP in general I was wondering if anyone knew of books or sites I should take a look at that might help me get started.

View Replies View Related

Client Intranet

I'm currently working on an Intranet for one of our clients. I'm developing a user directory for them using a SQL Server database.
My client has provided me with the information to connect to the server remotely via windows remote desktop connection. I would like to know how I go about getting Dreamweaver to connect to the database?
Will I have to create a database locally and then publish the local database onto their server or, can I create the database on their server and using DW to connect to it?

View Replies View Related

Intranet Search

I have developed a company Intranet page,and have the requirement of adding a search function to it. My question is,i need a simple search solution, that will search through my site which has include files.What tool do you recommend to run that will index my pages?

View Replies View Related

My Intranet Website

I have an Intranet website that our corporate users and customers access to pull up information on various things. I now have to publish content that should only be available to corporate users. I do not want to create another website or use host headers... there is no login page or anything today within the ASP pages.

What is the best way for me to host content that only internal users can see? I thought about removing all NTFS permissions to the "private" directory where I plan on having web pages... thinking that IIS would prompt users when trying to access pages within this directory. For some reason, IIS still displays the page. I'm not sure what I'm missing.

View Replies View Related

Intranet And Internet

I'm dowing a web site on my intranet in a ASP page I have to made save option, on the intranet everything is working fine, but when I upload my website in the internet I have this message:

The page cannot be displayed
There is a problem with the page you are trying to reach
and it cannot be displayed.

What is the probleme my page is in ASP and on intranet it's working fine.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved