[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phptest-users] problem with single quotes in questions
From: |
dank |
Subject: |
[Phptest-users] problem with single quotes in questions |
Date: |
Mon, 05 Aug 2002 20:49:22 -0700 |
With HTML questions enabled, if you use a single quote
in your question, you get a nasty suprise.
- Dan
add:
There was an SQL error. The error message is:
You have an error in your SQL syntax near 'bar' bletch', 'a', 'b', 'c', 'd',
'')' at line 1
Please notify the site administrator.
The SQL Query that failed is: INSERT INTO questions (s_id, required, type,
weight, question, answer, alt_1, alt_2, alt_3, additional_notes) values (31,
'0', 0,
1, 'foo 'bar' bletch', 'a', 'b', 'c', 'd', '')
edit:
There was an SQL error. The error message is:
You have an error in your SQL syntax near 'b', alt_1 = 'c', alt_2 = 'd', alt_3
= 'e', additional_notes = '' WHERE q_id = 14' at line 1
Please notify the site administrator.
The SQL Query that failed is: UPDATE questions SET s_id = 31, required = 0,
type = 0, weight = 1, question = 'a'', answer = 'b', alt_1 = 'c', alt_2 = 'd',
alt_3
= 'e', additional_notes = '' WHERE q_id = 147
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phptest-users] problem with single quotes in questions,
dank <=