Hi, I'm using ASP with an Access database to track the user's usage of a Data Entry program. Each time the user inputs data, a record is made in the database that includes a time and date stamp. That way I can track how many records were made per hour, per day, etc. My problem is in bui...more >>

I have a table that is corrupted (it has a number of duplicate records in it). When I attempt to delete the duplicate records from the Enterprise manager I get an error. So I need to programatically remove them using ASP code. I have no idea how to do that. Can anyone point me to some ...more >>

Hell How can you open a new blank window using asp code. My question is how can I get this redirect to open to a new window. Here is a snippet of my code Dim i As Intege Dim intgroup As Intege Dim sitecount As Intege Dim sitesum As Intege Dim strma...more >>

Hi there, I am currently running into a somewhat weired problem and hope that this NG is able to help ;-) I have a table in a MSSQL Server in which there is one Column that stores a date. The Format is 04.03.2004 Now I want to populate a Listbox but only with the year from that Column. So...more >>

Hi I have a web ASP application using Access 2000 format databases which I developed in vb script on Windows 2000. The product works fine on IIS in the development machine and was fairly widely used publically for customer demonstration with limited db's in a trial ISP using NT4. The we...more >>

I currently am trying to connect to a SQL Server 2000 database from an ASP page and a Java connection. I can connect to the database fine using ODBC locally, but when I try to create my connection string in ASP with the same username and password, I get an error Also, on the same server, I curren...more >>

Hey guys, thank you for all the help i've recieved recently from this newsgroup. I've not another problem which I was hoping someone might be able to help me with. I've been accessing a stored procedure in an asp and passing in the necessary input parameters and returning the results in a html tab...more >>

I am trying to display the records which the date (the Name field is Period) are greater than today's date from MS Access. It works fine except that I cannot display any records for April. Please find the below query and help to resove the problem and many thanks in advance. reqSQL = "Sel...more >>

I have an ASP page that presents the results of a query. The page gives from every found record normal data but also an image. This is a thumbnail. It is my purpose that a bigger image will be showed as soon as you click on the thumbnail. I do not know how I have to do this. Can someone help? ...more >>

Just a really quick question to clarify something. VB.net is basically the .net version of VB and the premise is that this is for creating an app. ASP.net is basically the .net version of ASP and the premise is that this for running server-side apps for a web site. I believe the 2 are now...more >>

Hi All All I'm asking in this post is just for some user interface advice on the best way round it. Basically I've created a colours and sizes mechanism in my shopcart that allows me to specify different prices for my products if a user selects say a particular colour or size. To see my sh...more >>

Hi All I'm in a quandary and I don't know whats best. Basically I have a secure section that takes the user through 4 stages before they submit their order. Stage 1 is for them to enter their invoice address, stage 2 to enter their delivery address (if applicable), stage 3 to enter their p...more >>

How can I open a CSV file in MS-Excel via a link on an ASP page? I have an ASP page that allows a user to select a database table, view all of the table's field names, select field names of interest, and generate an CSV file from a constructed SELECT statement. Upon completion I'd like to off...more >>

I recently installed Windows 2003 Server Web Edition/IIS6. I put an ASP site that uses Access 2000. I have ASP extensions enabled in IIS. When I go to an ASP page is works, however, when I go to an ASP that uses the db it does not work. Error: HTTP 500 - Internal server error Internet ...more >>

Where you can use schedule jobs, backup your own data, run DTS processes, etc. I have ReadyHosting and I am quite limited in what I can do. I have to call them to backup my data, I cannot run DTS processes, cannot schedule jobs. I want a better host where I can have more control of SQL ...more >>

Hi everyone, This may be a simple question: When I pass "%" (without the quotes) in an asp page to a stored procedure, I get the Incorrect syntax near '%'. message. I get the same message from the query analyzer, if I dont use the single quotes. I cannot encase the % sign in single quo...more >>

Hi, This is my SQL Procedure : IFF(21 in(SELECT PageID FROM TBL_Trafic WHERE PageID=21), (UPDATE TBL_Trafic SET Hits=Hits+1, BytesUsed=BytesUsed+1713, LastEntered=now() WHERE PageID=21), INSERT INTO TBL_Trafic (WebsiteID,PageID,Hits,BytesUsed,LastEntered) VALUES (1,21,1,1713,now())) For ...more >>

Hi Im trying to get a mm/dd/ccyy format and can nearly do this using date() however I for 02 Feb 2004 I get 2/2/2004 and I want 02/02/2004 Regards John Berman john_berman@blueyonder.co.uk ...more >>

Hi is it possibel to add a CR and LF after date in a string ie: the quick CR LF bronw fox so when a report is generated the CR and LF are put into action and the viewer would see the quick bronw fox Regards John Berman john_berman@blueyonder.co.uk ...more >>

Hi there, I have asp pages running from a hosting server. In there I open a bunch of connection to an access database. When we ported over to win2k3, the site started going down, or hanged (with no response). I am suspecting a set of possibilities: 1-we could have reached access max db ...more >>

Hello, I try to connect a oracle database from my ASP page, but i have a error: 500.100 internal server error ... Alias server is AI-AI12 User: moi PW: call123 database: AI Have you the right script for this connection Thanks Joe ...more >>

Does anyone know of a freely downloadable list of all the countries in the world. Any format I can pull into SQL server. Regards. ...more >>

I am new to ASP. I have a form created in Frontpage. I am trying to put a drill down window that pops up and displays the data from a SQL table and then be able to select the entry I want and insert it into the text box in the form. then when I click submit on the form it inserts the form into...more >>

Hi guys, withou using SP, I want to be able to add a Parameter to the SQL Query and retrive the Recordset so I can use the Paging property under the recorset object.... how can I do this? I'm stuck here. Set cnData = server.createObject("ADODB.Command") Set rsData = server.createObje...more >>

I was wondering if anyone can help me. I've converting an already existing system (designed in Access which produces reports for the accounts dept) over to a web based system. The Access atabase has been transfered to a SQL database and I've designed a number of stored procedures to extract inform...more >>

Can anyone help me find a code for Database Paging? I have seen some of it but its very hard for me to read, its too advance. Need to have a code with beginner to intermediate level. thanks, Mark ...more >>

Hello, I am receiving a 500 internal error after creating a database wizard connection in FP. I can get to the login page and login. When the following pages load I get the 500 error on both pages. When I click the back button in the browser I get these errors any direction here Please. M...more >>

I am looking at writing a routine which will validate input to be used in database queries so as to protect against sql injection attacks. Obviosly I can look at removing items like single quotes however I have read that there are means of circumventing this such as by using hexadecimal or the char ...more >>

Hello, I am getting the infamous 80004005 (like just about everyone else on the net it seems). Using NT4/IIS4, Access 97 DB, it is a low volume (20 hits a day) site that worked perfectly for over a year. Then suddenly, without me changing any code on the site, it decided to start giving 8000...more >>

I am trying to create a simple 1 page asp page that should be very easy, but I can't figure out what I am doing wrong. It lists a person's gross income, and a list of deductions, number of dependents, and a net income. As each field is entered, the net income field should be refreshed. Proble...more >>

Start http://212.123.5.17/mb/xdata/am.asp in the left Frame choose N,F or D (Nederlands, French, Deutsch) Not E (Standard for English) Click GO Close your Browser Reopen the page. On top you will see the result of the Language Cookie - result = N,F or D Start http://www.adq.be/ws.htm ...more >>

I'm running a query from a text file to return data that I will then use to insert into SQL - could someone give an example as to how to insert that data after it's read? or during the read?...more >>

My mission is to get some data out of a sage application, via a very complicated query, into a csv file. My approach, so far, has been 1) link access tables to the sage application 2) build some sub queries 3) build a big query that brings together all the little queries. 4) dump the d...more >>

This is C# dot.net...more >>