two tables in one database, different result

ntgcmlfu · #1 (**permalink**) Apr 20th, 2006, 17:55

hi,

i just found out something wrong with my database. when i try to use asp to get access to one table in database to retrieve all values in it, I succed.

however, when i try with another table, it suddenly appears below error message:

(0x80004005)
Unspecified error
/Public/example.asp, line 24

can anyone suggest what's wrong with this? i think it might come from the relationship of the table but i really cannot see anything wrong with it (i can do this with microsoft access but when in asp, it is not possible

)

Rob · #2 (**permalink**) Apr 20th, 2006, 20:03

Post Your Code

ntgcmlfu · #3 (**permalink**) Apr 20th, 2006, 20:42

Code: Select all

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<%
    Dim Rst, DBConn, strSQL, id
%>
<body>
<%
    Set DBConn = Server.CreateObject("ADODB.Connection")
    DBConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/") & "/../WEB_ROOT/Database/wad.mdb" & ";"
    
    strSQL = "SELECT PositionID FROM Position"

    Set Rst = Server.CreateObject("ADODB.RecordSet")
    Set Rst = DBConn.Execute(strSQL)
    While Not Rst.EOF
        Response.Write Rst("PositionID") & "<BR>"
        Rst.MoveNext
    Wend
    Rst.Close
    Set Rst = Nothing
    DBConn.close
    Set DBConn = Nothing    
    
%>
</body>
</html>

this is my code to check the two tables, when I switch the "Position" in the strSQL statement by something else, more specifically, some other tables in the database, they work find when I try to RESPONSE.WRITE RST(""). However, when I test with Position, it just says that error. Really weird and ...weird.

Thanks for reading, Rob

ntgcmlfu · #4 (**permalink**) Apr 20th, 2006, 22:37

thanks for this, but i found out the error.
ASP does not like Position, should be somethine else.

Working perfectly.

Rob · #5 (**permalink**) Apr 20th, 2006, 23:46

ok..... just as a pointer for future errors, ALWAYS POST YOUR CODE.

For future reference, here is a list of RESERVED words when using the JET ENGINE:-

A

ABSOLUTE ACTION ADD ADMINDB
ALL ALLOCATE ALPHANUMERIC ALTER
AND ANY ARE AS
ASC ASSERTION AT AUTHORIZATION
AUTOINCREMENT AVG

B

BAND BEGIN BETWEEN BINARY
BIT BIT_LENGTH BNOT BOR
BOTH BXOR BY BYTE

C

CASCADE CASCADED CASE CAST
CATALOG CHAR CHARACTER CHAR_LENGTH
CHARACTER_LENGTH CHECK CLOSE COALESCE
COLLATE COLLATION COLUMN COMMIT
COMP COMPRESSION CONNECT CONNECTION
CONSTRAINT CONSTRAINTS CONTAINER CONTINUE
CONVERT CORRESPONDING COUNT COUNTER
CREATE CREATEDB CROSS CURRENCY
CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP
CURRENT_USER CURSOR

D

DATABASE DATE DATETIME DAY
DEALLOCATE DEC DECIMAL DECLARE
DEFAULT DEFERRABLE DEFERRED DELETE
DESC DESCRIBE DESCRIPTOR DIAGNOSTICS
DISALLOW DISCONNECT DISTINCT DOMAIN
DOUBLE DROP

E

ELSE END END-EXEC ESCAPE
EXCEPT EXCEPTION EXCLUSIVECONNECT EXEC
EXECUTE EXISTS EXTERNAL EXTRACT

F

FALSE FETCH FIRST FLOAT
FLOAT4 FLOAT8 FOR FOREIGN
FOUND FROM FULL

G

GENERAL GET GLOBAL GO
GOTO GRANT GROUP GUID

H

HAVING HOUR

I

IDENTITY IEEEDOUBLE IEEESINGLE IGNORE
IMAGE IMMEDIATE IN INDEX
INDICATOR INHERITABLE INITIALLY INNER
INPUT INSENSITIVE INSERT INT
INTEGER INTEGER1 INTEGER2 INTEGER4
INTERSECT INTERVAL INTO IS
ISOLATION

J

JOIN

K

KEY

L

LANGUAGE LAST LEADING LEFT
LEVEL LIKE LOCAL LOGICAL
LOGICAL1 LONG LONGBINARY LONGCHAR
LONGTEXT LOWER

M

MATCH MAX MEMO MIN
MINUTE MODULE MONEY MONTH

N

NAMES NATIONAL NATURAL NCHAR
NEXT NO NOT NOTE
NULL NULLIF NUMBER NUMERIC

O

OBJECT OCTET_LENGTH OF OLEOBJECT
ON ONLY OPEN OPTION
OR ORDER OUTER OUTPUT
OVERLAPS OWNERACCESS

P

PAD PARAMETERS PARTIAL PASSWORD
PERCENT PIVOT POSITION PRECISION
PREPARE PRESERVE PRIMARY PRIOR
PRIVILEGES PROC PROCEDURE PUBLIC

Q

R

READ REAL REFERENCES RELATIVE
RESTRICT REVOKE RIGHT ROLLBACK
ROWS

S

SCHEMA SCROLL SECOND SECTION
SELECT SELECTSCHEMA SELECTSECURITY SESSION
SESSION_USER SET SHORT SINGLE
SIZE SMALLINT SOME SPACE
SQL SQLCODE SQLERROR SQLSTATE
STRING SUBSTRING SUM SYSTEM_USER

T

TABLE TABLEID TEMPORARY TEXT
THEN TIME TIMESTAMP TIMEZONE_HOUR
TIMEZONE_MINUTE TO TOP TRAILING
TRANSACTION TRANSFORM TRANSLATE TRANSLATION
TRIM TRUE

U

UNION UNIQUE UNIQUEIDENTIFIER UNKNOWN
UPDATE UPDATEIDENTITY UPDATEOWNER UPDATESECURITY
UPPER USAGE USER USING

V

VALUE VALUES VARBINARY VARCHAR
VARYING VIEW

W

WHEN WHENEVER WHERE WITH
WORK WRITE

X

Y

YEAR YESNO

Z

ZONE

ntgcmlfu · #6 (**permalink**) Apr 20th, 2006, 23:59

wow
this is so cool man, thanks a lot.

this solves a lot of problem for me, seriously.

cheers,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formating php output result	dhossai	PHP Forum	3	Oct 26th, 2007 23:08
can create database but not tables	saltedm8	Databases	28	Sep 16th, 2007 19:31
Displaying MySQL database tables on a page	vandiermen	PHP Forum	3	Jun 30th, 2007 21:58
Returning result from db as a hyperlink	lobster1983	PHP Forum	2	Sep 18th, 2005 19:59
ASP Result Field	djaccess	Classic ASP	6	Aug 28th, 2003 16:17

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
two tables in one database, different result