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?
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?
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'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 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.
My global.asa is not being called.. any idea what may be the problem
View Replies View RelatedI am getting the below error when i am calling function of dll in my asp page.
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'GenerateWelcomeLetter'
/cgi-bin/Anagram_Utils/welcome_letter/generatedoc.asp, line 72
dim a
a = false
a = welcome.GenerateWelcomeLetter (qry,template_filename, save_filename)
The function in dll is having boolean as the return type. Can someone plzzz tell me what can be the problem. I am using dll for the first time in asp.
My web site HTML comes from a database via querystring e.g. page.asp?pid=55. I have a separate asp search page, search.asp. Its output is retrieved by an ajax call from page.asp and its HTML is then neatly wrapped and styled by page.asp.
I want search.asp to recognise if it is not being called via ajax frompage.asp, but directly e.g. via the address bar (and if so, redirect to page.asp). Do I need to put something into the posted string, or (better) is there an asp method that can do this?
The ajax call is
function GetSearchPage(st) {
var poststr = "searchterm=" + encodeURI(st);
makePOSTRequest('/search/search.asp', poststr,'divFullSearchDisplay');
}
I don't know the exact operators, but it's something like:
a?b:c
Which translates to:
If a = TRUE then
return b
else
return c
end If
I need this for an ASP script.
I have the a function which creates a table of search results from a paramater passed from the page Request as shown below..
<%
GetSearches(unescape(Request("serialNumber")))
%>
Is there a way to detect when this function has finished execution as i want to page a page loader on the page until all the HTML is build and ready for rendering? I have the page loader in a div so when the above function finishes i would like to disable or hide it via Javascript. That bit is fine it's just the how to send a call to the Javascript so the DIV can be hidden is the problem.
I have a logout button for my admin system. I really need on logout, to go back to the login page. This is fine but I also need the session set to false. I could do this via using a secondry page called logout.asp, and place inside that something like session.abandon and a response.redirect. But I do not wish to have a secondry page.
View Replies View Relatedmy web application has user name and password, whenever user logged in i set his status in database as 1 so that only one user can logged at one time with same login and i
write a code to set status to 0 on logout menu, but if session expired then status will remain 1.
i have written code to set staus to 0 in onSession_End sub but it not work all the time. Sometimes it works and sometimes not. So i m looking for an alternative way of doing it
I'm running my script locally and the cookie has been saved on the machine because the login page is by-passed (with the Redirect to "menu.asp" below.
OK - but where is my cookie stored? Or at least give me clue. What will the cookie be called and what text will it contain if:
iAuthorID = 1
iSecurityLvl = 3
uName = "barny" ?
The machine user is "flintstone" and machine name is "W2KPro". The CookieName will be "mABmyASPBlog" ....
I have an .asp file that generates a nav menu.
I have tried and tried to "include" this in the blogger template, so that I can update the menu dynamically, without fiddling with a cumbersome blogger template all of the time.
The question is, does anyone know how I can "call" this file in to the template successfully?
I have tried using <script> tags: something like:
<script type="text/javascript" src="http://url.com/menu.asp"></script>
But had no success.
Does anyone know how I can accomplish this?
When some of the SQL Server stored procedures I have written are called via
my Classic ASP page I have written I get the following error in the cell that
is supposed to be retrieving a single result:
"ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name
or ordinal.
/Default.asp, line 130"
I have no idea why this could be occuring. Some of the other stored
procedures work just fine. Any one have any ideas?
I don't know if this is a truly esoteric question, or not, but I'm
wondering how (or even if) you handle a timeout on a transaction
within a stored procedure executed in a Stored Procedure?
A theoretical example of the stored procedure (sadly, I'm not allowed
to post the actual code):
Create proc sp_testproc @myval int, @outval int OUTPUT as
begin tran
select top 1 @outval= myname from mytable where recid = @myval
update mytable set myname='xxxx' where recid = @myval ...
This is a mix of technologies so I hope I've put this in the right place.
I have a system where people can sign up to a data feed. They place a single line of Javascript on their web page and a formatted banner of products is displayed based on the options they have chosen in their affiliate account.
<script language="Javascript" src="http://www.somewhere.com/feed.asp"></script>
The original system was built by our developer 3 or 4 years ago, and worked fine. However, he built the system using two ASP files - feed.asp which looks like this:
Code:
I got an error saying
Microsoft VBScript runtime error- Error '800a000d'
Type mismatch
/briansforums/default.asp, line 923
also another error called Code: