Re: Need help

2008-03-23 Thread Azadi Saryev
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

Re: Coldfusion 8 on Leopard - all of a sudden stopped working

2008-03-23 Thread J.J. Merrick
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

Round Up

2008-03-23 Thread Jenny Gavin-Wear
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

Re: Round Up

2008-03-23 Thread Will Tomlinson
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

RE: Round Up

2008-03-23 Thread Jenny Gavin-Wear
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

Re: Round Up

2008-03-23 Thread James Holmes
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()

Re: Round Up

2008-03-23 Thread James Holmes
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

Re: Round Up

2008-03-23 Thread Will Tomlinson
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

Re: New To CF

2008-03-23 Thread Bruce Kersten
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

Re: New To CF

2008-03-23 Thread Bruce Kersten
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

Re: New To CF

2008-03-23 Thread Bruce Kersten
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.

Re: New To CF

2008-03-23 Thread Bruce Kersten
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

Re: New To CF

2008-03-23 Thread Bruce Kersten
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

Re: Google Maps, CF and Ajax

2008-03-23 Thread Paul Ihrig
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

Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.

2008-03-23 Thread Ali
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

Re: Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.

2008-03-23 Thread Dan Vega
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

Re: Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.

2008-03-23 Thread Ali
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

RE: Round Up

2008-03-23 Thread Jenny Gavin-Wear
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()

RE: Round Up

2008-03-23 Thread Jenny Gavin-Wear
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

Re: Round Up

2008-03-23 Thread Claude Schneegans
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.

MS SQL DB Size

2008-03-23 Thread Jenny Gavin-Wear
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

Re: Images in the database good or bad?

2008-03-23 Thread Claude Schneegans
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

Re: Images in the database good or bad?

2008-03-23 Thread Claude Schneegans
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

Re: Images in the database good or bad?

2008-03-23 Thread Claude Schneegans
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

Re: Images in the database good or bad?

2008-03-23 Thread Claude Schneegans
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? --

Re: MS SQL DB Size

2008-03-23 Thread Bruce Sorge
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

Re: Need help

2008-03-23 Thread Don L
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

RE: Images in the database good or bad?

2008-03-23 Thread Dave Watts
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:

RE: Images in the database good or bad?

2008-03-23 Thread Dave Watts
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

Re: open source ColdFusion UML CASE tool

2008-03-23 Thread Richard White
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

Re: open source ColdFusion UML CASE tool

2008-03-23 Thread Richard White
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

Re: open source ColdFusion UML CASE tool

2008-03-23 Thread Larry Lyons
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

Re: open source ColdFusion UML CASE tool

2008-03-23 Thread Larry Lyons
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

Re: Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.

2008-03-23 Thread Dan Vega
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

Re: Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.

2008-03-23 Thread Ali
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,

RE: MS SQL DB Size

2008-03-23 Thread Jenny Gavin-Wear
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

RE: Which approach to take?

2008-03-23 Thread Mark Fuqua
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

Any Gotcha's in using CF UUID for db record primary key?

2008-03-23 Thread Rick Faircloth
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

RE: Which approach to take?

2008-03-23 Thread Rick Faircloth
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

Re: Any Gotcha's in using CF UUID for db record primary key?

2008-03-23 Thread Dominic Watson
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

RE: Any Gotcha's in using CF UUID for db record primary key?

2008-03-23 Thread Rick Faircloth
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

Re: Any Gotcha's in using CF UUID for db record primary key?

2008-03-23 Thread C. Hatton Humphrey
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

RE: MS SQL DB Size

2008-03-23 Thread Jenny Gavin-Wear
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

RE: Any Gotcha's in using CF UUID for db record primary key?

2008-03-23 Thread Mark Fuqua
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

RE: Any Gotcha's in using CF UUID for db record primary key?

2008-03-23 Thread Mark Fuqua
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

RE: Any Gotcha's in using CF UUID for db record primary key?

2008-03-23 Thread Jim Davis
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

RE: Any Gotcha's in using CF UUID for db record primary key?

2008-03-23 Thread Andy Matthews
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,

RE: Coldfusion 8 on Leopard - all of a sudden stopped working

2008-03-23 Thread Andy Matthews
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

Re: CFWINDOW Problem

2008-03-23 Thread Don L
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

Re: Need help

2008-03-23 Thread Don L
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

RE: Coldfusion 8 on Leopard - all of a sudden stopped working

2008-03-23 Thread Andy Matthews
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

Re: Cgrid needs Java Runtime Environment while Windows XP doesnt have it by defalut.

2008-03-23 Thread Ali
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

RE: MS SQL DB Size

2008-03-23 Thread Dawson, Michael
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

RE: Images in the database good or bad?

2008-03-23 Thread Dawson, Michael
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

RE: Any Gotcha's in using CF UUID for db record primary key?

2008-03-23 Thread Rick Faircloth
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

RE: Coldfusion 8 on Leopard - all of a sudden stopped working

2008-03-23 Thread Dave Watts
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

RE: Any Gotcha's in using CF UUID for db record primary key?

2008-03-23 Thread Dave Watts
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

Seeking Spreadsheet App Simulation in CF

2008-03-23 Thread Colman, Richard
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®

Re: Seeking Spreadsheet App Simulation in CF

2008-03-23 Thread Crow T. Robot
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