I want to make a dropdown using a column from my table in the list of the dropdown.
What's wrong with this?
<form>
<select size="1" name="D1">
<option VALUE="0" SELECTED>chapter</option><br>
<%Do while not RS.eof
ResponseWrite "<option VALUE="" & chapter & "">chapter</option><br>"
rs.movenext
loop
' Exit the loop when reaching the end of the recordset
'If rs.EOF Then Exit For end if
'next
'end if%>
</select></form>
I want to make a dropdown using a column from my table in the list of the dropdown. What's wrong with this? Code:
<form>
<select size="1" name="D1">
<option VALUE="0" SELECTED>chapter</option><br>
<%Do while not RS.eof
ResponseWrite "<option VALUE="" & chapter & "">chapter</option><br>"
rs.movenext
loop
' Exit the loop when reaching the end of the recordset
'If rs.EOF Then Exit For end if
'next
'end if%>
</select></form>
I want to make a dropdown using a column from my table in the list of the dropdown. What's wrong with this? Code:
<form>
<select size="1" name="D1">
<option VALUE="0" SELECTED>chapter</option><br>
<%Do while not RS.eof
ResponseWrite "<option VALUE="" & chapter & "">chapter</option><br>"
rs.movenext
loop
' Exit the loop when reaching the end of the recordset
'If rs.EOF Then Exit For end if
'next
'end if%>
</select></form>
I have a category that I will call "company". in my access DB, there are about 6 or so companies. On another table, I have a list of locations that are related to these companies.
What I want to do, is have a drop down menu that lists all the companies. When you select the company, the second drop down menu will automatically populate with the locations of the company you selected in the first dropdown.
Anyone know any links to some examples of this? My google searches have been pretty fruitless since Im having a bit of a problem trying to explain it concisely (as you probably noticed).
Anyone got a good tutorial on how to build a CMS with ASP?
View Replies View RelatedI have the following piece of code:If RS.EOF or RS.BOF Then
Session("Authenticated") = False
Response.Write "Sorry, your userid or password did not match"
Response.Write "<BR>"
Response.Write " or you have not registerd yet, please register"
Response.Write <a href="default.asp">Clik here
Response.End
Here, I need to build the line (Response.Write <a href="default.asp">Clik
here)
dynamically, so that the html output from asp page
gives us <a href="default.asp">Clik here
I have a situation where I have to update a single table with information from a bunch of fields. So I can explain better this is a sample table with some data... Code:
I am having trouble with structuring my query for searching using "LIKE". I
return no records with my current SQL statement.
Here is the string I am sending through ASP using VBScript as my language.
Other piece:
strClass = Request("SiteLOCCode")
String from ASP page:
"SELECT * FROM LDSWSNames WHERE WSName LIKE '" & strClass & "' "
Output string from ASP:
SELECT * FROM LDSWSNames WHERE WSName LIKE 'KYLEXAD01'
I'm facing a crazy problem:
<%
spc = "<abcd"
response.write spc
%>
will not work, spc is empty.When I replace <abcd with ab<cd, then spc contains only ab.
Where do I make the mistake ?
I need to get my name value "MenuSubCat" to act as athird level menu. This is a dynamic menu and it only does Code:
View Replies View RelatedI am creating a search page and need help writing the code to build the sql
string.
I have 3 fields on the main page which a user can choose to enter search
terms in any of the 3 fields. My question is how do I write the logic so it
only includes the fields in the search criteria where the user has entered
anything.
Fields are
Production No
Production Title
Synopsis
The user may enter any, all or some of the search teams in the fields.
On the search page I am using lots of if conditions to build my sql string
like
strSQL = "Select * from Productions where "
now after where there are lots of permutations and combination like
production no could be empty or it could be filled in and the other fields
might be empty or filled in as well.
Does someone has a simple logic to build the correct sql String?
I'm about to start building a website which has a MS SQL back-end database. The host annoyingly won't allow me to connect to the database through Enterprise Manager, so he's advised that the database be created entirely though scripts.
I'm not particuarly good with T-SQL, so is there a tool I can use to generate the scripts from a database I have built? Can Enterprise Manager output the source code to build a database once it has been built? Could I set up and test the database on a different MS SQL server, then export the entire script and contents into a SQL query which could then be run through an ASP script to build the same database on a different server?
Basically I need to create a recruitment website whereby the recruitment company can post up new jobs and create new categories. On the home page it must display all the categories in boxes with each job that relates to that particular category displayed underneath it. For example: Code:
View Replies View Relatedanyone has any program or tool or code which builds a shopping cart easily?
View Replies View RelatedI'm trying to build a details page that is reachable when a user clicks on the ID of a query that's returned multiple rows of data. The first piece of code is the querytest.asp page, and the second is the details.asp page. However, how do I get the user_id passed to the details page? Code:
View Replies View RelatedI'm interested in building a graphical timeline for a series of tasks that are stored in a SQL Server 2000 database. The tasks reside within a table. We also have a table to track the history and date of status changes. Some of the status flags are as follows:
1 - In Progress.
2 - Awaiting Info.
3 - On review server.
For each task, using ASP or ASP.Net, I would like to be able to display a graphical timeline for each task, with the status changes denoted for a given date range.
Does anyone have any ideas on the best approach for this task?
I need to build an UPDATE statement that copies the values of roughly 40 fields from a table that stores standard or default values into a table of specific contracts. There are 8 or so fields in the source table that are not in the destination table. The remaining field names are identical in both tables.
How do I create a recordset of the field names I am interested in so that I can loop through it to build my UPDATE statement?
I have spent the past several weeks building an ASP.NET 2.0 Application that has a Users.xml file where all user information is stored. I am now designing the administrator tools and want to be able to sort through the records in the XML file. Essentially, I want to be able to build this:
http://beta.asp.net/QuickStartv20/aspnet/samples/data/GridViewSorting_vb.aspx
It seems that every example i hit is a sqlserver example and there doesn't seem to be very good sorting capabilities for XML. is this true? how do i acheive the above link? I would really appreciate any code examples or code links if you know/have them.
I want to build a website who handle 3 different countries (english, german, french). The changes between the countries is the text on the website. I know that i can put the text in a database to change it dynamic. But i wonder if i can do it on another way?
View Replies View RelatedI seem to have a very good library for PHP, XML, Cold Fusion, Flash, JavaScript, and Java..but Im wanting to begin building some helpful references for ASP.net. I got one book called "Designing ASP.net Applications" from Microsoft, but it, sadly, wasnt very good for someone like me thats starting out.
Can we use this thread to possibly suggest good books on ASP.net, VB.net, C#, etc that have helped you, and perhaps others can benefit from it, as well as me?
Is it possible to build a pop up calender using dreamweaver? I have a text box where user need to type a date format. I want to a calender to display when the user double click on the text box so that the user can choose a date and then the date must be appear in the text box.
View Replies View RelatedI've been following the building an FAQ tutorial and have uploaded all my files to the server but get a message saying the page cannot be displayed when I try to access it.
Can anyone tell me what obvious mistakes I might have made? I've checked the code over and over again but the only thing I'm not sure about is the connection to the database. How do I know the path to my database?
i want to build simple chat system for fun. but i dont know where should i start. i know asp and little JS , AJAX .
i think these are enough for that kind of target. actually most important question is where should i store messages? and how can i send incoming messages to users "AT THE SAME MOMENT" . i mean how can i make continuous connection or is it possible?
i have a project for school and i have to build a shopping cart can anyone tell me how to do this thank you?
View Replies View Relatedi'm trying to build a simple re-usable function which lets me connect to a database, using whatever parameters i pass through, and which i can then call from inside other functions in my page which use the data.
e.g. this is the kind of thing i'm trying so far, but at the moment it's throwing up an "Object required: 'rs'" error. Code:
I am currently putting together an eCommerce site. I have almost everything
in place, but I am not happy with the category system for our products.
There are around 2500 products in a SQL Sever db, each assigned 1 of 300 odd
categories. Currently, I have statically built the category tree but wish to
automate this task as it is becoming increasingly difficult to manage.
I have googled plenty of info, specifically for ADO data shaping. Is this
the right route to take, especially considering each branch of the category
tree may differ in depth of categories? How exactly do other eCommerce sites
automate this task?
I would also want to be able to copy the category system that provides links
to previously selected categories i.e.
Category 1 > Sub Category 2 > Sub Category 3 > etc etc
Is this possible with the SHAPE command? Are there other methods of
performing this task?
I am particularly concerned about the database taking a major performance
hit from all of these SHAPE queries, which would be required on every
category page. Could I use a stored procedure, and how much would it improve
performance? Considering I will be hosting on a shared server, I want to
make this as efficient as possible.
what is the correct way to dynamically build a call to a function in asp? i have the name of the function i want to call in a dictionary object, this works to execute the function but the output_value variable does not get set.
functionString = d.Item("create_contract_function_name") 'set variable for
the create contract function name that was retrieved
functionString = "output_value = " & functionString & "(param1, param2)"
Execute functionString
I want to know,
. Operation Behind the Online Money Transaction.
. If Once The client paid the money,
. How is it validated..( Credit Card)
. Also how Can the Admin of the Site will get the Money from the User.
Wondering about best practices as regarding database connections and usage (MS SQL). Was building a class to contain all of the methods and suddenly wondered if this was the best way? Using a sledgehammer to crack a walnut etc.... Code:
View Replies View RelatedWhen you submit the form you can see I am trying to get the each row of the form elements into a format such that I can build multiple insert statements. Here is what I am working with:
<%
Dim x
For x = 1 to Request.Form.Count
Response.Write Request.Form.Item(x)
Next
Would I use some type of Mod operator on the value of x to determine my line breaks?
Does anyone have any code to display a dynamic dropdown menu (similar to Windows Start menu)? There seems to be a browser compatability problem with most that I've seen.
View Replies View RelatedI am trying to get the value of a dropdown box which is populated from a access database.
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("mydb.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT DISTINCT Company FROM Customers ORDER BY Company"
rs.Open sql,conn
company=request.form("company")
%>
I need to send dthe value of this dropdown to the next page which will response.write the company name. Any ideas on how to do this?
i had done coding for two dependent dynamic drop down boxes.taking code from http://forums.aspfree.com/t53159/s.html......it is working nice
but now select 2nd box and populate 3rd one.i m very confused how make a changes in code for 3rd one.if any of u
have time i can send my code for urs technicalful advise