Cannot Show Up Data From Access

My code show no error but the record cannot appear. My code =

if request("tarikh") = "" then
tarikh = Date()
else
tarikh = request("tarikh")
if isdate(tarikh) = false then
ralat = "Sila masukkan tarikh dalam format dd/mm/yyyy"
tarikh = Date()
end if
end if

sql = "select * from audit_trail where cstr(tarikhlogin) = '"&tarikh &"' order by masalogin desc"
set rs = conn.execute(sql)

response.write sql =
select * from audit_trail where cstr(tarikhlogin) = '04/02/2005' order by masalogin desc

Storing record have no problem but this code cant display any data.

View Replies


ADVERTISEMENT

Best Way To Show Summary Of Data...

i would like to show a summary of data in our database. it's more like a report showing things like totals for 2006, 2005, etc. what is the best way to do this and make it efficient?

i have a report right now consisting of about 20 queries i've been slowly putting together. when i run all of these on the page, it takes a good 15 seconds for it to generate the figures (and this is on a dual 3.0 ghz xeon machine). does anyone have any suggests on an efficient way to accomplish this?

View Replies View Related

Show Excel Data

how to show excel data in asp?

View Replies View Related

Show All Post Data

I was just wondering if there is a variable or procedure for getting all the POST data sent to a page. I don't want to have to handle every case for the POST data, I just want all POST data sent to the page to be outputted automatically.

View Replies View Related

Show Selective Data

I have an Excel file and NEED to show the data onto the webpage using ASP. The data shown on the page varies depending on the ID entered in the webpage.

Right now i Import the data into Access and then show it on the page with the JET engine.

View Replies View Related

Images Won't Show Linked From Access DB

I am unable to show and image or flash i have in an access database that is linked to an images subfolder, below is what i am using to show text on my ASP page but i want to ad a couple of images to the database to show in different locations on the page or pages, so i guess i needed a call function but ive used the one i have on my database image rotator scipt and a few others i have dowloaded and still the call scripts wont work, i'm sure im doing alot wrong can someone please edit this code and show me what to do... if its no bother

This works fine for showing the text on a page:

<%
Dim rs
Set rs = Server.CreateObject ("ADODB.Recordset")

rs.Open "introtext", "DSN=introTXT.mdb"

While Not rs.EOF
Response.Write "<br>" & rs("Content") & "<br>"
Response.Write "" & rs("URL") & ""
rs.MoveNext
Wend

rs.Close
Set rs = Nothing
%>

View Replies View Related

ASP With MS Access - Got It To Work But One Problem Always Show Up

I recently managed to get the connection and created an intranet that manage to show, insert, and edit records from this forum.

The problem is after a while when I try to view the asp pages again. it always give me the error page saying that the connection with the database is open or i don't have access even though I checked that the database file hasn't been edit and no browser is open.

I couldn't figure out why, and the only way to fix this problem right now is to create a new access file and new connection and everything very tideous. I am just wondering if this is a normal case and is there any easier way to fix ?

View Replies View Related

Show Previously Entered Data

I have two pages in my Web system that works in such a manner:
1. Page A allows users to input data into the web form
2. Page B displays data from Page A and other additional info

Page A contains only data inputs of HTML types TEXT and SELECT.I'd like to have an "Edit" button in Page B where it allows users to be redirected to Page A to view all of the previously entered data (and edit the data from there).

Can I do this without using "Request.QueryString" or "Request.Form" commands? I can't use "history.back()" or "history.go(-1)" commands, because with them, Page A is shown with empty data in it.

View Replies View Related

Show Data Without Database Installed

I have a strange problem. I have to show demo presentation in CD. In
this presentation record will be show from database. But we dont have
to install the database. any body can see the cd and can search the
data. how it is possible because the databse will not be installed in
CD and computer also.

View Replies View Related

Show Only If Data In Individual Database Fields

I have announcements down the left hand column of a site and want to display contact info if it is available - if it is entered into the database. So I only want to display a space plus the data if there is data in the field. Code:

View Replies View Related

Data Type Mismatch When GETting Data From An Access DB

We are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.

THE RESULTS:
(returns a blank page with only HTML Titles)

THE SCRIPT:
(you may notice this is a modified sample script): Code:

View Replies View Related

Asp+access Data

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

View Replies View Related

Access Data

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.

View Replies View Related

Access Data

i want 2 asked 2 howwe can acces the data from database using combo box.and how we can save the data to the database from combo box.

View Replies View Related

Data Access Via ASP

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.

View Replies View Related

Use Asp To Access Data In Db2

is there anyone use asp to acess data in db2?

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 ?

or i can only do that through ODBC ??

View Replies View Related

MS Access Data

Im trying to write some asp code to copy MS Access Data into an Oracle database. I have one connection open to the access database but when I try and open the oracle connection it says that the ms access tables does not exist.

Basically what Im trying to do is get the data from a row in the Access db and insert it into a row in an oracle db.

View Replies View Related

Data Access Permissions

I am using winXP pro + IIS5.1 to develop my site offline.

My data is in a folder outside the web, and I am told "my IUSR account needs
to have read/write/modify NTFS permissions to the directory housing the
file"

I can find no info on how actually to do this. Can anyone explain?

View Replies View Related

Data Access With JavaScript

I'm attempting a login script where I first authenticate a user's login info for a valid connection. When I use a valid ID/Password everything works. When I use a bad user/password I get an error page stating the login failed.

I would prefer to redirect the user to another page on a failed login. This is the part that doesn't work. I'm new to ASP and JavaScript, but have done this kind of thing with PHP with no problems.

View Replies View Related

Can't View Data In Access DB

I have a datbase (db2.mdb) on the server

Here is the information:
DB name-Addresses
Input - user
Input - password

Here is the script that I'm using to try to view, unsuccessfully, the user in this database. Does anyone see the error? Code:

View Replies View Related

Data From ASP Web To Access Database

I'm using Dreamweaver MX with ASP VBScript and using a MS Access Database. For about the longest time now, I've been trying to make a Mailing List form online and when you submit the data, [data] goes into the Access Database.

The Form is obviously working fine, although sometimes I do get errors, I'm mainly trying to get this data skullduggery working. Is that even possible (with ASP even)? I have to use ASP and I can't use SQL (because I would), but I think my n00b self has tried everything I could think of. Code:

View Replies View Related

Populating Data With Asp And Access

I have an access database with about 5 tables. One of which i want to populate data to. Specially 1000 enties at one time(In this example im adding employee numbers to a database table. Initially i want to add the for the employee name field " Unassigned" and when i ready to append a real employee name to the fields add if through a script(Can this be done?

Or is there a better way to do this?)This way, in my script i can call one of of those 1000 entries or employee numbers from a dropdowlist (ex. 1-1000). This way if go to use one of those entries from the dropdownlist the database would not get the " EOF/BOF error ". What logical suggestions do you guys have ?

View Replies View Related

How Can I Clear All Data From Access DB?

I have an Access database containing 10 Tables with a lot data in each Table. I need to copy the database with no data in another directory. Is there an ASP code or object that allows me to clear data in all Table at once? How can I clear all data from Access DB?

View Replies View Related

Entering Data Into Access.

I am having a problem with entering long ammounts of information (roughly 400 characters) into a database. The database field is set to memo.

Seems that whenever I want to enter strange characters it gives me an error. (I need to enter strange characters for an important reason).

Also I am having some problems with using ASP on Netscape (not testing...just clients are having problems). Does anybody have an idea of whats going on??

View Replies View Related

Retrieve Data From Ms Access

How can I retrieve data from Ms Access Database which is located in another computer over the network.

View Replies View Related

Retrieve Data From MS Access

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."

View Replies View Related

Access Data To Excel Using Asp

I have an intranet application written in asp using access as the backend database. My users have requested they be able to download certain data into an excel spreadsheet. I have limited asp experience and could use some help.

Ideally, the user would be prompted to save and name the file (save as dialogue) and then the data would be selected and saved into that file. I know I can use a select statement to select data directly into an excelspreadsheet using:

SELECT * INTO [Excel 8.0;Database=" & lcPathFile & "].[Sheet1] FROM myTable

But I'm not sure that is the right approach.

View Replies View Related

Limiting Data Access

I have 40 different users. Each user manages a subset of the total database. Currently I have a pull-down menu to let the user select their subset and then manage the data within it. I'd like to use their login info to pre-select the subset so that they have access only to their assigned areas. How do I "send" the subset name from one asp page to another? the db is "2004" the table is "Students" .

View Replies View Related

Data Not Saving In MS Access

I have an MS Access database within the same folder as the web pages on my IIS server. I input data into the forms but the data isn't being saved to Access. Is there a problem with this code?

View Replies View Related

Migrating Data (MS Access)

if i have 2 datasources with different table names and column headers that i want to merge i.e. "ptitle" and "name" whats the best way of doing this? are there any standard routines or should i use something intermediary like xml?

View Replies View Related

Input Data In Access Db

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 Related

Retrive Data From Ms Access

i am designing a database using Ms Access and ASP. i have 3 tables in access namely 'PERSONAL', other as 'POLICY' and 3rd one is named as 'STAFF'. in the contact table i have ID, Name, Children as fields. Also in policy table the firlds are:- ID, date_of_policy, no_policy, amount_paid, amount_balance and similarly the 3rd ie., staff has few fields. all three are linked my a common field which is ID

all i want is when the user searches for a perticular name (from frontend) it should search through table- 'PERSONAL' (fields- Name and Children). once it get the perticular name with the help of the ID it should retrive the datafrom both 'POLICY' and 'STAFF' of that perticular Name.

i do know how to search and retrive data from the same table but got a bit confused on how to retrive data from different tables using the 'PERSONAL' table just for reference and linking to the other 2 tables.

View Replies View Related

Data Into A Access Table

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







Copyrights 2005-15 www.BigResource.com, All rights reserved