I am using one combo box and populating it with the values . i have another combo box on the page. I want to display the related values in this second combo box based on the selection in the first combo box.
I am trying to reload this page on the change event of the combo box but the values are not coming in the 2nd combo box . Please send me a solution to this or if possible a sample code for the same.
I have a database that has 2 tables linked into it from another database. I am having problems trying to pull in values from those 2 linked databases. One of the tables is tblClient. Code:
View Replies View RelatedIthe goalposts have been moved (yet again!) and the database that was one, may have to become many, being used on subdomains of the same server sharing some information but not all from a 'global' database.The solution I initially found was to used linked tables and developing it on pws - this was perfect. I linked local databases to the external table data in the 'global' database hey presto the application ran smoothly. There was only 1 connection to each local database and I could retrieve all the information I needed from the global one. However on uploading I have no idea how to set this via asp or sql as online the path of the linked tables is what was on my local machine and I have found no way of being able to edit this or indeed know if this is possible.
View Replies View Relatedim trying to link to a Access db which uses linked tables via a odbc connection... is there anything different about the connection string / driver?
adoConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Resources/peterjohntest.mdb")
but this error comes up Code:
how can i get the combobox value? i need to check the contents in the combobox for validation.
View Replies View Related<i><b>Originally posted by : dhiren (dhirenchauhan@yahoo.com)</b></i><br /><br />depending upon selection of first combobox second combobox should contain all value related to only first combobox.
View Replies View RelatedI have a "booking" section on my intranet.
2 questions.
1. Can I, say by session, determine if a user logged in can amend/delete data they have entered? But no one else.
Say they book a conference room, but only they can delete it
2. I want to prevent cross bookings (in terms) of time.
I have an Access DB that has a linked table to a SQL Anywhere DB. When I try to access this Access DB, it prompts me the first time every time for username and password to the SQLA DB. This isn't a problem when it is just me that is working on development, however,
I figured MS would have something good to say about this issue, so that my users can use this DB as well. MS says I need to pre-open the table using the same credentials for both DB's. I have tried this several ways, and am still unable to open the linked access DB.
The error I get is that the DSN=xsellvehicles (this is the DSN that is used by Access to open the table that resides in SQLA) can't be used because the username or password doesn't work.
I've been tasked with the challenge of re-sizing images linked via BBcode on the fly. I have compiled a list of functions that do individual components of this task, but stringing them together has proved, well, a challenge.
I discovered this code that will re-size the images, however this will need to be added on an ad-hoc basis, and the fact that the image name appears twice complicates the usual system I used to add the code.
Usual way of replacing the code (inside a function):
Code:
vText = Replace(vText,"[ img ]","<div align='center'><img align='middle' src='")
vText = Replace(vText,"[/ img ]","'></div>")
Image resize code:
if you have seen an example floating around on the internet of three linked list boxs using asp code and a database connection. I have managed to get it to work for the first 2 list boxs, but I am unable to get it to populate the third list box, this is how it is:-
Tables:-
Main_cat
Sub_cat
Subsub_cat.
Not all Sub_cats will have subsub_cats, hope this makes sense. I have attached the code.
how can i change the options of a combo box when selecting an option of another combo box?
View Replies View RelatedI currently have a page with car manufacturers in a dynamic form menu. Users can select one and click submit to find available cars by that manufacturer. What i now need is a second menu on the page where when a manufacturer is selected, the models associated with that manufacturer display for a user to choose. For example if Ford is selected:
Menu One Menu Two
------------------ -----------------
Ford Focus
Fiesta
Ka....
Can i do this with ASP to say "if menu one is ford, menu two contains...."? Or is there a much easier way which i am somehow missing?
how to clear the combobox by calling a function in ASP.
View Replies View RelatedI have combobox that those value is based on my database. So i want to get the selected value in order to do another matching for the SQL statement. May i know how to get it? Is it just use for example WHERE column=' "&combobox&" '? use the combobox name.
View Replies View RelatedI need to display the time in combo box like the one we have it inWindows 2000.we can change the time using the arrow.. it looks like this:
4:40:54 PM
in a text box. i need to do it like this in my page.
sourinsen is correct. that's the way to split values in your combobox.
View Replies View RelatedHow can I check if a table exists in an MS SQL database using asp.
View Replies View Relatedi have already populate a list from my database using the following code . Code:
<form method=post action="ProcessOrder.asp">
<select NAME="TEST">
<% Do while NOT rsHis.EOF
response.write "<OPTION VALUE=' " & rshis("pic_id") & " '> "
response.write rshis("title")
rsHis.MoveNext
loop%>
</select>
But i dont know how to present the results from the combo box.
What is the most simple way to make an editable combobox bounded to the database.
View Replies View Relatedi have several radio buttons and a combobox. i want to know how to make this combobox enabled only once a radio button is checked and populate it with data from access database depending on which button is checked.
View Replies View RelatedCode:
' then set up a query
' -----------------------------------------------
sQuery = "SELECT DISTINCT * from tablename Order By columnA, columnB " ' << insert your own sql here
could someone give an example so I could follow it?
I want to link 2 list boxes on the same page without reloading it. The list boxes are dynamic and when one selects an item in the first one, the second one get's populated accordingly. So far I've been stuck with Javascript Object Expected Error and I cant find a way to make it work. Code:
View Replies View RelatedI am unable to show and image or flash i have in an access database that is linked to an images subfolder, below is what i am using to show text on my ASP page but i want to ad a couple of images to the database to show in different locations on the page or pages, so i guess i needed a call function but ive used the one i have on my database image rotator scipt and a few others i have dowloaded and still the call scripts wont work, i'm sure im doing alot wrong can someone please edit this code and show me what to do... if its no bother
This works fine for showing the text on a page:
<%
Dim rs
Set rs = Server.CreateObject ("ADODB.Recordset")
rs.Open "introtext", "DSN=introTXT.mdb"
While Not rs.EOF
Response.Write "<br>" & rs("Content") & "<br>"
Response.Write "" & rs("URL") & ""
rs.MoveNext
Wend
rs.Close
Set rs = Nothing
%>
I want to create an asp page from these forms in my database:
Database:
Table 1 =>
1.1) ID:
1.2) Product Name
1.3) Description
Table 2 => For the ASP Form
2.1) ID:
2.2) Text field 1 (Normal input field)
2.3) Product (Dropdown Menu, Data Source Table 1, Field 1.2)
2.4) Description (Text Field, Data Source Table 1, Field 1.3)
The Description value should be in correlation with the Dropdown Menu value in Table 1
I want to make a form where m using two drop down menus.
Where in based on selection in first drop down the second drop down should populate itself with relevant data based on first drop down. Like first can be COUNTRY name and second can be STATE name where based oon country selected the STATES are displayed in second drop down for selection.
I have an ASP-page where I want to be able to select a fabric and color of that fabric. Since different fabrics comes with different colors I want to have a form with two drop-down lists where selection of fabric in the first list populates the second list with the right set of colors. I need to have the lists in the same form so it only require one submit.
View Replies View RelatedI'm creating a forum based site with basic BBCode features, but am concerned that misuse of the [ img ] tag will mess up my layout. I do not want to go down to road of users uploading images, but want to allow them to embed images from flickr, photobucket etc.
So, is it possible to restrict all linked images that are say, over 400 pixels wide? I've been racking my brains and have had trouble coming up with any solutions. Is it possible?
I'm using a VB combo box in an ASP/VBScript app
<OBJECT ID="cmbLocation" NAME="cmbLocation" WIDTH=238 HEIGHT=23 CLASSID="CLSID:8BD21D30-EC42-11CE-9E0D-00AA006002f3">
<PARAM NAME="VariousPropertyBits" VALUE="746604571">
<PARAM NAME="DisplayStyle" VALUE="3">
<PARAM NAME="Size" VALUE="2540;635">
<PARAM NAME="MatchEntry" VALUE="2">
<PARAM NAME="ShowDropButtonWhen" VALUE="2">
<PARAM NAME="FontCharSet" VALUE="0">
<PARAM NAME="FontPitchAndFamily" VALUE="2">
<PARAM NAME="FontHeight" VALUE="232">
<PARAM NAME="LimitToList" VALUE="No">
</OBJECT>
I'm using the _change event to copy the combobox value to a hidden input box called txtLocation
<script type="text/vbscript">
function cmbLocation_change()
addForm.txtLocation.value = location_array(addForm.cmbLocation.listindex)
addForm.btnLocation.focus()
end function
</script>
Is there a keypress event for the combobox?
In my Data Access Page, I have a a combo box from which the user can select a specific record to view based on the value SupervisorManagerName. My combo box works fine in that respect. The user clicks on a name in the combo box, and the record is populated with the correct record.
When I add a *new* record, however, the combo box does not refresh immediately to include the new SupervisorManagerName in its list. Once I close the DAP and then reopen it, the new SupervisorManagerName is included in the combo box, and I can select the name to pull up the record.
Any suggestions on how to get the combo box to refresh immediately upon adding/saving a new record without having to actually close and then reopen the page?
I am able to make this process work using VBA and a regular Access page, but can't figure out how to do this using vbScript Code:
I have a Combobox and a textbox in my asp page. I want the value of Combobox in Onchange event shows in the textbox. this my code but it isnot correct.
<script Language="JavaScript">
function NavTo(a1)
{
document.forms[0].text1.value=a1
}
</Script>
<SELECT id=select1 name=select1 onchange=Navto(document.forms[0].select1.value)>
<OPTION value="1046">1046</OPTION>
<OPTION value="1045">1045</OPTION>
</select>
<INPUT type="text" id=text1 name=text1 >
I want to write an sql statement given that the request form combobox has a particular index or a particular value. The combobox in the below example only has 4 items, hense why i am using index.-But does index exist in ASP?also would the below procedure work?
If Request.Form("cmdSearch") then
if Request.Form("Turnover").Index = 0 then
sql = "Select * from Prospect "
sql = SQL & "WHERE Turnover < 999000"
elseif Request.Form("Turnover").Index = 1 then
sql = "Select * from Prospect "
sql = SQL & "WHERE Turnover > 999000 AND Turnover < 5000000"
endif
endif
i retreived my data's in the database and i filled in my combobox, in that there is know "all" option in database,but i need that option has to be included in my combobox, so it has to be added statically, please give me coding to add that in my combo box statically. my combobox name is "selSchemeNo" .
View Replies View RelatedI cant save my data, i tested with response.write 1 and 2 and it only gives me the first one, why is this appening, the code seem good? Code:
View Replies View Related