I'm trying to figure out why the Left function doesn't seem to work.
One of the pages fails with an error:
Microsoft VBScript runtime error '800a000d'
Type mismatch
/status.asp, line 45
Line 45 is:
response.write Left("This is A Test!", 6)
Where is the Type mismatch? All my references say this should work, and give me "This i" as output. The Right function doesn't work either. But the MID function does work.
I need to create better search results. If people enter 3 words (ie "Search for this")
I was thinking of splitting them up and search for "Search", "for", and" this" separately. IF ANYONE KNOW OF A BETTER WAY PLEASE LET ME KNOW.
heres what i need help with
algorithm
-------------------------------
split string at spaces.
create a SQL string that searchs "LIKE '%search%' OR LIKE '%for%' OR LIKE '%this%'"
-------------------------------
i need help with spliting the string and counting how may new strings there are.
I'm looking for a string function to take a url and pull out the word between the dots, for example the url http://www.example.com would return the word example. The only criteria is because I don't know how long each url is I need to extract the word between each dot.
View Replies View Related6408373-SALE-11/1/2007
From string, i want to extract "SALE"
How to do it using mid and Instr ?
Also,
6408373-DECLINE-11/1/2007
From string, i want to extract "DECLINE". How to do it using mid and Instr ?
I wanna know all String function reference in ASP and ASP.net. Is any website provide this information?
and Is string function in ASP and ASP.net has same.?
This example outputs "XMLString = Data 1Data 2." When I pass XML string in ASP, i
will output the data only, without <data> anymore. Then how can I retrieve the data one by one? .....
In the ASP page that is in question, I build a large string (no more
than 10K) which is basically an email template in HTML format. Then I
replace the parts with the values, which are also strings with the size
of 1-2 KB. Code:
I have a string --> 7,8,9,10. This string may contain more or less than 4 numbers.
I want to separate each number and run an sql query for each number.
for example:
select * from table1 where code = '7'
select * from table1 where code ='8'
and etc....
Can I do this in a loop?
What's the difference between private and public functions in ASP? When should I use either?
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 am using a simple guestbook /portal and i want script to send mail to the thread owner when someone reply his message.
this is the send message code ....
i use a IIS 5.1 with win XP with the newest updates etc.
its possible to start aspx and html files but not asp files
what could it be ? what can i check ?
Can a ASP work like a CGI.(Email Scripts) ? Can a ASP script for email will work, if a Script is on 1 server and form(html.form) is on another server and a thank you page is on 3rd server. Like if u don't know about a CGI there are many websites who give you permission to use their script by editing little bit in yours form and place them on yours server website, there are number of site.
And 1 more thing I want to ask is if some one use a windows server he have a form html on that server, can he run asp script which is on Linux server to get form result on his desired email id.
cannot using onAfterPrint in IE 6.0, the page can print but cannot close.
Why??
my code like as below
<body
:
<script language="javascript" type="text/javascript">
<!--
window.print();
//-->
</script>
</body>
<!--#Include Virtual="/bug/adovbs.inc"-->
<title>Bug Status Board</title>
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog =
techsupportBT; User Id = sa; Password="
Set rs = server.CreateObject("ADODB.Recordset")
sSQL="SELECT T.BugIndex, T.[Date Entered], T.DESCRIPTION,"
sSQL= ssql &" T.Company, T.Technician, T.Developer, T.PROGRAM, "
sSQL= ssql &" T.Status, T.PRIORITY, T.[Version Fix], n.noc"
sSQL= ssql &"FROM TSHIGHISSUES INNER JOIN noc ON T.BugIndex =
n.bugindex "
set rs=conn.Execute(ssql)
and this is the error message that I get Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Incorrect syntax near the keyword 'INNER'
I cannot find an example anywhere that helps with this situation. This works fine in SQL, but for some reason asp is being a pain.
I copied ASP/VBScript code from several sources and adapted it to my page and variables. Here is my current code for implementing CDO:
View Replies View RelatedI am trying to construct a sub procedure that concects to db , executes a stored procedure and returns a recordset. Connection to db and executing the stored procedure works fine.
The problem is that when I call the sub in the asp page to be executed the recordset is refused to be returned from the sub and the recordset itself does not appear to be constructed. or in another words the error displayed is: 'object required' --> refering to my recordset --> 'rs'
I do not know why, can any one tell me the reason, I tried much but with no result.
NOTE: For testing puropses I looped through the recordset isnide the sub itself and it worked fine Code:
Is there somebody who can explain to me how I can use a Global.asa to store Functions and Variables in it? I understand that there are 4 events that can be used in a global.asa : Application_OnStart, Application_OnEnd, Session_OnStart, Session_OnEnd
But still i don't get how i can CALL functions of variables. Because with those 4 things they start all in the beginning or in the end of a session or application.
For example i use an encrypt function in different pages, can i just put it in de global.asa and call it when i need it?
I've just moved all asp file from IIS4/5 to IIS6(2003), but they don't work.It there any trick?
View Replies View RelatedI need to provide a pulldown with work weeks displayed.Is there any easy way to do this?
I would like to go 6 months from the current date and show a week as Oct. 11- 15.Which is Monday to Friday.
I have an asp page. In this there is a form when submit it have to chech if the fields are not emtpy.When it not empty it wil insert into a database an a mail.If a field is empty it send it anyway, it doens't do the validation. Here is a part of my code:Code:
<% if request("action") = "Verzenden" then
datum = request("dtmmeldinghelp")
if datum <>"" then
'I have tried also: if len(datum) <0 then
response.Write("<html>" & "<body>" & "Fout" & "</body>" & "</html>")
else
' here come my sql insert to code and the code for email
' this works fine
%>
i built this test program:
<HTML>
<HEAD><TITLE>Test</TITLE></HEAD>
<BODY>
the time is <% = Time %>
</BODY>
</HTML>
It does not show the time! very basic probably but not for me.
I am trying to add a button to a menu which it's action is conditioned by a session variable. The button shows up fine but I get no action from the button being clicked . The variable does have a valid value. If anyone can help me out with this it would be greatly appreciated. The code follows:
<input TYPE="submit" NAME="Button1" VALUE="Quote Generator">
<SCRIPT LANGUAGE="VBScript" FOR="Button1" EVENT="onClick">
If Session("RVQuoteAuthority") = "Y" then
Response.Redirect(Quote.asp)
else
MsgBox "No Authority"
End If
</SCRIPT>
Talking about the cdonts objects.. i want to send the email in windows xp..
i downloaded cdonts.dll and registered it.. but still i am not able to send
the mail.. is it so that i need to set the settings in the Virtual SMTP server
in IIS ?
I have not been working with ASP for too long at this time and am not real familiar with a lot of things about ASP. I have searched for articles on the following question but
not come up with any definite answers. Code:
I am trying to get ASP to work with IIS and i keep getting page cannot be displayed when i try to open asp pages? Do i have some settings wrong somewhere?
View Replies View RelatedThe problem is, even when i set the LCID property at the
beginning of my code, it always returns the date in
brazilian date format. Example:
<% @Language=VBSCript %>
<% Session.LCID=1033 %>
<% Response.write (now & "<BR>" & Session.LCID) %>
This code should return:
MM/DD/YYYY HH:MM AM or PM
1033
But it´s returning:
DD/MM/YYYY HH:MM
1033
Do you see? The LCID is correct but it keeps showing the
date in brazilian format? What the hell is happenning?
I am using CDONTS to send mail to the user from my ASP application.
However, the code doenst works all the time. I am able to get mails but
nothing happnes most of the time. The code works maybe once in 20 tries.
What could be the reason?
I have the following reference to an image in my web page. The name of the image is simply one Chinese character followed by .jpg.
<a HREF="transfer/rad0/﨨.jpg" TARGET="_blank">﨨.jpg</a>
The Chinese character is HTML encoded. I'm specifically setting UTF8 encoding w/codepage 65001 in each web page. When I right click this URL and attempt to download the image to disk, I get an error saying the web server can't locate the URL. In the error message, the Chinese character is displayed as ? (question mark). It works if the URL has only ASCII characters in it.
What do I need to do to be able to download images via URLs that contain Chinese (Unicode) characters?
i have this css file.
default.css
Code:
#navcontainer ul
{
margin: 0;
padding: 0;
list-style-type: none;
}
when i put both codes at 1 file, everything are ok, but when i separeted them into different files, nothing happened. what's wrong with the code?
i have this if endif condition but it doesn't seem to work
if date = "12-06-2007" then
response.write "its december 6"
else
response.write "its not december 6"
end if
and i try this also but its not working either
if day = "6" and month = "December" and year = "2007" then
response.write "its december 6"
else
response.write "its not december 6"
end if
I am having a prob with getting for example, ASP Free Forums > Programming > etc, to display properly. I can get it to work sort of but need to be able to read in a value and be able to change it before its displayed.
It works on the first page but when going to other pages it doesn't. Also when going back to the original page, topic.asp where it works, from view topic the formatting disapears which is a mystery to me. Here is the code that gets it to work on the topic.asp page:section = Trim(Request("Section")) Code:
I am having ASP with the following code to access the file with windows
scripting host. The page run on local server IIS 5.1 on Win XP Pro SP2. The
IE never show me any error with this, but will keep access the page for very
long. This code is running fine on other system. Code: