Data type conversion for SQL update

[ Follow Ups ] [ Post Followup ] [ Intranet eXchange ] [ IDM Home ]

Posted by Ben McLendon on October 28, 1999 at 12:21:9:

[ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type varchar to data type money, table 'CUSA.dbo.CSRT_Work', column 'CW_Cost'. Use the CONVERT function to run this query.

HOW?!

I've tried several ways of converting the varchar to money but they don't work. Maybe because of syntax. Speaking of syntax. Any one know of a good source on syntax for VBScript and SQL in ASP pages?

Any help would be appreciated!

BEN

Follow Ups:

• ativan ativan 04:56:36 8/03/04 (0)
• valium valium 06:23:21 7/21/04 (0)
• xanax xanax 04:49:10 7/19/04 (0)
• Re: Data type conversion for SQL update Ben McLendon 09:28:03 10/29/99 (3)
  • ativan ativan 04:56:36 8/03/04 (0)
  • valium valium 06:26:40 7/21/04 (0)
  • xanax xanax 04:49:10 7/19/04 (0)

Post a Followup

Name:     
E-Mail:   
Subject:  
Message:

Optional Link URL: 
Link Title: