Can you pleaseeee let me know if what I am attempting to do is possible? ....and how. I have a Access database at backend of my ASP site. Is there a way in which I can design a page which will pick up only the records modified/added today in one database and add those to another database?
Is transfer of data between two databases possible?
I am trying to write a SELECT query in ASP to retrieve information from two databases (that must be kept seperate :-().
I have managed it using Access using something similar to the code included below, which I have modified for ASP. Looking around this seems to not be possible in ASP, instead the general recommendation is to link tables??? I would prefer to do it using ASP. Code:
How do you use SQL to recall and add data to MS Access databases? or is there a seperate way? ...
View Replies View Relatedi have data in multiple access databases (not multiple tables within one database file) and was wondering if there is a way with ASP to display selected data on one webpage from these different databases?
View Replies View RelatedI need to make a table's data available to users. The table is about 150,000 rows x 20 columns. So Excel is out of the question. I think the next common file types would be MDB or DBF. Using ASP, what are the steps to converting this data to one of those file types, then ZIPPING the files for download?
View Replies View RelatedI am creating a database and it has to be up dated from all over the county.But Unfortunately there are some users who have only telophone connection not internet connection. Is ther any way that I can allow them to up-date my database using telephone line i/o interne.
View Replies View RelatedI am new user of ASP and as well as this forum, i want to make a web page, to enter data,in which , first user login page, then he enter data on his authorize database, database names are same as user login name.
e.g if someone login as user xyz he must open xyz.mdb, and if other login as abc he must open only abc.mdb to enter data, and data entry page must validate fields such that numeric fields, text fields, numeric lenght, etc
I would like the value of the textfield from text1 from Select_License.asp to be transfered to swname from License_add.asp when i click on the Next button from Select_License.asp
<html>
<head>
</head>
<body>
<form name="form1" method="post" action="">
<P>
Software: <INPUT name=text1 >
<input type="submit" name="Submit" value="Find">
<%
on error goto 0
If Request.Form("Submit") = "Find" Then
description = Request.Form("text1") .....
How i can know the data tranfer rate for particulat directory on server using ASP?
View Replies View RelatedAny ideas on how I can set some data in 1.asp, then have 1.asp do a server.transfer (or .execute, come to that) to 2.asp, and have 2.asp access the original data?
I'm aware that the Session object fits the bill but want to avoid using this if I can. Having said that, the nature of the data is very much per-user so things like the application object are definitely inappropriate.
Another way I can do this is redirect/querystring, but the additional roundtrip here is not attractive.
Any other (sensible) methods anyone can think of?
I have an asp page that collects data from a database and then displays it in a table on the page. I also want to be able to put this information into excel. I know how to get the page to load up in excel and then display the data using the following command -:
response.contentType = "application/vnd.ms-excel"
however I want it so that there is an Extra button on the page that the user can press to transfer the data accross. Does anyone know how to do this?
I need some ideas in this if you can please help me.The folllowing is the scenerio:
I have a form which is the normal html with some validations and scripting done in javascript and i have a text box by name ticket no when the user enters a ticket no which exists in my database I need to update all my other form textboxes and textboxes with the data in the database else I need to show a alert that this doent exist in the database.
usually the event handling is done in javascript but now i have to call server side connection I have no clue how to do this.
Our asp programs seem to have different behaviors when users use IE and firefox. One of most annoying things is the data disappearing problem in IE but not in firefox.(Note: Sometimes a search program can run much faster in Firefox than in IE, don't know why)
For example, I have an internal user interface which they can do different product data
entry, the program will use Server.Transfer to different asp program for data entry.
Page1---UserInterface.asp
Select Case Request("Product")
Case "Sel"
Server.transfer("/Virtualdir1/test1.asp ")
Server.Transfer("/Virtualdir2/Test2.asp")
Case "Bear"
Server.Transfer("/Virtualdir3/test3.asp")
Case "IMED"
Server.Transfer("test4.asp")
Case "AC"
Server.Transfer("/Virtualdir4/test5.asp")
Case Else
End Select
When user finished data entry on test1.asp(second page, the web address will still show UserInterface.asp page as you know), click continue, on the third page if they found something typed wrong, if they click back button in the broswer, all data on the second page is gone. This only occurrs in IE, Firefox is fine.
It's very annoying, how can I fix it, if not, is there any other way?
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
Any idea what is causing this error? 006~ASP
0230~Server.Transfer Error~The call to Server.Transfer
failed while loading the page.
Just read about benefits of Server.Transfer over
Response.Redirect, replaced, and getting the error.
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 ....
I am a new programmer seeking a right way for transferring data between forum to forum, as i am creating a site wich have a page keeping 20's of server controls like drop down list and text boxes the value of ddl2 changging on change of ddl1 and displaying its corresponding value in text box and i have 10 rows in this way and i wanna display all selected values of server controls in next page as report.
View Replies View RelatedI'm learning ASP with a database in Access (new to Access also). I have created my tables and all but I'm stuck on how to query the table. I'm familiar with sql statements, so I was wondering if you can access the database the same way as with php and mysql. I.E.
Code:
Select * From Table Where id = 5.
Something like that, or will I need to use
Code:
objRS.Filter "ID = 5"
I guess the main question is does Access accept SQL statements and if so can you give me some examples as to querying the database.
I am working on ASP and SQL Databases. I have written the code . the program is very simple . its just an application form and u will be having upload and submit button . So after the data is being entered , the submit button code should be invoked and the data entered should be stored in the database.
View Replies View RelatedI'm having Difficulty understanding the concept of retreiving information from a database upon user request. E.g i have an ASp page that has a form with 3 drop down boxes and a submit button.
I want the next page to bring results from the database that meet the criteria set upon by the 3 drop down boxes. The DB is Access and its already got the information in it, i just want the correct information to come up in tables once the user has selected the choices in the drop down boxes.
If i upload an ASP page that is connected to an MDB (Access) database to my FTP server, is there any way that I can ensure that no one can download the database and that it remains "untouchable".
View Replies View RelatedThe problem I have is that I need to save the content of a form in a database, and I donw know how to save the content of a checkbox, can you give me an example of the code?
View Replies View RelatedI need script or a link to a tutorial that will allow me to do the following.
User enters username and password site checks the username and password against database1
if the user entered the correct username and password the page shows records from database2 if the user enterend incorrect username or password then nothing happens.
I am new to this forum and really looking forward to being involved in the community.
I'm trying to design a simple website with 2 dynamic searching functions. The first is the user enters text into a search box, clicks on the search button and then connects to a sql or access database and brings back those records that are LIKE the search phrase. It's my intention to then have a detailsview link on the searches so the user can drill through.I'm designing an online version of my catalog so that the user can browse by page. I also want the user to enter a page number and then click go and that would then take the user to the corresponding page in the catalog. I'm guessing I'll need to declare If 1 then open page1.html, if 2 then open page2.html.
I know I'm close but not close enough and my knowledge has been well and truly stretched and I must have read and read my Dummies book about 20 times over the last week.
For my ICT (computers) project at college I'm using an Access database, and I now have a problem with that. Basically the way it works is that the user enters their details in a form page (here). This then does the usual thing; runs a script which inputs the data into a database and then displays a thank you message.
the problem I'm having is that whenever I input punctuation into the form, it refuses to work; it comes back with a 500 server error. This is understandably quite irritating, as I'm setting up a mailing list that needs to incorporate a list of email addresses
My hosting account gives me a lot of MySQL databases but I usually just stick with MS SQL Server because it gives me fewer troubles.Now I want to challenge MySQL again. I use connString "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver; DATABASE=mybase; UID=myID;PASSWORD=myPwd; OPTION=3"
And the conn and recordset objects connects smoothly with the database. I can even get the things i want out of it. But every time I try to update the database such as:
rs("Content")="Cool"
rs.update
'or
names=array("Content")
values=("Cool")
rs.update names, values
It just wouldn't work...why? Content field is a text field.
What i need to do is build 2 tables below with the following fields:
tblUsers
id
name
address
postcode
tblShop
id
product
Now i need to build a relation between the two id fields but what i relaly need to know is how to retreve the data in the tblUsers from the id in the tblShop through asp. This is like for a shop
I'm trying to pull information from two different databases, use it, and then put it back into a database. The program I am writing is one which will keep track of exempt employees' absences. At the end of the year, employees get to rollover the sick days that they do not use. Herein lies the problem. The information on how many sick days an employee is in an AD download on one server. The information on how many days that employee has taken this year is on another. I need to take that information do a little math, and then add those days into a different table on the same server that the absences came off of to keep track of their "sick bank".
I would like to just Loop the information, but I cannot put recordsets inside recordsets and I cannot create a view from two separate servers, so I am at a stop sign. Can I just take all of the users and the amout of sick days they have and put them in a text file and then pull off of the text file? I'm not quit sure how to do this.
How do you go about searching three tables at the same time? I'm using Dreamweaver MX, but I can also hand code it in if know one knows the dreamweaver method
View Replies View RelatedGiven if tables A and B are in the same database, writing a query for them is relatively easy. But what if tables A and B are in different databases? Is it possible to query them together? If so, can anyone provide a generic example?
View Replies View RelatedI have a search page with an access database in the background.
When you type in a keyword, it brings the related article up.
Is it possible for this to display a hyperlink??? When i choose hyperlink in the access field it displays thefollowing on the screen: Code:
Inserting into an Access database using the above script generates this
error :
Microsoft JET Database Engine error '80040e07'
Syntax error in date in query expression '#20031021 20:36#'.
Using SQL : UsersTable SET UpdateTime=#"& dbDate(Now())&"# .....
If YYYYMMDD hh:mm:ss is a universal date, why is it rejecting it?
If I change it to YYYY/MM/DD hh:mm:ss it then becomes valid. Is this valid
in all situations, or am I doing something wrong in the first step?
I need script or a link to a tutorial that will allow me to do the following.
User enters username and password
site checks the username and password against database1
if the user entered the correct username and password the page shows records from database2 if the user enterend incorrect username or password then nothing happens.
I am new to this forum and really looking forward to being involved in the community.