I'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 RepliesI am looking to create an upload page for my website. I would like to have the user login and depending on who they log in as depends on which folder they upload to. I'd like to be able to upload multiple files, have the file size(s) show up on the form and also be able to calculate how much time it will take to upload the file.
View Replies View RelatedJust uploaded my database how to i create a simple page where i can enter customer details into my database. i would like fields like customer id, first name last name etc where the telephone number could be the primary key
I am creating my student website. I have completed with student registration parts (student enrolment form, personal details) but now my client requirement is that if any student come to my website , he/she needs to register first so if they log on next time , screen will comes up with their all details.
I tried to create login page and if they are not in database , they can register on my website. But I could not able to create in my website. There might be more users so need to have loop in my code.
Once user log in their name and password , it will search in database and if database found that record in it , that page will redirect to my website page which will comes up with perticular student information.
project details : XHTML (Front End), Java Script (Validation), ASP (Connectivity), MS ACCESS (DATABASE).
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 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'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 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 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 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 RelatedIs it possible to find, and display a pc name in an asp web page using vb.
i'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.
I'm trying to get a very simple task to work. Using the users login name
(gained from IE) I want to get their full name from AD (Win 2k and 2003 AD
domain).I'm using this ASP code on the IIS server:
usr=mid(request.ServerVariables("LOGON_USER"),8)
Set User = GetObject("WinNT://domainname/" & usr & ",user")
response.write "Name is " & User.Fullname
set usr=nothing
This code works fine when run on the server direct using wscript, but when
served by the web server I get the error:
Active Directory (0x80070005)
General access denied error
I have a working members code now where members can sign up, login to a protected page and log out. I now want to personalise each members login so when a member logs in it says welcome [username] etc and then when the use logs out it says 'thanks [username] you have logged out'. I tried to query my database but it doesnt work.
View Replies View Related