Re: Flat File as a Database?

2009-01-25 Thread Bob Wright
Hi Kym, thanks for the reply. Very good question. The criteria is really "No Database". There is more detailed and specific language than that, but it pretty much sums it up. As you pointed out, a filesystem is certainly a database, of sorts. I have been pondering it. It seems a bit messy th

Re: Flat File as a Database?

2009-01-25 Thread Kym Kovan
Hi Bob, OK so you want a flat file. Does it have to be that or is the criteria really "No database"? What we don't know is your overall site design, is the database going to be big, hundreds/thousands/millions of entries, etc? If it not ridiculously big and depending on what you need to so in

Re: Flat File as a Database?

2009-01-25 Thread Bob Wright
Thanks all for the replies. It sounds like some of you are in a position to fire clients. But since I get paid by the job, I can't just do that. Maybe someday, but not today. Besides, the client is not an idiot. I'm sorry, I can't go into detail about the reasons why we are limited to a flat

Re: SQL query sorting problem

2009-01-25 Thread Azadi Saryev
rty a UNION query generated inside a : (SELECT *, #j# AS sortcol FROM cities WHERE state = '#listgetat(states, j)#') UNION ORDER BY sortcol, city you could also probably build a dynamic CASE statement instead of using a UNION query, but i will need to check up the syntax of that... Azadi Sa

SQL query sorting problem

2009-01-25 Thread Jim McAtee
DBMS is MySQL 5. I have a report that is generated for cities within several states. The states are designated by their two letter postal abbreviations and are in a certain order. For example: 1. NY 2. CA 3. FL I would like the records of the report sorted by the original state order, then

Re: Adobe "Bolt" anyone?

2009-01-25 Thread Eric Roberts
Where...I even double checked it and didn't see anything the last time we had this discussion/comic dialogue... Eric Brian Kotek wrote: > Actually, the Adobe NDA explicitly states that you cannot even admit the > existence of the beta software, among numerous other things. I suggest you > reread

Re: Adobe "Bolt" anyone?

2009-01-25 Thread Gerald Guido
Unbelievable. God forbid anyone get even the tiniest glimpse of the tools that they use to make their living. For the love of what ever you believe in, who here has read the terms of a prerelease or any other "click here to accept" license? God forbid that the stewards of CF squander any more of it

Re: "From" and "ReplyTo" address, CFMAIL and Spam filters...

2009-01-25 Thread Matt Quackenbush
IMO, you should definitely be sending _from_ an address at the site's domain. Simply place the form respondent's email address in the replyto attribute of . // message HTH. ~| Adobe® ColdFusion® 8 software 8 is the most

Re: Adobe "Bolt" anyone?

2009-01-25 Thread Wil Genovese
So if you know what the NDA says, then that must mean you've read the NDA and thus are part of an Abode prerelease program. Does this mean you just violated your NDA by saying you read the NDA? I'm just wondering. Not that I have any knowledge of the NDA or if it even exists. Wil Genov

Re: Adobe "Bolt" anyone?

2009-01-25 Thread Brian Kotek
Actually, the Adobe NDA explicitly states that you cannot even admit the existence of the beta software, among numerous other things. I suggest you reread the NDA, because you just violated it. On Fri, Jan 23, 2009 at 8:05 PM, Eric Roberts < ow...@threeravensconsulting.com> wrote: > That is incor

"From" and "ReplyTo" address, CFMAIL and Spam filters...

2009-01-25 Thread Les Mizzell
Recently have seen some emails vanish without being delivered from various forms on a particular site. Been working great past four years with no trouble, so was a head scratcher... After going back and forth with HostMySite a number of times, the only thing we could could come up with was that

Creating a struct while not knowing node names

2009-01-25 Thread Joe
Always so close yet so far away... That did it - thanks a lot!!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Arch

Re: Creating a struct while not knowing node names

2009-01-25 Thread Peter Boughton
Wait, are you converting a query to a structure of arrays just so you can then convert that to JSON? If so, stop it - it's unnecessary. If you're on CF8 you can add cffunction attributes returnformat="JSON" and queryformat="row|column" as appropriate and just cfreturn the query. If you're on C

Re: Removing spaces from a string?

2009-01-25 Thread Joel Polsky
>Trim will only remove leading and trailing spaces. > >If you want to remove all spaces, > >Replace(StringVar, " ", "", all) > >Rob >At 08:59 PM 6/28/2003 +0200, cf-t...@sdsolutions.de wrote: >> This is correct: (and a little old to reply, but wanted to have it correct for future people who read

Re: Flat File as a Database?

2009-01-25 Thread Nitai @ SixSigns
Hi Bob Use a embedded database like H2. This will solve your problem. It is a flat file that you can use with the normal cfquery. Kind Regards, Nitai On Jan 25, 2009, at 6:51 PM, Bob Wright wrote: > I have a need to build a site which will not have access to a > database. Instead, the clie

Re: Creating a struct while not knowing node names

2009-01-25 Thread Peter Boughton
> > > Use there instead. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http:

Creating a struct while not knowing node names

2009-01-25 Thread Joe
I'm working a CFC web service where I want to return a JSON string; I don't necessarily know my table's column names ahead of time. I am able to pull out the table's column names and am trying to use them as my struct's node names. When I try to dump them out, I get the string "IDX" rather than t

Re: Flat File as a Database?

2009-01-25 Thread Don L
> Hello everyone, > > I have a need to build a site which will not have access to a database. > Instead, the client has specified that I must use a flat file. On > this flat file, I need to be able insert, update, and select > > Honestly, I don't even know where to start. > > Anyone have any

Re: Flat File as a Database?

2009-01-25 Thread Claude Schneegans
>>I have never thought it a good business practice to call a client stupid. Calling him stupid, no, but get rid of him yes! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Tria

Re: Flat File as a Database?

2009-01-25 Thread Gerald Guido
I know you can define a text file (csv, txt) as an ODBC database. I have played with it a bit trying to import some stuff from a text document but nothing past doing a simple select statement. You can define delimiters and all that. G! On Sun, Jan 25, 2009 at 12:51 PM, Bob Wright wrote: > Hello

Re: Flat File as a Database?

2009-01-25 Thread Mike Chabot
"Flat file" is a type of database. Many flat file databases support SQL at some level. You should really clarify what the client is requesting here. If they are specifically requesting a flat file database instead of a relational database then there is a good chance that they have a specific produc

Re: Flat File as a Database?

2009-01-25 Thread Shannon Peevey
Umm... I have never thought it a good business practice to call a client stupid. Just my .02 Speeves On 1/25/09, Claude Schneegans wrote: > >>Honestly, I don't even know where to start. > > If the client is that stupid, use an Access database, and tell him it's > a flat file. > And don't tell h

Re: Using CFloop to pull data from CFC

2009-01-25 Thread Patrick McDonough
thanks I have got past this. Pat /grfxs ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoff

Re: Flat File as a Database?

2009-01-25 Thread Claude Schneegans
>>Honestly, I don't even know where to start. If the client is that stupid, use an Access database, and tell him it's a flat file. And don't tell him it's a database... And here is a better advice: find yourself another client! ~~

Re: Flat File as a Database?

2009-01-25 Thread Peter Boughton
Um, did you reply there? Just getting my message quoted... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: ht

Re: Using CFloop to pull data from CFC

2009-01-25 Thread Joel Watson
That is, "returnvariable=result", and then loop over "result". > You need to return and loop over "result" (what is being returned from > your component), not the method name. ~| Adobe® ColdFusion® 8 software 8 is the most impo

Re: Using CFloop to pull data from CFC

2009-01-25 Thread Joel Watson
You need to return and loop over "result" (what is being returned from your component), not the method name. > I am having trouble pulling data from a cfc for a pull down menu. Here > is the code from the cfm file: > > > > > class

Using CFloop to pull data from CFC

2009-01-25 Thread Patrick McDonough
I am having trouble pulling data from a cfc for a pull down menu. Here is the code from the cfm file: Catalog Request Our Products

Re: Flat File as a Database?

2009-01-25 Thread Bob Wright
> Why can't you use a database? > > Is the client just being an idiot, or is there a legitimate reason for > it? > > > If you're on CF8 or Railo, you can serialize/deserialize your query > objects, so you could store the data as a flat CFML/JSON file, but act > on it using Query of Queries. >

Re: Flat File as a Database?

2009-01-25 Thread Peter Boughton
Why can't you use a database? Is the client just being an idiot, or is there a legitimate reason for it? If you're on CF8 or Railo, you can serialize/deserialize your query objects, so you could store the data as a flat CFML/JSON file, but act on it using Query of Queries. But first I would

Flat File as a Database?

2009-01-25 Thread Bob Wright
Hello everyone, I have a need to build a site which will not have access to a database. Instead, the client has specified that I must use a flat file. On this flat file, I need to be able insert, update, and select Honestly, I don't even know where to start. Anyone have any idea how to go ab

Re: Insert from Dynamically Generated Form

2009-01-25 Thread James Holmes
Use structKeyExists(); it's neater and it can perform better. Also, the evaluate()s are unnecessary. This; is an unnecessarily complicated way of doing which is far more readable. You could also avoid the whole isdefined/structkeyexists issue by looping directly through the form struct as

Re: Insert from Dynamically Generated Form

2009-01-25 Thread Jason Congerton
Hi Can't believe I’ve been such a numpty, the isdefined statement I was trying had an error in the format missing bracket!! Corrected the bracket issue, works fine... Kind Regards Jason ~| Adobe® ColdFusion® 8 soft

RE: Insert from Dynamically Generated Form

2009-01-25 Thread Terry Troxel
What about isdefined or using cfparam? -Original Message- From: Jason Congerton [mailto:ja...@jasoncongerton.co.uk] Sent: Sunday, January 25, 2009 3:59 AM To: cf-talk Subject: Insert from Dynamically Generated Form Hi I have created a form using a database table to supply the form field

Insert from Dynamically Generated Form

2009-01-25 Thread Jason Congerton
Hi I have created a form using a database table to supply the form fields; one of the fields is a check box, the other a text field. Please see code below, I am using the following code to insert the record, however if all the check boxes are not checked, I