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?
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?
My site web is using database in ACCESS. I'M using a Table and a Query, the table work fine but the Query don't work.I got the error : Undefined "NZ" function.
I did some search and found that when query are used, it use a function "NZ" to replace NULL with " ". But ASP can't use that. It's what I understood.
I found some code to repair this but they modify my Database, and I don't think I should do this because maybe it could crash it.Somoene know how to get ride of this with out modifying the DB?
I got this error:
Error Type:
Microsoft VBScript runtime (0x800A01F4)
Variable is undefined: 'myapp'
When I was doing this:
Set myapp = Server.CreateObject("MyAppCOM.MyApp.1")
Why?
Is there a way of detecting what the causes is on a undefined error without using asp?
Asp scripts have stopped working on my site. HTML pages still work, but not if I change the extension to ASP. I get a 500 error, even when the asp script only contains HTML.
My host is Fasthosts but my reseller never returns my emails.
I am getting an undefined error on the SELECT line that contains locaiton_form. Can someone help me fix this error.
<html>
<body>
<form action="connopen.asp" method="get">
First Name: <input type="text" name="first_name"><br>
Last Name:<input type="text" name="last_name"><br>
<form name="location_form" method="get">
<select name="Location" onChange="location_form.submit();">
<option value="null"<%IF loc_id = "null" THEN%> selected="selected"<%END IF%>>
<option value="MAE"<%IF loc_id = "MAE" THEN%> selected="selected"<%END IF%>> MAE
<option value="LCQ"<%IF loc_id = "LCQ" THEN%> selected="selected"<%END IF%>> LCQ
<option value="GSO"<%IF loc_id = "GSO" THEN%> selected="selected"<%END IF%>> GSO
<%
response.write(test())
%>
<script language="javascript" runat="server">
function test()
{
var s = window.dialogArguments;
return s
}
</script>
from my asp page1 i am calling the showmodaldialog and passing the argument. this is the code i was written in asp page2. it's thrown an error like.
Error shows in browser as
Microsoft VBScript runtime error '800a01f4'
Variable is undefined: 'JMail'
/SendEMail2.asp, line 38 ....
I have the following asp code and the functionality works, but before it works a dialog box pops up and says 'Runtime error 'Episodes' is undefined. I don't know how to get rid of it. Anyone have any ideas?:
for i=1 to 5
response.write "<tr><td><a style='text-decoration: underline;' class='biosLinks' href='http://www.url.com/Episodes/episode" & i & ".wmv' onclick='window.open(Episodes/episode" & i & ".wmw); return false'>Episode " & i & "</a><br></td></tr>"
next
Can someone point out why this is giving me the error "Variable is
undefined: 'arrProducts' "
<begin_code>
Dim m_arrProducts()
Sub SerializeCart()
ReDim m_arrProducts(m_intCartCount -1)
response.Write("ARRAY: " & IsArray(m_arrProducts) & " Cart Count: " &
m_intCartCount)
For intCounter = 0 to m_intCartCount - 1
response.Write("product 1" & "<br/>")
Next
End Sub
<end_code>
the Response.Write prints "True" for IsArray and "2" for m_intCartCount.
I'm developing an account lookup, mostly in ASP, that displays a list of radio buttons to select one account from those found in a recordset. Here is a snip of the account display, after the recordset is populated: Code:
View Replies View RelatedI'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 :
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.
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 RelatedI 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.
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.
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.
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") & "" ...
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 &")
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?
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: ....
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"
I am trying to insert values into a database using an sql statement that i read from a table that contains all my different sql commands. The sql statement is stored in the following way in the table: Code:
View Replies View RelatedI 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.