aegregory
Posts: 7
|
| Posted: 05/06/2006, 2:53 PM |
|
I created a stored procedure in SQL Server to insert values from my asp form. The server returns the following error when I attempt to add a record:
"Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query. (Microsoft OLE DB Provider for SQL Server)"
I'm not sure where this conversion from datetime to int is taking place. The fields in the table are set to smalldatetime. The textboxes on my form are set to 'Date mm/dd/yyyy'.
The parameters in my Custom Insert are set up as follows:
Name: @Date_Received
Direction: Input
Data Type: DateTime
Type: URL
I've tried altering my stored procedure the following ways and nothing seems to work.
@Date_Received nvarchar(15) = NULL
@Date_Received smalldatetime
I tried the cast and convert functions in the values section too.
Convert(varchar(10),@Dispute_Date_Received,101)
I'm stumped and I don't know what else to try. Can anyone tell me what is really causing this error and how to fix the problem?
|
 |
 |
|
