How Can U Connect To 1 Of Several Dbs Based On Selection User Makes When Accessing Main Page
We have a web site IIS 5 (on Win2000k) with Oracle 9i backend (Sun unix).
There is 1 user ID to oracle(APT_W3) that is used by all users (50).
We have a global.asa file that has one APP Start connection string using OLE
DB:
Application("dbConnString")="Provider=MSDAORA.1;Password='SDERSD';User
ID=APT_W3;Data Source=CCEWSDD1_new;Locale Identifier=1033;OLE DB services=-1"
The first page that a user sees asks that they select the area they want to
see (western, northern, etc) from a dropdown menu. Once they select it and
hit save they can go to other pages, session varibles indicating what area
they selected are then passed to pages. Currently all areas are in one
database.
What we want to do is have areas in separate dbs, a northern one, a western
one.etc. Each will have separate user ids (APT_W2N, APT_W3W,etc).
We want the users to have the web page presented to them where they select an
area. Based on the area they select, the appropriate conneciton string will
be used (the one in the global asa). Code:
View Replies
ADVERTISEMENT
I have a survey/member form that gathers information. I would like to have a drop down list on a page that a user selects, either 1, 2 or 3.If 2 or 3 I would like to show on the form another field for information gathering ie:if a user has 1 cat, fields for cat name, sex & age show.
if a user has 2 cats, 2 fields show instead of one for each, and the same
for 3.....
View Replies
View Related
I writing an asp application that uses three listboxes. the first one lists departments ids the second list box populates either users or supervisors based on which button is pressed ( users button and supervisors button).
If a user is selected from the list the submit button redirects to page1.asp. if a supervisor is selected the same submit button redirects to page2.asp My question is how can I submit the form without using more than one submit button.
View Replies
View Related
What I would like to happen on this page is that when a user selects a company name from a drop down list, his selection autopopulates the cID field based on the selection. The drop down list is getting its choices from the customer table.
As I am still a novice, I am sure there is a way to do it I have not been able to get it right. Code:
View Replies
View Related
ASP/javascript with a drop down populated by an access database. The drop down works fine but I cant figure out how to get it to change a value of a text field.
I want the value in the text field to change to reflect the data in another column in the table, same row. Code:
View Replies
View Related
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
I have a menu box with dynamic values from a recordset (value = 'Size' column)
I then have a textbox for which I want to display the 'Price' column according to the record selected in the menu box.
View Replies
View Related
I need to have my ASP form "post" action=? pass to a different confirmation page based on a radio button selection on the form, after submit.
Depending on which radio button they click on, they will receive the same confirmation but then be redirected to a selection specific page, based on the radio button selection. I'm assuming I need to create several different action pages, each with a different redirect, then have the radio button determine which action page the form is directed to based on the radio button selection.
I've tried several different options, such as creating a variable on the form, sDirectionVar, with redirect conditions, but I don't know how to call that on submit? I'm not sure I'm even going in the right direction.
View Replies
View Related
I am using JQuery's thickbox 3.1 and ASP.
I want perform : click a link in main page, then pop up a form in div window by thickbox, after I sumbit this form , div window disappear and go back main page.
My problem is : after I sumbit the form inside div window, form is sumbited , but still in div window!
How can I make it jump back to main page after I submit ?
View Replies
View Related
My boss wants me to create a form that will contain about 50 condo listings. He wants me to place a restriction on the form as to the number of Condo listings a user can select/request. Is that possible? If so, what will I need to do or use to make this stunt possible?
There will be several pages that will make up the form. There will be data being passed between the forms. To do that I would use ASP (I guess).
The items on each page would be different. Lets say on page1 there are 20 available condos located in area A. On page2 there are 20 available condos located in area B. On page3 there are 10 available condos located in area C.
The user goes to page2 sees a condo that he/she would like information about. They select that condo.
The user has now selected -one- condo from page2.
If the user goes to page 1 or 3 and selects a condo from those pages when the user hits the Submit button, the program should not allow the page(s) to submit since they have selected more than one condo. How can I make this possible?
View Replies
View Related
I have a page which on default will display 5 rows per page. I would the user to be able to select from a listbox (on the recordset page)and change the number of rows displayed on the page.
I have tried a page with a listbox on and submitting to itself. But on re-load the listbox returns to its default value.
View Replies
View Related
I'd like to have a frequently used link page on our intranet that displays
the urls' based on a users's ad group membership, i.e. if from accounting
show general ledger reports, if from loans, show credit report. I'm not much
worried about hiding from enterprising users, i'd just like to make it
simpler rather than having people have to scroll through pages of links.
View Replies
View Related
My app lists jobs for a recruiter. He wants to track members who have
replied directly to job postings. So instead of simply making the client's
email address an <a href="mailto:...> link, I need to do 2 things:
- add a record of their posting to a database table
- open the email client to the job
Howe do I do this? The first part is easy, but I don't know how to open the
email client in an ASP command (I don't really want to auto-sed email, just
open the client and let the user attach their resume and add their cover
latter). Do I have to get my Web Hosting company to install CDO, or is that
standard with all IIS? I get an error when I try to run 'Set MailObj =
CreateObject("CDONTS.NewMail")'
View Replies
View Related
I am trying to add record to the database (Ms Access) from a ASP page, which is the easy part. Now I am faced with a simple but hard to me problem. I've a select menu where user can pick multiple value, but when there's a option is not there I was user to be able enter a new option vale and select it.
right now I am redirecting them to a page where by they can add but in process I am lossing the information they entred before hand in other fields.
what I like to do is: from the page where user enter info be able to put a pop-up window then ask them for info and copy the info and add to the option box for selection without reloading the page. is this possible?
View Replies
View Related
I am getting a 404 error when trying to access an ASP page from a remote machine (via Internet Explorer). However, the asp page is processed successfully when accessing this page from the local machine.
I checked permissions from IIS administration and from explorer and nothing seemed out of the ordinary. Other ASP pages work from other virtual directories, but for some reason this one does not.
View Replies
View Related
i wanna connect front page forms with the database for searching and updation .. how can i do it.. in asp it ask to host the web it doesn't works on disk drive..any one help to solve this proplem..any alternative
View Replies
View Related
I am unable to access an Access database through a webpage I built, but only if the database is on a server running Windows NT 4.0 Server. If I copy the database to
a pc using NT Workstation then there is no problem. I have a user account set up on the sever as IUSR_pcname. It is a domain user with full privileges. This is the connection code:
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=10.10.10.10pcdTEST.mdb;"
It gives me a 'disk or network' error and for some reason, and the server locks out the IUSR_pcname account after I try.
View Replies
View Related
I have creaed a tree stucture using Frames. When selecting an option from the left side, an ASP page (Let us say page1.asp) opens.
In the ASP page, I am getting inputs from the user. On clicking Submit, i am opening another ASP (Page2.asp) which has the connection tags.
What happens now is, page1.asp gets loaded, when I click Submit, it says "Page cannot be displayed". Code:
View Replies
View Related
I have created a asp project local.and have created a access database local. Iam trying to use the access database from the asp page. But It is not accessing the database file.
once i changed the rights of the access file and checked it.It inserted the records.And after some time, iam not able to access it.some times it accesses and some times it doesnt.
View Replies
View Related
My form contains a drop down list of univ. campuses and depending
upon the campus user is selecting, I am selecting the courses offered
in that campus from database (MS Acccess) and showing those in a
different drop down list below.
Is there any way that I can access that campus-list value before
submitting it to database?
Also, please give me solutions in VBScript and no javascript. That's my
Prof.s restriction. One of my friend told, there is no way this can be
done. But I am sure there must be some solution. Microsoft is not that less
creative.
View Replies
View Related
We are hosting a web site, and within this web site we are trying to open a .aspx page within the DMZ. Is there anyway to do this? We are currently running Windows 2003 on both servers, and both servers are running IIS. Redirecting the page of course does not work, any other ideas?
View Replies
View Related
As creating folders after a form submission is quite easy (as pointed out in my last post - thanks again) I was wondering If it was also possible to create a new permanent ASP page based on a template .
All that needs to be changed is the title of the page and the file name. However the new page must be a copy of the template (only with these changes in it.
View Replies
View Related
I have say 100 records. I am displaying 10 records per page with 4 columns each per row. And i am able to force page break after 10 records on all pages. Noe one column contains dynamic content. So if the dynamic content is more the page is filled with data.
If the dynamic content is less, the page is not filled completely. So is there a way to check number of lines per page and then fill in the remaining page with another record. In brief displaying records based on page height and then force a page break.
View Replies
View Related
I have implemented a Web Service on an IIS 5.0 platform using the ASP listener
I can access the Web Service just fine from a VB 6 App and classic ASP using the SOAP 3.0 toolkit and its "MSSOAP.SoapClient30" object
However, one of the servers that I'd like to call the Web Service from is a shared hosting platform that does not offer the "MSSOAP.SoapClient30" object
It only has the MS XMLDOM. I have located an example of Accessing a Web Service via the MSXML DOM from an Active Server Page where the Web Service is on a .NET platform (http://home.att.net/~codeLibrary/ASP/ws.htm
But I need to know how to access a Web Service from an Active Server Page with the MS XMLDOM where the Web Service is implemented using classic ASP.
View Replies
View Related
Is there a way in ASP to prevent users from accessing a web page when the back button is pressed in the browser.
View Replies
View Related
What I want to be able to do is create a user control that will display an
entire page page within it. Does anyone know how to do this or better yet
have any same code?
View Replies
View Related
I am doing a project that uses ASP VBScript on Dreamweaver. I try to display data based on the hyperlink on the previous page, where I click on the hyperlink("ID of the informationfile") and the following page will show the detailed information of this particular file.
However, I can't display the next page even if I add the hyperlink and the required parameter on the records that are shown on the first page. I need to ask how can I display the detailed information based on the hyperlink, or in fact the fileID from the first page ??? Code:
View Replies
View Related
What I want to do is have a recordset with all records in and display a list by title with a tick box next to them, then goto a new page which the recordset is all the records that the user selected on the previous page.
View Replies
View Related
I have an asp page that displays informaton from an Access database. I want to create a form that allows users to display only data that matches their search criteria.
I have made many forms like this in Front Page with the Database results wizard, but I want to manually code it. Code:
View Replies
View Related
i have a problem with differentiating these
response.redirect()
server.transfer()
server.execute()
do they all perform same?
View Replies
View Related
if a page always have some picture that totally have near 250k does this a main point of affect the loading speed?
View Replies
View Related
The example I am working from uses the following code which does not work:
RDS.Connect = "Provider='sqloledb';Integrated Security='SSPI';Initial
So I tried the following, but still no go. Code:
View Replies
View Related
The example I am working from uses the following code which does not work:
RDS.Connect = "Provider='sqloledb';Integrated Security='SSPI';Initial
Code:
View Replies
View Related
