Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Other > Programming Help
Reload this Page

Expected end of statement error

Discuss Expected end of statement error in the Programming Help forum on ASP Free.
Expected end of statement error Programming Help forum discussing programming solutions and code assistance related issues. Feel free to ask questions, or to offer your assistance.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old April 21st, 2005, 01:55 PM
dzigner dzigner is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 27 dzigner User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 21 m 41 sec
Reputation Power: 0
Send a message via MSN to dzigner Send a message via Yahoo to dzigner
Expected end of statement error
Hi
I searched for the above error, and I browsed to the answers available here and elsewhere. I tried those things and it didn't work. So I am posting here the code.
The code which worked previously was this (line breaks for readability):
Code:
<%
var rsmidtown = Server.CreateObject("ADODB.Recordset");
rsmidtown.ActiveConnection = MM_connmidtown_STRING;
rsmidtown.Source = "SELECT SKU, Description, Unit, ListPrice,
 MasterCategoryID, CategoryID, SubCategoryID, UPC FROM tblMasterSKU";
rsmidtown.CursorType = 0;
rsmidtown.CursorLocation = 2;
rsmidtown.LockType = 1;
rsmidtown.Open();
var rsmidtown_numRows = 0;
%>

This was working, then I went into Access, and got another query with multiple tables and fieldnames, with joins. Instead of previous rsmidtown.source I entered this rsmidtown.source statement:
Code:
rsmidtown.Source = "SELECT tblMasterSKU.SKU, tblMasterSKU.MasterCategoryID, 
tblMasterCategoryNames.MasterCategoryName, 
tblMasterSKU.CategoryID, _  
tblCategoryNames.CategoryName, 
tblMasterSKU.SubCategoryID, tblSubCategoryNames.SubCategoryName, 
tblSKUProductGroupLinks.ProductGroupID, 
tblMasterProductGroups.ShortDescription, 
tblMasterProductGroups.LongDescription, 
tblMasterProductGroups.MfgrID, tblManufacturer.MfgrName, 
tblManufacturer.URL FROM (tblSubCategoryNames INNER JOIN
 (tblMasterCategoryNames INNER JOIN (tblCategoryNames 
INNER JOIN tblMasterSKU ON tblCategoryNames.CategoryID = 
tblMasterSKU.CategoryID) ON 
tblMasterCategoryNames.MasterCategoryID = 
tblMasterSKU.MasterCategoryID) ON 
tblSubCategoryNames.SubCategoryID = 
tblMasterSKU.SubCategoryID) INNER JOIN ((tblManufacturer 
INNER JOIN tblMasterProductGroups ON 
tblManufacturer.MfgrID = tblMasterProductGroups.MfgrID) 
INNER JOIN tblSKUProductGroupLinks ON 
tblMasterProductGroups.ProductGroupID = _ 
tblSKUProductGroupLinks.ProductGroupID) ON 
tblMasterSKU.SKU = tblSKUProductGroupLinks.SKU;";

Now the previous statement is also not working.
Can someone help me with this?
This is an asp page, in vbscript, for an Access db.
thanks
Reply With Quote
  #2  
Old April 21st, 2005, 02:00 PM
Memnoch's Avatar
Memnoch Memnoch is offline
Unholy Moderator
ASP Free God 14th Plane (11500 - 11999 posts)
  
Join Date: Oct 2003
Location: In hell, where did you think?
Posts: 11,776 Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 3 Weeks 5 Days 8 h 27 m 42 sec
Reputation Power: 470
You should do it like this
Code:
strSql = "SELECT tblMasterSKU.SKU, tblMasterSKU.MasterCategoryID, "
strSql = strSql & "tblMasterCategoryNames.MasterCategoryName, "
etc...

rsmidtown.Source = strSql
Reply With Quote
  #3  
Old April 21st, 2005, 05:14 PM
dzigner dzigner is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 27 dzigner User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 21 m 41 sec
Reputation Power: 0
Send a message via MSN to dzigner Send a message via Yahoo to dzigner
hi
thanks, it works now.
Reply With Quote
  #4  
Old April 21st, 2005, 09:13 PM
dzigner dzigner is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 27 dzigner User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 21 m 41 sec
Reputation Power: 0
Send a message via MSN to dzigner Send a message via Yahoo to dzigner
Hi
It worked probably 2 times, and now it gives me time-out error?
Why?
thanks
Reply With Quote
  #5  
Old April 21st, 2005, 09:33 PM
Memnoch's Avatar
Memnoch Memnoch is offline
Unholy Moderator
ASP Free God 14th Plane (11500 - 11999 posts)
  
Join Date: Oct 2003
Location: In hell, where did you think?
Posts: 11,776 Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 3 Weeks 5 Days 8 h 27 m 42 sec
Reputation Power: 470
Make sure you are closing and disposing of all of your objects.
Timeout errors are generally caused by high network traffic or locking on the database.
Reply With Quote
  #6  
Old April 22nd, 2005, 12:06 AM
dzigner dzigner is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 27 dzigner User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 21 m 41 sec
Reputation Power: 0
Send a message via MSN to dzigner Send a message via Yahoo to dzigner
what is locking of the database?
Reply With Quote
  #7  
Old April 22nd, 2005, 09:51 AM
Memnoch's Avatar
Memnoch Memnoch is offline
Unholy Moderator
ASP Free God 14th Plane (11500 - 11999 posts)
  
Join Date: Oct 2003
Location: In hell, where did you think?
Posts: 11,776 Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 3 Weeks 5 Days 8 h 27 m 42 sec
Reputation Power: 470
When updating or deleting records, the database is locked so the records can't be read.
Reply With Quote
  #8  
Old April 24th, 2005, 03:19 PM
dzigner dzigner is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 27 dzigner User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 21 m 41 sec
Reputation Power: 0
Send a message via MSN to dzigner Send a message via Yahoo to dzigner
Hi
I opened and closed the db, and it is OK now.
thanks for your help
Reply With Quote
Reply

Viewing: ASP Free Forums > Other > Programming Help > Expected end of statement error

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway. 
Stay green...Green IT