I'm looping through the source code of an HTML page, looking for links, grabbing the source of those links and saving each one in turn to an HTML page on disk.
This is working fine about 70% of the time, but sometimes it falls over when I try to write the source code as a text file to disk: Code:
I am working on some minor modifications, face uplift and fixing some bugs/problems. This site is done in VBScript and currently is down.
When uploading a file, the following error happens on both my local machine and the development server. Code:
I get this error melding >>>Invalid procedure call or argument: 'InStr' and this is the code where this error refers to:
If (InStr(r, UCase(strRetVal), "<TABLE>") > 0) AND _(InStr(r, UCase(strRetVal), "<TABLE>") < _
InStr(r, UCase(strRetVal), "</TD>")) then ThisCellText = mid(strRetVal, StartCellText, _
InStr(r, UCase(strRetVal),"<TABLE>")- StartCellText )
Else
ThisCellText = mid(strRetVal, StartCellText, _
InStr(r, UCase(strRetVal), "</TD>")- StartCellText )
End If
in this area i am doing something, can anyone plz direct me and tell whats wrong?
I have been modifying a forum I found on the web for a web site I am developing. Everythiing has been going great (www.tastytuscany.com/forum) until I yesterday when I hit a brick wall. There seesm to be an issue with the email functionality. The author wrote a "send_email" function that I just can't figure out why I keep getting this error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
/forum/admin/functions/functions_send_mail.asp, line 158
In the script for the email function, here is an excerpt of the code (he uses a select statement for various email types...) and a call to the function from a page. Might I just modify that include file with my own CDONT script? I use cdonts on other pages in the site just fine? BUT, I would really like to get this to work.. Code:
I am receiving the following error from the simple script below. This works
fine from a .NET form but when I access the dll from a Classic ASP page it
fails.
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'GetGroups'
Code:
I am new to working with ASP and I would like to know
the code to create a textfile on the serer and then write
something in it using ASP.
I'm writing data from an access db to a text file then emailing the text file. Everything works fine but it needs to tab deliminated. Can some one post the code for a "tab"?
View Replies View Relatedhow to write (String data) to a text file from an ASP page?
View Replies View RelatedCan this be done? For example, in the line below. There may not always be a & objRS("ShippingAddress2") and I'm wondering if there is a way to use an if/then in there some how. If there is no data in that field then I need to pass over this part completely & objRS("ShippingAddress2") & "|"
I'l have several instances where I need to do this Code:
fname.WriteLine("hd2|" & objRS("ShippingName") & "|" & objRS("ShippingAddress") & "|" & objRS("ShippingAddress2") & "|")
i found this piece of code from a site and it claims that you could create a text file into directory "c:test.txt" and writes the line Hello world in it. Code:
View Replies View RelatedI have the following file whatnew.txt on my server! It consists of lines each line hase 3 items seperated by commas like this:
item1,item2,item3
item12,item22,item32
...
...
I need the code to add new items to this file using the browser!
I'm having a hard time to open/write to a txt file from a .asp, the code is right, but, looks that the iis 5.0 is messing with the file system.
once the execution gets to the point of :
Set filetxt = filesys.OpenTextFile(sFilePathAndName, ForReading, False)
the browser just hangs forever, If I do the request to the same .asp several times then the IIS hangs, and can not even stop the service(a bug in IIS). Code:
I have an application which was successfully writing data from submitted forms to a text file in a directory - in this case:
/data/findata.txt
This was fine because the forms lived at the root level with this directory.
Since then I have added enabled the forms to be used on subdirectories :
/subdirectory/myform.asp
I've used the same code for server.mapparth("data") etc - but instead of locating the directory at the root of the server called "data" it looks to the current directory- doesn't find it and creates another! eek!
What I need is a way to say "right, it doesnt matter what level you are at at the moment, always look at the root level /data directory"...
This has to be fairly dynamic - on the development server here its got a different file structure than on the live server (ie, it lives another level down again on the physical drive)...
Anyone got a good idea on how to look back up?
I do have one way to test which level they are at - but I feel that its a bit 'weak' - I have an ID that tells me if they are working on the upper or lower levels (ie, anything other than 1 is a lower level) - whilst I realise I could use this in the test I'm not sure if its going to be 100% fool proof to base this criteria on this ID.
Therefore I was hoping for a better way using the server.mappath etc...
I'm having a hard time to open/write to a txt file from a .asp, the code is right, but, looks that the iis 5.0 is messing with the file system.
once the execution gets to the point of:
Set filetxt = filesys.OpenTextFile(sFilePathAndName, ForReading, False)
the browser just hangs forever, If I do the request to the same .asp several times then the IIS hangs, and can not even stop the service(a bug in IIS).
I'm running w2k pro, w/IIS 5.0
Here is the code:
Does anyone know if it's possible to write and retrieve variables from a text file??
I know how to use the FSO to create text files and write data to them etc. I just don't know how to write a variable to a text file, and retrieve it at a later date??
I would like similar functionality to a cookie. The reason I can't just use a normal cookie is because the data needs to be permanent and I can't risk the cookies being removed off a users machine.
Here is what I have setup:
- a form that updates a text file.
- for example, in the form I have two fields, title and story. then, this write to a textfile (i.e. theinfo.asp). the update.asp file looks like this:
TSO.write "<%" & vbCrLf
TSO.write "title = """
TSO.write Request.Form("title")
TSO.write """" & vbCrLf
TSO.write "story = """
TSO.write Request.Form("story")
TSO.write """" & vbCrLf
- so, essentially it is creating an asp file with two variables.
- this works fine, it updates the file and i can call these variables in other pages. however, when i call these variables into a form : old versions of the variables populate the form: Code:
i had a vbscript that will read the text file from the bottom to the top, and after reading the file, it will be displayed in the screen, and the code look like this:
PHP Code: Code:
I'm trying to access a stored procedure The stored procedure works fine when run from the server) the code:
View Replies View RelatedI'm having an "ocassional" problem with a script. I have been unable to duplicate the error on my mac or pc but it's happening to about 5% of our customers.
The page is called add.asp It takes the info from a form, sets a cookie to track the customer, adds the purchase info to the database and redirects to the shopping cart (cart.asp) Code:
when i try to write a procedure in asp file i get error message, Please explain whats wrong in my coding?
<%
CREATE PROCEDURE ProcedureName_1 AS
select * from table1
%>
Error message:-
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/sixsigma/installation_region.asp, line 2
CREATE PROCEDURE ProcedureName_1 AS
I would like to know if anyone knows how to execute a stored procedure from ASP.NET 2.0. I'm using the NorthWind database and I'm trying to execute the "CustOrderHist" stored procedure. The error I get is "Incorrect syntax near 'CustOrderHist'. "
Public Function GetCustomerOrderHistory(ByVal customerid As String) As
SqlDataReader
Dim conn As New SqlConnection(conString)
Dim cmd As New SqlCommand("CustOrderHist", conn)
cmd.Parameters.AddWithValue("@CustomerID", customerid)
conn.Open()
Dim dtr As SqlDataReader =
cmd.ExecuteReader(CommandBehavior.CloseConnection)
Return dtr
End Function
How do I call a Stored Procedure with ASP?
View Replies View RelatedIs this the correct way to read a variable from a stored procedure
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "sp_Supplier"
Hi i'd like to know what this line in a asp page does ?
cmd.Parameters.Append cmd.CreateParameter("Supplier",adVarChar,adParamInput,10,sChangeSupplier)
I have a Stored Procedure (SP) being called by my ASP page, but nothing is being executed. The SQL Profiler shows a RPC execute, but the actual SP is not executing as nothing is being inserted.
If I run an EXEC in Query Analyzer, with the same data being passed, it works fine and returns my OUTPUT. The SQL Profiler shows all the hits to the database then too. Code:
I'm trying to call a stored procedure(package) from asp/vb using following
code but I got the error message. What's the correct syntax for oracle stored procedured? Code:
I'm trying to call a stored procedure(package) from ASP/VB using following code. But I got the error message. Code:
View Replies View RelatedMy system is on a NT4 (w/SP6a) running IIS 4. I am developing a page that query one record from my Oracle DB 8.1.6 on a separate machine. I am using the MS ODBC for Oracle drive. In my ASP page I have (Connection object has been crreated.) then..
View Replies View Relatedhow to write a text file to a mapped drive or network drive. In my script, I’m currently writing the text file to a local folder on the server temporarily until I can figure this out.
So far I have tried to use the mapped drive letter, network path, etc. to get this working. I believe all the permissions are in order (I hope) as well. No matter what I have tried, I just get a Path Not Found script error. I know this has to be possible, just I’m missing something … probably something right under my nose but I just can’t figure it out.
I am just wodering in asp program, if there is anybody writing store procedure for inserting data into database since there are so many parameters need to be passed into store procedure(assume there are many columns in the table).
I need to insert data into two separate tables, the relation between these two tables is 1 row of data in table1 could have multiple rows in table2 related to table1, but if the data insertion into any one of the tables is failed, the transaction will roll back and no data will be remained in any of the tables.
If this needs to be handled in asp program using transact sql, how do I implement it. If I need to it using store procedure, how do I pass the error or success signal to asp program from database.
How do I write the code for a button that will call a function/procedure in ASP and delete all records in an array? Should I use a function or procedure? Anyone who would like to finish this code? Code:
View Replies View RelatedI really don't know what's happening now with my IIS, it's really annoying me, before, when I'm accesing my asp page, I got the "ActiveX component can't create object" error and that's pointing to the line of "Set objConn = Server.CreateObject("ADODB.Connection")".
And I think the registration of my components are fine. I already reinstall my MDAC 2.8 but still no luck, then I used the IIS lockdown tool and now I can run my asp pages. But there's another problem, when I used to process my first page to the second page...
It really takes a long time to process and nothing happens, and when i refreshed the page or close it....I got now this error msg "The remote procedure call failed and did not execute".
That's what I get when I try and view "default.asp" on my server.
EVERY other page works except that and no, it's not the ASP code since it works fine on our web host (uplinkearth.com) as you can see here.
Why does it do that? The service is stared in Services, along with the Locator...why shouldn't it work? It just started doing this not to long ago for no good reason (of course, we all know NOTHING happens for 'no good reason'). Any ideas?
If I type it in (http://frontier/) it doesn't load, so I 'Stop' it, then refresh and gives me that message...
I'm using Windows XP Pro with IIS 5...all service packs and updates installed along with mySQL.
is there any component to make it.. i want to make user registiration page..
in this page i want to place a image which has a text and a user must be
type this text to a text box and after that i will check the textbox value
and image text value.. how can i make it.. do i need a component. if there
is a component what is its name .. and i need a free one...