Display Data From Different Table
If i created three different type of table. Inside these tables, they might have the same key field's name. Example:
Table A - ExecNo, Month, Year, CustCode
Table B - ExecNo, Month Year, DestCode
as u can see that these two tables have almost the same key field but they r actually keeping different data. how can i list these different data out in an asp page? it is because i am having the problem whereby.
where the table want to display data from table B, it actually misplace by table A . how can i write the sql function to differentiate both of them.
View Replies
ADVERTISEMENT
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
View Replies
View Related
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies
View Related
I'm trying to display records from a table in a sql database.The problem is, every month a new table is created, so I don't know what the name of that table is going to be.
It there a way that I can make sure the sql only reads from the latest created table?
View Replies
View Related
i want to convert my txt file into a html table for display . But i dun want it to go through db .
View Replies
View Related
I'm sure it sounds kinda nutty to display 200 columns and
500,000 rows of data. But I have been pulling data from a
Lotus Notes database into Sql Server for a while now, but
Lotus Notes is starting to crack, columns getting
corrupted. Can't handle the volume of data and number of
columns. Sql Server has no problem. But displaying the
data is the big deal. The end users want to be able to
scroll acros a page to the colum of their choice, or be
able to scroll up or down.
I was thinking of breaking up
the table into section, but this would reqire additional
clicking to get to the next section of the table. Would
it be feasable to have a 200 column table in asp? or
should I stick with the section idea? I have to tell my
dept something. They started out with Lotus Notes but
couldn't query the data. I have been suggesting to
migrate the project entirely to Sql Server/IIS. Notes can
at least display all the columns.
View Replies
View Related
When a selection is made from a list (lstpos) - single selection allowed, (for example a user selecting engineer), it retrieves all the duties (it may b a duty i.e. 1 record OR many duties i.e. more than 1 record) an engineer performs (each one on a different line) from a table and automatically displays text boxes next to each duty so that the user can input "scores" for each duty (rate the engineer).
How to do this?
Next this data needs to be input in a table when the user clicks a button (ADD or OK) in the format :
user duty score
user1 duty1 score1
user1 duty2 score2
user1 duty3 score3
etc...
Anyone has an idea how to do this?
View Replies
View Related
I need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a
webpage (ASP)
I can retrieve the recordset from the database and display the field data
results in rows of a table but have the entire 60 character string in one
cell. I need to break that string apart and put each semi-colon delimited
value in it's own cell. Then move to the next record and do the same thing
in the next row of the table. - and so on
I'm using ASP, VB Script with DMSII Database and OLEDB
Does anyone have some code examples on how to break this field apart and
then arrange the data into an html table on a webpage?
View Replies
View Related
how can i Count and display number of records in table?
View Replies
View Related
I'm trying to display records from an MS Access DB (*.mdb) in an ASP page (table).. I don't want to display all the records though, I just want to display the total of these records..i.e in my table I would like to show how many calls someone has closed this year..(number)
Joe Bloggs ---> 100 Closed
Is this possible? I was thinking that I need to write an ADO that includes COUNT but I'm not too sure how to write this.. Here's what I have so far: Code:
View Replies
View Related
I am trying to align this piece to the data table.Here is the code. Please take a look at the word doc2 and tell me what am I doing wrong.
<%
Do Until objRS.EOF
Response.Write("<a href='Page2.asp?tnum=" & objRS("Ticket_Number") & "'>" & objRS("Ticket_Number") & "</a><br>")
View Replies
View Related
How do i add data from table to cookie? I mean, I have an excel style table at website that is read from database via query, and what I want to do is add information, that is at the same line with the "apply" button, to a cookie for further use?
View Replies
View Related
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 Related
sql = "SELECT [R.oriAddress], [R.oriCity], [R.oriPostcode], [R.oriState], [R.oriCountry], " & _
"[R.mobileNo], [R.homeNo], [R.resDate], [R.resTime], [R.surveyDate], [R.surveyTime1], " & _
"[R.surveyTime2], [R.moveDate], [R.moveTime1], [R.moveTime2], [R.destAddress], [R.destCity], " & _
"[R.destPostcode], [R.destState], [R.destCountry], [R.resType], [R.resStatus], [R.staffCode], " & _
"[S.staffCode], [S.staffName], [C.custName], [C.custIC] " & _
"FROM (Reservation R " & _
"INNER JOIN Customer C " & _
"ON R.custCode = C.custCode) INNER JOIN Staff S " & _
"ON R.staffCode = S.staffCode " & _
"WHERE R.resCode = " & id
i used sql code above to display data in a table. basically, the flow is like this. when there is a new reservation, a staff will be assigned to handle that reservation from the beginning until the end. before this, i just display a staffCode that retrieved from Reservation table.
then, i made changes to display staffName and removed staffCode from the table (based on requirement). but, because previously, there are some reservations that have been assigned to staff, i do not have any problem to view all data in the table.
but, when i click other reservations that have not assigned to any staff, an error page came out. the default value for staffCode in the Reservation table is null. because this null value, i've got an error page. is there any steps i can use to solve it?
View Replies
View Related
I have created an empty table(.mdb) with 2 columns
Order(AutoNumber) and BuildingID(text)
and i use :
cn.execute "Insert into [Temp](BuildingID) values ("&Buildingid&") "
to insert buildingID into the table
however all buildingid start with 0 with be omitted,
eg. buildingid = "00003333" after insert into the table become "3333"
i have checked that response.write len(buildingid) = 8
What is the problems?
View Replies
View Related
Right i got the login page working, on my main page i have a big table in the middle with a few small tables either side of it, one of the smaller tables has a form where you can search a database, is it possible to have the results of the search appear in the main table? and is it difficult?
View Replies
View Related
I have a table outputting results as follows:
Time | Location 1 | Location 2 | Location 3
9-10 | Room 1 | No | No
9-10 | No | Room 2 | No
9-10 | No | No | Room 3
However I would ideally want it as
Time | Location 1 | Location 2 | Location 3
9-10 | Room 1 | Room 2 | Room 3
Any help on this would be great.
View Replies
View Related
Is it better to use the Recordset methods or make an SQL query string and use conn.Execute() if I want to add to a table? I figure the first might be safer, but it seems weird to someone who learnt on PHP... I'm using SQL Server if that matters.
View Replies
View Related
I have coded a form which enters data into a access table however I want the same recordset when clicked to go to another table in the same database then when clicked again to go to another table within that database...is this possible?
View Replies
View Related
I have a table that's holding 'open data' until it needs to be moved to another table where it is then 'closed'. I think I have my SQL statement correct to do this, but I keep getting the error below.
Quote: Originally Posted by Error Message
[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
I have verified that I have the same number of fields in each table, but I think the problem is both tables have an Autonumber field and obviously you cannot move one autonumber field overtop another one. What is the easist way to exclude my autonumber field from being inserted into my other table without having to call every single field by name in the SQL statement? Code:
View Replies
View Related
I am wanting to add three fields that adds the totals from a column. Here is my current code that writes out my data from my table: Code:
View Replies
View Related
I have a txt file and i would want to import many data fron txt and put in a table fo access...
For example
txt_var1 in table prova filed filed_var1
txt_var2 in table prova filed filed_var2
assuming my txt file is named test.txt and my mdb prova.mdb and table tabella1
View Replies
View Related
In an asp page, there is a table defined.
I need help in:
1. populating letters in the bottommost row randomly
2. On selecting any letter in the bottommost row, and pressing any column in the top rows (Row1 Col1), the letter should be displayed in the desired location (Row 1 Col1)
View Replies
View Related
Is it posible in ASP to hide a table that brings no data when you query a data base and if you have two tables that brings different information?. If it's posible, can you guys help me with this one please?. The table that I would like to hide is the one that brings no data.
View Replies
View Related
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.
View Replies
View Related
I'm involved in this localization project, and part of the process is
taking the english content out of the pages and storing them in the db
as key/value pairs (which we call tokens).
Would be any performance problem if all of the tokens were stored in
one table, for each language. Say there’s 1000 Tokens, and there’s 50
languages supported, then that would be 50000 entries. It's hard to
guess how long each string will be... Ok, that’s not very big, but
what if we were to load that up in the application scope, so it would
be easily accessible (maybe in a dictionary object for each locale).
Do you forsee any problems in that? Or does ASP offer some other
caching mechanism for this?
View Replies
View Related
there is a JavaScript/ASP function that that will check for new Private Message (PM) Inbox. New PM will be referred as "NEW" in the status field in the database and "READ" for all the old PM.hen there is a new PM, a popup will appear in my page. But I have to press the REFRESH BUTTON before I get the popup ALERT!
Can this be done in AJAX? (Alert me without refreshing the page?)
View Replies
View Related
May I know how to use the ASP to display the data from database in the format of data grid or table? If possible, please provide coding.
View Replies
View Related
I have a database for my users orders, and I what a search for the admin to search for the orders in a specific user and display them in a chart.
View Replies
View Related
I Have a list of groups that are assigned to users. I want to list groups for a particular user in order by name. I want to then have a drop down list that shows all the groups that the user is not in at the moment. Users can then add groups to that user.
How i have it setup:
I have a table that has an id and group name.
I have another table that has id, userid and groupid
Do anyone have any ideas how to diplay it. Keep in mine that the groups have to be in order of the group name. Thats tge part that is confussing me.
View Replies
View Related
I am creating a resource website and pulling from an access databse, I have 1 page that loads with a list of catagories, when you click a catagory the page reloads with a querystring attached that loads only the contents of that catagory.
All of this is coming from the same table in the database, I have an ID column that is shared by the articles in the same catagory.. (i.e. ID is set to 1 for all the items in catagory 1, set to 2 for all in catagory 2 and so on).
I currently have articles in about 6 of 16 catagories. Everything displays fine but if you click on a catagory that has no articles, I would like a message to appear such as "There are no articles found for that catagory". How can I get the ASP script to see that there are no (we will say) entries for ID 8 in the databse, and display the message.
View Replies
View Related
We're working on creating a site that tracks club sports results - we originally created a form that inserts the results into a database, but the folks using it have decided they'd rather enter the information in a spreadsheet and upload it.
what is the best practice for this data - should I write some code that just reads the content of the excel file and displays that on a results page or should I take their data and import it into the database we initially designed.
View Replies
View Related
here is an RSS feed for top stories from a local news station. http://lex18.com/Global/category.as...&clienttype=rss.I need to display this data on my own website. I know ASP, but not XML.I have read some documentation and browsed websites, but I cannot figure it out.
View Replies
View Related
