Music previewing
Hey all, I was wondering if anyone knows of a custom tag or a method that will allow me to have a preview of a music file. I know that we have all of the image tags to handle thumbnailing images, but do we have any that will pull a fragment out of the uploaded music file? I am trying to get a temporary fix of having an embed object created dynamically through javascript and then using a settimeout to replace that object with a blank one that will 'stop' the music playing, but since the music isn't 'streaming' the song takes too much time to download to the users' machine before starting the playback. Other than having the preview created separately and uploaded separately, does anyone here have any ideas on how to crack this nut? Thank you in advance, William ~| 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:301887 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
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: 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
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?
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: 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: 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: 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. 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: 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 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 -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: 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: 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 > > > > Couldn't you be cooperative? > > > > > function init() { >> frames.dataRow#currentrow#.document.designMode = "On"; ... > > > > > > > > name="dataRow#currentrow#"> > > > > > > > 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: 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: 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: 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 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?
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: 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: #DB_Size# ~| 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?
> 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: 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?
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: 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
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?
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
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: #DB_Size# ~| 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: 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: 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: 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: 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
>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
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: 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: 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: 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 main page 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('Hello!'); doc.close(); // method 2 frames.nuts2.document.designMode = "On"; var s2 = "plain text test"; var D2 = frames['nuts2'].document; D2.open(); D2.write('' + s2 + ''); D2.close(); } 3. Response (by Firebug) main page ~| 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: MS SQL DB Size
Try this: #DB_Size# 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: 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: 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?
>>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?
>>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
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: 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
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
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: 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: 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
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: 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
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: 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
>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
>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 "#now()#" 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
>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: 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: 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
Did this but it looks messy, maybe there is a better way? #roundNum# ~| 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
>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
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: 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