Loading Stuff Into Combobox
I have a combobox that on page load is disabled. I've noticed that the information will not load into the combo box if this is the case. Is there a way to load the information and then disable it so the user has no idea what has happened? I load another combobox before this one, that is NOT disabled and so loads properly.
Code:
="1" name="County" disabled="true">
<%
While not objrs.eof
%>
<option value ="<%=objrs("County")%>">
<%=objrs.fields("County")%>
<%
objrs.movenext
wend
objrs.close
%>
View Replies
ADVERTISEMENT
I'm trying o get my head around XML and using ASP to parse documents.
I've managed to kncok together the code below to send a request to an
external server and then pop the response into a variable and format it
a bit.
What I'm trying to do is insert the data into a nice HTML table, maybe
using the node names as column headings. Has anyone got any suggestions
on how I can do this? and also, is this the best methid of performing
this task? I need it to be xbrowser compatible so I figured server side
would be the best option. Code:
View Replies
View Related
I've written several scenarios where the end user needs to enter data into a textarea (descriptions, messges etc) which becomes part of a form. End users often put apostrophe's and carrige returns in the textarea... however, when the code i write is submitted to the database, it generates an sql command from the page that sent the action.
Client Side:
<form action="somepage.asp" method="post">
<input type="text" name="emailaddress">
<textarea cols="20" rows="5" name="comments"></textarea>
</form>
On code submission...
sql="insert into tableName (email,comments) values ('" & request.form("emailaddress") & "','" & request.form("comments") & "');"
db.execute(sql)
Now, when strange people put carrige returns, it stuffs up the string and therefore produces an error, and to make matters worse if it did recognise a carrige return, it wouldn't be displayed on HTML output. Apostrophes are even worse - they signify the end of a variable in the SQL sentance Can anyone help me and figure out a new way of writing to the DB?
View Replies
View Related
I'm gonna be writing a new ASP based system for work for staff to book in deliverys with our warehouse - I'm starting to think about the database design and i'm trying to think how best to work it - Each day will be a record - with a date field - but I have no idea how to automatically create a date field with concurrent dates - and also we can book deliverys upto 6 months in advance, so there needs to be a lot of records created.
View Replies
View Related
<%
dyear = year(RS("dates"))
dmonth = Month(RS("dates"))
dDay = day(RS("dates"))
response.write dyear
response.write dmonth
response.write dDay
%>
i get 2003 12 9
how do i dispaly 2003 December Tuesday
View Replies
View Related
I have a web form (fine so far) which POSTs to a PHP routine which mails the information. Very standard. Now I would like to update a database as well as emailing the form contents.
The problem is that the database has to br MS SQL and I can't install the bits to make it work with PHP - so the database part HAS to be ASP. The mail bit HAS to be PHP as that's the only mail routine I can use. Code:
View Replies
View Related
is it possible to do a insert, add, and a redirect all on the same page?
for example... signup.asp. there's a text box labeled Acctid. If you don't have an acctid please enter "0000" otherwise enter one. This box is used to see if they have an existing account in the database by using an UPDATE query and if they don't it does an INSERT query with acctid = 0000 for all non customers. What I want the if.then.else statement to do is to
If acctid = "0000" then
conn.execute acct_add
(and if sucessful to response.redirect "/yay.asp"
Else if NOT acctid = "0000" then
conn.execute acct_update
(but I want it to return an error if the update wasn't sucessful either because the acount doesn't exist or watever and if the update was sucessful to response.redirect "/yay.asp") END IF
Do ya get it?
View Replies
View Related
I am about to get rid of TZO on my computer, and I've been using it's photo software to view photo's on my web site. I could write something in ASP (or asp.net), but I figure why spend time re-inventing the wheel if there's something already out there.
Does anyone have any recommendations on ASP apps that I can use for viewing photo's on my web site? I would rather it be free if possible, and it needs to just look at a folder, or series of folders, and build a thumbnail type of view from what's there. In other words, I don't want to have to populate a database with all of my pictures.
View Replies
View Related
I was wondering if anybody could help me translate this from my native Cold Fusion tongue to ASP? :
#DateFormat(Visitors_DateTime, 'dd mmmm yyyy')#
#TimeFormat(Visitors_DateTime, 'h:mm tt')#
The data is held with SQL2000 in a smalldatetime datatype column.
Would just like to display the full date and time really.
View Replies
View Related
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 Related
how to clear the combobox by calling a function in ASP.
View Replies
View Related
I 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 Related
I 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.
View Replies
View Related
sourinsen is correct. that's the way to split values in your combobox.
View Replies
View Related
How can I check if a table exists in an MS SQL database using asp.
View Replies
View Related
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.
View Replies
View Related
i 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.
View Replies
View Related
What is the most simple way to make an editable combobox bounded to the database.
View Replies
View Related
i 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 Related
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?
View Replies
View Related
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:
View Replies
View Related
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 >
View Replies
View Related
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
View Replies
View Related
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 Related
I 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
I have a combo box in an ASP page, there are 7 lists total in the combo box, there is another text box on the page and a search button. I want the users to select an item from the combo box and type a keyword and click search.
The combo item and keyword will be used as an criteria to query a SQL database. I'm familiar with SQL connection and running queries but how do I take the criteria and pass on further.
View Replies
View Related
I want to be able to search a user with a user code, get a form populate if the user exist in the Database, but at the same time in one corner of the form I want to be able to see the list of other user's code in a ComboBox from the Database, and onclicking on any user code in the ComboBox the same form should be populated with the user' information.
Right now I have a functional Application but without the ComboBox functionality.
View Replies
View Related
I am working on a HTML form with textfields, radiobuttons and comboboxs. I was wondering if it were possible to automatically update values within a combobox based on the users selection of a radiobutton. I have stored values within a database table of 'seminar_times' and the two radiobuttons options are 'city1' and 'city2' on the form.
So on the form, when the user selects city1 radiobutton, the combobox value updates with approriate city1 seminar times. Is this possible with ASP programming?
View Replies
View Related
I'm trying to call a sub procedure with the onchange event of a combobox. Code:
View Replies
View Related
I m having three combo boxes on my asp page.
For 1st, i m fetching values thru a query.
For second, I want to populate it with values thru a query by giving the selection from first combobox as input.
Similarly for Third also i want to populate it with values using query by entering selection from second combobox as input.
So in other words second combobox is dependent on first and third combobox is dependent on second combobox.
View Replies
View Related
We have a web server running IIS 5.0 that will not load
any file with an .asp file extension. The server
loads .html just fine, but all links to an .asp file end
up timing out.
View Replies
View Related
Is it possible to create a loading bar with ASP? I am thinking of displaying the loading bar while my customers' requests are being processed (databse update).
View Replies
View Related