i need to pull the following info from my database and display it from the most to the least. User can choose between lets say 10 options. Now i want to generate a page which displays the order for the option most chosen to the option least chosen. Does that make any sense?
View RepliesI have a simple asp script to record user email address entries in a access database.
the script makes record as followed
Set con = Server.CreateObject("ADODB.Connection")
con.Open data_source
con.Execute sql_insert
con.Close
Set con = Nothing
Response.Write "Your email address was successfully added to our database"
The problem here is it repeat the same address. how can I report to the user if the entry is alread entered.
I am trying to setup a form in Dreamweaver where I have a list box (Car Batteries, Antifreeze, Paint, etc.)
How do I setup the page up so that when an item is selected and they hit the submit button it will send them to another page returns just the information from that item on the database and not the entire database?
It all seems to work well, but takes a large amount of time for the entire page to load, I guess due to the amount of records that get displayed, or maybe its the repeat region. So, Is there anything I can do in my asp code to speed these things up. Code:
View Replies View RelatedI am trying to search for clients contained within a database using multiple search criteria that the user is able to select using a front end form.
The user is able to select there criteria by selecting one or more check boxes and the results are thus retrieved based on what the user has selected. The search works fine until you try and select multiple client types Code:
I have a database page with a table. I am using ASP and MSSQL on a Windows 2003 machine.
When I get the database information displayed in the table, I have something like the following:
<table>
<tr><td>row1</td><td>row1</td><td>row1</td<td>row1</td>
</tr>
</table>
The table has a total of 167 row that would be divided into five categories.
How can i get the above table to show:
<tr><td>row1</td><td>row2</td><td>row3</td><td>row4</td></tr>
Can anyone tell me how to link from ASP to Crystal Report like to create a report in CR when a user key in some requirement to pull out data from database(SQL Server)
I dont ASP, but I need to get the report.asp in this code top open in new window with the results desired. It works fine the way it is, but I just want the report to open in a new window. I would appreciate any help possible.
case "five"
OD=Request("OD")
pwt=request("pwt")
pg=request("pg")
cwt=request("cwt")
cpg=request("cboCPG")
strSQL="Select * from Query1 where PipeOD="& OD &" and tblpipe.wall_thickness = "& pwt &" and tblpipe.pipe_grade = '"& pg &"' and tblconnectors.wall_thickness = "& cwt &" and tblconnectors.pipe_grade = '"& cpg &"'"
response.redirect("report.asp?myquery="& strSQL &"")
I'm new to ASP & wish to use it to create SQL report based on the following query:
SELECT DISTINCTROW Users.LastName, Users.FirstName, Users.JobTitle, Courses.CourseName, Status.Status, Status.Date FROM Users INNER JOIN (Courses INNER JOIN Status ON Courses.CourseID = Status.CourseID) ON Users.LoginName = Status.LoginName WHERE (((Status.Option)="Required")) ORDER BY Users.LastName;
Do I need to break up the SQL query per row and write out the report? I was thinking I could create this query, retrieve the information & create an SQL report.
However, my SQL is very rusty so I don't remember how to make the command (the only nice thing about GUI interfaces, the client thinks I know how to make the report as I can print it from the db.).
I have made some reports with asp codes. the reports are working correctly. but I want to set the margins, header & footer dynamically using asp codes. is there anyway to do it?
when I print the report, I don't want the header & footer to be printed out. I know that we can set this by going to the printer settings...but then this application will be installed in our server and we can't expect every staff to change them when they want to print.
i'm trying to add the data of such client, some of his data have been added already but if i'm going to add or update his data (additional info.) what happened is the data is being added into new row not on the specific client. Code:
View Replies View RelatedI would like to email detailed error information from my website when an
error occurs.
I tried to use "On Error Resume Next" and if an error occurs check the Err
object and the AspError object returned by Server.GetLastError(), but I
didn't get the same amount of details as I can see on the browser's window
if I don't set "On Error Resume Next".
Is there a way to get detailed information from IIS ?
I'm have a page which requires considerable database processing before writing the results to the page. I therefore wish to have a "Please wait message" up on the screen whilst the main page is processed.
I've tried Response.redirect hoping that the previous page will stay until all processing on th main page is complete and id drawn but this is not the case.
When I submit information i post it to a page and when it’s reloaded it runs as code accordingly if I refresh it re runs the asp because the information is still posted. How do I clear the posted information? Or possibly after it runs the asp code alter a value in the posted information.
View Replies View RelatedI would like to have my application send a 'request' to an ASP page on my server. something like:-
http://www.mydomain.com/registration.asp?name="Fred"&age="25"
The browser then displays the full URL including the
parameters: name="Fred" and age="25"
Is there any way I can send the parameters without them appearing in the URL.
how can i retrieve information on a form page that once previously submitted by the user so that when the user goes back to that form page it will remember what they inputted instead of having them to retype it again? do i have to use session? can somebody please help me... what would be the easiest and most efficient for a newbie to tackle this problem?
View Replies View RelatedI have an update page, when user changes their info. Click update button then go to the update.asp:Code:
LastName= Request.Form("LastName")
Conn.Execute "Update UserInfo SET UserID='" & UserID & "'
'Send an email to confirm…
'Thanks for updating your information
If I refresh the page, it keep sending email. How can we prevent sending email if he/she keep refreshing the page (do not want to disable the refresh button).
I've an ASP page in wich the customer write his card number for the payment. How can I make this information secure when it's sent to the server?
View Replies View RelatedI have a login page, which is not in SSL. However, the script that processes this information is. While that information passes to the login page to the page that processes this information, is this information encrypted?
View Replies View RelatedI'm trying to make a web site that get user hardware information (processor's id and motherboard's id, one of them at least).there's been already one week and nothing yet.I have 2 servers:
windows 2003 server
windows XP professional
both have wmi and iis
I am looking for tutorial and/or help on regards to accessing information using SOAP using ASP. I'm proficient in ASP, but know ver little about SOAP and XML.
View Replies View Relatedhow do i insert two bits of information (email and emailend) into the one database field "email"?
Code:
SQL = "Insert INTO users (uid,pwd,firstname,lastname,email) Values ('" & uid & "','" & pwd & "','" & firstname & "','" &
lastname & "','" & email & "')"
how can you do that?
I use ASP to check users data they submit. In particular, I'm checking for credit cards and I also use a server component DynuCreditCard. It basically affirms that the number "could be" a real credit card number.
Anyway, I cannot get through the website without having a legit CC#. None of the handful of testers that help cannot get through without a legit CC#. About once a month some user gets through with a blank credit card field. How do you troubleshoot something like that? I can't replicate the problem. Do you just say... "oh well... there was a computer glitch"...? How can I approach this problem?
If i have a combo box, automatically when the user changes the item, i want to display information from the database within a textbox, without having to go to the next page.
Currently i only know how to do this by going onto another page.
In VB it was a simple case of calling a procedure, how does it work in ASP? If i need to call a procedure, how would i do this in ASP. The example in w3schools passes the variables, can i do it without it?
How do i search for user based on specific fields? I have a checkbox beside each field of Name, User ID, Email. There's a textbox beside each field for the user to fill up. How it suppose to work is the user would fill up the textboxes and check the appropriate fields to search on.
It can have a combination of searches like he can search on the name and the user ID or all 3 fields. I was thinking is it possible to store the textbox information into the checkbox of that field and retireve the information?
I have a table that contains information that I need to export to a .csv file without manually saving the file, e.g click a button, information is passed and saved. I have no problem geting the information from the table, just exporting it into a .csv and then saving.
View Replies View RelatedI am working on a project involving pulling information from Active Directory (Name, email address, contact no.) and sticking this information in some SQL tables. Using ASP, How do I enable windows authentication (username and password from active directory) ?.
In other words, when the incharge user wants to login to the tables on the web, he must use his/her windows username and password ? On the same project, I want to assign different groups with different security levels. (something similar to the Active Directory security groups), and let the admin asign rights to each group in order to control access and privilege of each user within a group.
how to store information after the ? in the url in form fields. i.e. http://url/test.asp?User=Rob in Form Field UserName .
View Replies View Relatedhow the information boxes pop up when you mouse over a link? For instance in this forum, when you mouse over the Title of the thread, an information box pops up with the entire message. I assume that is Javascript, but does anyone know where I can find more information on this?
View Replies View RelatedThere is a web page (asp.net) that shows some information on a table, we need to collect these information from this web page every 6 hours and save it to a SQL data base and prepare it for further analyzes.
how can I collect the data from this web page automatically.
i'm starting at ASP now and I'm searching some information about it. For example, I need to know all about Application object. Some oficial documentation where I can find it?
View Replies View RelatedEarlier this week i asked a question about using SQL to select information from a database as part of a sign up script that checks to see if a clients chosen login name has already been taken.
now Im attempting to do the login page for the site. The login scripts are made of two pages - the actual login.asp page, which contains a very simple form, and the dologin.asp page, which checks the information they enter with the information in the database.
This section of code is designed to check whether or not the login name they have entered is even in the database at the moment, and will later check things like passwords.... The script on the dologin.asp page is as follows: Code:
i am so sorry because asking this problem. u have read thru several solutions within this forum and i think i still a clear explanation regarding my problem. it works like this, a customer could view his/her reservation after entering his/her reservation ID.
a complete detail will appear in a HTML table. this table is located in a form tag because it allows customer to update the information. besides, customer also allowed to print the reservation detail by clicking the print button. my question is how to export all the information to ms word? i stucked because this page also allow customer to make changes. what i am thinking is to use 2 form tags but both have different action/process.