RE: cfdbinfo REMARKS column

2007-11-17 Thread Adrian Lynch
Seems like it! I went with another method. I created my own tables and a simple page to add and edit them. Works nicely but I'd still like to know about the REMARKS column. A job for another day prehaps :O) Adrian -Original Message- From: Todd [mailto:[EMAIL PROTECTED] Sent: 16 November

RE: cfdbinfo REMARKS column

2007-11-17 Thread Adrian Lynch
Ah cheers dude. Good to know. Adrian -Original Message- From: Tom Donovan [mailto:[EMAIL PROTECTED] Sent: 16 November 2007 22:39 To: CF-Talk Subject: Re: cfdbinfo REMARKS column Adrian Lynch wrote: Where would the remarks column get populated from when I use the code below on SQL

Re: cfdbinfo REMARKS column

2007-11-17 Thread Jochem van Dieten
Adrian Lynch wrote: I went with another method. I created my own tables and a simple page to add and edit them. Works nicely but I'd still like to know about the REMARKS column. It is part of the return from the getTables method of the JDBC API:

Re: How to invoking CFC in with relative path

2007-11-17 Thread Dominic Watson
Brian, I am certainly not against ColdSpring and I understand that using a mapping is often preferrable to this approach, I just offer it as an alternative. I realised I asked why it is not good and I can see that for certain uses of CFCs that you pointed out it is clearly not. However, I do thnk

Re: Filtering users by IP

2007-11-17 Thread George Linderman
Thanks a lot guys for all the answers...it's very appreciated. I'm going to mess around with the options you've given me, and then post back here if I have any more troubles. I see what you mean about the dynamic IP. All of our users use a computer given to them by the company, with a mobile

Re: cfinput type=quot;filequot; accept=quot;application/msexcelquot;

2007-11-17 Thread Richard White
1) use correct mime type for excel files - it is NOT application/msexcel 2) the accept attribute, afaik, is for cffile tag, not for cfinput, and is executed on the server 3) the accept attribute, afaik, will only check the extension of uploaded file - even if i rename my .exe file as .xls it

Re: blocking spambots

2007-11-17 Thread Richard Dillman
Maybe this is a little too simple, but I simply block any non email fields from containing an @ or http://; or www. On Nov 16, 2007 3:57 PM, Ben Doom [EMAIL PROTECTED] wrote: Which is more or less what I meant by variant. --Ben Doom Larry Lyons wrote: Always use CAPTCHA or a variant when

Re: Verity, does it work?

2007-11-17 Thread Raymond Camden
I found the stuff in the cf8 docs and confirmed the limit #s are the same. For some reason they hide this info next to the info about the command line tools. On Nov 17, 2007 7:42 AM, Raymond Camden [EMAIL PROTECTED] wrote: On Nov 16, 2007 7:09 PM, Jonathan Gingerich [EMAIL PROTECTED] wrote: I

Re: Verity, does it work?

2007-11-17 Thread Raymond Camden
On Nov 16, 2007 7:09 PM, Jonathan Gingerich [EMAIL PROTECTED] wrote: I take a collection and index it using the Administrator against a single directory with two .html files and a .doc file. No matter how I play around with the extensions, I either get the 2 .html files indexed, or none of

Re: How to invoking CFC in with relative path

2007-11-17 Thread Dominic Watson
Having spent this morning looking at ColdSpring and AOP, I take the liberty to write an alternative to your initial reply. Hopefully my intitial objections will be clear (the use of the words 'hack' and 'correctly'). New response: David, you can do 1 of 3 (or more) things: 1. Create a mapping

Re: How to invoking CFC in with relative path

2007-11-17 Thread Brian Kotek
On Nov 17, 2007 6:14 AM, Dominic Watson [EMAIL PROTECTED] wrote: Perhaps I was not clear in the initial post, but here is an example of how this works to solve the problem of not being able to use relative paths for components. Let us say you have the following folder struct: wwwroot\

Re: How to invoking CFC in with relative path

2007-11-17 Thread Brian Kotek
Heh, it doesn't take much playing with ColdSpring for that a-ha moment to come. ;-) On Nov 17, 2007 9:09 AM, Dominic Watson [EMAIL PROTECTED] wrote: Having spent this morning looking at ColdSpring and AOP, I take the liberty to write an alternative to your initial reply. Hopefully my intitial

Globalization Question

2007-11-17 Thread Steve Milburn
Hi folks I am developing an applications that is eventually going to required support for multiple languages.  I'm new to I18N, etc, and have a question I'm hoping somebody gave help with.  Based on what I'm reading in the CFWACK books and by various posting on Paul Hastings blogs and articles

outputting table and column names from a database

2007-11-17 Thread Steve Good
I am drawing a blank here. How do I dump the names of all the tables in a database and the columns in each of the tables? I know how to dump the columns and rows from a specified table, but that's not what i want to do. What I'm trying to do is create a printable database structure list

Re: outputting table and column names from a database

2007-11-17 Thread Mike Chabot
I think this is more of a database question than a CF question, so the answer would depend on which database you use. If you use MS SQL Server, you will find many free scripts that do this at sqlservercentral.com under the scripts section. If what you want is a printable db structure, you could

Re: outputting table and column names from a database

2007-11-17 Thread Casey Dougall
On Nov 17, 2007 2:25 PM, Steve Good [EMAIL PROTECTED] wrote: I am drawing a blank here. How do I dump the names of all the tables in a database and the columns in each of the tables? I know how to dump the columns and rows from a specified table, but that's not what i want to do. What I'm

Re: outputting table and column names from a database

2007-11-17 Thread Steve Good
I figured it out just as soon as i sent my email. I just needed something quick and dirty so i could print out the structure. Code i used below. style li {margin-left:25px;} /style cfquery name=dump datasource=datasource SHOW TABLES /cfquery cfloop query=dump cfoutput

Re: outputting table and column names from a database

2007-11-17 Thread Claude Schneegans
Coldfusion 8... And if NOT CF*, see CFX_ODBCinfo: http://www.contentbox.com/claude/customtags/ODBCInfo/E/TestODBCInfo.cfm Works with any ODBC database. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please

RE: Converting simple Java code to CF

2007-11-17 Thread Jaime Metcher
That error is a totally non-specific object instantiation error. That third sentence (...must not be an interface...) is just a stab in the dark by some engineer trying to be helpful. Look down the full stack trace to find out what the real error is. Jaime Metcher That looks very promising,

Re: Globalization Question

2007-11-17 Thread Paul Hastings
Steve Milburn wrote: options in a database.� Why should I use resource bundles instead of just adding a locale field to the database and querying based on the user's locale?� It seems this technique could be used for just about anything, table my only questions are how will you manage

Re: How to invoking CFC in with relative path

2007-11-17 Thread Dominic Watson
Maybe this is what you're missing, because you don't need to have a mapping in this example to use ColdSpring or just to call the components yourself. Yup, dead right (that is what I am missing)! Shocking that I've had that impression for such a long time too. We have always used a mapping

Re: Globalization Question

2007-11-17 Thread Steve Milburn
Hi Paul Thanks for the response.  I'm obviously new to this, but in response to your questions (1) would the process of managing translations for a db be that much different than managing translations for resource bundle properties files?  (2) I'm certainly not trying to re-invent the wheel,

Re: Converting simple Java code to CF

2007-11-17 Thread Janet MacKay
That error is a totally non-specific object instantiation error. That third sentence (...must not be an interface...) is just a stab in the dark by some engineer trying to be helpful. Look down the full stack trace to find out what the real error is. Jaime, That wouldn't surprise me, but I