This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
Hi. I'm attempting to connect to a Microsoft Access database and get am pulling out some data to a ResultSet. I'm attempting to format the date using the format command SELECT tblCases.fldCaseID, tblCases.fldCaseName, tblCases.fldCaseTypeID, Format(fldDateStart,"dd/mm/yyyy") AS Expr1, Format(fldDateEnd,"dd/mm/yyyy") AS Expr2, tblCases.fldUserID FROM tblCases; This is the query string and I've tested it in Access 97 and it is valid. However when I put it in my query string in my Java class I get "Too Few Parameters. Expected 1." reported back to me. If I remove the Format command from the query then it works fine. Can anyone help?