|
|
|
|
|
|
Joined: Nov 2004
Posts: 1
Newbie
|
OP
Newbie
Joined: Nov 2004
Posts: 1 |
Hi, need some help!
sql="SELECT a.username,a.ModuleID," & _ "b.ModuleName FROM table1 a, table2 b"&_ "WHERE a.moduleID = b.moduleID" & _ "ORDER BY a.username" rsPlantilla.Open sql
I got an error message: Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E14) Line 1: Incorrect syntax near 'a'. /plantilla/access/userModule.asp, line 32
Thanks, jhoann
|
|
|
|
|
|
|
|
|
|
|
|
|
Joined: Nov 2004
Posts: 1
Newbie
|
Newbie
Joined: Nov 2004
Posts: 1 |
It would appear that you are missing a space between the table alias "b" and the WHERE clause, as well as one between the moduleID and the ORDER BY clause. A quick lblMessage.text = sql or a debug.print sql will show you if you are missing spaces...
|
|
|
|
|
|
|
|
|
|
|
|
|
Joined: Jan 2004
Posts: 22,934 Likes: 4
BellaOnline Editor Highest Posting Power Known to Humanity
|
BellaOnline Editor Highest Posting Power Known to Humanity
Joined: Jan 2004
Posts: 22,934 Likes: 4 |
Right, always do a
response.write SQL
before you use it to debug it. You should always guarantee your code is doing what you think it is doing with actual write-outs, while you are figuring out what it is doing.
I would also not use SQL as a variable, just in case. It's safer to use SQLTxt for example.
|
|
|
|
|
|
|
|
|
|
|
|
|
Joined: Dec 2004
Posts: 1
Newbie
|
Newbie
Joined: Dec 2004
Posts: 1 |
Definitely Best Machine Hosting is not good. They ruin my bussiness , they don't answr to any of my email just stupid answers and after one month i ask for refund . Is the worst hosting i ever seen.
[URL]
|
|
|
|
|
|
|
|
|
|
|
|
|
Joined: Jan 2004
Posts: 22,934 Likes: 4
BellaOnline Editor Highest Posting Power Known to Humanity
|
BellaOnline Editor Highest Posting Power Known to Humanity
Joined: Jan 2004
Posts: 22,934 Likes: 4 |
Best-machine.com was fine for us at first - we were with them for almost a year which is the longest we'd stayed with anyone. In general they were good about answering questions so I'm surprised they didn't answer yours. However they were not always prompt in a same-day situation, i.e. when the servers went down. So that is why we left them.
If your questions were "why is my server down", then that should be answered properly. But if your questions were "how do I code this in ASP", that's not really their responsibility. So it all depends on what you were asking them <img src="/images/graemlins/smile.gif" alt="" />
|
|
|
|
|
|
|
|
|
|
|
|
|
Joined: Aug 2006
Posts: 10
Newbie
|
Newbie
Joined: Aug 2006
Posts: 10 |
Best-machine.com was fine for us at first - we were with them for almost a year which is the longest we'd stayed with anyone. In general they were good about answering questions so I'm surprised they didn't answer yours. However they were not always prompt in a same-day situation, i.e. when the servers went down. So that is why we left them.
If your questions were "why is my server down", then that should be answered properly. But if your questions were "how do I code this in ASP", that's not really their responsibility. So it all depends on what you were asking them <img src="/images/graemlins/smile.gif" alt="" /> however i think as a good web hosting providers, one should reply to all questions even it is not under their responsibility. They can answer by telling their clients directly. <img src="/images/graemlins/computer.gif" alt="" />
|
|
|
|
|
|
|
|
|
|
|
|
We take forum safety very seriously here at BellaOnline. Please be sure to read through our Forum Guidelines. Let us know if you have any questions or comments!
|
|
|
|
|
|
|
|
|
|
|
This forum uses cookies to ensure smooth navigation from page to page of a thread. If you choose to register and provide your email, that email is solely used to get your password to you and updates on any topics you choose to watch. Nothing else. Ask with any questions!
|
|
|
|
|
|
|
|
|
|