Bug Report #1288

MSSQL list_fields has MySQL request

Added by dcunited08 - almost 3 years ago. Updated over 2 years ago.

Status:Closed Start date:
Priority:Normal Due date:
Assignee:Jeremy Bush % Done:

100%
Category:Libraries:Database
Target version:2.3.4
Resolution:fixed Points:

Description

MSSQL list_fields query seems to be copied directly from MySQL and does not work. I did a search to find something comparable that works with MSSQL and this is what I found. I have not done a complete test of the submitted code but I believe it should work better than the current release.

293 - release: if ($query = MSSQL_query('SHOW COLUMNS FROM '.$this->escape_table($table), $this->link))

293 - my edit: if ($query = MSSQL_query("SELECT COLUMN_NAME AS Field, DATA_TYPE as Type  FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = '$table' ", $this->link))

Related issues

related to Kohana v2.x - Bug Report #1142: Database->list_tables() ignores table_prefix 2.4 Closed

Associated revisions

Revision 4387
Added by Jeremy Bush over 2 years ago

Fixing #1288.

History

#1
Updated by Jeremy Bush over 2 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

Applied in changeset r4387.

#2
Updated by Jeremy Bush over 2 years ago

  • Resolution set to fixed

#3
Updated by Jeremy Bush over 2 years ago

  • Target version changed from 2.3.3 to 2.3.4

Also available in: Atom PDF