Since a server migration project last year by our IT department, I've been unable to create new websites in FrontPage, or open existing ones via http://servername/websitename on our development server.
On our live server I can do these things so it looks like the problem is on the server and not the client.
Can anyone suggest how to fix this?
Thanks
twave
twave
Last Activity: Mar 19 '07, 11:08 AM
Joined: Dec 15 '06
Location: UK
-
Problem was in SQL statement. 'Now()' changed as it ran through a loop updating fields in the record. If the update completed before the next second started it all got written to the database. Otherwise the WHERE clause didn't match and it didn't write.
I added another SQL statement to get the date from the original record and compare this in the SQL statement instead of 'Now()'. -
There is no error message. I am recording the SQL output to a text file to check the results. If I answer yes to all questions on the form, this is the output in the text file:
UPDATE tblQuestionnair eResults SET Q1 = '1' WHERE NTUsername ='ntusername' AND DateOfAssessmen t = Now();
UPDATE tblQuestionnair eResults SET Q2 = '1' WHERE NTUsername ='ntusername' AND DateOfAssessmen t = Now();
UPDATE tblQuestionnair eResults SET...Leave a comment:
-
Problem saving to database
I have a form with a list of yes/no questions which records to an Access database. Occasionally a string of 'yes' answers are being recorded as 'no' in the database. For example, the first 3 may record as 'yes' then the remaining questions all record as 'no'.
I have set up tests to check the SQL statements which confirm the data being sent is correct.
The code is posted below.
Any help is appreciated....
No activity results to display
Leave a comment: