Expected Literal Constant Error Question

I am getting this error:

Microsoft VBScript compilation error '800a0415'

Expected literal constant

/....includes oolboxgallery-entry-header.txt, line 29

Const VirtualFolder = "../images/gallery/shop" & session("shop")
----------------------------------------------------------------^

THe issue seems to be with the appending of session("shop") to the VirtualFolder constant variable.

View Replies


ADVERTISEMENT

Expected Literal Constant

Why am i getting the above error

<%

'DataBase
const DSN_NAME = "ORADBA"
const DSN_SERV = "localhost"
const DSN_UID = "ORADBA"
const DSN_PWD = "ORADBA"
const MM_Prod_DSN = "dsn=" & DSN_NAME & ";server=" & DSN_SERV & ";uid="
& DSN_UID & ";pwd=" & DSN_PWD & ";"

%>

Please note, MM_Prod_DSN is defined on a single line.

View Replies View Related

Unterminated String Constant Error

I am trying to resize images which have been retrieved from my database using 2 DLL files. I can display the images correctly but get an error message (Unterminated string constant) when I try to resize them.

The syntax I was given is: ....

View Replies View Related

Error :: Unterminated String Constant

I am getting the error message

Microsoft VBScript compilation (0x800A0409)
Unterminated string constant

Here is my Query, It is slight incorrect: HELP.

newest_sql = "SELECT TOP 5 CatID, ContentID, DateAdded, Title, FeaturedLabel, NewestLabel FROM Content, ContentTypes Where Content.ContentTypeID = ContentTypes.ContentTypeID
AND (((Content.Display)=1) AND ((ContentTypes.ContentTypeId)=4))
ORDER BY DateAdded DESC"

View Replies View Related

Expected ')' Error

I am getting the following error:

Expected ')' line 63
Set Rec2 = oConn.Execute("SELECT * FROM userlogins WHERE CustID=Rec1("CustID")")

Line 63 is: Code:

View Replies View Related

Expected Error

<td width="65"><span style="color: #000000">Chat Id:</span></td><td width="145"><span style="color: #FFFF00"><% if Request.Cookies("username") = "" then %><input type=text name=uname class=form1>
<% else %>
<%=Request.Cookies("username")
end if%>
</span></td>


Above is the code I am trying to use however it keeps coming up with an expected error.Another blonde moment methinks but where am I going wrong

View Replies View Related

Expected End Statement Error

I need the end statement to this sql query, but I am doing something wrong, is there site where they show you the different forms of ending sql statments in ASP? Code:

View Replies View Related

Error (0x800A0401) Expected End Of Statement

during the creation of an HTML page using asp variable I have this
problem:

Microsoft VBScript compilation (0x800A0401) Expected end of statement
/asp/pages/connect1_1.asp, line 27, column 35
strtable = strtable & "<tr valign="top">" &

The code is the following: Code:

View Replies View Related

Random Error: Too Few Parameters. Expected 1.

I needed to create a quick and simple "lock-in" system where many people in a computer lab can pick an answer (A, B, C, etc.) and then the results be displayed to me. I went looking for a free ASP poll script that would work for my needs. I found one called Poll Manager on AspPlanet.net (http://www.aspplanet.net/viewdl.asp?itemid=6). It gives me the ability to see the results with a bar graph of sorts and easily reset the data. I have everything set-up and working, however, I modified the results page so that it reloads using javascript every 5 seconds. After letting the page reload several times, I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.


I can reload the page and often the error goes away, but sometimes it takes a few reloads. What could be causing this? The code can be found at aspplanet.net but I can also copy and paste it here if needed. Any ideas?

View Replies View Related

Expected End Of Statement Error With Response Write

If getting an End of statement error. I know it's something I'm missing and my lack of ASP isn't helping.

Response.Write "<option value='Admin_Game_List.asp?TS=League&LeagueID=" & objRsLeague("ID") & "'>" & objRsLeague("LeagueName") & "</option>"

View Replies View Related

Constant Called Constant Value

I try to make this:

const server="hello"
const conn= server & ".xxx.com"

but it indicate got literal problem. any expert can help me on this?

View Replies View Related

Error:[Microsoft][ODBC Microsoft Access Driver] Too Few Parameters. Expected 2.

I am trying to peform a multiple deletion of records from a single table "Stockist"

I i keep getting the following Error and can't see where i am going wrong. Can anyone help?

Microsoft OLE DB Provider for ODBC Driverserror '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/RetailerStockProductRemove.asp, line 22

The code i have used is as follows:

View Replies View Related

"Error 500: Expected Statement"

I am useing CDonts to send an e-mail to a customer to inform them that their bid has been received. When I test the page i get this error:

Microsoft VBScript compilation error '800a0400'

Expected statement

/MailPages/MailPages.asp, line 35 "<br><br>Click <a href=http://" & vURL & "/Login.asp?reg=E>HERE</a> to login to HVL Online.<br><br>"& _^ The code for this page is as follows: Code:

View Replies View Related

AdUseServer Constant Undefined

I have an ASP page in which I reference quite a few ADO constants such as adOpenStatic, adLockReadOnly and they work fine but a reference to adUseServer comes up as undefined?

I have a typelib definition in that page:

<!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" -->

For the time being I used the constant 2 to replace that reference - I hope
that is correct?

Any ideas on why that constant remains undefined?

View Replies View Related

Unterminated String Constant

I've searched these forums but no joy - am sure this is a newbie error but I'm still tearing my hair out. Receiving this message :

Microsoft VBScript compilation error '800a0409'

Unterminated string constant

The ASP code is :

View Replies View Related

Unterminated String Constant

how do i put something like this

response.write "hello world!"

into a string

for eg strtext =" response.write ""hello world!"" "

now i have tried single quotes and double and both give the error
Unterminated string constant
reason i want this is so that i can write this line to a text file

or better yet "<%response.write "hello world!"%>"
into a file and then save it as an asp page, and then open that page from my browser.

View Replies View Related

What Is The ADO Constant For Text Datatype?

I have a table (MSSQL 2000 server) with a column called "Content" whose datatype is text. Now I'm trying to insert data into the table using a stored procedure. What is the ADO constant that I should use to insert value into that column? Code:

View Replies View Related

Intentional ASP Constant Loop

I need to create an ASP page that automatically queries my database once every hour on the hour. So, what I was hoping to do was just create an ASP page that constantly loops and never actually turns itself off. Within this code, it could check the current time and if it's the top of the hour again, my database gets queried however I have a feeling that my web host probably won't permit this.
So I was just wondering if this would work or if not, is there a work around? Worse case senario is I could create a visual basic application that sits on my desktop and just works off of there but I would prefer to develop this in a web based language such as ASP or .NET if possible.

View Replies View Related

Unterminated String Constant?

I write following code for call java script funtion through hyperlink column of datagrid
strId=DataGrid1.Items[j].Cells[4].Text.Trim();

DataGrid1.Items[j].Cells[15].Text ="<a href='#' onClick=javascript:fun(escape('" + HttpUtility.HtmlEncode(strId) + "'))>Select</a>" ;

its working fine but if any record have space like "G 59" it gives error
unterminated string constant.

View Replies View Related

Unterminated String Constant

i have no idea what this error is referring to. I thought it was a missing quotation set but I'm not sure where it should go

strsql="UPDATE software_signout SET signin_date='<%=date()%>',received_by='" & request("received_by") & "' where id=" & request("id") & "" ...

View Replies View Related

Unterminated String Constant

I'm trying the following:

Code:

response.redirect("shoppingCart_02.asp?carrierName="& carrierName &"&carrierRate="& carrierRate &")

And I'm getting:

Error Type:
Microsoft VBScript compilation (0x800A0409)
Unterminated string constant
/kennyshardwood/freightQuote2.asp, line 476, column 99
response.redirect("shoppingCart_02.asp?carrierName="& carrierName &"&carrierRate="& carrierRate &")

View Replies View Related

Insert Record With Constant Text

I have a quick question regarding a text field for inserting record, I have a page which inserts various fields including area code an phone number for a new record, however I am curious if there is a way that I can either make the area code appear with brackets around it in the text field which is sent so that the user does not have to type it in each time.

I was thinking I could concantenate the value i send in each time with brackets but am not sure what the syntax would b for this. or perhaps there is another way of doing this?

View Replies View Related

Expected End

When adding an item to cart I get the following message and I dont know why:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/sc_addToCart.asp, line 114

rst.open "select * from scItemsOrdered where scOrdersID = " & scOrdersID " & and scProductsID = " & dsReturnInt(scProductsArray(i), 0, MAXINT) & " and Modifiers = '" & scModifiersID & "'", cnn, 1, 2

View Replies View Related

Expected 'End'

Anyone knows how to fix this:

Microsoft VBScript compilation error '800a03f6'Expected 'End'
line 281

line 281: <td width="155" height="1"><%Response.Write(rsResult("Fuel_Sub_Mode"))%></td>

Does it mean I'm missing an End somewhere?

View Replies View Related

Expected ';'

I am getting the error below and can't get it figured out. Any ideas.

Expected ';'
/waukon/news/dbconnection.inc, line 3
Set adoCon = Server.CreateObject("ADODB.Connection")
----^

Code:
src = "e:webdevwaukondbwaukon.mdb"
Set adoCon = Server.CreateObject("ADODB.Connection")
sConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & src
adoCon.Open sConnStr

View Replies View Related

As Expected

I did not expect this to work as expected:

<%
function a()
%>ha !<br><%
end function

a
a
a
a
a
%>

So, why do we use so much response.writes?

View Replies View Related

Expected 'End' But Where??

I'm querying 2 tables in 2 seperate recordsets and comparing set 2 to set 1 using ASP. If booking exists in set 2 that matches item in set 1 then I need to display the length item is booked for. I'm using a table with many cells and shading background to identify booked areas.

Keep getting error

Microsoft VBScript compilation error '800a03f6'

Expected 'End'

/loans/kitdiary.asp, line 115

else if d2 > fidate then
^

Code:

View Replies View Related

Expected 'End'

I've written a script that allows users to choose their own colors for the style sheet, but when I try to include the style sheet (style.inc), I get this error:

Microsoft VBScript compilation error '800a03f6'

Expected 'End'

/theroguehacker/style.inc, line 106

Line 106 is the end of the file... I've messed with it at least two hundred times... Please take a look and see if I'm doing it wrong. (I'm definately a beginner)

Also, I'm going to post the script that processes all the input. I'd like to know if there's an easier way to do it. Code:

View Replies View Related

Expected End Of Statement

i have a dropdown box with some values, i take that value and query the DB, i need to take that value and query across more than one column i set the up but am i have some problems i'm getting an error "Expected end of statement, Code:

View Replies View Related

Expected End Of Statement

i am running my asp code to access the table names in the database odbc_exmp, but i am receiving this error

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/odbc_exmp.asp, line 24, column 5
next conn.MoveNext
----^

i am not able to figure out the problem with the code:

View Replies View Related

Expected End Of Statement

I've walked myself through a Beginning ASP book and taken a class on SQL2000. I'm able to access my database on my server through a DataConn_Open.asp page. The code below is giving me back the error:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/InventoryTrans.asp, line 48

Response.Write "<option Value=" & strRSRrodLine & "</option>"
--------------^

The code is as follows: Code:

View Replies View Related

Too Few Parameters. Expected 1.

Getting this famous error when I try to do the following select statement:

"SELECT * FROM Deliveries WHERE Deliveries.ShippingNo = " & iShipment & ";"

iShipment is passed thru a querystring above the SQL statement as follows:

iShipment = Request.QueryString("shipno")
iShipment = Cstr("iShipment")

There is definitely a 'ShippingNo' field in my access database. Cannot seem to find why this is happening.

View Replies View Related

Too Few Parameters. Expected 1

I keep on getting this error. I had an sql statement before and it works. I changed it and i get this error so i know it's within the sql statement. Does anybody know what is wrong?Code:

<% dim mysql
set objconn = server.createobject("ADODB.connection")
objconn.connectionstring = "dsn=prospect"
objconn.open
set objrs = server.createobject("ADODB.recordset")
'mysql = "select * from Prospect where asm = '" & Username & "' order by Prospects_Name ASC "
mysql = "Select * from Prospect WHERE Status_Report.Prospect_Number = Prospect.Prospect_Number "
objrs.open mysql, objconn
%>

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved