Combos Selection
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
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'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
View Related
i want to do a voting, which let user select. how can i count the number of user vote?
n... how can i accumulate each slection and display a chart by percent?
example:
.apple
.beer
View Replies
View Related
I have a web page where a user can select a location out of a possibility of 5. I also give them the option of seraching all 5.
However when I put this in it get rids of the drop down box and puts them all in an open box about 2 inches in length. Which isn't too bad but if I say had 20 locations it would take up half the page.
View Replies
View Related
I have a form field called Streets that contains 'HIGH STREET,MAIN STREET'
I have a field in my access db called StreetName a single record would contain one street and I want to return all records that have a StreetName in the Streets field. How would I go about this?
View Replies
View Related
I do not write the whole code.
I have a IF statement like the following.
if request.Form("UyeTipi") = 1 then
strsql=select ****
else if request.Form("UyeTipi") = 2 then
strsql2=select *****
this is the recordset
set objRecordset = objConnection.Execute(strSql)
With loop I want to display data either from "strsql1" or "strsql2"
I create table like the following with loop
Code:
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
My left frame contains a combo box which loads the selected record in the main frame.The combo box retrieves concatenated 3 columns from my db. E.g. ID, Firstname & Surname.
Because of this, it seems to blow out the size of the frame,thus ruining my nav system.Does anyone know how I can restrict the box width, but allow the drop down part to remain wide?
View Replies
View Related
How do i select a completly random record from a database?
sql = select (random) from tbl, sort of thing.
View Replies
View Related
I have searched through a lot of paging articles. But I have not found any specific recommendations for my issue. I have a large record set that I need to page through (1000 records). But on each page (100 records) I must be able to select some rows, add
some comment for each and sumarize them on-the fly.
if I page forward and backward, I still need to see before selected rows with comments and I can even deselect or edit some of them. Should I store all this information (selection, comment, price) in session variables or is there a better way?
View Replies
View Related
My site is running on IIS5.0 hosted on win2k service pack 4 m/c. We are going to procure high end windows M/C . I seek your advice in selecting right os and version of IIS. My comp is a bit hesitant to migrate to .net too (I don’t know planning of comp in future).My requirement should be
1) Same Program should run on new server with minimum changes.
2) If required we can migrate to .net (although planning is not in near future and I even don’t know what is needed for that)
Your advice in this regard is highly appreciated. Also if you can explain in short about new feature in IIS6.0 (or upper version). Which version of IIS come along with Windows 2003 server, I really have very little knowledge in this field.
View Replies
View Related
i am using frontpage ,ASP, and some javascript. how do you create a START-> ALL PROGRAMS selection option. you place the mouse over the "all programs" and you got all selection related to "all programs"
i want to do the same thing with data from a database. how do i do this?
View Replies
View Related
I have this code the value thats stored in table is Yes in College_Assistance field
so i want to select the Yes radio button
but its not selecting
when i see he view source it doesnt say checked="true"
any idea why. Code:
View Replies
View Related
I have a selection list of the 50 states that is not dynamically built. If &state=CA is in the query string i want the selection list to automatically select CA out of the selection list since that is what was in the querystring. Know what I mean?
View Replies
View Related
Has anyone used the UPS e-tools such as address verification and rate selection service? I'm trying to implement it on our site and I would just about kill to see some source code. It's a little above my coding level and I just can't seem to figure it out.
The documentation goes into a VB sample, but I dont think that is necessary since you can perform an HTTP POST and parse XML in an ASP page.
View Replies
View Related
I am trying to show some stats. However I have four levels to choose from, which are shown as true/false. I want to count each entry by employee and categorize it only under the highest level achieved. One entry can have multiply Levels. Hope this make sense my mind is a little foggy today.
Here is the sql statement I am using. I have added the levels as or however I want to count each level but only the highest level achived. I don't know if it would be easier to do this in a SQL statement or in vb script. Code:
View Replies
View Related
I have 4 radio buttons
<input type="radio" name="One" value="One" checked
One
<input type="radio" name="Two" value="two"
Two
<input type="radio" name="Three" value="Three"
Three
<input type="radio" name="Fout" value="Four" >
Four
How do i remember wich one was selected when the page is posted back.Meaning having all options back with the selected one being checked.
View Replies
View Related
I have a webpage where there are two drop down menues. From each of them, one item can be selected. I need code to test if there was an item selected from both the drop down menus. How do I do this? Do use ASP or HTML?
View Replies
View Related
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
How can i retrive random row of table in ASP.i have a table created in
access2003 and i want to show randomly selected row to the client.is
there any way to do this using recordset object.
View Replies
View Related
I have a script that has worked flawlessly for a while. It allows a user to select from a listbox - with highlighted lines already of their settings, multiple lines (CTRL-SHFT) and the page updates the database properly.
Now, for some reason, I have a user that when we load their settings, all is fine. If I submit the form, immediately, with no new additional selections, all works fine. But, if I add even one new selection on the list box by holding CTRL-SHFT, the submit button no longer works at all.
This user does have a long list of selections already, I am just wondering if I may have hit a max some how?
View Replies
View Related
Is there an SQL query which select an item from the database randomely!
View Replies
View Related
I have a dropdown list where u can add students name inside the listbox. As u can see there is a "Please select one" option in the dropdown list also. When i click on the option, it will be added into the listbox also. Can someone pls help me to solve this in JavaScript. My attachment.
if (document.teamForm.newMember.value == "-- Please Select One --")
{
alert ("You can not select this option.")
teamForm.newMember.focus();
return false;
}
View Replies
View Related
I have used the follwing query before in SQL and its worked fine but not on an access database is the syntax different?Code:
strSQL = "SELECT Count(DISTINCT BID) as varAmount FROM Bookings Where BookedBy = '" & rsStaff("Name") & "'"
The Error i recieve is:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Count(DISTINCT BID)'.
View Replies
View Related
I have three sets checkboxes in my .
Checkbox a,b,c with different names
If a user selects checkboxes in set A. He cannot select any check box in set B, but he must select in C. If a user selects check boxes in set B. He cannot select any check box in A and C. If a user selects check boxes in C. He cannot select any check box in set B, but he must select in set A.
View Replies
View Related
i have 5 checkboxes in one asp page, I am trying to get the values of all checkbox that are checked using for each loop but I dnt get any result,just a blank page. Herez my code where I am trying to get the values of all check boxes
Code:
for each cid in request.Form("chk")
response.Write cid & "<br>"
next
View Replies
View Related
i have an access database with 5 records in and i need to show them in a random order every time the page is refreshed or reloaded. i've searched round and tryed no end of code but nothing seems to work.
i just need something really simple that selects a random feild from my DB. Sql = "SELECT * FROM tblmain ORDER BY RND()" - ive tryed this and it just shows the results in teh same order.
View Replies
View Related
i have 5 checkboxes in one asp page, I am trying to get the values of all checkbox that are checked using for each loop but I dnt get any result, just a blank page. Herez my code where I am trying to get the values of all check boxes:
for each cid in request.Form("chk")
response.Write cid & "<br>"
next
View Replies
View Related
I'm creating a bilingual site for an Intranet. The site is created with a modified version of NukeEdit. The way it works is I have 2 completely seperate sites that are identical for both languages (other than the content of course).
To make things simpler all the files and folders are named in English so the directory and file stucture for the site is the same for both languages.
On each page there is a button to switch languages. The thing is I have the button linking to the homepage. I would like it to be a bit smarter and take you to the actual page you're in. Code:
View Replies
View Related
Is there any way to select mutiple files from Client machine's drive for uploading?
View Replies
View Related
I have a list box that allows users to search an SQL database on ZIP, Name and so on
After the submit the List Box selection always goes back to the defaut selection.
I figured by writing the current selected item to a cookie prior to the submit I could recall it upon reload.
Does anybody know how to set default selected item for a list box? Am I going about this the right way? The more I research it seems dynamically creating the list box is the way t go
View Replies
View Related
At the moment i'm working on a template based newsletterscript and this a testscript to get some variables. This is actually working for one record but i want it to get al the records where the Newsid = "1" e.q.
It's not necessary to print/ write the results but this is just testing.
Actually the following part should be a select case... depending on the value of the column = template e.q "1" he should display this record in another format. Code:
View Replies
View Related
