Title:
Bug 74242:Observed in Microsoft SQL Server 2005: If the first character of the database name is a number, the following can occur: 1) cfdbinfo type="tables" returns an empty query object, 2) cfdbinfo type="colu
| View in TrackerStatus/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)
Created: 12/14/2008
Components: Database, CFDBINFO
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Normal / Unknown
Locale/System: English / Win All
Vote Count: 1
Problem:
Observed in Microsoft SQL Server 2005: If the first character of the database name is a number, the following can occur: 1) cfdbinfo type="tables" returns an empty query object, 2) cfdbinfo type="columns" returns an error message "Table x not found" (where x is the name of the table specified in the table attribute).
Method:
Example:
Datasource Name: myDSN
Database name: 1mydatabase
Table Name: myTable
Column Names: id, myColumn
CFML1: <cfdbinfo datasource="myDSN" type="tables" dbname="1mydatabase" name="myDBInfo" />
CFML2: <cfdbinfo datasource="myDSN" type="columns" table="myTable" name="myDBInfo" />
CFML3: <cfquery name="myQuery" datasource="myDSN">SELECT myColumn FROM myTable</cfquery>
CFML1 & CFML2 resulted in the aforementioned occurrences.
CFML3 succeeded.
Result:
Forum post: https://prerelease.adobe.com/project/forum/thread.html?cap=87529bda13744b3db718e841890b9240&forid={a8760b70-42a5-45fc-8ba2-dfcf173a9580}&topid={E0A30A5E-0135-410B-A769-BE30DF1F54D9}
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3037053
External Customer Info:
External Company:
External Customer Name: Aaron Neff
External Customer Email: 3D1D17B03C844EBF992001AC
External Test Config: 12/14/2008Attachments:
Comments: