I am not totally certain, but remove the [skyfocus.] that appears in your
WHERE statement of the first Query.
The query already knows that it is pulling from [skyfocus.] if your
datasource {focusadmin} is already pointing to [skyfocus.]
Hope this helps.
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-----Original Message-----
From: Tony Turner -CFUG [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 09, 2000 10:08 AM
To: CF-Talk
Subject: Help - Please
Hi
I have a question:
We have a customer who is going mad as he gets and error whe he runs two
types or queries.
I never do what he is trying to do and don't understand why?
Queries as below:
They both appear to have the same datasource name (fine) but then the first
explicitly
defines the database. (FROM SKYFOCUS.CC_DATA)
The database is MySQL 3.22.32 and the database in ColdFusion and MySQL both
have the same username and password on and localhost access in MySQL. The
database is called skyfocus in MySQL.
Should you be able to call a connection like this in test1 in this manner.
http://www.hotchilli.com/test1_tony.cfm ----------
Errors
<cfquery name="GOT_CC" datasource="focusadmin">
SELECT CD_CC_NAME, CD_CC_ID, CD_CC_MSO_ID
FROM SKYFOCUS.CC_DATA
</CFQUERY>
http://www.hotchilli.com/test2_tony.cfm ----------
No Error (would expect a blank page)
<CFQUERY NAME="MSO" DATASOURCE="focusadmin">
SELECT md_mso_name
FROM mso_data
</CFQUERY>
Please - Please if this is standard practice could someone point me to some
documentation on the Allaire site. I would in perl or php3/4 explicitly
define the database in the connection/query but ColdFusion? Whats the
benefit?
Thanks
Tony
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
