I am using a xml parser to retrieve and scan through some HTML from a website so that I can use VBScript operations (Left, Right, Mid, Len etc) to pick out the data that I require from the responsetext.
The code works very well and I am attempting to validate the data that the code finds by comparing it to data in a database. Below is a section of code that extracts race locations from a website. Code:
when it writes the varFault option to SQL, there is lots of whitespace written too!I have tried the Trim option but to no joy
<%@LANGUAGE="VBSCRIPT" %>
<%OPTION EXPLICIT
Dim objConn, strSQL, objRS, varName, VarExt, VarFault, varDept, strSQL1, objRS1
Set objConn = Server.Createobject("ADODB.Connection")
objConn.open Application("helpdesk")
varName = Request.Form("name")
varDept = Request.Form("departments")
varFault = Request.Form("txtFault")
strSQL = "INSERT INTO new_calls (Name, Department, Fault) VALUES "
strSQL = strSQL & "( '" & varName & "','" & varDept & "','" & varFault & "')"
strSQL1 = "SELECT * FROM new_calls "
strSQl1 = strSQL1 & "WHERE call_id= '"'
set objRS = objConn.Execute(strSQL)
%>
Say I have a 'Mc Paul' in the database, what would i need to do if the user searched for 'McPaul' how could i pull that record out of the DB.
View Replies View RelatedDoes anyone have an example of how to replace all whitespace at the end of a string?
I'm trying something like:
do while right(str,1) = " "
str = replace(right(str,1)," ","")
loop
response.write("str:" & str)
.... but it is killing off the entire string ...
what is the easiest way to pull in an html file with asp and parse text out of it?
View Replies View RelatedI need to grab product info including images from specified websites with no RSS or common structure.
I've been searching and reading articles for 2 days and have played around with grabbing html from a site and trying to find out what to do with it at that point. I think I need to parse it for the patterns I'm looking for, (creating an array out of them?) and save that information to my DB. I also want to grab the actual images and display them from my site so that the product suppliers bandwidth is not used by the pics being on my site...
I'm thinking, with my current skills which are limited, I'll be doing this with ASP (vbscript) and javascript (if necessary). I'm not great with those but good enough to figure stuff out eventually.
Can you tell me if you think I'm on the right track and recommend any learning resources specific to the skills needed to accomplish this?
If it's not too much to ask, a bit of pseudocode might keep me on the right track... what to do and when.
My site seems to preload everything prior to displaying itself. I get a white screen for a couple of seconds and then, bam!, its all loaded and displayed.The same happens when the user navigates around the site. In between each page there is a white screen and a delay.is there anything I can do to minimise this white screen delay?
View Replies View RelatedThere is a problem which confused me for a long time. I have a web application built by ASP running on IIS, and most time it's OK.
occasionally when IE send request to IIS and then receive HTML from server it will stop with no reason. IE shows a white-screen and then I check the HTML source and find that only partially received. After I press F5 everything is OK again...
I was calling another asp page from my main page. The another page contains lot of code and processing But after some time my page has turned white and curosr shows that sytem is still busy. Why this happened ?
View Replies View RelatedI have two sites, one is a white label version of another. they both use exactly the same code.
The site that isn't white label works fine. Hover the white label site gives the following error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'left'
/list.asp, line 234
I've looked at line 234 in list.asp and it is just a SQL expression that doesn't appear to have any problems: Code:
I have compiled an activeX dll and pass variables using asp into functions within the dll.
When I test this running the code with Visual Studio the data is output correctly to the browser, however when I compile the code and run the same code the data is different! This is confusing me as to why this is happening....
I always re-start the web service after registering the dll...
Any ideas?
I have a page that lets the users make contact groups and send an email to
them. I have a form that lets the user enter the details of his message
including his full name and his email address. Once this form is submitted,
I do the following to get a string for .From property of the CDONTS mail
object:
Sender = userFullName & "<" & userEmailAddress & ">"
Now I stumbled upon a bug where if the user adds a title to his name (i.e.:
"John Smith, MD"), the address for the recipient gets truncated where the
comma is and the recipents can't reply as the address is now invalid. Is
there a way to encode any special character in the string so that it will be
mailer friendly?
I keep getting an error in coding. I am using Dreamweaver MX 2004 and once I
preview it in IE it works then once I press F5 to 'refresh' it fails again.
The IE error returns this link
http://support.microsoft.com/defaul...Q241271&sd=tech
It regards the following : IIS 5.0 Continues to Return 500;100 Error Page
with Response.Buffer Set to False
Does anyone know what this means and how to fix it?
P.S The previous thing I was doing before the problem was setting up 'data
bindings' in DWMX - to be fair this was somewhat a trial and error approach
and I'm not sure if I've damaged IIS or DWMX in someway.
Can anyone help me with this error?
code start ____________________________________________
Microsoft VBScript compilation error '800a03ee'
Expected ')'
/example.asp, line 142
Private Function FuncDiff(ByVal DateOne As DateTime, ByVal DateTwo As
DateTime)
------------------------------------------^
code end ____________________________________________
I'm running ASP under IIS 6 with Tomcat. During the process, Tomcat will
forward to an ASP page with some data and those data will be written to MS
SQL and display some information in that particular ASP page. The Servlet
has no unsafe code. The strange thing is that all the data is written
correctly in the MS SQL with correct user and related information but the
data might become blank or send to different users in that ASP page.
Does anyone know what might cause this strange behavior ?
I have developed a site for my client,
eg., www.abc.com
I have registered the domain with godaddy and mapped the dnc to my server (Windows 2000)
When i browse that site using that www.abc.com, in one of the pages i found that the session value is lost. This happens only in some machines not same with all. Most of the machines works that site properly. But not the same in some machines. All machines has configured same.
The exact part is
eg.,
customerdata.asp
session("custdata") = request("name")
response.redirect checkout.asp
in checkout.asp
if i give response.write for that session("custdata"), In some machines i m not getting the value.
**MySQL is accessible via ODBC manager and MySQL -Front. I am able to modify the databse. I can not access database from the ASP page that I did not modiy after the last successful interaction with database**
MySQL 4.1/IIS
Everything was working fine until last night PC shutdown to give it a break, was running for a few days. Today, after reboot, the ASP page, and my entire site for that matter, stopped working.
Here is the connection string that was working:
dbPath = "SERVER=localhost;DATABASE=molsonbubba;UID=xxxx;PWD=xxxx;OPTION=35"
useDSN = False
If useDSN Then
cString = dbPath
Else
cString = "DRIVER={MySQL ODBC 3.51 Driver};" & Server.MapPath(dbPath)
End If
Here is the code that throws the custom error (Database is not found) and stops. If I remove the code I am able to get the site up but no db operations work as I get a "HTTP 404 - Page not found error" ? Code:
I just re-uploaded my .asp site to a new host.
But one of my pages now bugs, I get this error message in a Windows alert box:
Redirection limit for this URL exceeded. Unable to load the requested page. This may be caused by cookies that are blocked.
All other pages work fine.
Not sure if anybody has run into this problem. I'm using ASPEmail from Persits to generate an email and send it. The problem is that when I check the email that the asp code sent using Outlook Express or Outlook the email gets cut off 3/4 of the way. If I check the email on hotmail, yahoo mail, any other email program....the email comes in full. Any ideas why this might be?
View Replies View RelatedWhen adding i am checking if that name already exists in the DB and if so i am poping up the message that name already existing.
It is working perfectly in my win2000prof and i have tested in both in my localhost and ftp servers and in both places it is working as i ahve expected.
But when the same application is opened in winxp i have a strange problem coming. When i add a new list , then it checks for the name and what happens is every time i add a new one and even if there is no matching record or matching name avialable for that record, javascript popups saying "Favourite List Name Already Exists" and the strangest part is the insert part also working. That is both if and else part are working together. I am getting this problem only in XP. Code:
A bit of a strange request this, but I do have a reason When using request.form to access a forms elements data, is it possible to btain the elements type.
For instance whether the field (element) its being passed from was a hidden field, a text box etc etc! I've hunted everywhere, and tried lots of variates but I couldnt find anything..
This problem occured just the other day. Whenever I try to access an .asp file on my server with an exact url, I get an error: The system cannot find the file specified.
BUT, if I type in an url to a folder containing a default file (in my case, index.asp) the file is shown correctly .....
Have an ASP page on internet, where I let the user write his email address. Today I see that this text input field has got a yellow background instead of the normal white as the other input fields. The code is quite normal. Using IE 6.0.2900. It has not appeared before. Then I rebooted the computer,but got the same result.When I try another computer, also with XP pro and the same IE, the text input is white as it should.
View Replies View Relatedwhy a ADO recordset.recordcount would return a -1? I have confirmed that it has records in it by writing some values to the screen. Why can't I count the number of records returned though?
View Replies View RelatedI have the simple form as below. When I click it is not getting the form
action from the line inside the loop but from somewhere else in the page.
The page has multiple forms but depending on what the status is various
elements are dsiplayed or hidden. For examples even If I change the
viewpo.asp to nopage.asp it still is displaying the page and going to
viewpo.asp page with the PONumber query string set. Code:
For some reason,, the following recordset rs("w2itd1") will run fine when I'm looping it out on a page, but when I have it inside a sql statement, I get errors.
for example:
sql = " Insert into table (title) values ('"& rs("w2itd1") &"') "
This will give me an error. The contents of this rs is a book title. Oddly enough, however, if I enter any other of the rs("fieldnames") that I have, in exactly the same fashion, I have no problem. There just seems to be an issue with the text coming thorugh. Can someone
indicate what the problem could be?
Using IIS 5.0 and sometime some asp pages (absolutely
randomly) showing as blank white pages. So far only one
way of fixing it - restart whole server. Restarting IIS,
or specific web server not helping, only whole server.
I enable server side and client side debugging, but no
errors showing up...
In view source pages always look like this:
-----------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html;
charset=windows-1251"></HEAD>
<BODY></BODY></HTML>
-----------------------
Any idea why it can happened and how to fix?
I have a Website at work which we use for logs. You must login to access anything. I didn't change any code on one of the 9 pages I have and all of a sudden, the Submit button won't work. I'm totally stumped as to why. All the other Submit buttons work fine on all the othere pages.
View Replies View RelatedI have an access database with lots of fields including a memo field called
'priecinfo'.
Everything works well, lots of data is written, but in one particular
situation, I can't get the field 'priceinfo' to write out:
1) the code below works properly except that the field 'priceinfo' doesn't
get written - replace it with any other field and it works. Code:
I am trying to run the following query:
strSQL ="select * from fn_select_loads_carrier('"& strCarrierEmail &"', DEFAULT, DEFAULT)"
from an asp page. When i run it on the SQLl server it results me a result set. And also in the asp page all the results are getting displayed properly. This is how i am running the query: Code:
I am trying to run the following query:
strSQL ="select * from fn_select_loads_carrier('"& strCarrierEmail &"', DEFAULT, DEFAULT)"
from an asp page. When i run it on the SQLl server it results me a result set. And also in the asp page all the results are getting displayed properly. This is how i am running the query:
Create_Recordset()
obj_RS.CursorLocation = adUseClient
obj_RS.Open strSQL, obj_Conn ,adOpenStatic, adCmdTable
If strSort = "none" Then
obj_RS.Sort = "LoadID, TMSName"
Else
obj_RS.Sort = "" &strSort &""
End If
If Err.Number <> 0 Then
strRedirect = "Error.asp"
response.write "Erro number" &Err.Number
End If
I am getting the Err.Number as 13 and it doesnt display at which line the following error is occuring. But all the results which the database is returning are getting displayed on the webpage.
I have no idea from where this err.number 13 is occuring at. I crossed checked all my procedures and script.
On the same client with different IIS servers I got a different behaviour of the same code. In one environment it opens in the frame and in the other it opens a new window.
Action Codeline: <Form action="show.asp" target="show" method = post></Form>
Show Codeline: <Frameset><frame src="show.htm" name="show" scrolling="yes"></frameset>
Im writing a script that has a lot of "nested" IF statements - it breaks a complicated situation down through a sort of logic system, and when it reaches the end of the tree it performs a certain task - in this case, it writes a row of data into a table.
Its very annoying that the IF statements work exactly as I want/expect them to...but when it gets to the end of the tree of IF's I get the following error: Code: