error 0

Page 3 of 3 12 3
02/17/2011 21:33 topazee#31
Msg 242, Level 16, State 3, Line 1
The conversion of a char data type DATETIME returned a value out of range for date and time.
The statement has been terminated.
02/17/2011 21:42 topazee#32
apparently it must be the date and time that is the problem
02/17/2011 22:31 abrasive#33
Ya, it is something with the datetime. But that datetime is a valid datetime in the US. I think it may have something to do with how different countries write datetime.

See if this works:
Code:
SET DATEFORMAT YMD;
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate)
VALUES(1,1,3,349,'AC_1000 75_1','2011-02-17 19:41:38');
02/18/2011 05:17 topazee#34
always error :(

Msg 208, Level 16, State 1, Line 2
Nom d'objet 'PointLog' non valide
02/18/2011 05:21 topazee#35
I think sql server management studio is in French for which I have the error written in French
02/18/2011 16:28 abrasive#36
What if you explicitly tell it the location of PointLog, like this?

Code:
SET DATEFORMAT YMD;
INSERT INTO PS_GameData.dbo.PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate)
VALUES(1,1,3,349,'AC_1000 75_1','2011-02-17 19:41:38');
02/18/2011 17:44 topazee#37
here's what gives me

[Only registered and activated users can see links. Click Here To Register...]
02/18/2011 19:02 abrasive#38
It looked like that worked then, so probably your SQL Server expects dates to be in some format other than YMD.

You can try adding
Code:
SET DATEFORMAT YMD;
into your [dbo].[usp_Save_User_BuyPointItems_NCash] stored procedure and it should fix that varchar to datetime conversion error you were getting there.
02/18/2011 19:50 topazee#39
I have tried to add it gave me this message


(1 row (s) affected)
02/18/2011 19:59 abrasive#40
Quote:
Originally Posted by topazee View Post
I have tried to add it gave me this message


(1 row (s) affected)
When you updated your stored procedure? or when?
02/19/2011 06:46 topazee#41
When I carried the new query code and then execute it gives me

(1 row (s) affected)
02/21/2011 07:20 topazee#42
I just still do not buy item mall :(
Page 3 of 3 12 3