phptest-users
[Top][All Lists]
Advanced

[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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]