Gerald
|
Posted: 10/02/2003, 5:49 PM |
|
I am using ASP/VBScript and MySQL 4.0.12.
I want to execute a query that creates a temporary table.
(the query is at the bottom of this note).
The CREATE TEMPORARY TABLE doesn't seem to work (though it works directly when I use it on the database). What is my problem?
...Gerald
CREATE TEMPORARY TABLE temptable
SELECT call_info.call_id, answers.answer
FROM answers INNER JOIN call_info ON answers.call_id = call_info.call_id
WHERE call_info.CI_survey_num=1 AND answers.question=1;
SELECT COUNT(temptable.call_id) as cid, temptable.answer as A, answers.answer as B
FROM answers INNER JOIN temptable ON answers.call_id = temptable.call_id
WHERE answers.question=3
GROUP BY B, A
ORDER BY B, A;
|
|
|
kevina
|
Posted: 10/08/2003, 12:53 PM |
|
Check your rights, the web user may not have the right to 'Create' a table.
|
|
|
|