Re: CFStoredProc cfsqltype=cf_sql_Date doesn't work with SmallDateTime SQL Type...Why?

2002-02-08 Thread Gary Ashbaugh
knows that I'm clueless! Thanks! Gary 8-) - Original Message - From: Kwang Suh [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 3:21 PM Subject: RE: CFStoredProc cfsqltype=cf_sql_Date doesn't work with SmallDateTime SQL Type...Why? Try using

CFStoredProc cfsqltype=cf_sql_Date doesn't work with SmallDateTime SQL Type...Why?

2002-02-07 Thread Gary Ashbaugh
When I use cf_sql_Date for the cfsqltype with in my cfstoredproc for a SmallDateTime SQL field, I get an error...why? ERROR MESSAGE RECEIVED: ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error, COLDFUSION CODE:

RE: CFStoredProc cfsqltype=cf_sql_Date doesn't work with SmallDateTime SQL Type...Why?

2002-02-07 Thread Kwang Suh
Try using CF_SQL_TIMESTAMP. -Original Message- From: Gary Ashbaugh [mailto:[EMAIL PROTECTED]] Sent: February 7, 2002 12:38 PM To: CF-Talk Subject: CFStoredProc cfsqltype=cf_sql_Date doesn't work with SmallDateTime SQL Type...Why? When I use cf_sql_Date for the cfsqltype with in my