Re: AuthorizeNet Recurring Payments?

[Jim McAtee]

I looked through the linked AIM documentation and noticed the same thing. 
You need to be able to specify an interval and a duration, but there 
appears to be no way to do so.


- Original Message - 
From: "Josh Nathanson" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Thursday, January 12, 2006 11:29 PM
Subject: Re: AuthorizeNet Recurring Payments?


> H...when I talked to them recently, that x_billing_recurring 
> attribute
> was not being used...if you can use that, then where do you specify 
> other
> data, such as whether the recurring billing is every month, every other
> month, or every 12 months for example?  Also the starting and ending 
> date
> for the subscription? Look more closely at the AIM API fields and you 
> won't
> find anywhere to send that data.  Simply specifying x_billing_recurring
> yes|no would not be enough information to actually get the subscription 
> up
> and running.  I think they stuck that x_billing_recurring field in there 
> in
> hopes of setting up an API for recurring billing at some point, but it's 
> not
> doable at the moment.
>
> I think there are issues with changing subscriptions frequently, that 
> would
> be a disincentive for AuthNet to make recurring billing subscriptions
> accessible via an API, so they may never actually offer that capability.
>
> -- Josh Nathanson
>
>
>
> - Original Message - 
> From: "John C. Bland II" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Thursday, January 12, 2006 8:12 PM
> Subject: Re: AuthorizeNet Recurring Payments?
>
>
>> Yes, there is. Specify x_billing_recurring (Yes|No) when you send your
>> data
>> and it will setup the recurring payment. Look at the AIM guide on the
>> Auth.net site. Better yet, here's the location of the file.
>> 
>> http://www.authorize.net/support/AIM_guide.pdf
>>
>> On 1/12/06, Josh Nathanson <[EMAIL PROTECTED]> wrote:
>>>
>>> I've used the Authorize.net recurring payments for about six months, 
>>> and
>>> it
>>> works fine, but as of the last time I checked (a few months ago), 
>>> there's
>>> no
>>> API to interact with the recurring billing system -- only the single
>>> transactions.  You have to set up the subscriptions manually through
>>> their
>>> website forms. I think they do have a batch processing feature, where 
>>> you
>>> can upload multiple subscriptions from a flat file, but I haven't 
>>> looked
>>> into that feature personally, and I think you still have to do it 
>>> through
>>> the AN website, there's no API for that.
>>>
>>> -- Josh Nathanson
>>>
>>>
>>> - Original Message -
>>> From: "Jim McAtee" <[EMAIL PROTECTED]>
>>> To: "CF-Talk" 
>>> Sent: Thursday, January 12, 2006 5:20 PM
>>> Subject: AuthorizeNet Recurring Payments?
>>>
>>>
>>> > The CC thread reminded me of this...
>>> >
>>> > We've been using AuthorizeNet for many years and recently (well, in 
>>> > the
>>> > last couple of years, anyway) they began offering a means of doing
>>> > recurring payments.  It looks like these payment have to be set up
>>> > manually through forms on the AN web site, but I could be wrong. 
>>> > Does
>>> > anyone know if there's some kind of API that allows you to set up
>>> > recurring payments, halt them, check the success of transactions, 
>>> > etc.?
>>> > I'd like our sales associates to be able to set up these payments
>>> > themselves, but I don't want to give them administrative access to 
>>> > the
>>> > AuthorizeNet merchant login.


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

Re: AuthorizeNet Recurring Payments?

[Josh Nathanson]

H...when I talked to them recently, that x_billing_recurring attribute 
was not being used...if you can use that, then where do you specify other 
data, such as whether the recurring billing is every month, every other 
month, or every 12 months for example?  Also the starting and ending date 
for the subscription? Look more closely at the AIM API fields and you won't 
find anywhere to send that data.  Simply specifying x_billing_recurring 
yes|no would not be enough information to actually get the subscription up 
and running.  I think they stuck that x_billing_recurring field in there in 
hopes of setting up an API for recurring billing at some point, but it's not 
doable at the moment.

I think there are issues with changing subscriptions frequently, that would 
be a disincentive for AuthNet to make recurring billing subscriptions 
accessible via an API, so they may never actually offer that capability.

-- Josh Nathanson



- Original Message - 
From: "John C. Bland II" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Thursday, January 12, 2006 8:12 PM
Subject: Re: AuthorizeNet Recurring Payments?


> Yes, there is. Specify x_billing_recurring (Yes|No) when you send your 
> data
> and it will setup the recurring payment. Look at the AIM guide on the
> Auth.net site. Better yet, here's the location of the file.
> 
> http://www.authorize.net/support/AIM_guide.pdf
>
> On 1/12/06, Josh Nathanson <[EMAIL PROTECTED]> wrote:
>>
>> I've used the Authorize.net recurring payments for about six months, and
>> it
>> works fine, but as of the last time I checked (a few months ago), there's
>> no
>> API to interact with the recurring billing system -- only the single
>> transactions.  You have to set up the subscriptions manually through 
>> their
>> website forms. I think they do have a batch processing feature, where you
>> can upload multiple subscriptions from a flat file, but I haven't looked
>> into that feature personally, and I think you still have to do it through
>> the AN website, there's no API for that.
>>
>> -- Josh Nathanson
>>
>>
>> - Original Message -
>> From: "Jim McAtee" <[EMAIL PROTECTED]>
>> To: "CF-Talk" 
>> Sent: Thursday, January 12, 2006 5:20 PM
>> Subject: AuthorizeNet Recurring Payments?
>>
>>
>> > The CC thread reminded me of this...
>> >
>> > We've been using AuthorizeNet for many years and recently (well, in the
>> > last couple of years, anyway) they began offering a means of doing
>> > recurring payments.  It looks like these payment have to be set up
>> > manually through forms on the AN web site, but I could be wrong.  Does
>> > anyone know if there's some kind of API that allows you to set up
>> > recurring payments, halt them, check the success of transactions, etc.?
>> > I'd like our sales associates to be able to set up these payments
>> > themselves, but I don't want to give them administrative access to the
>> > AuthorizeNet merchant login.
>> >
>> >
>> >
>>
>>
>
> 

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

Re: AuthorizeNet Recurring Payments?

[John C. Bland II]

Yes, there is. Specify x_billing_recurring (Yes|No) when you send your data
and it will setup the recurring payment. Look at the AIM guide on the
Auth.net site. Better yet, here's the location of the file.

http://www.authorize.net/support/AIM_guide.pdf

On 1/12/06, Josh Nathanson <[EMAIL PROTECTED]> wrote:
>
> I've used the Authorize.net recurring payments for about six months, and
> it
> works fine, but as of the last time I checked (a few months ago), there's
> no
> API to interact with the recurring billing system -- only the single
> transactions.  You have to set up the subscriptions manually through their
> website forms. I think they do have a batch processing feature, where you
> can upload multiple subscriptions from a flat file, but I haven't looked
> into that feature personally, and I think you still have to do it through
> the AN website, there's no API for that.
>
> -- Josh Nathanson
>
>
> - Original Message -
> From: "Jim McAtee" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Thursday, January 12, 2006 5:20 PM
> Subject: AuthorizeNet Recurring Payments?
>
>
> > The CC thread reminded me of this...
> >
> > We've been using AuthorizeNet for many years and recently (well, in the
> > last couple of years, anyway) they began offering a means of doing
> > recurring payments.  It looks like these payment have to be set up
> > manually through forms on the AN web site, but I could be wrong.  Does
> > anyone know if there's some kind of API that allows you to set up
> > recurring payments, halt them, check the success of transactions, etc.?
> > I'd like our sales associates to be able to set up these payments
> > themselves, but I don't want to give them administrative access to the
> > AuthorizeNet merchant login.
> >
> >
> >
>
> 

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

HAPPY BIRTHDAY MICHAEL!

[Will Tomlinson]

Just wanted to wish Michael D. a HAPPY BIRTHDAY! 

It was yesterday, but better late than never, right?

Hope you get lotsa cool stuff dude! 

Will

 

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

Re: AuthorizeNet Recurring Payments?

[Jim McAtee]

We have some instances where we have a need for 'subscription' type 
payments - mostly monthly charges for web hosting for clients.  Our main 
need, however, is for periodic payments for services.  For example, 
someone purchases one year of advertising and the salesperson agrees to 
allow them to pay quarterly.  The only way this is convenient for either 
us or the customer is to take a CC number.  So then we're tasked with 
how/where this CC number is stored.  I've instructed sales to keep CC 
numbers out of all computer records, as our sales applications reside on 
systems reachable from the net for telecommuting purposes.  But I've found 
CC numbers in _plain_text_ within notes fields of our contact management 
application.


- Original Message - 
From: "Josh Nathanson" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Thursday, January 12, 2006 7:26 PM
Subject: Re: AuthorizeNet Recurring Payments?


> I've used the Authorize.net recurring payments for about six months, and 
> it
> works fine, but as of the last time I checked (a few months ago), 
> there's no
> API to interact with the recurring billing system -- only the single
> transactions.  You have to set up the subscriptions manually through 
> their
> website forms. I think they do have a batch processing feature, where 
> you
> can upload multiple subscriptions from a flat file, but I haven't looked
> into that feature personally, and I think you still have to do it 
> through
> the AN website, there's no API for that.
>
> -- Josh Nathanson
>
>
> - Original Message - 
> From: "Jim McAtee" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Thursday, January 12, 2006 5:20 PM
> Subject: AuthorizeNet Recurring Payments?
>
>
>> The CC thread reminded me of this...
>>
>> We've been using AuthorizeNet for many years and recently (well, in the
>> last couple of years, anyway) they began offering a means of doing
>> recurring payments.  It looks like these payment have to be set up
>> manually through forms on the AN web site, but I could be wrong.  Does
>> anyone know if there's some kind of API that allows you to set up
>> recurring payments, halt them, check the success of transactions, etc.?
>> I'd like our sales associates to be able to set up these payments
>> themselves, but I don't want to give them administrative access to the
>> AuthorizeNet merchant login.


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

Re: AuthorizeNet Recurring Payments?

[Josh Nathanson]

I've used the Authorize.net recurring payments for about six months, and it 
works fine, but as of the last time I checked (a few months ago), there's no 
API to interact with the recurring billing system -- only the single 
transactions.  You have to set up the subscriptions manually through their 
website forms. I think they do have a batch processing feature, where you 
can upload multiple subscriptions from a flat file, but I haven't looked 
into that feature personally, and I think you still have to do it through 
the AN website, there's no API for that.

-- Josh Nathanson


- Original Message - 
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Thursday, January 12, 2006 5:20 PM
Subject: AuthorizeNet Recurring Payments?


> The CC thread reminded me of this...
>
> We've been using AuthorizeNet for many years and recently (well, in the
> last couple of years, anyway) they began offering a means of doing
> recurring payments.  It looks like these payment have to be set up
> manually through forms on the AN web site, but I could be wrong.  Does
> anyone know if there's some kind of API that allows you to set up
> recurring payments, halt them, check the success of transactions, etc.?
> I'd like our sales associates to be able to set up these payments
> themselves, but I don't want to give them administrative access to the
> AuthorizeNet merchant login.
>
>
> 

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

Re: Encrypt CC number and store in DB

[Casey Dougall]

Eeks. This is a great topic to get super vage info since we're all
shooting to protect our data and not get sued.

Encrypt it and don't lable the filed names like CreditCard or CC  Uses
something which won't lead the hacker believe it's a CC field. Ever
better encrypt every field in the table and use a seperate key with
every column.

Yes, your playing by ear when you do stuff like this but hey, so are
the people who process these high risk things. If your not on a
dedicated box with dedicated database i wouldn't recommend it period.
have a note or something instead that mentions we will call you to
assist in final arrangements and payment..


Casey

If your not doing 100,000 plus transactions then your not someone like paypal or
On 1/12/06, Baz <[EMAIL PROTECTED]> wrote:
> Hmm... I'm going to look into that Bryan. I didn't know processors generally
> gave functionality to store and query CC nums by customer - I'll see if mine
> does it.
>
> Baz
>
>
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 12, 2006 7:17 PM
> To: CF-Talk
> Subject: Re: Encrypt CC number and store in DB
>
> The best way is DO NOT DO IT.
>
> No I'm not just being sarcasticbut there should be no reason to do
> thisif it's for recurring billing or for future orders...this can all be
>
> setup with your CC processing company...they store the CC Cnum and give you
> a
> customer ID to store and use for future Txs.they spend all the $$ on
> security and liability insurancewhy should you ;-)
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>
>
>
>
> 

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

RE: Encrypt CC number and store in DB

[Baz]

Hmm... I'm going to look into that Bryan. I didn't know processors generally
gave functionality to store and query CC nums by customer - I'll see if mine
does it.

Baz


-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 7:17 PM
To: CF-Talk
Subject: Re: Encrypt CC number and store in DB

The best way is DO NOT DO IT.

No I'm not just being sarcasticbut there should be no reason to do 
thisif it's for recurring billing or for future orders...this can all be

setup with your CC processing company...they store the CC Cnum and give you
a 
customer ID to store and use for future Txs.they spend all the $$ on 
security and liability insurancewhy should you ;-)

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 




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

Re: Get last inserted ID

[James Holmes]

Assuming there's only one CF server (not a cluster) and no other
method of accessing the DB is used (no other server platforms,
developers etc).

On 1/13/06, Robert Munn <[EMAIL PROTECTED]> wrote:
> If you are only inserting into the address table in this bit of code, you 
> could also serialize the whole thing by using  around the 
> transaction, but I don't like using application-level locking where I should 
> be using database-level locking.

--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/

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

AuthorizeNet Recurring Payments?

[Jim McAtee]

The CC thread reminded me of this...

We've been using AuthorizeNet for many years and recently (well, in the 
last couple of years, anyway) they began offering a means of doing 
recurring payments.  It looks like these payment have to be set up 
manually through forms on the AN web site, but I could be wrong.  Does 
anyone know if there's some kind of API that allows you to set up 
recurring payments, halt them, check the success of transactions, etc.? 
I'd like our sales associates to be able to set up these payments 
themselves, but I don't want to give them administrative access to the 
AuthorizeNet merchant login. 


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

Re: Encrypt CC number and store in DB

[Jim Priest]

> I have to store credit card numbers for an internal order
> processing system. Orders come by fax and the credit card number
> must be written to DB for later viewing/charging by another
> employee.

Is the 'internal order system' on the web?  Or is this inside a protected 
network?

Here is some good info from Visa:
http://usa.visa.com/business/accepting_visa/ops_risk_management/cisp.html

Jim


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

Re: Encapsulate persistent variables

[James Holmes]

My choice is to ensure the CFC takes care of all locking within
itself. If a group of operations need to be locked, make a new method
that calls all the other methods within the lock. Named locks work
well for this kind of thing.

One trick that can help with OO code is to create a unique lockname in
the Init() method (based on a UUID) and save it as
VARIABLES.myLockname (or similar). Then, all named locks for which you
use that name are particular to that instance of the object. It
doesn't matter where you instantiate it (SESSION, APPLICATION,
whatever), the locks ensure that that object remains consistent and
other instances of the same object can continue on their way without
interference. If you really need to lock outside the object, you could
create a getter method getLockName() (as long as that external lock
applies only to that object and not data shared with other objects or
other code).

On 1/13/06, Baz <[EMAIL PROTECTED]> wrote:
> Let's say you have a display TAG for Customer.CFC. And since we all know
> that TAGs should never access outside variables, we pass in Customer.CFC.
> All the TAG does is update some part of customer, and then displays its
> values.
>
> Now let's say instead of passing in a new instance of Customer.CFC you pass
> in session.CustomerObj. You've passed in a session scoped instance of
> Customer, but the TAG doesn't know it, nor should it. So where do you lock?
>
> Baz
>
>
>
>
>
> 

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

Re: Query of query error

[James Holmes]

Ah, yes, possibly. CLOBS and VARCHARs are very different - if you want
to be able to do a LIKE clause in the QoQ, try using
to_char(theCLOBColumn) in the original query (assuming the text is
small enough).

On 1/13/06, Robert Everland III <[EMAIL PROTECTED]> wrote:
> Another thing to add is the field is a CLOB from Oracle, could that have 
> anything to do with why I can't query that field?

--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/

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

Re: Encrypt CC number and store in DB

[John C. Bland II]

Exactly. :-)

On 1/12/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> The best way is DO NOT DO IT.
>
> No I'm not just being sarcasticbut there should be no reason to do
> thisif it's for recurring billing or for future orders...this can all
> be
> setup with your CC processing company...they store the CC Cnum and give
> you a
> customer ID to store and use for future Txs.they spend all the $$ on
> security and liability insurancewhy should you ;-)
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>
>
> 

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

Re: Encrypt CC number and store in DB

[Bryan Stevenson]

The best way is DO NOT DO IT.

No I'm not just being sarcasticbut there should be no reason to do 
thisif it's for recurring billing or for future orders...this can all be 
setup with your CC processing company...they store the CC Cnum and give you a 
customer ID to store and use for future Txs.they spend all the $$ on 
security and liability insurancewhy should you ;-)

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


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

Re: Encrypt CC number and store in DB

[John C. Bland II]

If they come by fax why not do an authorization only, which basically
creates the transaction with your processor, then later come back and
finalize the authorization. Authorize.net allows this but I'm not sure about
other gateways. This seems to be the best way to remove all liability from
you/your client and placing it on your gateway.

The only downfall is I'm sure there is a timespan between the time you
authorize to the time you charge. That would be gateway specific. Here's
how/why/when I use it.

1) Authorize card (show error if not approved, if so, move on)
2) save to database (if save is successful move on, else show error and
remove authorization)
3) Charge credit card

This prevents orders from being saved without charging cards and prevents
cards from being charged without orders being saved to the db.
Unfortunately, I've had both of those issues before on e-comm sites so I was
forced to fail-safe it.

Also, if they come by fax, are they shredding the fax after receipt? If not,
just store the last 4 and reference the fax doc.

On 1/12/06, Baz <[EMAIL PROTECTED]> wrote:
>
> I have to store credit card numbers for an internal order processing
> system.
> Orders come by fax and the credit card number must be written to DB for
> later viewing/charging by another employee.
>
> Where can I see these regulations?
>
> Cheers,
> Baz
>
>
> -Original Message-
> From: Jordan Michaels [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 12, 2006 6:13 PM
> To: CF-Talk
> Subject: Re: Encrypt CC number and store in DB
>
> Dave Watts wrote:
>
> >>What's the best way to encrypt a CC number and store it in DB?
> >>
> >Ideally, it's best not to store it at all.
> >
> >
> Couldn't have said it better myself.
>
> Also, keep in mind that CC storage is highly regulated. Non-compliance
> could lead to heavy fines and, in most cases, cancellation of your
> merchant account.
>
> --
> Warm regards,
> Jordan Michaels
> Vivio Technologies
> http://www.viviotech.net/
> [EMAIL PROTECTED]
>
>
>
> 

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

Re: Get last inserted ID

[Robert Munn]

If you are only inserting into the address table in this bit of code, you could 
also serialize the whole thing by using  around the transaction, but I 
don't like using application-level locking where I should be using 
database-level locking.

>Is this the best way to do this:
>
>
>  
>INSERT INTO Address (City)
>VALUES ()
>  
>   
>  
>SELECT MAX(AddressID) as MaxID
>FROM Address
>  
>   
>
>I'm using MySQL.
>
>Cheers,
>Baz

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

Re: Swfs not showing when CF is Connected

[John C. Bland II]

Wouldn't show the swfs. I don't recall CF crashing but I know my PC didn't
crash.

On 1/12/06, Rich Tretola <[EMAIL PROTECTED]> wrote:
>
> Did it actually crash your server or just not show the swfs ?
>
> Rich
>
> On 1/12/06, John C. Bland II <[EMAIL PROTECTED]> wrote:
> > I couldn't answer, really. Once I found the issue I could care less why
> it
> > happened...as long as it was fixed. This was my local IIS so it wasn't a
> big
> > deal to me...just very annoying.
> >
> > On 1/12/06, Rich Tretola <[EMAIL PROTECTED]> wrote:
> > >
> > > Yes,  someone from then JRUN list suggsested the same thing and this
> > > did work.  It is very odd however as there are 5 other cf instances on
> > > this server and they are all working fine and all still have the
> > > mapping in IIS.  The only difference between this instance and the
> > > others is that it has more than one domain name mapped by the web
> > > connector.  Do you think this is the reason it is behaving differently
> > > ?  Another thing that is weird is that it had been working fine for
> > > the past 2 months and then suddenly stopped displaying the swfs this
> > > week after crashing repeatedly with cfoutput timeouts.  I assume that
> > > it was the cfoutputs surrounding the swf object tag that were timing
> > > out until the server finally gave up on the swfs and then was working
> > > fine with the exception of the swfs no longer showing.
> > >
> > > Rich
> > >
> > > On 1/11/06, John C. Bland II <[EMAIL PROTECTED]> wrote:
> > > > If you look at your site configuration (in IIS) you'll notice the
> .swf
> > > > extension is mapped to CF. I had this same issue locally after flash
> > > forms
> > > > came out. I believe I just deleted the .swf. Its been awhile so
> don't
> > > quote
> > > > me on that one.
> > > >
> > > > On 1/11/06, Rich Tretola <[EMAIL PROTECTED]> wrote:
> > > > >
> > > > > OK here is our setup:
> > > > >
> > > > > JRun 4 with CFMX 6 under IIS
> > > > >
> > > > > Our issue is that as soon as we add a 2nd domain using the web
> > > > > connector, the server ignores all swfs.  If we disconnect
> ColdFusion
> > > > > from IIS we can then browse to swfs again.  has anyone seen
> anything
> > > > > like this ?
> > > > >
> > > > > Rich
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> 

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

RE: cf open shopping cart

[Andy]

We are not focused enough yet, but quickly getting there.

https://sourceforge.net/projects/openbizservices/
 

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 2:09 PM
To: CF-Talk
Subject: Re: cf open shopping cart

Ok maybe 'bickering' is too strong  a word, but it didnt look to me like the
kind of productive, energetic, progressive discussion I see happening on the
CFEclipse and Model-glue lists for example.   As i said, it could well be
that the initial wide-ranging stuff has now been narrowed down to a more
focussed point, and what seemed like a cloud of ideas has now gelled into an
organised project.  rely

I lost track of the project when it moved off CF-Talk, but at the time that
happened, it didnt look to me like it was going to [A] offer me anything i
could use that i didn't already have, and/or [B] offer an opportunity for me
to learn at the same time as contributing something back to the cf community
that has supported me so well over all these years since cF4.0.1

Your post, Andy, puts an entirely different perspective on it.  Thanks for
your post.

Where can those of us who are interested in the project, but not currently
involved, find out more?

Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month


On 1/12/06, Andy <[EMAIL PROTECTED]> wrote:
>
> Mike,
> I am sorry that you took it as bickering. Sounded like discussion to 
> me.  As far as you other points, the "project" is not in a mess, right 
> now, there are just two of us working through it, and perhaps as we 
> progress, you might reconsider.
>
> Andy
>
> PS:  We are using CFC's, and will probably end up converting Ben's 
> work in the process. I am just finishing a first draft of a high level 
> archicture document.
>
>




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

Re: Encrypt CC number and store in DB

[Stan Winchester]

If you must store CC numbers be sure you client understands the risks. We have 
used CardCrypt and TextCrypt from Perth Web (http://developer.perthweb.com.au/) 
with good success. Just be sure you NEVER let the private key be stored on the 
server and NEVER use it without SSL. And NEVER let the private just lay around. 
The private key MUST be stored in a safe and secure loction just like you would 
the keys to a safe. I always suggest to clients they remove the CC numbers ASAP 
after they don't need them anymore like Bobby suggested #replace(ccnumber, 
ccnumber, "")#

>What's the best way to encrypt a CC number and store it in DB?

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

RE: Encrypt CC number and store in DB

[Baz]

I have to store credit card numbers for an internal order processing system.
Orders come by fax and the credit card number must be written to DB for
later viewing/charging by another employee. 

Where can I see these regulations?

Cheers,
Baz


-Original Message-
From: Jordan Michaels [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 6:13 PM
To: CF-Talk
Subject: Re: Encrypt CC number and store in DB

Dave Watts wrote:

>>What's the best way to encrypt a CC number and store it in DB?
>>
>Ideally, it's best not to store it at all.
>  
>
Couldn't have said it better myself.

Also, keep in mind that CC storage is highly regulated. Non-compliance
could lead to heavy fines and, in most cases, cancellation of your
merchant account.

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



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

RE: Encrypt CC number and store in DB

[Baz]

I was expecting an answer like: "put encrypt() in your setter method and
decrypt() in your getter"... heh. Or better yet, a link to a function on
cflib... looks like this is going to be a big one.

Baz



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 5:59 PM
To: CF-Talk
Subject: RE: Encrypt CC number and store in DB

> What's the best way to encrypt a CC number and store it in DB?

The "best way" is really a business question - what's the best way for one
company may not be best for another. My answers below emphasize security
above convenience, but that might not be the choice you want to make.

Ideally, it's best not to store it at all.

If you must store it, you shouldn't allow the same application to encrypt
and decrypt the number. For example, using PKI you could have your ecommerce
application encrypt the number, and a private internal application on a
separate machine could then decrypt it.

Choosing an algorithm is much less important than figuring out how you'll
manage keys. It doesn't matter how strong your encryption algorithm is, if
an attacker can get all the keys from one place. This is the big problem
with symmetric encryption, of course.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!




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

Re: Encrypt CC number and store in DB

[Jordan Michaels]

Dave Watts wrote:

>>What's the best way to encrypt a CC number and store it in DB?
>>
>Ideally, it's best not to store it at all.
>  
>
Couldn't have said it better myself.

Also, keep in mind that CC storage is highly regulated. Non-compliance
could lead to heavy fines and, in most cases, cancellation of your
merchant account.

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

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

RE: Encrypt CC number and store in DB

[Dave Watts]

> What's the best way to encrypt a CC number and store it in DB?

The "best way" is really a business question - what's the best way for one
company may not be best for another. My answers below emphasize security
above convenience, but that might not be the choice you want to make.

Ideally, it's best not to store it at all.

If you must store it, you shouldn't allow the same application to encrypt
and decrypt the number. For example, using PKI you could have your ecommerce
application encrypt the number, and a private internal application on a
separate machine could then decrypt it.

Choosing an algorithm is much less important than figuring out how you'll
manage keys. It doesn't matter how strong your encryption algorithm is, if
an attacker can get all the keys from one place. This is the big problem
with symmetric encryption, of course.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


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

RE: Encrypt CC number and store in DB

[Bobby Hartsfield]

HINT: #replace(ccnumber, ccnumber, "")#

;-)

..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
 
 
-Original Message-
From: Baz [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 5:47 PM
To: CF-Talk
Subject: Encrypt CC number and store in DB

What's the best way to encrypt a CC number and store it in DB?





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

Encrypt CC number and store in DB

[Baz]

What's the best way to encrypt a CC number and store it in DB?



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

Re: CSS mystery

[Bryan Stevenson]

BTW I have never seen this notation before "leftMenu"  normally I'd expect 
to see ".leftMenu"

So that most certainly could be "a" problemwhether or not it is "the" 
mysterious and unknown problem you are having I do not know ;-)

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


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

Re: CSS mystery

[Bryan Stevenson]

judging by the padding being used my guess would be the box model 
hackalthough this is an issue with IE...not FF

and yes...of course knowing what it is supposed to do and is not doing 
would 
be a tad more helpful ;-)

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


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

RE: CSS mystery

[Munson, Jacob]

I am using Firefox 1.5, IE 6, and Opera 8.5.  I don't see any overlap in
any of them.  However, IE is the only one that shows me a darker shade
for the inner box.  I don't even see the box in Firefox nor Opera.  

It looks like you could be using some IE specific CSS, you could try
validating your CSS with the W3C validator.

> -Original Message-
> From: Robert Everland III [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, January 12, 2006 1:09 PM
> To: CF-Talk
> Subject: Re: CSS mystery
> 
> There is a box inside of a box. In IE and Opera the inner box 
> is constrained to the size of the outer box. In FF with 
> padding it goes over the container box.


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



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

Re: Scripting DB records in enterprise manager

[Mike Little]

thanks guys for the advice. i have ended up using the DTS export - but had to 
change the table ownership first on the relevant tables.

mike

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

Re: OT: CSS mystery

[Robert Everland III]

That's awesome, it works beautifully now. It was driving me crazy.


Also those extra periods were added after I posted. The code only has one 
period.




bob

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

Re: Get last inserted ID

[alexander sicular]

dont know about mysql, but this is how i do it in mssql2k :


SET NOCOUNT ON
INSERT INTO Objects (EmployeeID,  patientID, ObjectTypeID)
VALUES (,
,
)
SELECT @@identity as maxObjectID
SET NOCOUNT OFF



then to get the value i do #getMaxObject.maxObjectID#.

give it a shot?
-alex

>Is this the best way to do this:
>
>
>  
>INSERT INTO Address (City)
>VALUES ()
>  
>   
>  
>SELECT MAX(AddressID) as MaxID
>FROM Address
>  
>   
>
>I'm using MySQL.
>
>Cheers,
>Baz

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

Re: OT: CSS mystery

[Zaphod Beeblebrox]

It has to do with the way IE and Firefox treat the box model in quirks
mode.  There's some info about it here:

http://www.quirksmode.org/css/quirksmode.html

Also, if you remove the width:100% in the menu def, it will fill out correctly.


On 1/12/06, Robert Everland III <[EMAIL PROTECTED]> wrote:
> Can anyone explain to me why this works in IE 6 and Opera but not in Firefox?
>
>
> 
>
> 
> 
> Untitled
> 
>
>
> 
> .container {
> color: #00;
> font-family:tahoma, verdana, helvetica;
> font-size: 11px;
> background-color: #f1f1ed;
> width:170px;
> height: 100%;
> border-right: buttonshadow 1px solid;
> border-top: #f5f5f5 1px solid;
> border-left: #f5f5f5 1px solid;
> border-bottom: buttonshadow 1px solid;
> padding-right : 1px;
> padding-top : 1px;
> padding-bottom : 1px;
> }
> ...leftMenu {
> color:#006699;
> text-decoration:none;
> font-weight:bold;
> }
> ...leftMenu:hover {
> color:#00;
> text-decoration:none;
> font-weight:bold;
> }
> ...leftMenu:active {
> color:#00;
> text-decoration:none;
> font-weight:bold ;
> }
> ...Menu {
> width: 100%;
> height: 20px;
>
> padding:2px 5px 3px 2px;
> border-right: buttonshadow 1px solid;
> border-top: #f5f5f5 1px solid;
> border-left: #f5f5f5 1px solid;
> border-bottom: buttonshadow 1px solid;
>
> background-color: #D4D0C8;
> cursor:hand;
> color:#00;
> }
> ...Option {
> width: 100%;
> height: 24px;
> padding:2 5 3 16;
> background-color: #f5f5f5;
> border-top : 1px solid #ff;
> border-bottom : 1px solid #ff;
> border-left : 1px solid #ff;
> border-right : 1px solid #ff;
> cursor:hand;
> }
> ...Options {padding:1 1 1 1}
>
> ...imgPosition {
> vertical-align: middle;
> }
> 
>  marginwidth="0" marginheight="0">
>
>
> 
> 
> 
> 
> 
> 
> 
>
>
>
> Bob
>
> 

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

Re: OT: CSS mystery

[Barney Boisvert]

Because IE and Opera are incorrectly ignoring the first two periods,
while Firefox is correctly ignoring the rest of the rule?  I'm not
sure that applies to selectors or just rules, but I'd guess it's for
both.  Or perhaps its a case-sensitivity issue.  CSS is case
sensitive, but I believe IE doesn't enforce it.  Did you try removing
the extra periods or fixing the casing and see if that resolves it?

cheers,
barneyb

On 1/12/06, Robert Everland III <[EMAIL PROTECTED]> wrote:
> Can anyone explain to me why this works in IE 6 and Opera but not in Firefox?
>
>
> 
>
> 
> 
> Untitled
> 
>
>
> 
> .container {
> color: #00;
> font-family:tahoma, verdana, helvetica;
> font-size: 11px;
> background-color: #f1f1ed;
> width:170px;
> height: 100%;
> border-right: buttonshadow 1px solid;
> border-top: #f5f5f5 1px solid;
> border-left: #f5f5f5 1px solid;
> border-bottom: buttonshadow 1px solid;
> padding-right : 1px;
> padding-top : 1px;
> padding-bottom : 1px;
> }
> ...leftMenu {
> color:#006699;
> text-decoration:none;
> font-weight:bold;
> }
> ...leftMenu:hover {
> color:#00;
> text-decoration:none;
> font-weight:bold;
> }
> ...leftMenu:active {
> color:#00;
> text-decoration:none;
> font-weight:bold ;
> }
> ...Menu {
> width: 100%;
> height: 20px;
>
> padding:2px 5px 3px 2px;
> border-right: buttonshadow 1px solid;
> border-top: #f5f5f5 1px solid;
> border-left: #f5f5f5 1px solid;
> border-bottom: buttonshadow 1px solid;
>
> background-color: #D4D0C8;
> cursor:hand;
> color:#00;
> }
> ...Option {
> width: 100%;
> height: 24px;
> padding:2 5 3 16;
> background-color: #f5f5f5;
> border-top : 1px solid #ff;
> border-bottom : 1px solid #ff;
> border-left : 1px solid #ff;
> border-right : 1px solid #ff;
> cursor:hand;
> }
> ...Options {padding:1 1 1 1}
>
> ...imgPosition {
> vertical-align: middle;
> }
> 
>  marginwidth="0" marginheight="0">
>
>
> 
> 
> 
> 
> 
> 
> 
>
>
>
> Bob
>
> 

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

Re: Mail list archives

[Robert Everland III]

Can't believe I remembered the name of this application. This should do what 
you want http://www.amxfiles.com/wixlist/



Bob

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

RE: Encapsulate persistent variables

[Baz]

Let's say you have a display TAG for Customer.CFC. And since we all know
that TAGs should never access outside variables, we pass in Customer.CFC.
All the TAG does is update some part of customer, and then displays its
values. 

Now let's say instead of passing in a new instance of Customer.CFC you pass
in session.CustomerObj. You've passed in a session scoped instance of
Customer, but the TAG doesn't know it, nor should it. So where do you lock?
 
Baz





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

Re: CSS mystery

[Robert Everland III]

There is a box inside of a box. In IE and Opera the inner box is constrained to 
the size of the outer box. In FF with padding it goes over the container box.



Bob

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

RE: CSS mystery

[Andy Matthews]

What's it supposed to be doing? What doesn't it do in FF?



-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 12, 2006 1:50 PM
To: CF-Talk
Subject: OT: CSS mystery


Can anyone explain to me why this works in IE 6 and Opera but not in
Firefox?






Untitled




.container {
color: #00;
font-family:tahoma, verdana, helvetica;
font-size: 11px;
background-color: #f1f1ed;
width:170px;
height: 100%;
border-right: buttonshadow 1px solid;
border-top: #f5f5f5 1px solid;
border-left: #f5f5f5 1px solid;
border-bottom: buttonshadow 1px solid;
padding-right : 1px;
padding-top : 1px;
padding-bottom : 1px;
}
leftMenu {
color:#006699;
text-decoration:none;
font-weight:bold;
}
leftMenu:hover {
color:#00;
text-decoration:none;
font-weight:bold;
}
leftMenu:active {
color:#00;
text-decoration:none;
font-weight:bold ;
}
Menu {
width: 100%;
height: 20px;

padding:2px 5px 3px 2px;
border-right: buttonshadow 1px solid;
border-top: #f5f5f5 1px solid;
border-left: #f5f5f5 1px solid;
border-bottom: buttonshadow 1px solid;

background-color: #D4D0C8;
cursor:hand;
color:#00;
}
Option {
width: 100%;
height: 24px;
padding:2 5 3 16;
background-color: #f5f5f5;
border-top : 1px solid #ff;
border-bottom : 1px solid #ff;
border-left : 1px solid #ff;
border-right : 1px solid #ff;
cursor:hand;
}
Options {padding:1 1 1 1}

imgPosition {
vertical-align: middle;
}














Bob



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

RE: Proper Syntax for Access (CF App)

[Adkins, Randy]

Got it.. Now I can understand it. Sometimes you just have to step away
And then come back.

Thanks! 

-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 3:18 PM
To: CF-Talk
Subject: RE: Proper Syntax for Access (CF App)

Usually this stuff in MS sql and access is left associative, so you have
to use parens like this 

FROM
(((a left join b) left join c) left join d)
 


-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 12, 2006 3:14 PM
To: CF-Talk
Subject: Proper Syntax for Access (CF App)

I have created an application using MySQL database platform but a client
wants to use the App using MS Access.
 
Now I created the tables and everything but some of the Query statements
bomb out in Access.
 
Example 1 (MySQL)
 SELECT
  SUBMISSIONRECORDS.EMPLOYEEID,
   MEMBERS.FIRSTNAME AS EMPLOYEE_FIRST_NAME,
   MEMBERS.LASTNAME AS EMPLOYEE_LAST_NAME,
   MANAGER.EMPLOYEEID AS MANAGER_EMPLOYEE_ID,
   MANAGER.FIRSTNAME AS MANAGER_FIRST_NAME,
   MANAGER.LASTNAME AS MANAGER_LAST_NAME,
   RELEASED.EMPLOYEEID AS RELEASED_EMPLOYEE_ID,
   RELEASED.FIRSTNAME AS RELEASED_FIRST_NAME,
   RELEASED.LASTNAME AS RELEASED_LAST_NAME,
   APPROVER.EMPLOYEEID AS APPROVER_EMPLOYEE_ID,
   APPROVER.FIRSTNAME AS APPROVER_FIRST_NAME,
   APPROVER.LASTNAME AS APPROVER_LAST_NAME,
   SUBMISSIONRECORDS.RELEASED,
   SUBMISSIONRECORDS.APPROVED,
   PAYPERIODS.ID AS PAYPERIODID,
   PAYPERIODS.PPSTARTDATE,
   PAYPERIODS.PPENDDATE,
   TIMESUBMISSIONS.PPDATE,
   TIMESUBMISSIONS.ST_TIME,
   TIMESUBMISSIONS.OT_TIME,
   TIMESUBMISSIONS.DT_TIME,
   TIMESUBMISSIONS.JCW_CODE,
   TIMESUBMISSIONS.JOBCODE,
   TIMESUBMISSIONS.CRAFTCODE,
   WAGERATES.WAGERATE
   
 FROM
   SUBMISSIONRECORDS
LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID
LEFT JOIN MEMBERS AS MANAGER ON SUBMISSIONRECORDS.MANAGERID =
MANAGER.ID
LEFT JOIN MEMBERS AS RELEASED ON SUBMISSIONRECORDS.RELEASEDBY =
RELEASED.ID
LEFT JOIN MEMBERS AS APPROVER ON SUBMISSIONRECORDS.APPROVEDBY =
APPROVER.ID
LEFT JOIN PAYPERIODS ON SUBMISSIONRECORDS.PAYPERIODID =
PAYPERIODS.ID
LEFT JOIN TIMESUBMISSIONS ON SUBMISSIONRECORDS.ID =
TIMESUBMISSIONS.SUBRECID
LEFT JOIN WAGERATES ON TIMESUBMISSIONS.WAGERATE = WAGERATES.ID
 
 
This worked perfectly in MySQL but then requires the ( ) in the FROM
line on Access such as:
   (SUBMISSIONRECORDS
 LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID)
 
Now if I only had ONE join transaction, it would be okay, what is the
syntax for multiple Joins?
 







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

OT: CSS mystery

[Robert Everland III]

Can anyone explain to me why this works in IE 6 and Opera but not in Firefox?






Untitled




.container {
color: #00;
font-family:tahoma, verdana, helvetica; 
font-size: 11px;
background-color: #f1f1ed;
width:170px;
height: 100%;
border-right: buttonshadow 1px solid; 
border-top: #f5f5f5 1px solid; 
border-left: #f5f5f5 1px solid; 
border-bottom: buttonshadow 1px solid;
padding-right : 1px;
padding-top : 1px;
padding-bottom : 1px;
}
...leftMenu { 
color:#006699; 
text-decoration:none; 
font-weight:bold;
}
...leftMenu:hover { 
color:#00; 
text-decoration:none; 
font-weight:bold;
}
...leftMenu:active { 
color:#00; 
text-decoration:none; 
font-weight:bold ;
}
...Menu {
width: 100%; 
height: 20px; 

padding:2px 5px 3px 2px; 
border-right: buttonshadow 1px solid; 
border-top: #f5f5f5 1px solid; 
border-left: #f5f5f5 1px solid; 
border-bottom: buttonshadow 1px solid; 

background-color: #D4D0C8; 
cursor:hand; 
color:#00;
}
...Option {
width: 100%;
height: 24px;
padding:2 5 3 16;
background-color: #f5f5f5;
border-top : 1px solid #ff;
border-bottom : 1px solid #ff;
border-left : 1px solid #ff;
border-right : 1px solid #ff;
cursor:hand;
}
...Options {padding:1 1 1 1}

...imgPosition {
vertical-align: middle;
}




   









Bob

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

RE: Encapsulate persistent variables

[Baz]

Sir Robert Everland the III,

>You would have to know the name of the lock you set up.

I agree.  That's a downfall of using named locks, but another great reason
to encapsulate all locking in 1 place!

> Named locks on application scope are not needed

I disagree. If you were to update the application scope and not just read
from it, you need to lock.

> Someone pointed out that they don't lock the entire box, only the 
> application, then the scope.

I agree. If you lock the session scope, I think it's only that specific
session that's locked and not all sessions on the box - same with
application scope, only a specific application is locked and not all
applications on a box.

Baz


-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 2:37 PM
To: CF-Talk
Subject: Re: Encapsulate persistent variables

I have an issue with using name locks. 

I think that becomes very unmanigable unless you set up a dynamic name based
on session. Named lockes on application scope are not needed. It's only
going to be a one hit and that's it. The only place would be session.
Someone pointed out that they don't lock the entire box, only the
application then the scope.




Bob



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

Re: Free third party DNS hosting from godaddy

[Alan Rother]

We use it all the time at my company. It's great. Lots of options, easy to
use. I would highly reccommend it.

On 1/12/06, Owner, Three Ravens Consulting <[EMAIL PROTECTED]>
wrote:
>
> I use registerfly.com
>
> Eric
>
> On Thu, 12 Jan 2006 09:21:12 -0500
> "Katz, Dov B \(IT\)" <[EMAIL PROTECTED]> wrote:
> > has anyone tried using the free DNS management from
> >godaddy?
> >
> > They apparently let you manage dns records of outside
> >domains without
> > transferring them there (just pointing the nameserver to
> >godaddy).  I'm
> > looking for a place that I could set up and manage
> >domains at and my
> > hosting company doesnt offer that
> >
> > Thanks
> > 
> >
> > NOTICE: If received in error, please destroy and notify
> >sender.  Sender does not waive confidentiality or
> >privilege, and use is prohibited.
> >
> >
> >
>
> 

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

Re: Encapsulate persistent variables

[Robert Everland III]

I have an issue with using name locks. 

You would have to know the name of the lock you set up. I think that becomes 
very unmanigable unless you set up a dynamic name based on session. Named 
lockes on application scope are not needed. It's only going to be a one hit and 
that's it. The only place would be session. Someone pointed out that they don't 
lock the entire box, only the application then the scope.




Bob

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

RE: Encapsulate persistent variables

[Baz]

Good example Jochem,

I'm a bit surprised about how many people think that locking is unnecessary.
The need to do it is definitely less noticeable nowadays because your server
won't crash, but it's still essential. Imagine charging your customer too
little or too much because s/he was accessing your session scoped shopping
cart with 2 browsers... not fun.

Locking is still required! (albeit in fewer cases)
 
The solution of auto-locking in the CFAdmin is not optimal because, as
Charlie Griefer mentioned, the performance impact could be catastrophic -
especially if you were locking the application scope on every request! That
would likely be your #1 bottleneck.

It is in fact could practice to only use named locks. You should almost
never lock an entire scope, except, perhaps, at app startup or some other
rare case, but definitely not on every request.
 
So this brings us back to the original question of how to manage all this.
It would be nice to be able to encapsulate all locking somehow, and not have
the developer worry about which variable was in what scope, and what's that
lock name again? The developer would only reference the new custom scope
called AppName (a CFC), that manages and contains all persistent vars.

Oh, how that would be great...

Baz



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

RE: Proper Syntax for Access (CF App)

[Katz, Dov B \(IT\)]

Usually this stuff in MS sql and access is left associative, so you have
to use parens like this 

FROM
(((a left join b) left join c) left join d)
 


-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 3:14 PM
To: CF-Talk
Subject: Proper Syntax for Access (CF App)

I have created an application using MySQL database platform but a client
wants to use the App using MS Access.
 
Now I created the tables and everything but some of the Query statements
bomb out in Access.
 
Example 1 (MySQL)
 SELECT
  SUBMISSIONRECORDS.EMPLOYEEID,
   MEMBERS.FIRSTNAME AS EMPLOYEE_FIRST_NAME,
   MEMBERS.LASTNAME AS EMPLOYEE_LAST_NAME,
   MANAGER.EMPLOYEEID AS MANAGER_EMPLOYEE_ID,
   MANAGER.FIRSTNAME AS MANAGER_FIRST_NAME,
   MANAGER.LASTNAME AS MANAGER_LAST_NAME,
   RELEASED.EMPLOYEEID AS RELEASED_EMPLOYEE_ID,
   RELEASED.FIRSTNAME AS RELEASED_FIRST_NAME,
   RELEASED.LASTNAME AS RELEASED_LAST_NAME,
   APPROVER.EMPLOYEEID AS APPROVER_EMPLOYEE_ID,
   APPROVER.FIRSTNAME AS APPROVER_FIRST_NAME,
   APPROVER.LASTNAME AS APPROVER_LAST_NAME,
   SUBMISSIONRECORDS.RELEASED,
   SUBMISSIONRECORDS.APPROVED,
   PAYPERIODS.ID AS PAYPERIODID,
   PAYPERIODS.PPSTARTDATE,
   PAYPERIODS.PPENDDATE,
   TIMESUBMISSIONS.PPDATE,
   TIMESUBMISSIONS.ST_TIME,
   TIMESUBMISSIONS.OT_TIME,
   TIMESUBMISSIONS.DT_TIME,
   TIMESUBMISSIONS.JCW_CODE,
   TIMESUBMISSIONS.JOBCODE,
   TIMESUBMISSIONS.CRAFTCODE,
   WAGERATES.WAGERATE
   
 FROM
   SUBMISSIONRECORDS
LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID
LEFT JOIN MEMBERS AS MANAGER ON SUBMISSIONRECORDS.MANAGERID =
MANAGER.ID
LEFT JOIN MEMBERS AS RELEASED ON SUBMISSIONRECORDS.RELEASEDBY =
RELEASED.ID
LEFT JOIN MEMBERS AS APPROVER ON SUBMISSIONRECORDS.APPROVEDBY =
APPROVER.ID
LEFT JOIN PAYPERIODS ON SUBMISSIONRECORDS.PAYPERIODID =
PAYPERIODS.ID
LEFT JOIN TIMESUBMISSIONS ON SUBMISSIONRECORDS.ID =
TIMESUBMISSIONS.SUBRECID
LEFT JOIN WAGERATES ON TIMESUBMISSIONS.WAGERATE = WAGERATES.ID
 
 
This worked perfectly in MySQL but then requires the ( ) in the FROM
line on Access such as:
   (SUBMISSIONRECORDS
 LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID)
 
Now if I only had ONE join transaction, it would be okay, what is the
syntax for multiple Joins?
 





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

Proper Syntax for Access (CF App)

[Adkins, Randy]

I have created an application using MySQL database platform but a client
wants to use the App using MS Access.
 
Now I created the tables and everything but some of the Query statements
bomb out in Access.
 
Example 1 (MySQL)
 SELECT
  SUBMISSIONRECORDS.EMPLOYEEID,
   MEMBERS.FIRSTNAME AS EMPLOYEE_FIRST_NAME,
   MEMBERS.LASTNAME AS EMPLOYEE_LAST_NAME,
   MANAGER.EMPLOYEEID AS MANAGER_EMPLOYEE_ID,
   MANAGER.FIRSTNAME AS MANAGER_FIRST_NAME,
   MANAGER.LASTNAME AS MANAGER_LAST_NAME,
   RELEASED.EMPLOYEEID AS RELEASED_EMPLOYEE_ID,
   RELEASED.FIRSTNAME AS RELEASED_FIRST_NAME,
   RELEASED.LASTNAME AS RELEASED_LAST_NAME,
   APPROVER.EMPLOYEEID AS APPROVER_EMPLOYEE_ID,
   APPROVER.FIRSTNAME AS APPROVER_FIRST_NAME,
   APPROVER.LASTNAME AS APPROVER_LAST_NAME,
   SUBMISSIONRECORDS.RELEASED,
   SUBMISSIONRECORDS.APPROVED,
   PAYPERIODS.ID AS PAYPERIODID,
   PAYPERIODS.PPSTARTDATE,
   PAYPERIODS.PPENDDATE,
   TIMESUBMISSIONS.PPDATE,
   TIMESUBMISSIONS.ST_TIME,
   TIMESUBMISSIONS.OT_TIME,
   TIMESUBMISSIONS.DT_TIME,
   TIMESUBMISSIONS.JCW_CODE,
   TIMESUBMISSIONS.JOBCODE,
   TIMESUBMISSIONS.CRAFTCODE,
   WAGERATES.WAGERATE
   
 FROM
   SUBMISSIONRECORDS
LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID
LEFT JOIN MEMBERS AS MANAGER ON SUBMISSIONRECORDS.MANAGERID =
MANAGER.ID
LEFT JOIN MEMBERS AS RELEASED ON SUBMISSIONRECORDS.RELEASEDBY =
RELEASED.ID
LEFT JOIN MEMBERS AS APPROVER ON SUBMISSIONRECORDS.APPROVEDBY =
APPROVER.ID
LEFT JOIN PAYPERIODS ON SUBMISSIONRECORDS.PAYPERIODID =
PAYPERIODS.ID
LEFT JOIN TIMESUBMISSIONS ON SUBMISSIONRECORDS.ID =
TIMESUBMISSIONS.SUBRECID
LEFT JOIN WAGERATES ON TIMESUBMISSIONS.WAGERATE = WAGERATES.ID
 
 
This worked perfectly in MySQL but then requires the ( ) in the FROM
line on Access
such as:
   (SUBMISSIONRECORDS
 LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID)
 
Now if I only had ONE join transaction, it would be okay, what is the
syntax for multiple Joins?
 



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

Re: cf open shopping cart

[Mike Kear]

Ok maybe 'bickering' is too strong  a word, but it didnt look to me like the
kind of productive, energetic, progressive discussion I see happening on the
CFEclipse and Model-glue lists for example.   As i said, it could well be
that the initial wide-ranging stuff has now been narrowed down to a more
focussed point, and what seemed like a cloud of ideas has now gelled into an
organised project.  rely

I lost track of the project when it moved off CF-Talk, but at the time that
happened, it didnt look to me like it was going to [A] offer me anything i
could use that i didn't already have, and/or [B] offer an opportunity for me
to learn at the same time as contributing something back to the cf community
that has supported me so well over all these years since cF4.0.1

Your post, Andy, puts an entirely different perspective on it.  Thanks for
your post.

Where can those of us who are interested in the project, but not currently
involved, find out more?

Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month


On 1/12/06, Andy <[EMAIL PROTECTED]> wrote:
>
> Mike,
> I am sorry that you took it as bickering. Sounded like discussion to
> me.  As
> far as you other points, the "project" is not in a mess, right now, there
> are just two of us working through it, and perhaps as we progress, you
> might
> reconsider.
>
> Andy
>
> PS:  We are using CFC's, and will probably end up converting Ben's work in
> the process. I am just finishing a first draft of a high level archicture
> document.
>
>


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

RE: Slightly OT:Linux distro for CF Developers

[Bobby Hartsfield]

So is he ;-)
 
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
 
 

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 9:40 AM
To: CF-Talk
Subject: Re: Slightly OT:Linux distro for CF Developers

You're assuming that the computer they run the usb drive off of is able to
get to the internet.



Bob



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

RE: Detecting if a Verity Collection Exists in CFMX7...

[Dan G. Switzer, II]

>admin API perhaps?

It seems as if the admin may use the  command.
I've got 64 collections on my box and this tag takes like 20 seconds to run.
It takes forever for the admin page to load.

I looked on CFLIB.org for an existing UDF and found one, but it uses the
 action as well--which takes way to long to run.

What I did was re-write the UDF to the code at the bottom of this message.
What this code does is attempt to use  to search a collection.
If an error is thrown that has the string "does not exist" then I return
false, otherwise the function returns true. 

This seems to runs much more efficiently in my tests.

-Dan

























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

Re: OT: Access to Oracle

[Bryan Stevenson]

> There's a thing called the oracle migration workbench that could be of some
> help. I've never actually used it because the DBA's restrict our use of it
> here. But, it might help.

Great..I'll look into that one.

>
> There's always just creating an access datasource in CF and running queries
> to enter it into Oracle. I do that when I don't want to fiddle with asking
> for DBA permission.

Yep...have been thinking of this approachwill run a hell of  alot 
slowerbut I wouldn't waste a bunch of time looking at various daat 
transformation tools ;-)

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


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

Re: Scripting DB records in enterprise manager

[Zaphod Beeblebrox]

I use this program quite often.  It does everything I need it to and
it's free.  It's getting harder to find as it seems like it's
abandonware.  I'll always keep a copy of it though.

http://www.yessoft.com/software/sqlservercompare/sqlservercompare.htm


On 1/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> +1 on that recommendation, I'm currently using it to synch schemas and data
> on some large tables and it works great!
>
> Kola
>
> > -Original Message-
> > From: Jim Wright [mailto:[EMAIL PROTECTED]
> > Sent: 12 January 2006 14:58
> > To: CF-Talk
> > Subject: Re: Scripting DB records in enterprise manager
> >
> > Mike,
> > If this is something that you need to do often, or need to keep those
> > two databases in synch, I would definitely check out the sql-compare
> > and sql-datacompare tools from redgate...
> > http://www.red-gate.com/
> > They are a bit pricey, but they can save you a lot of time and headache.
> > -jim
> >
> > On 1/11/06, Mike | NZSolutions Ltd <[EMAIL PROTECTED]> wrote:
> > > hi guys,
> > >
> > > I need to duplicate some existing tables to a new SQL database.
> > >
> > > i am trying to script my sql server db, and include all records - not
> > > just the table structure. i am using the generate SQL script tool, but
> > > cannot seem to include the records.
> > >
> > > does anyone know what i am not doing?
> > >
> > > Regards
> > > Mike
> > >
> > >
> > >
> >
> > ~
> >
>
> 

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

Re: Free third party DNS hosting from godaddy

[Owner, Three Ravens Consulting]

I use registerfly.com

Eric

On Thu, 12 Jan 2006 09:21:12 -0500
  "Katz, Dov B \(IT\)" <[EMAIL PROTECTED]> wrote:
> has anyone tried using the free DNS management from 
>godaddy?
> 
> They apparently let you manage dns records of outside 
>domains without
> transferring them there (just pointing the nameserver to 
>godaddy).  I'm
> looking for a place that I could set up and manage 
>domains at and my
> hosting company doesnt offer that
> 
> Thanks
> 
> 
> NOTICE: If received in error, please destroy and notify 
>sender.  Sender does not waive confidentiality or 
>privilege, and use is prohibited.
> 
> 
> 

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

RE: Slightly OT:Linux distro for CF Developers

[Munson, Jacob]

> I admire someone as open-minded as you. The desire to learn new things
> and try new ways of doing things is an attribute that 
> deserves respect.

I second that.  So many people just use what came on their PC/Server,
even if they are geeks.  There is no adventure in saying, "Everybody
uses [preinstalled software], and I want to be compatible, plus I don't
have the time to learn [alternative software]".  I can remember the
first time I tried Windows, it was SOO cool.  I think everybody probably
had the same experience.  But now most people are too
busy/complacent/lazy or whatever to go out and try new things.


---

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



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

Re: CF Blog Hosting

[Owner, Three Ravens Consulting]

Check out uplinkearth.com  I have been with them a couple 
of years.  I pay $105 for 3 months, which includes 3gig of 
space, MySQL db (you can also get SQL Server).  They use 
CFMX7.  Not sure if they support IMAP or not.

Eric

On Thu, 12 Jan 2006 07:59:53 -0600
  Cutter <[EMAIL PROTECTED]> wrote:
> Looking for a very affordable (I'm still poor) CF Domain 
>Hosting for a 
> single domain with support for Ray's BlogCFC, MySQL 
>4.1x+, 5 or six IMAP 
> mail accounts. Someplace I can eventually show off a 
>small sample app or 
> two. Any suggestions?
> 
> Cutter
> 
> 

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

Re: Slightly OT:Linux distro for CF Developers

[Robert Munn]

I like Fedora myself because of wide support availability.

It isn't free, it's $35 / year, but the MyEclipse plugin has a huge set of 
tools that would round out your feature set, including UML, XML, CSS, JS, 
database, J2EE editing features. It has a free 30-day trial. 

Optionally, just look for other Eclipse plugins. There are free plugins for 
most of this stuff. 

I don't know if you will get the whole thing on a USB drive. Eclipse/CFE alone 
is pretty big if you include the full Eclipse installer. CFMX on Linux is a big 
install as well. That's a few hundred MB worth of stuff right there. MyEclipse 
is big as well. I guess it depends on whether you plan on pre-installing all 
the apps and making an image of your distro, then you might get away with a USB 
drive.

Don't forget a database server- MySQL is the way to go.

What about source control? You could setup SubVersion and the subClipse plugin, 
that's all free stuff.


>Eclipse with the cfeclipse plug-in (any body know of any other good
>plug-ins for web developers that I might want to include?)
>FireFox for web browsing
>Thunderbird for e-mail
>
>I'm not sure if flowcharting would be useful to the average cf developer
>(I use Visio) but if so does anyone know of Linux flow charters?
>
>In the end, I'm hoping that all of the software will be totally free.
>(remember I said cf developer edition not server)
>

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

Re: Mail list archives

[Owner, Three Ravens Consulting]

I don;t know of any out of the box solutions, but you 
could just use CFPOP to store the emails in your DB and 
then you have an easy way to display them in an archive...

Eric

On Thu, 12 Jan 2006 12:24:17 -
  "Jennifer Gavin-Wear" <[EMAIL PROTECTED]> 
wrote:
> I'm looking for an out of the box coldfusion based 
>application for storing
> and displaying mail list archives.
> 
> I've looked at doing it myself and it ocurrs to me I am 
>probably wasting my
> time creating an application that I'm sure must have 
>been done before.
> 
> I already have a mail list server and as this needs to 
>integrate into a
> "members area" of a site I need it to fit into the 
>existing security set up
> for controlled access.
> 
> It also needs to be MS SQL based.
> 
> If anyone has a product in mind, and even better with 
>feedback from using
> it, I'd appreciate the info.
> 
> Many thanks, Jenny
> 
> 
> 
> 
> 

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

Re: OT: Access to Oracle

[Jochem van Dieten]

Bryan Stevenson wrote:
> 
> I have an Access DB that needs to move to Oracle 9i.  The Oracle DB has been 
> created and then generated via Oracle Designer and does contain different 
> table names than the Access DB, and some tables will have less/more columns 
> than their Access counterparts.   In some cases their will be additional 
> columns on the Oracle side that I will need to add a default value to (so not 
> data that comes from the Access DB).
> 
> So does anyone have advice to transform this data from Access to Oracle given 
> the above issues?  and before you say flat filere-read the above ;-)

For a one-time manual job: Create linked tables in Access to your 
Oracle database. Then just use SELECT .. INTO ... to move the 
data and apply any transformation you want in the process.
For repeated exports: export from Access to flat files and mount 
them in Oracle as external tables.

Jochem

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

Re: OT: Access to Oracle

[Deanna Schneider]

There's a thing called the oracle migration workbench that could be of some
help. I've never actually used it because the DBA's restrict our use of it
here. But, it might help.

There's always just creating an access datasource in CF and running queries
to enter it into Oracle. I do that when I don't want to fiddle with asking
for DBA permission.


On 1/12/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> Hey All,
>
> I have an Access DB that needs to move to Oracle 9i.  The Oracle DB has
> been created and then generated via Oracle Designer and does contain
> different table names than the Access DB, and some tables will have
> less/more columns than their Access counterparts.   In some cases their will
> be additional columns on the Oracle side that I will need to add a default
> value to (so not data that comes from the Access DB).
>
> So does anyone have advice to transform this data from Access to Oracle
> given the above issues?  and before you say flat filere-read the
> above ;-)
>
> TIA
>
> Cheers
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>
> 

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

Re: Encapsulate persistent variables

[Jochem van Dieten]

Bryan Stevenson wrote:
>> I'm on MX7, so it should be fine, but what about race conditions? Those can
>> easily occur no? People don't lock their shopping carts in MX7? What about
>> application scope vars, that's race-condition central..
> 
> appliocation/session/server scopes are all handled automatically

They are not automatically protected against race conditions. 
Guess what happens when the following templates run concurrently:

up.cfm:

   do something


down.cfm:

   do something


Jochem

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

Re: OT: Access to Oracle

[Aaron Rouse]

In the past I have used MSSQL's Import/Export tool for this since it will
let you connect to both of those DB types and it is free with their client
tools.  Usually if I need to do a lot of manipulation I just take what I am
importing and put it into staging tables then write some PL/SQL scripts to
run aftwards that will do the changes needed and insert into the "live"
tables.

On 1/12/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> Hey All,
>
> I have an Access DB that needs to move to Oracle 9i.  The Oracle DB has
> been created and then generated via Oracle Designer and does contain
> different table names than the Access DB, and some tables will have
> less/more columns than their Access counterparts.   In some cases their will
> be additional columns on the Oracle side that I will need to add a default
> value to (so not data that comes from the Access DB).
>
> So does anyone have advice to transform this data from Access to Oracle
> given the above issues?  and before you say flat filere-read the
> above ;-)
>
> TIA
>
> Cheers
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>
> 

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

OT: Access to Oracle

[Bryan Stevenson]

Hey All,

I have an Access DB that needs to move to Oracle 9i.  The Oracle DB has been 
created and then generated via Oracle Designer and does contain different table 
names than the Access DB, and some tables will have less/more columns than 
their Access counterparts.   In some cases their will be additional columns on 
the Oracle side that I will need to add a default value to (so not data that 
comes from the Access DB).

So does anyone have advice to transform this data from Access to Oracle given 
the above issues?  and before you say flat filere-read the above ;-)

TIA

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

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

Re: Query of query error

[Robert Everland III]

Another thing to add is the field is a CLOB from Oracle, could that have 
anything to do with why I can't query that field?



Bob

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

Re: Encapsulate persistent variables

[Max Hamby]

According to MM, you still need to lock shared-scope variables to protect
against race conditions. AFAIK, setting the locking in the CFadmin will
affect performance.

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?event=view&id=KC.tn_18235&extid=tn_18235&dialogID=92334813&iterationID=1&sessionID=963070052628646c1818&stateID=1+0+92344765&mode=advanced

~Max

On 1/12/06, Charlie Griefer <[EMAIL PROTECTED]> wrote:
>
> doesn't locking all the scopes in the admin have an impact on
> performance?  aren't you effectively single threading -every-
> reference to those scopes server-wide?
>
> no bottlenecking results from this?
>
> On 1/12/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> > > I'm on MX7, so it should be fine, but what about race conditions?
> Those can
> > > easily occur no? People don't lock their shopping carts in MX7? What
> about
> > > application scope vars, that's race-condition central..
> > >
> > > Baz
> >
> > appliocation/session/server scopes are all handled automatically
> >
> > Bryan Stevenson B.Comm.
> > VP & Director of E-Commerce Development
> > Electric Edge Systems Group Inc.
> > phone: 250.480.0642
> > fax: 250.480.1264
> > cell: 250.920.8830
> > e-mail: [EMAIL PROTECTED]
> > web: www.electricedgesystems.com
> >
> >
>
> 

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

RE: Time zone issue

[Brad Wood]

Fixed.

"-Duser.timezone=America/Chicago"  was added to the JVM arguments
parameter list upon init



http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4762673

~Brad

-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 11:14 AM
To: CF-Talk
Subject: Re: Time zone issue

daylight savings perhaps on the OS?

There is no time zone stuff in CF - it comes from the host

On 1/12/06, Brad Wood <[EMAIL PROTECTED]> wrote:
> I am running CF MX 7.01 on linux.  My time zone in telnet (both os and
> hardware) is set to CST, but the now() function returns EST.
>
> WHY???
>
> I can't find any setting in cf admin to change the time zone.
>
> ~Brad
>


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

Re: Time zone issue

[John Beynon]

daylight savings perhaps on the OS?

There is no time zone stuff in CF - it comes from the host

On 1/12/06, Brad Wood <[EMAIL PROTECTED]> wrote:
> I am running CF MX 7.01 on linux.  My time zone in telnet (both os and
> hardware) is set to CST, but the now() function returns EST.
>
> WHY???
>
> I can't find any setting in cf admin to change the time zone.
>
> ~Brad
>
>
> 

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

Re: Encapsulate persistent variables

[Charlie Griefer]

doesn't locking all the scopes in the admin have an impact on
performance?  aren't you effectively single threading -every-
reference to those scopes server-wide?

no bottlenecking results from this?

On 1/12/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> > I'm on MX7, so it should be fine, but what about race conditions? Those can
> > easily occur no? People don't lock their shopping carts in MX7? What about
> > application scope vars, that's race-condition central..
> >
> > Baz
>
> appliocation/session/server scopes are all handled automatically
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>
> 

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

Re: Time zone issue

[Paul Hastings]

Brad Wood wrote:
> Is this from java?  How do I change?

yes that's from the JVM. if it's a shared host, you probably won't be allowed 
if 
that's the correct tz (or you shouldn't) but try setDefault(tz) off that same 
java class.

if you need to cast between tz, etc. have a look at 
http://www.sustainablegis.com/projects/tz/testTZCFC.cfm

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

RE: eGovernment and Wiki's --- anyone making Wiki's with CF?

[Kevin Graeme]

The way I think of it is that most CMS are designed around the idea of
structured, categorized content. A wiki tends to be more "pure" hypertext in
that it's not so much categorized as cross-linked. 

Those are really broad oversimplifications, and a CMS can certainly be
designed to be wiki-like but a wiki can't be anything but a wiki. 

---
Kevin Graeme
Cooperative Extension Technology Services
University of Wisconsin-Extension
 


> I really don't see how this differs from any other public or 
> semi-private CMS system, which employs access control among a 
> group of users.  I build this type all the time.  I guess a 
> "CMS by any other name is still just a CMS..."
> 
> Is it just in how wiki's are built that distinguishes them?
> 
> (I guess I just need to spend some time working on a wiki...)
> 
> Rick



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

Re: Encapsulate persistent variables

[Bryan Stevenson]

> I'm on MX7, so it should be fine, but what about race conditions? Those can
> easily occur no? People don't lock their shopping carts in MX7? What about
> application scope vars, that's race-condition central..
> 
> Baz

appliocation/session/server scopes are all handled automatically

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

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

Re: Slightly OT:Linux distro for CF Developers

[Jordan Michaels]

No, they haven't worked the bugs out of the built-in FTP client yet.
Hence my use of KBear for FTP. I'll happily use the built-in FTP client
once it works well enough to be dependable.  ;)

-JM

Russ wrote:

>I like Redhat Fedora myself.  As far as CFEclipse, it has an ftp client
>built in, although I don't think they've worked all the bugs out yet... And
>it doesn't support secure FTP afaik, but it's better then nothing. 
>
>
>
>  
>
>>-Original Message-
>>From: Jordan Michaels [mailto:[EMAIL PROTECTED]
>>Sent: Thursday, January 12, 2006 11:29 AM
>>To: CF-Talk
>>Subject: Re: Slightly OT:Linux distro for CF Developers
>>
>>Hi Steve,
>>
>>I admire someone as open-minded as you. The desire to learn new things
>>and try new ways of doing things is an attribute that deserves respect.
>>
>>I'm a linux man myself. I'm currently writing you from a SuSE Linux
>>system and I'd recommend SuSE Linux for both your server and PC
>>environment - as that's what I do myself. There are other great distro's
>>out there, but SuSE is widely supported in both servers and desktops and
>>I find that makes my life easier most times. SuSE 10 can also be
>>downloaded for free at www.opensuse.org. What's more, Macromedia/Adobe
>>officially supports it as a server environment. I don't know if the
>>developer edition works on Linux, but I know the Server works great on
>>it. The viviotech.net web site is a SuSE server.
>>
>>For an IDE, I'd highly recommend the Eclipse/CFEclipse combo. It takes a
>>little getting used to, but so did dreamweaver when you first started
>>using it. ;) For FTP, I use the KBear client that comes with OpenSuSE.
>>It reminds me of what I used to do with CFStudio and WS_FTP LE back in
>>the day. Again, it'll take a little getting used to when you first get
>>into it, but once you're familiar with it it's pretty slick.
>>
>>Hope this helps!
>>
>>Warm regards,
>>Jordan Michaels
>>Vivio Technologies
>>
>>
>>
>>DURETTE, STEVEN J (AIT) wrote:
>>
>>
>>
>>>Hi all,
>>>
>>>After many years, I decided to go back to school and finish my degree...
>>>One of my current classes is Linux + Certification and I am going to
>>>have a project.
>>>
>>>I was thinking that my project would be to create a Linux distro that
>>>had just the tools needed by ColdFusion developers to do their work.
>>>
>>>That being said, I have some questions for everyone on the list.  Is
>>>there anyone out there that is using Linux as a CF Development
>>>environment?  What software are you using to do it?  What extra software
>>>do you use that might not be used directly for you coding but is needed
>>>to do your job?  Is there a CF Developer Edition for Linux?  (Of course
>>>I'm thinking with Linux that the editor would probably be Eclipse with
>>>the cfeclipse plug-in)
>>>
>>>I'm from an entirely Windows background, so this is going to be
>>>interesting.
>>>
>>>I'd also like to hear what Windows programs that developers just can't
>>>seem to be without.  Maybe I can find Linux versions.
>>>
>>>Comments?  Questions?  I'd love to hear them.
>>>
>>>I'm also considering doing a Linux distro for Database Administrators so
>>>if you know of Linux software to manage MSSQL, Oracle, mySQL, etc I'd
>>>love to hear about those also!
>>>
>>>Steve Durette
>>>
>>>
>>>
>>>
>>>
>>>  
>>>
>>
>>
>
>

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

RE: Time zone issue

[Brad Wood]

Oh yeah, when I run




TimeZone: #tz.getDisplayName()# (#tz.getID()#)


It says I am in the America/New_York time zone.

Is this from java?  How do I change?

-Original Message-
From: Brad Wood 
Sent: Thursday, January 12, 2006 10:55 AM
To: CF-Talk
Subject: Time zone issue

I am running CF MX 7.01 on linux.  My time zone in telnet (both os and
hardware) is set to CST, but the now() function returns EST.  

WHY???

I can't find any setting in cf admin to change the time zone.

~Brad




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

Time zone issue

[Brad Wood]

I am running CF MX 7.01 on linux.  My time zone in telnet (both os and
hardware) is set to CST, but the now() function returns EST.  

WHY???

I can't find any setting in cf admin to change the time zone.

~Brad


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

RE: Encapsulate persistent variables

[Baz]

I'm on MX7, so it should be fine, but what about race conditions? Those can
easily occur no? People don't lock their shopping carts in MX7? What about
application scope vars, that's race-condition central..

Baz


-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 11:43 AM
To: CF-Talk
Subject: Re: Encapsulate persistent variables

Bazlocking is not required on version 6 or higherin CF Admin you can
set 
CF to auto-lock those scopes.

Hope you're on 6 or higher ;-)

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 




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

Re: Encapsulate persistent variables

[Bryan Stevenson]

DOH!...and you obviouslky are on 6 or higher if you're using CFCs...hehe

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

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

Re: Encapsulate persistent variables

[Bryan Stevenson]

Bazlocking is not required on version 6 or higherin CF Admin you can 
set 
CF to auto-lock those scopes.

Hope you're on 6 or higher ;-)

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


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

RE: Scripting DB records in enterprise manager

[Russ]

Why not just backup the db or use DTS to transfer the tables and data?

> -Original Message-
> From: Vance M. Duke [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 12, 2006 11:33 AM
> To: CF-Talk
> Subject: RE: Scripting DB records in enterprise manager
> 
> There is also a stored procedure that was written and I have used
> extensively if you do not want to pay for Red-Gate.
> 
> http://vyaskn.tripod.com/code/generate_inserts.txt
> 
> This will script the inserts and will also set the identity Off and then
> Back on... You can take all these insert statements and paste them at
> the end of you CREATE tables and keys statements.
> 
> Vance
> 
> 
> -Original Message-
> From: Jim Wright [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 12, 2006 8:58 AM
> To: CF-Talk
> Subject: Re: Scripting DB records in enterprise manager
> 
> Mike,
> If this is something that you need to do often, or need to keep those
> two databases in synch, I would definitely check out the sql-compare
> and sql-datacompare tools from redgate...
> http://www.red-gate.com/
> They are a bit pricey, but they can save you a lot of time and headache.
> -jim
> 
> On 1/11/06, Mike | NZSolutions Ltd <[EMAIL PROTECTED]> wrote:
> > hi guys,
> >
> > I need to duplicate some existing tables to a new SQL database.
> >
> > i am trying to script my sql server db, and include all records - not
> > just the table structure. i am using the generate SQL script tool, but
> > cannot seem to include the records.
> >
> > does anyone know what i am not doing?
> >
> > Regards
> > Mike
> >
> >
> >
> 
> 
> 
> 

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

RE: Scripting DB records in enterprise manager

[kola.oyedeji]

+1 on that recommendation, I'm currently using it to synch schemas and data
on some large tables and it works great!

Kola

> -Original Message-
> From: Jim Wright [mailto:[EMAIL PROTECTED]
> Sent: 12 January 2006 14:58
> To: CF-Talk
> Subject: Re: Scripting DB records in enterprise manager
> 
> Mike,
> If this is something that you need to do often, or need to keep those
> two databases in synch, I would definitely check out the sql-compare
> and sql-datacompare tools from redgate...
> http://www.red-gate.com/
> They are a bit pricey, but they can save you a lot of time and headache.
> -jim
> 
> On 1/11/06, Mike | NZSolutions Ltd <[EMAIL PROTECTED]> wrote:
> > hi guys,
> >
> > I need to duplicate some existing tables to a new SQL database.
> >
> > i am trying to script my sql server db, and include all records - not
> > just the table structure. i am using the generate SQL script tool, but
> > cannot seem to include the records.
> >
> > does anyone know what i am not doing?
> >
> > Regards
> > Mike
> >
> >
> >
> 
> ~
> 

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

RE: Slightly OT:Linux distro for CF Developers

[Russ]

I like Redhat Fedora myself.  As far as CFEclipse, it has an ftp client
built in, although I don't think they've worked all the bugs out yet... And
it doesn't support secure FTP afaik, but it's better then nothing. 



> -Original Message-
> From: Jordan Michaels [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 12, 2006 11:29 AM
> To: CF-Talk
> Subject: Re: Slightly OT:Linux distro for CF Developers
> 
> Hi Steve,
> 
> I admire someone as open-minded as you. The desire to learn new things
> and try new ways of doing things is an attribute that deserves respect.
> 
> I'm a linux man myself. I'm currently writing you from a SuSE Linux
> system and I'd recommend SuSE Linux for both your server and PC
> environment - as that's what I do myself. There are other great distro's
> out there, but SuSE is widely supported in both servers and desktops and
> I find that makes my life easier most times. SuSE 10 can also be
> downloaded for free at www.opensuse.org. What's more, Macromedia/Adobe
> officially supports it as a server environment. I don't know if the
> developer edition works on Linux, but I know the Server works great on
> it. The viviotech.net web site is a SuSE server.
> 
> For an IDE, I'd highly recommend the Eclipse/CFEclipse combo. It takes a
> little getting used to, but so did dreamweaver when you first started
> using it. ;) For FTP, I use the KBear client that comes with OpenSuSE.
> It reminds me of what I used to do with CFStudio and WS_FTP LE back in
> the day. Again, it'll take a little getting used to when you first get
> into it, but once you're familiar with it it's pretty slick.
> 
> Hope this helps!
> 
> Warm regards,
> Jordan Michaels
> Vivio Technologies
> 
> 
> 
> DURETTE, STEVEN J (AIT) wrote:
> 
> >Hi all,
> >
> >After many years, I decided to go back to school and finish my degree...
> >One of my current classes is Linux + Certification and I am going to
> >have a project.
> >
> >I was thinking that my project would be to create a Linux distro that
> >had just the tools needed by ColdFusion developers to do their work.
> >
> >That being said, I have some questions for everyone on the list.  Is
> >there anyone out there that is using Linux as a CF Development
> >environment?  What software are you using to do it?  What extra software
> >do you use that might not be used directly for you coding but is needed
> >to do your job?  Is there a CF Developer Edition for Linux?  (Of course
> >I'm thinking with Linux that the editor would probably be Eclipse with
> >the cfeclipse plug-in)
> >
> >I'm from an entirely Windows background, so this is going to be
> >interesting.
> >
> >I'd also like to hear what Windows programs that developers just can't
> >seem to be without.  Maybe I can find Linux versions.
> >
> >Comments?  Questions?  I'd love to hear them.
> >
> >I'm also considering doing a Linux distro for Database Administrators so
> >if you know of Linux software to manage MSSQL, Oracle, mySQL, etc I'd
> >love to hear about those also!
> >
> >Steve Durette
> >
> >
> >
> >
> >
> 
> 

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

RE: Scripting DB records in enterprise manager

[Vance M. Duke]

There is also a stored procedure that was written and I have used
extensively if you do not want to pay for Red-Gate.

http://vyaskn.tripod.com/code/generate_inserts.txt

This will script the inserts and will also set the identity Off and then
Back on... You can take all these insert statements and paste them at
the end of you CREATE tables and keys statements.

Vance


-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 8:58 AM
To: CF-Talk
Subject: Re: Scripting DB records in enterprise manager

Mike,
If this is something that you need to do often, or need to keep those
two databases in synch, I would definitely check out the sql-compare
and sql-datacompare tools from redgate...
http://www.red-gate.com/
They are a bit pricey, but they can save you a lot of time and headache.
-jim

On 1/11/06, Mike | NZSolutions Ltd <[EMAIL PROTECTED]> wrote:
> hi guys,
>
> I need to duplicate some existing tables to a new SQL database.
>
> i am trying to script my sql server db, and include all records - not
> just the table structure. i am using the generate SQL script tool, but
> cannot seem to include the records.
>
> does anyone know what i am not doing?
>
> Regards
> Mike
>
>
> 



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

Re: Slightly OT:Linux distro for CF Developers

[Jordan Michaels]

Hi Steve,

I admire someone as open-minded as you. The desire to learn new things
and try new ways of doing things is an attribute that deserves respect.

I'm a linux man myself. I'm currently writing you from a SuSE Linux
system and I'd recommend SuSE Linux for both your server and PC
environment - as that's what I do myself. There are other great distro's
out there, but SuSE is widely supported in both servers and desktops and
I find that makes my life easier most times. SuSE 10 can also be
downloaded for free at www.opensuse.org. What's more, Macromedia/Adobe
officially supports it as a server environment. I don't know if the
developer edition works on Linux, but I know the Server works great on
it. The viviotech.net web site is a SuSE server.

For an IDE, I'd highly recommend the Eclipse/CFEclipse combo. It takes a
little getting used to, but so did dreamweaver when you first started
using it. ;) For FTP, I use the KBear client that comes with OpenSuSE.
It reminds me of what I used to do with CFStudio and WS_FTP LE back in
the day. Again, it'll take a little getting used to when you first get
into it, but once you're familiar with it it's pretty slick.

Hope this helps!

Warm regards,
Jordan Michaels
Vivio Technologies



DURETTE, STEVEN J (AIT) wrote:

>Hi all,
> 
>After many years, I decided to go back to school and finish my degree...
>One of my current classes is Linux + Certification and I am going to
>have a project.
> 
>I was thinking that my project would be to create a Linux distro that
>had just the tools needed by ColdFusion developers to do their work.  
> 
>That being said, I have some questions for everyone on the list.  Is
>there anyone out there that is using Linux as a CF Development
>environment?  What software are you using to do it?  What extra software
>do you use that might not be used directly for you coding but is needed
>to do your job?  Is there a CF Developer Edition for Linux?  (Of course
>I'm thinking with Linux that the editor would probably be Eclipse with
>the cfeclipse plug-in)
> 
>I'm from an entirely Windows background, so this is going to be
>interesting.
> 
>I'd also like to hear what Windows programs that developers just can't
>seem to be without.  Maybe I can find Linux versions.
> 
>Comments?  Questions?  I'd love to hear them.
> 
>I'm also considering doing a Linux distro for Database Administrators so
>if you know of Linux software to manage MSSQL, Oracle, mySQL, etc I'd
>love to hear about those also!
>
>Steve Durette
>
>
>
>
>

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

RE: Slightly OT:Linux distro for CF Developers

[Munson, Jacob]

As far as a specific distro, you might use Red Hat or Fedora (Red Hat's
bleeding edge).  Why?  Because Steven Erat, one of Macromedia's support
guys, has a LOT of excellent information for using CF with Red Hat.
Search his blog for Linux and you will find a lot of good information.
Because you will most likely run into problems getting CF to work, but
Steven has fixes posted for most everything you'll run into.  Personally
I'd prefer not to use Fedora/Red Hat, but since there is such a wealth
of information for Red Hat/CF, I'd probably go that route.

Also, search the archives of the Online CF Meetup group, because there
were one or two presentations by Steven that cover using CF in Linux.

Sorry I didn't grab any links for you, but that's what Google's for,
right?  ;)

> -Original Message-
> From: DURETTE, STEVEN J
> 
> Hi all,
>  
> After many years, I decided to go back to school and finish 
> my degree...
> One of my current classes is Linux + Certification and I am going to
> have a project.
>  
> I was thinking that my project would be to create a Linux distro that
> had just the tools needed by ColdFusion developers to do their work.  
>  
> That being said, I have some questions for everyone on the list.  Is
> there anyone out there that is using Linux as a CF Development
> environment?  What software are you using to do it?  What 
> extra software
> do you use that might not be used directly for you coding but 
> is needed
> to do your job?  Is there a CF Developer Edition for Linux?  
> (Of course
> I'm thinking with Linux that the editor would probably be Eclipse with
> the cfeclipse plug-in)
>  
> I'm from an entirely Windows background, so this is going to be
> interesting.
>  
> I'd also like to hear what Windows programs that developers just can't
> seem to be without.  Maybe I can find Linux versions.
>  
> Comments?  Questions?  I'd love to hear them.
>  
> I'm also considering doing a Linux distro for Database 
> Administrators so
> if you know of Linux software to manage MSSQL, Oracle, mySQL, etc I'd
> love to hear about those also!

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



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

RE: Slightly OT:Linux distro for CF Developers

[Munson, Jacob]

I have never had much luck trying to get Windows software to run on
Linux.  Some things go Ok, but some don't.  If one wants to move to
Linux (or just try it), one is better off forgetting about their
favorite software from the Windows world, unless they have a Linux
version.  

That said, there /are/ a ton of good Linux replacements for popular
Windows software.  Graphics?  The Gimp.  Multimedia player?  MPlayer.
Games?  Sorry, out of luck.  ;)  Actually there are a lot of really good
games for Linux, but you have to be open minded.  Don't say, "I want to
play WarCraft III on Linux" but say "I want a good RTS game for Linux".
Once you start thinking that way, a whole world opens up.  You start
checking sites like
http://www.sourceforge.net/
http://www.freshmeat.net/
http://www.happypenguin.org/
And you discover a ton of really great, production quality software (or
close to it) to do exactly what you need.  And most of it was built FOR
Linux, not ported TO Linux.

> -Original Message-
> From: Casey Dougall
> 
> Hi Steven,
> 
> You might be better to focus on the linux/coldfusion server distro vs.
> adding another desktop to a crouded environment.
> 
> I was using linux for a bit and just had troubles since i couldn't get
> Macromedia apps to work."Post MX2004" I tried and had to revert back
> to windows. This was even post install of CodeWeavers Crossover
> Plugin. Problem here was a licencing script that runs in the
> background on Macromedia Products.
> 
> You'll be hard pressed to put something together that would beat
> Ubuntu but if you can figure out how to get around that problem with
> Macromedia apps I'll make the switch.
> 
> http://www.ubuntu.com
> http://www.kubuntu.org
> 
> On 1/12/06, DURETTE, STEVEN J wrote:
> >
> > I was thinking that my project would be to create a Linux 
> distro that
> > had just the tools needed by ColdFusion developers to do their work.
> >


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



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

RE: Slightly OT:Linux distro for CF Developers

[DURETTE, STEVEN J \(AIT\)]

Well,

If there are no legal problems with including the developer edition with
the distro, then it would be totally self-sufficient storing all the
data (cfm files, etc) on the usb drive.

The extra software like Thunderbird would be for IF you had an internet
connection.

Steve



-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 9:40 AM
To: CF-Talk
Subject: Re: Slightly OT:Linux distro for CF Developers


You're assuming that the computer they run the usb drive off of is able
to get to the internet.



Bob



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

Re: Detecting if a Verity Collection Exists in CFMX7...

[John Beynon]

admin API perhaps?

john.

On 1/12/06, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote:
> I'm need to detect if a collection exists and if it doesn't, then I need to
> create the collection.
>
> In previous versions of CF, if you performed the  action="create" /> on a collection it would throw an error. This meant you
> could just wrap the code in a cftry and than use a cfcatch to skip
> processing.
>
> In CFMX7 they've added a  to retrieve all the
> collections which you can use to see if a collection exists. The problem is,
>  is taking 20+ seconds to run--which is way too long.
>
> Is there a faster way to determine if a collection exists? I know I could
> check for the directory, but this doesn't really confirm if the collection
> is actually registered.
>
> -Dan
>
>
>
> 

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

RE: eGovernment and Wiki's --- anyone making Wiki's with CF?

[Munson, Jacob]

There is one (farcry), read earlier in this email for the link.  (I'm
assuming you meant open source CMS) 

> -Original Message-
> From: Cutter (CF-Talk) 
> 
> Sounds like a new Open Source CF project for somebody...
> 
> [EMAIL PROTECTED] wrote:
> 
> >I've also played with Confluence and I think its awesome, 
> shame its not
> >written in CF 
> >
> >>-Original Message-
> >>From: Geoff Bowers 
> >>
> >>On 1/12/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
> >>
> >>>It sounds like you want a content management system rather 
> than a wiki.
> >>>The difference being you give people access to edit your 
> content instead
> >>>of a free-for-all system.  Check out Farcry, an open 
> source, CF based
> >>>CMS.  Personally I haven't tried it, but I did attend their demo at
> >>>CFUnited 2005, and I was pretty impressed.
> >>>  
> >>>
> >>Thanks for that :)  Not our demo per se just an 
> enthusiastic member of
> >>the community at CFUnited.
> >>
> >>Current link for FarCry community site:
> >>http://www.farcrycms.org/


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



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

Encapsulate persistent variables

[Baz]

Hi,

Is there a way to encapsulate and hide the cflocking of persistent
variables? For example, in my app I would like to do:

 PersistentVariables.CustomerObj.Update()

Instead of:

 
Session.CustomerObj.Update()
 

Basically the PersistentVariables CFC stores and manages all persistent
variables and locking.

Thanks,
Baz




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

Re: Slightly OT:Linux distro for CF Developers

[Robert Everland III]

You're assuming that the computer they run the usb drive off of is able to get 
to the internet.



Bob

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

RE: I don't know if this is even possible

[Sandra Clark]

Jared Smith of WebAIM (Web Accessibility in Mind) just came out with Part 1
of an article series talking about Ajax and its accessibility.

Part one is basically an overview, but it does contain links to other
resources.

http://webaim.org/techniques/ajax/ 

I'm still out on it, especially since as he points out, the WCAG 1.0 does
require that pages function correctly without Javascript.

Sandra Clark

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 10, 2006 8:42 PM
To: CF-Talk
Subject: Re: I don't know if this is even possible

Rubbish. I tested all of my stuff in FF pre 1.5 and IE 6, months ago - all
of the new links I was writing to the screen (via AJAX) read out perfectly
in all 3 screen readers I tested. The links were not in a form.

On 1/11/06, Sandra Clark <[EMAIL PROTECTED]> wrote:
> The problem is that up until Firefox 1.5 dHTML is not totally 
> accessible by screen readers. Most screen readers can handle some 
> javascript, but not any screen changes after a body onload(). Thus any 
> dHTML changes to the screen will not be noticeable to screen readers.  
> If a user is in a forms mode, it might work in some screen readers, 
> but its not across the board. And if you aren't talking about a form, 
> but changing the screen, thats where the problems come in.
>
> Ajax is not inherently inaccessible, its the way of presenting the 
> information (dHTML and Javascript changes to the client screen) that 
> are problematic.
>
> FireFox 1.5 has incorporated a newer version of Javascript (think Web 
> 2.0) which when combined with Window-eyes actually created accessible
javascript.
> I saw a demo by IBM at the CSUN accessibility conference last March.
> Unfortunately most disabled users are using a combination of IE and 
> Jaws, neither of which supports it.

--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/



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

RE: Slightly OT:Linux distro for CF Developers

[DURETTE, STEVEN J \(AIT\)]

I was planning on having the cfmx 7 developer edition as an install
option if it works on Linux.

This may just be for me when all is said and done, but if I can get the
ok from Adobe (for the cf dev edition) I might release it.  Or I might
just give an option in the install that goes out to Adobe/Macromedia and
downloads the dev edition (have to check if that's legal).

I'm just in the planning stages right now.  The first class was last
night and we will be getting more indepth creating or using existing
distros to do specifically what is needed.  




-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 9:28 AM
To: CF-Talk
Subject: Re: Slightly OT:Linux distro for CF Developers


You could include an option to install a cf server, since you can't run
or debug without the server.



Bob



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

RE: Slightly OT:Linux distro for CF Developers

[Bobby Hartsfield]

but you could FTP it to one
 
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
 
 
-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 9:28 AM
To: CF-Talk
Subject: Re: Slightly OT:Linux distro for CF Developers

You could include an option to install a cf server, since you can't run or
debug without the server.



Bob



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

Re: Slightly OT:Linux distro for CF Developers

[Robert Everland III]

You could include an option to install a cf server, since you can't run or 
debug without the server.



Bob

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

Re: eGovernment and Wiki's --- anyone making Wiki's with CF?

[Cutter (CF-Talk)]

Sounds like a new Open Source CF project for somebody...

[EMAIL PROTECTED] wrote:

>I've also played with Confluence and I think its awesome, shame its not
>written in CF 
>
>Kola
>
>:)
>
>  
>
>>-Original Message-
>>From: Geoff Bowers [mailto:[EMAIL PROTECTED]
>>Sent: 11 January 2006 22:32
>>To: CF-Talk
>>Subject: Re: eGovernment and Wiki's --- anyone making Wiki's with CF?
>>
>>On 1/12/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
>>
>>
>>>It sounds like you want a content management system rather than a wiki.
>>>The difference being you give people access to edit your content instead
>>>of a free-for-all system.  Check out Farcry, an open source, CF based
>>>CMS.  Personally I haven't tried it, but I did attend their demo at
>>>CFUnited 2005, and I was pretty impressed.
>>>  
>>>
>>Thanks for that :)  Not our demo per se just an enthusiastic member of
>>the community at CFUnited.
>>
>>Current link for FarCry community site:
>>http://www.farcrycms.org/
>>
>>I thought I might chime in to say I've been using a WIKI as an
>>experiment for building developer documentation for the FarCry
>>community.  You can see our efforts here:
>>http://bugs.farcrycms.org:8080/confluence/dashboard.action
>>
>>We tried this in FarCry initially but WIKI and CMS are not really
>>equivalent.  A wiki is a very niche sort of CMS; very interactive and
>>very organis. And although I'm sure we could engineer FarCry to run in
>>"wiki mode" I'm not sure about the return on investment given the
>>multitude of specialist wiki engines out there.
>>
>>I'm a late convert to the WIKI seen.. but I quite like working with
>>them once you get going.  I think however you need the right content
>>project and a community of wiki users ie people who know how it works
>>or are prepared to learn -- this isn't the general public just yet.
>>Navigational concepts get a bit blurry and its important that people
>>who really do know what they are doing constantly keep pruning the
>>wiki so to speak, otherwise it gets out of hand, and/or whithers and
>>dies.
>>
>>We're using Confluence.  Its Java and its commercial (unless you are
>>an open source project) but its very much more sophisticated than the
>>variety of other WIKIs I've tried to set up:
>>http://www.atlassian.com/software/confluence/
>>
>>If you are building wikis you wouldn't go far wrong trying to
>>benchmark against Confluence's feature set -- it's really a great
>>product.
>>
>>-- geoff
>>http://www.daemon.com.au/
>>
>>~
>>
>>
>>
>
>

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

RE: Slightly OT:Linux distro for CF Developers

[DURETTE, STEVEN J \(AIT\)]

Actually what I was hoping to do was when it was all said and done, the
whole thing would fit on a usb drive.

Then you walk up to a workstation/pc/etc.  Boot from the usb and work
with your files on the usb (no need to really touch the hard drive). 

An entirely portable development environment.

I just wanted to start with a regular distro until I get more
proficient.

That's why I wanted a list of software that most cf/web developers just
can't live without.  I want it to be able to do anything that might be
needed.

The absolute basics that I was thinking of were:

Eclipse with the cfeclipse plug-in (any body know of any other good
plug-ins for web developers that I might want to include?)
FireFox for web browsing
Thunderbird for e-mail

I'm not sure if flowcharting would be useful to the average cf developer
(I use Visio) but if so does anyone know of Linux flow charters?

In the end, I'm hoping that all of the software will be totally free.
(remember I said cf developer edition not server)

Steve



-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 12, 2006 7:17 AM
To: CF-Talk
Subject: Re: Slightly OT:Linux distro for CF Developers


Hi Steven,

You might be better to focus on the linux/coldfusion server distro vs.
adding another desktop to a crouded environment.

I was using linux for a bit and just had troubles since i couldn't get
Macromedia apps to work."Post MX2004" I tried and had to revert back
to windows. This was even post install of CodeWeavers Crossover
Plugin. Problem here was a licencing script that runs in the
background on Macromedia Products.

You'll be hard pressed to put something together that would beat
Ubuntu but if you can figure out how to get around that problem with
Macromedia apps I'll make the switch.

http://www.ubuntu.com
http://www.kubuntu.org

regards,

Casey

On 1/12/06, DURETTE, STEVEN J (AIT) <[EMAIL PROTECTED]> wrote:

>
> I was thinking that my project would be to create a Linux distro that
> had just the tools needed by ColdFusion developers to do their work.
>



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

Re: Scripting DB records in enterprise manager

[Jim Wright]

Mike,
If this is something that you need to do often, or need to keep those
two databases in synch, I would definitely check out the sql-compare
and sql-datacompare tools from redgate...
http://www.red-gate.com/
They are a bit pricey, but they can save you a lot of time and headache.
-jim

On 1/11/06, Mike | NZSolutions Ltd <[EMAIL PROTECTED]> wrote:
> hi guys,
>
> I need to duplicate some existing tables to a new SQL database.
>
> i am trying to script my sql server db, and include all records - not
> just the table structure. i am using the generate SQL script tool, but
> cannot seem to include the records.
>
> does anyone know what i am not doing?
>
> Regards
> Mike
>
>
> 

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

Detecting if a Verity Collection Exists in CFMX7...

[Dan G. Switzer, II]

I'm need to detect if a collection exists and if it doesn't, then I need to
create the collection.

In previous versions of CF, if you performed the  on a collection it would throw an error. This meant you
could just wrap the code in a cftry and than use a cfcatch to skip
processing.

In CFMX7 they've added a  to retrieve all the
collections which you can use to see if a collection exists. The problem is,
 is taking 20+ seconds to run--which is way too long.

Is there a faster way to determine if a collection exists? I know I could
check for the directory, but this doesn't really confirm if the collection
is actually registered.

-Dan



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

Calculate schedule timeslots

[Andy Mcshane]

I am sure that I saw something a while back that may address the issue I have. 
I have a scheduler that has time slots in increments of 15 minutes. What I need 
to do is to be able to exclude time slots that have already been allocated. For 
example I have start and end time dropdown lists so a user can select a time 
slot as follows;

Start time : 11:45 AM Finish Time : 12:45PM

Once this time slot has been allocated I need to be able to exclude this range 
from both of dropdown list i.e.

Start time will now look as follows

11:30AM
01:00PM

End time will be same. I already have the logic to ensure that the start and 
end time are not the same and also that the end time is after the start time 
but I am struggling to figure out how edit my dropdowns on the fly as time 
slots are allocated. Anybody help?

Maybe a more simple method would be to only initially populate the start time 
dropdown and use the onchange method to populate the end time box? Would this 
be easier do you think?

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

Re: cfform type=xml class_cfLabelPosRight

[Sebastian Mork]

any tips about xml-forms (skins etc) - tutorials/doku?
--
Sebastian Mork
[EMAIL PROTECTED]
--

On Wed, 11 Jan 2006 16:09:12 +0100
Sebastian Mork <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> In my last app I used flash-forms, now I'm developing a new application
> and I arrived at that point I need to create the first forms.
> Well, now I want to use xml-Forms and made the first test modifying the
> system-styles (e.g. blue_style.css, blue.xsl)
> I've read the article from Mike Nimer 
> (http://www.macromedia.com/de/devnet/coldfusion/articles/richforms_05.html)
> about that topic...
> So, using xforms might be a reason, as he wrote, to learn about xsl..
> 
> I googled to find some kind of tutorial using cfforms xml-forms but
> didn't find any good sources. Does anyone know some?
> 
> Another question.. in my first tests I created a simple form (code below)
> and used a cfformgroup-tag with type=vertical, to align some
> input-fields vertically.
> Now, why does the first table-cell with the laber for the input 'emailsender'
> gets the class 'cfLabelPosRight'? (confused)
> 
> thx
> sebastian
> 
> code:
> 
>action="" 
>   id="formtaf" 
>   skin="blue" >
> 
>   
>validate="email" size="20" maxlength="100" required="true" message="Bitte 
> geben Sie eine gültige Absender-Email-Adresse ein." />
>validate="email" size="20" maxlength="100" required="true" message="Bitte 
> geben Sie eine gültige Absender-Email-Adresse ein." />
>   
>   
> 
>  
> 
> 
> generated code (without script):
> 
>  type="text/css" media="all"/>
> 
>  method="post" onsubmit="return _CF_checkCFForm_1(this);" class="cfHaloSkin" 
> name="CFForm_1">
>  class="vertical">
> 
> 
> 
> Artikel weiterempfehlen
>  class="vertical">
> 
> 
> 
> 
> * Absender
> 
> 
> 
>  value="" type="text" maxlength="100" size="20"/>
> 
> 
> 
> 
> 
> * Empfänger
> 
> 
> 
> 
> 
> 
> 
>  nowrap="nowrap">
> Mitteilung
> 
> 
> 
> 
>  
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> -- 
> Sebastian Mork <[EMAIL PROTECTED]>
> 
> 
> 

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

RE: CF Blog Hosting

[Snake]

U can't blame them.
If you do support createobject you are creating a potential security
nightmare with people able to hack into the cfadmin and do all kinds of
nasty things with java such as steal other sites session data or get into
their application variables and steal database usernames and password etc.

Russ 

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: 12 January 2006 14:07
To: CF-Talk
Subject: Re: CF Blog Hosting

Just a warning - do not do GoDaddy. They do not support createObject.
(On the other hand, I _love_ GoDaddy for their DNS work, and their virtual
server prices are good. You should see if that is cheap enough for you.)


On 1/12/06, Cutter <[EMAIL PROTECTED]> wrote:
> Looking for a very affordable (I'm still poor) CF Domain Hosting for a 
> single domain with support for Ray's BlogCFC, MySQL 4.1x+, 5 or six 
> IMAP mail accounts. Someplace I can eventually show off a small sample 
> app or two. Any suggestions?
>
> Cutter
>
> 



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

RE: CF Blog Hosting

[Snake]

If you want cheap or free and it's non commercial, try www.cfdeveloper.co.uk
 

-Original Message-
From: Cutter [mailto:[EMAIL PROTECTED] 
Sent: 12 January 2006 14:00
To: CF-Talk
Subject: CF Blog Hosting

Looking for a very affordable (I'm still poor) CF Domain Hosting for a
single domain with support for Ray's BlogCFC, MySQL 4.1x+, 5 or six IMAP
mail accounts. Someplace I can eventually show off a small sample app or
two. Any suggestions?

Cutter



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

Re: Query of query error

[Robert Everland III]

I'm just trying to integrate the new changes to lighthouse into the 6.1 
version, nothing crazy. I did a dump of the query and it has the column in it



select  *
fromissues
where   1=1



and bugtype = 




and locusidfk = 




and severityidfk = 



 
and statusidfk = 



 
and useridfk = 



 
and (upper(name) like 
 or
 upper(description) like )




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