Member Avatar

I have two textfields which are formatted for dates, i want to retrieve data from the database within a period of days which the two textfields stand for the "from" and "to" dates.Can anybody help me out? select distinct courseId,courseName,description,Date,amount from course where date>='2013/05/11' and date<='2013/05/11' for the SQL queries above, i used JDatepickers, the Jdatefield when editted to pick to pick the date, it does not change, when i echo the combination of the sql query, it shows current date.

Member Avatar
+0 forum 1
Member Avatar

hi i need help is there anyone here have the knowledge of java to retrieved files in the folder and print it out im using this script File folder = new File("your/path"); File[] listOfFiles = folder.listFiles(); for (int i = 0; i < listOfFiles.length; i++) { if (listOfFiles[i].isFile()) { System.out.println("File " + listOfFiles[i].getName()); } else if (listOfFiles[i].isDirectory()) { System.out.println("Directory " + listOfFiles[i].getName()); } } but the problem is im always seeing this error 500 (access denied (java.io.FilePermission \images\pictures read)) can anyone help me thanks

Member Avatar
+0 forum 1
Member Avatar

I saved some images in an sqlite database but when i tried to display them using static bitmap i get an error OnOpenEdit self.frmEdit.imageCtrl.SetBitmap((i[7])) File "C:\Python27\lib\site-packages\wx-2.8-msw-unicode\wx\_controls.py", line 1229, in SetBitmap return _controls_.StaticBitmap_SetBitmap(*args, **kwargs) TypeError: in method 'StaticBitmap_SetBitmap', expected argument 2 of type 'wxBitmap const &' here is a print of the data from sqlite [(1, u'one', u'two', <read-write buffer ptr 0x03155C00, size 74913 at 0x03155BE0>, u'four')] i felt it may have to do with conversion but since a lot of people don't support storing images in databases there is not much information on this. I would also like to know …

+0 forum 0
Member Avatar

hi to all, can you help me in my program, i can't retrieve my image in the database to vb.net how can i view my image when i click in listview? plss help me THIS IS MY CODE HOPE YOU CAN HELP ME! Imports MySql.Data.MySqlClient Public Class Often_Motorcycle_Problems Public ConnString As String = "server=localhost;user id=root;password=;database=motorcycle" Public CONNECTION As New MySqlConnection(ConnString) Public ds As New DataSet Public strSQL As String Public cmd As New MySqlCommand Public dr As MySqlDataReader Dim a, b, c, d, e, f, g Private Sub ListView1_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles ListView1.DoubleClick If ListView1.Items.Count …

Member Avatar
+0 forum 12
Member Avatar

Hey everyone, i'm currently working on a program that requires a number to be saved outside of the program in some manner and recalled later. Sounds confusing but perhaps this will help. The program i'm making is a game, and i want to be able to create something similar to a best players board, that ranks the players time and name. So starting off i set the fastest time to 10000 seconds, if you beat that time it prompts you to enter your name and on the game over screen it shows the fastest time, this works ideally when you …

Member Avatar
+0 forum 2
Member Avatar

Hi, I am building a room availability form that contains a foreign key 'roomNumber' that references the multiple dropdown list that contains the data time starting from 07:00 AM to 09:00 PM from monday to saturday, i can already store the data into the database but my problem now is editing the intended available time of a roomNumber. basically, my idea is that i have an edit button, and i will click on the roomNumber list my desired roomnumber and when i click the edit button, the previous entry made on the multiple dropdown lists will be shown again, and …

Member Avatar
+0 forum 3
Member Avatar

-- hello there!, here i am again asking for some help... i want to retrieve my data from my ms access database and i it gave me this error.. [COLOR="Green"]"Index was outside the bounds of the array."[/COLOR] ------ can someone help me about this?.. i put my code on my radio button function because, what i wanted to happen is when the user selected the "vote by party list" selection the party list names will automatically load on the activated combo box. here's my code.. [CODE] Private Sub rbPartylist_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles rbPartylist.CheckedChanged If rbPartylist.Checked …

Member Avatar
+0 forum 6

The End.