im trying to insert <script>waspEmbed('example1.flv', 500, 367);</script>
i guess its using the , to seperate fields or something. how do i insert this?
having trouble inserting something into SQL database
Moderator: General Moderators
-
psychotomus
- Forum Contributor
- Posts: 487
- Joined: Fri Jul 11, 2003 1:59 am
If you are trying to insert that exact text, then you could have problems depending on how you quote your values. If you quote the text with single quotes, you will need to escape your single quotes in your text. For example, if your field is named myfield, then in MySQL you would do:
The comma should not be a problem as long as you have correctly quoted your value.
You might like to check out http://dev.mysql.com/doc/refman/5.0/en/ ... yntax.html for more info using MySQL.
Code: Select all
...SET myfield='<script>waspEmbed(\'example1.flv\', 500, 367);</script>'You might like to check out http://dev.mysql.com/doc/refman/5.0/en/ ... yntax.html for more info using MySQL.