Results 1 to 6 of 6
- 08-22-2010, 06:15 PM #1
Member
- Join Date
- Nov 2008
- Posts
- 71
- Rep Power
- 0
-
I think that you're going to have to show some code as well as the error message itself (not your interpretation of the message).
- 08-23-2010, 04:16 AM #3
- Join Date
- Jul 2007
- Location
- Colombo, Sri Lanka
- Posts
- 11,370
- Blog Entries
- 1
- Rep Power
- 26
How did you save it, can you show it for US?
- 08-23-2010, 11:02 PM #4
Member
- Join Date
- Nov 2008
- Posts
- 71
- Rep Power
- 0
this is my code part..
Java Code:final DateTime ftime = new DateTime(group,SWT.TIME|SWT.BORDER|SWT.SHORT); ftime.setBounds(130,150,73,23); final DateTime totime = new DateTime(group,SWT.TIME|SWT.BORDER|SWT.SHORT); totime.setBounds(130,180,73,23);
Java Code:Execute exc = new Execute(); exc.ExecuteQuery("INSERT INTO tblfacultyscheduling(sy,courseid,insid,section,timefrom,timeto,day) VALUES('"+cmbSY.getText()+"','"+cmbCourse.getText()+"','"+cmbInsId.getText() +"','"+cmbSection.getText()+"','"+[B](ftime.getHours()+":"+ftime.getMinutes())[/B]+"','"+(totime.getHours()+":"+totime.getMinutes())+"','"+cmbDay.getText()+"')",factSched,cmbCourse.getText()); exc=null;
:cool:
- 08-24-2010, 03:33 AM #5
Member
- Join Date
- Nov 2008
- Posts
- 71
- Rep Power
- 0
hi guys, i already solved the half of my problem (no duplication of id anymore) but my problem is, how can i save the whole date to the database? the system can only save the hourse:minutes but the AM/PM is not.. thank you..
:cool:
- 08-24-2010, 05:05 AM #6
- Join Date
- Jul 2007
- Location
- Colombo, Sri Lanka
- Posts
- 11,370
- Blog Entries
- 1
- Rep Power
- 26
If you define the correct data type in the database, and if you pass the relevant value it works. So where you stuck?
Similar Threads
-
[SOLVED] how to save hindi text into Oracle Database
By sanjeevtarar in forum JDBCReplies: 14Last Post: 12-07-2010, 11:41 AM -
How to save image in database
By sandeep23k in forum Advanced JavaReplies: 3Last Post: 08-02-2010, 01:02 PM -
how to print the from and to datetime
By baktha.thalapathy in forum New To JavaReplies: 1Last Post: 06-10-2010, 10:58 AM -
Save JTable to database
By Geraldo in forum AWT / SwingReplies: 0Last Post: 06-04-2010, 03:03 PM -
save file to database
By katerinaaa in forum New To JavaReplies: 0Last Post: 08-14-2007, 01:15 PM
Bookmarks