Hi I have a web page which receives information from a form (using request.form) and also attempts to look at an Access query to read in recoeds to a variable named rsGroup. When I have the following line commented, so it does not activate, I can successfully print all of the response.write...more >>

Hi I am a relative beginner with VBscript AND VERY INEXPERIENCED WITH if, Then Loops. I have an ASP page which successfullly prints out a list of all GroupID's held in a variable named GroupsAll and another list of GroupID's held in a variable named GroupsJ (ie the groups a member has joined)...more >>

Hi All I have an ASP application which uses a single SQL Server based in London. I have two webservers on which the code is hosted one in London and one in New York both connect to the same SQL server database based in London. The connection between London Webserver to SQL Server is fast b...more >>

I need to migrate an Access Database to SQL Server 2000. The DB is Access 2003. The Database has numerous tables and numerous select queries with parameters included for efficient 'selecting'. Now, I would like to migrate the whole lot to SQL 2000. I have tried the Microsoft upsizing w...more >>

Hi I am a relative beginner with SQL and ASP. With some help after previous posts I have a page which successfully requests querystrings from another page and deletes a record from an access table, However, I get the error message: "Row handle referred to a deleted row or a row marked for d...more >>

Hi I am a relative beginner with ASP and very weak on syntax, basically I find something that works and modify it - but I have 1 SQL statement which I cannot get to work. I am using asp3.0 and VB Script I have a querystring from another page with the url http://localhost/gc6/www/LeaveGro...more >>

Hi, I have a “Yes/No” data field in MS Access database that I am trying to update. Here is my update statement, strSQL = "UPDATE dndusers SET Active = Yes WHERE E_Mail='" & Request.QueryString("email") & "' AND Activation_Code = " & fRandomPassword & ";" I get an error message sayin...more >>

I have an asp script that gets recordss from an access database. .The fields in the database have a specific length. I need to write the recordsets into a txt file but if i have a field in the db that is 15 char. long but there are only 5 char. written into the db i need to retreve the 5 char...more >>

After posting a record to SQL Server, is there ever an issue trying to get the last record posted and it not being there due to an extensive process during the post? What is the best way to handle this, in ASP or SQL? TIA... -- Roland Hall /* This information is distributed in the hope t...more >>

Could someone tell me if this parameter stored query is correct? Its not throwing up errors BUT also not returning any records...unsure if concentation is somehow needed to tie it all together? Are the apostrophe's needed...do i perhaps need '+' symbols? CREATE Procedure spr_GetStoryTitl...more >>

Dose a machine that has an asp application that uses access database have to have access installed or just the mdb file?? ...more >>

Hi All, Is that possible that I can send request to IIS Server after a .ASP page is displayed? My Requirement is: Clinet will Fill the Details in one Request Form after the details are filled then the Request Files will be shown to the user as Link in Another page. (Currently before Send...more >>

Hi All, I know that the SMTPsvg.Mailer component is used to send mails from ASP Page. Can any body tell me where can I get the Component for download or Do I need to purchase the component? Is this Component is better than CDO ? Thanks Prabhat ...more >>

I am very new to ASP. What I want to do is, Show results by each month from data sent from a input page. The results page now shows all data from the past year in a table. Is there a way to only show the current month and past month but maybe archive the other months? Maybe something I can add t...more >>

I've got a Windows 2000 server running IIS to host a small intranet for my company. This week my server died on me and I've spent all day building a new one. Most of the pages use ASP to pull data from FoxPro tables using a DSN connection. When it page loads, it seems to lock the file it is...more >>

I am building a where condition on an asp page. Here is the code. if IsDate(request.Form("dteStart")) then dteStart=FormatDateTime(request.Form("dteStart"),1) strWhere=strWhere & " PODate >= #" & dteStart & "# AND " Else dteStart=#2001-11-01# end if if IsDate(request.Form("dteEnd")) ...more >>

Could soneone help me extend the following select statement to selet the top five recently published news stories in descending order but RANDOMIZED. I already have the NewID() doing the donkey work but I am having trouble using an ORDER BY after it...is it possible? At the moment it randomize...more >>

A quick question. I have two access dbf files in the same directory structure. I can access them via ASP separately but when I try to access a table in one which has been linked using the link manager I get kicked out. If I just go into access I can access the linked table. For instance: ...more >>

Hi, ---- ------------------------------- id | date1 | date2 |user_id|priva| --- ------------------------------- 1 |something |something| 1 | 0 | 2 |something |something| 1 | 1 | 3 |something |something| 2 | 0 | 4 |something |something| 1 | 0 | 5 |some...more >>

I'm developing an online Payroll/Cash Advance application for a client. = So far, I have a table with the fee structures for both the check cashing = and cash advance. Now I need a "cash register" type table for keeping = track of the transactions going in and out for the cashier. My idea so =...more >>

I have a form where I would like to Getting the last auto of a record added in MS Access in Windows 2000 Server using DNS connect method for connecting to the Database I had tried to use objRS.Fields.Item("company_id").Value objRS("company_id") CStr(objRS("company_id")) It really ...more >>

Hi, I have images saved in a SQL Server DB on a webserver. How can I get them and show them on a webpage? Thanks Martins ...more >>

Hello, I am working on a classroom database for a small nonprofit organization and have fun into a dilema. I have an HTML form that allows instructors to select a class from a drop down list and it displays the students enrolled in the class like this: <script language="vbscript"> sub Cla...more >>

Hi, folks: Thank you in advance for you kind input. My ASP program is supposed to retrieve some information from a remote database and list the retrieved information in a browser. It was working fine the day before yesterday, but the exactly same code suddenly stopped working yesterday - I ...more >>

I have a Win 2003 server. I am running an .asp page that works fine on a development server. The production server will not display the proper data. This .asp page calls a SQL stored procedure that is passed a value thru Set cmdStored = Server.CreateObject("ADODB.command") Set param = cmd...more >>

This is probably a really naive question, but I need to ask it. Is there a way to automaticallly generate an INSERT statement inside sql server with the associated entry parameters? I have attempted to use query analyzaer to spit out a SQL SCRIPT which seems to partly do the job of creatin...more >>

First off thanks in advance for any assistance. This is what I'm trying to do. I have a database with 3 columns, fMonth, fDay, and fYear. I'm trying to create an sql statement with asp/vb to select these values and convert them to a date, and then compare them using 'between' to two other va...more >>

I'm getting the Following Error when trying to use Integrated Authentication from a ASP Web Page to our Production SQL Server. Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a ...more >>

Hello, I want to access the outlook express or Microsoft Outlook email contant list of client which is opening the site, using ASP 3.0. The requirement is to show the outlook email list on ASP page's list box. If anyone know about this please help me, Thanks in advance Anurag ...more >>

I am writing an Active Server Page application that will get all of the databases that a user can access. Is there a way I can do this with Active Server Pages? I also will provide the users with the option to change records, table structure, etc with this application. I will also be developin...more >>

The short version: I've got 3000+ databases on one of my servers that I am planning on updating (couple new fields etc) and am wondering about the best way of doing this without doing it manually. Unfortunately the server is owned by FastHosts so using my own components is unfortunately, ou...more >>

First a couple of apologies, Sorry if this message looks over-complicated but I'm uncertain of precisely where things are going wrong... and secondly, if I've double-posted I didn't mean to but I'm using a web-based news client and I'm not sure if it worked when I first clicked submit :( I ...more >>

Hi, I have an Access2000 db, IIS5. In an attempt to get back to basics, I am going thru a beginning ASP databases book by wroX -- and this piece of code is suppose to work according to the book -- and I cannot get it to work -- all I get is a blank page -- no errors: <% strDBPath = Se...more >>

Im geting an error like this when im executing the stored procedure thru ASP page as Cn.Execute "EXEC ......" Microsoft OLE DB Provider for SQL Server error '80040e14' Line 1: Incorrect syntax near ' '. /cr/NewRpt.asp, line 748 after the error if i copy the executing part ...more >>

Hi, Having a nightmare with IIS permissions. I have an ASP application reading and updating an ACCESS database successfully. I have authorisation to view the pages when using IUSR_Servername. However whenever I try and use the command Server.CreateObject("Access.Application") I get an e...more >>