update query not working any ideas?

[SilentBob'secretfusion]

Hi, I am attempting to do a simple update query using the cfquery tag. The
code is:
<cfquery datasource="test" name="testers">
update tablename
set col1=col1 + "some new stuff"
where colid=4
</cfquery>

I am not getting an error, however I am also not getting an update. Any
clues. I am using sql 2000.

[paross1]

Are you attempting string concatenation or adding numbers?

Phil

[JMGibson3]

It SHOULD be crashing, SQLServer likes single not double quotes.
That said, perhaps you're not executing that portion of the code, or that new page.

[SilentBob'secretfusion]

whoops. sorry. it should be single quotes, I mistyped in forum.

Correct

<cfquery datasource="test" name="testers">
update tablename
set col1=col1 + 'some new stuff'
where colid=4
</cfquery>

[SilentBob'secretfusion]

Just adding a string value to a string value.

[paross1]

Perhaps there aren't any rows where colid=4. Otherwise, I don't see why it wouldn't work.

[MikerRoo]

Either you have left something off in your problem code, or there are no
matching rows, or you've overflowed the column.

It's better to always <b>attach</b> the <b>exact</b> code. Doubtless the key
problem was lost in "translation".

In the meantime, you can change your query to this:<i>
<cfquery datasource="test" name="testers">
update tablename
set col1=col1 + 'some new stuff'
where colid=4

<b>select @@RowCount as NumUpdated</b>
</cfquery></i>

... and dump the result.