2. ASPRunnerPro General questions
  3. [SOLVED]  Expected end of statement
This topic is locked
[SOLVED]

 Expected end of statement

 		3/26/2003 5:17:57 AM
ASPRunnerPro General questions
author

Hi, I'm currently evaluating the product. First attempt run into some trouble. When trying to access the created asp page I get the following error message in the browser:

The page cannot be displayed

There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the home page, and then look for links to the information you want.

HTTP 500.100 - Internal Server Error - ASP error

Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:

Microsoft VBScript compilation (0x800A0401)

Expected end of statement

/projects/include/variables.asp, line 6, column 15
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Page:

GET /projects/Project Database_list.asp 


Any idea what could be causing this? - Thanks.
Sergey Kornilov admin 3/26/2003

Hi,
this line in variables.asp contains table name
strTableName="[Customers]"
Please check if your table name contains any bad characters in it.
Sergey Kornilov
500021 3/27/2003

Thanks,
The strtablename variable was contained within double quotes. EG
strTableName=""Customers""
There were numerous other extra and unbalanced quotes in this file which I have edited manually.
Now seems to be opening OK.
Thanks again.
A
 		ac163601 8/16/2006

Hi, I am also having the same Problem with my page not displaying:
Technical Information (for support personnel)
Error Type:

Microsoft VBScript compilation (0x800A0401)

Expected end of statement

/include/ASP_CRITICAL_CARE_aspfunctions.asp, line 688, column 57
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1)
Page:

GET /ASP_CRITICAL_CARE_list.asp
[color=#3333FF]

the Table names are fine (I think).
[color=#990000]

strKeyField="WorkOrder"

strKeyField2=""

strKeyField3=""

strTableName="[ASP_CRITICAL_CARE]"

strOriginalTableName="[ASP_CRITICAL_CARE]"

PageSize=100

session("pagesize") = PageSize

strLeftWrapper="["

strRightWrapper="]"

gstrOrderBy="ORDER BY [WOType] ASC, [PFT] ASC"

bKeyFieldEditable1=False

bKeyFieldEditable2=False

bKeyFieldEditable3=False

gstrSQL = "select [ETA Validity], [WOType], [PFT], [WorkOrder], [Branch], [Territory], [ETA], [DispatchDate], [WOStatus], [CustomerName], [FIRST NAME], [SURNAME], [MOBILE], [ActionedBY], [Notes], [Query TYpe] From [ASP_CRITICAL_CARE]"

gstrQuote = Session(strTableName & "_gstrQuote")

gstrQuote2 = Session(strTableName & "_gstrQuote2")

gstrQuote3 = Session(strTableName & "_gstrQuote3")
cXMLTopNode = "rs"

cXMLRowNode = "row"
cAdvSecurityMethod = 0
ColumnsCount = 1

%>[/color]
[color=#000000]
I also am not sure what has happened as I previously had this page working, but when I created a new one and copied it into the Root folder, the new one stopped working.
To make matters worse, I then compiled both again and placed them in the Root and now none of them work and both are giving the same error.
help please, I've only been using this for a couple of days and am very impressed, but also very stressed.
Thanks
A
 		ac163601 8/16/2006

I've sorted this one. For anybody following with the same Error, when I checked the location shown in:
/include/ASP_CRITICAL_CARE_aspfunctions.asp,
It transpired that the DEFAULT EDIT Value was without Quotes. Either check that you have ""'s surrounding the text prior to compiling, or fix it in the _aspfunctions.asp file.
Regards

Andrew