Database Discussion - SQL log files...

Print Page | Close Window

SQL log files...

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8039
Printed Date: 30 March 2026 at 9:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL log files...

Posted By: Gullanian
Subject: SQL log files...
Date Posted: 12 December 2003 at 12:09pm

Ok I got this query, it doesnt give any error, and doesnt seem to update the log file at all (log file just being a memo field in access database)

UPDATE tblChatLogs SET [log] = [log] + '[12:07:40 PM] [efeff] Ffffffff. ' WHERE visitorID = 2

Table and record definatly exist

Replies:

Posted By: Gullanian
Date Posted: 12 December 2003 at 12:17pm

Also the SQL server stored procedure isnt working as its meant to:

CREATE PROCEDURE [dbo].[LSsp_updateLog]
(
@username varchar(25),@visID int,@time datetime,@message varchar(255)
)
AS
UPDATE tblChatLogs SET [log] = [log] + mailto:'@time - '@time @username @message' WHERE visitorID = @visID
GO

Ive checked all parameters are passing through correctly. Log file field datatype is varchar(8000)

Posted By: Flamewave
Date Posted: 19 December 2003 at 12:00pm

UPDATE tblChatLogs SET [log] = [log] + @time + ' ' + @username + ' ' + @message WHERE visitorID = @visID

-------------
- Flamewave

They say the grass is greener on the other side, but if you really think about it, the grass is greener on both sides.

Posted By: ljamal
Date Posted: 19 December 2003 at 2:00pm

You may also need to convert the different datatypes into a varchar.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming