Im in the final stages of cleaning up an xtensive ASP/Access-db project. I've ran everything through with Option Explicit - and that proved to be VERY helpful. Now - is there a similar command to put in that helps tracing declared objects that is never used I.e - see below simple exampl...more >>

I am writing a .NET web application that provides secure access t images and files. Basically files/images will be uploaded to th website (storage method to be determined) by a given user and the access to the file will be restriced to other specific users base upon some permissions that are sto...more >>

Here's my quandry... I have a table called addrTable with the following fields: storename, storeAddr, address2,City,State,phone, prods I want to return a recordset based upon the search criteria of prods. I want to filter out duplicate storeAddr data (this list was generated from invoic...more >>

Hi all I have a working ASP System containing the code listed under 'Target Code in a longish loop which reproduces on the web page the sections of the customer catalogue that the client is interested in. The code determines if a Customer has logged on and tailors some of the links on the Cata...more >>

Hi, I'm using WinXP-Pro, ASP classic, IIS 5.0. I regularly get this error, but I know I am the only user accessing the website at the time of the error. I looked it up on the MS support webiste. Their recommendation is this ... ------------------ on Microsoft Windows XP Professional...more >>

Hi, Can anyone give me a pointer here. I have a site that is working well after first build. All the tables in the Access database are standalone, if you like, but I wanted to try and incorporate lookup columns within the database to try and reduce possible input mistakes. The only problem now i...more >>

Hello, Got a question for you guys... thanks for taking a look at this. Question: I have a link which pops-up a form. I have a validation script which checks the values in the form upon submission. I have all this working great. My issue is I want to also automatically close the pop-up a...more >>

Would someone please be able to help me write the code to update the details in a record on a table. I want to update the value of a field within the record. For instance I need to be able to change the details in a table which look like as follow AccountNo Agent Name Typ 01568H ...more >>

I have installed IIS and Oracle 9.2 on my PC, but can't start ASP page. Could you please advice? Detail - Oracle9i Database 9.2.0.1.0 (Server) - Oracle9i client 9.2.0.1.0> General Purpose and IIS 5.0 on Windows 2000 Server.(Client) - I can connect to Oracle and retrieve data using Oracle'...more >>

Hi All I know you ask for a schema of the tables, etc, but I think this is more an ASP thing than a T-SQL thing. I can get the row-by-row data that I want into a recordset (auto-sorted by SALESCENTREID and then STOCKCATEGORYID), but what I need to do is sub-total certain columns of this dat...more >>

Hi All I've seen a few examples of multi-language ASP web sites, but none that seem to do it very well. Basically I can see that all of the strings need to be kept in the database and that the relevant table needs to be constructed as follows: STRINGID, LANGUAGEID, STRING 123, ENG, Baske...more >>

Hi all I have a requirement in which customer fills in a form. The provided form fields are searched against the coulmns in customer table. For example FirstName is searched against FirstName in the table and so on. If the form data is same as that of a table row than it is 100%. If for examp...more >>

Hi All Few logic queries again. I've seen a lot of sites that display categories in a sort of table with the number of items/products that are available in each category being represented by a number next to each category, eg: Books (5) Cats (2) Dogs (8) ...more >>

...more >>

Hey there I'm working on revamping an application I originally helped architect. At the time I first created it, it was my first DB/ASP project and a lot of things in it now seem glaringly wrong about it. Namely, there is one field in the table we use that breaks the cardinal rule of atmocity - it...more >>

I am developing an asp/sql driven application. Right now I am passing parameters like this: page2.asp?uid=<%=User%>&otherinfo=<%=otherinfo%> I then use the value of 'uid' and 'otherinfo' to query my dbase. The problem is that the user can see what is happening and change the value of .....more >>

I need to update values in different posts in an Accesdatabase without opening and closing more than once How do I do that The values should always be updated - +1 Typically: RecSet("Col1") = RecSet("Col") + 1 This does not work Uppdat = "SELECT Col1 FROM My_Db WHERE ID IN (497, 498)...more >>

I have a little script that reads an XML file from a remote server. The xml file was generated from an ado recordset with the recordset.save method, and it is read in using the recordset.open method. The silly thing is that I can't get it to work unless I first save the recordset to a file an...more >>

I am trying to select the max value in my order_id column from my orders table and there after insert this selected order id into my ordereditems table. sqlString="select max(order_id) from orders" RS.Open sqlString order_id = RS( "order_id") sqlString = "INSERT INTO ordereditems ( "...more >>

Hi all need some serious help; i am trying create a VBscript that will record computer usage information and i am tryin to connect to my oracle 9i database on a server using a connection string but not on your nelly can i get the thing to work!!! heres what i have "Driver={Microsoft ODBC...more >>

Hi All I know these are probably a very general questions, but I'd like to know your thoughts all the same. Basically my shopcart is taking shape and I want to do the following: 1) A user's product has a set price and then an option to enter a price for each size. Before I can display th...more >>

Hi, I'm using asp.net. I don't know why the following has error. The code has error in line 3 on ADOConnection. Can someone please kindly tell me why it doesn't compile??? Thanks, Wing <SCRIPT LANGUAGE="VB" RUNAT="SERVER"> sub page_load(sender as object, e as eventargs) dim cna as ADO...more >>

I have 2 tables. I'm trying to add a ranking feature to my CMS. Here are the details. content ---------- id int identity catid int title varchar(20) body text status char(1) rank category ---------- catid int catTitle varchar(30) status char(1) sample data - content ------...more >>

I am developing a small website using ASP scripts to format data retrieved from an Access database. It will run on a Windows 2003 server supporting FrontPage extensions 2002 hosted by the company 1&1 with only limited server configuration via a web based control panel. My query relates to the ...more >>

I saw a select statement in a book and wasn't sure what this meant, "where 1=0" It was in a select into clause. Any help would be appreciated....more >>

Hello I get the following error, when trying to pass an OrderID from one WebForm to another Server Error in '/FinalProject_cs_new' Application ------------------------------------------------------------------------------- An OleDbParameter with ParameterName '@OrderID' is not contained by t...more >>

I normally use code like this when connecting to my database... set conn = Server.CreateObject("ADODB.Connection") conn.open "Provider=SQLOLEDB; Data Source=P400; Initial Catalog=dbase1; User ID=John; Password=1234" conn.execute("CREATE TABLE Names (FirstName CHAR(20), LastName CHAR(20) );") ...more >>

Hi, I've recently converted some asp code reading records from a database table to use the more efficient getrows method. The strange thing is that even when returning as many as 600 results the getrows method is up to 3 times slower than using the traditional recordset and using objRS("fie...more >>

Does anybody know anything about problems with MDAC 2.6 and Access 97? My hosting provider adviced against using Access 97 on their servers because MDAC 2.6 and higher would not support this properly. I decided to try anyway. A few weeks it worked flawlessly, but all of a sudden no database coul...more >>

I need to be able to update details in a record in a table. I want to take the information from a textbox on a form - Request.Form("classification") The table has three fields and I only want to change the details in one of the fields (classification Can someone help me write the asp code to u...more >>

I have some asp code which returns record details in html textboxes. The code is working fine however I would like one of the textboxes to display the results of that record but also have a drop-down menu displaying the other distinct field values in that field. My code looks as follows: < set ...more >>

Hi! i am using oracle sql and ASP to do my shopping cart. Below is a snippet of my asp codes. sqlString = "INSERT INTO orders ( " &_ "order_userID, " &_ "order_ccnumber, " &_ "order_entrydate " &_ ") VALUES ( " &_ " '" & userID & "'," &_ " '" & ccnumber &...more >>

This is slightly off topic but is there an affordable way to get Windows 2003 Server for testing use at home. Paul ...more >>

I have a problem with my connection. My computer is a customer Windows 2000 Professional, I Installed IIS into my computer. I want use a connection with a remote database into the server or other computer (The server is Windows 2000 Server). When I put the database into a folder in my c...more >>

Hi, When I trie to browse the site I get this two errors: * Microsoft OLE DB Provider for ODBC Drivers error '80004005' * [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by...more >>

I have a web app that uses a connection object as the activeConnection property for several stored procedures on a page. At the end of the page I dutifully close and set the connection object to nothing. Should I do the same for very command object that uses this connection as the .activeConne...more >>

Could some one help me write the asp code which adds a record to a database table. The connection i've been using is as follows: set dbconn = server.CreateObject("ADODB.Connection") dbConn.Open Application("connectionString" I need to add the contents of a textbox on a web form into the field...more >>

I have a piece of asp code which is populating a drop-down list box from the information of a field in a table, but I need the width of the drop-down list box to be exactly 34char but it would seem to work for me. Here is my code below: - Can anyone help m <tr><td height="30"><div align="l...more >>

Hi Is there a way to convert an asp site to asp.net? I am not looking to change any existing functionality for now and I don't mind if code behind remains in legacy vb/asp. I just want to do any future additions to the site in asp.net hence the need to convert the existing site. Thanks R...more >>

Hi, I have just started test our website against Oracle 9i Release 2 on a Windows 2000 server and are experencing problems connecting to the database. When trying to connect via OLE DB using MSDAORA it seems to not recognise the Oracle Client software and returns a error stating that the...more >>

Win-XP pro. NAV from Norton System Works 2002. Script blocking service is "automatic" but doesn't seem to be started when the system starts. It will start when told to do so manually, but about 10 seconds later it stops. Have searched previous posts (this issue seems to date back to at le...more >>

Hello I am working with Windows XP on my Toshiba laptop computer I have the following pb ---- MICROSOFT DEVELOPMENT ENVIRONMEN The connection could not be open because of the following error Format of the initialization string does not conform to the OLE DB specification ---- I click the '...more >>

I've been told that OLEDB is a faster way to get to a SQL Server database from ADO than to use ODBC. My paranoid streak prevents me from putting a password in cleartext on my web server. Given the number of source revelation exploits I've read about, I would rather not do this and just use the I...more >>

Hello All This is somewhat related to an earlier post that I had. I am paging between records (10 records per page). If I make a change to a record on a page before paging to the next page (by clicking next page or previous page), I would like to commit my changes to the db. How would I do suc...more >>

I wan't the user to pass an image (from their hard drive) as a parameter to a SQL stored procedure. From the web page, the user will identify the path and file name and submit the page. I know how to write the stored procedure to do this but I am unsure about how to do this from the web pag...more >>

Hello I am writing an ASP.NET application and trying to access an Northwind.mdb MS-Access database usin oleDbAdapter1, oleDbConnection1, and DataSet11 objets and a dataGrid control I get the following error when I run the application ---- Server Error in '/FinalProject_cs_new' Application ...more >>

I create a stored procedure and a asp page. But I got an error. Please help. Thanks, Lin Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E10) Procedure 'getCustomerList' expects parameter '@Location', which was not supplied. --------------- asp page -------------- Dim cm...more >>

i have a cms i am working on. there is a table called page (pageid int identity, body text, status char(1). I have a problem. Currenly if you add a page, it will fall in the navigation structure in that same order. How can I change the order of the pages in the navigation if a users wa...more >>

everytime i run my asp project i get this following error: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified this is what i have in my global.asa file: Sub session_onStart session("...more >>

everytime i run my asp project i get this following error: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified this is what i have in my global.asa file: Sub session_onStart session("...more >>