Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

&quot into "" and running a script

Jul 4, 2007 11:08AM PDT

Hello everyone,

I'm storing a video script on my SQL database, and everything seems to be working fine until I try to use the string produced by the database. It converts all of the quotes to &quot and several other characters, then instead of running the script it just displays it as text on the screen. Is there anyway to fix this?

Thanks!

Discussion is locked

- Collapse -
Doubtlessly there is ...
Jul 4, 2007 5:18PM PDT

but you don't provide any useful and detailed information to see what you're doing wrong.

Kees

- Collapse -
More info
Jul 5, 2007 2:57AM PDT

Sorry about that. This is part of the code from a plugin were using, Here's what the code looks like:

<table border='0' cellpadding='0' align="left">
{if $SETTINGS.global_stream == 1 && $video.allow_stream == 1 && ($video.file_converted != '' || $SETTINGS.global_stream_original.test == 1)}
<tr><td>
{include dir=$TEMPLATEPATH file=$video_player_template}
</td></tr>
{else}
<tr><td>
{$video.remote_link}
</td></tr>
{/if}
<tr><td>
---------

The variable $video.remote_link is the one that I pulled from the SQL database. Here's what it outputs:

<object width="425" height="350"><param name="movie" value="http://www.youtube.com/v/l3_vkMWfYdI"></param><param name="wmode" value="transparent"></param><embed src="http://www.youtube.com/v/l3_vkMWfYdI" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"></embed></object>

instead of the way its supposed to look:

<object width="425" height="350"><param name="movie" value="http://www.youtube.com/v/l3_vkMWfYdI"></param><param name="wmode" value="transparent"></param><embed src="http://www.youtube.com/v/l3_vkMWfYdI" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"></embed></object>

--

All that it does is display the code on the screen instead of running the script.

Any ideas?