Re: Open Source Store?

[Dave l]

only free one i can recall
http://www.cfshopkart.com/



>I recall awhile back when there was a discussion about a year or 2 ago
>on this list about free web ecommerce stores and it led me to a really
>fantastic application that handled all my needs. It had a menu on the
>left side, full ecommerce, customizable web pages, ran on MySQL, etc.
>It was everything I could ask for in an open source app.
>
>1 hard disk crash later and loss of email and no real need (until now)
>to retrack it down (I since gave out the FTP access to the client and
>no longer was part of the project), I find myself in need of it again
>but I can't REMEMBER THE NAME!!!
>
>So I will ask again and hopefully, I'll find my oasis again. :) Does
>anyone know of such an app that is fully open source? I looked on RIA
>Forge which is where I thought I found it before (or was led to), but
>the only 3 ecommerce apps were all pre-beta.
>
>Can anyone help a brotha out? :) 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324848
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: WildCard query

[David McGuigan]

You can grab a list of all of the columns of any table and loop through them
pretty easily ( they syntax varies with your database vendor ).

MySQL is just:

describe tableName


On Wed, Jul 22, 2009 at 9:10 PM, Tom Jones  wrote:

>
> Hello,
> I'm migrating some pages from Lasso to Coldfusion and one of the
> current pages in Lasso has a query to search any field/column for a
> value. I have never done this with coldsuion before so I'm not sure
> how to go about this.
>
> thanks,
> tom
>
>
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324847
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: ecommerce emergency

[Justin Scott]

> So I hear what you are saying. Just with even
> a low price point, I can't afford it.

Get your client to pay for it then. :)  If they're going to be doing online
sales, it should be pretty easy for them to front the $400 license fee as a
cost of doing business.  Whenever I'm working with a client and need outside
components or software I just tell them what they will need (hosting, cart
software, merchant account, etc.) and point them to the right places to go
acquire all of those things and bring them back to me so I can do all of the
setup and customization for them.  If they can't swing $400 for a decent
online store...


-Justin


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324846
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ecommerce emergency

[Phillip Vector]

Fair enough. Once I get a few bucks into my pocket, I'll look into it.
But for now, I need to give him some freeware and charge him to set it
up.

So I hear what you are saying. Just with even a low price point, I
can't afford it.

On Wed, Jul 22, 2009 at 8:28 PM, C. Hatton Humphrey wrote:
>
>> That's all well and good, but I know for me personally, I don't have
>> any cash at the moment. Unless you are willing to loan me some money
>> to pay for it (I need it within the week), then I'll have to make due
>> with what I got. :)
>
> I waited for someone else to say it but +1 for CF Webstore.  The price
> point is set so well that it would cost you more in man hours to build
> it than to buy it.  It's actively developed, customizable and
> constantly growing.
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324845
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ecommerce emergency

[C. Hatton Humphrey]

> That's all well and good, but I know for me personally, I don't have
> any cash at the moment. Unless you are willing to loan me some money
> to pay for it (I need it within the week), then I'll have to make due
> with what I got. :)

I waited for someone else to say it but +1 for CF Webstore.  The price
point is set so well that it would cost you more in man hours to build
it than to buy it.  It's actively developed, customizable and
constantly growing.

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324844
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

WildCard query

[Tom Jones]

Hello,
I'm migrating some pages from Lasso to Coldfusion and one of the  
current pages in Lasso has a query to search any field/column for a  
value. I have never done this with coldsuion before so I'm not sure  
how to go about this.

thanks,
tom



  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324843
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ecommerce emergency

[Phillip Vector]

On Wed, Jul 22, 2009 at 7:53 PM, Kevan Stannard wrote:
>
> Phillip, you might need to double check but last I looked cfshopkart it was
> storing credit card details in its database (an MS Access database). And if
> you're on shared hosting this this db is likely to be web accessible. If
> this is still the case then avoid this cart.

If this is the case, then I will remove it. I do know however the following.

1) MySQL is useable with it now.
2) My client wants to use Paypal only, so it's easy to strip it out.

> Mike, cfshopkart was one of the authors first cf applications so is not a
> good example of a well designed or coded app.

It has been 5 years since he started it, but last update was April
21st, 2009. So I think it's a bit better then you may recall it.

> I'd recommend going with James' advise:
>
> http://www.cfwebstore.com

That's all well and good, but I know for me personally, I don't have
any cash at the moment. Unless you are willing to loan me some money
to pay for it (I need it within the week), then I'll have to make due
with what I got. :)

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324842
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ecommerce emergency

[Chris Montgomery]

James Holmes said the following on 7/22/2009 9:21 PM:
> The only sane advice, given those conditions, is to buy a cart product
> (e.g. http://www.cfwebstore.com/).

+1
Well worth the money when you consider the headaches and time it will save.

-- 
Best regards,

Chris Montgomery

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324841
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ecommerce emergency

[Kevan Stannard]

Phillip, you might need to double check but last I looked cfshopkart it was
storing credit card details in its database (an MS Access database). And if
you're on shared hosting this this db is likely to be web accessible. If
this is still the case then avoid this cart.
Mike, cfshopkart was one of the authors first cf applications so is not a
good example of a well designed or coded app.

I'd recommend going with James' advise:

http://www.cfwebstore.com




2009/7/23 Phillip Vector 

>
> Just figured it out what I was looking for (and it seems we have the
> same issue).
>
> http://www.cfshopkart.com/
>
> :)
>
> On Wed, Jul 22, 2009 at 7:00 PM, mike pop wrote:
> >
> > i have 2 months to learn how to build an entire ecommerce application.
>  i've been in the finance field for so long that ecommerce is a completely
> new industry for me.
> >
> > to be honest, i wouldn't know if cookies or client variables are the best
> choice for cart storage.  what data should i store in session variables?
>  the basic ecommerce questions are things that I have not been exposed to
> before.
> >
> > there's lots of snippets here and there; lots of basic material in books
> and tutorials.
> >
> > i need something to tie everything together.  i found a free coldfusion
> app but this spaghetti code is so old that it's like looking at code from a
> time machine.
> >
> > all recommendations and advice welcome.  if anything, the first step is
> building the admin interface for products, categories/subcategories,
> customers, orders, shipping, and payment (only credit card and COD
> available).
> >
> > the customer site will come later.
> >
> >
> >
> >
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324840
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: ecommerce emergency

[Justin Scott]

> The only sane advice, given those conditions, is
> to buy a cart product (e.g. http://www.cfwebstore.com/).

Seconded.  It's hard to be involved in web development and not have to do
e-commerce at some point, but there are so many things to deal with that I
would highly recommend you work with a team that has experience so you can
learn more about the pitfalls before going at it on your own (or purchase a
reputable pre-built application like CFWebStore to get started).  Every
client will have different needs for shipping, taxes, how payments are
handled, etc.  There are also regulations such as the PCI-DSS that have to
be dealt with if you're taking credit cards directly on your store (i.e. not
through PayPal or the like).  It's certainly not something to be approached
lightly.  I wish you the best of luck with your project though.


-Justin


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324839
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ecommerce emergency

[Phillip Vector]

Just figured it out what I was looking for (and it seems we have the
same issue).

http://www.cfshopkart.com/

:)

On Wed, Jul 22, 2009 at 7:00 PM, mike pop wrote:
>
> i have 2 months to learn how to build an entire ecommerce application.  i've 
> been in the finance field for so long that ecommerce is a completely new 
> industry for me.
>
> to be honest, i wouldn't know if cookies or client variables are the best 
> choice for cart storage.  what data should i store in session variables?  the 
> basic ecommerce questions are things that I have not been exposed to before.
>
> there's lots of snippets here and there; lots of basic material in books and 
> tutorials.
>
> i need something to tie everything together.  i found a free coldfusion app 
> but this spaghetti code is so old that it's like looking at code from a time 
> machine.
>
> all recommendations and advice welcome.  if anything, the first step is 
> building the admin interface for products, categories/subcategories, 
> customers, orders, shipping, and payment (only credit card and COD available).
>
> the customer site will come later.
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324838
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ecommerce emergency

[James Holmes]

The only sane advice, given those conditions, is to buy a cart product
(e.g. http://www.cfwebstore.com/).

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

2009/7/23 mike pop :
>
> i have 2 months to learn how to build an entire ecommerce application.  i've 
> been in the finance field for so long that ecommerce is a completely new 
> industry for me.
>
> to be honest, i wouldn't know if cookies or client variables are the best 
> choice for cart storage.  what data should i store in session variables?  the 
> basic ecommerce questions are things that I have not been exposed to before.
>
> there's lots of snippets here and there; lots of basic material in books and 
> tutorials.
>
> i need something to tie everything together.  i found a free coldfusion app 
> but this spaghetti code is so old that it's like looking at code from a time 
> machine.
>
> all recommendations and advice welcome.  if anything, the first step is 
> building the admin interface for products, categories/subcategories, 
> customers, orders, shipping, and payment (only credit card and COD available).
>
> the customer site will come later.
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324837
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ecommerce emergency

[Greg Luce]

Here is a fusebox shopping cart app that might be a good starting point:
http://www.briankotek.com/index.cfm?fuseaction=content.viewcontentitem&contentid=47&returnto=coldfusion.main

Greg

On Wed, Jul 22, 2009 at 10:00 PM, mike pop  wrote:

>
> i have 2 months to learn how to build an entire ecommerce application.
>  i've been in the finance field for so long that ecommerce is a completely
> new industry for me.
>
> to be honest, i wouldn't know if cookies or client variables are the best
> choice for cart storage.  what data should i store in session variables?
>  the basic ecommerce questions are things that I have not been exposed to
> before.
>
> there's lots of snippets here and there; lots of basic material in books
> and tutorials.
>
> i need something to tie everything together.  i found a free coldfusion app
> but this spaghetti code is so old that it's like looking at code from a time
> machine.
>
> all recommendations and advice welcome.  if anything, the first step is
> building the admin interface for products, categories/subcategories,
> customers, orders, shipping, and payment (only credit card and COD
> available).
>
> the customer site will come later.
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324836
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

ecommerce emergency

[mike pop]

i have 2 months to learn how to build an entire ecommerce application.  i've 
been in the finance field for so long that ecommerce is a completely new 
industry for me.  

to be honest, i wouldn't know if cookies or client variables are the best 
choice for cart storage.  what data should i store in session variables?  the 
basic ecommerce questions are things that I have not been exposed to before.

there's lots of snippets here and there; lots of basic material in books and 
tutorials.

i need something to tie everything together.  i found a free coldfusion app but 
this spaghetti code is so old that it's like looking at code from a time 
machine.

all recommendations and advice welcome.  if anything, the first step is 
building the admin interface for products, categories/subcategories, customers, 
orders, shipping, and payment (only credit card and COD available).

the customer site will come later.



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324835
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Log In Form

[Arsalan Tariq Keen]

The approach used by Alan is nice... I guess that's is the most common one 
used ...
besides ... don't ever tell the visitor that he/she entered the WRONG 
PASSWORD ... that's just affirming that they entered the right username ... 
hence doing 50% of their work if they are trying to break into your system 
:)

I hope you get the point :)

Regards,
Arsalan

--
From: "Barry Mcconaghey" 
Sent: Thursday, July 23, 2009 6:35 AM
To: "cf-talk" 
Subject: Re: Log In Form

>
> Thanks Alan.
>
> I'll test it.
>
>>It's not real or tested, but it should give you an idea how to do it.
>>
>>=]
>>
>>
>>
>>SELECT UserUUID, UserName
>>FROM SomeTable
>>WHERE
>>UserName = >value="#Form.userLogin#">
>>AND
>>User_IsActive = 1
>>
>>
>>
>>
>>
>>SELECT UserUUID, UserName
>>FROM SomeTable
>>WHERE
>>UserUUID = >value="#variables.qCheckUN.UserUUID#">
>>AND
>>User_Password = >value="#Form.userLogin#">
>>AND
>>User_IsActive = 1
>>
>> 
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>>method="post">
>> 
>> 
>> 
>> 
>> 
>> 
>>  
>>#variables.ErrorMessage#
>>
>> 
>>
>> 
>> Username:
>> 
>>
>> 
>> > type="text"
>> name="userLogin"
>> size="20"
>> value="#Form.userLogin#"
>> maxlength="100"
>> required="Yes"
>> message="Please type your Username first.">
>>
>> 
>> 
>> Password:
>> 
>>
>> 
>> > type="password"
>> name="userPassword"
>> size="12"
>> value="#Form.userPassword#"
>> maxlength="100"
>> required="Yes"
>> message="Please type your Password first.">
>>
>> 
>> > value="Enter"
>> title="Enter">
>> 
>> 
>> 
>>
>>
>>-- 
>>Alan Rother
>>Adobe Certified Advanced ColdFusion MX 7 Developer
>>Manager, Phoenix Cold Fusion User Group, AZCFUG.org
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324834
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Calling .ASPX.VB from .CFM

[Casey Dougall]

On Wed, Jul 22, 2009 at 6:06 PM, Jason Neidert wrote:

>
>
> How can I accomplish the creation of the object CheckAvailabilityRQ using
> ColdFusion?
>
> name = "IRMPublic">
>webservice= "http://resortdata.com/IRMPublic";
>type = "webservice"
>wsportname = "IRMPublicMethodsSoap">
>
> Then use CFINVOKE or something to create an instance of
> 'IRMPublic.CheckAvailability_irmRQ'?
>
> I think I am getting closer...
>

you try something like this? not sure what the actual url is to api




  http://resortdata.com/IRMPublic";>

  
22352345234
234523452354
235234523452
52345234523
  
  
2009-08-20
2009-08-22
single
2
0
0
0
  

  



  





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324833
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Log In Form

[Barry Mcconaghey]

Thanks Alan.

I'll test it.

>It's not real or tested, but it should give you an idea how to do it.
>
>=]
>
>
>
>SELECT UserUUID, UserName
>FROM SomeTable
>WHERE
>UserName = value="#Form.userLogin#">
>AND
>User_IsActive = 1
>
>
>
>
>
>SELECT UserUUID, UserName
>FROM SomeTable
>WHERE
>UserUUID = value="#variables.qCheckUN.UserUUID#">
>AND
>User_Password = value="#Form.userLogin#">
>AND
>User_IsActive = 1
>
> 
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>method="post">
> 
> 
> 
> 
> 
> 
>  
>#variables.ErrorMessage#
>
> 
>
> 
> Username:
> 
>
> 
>  type="text"
> name="userLogin"
> size="20"
> value="#Form.userLogin#"
> maxlength="100"
> required="Yes"
> message="Please type your Username first.">
>
> 
> 
> Password:
> 
>
> 
>  type="password"
> name="userPassword"
> size="12"
> value="#Form.userPassword#"
> maxlength="100"
> required="Yes"
> message="Please type your Password first.">
>
> 
>  value="Enter"
> title="Enter">
> 
> 
> 
>
>
>-- 
>Alan Rother
>Adobe Certified Advanced ColdFusion MX 7 Developer
>Manager, Phoenix Cold Fusion User Group, AZCFUG.org 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324832
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Log In Form

[Alan Rother]

It's not real or tested, but it should give you an idea how to do it.

=]



SELECT UserUUID, UserName
FROM SomeTable
WHERE
UserName = 
AND
User_IsActive = 1





SELECT UserUUID, UserName
FROM SomeTable
WHERE
UserUUID = 
AND
User_Password = 
AND
User_IsActive = 1

 
















 
 
 
 
 
 
  
#variables.ErrorMessage#

 

 
 Username:
 

 
 

 
 
 Password:
 

 
 

 
 
 
 
 


-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324831
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Log In Form

[Alan Rother]

Yeah... Gimmie a sec, I'll knock a quick demo out...
=]
-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324830
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Log In Form

[Barry Mcconaghey]

Good point...

Maybe I'll just say "Wrong Paco"

OK now for the dumb question.

Where do I add the code???

I just think it would be nice to tell the visitors what went wrong.
>(Wrong username, password, or both).
>I wouldn't recommend doing that. If someone is trying to gain illicit access
>to your site, your providing them with helpful information. For example, if
>you tell them they got their username right, then they just have to brute
>force attack the form with random passwords until they get in.
>However, if you still want to do this, it's pretty easy.
>
>First check in one query to see if the user name is in the database then if
>it is in a second query see if that username and password are both in the
>database in the same record.
>
>If it is, then log them in.
>
>If they pass the first query test, but not the second, then you know they
>entered the right username, but wrong password, this can be verified by
>checking the queryname.RecordCount on the first query. If it's GT 0 they
>have a username in the database.
>
>If they fail the first one, then they inherently failed the second test, so
>you can pass back a message stating they entered an invalid
>username/password combination.
>
>=]
>
>-- 
>Alan Rother
>Adobe Certified Advanced ColdFusion MX 7 Developer
>Manager, Phoenix Cold Fusion User Group, AZCFUG.org 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324829
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Log In Form

[Alan Rother]

>>>I just think it would be nice to tell the visitors what went wrong.
(Wrong username, password, or both).
I wouldn't recommend doing that. If someone is trying to gain illicit access
to your site, your providing them with helpful information. For example, if
you tell them they got their username right, then they just have to brute
force attack the form with random passwords until they get in.
However, if you still want to do this, it's pretty easy.

First check in one query to see if the user name is in the database then if
it is in a second query see if that username and password are both in the
database in the same record.

If it is, then log them in.

If they pass the first query test, but not the second, then you know they
entered the right username, but wrong password, this can be verified by
checking the queryname.RecordCount on the first query. If it's GT 0 they
have a username in the database.

If they fail the first one, then they inherently failed the second test, so
you can pass back a message stating they entered an invalid
username/password combination.

=]

-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324828
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Log In Form

[Barry Mcconaghey]

Hello.

I'm using this log in form for my website but went a user types in the wrong 
username or password, I would like to display an error message "Sorry...wrong 
username" or "Sorry...wrong password". As of now this form, if wrong, returns 
back to loginform.cfm.

I just think it would be nice to tell the visitors what went wrong. (Wrong 
username, password, or both).

Thanks for HELP!

Barry

LoginForm

 
 



 
 
 
 
 
 
 Username:
 
 
  
 

 
 
 Password:
 
 
  
 

  
 
 
 
 


Logincheck.cfm








 SELECT *
 FROM Contacts
 WHERE UserLogin = '#FORM.UserLogin#'
 AND UserPassword = '#FORM.UserPassword#'




 
 
 
 
 
 
 
 
 

 
 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324827
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Open Source Store?

[Phillip Vector]

I recall awhile back when there was a discussion about a year or 2 ago
on this list about free web ecommerce stores and it led me to a really
fantastic application that handled all my needs. It had a menu on the
left side, full ecommerce, customizable web pages, ran on MySQL, etc.
It was everything I could ask for in an open source app.

1 hard disk crash later and loss of email and no real need (until now)
to retrack it down (I since gave out the FTP access to the client and
no longer was part of the project), I find myself in need of it again
but I can't REMEMBER THE NAME!!!

So I will ask again and hopefully, I'll find my oasis again. :) Does
anyone know of such an app that is fully open source? I looked on RIA
Forge which is where I thought I found it before (or was led to), but
the only 3 ecommerce apps were all pre-beta.

Can anyone help a brotha out? :)

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324826
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Calling .ASPX.VB from .CFM

[Jason Neidert]

Digging deeper...

Using a program called 'Altova MapForce'. Opened the WSDL file in there,
here are the global settings.

WSDL Definitions:
http://irm.resortdata.com/LutsenInterface/IRMPublic.asmx?wsdl
Service: {http://resortdata.com/IRMPublic}IRMPublicMethods
Port: IRMPublicMethodsSoap
Operation: {http://resortdata.com/IRMPublic}CheckAvailability

Endpoint: http://irm.resortdata.com/LutsenInterface/IRMPublic.asmx

Looking again at the aspx.vb file:

Dim CheckAvailabilityRQ As New IRMPublic.CheckAvailability_irmRQ
(in the VB file it appears they are creating a new object from the def.
IRMPublic.CheckAvailability_irmRQ) 

How can I accomplish the creation of the object CheckAvailabilityRQ using
ColdFusion?


webservice= "http://resortdata.com/IRMPublic";
type = "webservice"
wsportname = "IRMPublicMethodsSoap">

Then use CFINVOKE or something to create an instance of
'IRMPublic.CheckAvailability_irmRQ'?

I think I am getting closer...

 



-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Wednesday, July 22, 2009 1:11 PM
To: cf-talk
Subject: Re: Calling .ASPX.VB from .CFM


> SO... if I use CFINVOKE I am not quite sure what to pass in the
> CFINVOKEARGUMENT
>
> Do I attempt to create a large structure and pass it in under
> 'CheckAvailability_irmRQ'?

I think you'll need a little more than that; you'll need CFCs to
represent the objects and you'll need to use CFPROPERTY to name the
properties of those objects in a way that the CF WSDL stub builder
will be able to map to the original WSDL. For example, a Credentials
object:




   ... other properties go here ...
   ... code to populate those properties goes here ...


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!



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324825
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF8 functions only working in webroot?

[Paul Henderson]

The virtual directory did the trick, thanks Adrian

-Original Message-
From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] 
Sent: Wednesday, July 22, 2009 5:07 PM
To: cf-talk
Subject: RE: CF8 functions only working in webroot?


All the AJAXy tags and function access files in domain.com/cfide/blaa/blaa.

Add CFIDE as a virtual directory in your new sites and see if that fixes it.

Adrian


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324824
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Calling .ASPX.VB from .CFM

[Jason Neidert]

Dave,

I dug more and here is the aspx.vb file which .NET uses to create the
objects:

In the web.config file there is a setting:

http://irm.resortdata.com/LutsenInterface/IRMPublic.asmx"/>


Then in the aspx.vb file:

 Dim irm As New IRMPublic.IRMPublicMethods

  Dim CheckAvailabilityRQ As New IRMPublic.CheckAvailability_irmRQ
  Dim CheckAvailabilityRS As IRMPublic.CheckAvailability_irmRS

  With CheckAvailabilityRQ
.Credentials = New IRMPublic.irmWebSvcCredentials
'loginid/password for testing
.Credentials.LogonID = "IRMTest"
.Credentials.Password = "1qasw2"
'DataPath dependant on propery installation, for demo use
c:/rdp1202/rdp95
.Credentials.DataPath = txtDataPath.Text
'Unique id between 29000-2 for each session, set in Global.asax
.Credentials.DatabaseID = Session("DatabaseID").ToString


.AvailabilityRequest = New IRMPublic.irmDatesRoomInfo
With .AvailabilityRequest
  'Current date in demo files is 03/01/1998
  .ArrivalDate = CType(txtArrival.Text, Date)
  .DepartureDate = CType(txtDeparture.Text, Date)
  'Valid room types for demo: DD, Q, QQ, K, KA, PH
  .RoomType = txtRoom.Text
  .People1 = CType(ddPeople.SelectedValue, Int32)
  .People2 = 0 : .People3 = 0 : .People4 = 0
End With
  End With

  CheckAvailabilityRS = irm.CheckAvailability(CheckAvailabilityRQ)

SO, I am thinking that CFINVOKE will call the method 'CheckAvailability'

I will need to pass it the CheckAvailabilityRQ object

The CheckAvailabilityRQ object will contain the 'Credentials' and the
'AvailabilityRequest' objects that you gave me insight on how to create via
CFCOMPONENT. 

Once I create the 'Credentials' and 'AvailabilityRequest' objects how do I
nest them inside an object called 'CheckAvailabilityRQ'?






-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Wednesday, July 22, 2009 1:11 PM
To: cf-talk
Subject: Re: Calling .ASPX.VB from .CFM


> SO... if I use CFINVOKE I am not quite sure what to pass in the
> CFINVOKEARGUMENT
>
> Do I attempt to create a large structure and pass it in under
> 'CheckAvailability_irmRQ'?

I think you'll need a little more than that; you'll need CFCs to
represent the objects and you'll need to use CFPROPERTY to name the
properties of those objects in a way that the CF WSDL stub builder
will be able to map to the original WSDL. For example, a Credentials
object:




   ... other properties go here ...
   ... code to populate those properties goes here ...


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!



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324823
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF8 functions only working in webroot?

[Adrian Lynch]

All the AJAXy tags and function access files in domain.com/cfide/blaa/blaa.

Add CFIDE as a virtual directory in your new sites and see if that fixes it.

Adrian

> -Original Message-
> From: Paul Henderson [mailto:pa...@d2phosting.com]
> Sent: 22 July 2009 21:14
> To: cf-talk
> Subject: CF8 functions only working in webroot?
> 
> 
> I'm not sure why this is but I'm working on a new CF8 install using IIS
> and
> for whatever reason the CF8 functions such as cflayout only seem to
> work in
> the webroot and default site. All other CF functionality works on the
> sub
> sites. Any ideas why I'm facing this issue?
> 
> 
> 
> Thanks in advance
> 
> -Paul


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324822
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Calling .ASPX.VB from .CFM

[Jason Neidert]

Dave,

That definitely points me in a better direction, thank you.

One other thing that is confusing me however is how the complex types of the
WSDL are pointing to other complex types. For instance, in this following
bit of the WSDL:



 


  



 
 




The element 'CheckAvailability' defines a complex type of
'CheckAvailability_irmRQ'. 

'CheckAvailability_irmRQ' is later defined as a complex type that points to
two other complex types within the WSDL. 

I'm trying to wrap my brain around how to create and send complex objects to
the web service but it's hurting. I know that the data to be sent in is:
String: dataPath
String: LogonID
String: Password
String: DatabaseID
String: RoomType
DateTime: ArrivalDate
DateTime: DepartureDate
Int: People1
Int: People2
Int: People3 
Int: People4

How can it be so tricky to get these values into cold fusion objects that
will map correctly the XML of this WSDL? Just a bit more insight and I
promise I won't write again until I have exhausted all newly found help.






-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Wednesday, July 22, 2009 1:11 PM
To: cf-talk
Subject: Re: Calling .ASPX.VB from .CFM


> SO... if I use CFINVOKE I am not quite sure what to pass in the
> CFINVOKEARGUMENT
>
> Do I attempt to create a large structure and pass it in under
> 'CheckAvailability_irmRQ'?

I think you'll need a little more than that; you'll need CFCs to
represent the objects and you'll need to use CFPROPERTY to name the
properties of those objects in a way that the CF WSDL stub builder
will be able to map to the original WSDL. For example, a Credentials
object:




   ... other properties go here ...
   ... code to populate those properties goes here ...


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!



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324821
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF8 functions only working in webroot?

[Paul Henderson]

I'm not sure why this is but I'm working on a new CF8 install using IIS and
for whatever reason the CF8 functions such as cflayout only seem to work in
the webroot and default site. All other CF functionality works on the sub
sites. Any ideas why I'm facing this issue?

 

Thanks in advance

-Paul

 

 

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324820
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: asynchronous form values

[David Mineer]

I had no luck figuring this out so I used another method.  I used
coldfusion.navigate to submit the form to a div at the bottom of the page.

This works great and is actually a nicer solution, but I still I wish I knew
how to make asynchronous form values stick.

On Mon, Jul 20, 2009 at 2:25 PM, David Mineer  wrote:

> I have a form page.  Several of the fields are cfselect dropdowns with bind
> values that relate them to each other.  I save the values in an object in
> session scope.
>
> This page by itself works perfect.  You choose values, submit the form and
> when the page comes back, the values you chose are preselected.
>
> The problem is that I want the page as part of a tabbed interface.  So the
> main page contains several tabs, and the page in question pulls up when you
> click on "it's" tab.
>
> When the form is submitted from within the tab, the default values are not
> selected.  My research tells me that form values submitted asynchronously
> are not saved like you would expect in a normal page submit.
>
> How can I save and reference the chosen form values when the from is
> asynchronous.
>
> --
> David Mineer Jr
> -
> The critical ingredient is getting off your
> butt and doing something. It's as simple
> as that. A lot of people have ideas, but
> there are few who decide to do
> something about them now. Not
> tomorrow. Not next week. But today.
> The true entrepreneur is a doer.
>



-- 
David Mineer Jr
-
The critical ingredient is getting off your
butt and doing something. It's as simple
as that. A lot of people have ideas, but
there are few who decide to do
something about them now. Not
tomorrow. Not next week. But today.
The true entrepreneur is a doer.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324819
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

verity search

[Chad Gray]

Is verity case sensitive on a search?

I type in Test and test and get different results.

Is there a way to make it not case sensitive?


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324818
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: scrolling thumbnails delema

[Alan Rother]

Check out Ben Nadel's Image Utils CFC on RiaForge.com, it should help with
the cropping (he's done all the hard work for you)
http://imageutils.riaforge.org/


As for Pagination, check out Nathan
Strutz's Pagination.cfc

http://paginationcfc.riaforge.org/


HTH

=]


-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324817
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

scrolling thumbnails delema

[Richard Dillman]

I need to add an image up loader to a clients site.
I need to create thumbnails during the upload.
I need an auto scrolling container to hold all the thumbnails. Pagination is
optional.
I need to plan on having 300+ products at any one time in this scroller.

I cannot dictate to the photographer what shape to make the image, so I will
have both portrate landscape and Square. (this is where i run into problems)

I have available MS SQL 2005, Coldfusion 8, and whatever Ajax I want, altho
i have not used much Ajax yet.

What suggestions would you all make?

-- 
-- 
Richard Dillman
rdill...@gmail.com

"There are painters who transform the sun to a yellow spot, but there are
others who with the help of their art and their intelligence, transform a
yellow spot into the sun."
- Pablo Picasso


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324816
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Calling .ASPX.VB from .CFM

[Dave Watts]

> SO... if I use CFINVOKE I am not quite sure what to pass in the
> CFINVOKEARGUMENT
>
> Do I attempt to create a large structure and pass it in under
> 'CheckAvailability_irmRQ'?

I think you'll need a little more than that; you'll need CFCs to
represent the objects and you'll need to use CFPROPERTY to name the
properties of those objects in a way that the CF WSDL stub builder
will be able to map to the original WSDL. For example, a Credentials
object:




   ... other properties go here ...
   ... code to populate those properties goes here ...


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!

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324815
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFML Code Colorizer for display on a web page.

[Gerald Guido]

That's the one. Thanx... I was searching for the wrong thing.

G!

On Wed, Jul 22, 2009 at 1:17 PM, Charlie Griefer
wrote:

>
> check out http://coldfish.riaforge.org/
>
> On Wed, Jul 22, 2009 at 10:06 AM, Gerald Guido  >wrote:
>
> >
> > I have been looking around on Google, CFLib and RIAforge for something to
> > colorize CF code (and CSS,JS, html if possible) such that it can be
> > displayed on a web page. I am pretty sure I have seen one before, I just
> > can't seem to find it.
> >
> > Does anyone know off hand of a CFC or UDF that will do this. I saw a
> plugin
> > for mango blog and Ben Nadel had a code example that didn't look like it
> > was
> > finished. I was looking for something that would (hopefully) work out of
> > the
> > box.
> >
> > As always, many TIA
> >
> > G!
> >
> > --
> > Gerald Guido
> > http://www.myinternetisbroken.com
> > http://www.cfsimple.org/
> >
> > "To invent, you need a good imagination and a pile of junk."
> > -- Thomas A. Edison
> >
> >
> >
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324814
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFML Code Colorizer for display on a web page.

[Wil Genovese]

Yeah, Jason Delmore wrote one that gets included into BlogCFC.  It's called
Cold Fish.

http://coldfish.riaforge.org/

Wil Genovese
Sr. Web Application Developer




On Wed, Jul 22, 2009 at 12:06 PM, Gerald Guido wrote:

>
> I have been looking around on Google, CFLib and RIAforge for something to
> colorize CF code (and CSS,JS, html if possible) such that it can be
> displayed on a web page. I am pretty sure I have seen one before, I just
> can't seem to find it.
>
> Does anyone know off hand of a CFC or UDF that will do this. I saw a plugin
> for mango blog and Ben Nadel had a code example that didn't look like it
> was
> finished. I was looking for something that would (hopefully) work out of
> the
> box.
>
> As always, many TIA
>
> G!
>
> --
> Gerald Guido
> http://www.myinternetisbroken.com
> http://www.cfsimple.org/
>
> "To invent, you need a good imagination and a pile of junk."
> -- Thomas A. Edison
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324813
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: dynamic EXCEL print header/footer using coldfusion & MSSQL

[Tony Bentley]

I found a way to do it using VBS here:

http://www.cpearson.com/excel/headfoot.htm

Which is a shortcut that grabs field/s in one of the sheets as the header 
value/s. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324812
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFML Code Colorizer for display on a web page.

[Charlie Griefer]

check out http://coldfish.riaforge.org/

On Wed, Jul 22, 2009 at 10:06 AM, Gerald Guido wrote:

>
> I have been looking around on Google, CFLib and RIAforge for something to
> colorize CF code (and CSS,JS, html if possible) such that it can be
> displayed on a web page. I am pretty sure I have seen one before, I just
> can't seem to find it.
>
> Does anyone know off hand of a CFC or UDF that will do this. I saw a plugin
> for mango blog and Ben Nadel had a code example that didn't look like it
> was
> finished. I was looking for something that would (hopefully) work out of
> the
> box.
>
> As always, many TIA
>
> G!
>
> --
> Gerald Guido
> http://www.myinternetisbroken.com
> http://www.cfsimple.org/
>
> "To invent, you need a good imagination and a pile of junk."
> -- Thomas A. Edison
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324811
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF9 and Bolt in eWEEK

[Casey Dougall]

On Wed, Jul 15, 2009 at 11:15 AM, george.e...@ssa.gov george.e...@ssa.gov <
george.e...@ssa.gov> wrote:

>
>
> http://www.eweek.com/c/a/Application-Development/Adobe-Delivers-Beta-of-ColdFusion-9-and-ColdFusion-Builder-IDE-361260/?kc=EWKNLNAV07152009STR5
>
> George
>



Eweek arrived in mailbox today... No mention of Coldfusion :-(


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324810
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFML Code Colorizer for display on a web page.

[Gerald Guido]

I have been looking around on Google, CFLib and RIAforge for something to
colorize CF code (and CSS,JS, html if possible) such that it can be
displayed on a web page. I am pretty sure I have seen one before, I just
can't seem to find it.

Does anyone know off hand of a CFC or UDF that will do this. I saw a plugin
for mango blog and Ben Nadel had a code example that didn't look like it was
finished. I was looking for something that would (hopefully) work out of the
box.

As always, many TIA

G!

-- 
Gerald Guido
http://www.myinternetisbroken.com
http://www.cfsimple.org/

"To invent, you need a good imagination and a pile of junk."
-- Thomas A. Edison


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324809
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Calling .ASPX.VB from .CFM

[Jason Neidert]

I am beginning to see how WSDL works here and how I will be able to call it
via CFINVOKE.

If I want to call the method called 'CheckAvailability' I am still a bit
sketchy on what data structures to pass.

It appears that:

 - CheckAvailability CALLS CheckAvailability_irmRQ
 - CheckAvailability_irmRQ CALLS Credentials
 - Credentials CALLS irmWebSvcCredentials
 - - irmWebSvcCredentials is looking for a structure containing 4
strings

 - CheckAvailability_irmRQ ALSO CALLS AvailabilityRequest
 - AvailabilityRequest  CALLS irmDatesRoomInfo
 - - irmDatesRoomInfo is looking for a structure that contains 2
dates, 1 string and 4 integers


SO... if I use CFINVOKE I am not quite sure what to pass in the
CFINVOKEARGUMENT

Do I attempt to create a large structure and pass it in under
'CheckAvailability_irmRQ'?


Here is an example I was provided of the SOAP request to check availability:

http://resortdata.com/IRMPublic";>
  

  string
  string
  string
  string


  dateTime
  dateTime
  string
  int
  int
  int
  int

  

  





-Original Message-
From: James Holmes [mailto:james.hol...@gmail.com] 
Sent: Saturday, July 18, 2009 7:13 PM
To: cf-talk
Subject: Re: Calling .ASPX.VB from .CFM


Yes, look at the request in the WSDL:



  

and then



  

  

  
  

  
  

  
  

  
  
  
  

  
  

  
  
  
  
  
  
  

  

There's a lot of work building the correct request type for that service.

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

2009/7/19 Adrian Lynch:
>
> Yes. Chances are you need to pass arguments along with your method call.
>
>> -Original Message-
>> From: Jason Neidert
>> Sent: 17 July 2009 18:50
>> To: cf-talk
>> Subject: RE: Calling .ASPX.VB from .CFM
>>...
>> It tells me that CheckAvailability cannot be found. I can see the it
>> though
>> in the wsdl file. Am I calling incorrectly?



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324808
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

dynamic EXCEL print header/footer using coldfusion & MSSQL

[Tony Bentley]

Does anyone know of a way to insert a print header either using an external 
source using SQL, CF and possibly POI?



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324807
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF app control

[Don L]

I don't think you know how my app is going to be deployed.  Of course one 
should trust their customers.

> On Tuesday 21 Jul 2009, Don L wrote:
> > Thank you for your thoughts.
> 
> See also defectivebydesign.org - if you can't trust your paying 
> customers you 
> have bigger issues.
> 
> -- 
> Helping to authoritatively incentivize IPOs as part of the IT team of 
> the 
> year, '09 and '08
> 
> 
> 
> This email is sent for and on behalf of Halliwells LLP.
> 
> Halliwells LLP is a limited liability partnership registered in 
> England and Wales under registered number OC307980 whose registered 
> office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, 
> Manchester, M3 3EB.  A list of members is available for inspection at 
> the registered office together with a list of those non members who 
> are referred to as partners.  We use the word “partner” to refer to a 
> member of the LLP, or an employee or consultant with equivalent 
> standing and qualifications. Regulated by the Solicitors Regulation 
> Authority.
> 
> CONFIDENTIALITY
> 
> This email is intended only for the use of the addressee named above 
> and may be confidential or legally privileged.  If you are not the 
> addressee you must not read it and must not use any information 
> contained in nor copy it nor inform any person other than Halliwells 
> LLP or the addressee of its existence or contents.  If you have 
> received this email in error please delete it and notify Halliwells 
> LLP IT Department on 0870 365 2500.
> 
> For more information about Halliwells LLP visit www.halliwells.
co

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324806
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cfgrid customization

[RamaDevi Dobbala]

hi frnds,

how to customize the cfgrid, based  on the no.of columns i am returning that 
many cfgridcolumns i need to display automatically, how can i do that, please 
any one can help me...


Rama 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324805
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: 8.0.1 webservice compile errors

[Sebastiaan GMC van Dijk]

It's even stranger. We've continued to test today and on one instance on one 
server the webservice runs without a hitch and on another server we get this 
error. Within the same domain. Alas it fails on the server where it should run 
and works on a server where it doesn't need to run... Crap!
Sebastiaan
=
So long and thanx 4 all the fish

==> Onlinebase.nl

> Date: Wed, 22 Jul 2009 15:15:53 +0100
> Subject: Re: 8.0.1 webservice compile errors
> From: tom.chiver...@halliwells.com
> To: cf-talk@houseoffusion.com
> 
> 
> On Wednesday 22 Jul 2009, Sebastiaan van Dijk wrote:
> > We get the same error on our
> > internal production servers, but our external servers seem to run the cfc
> > with no problem.
> 
> Could it be a proxy setting ?
> 
> -- 
> Helping to adaptively monetize industry-wide B2B appliances as part of the IT 
> team of the year, '09 and '08
> 
> 
> 
> This email is sent for and on behalf of Halliwells LLP.
> 
> Halliwells LLP is a limited liability partnership registered in England and 
> Wales under registered number OC307980 whose registered office address is at 
> Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
> of members is available for inspection at the registered office together with 
> a list of those non members who are referred to as partners.  We use the word 
> “partner” to refer to a member of the LLP, or an employee or consultant with 
> equivalent standing and qualifications. Regulated by the Solicitors 
> Regulation Authority.
> 
> CONFIDENTIALITY
> 
> This email is intended only for the use of the addressee named above and may 
> be confidential or legally privileged.  If you are not the addressee you must 
> not read it and must not use any information contained in nor copy it nor 
> inform any person other than Halliwells LLP or the addressee of its existence 
> or contents.  If you have received this email in error please delete it and 
> notify Halliwells LLP IT Department on 0870 365 2500.
> 
> For more information about Halliwells LLP visit www.halliwells.co
> 
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324804
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfquery

[RamaDevi Dobbala]

select  

iif(lm.user_id = s.lead_mgr, (lm.first + ' ' + 
lm.last) , s.lead_note)  as leadMgr, 

iif(lm.user_id = s.AREA_MGR_RDO, 
lm.first + ' ' + lm.last  , s.Area_Note)   as director
,
iif(lm.user_id = s.sdir_ndir, lm.first 
+ ' ' + lm.last , s.sdir_note) as sndir
,
iif(lm.user_id = s.vice_pre, lm.first + 
' ' + lm.last , s.vice_note)  as vicePre
,
iif(lm.user_id = s.fast_mgr, lm.first + 
' ' + lm.last , s.fast_note) as fastMgr
,   
from sourcebook_1 s,user_info lm
where s.active = 1 and  (lm.user_id = s.lead_mgr or 
lm.user_id = s.AREA_MGR_RDO or lm.user_id = s.sdir_ndir or lm.user_id = 
s.vice_pre or lm.user_id = s.fast_mgr)
and s.office_id not in(36,37,38,73)

order by s.office_number
 

i am writing like this, it is working fine, thanks for your response





>I think you want it this way, using a CASE statement for the leadmgr 
>column.  I also moved all your subselects into left joins, which should 
>give a bit better performance.
>
>
>select
>s.address + ' ' + s.address2 + ' ' + s.address3 + ',' + s.city + ',' + 
>s.state + ',' + s.city as office_address,
>leadmgr = case 
>when (lm.user_id is null) then lm.lead_note
>else lm.first + ' ' + lm.last
>end, 
>amr.first + ' ' + amr.last as director,
>sn.first + ' ' + sn.last as SDIRNDIR,
>vp.first + ' ' + vp.last as VICEPRE,
>fm.first + ' ' + fm.last as FASTMGR
>from sourcebook_1 s left outer join
>user_info lm on s.lead_mgr = lm.user_id left outer join
>user_info amr on s.area_mgr_rdo = amr.user_id left outer join
>user_info sn on s.sdir_ndir = sn.user_id left outer join
>user_info vp on s.vice_pre = vp.user_id left outer join
>user_info fm on s.fast_mgr = fm.user_id
>where active = 1
>and office_id not in (36,37,38,73)
>order by office_number
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324803
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: 8.0.1 webservice compile errors

[Tom Chiverton]

On Wednesday 22 Jul 2009, Sebastiaan van Dijk wrote:
> We get the same error on our
> internal production servers, but our external servers seem to run the cfc
> with no problem.

Could it be a proxy setting ?

-- 
Helping to adaptively monetize industry-wide B2B appliances as part of the IT 
team of the year, '09 and '08



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office together with a 
list of those non members who are referred to as partners.  We use the word 
“partner” to refer to a member of the LLP, or an employee or consultant with 
equivalent standing and qualifications. Regulated by the Solicitors Regulation 
Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.co

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324802
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFMX7, Ubuntu, Virtual Hosts, and a weird CFLOCK issue

[Tom Chiverton]

On Wednesday 22 Jul 2009, Rob Barthle wrote:
> > Wasn't Application.cfc introduced in CF8, not 7 ?
> If that were the case, then I'd be having bigger problems... ;-)

Coffee failure, oops.

-- 
Helping to proactively compete essential cross-platform systems as part of the 
IT team of the year, '09 and '08



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office together with a 
list of those non members who are referred to as partners.  We use the word 
“partner” to refer to a member of the LLP, or an employee or consultant with 
equivalent standing and qualifications. Regulated by the Solicitors Regulation 
Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.co

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324801
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: eSignature

[Tom Chiverton]

On Wednesday 22 Jul 2009, cftalk wrote:
> Hi Tom,
>
> Could you elaborate on that answer? I am also interested in digital
> signatures. Using standard...

gpg is a GNU tool for processing (public key) cryptography, such as digital 
signatures.
http://www.gnupg.org/documentation/

-- 
Helping to centrally negotiate one-to-one best-of-breed proactive IPOs as part 
of the IT team of the year, '09 and '08



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office together with a 
list of those non members who are referred to as partners.  We use the word 
“partner” to refer to a member of the LLP, or an employee or consultant with 
equivalent standing and qualifications. Regulated by the Solicitors Regulation 
Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.co

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324800
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: using CF to eliminate old Real Estate photos

[Sawyer, Edward]

It sounds to me like the photos aren't in the database at all, but probably 
just in a directory? If they are in a DB table, then as mentioned the primary 
key/ indexing really needs to be rethought. 

Rather than run a purge via the query (which is going to be a big resource 
load, from the looks of it) I'd put the delete photos functionality into 
whatever method is used to close a listing. E.g. house sells, close the listing 
and delete the photos. 

Good luck
-Ed

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324799
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: eSignature

[cftalk]

Hi Tom,

Could you elaborate on that answer? I am also interested in digital
signatures. Using standard...


-Original Message-
From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] 
Sent: July-22-09 1:55 AM
To: cf-talk
Subject: Re: eSignature


On Tuesday 21 Jul 2009, Randy Adkins wrote:
> Or if there is a way to use CF to verify that a document (DOC or PDF) has
> been electronically signed??

With what standard ? The generic answer would be to cfexecute 'gpg' and
parse 
the result, or find a suitable Java API.

-- 
Helping to efficiently cluster B2C fourth-generation transparent 
attention-grabbing applications as part of the IT team of the year, '09 
and '08



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A
list of members is available for inspection at the registered office
together with a list of those non members who are referred to as partners.
We use the word "partner" to refer to a member of the LLP, or an employee or
consultant with equivalent standing and qualifications. Regulated by the
Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may
be confidential or legally privileged.  If you are not the addressee you
must not read it and must not use any information contained in nor copy it
nor inform any person other than Halliwells LLP or the addressee of its
existence or contents.  If you have received this email in error please
delete it and notify Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.co



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324798
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: 8.0.1 webservice compile errors

[Sebastiaan van Dijk]

We're on CF801 Enterprise with JRE 1.6.013.

> Has anyone got a solution to this problem? We get the same error on 
> our internal production servers, but our external servers seem to run 
> the cfc with no problem. 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324797
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: 8.0.1 webservice compile errors

[Sebastiaan van Dijk]

Has anyone got a solution to this problem? We get the same error on our 
internal production servers, but our external servers seem to run the cfc with 
no problem. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324796
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

re: Request in cfhttp tag.

[Jason Fisher]

Change type to "url", I believe.


 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324795
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

A request in cfhttp tag.

[Piotr Artman]

Hi,
I have to send post reqest with data in url string,

for example:

https://example.com"; username="xxx" password="xxx" method="post" 
result="result">




Is this example correct? 

Thanks for help


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324794
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Request in cfhttp tag.

[Piotr Artman]

Hi,
I have to send post reqest with data in url string,

for example:

https://example.com"; username="xxx" password="xxx" method="post" 
result="result">




Is this example correct? 

Thanks for help


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324793
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

re: cfquery

[Jason Fisher]

I think you want it this way, using a CASE statement for the leadmgr 
column.  I also moved all your subselects into left joins, which should 
give a bit better performance.


select
s.address + ' ' + s.address2 + ' ' + s.address3 + ',' + s.city + ',' + 
s.state + ',' + s.city as office_address,
leadmgr = case 
when (lm.user_id is null) then lm.lead_note
else lm.first + ' ' + lm.last
end, 
amr.first + ' ' + amr.last as director,
sn.first + ' ' + sn.last as SDIRNDIR,
vp.first + ' ' + vp.last as VICEPRE,
fm.first + ' ' + fm.last as FASTMGR
from sourcebook_1 s left outer join
user_info lm on s.lead_mgr = lm.user_id left outer join
user_info amr on s.area_mgr_rdo = amr.user_id left outer join
user_info sn on s.sdir_ndir = sn.user_id left outer join
user_info vp on s.vice_pre = vp.user_id left outer join
user_info fm on s.fast_mgr = fm.user_id
where active = 1
and office_id not in (36,37,38,73)
order by office_number
 
 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324792
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFMX7, Ubuntu, Virtual Hosts, and a weird CFLOCK issue

[Rob Barthle]

> Wasn't Application.cfc introduced in CF8, not 7 ?
> 

If that were the case, then I'd be having bigger problems... ;-) 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324791
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Caching issue

[Jacob]

Found it.

There is a program call PipeBoostCache for compression and caching. It was
for compression and not for caching, but someone turned on the caching...

-Original Message-
From: Gaulin, Mark [mailto:mgau...@globalspec.com] 
Sent: Tuesday, July 21, 2009 1:07 PM
To: cf-talk
Subject: RE: Caching issue


Are you using session scope for anything (like the current customer)?

If so, do you have a load balancer that may have lost its "sticky IP"
setting? (It could be that you are bouncing around your web site cluster
and getting different session state on each one.)

Thanks  
Mark

-Original Message-
From: Jacob [mailto:ja...@excaliburfilms.com] 
Sent: Tuesday, July 21, 2009 3:49 PM
To: cf-talk
Subject: Caching issue


Setup.. 18 web servers with Windows 2003/CF7 or 2008/CF8.

It appears that I am pulling up cached queries from the servers. If I
pull up a movie list from a customer, I get a different customer. If I
refresh the list, then the right list shows up.  If I clear my
cookies/cache, close the browser and try again with a different customer
list.. same thing. I get the wrong list, but when I refresh I get the
right list.

No changes to the scripts and this starting happening over night. None
of the servers have saved cached queries and all the queries in the
coding are not cached. If I try to debug, I get no debugging info (with
the wrong list). But if I refresh, I then get debugging info with the
right list.

I have added the following on top of the application.cfm template:

  

But that still does not appear to fix the issue.

Any other ideas what to look for?  

Thanks
Jacob






~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324790
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cfquery

[RamaDevi Dobbala]

select 
address + ' ' + address2 + ' ' + address3 + ',' + city 
+ ',' + state + ',' + city as office_address,
(select first + ' ' + last as full from user_info 
where  user_id =lead_mgr ) as leadmgr,  (here if user_id neq lead_mgr i have to 
return lead_note column) how to do this...please help me

   
(select first + ' ' + last as full from 
user_info where user_id = AREA_MGR_RDO ) as director,
(select first + ' ' + last as full from 
user_info where user_id = SDIR_NDIR) as SDIRNDIR,
(select first + ' ' + last as full from 
user_info where user_id = VICE_PRE ) as VICEPRE,
(select first + ' ' + last as full from 
user_info where user_id = FAST_MGR ) as FASTMGR
from sourcebook_1
where active = 1
and office_id not in(36,37,38,73)
order by office_number
 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324789
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFMX7, Ubuntu, Virtual Hosts, and a weird CFLOCK issue

[Tom Chiverton]

On Tuesday 21 Jul 2009, Rob Barthle wrote:
> Background: I have a local CFMX7 
...
> The Application.cfc file has things set up properly:

Wasn't Application.cfc introduced in CF8, not 7 ?

-- 
Helping to professionally entrench open-source convergence as part of the IT 
team of the year, '09 and '08



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office together with a 
list of those non members who are referred to as partners.  We use the word 
“partner” to refer to a member of the LLP, or an employee or consultant with 
equivalent standing and qualifications. Regulated by the Solicitors Regulation 
Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.co

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324788
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF app control

[Tom Chiverton]

On Tuesday 21 Jul 2009, Don L wrote:
> Thank you for your thoughts.

See also defectivebydesign.org - if you can't trust your paying customers you 
have bigger issues.

-- 
Helping to authoritatively incentivize IPOs as part of the IT team of the 
year, '09 and '08



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office together with a 
list of those non members who are referred to as partners.  We use the word 
“partner” to refer to a member of the LLP, or an employee or consultant with 
equivalent standing and qualifications. Regulated by the Solicitors Regulation 
Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.co

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324787
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: eSignature

[Tom Chiverton]

On Tuesday 21 Jul 2009, Randy Adkins wrote:
> Or if there is a way to use CF to verify that a document (DOC or PDF) has
> been electronically signed??

With what standard ? The generic answer would be to cfexecute 'gpg' and parse 
the result, or find a suitable Java API.

-- 
Helping to efficiently cluster B2C fourth-generation transparent 
attention-grabbing applications as part of the IT team of the year, '09 
and '08



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office together with a 
list of those non members who are referred to as partners.  We use the word 
“partner” to refer to a member of the LLP, or an employee or consultant with 
equivalent standing and qualifications. Regulated by the Solicitors Regulation 
Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.co

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324786
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4