Actually I just tried it from CF on a test table, and it's working fine (i'm
using CF5 Beta 1, but I don't think that matters). Maybe there was a slight
difference in your syntax? Here's the cf query
<cfquery datasource="dubliners" name="qry" username="sbloom">
USE pubs
UPDATE tbl
SET col =left(col,3)
+ '0'
+ right(col, len(col) - 4)
</cfquery>
pubs is the database, tbl is the table, and col is the column. Zero can of
course be replaced with any digit.
Hope it works --- feel free to post a more complete version of your code if
it doesn't.
-----Original Message-----
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 07, 2001 3:38 PM
To: CF-Talk
Subject: RE: update numeric SubString?
This works perfectly in T-SQL but in CF it makes the field <NULL>, Ive tried
a few different formatting options but they all err out. Any ideas on how
to make CF happy with this?
Thanks!
Adrian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
