Search results for query: *

Hi, I am trying to set up an Apache Web Server on A Windows 2000 Server as a testing server before moving our ASP site over to a Linux box. We have installed the version of Apache that comes with OpenSA as this automatically runs both the ASP & SSI modules. The problem I have is telling the...

Hi, I have a bit of a problem. Below is a query that runs fine in Access, but fails on an ASP page. SELECT [Status Codes].Description, Customers.[Address Line 3], [Service Records].[Problem Description], [Service Records].[Date Call Placed], [Service Records].[Service Record ID], [Service...

Hi, I've got an excellent file upload script which works really well. If I upload a .txt file, then there are no problems, however, if I try uploading a .doc or .pdf then the file does upload, but the script has moved on and saya that the file did not upload, thus the next part of the script...

Hi, I need to move some data from one page to the next. I can not use Cookies or the GET transfer option. I need to do it using something like the Meta tag that refreshes a page. Does anyone know how to do this, but POST the data, not add it to the URL after a ? (GET transfer). Any help...

Hi, I have an ASP page that looks up data from an Access database and displays it on screen. I wish to be able to offer the user the option to save this data as an Excel spreadsheet. I have set up the Export to Excel using OWC11, but I am having trouble transfering some variables from the...

Hi, I have an ASP page that looks up data from an Access database and displays it on screen. I wish to be able to offer the user the option to save this data as an Excel spreadsheet. I have set up the Export to Excel using OWC11, but I am having trouble transfering some variables from the...

Hi, Can anyone offer me assitance in setting up the Export command for OWC11. I have produced my XML page using ASP and have got down to my export command, but the script refuses to aknowledge my constants variable even though I have already defined it. Dim oSS Dim c Set oSS =...

Hi, I am trying to use an SQL lookup query to extract data from an Access MDB and place it into the Excel OWC Spreadsheet object using ASP. I have managed to produce the ASP script and create the Spreadsheet object. I have writen my SQL and I know that it works OK. The problem I have now is...

Hi, I am doing this using ASP. I have an Access database and I need to do an SQL search on this database and then transfer the data into an Excel spreadsheet. I have got OWC11 installed and have worked out how to create a spreadsheet. The problem I have now is getting the data from the SQL...

Hi all, I know how to create a new excel spreadsheet using OWC. What I really need to do is open an existing spreadsheet to use as a template to put the data into. I've read on a couple of sites that you can do this by streaming an XML version of your template spreadsheet and then adding your...

Hi, Does anyone know where I can get a list of, or a good online guide to using Office Web Components. I'm trying to develop an asp page that exstracts data from a database and places it into an Excel template. Any ideas would be much aprechiated. Thanks, Barry ICT Network Administrator IT...

Hi, Does anyone know where I can find a list of the VB commands for the OWC.spreadsheet function. I am trying to develop a web based system that will export data from a web site in to an Excel spreadsheet, but it is in need of somw drastic formating, and if possible, to use a pre-designed...

Hi all, I have a database table which contains lots of records. When I run a page in my asp script, I need it to do a check on the current SQL lookup recordset to see if there are any records that match the SQL query. Depending on the results, depends on the html code that gets displayed...

Hi all, I have two domain controllers running my domain for me. They are both acting as DNS servers, as well as running IIS. One of them is also acting as an email server. They are both running happily under their main domain name and hosting the main web site without any problems. I want to...

Hi all, I'm having problems with this sql statement. Could you please look at it and advise on any problems. sdate & edate = dd/mm/yyyy format which is the same format as the data in the access database. SQL statement is: strSql1 = "SELECT * FROM (([Service Records] LEFT JOIN JobTypeTable ON...

Hi all, I'm trying to do a data serch on a database. I have several different fields to which the search can be carried out from and I am offering these fields to the user on the search page. My question is: Is it possible to get ASP to run a single RS lookup (rs = conn.Execute(sql)) using...

Hi all, I keep getting the following error: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. This is the posted data: POST Data...

Hi all, Im trying to display a seven day calender. I have managed to configure the display format and to get it to increase the date by one for each day, but if I start my seven day display on the 29th July, it will finish on the 35th July! How can I get it to roll over to the next month? I...

Hi all, I'm trying to put together an ASP check to make sure that a set of variables contain the correct data before proceeding. I have three data variables, (v1, v2 and v3), and I want make sure that v1 and v2 contain data if v3 does. I have tried the following: if v1 or v2 = "" and v3 <> ""...

Hi all, I have a form with several checkboxes on it. The value of these boxes is set to True. When the box is ticked, the value true is returned in the post data, but if a box isn't ticked, then no value is returned. I want to have either true or false entered into my MS Access database via an...