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?
posted 14 years ago
Might be the problem with "" quotes in the format. Chnage it to single quotes or make it a proper java string by proper concatenation. Hope this helps. venug.