incorrect count field

[bowden]

Hi pals

I'm trying to get a discussion forum up and running but am getting a ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect:

Code:
DIM insertStr
insertStr="INSERT INTO CATEGORIES (CAT_NAME, CAT_DESC, LAST_POST) VALUES("
insertStr=insertStr & "'" & request("CAT_NAME") & "',"
insertStr=insertStr & "'" & request("CAT_DESC") & "',"
insertStr=insertStr & "'" & DATE() & "')"

Set AddLinkCmd = Server.CreateObject("ADODB.Command")
AddLinkCmd.ActiveConnection = connStr
'here's where the error is
AddLinkCmd.CommandText = InsertStr
AddLinkCmd.Execute
AddLinkCmd.ActiveConnection.Close
end if

Is it a problem with the date() line?

What r ur views???? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[pinnacle]

Originally Posted by bowden

Is it a problem with the date() line?

I think so

Code:
insertStr=insertStr & " getdate())"

that is you want the date/time of the current moment

cheers -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[furious]

If you are using ODBC maybe you need to use CURDATE() or NOW()?

Microsoft reference for date and time functions for ODBC

http://msdn.microsoft.com/library/d...l_functions.asp

Good day -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[krissh]

date fields in access need to be surrounded by # and not single quotes -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --