BinaryWorks.it Official Forum
BinaryWorks.it Official Forum
Home | Profile | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
 All Forums
 eXtreme Movie Manager (Rel. 7), No More Updates
 Bug Report
 SQL Request failed		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

MoBO
Starting Member

Switzerland
48 Posts
Posted - 13 Sep 2009 :  22:56:03  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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
Edited by - MoBO on 13 Sep 2009 23:00:29

MoBO
Starting Member

Switzerland
48 Posts
Posted - 17 Sep 2009 :  00:57:47  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.
Go to Top of Page

Alessio Viti
Forum Admin

Italy
9171 Posts
Posted - 17 Sep 2009 :  06:00:00  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
http://www.facebook.com/pages/eXtreme-Movie-Manager/47220214342?ref=mf
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
BinaryWorks.it Official Forum © Binaryworks.it Go To Top Of Page
Generated in 0.14 sec. Powered By: Snitz Forums 2000 Version 3.4.07