View Single Post
Old 06-11-2004, 12:56 PM   #2 (permalink)
Rawb
Crazy
 
Location: Salt Town, UT
Watch your quoting

Watch your quotes. You need to put anything text-wise into a database enclosed in quotes. But when it hits another set of those quotes, the quoting stops, and it tries to go back into plain old sql mode.

So everywhere in your actual text, you need to escape all of the " with \" (most systems have a way to do this, like php's addslashes() )

Example:

Before:
INSERT INTO pages VALUES
(
1, "<SCRIPT LANGUAGE="JavaScript">
<!-- Begin

After:
INSERT INTO pages VALUES
(
1, "<SCRIPT LANGUAGE=\"JavaScript\">
<!-- Begin
Rawb is offline  
 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54