I ran into a problem today when checking out the COAPI section of the
Admin. The code errored on a Query of a Query from the the
AlterType.cfc. It looked like it was trying to get all tables with a
name LIKE 'DMFLASH_A%'. It seemed to be using a QoQ because the MySQL
SHOW TABLES statement doesn't support the use of functions that help
ignore case like uppercase.
Here's the code...
<cfquery datasource="#application.dsn#" name="qArrayTables1">
show tables
</cfquery>
<cfquery dbtype="query" name="qArrayTables">
select #qArrayTables1.columnlist# as name
from qArrayTables1
where upper(#qArrayTables1.columnlist#) like
'#ucase(arguments.typename)[EMAIL PROTECTED]' escape '@'
</cfquery>
My problem was because my database name had a dash in it. I think
this may be a problem with QoQ in which case there's not much that
could be done. But I thought you all should be aware of it. Luckily
I know the owner/sysadmin of my host company personally and he was
able to change the database name for me, something I don't normally
have any control over.
--
Ryan P. Miller
[EMAIL PROTECTED]
---
You are currently subscribed to farcry-dev as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
