BinaryWorks.it Official Forum

BinaryWorks.it Official Forum

All Forums

eXtreme Movie Manager (Rel. 7), No More Updates

Bug Report

SQL Request failed

Note: You must be registered in order to post a reply.

Screensize:

UserName:

Password:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

Check here to include your profile signature.

T O P I C R E V I E W
MoBO	Posted - 13 Sep 2009 : 22:56:03 Hello Alessio, I'm facing few trouble related to my VB work on the PopCorn MoviePortal since the last DB update (long long time ago). You switched from "Integer" to "Date" and since then I have not been able to retrieve the "DateInsert" field I thought the problem was somewhere else but... I'm not able to make this request to work correctly : SELECT DateInsert FROM Movies WHERE (DateInsert > 20090501) ORDER BY DateInsert DESC If I change the date prior WHERE (DateInsert < 20090501) I can see all movie inserted before the date. -> all movies insert BEFORE the change !!! I checked the DB and the fields are correctly filled. I'm... lost Anyway for you to help me on this ? Thanks PS On your version of the PopCorn MoviePortal, the "Last Added: TODAY, WEEK, MONTH, YEAR" are not working ! MoBO
2 L A T E S T R E P L I E S (Newest First)
Alessio Viti	Posted - 17 Sep 2009 : 06:00:00 Hi MoBo! Sorry for my late reply! I have switch to date field instead of integer to avoid some problems in date conversion. Please when you have finish send to me the working version of PopCorn MoviePortal so I can let all users download it. Thank you! Ale
MoBO	Posted - 17 Sep 2009 : 00:57:47 Hello Alessio, I have been able to fix this way... oGloCmd.CommandText = "SELECT DateInsert FROM Movies WHERE (DateInsert >= #" & VB6.Format(DateAdd(Microsoft.VisualBasic.DateInterval.Day, -1, Now), "dd-mm-yyyy") & "#) ORDER BY UCASE(DateInsert)DESC" and... sSQL = "SELECT MovieID,Title,Genre,Cover FROM Movies WHERE (DateInsert >= #" & VB6.Format(DateAdd(Microsoft.VisualBasic.DateInterval.Day, -1, Now), "dd-mm-yyyy") & "#) ORDER BY Year DESC " I still have a small issue with the "week" sorting but not sure if it's my fault or something else. Must be applied to TODAY, WEEK, MONTH & YEAR according their variables.

BinaryWorks.it Official Forum

Generated in 0.07 sec.