Search results for query: *

The error occurs with different code from each application. But it's when they are all trying to use the database object after using it. Yes it's open, and yes it returns rows. I'm positive it's not a coding error because the same code works on the old server, and my local computer. Just not...

Hello, I have a few web applications that I have been running on one of our web servers at work and everything is fine. Rearrangements have come about and a change of server is needed. Therefore all the intranet websites/applications on one server were moved onto a new server. But now some...

Thanks very much Ca8msm, works like a charm, much appreciated.

Hello, I am trying to use Javascript within an ASP.NET web page to create an alert confirmation popup. A certain function run if a user clicks Yes or No to the alert popup. I have tried the following code so far. The HTML code is as follows: <%@ Page Language="vb" AutoEventWireup="false"...

Hi, I have a function for inserting new data into a table but I'm receiving the following error: Server Error in '/Contractors' Application. Insert Error: Column name or number of supplied values does not match table definition. Description: An unhandled exception occurred during the execution...

Hi, I am getting the following error when I load the page shown below: Object variable or With block variable not set. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it...

Hi, I have an ASP.NET page that contains quite a few looping SQL queries. After either loading this page (all.aspx) or doing a few table sorts the page freezes up and just loads for about 20 seconds. Sometimes the page just loads and doesn't show any results when I know there should be results...

Cool thanks oppcos. I'll give that a try tonight and let you know, hopefully it's not different for touchpad's. Alex

Yeah CentOS is a distro of Linux based on Red Hat. The mouse just doesn't install all together.

Hello, I installed CentOS 3.3 in VMWare 4.0 Workstation on my Dell Inspiron 8600 Notebook on the weekend but I can't for the life of me configure it to use either my Dell Mouse Touchpad nor a Microsoft Optical USB Mouse. Has anyone had any issues with this before or know of a quick solution? I...

Hi ca8msm, thanks very much for the help. I got it working from the last class code you showed me. Much appreciated. Alex

How do I use that class? And I don't think I want a DataGrid? This method seems very complicated for just selecting a singluar column from a table. Do you know of a tutorial on the technique that explains it better? Alex

Hi, I've migrated from ASP Classic to ASP.NET but I'm having real trouble learning the new ADO.NET way of database programming. I used to use the following two functions for creating ASP Classic database connections: <% Function CreateConn() dim Connect dim cnDB Connect =...

Ok cool thanks again SonOfEmidec1100, I'll have a try with both. This can be closed. Alex

Cool thanks SonOfEmidec1100, it works! The following query is what I ended up with: select * from Contractors.dbo.Contacts where VendorNo collate SQL_Latin1_General_CP850_CI_AI in (select No_ from [BMIS Live Database].dbo.[BMIS Live Database$Vendor] where [Name] like '%off%') Just out of...

Hi SonOfEmidec1100, Thanks for the very fast reply! I tried both examples you gave me but there are still errors. Just so you know, "BMIS Live Database$Vendor" is the actual table name. The second example you gave me gives the same error as the others: Server: Msg 446, Level 16, State 9...

Hello, I've put together the following query, but it has been unsuccessful running it so far. select * from Contractors.dbo.Contacts where VendorNo in (select No_ from [BMIS Live Database].dbo.[BMIS Live Database$Vendor] where [Name] like '%of%') I'm trying to grab values from the column...