Home.... | log in.... | Pub my question! | Sign-up....

MS Access + Java

I'm trying to insert dates from a JTextField onto an Acess database. It refuses to enter the date correctly , it either goes in as some garbage like "1.234756425" or "1993"Can anyone help please? its driving me insane

[232 byte] By [Damo_Suzukia] at [2007-10-2 14:36:28]

«« ObjectInputStream
»» problems in deploying

# 1

You're probably mixing up data types. That's my best guess, as you've only given a sparse amount of information with which to troubleshoot your problem.

yawmarka at 2007-7-13 13:02:03 >

# 2

The code is something like this

connection code here

Calendar cal = Calendar.getInstance();

Date today = cal.getTime();

SimpleDateFormat fmt =new SimpleDateFormat("MM-dd-yyyy");

String todayStr = fmt.format(today);

executequery("insert into table values("+todayStr+","+othervalue+")";

Damo_Suzukia at 2007-7-13 13:02:03 >

# 3

As Yawmark said, you're most likely trying to stuff a String into a Date field (hard to tell without the DDL). Use PreparedStatement and the setDate method and let the Driver take care of it for you.Good LuckLee

tsitha at 2007-7-13 13:02:03 >

# 4

And why, pray tell, did you think that the "Internationalization" forum was the place to post this question in? (just curious)

tsitha at 2007-7-13 13:02:03 >

# 5

Thx Yawmarkclicked on the wrong one sorry

Damo_Suzukia at 2007-7-13 13:02:03 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

MS Access + Java

Desktop New Topic

Desktop Hot Topic

Desktop

All Classified