Recent content by smurf01

Up until today I had several web pages running fine on an intranet at work however today I find that when I access the web page for the first time it loads OK but when I click the refresh button I get an error message like the one shown below. Provider error '80004005' Unspecified error But...

Tony, Thanks for responding I am posting the SQL for you to look at The field I am having problems with is QryMDWorkip.StartDateTime this looks for all orders that are in progress then I have a left join on QryMDLoads. The problem is that QryLoads has more records than QryWorkip and as I need to...

Golom Thanks for the speedy reply I have tried the Nz function without any success. I do need to show the rows where the "#Error" message is, any other ideas Regards Paul

I have a multitable query where I am using all the records from the left query and only records from the right query that match one of the fields from the right query is "StartDateTime" which is formatted a shown 23/03/2004 09:34:00 My problem is that where the field contains no dateTime then...

OK soted it now i had to put # either side of the date criteria i.e. WHERE DueDate = #Ddate# Regards Paul

I have an asp page that shows the total number of future orders by date, they are grouped by date and summed by number of orders. what I was hoping to do was to create a detail page that would be populated by using the date column as the parameter however whenever I try it i keep getting a data...

It's Ok I have sorted it now. I am using dreamweaver to code the page for me and for some unknown reason it was not adding the appropiate page into the MM_editRedirectUrl = I have added the page to the line manually and it works fine now Regards Paul

When I do this all that happens is that when i call my asp page with the form on it, instead of showing the form page it just returns to my original page Regards Paul

DeCojute, Where exactly would I put this code in the head or the body Regards Paul

Hi, I have an asp page (MCdata.asp) that extracts data via a recordset, I have a repeat region for all records, these records relate to machine numbers. The field for the machine numbers is set so that when any of the numbers are clicked then the user is taken to another page (MCdatachange.asp)...

Chris, I understand what you say about the auto generated code, however I am not proficient enough yet to be able to hand code. I do appreciate your help and the code you just sent me has worked great. Thanks for all your help and patientence [2thumbsup] :-D [2thumbsup] Regards Paul

Chris, I am struggling here so I am posting my code I hope you don't mind <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="../Connections/SMstocks.asp" --> <% 'Set the server locale Session.LCID = 2057 %> <% Dim RSFeeds Dim RSFeeds_numRows Set RSFeeds =...

Chris, No your right i did miss the braces, one question where would you put the code ???. in the body ???. Or should it go somewhere else Regards Paul

DeeCee, If you can help me it would be much appreciated Regards Paul

DeeCee, Sorry to confuse you I am using DW4 and asp pages and I am pulling the data from a recordset. The field called "Status" will show only two text alternatives these will be either "OK" or "OverLoad". What I want to do is: If the text shows "OverLoad" then the text will be colored RED...