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
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.
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.
I am currently attempting to convert from PHP to ASP and I am having some difficulties.
Foremost, from my PHP page I have pages that reference HTML source code from a remote page, write it to a local page and then displays it. I haven't been able to find any way to display this HTML source anywhere.
I tried using the following statements to transfer to html and asp page but i could not
response.redirect("&results('Url')&")
or
Server.Transfer(results("Url"))
pls tell me how can i transfer to html and asp page that i get its url from database...
i got an error saying file not found 404 when redirect to html page
and i ensure that the file is found in the same directory and in the database :
response.redirect results("Url")
where Url is the column name in the database that contain the page name.
what I want to make actually is to take the results of a search engine that I use, which are in form of HTML or ASP and transport that results in a DataBase. For example, I wont to place as registrations in the DataBase the equivalents URLs and their descriptions from the results of search. I use MS Access, code asp, HTML , Javascript .
QUESTION! How can I insert the content from an HTML or ASP page into a dataBase? How can I determine from what point to what point a string it will be entered in the first cell of table and afterwards in the next and next ....
OK - I have a shopping basket with data in a database. Once the person
has successfully completed their order I want to be able to send them
an email with the products ordered roughly in the following format:
Product Price Quantity
prod1 £6.99 1
prod2 £5.99 2
Postage £0.50
Total whatever..I'm
lazy
Formatting would be a little different (just spacing out the prod
table a little more.
Any ideas or links to scripts that do this?. I've been looking for a
while now but have had no luck in finding a solution. I just want to
send a text email (and not html).
The other thing is that on the last page but one, this shopping basket
is displayed. Is there anyway I could capture the html data from that
page, store it in a session variable and then generate the email after
the order has been completed (so sort of like sending a mirror of that
page)? In that case having a HTML formatted email would be ok.
My client has various Access databases that they want to be able to access (using MS Access, not through ASP pages). I thought I'd be able to create the link from an HTML page but when I do that and click the link, the file is downloaded to the local temp folder. I want the database to open directly from the web server, and then changes must be saved.
View Replies View RelatedI'm doing a content management system, whereby the user can enter the HTML code for a currency symbol, eg £ for £.y . when I bring this data backup, say they want to edit the settings, then my ASP/HTML page is rendering the HTML code, eg £, rather than showing the original value, eg £.
If for example I put a space between the '&' and the 'pound;', eg & pound; then this will cause me problems because the user will think that they have to a put a space in or they file it with the space, which means the HTML code won't work any more. Is there a way round this?
I need to grab product info including images from specified websites with no RSS or common structure.
I've been searching and reading articles for 2 days and have played around with grabbing html from a site and trying to find out what to do with it at that point. I think I need to parse it for the patterns I'm looking for, (creating an array out of them?) and save that information to my DB. I also want to grab the actual images and display them from my site so that the product suppliers bandwidth is not used by the pics being on my site...
I'm thinking, with my current skills which are limited, I'll be doing this with ASP (vbscript) and javascript (if necessary). I'm not great with those but good enough to figure stuff out eventually.
Can you tell me if you think I'm on the right track and recommend any learning resources specific to the skills needed to accomplish this?
If it's not too much to ask, a bit of pseudocode might keep me on the right track... what to do and when.
I have two folders in inetpub/wwroot. One has all HTML code, the other has
HTML & ASP pages. The pure HTML files show up in IE6 just fine. The other
pages just say done with a blank page. I had servral files that were ASP
pages but only had HMTL code and changed the extension to HMTL and still get
blank pages. Not sure why these pages do not display but the other directory
does.
Both folders have the same rights configuration (scripts &
executables). I am using IIS 5.1 on XP SP2 machine and I Have all updates
installed. If I open these sites in FrontPage they both work fine. I guess
FrontPage handles the code itself and does not use IIS. I am tryint to
relearn my ASP & HTML and I need to get this working,
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 RelatedI 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 , ???
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:
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%>
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:
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 RelatedI have a table having 3 columns. There is a checkbox for each line. I
need to get those lines whose checkboxes are checked, and show those
lines to another webpage. Is there any way to do that? My concern is
that all information in the table are in <tb></tb> pairs without any
name tag. Any idea?
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.
The code sends an automatic email, but the email is html format. At the top of the email i want to include an image.
Everything is working except the image is not being included, instead a box with a X appears.
Here is the code that i am currently using
Dim htmlMess ' THIS STORES THE HTML CODE
PHP Code:
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 RelatedIm 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?
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.
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 RelatedExcept 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.
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 ?
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:
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:
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 RelatedI 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
%>
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 RelatedI 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: