Re: Rate your favorite coldfusion framework

2006-10-21 Thread Nick Tong - TalkWebSolutions.co.uk
I agree that most people will think of the popular frameworks and it's only these that have been included in the poll (some of which I've missed out and for that I'm sorry). In software development, a *framework* is a defined support structure in which another software project can be organized

Re: CFDOCUMENT and CFCONTENT

2006-10-21 Thread James Holmes
Sorry, where is the DB call here? On 10/21/06, Bryan Stevenson [EMAIL PROTECTED] wrote: binaryImage.cfm cffile action=readbinary file=d:\appName\images\image.jpg variable=outputImage cfcontent type=image/jpg variable=#outputImage# -- CFAJAX docs and other useful articles:

RE: Rate your favorite coldfusion framework

2006-10-21 Thread Snake
Of course don't forget that ColdFusion itself is a framework. -Original Message- From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED] Sent: 21 October 2006 11:01 To: CF-Talk Subject: Re: Rate your favorite coldfusion framework I agree that most people will think of the

RE: URLSessionFormat() and Spry request

2006-10-21 Thread Dan G. Switzer, II
Walter, The problem is below is a URL derived from JavaScript code: var request_URL =/petitions/client/remote/authenticate.cfm?username=+uName+password=+u Pass; Spry.Utils.loadURL(GET, request_URL, false, authBack); which returns values as expected but does not set the session variables, so I

RE: Can I use replace function on a string to create form drop bo x options?

2006-10-21 Thread Andrew Tyrone
1º using a (small) list is not a workaround, it is a short cut. Before I take short cuts, the first thing that comes to mind is, I hope I won't need to redo this later. 2º updating one field in a table is much more straightforward than updating a multi records cross table. If you mean the

RE: Can I use replace function on a string to create form drop bo x options?

2006-10-21 Thread Dave Watts
1º using a (small) list is not a workaround, it is a short cut. Whatever you want to call it, doesn't matter to me. I find that, for me, taking short cuts now often means longer detours later. 2º updating one field in a table is much more straightforward than updating a multi records cross

SOT: Any way to get table names and datatypes via a query?

2006-10-21 Thread Pete Ruckelshaus
Slightly Off-Topic SQL question: Using SQL Server 2000, is there any way to get (a) a list of non-system table names for a given database, and (b) any way to get the datatypes for database columns? This would be via two different queries. I want to create a CF-based utility that I can point at

Re: SOT: Any way to get table names and datatypes via a query?

2006-10-21 Thread Andrew Scott
yes from the system tables cant think of the exact query off the top of my head. On 10/22/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote: Slightly Off-Topic SQL question: Using SQL Server 2000, is there any way to get (a) a list of non-system table names for a given database, and (b) any way

Re: Can I use replace function on a string to create form drop bo x options?

2006-10-21 Thread Claude Schneegans
Before I take short cuts, the first thing that comes to mind is, I hope I won't need to redo this later. Then if you're not sure, don't do it. The purpose of and RDBMS is storing data in a relational way in the first place, Right, when there is a relation worth to be treated as such. so

Re: SOT: Any way to get table names and datatypes via a query?

2006-10-21 Thread C. Hatton Humphrey
I've built something similar that lets me create a SQL Script dump file similar to what MySQL allows. Here's the starting idea for the query - SELECT SO.Name as TableName, SC.Name as ColumnName, ST.Name + CASE WHEN ST.Status = 2 THEN '(' + CONVERT(VarChar(6), SC.Length) + ')' ELSE CASE WHEN

Re: Can I use replace function on a string to create form drop bo x options?

2006-10-21 Thread Claude Schneegans
In this specific case, you have a fixed list of Boolean values. I said a short list, it doesn't have to be fixed. It can be a list of codes related to a table with codes and description, and this table is expandable. But you don't always need a cross table between them. I use this for

HomeSite-esque Forms Generator

2006-10-21 Thread Andrew Peterson
Hi, In the event that I at some point lose track of my HomeSite installation, is there another Build-a-Form Generator based off of a table structure? It makes for a nice start for huge forms. Thanks in advance. Sincerely, Andrew

Re: HomeSite-esque Forms Generator

2006-10-21 Thread Massimo Foti
In the event that I at some point lose track of my HomeSite installation, is there another Build-a-Form Generator based off of a table structure? It makes for a nice start for huge forms. Thanks in advance. Dreamweaver's Application Objects offer a similar kind of functionality. Of course,

Re: SOT: Any way to get table names and datatypes via a query?

2006-10-21 Thread Pete Ruckelshaus
That's awesome Hatton, thanks. I'll look in BOL to see if I can figure a better way to find the datatypes, since only varchar and int IDENTITY seem to be set in your script. Thanks again, Pete ~| Introducing the Fusion

PDF output : cfdocumentitem type=header

2006-10-21 Thread Walter Conti
PDF output : cfdocumentitem type=header Is it possible to start header output from page 2? Thanks for helping. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by

Re: SOT: Any way to get table names and datatypes via a query?

2006-10-21 Thread C. Hatton Humphrey
On 10/21/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote: That's awesome Hatton, thanks. I'll look in BOL to see if I can figure a better way to find the datatypes, since only varchar and int IDENTITY seem to be set in your script. That was the initial query that I wrote for the dumper... I

RE: SOT: Any way to get table names and datatypes via a query?

2006-10-21 Thread Dave Francis
cfquery name=q1 datasource=datasource SELECT * from INFORMATION_SCHEMA.tables WHERE table_type = 'BASE TABLE' ORDER BY table_name /cfquery cfquery name=q2 datasource=datasource SELECT * from

Re: Changed CGI.REQUEST_URI behaviour with CF7/Apache - A Solution

2006-10-21 Thread James Holmes
It took me ages to find it, and it's part of the Apache docs but not part of the CF docs. http://httpd.apache.org/docs/2.0/custom-error.html On 10/19/06, Rob Wilkerson [EMAIL PROTECTED] wrote: Where were you about a week ago?! I ended up setting my own CGI variable using the E flag of

Re: Designing for modularity

2006-10-21 Thread Denny Valliant
On 10/19/06, Tom Chiverton [EMAIL PROTECTED] wrote: On Sunday 15 October 2006 17:10, Doug Brown wrote: server. Anyhow, any help or suggestions would be greatly appreciated. Remember the premature optimisation anti-pattern. Unless you are certain volume or redundancy issues are going to come

Re: IE7 ?

2006-10-21 Thread Denny Valliant
On 10/19/06, Kevin Aebig [EMAIL PROTECTED] wrote: All in all, I uninstalled it and got IE 6 back, but frankly I'll personally call up M$ and tell them to eat a bowl of my nuts if they try and force this on me with a patch... As an interesting side, that I wouldn't mind getting

Re: SOT: Any way to get table names and datatypes via a query?

2006-10-21 Thread Pete Ruckelshaus
OK, since all I needed for what I'm planning is the table names, column names, datatypes, and column length (primarily for varchar fields), here's the query I came up with (based upon Hatton's work): SELECT SO.Name as TableName, SC.Name as ColumnName,

Re: Rate your favorite coldfusion framework

2006-10-21 Thread Denny Valliant
On 10/21/06, Snake [EMAIL PROTECTED] wrote: Of course don't forget that ColdFusion itself is a framework. Everything's a framework!!! Ahhh!! order and chaos are at it again! I think consistency is a good thing to aim for, although consistent doesn't always mean good. ;-) Personally, (i've been

RE: Can I use replace function on a string to create form drop bo x options?

2006-10-21 Thread Andrew Tyrone
Just put the days in the list, not codes ;-)) That will make a field with a max of what? 50 characters may be? Big deal! ;-) And...? It doesn't matter which types of data you store in those lists. How would you return a workable query? You can't, and you'd have to jump through a bunch of

WASHINGTON DC COLD FUSION DEVELOPER NEEDED

2006-10-21 Thread CL Smoothest
The Web Developer develops, implements, and maintains web applications for a government agency in Washington DC using Cold Fusion. Work will include development of new modules, conversion of conventional database applications and troubleshooting active modules on the internet and intranet.