I have an asp contact from which gets data and generates an email containing the users contact details it also send the user a confirmation email.
I was wondering if anyone could explain in simple terms how i would send the form data to be stored in a database?
I know i would have to set up a databse conenction.
how would the form fields be sent to the database?
is there a way to capture the pagename. say I am using a form with "post" method and then use request.form to get the value
of variables from the previous form. is there a way to capture the name of the form that made the request? for e.g if the first
form is "welcome.asp" and the second form is "Hello.asp". can i capture the form name (welcome) in the second form?
Is there a script/compoenent which can capture Faxes and store that in a DB
using a unique ID?
Any help will be greatly appriciated.
Code:
<%
Dim rsDB
Dim strSQL
Dim name
Dim price
Set rsDB = Server.CreateObject("ADODB.Recordset" )
strSQL = "SELECT ProductName, ProductPrice FROM Products WHERE ProductID=" & Request("ProductID" )
rsDB.Open strSQL, Application("strConn" )
' put fields into variables
name=rsDB("ProductName" )
price=rsDB("ProductPrice" )
%>
I am trying to store some data from my database (access) into some variables so that I don't have to keep on opening up the database everytime I want to display the data. Dont know what I am doing wrong but i keep getting an internal server error 500.
I currently have a web page that pulls in job vacancies from a search form all written in asp and the database is in access. I will be placing an extra field which will say "apply now" and on selecting this you will be taken to a new page where you can fill in your details and email them to the employer.
My problem is I need to know how to get a field in the form that will automatically fill in the title of the vacancy being applied for from the database.
Basically i have a form on a HTML page which someone fills out with a few IDs, then i have a .asp file which is meant to add the info to a database.
However it just wont work, the field names in the database are correct. - i hope the if statement is correct too. Code:
I am trying to insert data from a form into a database and i am getting the following error:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
The code that i used can be seen below: Code:
I have a member registration form that when the user clicks the submit button the form info is sent to a file name validate.asp.
The file validate.asp checks all the information to see if it correct and now I would like to have the data that was submitted added to an access database named members into a table that I named reginfo (registration info) and I have tried numerous ways to do this and spent countless hours browsing through websites but cant seem to get it to work. Code:
Is anyone know how I can store Word Docs and PDF's in database, and how I can make link for visitor to download these files.
View Replies View RelatedI have a shopping cart in which I am trying to use breadcrumb style
navgiation. I need to be able to display the categroy heading relating to
the section of the site a visitor is using i.e If a user is in the "camera"
section I need to display that heading as a link "camera", however in order
to do this at the moment I am querying the database and storing the
recordset in the application object (see below). Code:
Is there a way to store a form value that can be passed across multiple
pages, other than creating a session variable for the form value?
Can an array be created to hold form values and maintained and used across
many pages? Or, other alternatives?
I've used session variables, but have understood that using many session
variables isn't good and there would be a better method to handle this?
I have an ASP form that has a field that automatically places the current date into it. It uses the function Date().
The problem I am having is when the form is submitted into my Access database the date is coming out wrong in the Access field. The datatype for the field is Date/Time but it still is not coming out right.
Example: the date in the ASP form shows as 12/19/2006 and the entry in the Access form shows 12:00:27 AM. If I change the format of the Date/Time field to Short Date, the result is: 12/30/1899.
Does anyone know how I can get the data that is posted to the Access database to come out the same as the ASP form?
i am developing an application using ASP.I have to get product picture from user and store it in to database. i am getting the file path of the picture.
How to read this image and store it in database and retrieve it back for display in another page ?
I am creating a page that will help college students to determine what schedule they should follow when choosing classes for the next semesters. I will have a database in Access that will list all the different courses they need to graduate & the info surrounding them (including what classes they need to take before they can take specific classes).
Students will fill in their current grades of classes on a form with all the classes listed & then based on what they have taken, this will provide a schedule for the remainder of their classes. I plan to use ASP, VB,& SQL to achieve this.
This is my question: It would be much easier to simply have the student's grades be placed in another table HOWEVER, due to security reasons, I cannot do that. I will need to store the grades (as well as the classes that they were for) in an array of some sorts.
Any suggestions? I was debating putting them in a database & then deleting or clearing that database upon them leaving but I do not know if that is the best solution. HelP? Code:
I am using the code below to add a date input into an access database.
Quote: rs.Addnew
rs("Date")= Request.Form("Date")
Instead of inserting a date with the format dd/mm/yy, a date format of yy/mm/dd will be inserted into the database.
I entered the following code before the insertion Quote: response.write request.form("Date") and it displayed the correct date format as dd/mm/yy.
Pls how do I insert the date into the database for it to store the date as dd/mm/yy instead of as yy/mm/dd. The date format in the date field of the database is dd/mm/yy.
How can I accomplish the following:
I want to upload image files (jpg) into a sub-directory of a website root directory using a web interface allowing the user to browse their drive and select the jpg file to upload.
Also, is there a way to parse the information from the jpg file and insert the information into a SQL database table which would hold the file name, image height, and image width?
I'm new to handling binary files, so I'm not sure how to accomplish this?
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
I have some ASP server-side code that works perfectly when the client is running on Windows (IE, Netscape, Firefox, etc.) but doesn't work at all when the client is running on Macintosh (IE, Omniweb, Safari, etc.) This is the client-side Javascript code:
View Replies View RelatedI'm having a bit of a problem trying to capture a users LAN ID from the network. Currently I have an activex component that does it for me and I use Javascript to display/capture. Which was fine prior to the DDA guidelines. Now I need to find a way to do so without using JavaScript.
The first thing I tried was to use the Servervariables available but unfortunatly our servers use annonymous authentication, so I can't use that method. I've even tried but had no joy accessing Active Directory for the LAN ID, so I'm currently left scratching my head. Does anyone know of a way I can acheive this?
I have made a asp page that accepts some data from user and stores it in MS Access database. Now I want to identify the user who filled the form and store this information in database. About the enviornment.
the server has Windows 2000 server installed. Clients have Windows XP. Server also has Exchange 2003 installed and every client has Outlook Express installed. Every user has to login to his account inorder to use a machine. A given user can login on any machine.
How can i find the identity of the user who submitted the form? Is it possible to find out the current logged in user given the IP address of the machine? If yes, how and will there be any chances of error due to delay in replication?
I run the internal reporting system of a few dozen employees. They submit many extensive reports and if they encounter a server, SQL, or parse error they have to re-enter the information, causing great frustration.
If I can save their querystring somehow, I can fix the problem and then resubmit their input myself, saving them a great amount of frustration. Ideally, I'd like to just be able to just put a function or an include at the top of every script I'm looking to save, however, in the case of a parse-error I believe the input will halt altogether.
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
I have a series a forms that submit data to different tables in a database. As it stands, when a user completes FORM 1 and clicks the SUBMIT button, the FORM 1 data is submitted (action = form2.asp, method = post) to ASP code at the top of FORM 2 (request.form("form1 field name") etc...), and submitted to the database with SQL code, also at the top of FORM 2(INSERT into...). Hence the submit button on FORM 1 directs the user to FORM 2, and submits the data which is exaclty what I wanted. However, I now need the users to submit multiple sets of data with FORM 1, and direct them to FORM 2 once they have finished using FORM 1. Most importantly, I need to pass a few parameters from FORM 1 to FORM 2, and have these parameters submitted to the database.
My main problem is getting a fresh form1 after submiting the same form1, in preparation for anoter set of data using the same form. Basically, the database has 'one to many' relationship tables. Form1 and form2 are both populating the 'many' tables, so that each form needs to be filled-in several times while retaining the key field of the 'one' table. At the moment submiting form1 takes me to form2. Is is possible to submit the data to the database, get form1 back again to submit more data, as many times as required, then click another button to load form2 when the user is finished with form1?
Can anyone please give me some pointers? or at least explain the concept of what I need to do. I am a novice and it's taking me a while to get to this stage. Any help will be greatly appreciated.
Is it possible to post FORM1 to itself and insert the data (i.e. place the request.form at the top of FORM 1) If so, how do I direct users to FORM 2 while retaining my parameters?
Can someone help me regarding Capturing Image from a Video in ASP. what I have achieved is this, I have run the video using Media Player Active-X Control and have got a button control on which I have initiated a component known as Media Processor, which saves the frame according to current position supplied in a picture format. But the problem is that it doesn't support files greater than 300 MB or so. I want to have a support of upto 2 GB files. Moreover, I have to keep in consideration the performance issues, it shouldn't get my server down. Can someone give me any idea about any component for this job, I have been able to find out only this on different locations. I have got another one that is working well in VB, but there is a problem with using in ASP. I am using Media Player just because of buffering, actually I want is kind of streaming so that the server gets minimum load. How to achieve this?
View Replies View Relatedi have an online form and i have a number of multiple checkboxes in it..which the user can select all or just one...now i dont know how to capture this date of checkboxes to send it to my email after the user hits submits.i am using CDOSYS for getting the email....
View Replies View RelatedI'm trying to design a voting page. The flow as follow:
1) there is a table filled with rows (data from db)
2) each row come with a button = "vote"
3) when user click the button "vote", db will UPDATE the value(Yes/No/etc) of the row + 1
example:
1. Yes "Button"
2. No "Button"
3. etc "Button"
Since there is three button, how can the button identify which value to UPDATE in db (when the user might just click any one of it)?
Is anyone familiar w/ using checkbox to select which person to send a certificate to. For example, owner, user, contractor contact info is displayed on the webpage and to the left of those 3 contacts I have 3 checkboxes to designate who to send the cert to by inserting that contact_id into the cert_recip_cont_ID.
Owner_contact_id
User_Contact_id
Contractor_id
I have succesfully captured the users login detail, but I now have a new problem I have assigned the login to a Session Variable, however when I come to use the string stored in the variable it excludes the which seperates the domain from the user name, it should be :DOMAINUSERNAME , but I am getting DOMAINUSERNAME which really is a pain. Anybody know why this is happening and how I can overcome it ?
View Replies View Relatedhow i can pull the logged in user name from a computer for a web form? this is what i did to pull from the cookie when user log into my site but now i want to get request from non site users but capture non logged in users ids too.
~ <input type="text" name="EmailID" maxlength="10" size="10"
Value="<%=Request.Cookies("NPSC")("UserName")%>"
~
I have a form that I use to submit feedback to a database. The form can be called from any number of pages and I track the page that has opened the form using the server variable, HTTP_REFERER.
A user does have the option of submitting multiple feedback messages by filling out the form multiple times and clicking submit for each (there are different categories that can be chosen on the form itself that make this obvious).
The problem is that on submissions after the first, HTTP_REFERER no longer refers to the original opener but to the feedback page (since the user returns to the feedback page) . How can I capture and keep the original HTTP_REFERER? Code:
I need to develop a web application in asp.net which can detect a USB device and capture its
events...
For example when a person access the web page and connects the device to his machine he shld be
able to detect the device and shld be able to read or write into it.
I wrote a java program using jusb and called that in an applet..though it worked it needed lot
of client side configurations.
My requirement is that there should not be any configurations in client side and things shld
work smoothly.
I know some one had done this in asp and javascript. but i don't know how its done.
I would like to capture window close event, i.e. when user clicks "X" button of the browser, I would like to close all open dataabse connections.
Also, I would like this to apply when a user tries to close browser using File > Exit or when the user tries to type another website URL in the browser.