logo

Previous Thread
Next Thread
Print Thread
ASP (SELECT statement) #145152 11/03/04 12:40 AM
Joined: Nov 2004
Posts: 1
jhoann Offline OP
Newbie
OP Offline
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

Re: ASP (SELECT statement) #145153 11/08/04 12:02 PM
Joined: Nov 2004
Posts: 1
Kdevine Offline
Newbie
Offline
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...

Re: ASP (SELECT statement) #145154 12/02/04 05:01 AM
Joined: Jan 2004
Posts: 22,776
Lisa LowCarb Offline
BellaOnline Editor
Highest Posting Power Known to Humanity
Offline
BellaOnline Editor
Highest Posting Power Known to Humanity
Joined: Jan 2004
Posts: 22,776
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.


Lisa Shea, Low Carb and Video Games Editor
Low Carb Forum
Re: ASP (SELECT statement) #145155 12/17/04 02:56 PM
Joined: Dec 2004
Posts: 1
acidutzu Offline
Newbie
Offline
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]
Re: ASP (SELECT statement) #145156 01/25/05 02:28 PM
Joined: Jan 2004
Posts: 22,776
Lisa LowCarb Offline
BellaOnline Editor
Highest Posting Power Known to Humanity
Offline
BellaOnline Editor
Highest Posting Power Known to Humanity
Joined: Jan 2004
Posts: 22,776
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="" />


Lisa Shea, Low Carb and Video Games Editor
Low Carb Forum
Re: ASP (SELECT statement) #145157 10/02/06 03:48 AM
Joined: Aug 2006
Posts: 10
L
loon Offline
Newbie
Offline
Newbie
L
Joined: Aug 2006
Posts: 10
Quote:
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="" />


best regards,
loon
WebHostForASP.NET Support term
ASP.NET Hosting

Moderated by  Lisa LowCarb 

Brand New Posts
2020: On this day . . .
by Mona - Astronomy - 11/29/20 09:50 AM
Container Gardening TIP OF THE DAY
by Lestie4containergardens - 11/29/20 05:13 AM
Native American Heritage Month
by Angela - Drama Movies - 11/29/20 01:25 AM
Advent 2020
by Angie - 11/28/20 11:18 PM
Thanksgiving and Gratitude
by Angie - 11/28/20 01:36 PM
Meanwhile in Canada
by Angie - 11/28/20 01:34 PM
Thanksgiving in Space
by Angie - 11/28/20 01:30 PM
The Solar System - for Kids & Others
by Mona - Astronomy - 11/28/20 12:39 PM
Uranus - Facts for Kids *new article*
by Mona - Astronomy - 11/28/20 12:36 PM
Sewing Ideas Towards Best Fit
by Cheryl - Sewing Editor - 11/25/20 09:36 PM
Privacy
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!
Channel List
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies
Safety
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!
Sponsor


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2020 Minerva WebWorks LLC. All rights reserved.


Powered by UBB.threads™ PHP Forum Software 7.7.3