Music previewing

2008-03-24 Thread William Seiter
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

Re: Seeking Spreadsheet App Simulation in CF

2008-03-24 Thread Mike Chabot
Take a look at the cfgrid tag. What you are describing doesn't sound like a spreadsheet. It sounds more like a basic grid to me. Basic grid solutions are much easier to find than spreadsheet solutions. -Mike Chabot On Mon, Mar 24, 2008 at 12:01 AM, Colman, Richard [EMAIL PROTECTED] wrote: Does

Re: Seeking Spreadsheet App Simulation in CF

2008-03-24 Thread Andrew Scott
Except that cfgrid is tied to a specific type, which you can't have a column with multiple types like you can in a spreadsheet. But it is a start. Have a look at www.ajaxian.com I am sure that there is one article that may have covered someone who has done this before. On Mon, Mar 24, 2008 at

Re: Need help

2008-03-24 Thread Andrew Scott
Sorry I am not sure what you actual problem is. But can I ask why you are using IFrames? Cfdiv maybe just as good for your needs:-) On Mon, Mar 24, 2008 at 3:52 AM, Don L [EMAIL PROTECTED] wrote: when you are working with cf8 ajax ui controls, you should either have all your js in an

Re: Music previewing

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

Re: Seeking Spreadsheet App Simulation in CF

2008-03-24 Thread Will Tomlinson
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 Sounds like more of a CSS thing to me. Stick some inputs in your cells and style the

RE: MS SQL DB Size

2008-03-24 Thread Jenny Gavin-Wear
In case anyone finds it useful. This code updates a table with the db sizes of all db's on the server. Thanks for your help putting this together :-) CFLOCK Name=ServiceFactory Type=Exclusive TimeOut=10 CFSET Factory = CreateObject(java, coldfusion.server.ServiceFactory) CFSET Service =

cfgridupdate doesn't work when I edit more than one Cell!

2008-03-24 Thread Ali
Hi: I made a grid with cfgrid then I made an action page with cfgridupdate. It works when I change one cell but doesn't work when I change more than one cell! Here is the code: The page that contains grid : cfgridtets.cfm !--- the start of the first page --- cfquery name=UsersGrid

RE: Music previewing

2008-03-24 Thread Bobby Hartsfield
That's right... Flash Will and he will stream the music automatically like you need ;-) Ditto on Flash though. You can play an mp3 from a url for N seconds -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2008 7:16 AM To: CF-Talk Subject: Re:

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

2008-03-24 Thread Rick Faircloth
What's the reason for using the db instead of CF to generate the UUID? To keep the load off CF? I was thinking I might use CF in the following manner to generate a UUID for a record: - Create UUID and variable to hold UUID via CF and cfset - User completes form with textual information and

Help setting up server file locations

2008-03-24 Thread Donald R Langley
I need some help configuring my server. The server has dual drives a 30 gig (C: drive) and a 180 gig (D; drive) . Both are backed up by redundant drives. What I want to do is to run the CF applications on the C drive and locate all of the uploaded photos, and files (word, excel, powerpoint

Re: cfgridupdate doesn't work when I edit more than one Cell!

2008-03-24 Thread Gerald Guido
I have not used CF grid since 61 (java version). It was a bit dodgey back then, I could not get it to update with a client on a Mac. If you are on CF 8 check this out: http://www.anujgakhar.com/2008/03/18/crud-with-cfgrid-html-format/ Ben Forta has a tute on his blog on using cfgrid to do crud

Re: Images in the database good or bad?

2008-03-24 Thread Dave Ross
IMO there are times when it makes sense to store binary content in a database, and times when it does not. My rule of thumb is based on size and usage. If you expect the amount of binary content to grow tremendously, I would avoid storing binary content in the db. Otherwise, for small items

Re: Images in the database good or bad?

2008-03-24 Thread Casey Dougall
On Mon, Mar 24, 2008 at 10:17 AM, Dave Ross [EMAIL PROTECTED] wrote: IMO there are times when it makes sense to store binary content in a database, and times when it does not. My rule of thumb is based on size and usage. If you expect the amount of binary content to grow tremendously, I

RE: Images in the database good or bad?

2008-03-24 Thread Dawson, Michael
Lets say you get to be the size of myspace.com or flickr.com they cannot be storing all of those images in a database would they? It is very possible... TerraServer: http://terraserver-usa.com/about.aspx?n=AboutTerraServiceOverview http://research.microsoft.com/displayArticle.aspx?id=272 The

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

2008-03-24 Thread Mark Fuqua
What if you have four concurrent users (or four hundred if your app get popular!), what happens if user two gets user three's id when she runs LAST_INSERT_ID()? That's the one of the only reasons I can see for using alternate keys. Whether it is a UUID created in Coldfusion or someother unique

Re: Need help

2008-03-24 Thread Don L
Sorry I am not sure what you actual problem is. But can I ask why you are using IFrames? Cfdiv maybe just as good for your needs:-) Hey Andrew, I have to use IFrames inside a CFWINDOW because I need to allow multiple instances of a WYSIWYG editor (which I've created and is working

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

2008-03-24 Thread Ben Forta
Whether it is a UUID created in ColdFusion or some other unique value...you KNOW what it is...every time, because you set it, not the DB. Until you need to use another database client, one other than ColdFusion, then things get messier. If you need to manually insert rows, or do a batch import,

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

2008-03-24 Thread Claude Schneegans
I'm thinking about changing from using auto-incrementing integers to CF-generated UUID's for primary keys in my mysql db's. Keep in mind that primary keys are by definition indexed, and in order to maintain an index, keys are compared to others. Now comparing to numbers takes only one machine

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

2008-03-24 Thread Greg Morphis
But can't you put a cflock / around the query that inserts the record and retrieves the last ID? On Mon, Mar 24, 2008 at 8:59 AM, Mark Fuqua [EMAIL PROTECTED] wrote: What if you have four concurrent users (or four hundred if your app get popular!), what happens if user two gets user three's id

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

2008-03-24 Thread Rick Faircloth
And this is the info in the MySQL 5 docs that convinced me that LAST_INSERT_ID() was a safe means of retrieving id's, even with unlimited number of users working simultaneously... == The ID that was generated is

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

2008-03-24 Thread Dave Watts
But can't you put a cflock / around the query that inserts the record and retrieves the last ID? If you want to serialize database transactions, that's what the CFTRANSACTION tag is for. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin

Re: Images in the database good or bad?

2008-03-24 Thread James Holmes
Exactly - people who work in GIS will tell you a lot (if you ask) about the power of DB systems that can do spatial analysis (Oracle, for example). On Mon, Mar 24, 2008 at 10:53 PM, Dawson, Michael [EMAIL PROTECTED] wrote: Lets say you get to be the size of myspace.com or flickr.com they

CFScript compedium

2008-03-24 Thread Scott Stewart
Hey all, Is there a comprehensive CFScript compendium anywhere? Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) No virus found in this outgoing message. Checked by AVG.

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

2008-03-24 Thread Dave Watts
And this is the info in the MySQL 5 docs that convinced me that LAST_INSERT_ID() was a safe means of retrieving id's, even with unlimited number of users working simultaneously... == The ID that was generated is maintained in

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

2008-03-24 Thread Dave Watts
What if you have four concurrent users (or four hundred if your app get popular!), what happens if user two gets user three's id when she runs LAST_INSERT_ID()? This is exactly why databases provide concurrency control. You should use it. That's the one of the only reasons I can see for

Re: Help setting up server file locations

2008-03-24 Thread J.J. Merrick
This will probably be done via your Web server app and not really ColdFusion. All CF needs to know is where to place the files so if you created a Static Files application variable then just change it to d:\whereeveryourfileare As far as making certain directories off your webroot point to

RE: Help setting up server file locations

2008-03-24 Thread Dave Watts
I need some help configuring my server. The server has dual drives a 30 gig (C: drive) and a 180 gig (D; drive) . Both are backed up by redundant drives. What I want to do is to run the CF applications on the C drive and locate all of the uploaded photos, and files (word, excel,

Re: CFScript compedium

2008-03-24 Thread Casey Dougall
On Mon, Mar 24, 2008 at 11:01 AM, Scott Stewart [EMAIL PROTECTED] wrote: Hey all, Is there a comprehensive CFScript compendium anywhere? Only one I know of is the Cheat Sheet. http://www.petefreitag.com/cheatsheets/coldfusion/cfscript/ Casey

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

2008-03-24 Thread Dave Watts
What's the reason for using the db instead of CF to generate the UUID? To keep the load off CF? Primarily, because that sort of thing is the database server's job, in the same way that calculating aggregates is something better left to the database server than your application. There are

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

2008-03-24 Thread Mark Kruger
Dave, Of course the other side of the coin is writing an application that can work with multiple databases... That can sometimes require a generic approach that resides in the application logic. Many shopping carts are like that. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105

Re: CFScript compedium

2008-03-24 Thread Charlie Griefer
On Mon, Mar 24, 2008 at 8:01 AM, Scott Stewart [EMAIL PROTECTED] wrote: Hey all, Is there a comprehensive CFScript compendium anywhere? it's a tad old, but it still works (the notable exception being the new operators in CF8 not being there)... http://www.houseoffusion.com/tutorials/cfscript/

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

2008-03-24 Thread Raymond Camden
Dave, what issues do you speak of? I know that UUID creation is NOT fast, but when you say issues, it leads me to think you mean multiple bugs. On Mon, Mar 24, 2008 at 10:23 AM, Dave Watts [EMAIL PROTECTED] wrote: What's the reason for using the db instead of CF to generate the UUID? To

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

2008-03-24 Thread Brad Wood
I wondered the same thing, but a few minutes of Googling only turned up this: http://orangepips.instantspot.com/blog/2007/11/12/Coldfusion-and-UUIDs- which addresses security concerns that a Version 1 UUID can be reverse engineered to produce the MAC address of your server. Additionally, I

Re: CFScript compedium

2008-03-24 Thread Gerald Guido
not suggesting this is a best practice by any means... was just me trying to jump into cfscript with both feet. calendar sample and code are at http://charlie.griefer.com/code/cf/cfscript_calendar.cfm. this Huh, that looks a lot like PHP. Charlie points out reason # 432 why I use CF. Write

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

2008-03-24 Thread Dave Watts
Dave, what issues do you speak of? I know that UUID creation is NOT fast, but when you say issues, it leads me to think you mean multiple bugs. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:51685#278231 http://www.bpurcell.org/blog/index.cfm?mode=entryentry=970 Dave Watts,

Re: error with ColdFusion 8 ODBC Agent

2008-03-24 Thread Troy Montour
Hareni, not sure if your still on the boards since this post is a year old but just doing a clean multi-server install and was getting the issue below so I ran your scripts which removed the services just fine but when it ran the install script it came back with this error. An error occurred

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

2008-03-24 Thread Raymond Camden
Wow, that convinces me. ;) On Mon, Mar 24, 2008 at 11:22 AM, Dave Watts [EMAIL PROTECTED] wrote: Dave, what issues do you speak of? I know that UUID creation is NOT fast, but when you say issues, it leads me to think you mean multiple bugs.

Re: Seeking Spreadsheet App Simulation in CF

2008-03-24 Thread Josh Nathanson
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 - I have used a jQuery plugin called jEditable to achieve something like this.

Re: Seeking Spreadsheet App Simulation in CF

2008-03-24 Thread Axel Schultze
Rick, I guess CFGRID is your answer. It has the special advantage that you can edit any cell of a structure and than update the whole enchilada at once. It is a very powerful way to edit large amount of structured data, like a customer database. You define your GRID, load data with the

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

2008-03-24 Thread Jochem van Dieten
Rick Faircloth wrote: 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? 1. Storage size. Let's suppose you have a table for a many-to-many relation. That is 72 bytes for the 2 fields and

Re: Images in the database good or bad?

2008-03-24 Thread Jochem van Dieten
Richard Dillman wrote: I'm in the process of designing a site that will allow people to upload (JPG,PDF,DOC,XLS) files. I'm looking at about 1-4 mb each item. Is it better to do a file upload, or better to insert to the database? I find keeping the images in the database is more manageable

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

2008-03-24 Thread Jochem van Dieten
Rick Faircloth wrote: The ID that was generated is maintained in the server on a per-connection basis. This means that the value returned by the function to a given client is the first AUTO_INCREMENT value generated for most recent statement affecting an AUTO_INCREMENT column by that client.

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

2008-03-24 Thread Brad Wood
Rick Faircloth wrote: 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? 1. Storage size. == I'll ditto that. Our Database is a healthy 32 Gigs or so. We used

Using CFWindow getting the parent page to refresh

2008-03-24 Thread Rick Mason
I have a report that when called pops up a separate instance of the browser. I have a link on that report that calls a cfwindow containing a cfform that lets you change filters and sort order on the report. In the past I have successfully used location.refresh() to refresh the page reflecting

Re: Images in the database good or bad?

2008-03-24 Thread Dana Kowalski
I think the main thing in the end is the scope of the project and personal preference. If the site will maintain heavy load, especially the images section, then you may want to consider a file server for uploads and just store the filename with your record. This can take the strain off a

ColdFusion and IIS Application Pool recycling

2008-03-24 Thread mark kecko
Setup: Windows 2003 Server / IIS 6 / CF 8 We have several websites setup in IIS, each with their own IIS application pool. Every once in a while, one of these application pools will fail more than 5 times in ten minutes, causing the application pool to shutdown. The good news is all of our

OT: Looking to create CREATE script

2008-03-24 Thread Michael Muller
I've been using BACKUP and RESTORE scripts to replicate BDs to new DBs for years and would like to move to using CREATE and INSERT instead. Is there a stored procedure that will create a full set of CREATE and INSERT statements to completely create a new DB? If there's something in the

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

2008-03-24 Thread denstar
Are you sure it's the same copy of apache that's running, that you installed? Sounds sorta like maybe the previous version is running, instead of the one you'd personally installed. There's an easy way to tell what's running from where, but I haven't had enough coffee today, or something, as I

ColdFusion and IIS Application Pool recycling

2008-03-24 Thread mark kecko
Setup: Windows 2003 Server / IIS 6 / CF 8 We have several websites setup in IIS, each with their own IIS application pool. Every once in a while, one of these application pools will fail more than 5 times in ten minutes, causing the application pool to shutdown. The good news is all of our

RE: Music previewing

2008-03-24 Thread William Seiter
Thank you Will and Bobby, In my searches, I came across a premade 'sound machine' flash file which takes an XML document and then you indicate which sound file from the XML you had wanted. Does anyone know of any other premade flash files which would take a simple 'url' in the flash variables

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

2008-03-24 Thread Dominic Watson
I need to become more familiar with using unique constraints, etc Yes you do! Do it now and save yourself pain later ;) Relying on a primary key to make a table row unique invariably leads to duplicate data (even though they have unique keys) which is a royal PITA. As a general rule, every

Re: CFScript compedium

2008-03-24 Thread Michael Dinowitz
I'll update it asap. On Mon, Mar 24, 2008 at 11:35 AM, Charlie Griefer [EMAIL PROTECTED] wrote: On Mon, Mar 24, 2008 at 8:01 AM, Scott Stewart [EMAIL PROTECTED] wrote: Hey all, Is there a comprehensive CFScript compendium anywhere? it's a tad old, but it still works (the notable

Re: Using CFWindow getting the parent page to refresh

2008-03-24 Thread Don L
I have a report that when called pops up a separate instance of the browser. I have a link on that report that calls a cfwindow containing a cfform that lets you change filters and sort order on the report. In the past I have successfully used location.refresh() to refresh the page reflecting

Re: String index out of range: 0

2008-03-24 Thread T A
thanks...sorry for the delay was away for over a week now...it worked. ~| 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

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

2008-03-24 Thread RICHARD SIMPSON
What if you have four concurrent users (or four hundred if your app get popular!), what happens if user two gets user three's id when she runs LAST_INSERT_ID()? This is exactly why databases provide concurrency control. You should use it. That's the one of the only reasons I can see for

cascade delete issue?

2008-03-24 Thread Nisher
this is the code i am using while attempting to do a cascade delete of navagation items in our custom menu system. it will delete the parent nav but then errors out while attempting to delete the sub navs. and comments r suggestions would be welcome. cfoutput body onload=self.focus(); form

RE: cascade delete issue?

2008-03-24 Thread Dave Watts
this is the code i am using while attempting to do a cascade delete of navagation items in our custom menu system. it will delete the parent nav but then errors out while attempting to delete the sub navs. and comments r suggestions would be welcome. I suggest you post the actual error

Re: Images in the database good or bad?

2008-03-24 Thread Richard Dillman
OMG! I could tell you some stories about government contracting. I actually had an IOT manager in an SSL and Site security meeting ask just how many extra guards he was gonna have to hire!! .. . . o.0 .. . . Only 1 and, he wont have to be armed... On Mon, Mar 24, 2008 at 2:33 PM, Dana

cascade Delete issue

2008-03-24 Thread Nisher
hello I am attempting to further customize a menu system that consists of head navs, parent navs and subnavs...it is tri-level. What i am trying to do is delete the head nav and have it loop through and delete the other levels as well so they become inactive as well. Any help would be

ColdFusion instances running under other instances?

2008-03-24 Thread Ryan Stille
I'm working on a server with multiple instances of ColdFusion running on a Jrun4 installation. Sometimes this gets weird and I get one of the instances running under another one. This screen shot explains it better: http://tinyurl.com/2l73dy You can see the admin instance is running under

Re: String function question

2008-03-24 Thread denstar
This is probably too late to help, but I did a similar hackish job: cfsavecontent variable=thisForm #thisForm.editForm(url.formnum)# /cfsavecontent cfscript contents = rereplace(thisForm,textarea[^]*(.*?)/textarea,span style='background-color:silver;'\1/span,all); contents =

Where is jar.exe?

2008-03-24 Thread Troy Simpson
I am trying to find jar.exe according to the ColdFusion 8 documentation, but it is no where to be found. Where do I find jar.exe. The ColdFusion 8 documentation say it should be in C:\JRun4\bin\. Thanks, -- Thanks, Troy ~|

Re: Using CFWindow getting the parent page to refresh

2008-03-24 Thread Rick Mason
Don, OK. On the home page of a portal users click on an icon and launch a report in a separate browser instance. At the top of the report there's a link that launches a cfwindow that allows them to filter the report and select how they want it sorted. Their choices are saved to the database

Perhaps a little over complicated - Dissecting a String

2008-03-24 Thread Nate Willard
Give a String such as: Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Ut magna lectus, tristique in, convallis sed, eleifend in, nulla. Nullam vulputate velit a urna. Vestibulum ultrices interdum est. Aliquam erat volutpat. Vestibulum ut massa ut diam dignissim vestibulum. Donec orci

RE: Perhaps a little over complicated - Dissecting a String

2008-03-24 Thread Brad Wood
You mean like this? (untested) cfif len(listfirst(my_string,.)) LTE 100 #listfirst(my_string,.)#. cfelse #left(my_string,100)# /cfif ~Brad -Original Message- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2008 5:00 PM To: CF-Talk Subject: Perhaps a

Re: String function question

2008-03-24 Thread Bruce Sorge
Appreciate it. I will give it a try. denstar wrote: This is probably too late to help, but I did a similar hackish job: cfsavecontent variable=thisForm #thisForm.editForm(url.formnum)# /cfsavecontent cfscript contents = rereplace(thisForm,textarea[^]*(.*?)/textarea,span

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

2008-03-24 Thread Dave l
I dont remember how you get back into the web connector but it should look like this http://www.markdrew.co.uk/blog/images//Picture%202.png You can tell if default apache is running by going into your home folder then to sites and then run the html file in there or into your HD library

Re: Perhaps a little over complicated - Dissecting a String

2008-03-24 Thread Steve Bryant
I think you want: #Left(ListFirst(string,.),100)#. (untested) Instead of returning say just 100 characters. Is there a way to return the first sentence only if its under 100 characters, and if not then 100 characters resulting in a cut off string.

Re: Where is jar.exe?

2008-03-24 Thread Nathan Strutz
Yeah I don't think it comes with CF, strangely. Especially with Enterprise edition, you'd think it might. It's actually bundled with the JDK as opposed to the plain JRE that comes with CF. The JDK contains the JRE as well, so you'll get some redundancy unless you delete your CF jre folder and

Re: String function question

2008-03-24 Thread Charlie Griefer
so just out of curiosity... the backreferences thing didn't pan out at all? On Mon, Mar 24, 2008 at 3:17 PM, Bruce Sorge [EMAIL PROTECTED] wrote: Appreciate it. I will give it a try. denstar wrote: This is probably too late to help, but I did a similar hackish job: cfsavecontent

Re: Perhaps a little over complicated - Dissecting a String

2008-03-24 Thread Charlie Griefer
bear in mind the previous suggestions (while not incorrect) will potentially cut off a word in the middle. cflib.org has a few UDFs that will make sure you return whole words. http://cflib.org/udf.cfm?ID=1106 http://cflib.org/udf.cfm?ID=832 http://cflib.org/udf.cfm?ID=329 and more :) On

Re: Using CFWindow getting the parent page to refresh

2008-03-24 Thread Don L
Don, OK. On the home page of a portal users click on an icon and launch a report in a separate browser instance. At the top of the report there's a link that launches a cfwindow that allows them to filter the report and select how they want it sorted. Their choices are saved to the database

Re: String function question

2008-03-24 Thread Bruce Sorge
The biggest problem I am having is getting the columns for the form to line up properly (they are a series of radio buttons). I can get all of the values and the text fields fill in properly. The radio button values fill in with what I select, just not in the correct column. Bruce Charlie

Date Range Search Problem - when it's integers stored and not dates

2008-03-24 Thread Les Mizzell
I've got a database in which dates are stored as integers in three separate columns as: day|month|year This was done because the client wished to create records that could contain only a year, or just a year and month, or year, month, and day, or no date at all. Values in the columns default

Re: Perhaps a little over complicated - Dissecting a String

2008-03-24 Thread Nate Willard
These are all good steps in the right direction however, I haven't found anything that ties all this logic together. Logic if first sentence is between 200-250 characters show that setence if no sentence, show first 250 characters +... if first sentence is less than 250 sentences, get as many

Google geocoder and CF5

2008-03-24 Thread Claude Schneegans
Hi, Has anyone succeeded getting the Google geocoder to work underCF5? I have my API working fine under CFMX, but under CF5 Google keeps returning code=610 meaning invalid key. My API calls the geocoder through CFHTTP. -- ___ REUSE CODE! Use custom tags; See

Re: Date Range Search Problem - when it's integers stored and not dates

2008-03-24 Thread Josh Nathanson
You might be able to join the table to itself in a query, and on that join concat your date integers into actual date values. Something like... SELECT whatever FROM thetable t INNER JOIN ( SELECT id, CONCAT(yearcol,'/',monthcol,'/',daycol) AS gooddate FROM thetable )

Re: Date Range Search Problem - when it's integers stored and not dates

2008-03-24 Thread Les Mizzell
The idea being to parse the separate date columns into usable dates in the subquery, and then join that to the superquery as needed. I'd been trying to come up with a way to do this, but the columns with a 0 in them are throwing me off, since 0 isn't a valid date value.

Re: Date Range Search Problem - when it's integers stored and not dates

2008-03-24 Thread Les Mizzell
I'd been trying to come up with a way to do this, but the columns with a 0 in them are throwing me off, since 0 isn't a valid date value. and I might add - it was put a 0 in there, or allow a null, which would have been worse...

Re: Date Range Search Problem - when it's integers stored and not dates

2008-03-24 Thread Claude Schneegans
How about: and YEAR = #form.from_y# and YEAR = #form.to_y# and ((MONTH = #form.from_m# and MONTH = #form.to_m#) OR MONTH=0) and ((DAY = #form.from_d# and DAY = #form.to_d#) OR DAY=0) -- ___ REUSE CODE! Use custom tags; See

Re: Date Range Search Problem - when it's integers stored and not dates

2008-03-24 Thread Josh Nathanson
I'd been trying to come up with a way to do this, but the columns with a 0 in them are throwing me off, since 0 isn't a valid date value. You could use CASE or IF to fill in dummy values for those zeroes, but then, if you substituted 1 (January) for the month for example, it wouldn't be found

Re: Date Range Search Problem - when it's integers stored and not dates

2008-03-24 Thread Les Mizzell
Claude Schneegans wrote: How about: and YEAR = #form.from_y# and YEAR = #form.to_y# and ((MONTH = #form.from_m# and MONTH = #form.to_m#) OR MONTH=0) and ((DAY = #form.from_d# and DAY = #form.to_d#) OR DAY=0) The problem with that is the same problem as the previous example I

How to limit this query to 1 photo per community?

2008-03-24 Thread Rick Faircloth
This seems like it ought to be simple, but I'm not quite seeing the solution. How would I adjust this query to select one community from the new_communities table and only the *first* photo from the new_community_photos table. Right now I get the community as many times as there are photos for

Re: How to limit this query to 1 photo per community?

2008-03-24 Thread Bruce Sorge
This should work: select TOP (1) nc.new_community_id, nc.new_community_name, nc.new_community_short_desc, ncp.new_community_photo_w150, ncp.new_community_photo_w500 from new_communities nc, new_community_photos ncp where nc.new_community_id = ncp.new_community_id order by

Re: Date Range Search Problem - when it's integers stored and not dates

2008-03-24 Thread denstar
Are they against letting you add a real date field? I've been there, in spades, and there's always a way through. Sometimes it's a lot easier, and not as much fun, as banging your head against the same angle of attack for hours tho. :-) Perhaps add a date field, and then make some magic that

Re: Date Range Search Problem - when it's integers stored and not dates - IDEA!!!

2008-03-24 Thread Les Mizzell
Ahhh- here's an idea! OK, in theory... Let's just look at just the month for starters... form.startMONTH form.endMONTH Each has a value of 1 - 12 but, let's use that as LIST START AND END POSITIONS Set a list containing 2 years worth of months: cfset findMONTHS =

Re: Date Range Search Problem - when it's integers stored and not dates

2008-03-24 Thread Les Mizzell
denstar wrote: Are they against letting you add a real date field? Seeing there's already several hundred records in the database, some with dates, some with NONE - which is exactly what they want - adding a real date field would be tough. It was a hard argument to start with, and I let them

Re: String function question

2008-03-24 Thread C S
The biggest problem I am having is getting the columns for the form to line up properly (they are a series of radio buttons). I can get all of the values and the text fields fill in properly. The radio button values fill in with what I select, just not in the correct column. Did you ever try

Re: Date Range Search Problem - when it's integers stored and not dates

2008-03-24 Thread C S
The problem with that is the same problem as the previous example I posted though. Try searching for dates between 10/15/2006 and 04/14/2007 Given those search dates, how do you want to handle records with a year only (2006 or 2007). Same question for the month.

RE: Google geocoder and CF5

2008-03-24 Thread Adrian Lynch
Show us your code. Adrian -Original Message- From: Claude Schneegans Sent: 24 March 2008 23:32 To: CF-Talk Subject: Google geocoder and CF5 Hi, Has anyone succeeded getting the Google geocoder to work underCF5? I have my API working fine under CFMX, but under CF5 Google keeps

Re: Date Range Search Problem - when it's integers stored and not dates

2008-03-24 Thread Claude Schneegans
Try searching for dates between 10/15/2006 and 04/14/2007 See the problem? Yeah, my answer was a bit too easy ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL

RE: How to limit this query to 1 photo per community?

2008-03-24 Thread Rick Faircloth
Hi, Bruce and thanks for the reply. TOP (1) isn't working. From what I can tell, that's an MSSQL function and MySQL (sorry, should have specified db) doesn't use it. MySQL uses Limit 1 for that functionality, but in this case, I don't want to get just the first community, but every community,

Re: String function question

2008-03-24 Thread Bruce Sorge
Yes I did. Had to make some changes though. Still did not produce the desired result. Here is what I did: Original code: newValue was being created inside the cfif's, but was not there in the last CFSET. Also, form.FieldNames were not being found until I added the loop before the CFIF's. What

Re: Google geocoder and CF5

2008-03-24 Thread Claude Schneegans
Show us your code. Well the code works under CF 7 and not with CF5, so I suspect it is something like Google expecting UTF-8 in headers or something like that. Any way, the code is: CFHTTP URL=http://maps.google.com/maps/geo?q=#q#output=xmlkey=#googleKey#; METHOD=GET RESOLVEURL=false I doubt

Re: How to limit this query to 1 photo per community?

2008-03-24 Thread Bruce Sorge
Ahh, sorry about that. I am not very good with MySql so I am afraid I can't be of more assistance. Bruce Rick Faircloth wrote: Hi, Bruce and thanks for the reply. TOP (1) isn't working. From what I can tell, that's an MSSQL function and MySQL (sorry, should have specified db) doesn't use

RE: How to limit this query to 1 photo per community?

2008-03-24 Thread Rick Faircloth
Go it... just needed to add: group by nc.new_community_name before the order by clause Thanks for your assistance! Rick -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2008 8:55 PM To: CF-Talk Subject: Re: How to limit this query to 1 photo

RE: Perhaps a little over complicated - Dissecting a String

2008-03-24 Thread Bobby Hartsfield
Been using this forever. !--- Author: Bobby Hartsfield | [EMAIL PROTECTED] File: trimtext.cfm Description: This tag will take the text passed to it and create a teaser Meaning, it will trim the text back and add a trailing ... to the end Making for a good

RE: Perhaps a little over complicated - Dissecting a String

2008-03-24 Thread Nate Willard
Thanks bobby. This ensures words are not cut in half, not sentences correct? Or did I miss something? Thanks Bobby Hartsfield [EMAIL PROTECTED] wrote: Been using this forever. Author: Bobby Hartsfield | [EMAIL PROTECTED] File: trimtext.cfm Description: This tag will take the text passed to it

Is it a CF8 BUG? Very strange CFGRID format = HTML error!

2008-03-24 Thread Ali
Hi: This is very strange. The FGRID works fine when I choose Format = Applet but when I choose Format = HTML and I don't choose anything on the GRID and press submit button the following error returns! The cfgridupdate tag cannot find the grid named MyGrid When I choose a grid cell and edit it and

  1   2   >