im currently working on a login system, and its the first time i have had to use an inner join. basically i have 2 tables, an attendance table and a member table. the attendance table contains the following: Code:
View RepliesI did a function to display the tables in pages. However i got 2 problems....
Problem 1 : The next and previous "links" are directed to the same page. This same page displays the first 50 records. So yea..previous and next is the "SAME" page....
Problem 2 : The "JUMP to page" + count doesnt work...
the counter doesnt appear...
Code:
i run a classified ads site that allows people to post ads, and stores the results in a ms access database.
2 of the imput fields are: price and quantity
What i am trying to do is the following:
To add all the prices and and quantities together and be able to display the results on my site for example my database has the following:
Price | Quantity
2.00 | 300
1,50 | 1
10.00 | 10
140,00 | 7
and on the website i can display the results like so:
Current ads worth: 1681.50
I need the script to ignore letters as in the quantity field people have also added word such as packs and VE ETC so i need it to ignore letters, however in the price field some people have placed the ( , ) sign in there price so the code must recognize ( , and . )
I develop a .asp app that reads its data from an Access DB "A", and I have a desktop app with a FoxPro DB "B".
How can I insert data from a table in DB "A" to a table in DB "B". Im new to asp and I really know only the basic's, so who can guide me to a tutorial or where can I dowload an example...
I have two tables. Table1 contains the names of training classes being offered and Table2 has the names of the people who are going to attend. The code below lists the classes being offered and a links to add, remove, and view other employees that are attending that class.
I only want the remove button to appear if you have already signed up for the class. I also only want the remove button to appear if the username cookie equals the username of the person that is signed up for the class which means the employee that wants to be removed from the class has to do it. My insert code (not shown) puts the username in the cookie into the Table2.
I tried using this code to accomplish what I wanted above but it does not display the remove button if the person is signed up and trying to remove themself. Code:
if i wanna list data from 2 tables at the same time, is that possible. i have 2 tables: itemsorderd and orders, which both have OrderID.
now i want to list the 2 fields from itemsorder which are Quantity and ProductID, as well as all the fields from orders, which contains the shipping details. how can i do that in a single SQL statement ? also if i wanna delete all these datas associated with the OrderID, how can i do that ?
if there is two tables. for example
Table 1: IC No, Name
Table 2: IC, No, Address
IC No are primary keys
There will be only one user maintaining the Table 1 then another user maintaining address only in table 2. So the second user need to retrieve the data from table 1 on the IC No. how should i do it? is it using session?
I have 3 tables, product, industry and plist. product has productID and product, industry has industryID and industry, plist has productID foreign key with productID on product table and industryID foreign key with industryID on industry table.
In the plist table I am storing the productID and the industryID's that relate to that productID..
industryID productID
1 4
1 7
1 9
1 10
etc.
What I want in my ASP page is to return the actual products that each industry serves. So for the above example my script should return the products in the product table that relate to the productID's 4, 7, 9, 10, when I search it by industryID 1. I hope this is making sense. Code:
I want to create another Database using ASP, this I can do. However, what is the easiest way to copy tables from one DB to this new DB?
I dont really want to have to write the SQL to create each table and then to use a 'select into' code for table, especially as I have around 15 tables to do!
i have 2 tables;
table01:
fields are
field01,field02,field03,field04,field05
and another table
table02:
fields are
field01,field02
when someone submits the form, i want to add the infos supplied by the user to be added to these 2 tables.
field01 & field02 shall be added to tables 1 & 2;
&
field03,field04 & field05 to table01 only
i tried using this code:
myquery = "INSERT INTO table01 (field01,field02,field03,field04,field05) VALUES ('" & f1 & "','" & f2 & "','" & f3 & "','" & f4 & "','" & f5 & "')"
myquery2 = "INSERT INTO table02 (field01,field02) VALUES ('" & f1 & "','" & f2 & "')"
adocon.execute myquery,myquery2
but this one only adds to the first table.
can someone tell me how to fix the problem?
I have 3 tables (MS Access) and I would like to display the content of all three tables alphabetically on a .asp page I have no problem displaying a list from each of the individual tables, but I am stumped when I try to display a combined listing..
View Replies View RelatedI have two tables Property & Landlord. I have a form and when it is filled in and submitted the information should be sent to the two tables, but i cant seem to get my head around this problem.
View Replies View RelatedI have a fairly simple (at least in PHP) request but I can not find how do do it. I've seen things that are kindof what I want but not really. Here is what I want:
I have a ton of data in a DB. I want to pull some of that data and display it in a table. In PHP I would create a SQL query called $Result "(SELCT * FROM whatever)" and produce this code:
Is it possible to show different information on a page for different users?
For example a first year student that needs to select modules for this year compared to a second year student how would have to select different modules.
I've got an table that has event name, start date, end date. For instance:
EventID: 1
EventName: My Event
EventStartDate: 1/1/2007
EventEndDate: 1/4/2007
Right now we just display the name, start date through end date (if there's a different end date). So the above looks like:
My Event
1/1/2007 - 1/4/2007
Now instead, they want to have something like the following:
My Event 1/1/2007
My Event 1/2/2007
My Event 1/3/2007
My Event 1/4/2007
Other than trying to create some kind of math calculation based on the date, is there an easier
I would like to display the data in a table like first 50 records in a column and next 50 records in another columns.
View Replies View RelatedI have a client who is running a Windows Media Server where audio files are streamed with a ASX file. The client wants to display the most recent tracks played on a webpage.
The problem is, how can one find out what is the current track playing on Windows Media Server, so it can take the data and then insert it into a database which the webpage can just take it from there.
I'm using ASP to display data from an Access Database. My question revolves around the data and how it looks using CSS.
1) Do I have to use <p> in my access data to display paragraphs in my story.asp page? Without the <p> I just get one big chunk of data.
Which leads my to my other problem. When I do use <p> in my access data this code won't pick up my CSS class "body". I'm not sure why because I would think it would cascade.
<P class="body"> <%Response.Write (rs("newsBody"))%></P>
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:
I am trying to display a vaule from access (which is set to currency in access) as a currency (2 dp) on a web page. Here is the code: code:
Dim rsDB
Dim strSQL
Set rsDB = Server.CreateObject("ADODB.Recordset" )
strSQL = "SELECT ProductName, ProductPrice FROM Products WHERE ProductID=" & Request("ProductID" )
rsDB.Open strSQL, Application("strConn" )%>
<p><b>Product:</b> <%=rsDB("ProductName" )%></p>
<p><b>£</b><%=rsDB("ProductPrice" )%></p>
<% rsDB.Close %>
Should be easy enough, but I'm just starting out.
I have an ASP web page that displays records from SQL 2005 database. It works fine until I re-order the columns, all values of some columns disappear. I have no error or warning
I tried to change the font and font size, it doesn't effect.
Also I have an update record form, If I re-order the fields, some values disappear Code:
I am creating a dynamic website by using Dreamweaver 8 and Access as the database. I have designed the layout for the website and the database have also been completed. However, when I try to display the data on the webpage, it just won't display. I am also having some problems with the form and recordset.
View Replies View RelatedI am using MS-Access database to display top 10 records containg title and date, and with each record a text named "NEW" is also displaying.
But I want to display "NEW" only with the records which are not older than a week. Is there some way to calculate the present date with the date of each record?
I want to display data like the following:
<table>
<tr>
<td>1 to 10 records</td><td>11 to 20 records</td><td>21 to 30 records</td>
</tr>
<tr>
<td>31 to 40 records</td><td>41 to 50 records</td><td>51 to 60 records</td>
</tr>
</table>
I tried with rowcount it is displaying in a row ancontinully with if conditions also. how to do this or any example script.
I want to be able to display my recordset as follows:
a e
b f
c g
d h
Instead of :
a b
c d
e f
g h
Any links to some examples?
I thought its more space efficient of displaying the data in multiple columns (let's say 2 columns for now), instead of one loooooooooong column in a table, are there a simple script of coding that can do just that?
How about 3 columns?
I have a drop down list which pulls Names from a column called 'Name' from an SQL Server view.
In this view is another column called 'ref' and each person has their own unique ref no.
I have linked a drop down list to the Name column (so user can pick name from the list) but now after selecting a particular name, I want my page to also display the corresponding ref for that particular name underneath.
The ref can be displayed just as text on the page.
I have an ASP/SQL 7 application that rips data from SQL Views onto an ASP
page. I have a money column in a SQL table that contains money income values.
When data is input to this field it needs to be displayed as money (to 2
decimal places - 10.00 or 7.60)
However, this only seems to be occurring when the user puts in the extra 0,
and if 7.6 is entered, it is still displayed as 7.6
I need all data to be displayed as money values (and it is selected as money
in SQL), so is there any way (either in the table design, View design, or
display on the ASP page) to get the data to 2 decimal places, no matter
what?
I need to solve this as part of a class project. It is designed to simply read a SQL table and display the data in the browser. But it will only show one record based on ID at a time. So if I have multiple records with the same ID such as page.asp?ID=9734, it would show all records using that ID in the browser. Code:
View Replies View RelatedI've got an application setup that uses freightquote.com API to receive XML responses containing shipping information. A basic response example is as follows: Code:
View Replies View RelatedI'm trying to display three columns in a table row, then I want to create a new row with three columns until there are no more records to display. Unfortunately, my code only displays one column in each row: Code:
View Replies View RelatedI am calling the values from a table and displaying them in a table, no biggie, i have not used a for loop to create the Html table, rather i have created it myself using a for loop so i can specify the table values i want.
What i am calling from the table is All of the fixtures for the football games in a season but i want to put a seperator or insert a spece of some sort just to seperate the fixtures by date otherwise it just comes out in a long list of fixtures, no nice on the eyes.
here is the code from selecting the data form the table to displaying it:
I am trying to display some DateTime data from a SQL Server db using the standard recordset object...objRec("PostTime").value
It displays nothing.