I'm trying to update an NText field in SQL 2000 using Classic ASP. Here is the code I'm using to do it. Any one have any pointers on how to maybe speed it up? Or am I stuck with it. set Cnn = server.CreateObject("ADODB.connection") Cnn.ConnectionString = Application("Cnn_ConnectionString") Cnn.open set rs = server.CreateObject("ADODB....
I'm trying to find a way to capture the response of ASP templates for testing purposes. After reading this post i was hoping that the following code would provide a solution: class cMockResponse public data public sub write( value) if isempty(data) then data = "" data = data & value end sub end class class c...
I am getting error trying to run my asp code for executing stored proc. my code is: Set conn = server.createobject("ADODB.connection") conn.open Set rs = server.createobject("ADODB.recordset") strSQL = "exec spActiveEmployee" rs.open strSQL, conn, 3, 3 I am getting an error that says: - "Either BOF or EOF is True or the current reco...
I'm trying to implement a REST interface under IIS5.1/ASP-classic (XP-Pro development box). So far, I cannot find the incantation required to retrieve request content variables under the PUT HTTP method. With a request like: PUT http://localhost/rest/default.asp?/record/1336 Department=Sales&Name=Jonathan%20Doe%203548 how do I read...
For some unknown reason, when I try to read the RecordCount property from an ADODB.Recordset object in ASP it causes strange data corruption that doesn't appear to follow any particular pattern that I can find. I'm using ASP to connect to an Oracle 10g database. The following is the code I am using. c_objRS.Open strSql, objPage.objCn,...
I've created a pseudo user control for a site written in classic asp. The control is simply an asp page (with full HTML headers and body) that resides within an iframe in the parent page. The point was to create an AJAX-like interface for uploading files asynchronously (the parent page contains a large form and I didn't want to have to...
I know it's a simple question, but I can't seem to drag it out of Google noise. I know .NET can use a session state service or a SQL database to back its session state, but I don't know if ASP offers any out-of-process options for storing it. Does it have any, or am I stuck with losing session variables on ASP applications when a load-ba...
Clearly, when GROUP BY clause used, columns that are not aggregate function should be part of the group by clause. The problem here is, I cannot contain HTTPADDRESS & DATEENTERED columns in GROUP BY clause. Also, I dont know a function that will give me the latest entries of all. edit: I use sql-server. I would use LAST function if I w...
I am trying to list last visits per hour in last 24 hours. I thought the following code would do it, but I get the outcome below. Any idea where I screwed it up? [,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0],[,0], Dim ListHours() HoursInCurrentDay = "24" Redim ListHo...
I want to track IP addresses visited my website. I want to know what time and what page they visit. I store ip address in VISITORIP, date entered in DATEENTERED and page URL in HTTPADDRESS columns. I want to group them by dates. My outcome should be like: TIME PAGE 7/12/2009 3:16:27 PM ?Section=products&SubSection=...
What is the best way to save data in session variables in a classic web site? I am maintaining a classic web site and want to be able to allow my users to demo all functionality of the site, this means allowing them to delete records. The closet example I have seen so far are the demos of Telerik controls where they are saving the data...
We're looking for a good way to stop fraud on our website. We have a site with constant traffic coming in - we have regular access to the normal info (IP, session, cookies etc), plus info that the users have provided. We need to be able to detect duplicate users in real time. Basically, people are coming in pretending to be different pe...
Hi I would like to monitor all the requests made to remote server. I was thinking to create a local proxy server, make all the requests to my local server and then server connects to remote server. There a millions of other ways to solve this, but currently there is no better solution for an big and old asp site and slow and old develo...
Hi, I need to convert uploaded binary files to base64 string format on the fly. I'm using ASP, Vbscript. Using Midori's component for base64 conversion. For small size files (<20K) the performance is okay. But when it exceeds 75 or 100K, its totally lost. Is there any efficient way to convert big binary files (2MB) to base64 string form...
I take This Week's Revenue and Last Week's Revenue values from the server and save them as: RevenueThisWeek = objRevenueThisWeek("REVENUE") RevenueLastWeek = objRevenueLastWeek("REVENUE") Then, I calculate percentage of them as: RevenuePercent = RevenueThisWeek - RevenueLastWeek RevenuePercent = RevenuePercent / RevenueLastWeek RevenuePe...
How can I convert a windows-1255 string to utf-8 in clssic asp? My database is windows-1255 and i want to transfer my site to utf-8. Thanks and sorry for my English. ...
Hello programmers, I have a form in ASP. User can add new values in the input form and press Save button to save the record.On clicking the view button,the updated values aren't entered.To display the updated values, a page refresh is required.Is there a way to get the updated values without having to do a manual refresh.Any help would ...
The company I work for has decided to join the 21st century and upgrade our main database cluster from SQL Server 7 to SQL Server 2005. As a web developer what new whiz-bang features of SQL Server 2005 should I get excited about or get to know? Currently I'm mainly writing CRUD style queries, pretty much exclusively using Stored Procdur...
I'm trying to dynamically create a PDF from a background image and some text from a database. When a user visits our site, they can click on a button to print a voucher that can be redeemed in store. The voucher consists of a background image and some text printed over the top of it; Name, Voucher Code (generated from a hash algorithm) ...
I have a client who has an ASP shopping cart (classic asp) and a Windows based point of sale system both using their own SQL Server databases. The maker of the Windows point of sale system has a utility that will export the inventory as an XML file and will also retrieve any sales from the shopping cart if it is in their special XML for...