Search results for query: *

Hi I am testing an old VB6 application under Windows 7 and code that has been working fine for years is now failing. The code below updates order detail lines that have been entered via a grid. The grid can include old rows and newly added rows. The order detail table has a primary key...

Hi I am submitting data to a payment provider using an html form with hidden fields and SSL. However, it appears that this data can be intercepted and modified using a proxy tool. How can I achieve the equivalent within classic ASP alone - i.e. generate and submit the form from the server...

I have a Windows XP virtual PC (guest) running on a Windows 7 PC (host) with a SQL 2008 Express instance installed. As things stand, I can only access the host SQL instance from the guest (using SSMSE and sqlcmd) when the host's firewall is completely turned off. Any attempts I make to tweak...

I want to embed a video in a web page and activate it immediately when the page is opened. Can someone point me in the right direction please? Is it possible to do the same with a PowerPoint presentation and set an automatic slide show running without user intervention? The only solution I've...

I am developing a site which allows registered members to upload a personal (colour) photograph to the site for others to view in the same way as many forums do. For the moment I expect most photos to be about passport size in terms of on-screen display. Perhaps up to 150 x 150 pixels. I won't...

I have been successfully using a linked server to upload data to a remote MySQL database. However, one of the fields I upload to has recently changed from a MySQL varchar type to a MySQL text type and I now have a problem because the upload fails with the message: The OLE DB provider "MSDASQL"...

I have been using the shell folder object to copy files from a local folder to a remote one using ftp and the CopyHere method. However, I would like to be able to remove certain files from the remote folder first. The closest I have come is the code below but the InvokeVerb ("delete") line...

I am generating bound textboxes and bound comboboxes dynamically and adding them to a form. The textbox code seems to work fine such that, when I step through rows in the table, the textbox contents change and show the values anticipated. The comboboxes do not behave the same way. When I step...

I'm using Visual Studio 2010 to develop a very simple VB form. It has a datagrid bound to Table1. One of the columns is a combo box which is populated from a separate database table - Table2. The datagridview displays as I would expect, translating the lookup field in table1 to show the...

I have been developing an ASP.NET site in a folder using Visual Studio 2005 with no project or solution file. Occasionally I get very odd problems relating to two user controls such that I have to remove the user controls, re-create them (ultimately with identical names & code) and use "add...

Is there a "standard " intelligence behind the kinds of searches offered by the likes of Amazon and thousands of other shops with regard to matching items in a catalogue with a search string entered by the user. I need to introduce something similar and I don't want to re-invent the wheel nor...

I have some code that I have been using for years to return the results of a SQL Server (2005) query into an ADO recordset. With one such query I am getting the message: when I attempt to reference the RecordCount property of the recordset. When I run the query in management studio, it returns 9...

I am using a SQL 2005 server whose collation is set to SQL_Latin1_General_CP1_CI_AS. I am manipulating a database on that server whose collation is set to Latin1_General_CI_AS and, as far as I can see, all relevant fields within the tables on that database also have Latin1_General_CI_AS...

Is there a reliable way to retrieve the version of windows running on the web server? The closest I've come is Request.ServerVariables("SERVER_SOFTWARE") but its behaviour does not seem very consistent. It returns a string that includes the OS under Vista but not under XP.

I have a custom error page that is being called successfully when I want it. At the top of the code I have an "Imports CfgLib" statement. Within CfgLib.vb I have code along the the following lines:Public Shared CfgHoldFolder As String Public Shared Function CfgInitialise() As Boolean...

Most of my experience is with classic ASP, pleased excuse my ignorance… I have a series of HTML files in a secure folder at the same level as the the web site's root. Users will login and be able to access only the files appropriate to them. I will generate a series of links to these files for...

I've been looking at strongm's posts in http://www.tek-tips.com/viewthread.cfm?qid=1337638 and, in particular, the nifty code for ftp copying. However, I'm trying to suppress the "file already exists, overwrite?" prompt that can be triggered when initiating the copy. There is a flag that...

I want to present details of a shopping cart in a .aspx page using an HTML table with columns that show product code, description and price and show quantity as an adjustable dropdown box. The number of rows will depend upon the number of products purchased. I have got this working using a text...

I want to be able to increment, return and update the next available order number from a 'pot' held in a control table. So one possible approach would be:UPDATE RefStore SET NextOrderNo=NextOrderNo+1 SELECT NextOrderNo FROM RefStoreBut what if someone else is executing the same logic...

I have a .ASPX page, code behind it and I have a class containing a library of data validation functions. I call many of these data validation functions from the code behind. One of the data validation functions in the library loops through an array of validation rules and performs various...