Displaying Database Info On Asp Page
I can display information to a webpage from a database and handle the connections etc. My next task is a bit more complicated for myelf. Id like to have a page the pulls information from a record set and displays like this.
down one side
the container numbers
along the top
the products in the containers
the information in the middle would be the amount of product that came on that container.
Im just wondering how the best way to setup my database would be, and the best way to setup the asp webpage. (oh) nearly forgot, it has to repeat the information till all the records are finished but i guess that gos without saying.
View Replies
ADVERTISEMENT
if I have a list of book names and prices and I just want the info to be called onto an HTML page to be displayed how would I do that?
It sounds easy...but who knows with code? :P
I havent' set up the database yet but i suspect it will just be called books.mdb and the table will be called Books.
Fields in the table will be
Name, Type, Condition, Price
View Replies
View Related
I have a database on my server that houses information regarding trouble tickets. I know how to write asp page to take the inputted info from a form and put it in the database but what I would like to know if someone could show me or point me in the direction of a good tutorial that shows me how to list all the content in my database on a web page.
For instance I would have a page titled, view all tickets, then on that page would be a listing of all the tickets and their information with buttons to add, delete or update ticket.
View Replies
View Related
I am trying to learn how to retrieve information from the database. I am not too familiar with ASP but I was told to use it. How do I go about doing this? What specific aspect of ASP do I need to learn?
View Replies
View Related
I have made a registration form for adding my friends information in a
database. The problem is that I want to connect the persons with companies
in the same database. I wonder how i could connect a person to several other
id's in a table.
I wonder if I can make a string in the database that holds all the id's
separated with , for example....?
the string would then look like this:
1,4,6,22,56
for example...
But how can I then open this string and separate the numbers from the , ???
View Replies
View Related
I have a form that when the user inserts the password data it is supposed to update the member info in the database with the password but instead it just adds a new row with the password and leaves the id requiring the password blank. SO it does add to the database but just not in the correct row.
Here is the code that I have:
View Replies
View Related
i have been trying to get info from a form into a database on the server for months, i have one form page and one asp page that should send the data to the database on server heres is my code for both pages. here is the form page:
<form action="deantest.asp" method="POST">
<input type="text" name= "name" ><BR>
<input type="Submit" value="Submit">
</form>
and here is the asp page with the code that i use to put the form data into the data base.
<%dim strformfieldvalues
strformfieldvalues =request.Form("name")
response.Write ("your name is ") & strformfieldvalues%>
View Replies
View Related
Im getting this error message:
Microsoft JET Database Engineerror '80040e07'Data type mismatch in criteria expression.
Im passing a ID value to a pop up window attached to a variable named 'cat'.
Its passing it across fine, but the following code doesnt seem to be working in relation to it:
strsql = "SELECT cat_ID, art_Artist, art_Title, art_FDescription, art_Price, art_PicFull " &_
"FROM eventDisplay WHERE cat_ID='" & cat & "' "
can anybody see what im doing wrong here?
The following code:
View Replies
View Related
I'm trying to update a database from a form, but only by updating the info that was changed on the form (if that makes sense.) Basically, the problem I am having it that the if statements I have setup to build the sql isn't working when the database doesn't have any info in that field. Code:
View Replies
View Related
I am working on a users system for my site. I have the databases and most of the pages set up. But, I need to create a page called "My Info". This page would display only the information of the person that is logged in.
I am curious as to how I would retrieve only one entry in an access database and display it based on the person logged in.
View Replies
View Related
I have a table in an Access database that is called news. Inside that table is a field name called newsNews. I'm trying to get that is in that field to display on a page and her is my code:
View Replies
View Related
Im doing a login page for my website, and it seems i have to do this:
'Database connection info and driver
strCon = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=letmein; DBQ=" & Server.MapPath(strAccessDB)
What the hell is that? Do I just put the physical path of my DB in there?
View Replies
View Related
I want to build a page having a list of products with their individual price, order qty, and total price.
What I would really like is that when a user enters the order qty and tabs out, that the total price is updated instantly. How would I go about doing this?
When the user has finished all his order, then he would press the submit button and not before.
View Replies
View Related
How can I get contents of a web form transferred to an ASP page. i.e. the form variables? I tried using Server.Transfer with the preserve form parameter set to true, but this created some wierd .NET framework error.
View Replies
View Related
Except for extremely basic ASP programming that I did two years ago and have forgotten I have not touched coding since!
I've taken a look at a couple of tutorials but they all baffle me!
Can anyone tell me how I can just create a simple html form with input fields of FirstName, LastName, Email and Phone amd when the user hits submit it is recorded in an access database?
I can do the HTML part fine. And I believe I've set up access ok although Ive never used it before.
Also, if the server that the database will go on is a Microsoft one i suspect that is ok? Im not sure if all i have to do is upload the database and it will work? or do i need to talk to my hosting company to set up some kind of odbc thing that ive heard about?
My database will just be called clients.mdb and the table is called Customers.
View Replies
View Related
Code:
while (!MyQuery.EOF){
Response.Write("<tr><td colspan='2' class='results'>" + MyQuery('Title') + "</td>");
Response.Write("<td align='right' class='results'>£ " + MyQuery('Price') + "</td></tr>");
MyQuery.MoveNext();
}
I have that returning a record set to display ! I then need to make it so the "Title" is a link to a page with all the information shown for that book! How would i go about doing this ?
View Replies
View Related
I have two forms, one on each page. The user fills the first, then the second, then on the third page all the information is displayed for the user to make sure thats what they want to send.
Then they click submit on the third page and it goes through a database and depending on which category, state and county the user selected it will email all the information displayed on that third page to all the emails in the Email field in the database.
Now, I already have the first and second pages(easy enough) and the third page I can get it to display all the info how I want it and now I need to know how to go about emailing that info to the emails that match the specific fields? Right now all I have it doing on the third page, instead of submitting it for emailing, it just displays the info from the forms AND emails that match from the database. Code:
View Replies
View Related
I have a SelectBoxes.asp page that is working with multiple selection
dropdown boxes to extract data and total the selection prices.
Tom & Bob were kind enough to give me a big help getting this page
working and it's working just fine, no problems with this page.
However I then would like this data e-mailed using jmail (my host insists
on this method) and that is the function of the sendEMail2.asp page.
This is failing and only giving me a HTTP 500 - Internal server error and
I'm at a loss as to what's wrong. Code:
View Replies
View Related
i am new to asp and web designing, and was wondering how to reload a page so that a different set of images appear, depending on which submit button is pressed. Code:
View Replies
View Related
I need to know how to display a new post above an old one:
here is my script to display the database (news):
Code:
<%@ Language=VBScript %>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("database/news.mdb")
Conn.Open
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open "SELECT * from news", Conn, 1,3
do while not rs.EOF
Response.Write rs("name") & " " & rs("when") & "<br>" & rs("news") & "<p>"
rs.MoveNext
loop
set Rs = nothing
set Conn = nothing
%>
View Replies
View Related
I have a set of code for displaying information from the database. However now i can only view text with no pics... what can i add in order to see pics together with the text and what data type should i put for the pics in the database? Code:
View Replies
View Related
I am building a website where users can place advertisements with images. I have decided to place the images in an Access database to ensure the right images are matched the correct advertisements. My problem is that I can retrieve all of the data from the table which holds the photos (eg, filename, file size, content type) except for the actual photo itself. When I try to download the photo or press the hyperlink to display the photo all I get is the square with the red cross. I do not get any error messages.
Does anyone know why this is happening. My code is below:
View Replies
View Related
I am trying to display images on a results page which have been saved in a Access database as BLOBS. I also trying to resize the images at the same time so that each record on the results page has the same dimensions. I have 2 include files on the webpage to resize the images, a processing ASP page to download the images and the syntax to make it all work.
My problem is that I am new at ASP programming and having the problem of putting all of the pieces together. I keep on getting an error message on 1 particular line and have no idea on how to fix it after many hours of trying different ideas. Code:
View Replies
View Related
I have a page that allows users to sign on and then have access to the site. What I need to do is to have them sign on and see selected (tables) or data that is in the database.
I need some help. How would this be written. Unfortunalely the only book I have on the subject is asp.net. Code:
View Replies
View Related
I have just recently use record paging, i now have a problem the way the records are displayed.
I have a table header with each header name of records to be displayed, and each individual record should be displayed directly underneath each other PHP Code:
View Replies
View Related
I am using MS Sql server and asp pages together.The problem I am getting is not knowing what data type to best set my data to.There is a part # set to nvarchar which seems to work great.
THen an Inductance, currently set as float. My inductance values show as 1.5 and 5, 3, 3.2, etc etc, however I need it to show 5.00 and 3.00, 3.20 etc.the inductance is measured in mH and another column called DCR is measured in Ù. Is there anyway to get this symbol to show in my table on my asp page? or do I need to enter the symbol into the database table?
View Replies
View Related
I am trying to display all the records in my database when I click a button that I made. Can anyone show me how to do that? Right now I have no code for this. I just want a button on my page, so that someone can print out a list of all the records in my database and have it for reference.
View Replies
View Related
i would like to store images in a database so that when a link is clicked on a html page a new page opens with the image taken from the database. I have heard that you should only store the image path name in the database. how i would do this and then display the image on a HTML page.
View Replies
View Related
I am displaying a table that contains 36 columns and 20-40000 rows.The first row is a header.When i scroll the page down the header disappears(anyways this is a fact).Is there any way in which i can keep the header/first row constant when i scroll the page downwards or sideways for n number of records? I am using Access as the Backend and the front scripting is by ASP and connecting thru ADO.
View Replies
View Related
Following is a function on button click event to display the details of an user.if i include this function page is not displaying.can u tell me where the mistake is? Code:
View Replies
View Related
I have IIS 5.0 configured in win2k server. When I browse a html I have no problem. But when I browse an asp page, the browser is hanging around.
View Replies
View Related
I am trying to create an XML file but i want to create an ASP page that will eventually save the XML file to the site, but to get the formatting of the file correct first, i want the ASP page to display the XML in the browser window. as an example: Code:
Response.write "<graph caption='Feburary Track Listend To' xAxisName='Date' yAxisName='Total Tracks Listened Too' showNames='1' decimalPrecision='0' formatNumberScale='0'>"
as i have it i can see the line if i view source but its not displaying on the actual page. Once i have the format of the file correct i will need to save it to the disk on the web server but for now i just need to see what will be saved.
View Replies
View Related
I have an XML file, which is a phone list of staff for the firm i work with. I need to display this in an ASP page. Is there a code which will do this? As it will be live and update as the XML file is updated.
View Replies
View Related