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:
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>
how to retrieve a data that has been selected using combo box with asp
View Replies View RelatedHow can I retrieve data from Ms Access Database which is located in another computer over the network.
View Replies View RelatedI 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 am trying to get informaton off the URL to display in dropdown menu with asp. not from xml file but data from a URL.
View Replies View RelatedI 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.
View Replies View RelatedI'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.
How can I retrieve data from Ms Access Database which is located in another computer over the network.
View Replies View Relatedmy 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.
View Replies View RelatedI 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."
View Replies View RelatedI 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.
I want to retrieve data that 30 days before or 60 days before from access. How can I do it.Using vbscript or SQL language or both?
View Replies View RelatedA 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.
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??
How can I retrieve all the records from the database having the following parameter:
in form, these are the fields to be entered:
month (it's a select option)
year
Then from the database the field objrs("strDate")
Scenario: User entered the ff:
month = January (with the value 1)
year = 2004
if in the database the input for the strDate field is having this format: 1/2/2004
How can I retrieve all data for January?
I have 2 tables Table_A and Table_B are linked together by TaID
Table_A
TaID - autonumber
Name
Address
Table_B
TbID - autonumber
TaID
Comments
here is my asp page
-------------------------
<%@ Language="VBScript" %>
<!-- #include file="connectionstring.asp" -->
<%
'declare variables
DIM ......
'Assign Variables
.......
Set Conn = Server.CreateObject("ADODB.Connection")
'database connection
Conn.provider = provider
Conn.ConnectionString = dbasepath
Conn.Open
'Sql statement to insert the data
sql = "insert into Table_A ( Name, Address) values (...*data from form*...)
' execute it
Conn.Execute(sql)
Response.Write "Data successfully inserted!"
Conn.Close
Set Conn = Nothing
--------------------------------------------
my question is I also need to insert the data to Table_B, but before that, I want to retrieve the Table_A.TaID first.
so if i do "select TaID from Table_A" and execute the sql how do I assign just the LAST record of TaID and assign to temp variable?
Do I allow to do that? if so, where should I put in the code above?
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 ...
Hi. I maintain an asp website with many input text boxes. I need to
check all the data that is typed in for special chars. What is the
best way to do this? I need something that will always run, regardless
of browser settings (disabling of javascript, etc
I think u don't seem to understand my question. I'm not talking about ur coding. what do type in the url address to open ur htm page? is it D:messageform.htm or something using http:// ?
View Replies View RelatedI have a problem to keep the input value from user still keep. The condition when User input , let me say" Employee Code","Employee Name","Level", then the user input all the 3 field, but when the user submit the employee code not unique/already had by another record,then the problem is after that Employee Name and level input value empty again. Then How to keep the input value....with that condition.....i have no idea....
View Replies View RelatedI'm just wondering which code will be best to achieve this?
Say I have a column table called SIZE with data:
A, B, C, D, E, F, G
User can enter any value between A-G.
So if user choose size B-E and I want to display a drop down menu listing values in between A-E ie: B, C, D, E
I use while-loop the show the table content in web page. e.g (bookingno,
booking date,customer no)
However, the client need me insert one column (confirmdate ) and allow the
user input and update the date .
Can someone tell me if it is possible to store the contents of a TEXT AREA
field in HIDDEN FIELD in another page after the initial form containing the
textarea is submittted....
I need to do this to seamlessly present the submitted data in an attractive
format while hiding his submitted data in the hidden field...but I am not
sure if there are restrictions of eg 255 characters for a hidden field?
I have sent form data through email using .asp before but I have never done it when you are using a form that has createelements involved. I have a form w/ 3 inputs, two text inputs and one select combo box. if i click an add user button it will appear with another row of 2 text boxes and a combo box, and you can repeat up to as many as you need. I am trying to figure out how to mail all of those values to someone. Is there an easy way. Below I will attach the code that I use to name the fields when they are generated maybe it will help....
<SCRIPT language="javascript">
counter = 1
function addRow(id){
var tbody = document.getElementById(id).getElementsByTagName("TBODY")[0];
var row = document.createElement("TR");
row.setAttribute("id","tr"+counter);
var td2 = document.createElement("TD");
var input2 = document.createElement("INPUT");
input2.setAttribute("type","text");
input2.setAttribute("name","pName"+counter);
input2.setAttribute("id","name"+counter);
td2.appendChild(input2);
var td3 = document.createElement("TD");
var input3 = document.createElement("INPUT");
input3.setAttribute("type","text");
input3.setAttribute("name","userName"+counter);
input3.setAttribute("id","prc"+counter);
td3.appendChild(input3);
var td4 = document.createElement("TD");
var input4 = document.createElement("select");
input4.name = "Role"+counter;
input4.id = "Role"+counter;
option = document.createElement("OPTION");
option.value ="Admin";
option.text = "Admin";
input4.add(option);
option = document.createElement("OPTION");
option.value ="Read";
option.text = "Read";
input4.add(option);
option = document.createElement("OPTION");
option.value ="Read/Write";
option.text = "Read/Write";
input4.add(option);
td4.appendChild(input4);
row.appendChild(td2);
row.appendChild(td3);
row.appendChild(td4);
tbody.appendChild(row);
counter++;
}
</SCRIPT>
I'm using the detailsview to perform edit and insert of new records via an
object datasource.
If an error occurs on the insert, I want to preserve the data the operator
tried to input, along with my error messages. Currently, it appears that the
detailsview is trying to rebind after the error, to the empty/null detail
item(on insert it is null), and thus I lose all the operator's input. Can
someone suggest the proper way for me to achieve the persistence I'm looking
for?
I have a little code to add multiple items to a shopping cart based
page. This code works perfect, but it adds all of the info to the
same input fields every time it loops. I need it to change the input
names each time it loops. Here is the code:
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
How to value in drop down value from mysql database ..
Technical Languages:
Front ENd: XHTML
Validation: JavaScript
Server Scripting: ASP
Server:IIS
Database: MySQL
I want to have a form where there is a textfield and a Browse... button to the right of it. I want the user to be able to press the Browse... button and select a file and then that filename be returned to the textfield.
I don't want it to upload it or anything like that...I just want to know the filename that the user has selected. Also, when the user presses the Browse... button, I want it to automatically go to a certain place.
I write the code as floowing to check the file nam before submit , but it show nothing when i click submit button. Code:
View Replies View Related