Re: Need help
when you are working with cf8 ajax ui controls, you should either have
all your js in an external file, or, if you have js in the same file,
your js functions must be declared as
functionname = function(arguments) {
}
not
function functionname(arguments) {
}
hth
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Don L wrote:
Ok, my attempt of wrestling with dynamically setting iframe attributes inside
a CFWINDOW has been in vain, some of you may have a solution, Andrew Scott?
Terry Schmitt? and more...
a CFWINDOW-launched template looks like this:
(Please note the template would run just fine if not launched via the
CFWINDOW tag, but that's not a choice at this point)
-- run a query named myData here
html
head
titleCouldn't you be cooperative?/title
/head
body
script type=text/javascript
function init() {
cfoutput query=myData
frames.dataRow#currentrow#.document.designMode = On;
...
/cfoutput
/script
body onload=init()
cfoutput query=myData
iframe id==dataRow#currentrow# name=dataRow#currentrow#/iframe
/cfoutput
/body
/html
Thanks.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301828
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion 8 on Leopard - all of a sudden stopped working
Andrew, I actually had Matthew's MAMP way of doing things working for about an hour and then it just stopped running and I couldn't get it back up again. I tell you your best bet is to go try to get in the prerelease Updater 1 program. I can't tell you anything about it or if I am actually in it and I can't tell you that it runs wonderfully and I can't tell you that it could save you many hours of headaches :-) J.J. On Sat, Mar 22, 2008 at 9:33 PM, Andy Matthews [EMAIL PROTECTED] wrote: I've had CF8 running on my Intel Mac Mini for about 2 months now. I followed a tutorial which told me to use MAMP rather than the built in version of Apache: http://www.flashalisious.com/2007/12/14/installing-coldfusion8-on-leopard-using-mamp/ Anyway, that's not the point as it's been running great since I got it working. However, I just did the Apple update a few days ago and now all of a sudden I can't get CF running right. Apache starts just fine, but when I try to view a CF page in the browser, I just see source code. I've restarted Apache and CF8 multiple times to no avail. I've double checked the httpd.conf to make sure that .cfm pages are listed there and it still doesn't work. Does anyone have ANY input whatsoever? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301830 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Round Up
is there any function or easy to always round up a number, please? Jenny ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Round Up
is there any function or easy to always round up a number, please? Jenny Round() http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt274.htm Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Round Up
Did this but it looks messy, maybe there is a better way? cfoutput cfset Num = 1.1 cfset RoundNum = #round(Num)# Cfif roundnum lt num cfset roundNum = roundNum +1 /Cfif #roundNum# /cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301832 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Round Up
Ceiling actually: http://www.cfquickdocs.com/#Ceiling Round might round down; the OP wants to round up always. On Sun, Mar 23, 2008 at 9:04 PM, Will Tomlinson [EMAIL PROTECTED] wrote: is there any function or easy to always round up a number, please? Jenny Round() http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt274.htm Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Round Up
Sorry, the link shoudl be http://www.cfquickdocs.com/#Ceiling?getDoc=Ceiling On Sun, Mar 23, 2008 at 8:08 PM, James Holmes [EMAIL PROTECTED] wrote: Ceiling actually: http://www.cfquickdocs.com/#Ceiling Round might round down; the OP wants to round up always. On Sun, Mar 23, 2008 at 9:04 PM, Will Tomlinson [EMAIL PROTECTED] wrote: is there any function or easy to always round up a number, please? Jenny Round() http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt274.htm Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301834 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Round Up
Ceiling actually: http://www.cfquickdocs.com/#Ceiling Oh heck. I thought it might be ceiling(), but figured it didnt matter if it went down . Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: New To CF
Just responded to the same posting on cf-newbie but will that response in here as well. Bruce, That will get you started with basic CF but to build data driven sites you'll also need some sort of RDMS such as MSSQL, Access, MySQL or some other such product. If you're a visual learner, MS Access is great for getting started as it lends itself to creating visual models or prototyping if you will. As for the best way to learn CF really depends on your learning style, if you're more a visual learner then perhaps what is offered at http://lynda.com/ would be a good starting point for you. If you're fine with have printed materials as a guide then I would suggest purchasing a copy of the latest CF WACK http://www.forta.com/books/0321125169/ will work for you. IMHO having a copy of WACK is a tool worth having in your box and well worth the investment. There are a number of sites out there that can help you jump right in a get up a running quickly. One site I used a good bit to start with was easycfm.com http://www.easycfm.com/ with lots of real world examples and tutorials. The short answer to what is the best way to learn CF is by doing :) I might add that http://cflearn.com might also provide an opportunity to learn about debugging :) HTH Bob Imperial art design development 6204 Lead Mine Road Raleigh, NC 27612 919-602-3118 www.imperialart.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301836 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New To CF
Welcome to CF. You are on your way and in the right direction. I would suggest, before you do any 'major' reading on the subject, that: 1. First you create a very simple .cfm page and test to verify your installation is working. Open a text editor, type in cfoutput#now()#/cfoutput and save it as index.cfm in the webroot of your local site. Open that new page in a browser and verify that you do not see the actual text you typed in, but you see the current time in 'timestamp' format. 2. Go to a good online tutorial site and follow the steps exactly so that you can get a feel for the language. I have heard some good things about http://cflearn.com/ 3. If you are an experienced web developer, take a page you have built in another language (PHP, .NET, ASP, etc) and translate its functionality into ColdFusion. Feel free to ask any questions of us here. This list and the house of fusion's CF-Newbie list can be very helpful to you. Good Luck!! William ::-Original Message- :: ::Sent: Saturday, March 22, 2008 1:18 PM ::To: CF-Talk ::Subject: New To CF :: ::I just upgraded and installed my Adobe software. I installed ColdFusion 7 ::developer version. Is that all I need to produce CF sites? If not what ::do I need and what is the best way to learn? ::Thanks :: :: Thanks for your reply. How do I get version 8? Is it free? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301837 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New To CF
Everything that William said and a few other items. The adobe site has a quick start guide: http://www.adobe.com/devnet/coldfusion/?navID=gettingstarted The developer center is a good place to start as well http://www.adobe.com/devnet/coldfusion/ An editor geared for CF is a good thing to have. The three most popular (and often debated) choices are (in no particular order) - Homesite/CFStudio (w/Free evaluation) ~ $100 No longer being actively developed by Adobe (CFStudio has been discontinued) but is a long time favorite of many in the community (myself included) http://www.adobe.com/products/homesite/ --- CFEclipse Free and open source and VERY capable. My personal favorite. http://www.cfeclipse.org/ You will want to install the ColdFusion 8 Help Files and Extensions for Eclipse http://www.adobe.com/support/coldfusion/downloads.html Here are some Video tutes on installing http://www.cfeclipse.org/cfeclipsetv.cfm http://www.cfeclipse.org/cfeclipsetv.cfm Dreamweaver $399 retail (w/Free evaluation)- $200 - $400 at various online stores and ebay. It is an excellent tool for web development. http://www.adobe.com/products/dreamweaver/ Hope this helps. Happy coding! G On Sat, Mar 22, 2008 at 4:18 PM, Bruce Kersten [EMAIL PROTECTED] wrote: I just upgraded and installed my Adobe software. I installed ColdFusion 7 developer version. Is that all I need to produce CF sites? If not what do I need and what is the best way to learn? Thanks Thanks so much for all of these sources. I have Homesite 5.5. It came with Studio 8. Can I use that? Best regards ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New To CF
Thanks so much for all of your help. I will check out these sources. I am sure I will have more questions as I go.Best regards, Bruce Kersten Savant Creative Group http://www.savantcreative.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New To CF
Just responded to the same posting on cf-newbie but will that response in here as well. Bruce, That will get you started with basic CF but to build data driven sites you'll also need some sort of RDMS such as MSSQL, Access, MySQL or some other such product. If you're a visual learner, MS Access is great for getting started as it lends itself to creating visual models or prototyping if you will. As for the best way to learn CF really depends on your learning style, if you're more a visual learner then perhaps what is offered at http://lynda.com/ would be a good starting point for you. If you're fine with have printed materials as a guide then I would suggest purchasing a copy of the latest CF WACK http://www.forta.com/books/0321125169/ will work for you. IMHO having a copy of WACK is a tool worth having in your box and well worth the investment. There are a number of sites out there that can help you jump right in a get up a running quickly. One site I used a good bit to start with was easycfm.com http://www.easycfm.com/ with lots of real world examples and tutorials. The short answer to what is the best way to learn CF is by doing :) I might add that http://cflearn.com might also provide an opportunity to learn about debugging :) HTH Bob Imperial art design development 6204 Lead Mine Road Raleigh, NC 27612 919-602-3118 www.imperialart.com Thanks so much for your help. I will check these great sources and I am sure to beck with questions. Best regards, Bruce Kersten Savant Creative Group http://savantcreative.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Google Maps, CF and Ajax
i would be interested in learning how to create custom regions in google maps, based on zip codes. say i pull results from my sales force db in cf8. sales guy one territory is zip code 43202, 43206 43215 i would like to see a border of those combined zip codes in gmaps, with other sats based on sales... not even sure where to start. any help, advice would be stellar! thanks -paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.
Hi: I was very excited when I tried using CFGRID cause it could make a very nice difference in my application but when I tested the page I saw FireFox returned an error and wanted JRE. Windows Vista seems to have it by default but Windows XP doesn't and still most of the users/customers use XP. Is there anyway to use CFGRID without the need of JRE? Thanks Ali ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.
Make sure you use format=html. If you do not provide a format attribute it defaults to applet. - applet - generates a java applet - flash - generates a flash grid control - html - generates an ajax based html grid control that supports data binding - xml - generates an xml representation of the grid Dan On Sun, Mar 23, 2008 at 8:35 AM, Ali [EMAIL PROTECTED] wrote: Hi: I was very excited when I tried using CFGRID cause it could make a very nice difference in my application but when I tested the page I saw FireFox returned an error and wanted JRE. Windows Vista seems to have it by default but Windows XP doesn't and still most of the users/customers use XP. Is there anyway to use CFGRID without the need of JRE? Thanks Ali ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.
Hi: Thanks it worked just fine. I have another question if you don't mind. Can I set grid cells that if I double click on one of them I can select one from a combobox(list/menu)? Right now it works just fine with Yes/No cells and when I double click on them a check box appears, exactly the way I need it but I need to select from a list of months and a list of Genders (male , female). Is it possible? Thanks ALi On Sun, Mar 23, 2008 at 4:19 PM, Dan Vega [EMAIL PROTECTED] wrote: Make sure you use format=html. If you do not provide a format attribute it defaults to applet. - applet - generates a java applet - flash - generates a flash grid control - html - generates an ajax based html grid control that supports data binding - xml - generates an xml representation of the grid Dan On Sun, Mar 23, 2008 at 8:35 AM, Ali [EMAIL PROTECTED] wrote: Hi: I was very excited when I tried using CFGRID cause it could make a very nice difference in my application but when I tested the page I saw FireFox returned an error and wanted JRE. Windows Vista seems to have it by default but Windows XP doesn't and still most of the users/customers use XP. Is there anyway to use CFGRID without the need of JRE? Thanks Ali ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Round Up
hi Will .. round makes 1.1 into 1 ... need 1 to be 2 .. -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 23 March 2008 12:05 To: CF-Talk Subject: Re: Round Up is there any function or easy to always round up a number, please? Jenny Round() http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt274.htm Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Round Up
sweet .. thanks James -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 23 March 2008 11:08 To: CF-Talk Subject: Re: Round Up Ceiling actually: http://www.cfquickdocs.com/#Ceiling Round might round down; the OP wants to round up always. On Sun, Mar 23, 2008 at 9:04 PM, Will Tomlinson [EMAIL PROTECTED] wrote: is there any function or easy to always round up a number, please? Jenny Round() http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt274.htm Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Round Up
Round might round down; Well, as far as I know, this is what round means, no? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301847 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MS SQL DB Size
I need to be able to query the size of an MS Sql database and get the value into a variable. I've seen that there are stored procedures, but I have no idea how I would go about using them inside CF. Is there an easy way to go about this, please? J ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Images in the database good or bad?
put the table holding the images on it's own file group back that up separately from the main db. you do not have to back up the images along w/the rest of the data. This is true until some one adds a new image to the database, then the whole table with all the images will have to be backed up. If you store images as ordinary files, only the new image will be backed up. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Images in the database good or bad?
But, you didn't take into account the amount of time it will take to backup the file system. What's important is that images are generally not modified, only added or deleted, so only new files will have to copied into the backup. Is the images are in a table, the whole table will have to backed up. Unless there exists some backup system that will only copy new records? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Images in the database good or bad?
Some databases can automatically extract metadata (EXIF, for example). Now this is completely ridiculous: if you really need things like what's in EXIF, you extract it first and store it in an appropriate record about the file, just as well as width or height etc. This does not justify storing all pixels and colors as well in the database. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images in the database good or bad?
In my opinion, a database is used to organize related data. In this case, a binary file would be related to its metadata that you would normally store in a database. Michael, if you have a table to organize data related to employees, will you store the employees in the employee table? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301852 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MS SQL DB Size
Try this: cfstoredproc procedure=sp_helpdb datasource=DataSourceName cfprocparam cfsqltype=CF_SQL_VARCHAR dbvarname=Name type=In value=DatabaseName cfprocresult name=MyResult /cfstoredproc cfoutput query=MyResult #DB_Size# /cfoutput Jenny Gavin-Wear wrote: I need to be able to query the size of an MS Sql database and get the value into a variable. I've seen that there are stored procedures, but I have no idea how I would go about using them inside CF. Is there an easy way to go about this, please? J ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need help
when you are working with cf8 ajax ui controls, you should either have
all your js in an external file, or, if you have js in the same file,
your js functions must be declared as
functionname = function(arguments) {
...
}
not
function functionname(arguments) {
...
}
hth
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Yes. I read about them and have tried them in vain. Here's the detailed test
result, please take a look. Many thanks.
Test Env:
a) IE7 on XP
b) FF2 on XP
Test Outcome:
Not working; the js in question has not be called
DETAILS:
1. The test cf template in question (it's inside a CFWINDOW) reads
html
head
script type=text/javascript src=/js/TestIframes.js/script
/head
body
main page
form id=nutsFrm method=post
iframe name=out id=out src=Untitled1.html contenteditable=true
style=width:300px; height:150px/iframebr/
/form
form id=nutsFrm2 method=post
iframe name=nuts2 id=nuts2 style=width:300px; height:150px/iframebr/
/form
cfset AjaxOnLoad = init
/body
/html
2. The TestIframes.js reads
init = function() {
alert(hi);
// method 1
var doc = self.frames['out'].document;
if ('designMode' in doc) {
self.frames['out'].document.designMode = 'on';
}
doc.clear();
doc.open('text/html','replace');
doc.write('htmlbodyHello!/body/html');
doc.close();
// method 2
frames.nuts2.document.designMode = On;
var s2 = plain text test;
var D2 = frames['nuts2'].document;
D2.open();
D2.write('html' + s2 + '/html');
D2.close();
}
3. Response (by Firebug)
html
head
script type=text/javascript src=/js/TestIframes.js/script
/head
body
main page
form id=nutsFrm method=post
iframe name=out id=out src=Untitled1.html
contenteditable=true/iframebr/
/form
form id=nutsFrm2 method=post
iframe name=nuts2 id=nuts2/iframebr/
/form
/body
/html
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301854
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Images in the database good or bad?
Unless there exists some backup system that will only copy new records? Why, as a matter of fact, there is. It's called a differential database backup. http://msdn2.microsoft.com/en-us/library/ms181092.aspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Images in the database good or bad?
Now this is completely ridiculous: if you really need things like what's in EXIF, you extract it first and store it in an appropriate record about the file, just as well as width or height etc. This does not justify storing all pixels and colors as well in the database. Perhaps this feature alone doesn't justify storing binary data within the database, but collectively, the advantages can outweigh the disadvantages. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: open source ColdFusion UML CASE tool
thanks steve we will give this a go then if you are funding it useful thanks again richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: open source ColdFusion UML CASE tool
Since UML is a software-independent specification for modeling components, I would be surprised if you found one geared specifically to ColdFusion or Flex. hi steve sorry i should have been more specific what i mean by this is code generation... i was wondering whether there was a uml tool that took the models to build cfc and cfm code. thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: open source ColdFusion UML CASE tool
At work I use Magic Draw, along with the Team Server. Its very good, very powerful, but too powerful for a lot of my development work. But it has some very nice round trip features if you're moving back and forth between your diagrams and test code. Recently I used it to help me reverse engineer a set of java classes. I found it awkward in some ways, but that seemed more personal preference. Its biggest drawback is that its very expensive. Even more so when you're using their team server to collaboratively design a system. Magic Draw has both PC and Mac versions, it also has an eclipse plugin. Unfortunately I cannot use that because its incompatible with the Team Server we use at work Another more basic UML tool is Blu-Jay. It has all the basic diagrams etc. Its free and offers some round trip capacities. What I've found I've been using more and more often at work is the UML Diagram plugin that is a part of the MyEclipse package. It has all the necessary tools and diagrams etc. It exports the diagram in XMI 1.0 format, so you can import it into cfc stub generator. Its a fairly quick way to set up the basic skeleton of your application, along with all the necessary files for coldspring, ant deployment and cfunit tests. ArgoUML or Poseidon are two. there are quite a few, just do a google search on it. hi, thanks we have done a Google search in the pass which led to us using argouml. it needs alot of improvement before it can be of any serious use. so what we are after is not google search results but recommendations from people that use the software and find it great. it doesnt have to be opensource actually as we are just after some great software. ideally it is specifically for coldfusion and flex applications thanks, we look forward to your replies richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: open source ColdFusion UML CASE tool
I think I mentioned this previously but have you looked at CFC Stub Generator? http://cfcstub.riaforge.org/ From the web site: -- Code generator that takes a simple text file and generates CFC stubs, unit tests (either CFUnit or CFCUnit), mock objects, ColdSpring.xml, ANT unit test build script, and test runners. In the latest update, the Stub Generator can also generate components based on an XMI data file. XMI is a standard XML format for describing UML diagrams. I have only tested this with Poseidon UML, but as far as I know any UML tool that can export to XMI should work. Note that the location of the XMI file used in the generation will be used as the base location for the test suite files (the test suite files will be placed in a subdirectory called 'testsuite' beneath the folder containing the XMI file). -- hth, larry hi steve sorry i should have been more specific what i mean by this is code generation... i was wondering whether there was a uml tool that took the models to build cfc and cfm code. thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.
I wrote an article about that a couple of weeks ago, this should help. http://www.danvega.org/blog/index.cfm/2008/3/12/Custom-Grid-Editor -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.
It is very cool but what can I do if I want to use a cfquery in the combo box. For example I have the states names in a DB table. Them how can I load data there? Thanks Ali On Mon, Mar 24, 2008 at 12:14 AM, Dan Vega [EMAIL PROTECTED] wrote: I wrote an article about that a couple of weeks ago, this should help. http://www.danvega.org/blog/index.cfm/2008/3/12/Custom-Grid-Editor -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MS SQL DB Size
Awesome, many thanks Bruce. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: 23 March 2008 15:28 To: CF-Talk Subject: Re: MS SQL DB Size Try this: cfstoredproc procedure=sp_helpdb datasource=DataSourceName cfprocparam cfsqltype=CF_SQL_VARCHAR dbvarname=Name type=In value=DatabaseName cfprocresult name=MyResult /cfstoredproc cfoutput query=MyResult #DB_Size# /cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Which approach to take?
If you make the UUID an alternate key, you don't even have to change the structure of you table. Your primary key can stay the same as it is now. Mark -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 12:05 AM To: CF-Talk Subject: RE: Which approach to take? I use the ColdFusion UUID as the ID for the post so I already know the ID before the message is saved. I guess using the UUID would make that approach work well. I'll have to check into that. Rick -Original Message- From: Mike Harman [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 12:11 AM To: CF-Talk Subject: Re: Which approach to take? I guess I'm probably the rebel here, but I just completed some modifications to our company's forum post interface that contains both text input and file attachments. The user enters the title in one input box and if the user wants to attach a file, clicks an 'attach file' link below the text area. When the link is clicked, a javascript function is called and places a file input box on the screen below the link. If clicked again, and input exists in the first file input, another file input box appears below the first. This allows the user to attach as many files as necessary. Once the post button is clicked, the title and post is validated and stored followed by the attachments. I use the ColdFusion UUID as the ID for the post so I already know the ID before the message is saved. I hope this helps, Mike Harman Hi, all... I'm designing part of an app that will allow users to input info and photos for newly constructed communities. (Real Estate site) I'm going to allow the users to input unlimited photos for each community. There will be one table holding the textual info about each property and another table in the db holding the photos. Therefore, the photos will need to be linked via foreign key in the db to the property table. That said, I'm wondering what approach to take for the input of photos. First Approach: 1) Users input textual information and submit 2) Users then click on link to upload photos which will provide the community_id to connect the photos to the property identified in the URL variable. Second Approach: 1) Users input all data on the same page...textual and photos. 2) For processing, textual data is input first 3) New id for the property is retrieved 4) Photos are uploaded, processed, and put into the db connected to the property via the community_id created in the insert query for the textual info. The first approach is more trouble for the user, but easier. The second approach is preferable if I can consistently retrieve that last id inserted without any problem. I know this is discussed and debated from time-to-time, but I thought I'd ask again, now that I'm on CF 8 and MySQL 5.0. Thoughts, anyone? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Any Gotcha's in using CF UUID for db record primary key?
Hi, all... I'm thinking about changing from using auto-incrementing integers to CF-generated UUID's for primary keys in my mysql db's. Any drawbacks in doing that? The main reason I'm thinking about swapping is so I can eliminate the two-step process of creating, say, a database record for a new Real Estate development community for the textual information, and then requiring a user to click a link with the record id in the URL to add photos for the community. With a UUID, I can apparently create the UUID in advance and use it for the primary key in the community and also for adding the photos, all on the same page. This is my *first* time using a UUID, so don't leave anything out! Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Which approach to take?
So I would just code my CF referencing and UUID as I do my primary auto-incrementing, integer keys now? As in: a href=community.cfm?community_UUID=#get_community.community_UUID# ??? Rick -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 6:35 PM To: CF-Talk Subject: RE: Which approach to take? If you make the UUID an alternate key, you don't even have to change the structure of you table. Your primary key can stay the same as it is now. Mark -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 12:05 AM To: CF-Talk Subject: RE: Which approach to take? I use the ColdFusion UUID as the ID for the post so I already know the ID before the message is saved. I guess using the UUID would make that approach work well. I'll have to check into that. Rick -Original Message- From: Mike Harman [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 12:11 AM To: CF-Talk Subject: Re: Which approach to take? I guess I'm probably the rebel here, but I just completed some modifications to our company's forum post interface that contains both text input and file attachments. The user enters the title in one input box and if the user wants to attach a file, clicks an 'attach file' link below the text area. When the link is clicked, a javascript function is called and places a file input box on the screen below the link. If clicked again, and input exists in the first file input, another file input box appears below the first. This allows the user to attach as many files as necessary. Once the post button is clicked, the title and post is validated and stored followed by the attachments. I use the ColdFusion UUID as the ID for the post so I already know the ID before the message is saved. I hope this helps, Mike Harman Hi, all... I'm designing part of an app that will allow users to input info and photos for newly constructed communities. (Real Estate site) I'm going to allow the users to input unlimited photos for each community. There will be one table holding the textual info about each property and another table in the db holding the photos. Therefore, the photos will need to be linked via foreign key in the db to the property table. That said, I'm wondering what approach to take for the input of photos. First Approach: 1) Users input textual information and submit 2) Users then click on link to upload photos which will provide the community_id to connect the photos to the property identified in the URL variable. Second Approach: 1) Users input all data on the same page...textual and photos. 2) For processing, textual data is input first 3) New id for the property is retrieved 4) Photos are uploaded, processed, and put into the db connected to the property via the community_id created in the insert query for the textual info. The first approach is more trouble for the user, but easier. The second approach is preferable if I can consistently retrieve that last id inserted without any problem. I know this is discussed and debated from time-to-time, but I thought I'd ask again, now that I'm on CF 8 and MySQL 5.0. Thoughts, anyone? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301866 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any Gotcha's in using CF UUID for db record primary key?
Hi Rick, Personally, I would still use an auto-incrementing integer for the PK but have the UUID as a separate field with a unique constraint. Primary keys are not for making a single row unique but for facilitating the relational bit of relational databases (i.e. defining Foreign Key relationships). Having PKs as narrow as possible is better for performance when querying a database across relationships (i.e. using Joins, etc). Of course, as well as having the unique constraint on the GUID, your table should also define a constraint/index that logically defines what makes a row unique (i.e. a combination of account number and sort-code is a logical unique identifier for a bank account and should have a unique index or constraint - but not be a PK). HTH Dominic On 23/03/2008, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... I'm thinking about changing from using auto-incrementing integers to CF-generated UUID's for primary keys in my mysql db's. Any drawbacks in doing that? The main reason I'm thinking about swapping is so I can eliminate the two-step process of creating, say, a database record for a new Real Estate development community for the textual information, and then requiring a user to click a link with the record id in the URL to add photos for the community. With a UUID, I can apparently create the UUID in advance and use it for the primary key in the community and also for adding the photos, all on the same page. This is my *first* time using a UUID, so don't leave anything out! Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any Gotcha's in using CF UUID for db record primary key?
Thanks for the feedback, Dominic. I'll have to do some more research on this approach. I was thinking that the UUID would take the place of using the PK my databases, as in: a href=community.cfm?community_uuid=#url.community_uuid and I would begin to code all my links using the uuid as the relational key instead of the PK. I need to become more familiar with using unique constraints, etc. Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 7:10 PM To: CF-Talk Subject: Re: Any Gotcha's in using CF UUID for db record primary key? Hi Rick, Personally, I would still use an auto-incrementing integer for the PK but have the UUID as a separate field with a unique constraint. Primary keys are not for making a single row unique but for facilitating the relational bit of relational databases (i.e. defining Foreign Key relationships). Having PKs as narrow as possible is better for performance when querying a database across relationships (i.e. using Joins, etc). Of course, as well as having the unique constraint on the GUID, your table should also define a constraint/index that logically defines what makes a row unique (i.e. a combination of account number and sort-code is a logical unique identifier for a bank account and should have a unique index or constraint - but not be a PK). HTH Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any Gotcha's in using CF UUID for db record primary key?
The main reason I'm thinking about swapping is so I can eliminate the two-step process of creating, say, a database record for a new Real Estate development community for the textual information, and then requiring a user to click a link with the record id in the URL to add photos for the community. I'd go with Dominic's idea personally. From a DBA perspective I've *hated* apps that used only GUIDs for their PK... especially when I have to either manually enter data or perform manual joins. SELECT * FROM PROPERTY JOIN PICTURES ON PROPERTY.ID = PICTURES.PROPERTYID WHERE PROPERTY.ID = 928 Is lot easier than typing out a 50-odd character string. If you're worried about embedding ID's in your URL, use forms or have a second unique that is your GUID Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS SQL DB Size
is it also possible to query all datasources on the server, please ? Jenny -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: 23 March 2008 15:28 To: CF-Talk Subject: Re: MS SQL DB Size Try this: cfstoredproc procedure=sp_helpdb datasource=DataSourceName cfprocparam cfsqltype=CF_SQL_VARCHAR dbvarname=Name type=In value=DatabaseName cfprocresult name=MyResult /cfstoredproc cfoutput query=MyResult #DB_Size# /cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any Gotcha's in using CF UUID for db record primary key?
Keep you pk like it is...auto incrementing...and add another field with uuid and then you can reference them -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 7:38 PM To: CF-Talk Subject: RE: Any Gotcha's in using CF UUID for db record primary key? Thanks for the feedback, Dominic. I'll have to do some more research on this approach. I was thinking that the UUID would take the place of using the PK my databases, as in: a href=community.cfm?community_uuid=#url.community_uuid and I would begin to code all my links using the uuid as the relational key instead of the PK. I need to become more familiar with using unique constraints, etc. Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 7:10 PM To: CF-Talk Subject: Re: Any Gotcha's in using CF UUID for db record primary key? Hi Rick, Personally, I would still use an auto-incrementing integer for the PK but have the UUID as a separate field with a unique constraint. Primary keys are not for making a single row unique but for facilitating the relational bit of relational databases (i.e. defining Foreign Key relationships). Having PKs as narrow as possible is better for performance when querying a database across relationships (i.e. using Joins, etc). Of course, as well as having the unique constraint on the GUID, your table should also define a constraint/index that logically defines what makes a row unique (i.e. a combination of account number and sort-code is a logical unique identifier for a bank account and should have a unique index or constraint - but not be a PK). HTH Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any Gotcha's in using CF UUID for db record primary key?
I have two tables with alternate keys...one is the user table that has a auto incrementing PK with the email (user name in this application) as a unique alternate key and one table of uploaded file info with an auto incrementing PK with file name (combination of file name and job name) as a unique alternate key. When records are added to either of these tables, records are added to other tables that have to relate to these new records and we can't be sure, with multiple users, of what the auto incrementing PK is (because that is set by the DB), but we do know the alternate key, bacause we actually insert that with the new record. So we can use that alternate key to be sure, 100% sure, we are grabbing the right record's PK. HTH Mark Fuqua -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 7:38 PM To: CF-Talk Subject: RE: Any Gotcha's in using CF UUID for db record primary key? Thanks for the feedback, Dominic. I'll have to do some more research on this approach. I was thinking that the UUID would take the place of using the PK my databases, as in: a href=community.cfm?community_uuid=#url.community_uuid and I would begin to code all my links using the uuid as the relational key instead of the PK. I need to become more familiar with using unique constraints, etc. Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 7:10 PM To: CF-Talk Subject: Re: Any Gotcha's in using CF UUID for db record primary key? Hi Rick, Personally, I would still use an auto-incrementing integer for the PK but have the UUID as a separate field with a unique constraint. Primary keys are not for making a single row unique but for facilitating the relational bit of relational databases (i.e. defining Foreign Key relationships). Having PKs as narrow as possible is better for performance when querying a database across relationships (i.e. using Joins, etc). Of course, as well as having the unique constraint on the GUID, your table should also define a constraint/index that logically defines what makes a row unique (i.e. a combination of account number and sort-code is a logical unique identifier for a bank account and should have a unique index or constraint - but not be a PK). HTH Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any Gotcha's in using CF UUID for db record primary key?
For what it's worth I kind of agree with the others about the performance benefits... but at the same time the busiest site I've ever worked on (and my personal site, since it's built using the same engine) uses only UUIDs for PKs and never had an issue because of it. We used them, as I assume you are, to ensure that cross-domain information could be easy combined (something we actually didn't end up doing) and used in the application (the same PKs were used as StructKeys in session management) but we took millions of hits on moderate hardware using CF 6, Windows and SQL Server and it never winced. At the same time I kind of DON'T agree with them if you're doing what we were doing: if you're using the key to link tables (so that you can combine multiple databases easily) and using them to link to non-DB information (log files, etc) then it seems like extra work to do a real auto-increment PK as well. Jim Davis ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any Gotcha's in using CF UUID for db record primary key?
I'd agree with Dominic. My company used to use GUIDs for OK and it's a pain in the arse. When you start getting hundreds of millions of records in the database, that varchar field for the GUID starts to take up a lot of space. Using it as the key for joins is trouble waiting to happen because now, you've got the GUID in not only one table, but MULTIPLE tables. Stick with the integer field for PK. -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 6:10 PM To: CF-Talk Subject: Re: Any Gotcha's in using CF UUID for db record primary key? Hi Rick, Personally, I would still use an auto-incrementing integer for the PK but have the UUID as a separate field with a unique constraint. Primary keys are not for making a single row unique but for facilitating the relational bit of relational databases (i.e. defining Foreign Key relationships). Having PKs as narrow as possible is better for performance when querying a database across relationships (i.e. using Joins, etc). Of course, as well as having the unique constraint on the GUID, your table should also define a constraint/index that logically defines what makes a row unique (i.e. a combination of account number and sort-code is a logical unique identifier for a bank account and should have a unique index or constraint - but not be a PK). HTH Dominic On 23/03/2008, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... I'm thinking about changing from using auto-incrementing integers to CF-generated UUID's for primary keys in my mysql db's. Any drawbacks in doing that? The main reason I'm thinking about swapping is so I can eliminate the two-step process of creating, say, a database record for a new Real Estate development community for the textual information, and then requiring a user to click a link with the record id in the URL to add photos for the community. With a UUID, I can apparently create the UUID in advance and use it for the primary key in the community and also for adding the photos, all on the same page. This is my *first* time using a UUID, so don't leave anything out! Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion 8 on Leopard - all of a sudden stopped working
JJ... Matt's MAMP method has worked flawlessly up until this update. Something has changed, but I don't have any clue what. Dave Watts... Is the appropriate LoadModule line in httpd.conf? What LoadModule would that be? I know enough about configuring servers to be dangerous. Dave L... What web connector? All: I've rerun the CF Launcher several times, as well as reconnecting CF to Apache using the JRun connector utility and it's still not working. andy -Original Message- From: J.J. Merrick [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 5:59 AM To: CF-Talk Subject: Re: Coldfusion 8 on Leopard - all of a sudden stopped working Andrew, I actually had Matthew's MAMP way of doing things working for about an hour and then it just stopped running and I couldn't get it back up again. I tell you your best bet is to go try to get in the prerelease Updater 1 program. I can't tell you anything about it or if I am actually in it and I can't tell you that it runs wonderfully and I can't tell you that it could save you many hours of headaches :-) J.J. On Sat, Mar 22, 2008 at 9:33 PM, Andy Matthews [EMAIL PROTECTED] wrote: I've had CF8 running on my Intel Mac Mini for about 2 months now. I followed a tutorial which told me to use MAMP rather than the built in version of Apache: http://www.flashalisious.com/2007/12/14/installing-coldfusion8-on-leop ard-using-mamp/ Anyway, that's not the point as it's been running great since I got it working. However, I just did the Apple update a few days ago and now all of a sudden I can't get CF running right. Apache starts just fine, but when I try to view a CF page in the browser, I just see source code. I've restarted Apache and CF8 multiple times to no avail. I've double checked the httpd.conf to make sure that .cfm pages are listed there and it still doesn't work. Does anyone have ANY input whatsoever? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFWINDOW Problem
A related note:
Holly mother of Lord! I just love those corporate Frankenstein style
solutions.
refering to zillions of open source js code, Ext, YUI, among others...
+ add nice presentation and very handy for better Use Experience.
- hard to debug
// Adobe got the upper hand (more money in their top management and major stock
holder's pocket) while non-gov/non-corp developers have to spend more time to
fix things at their own expense...
Ok, my attempt of wrestling with dynamically setting iframe attributes
inside a CFWINDOW has been in vain, some of you may have a solution,
Andrew Scott? Terry Schmitt? and more...
a CFWINDOW-launched template looks like this:
(Please note the template would run just fine if not launched via the
CFWINDOW tag, but that's not a choice at this point)
-- run a query named myData here
html
head
titleCouldn't you be cooperative?/title
/head
body
script type=text/javascript
function init() {
cfoutput query=myData
frames.dataRow#currentrow#.document.designMode = On;
...
/cfoutput
/script
body onload=init()
cfoutput query=myData
iframe id==dataRow#currentrow#
name=dataRow#currentrow#/iframe
/cfoutput
/body
/html
Thanks.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301876
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need help
when you are working with cf8 ajax ui controls, you should either have
all your js in an external file, or, if you have js in the same file,
your js functions must be declared as
functionname = function(arguments) {
...
}
not
function functionname(arguments) {
...
}
hth
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
D
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301877
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Coldfusion 8 on Leopard - all of a sudden stopped working
I think I know what you mean about LoadModule Dave...this is what's currently in my httpd.conf file for CF/JRun: # JRun Settings LoadModule jrun_module /Applications/ColdFusion8/runtime/lib/wsconfig/1/mod_jrun20.so IfModule mod_jrun20.c JRunConfig Verbose false JRunConfig Apialloc false JRunConfig Ignoresuffixmap false JRunConfig Serverstore /Applications/ColdFusion8/runtime/lib/wsconfig/1/jrunserver.store JRunConfig Bootstrap 127.0.0.1:51800 AddHandler jrun-handler .jsp .jws /IfModule -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Saturday, March 22, 2008 11:37 PM To: CF-Talk Subject: RE: Coldfusion 8 on Leopard - all of a sudden stopped working I've restarted Apache and CF8 multiple times to no avail. I've double checked the httpd.conf to make sure that .cfm pages are listed there and it still doesn't work. Does anyone have ANY input whatsoever? Is the appropriate LoadModule line in httpd.conf? As others have mentioned, you can probably repair this using the web server configuration tool. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.
Found the solution. Very easy! It works for CF8, cfgrid Format = HTML you should have a cfquery named: rsStatesList too read the states names.. and you know the rest. cfgridcolumn name=States values=#ValueList(rsStatesList.StateName)# select=Yes header=State On Mon, Mar 24, 2008 at 12:37 AM, Ali [EMAIL PROTECTED] wrote: It is very cool but what can I do if I want to use a cfquery in the combo box. For example I have the states names in a DB table. Them how can I load data there? Thanks Ali On Mon, Mar 24, 2008 at 12:14 AM, Dan Vega [EMAIL PROTECTED] wrote: I wrote an article about that a couple of weeks ago, this should help. http://www.danvega.org/blog/index.cfm/2008/3/12/Custom-Grid-Editor -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MS SQL DB Size
If you have CF8, you can use CFDBINFO. Or try this... http://cf-bill.blogspot.com/2005/02/listing-available-datasources.html m!ke -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 6:54 PM To: CF-Talk Subject: RE: MS SQL DB Size is it also possible to query all datasources on the server, please ? Jenny ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Images in the database good or bad?
Yes. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 10:23 AM To: CF-Talk Subject: Re: Images in the database good or bad? In my opinion, a database is used to organize related data. In this case, a binary file would be related to its metadata that you would normally store in a database. Michael, if you have a table to organize data related to employees, will you store the employees in the employee table? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any Gotcha's in using CF UUID for db record primary key?
Sounds like there are definite pros and cons to UUID usage. And, too, this seems to be a case of need driving functionality. With high traffic sites, I can see the need for various indexes, etc. My db's will all be relatively small and won't have issues with high traffic. I've never even had to use indexes to speed up db data flow. Initial impression is that working with UUID's, etc., may prove to be more effort than it's worth just to save users a step in adding unlimited photos to, say, a Real Estate property. Instead of all on one page, using the UUID as a relational key, I just have the user create the property record, then on the success confirmation page, offer a link to add photos to the property. When updating an existing property, there's no issue since the user has had to click a link with an id embedded in the URL anyway. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion 8 on Leopard - all of a sudden stopped working
I think I know what you mean about LoadModule Dave...this is what's currently in my httpd.conf file for CF/Jrun ... That's what I was asking about, yes. It looks ok to me. I suggest you try running the web server configuration utility (wsconfig). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any Gotcha's in using CF UUID for db record primary key?
At the same time I kind of DON'T agree with them if you're doing what we were doing: if you're using the key to link tables (so that you can combine multiple databases easily) and using them to link to non-DB information (log files, etc) then it seems like extra work to do a real auto-increment PK as well. I'll second this. Either use UUIDs or don't. In either case, I'd recommend that you use your database's ability to generate these instead of doing it from CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Seeking Spreadsheet App Simulation in CF
Does anyone know of a tag or simple app that simulates a spreadsheet within a page. I am looking for only the simplest functionality that will enable users to input/update simple text data into a cell. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Seeking Spreadsheet App Simulation in CF
Sharepoint does this, although I am doubting that this meets the simple solution requirement... On Sun, Mar 23, 2008 at 11:01 PM, Colman, Richard [EMAIL PROTECTED] wrote: Does anyone know of a tag or simple app that simulates a spreadsheet within a page. I am looking for only the simplest functionality that will enable users to input/update simple text data into a cell. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
