having probs inserting data into table

[TeaAddictedGeek]

I can't seem to get the data inserted into the table... it'll input the date and time, but when I open up the row in SQL server, it shows a blank cell for the variable data.<br>
<br>
The code is below, in both SQL and Cold Fusion.... I know that there's a separate group for Cold Fusion tags, but this seems to be a SQL issue. Can anyone help? It's driving me nuts; I can't seem to figure it out.<br>
<br>
<br>
Thanks!<br>
<br>
<br>
<br>
<br>
<br>
&lt;cfloop query="source"&gt; &lt;!--- begin CFLOOP query source ---&gt;<br>
&lt;P&gt;&lt;center&gt;<br>
&lt;font class="partnersbody"&gt;&lt;h3&gt;Checking source and destination(s)....&lt;/h3&gt;&lt;/font&gt;<br>
&lt;/center&gt;&lt;P&gt;<br>
&lt;cfif d_id is " "&gt;<br>
&lt;cfabort&gt;<br>
&lt;/cfif&gt;<br>
<br>
&lt;P&gt;&lt;center&gt;<br>
&lt;font class="partnersbody"&gt;&lt;h3&gt;Successful copy!&lt;/h3&gt;&lt;/font&gt;<br>
&lt;/center&gt;&lt;P&gt;<br>
&lt;cfquery datasource="wl_application" name="copy"&gt;<br>
exec master..xp_cmdshell 'robocopy #source.s_path# #source.d_path# *.* &lt;cfif source.s_recurse IS "1"&gt;/E&lt;/cfif&gt;'<br>
<br>
&lt;/cfquery&gt;<br>
&lt;pre&gt;<br>
<br>
&lt;cfoutput query="copy"&gt;#copy.output#&lt;br&gt;&lt;/cfoutput&gt;<br>
<br>
&lt;cfquery name="update" datasource="wl_application"&gt;<br>
<br>
insert into repl_log(data)<br>
values('#copy.output#') <br>
&lt;/cfquery&gt;<br>
<br>
&lt;/pre&gt;&lt;br&gt;<br>
&lt;/cfloop&gt; <br>
<br>