sql insert statement

[David Elliott]

I'm not functioning here:

Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 2:
Incorrect syntax near ']'.  
  
The error occurred in
C:\Inetpub\wwwroot\DaveActionForm.cfm: line 18
 
16 : 
17 : insert into card_information([date of entry],
[date of charge], [vendor name], [amount of charge],
[credit card number], [charge category], [employee /
comments])
18 :values('#form.dateofentry#',
'#form.date_of_charge#', '#form.vendor_name#',
#form.amount_of_charge#, '#form.credit_card_number#',
'#form.charge_category#', '#form.comments_employee#')]
19 :  
20 : 
 


 
SQLinsert into card_information([date of entry],
[date of charge], [vendor name], [amount of charge],
[credit card number], [charge category], [employee /
comments]) values('4/14/06', '12/31/06', 'whodunit',
0.00, '6167', 'food', '')]  
DATASOURCE   creditcard 
 


any comments or guidance appreciated!

Dave

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237797
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: 19 >= 19 - query error

[Adrian Lynch]

And to balance out the argument some, writing all the columns takes longer
to write!

Go on, fire away, I'm in my bunker and the flaps are down :OD

Adrian

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: 14 April 2006 20:32
To: CF-Talk
Subject: RE: 19 >= 19 - query error


Rick,

This is the easiest problem in the world to fix

Don't use SELECT *.

Name the column in the select statement. Not only does this cut out your
problem, it also:

1. Makes the select statement more clear to anyone else reading.
2. Increases speed of the query.
3. Decreases the amount (most likely) of info that SQL has to transfer to
the CF memory space.

Cheers,
ben



Ben Nadel
www.nylontechnology.com

Sanders: Lightspeed too slow?
Helmet: Yes we'll have to go right to ludacris speed.
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, April 14, 2006 11:51 AM
To: CF-Talk
Subject: 19 >= 19 - query error

what the heck is this?

19 >= 19


The error occurred in
E:\Inetpub\wwwroot\tools\email_responses\respond.cfm: line 20

18 :A.*, B.name as PRMLNAME
19 :   FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
20 :   where id=
21 : 
22 : 


It's worth noting that there are 18 columns in the table.  I dropped another
column and ran the query again and I got "18 >= 18" (now there are only 17
columns)

here's the full query:

   SELECT
A.*, B.name as PRMLNAME
   FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
   where id=

Rick


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237796
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Pause?

[Adrian Lynch]

http://www.cflib.org/udf.cfm/sleep

-Original Message-
From: Loathe [mailto:[EMAIL PROTECTED]
Sent: 14 April 2006 19:26
To: CF-Talk
Subject: Pause?


If I wanted to say have a template pause for 10 seconds, how would you do
that, I mean, I can think of a couple of looping ways that would accomplish
about the same thing, but I remember seeing a Java class that does this
properly.

Ideas?

--
Timothy Heald
Analyst, Architect, Developer
[EMAIL PROTECTED]
W: 202-228-8372
C: 703-300-3911




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237795
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Pause?

[Loathe]

If I wanted to say have a template pause for 10 seconds, how would you do
that, I mean, I can think of a couple of looping ways that would accomplish
about the same thing, but I remember seeing a Java class that does this
properly.

Ideas?

--
Timothy Heald
Analyst, Architect, Developer
[EMAIL PROTECTED]
W: 202-228-8372
C: 703-300-3911


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237793
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: 19 >= 19 - query error

[Ben Nadel]

Rick, 

This is the easiest problem in the world to fix

Don't use SELECT *. 

Name the column in the select statement. Not only does this cut out your
problem, it also:

1. Makes the select statement more clear to anyone else reading.
2. Increases speed of the query.
3. Decreases the amount (most likely) of info that SQL has to transfer to
the CF memory space.

Cheers,
ben 


...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Ave.
Suite 1005
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com

Sanders: Lightspeed too slow?
Helmet: Yes we'll have to go right to ludacris speed.
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 14, 2006 11:51 AM
To: CF-Talk
Subject: 19 >= 19 - query error

what the heck is this?

19 >= 19


The error occurred in
E:\Inetpub\wwwroot\tools\email_responses\respond.cfm: line 20

18 :A.*, B.name as PRMLNAME
19 :   FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
20 :   where id=
21 : 
22 : 


It's worth noting that there are 18 columns in the table.  I dropped another
column and ran the query again and I got "18 >= 18" (now there are only 17
columns)

here's the full query:

   SELECT
A.*, B.name as PRMLNAME
   FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
   where id=

Rick



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237794
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Insert SQL Statement

[Wexel, Ken]

Use []

e.g.

INSERT INTO
[card information]([card number])
values(1);



Ken Wexel
Senior Programmer Analyst
Verian Technologies
8701 Mallard Creek Road
Charlotte, NC 28262 

ProcureIT- Spend Management for Your Enterprise

mailto:[EMAIL PROTECTED]
http://www.verian.com/

Verian Technologies Named to Supply & Demand Chain Executives'  Top 100 List 
Four out of Five Years
http://www.sdcexec.com/article.asp?article_id=7377

Global Logistics & Supply Chain Strategies Readers Name Verian Technologies as 
one of Top 100 Supply Chain Partners for Second Year
http://glscs.texterity.com/glscs/200507/?pg=30&pm=2

Verian Technologies Named one of  Inbound Logistics 2005 Top 100 IT Logistics 
Companies
http://www.verian.com/PressReleases/documents/PRInboundLogisticsTop100.htm


-Original Message-
From: David Elliott [mailto:[EMAIL PROTECTED]
Sent: Friday, April 14, 2006 2:48 PM
To: CF-Talk
Subject: Insert SQL Statement


Poor planning on my part but, 

I have a table on an sql server named 'card
information'.  It is two words.  There are 5 rows
inside this table.  They two are made up of names like
'credit card number' or 'amount of charge' (all
without the punctuation[.  It looks like the rows are
working just fine.  However, I am unsure how to deal
with the two word table name.

Any suggestions?

Thanks,

Dave



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237792
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Insert SQL Statement

[Andy Matthews]

Quote it?



-Original Message-
From: David Elliott [mailto:[EMAIL PROTECTED]
Sent: Friday, April 14, 2006 1:48 PM
To: CF-Talk
Subject: Insert SQL Statement


Poor planning on my part but,

I have a table on an sql server named 'card
information'.  It is two words.  There are 5 rows
inside this table.  They two are made up of names like
'credit card number' or 'amount of charge' (all
without the punctuation[.  It looks like the rows are
working just fine.  However, I am unsure how to deal
with the two word table name.

Any suggestions?

Thanks,

Dave



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237791
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: disk size manager

[Munson, Jacob]

As someone else mentioned, I think what you need to do is best handled
by the OS.  You can probably do something with CF, but it's probably
going to be time consuming and inefficient.  If you're on Linux, you can
use the du command in a script, and call this with cfexecute.  I'm not
sure if there's anything that handy in Windows land... 

> -Original Message-
> From: Turetsky, Seth [mailto:[EMAIL PROTECTED] 
> Sent: Friday, April 14, 2006 11:35 AM
> 
> Andy/Jacob
> Very handy, but I'm using BlueDragon.  Tried it out of 
> curiosity, but it just listed the current directory.
> Will inquire with NewAtlanta about it.
> 
> -Original Message-
> From: Munson, Jacob [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 14, 2006 1:06 PM
> 
> > ColdFusion 7 has recursion built into cfdirectory I believe.
> 
> You are correct:
> http://coldfusioncookbook.com/entry/79/How-do-I-find-the-size-
> of-a-direc
> tory?


[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237790
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Insert SQL Statement

[David Elliott]

Poor planning on my part but, 

I have a table on an sql server named 'card
information'.  It is two words.  There are 5 rows
inside this table.  They two are made up of names like
'credit card number' or 'amount of charge' (all
without the punctuation[.  It looks like the rows are
working just fine.  However, I am unsure how to deal
with the two word table name.

Any suggestions?

Thanks,

Dave

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237789
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: TextArea for multi inputs

[Loathe]

On the action page you treat the form field's output (form["whatever"] or
form.whatever) as a list using CRLF as the list delimiter.

--
Timothy Heald
Analyst, Architect, Developer
[EMAIL PROTECTED]
W: 202-228-8372
C: 703-300-3911
-Original Message-
From: j s [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 14, 2006 11:44 AM
To: CF-Talk
Subject: TextArea for multi inputs

Does anyone know how to use a textarea as a multi input field?  F.e. I'v
seen a form which uses a textarea to insert mulitple email addresses each
separated by the carriage return.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237788
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: StructFindKey Path and evaluate

[Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions]

Isaac,

Thanks for the 

RE: java.lang.OutOfMemoryError: unable to create new native thread

[Chris Norloff]

We had out-of-memory problems with CFMX 6.1 udpater, and using metrics 
determined it wasn't growing the heap as it was supposed to. (We've stuck with 
the same settings on CFMX 7).  

I'd try starting the heap at the same size as the maximum, and also experiment 
with starting the Permanent Generation at 256, ... and get those metrics going. 


Here's a simple thing you can use in the interim:






 



Free Allocated Memory: #Round(freeMemory)# MB
Total Memory Allocated: #Round(totalMemory)# MB
Max Memory Available to JVM: #Round(maxMemory)# MB









% of Free Allocated Memory: #percentFreeAllocated#%
% of Available Memory Allocated: #percentAllocated#%




-- Original Message --
From: "Russ" <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date:  Tue, 11 Apr 2006 12:16:02 -0400

>I have already played with those settings, but it still crashed yesterday.
>Here are the settings I'm using:
>
>java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xms256m
>-Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=512m
>-XX:+UseParallelGC -XX:+AggressiveHeap
>
>You would think 512mb is enough for the heap?   Am I giving it too much
>possibly?  
>
>This server has 1gb of ram. 
>
>Russ
>
>> -Original Message-
>> From: Oleg Gunkin [mailto:[EMAIL PROTECTED]
>> Sent: Monday, April 10, 2006 7:48 PM
>> To: CF-Talk
>> Subject: RE: java.lang.OutOfMemoryError: unable to create new native
>> thread
>> 
>> Coldfusion 7 needs more heap space than your JVM allows it to use. You
>> need to increase maximum heap size.
>> 
>> The following is for JSP, but solution is the same.
>> 
>> http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17470
>> 
>> --
>> Oleg Gunkin
>> Email: [EMAIL PROTECTED]
>> Phone: (604) 666-9392
>> Emerging Technologies / Pacific Web Services
>> Information Technology Services
>> Public Works and Government Services Canada (Pacific)
>> 
>> 
>
>

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237786
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

TextArea for multi inputs

[j s]

I want to use a textarea form feild to insert multiple values.  f.e. I've seen 
it used to insert muliple email addresses seperated by a carriage return.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237785
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: database linking table naming conventions?

[Shepherd, Brandon]

I preface all table names with 3 character group reference.

SECURITY
SEC_Roles PK=Role_Key
SEC_Users PK=User_Key
SEC_User_Roles PK=User_Role_Key
  FK=Role_Key
  FK=User_Key

BILLING
BIL_Invoices PK=Invoice_Key
BIL_Payments PK=Payment_Key
BIL_Invoice_Payments
 FK=Invoice_Key
 FK=Payment_Key

Etc...

-B

-Original Message-
From: Munson, Jacob [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 14, 2006 10:02 AM
To: CF-Talk
Subject: RE: database linking table naming conventions?

I'm confused.  You're worried about the name of the table and the order
of the table names in your DB?  This is a problem I've never heard of.
DBAs just name things what they want, and I've never heard of table
names causing problems except for cases like reserved words and special
characters in the name.  Or am I misunderstanding your question?

> -Original Message-
> From: John McKown [mailto:[EMAIL PROTECTED] 
> Sent: Friday, April 14, 2006 7:05 AM
> 
> Imagine these two database tables: "Users" and "Groups"
> 
> You want a Foreign Key table to link them together (or what I 
> call a linking
> table) that might be named "UserGroups".   
> 
> But "UserGroups" as a table name itself does not stand out in 
> the table list
> because it does not use a prefixed naming convention 
> (something I like about
> Fusebox on the web side).   
> 
> Examples table names might be:   "LT_Users_Groups" or 
> "FK_Users_Groups".
> 
> Is there an understood standard there?  Also, the order of 
> the table names
> might need to be taken into account based on where the 
> foreign keys are.


[INFO] -- Access Manager:
This transmission may contain information that is privileged,
confidential and/or exempt from disclosure under applicable law.  If you
are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. If you
received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic
or hard copy format.  Thank you.   A2





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237784
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: database linking table naming conventions?

[Rob Wilkerson]

I tend to follow Ryan's naming conventions for columns (e.g. user_id
in the user table) and I also understand what Josh is asking.  I'm
also a little obsessive about being able to quickly find tables or
files or any other object that might be present in a list.  To his
question, I often use 'lnk_' to denote linking tables and 'lu_' to
denote lookup tables.

In a database with many tables (or a directory with many files),
simple prefixes (or any such naming convention) make finding what I'm
looking /so/ much quicker.  Perhaps bordering on OCD, sometimes, but
it works for me.

On 4/14/06, Ryan Guill <[EMAIL PROTECTED]> wrote:
> Personally, I always make the primary key of a single table,
> tablenameID, so if its a user table, the primary key is userID.  If
> userid is used as a foreign key anywhere else in my database, its
> called userID.  A better way to put it is, if I have the same
> columnname in two tables, its a foreign key.  And usually the ID at
> the end of any column can tip you off to that fact.
>
> But thats just me personally.
>
> On 4/14/06, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> > :OS <--<< that's me turning up my nose to the LT_ and FK_!
> >
> > I prefer UsersToGroups for your example.
> >
> > -Original Message-
> > From: John McKown [mailto:[EMAIL PROTECTED]
> > Sent: 14 April 2006 14:05
> > To: CF-Talk
> > Subject: database linking table naming conventions?
> >
> >
> > Imagine these two database tables: "Users" and "Groups"
> >
> > You want a Foreign Key table to link them together (or what I call a linking
> > table) that might be named "UserGroups".
> >
> > But "UserGroups" as a table name itself does not stand out in the table list
> > because it does not use a prefixed naming convention (something I like about
> > Fusebox on the web side).
> >
> > Examples table names might be:   "LT_Users_Groups" or "FK_Users_Groups".
> >
> > Is there an understood standard there?  Also, the order of the table names
> > might need to be taken into account based on where the foreign keys are.
> >
> > Thoughts?
> >
> >
> > John McKown
> >
> >
> >
> >
> >
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237783
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

OT: Mysql outer join with conditions syntax

[Deanna Schneider]

Hey folks,
I'm trying to convert a project from Oracle to Mysql 5, and I have a
question about outer join syntax in mysql. In oracle, I can do something
like the below to tell Oracle that on the outer joined table, if there's a
value, I want it to be X. On mySql, all I've been able to figure out is the
second syntax (which works, I think). Is that the preferred method?


ORACLE, NON-STANDARDS COMPLIANT CODE
FROMfscd_client c, fscd_county x, fscd_state s, fscd_survey u, fscd_post
p
WHEREc.countyid = x.countyid
ANDx.stateid = s.stateid
ANDc.clientid = u.clientid (+)
ANDc.clientid = p.clientid (+)
AND c.active = 1
ANDp.active (+) = 1
ANDu.active (+) =  1  

MYSQL VERSION
FROM  (fscd_county x JOIN fscd_client c ON (x.countyid = c.countyid)
  JOIN fscd_state s on (s.stateid = x.stateid))
  LEFT OUTER JOIN fscd_survey u ON c.clientid = u.clientid
  LEFT OUTER JOIN fscd_post p ON c.clientid = p.clientid
WHERE  x.active = 1
ANDc.active = 1
AND(p.active = 1 OR p.active is null)
AND(u.active = 1 OR u.active is null) 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237782
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to determine JDBC driver version in use

[S . Isaac Dealey]

> By the way, this was fortuitous, because I found that
> 2.0.11 beats the snot out of 3.1.10 for my application.
> The "new" driver takes 50ms PER VARCHAR FIELD to retrieve
> one row of data, whereas the old one performs as I would
> expect, and executes my queries TEN TIMES faster.

Wow. Maybe you should do some googling to see if there are any known
bugs with that driver that might cause that.


s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237781
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: disk size manager

[Nathan Strutz]

Still, that would be a huge pain to do a cfdirectory then count all the
filesizes. yuck! Time consuming, too.

What you need is the ability to get into the underlying OS, which probably
already knows the amount of space you are taking, and have left.

Here, I made a little command-line app for you, it runs on .NET 2.0
http://www.dopefly.com/junk/DriveSizeAvailable.zip
I'ts really fast, takes one parameter, the drive letter, and spits out the
drive space available on the given drive. I made it in 5 minutes, so YMMV,
but it worked for me, even on network drives :)  Oh, .NET 2.0 can be found
via windows update. Windows only (unless you can get it to work on mono)

-nathan strutz
http://www.dopefly.com/


On 4/14/06, Andy Matthews <[EMAIL PROTECTED]> wrote:
>
> ColdFusion 7 has recursion built into cfdirectory I believe. At least I
> think Dave Watts said something along those lines a week or two back.
>
>  andy matthews
> web developer
> ICGLink, Inc.
> [EMAIL PROTECTED]
> 615.370.1530 x737
> --//->
>
> -Original Message-
> From: Turetsky, Seth [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 14, 2006 8:52 AM
> To: CF-Talk
> Subject: disk size manager
>
>
> We just ran out of disk space on a webserver and finding the culprit
> folder
> is tough.  Since, we don't have direct access to some drives, it would be
> nice to have this running under CF since it can access everything :)
> We wrote a simple file explorer in CF to browse and delete files, but I'd
> like to have it auto-recurse through all of the folders and subfolders
> reporting back large ones.  Is there such an app already in CF?
>
> -seth
>
>
> 
> ==
> Please access the attached hyperlink for an important electronic
> communications disclaimer:
>
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
>
> 
> ==
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237780
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: disk size manager

[Turetsky, Seth]

Andy/Jacob
Very handy, but I'm using BlueDragon.  Tried it out of curiosity, but it just 
listed the current directory.
Will inquire with NewAtlanta about it.

Thanks this would save time.

-Original Message-
From: Munson, Jacob [mailto:[EMAIL PROTECTED]
Sent: Friday, April 14, 2006 1:06 PM
To: CF-Talk
Subject: RE: disk size manager


> ColdFusion 7 has recursion built into cfdirectory I believe.

You are correct:
http://coldfusioncookbook.com/entry/79/How-do-I-find-the-size-of-a-direc
tory?

(I just noticed that the cfcookbook as questionmarks in the URLs...weird
(as punctuation, not a url param).  That seems dangerous.)





[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237779
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: database linking table naming conventions?

[Ryan Guill]

Personally, I always make the primary key of a single table,
tablenameID, so if its a user table, the primary key is userID.  If
userid is used as a foreign key anywhere else in my database, its
called userID.  A better way to put it is, if I have the same
columnname in two tables, its a foreign key.  And usually the ID at
the end of any column can tip you off to that fact.

But thats just me personally.

On 4/14/06, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> :OS <--<< that's me turning up my nose to the LT_ and FK_!
>
> I prefer UsersToGroups for your example.
>
> -Original Message-
> From: John McKown [mailto:[EMAIL PROTECTED]
> Sent: 14 April 2006 14:05
> To: CF-Talk
> Subject: database linking table naming conventions?
>
>
> Imagine these two database tables: "Users" and "Groups"
>
> You want a Foreign Key table to link them together (or what I call a linking
> table) that might be named "UserGroups".
>
> But "UserGroups" as a table name itself does not stand out in the table list
> because it does not use a prefixed naming convention (something I like about
> Fusebox on the web side).
>
> Examples table names might be:   "LT_Users_Groups" or "FK_Users_Groups".
>
> Is there an understood standard there?  Also, the order of the table names
> might need to be taken into account based on where the foreign keys are.
>
> Thoughts?
>
>
> John McKown
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:23
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: TextArea for multi inputs

[S . Isaac Dealey]

Of course then if you need to pre-populate the textarea, you need to
use the same sort of strategy:

#ValueList(myQuery.column,chr(13) & chr(10))#

-- you may find that you only need one or the other character when
embedding those values in the html due to the browser's handling of
line breaks. This is an edge case for me, so I can't give you loads of
info about it.

> When processing, just treat the form value as a list with
> chr(13) and
> chr(10) as its delimiters.

>  '#chr(13)##chr(10)#' ) />

> On 4/14/06, j s <[EMAIL PROTECTED]> wrote:
>> Does anyone know how to use a textarea as a multi input
>> field?  F.e. I'v seen a form which uses a textarea to
>> insert mulitple email addresses each separated by the
>> carriage return.


s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237778
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Using CFFTP Via SSH

[Damien McKenna]

> -Original Message-
> From: [EMAIL PROTECTED] 
> Sent: Friday, April 14, 2006 10:48 AM
> 
> Mike Traher recently posted a cfc to his blog which may be what you're
> looking for.

/me tips his hat to Kola and Mike.
Perfect.

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237766
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: disk size manager

[Munson, Jacob]

> ColdFusion 7 has recursion built into cfdirectory I believe.

You are correct:
http://coldfusioncookbook.com/entry/79/How-do-I-find-the-size-of-a-direc
tory?

(I just noticed that the cfcookbook as questionmarks in the URLs...weird
(as punctuation, not a url param).  That seems dangerous.)





[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237775
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: 19 >= 19 - query error

[Rick Root]

Dan G. Switzer, II wrote:
> 
> The error may be because you've used an ambigious column name of "id". Try:
> 
>   where A.id =  />

That's interesting because the query worked exactly as it was until I 
started dropping other columns.  "Id" only exists in the dbo.results 
table so this usually works.

I did solve the problem by specifying columns in my select list rather 
than using A.* ... still have the "ambiguous" id field in the where clause.

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237776
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: database linking table naming conventions?

[Munson, Jacob]

I'm confused.  You're worried about the name of the table and the order
of the table names in your DB?  This is a problem I've never heard of.
DBAs just name things what they want, and I've never heard of table
names causing problems except for cases like reserved words and special
characters in the name.  Or am I misunderstanding your question?

> -Original Message-
> From: John McKown [mailto:[EMAIL PROTECTED] 
> Sent: Friday, April 14, 2006 7:05 AM
> 
> Imagine these two database tables: "Users" and "Groups"
> 
> You want a Foreign Key table to link them together (or what I 
> call a linking
> table) that might be named "UserGroups".   
> 
> But "UserGroups" as a table name itself does not stand out in 
> the table list
> because it does not use a prefixed naming convention 
> (something I like about
> Fusebox on the web side).   
> 
> Examples table names might be:   "LT_Users_Groups" or 
> "FK_Users_Groups".
> 
> Is there an understood standard there?  Also, the order of 
> the table names
> might need to be taken into account based on where the 
> foreign keys are.


[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237773
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: 19 >= 19 - query error

[S . Isaac Dealey]

You may also eliminate this problem by changing the "max pooled
statements" value in your DSN to 0. I'm not certain of that, but I
know that the pooled statements are a form of SQL syntax caching and
that for most applications they're not very effective in improving
performance, so unlike disabling the "maintain client connections"
feature there's not much to lose. I have some recollection of having
the same sort of issues myself (change db structure outside cf, get
error from unchanged and still valid select statement in cf) and being
able to eliminate them that way.

> This bug usually happens when you change something on the
> database
> server when you are using a prepared statement
> (cfqueryparam).  The
> workarounds I can recommend are
> 1. Disable "maintain client connections" in the cf admin -
> less desirable
> 2. Change the query ever so slightly.  I usually add an
> extra where
> clause : "AND 1=1" which has no performance penalty but
> makes the
> prepared statement recompile


> On 4/14/06, Rick Root <[EMAIL PROTECTED]> wrote:
>> what the heck is this?
>>
>> 19 >= 19
>>
>>
>> The error occurred in
>> E:\Inetpub\wwwroot\tools\email_responses\respond.cfm:
>> line 20
>>
>> 18 :A.*, B.name as PRMLNAME
>> 19 :   FROM dbo.results A left join dbo.results2 b on
>> a.fromAddress=b.email
>> 20 :   where id=> value="#id#">
>> 21 : 
>> 22 : 
>>
>>
>> It's worth noting that there are 18 columns in the table.
>> I dropped
>> another column and ran the query again and I got "18 >=
>> 18" (now there
>> are only 17 columns)
>>
>> here's the full query:
>>
>>SELECT
>> A.*, B.name as PRMLNAME
>>FROM dbo.results A left join dbo.results2 b on
>>a.fromAddress=b.email
>>where id=>value="#id#">
>>
>> Rick
>>
>>

> ~~
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237772
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: TextArea for multi inputs

[Coldfusion]

Same concept, one TEXTAREA field and on the action page, just parse the
Results as a list type field using the carriage return as the delimiter. 

-Original Message-
From: j s [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 14, 2006 11:44 AM
To: CF-Talk
Subject: TextArea for multi inputs

Does anyone know how to use a textarea as a multi input field?  F.e. I'v
seen a form which uses a textarea to insert mulitple email addresses each
separated by the carriage return.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237768
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: TextArea for multi inputs

[Andy Matthews]

You can put whatever you like into a textarea field. If you put multiple
email address in there, seperated by a comma say. Then all you need to do is
to loop over the contents of that field to perform multiple inserts when
you're processing the form.



-Original Message-
From: j s [mailto:[EMAIL PROTECTED]
Sent: Friday, April 14, 2006 10:44 AM
To: CF-Talk
Subject: TextArea for multi inputs


Does anyone know how to use a textarea as a multi input field?  F.e. I'v
seen a form which uses a textarea to insert mulitple email addresses each
separated by the carriage return.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237765
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: StructFindKey Path and evaluate

[S . Isaac Dealey]

> Hi all


> I have a structure I am using StructFindKey with.

> Which returns an array/Structure.

> One of keys returned is Path, which is a dot separated
> list of the path thru
> the structure to the key your looking for.

> Something like:  MyStruc.item1.item2.item3.item4 (find key
> Item4), returns
> item1.item2.item3.item4

> I tried:  NewPath = 'MyStruc' & Path (with and without
> using evaluate)
> couldn't get it to work.
> I did get this to work:
>   did a replace to make path =
>   ['item1']['item2']['item3'['item4']
>   NewPath = 'MyStruc' & path

> #Evaluate(NewPath & '.lastitem')#

> Is there anyway to get this to work with out using
> Evaluate?

> Hope I explained this well enough?

Yes, but in this case evaluate might actually be faster.


temp = Mystruc;
aPath = listToArray(path);
arrayDeleteAt(aPath,1);
while (arrayLen(aPath)) {
temp = temp[aPath[1]];
arrayDeleteAt(aPath,1);
}

#temp.lastitem#

You could encapsulate that into a function, which would make it less
efficient but gain you loads of maintainability (imo that's
important).

I've used this strategy for getting nested values before, but not for
the sake of efficiency -- in my case I've done this when I didn't know
what the names of keys might be, so this allows the storage of keys
that begin with numbers or are for some other reason invalid variable
names which would produce an error with the isDefined() function. If
you know that all your structure keys begin with alpha characters,
don't contain hyphens, etc. then it is probably more mechanically
efficient in this case to use the single evaluate() than to use the
loop and indeterminate number of array management statements.

s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237770
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: disk size manager

[Nathan Strutz]

Hah, I totally misunderstood the original post. Fun times.
So yeah, CF7 has recursive cfdirectory. If you're on 6, you can probably
find a function on cflib to recurse through a directory. Just modify it to
delete everything it finds :)

-nathan strutz
http://www.dopefly.com/


On 4/14/06, Nathan Strutz <[EMAIL PROTECTED]> wrote:
>
> Still, that would be a huge pain to do a cfdirectory then count all the
> filesizes. yuck! Time consuming, too.
>
> What you need is the ability to get into the underlying OS, which probably
> already knows the amount of space you are taking, and have left.
>
> Here, I made a little command-line app for you, it runs on .NET 2.0
> http://www.dopefly.com/junk/DriveSizeAvailable.zip
> I'ts really fast, takes one parameter, the drive letter, and spits out the
> drive space available on the given drive. I made it in 5 minutes, so YMMV,
> but it worked for me, even on network drives :)  Oh, .NET 2.0 can be found
> via windows update. Windows only (unless you can get it to work on mono)
>
> -nathan strutz
> http://www.dopefly.com/
>
>
>
> On 4/14/06, Andy Matthews <[EMAIL PROTECTED]> wrote:
> >
> > ColdFusion 7 has recursion built into cfdirectory I believe. At least I
> > think Dave Watts said something along those lines a week or two back.
> >
> >  > andy matthews
> > web developer
> > ICGLink, Inc.
> > [EMAIL PROTECTED]
> > 615.370.1530 x737
> > --//->
> >
> > -Original Message-
> > From: Turetsky, Seth [mailto: [EMAIL PROTECTED]
> > Sent: Friday, April 14, 2006 8:52 AM
> > To: CF-Talk
> > Subject: disk size manager
> >
> >
> > We just ran out of disk space on a webserver and finding the culprit
> > folder
> > is tough.  Since, we don't have direct access to some drives, it would
> > be
> > nice to have this running under CF since it can access everything :)
> > We wrote a simple file explorer in CF to browse and delete files, but
> > I'd
> > like to have it auto-recurse through all of the folders and subfolders
> > reporting back large ones.  Is there such an app already in CF?
> >
> > -seth
> >
> >
> > 
> > ==
> > Please access the attached hyperlink for an important electronic
> > communications disclaimer:
> >
> > http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
> > 
> >
> > ==
> >
> >
> >
> >
> > 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237771
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: database linking table naming conventions?

[Adrian Lynch]

:OS <--<< that's me turning up my nose to the LT_ and FK_!

I prefer UsersToGroups for your example.

-Original Message-
From: John McKown [mailto:[EMAIL PROTECTED]
Sent: 14 April 2006 14:05
To: CF-Talk
Subject: database linking table naming conventions?


Imagine these two database tables: "Users" and "Groups"

You want a Foreign Key table to link them together (or what I call a linking
table) that might be named "UserGroups".

But "UserGroups" as a table name itself does not stand out in the table list
because it does not use a prefixed naming convention (something I like about
Fusebox on the web side).

Examples table names might be:   "LT_Users_Groups" or "FK_Users_Groups".

Is there an understood standard there?  Also, the order of the table names
might need to be taken into account based on where the foreign keys are.

Thoughts?


John McKown




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237774
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: insert a list into database

[S . Isaac Dealey]

I don't think that will work with an insert statement. The standard
for SQL insists on one value per column for inserts and updates. It's
only IN and NOT IN constructs in where clauses where comma separated
lists are allowed. In an insert statement with only one column in the
table, a comma in the values list should produce a "too many values"
or "number of values does not match number of columns" error message.

> John,

> You also don't need the loop. Just add list="yes" inside
> your cfqueryparam.

> Dina


> On 4/14/06, john holmes <[EMAIL PROTECTED]> wrote:
>>
>> That surely was it, thank you.
>>
>> Jerry Johnson <[EMAIL PROTECTED]> wrote: In an insert
>> statement, you don't
>> need the "tml_list =" in the values set.
>>
>> INSERT into tbl
>> (field_list)
>> VALUES
>> (valuelist)
>>
>> so in your example
>> INSERT INTOList_prac
>> (tbl_list)
>> VALUES
>> ()
>>
>>
>> On 4/14/06, john holmes  wrote:
>> > Hi,
>> > I have an list that I need to insert into a mysql
>> > database and I am not
>> quite sure how to do it. Right now I take the list
>> variable
>> "#thiswillbemylist#" and if I run a cfloop list to insert
>> it but it just
>> gets a null value in database.
>> >
>> > The part of query to insert is this:
>> >
>> >
>> >
>> > INSERT INTOList_prac (tbl_list)
>> > VALUES (tbl_list = )
>> >
>> >
>> >
>> >
>> > Can someone help?
>> > Thanks
>> > John
>> >
>> >
>> >
>> > -
>> > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone
>> > calls.  Great
>> rates starting at 1�/min.
>> >
>> >
>>
>>
>>
>>

> ~~
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237764
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: TextArea for multi inputs

[Jordan Michaels]

j s wrote:
> Does anyone know how to use a textarea as a multi input field?  F.e. I'v seen 
> a form which uses a textarea to insert mulitple email addresses each 
> separated by the carriage return.
> 

On your processing page, you can use something like the following:



#i#



Hope that helps!

-- 
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
Blue Dragon Alliance Member
[EMAIL PROTECTED]

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237769
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: TextArea for multi inputs

[Rob Wilkerson]

When processing, just treat the form value as a list with chr(13) and
chr(10) as its delimiters.



On 4/14/06, j s <[EMAIL PROTECTED]> wrote:
> Does anyone know how to use a textarea as a multi input field?  F.e. I'v seen 
> a form which uses a textarea to insert mulitple email addresses each 
> separated by the carriage return.
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237767
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: TextArea for multi inputs

[Everett, Al \(NIH/NIGMS\) [C]]

Just treat the resulting form.variable as a list using CHR(13) and
CHR(10) as delimiters.

-Original Message-
From: j s [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 14, 2006 11:44 AM
To: CF-Talk
Subject: TextArea for multi inputs

Does anyone know how to use a textarea as a multi input field?  F.e. I'v
seen a form which uses a textarea to insert mulitple email addresses
each separated by the carriage return.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237763
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

database linking table naming conventions?

[John McKown]

Imagine these two database tables: "Users" and "Groups"

You want a Foreign Key table to link them together (or what I call a linking
table) that might be named "UserGroups".   

But "UserGroups" as a table name itself does not stand out in the table list
because it does not use a prefixed naming convention (something I like about
Fusebox on the web side).   

Examples table names might be:   "LT_Users_Groups" or "FK_Users_Groups".

Is there an understood standard there?  Also, the order of the table names
might need to be taken into account based on where the foreign keys are.

Thoughts?


John McKown


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237762
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

TextArea for multi inputs

[j s]

Does anyone know how to use a textarea as a multi input field?  F.e. I'v seen a 
form which uses a textarea to insert mulitple email addresses each separated by 
the carriage return.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237761
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: 19 >= 19 - query error

[Adam Howitt]

This bug usually happens when you change something on the database
server when you are using a prepared statement (cfqueryparam).  The
workarounds I can recommend are
1. Disable "maintain client connections" in the cf admin - less desirable
2. Change the query ever so slightly.  I usually add an extra where
clause : "AND 1=1" which has no performance penalty but makes the
prepared statement recompile


On 4/14/06, Rick Root <[EMAIL PROTECTED]> wrote:
> what the heck is this?
>
> 19 >= 19
>
>
> The error occurred in
> E:\Inetpub\wwwroot\tools\email_responses\respond.cfm: line 20
>
> 18 :A.*, B.name as PRMLNAME
> 19 :   FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
> 20 :   where id=
> 21 : 
> 22 : 
>
>
> It's worth noting that there are 18 columns in the table.  I dropped
> another column and ran the query again and I got "18 >= 18" (now there
> are only 17 columns)
>
> here's the full query:
>
>SELECT
> A.*, B.name as PRMLNAME
>FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
>where id=
>
> Rick
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237760
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to determine JDBC driver version in use

[Jamie Jackson]

Thanks for the reply, and thanks for the documentation link.

I've got some new news, so I'll add some inline comments to my own post, for 
posterity.
 
> What I get is:
> DriverVersion   2.0.11
> NameMark Matthews' MySQL Driver
> 
> If this is true, it stuns me in several ways:

It is true. My function is reliable, the datasource was using the stock CFMX 
6.1 JDBC driver.

> 1. I thought that version 3.1.8 was installed.

I was wrong about this datasource, it was using the stock driver.

> 2. I suspect that the reported driver is the CFMX 6.1 "native" MySQL 
> driver. :-O

I still think this is the case

> 3. The datasource WORKS with our 5.x databases, which I *think* isn't 
> supposed to be true of the native drivers (due to authentication 
> protocols, among potential others).

We must have run the OLD_PASSWORD routine on our MySQL 5 machines to make it 
backward compatible with old clients.

By the way, this was fortuitous, because I found that 2.0.11 beats the snot out 
of 3.1.10 for my application. The "new" driver takes 50ms PER VARCHAR FIELD to 
retrieve one row of data, whereas the old one performs as I would expect, and 
executes my queries TEN TIMES faster.

Thanks,
Jamie

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237759
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: insert a list into database

[Dina Hess]

John,

You also don't need the loop. Just add list="yes" inside your cfqueryparam.

Dina


On 4/14/06, john holmes <[EMAIL PROTECTED]> wrote:
>
> That surely was it, thank you.
>
> Jerry Johnson <[EMAIL PROTECTED]> wrote: In an insert statement, you don't
> need the "tml_list =" in the values set.
>
> INSERT into tbl
> (field_list)
> VALUES
> (valuelist)
>
> so in your example
> INSERT INTOList_prac
> (tbl_list)
> VALUES
> ()
>
>
> On 4/14/06, john holmes  wrote:
> > Hi,
> > I have an list that I need to insert into a mysql database and I am not
> quite sure how to do it. Right now I take the list variable
> "#thiswillbemylist#" and if I run a cfloop list to insert it but it just
> gets a null value in database.
> >
> > The part of query to insert is this:
> >
> >
> >
> > INSERT INTOList_prac (tbl_list)
> > VALUES (tbl_list = )
> >
> >
> >
> >
> > Can someone help?
> > Thanks
> > John
> >
> >
> >
> > -
> > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great
> rates starting at 1�/min.
> >
> >
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237758
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: DailyRazor Hosting

[Jordan Michaels]

DURETTE, STEVEN J (ASI-AIT) wrote:
> Jordan,
> 
> Not to go into a lot of detail, but that's a steep price increase for my
> pocket book.  Your $19 to their $9.95 + 2.95 for every domain over 2.  I
> like the idea of all of the extras that you mentioned, but at this
> moment I simply can't afford that much right now.  I will definitely
> look at it when the situation changes.
> 
> FYI for others...  If someone breaks into your house and breaks into
> your safe to get pin numbers (and you don't notice because the safe is
> hidden), then they later steal your wallet and clean out your accounts
> using your atm cards, you will get the money back someday (maybe). You
> just get stuck with having to wait until the trial is over (with some
> insurance companies)!
> 
> Steve

Hi Steve,

Thanks for being willing to keep us in mind. One thing that it's
important to note here is that there is a huge difference between VPS
Accounts (Vivio) and shared hosting accounts (like what DailyRazor and
most other CF hosts offer).

With shared hosting accounts, all accounts on a server share all the
same resources - like RAM, CPU cycles, etc. If you get one site on the
shared server that uses a lot of memory, that will slow your site down.
(Although I must admit that most hosts I've seen watch for this very
closely.) Next, shared hosts are generally more restrictive due to
security complications. For example, some hosts do not allow you to use
the  tag, or even more common tags like the CFFILE tag because
they would create security issues with other sites that are hosted on
the same server.

With VPS Accounts, none of these issues exist. A VPS Account acts and
feels just like a dedicated server. You have complete control over your
own server, and you have your own instance of your CF Administrator. In
addition, you can host all the sites you can possibly squeeze on to your
VPS. There's no nickel and dimeing for every domain your add to your
system. What's more, your system resources (like RAM and CPU cycles) are
yours, and yours alone. You don't have to share them with anyone else -
which means your sites will always have the resources they need to run
well. You can't say these things about shared hosting accounts.

With regards to price, Vivio Technologies prices are *extremely*
competitive when it comes to CFML-enabled VPS Accounts. I'd actually
encourage you to look around and test us. If you find someone who offers
the same or better then what we do (and has been around for any length
of time), let us know!

As a developer myself, I truly believe that VPS Accounts are the
absolute best solution for both development and deployment. In fact,
Vivio Technologies started out as a development company. If any web host
had been offering then what we offer now, Vivio would be a much
different company then it is now.

At any rate, enough horn blowing.=P Thanks again for keeping us in mind!

-- 
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
Blue Dragon Alliance Member
[EMAIL PROTECTED]

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237757
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

StructFindKey Path and evaluate

[Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions]

Hi all


I have a structure I am using StructFindKey with.

Which returns an array/Structure.

One of keys returned is Path, which is a dot separated list of the path thru
the structure to the key your looking for.

Something like:  MyStruc.item1.item2.item3.item4 (find key Item4), returns
item1.item2.item3.item4

I tried:  NewPath = 'MyStruc' & Path (with and without using evaluate)
couldn't get it to work.
I did get this to work: 
did a replace to make path = ['item1']['item2']['item3'['item4']
NewPath = 'MyStruc' & path

#Evaluate(NewPath & '.lastitem')#

Is there anyway to get this to work with out using Evaluate?

Hope I explained this well enough?

Thanks
Rodney


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237756
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: catching a query based cfmail ...

[Munson, Jacob]

And if you're on MX 7, you can use the isValid function with
type="email".

> -Original Message-
> From: Jose Diaz [mailto:[EMAIL PROTECTED] 
> Sent: Friday, April 14, 2006 1:37 AM
> 
> On cflib.org there is a function titled 'isEmail' I have used 
> this a few
> times to validate emails. The function code is a s follows:
> 
> 
> 
> function isEmail(str) {
> return 
> (REFindNoCase("^['_a-z0-9-]+(\.['_a-z0-9-]+)[EMAIL PROTECTED](\.[a-
> z0-9-]+)*\.(([a-z]{2,3})|(aero|coop|info|museum|name|jobs|trav
> el))$",arguments.str)
> AND len(listGetAt(arguments.str, 1, "@")) LTE 64 AND
> len(listGetAt(arguments.str, 2, "@")) LTE 255) IS 1;
> }
> 
> Another alternative if you are using sql server is to doa  sql
> function and wrap the email element in that for validation.
> 
> Hope this helps
> 
> On 4/14/06, Denny Valliant <[EMAIL PROTECTED]> wrote:
> >
> > A crazy option would be to use a regular expression 
> (available in MySQL)
> > to
> > grab only valid emails.
> >
> > Heh. With the regex stuff going  on, had to mention it.
> >
> > By the by, a useful resource for regex for me has been
> > www.regular-expressions.com.
> > :D3|\|*
> >
> > On 4/13/06, Dawson, Michael <[EMAIL PROTECTED]> wrote:
> > >
> > > I think you are totally correct.  You will need to do the 
> CFLOOP thing
> > > to be able to catch an individual CFMAIL exception.
> > >
> > > M!ke
> > >
> > > -Original Message-
> > > From: Rick Root [mailto:[EMAIL PROTECTED]
> > > Sent: Thursday, April 13, 2006 9:07 PM
> > >
> > > If I'm using cfmail with the query attribute, populating 
> the to address
> > > dynamically... how to I catch an individual exception?
> > >
> > > Like if one row in the query contains an invalid email 
> address that
> > > throws a cfmail exception.
> > >
> > > If i put try/catch around the whole cfmail tag set it'll 
> actually stop
> > > the whole mailing...
> > >
> > > I'm assuming there's no way to do what I want to do 
> without axing the
> > > query attribute and doing something like
> > >
> > > 
> > > 
> > >  subject="foo">
> > >   ...
> > > 
> > > 
> > > 
> > > 

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237755
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: 19 >= 19 - query error

[Dan G. Switzer, II]

Rick,

>what the heck is this?
>
>19 >= 19
>
>
>The error occurred in
>E:\Inetpub\wwwroot\tools\email_responses\respond.cfm: line 20
>
>18 :   A.*, B.name as PRMLNAME
>19 :   FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
>20 :   where id=
>21 : 
>22 : 

The error may be because you've used an ambigious column name of "id". Try:

where A.id = 

(I'm assuming the "id" column is in the results table.)

-Dan


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237754
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: 19 >= 19 - query error

[Adrian Lynch]

What happens if you remove the cfqueryparam and run it again?

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: 14 April 2006 16:51
To: CF-Talk
Subject: 19 >= 19 - query error


what the heck is this?

19 >= 19


The error occurred in 
E:\Inetpub\wwwroot\tools\email_responses\respond.cfm: line 20

18 :A.*, B.name as PRMLNAME
19 :   FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
20 :   where id=
21 : 
22 : 


It's worth noting that there are 18 columns in the table.  I dropped 
another column and ran the query again and I got "18 >= 18" (now there 
are only 17 columns)

here's the full query:

   SELECT
A.*, B.name as PRMLNAME
   FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
   where id=

Rick


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237753
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: disk size manager

[Andy Matthews]

ColdFusion 7 has recursion built into cfdirectory I believe. At least I
think Dave Watts said something along those lines a week or two back.



-Original Message-
From: Turetsky, Seth [mailto:[EMAIL PROTECTED]
Sent: Friday, April 14, 2006 8:52 AM
To: CF-Talk
Subject: disk size manager


We just ran out of disk space on a webserver and finding the culprit folder
is tough.  Since, we don't have direct access to some drives, it would be
nice to have this running under CF since it can access everything :)
We wrote a simple file explorer in CF to browse and delete files, but I'd
like to have it auto-recurse through all of the folders and subfolders
reporting back large ones.  Is there such an app already in CF?

-seth


==
Please access the attached hyperlink for an important electronic
communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

==




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237752
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

19 >= 19 - query error

[Rick Root]

what the heck is this?

19 >= 19


The error occurred in 
E:\Inetpub\wwwroot\tools\email_responses\respond.cfm: line 20

18 :A.*, B.name as PRMLNAME
19 :   FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
20 :   where id=
21 : 
22 : 


It's worth noting that there are 18 columns in the table.  I dropped 
another column and ran the query again and I got "18 >= 18" (now there 
are only 17 columns)

here's the full query:

   SELECT
A.*, B.name as PRMLNAME
   FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
   where id=

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237751
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Set Variable on window close

[Patrick Forsythe]

<<< No Message Collected >>>

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237750
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Problem with Java object calls

[kola.oyedeji]

Is this code in a cfc cached in a shared scope?

How do you know it's the same instance? Also do you have a static method you
are calling?

K

> -Original Message-
> From: Andrew Dixon [mailto:[EMAIL PROTECTED]
> Sent: 11 April 2006 15:56
> To: CF-Talk
> Subject: Problem with Java object calls
> 
> Hi.
> 
> I having a problem with a Java object call. It appears that the CF server
> does not create the objects exclusively when more than one instance of the
> same script is running. I have created a java class to do multi-threaded
XML
> post to a web service. The java class works fine and everything is great
if
> you only call the script once. If you call it more that once at the same
> time it appears that a new instance is the same as the other instance.
Here
> is a code segment of how I'm creating the object.
> 
> 
> obj_PostXML = CreateObject('java', 'MultiThreadedXMLPost').init();
> obj_PostXML.executePost(arr_Arguments);
> while(obj_PostXML.completedCount LT 2) {}
> str_output = obj_PostXML.theData;
> 
> 
> 
> Is there anyway to make it exclusive?
> 
> Kind regards,
> 
> Andrew.
> 
> 
> ~
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237749
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cffile and names with spaces

[Adrian Lynch]

Do you have a test page for this? I'd like to see if there's something
causing the change of spaces.

Adrian

-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: 13 April 2006 17:32
To: CF-Talk
Subject: Re: cffile and names with spaces


I was surprised too. I have never seen this before, either.

CDC%20logo%20RGB.jpg

As an example pulled of the drive this morning.

Can I really change the form.field variable, and have the file still upload?


On 4/13/06, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> Can't say I've ever seen spaces replaced with %20 in the file names on
disk
> before. Are you sure they're being renamed that way?
>
> Adrian
>
> -Original Message-
> From: Jerry Johnson [mailto:[EMAIL PROTECTED]
> Sent: 13 April 2006 16:40
> To: CF-Talk
> Subject: cffile and names with spaces
>
>
> I have a simple form to upload an image.
>
> I use cffile to upload the file.
> I then use cffile.serverfile to get the name of the uploaded file
>
> If the user uploads a file called "space.gif", all is well.
> If the user uploads a file called "space station.gif", not so much.
>
> The file saved to disk is "space%20station.gif"
> The value in serverfile is "space station.gif"


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237748
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Auction Software.

[kola.oyedeji]

+1  Admittedly it was long time since I used it so it may have changed but
when I used it there was a lot of duplicated code all over the place

> -Original Message-
> From: Mark A Kruger [mailto:[EMAIL PROTECTED]
> Sent: 13 April 2006 20:43
> To: CF-Talk
> Subject: RE: Auction Software.
> 
> Run away from that Able option... Very bad indeed. We have some extensive
> experience with it... None of it pleasant :)
> 
> -Original Message-
> From: Jose Diaz [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 13, 2006 1:45 PM
> To: CF-Talk
> Subject: Re: Auction Software.
> 
> Hi Emmet
> 
> Steve is correct Able do produce a auction tool that was freeware a while
> back, Im not sure what the charge is now, but I imagine it has a 30 day
> trial period so worth a go.
> 
> Have you tryed the cf developers exchange ?
> 
> 
> Jose Diaz
> 
> 
> On 4/13/06, Steve Kahn <[EMAIL PROTECTED]> wrote:
> >
> > Emmet
> >
> > Visual Auction (beyond software)
> > Able Commerce had one but I think it was discontinued.
> > There is one more less expensive option available but I don't have it
> > on hand.
> >
> > Steve
> >
> > -Original Message-
> > From: Emmet McGovern [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, April 13, 2006 2:06 PM
> > To: CF-Talk
> > Subject: Auction Software.
> >
> > We've agreed to donate our time to a childrens hospital charity and
> > one of the things they will need is the ability to run an online
> > auction over the course of the summer.  Nothing fancy.  They will end
the
> auction manually.
> >
> > Does anyone know if something like this is available in cf or would
> > someone like to share some code?  :)
> >
> > Emmet
> >
> >
> >
> >
> >
> >
> 
> 
> 
> ~
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237747
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Using CFFTP Via SSH

[kola.oyedeji]

Mike Traher recently posted a cfc to his blog which may be what you're
looking for. He's looking for people to help test it and provide feedback:

http://www.socialpoints.com/blog/client/index.cfm/2006/3/25/coldfusion-sftp

HTH

Kola

> -Original Message-
> From: Billy Jamme [mailto:[EMAIL PROTECTED]
> Sent: 14 April 2006 04:54
> To: CF-Talk
> Subject: Re: Using CFFTP Via SSH
> 
> Hey Scott,
> I ran into this exact issue last week.
> 
> Check out:
> 
> http://www.glub.com/products/secureftp/
> 
> It's a java package that runs quite nicely in a command line.  As an added
bouns it
> has batch scripting.
> 
> The way I implemented it was to dynamically generate a batch file using
cffile, then
> using cfexecute to launch the .bat.  Total time to code: 45 mins.  Works
quite nicely
> for a cludge.
> 
> As it's a pure java app, I've also been tinkering with it to try and
integrate into CF.  If
> I ever figure it out, I'll post the code.
> 
> --ik
> 
> >We've got a requirement to use CFFTP via SSH (SFTP). Has anyone been able
to
> >do this?
> >
> >
> >
> >Thanks
> >
> >
> >
> >Scott
> >
> >
> >
> >Scott A. Stewart
> >
> >Webmaster/ Developer
> >
> >GlobalNet Services, Inc
> >
> >
> >
> >  http://www.gnsi.com
> >
> >11820 Parklawn Dr
> >
> >Rockville, MD 20852
> >
> >Voice: (301) 770-9610 x 335
> >
> >Fax: (301) 770-9611
> 
> ~
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237746
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

disk size manager

[Turetsky, Seth]

We just ran out of disk space on a webserver and finding the culprit folder is 
tough.  Since, we don't have direct access to some drives, it would be nice to 
have this running under CF since it can access everything :)
We wrote a simple file explorer in CF to browse and delete files, but I'd like 
to have it auto-recurse through all of the folders and subfolders reporting 
back large ones.  Is there such an app already in CF?

-seth

==
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237745
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: DailyRazor Hosting

[Coldfusion]

Try http://www.coldfusion-mx-hosting.com/ 

You can do 2 domains for $12/month or 
5 domains for $20/month.

Personally I have the next plan doing 10 
Domains for 35/month.

Plus they have MySQL / MS-SQL7 / MS-SQL2000
And access ODBCs, and depending on the plan
More subdomains than ever needed.

-Original Message-
From: DURETTE, STEVEN J (ASI-AIT) [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 13, 2006 10:47 AM
To: CF-Talk
Subject: RE: DailyRazor Hosting

Jordan,

Not to go into a lot of detail, but that's a steep price increase for my
pocket book.  Your $19 to their $9.95 + 2.95 for every domain over 2.  I
like the idea of all of the extras that you mentioned, but at this moment I
simply can't afford that much right now.  I will definitely look at it when
the situation changes.

FYI for others...  If someone breaks into your house and breaks into your
safe to get pin numbers (and you don't notice because the safe is hidden),
then they later steal your wallet and clean out your accounts using your atm
cards, you will get the money back someday (maybe). You just get stuck with
having to wait until the trial is over (with some insurance companies)!

Steve


-Original Message-
From: Jordan Michaels [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 6:46 PM
To: CF-Talk
Subject: Re: DailyRazor Hosting


Steve Durette wrote:
> Anyone have any thoughts on DailyRazor Hosting?
> 
> I need a host that will allow multiple domains.  I'm going to be doing
the websites for a couple of non-profit clubs so this is going to be all
out of my pocket.  What I really need is to host 3 websites (mine plus
the 2 clubs), and DailyRazor is the only one that I have seen that lets
you host multiple domains.  Only problem is that their plans jump from 2
domains to 8 domains with a difference in price of 2 domains for $120
per year and 8 domains at $215 per year.  The fact that they allow
unlimited e-mail addresses is nice (30 minimum required).
> 
> I know that there did used to be some places that hosted non-profits
for free, but I can't find them anymore.
> 
> I have looked through the recent messages and did research on the
hosting services that were listed, but so far DailyRazor has the most
for the least amount of money.  
> 
> Thanks for the help.
> Steve

Hi Steve,

How would you feel about a VPS Account? You can host all the domains you
want off of it and it only costs 19.95 per month. We offer BlueDragon
Server JX as a free add-on to our VPS Accounts so you can host CFML
sites on it as well. BlueDragon Server JX won't always be a free add-on,
as we're currently just trying to help the BlueDragon community grow,
but we're offering it free at the moment. ;)

In addition, we also offer free, no-obligation 7-day trials. So if you
just want to give us a shot and see how a VPS feels, you can do it
without any financial risk.

Hopefully this helps you, and feel free to let us know if you have any
questions alright?

-- 
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
Blue Dragon Alliance Member
[EMAIL PROTECTED]





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237744
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: IIF help

[Andy Matthews]

Rick...

It appears you've got quotes around your expression. Remove those and you
should be good.



-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, April 14, 2006 7:02 AM
To: CF-Talk
Subject: IIF help


I always have trouble using IIF...

Why doesn't this work?



It gives me this error:

Parameter validation error for function IIF.
The value of the parameter 1, which is currently "lcase(server.os.name)
contains 'windows'", must be a boolean value.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237743
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: IIF help

[Mingo Hagen]

iif(
lcase(server.os.name) contains 'windows',
de( "\" ),
de( "/" )
)

no quotes in the first argument.



-- 
Met vriendelijke groet / Kind regards

Mingo J. Hagen.
E-Line Websolutions B.V.Herenweg 160
2101 MT  Heemstede

phone: +31620 775444
fax: +3123 5471920
fax [mingo]: +3184 7594914
e-mail / msn: [EMAIL PROTECTED]
skype: mjhagen
icq: 4775556
url: www.e-line.ws



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237742
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: IIF help

[Douglas Knudsen]

try that, eh?

Also, no need for DE(), just use all teh quotes luke!  " ' foo ' " like that

DK

On 4/14/06, Rick Root <[EMAIL PROTECTED]> wrote:
> I always have trouble using IIF...
>
> Why doesn't this work?
>
>  'windows'",de("/"),de("\"))>
>
> It gives me this error:
>
> Parameter validation error for function IIF.
> The value of the parameter 1, which is currently "lcase(server.os.name)
> contains 'windows'", must be a boolean value.
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237741
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: IIF help

[Everett, Al \(NIH/NIGMS\) [C]]

Try this:

 


Al Everett (Contractor)
DIGICON Corporation
National Institute of General Medical Science
Information Resources Management Branch
[EMAIL PROTECTED]
301.594.4082

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 14, 2006 8:02 AM
To: CF-Talk
Subject: IIF help

I always have trouble using IIF...

Why doesn't this work?



It gives me this error:

Parameter validation error for function IIF.
The value of the parameter 1, which is currently "lcase(server.os.name)
contains 'windows'", must be a boolean value.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237740
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

IIF help

[Rick Root]

I always have trouble using IIF...

Why doesn't this work?



It gives me this error:

Parameter validation error for function IIF.
The value of the parameter 1, which is currently "lcase(server.os.name) 
contains 'windows'", must be a boolean value.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237739
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: DailyRazor Hosting

[DURETTE, STEVEN J \(ASI-AIT\)]

Jordan,

Not to go into a lot of detail, but that's a steep price increase for my
pocket book.  Your $19 to their $9.95 + 2.95 for every domain over 2.  I
like the idea of all of the extras that you mentioned, but at this
moment I simply can't afford that much right now.  I will definitely
look at it when the situation changes.

FYI for others...  If someone breaks into your house and breaks into
your safe to get pin numbers (and you don't notice because the safe is
hidden), then they later steal your wallet and clean out your accounts
using your atm cards, you will get the money back someday (maybe). You
just get stuck with having to wait until the trial is over (with some
insurance companies)!

Steve


-Original Message-
From: Jordan Michaels [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 11, 2006 6:46 PM
To: CF-Talk
Subject: Re: DailyRazor Hosting


Steve Durette wrote:
> Anyone have any thoughts on DailyRazor Hosting?
> 
> I need a host that will allow multiple domains.  I'm going to be doing
the websites for a couple of non-profit clubs so this is going to be all
out of my pocket.  What I really need is to host 3 websites (mine plus
the 2 clubs), and DailyRazor is the only one that I have seen that lets
you host multiple domains.  Only problem is that their plans jump from 2
domains to 8 domains with a difference in price of 2 domains for $120
per year and 8 domains at $215 per year.  The fact that they allow
unlimited e-mail addresses is nice (30 minimum required).
> 
> I know that there did used to be some places that hosted non-profits
for free, but I can't find them anymore.
> 
> I have looked through the recent messages and did research on the
hosting services that were listed, but so far DailyRazor has the most
for the least amount of money.  
> 
> Thanks for the help.
> Steve

Hi Steve,

How would you feel about a VPS Account? You can host all the domains you
want off of it and it only costs 19.95 per month. We offer BlueDragon
Server JX as a free add-on to our VPS Accounts so you can host CFML
sites on it as well. BlueDragon Server JX won't always be a free add-on,
as we're currently just trying to help the BlueDragon community grow,
but we're offering it free at the moment. ;)

In addition, we also offer free, no-obligation 7-day trials. So if you
just want to give us a shot and see how a VPS feels, you can do it
without any financial risk.

Hopefully this helps you, and feel free to let us know if you have any
questions alright?

-- 
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
Blue Dragon Alliance Member
[EMAIL PROTECTED]



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237738
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cffile and names with spaces

[Jerry Johnson]

I was surprised too. I have never seen this before, either.

CDC%20logo%20RGB.jpg

As an example pulled of the drive this morning.

Can I really change the form.field variable, and have the file still upload?


On 4/13/06, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> Can't say I've ever seen spaces replaced with %20 in the file names on disk
> before. Are you sure they're being renamed that way?
>
> Adrian
>
> -Original Message-
> From: Jerry Johnson [mailto:[EMAIL PROTECTED]
> Sent: 13 April 2006 16:40
> To: CF-Talk
> Subject: cffile and names with spaces
>
>
> I have a simple form to upload an image.
>
> I use cffile to upload the file.
> I then use cffile.serverfile to get the name of the uploaded file
>
> If the user uploads a file called "space.gif", all is well.
> If the user uploads a file called "space station.gif", not so much.
>
> The file saved to disk is "space%20station.gif"
> The value in serverfile is "space station.gif"

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237737
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFChart Format= Flash Veritical Value

[Peter J . Farrell]

>Hi Peter,
>
>Thank you very much for your reply.  That is great idea about the horizontal 
>bar.  I will take a look at that tomorrow (or later today) to see if that 
>works.  Yes we too are starting to use cfchart heavily too.  We are getting 
>requests for dashboards of all types of data.  We are using a  flash form 
>grids and flash charts to provide the data.
>
>Thank you again for your suggestion and confirming that we can't rotate the 
>data label element by 90 degrees.

David,

Glad to be of help.  Hopefully you'll be able to get everything you want with 
cfchart.  Don't forget that you can use the java classes to do things that 
cfchart won't do for you.

http://www.flfo.net/charts/doc/overview-summary.html
http://wiggy.coldfusionjournal.com/coldfusion_tip_using_the_included_webcharts3d_engine_in_cfmx.htm

I actually had create charts that cfchart won't do for a client.  Here's an 
example that Matt and I talked about on the ColdFusion Weekly podcast:
http://www.coldfusionweekly.com/images/1-2/cfw_1-2_charting_example.png

So it's all possible.  Good luck and you can ping me at this email address if 
you run into any big problems (I don't monitor the HoF list very closely).

Best,
...Peter
MaePub

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237736
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: catching a query based cfmail ...

[Jose Diaz]

Hi Rick

On cflib.org there is a function titled 'isEmail' I have used this a few
times to validate emails. The function code is a s follows:



function isEmail(str) {
return (REFindNoCase("^['_a-z0-9-]+(\.['_a-z0-9-]+)[EMAIL 
PROTECTED](\.[a-z0-9-]+)*\.(([a-z]{2,3})|(aero|coop|info|museum|name|jobs|travel))$",arguments.str)
AND len(listGetAt(arguments.str, 1, "@")) LTE 64 AND
len(listGetAt(arguments.str, 2, "@")) LTE 255) IS 1;
}

Another alternative if you are using sql server is to doa  sql
function and wrap the email element in that for validation.

Hope this helps

Jose Diaz




On 4/14/06, Denny Valliant <[EMAIL PROTECTED]> wrote:
>
> A crazy option would be to use a regular expression (available in MySQL)
> to
> grab only valid emails.
>
> Heh. With the regex stuff going  on, had to mention it.
>
> By the by, a useful resource for regex for me has been
> www.regular-expressions.com.
> :D3|\|*
>
> On 4/13/06, Dawson, Michael <[EMAIL PROTECTED]> wrote:
> >
> > I think you are totally correct.  You will need to do the CFLOOP thing
> > to be able to catch an individual CFMAIL exception.
> >
> > M!ke
> >
> > -Original Message-
> > From: Rick Root [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, April 13, 2006 9:07 PM
> > To: CF-Talk
> > Subject: catching a query based cfmail ...
> >
> > If I'm using cfmail with the query attribute, populating the to address
> > dynamically... how to I catch an individual exception?
> >
> > Like if one row in the query contains an invalid email address that
> > throws a cfmail exception.
> >
> > If i put try/catch around the whole cfmail tag set it'll actually stop
> > the whole mailing...
> >
> > I'm assuming there's no way to do what I want to do without axing the
> > query attribute and doing something like
> >
> > 
> > 
> > 
> >   ...
> > 
> > 
> > 
> > 
> >
> >
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237735
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: insert a list into database

[john holmes]

That surely was it, thank you.

Jerry Johnson <[EMAIL PROTECTED]> wrote: In an insert statement, you don't need 
the "tml_list =" in the values set.

INSERT into tbl
(field_list)
VALUES
(valuelist)

so in your example
INSERT INTOList_prac
(tbl_list)
VALUES
()


On 4/14/06, john holmes  wrote:
> Hi,
> I have an list that I need to insert into a mysql database and I am not quite 
> sure how to do it. Right now I take the list variable "#thiswillbemylist#" 
> and if I run a cfloop list to insert it but it just gets a null value in 
> database.
>
> The part of query to insert is this:
>
> 
> 
> INSERT INTOList_prac (tbl_list)
> VALUES (tbl_list = )
> 
>  
>
>
> Can someone help?
> Thanks
> John
>
>
>
> -
> Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great rates 
> starting at 1�/min.
>
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237734
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54