i have managed to pass over one item from a form and put it into the database, using this code:
' This writes information from the form to the customer database field (cust_name)
dim name
name =request.Form("name")
strSQL="INSERT INTO customer (cust_name) VALUES ('" & name & "');"
con.Execute strSQL
%>
how do i pass over more than one field and put them into the database, at the moment i can only pass over the name data and then store it into the cust_name field in the data base now i want to pass over address postcode , e.g and put that into the db how can i do this.
I've created a form for users to fill in, and I want to be able to write the details of each form to a text file. Each file is named username.txt (eg. JohnSmith.txt or MikeStiletti.txt)
However, when the code below is processed i get a "Path not found" error. Now these files are on a web server and i am trying to write to my C drive. It would be great if I could create these files on the same web server too by just removing the "C:Surveys" on the bolded line. Code:
I need to be able to write results from a form picklist to a file. I know I can append the output at the end of the file but is there a way to add the output to a certain place in the file. i.e Code:
I am using the following to create an SQL statement using the names and values from request.form. The loop goes through each item in request.form
The issue comes in having an additional "and" at the end of the loop and the value of x3 as not all options may be selected from the form yet the loop goes through the entire request.form list
I have to add addtional code to strip off the last "and" and was wondering if there is a way to eliminate the additional code needed for stripping the "and".
Is there a way to determine which is the very last request.form.item(i) that has a .key value and use that as x3? I would imagine I would not need the additional code if there is a way to determine this. Code:
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.
how I can repeat details in a ASP page. For example I have to fill in a a form which has the following quetion.Language : (a text box here to fill in the details)
and then a message with 2 buttons Do you want to insert another? YES NOWhen click on the button YES, I want my asp page to take the quetion "Language :" and the text box and copy it so the user can insert another value.How can I do it ??
Is there a way of detecting and then recording a visitors details(eg. browser, ip, country, OS...) and then storing that info to a database automatically?If, so, could you plz tell me how to record the info straight to a database without the user having to click on anything.
I have seen an example of a page that displays the users browser details in a friendly manner like this:
Your operating system : Microsoft Windows NT Your browser : Microsoft Internet Explorer 6.0
from a HTTP_User_Agent string like this: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Can somebody give me some sample code of how I can extract this result out of the string, using asp.
I have a list of requests that I'm displaying. The client wants to be able to display the details of the FIRST request as the page loads.
Right now, as I loop through the recordset, I'm checking the querystring for "rid", and if rid = "" then I do a response.redirect to the page adding the rid value to the querystring from the recordset.
I'm thinking this is not very effecient, but I can't figure out anything better.. anyone have a good solution to show the details of the first item on the list?
I 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.
Is it possible to run an asp script to display the details (i.e. last modifed time/date) of several files held on the client and or on the server running IIS (if i map it to the folder with the files in question).
im trying to work out basicly what i want to do his have a list of downloads and then at the top of the page have a form that has contact details that enables the download links and sends the details to an email address. is this possible and if so are there any scripts avaliable
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:
The code below takes the script name of a page (which is always an asp file) and substitutes the asp extension with html and then inserts the file in the <frame> tag.
This code works file for a url such as www.somesite.com/file.asp But if the url includes an index eg www.somesite.com/file.asp#position1 how do I get the #position1 added to the file name that is used in the <frame> tag? Is there a server variable for # info? Code:
I have a button which runs and submits a form and if the name and contact details aren't filled out yet all it does is recalculate some totals.
BUT, my problem is that there is a checkbox in this form that is being cleared when the form is submitted at this stage, is there anyway to stop this??
I am of the understanding that the checkbox has to be in the form because when it is selected it adds a value to a field further down in the form.
There is also another text field that I need retained as well???
Just 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
Im trying to make a client area on my website and an not sure on how to go about editing clients details.When the client logs in they are brought to a menu where they can update there record. How can i get the appropriate record from the database so they can update there details?
I badly need help head sore from banging it off the wall. I have a Gridview which when a field is clicked on displays more details for that record in detailsview. I am using a single SQL table with fields for details and 3 image file locations.
I need to create a slideshow in detailsview to show these 3 images. I have no problem displying 1 image but don't know how to add a link to flick between images.
I am trying to develop a shopping cart using a dictionary object to represent the shopping basket. I have a products page which displays all the products for the user to click on to add products to the basket. This works fine.
The problem I am having is when I want to display the content of the shopping cart. The dictionary object can only contain the product id / quantity, so I have written a function which uses the product ID to retrieve the product details from the database.
Whilst I can output the values in the function which retrieves the data from table into the array, I can't output the values in the procedure which receives the array. Code:
I have a feedback form which asks someone to enter their personal details and then submits them to db. There are input, checkboxes and selection boxes on form.
Now I want to allow user to edit this form. When user clicks 'edit', I retrieve all the values from db and populate the text boxes.
What happens with the options and checkboxes. How can I get these to reflect what their values in db? Also I have some drop downs allowing user to select date of birth ie. day drop down, month drop down and year drop down. How do I show user the details we have for them if I'm using drop downs?
I am looking into creating a intranet at work which will do a number of things including forums etc but one thing that i would like to do i dont know if it is possible or not.
When a user signs into their workstation it will launch the intranet, no problem, then i want it to log them in as the user id they logged into the workstation as. Is there any way of getting this information???
I have a database which inputs usernames, passwords, and email addresses into the database. I'm trying to create an asp page that lists the data for a specific user when they are logged in so that they can change details (password, email address etc) any ideas how i can retrieve the data and append the new data to the database???
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).
I have a form which only authenticated users can access (Basic Auth against an ADS domain). Currently, I use Request.ServerVariables("LOGON_USER") to display the login name of the user. This information is both displayed and submitted as apart of the form in a hidden field.
What I would like to do is to poupulate the form with user details from an LDAP directory (ADS at this stage, but quite possibly changing to CA eTrust) such as Name, Email Address, and contact numbers. Does anyone know of any resources which might outline how to acheive this, preferably with any code samples to acheive this?
I am trying to run and UPDATE, INSERT and DELETE SQL statements to update append and delete data from some tables in access. Here is the low down:
I want to update All of the fields from a table called TEMP into a table called POSTPONED, WHERE the 'postponed' fields = "False"
I want to then go on and clear the records from TEMP that have the field postponed = "false"
And finally i want to again append the remaining data in the TEMP folder into a table called RESULTS.
Does any one know how to do this or what the SQL statements should look like, i have tried writting them, no luck, i have tried generating them in Access but no luck because the ASP is erroring me on them and i dont know what its chatting about!
I have a folder that is protected, the users login with their unique username and password, these are held in a text file.
Is this information logged in a way that I can use the login name as a variable for use on my page, such as if I login as Jon the page can display "Logged in: Jon"
I know how to build forms with ASP and process user input. Now i want to take credit card payments via a form. i will then download the details and process them via our credit card machine.
do i just create a regular ASP form and use a certificate on the server to encrypt the data ? ie https://server/getpaymentform.asp
there is nothing special about the form is there? it is just the same as the form i have been using for user input.
I have a strSQL line.. that basically does a SELECT * from many joined tables. The output is displayed into a table. What I'd like to do is, to have each table's field entries (say a Name field) displayed as a URL.
Clicking this URL will spawn an external viewer, which will open a predefined MS Word template. ASP code should then do a few SELECT statements, parse them, and write them to certain areas of the MS-Word document.
Practically, a user should be able to click on a name, and have MS-Word launch, filling in details on the Word document, such as Name, Address, ZipCode and so on, which are stored in SQL-Server 2k. how I can get this to work?
