Is there any way by using ASP with MS access to retrieve a specific data from a table and when i retrieve i want to show me the data without repeating the same data or duplicating data and i want instead of this to count for each item how many row is there in a the table ....... loooool i know that most of you will tell me to re-explain what i want to say again ... ?
For example i had three rows in the table ... and those rows are the same with 4 attributes ... what i need is to retrieve those rows in the website .. but instead of showing three rows it will show me one and next to this row i want to put 3 which is the number of the rows in the table that are the same and if i have any other rows it will do the same ...
I am trying to retrieve some data from a table which is the link table from another Ms Access database of my network computer but i got a error message "It is already opened exclusively by another user, or you need permission to view its data."
I am using access database to store test results. Each test is asigned a automatic ID number in access. I have all the data collecting fine to the correct columns but had to add a new column named (comments) to the database and this column is made to store students comments on the tests. I created a new, view comments page where the students can view comments on the tests.
The problem I have is, I need to be able to bring up the info from the comment column by that asigned automatic id number thats asigned to the test. I can get it to show all comments on all tests but need to be able to view comments on each seperate test and each test has a diferent automatic id number.
How can I bring up the comments to view by the automatic number thats asigned to each diferent test? We need to view all comments that were made to each individual test by that tests automatic id number and using asp. This has got me puzzled to view comments to each individual test thats asigned with an automatic number generated by access database.
A customer reports a problem with a site that is unable to read utf-8 data from an access data base. The page only shows ? instead of text.
The parameter that turns Unicode support on/off is "on" DRIVER={Microsoft Access Driver (*.mdb)};useUnicode=yes; DBQ=C:Inetpubvhostsdomain.comhttpdocspath_to_dbname.mdb [no spaces, so that's not the problem]
Successfully tested ODBC connection -- but still can't read the data. The site has the content type set to CHARSET=utf-8.
im a bit of a rookie and i couldnt find anything using search,how can i have a statement which selects only the records which contain data. Code:
sSQL = "SELECT * FROM VIEW_COLLECTION " &_ "WHERE (BusinessID = 20) AND (Parentid = " & objRScats("CategoryID") & ") " &_"ORDER BY CollectionName"
Thats what i currently have. This is for the page navigation - and i dont want a those collections that do not have any data to be diaplyed - but i do not want to delete these records altogether just yet.
I want to create directory and set access permission to specific user.
i tried with wscript but it's not working, i used "cacls" command it's working only NTFS partition but i used to fat32 . how to set directory permission with asp script on fat32 so anyone help me?
how can i retrict user to only access the web page iif and only if they have the username and password, they neeed to login before can access the certain pages. How is the coding for that web pages?
I have two tables having similiar columns ( i had to do this to compare the values given to me, because both the table data came from different sources)
The tables named are OFFICERS token full_name division EMPLOYEE token full_name division
Now the table EMPLOYEE contains more than 5000 records and the table OFFICERS contains around 2400 records which are already present in the EMPLOYEE table.
Now I want to build a query that will return me all the records in the EMPLOYEE table that are not present in the OFFICERS table. The criteria for comparing 'full_name'. so the query should return me 2600 records that are not present in the OFFICERS TABLE.
I tried doing this " SELECT DISTINCT EMPLOYEE.full_name,EMPLOYEE.token,FROM EMPLOYEE,OFFICERS WHERE EMPLOYEE.full_name<> OFFICERS.full_name"
But this query returns me records that is not present in the OFFICERS table as well as some more 1000 records which are present in both tables. thanks a lot
I am trying to access the following site with an asp page. I am just starting out with XML URL
This is my stats page for battlefield Vietnam. I have managed to get a local verison to work if I save the source code of the page above as an xml file on my server, and I use the following code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Option Explicit %> <% Dim xmlDoc, root Dim success, player, strData, online ,rank, rp, score, kills, deaths, fttk, kdr Dim dpm, ftpm, mppr, medals, gold, silver, bronze, rounds Set xmlDoc = server.CreateObject("msxml2.DOMDocument") '
What I can't figure out is how to access the data from the external site.
This is my code can you fix it if it have an error
<select> <% set rs = Server.CreateObject("ADODB.Recordset") strSQL = "select cat from events" rs.ActiveConnection = conn rs.open strSQL if not (rs.eof or rs.bof) then for i = 0 to rs.eof response.write("<option>" + rs(i) + "</option>") next end if %> </select>
I have a question, is that any other way to retrieve data from another webpage besides using XML object? Because I am using XML object now but give me so much problems.
If I used MSXML2.ServerXMLHTTP object, it gives me time out error: msxml3.dll error '80072ee2' The operation timed out
If I used Microsoft.XMLHTTP object, it will hang IE. In both cases, I have to wait for half an hour or more in order for the XML object to be working again. Actually both webpages that's communicating are hosted at the same machine. The main site (ex. aa.domain.com) points to particular folder under it, while another one (ex. bb.domain.com) points to another folder which is two levels up to the first one.
I have problem like that. page1 is sending some variable data to page2 Now page2 have to decide whether it has to redirect it to page10,page20 or page30 basing on the value of a variable1 which is in page1 variable data. I want know how i can access variable data of page1 in page10,page20 or page30.
my problem is with a db(that i upload on server every day) which has some "static" tables in it plus a table updated every day. the website must show the date of last update of that table so i first retrieved that from the access file, but this means that every time i upload db(with that table untouched) the last update changes. i've found something about table's extend properties on the internet but i don't know if this can be useful to me.
I'm working with JMailBox app. This is an asp web based pop3 client.
The application has a inconsistency: when forwarded mail arrives, the system transforms the message into a .msg and .eml file, but this cannot be displayed on an ASP page. Some times the forwarded message contains attached files (.doc .xml .pps .pdf .html .zip etc.). These attachments are those that interest to me to recover.
Hopefully that somebody can help me to find the solution to recover the content of a .msg or .eml file, including attachments with pure ASP.
I have 4 ASP pages on my site & a DB for each page has a form pointing at its DB, I thought this would be the simplest way. You can add & submit data and you get the confirmation page, but I am seeing no data in my DB's. Each DB has a CHMOD of 777. Here's the link to what I am doing most of the test just read "SOME TEXT" Code:
my database table have 1 field is use for record the date.Please help me to program the code, so i can retrieve the data recorded from yesterday. That means everyday retrieve yesterday data automatically.
there are specific client of mine and there is a big database which i have to handle it, every time clients want to connect to this specific database it takes long time, this database is a static database it means you dont have to edit or update it by the clients, it is like a dictionary, you type your words/code and you will see some data,
I could not find a way to reduce the time for the clients(due to the big database), I am wondering that is it possible to put a copy of this database on client's computer (I have mentioned that there are specific clients and I have access to their computers) within Access Database so in this way I have to run the connection to the access database at clients side, if so what is the coding for it??
This is my query.i have a access database, hooked up to dreamweaver mx. inside the database are 3 tables. sun/moons/planets. the planets table is linked to the moons table. In the planets table are the fields: planet name; Text_1; Text_2; planetID; Distance; Pic_1; Pic_2; What i wish to do is from my index.asp page click on a link which then displays the planet and EITHER text_1 or Text_2, and seperately Pic_1 or Pic_2.
I have tried using random nos 1 or 2 but i dont know how to pull the number and access the right table/field
i want to display DATA stored in Access DB by using ASP script.i can read data from access so that task is only to display data is a list like.i have a record of some users and i just want to display the users name in a list.how can i do this.
i am working on a interanet application for Inventory handling, i have a problem while submitting the data to server, the problem goes like this
Data base : Ms-Access Front End : ASP
how to comit the data "say Invoice" to main database is two persons tries to make invoice at same time at different computers, How to maintain the series of Invoice unaffected, how to allocat Invoice number to them, and how to put a check that both of them can't make a invoice of same customer at a same time at different computers.
i am wondering if there's oledb provider for DB2? and where can i get it ? we use asp, not asp.net , therefore we can't install .NET framework , is there any other solution ?
