is it possible to pass an array into an Oracle PL/SQL stored procedure from ASP? I'm trying to upload approx. 15 000 rows into Oracle and for security reasons am only permitted to access the database through PL/SQL. At the moment I've got it uploading one row at a time by looping through but this is extremely slow.
how to create an array of checkboxes that were selected from a form on one page and pass them into hidden fields in a form on the next page? I have this massive project I've been working on and am having trouble with this.
I am trying to pass an array from an asp page (JScript) to a dotnet web service using the SOAP Toolkit 3.0. This is still at the Hello World stage, as you can see: ...
I've been searching for some information on the use of Classes in ASP, but found very little information. I found this http://www.daniweb.com/tutorials/tutorial19997.html . Are there more information somewhere online?
For the majority of my work, I just use plain ASP. On the rare occasion that I am doing something intensive that does require user interaction I might create a COM component (ie where performance gain outweighs the overhead of COM).
A simple Rule-of-Thumb. I imagine this is fairly common practice... (I hope it is, at least).
However, I'm curious about VBScript Classes. I would have imagined that if a page was complex enough to merit defining and creating your own classes/objects, that COM would be appropriate...
In which case, when and how do people use VBScript Classes?
I am re-coding a VB application to be used on the web, some of which requires additional DB components for user registration etc. Usually I use ASP classes to manage the DB I/O stuff but I was wondering whether they are any benefits in having them as VB classes and compiled as dlls?
I like the idea of having the VB application as dlls, but using asp classes for the general functionality of the application. However, I don't wish to do this out of convience for myself.
one developer once told me that he doesn't use classes as there is a performance issue. is this true? the functions i'd be creating can easily go into an include file as a set of functions and not a class. so i'm not too sure about going ahead and encapsulating them into classes. has anyone got any input?
I've been working in .NET for some time now and I don't remember specifically how asp classes are cleaned up in classic asp. I've been put on a Classic ASP project(ugh) and we're having some serious stability problems. Once we reach a point of sustained CPU useage of over 80% IIS 6 restarts the w3wp.exe process which of course terminates all sessions and resets the website.
I've noticed that the previous developer has an include which creates a couple of class objects in ASP. Not third party or "CreateObject" objects, but ASP classes. This include is in A LOT of files and the classes not being destroyed in any of them.
My question is could this be the problem? I seem to remember a problem with ASP classes and not destroying them causing leaks of some sort. I need to mention that the memory doesn't seem to be leaking but the CPU utilization goes wacko as if ASP/IIS is corrupt. My environment is Windows 2k3 and IIS 6. The previous environment was Windows 2K and IIS5. Both environments had the problem.
Before I go through these hundreds of files I was wondering if anyone remember what the problem was with ASP classes not being destroyed.
I've always had problems getting my head around using collections and classes together. Separately, they seem like fairly simple subjects, but I'm getting muddled up when trying to use them together.
Can someone toss together a simple example of how I'd create my classes and collection? Code:
I'd like to create a class file for a shopping cart that I'm working on but I'm not sure about how to use the database with it.
Do I connect and open to the database inside the class or outside of the class and set the properties?
I'm thinking that if I open and close the database with say a getItem() method and I have 15 items to get, I'll be opening and closing a connection 15 times. Isn't that bad?
I write classes in php, beans in jsp, what "modularity" does asp have? Can I write classes? Or "com" what can I do? which advantages exist with these paths: classes, com, etc.
<% Dim objMainItem Set objMainItem = New ItemContent objMainItem.item_id = 1 objMainItem.Open() %
and the class ItemContent creates a recordset based on the item_id passed in. Each item record contains the fields (header,label,content). I would like to reference the fields in the following format
Is there a way to use classes written in .NET in an ASP classic application? Maybe similair to using DLLs with Server.CreateObject? I want to write all our new classes using .NET with the intent of eventually changing the web application to ASP.NET.
I've tried Googling for the answer but I only get ASP.NET literature. Any suggestions for that problem?
I'm currently new to OO programming with Classic ASP and have been stopped dead in my tracks on the issue of validation inside classes and if I should be doing things that way. I have been using a User class and it has methods such as Save(), Update() and Delete(). Particularly with the Update() method I'm unsure if I should be validating my form(s) within the class or on the actual edit.asp page that uses the Update() method?
I have two types of edit pages; one for Admin users and one for the My Account page. On the My Account page if the user wants to change their password they have to enter their current password, a new password and then their new password again to confirm .
If an Admin user is updating that same user's info they do not have to go through those steps and they can simple just change the password by typing it in. The point here is that there are two separate cases of validation rules on two separate pages that both use the Update() method. Do you validate your forms inside your classes or outside?
I've written two classes in ASP (vbscript). Basically I am attempting a form of data encapsulation. The classes are a "master" class and an "address" class. The address class basically wraps a recordset. I've attached the file. whenever I call the "move" method the recordset should be EOF since there is only 1 record in my streetaddress table. If I write out the value of of p_oRs.eof inside of the "move" method it returns true.
I have declared p_oRs as a public variable. But if I access it from a different method (or a property get/let) then the p_oRs recordset is no longer EOF the pointer is on the first and only record.
Say I have a few functions for accessing a database e.g. openDBConn, closeDBConn, openRs, closeRs, getRsAsArray, executeSql, getDbConnString etc
I could put these functions in to an include file "incDbHelper.asp" and include the file in any page that needs database functionality... or I could create a class "clsDbhelper.asp" which again I would include in any page that needs it. Now once the files have been included, to access the functions I could do: Code:
I've read that one shouldn't include ADO objects in the Global.asa for the sake of performance, but would user-defined classes cause the same kind of performance hit? Assuming that they wouldn't, is it possible to do it?
I can't seem to figure out how to include them, nor find any reference to it in msdn.
Is there a way to do this? Or should I create a slew of Session variables? Code:
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
In working with arrays, I have found that I am unable to dimension and array with a variable that has an integer value but I can redimension one this way. I haven't see any information that tells me if this is a requirement, although it appears to be because I get an error if I try it.
Ex.
Dim b b = 10 Dim a(b) ' this errors out but Dim a() ' this Redim a(b) ' works
I want to create a new array called arrNames2 and copy contents of arrNames to arrNames2.
I then want to loop through my db and add more names (while going through the loop) to arrNames2. What is the best way to do this? Do I have to keep redim the array wehn I add more names?
I would like to pass the value %%LAST_NAME%% to another asp document.... I wanted to pass this value by doing a response.redirect, but, it truncates the double percentage signs
I know it works on a SUBMIT example: <form> <input type=text name="lname" value="%%LAST_NAME%%"> </form>
but, I would like to skip the submit and do a response.redirect... even if I create a variable using 'server.urlencode' it still truncates the %% example: response.redirect "newfile.asp?lname=%%LAST_NAME%%"
I'm trying to add a variable to the url that is going to be sent but when it is sent my additions are removed! I've tried numberous variations of action="caldelete.asp?curid=<%=iRecord%>" and every time it removes everything! What am I doing wrong? Code:
The code above passes the value of the "TimberSpecies" to the next page. I would also like to pass the value of the "CategoryTitle" to the next page at the same time.
How can i pass value from drop down list in 1 page to another pagei used onsubmit when i click the value in the drop down list and use request in another page to get the data.but why it still cannot works
I’ve used java script in my asp page for the new windows utility and also for link to .js extension (get calendar). Ok let see what I’ve done…. Within elseif : (see asp comment within coding page).
IM – date – open IM – date – close IM – date – all
What is a problem now, I try to test for calendar function (java script) in “– IM – date – all “.
I can retrieve date from javascript file -> ‘date-picker.js’ and insert date into these two textbox, but when I want to send/pass these two values (click button continue) to next asp page called byDateIMA.asp, browser told me that ‘error on page’. I’ve no idea about this problem. Hope anyone can help to solve this problem.
I have a simple form with a textbox, a combobox and a submit button. I want to also be able to pass the "values" of the textbox and the combobox in the URL. How do I do that? DO I need to set that up in the function? I know this must be simple becuase I can not find any information on how to do it.