G'day
I'm not sure what's causing this, but it dun't work on OBD 1.3
(Version 1.3 - 25-Apr-2010 08:07), and does work on CF8, BD.NET and
Railo.
<cfquery name="qTable" datasource="mydsn">
SHOW TABLES LIKE 'validTableNameHere'
</cfquery>
<cfdump var="#qTable#">
On OpenBD I get:
Type Internal
Tag Context CFQUERY (C:/webroots/openbd/misc/incompat/bd/
showTables.cfm, Line=1, Column=1)
Source
1: <cfquery name="qTable" datasource="mydsn">
2: SHOW TABLES LIKE 'validTableNameHere'
3: </cfquery>
4: <cfdump var="#qTable#">
^ Snippet from underlying CFML source
Stack Trace
java.lang.NullPointerException
at com.naryx.tagfusion.cfm.engine.cfQueryResultSetMetaData
$ColumnMetaData.access$800(Unknown Source)
at
com.naryx.tagfusion.cfm.engine.cfQueryResultSetMetaData.getColumnType(Unknown
Source)
at com.naryx.tagfusion.cfm.engine.cfQueryResultData.setRow(Unknown
Source)
at com.naryx.tagfusion.cfm.engine.cfQueryResultData.populate(Unknown
Source)
at
com.naryx.tagfusion.cfm.sql.cfSQLQueryData.executeAsStatement(Unknown
Source)
I am guessing - given the error - it's because the column name in the
returned record set is "TABLES_IN_DBNAME (validTableNameHere)", and
OBD might not like the parenthesis?
Want me to raise a bug or do some further troubleshooting, or..?
--
Adam
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
official manual: http://www.openbluedragon.org/manual/
Ready2Run CFML http://www.openbluedragon.org/openbdjam/
mailing list - http://groups.google.com/group/openbd?hl=en
