Strange ASP problem

OC · 02-25-2002, 01:22 PM

Ok, this is odd. I'm building an ASP app that calls on an Access database. In the database is a table called "grant". In my ASP page I have "Set rGrant = cConn.Execute ("SELECT * FROM grant")"

In this form, I get an error: Syntax error in FROM clause

If I change "grant" to "grants" in the ASP page and in the Access database it work fine.

Is "grant" something special in the world of ASP?

-OC

ironchef · 02-25-2002, 02:15 PM

bah.. i can't find an exact reference on MSDN, but i'd venture to guess that yes, you stumbled on a reserved word. best to leave it at "grants" or better yet, prefix your tables, forms, queries, and objects with appropriate identifiers (ie, "grant" becomes "tblGrant" or "t_grant")

ironchef · 02-25-2002, 02:21 PM

Aha! We're right:

Code:

GRANT Statement
Grants specific privileges to an existing user or group.

Syntax
GRANT {privilege[, privilege, …]} ON
    {TABLE table |    
    OBJECT object|

CONTAINER container } TO {authorizationname[, authorizationname, …]}


----------------------------------------------------------------------
The GRANT statement has these parts:

Part Description 
privilege -- The privilege or privileges to be granted. Privileges
             are specified using the following keywords:
             SELECT, DELETE, INSERT, UPDATE, DROP, SELECTSECURITY, 
             UPDATESECURITY, DBPASSWORD, UPDATEIDENTITY, CREATE, 
             SELECTSCHEMA, SCHEMA and UPDATEOWNER. 

tablename -- Any valid table name. 

object    -- This can encompass any non-table object. A stored query 
             (view or procedure) is one example. 

container -- The name of a valid container. 

authorizationname  -- A user or group name.

OC · 02-25-2002, 03:22 PM

Thanks cheffy!

-OC

02-25-2002, 01:22 PM	#1
OC the admiral formerly known as overclocked Join Date: Aug 2000 Location: Outside the mainstream Posts: 5,922	Strange ASP problem Ok, this is odd. I'm building an ASP app that calls on an Access database. In the database is a table called "grant". In my ASP page I have "Set rGrant = cConn.Execute ("SELECT * FROM grant")" In this form, I get an error: Syntax error in FROM clause If I change "grant" to "grants" in the ASP page and in the Access database it work fine. Is "grant" something special in the world of ASP? -OC __________________ But what is adulthood except a delayed end-run around our parents' better judgment? -- Peter Egan cough

02-25-2002, 02:15 PM	#2
ironchef Commander Join Date: Dec 2000 Location: SF Bay Area Posts: 1,342	bah.. i can't find an exact reference on MSDN, but i'd venture to guess that yes, you stumbled on a reserved word. best to leave it at "grants" or better yet, prefix your tables, forms, queries, and objects with appropriate identifiers (ie, "grant" becomes "tblGrant" or "t_grant") __________________ blurt blurt blurt

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

02-25-2002, 03:22 PM	#4
OC the admiral formerly known as overclocked Join Date: Aug 2000 Location: Outside the mainstream Posts: 5,922	Thanks cheffy! -OC

User Name
Password
Remember Me?