mssql - problems to create view

Hi there, I\'m having problems to create views. The SQL query works perfect if I use it with Enterprise Manager, Query Analizer or so, but integrated with PHP I get an error message. This is what I\'m using: $from_timeframe_id=\'3\'; $q_view1 = \"CREATE VIEW \". \"filtered_lineups_and_services AS \". \"(SELECT channel_lineup.timeframe_id, \". \"channel_lineup.lineup_acronym_id, \". \"channel_lineup.service_acronym \". \"FROM channel_lineup \". \"WHERE (timeframe_id=\'\".$from_timeframe_id.\"\') \". \"AND (NOT EXISTS \". \"(SELECT channel_lineup_changes.* \". \"FROM channel_lineup_changes \". \"WHERE channel_lineup.chnl_id = channel_lineup_changes.chnl_id \". \"AND channel_lineup_changes.timeframe_id = \'\".$from_timeframe_id.\"\')\". \") \". \"UNION \". \"SELECT channel_lineup_changes.timeframe_id, \". \"channel_lineup_changes.lineup_acronym_id, \". \"channel_lineup_changes.service_acronym \". \"FROM channel_lineup_changes \". \"WHERE (timeframe_id = \'\".$from_timeframe_id.\"\') \". \"AND (line_action <> \'D\'))\"; $view1 = new site_db; $view1->query($q_view1); site_db is defined in an include file. The error message is: Database error: Invalid SQL: CREATE VIEW filtered_lineups_and_services AS (SELECT channel_lineup.timeframe_id, channel_lineup.lineup_acronym_id, channel_lineup.service_acronym FROM channel_lineup WHERE (timeframe_id = \'3\') AND (NOT EXISTS (SELECT channel_lineup_changes.* FROM channel_lineup_changes WHERE channel_lineup.chnl_id = channel_lineup_changes.chnl_id AND channel_lineup_changes.timeframe_id = \'3\')) UNION SELECT channel_lineup_changes.timeframe_id, channel_lineup_changes.lineup_acronym_id, channel_lineup_changes.service_acronym FROM channel_lineup_changes WHERE (timeframe_id = \'3\') AND (line_action <> \'D\')) MSSQL Error: 1 (General Error (The MSSQL interface cannot return detailed error messages).) I tried another view and always the same problem. Any idea? Thanks in advance, /paula