RE: CF 8 Enterprise Database Drivers
cfset drivernames = macromedia.jdbc.oracle.OracleDriver, macromedia.jdbc.db2.DB2Driver, macromedia.jdbc.informix.InformixDriver, macromedia.jdbc.sequelink.SequeLinkDriver, macromedia.jdbc.sqlserver.SQLServerDriver, macromedia.jdbc.sybase.SybaseDriver cfset drivernames=Replace(drivernames, ,,ALL) !--- replace all spaces --- cfloop index=drivername list=#drivernames# cfobject action=CREATE class=#drivername# name=driver type=JAVA cfset args= ArrayNew(1) cfset driver.main(args) cfoutput#drivername# is #driver.getMajorVersion()#.#driver.getMinorVersion()#br/cfoutput /cfloop This is from.. http://www.bpurcell.org/blog/index.cfm?mode=entryentry=988 Is there a particular reason you want to play with the drivers? John Mason [EMAIL PROTECTED] 770.337.8363 www.FusionLink.com - ColdFusion and Flex hosting Now offering ColdFusion 8 Enterprise hosting FREE Subversion hosting -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, November 02, 2007 4:03 PM To: CF-Talk Subject: CF 8 Enterprise Database Drivers Is there a document or some method to find out exactly what drivers - make and model number - come with ColdFusion 8 enterprise. It would also be nice to see a how to guide for the time one may have to get under the hood and take wrenches and screwdrivers to monkey with these drivers. My Googling skills so far has only turned up an Adobe Knowledge base article dated to the 5.0 era. TIA Ian ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292587 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 8 Enterprise Database Drivers
I don't know how to get a listing of all available drivers, but you could always check individual ones using one of these methods http://carehart.org/blog/client/index.cfm/2006/8/8/checking_jdbc_driver_version It assumes you know the driver names, but you could get that information by viewing the contents of macromedia_drivers.jar HTH Janet ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292586 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 8 Enterprise Database Drivers
Is there a particular reason you want to play with the drivers? John Mason Nope, I'm hoping not to have to. But we are beginning the documentation process on how to build a brand new server here. A place that has not seen a new server since CF 4.5 was new and shiny. There are some very odd database applications lurking around and I just want to start from a known point if we have to start getting creative moving these antique legacy applications to a new server. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292596 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF code inside database column
I am building a site where I want the user to be able to drop in various elements so they can customize the way the site looks. I have a custom tag that takes an argument of something like products.main and that corresponds to an item in the database which has a text field with html and possibly another cf tag to drop in something else inside that, like a set of links, i.e. products.links...so that's what i'm trying to accomplish. Maybe I could use Mary's suggestion and just use a standard placeholder and regex out the names and then run those through my custom tag wrapped around a savecontent and then regex back in the output into the text and then cfoutput all of that. I'll give that a try. You have to write it out to a file beforehand, and then cfinclude it... But I have to ask.. why are you doing this? Mark On 2/2/07, Robert F [EMAIL PROTECTED] wrote: I can't seem to remember if it's possible to get CF to parse/execute coldfusion tags that are inside a database column. For instance, I have a resultset that I am going to output and the column i'm outputting has html tags with a cf tag mixed in there as well. I thought maybe wrapping an Evaluate around it would work, but that does not work. Any other thoughts? I thought I had found a way to make this work a long time ago and don't remember what I did before. Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268568 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF code inside database column
You have to write it out to a file beforehand, and then cfinclude it... But I have to ask.. why are you doing this? Mark On 2/2/07, Robert F [EMAIL PROTECTED] wrote: I can't seem to remember if it's possible to get CF to parse/execute coldfusion tags that are inside a database column. For instance, I have a resultset that I am going to output and the column i'm outputting has html tags with a cf tag mixed in there as well. I thought maybe wrapping an Evaluate around it would work, but that does not work. Any other thoughts? I thought I had found a way to make this work a long time ago and don't remember what I did before. Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF code inside database column
I can't seem to remember if it's possible to get CF to parse/execute coldfusion tags that are inside a database column. For instance, I have a resultset that I am going to output and the column i'm outputting has html tags with a cf tag mixed in there as well. One way I've done this in the past is to basically create a pseudo-tag in the output that I can search and replace on. Something like [cfcode]. Just create different tags for whatever you need to include in the text, and run your output through a function that will search and replace on them. --- Mary Jo ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF in a database
The short answer is no. The long answer is you can do it by writing the CF from the DB to a file, and the include that file.However, that's nasty because you have the compilation cycle every request, and writing files and then deleting them adds a lot of overhead.Back in the pre-MX days, I know some people used this solution on a RAMDISK which probably worked pretty well, because there wasn't a precompile cycle (the CFML was interpreted). Cheers, barneyb -Original Message- From: Eric Jones [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 11:45 AM To: CF-Talk Subject: CF in a database I posted this on CF-Newbie as well. Sorry for the cross post. Hey all, I'm wondering is it possible to store CF Code in a database and then have the CF server execute it when it's extracted? if so can you give me a working example?? ERJ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF in a database
Yes and Yes Once it is saved into the DB such as the following into a field called: myCode : CFOUTPUTCFSET myName = Randy#myName#/CFOUTPUT When you call it from the DB to be ran on the server: CFOUTPUT QUERY=qGetMyCode #EVALUATE(qGetMyCode.myCode)# /CFOUTPUT -Original Message- From: Eric Jones [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 2:45 PM To: CF-Talk Subject: CF in a database I posted this on CF-Newbie as well. Sorry for the cross post. Hey all, I'm wondering is it possible to store CF Code in a database and then have the CF server execute it when it's extracted? if so can you give me a working example?? ERJ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF in a database (my apologies)
spoke to soon, doh nevermind, thats right, you can't cause the evaluae would to display the code as string and not as commands.. My apologies.. lack of sleep the last few days -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 2:53 PM To: CF-Talk Subject: RE: CF in a database The short answer is no. The long answer is you can do it by writing the CF from the DB to a file, and the include that file.However, that's nasty because you have the compilation cycle every request, and writing files and then deleting them adds a lot of overhead.Back in the pre-MX days, I know some people used this solution on a RAMDISK which probably worked pretty well, because there wasn't a precompile cycle (the CFML was interpreted). Cheers, barneyb -Original Message- From: Eric Jones [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 11:45 AM To: CF-Talk Subject: CF in a database I posted this on CF-Newbie as well. Sorry for the cross post. Hey all, I'm wondering is it possible to store CF Code in a database and then have the CF server execute it when it's extracted? if so can you give me a working example?? ERJ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF in a database
Lets not get into the ugliness of this!!! CFOUTPUT QUERY=qGetMyCode #EVALUATE(qGetMyCode.myCode)# /CFOUTPUT [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF in a database (my apologies)
23.5 hours and counting :-) -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 2:56 PM To: CF-Talk Subject: RE: CF in a database (my apologies) spoke to soon, doh nevermind, thats right, you can't cause the evaluae would to display the code as string and not as commands.. My apologies.. lack of sleep the last few days -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 2:53 PM To: CF-Talk Subject: RE: CF in a database The short answer is no. The long answer is you can do it by writing the CF from the DB to a file, and the include that file.However, that's nasty because you have the compilation cycle every request, and writing files and then deleting them adds a lot of overhead.Back in the pre-MX days, I know some people used this solution on a RAMDISK which probably worked pretty well, because there wasn't a precompile cycle (the CFML was interpreted). Cheers, barneyb -Original Message- From: Eric Jones [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 11:45 AM To: CF-Talk Subject: CF in a database I posted this on CF-Newbie as well. Sorry for the cross post. Hey all, I'm wondering is it possible to store CF Code in a database and then have the CF server execute it when it's extracted? if so can you give me a working example?? ERJ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF in a database (my apologies)
You're not totally off base.You could use evaluate for some things (expressions), but certainly not for any actual CFML.Not sure if that would be useful for anything, but it could well be. Cheers, barneyb -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 11:56 AM To: CF-Talk Subject: RE: CF in a database (my apologies) spoke to soon, doh nevermind, thats right, you can't cause the evaluae would to display the code as string and not as commands.. My apologies.. lack of sleep the last few days -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 2:53 PM To: CF-Talk Subject: RE: CF in a database The short answer is no. The long answer is you can do it by writing the CF from the DB to a file, and the include that file.However, that's nasty because you have the compilation cycle every request, and writing files and then deleting them adds a lot of overhead.Back in the pre-MX days, I know some people used this solution on a RAMDISK which probably worked pretty well, because there wasn't a precompile cycle (the CFML was interpreted). Cheers, barneyb -Original Message- From: Eric Jones [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 11:45 AM To: CF-Talk Subject: CF in a database I posted this on CF-Newbie as well. Sorry for the cross post. Hey all, I'm wondering is it possible to store CF Code in a database and then have the CF server execute it when it's extracted? if so can you give me a working example?? ERJ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF in a database (my apologies)
yeah I know ... just running on empty here. pushing 35 hours of non-sleep... soon I can go home and crash for awhile. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 3:03 PM To: CF-Talk Subject: RE: CF in a database (my apologies) You're not totally off base.You could use evaluate for some things (expressions), but certainly not for any actual CFML.Not sure if that would be useful for anything, but it could well be. Cheers, barneyb -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 11:56 AM To: CF-Talk Subject: RE: CF in a database (my apologies) spoke to soon, doh nevermind, thats right, you can't cause the evaluae would to display the code as string and not as commands.. My apologies.. lack of sleep the last few days -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 2:53 PM To: CF-Talk Subject: RE: CF in a database The short answer is no. The long answer is you can do it by writing the CF from the DB to a file, and the include that file.However, that's nasty because you have the compilation cycle every request, and writing files and then deleting them adds a lot of overhead.Back in the pre-MX days, I know some people used this solution on a RAMDISK which probably worked pretty well, because there wasn't a precompile cycle (the CFML was interpreted). Cheers, barneyb -Original Message- From: Eric Jones [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 11:45 AM To: CF-Talk Subject: CF in a database I posted this on CF-Newbie as well. Sorry for the cross post. Hey all, I'm wondering is it possible to store CF Code in a database and then have the CF server execute it when it's extracted? if so can you give me a working example?? ERJ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF in a database (my apologies)
If the data does not change that often, you should be okay writing it to a cfml file and then including it. On future uses of the data you can check to see if the file already exists and if not re-generate it, and if it does, just include it. Whenever the data in the DB record is updated, also delete the generated cfml file which will force the script it to re-generate it the next time it is requested. I do this with one of my apps and it works good. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF in a database
I've not tried this in MX (have they actually improved it that much?) but in previous version EVALAUTE() would NOT evaluate tags, only expressions. So you could do EVALUATE(#myName#) or EVALUATE(#Len(myName)#) or even EVALUATE(#Iif(Len(myName), DE(Hi), DE(Bye))#) But NOT EVALUATE(cfoutput#myName#/cfoutput) Of course since 5.0 you could also abstract much of the Tag work you might need into UDFs allowing you to perform much more complex evaluations.But in the end also remember that Evaluate() is one of the most expensive and slowest of the CF functions so that that into account. Jim Davis _ From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 2:55 PM To: CF-Talk Subject: RE: CF in a database Yes and Yes Once it is saved into the DB such as the following into a field called: myCode : CFOUTPUTCFSET myName = Randy#myName#/CFOUTPUT When you call it from the DB to be ran on the server: CFOUTPUT QUERY=qGetMyCode #EVALUATE(qGetMyCode.myCode)# /CFOUTPUT -Original Message- From: Eric Jones [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 2:45 PM To: CF-Talk Subject: CF in a database I posted this on CF-Newbie as well. Sorry for the cross post. Hey all, I'm wondering is it possible to store CF Code in a database and then have the CF server execute it when it's extracted? if so can you give me a working example?? ERJ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF in a database (my apologies)
If the data does not change that often, you should be okay writing it to a cfml file and then including it. On future uses of the data you can check to see if the file already exists and if not re-generate it, and if it does, just include it. Whenever the data in the DB record is updated, also delete the generated cfml file which will force the script it to re-generate it the next time it is requested. I do this with one of my apps and it works good. cfset requestedpage = 5.cfm !--- include CFML from Record ID 5 --- cfif not fileExists(#request.fileroot#generatedCFML/#requestedpage#) cfquery name=myCFML select * from tbl_CFMLRespository where ID=5 /cfquery ! write the cfml to a file --- cfilfe action="" file=#request.fileroot#generatedCFML/#requestedpage# output=#myCFML.cfml# /cfif !--- include the generated cfml file --- cfinclude template=generatedCFML/#requestedpage# On your page where the CFML in the Database gets updated, you would simply delete the file after it was updated: cfquery name=myCFML update tbl_CFMLRespository set cfml='cfif x is 7 or z is 9cfset myFlag=true/cfif' where ID=5 /cfquery ! delete the cfml file if it exists --- cfif fileExists(#request.fileroot#generatedCFML/5.cfm) cfilfe action="" file=#request.fileroot#generatedCFML/5.cfm /cfif Brook P.S This is Pseudo Code! At 12:11 PM 4/9/2004, you wrote: yeah I know ... just running on empty here. pushing 35 hours of non-sleep... soon I can go home and crash for awhile. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 3:03 PM To: CF-Talk Subject: RE: CF in a database (my apologies) You're not totally off base.You could use evaluate for some things (expressions), but certainly not for any actual CFML.Not sure if that would be useful for anything, but it could well be. Cheers, barneyb -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 11:56 AM To: CF-Talk Subject: RE: CF in a database (my apologies) spoke to soon, doh nevermind, thats right, you can't cause the evaluae would to display the code as string and not as commands.. My apologies.. lack of sleep the last few days -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 2:53 PM To: CF-Talk Subject: RE: CF in a database The short answer is no. The long answer is you can do it by writing the CF from the DB to a file, and the include that file.However, that's nasty because you have the compilation cycle every request, and writing files and then deleting them adds a lot of overhead.Back in the pre-MX days, I know some people used this solution on a RAMDISK which probably worked pretty well, because there wasn't a precompile cycle (the CFML was interpreted). Cheers, barneyb -Original Message- From: Eric Jones [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 11:45 AM To: CF-Talk Subject: CF in a database I posted this on CF-Newbie as well. Sorry for the cross post. Hey all, I'm wondering is it possible to store CF Code in a database and then have the CF server execute it when it's extracted? if so can you give me a working example?? ERJ _ _ -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:159520This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=905.825.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=36 [] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF - post to database question
Both options are possible, although the e-mail option would have more possible points of failure (i.e. mail not deliverednot read properlyforgot the attachement etc.) The only really tough part here is extracting the data from the file.There are many customs tags to extract data from Excel files, so have a look at the MM Exchange.Grabbing data out of PROPERLY formatted flat file (CSV...tab delimited etc.) is very easy (but if the formatting is off you're up the creek).You simply use CFFILE to read the file in question.That is read into a variable which you then loop through to parse out the records.Remember that the first row is usually the column names...other than that pay specialattention to the row delimiters and the column delimiters (these will allow you to seperate out each record and then each field in that record).On each pass of the loop you insert your data. HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Michael Grove To: CF-Talk Sent: Monday, November 24, 2003 8:44 AM Subject: CF - post to database question I am looking for a way to post information directly to a database from a csv, excel or text delimited file. I am looking for one of two options. Option one would give a user the ability to email the file to a specific email address and the server/web app would pull the data from the file automatically and post it in a database. Option two would be to simply give the user the ability to access a web form and upload the file to the server, which in turn would place the data in a database. Can someone point me in the right direction? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF with Advantage Database Server ? Anyone?
Coming from a Clipper and FoxPro background, I bought and installed Advantage Database Server but never got around to getting it setup with Cold Fusion (client decided to go with SQL Server). But, talking with the folks at Extended Systems (vendor for Advantage Database Server), they assured me that it will work via their ODBC driver. However, since the ODBC driver is not in the CF Admin ODBC picklist, you will probably have to configure it like I did with MySQL and its ODBC driver. I gave a paper at the Annapolis Cold Fusion User Group meeting May 24th on what I did to get MySQL Database Server configured with CF. Follow that analogy and I think you will be able to get Advantage Database Server configured. The Extended Systems Folks said they would help, but I never got around to asking them for assistance. Their 800 number is 800-235-7576. If you would like the paper, it will be up on the Annapolis User Group Site soon http://www.ancfug.com/meetings/ or just email me back and I will send it to you -- it's about 900mb so I didn't want to send it out via my 56k line until I am sure you are interested. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Pablo Varando [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:40 PM To: CF-Talk Subject:CF with Advantage Database Server ? Anyone? I am faced with a customer that is needing a coldfusion powered site, but his company uses a database I've never heard of called Advantage Database Server. It does have OLEDB and ODBC capabilities, but am unsure as if ColdFusion could handle this project. I thought I'd ask everyone here and see if anyone has had experience with this database and if it could be done. There is more information on this database at: http://www.advantagedatabase.com ODBC/OLE Support at: http://www.advantagedatabase.com/ADS/Product+Detail/_FAQs+and+Data+Sheet s..htm#ProductFAQs Please reply if you can help. Thanks! Pablo Varando CFM-Resources.Com http://www.cfm-resources.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF with Advantage Database Server ? Anyone?
Yes I would be very interested in receiving that paper, I'm faced with the creation of this project, but amd having trouble with making the DB connection, any help (no matter how big it is :) I would appreciate. Thank you very much! Pablo - Original Message - From: Arden Weiss [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 26, 2001 3:21 PM Subject: RE: CF with Advantage Database Server ? Anyone? Coming from a Clipper and FoxPro background, I bought and installed Advantage Database Server but never got around to getting it setup with Cold Fusion (client decided to go with SQL Server). But, talking with the folks at Extended Systems (vendor for Advantage Database Server), they assured me that it will work via their ODBC driver. However, since the ODBC driver is not in the CF Admin ODBC picklist, you will probably have to configure it like I did with MySQL and its ODBC driver. I gave a paper at the Annapolis Cold Fusion User Group meeting May 24th on what I did to get MySQL Database Server configured with CF. Follow that analogy and I think you will be able to get Advantage Database Server configured. The Extended Systems Folks said they would help, but I never got around to asking them for assistance. Their 800 number is 800-235-7576. If you would like the paper, it will be up on the Annapolis User Group Site soon http://www.ancfug.com/meetings/ or just email me back and I will send it to you -- it's about 900mb so I didn't want to send it out via my 56k line until I am sure you are interested. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Pablo Varando [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:40 PM To: CF-Talk Subject: CF with Advantage Database Server ? Anyone? I am faced with a customer that is needing a coldfusion powered site, but his company uses a database I've never heard of called Advantage Database Server. It does have OLEDB and ODBC capabilities, but am unsure as if ColdFusion could handle this project. I thought I'd ask everyone here and see if anyone has had experience with this database and if it could be done. There is more information on this database at: http://www.advantagedatabase.com ODBC/OLE Support at: http://www.advantagedatabase.com/ADS/Product+Detail/_FAQs+and+Data+Sheet s..htm#ProductFAQs Please reply if you can help. Thanks! Pablo Varando CFM-Resources.Com http://www.cfm-resources.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF with Advantage Database Server ? Anyone?
ColdFusion can connect to ANY ODBC compliant database. Mark Warrick - Fusioneers.com Email: [EMAIL PROTECTED] Phone: 714-547-5386 http://www.fusioneers.com http://www.warrick.net -Original Message- From: Pablo Varando [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 7:40 PM To: CF-Talk Subject: CF with Advantage Database Server ? Anyone? I am faced with a customer that is needing a coldfusion powered site, but his company uses a database I've never heard of called Advantage Database Server. It does have OLEDB and ODBC capabilities, but am unsure as if ColdFusion could handle this project. I thought I'd ask everyone here and see if anyone has had experience with this database and if it could be done. There is more information on this database at: http://www.advantagedatabase.com ODBC/OLE Support at: http://www.advantagedatabase.com/ADS/Product+Detail/_FAQs+and+Data +Sheets..htm#ProductFAQs Please reply if you can help. Thanks! Pablo Varando CFM-Resources.Com http://www.cfm-resources.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF with Advantage Database Server ? Anyone?
it to you -- it's about 900mb so I didn't want to send it out via my 56k 900mb? What the heck is in that paper? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF with Advantage Database Server ? Anyone?
Whoops -- 900kb of course... ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Tony Schreiber [SMTP:[EMAIL PROTECTED]] Sent: Saturday, May 26, 2001 5:24 PM To: CF-Talk Subject:RE: CF with Advantage Database Server ? Anyone? it to you -- it's about 900mb so I didn't want to send it out via my 56k 900mb? What the heck is in that paper? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Variables in database...
you have to put a CFOUTPUT /cfoutput around the variables or CFOUTPUT query="blah" CFOUTPUT has to be around all ## variables in order to be processed as anything other then text/html Bill Wheatley Director of Development Allaire Certified ColdFusion Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: "Steve Reich" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, March 25, 2001 4:10 PM Subject: CF Variables in database... I have data in my database that contains CF varaibles. For example, "Hello, Mr. #lname#" might be in my database. I call this data from a query and insert it into a page that has lname defined. So I want it to assign a value to the variable. But when I out the code, it is returned as #lname#, complete with pound signs and CF ignores it. How can I run a query that returns variables to be processed by CF server? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Variables in database...
Works perfect! Thanks. "William Wheatley" [EMAIL PROTECTED] wrote in message news:000701c0b57e$e8c05740$[EMAIL PROTECTED]... you have to put a CFOUTPUT /cfoutput around the variables or CFOUTPUT query="blah" CFOUTPUT has to be around all ## variables in order to be processed as anything other then text/html Bill Wheatley Director of Development Allaire Certified ColdFusion Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: "Steve Reich" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, March 25, 2001 4:10 PM Subject: CF Variables in database... I have data in my database that contains CF varaibles. For example, "Hello, Mr. #lname#" might be in my database. I call this data from a query and insert it into a page that has lname defined. So I want it to assign a value to the variable. But when I out the code, it is returned as #lname#, complete with pound signs and CF ignores it. How can I run a query that returns variables to be processed by CF server? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Progress Database ODBC drivers
I ran into this sort of issue with Sybase. We needed to create a ODBC datasource with the SYBASE tools and connectivity options. I think we actually tested with M$'s ODBC test tool. So, I would check to see what Progress offers in the way of ODBC connections. Assuming they do, create an ODBC source with those tools, refer to it via CF, and away you go. Steve At 08:00 PM 6/27/2000 GMT, Cold Fusion wrote: I have an IIS box running CF451 and I want to be able to connect to a progress database which runs my companies financial applications. It runs on HP-UX. Anyway, there is no native CF support for progress as far as I can tell, but can someone pouint me the way to some instructions on how to connect? I know I need to install an ODBC driver on the IIS server, but does CF detect it and automagically add it to the list of drivers in CF Server?? The Progress DBA is stoked to get this working so any help is greatly appreciated:) Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Stephen Garrett GPS [EMAIL PROTECTED] (360) 896-2714 ICQ# 10776767 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF and Progress Database ODBC drivers
So long as you can connect to the database via standard ODBC, you should be able to set it up as a datasource. If the pro version of CF 451 can't do it, then possibly the Enterprise edition would. Or you might have to get a 3rd party driver. A 3rd party driver might work, but Allaire's not going to give you any technical support for that. Anyway, try setting up a datasource first via the control panel and see what happens. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Cold Fusion [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 27, 2000 1:01 PM To: [EMAIL PROTECTED] Subject: CF and Progress Database ODBC drivers I have an IIS box running CF451 and I want to be able to connect to a progress database which runs my companies financial applications. It runs on HP-UX. Anyway, there is no native CF support for progress as far as I can tell, but can someone pouint me the way to some instructions on how to connect? I know I need to install an ODBC driver on the IIS server, but does CF detect it and automagically add it to the list of drivers in CF Server?? The Progress DBA is stoked to get this working so any help is greatly appreciated:) Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [cf-talk][OT] : Database Theory
If your DB allows constraints to be function calls, then how about setting up a generic values table and using a stored procedure to validate, e.g. CheckValue ('TABLE', 'COLUMN', mycolumn) the stored procedure would access the table 'GENERIC_VALUES' which has a structure like: table_name, column_name, value with multiple rows for each table_name/column_name combination, e.g. Row 1 table_name = 'employee' column_name = 'gender' value= 'male' Row 2 table_name = 'employee' column_name = 'gender' value= 'female' Row 3 table_name = 'employee' column_name = 'gender' value= 'not given' Could also fire this off a trigger if you can't make the call in the constraint. -- Paul Wakefield All opinions expressed herein are those of the author and not of The Board of Executors -Original Message- From: Ken M. Mevand [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 12, 2000 10:09 AM To: 02 cf-talk Subject: [cf-talk][OT] : Database Theory this is a question of db design. suppose i have a field in a table that can contain only 3 values, eg. Membership type - 1=Ordinary, 2=Associate and 3=Founding. I would like to check how you ensure that it contains only these values. i see that there are 3 methods: a. constraint it by foreign key. meaning there is a table with only 3 rows of data, b. stored as an integer value (1, 2 or 3), use check constraint to enforce it. c. stored as a string ("ordinary", "associate" or "founding"). use check constraint to enforce it. i prefer method (a) for this reason : there is no need for the CF templates to interprete the meaning of the values. however, it seems quite silly to have a table with 3 rows on data only. but there are also advantage of future expansion. but what about gender which has only 2 possible value (at least in the foreseeable future). what's the general opinion on this? thanks. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.