SitePoint Sponsor |
|
User Tag List
Results 1 to 9 of 9
Thread: asp and sql
-
Oct 2, 2001, 22:25 #1
- Join Date
- May 2001
- Location
- Malaysia
- Posts
- 216
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
asp and sql
my sql statement... select * from tbl_m_user-one
and i'm having this two problems...
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
can u guys tell me what is going on?
thanks....Your WebHosting Partner - RouterWebHost.com
eXam SIMulation Software - ExamSim.net
geeks forums -ProgrammingTutor.com
BMWClub of Malaysia - BMWClub.com.my
unofficial MU Fan Club coming soon - ManchesterUnited.com.my
-
Oct 3, 2001, 01:44 #2
- Join Date
- May 2000
- Location
- Victoria, Australia
- Posts
- 1,661
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Have you double checked if if the tables name was spelt correctly?
.NET Code Monkey
-
Oct 3, 2001, 01:57 #3
- Join Date
- May 2001
- Location
- Malaysia
- Posts
- 216
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
yeah.... i double checked it... can the hyphen be the problem.... btw the database is in access....
Your WebHosting Partner - RouterWebHost.com
eXam SIMulation Software - ExamSim.net
geeks forums -ProgrammingTutor.com
BMWClub of Malaysia - BMWClub.com.my
unofficial MU Fan Club coming soon - ManchesterUnited.com.my
-
Oct 3, 2001, 03:14 #4
- Join Date
- Jul 2001
- Location
- Scotland
- Posts
- 4,836
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Could you post the code? That helps greatly.
-
Oct 3, 2001, 08:56 #5
- Join Date
- Sep 2001
- Location
- Barrie, Ontario
- Posts
- 324
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Take out the hyphen. I can't say for sure that it is causing the problem, but it is the one thing that logic says doesn't belong in a table or column name, much like reserved words.
-
Oct 3, 2001, 09:02 #6
- Join Date
- Jul 2001
- Location
- Scotland
- Posts
- 4,836
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Didn't read the the post right, lol.
As kode said, and that should hopefully fix it.
-
Oct 8, 2001, 02:59 #7
- Join Date
- Jun 2001
- Location
- kuala lumpur in malaysia
- Posts
- 15
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
but, when i put square bracket around the tablename, i seen some examples doing that....
select * from [tbl_m_user-one].... it work
-
Oct 8, 2001, 03:08 #8
- Join Date
- Jul 2001
- Location
- Scotland
- Posts
- 4,836
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Opps, I knew that, should have suggested that, sorry
-
Oct 8, 2001, 10:30 #9
- Join Date
- Sep 2001
- Location
- Barrie, Ontario
- Posts
- 324
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Yes, that would fix it, as square brackets are used to encase a string with "bad" characters, just like in ASP, you can have variables with spaces in them, using square brackets. If you took out the hyphen, you wouldn't need the square brackets.
Bookmarks