Re: upload destination

2008-09-19 Thread Steve Good
I'm pretty sure you can't use network pathing in cffile.  However, you  
could mount the remote directory as a drive on the server performing  
the cffile and target the mounted drive.  Or you could use cfftp.  I  
really don't know of another way, which doesn't mean there isn't  
another way, I just don't know of any others.

Steve Good
http://lanctr.com




On Sep 16, 2008, at 8:51 AM, Orlini, Robert wrote:

> Anyway to upload a file using CFFile to another server other than  
> the one where the CF server's gettempdirectory is?
>
>  fileField = "FileContents"
>
> destination = "\\otherserver\public\uploads\#i#\"
>
> accept = "image/jpg, application/msword, text/HTML, application/pdf"
> nameConflict = "MakeUnique">
>
> Thanks.
>
> RO
> HWW
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312834
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfwindow refreshOnShow

2008-06-05 Thread Steve Good
Ahh ok, that's the problem.  We haven't upgraded yet.

Thanks!

Steve Good
http://lanctr.com




On Jun 5, 2008, at 11:03 PM, Kay Smoljak wrote:

> On Fri, Jun 6, 2008 at 11:42 AM, Steve Good <[EMAIL PROTECTED]> wrote:
>> I mean that each time the window is opened the content is loaded  
>> fresh
>> rather than using the cached page.  One of the attributes of the
>> cfwindow tag is refreshOnShow.  It forces the window's content to be
>> loaded fresh each time to window is opened.  However, since I am not
>> using the tag directly and instead using cfajaximport and a  
>> javascript
>> to create unique windows I can't declare the attribute the same way  
>> as
>> with the tag.
>
> Support refreshOnShow was added in 8.0.1 I believe... you're running
> that, right? Prior to that you had to create the window and then
> immediately (in js) do a ColdFusion.navigate('the same url') to force
> a refresh.
>
> -- 
> Kay Smoljak
> business: www.cleverstarfish.com
> coldfusion: kay.smoljak.com
> personal: enterthegoatlady.com | heapsbad.com
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306945
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfwindow refreshOnShow

2008-06-05 Thread Steve Good
I mean that each time the window is opened the content is loaded fresh  
rather than using the cached page.  One of the attributes of the  
cfwindow tag is refreshOnShow.  It forces the window's content to be  
loaded fresh each time to window is opened.  However, since I am not  
using the tag directly and instead using cfajaximport and a javascript  
to create unique windows I can't declare the attribute the same way as  
with the tag.  in my example you can see where I am assigning  
attributes to the created window.

On a whim I tried to create the window with showInit equal to false  
then using another line of script in my function to show the window.   
This didn't make any difference.  When the window has been opened once  
the content will never change no matter how many times I open and  
close the window.

I may just turn to javascript to create a random window name.  This  
would be a hack, but it would force CF to see the window as unique  
each time it was opened.

Steve Good
http://lanctr.com




On Jun 5, 2008, at 10:28 PM, William Seiter wrote:

> Hey Steve,
>
> What do you mean by 'refresh'?
>
> My understanding is that if you 'close' the window and then 'reopen'  
> it,
> that is when it would 'refresh'.
>
> Also, After you run the function, does the window automatically show  
> up, or
> do you need to navigate to it first?
>
> --
> William Seiter
> ColdFusion Web Developer / Consultant
> http://william.seiter.com
>
> Free Website Trade Publication >> Website Magazine
> http://www.websitemagazine.com/referrals/?id=51344&f=text2
> Don't forget to answer the survey questions, it's a 10 second task ,
> a very small request  for access to this  incredible resource.
>
> Have you ever read a book that changed your life?
> Go to: http://www.winninginthemargins.com
> Use PassKey: GoldenGrove
> You'll be glad you did.
>
>
>
> ::-Original Message-
> ::From: Steve Good [mailto:[EMAIL PROTECTED]
> ::Sent: Thursday, June 05, 2008 6:00 PM
> ::To: CF-Talk
> ::Subject: cfwindow refreshOnShow
> ::
> ::
> ::Hi gang,
> ::
> ::I'm creating a cfwindow through a JS function.  I can declare the
> ::width, height, whether it's modal or not, etc through the function.
> ::However when i try to define refreshOnShow:true The cfwindow doesn't
> ::actually refresh.  Here's the JS I'm using:
> ::
> ::function makeWindow(client,campID) {
> ::ColdFusion.Window.create( campID,"Campaign " +
> ::campID,"onlineMarketing_campDetail.cfm?client=" + client +  
> "&campID="
> ::+ campID,
> ::{refreshOnShow:true,center:true,modal:true,width:500,height:400});
> ::}
> ::
> ::Anyone know how I can get this to work?
> ::
> ::Steve Good
> ::http://lanctr.com
> ::
> ::
> ::
> ::
> ::
> ::
> ::
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306942
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


cfwindow refreshOnShow

2008-06-05 Thread Steve Good
Hi gang,

I'm creating a cfwindow through a JS function.  I can declare the  
width, height, whether it's modal or not, etc through the function.   
However when i try to define refreshOnShow:true The cfwindow doesn't  
actually refresh.  Here's the JS I'm using:

function makeWindow(client,campID) {
ColdFusion.Window.create( campID,"Campaign " +  
campID,"onlineMarketing_campDetail.cfm?client=" + client + "&campID="  
+ campID,
{refreshOnShow:true,center:true,modal:true,width:500,height:400});
}

Anyone know how I can get this to work?

Steve Good
http://lanctr.com






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306940
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: MS SQL / Mac OS X

2008-06-02 Thread Steve Good
Ben,

Thanks for the reply.  I ended up throwing vista into a VM and  
installing SMSS.  Turns out my XP disc is the cause of my parallels  
woes, not parallels.

Steve Good
http://lanctr.com




On Jun 2, 2008, at 12:59 PM, Ben Densmore wrote:

> Hi Steve,
> I've been using Aqua Data Studio. It works quite well for doing most  
> things
> in SQL Server. I'm not sure if it can be completely used to manage  
> but for
> doing queries, writing stored procs and things like that it's fine.
>
> The one time I ran into an issue was trying to log into an account  
> that
> needed to change it's password. Aqua Data Studio didn't seem to know  
> how to
> do that.
>
> Thanks,
> Ben
>
> On Sat, May 31, 2008 at 3:11 AM, Steve Good <[EMAIL PROTECTED]> wrote:
>
>> I just got a MacBook Pro and everything is great, but I was wondering
>> what the best way would be to manage a MS SQL server would be.
>> Obviously I can't install MSSQL Studio natively.  I have Parallels,
>> but having a hell of a time getting Windows XP running in a VM.  My
>> original plan was to just run SQL Studio in the VM, but its not going
>> as well as I had expected.
>>
>> What do you all use to manage a SQL server from OS X, if you do at  
>> all?
>>
>> Thanks!
>> Steve
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306629
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


MS SQL / Mac OS X

2008-06-02 Thread Steve Good
I just got a MacBook Pro and everything is great, but I was wondering  
what the best way would be to manage a MS SQL server would be.   
Obviously I can't install MSSQL Studio natively.  I have Parallels,  
but having a hell of a time getting Windows XP running in a VM.  My  
original plan was to just run SQL Studio in the VM, but its not going  
as well as I had expected.

What do you all use to manage a SQL server from OS X, if you do at all?

Thanks!
Steve

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306605
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF8 AJAX controls (cfdiv)

2008-05-29 Thread Steve Good
I have a cfselect that I am binding to a CFC.  I also have a cfdiv that i am
binding to the same CFC but to a different method.  Is it possible to have
the value of the selected item in the cfselect passed as an argument to the
cfdiv's CFC method?

Here's what I was trying.


Select Client:











Where X in the the dnis method is a numeric value derived from the selected
item's value in the cfselect.  The CFC methods are just returning query
results.

I'm trying to populate form elements from the data selected in previous
elements.

Thanks!
-- 
Steve Good
http://lanctr.com/


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306300
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Looping over an XML Array

2008-05-19 Thread Steve Good
Stupid flipping typos...  Thanks Dave.

On Mon, May 19, 2008 at 12:55 PM, Dave Watts <[EMAIL PROTECTED]> wrote:

> > Anyone tell me what I'm doing wrong here?  XML and Arrays are
> > not my strong points.
> >
> >  > "numbers")>
> >  > structKeyExists(ledata.callmeasurement.resultscall.numbers, "dnis")>
> > 
> >  > to="#arrayLen(ledata.callmeasurement.resultscall.numbers.XMLCh
> > ildren)#"
> > index="i">
> >  > ledata.callmesurement.resultscall.numbers.dnis[i].XMLText />
>^^
>
> Shouldn't that be "callmeasurement"?
>
> Also, instead of referencing ledata..numbers.XMLChildren, you might as well
> just reference ledata..numbers.dnis directly.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
> http://training.figleaf.com/
>
> WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
> http://www.webmaniacsconference.com/
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305652
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Looping over an XML Array

2008-05-19 Thread Steve Good
Anyone tell me what I'm doing wrong here?  XML and Arrays are not my strong
points.










Here's a sample of the XML I'm parsing.





2145551234
2145551235




Thanks!


-- 
~Steve


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305646
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: create variables from a string

2008-05-06 Thread Steve Good
Thanks guys, this definitely helped me get this thing done.

~Steve
http://lanctr.com/

-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 06, 2008 4:15 AM
To: CF-Talk
Subject: Re: create variables from a string


SELECT  *
FROM #URL.TABLE#






   
   
   
   
   


Should do ya, HTH

Dominic
-- 
Blog it up: http://fusion.dominicwatson.co.uk



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304799
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: create variables from a string

2008-05-05 Thread Steve Good
I'm not sure that would do what I need, or I'm not understanding.

Here's a snippet of the code I'm using.  I'm pulling the column names from a
table and passing the list to my query and then using the list as the first
row in a csv file.













SELECT #columns#
FROM #URL.TABLE#









~Steve
http://lanctr.com/

-Original Message-
From: Azadi Saryev [mailto:[EMAIL PROTECTED] 
Sent: Monday, May 05, 2008 9:46 PM
To: CF-Talk
Subject: Re: create variables from a string

why not just cfloop over the list and create all vars you need?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Steve Good wrote:
> Is there a way to create named variables from a dynamic list (the list
> doesn't always have the same number of elements)?  
>   



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304774
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


create variables from a string

2008-05-05 Thread Steve Good
Is there a way to create named variables from a dynamic list (the list
doesn't always have the same number of elements)?  

 

One instance might be:

 

red,green,blue,yellow

 

becomes

 

#red#,#green#,#blue#,#yellow#

 

Or would this just be easier to do with listGetAt()?

 

Thanks!

 

~Steve

http://lanctr.com/

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304772
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Automating Subversion Commits

2008-04-29 Thread Steve Good
Right-o.  I have subclipse installed, and have been using it as my primary
way to commit code.  I hadn't thought about any of the risks with submitting
broken code as I am really the only one who uses the repository.  I really
just use it for version control and as an incremental backup, but I
definitely don't want to shoot myself in the foot if my dev team ever gets
bigger than 2.

Thanks for the answers :) 

~Steve
http://lanctr.com/

-Original Message-
From: Brian Kotek [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 29, 2008 12:11 PM
To: CF-Talk
Subject: Re: Automating Subversion Commits

Barney nails it on the head, as usual. Also, the general rule is to "never
commit broken code" to the repository. Any kind of automated commit risks
pushing unfinished code into the repository (unless you're running some kind
of unit tests through a pre-commit hook), which is a bad thing especially if
there is more than one developer.


On Tue, Apr 29, 2008 at 12:58 PM, Barney Boisvert <[EMAIL PROTECTED]>
wrote:

> Don't do that.  Install the Subclipse plugin for Eclipse, and check
> your code in manually.  Doing it automatically is trivial to set up,
> but you don't get atomic commits by doing it that way, no do you get
> helpful commit messages.  Without those, your version history is just
> a set of incremental backups, not anything of real use.
>
> cheers,
> barneyb
>
> On Tue, Apr 29, 2008 at 9:51 AM, Steve Good <[EMAIL PROTECTED]> wrote:
> > Has anyone had any experience setting up a way to automate committing
> code
> >  to a subversion repository?  I'm using assembla.com as my hosted
> repository
> >  and doing my commits manually through eclipse / tortoiseSVN.  I'd love
> to be
> >  able to setup a scheduled task that would commit my code automatically
> each
> >  night, but I really don't know where I would start.  Any advice on
> doing
> >  this?
> >
>
> --
> Barney Boisvert
> [EMAIL PROTECTED]
> http://www.barneyb.com/
>
> Got Gmail? I have 100 invites.
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304417
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Automating Subversion Commits

2008-04-29 Thread Steve Good
Has anyone had any experience setting up a way to automate committing code
to a subversion repository?  I'm using assembla.com as my hosted repository
and doing my commits manually through eclipse / tortoiseSVN.  I'd love to be
able to setup a scheduled task that would commit my code automatically each
night, but I really don't know where I would start.  Any advice on doing
this?

 

Thanks in advance!

 

~Steve

http://lanctr.com/

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304413
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: OT: Printing Database Structure

2008-04-25 Thread Steve Good
Cool, thanks for the tip, I'll look into it.  

~Steve
http://lanctr.com/


-Original Message-
From: Web Specialist [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 25, 2008 4:30 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure

Cool. Anyway I'll suggest you to know about DataMgr. DataMgr do this job so
easy.

http://datamgr.riaforge.org/

With getDatabaseTables method and looping over calling getDBTableStruct
method.

Cheers
Marco Antonio

On Fri, Apr 25, 2008 at 6:19 PM, Steve Good <[EMAIL PROTECTED]> wrote:

> Yep, that did the trick.  You rock!
>
> This time I saved the query ;)
>
> ~Steve
> http://lanctr.com/
>
>
> -Original Message-
> From: Web Specialist [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 25, 2008 4:13 PM
> To: CF-Talk
> Subject: Re: OT: Printing Database Structure
>
> Do you can try this statement:
>
> SELECT TABLE_CATALOG,
>   TABLE_NAME,COLUMN_NAME,
>   DATA_TYPE,
>   CHARACTER_MAXIMUM_LENGTH,
>   NUMERIC_PRECISION,
>   NUMERIC_SCALE,
>   IS_NULLABLE,
>   COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS
> IS_AUTOINCREMENT,
>   COLUMN_DEFAULT
> FROM   INFORMATION_SCHEMA.COLUMNS
> ORDER BY 2,3
>
> Cheers
> Marco Antonio
> On Fri, Apr 25, 2008 at 5:43 PM, Steve Good <[EMAIL PROTECTED]> wrote:
>
> > I did this once before, but forgot how I did it, and can't figure out
how
> I
> > found the answer either.
> >
> >
> >
> > Do any of you know how I can print all the table names, columns in the
> > tables, and data types of the columns from within MS SQL Server Mgmnt
> > Studio?
> >
> >
> >
> > Thanks.
> >
> >
> >
> > ~Steve
> >
> > http://lanctr.com/
> >
> >
> >
> >
> >
> >
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304275
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: OT: Printing Database Structure

2008-04-25 Thread Steve Good
Yep, that did the trick.  You rock!

This time I saved the query ;)

~Steve
http://lanctr.com/


-Original Message-
From: Web Specialist [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 25, 2008 4:13 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure

Do you can try this statement:

SELECT TABLE_CATALOG,
   TABLE_NAME,COLUMN_NAME,
   DATA_TYPE,
   CHARACTER_MAXIMUM_LENGTH,
   NUMERIC_PRECISION,
   NUMERIC_SCALE,
   IS_NULLABLE,
   COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS
IS_AUTOINCREMENT,
   COLUMN_DEFAULT
FROM   INFORMATION_SCHEMA.COLUMNS
ORDER BY 2,3

Cheers
Marco Antonio
On Fri, Apr 25, 2008 at 5:43 PM, Steve Good <[EMAIL PROTECTED]> wrote:

> I did this once before, but forgot how I did it, and can't figure out how
I
> found the answer either.
>
>
>
> Do any of you know how I can print all the table names, columns in the
> tables, and data types of the columns from within MS SQL Server Mgmnt
> Studio?
>
>
>
> Thanks.
>
>
>
> ~Steve
>
> http://lanctr.com/
>
>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304271
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: OT: Printing Database Structure

2008-04-25 Thread Steve Good
AHA! This looks familiar...  I'll give it a whirl.  Thanks!

~Steve
http://lanctr.com/


-Original Message-
From: Web Specialist [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 25, 2008 4:13 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure

Do you can try this statement:

SELECT TABLE_CATALOG,
   TABLE_NAME,COLUMN_NAME,
   DATA_TYPE,
   CHARACTER_MAXIMUM_LENGTH,
   NUMERIC_PRECISION,
   NUMERIC_SCALE,
   IS_NULLABLE,
   COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS
IS_AUTOINCREMENT,
   COLUMN_DEFAULT
FROM   INFORMATION_SCHEMA.COLUMNS
ORDER BY 2,3

Cheers
Marco Antonio
On Fri, Apr 25, 2008 at 5:43 PM, Steve Good <[EMAIL PROTECTED]> wrote:

> I did this once before, but forgot how I did it, and can't figure out how
I
> found the answer either.
>
>
>
> Do any of you know how I can print all the table names, columns in the
> tables, and data types of the columns from within MS SQL Server Mgmnt
> Studio?
>
>
>
> Thanks.
>
>
>
> ~Steve
>
> http://lanctr.com/
>
>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304270
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: OT: Printing Database Structure

2008-04-25 Thread Steve Good
Diagrams can do this, but I don't have the time to sit down and arrange all
the little boxes so that they fit on pages.  I was able, some time ago, to
make a list of my tables with their columns and the column's data types
through a query (I think).  Afterwards I was able to copy and paste it into
excel for printing.  Again, I THINK I did it this way, but who knows, I've
slept since then.

~Steve
http://lanctr.com/

-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 25, 2008 4:02 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure

>Do any of you know how I can print all the table names, columns in the
> tables, and data types of the columns from within MS SQL Server Mgmnt
> Studio?

Could creating a diagram with all the tables on it help here? This can
show all tables, column data and relationships. Diagrams can be
printed..

Dominic

On 25/04/2008, Steve Good <[EMAIL PROTECTED]> wrote:
> I did this once before, but forgot how I did it, and can't figure out how
I
> found the answer either.
>
>
>
> Do any of you know how I can print all the table names, columns in the
> tables, and data types of the columns from within MS SQL Server Mgmnt
> Studio?
>
>
>
> Thanks.
>
>
>
> ~Steve
>
> http://lanctr.com/
>
>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304269
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


OT: Printing Database Structure

2008-04-25 Thread Steve Good
I did this once before, but forgot how I did it, and can't figure out how I
found the answer either.  

 

Do any of you know how I can print all the table names, columns in the
tables, and data types of the columns from within MS SQL Server Mgmnt
Studio?

 

Thanks.

 

~Steve

http://lanctr.com/

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304264
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: LCDS + Flex 3 (AIR)

2008-04-24 Thread Steve Good
Ok,  I'm already lost.  A couple quick google searches for LCDS tutorials
yields lots of results, but not really anything that a beginner could pick
up and start doing anything with.  Any recommendations for where a beginner
should start looking?

~Steve
http://lanctr.com/


-Original Message-
From: João_Fernandes <[EMAIL PROTECTED]>
[mailto:=?ISO-8859-1?Q?Jo=E3o=5FFernandes_<[EMAIL PROTECTED]
om>?=] 
Sent: Thursday, April 24, 2008 4:58 PM
To: CF-Talk
Subject: Re: LCDS + Flex 3 (AIR)

Till now it has been mostly (and only) Flex related but integration with 
AIR should be that different.
If you have specific questions that you would like to know more, I can 
try to help.

-- 

João Fernandes

http://www.onflexwithcf.org
http://www.riapt.org
Portugal Adobe User Group (http://aug.riapt.org)




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304220
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: LCDS + Flex 3 (AIR)

2008-04-24 Thread Steve Good
Thanks guys.  I'm really excited about learning more about LCDS after I saw
what Blaze DS can do.  And if I'm not mistaken, blaze is part of the LCDS
family, but LCDS can do "more".

~Steve
http://lanctr.com/

-Original Message-
From: João_Fernandes <[EMAIL PROTECTED]>
[mailto:=?ISO-8859-1?Q?Jo=E3o=5FFernandes_<[EMAIL PROTECTED]
om>?=] 
Sent: Thursday, April 24, 2008 4:58 PM
To: CF-Talk
Subject: Re: LCDS + Flex 3 (AIR)

Till now it has been mostly (and only) Flex related but integration with 
AIR should be that different.
If you have specific questions that you would like to know more, I can 
try to help.

-- 

João Fernandes

http://www.onflexwithcf.org
http://www.riapt.org
Portugal Adobe User Group (http://aug.riapt.org)




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304219
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


LCDS + Flex 3 (AIR)

2008-04-24 Thread Steve Good
Anyone have or know of any great tutorials on using Live Cycle DS with Flex
apps?  I'm looking through my CF8 WACK and feeling pretty disappointed.

 

Thanks!

 

~Steve

http://lanctr.com/

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304207
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: autosuggest

2008-04-07 Thread Steve Good
Blah, it is returning only the first row it queries...  But I figured it
out...  I was actually only returning the first row with   I added some stuff to it and now I have  and it returns all the results.

~Steve
http://goodcf.instantspot.com/


-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 07, 2008 2:55 PM
To: CF-Talk
Subject: Re: autosuggest

Yeh, maybe - try calling it directly as you have it in the autosuggest
property, replacing the cfautosuggest variable with 's'.

Dominic


On 07/04/2008, Steve Good <[EMAIL PROTECTED]> wrote:
>
> I tried that, set it to 50.  I imagine that somehow my CFC is actually
> only
> returning 1 row...
>
> ~Steve
> http://goodcf.instantspot.com/
>
>
> -Original Message-
> From: Dominic Watson [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 07, 2008 2:48 PM
> To: CF-Talk
> Subject: Re: autosuggest
>
> Hm, only thing I can think of is the maxResultsDisplayed property of the
> tag. Have you tried setting that explicitly? It default to 10 though...
>
> On 07/04/2008, Steve Good <[EMAIL PROTECTED]> wrote:
> >
> > Ok, different issue.  The autosuggest is working, but for some reason
> only
> > returning 1 match only.  I can type in s and it will show me
> > [EMAIL PROTECTED] but if I type in st it will show me
> > [EMAIL PROTECTED]  But I want it to show both addresses when
> > the
> > user types in s.  I know this was working with the list example, so
> again,
> > I
> > think it has to do with my CFC.  Any ideas?  Sorry to be a pain
> today.  My
> > brain is only running at 1/3 capacity.
> >
> > ~Steve
> > http://goodcf.instantspot.com/
> >
> >
> >
> >
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302904
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: autosuggest

2008-04-07 Thread Steve Good
I tried that, set it to 50.  I imagine that somehow my CFC is actually only
returning 1 row...

~Steve
http://goodcf.instantspot.com/


-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 07, 2008 2:48 PM
To: CF-Talk
Subject: Re: autosuggest

Hm, only thing I can think of is the maxResultsDisplayed property of the
tag. Have you tried setting that explicitly? It default to 10 though...

On 07/04/2008, Steve Good <[EMAIL PROTECTED]> wrote:
>
> Ok, different issue.  The autosuggest is working, but for some reason only
> returning 1 match only.  I can type in s and it will show me
> [EMAIL PROTECTED] but if I type in st it will show me
> [EMAIL PROTECTED]  But I want it to show both addresses when
> the
> user types in s.  I know this was working with the list example, so again,
> I
> think it has to do with my CFC.  Any ideas?  Sorry to be a pain today.  My
> brain is only running at 1/3 capacity.
>
> ~Steve
> http://goodcf.instantspot.com/
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302901
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: autosuggest

2008-04-07 Thread Steve Good
Ok, different issue.  The autosuggest is working, but for some reason only
returning 1 match only.  I can type in s and it will show me
[EMAIL PROTECTED] but if I type in st it will show me
[EMAIL PROTECTED]  But I want it to show both addresses when the
user types in s.  I know this was working with the list example, so again, I
think it has to do with my CFC.  Any ideas?  Sorry to be a pain today.  My
brain is only running at 1/3 capacity.

~Steve
http://goodcf.instantspot.com/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302896
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: autosuggest

2008-04-07 Thread Steve Good
Yeah, I tried using trim() but that didn't seem to fix the issue.  Seems
like the only thing that worked was adding the space after the semicolon. ';
'

~Steve
http://goodcf.instantspot.com/


-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 07, 2008 1:00 PM
To: CF-Talk
Subject: Re: autosuggest

Lol, yeh - I was only writing as example, completely untested. Instead of
adding the space in the delimiter, try:



Adding a space as a delimiter could give you unexpected results..

Dominic


On 07/04/2008, Steve Good <[EMAIL PROTECTED]> wrote:
>
> Sweet Dom, thanks again.  I used your example, but that didn't want to
> work
> either.  I noticed that ListLast(arguments.search, ';') did not have a
> space
> after the semi-colon like the list of email addresses does after the
> autosuggest fills it in.  After I added the space in there it works like a
> champ!  Also needed to set the function to remote, but I guess I have to
> do
> SOME of the work lol!
>
> Thanks!
>
> ~Steve
> http://goodcf.instantspot.com/
>
> -Original Message-
> From: Dominic Watson [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 07, 2008 12:10 PM
> To: CF-Talk
> Subject: Re: autosuggest
>
> Hi Steve,
>
> I got it to work with a cfc by doing something like this:
>
>
> 
> 
>
> 
>
> 
> *SELECT* leemail
> *FROM* emailview
> *WHERE* ({ fn *UCASE*(leemail) } *LIKE* { fn*UCASE*('#emailSearch #%') })
> *AND* (frn_leuserid = #*session*.callmeasurement_uid#)
> *ORDER* *BY* leemail
> 
> 
>
> HTH
>
> Dominic
>
>
>
> On 07/04/2008, Steve Good <[EMAIL PROTECTED]> wrote:
> >
> > Sorry to beat a dying horse here, but I'm having issues getting a second
> > value to return using the custom tag.  It works fine if I use a list,
> but
> > if
> > I bind it to my cfc that runs a query it returns the first value but
> stops
> > after that.  I can see it's talking to my CFC if I keep typing, but it
> > never
> > returns anything.
> >
> > Here's the CFC I'm using, I'm sure the problem is in here
> > someplace.  Other
> > than the Application.cfc I'm relatively new to CFCs and they way they
> > work.
> > So I'm sure I missed something here.
> >
> > 
> >
> >
> > > hint="Queries for an email address based on string in form"
> > access="remote"
> > output="false" returntype="String">
> > > hint="passes the form string to the query" required="false" />
> >
> >
> >
> >
> > name="data">
> >SELECT leemail
> >FROM emailview
> >WHERE  ({ fn UCASE(leemail) } LIKE { fn
> > UCASE('#ARGUMENTS.search#%') })
> >AND (frn_leuserid =
> #session.callmeasurement_uid#)
> >ORDER BY leemail
> >
> >
> >
> >
> >
> >
> > 
> >
> > Thanks again for the help :)
> >
> > ~Steve
> > http://goodcf.instantspot.com/
> >
> >
> >
> >
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302892
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: autosuggest

2008-04-07 Thread Steve Good
Sweet Dom, thanks again.  I used your example, but that didn't want to work
either.  I noticed that ListLast(arguments.search, ';') did not have a space
after the semi-colon like the list of email addresses does after the
autosuggest fills it in.  After I added the space in there it works like a
champ!  Also needed to set the function to remote, but I guess I have to do
SOME of the work lol!

Thanks!

~Steve
http://goodcf.instantspot.com/

-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 07, 2008 12:10 PM
To: CF-Talk
Subject: Re: autosuggest

Hi Steve,

I got it to work with a cfc by doing something like this:








*SELECT* leemail
*FROM* emailview
*WHERE* ({ fn *UCASE*(leemail) } *LIKE* { fn*UCASE*('#emailSearch #%') })
*AND* (frn_leuserid = #*session*.callmeasurement_uid#)
*ORDER* *BY* leemail



HTH

Dominic



On 07/04/2008, Steve Good <[EMAIL PROTECTED]> wrote:
>
> Sorry to beat a dying horse here, but I'm having issues getting a second
> value to return using the custom tag.  It works fine if I use a list, but
> if
> I bind it to my cfc that runs a query it returns the first value but stops
> after that.  I can see it's talking to my CFC if I keep typing, but it
> never
> returns anything.
>
> Here's the CFC I'm using, I'm sure the problem is in here
> someplace.  Other
> than the Application.cfc I'm relatively new to CFCs and they way they
> work.
> So I'm sure I missed something here.
>
> 
>
>
> hint="Queries for an email address based on string in form"
> access="remote"
> output="false" returntype="String">
> hint="passes the form string to the query" required="false" />
>
>
>
>
>
>SELECT leemail
>FROM emailview
>WHERE  ({ fn UCASE(leemail) } LIKE { fn
> UCASE('#ARGUMENTS.search#%') })
>AND (frn_leuserid = #session.callmeasurement_uid#)
>ORDER BY leemail
>
>
>
>
>
>
> 
>
> Thanks again for the help :)
>
> ~Steve
> http://goodcf.instantspot.com/
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302885
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: autosuggest

2008-04-07 Thread Steve Good
Sorry to beat a dying horse here, but I'm having issues getting a second
value to return using the custom tag.  It works fine if I use a list, but if
I bind it to my cfc that runs a query it returns the first value but stops
after that.  I can see it's talking to my CFC if I keep typing, but it never
returns anything.

Here's the CFC I'm using, I'm sure the problem is in here someplace.  Other
than the Application.cfc I'm relatively new to CFCs and they way they work.
So I'm sure I missed something here.











SELECT leemail
FROM emailview
WHERE  ({ fn UCASE(leemail) } LIKE { fn
UCASE('#ARGUMENTS.search#%') })
AND (frn_leuserid = #session.callmeasurement_uid#)
ORDER BY leemail








Thanks again for the help :)

~Steve
http://goodcf.instantspot.com/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302876
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: autosuggest

2008-04-03 Thread Steve Good
Just posted my solution to the autosuggest "challenge" I was having
yesterday.  It's not nearly as nice as the solution that Dom presented, but
I think as a quick solution it's not half bad.

http://goodcf.instantspot.com/blog/2008/04/03/Creating-and-Appending-a-List-
Using-AutoSuggest-and-JQuery

~Steve
http://goodcf.instantspot.com/


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302654
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: autosuggest

2008-04-03 Thread Steve Good
Ahh cool, I get it.

I'll definitely be using this where I can.

~Steve
http://goodcf.instantspot.com/


-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2008 12:08 PM
To: CF-Talk
Subject: Re: autosuggest

>
> Fyi, your example for veggies is not including the delimiter when
> selecting
> the item.


Yeh, it's not supposed to. The two boxes are demonstrating different things.
The first is sideways animation and delimited list. The second is no drop
shadow, enforced selection and typeahead.

Of course, all the smart ppl behind the YAHOO ui are really to thank ;)

Dominic

-- 
Blog it up: http://fusion.dominicwatson.co.uk




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302640
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Coldfusion + AIR

2008-04-03 Thread Steve Good
Yep, my mistake, vol. II issue II.

~Steve
http://goodcf.instantspot.com/


-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2008 9:00 AM
To: CF-Talk
Subject: Re: Coldfusion + AIR

On Thu, Apr 3, 2008 at 9:35 PM, Steve Good <[EMAIL PROTECTED]> wrote:
> If you have Volume 3 issue 3 of the fusion quarterly, there are a whole
>  bunch of examples for connecting Flex 3 and AIR to webservices.

I think it was Vol 2 Issue 2; I particularly recommend the article by
James Holmes on this, in that issue (and the follow-up in Issue 3).

:-)

-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302636
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: autosuggest

2008-04-03 Thread Steve Good
Fyi, your example for veggies is not including the delimiter when selecting
the item.  But I like that I can specify my own delimiter in there.  And the
typahead is way cool.  Can this connect to a CFC in the same way as the
regular autosuggest attrib?  i.e.
autosuggest="cfc:mycfc.myfunction({cfautosuggestvalue})"

~Steve
http://goodcf.instantspot.com/


-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2008 11:01 AM
To: CF-Talk
Subject: Re: autosuggest

Here's the example.cfm that comes in the riaforge download:

http://dev.dominicwatson.co.uk/autosuggest/example.cfm

The first box has the following settings:



And the second:


Dominic



On 03/04/2008, Rick Faircloth <[EMAIL PROTECTED]> wrote:
>
> Got a demo of this, Dominic?
>
> Rick
>
> > -Original Message-
> > From: Dominic Watson [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, April 03, 2008 11:03 AM
> > To: CF-Talk
> > Subject: Re: autosuggest
> >
> > There is now a custom tag for an auto-suggesting cfinput with more than
> just
> > enabling listed auto-suggests :)
> >
> > http://betterautosuggest.riaforge.org/
> >
> > Dominic
> >
> > --
> > Blog it up: http://fusion.dominicwatson.co.uk
> >
> >
> >
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302635
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: autosuggest

2008-04-03 Thread Steve Good
Kick ass Dom, can't wait to try this out!

~Steve
http://goodcf.instantspot.com/

-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2008 10:03 AM
To: CF-Talk
Subject: Re: autosuggest

There is now a custom tag for an auto-suggesting cfinput with more than just
enabling listed auto-suggests :)

http://betterautosuggest.riaforge.org/

Dominic

-- 
Blog it up: http://fusion.dominicwatson.co.uk




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302631
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Coldfusion + AIR

2008-04-03 Thread Steve Good
If you have Volume 3 issue 3 of the fusion quarterly, there are a whole
bunch of examples for connecting Flex 3 and AIR to webservices.  There is
also an Acrobat Connect presentation out there (sorry, no link right now)
from a cfug in Scotland where the presenter has built a rudimentary email
client in AIR and calling CFCs remotely.  I'll be blogging one of my AIR
apps later next week.  It uses webservices and custom binding from CFCs.  So
keep an eye out for that.

HTH

~Steve
http://goodcf.instantspot.com


-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2008 8:15 AM
To: CF-Talk
Subject: RE: Coldfusion + AIR

Vishnu...

We'd need to know which type of AIR app you're going to build before
pointing you to some examples. Are you planning on building a Flex or Flash
based AIR app, or will it be done in HTML/JS?

-Original Message-
From: vishnu prasad [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2008 5:18 AM
To: CF-Talk
Subject: Coldfusion + AIR

Hi all
i am new to air actually i am yet to start programming in AIR 

Is is possible to call coldfusion web service from AIR if yes could any one
provide me some samples or link on the same...

like to develop an application air wich will get the data from databse using
web service 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302580
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: autosuggest

2008-04-03 Thread Steve Good
Wow Dom!  Thanks for spending so much time on this!  You came up with a much
better, and easier solution than I had come up with.  My way involved adding
some jquery to create a list of emails one at a time, appending the that
list to a  and the value attribute of a hidden input tag, then
clearing the autosuggest field each time an address was found, chosen, and
the user clicked an "Add" button.  I'll give your method a try since that
was what I had been looking to do in the first place.

Rock on!

~Steve
http://goodcf.instantspot.com

-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 02, 2008 8:10 PM
To: CF-Talk
Subject: Re: autosuggest

Right, I finally worked out a concise solution :) I blogged about it here:

http://fusion.dominicwatson.co.uk/2008/04/tidy-autosuggesting-solution.html

Dominic

-- 
Blog it up: http://fusion.dominicwatson.co.uk




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302571
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: autosuggest

2008-04-02 Thread Steve Good
Thanks Dom,

I'm binding to a cfc already, that isn't a problem.  What I'm hoping to do
is the same thing google does with gmail.  You start typing an address and
the autosuggest drops down addresses from your address book, you select one,
then start typing to find another one and the autosuggest starts returning
addresses based on what you started typing after the last address was
selected.  This is all done in a single input field.  I'm hoping that I can
avoid needing to write out a custom AJAX function to accomplish this since
it is being added onto a seldom used tool that we aren't really wanting to
spend a whole lot of time on.

Thanks!

~Steve
http://goodcf.instantspot.com/

-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 02, 2008 1:43 PM
To: CF-Talk
Subject: Re: autosuggest

You can get the autosuggest to give you a list of emails based on the last
entered text in a list by binding the autosuggest to a cfc or url. See the
'Using autosuggest text input fields' near the bottom of this page:

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=ajaxui_7.h
tml

However, I think the CF implementation of the autosuggest will force that a
single email picked from the autosuggest list will overwrite whatever is in
the text box. I think you would need to write some custom javascript to get
it to overwrite only the last item in a list but someone should be able to
help you with that if its the case (I'd be interested to see it!)

HTH

Dominic

-- 
Blog it up: http://fusion.dominicwatson.co.uk




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302522
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: autosuggest

2008-04-02 Thread Steve Good
Appending the semicolon was easy enough, I was trying to make it more
complicated than it was for some reason.  Never dawned on me to try 

 

Still looking for a way to keep autosuggesting emails once the first has
been selected though.

 

 

~Steve

http://goodcf.instantspot.com/

 

From: Steve Good [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 02, 2008 12:58 PM
To: CF-Talk
Subject: autosuggest

 

I have a form field that autosuggests an email address, however it only
works with one email address at a time.  How would I go about setting it up
so that when a user starts typing the autosuggest will append the email
address with a semicolon and then allow the user to search for another
address in the same field?  This is my first time really working with
autosuggest and the examples in the CFWACK don't cover what I want to do.

 

Thanks!

 

~Steve

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302517
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


autosuggest

2008-04-02 Thread Steve Good
I have a form field that autosuggests an email address, however it only
works with one email address at a time.  How would I go about setting it up
so that when a user starts typing the autosuggest will append the email
address with a semicolon and then allow the user to search for another
address in the same field?  This is my first time really working with
autosuggest and the examples in the CFWACK don't cover what I want to do.

 

Thanks!

 

~Steve

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302514
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: clearing form fields when tabbing

2008-03-27 Thread Steve Good
Thanks Nic,

This helped me get these stupid forms done and out of my hair.

~Steve
http://goodcf.instantspot.com/blog



Nicholas M Tunney wrote:
> You can add a focus event listener to each form input text element to 
> clear it when a user tabs to the field, or use onFocus="" for each. The 
> method that is called would look something like this:
>
> function clearFormField (elID) {
> document.getElementById(elID).value = '';
> }
>
> Nic
>
> Steve Good wrote:
>   
>> So I know how to clear form fields when they are clicked using 
>> onClick="this.value=''" but how do I clear them when tabbing through the 
>> form?  I looked at onActivate, but it seems pretty much unsupported.  I 
>> also read this article 
>> http://www.mindpalette.com/tutorials/clear_defaults/index.php , but I 
>> have around 50+ fields, and the thought of writing a script that 
>> addresses each field individually does not put a smile on my face.  
>> Anyone have a quick and dirty method of getting this done like the 
>> onClick method? 
>>
>> Thanks again!
>>   
>> 
>
>
>   

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302236
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


clearing form fields when tabbing

2008-03-27 Thread Steve Good
So I know how to clear form fields when they are clicked using 
onClick="this.value=''" but how do I clear them when tabbing through the 
form?  I looked at onActivate, but it seems pretty much unsupported.  I 
also read this article 
http://www.mindpalette.com/tutorials/clear_defaults/index.php , but I 
have around 50+ fields, and the thought of writing a script that 
addresses each field individually does not put a smile on my face.  
Anyone have a quick and dirty method of getting this done like the 
onClick method? 

Thanks again!
-- 

~Steve
http://goodcf.instantspot.com/blog


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302234
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: styling cfformgroup

2008-03-27 Thread Steve Good
ignore my question...  it helps if I look at which group i'm styling and 
then scroll down to that particular group.  *smacks head*

~Steve
http://goodcf.instantspot.com/blog



Steve Good wrote:
> Hi gang,
>
> I have an xml form and I'm using  to 
> group fields together.  Is it possible to change the background color 
> of the cfformgroup?  I tried applying a stylesheet against the group's 
> ID, and I've tried putting it in-line with the style attribute, but 
> neither have worked for me.
>
> Thanks!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302230
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


styling cfformgroup

2008-03-27 Thread Steve Good
Hi gang,

I have an xml form and I'm using  to group 
fields together.  Is it possible to change the background color of the 
cfformgroup?  I tried applying a stylesheet against the group's ID, and 
I've tried putting it in-line with the style attribute, but neither have 
worked for me.

Thanks!
-- 

~Steve
http://goodcf.instantspot.com/blog


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302228
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


OT: CAM-II, an open source CMS project

2008-03-12 Thread Steve Good
Hi Gang,

Every so often I get an itch that needs scratching.  That itch is 
learning something new with CF and building a project around that.  This 
time I am putting together an open source CMS project.  Unlike some 
other CMS apps out there, I want this one to be completely community 
driven, fully customizable, and extremely user friendly with an 
intuitive interface and API.  Besides basic blog functions, I am 
thinking about including a gallery, a calendar that be standalone or 
connect to a google calendar.  I'd really like to see this application 
become a modular platform that can fit many needs and provide a unique 
user experience for each installation.

The whole system is being built for CF MX 7 (I'm not opposed to using 
CF8, I just wanted to accommodate those who have not yet had the 
opportunity to update), AJAX (JQuery), and the Mach-II framework.  
CAM-II is an acronym derived from these technologies.

If this is something you would be interested in contributing to, or if 
you have questions let me know either here on this group, or email me 
directly.

Thanks for putting up with me yet again. ;-)
-- 

~Steve
http://goodcf.instantspot.com/blog


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301127
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFPOP #Body# and carriage returns

2008-03-11 Thread Steve Good
I am indeed working with plain text emails.  I will eventually be 
outputting the body in html.  Thanks for the push in the right direction.

~Steve
http://goodcf.instantspot.com/blog



Brad Wood wrote:
> How are you outputting the body of the E-mail?  If you are simply
> outputting it on an HTML page, you will need to replace carriage
> returns/line feeds with  tags since HTML ignores them.  
> Either that, or place the output in pre tags.  
> I'm assuming you are dealing with a plain text E-mail.  That may or may
> not be a safe assumption to make though.
>
> ~Brad
>
> -Original Message-
> From: Steve Good [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, March 11, 2008 2:21 PM
> To: CF-Talk
> Subject: CFPOP #Body# and carriage returns
>
> I am pulling data from a pop3 server using the cfpop tag and everything 
> is working smoothly, but I noticed that there are no carriage returns in
>
> the body of the emails.  Do I need to specify a delimiter or anything or
>
> am I just SOL?
>   

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300992
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFPOP #Body# and carriage returns

2008-03-11 Thread Steve Good
I am pulling data from a pop3 server using the cfpop tag and everything 
is working smoothly, but I noticed that there are no carriage returns in 
the body of the emails.  Do I need to specify a delimiter or anything or 
am I just SOL?
-- 

~Steve
http://goodcf.instantspot.com/blog


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300988
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Parsing Selected Parts of a CSV file

2008-02-26 Thread Steve Good
yeah, I had noticed that my delimiters were not correct.  I changed them 
back to chr(10) and chr(13).  I still am having issues with null 
values.  Going to just keep plugging away.

~Steve
http://goodcf.instantspot.com/blog



C S wrote:
>> I don't think it's necessary for the loop to work, but at the time I 
>> think I ended up putting listFix() on everything coming out of the CSV I 
>> was parsing.  Taking it out doesn't change anything.
>> 
>
> That is not the only issue.  Is each line in your CSV really delimited by a 
> tab (9) or is some combination of line feed/carriage return?
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299893
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Parsing Selected Parts of a CSV file

2008-02-25 Thread Steve Good
I don't think it's necessary for the loop to work, but at the time I 
think I ended up putting listFix() on everything coming out of the CSV I 
was parsing.  Taking it out doesn't change anything.

~Steve
http://goodcf.instantspot.com/blog



C S wrote:
>> The error crops up when the loop encounters a field that has null data.  
>> I am using ListFix, and i thought that this would solve the problem, but 
>> it doesn't.  
>> 
>> 
>
> Is that the correct loop logic?  Should you not be splitting on new lines, 
> then using ListFix on each row?
>
> 
> ... skip first 5 rows ..
> 
> 
> ...
> 
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299872
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Parsing Selected Parts of a CSV file

2008-02-25 Thread Steve Good
hmm, I am using cf8.  I'll have to see if I can find the param that does 
what you are talking about.  Thanks for the push in the right direction.

~Steve
http://goodcf.instantspot.com/blog



Azadi Saryev wrote:
> the problem is CF ignores multiple consecutive delimiters, pretending it 
> is just one delimiter.
> in CF8 there is a parameter in some list functions to tell cf NOT to 
> ignore empty list elements.
> before CF8 you have to insert something (like a space) into empty 
> elements in each line of your csv (using replace() or similar function).
>
> hth
>
> Azadi Saryev
> Sabai-dee.com
> http://www.sabai-dee.com/
>
>
>
> Steve Good wrote:
>   
>> The error crops up when the loop encounters a field that has null data.  
>> I am using ListFix, and i thought that this would solve the problem, but 
>> it doesn't.  I have no control over the csv files, so I need to figure 
>> out a way to accurately input these null fields without throwing an 
>> error.  Any ideas?
>>
>> ~Steve
>> http://goodcf.instantspot.com/blog
>>   
>> 
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299871
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Parsing Selected Parts of a CSV file

2008-02-25 Thread Steve Good
Ok, I'm attacking this thing from another angle.  I am trying to use 
cfhttp to read the file, however, I need to skip the first 5 lines of 
the CSV.  The original document has a bunch of garbage at the top that I 
don't want.  How do I skip the lines while using cfhttp?  Or do I need 
to define the column names and just hope for the best?

Thanks!

~Steve
http://goodcf.instantspot.com/blog



Steve Good wrote:
> Dang-it.  So I solved the mystery of grabbing just the data I want.  
> I'm now running into a new issue.  I am getting an error when parsing 
> through the file. 
>
>
>   Invalid list index 9.
>
> In function ListGetAt(list, index [, delimiters]), the value of index, 
> 9, is not a valid as the first argument (this list has 6 
> elements). Valid indexes are in the range 1 through the number of 
> elements in the list.
>
>
>
> The error crops up when the loop encounters a field that has null 
> data.  I am using ListFix, and i thought that this would solve the 
> problem, but it doesn't.  I have no control over the csv files, so I 
> need to figure out a way to accurately input these null fields without 
> throwing an error.  Any ideas?
>
> ~Steve
> http://goodcf.instantspot.com/blog
>
>
>
> Steve Good wrote:
>> Ha!  ok, so ignore my question...  I was on the right track, I just 
>> forgot to specify my delimiters correctly in the loop tag.
>>
>> ~Steve
>> http://goodcf.instantspot.com/blog
>>
>>
>>
>> Steve Good wrote:
>>> Hi Gang,
>>>
>>> About a year ago I wrote (with help from this list) a bit of code to 
>>> loop through a csv file and insert the data into my database.  I am 
>>> revisiting that code for a new project but there is a twist now.  
>>> Instead of putting all columns into their respective fields in the 
>>> DB, I want to grab only the columns I need from the CSV and ignore 
>>> the rest, then insert those selected columns into their DB fields.  
>>> I thought by playing around with the index in the cfqueryparam I 
>>> could just have it look at the columns I wanted, obviously this 
>>> isn't the case.  Below is a sample of what I tried.  I now know that 
>>> I have to start the index at 1 and go up incrementally.  Anyone have 
>>> an idea how I could accomplish my task?
>>>
>>>
>>>>> filefield="tdFile" nameconflict="overwrite">
>>>
>>>>> variable="fileData">
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>>> delimiters="#chr(9)#">
>>>
>>>
>>>
>>>
>>>
>>>INSERT INTO table (field1, field2, field3, field4, 
>>> field5, field6, field7)
>>>VALUES (
>>>>> value="#listgetat(listfix(record),2,chr(9))#" 
>>> cfsqltype="cf_sql_varchar">,
>>>>> value="#listgetat(listfix(record),3,chr(9))#" 
>>> cfsqltype="cf_sql_varchar">,
>>>>> value="#createODBCDateTime(listgetat(listfix(record),6,chr(9)))#" 
>>> cfsqltype="cf_sql_date">,
>>>>> value="#listgetat(listfix(record),9,chr(9))#" 
>>> cfsqltype="cf_sql_varchar">,
>>>,
>>>,
>>>
>>>)
>>>
>>>
>>>


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299868
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Parsing Selected Parts of a CSV file

2008-02-25 Thread Steve Good
Dang-it.  So I solved the mystery of grabbing just the data I want.  I'm 
now running into a new issue.  I am getting an error when parsing 
through the file. 


  Invalid list index 9.

In function ListGetAt(list, index [, delimiters]), the value of index, 
9, is not a valid as the first argument (this list has 6 
elements). Valid indexes are in the range 1 through the number of 
elements in the list.



The error crops up when the loop encounters a field that has null data.  
I am using ListFix, and i thought that this would solve the problem, but 
it doesn't.  I have no control over the csv files, so I need to figure 
out a way to accurately input these null fields without throwing an 
error.  Any ideas?

~Steve
http://goodcf.instantspot.com/blog



Steve Good wrote:
> Ha!  ok, so ignore my question...  I was on the right track, I just 
> forgot to specify my delimiters correctly in the loop tag.
>
> ~Steve
> http://goodcf.instantspot.com/blog
>
>
>
> Steve Good wrote:
>> Hi Gang,
>>
>> About a year ago I wrote (with help from this list) a bit of code to 
>> loop through a csv file and insert the data into my database.  I am 
>> revisiting that code for a new project but there is a twist now.  
>> Instead of putting all columns into their respective fields in the 
>> DB, I want to grab only the columns I need from the CSV and ignore 
>> the rest, then insert those selected columns into their DB fields.  I 
>> thought by playing around with the index in the cfqueryparam I could 
>> just have it look at the columns I wanted, obviously this isn't the 
>> case.  Below is a sample of what I tried.  I now know that I have to 
>> start the index at 1 and go up incrementally.  Anyone have an idea 
>> how I could accomplish my task?
>>
>>
>>> filefield="tdFile" nameconflict="overwrite">
>>
>>> variable="fileData">
>>
>>
>>
>>
>>
>>
>>
>>> delimiters="#chr(9)#">
>>
>>
>>
>>
>>
>>INSERT INTO table (field1, field2, field3, field4, field5, 
>> field6, field7)
>>VALUES (
>>> value="#listgetat(listfix(record),2,chr(9))#" 
>> cfsqltype="cf_sql_varchar">,
>>> value="#listgetat(listfix(record),3,chr(9))#" 
>> cfsqltype="cf_sql_varchar">,
>>> value="#createODBCDateTime(listgetat(listfix(record),6,chr(9)))#" 
>> cfsqltype="cf_sql_date">,
>>> value="#listgetat(listfix(record),9,chr(9))#" 
>> cfsqltype="cf_sql_varchar">,
>>,
>>,
>>
>>)
>>
>>
>>


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299863
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Parsing Selected Parts of a CSV file

2008-02-25 Thread Steve Good
Ha!  ok, so ignore my question...  I was on the right track, I just 
forgot to specify my delimiters correctly in the loop tag.

~Steve
http://goodcf.instantspot.com/blog



Steve Good wrote:
> Hi Gang,
>
> About a year ago I wrote (with help from this list) a bit of code to 
> loop through a csv file and insert the data into my database.  I am 
> revisiting that code for a new project but there is a twist now.  
> Instead of putting all columns into their respective fields in the DB, 
> I want to grab only the columns I need from the CSV and ignore the 
> rest, then insert those selected columns into their DB fields.  I 
> thought by playing around with the index in the cfqueryparam I could 
> just have it look at the columns I wanted, obviously this isn't the 
> case.  Below is a sample of what I tried.  I now know that I have to 
> start the index at 1 and go up incrementally.  Anyone have an idea how 
> I could accomplish my task?
>
>
> filefield="tdFile" nameconflict="overwrite">
>
> variable="fileData">
>
>
>
>
>
>
>
> delimiters="#chr(9)#">
>
>
>
>
>
>INSERT INTO table (field1, field2, field3, field4, field5, 
> field6, field7)
>VALUES (
> cfsqltype="cf_sql_varchar">,
> cfsqltype="cf_sql_varchar">,
> value="#createODBCDateTime(listgetat(listfix(record),6,chr(9)))#" 
> cfsqltype="cf_sql_date">,
> cfsqltype="cf_sql_varchar">,
>,
>,
>
>)
>
>
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299861
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Parsing Selected Parts of a CSV file

2008-02-25 Thread Steve Good
Hi Gang,

About a year ago I wrote (with help from this list) a bit of code to 
loop through a csv file and insert the data into my database.  I am 
revisiting that code for a new project but there is a twist now.  
Instead of putting all columns into their respective fields in the DB, I 
want to grab only the columns I need from the CSV and ignore the rest, 
then insert those selected columns into their DB fields.  I thought by 
playing around with the index in the cfqueryparam I could just have it 
look at the columns I wanted, obviously this isn't the case.  Below is a 
sample of what I tried.  I now know that I have to start the index at 1 
and go up incrementally.  Anyone have an idea how I could accomplish my 
task?


















INSERT INTO table (field1, field2, field3, field4, field5, 
field6, field7)
VALUES (
,
,
,
,
,
,

)



-- 

~Steve
http://goodcf.instantspot.com/blog


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299846
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Getting the difference between two times

2008-02-18 Thread Steve Good
Thanks! This helped me greatly!

~Steve
http://goodcf.instantspot.com/blog



Greg Morphis wrote:
> Not sure this is the most efficient but you could do something like:
>
> 
> 
>
> #fooDate# | #gooDate#
>
> 
>
> 
> 
> 
> 
> 
> 
> 
>
>
> 
> #fDate#
> days = #days#
> hoursfull = #hoursfull#
> hours = #hours#
> minsfull = #minsfull#
> mins = #mins#
> secsfull = #secsfull# 
> secs = #secs#
> 
>
>
> On Feb 18, 2008 6:05 PM, Steve Good <[EMAIL PROTECTED]> wrote:
>   
>> Hi gang,
>>
>> I am trying to evaluate the time elapsed between two stored ODBC dates.
>> I thought that dateDiff() would be my answer, but I get some very
>> strange results with the code I thought would work.  I have never used
>> dateDiff() before so perhaps I am doing something wrong.  Here is the
>> code I thought would work.  If anyone knows what I did wrong please let
>> me know.  Thanks!
>>
>> 
>> 
>> 
>> 
>> 
>> #cleanUp.winOpenTime# - #cleanUp.winCloseTime# = #evaluatedTime#
>> 
>>
>> --
>>
>> ~Steve
>> http://goodcf.instantspot.com/blog
>>
>>
>>
>> 
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299320
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Getting the difference between two times

2008-02-18 Thread Steve Good
Hi gang,

I am trying to evaluate the time elapsed between two stored ODBC dates.  
I thought that dateDiff() would be my answer, but I get some very 
strange results with the code I thought would work.  I have never used 
dateDiff() before so perhaps I am doing something wrong.  Here is the 
code I thought would work.  If anyone knows what I did wrong please let 
me know.  Thanks!






#cleanUp.winOpenTime# - #cleanUp.winCloseTime# = #evaluatedTime#


-- 

~Steve
http://goodcf.instantspot.com/blog


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299314
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: OT: Looking for Email provider

2008-02-16 Thread Steve Good
I ran my own Exchange 2005 server for a couple of years, but recently 
changed my MX to point to gmail.  So far everything is great as far as 
mail is concerned, but I do miss the extra exchange features sometimes.  
No calendar, or tasks in my client (thunderbird) but these things are 
available through the gmail interface or through plugins in your 
client.  If you are using Outlook then you will have these features 
still, but obviously won't be able to leverage them through Exchange.  
It's a toss up really.  If you don't want those things or don't care 
about collaboration through the desktop client then gmail might be a 
great fit as a mail exchanger.

That's my $.02 anyway.

~Steve
http://goodcf.instantspot.com/blog



Michael David wrote:
> Hello all
>
> Sorry for the off-topic thread, but my guess is that there are others
> here who have faced this same decision.
>
> I am considering outsourcing the email services I provide to my various 
> clients.
> Exchange 2007 would be nice, but not necessary.
>
> Any suggestions?
>
>   

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299200
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT: ThickBox (JQuery)

2008-02-14 Thread Steve Good
Aha!  This is even easier!  Thanks again!

~Steve



Matt Williams wrote:
> Steve, as for modal,
> add modal=true and clicking the parent is disabled. Though you will
> need to add a button or link that calls tb_remove() or you can't exit
> it all.
>
> I haven't tried any dragging. The sources the others have mentioned
> will be best for that and future questions.
>
> Matt
>
> On Thu, Feb 14, 2008 at 9:37 PM, Rey Bango <[EMAIL PROTECTED]> wrote:
>   
>> No prob. Just so you know, I'm part of the jQuery team and I troll here
>>  often. If you need something, feel free to email me directly.
>>
>>  Rey
>>
>>
>>
>>  Steve Good wrote:
>>  > Thanks Rey.  That might be exactly what I need.
>>  >
>>  > ~Steve
>>  >
>>  >
>>  >
>>  > Rey Bango wrote:
>>  >> Steve,
>>  >>
>>  >> Check out http://dev.iceburg.net/jquery/jqModal/
>>  >>
>>  >> Rey...
>>  >>
>>  >> Steve Good wrote:
>>  >>
>>  >>> I gave up on the CF8 bundled AJAX libraries and moved on to JQuery.  I
>>  >>> decided to use ThickBox for my modal window needs, but I've noticed some
>>  >>> differences between thickbox and cfwindow.
>>  >>>
>>  >>> 1.  ThickBox is not modal in the same way that cfwindow is.  It fades
>>  >>> out the parent layer, but unlike cfwindow, I can exit the thickbox by
>>  >>> clicking in the faded area.  With cfwindow my interaction is limited to
>>  >>> just the modal window.  Is there a way to accomplish the same thing in
>>  >>> ThickBox?
>>  >>>
>>  >>> 2.  I can't figure out how to make the thickbox window draggable like
>>  >>> cfwindow.  Is this something that is possible with thickbox?
>>  >>>
>>  >>> I know this isn't directly related to CF, but I am at a loss for places
>>  >>> to ask.  If anyone knows of a list or forums where these kinds of
>>  >>> questions would be more appropriate to ask please let me know :)
>>  >>>
>>  >>> Thanks!
>>  >>>
>>  >>
>> 
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299052
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT: ThickBox (JQuery)

2008-02-14 Thread Steve Good
Thanks Rey.  That might be exactly what I need.

~Steve



Rey Bango wrote:
> Steve,
>
> Check out http://dev.iceburg.net/jquery/jqModal/
>
> Rey...
>
> Steve Good wrote:
>   
>> I gave up on the CF8 bundled AJAX libraries and moved on to JQuery.  I 
>> decided to use ThickBox for my modal window needs, but I've noticed some 
>> differences between thickbox and cfwindow.
>>
>> 1.  ThickBox is not modal in the same way that cfwindow is.  It fades 
>> out the parent layer, but unlike cfwindow, I can exit the thickbox by 
>> clicking in the faded area.  With cfwindow my interaction is limited to 
>> just the modal window.  Is there a way to accomplish the same thing in 
>> ThickBox?
>>
>> 2.  I can't figure out how to make the thickbox window draggable like 
>> cfwindow.  Is this something that is possible with thickbox?
>>
>> I know this isn't directly related to CF, but I am at a loss for places 
>> to ask.  If anyone knows of a list or forums where these kinds of 
>> questions would be more appropriate to ask please let me know :)
>>
>> Thanks!
>> 
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299046
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


OT: ThickBox (JQuery)

2008-02-14 Thread Steve Good
I gave up on the CF8 bundled AJAX libraries and moved on to JQuery.  I 
decided to use ThickBox for my modal window needs, but I've noticed some 
differences between thickbox and cfwindow.

1.  ThickBox is not modal in the same way that cfwindow is.  It fades 
out the parent layer, but unlike cfwindow, I can exit the thickbox by 
clicking in the faded area.  With cfwindow my interaction is limited to 
just the modal window.  Is there a way to accomplish the same thing in 
ThickBox?

2.  I can't figure out how to make the thickbox window draggable like 
cfwindow.  Is this something that is possible with thickbox?

I know this isn't directly related to CF, but I am at a loss for places 
to ask.  If anyone knows of a list or forums where these kinds of 
questions would be more appropriate to ask please let me know :)

Thanks!
-- 

~Steve


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299035
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Auto Updating a CFDiv

2008-02-12 Thread Steve Good
How would I go about auto updating a cfdiv?  I tried the method Ray laid 
out in his blog posting "Building an 'auto refresh' div with ColdFusion 8."

http://www.coldfusionjedi.com/index.cfm/2007/7/19/Building-an-auto-refresh-div-with-ColdFusion-8

  It works for the most part, but I have two problems with his 
approach.  I need the update to look seamless, instant and also be 
triggerable.  Ie., when I close the cfwindow that pertains to the link I 
am clicking I want to trigger an update.  I also want it to reflect 
changes that other users may have made despite the current user's 
actions.  And I don't want to see the "Loading..." animation.

Also, I have cfwindows in my cfdiv.  Each time the div reloads using 
Ray's method CF complains about duplicate named cfwindow instances.  I 
am creating a cfwindow for each record returned from a query and naming 
the cfwindow instances dynamically based on the row ID number returned 
for each record.  I'm sure there is a better way to do this, but I 
haven't figured it out yet.

All this AJAX is making my head hurt :-p  I'm wishing I had done more 
with javascript way back when!

Thanks for all the help, y'all rock!

~Steve

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298826
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: passing URL variables to a cfwindow

2008-02-12 Thread Steve Good
Ok, I have my initial problem solved with passing data to my cfwindow.  
Thanks for the help!  Starting a new thread for the next road block I am 
having.

~Steve

Steve Good wrote:
> This definitely got me going in the right direction, however, I am 
> still having trouble with this.
>
> Here is what I am trying to do. 
>
> I have a page that is populated by looping through a query.  I am 
> showing an image dynamically based on the data returned by the query.  
> When a user clicks the image it shows the details of the query in a 
> cfwindow.  I have a "Close Window" button that closes the window by 
> calling the ColdFusion.Window.hide() function.  I also need the button 
> to run a query that changes the data in the same table that was being 
> queried to get the data, then update the parent page to reflect the 
> change without an actual page refresh.
>
> I sort-of have this working, but I run into a few snafus when trying 
> to update the parent page.  I was using a third party's ajax to 
> refresh the info in a div tag, but when I do this I end up with a 
> duplicate page embedded inside the parent page.  Is there an "easier" 
> way than the way I am doing it?  I can provide source code if needed 
> for clarification.
>
> Thanks!
>
> ~Steve
>
> Don L wrote:
>> Yes, the simpliest way looks like this
>> 
>>
>> But probaby you were looking for something more complexed?  Yes?  Like from 
>> cfpod or another cfwindow?  And that's doable as well.  The problem in my 
>> experience lies in multiple browser support, for instance, for the CFWINDOW 
>> tag, for the type of "Tab", I don't know if Adobe have done extensive 
>> testing with Firefox and Safari, IE7 works well while the other two not.
>>
>>   
>>> Is it possible to pass variables through the URL scope to a cfwindow?  
>>> If so, how?
>>>
>>> Thanks!  :)
>>> -- 
>>>
>>> ~Steve 
>>> 
>>
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298821
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: passing URL variables to a cfwindow

2008-02-12 Thread Steve Good
This definitely got me going in the right direction, however, I am still 
having trouble with this.

Here is what I am trying to do. 

I have a page that is populated by looping through a query.  I am 
showing an image dynamically based on the data returned by the query.  
When a user clicks the image it shows the details of the query in a 
cfwindow.  I have a "Close Window" button that closes the window by 
calling the ColdFusion.Window.hide() function.  I also need the button 
to run a query that changes the data in the same table that was being 
queried to get the data, then update the parent page to reflect the 
change without an actual page refresh.

I sort-of have this working, but I run into a few snafus when trying to 
update the parent page.  I was using a third party's ajax to refresh the 
info in a div tag, but when I do this I end up with a duplicate page 
embedded inside the parent page.  Is there an "easier" way than the way 
I am doing it?  I can provide source code if needed for clarification.

Thanks!

~Steve

Don L wrote:
> Yes, the simpliest way looks like this
> 
>
> But probaby you were looking for something more complexed?  Yes?  Like from 
> cfpod or another cfwindow?  And that's doable as well.  The problem in my 
> experience lies in multiple browser support, for instance, for the CFWINDOW 
> tag, for the type of "Tab", I don't know if Adobe have done extensive testing 
> with Firefox and Safari, IE7 works well while the other two not.
>
>   
>> Is it possible to pass variables through the URL scope to a cfwindow?  
>> If so, how?
>>
>> Thanks!  :)
>> -- 
>>
>> ~Steve 
>> 
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298800
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: passing URL variables to a cfwindow

2008-02-09 Thread Steve Good
No luck yet, but the other person working on the code may have found a  
solution.  I have not yet seen the code yet though.

~Steve

On Feb 9, 2008, at 8:56 AM, "Jose Diaz" <[EMAIL PROTECTED]> wrote:

> any luck on this steve? I noticed the same problem but have not had  
> time to
> delve any deeper.
>
> Jose
>
> On Feb 9, 2008 12:54 AM, Steve Good <[EMAIL PROTECTED]> wrote:
>
>> Is it possible to pass variables through the URL scope to a cfwindow?
>> If so, how?
>>
>> Thanks!  :)
>> --
>>
>> ~Steve
>>
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298622
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


passing URL variables to a cfwindow

2008-02-08 Thread Steve Good
Is it possible to pass variables through the URL scope to a cfwindow?  
If so, how?

Thanks!  :)
-- 

~Steve


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298601
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Flash Form Masking and Required Attribute

2007-11-30 Thread Steve Good
I am building a flash form and everything is going fine, but I am running
into an annoyance.  In my cfinput tags I am setting the mask attribute and
the required attribute.  This seems to flag the field as incorrectly input
and highlights it with a red box and popup.  Is there anyway to change this
behavior? Below is a snippet of my form.

Thanks in advance,
Steve
























~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294037
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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.


li {margin-left:25px;}


SHOW TABLES





#tables_in_datasource#


SHOW COLUMNS
FROM #tables_in_datasource#



#field#
Key: #key#
Null: #null#
Type: #type#
Default: #default#





Casey Dougall wrote:
> 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 trying to do is create a printable database structure
>> list without the row data.
>>
>> Thanks in advance!
>> ~Steve Good
>>
>> 
> Coldfusion 8...
>
> 
>
> 
>
> 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293548
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 without the row data.

Thanks in advance!
~Steve Good

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293545
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: [OT] Populating a MySQL Database from Active Directory

2007-10-27 Thread Steve Good
Cool!  Thank you so much!


Ryan, Terrence wrote:
> I'll clean it up and send it to this weekend.
>
> Terrence Ryan
> I.T. Director
> Wharton Computing and Information Technology?? 
> E-mail: ??? [EMAIL PROTECTED]
>
>
> -----Original Message-
> From: Steve Good [mailto:[EMAIL PROTECTED] 
> Sent: Friday, October 26, 2007 9:03 PM
> To: CF-Talk
> Subject: Re: [OT] Populating a MySQL Database from Active Directory
>
> I would LOVE to see this!  Thank you for the offer!
>
> On 10/26/07, Ryan, Terrence <[EMAIL PROTECTED]> wrote:
>   
>> I have some code that can pull down the entire contents of an active
>> directory domain from ldap.
>>
>> From there you could do anything you want with it.  (Including inserting
>> it into mysql. )
>>
>> Care for a look?
>>
>> Terrence Ryan
>> I.T. Director
>> Wharton Computing and Information Technology
>> E-mail: [EMAIL PROTECTED]
>>
>>
>>
>> -Original Message-
>> From: Steve Good [mailto:[EMAIL PROTECTED]
>> Sent: Friday, October 26, 2007 4:54 PM
>> To: CF-Talk
>> Subject: [OT] Populating a MySQL Database from Active Directory
>>
>> I have an internal app that is working pretty well.  Users log in using
>> credentials stored in Active Directory and the App runs on a MySQL DB.  As
>> I
>> expand the app I find I am running into problems with talking to AD.  My
>> bigest issue is with my Dev Enviro.  I have to code in a way to circumvent
>> checking usernames and passwords against AD and pull them from a DB
>> instead.  This is a pain and ends up adding a ton of extra lines to
>> maintain.  Is there a way to populate the database from info stored in AD
>> and then keep it synchronized?  I'd love to keep my user info stored in
>> the
>> DB since that would let me start developing my app without worrying about
>> where the app is running.
>>
>> Thanks yall.
>>
>> ~Steve
>>
>>
>>
>>
>>
>> 
>
>
>
> 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292188
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: [OT] Populating a MySQL Database from Active Directory

2007-10-26 Thread Steve Good
I would LOVE to see this!  Thank you for the offer!

On 10/26/07, Ryan, Terrence <[EMAIL PROTECTED]> wrote:
>
> I have some code that can pull down the entire contents of an active
> directory domain from ldap.
>
> From there you could do anything you want with it.  (Including inserting
> it into mysql. )
>
> Care for a look?
>
> Terrence Ryan
> I.T. Director
> Wharton Computing and Information Technology
> E-mail: [EMAIL PROTECTED]
>
>
>
> -Original Message-
> From: Steve Good [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 26, 2007 4:54 PM
> To: CF-Talk
> Subject: [OT] Populating a MySQL Database from Active Directory
>
> I have an internal app that is working pretty well.  Users log in using
> credentials stored in Active Directory and the App runs on a MySQL DB.  As
> I
> expand the app I find I am running into problems with talking to AD.  My
> bigest issue is with my Dev Enviro.  I have to code in a way to circumvent
> checking usernames and passwords against AD and pull them from a DB
> instead.  This is a pain and ends up adding a ton of extra lines to
> maintain.  Is there a way to populate the database from info stored in AD
> and then keep it synchronized?  I'd love to keep my user info stored in
> the
> DB since that would let me start developing my app without worrying about
> where the app is running.
>
> Thanks yall.
>
> ~Steve
>
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292177
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


[OT] Populating a MySQL Database from Active Directory

2007-10-26 Thread Steve Good
I have an internal app that is working pretty well.  Users log in using
credentials stored in Active Directory and the App runs on a MySQL DB.  As I
expand the app I find I am running into problems with talking to AD.  My
bigest issue is with my Dev Enviro.  I have to code in a way to circumvent
checking usernames and passwords against AD and pull them from a DB
instead.  This is a pain and ends up adding a ton of extra lines to
maintain.  Is there a way to populate the database from info stored in AD
and then keep it synchronized?  I'd love to keep my user info stored in the
DB since that would let me start developing my app without worrying about
where the app is running.

Thanks yall.

~Steve


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292170
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: converting sql scripts

2007-09-25 Thread Steve Good
I'm actually trying to convert the script that came with cf_shopkart.  I 
did do a dump from mysql after altering some of the table names.  I'll 
poke around and see if I can get it to format the way I want it.

Rick Root wrote:
> On 9/25/07, Steve Good <[EMAIL PROTECTED]> wrote:
>   
>> does anyone know a good tool for converting a mysql script to a mssql
>> script?  I started doing this by hand but with over 12,000 errors being
>> thrown by mssql I don't think I have the stamina to undertake the job.
>> 
>
> Are you trying to convert something generated by mysqldump?
>
> mysqldump *DOES* have some arguments for targeting specific databases
> with its output, including I think, SQL Server.
>
>   

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289473
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


converting sql scripts

2007-09-25 Thread Steve Good
does anyone know a good tool for converting a mysql script to a mssql 
script?  I started doing this by hand but with over 12,000 errors being 
thrown by mssql I don't think I have the stamina to undertake the job.

I'm looking for something free if possible since I won't be using it 
very often (if ever again)

Thanks in advance!
~Steve

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289459
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Not getting emails

2007-09-23 Thread Steve Good
>Steve Good wrote:
>> Anyone know who I should send an email to if I have not received any of 
>> the emails from the list since 9/6/07?
>
>Since everybody else receives your email you are still properly 
>subscribed and the problem is most likely on your end. I would suggest 
>starting with the email administrator of lanctr.com.
>
>Jochem

I'm the admin for the domain.   So I know that  I should still be getting 
messages.  I'll just keep going to the website for updates.  thanks for the 
reply though.

~Steve 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289245
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Not getting emails

2007-09-23 Thread Steve Good
nobody knows?

>Anyone know who I should send an email to if I have not received any of 
>the emails from the list since 9/6/07?
>
>I've already tried to unsubscribe and then subscribe again, but that 
>didn't change anything.
>
>Thanks!
>~Steve 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289238
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Not getting emails

2007-09-22 Thread Steve Good
Anyone know who I should send an email to if I have not received any of 
the emails from the list since 9/6/07?

I've already tried to unsubscribe and then subscribe again, but that 
didn't change anything.

Thanks!
~Steve

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289202
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Integrating blog / gallery / imagecfc / shopping cart

2007-09-17 Thread Steve Good
>By "Gallery" do you mean like a photo gallery?  BlogCFM actually does
>photo galleries.
>
>Not saying I'm recommending it, but if you're willing to customize,
>the functionality is already in there.
>
>rick
>
>-- 
>Rick Root
>Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
>www.opensourcecf.com

Thanks Rick,

I didn't realize there was a gallery function in BlogCFM.  I'm more than 
willing to customize.  I'm trying to put a standard package together so I can 
just apply some CSS changes and make life easy for myself when putting up new 
sites.

~steve 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288584
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Integrating blog / gallery / imagecfc / shopping cart

2007-09-15 Thread Steve Good
Ok,

So I have decided to integrate Rick's BlogCFM, and ImageCFC with a 
gallery and shopping cart.  But before I start this, does anyone have 
any recommendations for the shopping cart and gallery I should use?  I'm 
looking for something open source of course, and something that should 
be moderately easy to integrate.  Once I finish I'm hoping to be able to 
apply one CSS sheet, and have one database running the whole thing.  Any 
suggestions or success stories?

Thanks!
~Steve

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288526
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Incident Tracking

2007-07-20 Thread Steve Good
I thought lighthousepro was more for bug tracking, am I wrong?  I'm 
looking for something that can be used for Tech Support Call Tracking 
and for other support issues (non-technical).

Dan Vega wrote:
> We just started using lighthouse and I am liking everything so far!
>
> http://lighthousepro.riaforge.org/
>
>
> On 7/20/07, Steve Good <[EMAIL PROTECTED]> wrote:
>   
>> Hey Gang,
>>
>> Before I go and put a project together, thought I would ask if something
>> like this already exists.
>>
>> My support team needs a way to track various support incidents
>> throughout the company.  The only solutions I have seen were outdated
>> PHP apps.  The one I found that seemed to have the most promise is not
>> working the way I want it to.  Besides, I'm already running CF7, so I'd
>> like to leverage that to my benefit.
>>
>> Thanks in advance,
>>
>> Steve Good
>>
>>
>> 
>
> 

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284261
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Incident Tracking

2007-07-20 Thread Steve Good
Hey Gang,

Before I go and put a project together, thought I would ask if something 
like this already exists.

My support team needs a way to track various support incidents 
throughout the company.  The only solutions I have seen were outdated 
PHP apps.  The one I found that seemed to have the most promise is not 
working the way I want it to.  Besides, I'm already running CF7, so I'd 
like to leverage that to my benefit.

Thanks in advance,

Steve Good

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284251
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


cfeclipse tutorial

2007-07-02 Thread Steve Good
Anyone have any links to some good cfeclipse tutorials?  I am looking 
for a good alternative to Dreamweaver on Linux and cfeclipse seemed to 
be the right direction.  I have installed eclipse, cfeclipse, and the 
flex builder plugin to give me RDS capability, but I'm lost now hehe.

Thanks in advance!

~Steve

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282753
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Cfmail Authentication

2007-06-25 Thread Steve Good
true. I've never NOT had access, so i just assume everyone does. I know 
that not everyone has access. *dances back off into his own little world*

Steve Good
[EMAIL PROTECTED]



Andrew Scott wrote:
> Steve,
>
> Only good if you have access to the Administrator in the first place.
>
>
> On 6/25/07, Steve Good <[EMAIL PROTECTED]> wrote:
>   
>> in the past i found it easiest to just set set the parameters for cfmail
>> in the CF Administrator ( username:[EMAIL PROTECTED] ). You can
>> define the port there as well.
>>
>> Steve Good
>> [EMAIL PROTECTED]
>>
>>
>>
>> Glenn OConnor wrote:
>> 
>>> Hi there,
>>>
>>> Im trying to send mail via my hosting account. The only problem is there
>>>   
>> SMTP server is running on port 587, and requires authentication via username
>> and password ..
>> 
>>> Would this work?
>>>
>>>
>>> >>   
>> password="password" subject="I like this" server="mail.go-systems.co.za"
>> port="587">
>> 
>>> test
>>> 
>>>
>>>
>>>   
>> 
>
> 

~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282037
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Cfmail Authentication

2007-06-24 Thread Steve Good
in the past i found it easiest to just set set the parameters for cfmail 
in the CF Administrator ( username:[EMAIL PROTECTED] ). You can 
define the port there as well.

Steve Good
[EMAIL PROTECTED]



Glenn OConnor wrote:
> Hi there,
>
> Im trying to send mail via my hosting account. The only problem is there SMTP 
> server is running on port 587, and requires authentication via username and 
> password ..
>
> Would this work?
>
>
>  password="password" subject="I like this" server="mail.go-systems.co.za" 
> port="587">
> test
> 
>
> 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281985
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Why images en Tutorial does not show in my page as I learn?

2007-06-20 Thread Steve Good
Without looking at the tutorial code.

You may want to look and see what document is calling the images.  
Images are relative to the document.  Ie if I cfinclude a document from 
/includes which is on the same level as the /images directory and i call 
images/image.gif then the web browser is going to try to find the image 
in /includes/images/image.gif.  You may want to change the image src to 
/images/image.gif instead of images/image.gif.  This will tell the 
browser to look for the /images directory in the root of the application.

Just a thought :)

Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



Luis Octavio Galdames Hidalgo wrote:
> I am learning to program CFML following the Compass Travel example.
> I am following the lessons pretty well, obtaining the expected results, but...
> The lessons show a page with images for bottons, located in 
> /my_app/images/last.jpg
> I used  and also
>  but my page only shows the square where 
> the image should be...  Am I missign some configuration?
>
> 

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281637
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cfabort triggering onError function in Application.cfc

2007-06-13 Thread Steve Good
Thanks for the help guys, I got it working using Jake's cfif statement.  
Sometimes it's the simple things that throw me off hehe.

-- 
Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com


~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281097
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


cfabort triggering onError function in Application.cfc

2007-06-12 Thread Steve Good
I'm trying to catch errors and display them in a prettier way on one of 
my applications.  However part of the login script I use has a  
tag in it to stop processing until the user is authenticated.  Since I 
implemented the onError function in my Application.cfc the cfabort seems 
to be triggering it.  Is this normal?  if so how do I work around this?

Thanks!

-- 
Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com


~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280893
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Session timeouts with ntauthenticate and cflogin

2007-06-03 Thread Steve Good
nobody has any ideas?  *pouts*  Anyone have any links or able to tell me 
where in the CFWACK or CF Advanced books I should look?  I am truly 
stumped on this.

~Steve

Steve Good wrote:
> Sorry if anyone's mail to me was bounced back, stupid VPN connection 
> tricked DynDNS updater for my home network and reported the wrong 
> external IP.  *grumbles* should be fine now though.
>
> Steve Good
> [EMAIL PROTECTED]
> Portal Hosting
> http://www.lanctr.com
>
>
>
> Steve Good wrote:
>   
>> Hi gang,
>>
>> I using a login script in my Application.cfc that authenticates using 
>> cfntauthenticate to verify username password, then use cflogin to 
>> actually login to the site.  I use session variables throughout the 
>> site to determine what users can and can't access.  The problem I am 
>> running into is with session time outs and trying to login from more 
>> than one location.  For instance, I have session variables set to 
>> time-out after 1 hour.  However, the user stays logged into the system 
>> even after the session variables have been trashed, and because of 
>> this the site generates errors unless they actually pass a ?logout=1 
>> parameter through the URL.
>>
>> On my old site I was not authenticating against an Active Directory, 
>> and just using queries to verify login credentials.  I had no problems 
>> with session variables, and if the user was inactive for X number of 
>> minutes the script would kick them back to the login screen.
>>
>> How would I do this using cflogin and cfntauthenticate?  Below are 
>> snippets of my Application.cfc.
>>
>> Thanks for any help in advance!
>>
>> --Truncated --
>> 
>
> 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279959
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Session timeouts with ntauthenticate and cflogin

2007-06-01 Thread Steve Good
Sorry if anyone's mail to me was bounced back, stupid VPN connection 
tricked DynDNS updater for my home network and reported the wrong 
external IP.  *grumbles* should be fine now though.

Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



Steve Good wrote:
> Hi gang,
>
> I using a login script in my Application.cfc that authenticates using 
> cfntauthenticate to verify username password, then use cflogin to 
> actually login to the site.  I use session variables throughout the 
> site to determine what users can and can't access.  The problem I am 
> running into is with session time outs and trying to login from more 
> than one location.  For instance, I have session variables set to 
> time-out after 1 hour.  However, the user stays logged into the system 
> even after the session variables have been trashed, and because of 
> this the site generates errors unless they actually pass a ?logout=1 
> parameter through the URL.
>
> On my old site I was not authenticating against an Active Directory, 
> and just using queries to verify login credentials.  I had no problems 
> with session variables, and if the user was inactive for X number of 
> minutes the script would kick them back to the login screen.
>
> How would I do this using cflogin and cfntauthenticate?  Below are 
> snippets of my Application.cfc.
>
> Thanks for any help in advance!
>
> --Truncated --

~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279895
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Session timeouts with ntauthenticate and cflogin

2007-06-01 Thread Steve Good
Hi gang,

I using a login script in my Application.cfc that authenticates using 
cfntauthenticate to verify username password, then use cflogin to 
actually login to the site.  I use session variables throughout the site 
to determine what users can and can't access.  The problem I am running 
into is with session time outs and trying to login from more than one 
location.  For instance, I have session variables set to time-out after 
1 hour.  However, the user stays logged into the system even after the 
session variables have been trashed, and because of this the site 
generates errors unless they actually pass a ?logout=1 parameter through 
the URL.

On my old site I was not authenticating against an Active Directory, and 
just using queries to verify login credentials.  I had no problems with 
session variables, and if the user was inactive for X number of minutes 
the script would kick them back to the login screen.

How would I do this using cflogin and cfntauthenticate?  Below are 
snippets of my Application.cfc.

Thanks for any help in advance!

- Application.cfc Snippet -











  
  https://#CGI.SERVER_NAME#/";>







  
  
  
  
  
  
  
  
  
  
  
   



SELECT *
FROM logins
WHERE UserName = '#theusername#'

   



INSERT INTO logins (UserName, AccountType, CashRec)
VALUES ('#theusername#', 1, 0)


SELECT *
FROM logins
WHERE UserName = '#theusername#'





















  

The password for#theusername#is not correct
  Please Try again


The user name#theusername#is not valid
  Please Try again
  
    


  
















-- 
Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com


~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279893
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFMyAdmin

2007-05-13 Thread Steve Good
Anybody?  I'm trying to find a tool to manage my MySQL server remotely 
with the same ease phpMyAdmin provides.  Any push in the right direction 
would be great.  I would install php, but I want to keep my server 
overhead to a minimum.

Steve Good wrote:
> Has CFMyAdmin disappeared?  The cfmyadmin.com site says there is no site 
> configured for that domain.  Has it moved or is there something else out 
> there that is similar?
>
> Thanks!
> Steve
>
> 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277983
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFMyAdmin

2007-05-10 Thread Steve Good
Has CFMyAdmin disappeared?  The cfmyadmin.com site says there is no site 
configured for that domain.  Has it moved or is there something else out 
there that is similar?

Thanks!
Steve

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277676
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Flex and Coldfusion

2007-05-08 Thread Steve Good
I'm playing around with Flex and was wondering if there was a place with 
some nice tutorials showing how to integrate CF with Flex.  Anyone have 
any URLs to some tutorials?

Thanks!

~Steve

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277318
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Windows 2003 Service Pack 2 has been released

2007-03-15 Thread Steve Good
I have SP2 installed and running and haven't noticed anything bad.  In 
fact, I was finally able to get Darwin Streaming Server up and running 
on it!

Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



Paul Vernon wrote:
> I didn't realise that it was coming out so soon and yet, here it is!
>
> http://www.microsoft.com/technet/windowsserver/sp2.mspx
>
> I'm installing it on our dev server for testing so I'll let you know if we
> have *any* problems with CF after that...
>
> Paul
>
>
>
>
> 

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272721
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Getting file name after uploading

2007-03-09 Thread Steve Good
Thanks!

Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



Charlie Griefer wrote:
> look into the various attributes of the  element.
>
> On 3/9/07, Steve Good <[EMAIL PROTECTED]> wrote:
>   
>> Thanks for the answers.  I found the doc just after I sent the email.  I
>> do wonder, however, if there is a way to restrict the file types the
>> user is allowed to browse for (ie. they can only see .mov files) after
>> clicking browse.  I see that I can restrict the file types once the form
>> has been submitted, but that doesn't really stop a user from trying to
>> upload any file type they see fit to send.
>>
>> Steve Good
>> [EMAIL PROTECTED]
>> Portal Hosting
>> http://www.lanctr.com
>>
>>
>>
>> Steve Good wrote:
>> 
>>> I'm putting together a form for users to upload video files of our
>>> lectures realized I wasn't entirely sure how to go about getting the
>>> file name of the file that's being put to the server.  I want to add the
>>> file name into the database without having the user manually enter the
>>> file name in a form field.  I haven't really started looking around the
>>> web yet, but plan to as soon as this gets sent out.
>>>
>>> TIA
>>>
>>>
>>>   
>> 
>
> 

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272254
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Getting file name after uploading

2007-03-09 Thread Steve Good
Thanks for the answers.  I found the doc just after I sent the email.  I 
do wonder, however, if there is a way to restrict the file types the 
user is allowed to browse for (ie. they can only see .mov files) after 
clicking browse.  I see that I can restrict the file types once the form 
has been submitted, but that doesn't really stop a user from trying to 
upload any file type they see fit to send.

Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



Steve Good wrote:
> I'm putting together a form for users to upload video files of our 
> lectures realized I wasn't entirely sure how to go about getting the 
> file name of the file that's being put to the server.  I want to add the 
> file name into the database without having the user manually enter the 
> file name in a form field.  I haven't really started looking around the 
> web yet, but plan to as soon as this gets sent out.
>
> TIA
>
>   

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272251
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Getting file name after uploading

2007-03-09 Thread Steve Good
I'm putting together a form for users to upload video files of our 
lectures realized I wasn't entirely sure how to go about getting the 
file name of the file that's being put to the server.  I want to add the 
file name into the database without having the user manually enter the 
file name in a form field.  I haven't really started looking around the 
web yet, but plan to as soon as this gets sent out.

TIA

-- 
Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com


~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272231
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFMBB 1.20 Beta

2007-02-27 Thread Steve Good
I would imagine that you could use a mysql to access conversion tool... 
but the download doesn't have an access database in the installation folder.

Tool the converts mysql to an mdb file.
http://www.programurl.com/mysql-to-access.htm

You might give that a try, I don't know what kind of problems you might 
run into though.

Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



Walter Conti wrote:
> Does CFMBB 1.2 SUPPORT MSAccess?
> Walter Conti
>
> -Original Message-----
> From: Steve Good [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, February 27, 2007 9:04 AM
> To: CF-Talk
> Subject: Re: CFMBB 1.20 Beta
>
> I know there's MySQL support in v1.11 and I would assume that Rick would 
> continue that trend, but who knows.  *shrugs*
>
> Steve Good
> [EMAIL PROTECTED]
> Portal Hosting
> http://www.lanctr.com
>
>
>
> Dwayne Cole wrote:
>   
>> What about mySQL support?
>>
>> -- Original Message --
>> From: "Rick Root" <[EMAIL PROTECTED]>
>> Reply-To: cf-talk@houseoffusion.com
>> Date:  Tue, 27 Feb 2007 04:11:03 -0500
>>
>>   
>> 
>>> I just blogged about this, but wanted to share with cf-talk as well...
>>>
>>> CFMBB 1.20 is in beta now!  It includes many new features, including
>>>   
> support
>   
>>> for user groups, restricting forum access to specific user groups,
>>> integration of the CFOpenChat chat software, addition of basic content
>>> management features with integrated file manager (CFFM).
>>>
>>> Themes have been "simplified" in that the navigation is no longer
>>>   
> included
>   
>>> in the header/footer pages.  Previous versions of the themes included
>>>   
> with
>   
>>> CFMBB used wrapping tables, which aren't used any more.
>>>
>>> Version 1.20 also includes several bug fixes, adds support for Bluedragon
>>>   
> 7
>   
>>> (they've implemented a new built-in CFML function called querySort, which
>>> was the name of one of the UDFs in CFMBB, so I had to change its name to
>>> qrySort)
>>>
>>> This is not an official release, but if you'd like to download the beta
>>>   
> for
>   
>>> testing, it's here:  www.cfmbb.org/cfmbb-1.20b.zip
>>>
>>> Check out the demo at http://demo.cfmbb.org - Username: admin, password:
>>> admin
>>>
>>> Rick
>>> -- 
>>> I'm not certified, but I have been told that I'm certifiable...
>>> Visit http://www.opensourcecf.com today!
>>>
>>>
>>>
>>> 
>>>   
>> 
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270817
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFMBB 1.20 Beta

2007-02-27 Thread Steve Good
I know there's MySQL support in v1.11 and I would assume that Rick would 
continue that trend, but who knows.  *shrugs*

Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



Dwayne Cole wrote:
> What about mySQL support?
>
> -- Original Message --
> From: "Rick Root" <[EMAIL PROTECTED]>
> Reply-To: cf-talk@houseoffusion.com
> Date:  Tue, 27 Feb 2007 04:11:03 -0500
>
>   
>> I just blogged about this, but wanted to share with cf-talk as well...
>>
>> CFMBB 1.20 is in beta now!  It includes many new features, including support
>> for user groups, restricting forum access to specific user groups,
>> integration of the CFOpenChat chat software, addition of basic content
>> management features with integrated file manager (CFFM).
>>
>> Themes have been "simplified" in that the navigation is no longer included
>> in the header/footer pages.  Previous versions of the themes included with
>> CFMBB used wrapping tables, which aren't used any more.
>>
>> Version 1.20 also includes several bug fixes, adds support for Bluedragon 7
>> (they've implemented a new built-in CFML function called querySort, which
>> was the name of one of the UDFs in CFMBB, so I had to change its name to
>> qrySort)
>>
>> This is not an official release, but if you'd like to download the beta for
>> testing, it's here:  www.cfmbb.org/cfmbb-1.20b.zip
>>
>> Check out the demo at http://demo.cfmbb.org - Username: admin, password:
>> admin
>>
>> Rick
>> -- 
>> I'm not certified, but I have been told that I'm certifiable...
>> Visit http://www.opensourcecf.com today!
>>
>>
>>
>> 
>
> 

~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270796
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFMBB 1.20 Beta

2007-02-27 Thread Steve Good
Looking good Rick!  I am using and heavily modding v1.11 right now.  I 
look forward to the final release of 1.20 :-)

Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



Rick Root wrote:
> I just blogged about this, but wanted to share with cf-talk as well...
>
> CFMBB 1.20 is in beta now!  It includes many new features, including support
> for user groups, restricting forum access to specific user groups,
> integration of the CFOpenChat chat software, addition of basic content
> management features with integrated file manager (CFFM).
>
> Themes have been "simplified" in that the navigation is no longer included
> in the header/footer pages.  Previous versions of the themes included with
> CFMBB used wrapping tables, which aren't used any more.
>
> Version 1.20 also includes several bug fixes, adds support for Bluedragon 7
> (they've implemented a new built-in CFML function called querySort, which
> was the name of one of the UDFs in CFMBB, so I had to change its name to
> qrySort)
>
> This is not an official release, but if you'd like to download the beta for
> testing, it's here:  www.cfmbb.org/cfmbb-1.20b.zip
>
> Check out the demo at http://demo.cfmbb.org - Username: admin, password:
> admin
>
> Rick
>   

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270794
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Coldfusion based Ecommerce with CMS software recomendation

2007-02-26 Thread Steve Good
can try cartweaver, seems to be a good product.
http://www.cartweaver.com/

Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



Jesse Beckton wrote:
> Hello,
>
> I am looking for some Coldfusion based ecommerce software to purchase. i am 
> looking for something with all the bells and whistles (like ablecommerce) but 
> I need something with good CMS capability as well.
>
> Any recommendations?
>
> 

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270719
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Good resource for finding CFML developer jobs...

2007-02-26 Thread Steve Good
I am looking to leave the company I am with, and wondering if there are 
any particularly good places to seek out CF employment.  The company I 
am with now only hired me as Tech Support, but now they are asking me to 
do some heavy CF development for less than I could make at McDonald's.  
Thanks for any suggestions!

-- 
Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com


~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270706
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF Pocket Reference?

2007-02-23 Thread Steve Good
removed the asterisks from the url

http://download.macromedia.com/pub/coldfusion/documentation/cfml_quick_ref.pdf



Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



mark wrote:
> That link doesn't seem to work for me.
>
> -Original Message-
> From: Casey Dougall [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 23, 2007 7:13 AM
> To: CF-Talk
> Subject: Re: CF Pocket Reference?
>
>
> Coldfusion MX came with a pocket ref. too.
>
> Printing it from PDF might not be what you're looking for but you can
> download it here.
>
> download.macromedia.com/pub/coldfusion/documentation/*cfml*_*quick*_ref.pdf
>
>
>
>
> 

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270606
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


  1   2   >