I use filesys.createTextFile to create a csv file. If I have about 600 rows(10 columns) then I can see the csv file created. But, if I have about 700 rows(10 columns still) then the csv file not created. I repeated many times and the result is the same. Is there a limitation on filesys.createTextFile?
I know how to do GetRows paging and the like with a recordset, but does anybody know how to do paging with the FileSys object? Basically I use the FileSys object to list the pics that I have uploaded to my site, but as this library grows I'd like to break it down into say 10 per page. Does anybody have any code for this?
I want to create a text file,I have read numerous tutorials about this, the problem is when I try to create it,I get an error message saying that I don´t have permission, does anyone know how I can change the settings so I can do this? I´m running my test asp on my local mashine.
I am pulling info from a couple of different tables and writing the info to a formatted text file. Some of the info is pretty staight forward but I can't get my head wrapped around this last part. I'm looping through the items ordered but each line I write needs to be numbered. The bold number needs to 1,2,3,4, etc for each line thats written ("dt|1|" & objRS("SKUid") etc...).
I am trying to create a dynamic CSV file via FileSystemObject.CreateTextFile. I have no problem creating the CSV file normally but I would like to insert comments and VBScript into the coding.
Normally, the file would look something like this: .....
I develop a website on my local computer in ASP/SQL SERVER 2000 in XP PRO OS. The CreateTextFile, DeleteFile and OpenTextFile (for appending and also just for reading) functions doesn't work.
I had done all security rights from IIS (read, write, execute) and I shared the folder with all rights in reading, writing and executing. I don't understand why this functions doesn't work. I have no error display but the script never stop.
I am trying to execute the following function which performs four tests to make sure the current environment is capable of uploading files. Test 1 completes ok, but test 2 results in the page hanging indefinitely.
An error number is not returned (it just hangs on the line: Set testFile = fso.CreateTextFile(fileName, true) ). However when I execute test 2 using VBScript from within an Excel macro it creates the text file without any problem. Code:
When an introducer is logged onto our site, I want to create a separate directory for them and place in this an index.asp page that will redirect including a variable to identify them.
I have created the folder with no problem, but when I try and create the ASP file, I'm getting errors. Code:
I am having problems with serving an excel file to client web browsers. I am creating a tab delimited .xls from a recordset. Below is the .asp code. Code:
I am trying to figure out how to create a registration form that can limit that amount of people who are signing up for an event.
The form has to take in consideration the number of guests the attendee is bringing table seating location. How can interact with the database in order to do this. I know how to create a form and send that information to a database.
I have a web application that query and insert record into a remote DB2 database. It has an ODBC setup pointing to a remote UNIX DB2 database server. The problem that I ran into today is that IIS created too many DB session which max out my limit at the DB2 side. I see a lot of "mtx.exe" when I check the db applications of the db server.
Even thought I close my db connection after each query, it seems to stay around and occupying a session on the DB server. So I ended up with a lot of people with failed insert or login because there are no more available session on the db server.
So my question is how can I set a limit on the DB connection? How can I make sure "mtx.exe" disappear after a query? What other option do I have?
I've made an ASP page that use a VB6 ActiveX EXE with a CreateObject. Initially, this page work fine. The object’s reference created with the CreateObject are saved on a session variable for reuse it on many page. When many users call this page and many instance of the ActiveX EXE Object are created, the CreateObject command fails with a 429 error (ActiveX component can't create object). The class (in ActiveX EXE) are MultiUse, then only a single EXE are running. Terminating the EXE with Task Manager then the CreateObject will get to work again.
I'm pulling product descriptions from the database and would like to limit the number of charcters that is displayed. Also, I'd like to add ... at the end.
Something like: This long text is boring blah blah blah
I'm starting in asp and I'm trying to do a simple sql query to display a number of records on a page using the limit clause. I keep getting a syntax error in my from clause. Here's what I'm doing:Code:
rstProd.Source = "SELECT * from TBL_PRODUITS LIMIT 0,10"
I have no problem using this clause with PHP so I was wondering if there's some restrictions with it in ASP??
I've got a small problem with my ODBC query that I'm unable to resolve by searching google. I need to limit my query so that it only returns a certain ammount of rows, for example 10.
I have tried the MySQL type query and that failed to work. Then I found an example on the internet in what looked like a weblog which said use "select top 10 * from tblname". Although this fails to work it does limit it when it feels like it. Often I'll get 11 or more results, but if I decrease the 10 to 4 for eample it still returns the same 11 or more rows.
its there anyway via asp i can get around the 255 character limit for url strings.. its for use in a cms/eshot system. on a mailto: link i want to create a string of email address for the client and then send from there own inbox.
I am having a problem uploading large files through ASP.We have several sites in IIS on 1 application pool.I was able to use MetaBase Explorer and increase the AspMaxRequestEntityAllowed value in /LM/W3SVC, and for at least 1 of our sites, it worked. Unfortunately, on our Intranet site, the error persist. Does anyone have any idea why? We do have ASP.Net installed on this server, but the error is explicitly ASP.
Searching for answers I found that another value, MaxRequestEntityAllowed, could also be responsible. Unfortunately, this value is not anywhere in our metabase.xml file, and I am hesitant to simply create it.
I think an url variable could be limited, maybe someone know the maximum length I can use ? (I try to send an html code with the get method, maybe some symbols could not be accepted in url).Is this length limited for a variable or for the url string ?
We're running Windows 2003 Enterprise Edn.with IIS 6.We'd like to limit the access to two of our ASP apps to those who are on the domain--without using the integrated domain authentication popup.
In other words,we don't want users on the domain to have to log in every time (or even once);those not on the domain would not see the site at all. Is this possible?How?
I have a Visual FoxPro table with Memos fields, and when i insert into the table a value that cames from a TEXTAREA field on a form, give me an error. Why? if the table field is MEMO?
is there any reason why i can view a page at work (which is on our server) yet when i view it online from the domain name (some pages are hosted, some are running off our server) i get the message: "Redirection limit for this URL exceeded. Unable to load the requested page. This may be caused by cookies that are blocked."
I have exceeded the length of the URL limit. I have a form where I send data using GET method. Now I have to change method of posting data into POST method. But please tell me how to get data after passing them, because when I call
I have some calculations in my query string. Is it possible somehow to get a results of those calculations not in decimals but in integer in the query itself.