Modifying Querystring Information With Drop Downs
What I'm trying to accomplish is the ability to post information to the querystring based upon values that are within a drop down that was generated from a database. Code:
View Replies
ADVERTISEMENT
Drop Downs
is it possable if i set up a drop down and choose somthing a different drop down box will be filled with informatin dependsing on the first one. for example if i choose in drop down box to UK . i then get all the citys in the uk like london and so on. is this possabel.
View Replies View RelatedFilling In Drop Downs W/ASP
I've been using ASP for smaller (up to 4 items) dropdown menus, and so far I've been if/then/ statements such as this boolean case:
Code:
<select name=""gift">
" <%If MyGift = true Then %>
<option value="true" selected>YES</option>
<option value="false">NO</option>
<% Else %>
<option value="true">YES</option>
<option value="false" selected>NO</option>
<% End If %>
</select>
How do you set the selected item in a drop-down menu when you have many items in the dropdown, as in the case where the dropdown contains the 31 possible days in a month?
Linked Drop Downs
how can i change the options of a combo box when selecting an option of another combo box?
View Replies View RelatedDynamic Drop Downs
I have two drop downs. Both dropdowns are dynamic and data is send from a db for both,
Depending on what is selected in the first drop down i want to populate the second drop down. I know and have done this using XMLHTTPScripts but as this is for a website i dont want to go down this route.
Use Sub Drop-downs Or Sub Forms
I don't know what to call what I want, but here is the description. Can I use sub-Lists?
I have a dropdown that conatains a list of products. When a user chooses an item, I want another drop down or anything that will allow them to then choose the specific category.
For example:
#1: I have cars and trucks.
When I user selects cars, I want a dropdown to give them available cars to choose from.
Say for instance the user selects Ford. Then I want them to have the option to choose
from the list of Fords. Escort, T-bird etc. Their final choice is what's sent to the DB.
#2: Also, I don't want to give them the option to enter a date into the DB. I have a field in my DB design "timestamp". I want this field to be automatically populated server side once the data is submitted.
Multiple Drop Downs
i guess it depends on the domain for that answer. If it's a box with hundreds of webpages serving thousands of customers you'd want to conserve network bandwidth you'd probably want to do javascript, but i wouldn't consider reloading a page a big hit since if you just open the connection and runing two queries. But if you need the bandwidth you could do it with javascript.
I try to keep things out of javascripts and out of the hands of the client. Mainly because if they're running an older computer it will take longer to load and put unnessary strain on them and also if the client has scripting disabled you have no more drop down boxes and your site is pretty much disabled. With the strickly asp method you'd have at least the options to choose from and not any core functionality taken from it. That's my 2 cents on javascript to asp.
Multiple Dynamic Drop Downs
Im getting the functionality of it down first, thats what It looks a little bland. Anyway, the basic idea is that im trying to have a person select a department which brings up a list of class numbers, which brings up a table of tutoring times. Ive just started using ASP a week ago, so don't tear me apart too much. Code:
View Replies View RelatedTwo Linked Dynamic Drop Downs
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.
Object Drop Downs Not Appearing
I have an existing ASP file in a virtual directory. When I type server. or request. in this text file using Microsoft Script Editor I get a dropdown showing the properties available for the object.
However, if I change the extension to ASP on an existing html file, or create a new asp file I'm not getting the dropdown. I suppose this indicates the objects are not available in these new files, and they would not run properly if I tried to open them. What am I missing in setting up these new ASP files?
Multiple Drop Downs In A Form
basically what im trying to do is create a form to submit some data to an access db.
In the form i want to be able to have two dynamically populated drop downs (so if a user chooses cars in the first field it comes up with a bunch of car manufacturers, or if he chooses boats it comes up with boat builders etc etc.)
Ive searched high and low, and i the best i can find is javascript to make the drop dows. The java script however uses a form to repost the data back to the page to populate the second drop down. This wont work when its inside a form.
Dynamic Drop Downs And Page Variables
i have a website that uses (or needs to use) dynamically driven dropdowns using asp & JS on all pages. it contains 3 different dropdowns that are DB fed and are dependent upon the value of each other. the drop down values are updated using a repost to itself.
they work perfectly on the initial pages where no other variables are involved, but i am having troubles on the pages where more variables are being sent. eg: i have use a lot of error checking, and when i repost, the variables are deleted, and thus the error listings take effect as the variables are now blank. can i refresh the dropdowns without repossting to the samepage without effecting the existing variables on that page? sessions? cookies?
Dril Downs
I am creating a asp script that pulls records of an oracle database and displaying it as a table on an asp page. however what I want to do is display the records as links. for example.
record 1
(if record one is clicked)
record 1
information of another record from database 1
information another record from database 2
etc.
(and if record 1 is clicked again)
record 1
i really jus started learning asp and if anyone knows how to do that without any issues with client and server sides.
Drill Downs
I have a table, which is bound to a database, how would I go about, making fields in one column, so that I can drill down on them.For example, I have a column of Groups, and I wish to click on a group and see the members in that group.
View Replies View RelatedModifying
I have been searching for a solution to a permissions problem:
Currently, I have an app that creates an html file in a folder on the web server, closes the file, opens it again and dumps the contents into an HTML-formatted e-mail message. In order to create and open the file, I had to set permissions for anonymous browsers to READ/WRITE.
The app works fine, but this poses a security problem, because the files contain personal data that anyone may intentionally or unintentionally view.
My question is: Is it possible to modify the folder permissions within the ASP app? I'd like to open the folder for READ/WRITE in order to create the file and open it for sending the e-mail and then immediately turn off all permissions for anonymous browsers.
Modifying
is there a way to modify outlook distribution lists via ASP
View Replies View RelatedModifying Database
I need to modify the contents of a particular cell in an access database with asp. I know how to add rows to the table by using:
strQ = "INSERT INTO table1 (name, pass ) VALUES('"&fnames&"','"&fpass&"')"
objConn.Execute strQ
Is there a similar command i can use to select a particular row in the database and then change the contents of one of the columns?
Modifying Results
Using the following query I get my desired results. However, in the resulting recordset, how can I show for example 10 words before and 10 words after the keyword or phrase that was searched upon? If I get 20 resulting records I think it would be easier for the user to decide which they want to view.
DECLARE @SearchString varchar(100)
SET @SearchString = ' "stress" '
SELECT KEY_TBL.RANK, Title, Body
FROM Articles INNER JOIN
FREETEXTTABLE(Articles,*, @SearchString) AS KEY_TBL
ON Articles.ID = KEY_TBL.[KEY]
ORDER BY Rank DESC
Modifying PNG Files Within ASP
I have a simple png image file which has a white background and one layer of text. Is there a way in ASP/VB to dynamically change the contents of the text layer? I guess the steps would be to load the image, extract and replace the text, rebuild the image and save to the file system under a new name.
View Replies View RelatedModifying Code
Instead of locking this bit of code down to the "crreport1.rpt" entry I was wanting to have it receive a "POST" command(from a form page that would post to the page that contains this code) so that it can be more dynamic. Here's the original: Code:
Set session("oRpt") = session("oApp").OpenReport(basePath & "report1.rpt", 1)
Would something like this work in my asp page?Code:
Set session("oRpt") = session("oApp").OpenReport(basePath & Request.Form("report"), 1)
and then use something like www.test.com?report=report1.rpt
Modifying Code
I have downloaded some sample code from the net to display a calendar etc.
The code is below.
How can I modify this code so that when called in a popup window and a date
is clicked, that date is inserted into a form field on the original page. I
know how to pass this value back but do not know how to modify this code to
include the correct line. Code:
Modifying Content
if I could use the same 'Thank You' page but display a different message depending on which page it was referred to from: eg an order page or a mailing list page. Is there a way ASP can tell which was the preceding page?
View Replies View RelatedModifying Sql Queries On The Fly With Variables
I currently have a sql query that pulls all records based on a variable(var1) inputed by a user from a form. Each record in my database has a time stamp assoicated with it. I want to give the user the option of pulling all records based on (var1) and allow them to sort based on date or time stamp also with a two fields that will take a range.
(ex. Beginning date and Ending date). So my default sql query will allow for var1 to be inserted and to have all records returned for the current day. BUT, IF A USER HAS ENTERED
A DATE RANGE then all records will be returned for that date range based on the var1's value. How could i go about about structuring my code for this? I was thinking about a "Switch" statement that could response to different user options with different sql queries. What do you guys think?
Modifying A Radio Button
I cannot remember how you modify a radio button value that comes from a database. Here's my code:
<tr>
<td align="right"><font face="Arial" size=-1><strong>
Show Email Address?</strong></font></td>
<td> <input type="radio" name="radEmail" value="<%=ShowEmail%>" checked>
Yes
<input type="radio" name="radEmail" value=No>
No</td>
I am using a SQL Server database. I am using a bit datatype. O is true and 1 is False. How do I get the radio button to have the correct value checked for a certain record?
Modifying Number Format
Does anyone have and easy way of modifying the format of a number once pulled from an Access database? In the thread listed above, Access is stripping the 0's in front of my numbers. As a work around I have an If statement that checks to see if the number is < 10 and if so write a 0 before pulling from the recordset. I'm looking for a simpler, one line code instead of the big If statement.
View Replies View RelatedModifying A Word Document
I know that using Word Automation inside an ASP page is no good idea.Anything I want to do in the current project is: open document, change some text, save and close document. Basically changing some variables, consting of a name embraced by special chars, to some value. As for example: change "[FirstName]" to "Michael".
Does anybody know whether there is a way for achieving this with basic "file input / output". Can I regard a Word document as some binary data, perform the replacement, and save the data, without destroying Word's internal structure?
Modifying Authentication ASP Form
i have absolutely no experience using ASP or PHP, but I've been tasked with making a simple login page for certain clients. I found this tutorial which is almost what i'm looking for.
The one thing that i need to modify is each username, after login, must be directed to a specific protected page. Since the username and password get split into an array, i know there must be a way to also keep track of which pages are associated with which usernames, and then have that URL be evaluated in this line of code:
Code:
Response.Redirect ("/protected/default.asp")
if anyone has a better way of doing this simple form that would be very helpful as well, thanks
-ak
Modifying Iusr_machine Account
I have a typical internet web site that uses a VFP database on the back end which is accessed via ASP/ADO using the VFP OLEDB provider.
My ASP code for establishing a connection looked like this:
Set oConn = Server.CreateObject("ADODB.connection")
oConn.Open "Provider=vfpoledb;" & _
"Data Source=C:edsDATAedsdata.dbc;" & _
"Mode=ReadWrite|Share Deny None;" & _
"Collating Sequence=MACHINE;" & _
"Password=''"
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set rsUsers = Server.CreateObject("ADODB.Recordset")
It was working just fine. Then the need arrised to move the database off the web server box and onto a file server on the same domain. Code:
Modifying Text File Using FSO
if it is possible to open a text file using FSO and modifying the content of it.I have a template of a file (template.bsi) as a text file and I want to change variables within the text file by a simple replace command, but I'm not sure whether this is possible.
View Replies View RelatedPassing QueryString URL As A Paremeter In QueryString
The subject sounds confusing but here is what i want to do. I have a
button on my page which says
OnClick="javascript:window.open('reportsContainer.asp?pag eURL=Report1.asp?intCurrentPage=1&blnRetrieveFlag=1&Show=1',TasksRPT');"
Now on the Conatiner.asp what i do is
if Request.QueryString("Show") = 1 then
pageURL = Request.QueryString("pageURL")
end if
And then i set the pageURL along with intCurrentPage and
blnRetrieveFlag parameters to my fram src as
<frame height=500 scrolling=auto name="pageFrame" id="pageFrame"
border=0 src="<%=pageURL%>">
Code:
SQL/VBscript - Modifying Design Of Tables From Within ASP Page
i'm wondering if it's possible to modify the design of an sql database from within a script. I don't have MS SQL installed on my machine but i need to add a few fields to some of the tables.
I know it's possible to create and drop tables so that is one option. ie: drop the existing one and create it again with the extra fields. the problem with that way is I'll lose all the data. so long story short. how do i modify the design of a table from within a vbscript?
Display Drop Down Options Based On The Selected Item From Another Drop Down
The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:
View Replies View RelatedOpening Server-side Excel File Then Modifying It Client Side Using Vbscript
is it possible to open an excel file (used as a template) from server using server-side vbscript; then modify it or add values from client using client-side vbscript?
View Replies View Related