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 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'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 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.
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 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.
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 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.
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 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 think I wrote the Like part wrong. Code:
rssearch.open "SearchTable WHERE Path Like '" & console & cheatquer & ".asp""'", conn, 3, 3
I'm getting a "string could be truncated" error at the line where my
strSql is executed ( my_conn.Execute (strSql) ), but it doesnt happen
all the time, just periodically. I used to have this pointing to an
Access db, but I changed it over to Sql, getting rid of the # datetime
delimiters and replacing with ' . Wondering if the first StrSql string
in the if statement if too long: Code:
I got this error :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x57c4 Thread 0x3474 DBC 0x1234284 Jet'.
/cs/DBConnection.inc.asp, line 25
The code for DBConnection.inc.asp ;
Code:
some code inside my project:
<%
atitle1 = Request.Form("title1")
atitle2 = Request.Form("title2")
response.write(atitle1)
response.write(atitle1 & atitle2)
response.write(atitle2)
%>
returns not 4 but 2 values from atitle1 and atitle2...
In a separate asp file it works fine but inside my asp-page - as I described. Maybe somebody can recognize this situation. Why does it happends? Also, set obj = Server.CreateObject("InvalidProgId") don't give an error, just skipped by compiler with any call to obj too.
i have a connection string (this all in asp )
tCSCst = Provider=SQLOLEDB;Data Source=<bd>;Port=1444;Initial
Catalog=<cataloge>;User ID=<id>;Password=<password>
Set testCaseServerConn = Server.CreateObject("ADODB.Connection")
testCaseServerConn.Open tCSCstr
but i get the following error:
An error occured:-2147467259 - Invalid connection string attribute
the problem seems to be the port itself, if i use 1433 then it works
I am facing a problem with MAPI.SESSION for server.createobject in a ASP page. I am getting a message as "Invalid class string". I checked up the registry and found no entry for the same. So I used regsvr32 and registered the cdonts.dll file. But even then there is no entry in the registry and I am getting the same error in the asp script.
View Replies View RelatedI am trying to utilise xmlhttp for my website. I have been told that it is on the server (don't have access to the actual server so far as installing components etc.).
But I keep getting an 'Invalid Class String' error.
Is there a way to list out the valid class strings or list the components on a server from a normal asp page (so I can see what is/isn't available).
What are the different alternatives to the line...
[VBS] Set xml = Server.CreateObject("Microsoft.XMLHTTP")[/VBS]
that may be substituted depending on the version of it? Or is there another alternative to xmlhttp that will provide me with the source of a page on another server that may already be installed...?
I am using Dreamweaver MX 2004, and I am having one heck of a time connecting to a SQL Server DB. I can connect to the DB when I am using an ASP page and connecting with a local DNS, but I cannot connect when creating an ASP.NET and trying to connect with either an OLD DB Connection or a SQL Server Connection.
I am actually getting a "Connection Successful" when I am connecting with the OLE DB but as soon as I hit "OK" then no tables are found. When I try and test my connection once I out of the OLE DB connection GUI I get the following Error:
HTTP Error Code 500 Internal Server Error - This is very vague, and none of us can seem to figure it out. Anyone else have this kind of problem?
Can't find anything in MSDN that explains this ASP error; I'm trying to post data into sql dbase, and this error points to the SQL execute line. Code:
View Replies View RelatedI'm working on a page so that a user can change their password. I thought might be a simple update of a database, but everytime I do it I get the following error message. I've put x's where my ID would be showing for security purposes. Code:
View Replies View RelatedI'm passing a unique identifier from page1 to page2 to page3 querried from MS SQL Server. When I pass the value, it puts the value in the curly brackets. (Page1 is for display and Page2 is for edit and Page3 is update edit)
When I go to Page3, it gives me an error saying "Syntax error converting from a character string to uniqueidentifier" {7171B9BD-4599-43D9-9521-3DA583A1BB1A} This is the value and the error page says "id=%7B7171B9BD-4599-43D9-9521-3DA583A1BB1A%7D" It seems tp put "%7B" and "%7D" for "{" and "}". Has anyone seen this?
I'm also passing numbers and text and they don't seem to have this problem, just the unique key.
if my month is represent by numbers. like 2, 4, etc
i recognize this as a string but then i want to store it as int
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '2, 2, 2' to a column of data type tinyint.
/ords/asp/custorder_view.asp, line 41
u can see the varchar value to colum of data type tinyint
I'm not a asp expert and only use the built in Dreamweaver stuff, the problem I'm getting is a datatype mismatch due to the fact the sql statement is expecting a text string and not a number string, can anyone have a look at the following code and point me in the right direction in regards of what I need to change so the sql statemnet know to expect a number string: Code:
View Replies View RelatedI am trying to create a comments form with html and have it sent to my email address from the website via ASP. I keep getting an error message that says:
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/myapp/email.asp, line 3
Invalid class string
I've examined my line 3, and I cannot see the problem. Could anyone tell me whats wrong with the codes, or must I have a separate database to house the contents of my forms as well?
Heres the code:....
What do I need to do to enable CDONTS om my macine to make it working
I'm testing the code:
Dim objCDO
Set objCDO = Server.CreateObject("CDONTS.NewMail")
objCDO.To = "xyz@xxxxx.com"
objCDO.From = "zyx@zzzzz.com"
objCDO.Subject = "TESST CDONTS MAIL"
objCDO.Body = "SOME TEXT TO SEND OVER"
objCDO.Send
Set objCDO = Nothing
It gives me an error after Set objCDO =
Server.CreateObject("CDONTS.NewMail")
Server object, ASP 0177 (0x800401F3)
Invalid class string
I'm developing an Asp.NET system to take a CSV file uploaded via the web, parse it, and insert the values into an SQL database. My sticking point comes when I try to split() the string returned by readline() on the file.
The following code snippet works for me:
tokens = "one,two,three,four".Split(",")
for each token in tokens
response.write("<td>"+token+"</td>")
next
However, if I take the next line in the CSV, read using StreamReader.ReadLine on the PostedFile.InputStream, I receive "Object reference not set to an instance of an object." which I have narrowed down to be my string holding the line. Further investigation reveals that no other string member functions work on my line (.ToCharArray, .ToString, etc).
I suspect that StreamReader.ReadLine is not correctly returning a string, even though Response.Write(line) displays what I would expect .....
I have a form in which several elements are expected to be all digits. Some of those elements can be left empty, but if specified they must be all digits. I have this Sub to edit them: ....
View Replies View RelatedI am pulling info from a sql server By default the query pulls back the inforamtion as text.Therefore when I go to calculate some figures its giving me a type mismatch error.
Is there a function in can call to convert a text string to an integer string using
rstSearch.Fields("name").Value .To pull back the info in a for loop
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch
I got an error saying
Microsoft VBScript runtime error- Error '800a000d'
Type mismatch
/briansforums/default.asp, line 923
also another error called Code: