Multiple Combos
i'm trying to have a page with 2 combo boxes on it!! The only way i can seem to get it to work is like the code below. I've dim strSQL and strSQL1 and objRS and objRS1 surely they can all work on one line but I can't figure it out. code :
<%OPTION EXPLICIT
Dim objConn, strSQL, objRS, strSQL1, objRS1
Set objConn = Server.Createobject("ADODB.Connection")
objConn.open Application("helpdesk")
strSQL = "SELECT DISTINCT FirstName, Surname FROM Employee_Details ORDER BY FirstName "
strSQL1 = "SELECT DISTINCT Department FROM Employee_Details ORDER BY Department "
set objRS = objConn.Execute(strSQL)
set objRS1 = objconn.Execute(strSQL1)
%>
View Replies
ADVERTISEMENT
i've got 2 combos that are loadeed from 2 recorsets in the db. what i need is that when you select the first combo the recordset of the 2nd is based on the value of the 1st.
the problem is that i want this function to work both ways, so you select the first and it populates the second or you can select the 2nd to populate the 1st. i dont now if the users are going to chose the first or the second combo to search (the first search the product id and second the product name) .
i need to be able if the user chose id the name is set automatic, and the same if we search by name, the id must be automatic. i can only do it if using 1 combo to set the other but not the 2 of them.
View Replies
View Related
I am working in an asp/Vb script environment. In a form I have 2 combo boxes. first is main criteria and second one is sub criteria. in the first combo I have made predefined enteris(the headers of the table) say a table is:emp and its headers are:empid,empname,L1manager,accounts,location etc.
on a change event of first combo,I want to fetch the details from the table. say if I selected Ename in first combo. the second combo should automatically fetch the listed Enames and vice versa.
View Replies
View Related
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
View Replies
View Related
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
View Replies
View Related
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
View Replies
View Related
I have a database being updated by a text file every ten minutes, so in the code that is why the column names are messed up.
My problem is I get all the sums, and counts all working. What I need to do is at the end of it have a sum for for all the columns returned, i.e. col002, I need all the sums in that column added up for a total at the bottom. The following code works but when I try to do column totals I can't get it to work, Code:
View Replies
View Related
I need to connect to 2 different databases in ASP and execute two different queries. Please let me know how to proceed. I understand that ADODB.Command option can connect to only one database at a time.
View Replies
View Related
I have to do a multiple redirect. That means one ASP-script should do more than one HTTP-request.
e.g.
response.redirect(url1)
response.redirect(url2)
...
I know, that it won't work like that... Does anyone now a solution or workaround
View Replies
View Related
Is there a way of using multiple recordsets with the same connection?
My recordset at the moment inserts data into the database, and i want to have a drop down box with data already within the database, as well as the insert recordset, is there a way of doing this?
View Replies
View Related
This is my code, for some reason, when I use this exact code it doesn't update my database, but if I use the next section of code it does. Anybody knows why that when I use two different "Insert" in If Then End If, it doesn't work? Oh and I did try the "If PID = 105 OR 151 Then" alone and it works well. Code:
View Replies
View Related
I have a replace function <%= Replace(arData(0,i), "_", " ")%> that works
fine to replace the _ with a space, but I'd also like it to look for, and
replace one word with another in the same string (E,G replace the word
"Right" with "Wrong"). The code is located in a table that is displaying the
results of a database search.
I'm having problems with a) finding out if it's possible to do it this way,
and b) what the syntax should be. I've tried all manner of combinations, but
no luck. Any ideas?
View Replies
View Related
I WAS having problems. Solved it myself. I'll edit to show the working query for those who could use an example...
I'm having a multiple condition problem in my query statement. I know the what the result should be, but I have something wrong...
Here's the query:
set GetNADs = server.CreateObject("ADODB.Recordset")
set GetNADs.ActiveConnection = adoConnection ......
View Replies
View Related
I need script or a link to a tutorial that will allow me to do the following.
User enters username and password site checks the username and password against database1
if the user entered the correct username and password the page shows records from database2 if the user enterend incorrect username or password then nothing happens.
I am new to this forum and really looking forward to being involved in the community.
View Replies
View Related
i am trying to do Multiple Posting to different Server when
User post the Order form.
one to windows server
second to linux server
third to its own server
View Replies
View Related
how to have multiple language asp pages? For example, you have a database driven website that you want customers around the world to use. How do you setup the asp pages so that it is easy to change the text based on where the user is
connecting from?
View Replies
View Related
I need to have some dynamically created ASP, with mutliple word documents
and PDFs all connected so that it can be printed with a single print
command.
My two ideas are:
having the PDF and DOC files act like images and print entire thing as a web
page.
-Or-
Creating a single PDF file from the concatenation of the asp results and the
doc and pdf files.
View Replies
View Related
I am using asp codes to connect to my access database. But i have a query in mind. Will my database still work if more than 1 user is logon to edit the database records?
View Replies
View Related
How to perform multiple search using asp in website, the search from local adn remote database.
the local search is working properly, but the remote search stil kinda stuck with it...
my local search script(work well):
dim Connection
set Connection = server.createobject("ADODB.Connection")
Connection.open "Provider=SQLOLEDB;DATA SOURCE=PROTOS;UID=smc;PWD=project;DATABASE=Virtual-Observatory"
how to attach the remote database search for the same website??
View Replies
View Related
I have this search and results system on one page....
I'd like it where the results that come up from the search are editable and can be updated.
I can't seem to figure out a working way to update more than one field at a time.anyone have a good piece of code for multiple edits
View Replies
View Related
How can I get this to work?
<% if objRS2("System") <> "Scholastic" OR "Rolling Readers" OR "Reading Recovery" Then Response.Write "selected" End If%>
View Replies
View Related
I have some code I am working on. One function reads a file using fso, then
I have multiple functions using the string read from the file. Each
function splits the lines up and will return one value.
Is there a better way? Is handling this many array which are basically the
same going to cause some server distress
View Replies
View Related
We have a Web page that at load time will execute and build: a DHTML Menu/Data Driven, an Iframe with Detail Data, an Iframe to display Progress Information and another iframe with totals information of the previous iframe with Detail Data. Everything works fine except during the initial load. If we click on any place of the page during the above loading schema, the process stops
and we end-up with Iframes with incomplete information and empty calculations. We need to refresh and avoid using the mouse and keyboard during the load time to get a decent start.Is anyone familiar with this behavior? Any ideas to solve
this issue without disable the mouse?
View Replies
View Related
I'm working on an application that has a worklist of items for users to work on. I'd like to, based on user security, to filter a worklist based on between 1 and 8 items (i.e., location, category, alpha split). That first part is no problem.. the problem is.. how to then allow that user that is (for example) restricted to work 3 locations, to then further filter that worklist to just one location?
Yes.. I can use the ADO filter.. but.. that won't work if you extend the
filter beyond one element (i.e., location and category).
View Replies
View Related
Am having trouble opening multiple recordsets - keep getting the er:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/eft/postflight4.asp, line 146
Have checked the permissions and the user has full access.
Code:
View Replies
View Related
How do I pass in more that one variable in the form tag below
code:
<%
Dim CmdPopulatelist
Set Conn= Server.CreateObject ("ADODB.Connection")
Set CmdPopulatelist = Server.CreateObject("ADODB.Recordset")
%>
.
.
<% sql_select= "select * from Patch_Feedback where Patch_name= '"& view_name &" ' and Name_of_user = '" &Name_of_user &"' " %>
<%
Conn.Open "DSN=Patch;uid=cmadmin;pwd=dci01;database=cm_db"
Conn.execute(sql_select)
CmdPopulatelist.Open sql_select, Conn
%>
.
.
.
<form method ="post" action="updateresponseA1.asp?update_ID=<%Response.Write(""& CmdPopulatelist ("Patch_ID") )%> ">
View Replies
View Related
Is it possible to make a select list item red based on a condition
View Replies
View Related
Does anyone know of a database management program that I can use with my access dbs? I have several access dbs on one server, but have to log in to each one for editing, viewing users, etc. (obviously). I don't know if anything like this exists, but it sure would be helpful if I could just log into one db to view/edit all of my dbs. Does anyone know of such a program?
View Replies
View Related
I am dynamically generating multiple forms E.g.,
form1
form2
form3....depending upon the records
Onclick of a button i am passing the form name to another page through a querystring. I am opening the popup through window.open function. I want the value that calculates from that page to the opener page. For that I want the dynamic form name.
How will i write the form name in the code below:
window.opener.<form_Name>.<field_name>.value="aaa"
View Replies
View Related
I need to retrieve data from an Oracle Database. The values to be retrieved are comming divided by commas, every time I try to run the select I�ll get an error.
View Replies
View Related
I've tried to find this answer, but can't seem to get a clear example -
I'm using the following classic asp code to submit a form:
<form action="default.asp" name=order method=post>
What I need to do is to submit the form to multiple .asp pages, (that I
want to join with frames) and I can't find a way to do it
View Replies
View Related
I have 2 sessions that get created. One when the user logs in called
"uname" and another called "idrma" when that user choses to begin a
repair request.I know <%session.abandon% will kill both sessions,
how to I only target one?
View Replies
View Related
i want to have a search program that has multiple categories.
anybody can give a sample?
View Replies
View Related