Multiple data sources in one query?

2007-08-17 Thread Charles Love
Does anyone know if there is a way to access data from multiple data sources in 
one query or joined query? 

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286492
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Data source 'source_name' verification failed.????

2007-08-08 Thread Charles Love
Thanks, Loathe...That did it!!

I got all the info I needed to solve the problem.  Turns out I had different 
data sources within the same cftransaction and that is a CF error.  I was 
catching the error but only showing the message.  The cfcatch.Detail shows the 
REAL reason for the error

Thanks again... Good save 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285746
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Data source 'source_name' verification failed.????

2007-08-08 Thread Charles Love
I have a ColdFusion page that is accessing two different ColdFusion data 
sources from the same page.  I have many queries that are using the first 
source and they all work.  I have TWO queries that access the second source and 
one of them works and the other doesn't.  They are using the same data source 
definition and point to the same ORACLE schema.  The second one errors off 
giving the error: 'Data source 'source_name' verification failed.'  

I have removed the actual source name for security purposes.  Has anyone ever 
seen this?  Can you suggest a way to debug or isolate?  Any help would be 
appreciated.  I am at the end of my ideas.



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285721
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Showing ICONS is a SELECT list

2007-06-22 Thread Charles Love
Does anyone know if it is possible to include ICONS in a select list as the 
display value along with or in place of text?  If so, can you give me an 
example or point me to an example.

Thanks, Monty

~|
ColdFusion MX7 by AdobeĀ®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281938
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4