I've got an Access 2000 database on my webserver and I'm trying to write a SQL command to query the database and pull out cheese information. I can't get the INNER JOIN statement to work properly. What I'm trying to do is have the user click on a cheese milk type, let's say Cow Milk and then...more >>

Hi, I've have obtained an example shopping cart. It has the following code, each case is for a different product. This code works fine for these 5 items. Select Case iItemID Case 1 aParameters = Array("./images/shop_shirt.gif", "ASP 101 T-Shirt", "Brief details about ASP 101 T-Shirt",...more >>

When I try to execute the code below in asp I get the following error message: ADODB.Recordset (0x800A0E78) Operation is not allowed when the object is closed. Rs.Open "SELECT COUNT(KartNo) From Personel WHERE KartNo="&kayit3&"", Con, 3,3 While Not Rs.Eof if RS(0) = 0 Then ...more >>

I have been working on an ASP site www.middlesexccl.com on my localhost. It uses a Access MDB and DSNless connections - no issues. I have uploaded the site and it seems everytime I upload an new version of the database I am given this error. It also seems that everytime I upload I copy ac...more >>

I am trying to insert a record into my database but i get syntax error INSERT INTO CAn you help? the code is below ' *** Insert Record: construct a sql insert statement and execute it Dim MM_tableValues Dim MM_dbValues If (CStr(Request("MM_insert")) <> "") Then ' create the s...more >>

Hi. I am reading a foxpro .dbf file and displaying the results on an asp page. The page is working fine, but I did notice something strange. After the page is done loading the dbf file appears to be locked for the next minute. When I try to open it in FoxPro I get a "File access is denied" m...more >>

Hi, I'm not sure what the right SQL statement would be. In 1 database there's a table of parent companies and a table of child companies. The parents have a key in their table. The childs have their own key plus the parent key in another column. In the 2 database there's a list of events...more >>

I have developed an application using frontpage and MS Access, all functions work correctly on my development system. Have published the web site to a production server and all seemed to work. However when functions add a record the a database table, asp reports that the record was added,...more >>

I am upgrading from an NT4 IIS4 server to a new Server running 2003 and IIS6 and have a problem with date format in VB. I have several web pages that use the date command as part of SQL strings to read or write data to ether an Oracle, SQL, PI, or Access databases. The problem is the date fu...more >>

I need to be able to update a record about 200 characters with a click of a button. The user will enter the new text in a textarea called NewsText and then click on submit button. Right now when clicking on the submit button the exsisting data gets overwritten with a null or blank. Here is my c...more >>

Lets say I have an Access database named Database001. I have a table called Table001. In the table I have the following fields: 1: Date\Time (an automated date\time stamp when an entry is added) 2: Status (defaults to the term 'Active') 3: Del14 (defaults to the term 'No') I am tring to cr...more >>

I am having a problem getting my asp pages to connect. My database is MS SQL 2000 sp4 MDAC is 2.8 IIS is 6 - Authentication is Anonomous MS SQL authentication is on Mixed I get this error on the test page. Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][Connectio...more >>

I have developed an Application which opens an ADO Recordset on the Server using the following : Set adoConn=Server.CreateObject("ADODB.Connection") adoConn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\subsidy\subsidy.mdb" The above works fine or I could use Server.M...more >>

I am allowing users to save a .vcs file for an event coming from a = database. Everything works correctly except it is showing the incorrect = time. Does anyone have any clues on how to get this to show the time = correctly, everything else is great! ------------------------- script begin --...more >>

Hi all, I am aware of how to insert into a database the old fashioned way, but I am trying my hand asp.net and am SURE this isnt the right way to do it anymore... I am a newbie here - so please forgive me if I sound stupid... the query I am trying to run is... The code is fairly simple... <sc...more >>

Hello, I've done this with drop-downs where I loop through a recordset, populated another drop-down and so forth. But I think this should be easier, but I'm not sure. I have a table with states, cities and rates. What I need to do is when a user selects a certain state from a drop down, and t...more >>

Using ASP under IIS5 on Windows 2000 Server (latest patches and MDAC). OK, intermittently when I try writing a record to an Access database, I'm getting the phantom "Provider error '80004005' Unspecified error" on a connection Execute method call. When it works, it works perfectly. For ex...more >>

We've developed a small system which pulls information from a database by = use of query string parameters, ex. mypage.asp?var1=3D1&var2=3D2. Now to optimize our opportunity to be found by a search engine, it is = recommended that pages be static so that robots can pick it up. So what = would...more >>

When using SQL Server as a backend it is often recommended that developers put their database code into stored procedures (i.e. the selects, updates, inserts etc...) and then call the stored procedure from an .asp page using e.g.: conn.Execute("dbo.MySProc @Username = 'blah'") where MySProc...more >>

This is on the longer side so please bear with me. I have written the following stored procedure: CREATE PROCEDURE dbo.usrGet_ContactSearchPRODUCT_CATEGORY @ConsultantID Int, @LanguageID Int, @RequestedPage Int, @PerPage Int, @FromDate VarChar(10), @ToDate VarChar(10), @ProductC...more >>

Coding an ASP application and I'm creating a Public Function to return the results from a query. I've been told that it's better to return a recordset containing the results than it is to return an array. I'm not sure which would be better, or how I'd handle passing a real recordset back fr...more >>

My ASP pages uses several SQL stored procedures to show data. The first procedure finds all items "A" for a specific period, all other procedures query all other kind of stuff, using values "A" form the first procedure as a parameter. It looks something like this: <% sql1 = "exec proc1" sql2...more >>

Can anyone help me create a dsn less connection to the sql server 2005 db from the connection.asp file below please, <% ' FileName="Connection_odbc_conn_dsn.htm" ' Type="ADO" ' DesigntimeType="ADO" ' HTTP="true" ' Catalog="" ' Schema="" Dim MM_TobiasNET_STRING MM_TobiasNET_STRING = "dsn=...more >>

Can somebody please tell me is is possible to get the background of an option box to show different images?? <option value="Bubbles" selected="selected" style="background-image:url(Thumbs/Bubbles.jpg)">Bubbles</option> But those does not work, any ideas?? If not could anyone suggest away ...more >>

Hi I am currently trying to get a simple data submission asp form to export data to an access database, this is the code for the contact_insert page <html> <head> <meta http-equiv="Content-Language" content="en-us"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252...more >>

I'm trying to write a little ASP routine to display the top 10 items sold. Following is a sample database: Sale #: Name: Quantity: 1 Vodka 2 2 Beer 3 3 Beer 1 4 Vodka ...more >>

I know this is a long post, please bear with me. I have been working on this all weekend to no avail although I have done a good amount of research (see most pertinent links that I've looked at below). Please help me get through this!!! I'm having some serious problems attaching a .mdf f...more >>

hi, i have a problem with a web farm. an application asp net 1.1 that works in different servers doesnt works in the web farm (4 servers balanced). The error it says is "System.Web.HttpCompileException: External component has thrown an exception" basically is a page that its requested in one ...more >>

s.lagah@ntlworld.com michael_sanko23@yahoo.com varalli.ilenia@hotmail.com jenifermjohn33@tiscali.co.uk alhajigambo65@excite.com lisa_patri@email2you.info thirds@sit.fi peterwallace11@msn.com peterson11@walla.com benreplydepio@yahoo.com freelinkdepio@walla.com salah...more >>

Hi all, PLEASE HELP. I'm having a real issue with reading an Excel file from my asp on a remote server. A snipit of my script is as follows: exceldb="serverdetails/adotest.xls" Set objConn = Server.CreateObject("ADODB.Connection") ' Create a server connection object objConn.Open "DBQ=" ...more >>

I am working on an application that allows the entry of a product specification maintained in SQL 7.0 through a Web Page using ASP. There are four fields in the SQL database that are set to the format "money" since they represent monetary charges for special services. The amount of data to be ...more >>