Re: cfm bb

[Stan Winchester]

No offense taken, but don't you get it; I said we will give away MULTIPLE FREE 
licenses to those who help in the beta test. If we need to add features to be 
equal to phpbb, then we will see what we can do. 

I wish I could offer the forum for free, but I have to eat and so does my 
family, so free is not an option. The MSRP is only $89.95 and developers 
automatically get 25% off with the very first purchase! After you sell 50 the 
price is only $44.98 which equals a 50% discount! So in a way, we are almost 
giving the forums away.

I hope I don't offend anyone by sharing this much information about the 
marketing, I'm just trying to get beta testers, and responding to "Dave the 
disruptor"

> no offense but you can get rays for free, ya know what i mean?
> 
 
> And there isn't currently a cfm bb with the features of phpbb except 
> for fusetalk and it isnt even as nice.
> 
> ~Dave the disruptor~
> "A criminal is a person with predatory instincts who has not 
> sufficient capital to form a corporation." 
> 
> 
> From: Stan Winchester <[EMAIL PROTECTED]>
> Sent: Wednesday, July 13, 2005 1:07 AM
> To: CF-Talk 
> Subject: Re: cfm bb 
> 
> We have had our Aftershock Forums in beta for a while and we will give 
> away FREE licenses to those who help us. For more information please 
> visit: 
> 
> http://www.aftershockweb.net/forums/threads.cfm/ForumId/9
> 
> >I've been working at integrating a big site into the phpbb framework... 
> and 
> >I wouldn't want to port this chunk if someone paid me. Its completely 
> hacked 
> >and slashed together.
> >
> >I'd sincerely suggest trying to acheive the same features (and even 
> some of 
> >those are worthless), but to do it differently... and plan a method 
> of 
> >attack as its quite obvious they didn't.
> >
> >Cheers,
> >
> >Kevin
> >
> >- Original Message - 
> >From: "dave" 
> >To: "CF-Talk" 
> >Sent: Tuesday, July 12, 2005 8:45 PM
> >Subject: cfm bb
> >
> >
> >>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211722
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: cfm bb

[Jim Davis]

> -Original Message-
> From: dave [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 12, 2005 10:46 PM
> To: CF-Talk
> Subject: cfm bb
> 
> for those who havent heard there is a new project to port phpbb to a cfm
> bb, I think Ben blogged about it.
>  If you have free time please sign up and help out :)
> 
>  http://www.cfopenbb.com/

Well - you're welcome to use my BBML parser:

http://www.depressedpress.com/depressedpress/Content/Development/ColdFusion/
Extensions/DP_ParseBBML/Index.cfm

It was written in 4.5 but still works a treat in MX+ (and there's not much
I'd change were I to do it again).  I wrote it, originally, as the precursor
to a forums application that never materialized.

I believe the level of support is about what you'd find in phpBB.

I'd be willing to modify it to work better for the integration effort if you
needed it as well.

Jim Davis





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211721
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: cfm bb

[dave]

no offense but you can get rays for free, ya know what i mean?

 And there isn't currently a cfm bb with the features of phpbb except for 
fusetalk and it isnt even as nice.

~Dave the disruptor~
"A criminal is a person with predatory instincts who has not sufficient capital 
to form a corporation." 


From: Stan Winchester <[EMAIL PROTECTED]>
Sent: Wednesday, July 13, 2005 1:07 AM
To: CF-Talk 
Subject: Re: cfm bb 

We have had our Aftershock Forums in beta for a while and we will give away 
FREE licenses to those who help us. For more information please visit: 

http://www.aftershockweb.net/forums/threads.cfm/ForumId/9

>I've been working at integrating a big site into the phpbb framework... and 
>I wouldn't want to port this chunk if someone paid me. Its completely hacked 
>and slashed together.
>
>I'd sincerely suggest trying to acheive the same features (and even some of 
>those are worthless), but to do it differently... and plan a method of 
>attack as its quite obvious they didn't.
>
>Cheers,
>
>Kevin
>
>- Original Message - 
>From: "dave" 
>To: "CF-Talk" 
>Sent: Tuesday, July 12, 2005 8:45 PM
>Subject: cfm bb
>
>
>>



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211720
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: cfm bb

[dave]

it is a clusterf*ck-o-code but if it was in cfm at least it would be easy to 
manipulate it how you want it.

 I use it all the time and would love to have it in cfm instead of the headache 
inducing php but even if it's not for that it's for the community and by ppl 
not doing anything it puts us right were we are now (as far as sharing apps 
goes, way behind)

~Dave the disruptor~
"A criminal is a person with predatory instincts who has not sufficient capital 
to form a corporation." 


From: Kevin Aebig <[EMAIL PROTECTED]>
Sent: Wednesday, July 13, 2005 12:23 AM
To: CF-Talk 
Subject: Re: cfm bb 

I've been working at integrating a big site into the phpbb framework... and 
I wouldn't want to port this chunk if someone paid me. Its completely hacked 
and slashed together.

I'd sincerely suggest trying to acheive the same features (and even some of 
those are worthless), but to do it differently... and plan a method of 
attack as its quite obvious they didn't.

Cheers,

Kevin

- Original Message - 
From: "dave" 
To: "CF-Talk" 
Sent: Tuesday, July 12, 2005 8:45 PM
Subject: cfm bb

> for those who havent heard there is a new project to port phpbb to a cfm 
> bb, I think Ben blogged about it.
> If you have free time please sign up and help out :)
>
> http://www.cfopenbb.com/
>
> ~Dave the disruptor~
> "A criminal is a person with predatory instincts who has not sufficient 
> capital to form a corporation."
>
>
>
> 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211719
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: cfm bb

[Stan Winchester]

We have had our Aftershock Forums in beta for a while and we will give away 
FREE licenses to those who help us. For more information please visit: 

http://www.aftershockweb.net/forums/threads.cfm/ForumId/9

>I've been working at integrating a big site into the phpbb framework... and 
>I wouldn't want to port this chunk if someone paid me. Its completely hacked 
>and slashed together.
>
>I'd sincerely suggest trying to acheive the same features (and even some of 
>those are worthless), but to do it differently... and plan a method of 
>attack as its quite obvious they didn't.
>
>Cheers,
>
>Kevin
>
>- Original Message - 
>From: "dave" <[EMAIL PROTECTED]>
>To: "CF-Talk" 
>Sent: Tuesday, July 12, 2005 8:45 PM
>Subject: cfm bb
>
>
>>

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211718
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: Making a flash movie a link.

[Parker, Kevin]

Not that I know of. You have to create a button the size of the movie in
flash and apply the getURL command. 

I just looked in Flash Help and there are no parameters for creating a
link. You could try wrapping the  tags in  and/or  tags
to produce a link. You would probably need to use javascript onClick
methods for this. 



++
Kevin Parker
Web Services Consultant
WorkCover Corporation

p: 08 8233 2548
m: 0418 806 166
e: [EMAIL PROTECTED]
w: www.workcover.com

++

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 13 July 2005 11:27 AM
To: CF-Talk
Subject: Making a flash movie a link.

Is it possible to make an enitre flash .swf move a link, or does the
link have to be created inside the flash file?





~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211717
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: cfm bb

[Kevin Aebig]

I've been working at integrating a big site into the phpbb framework... and 
I wouldn't want to port this chunk if someone paid me. Its completely hacked 
and slashed together.

I'd sincerely suggest trying to acheive the same features (and even some of 
those are worthless), but to do it differently... and plan a method of 
attack as its quite obvious they didn't.

Cheers,

Kevin

- Original Message - 
From: "dave" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, July 12, 2005 8:45 PM
Subject: cfm bb


> for those who havent heard there is a new project to port phpbb to a cfm 
> bb, I think Ben blogged about it.
> If you have free time please sign up and help out :)
>
> http://www.cfopenbb.com/
>
> ~Dave the disruptor~
> "A criminal is a person with predatory instincts who has not sufficient 
> capital to form a corporation."
>
>
>
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211716
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: Making a flash movie a link.

[Kevin Aebig]

Have you tried it?

!k

- Original Message - 
From: "Ian Skinner" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, July 12, 2005 7:56 PM
Subject: Making a flash movie a link.


> Is it possible to make an enitre flash .swf move a link, or does the
> link have to be created inside the flash file?
>
>
>
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211715
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

cfm bb

[dave]

for those who havent heard there is a new project to port phpbb to a cfm bb, I 
think Ben blogged about it.
 If you have free time please sign up and help out :)

 http://www.cfopenbb.com/

~Dave the disruptor~
"A criminal is a person with predatory instincts who has not sufficient capital 
to form a corporation." 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211714
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

Making a flash movie a link.

[Ian Skinner]

Is it possible to make an enitre flash .swf move a link, or does the 
link have to be created inside the flash file?



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211713
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: CodFusion keystore

[Taco]

Sorry for the double post, I got the first one returned saying it was to big
so I posted it again.

-Original Message-
From: Taco [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 13 July 2005 11:40 AM
To: CF-Talk
Subject: RE: CodFusion keystore

I finally got the finger prints to match - by going to the site and copying
the cert to file and import it again.

But  ColdFusion is still throwing the following error 
Connection has been shutdown: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: No trusted certificate found

I don't know what to do anymore, it works when I run the Java class as an
application (it always has worked). In the Java class I explicitly point to
the keystore, could this have anything to do with it?






~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211712
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: CodFusion keystore

[Taco]

I finally got the finger prints to match - by going to the site and copying
the cert to file and import it again.

But  ColdFusion is still throwing the following error 
Connection has been shutdown: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: No trusted certificate found

I don't know what to do anymore, it works when I run the Java class as an
application (it always has worked). In the Java class I explicitly point to
the keystore, could this have anything to do with it?




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211711
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: CodFusion keystore

[Taco]

I finally got the finger prints to match - by going to the site and copying
the cert to file and import it again.

But  ColdFusion is still throwing the following error 
Connection has been shutdown: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: No trusted certificate found

I don't know what to do anymore, it works when I run the Java class as an
application (it always has worked). In the Java class I explicitly point to
the keystore, could this have anything to do with it?

-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 13 July 2005 11:18 AM
To: CF-Talk
Subject: CodFusion keystore

I am trying to import a certificate into another store (CF), but I can't
get the fingerprints to match on the two, while I am sure the
certificate is the same.

 

In my

C:\Documents and Settings\Administrator\ directory when I run "keytool
-list -keystore .keystore"

I get

 

Your keystore contains 2 entries

 

asiccert, 6/07/2005, trustedCertEntry,

Certificate fingerprint (MD5):
AE:A9:A6:61:D4:EE:D5:4A:B6:14:56:AC:6A:46:CB:2C

shelco, 6/07/2005, keyEntry,

Certificate fingerprint (MD5):
E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2

 

And the above works, but when I do the same on 

C:\CFusionMX\runtime\jre\lib\security\cacerts I get

 

asiccert, 13/07/2005, trustedCertEntry,

Certificate fingerprint (MD5):
E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2

 

This is how I added the later:

 

C:\Temp\signature>keytool -import -keystore
C:\CFusionMX\runtime\jre\lib\securit

y\cacerts -file C:\Temp\signature\Shelco.cert.der -alias asiccert

Enter keystore password:  changeit

Owner: CN=Graham Chapman test 200 serial, OU=eBusiness Development CA,
O=ASIC, L

=Sydney, ST=NSW, C=AU

Issuer: OU=eBusiness Development CA, O=ASIC, L=SYDNEY, ST=NSW, C=AU

Serial number:
ed128008ec110fd416d961bd42ea0cabbd42ff0caced128008ec110fd416d961b

d42ea0cabbd42ff0caced128008ec110fd416d961bd42ea0cabbd42ff0caced128008ec1
10fd416d

961bd42ea0cabbd42ff0caced128008ec110fd416d961bd42ea0cab

Valid from: Thu Aug 19 09:29:11 EST 2004 until: Fri Aug 19 09:29:11 EST
2005

Certificate fingerprints:

 MD5:  E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2

 SHA1:
70:ED:59:6E:02:B8:9B:C3:0D:9B:3D:0E:92:0C:7B:DB:73:BE:26:0E

Trust this certificate? [no]:  y

Certificate was added to keystore

 

Anyone able to help out?



Taco Fleur - E-commerce Development Manager

Shelco Searches & Services

An Authorised ASIC Information Broker

www.shelco.com.au

Ph: + 61 7 3236 2605

 





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211710
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: retrieve ID from db insert

[daniel kessler]

hey that's great!  thanks.  I looked it over and it seems very useful, at least 
for me.
I appreciate moving my Oracle questions over to Oracle.

>I have had very good luck here:
> http://forums.oracle.com/forums/forum.jsp?forum=75
> My experience everywhere else, even here at work has been the holier than 
>though DBAs you described. I even got that experience from one here at work 
>that I helped with by sending some LDAP/Oracle integration I had worked on 
>which I thought was rather surprising.
>
> On 7/12/05, Deanna Schneider <[EMAIL PROTECTED]> wrote:

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211709
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

CodFusion keystore

[Taco Fleur]

I am trying to import a certificate into another store (CF), but I can't
get the fingerprints to match on the two, while I am sure the
certificate is the same.

 

In my

C:\Documents and Settings\Administrator\ directory when I run "keytool
-list -keystore .keystore"

I get

 

Your keystore contains 2 entries

 

asiccert, 6/07/2005, trustedCertEntry,

Certificate fingerprint (MD5):
AE:A9:A6:61:D4:EE:D5:4A:B6:14:56:AC:6A:46:CB:2C

shelco, 6/07/2005, keyEntry,

Certificate fingerprint (MD5):
E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2

 

And the above works, but when I do the same on 

C:\CFusionMX\runtime\jre\lib\security\cacerts I get

 

asiccert, 13/07/2005, trustedCertEntry,

Certificate fingerprint (MD5):
E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2

 

This is how I added the later:

 

C:\Temp\signature>keytool -import -keystore
C:\CFusionMX\runtime\jre\lib\securit

y\cacerts -file C:\Temp\signature\Shelco.cert.der -alias asiccert

Enter keystore password:  changeit

Owner: CN=Graham Chapman test 200 serial, OU=eBusiness Development CA,
O=ASIC, L

=Sydney, ST=NSW, C=AU

Issuer: OU=eBusiness Development CA, O=ASIC, L=SYDNEY, ST=NSW, C=AU

Serial number:
ed128008ec110fd416d961bd42ea0cabbd42ff0caced128008ec110fd416d961b

d42ea0cabbd42ff0caced128008ec110fd416d961bd42ea0cabbd42ff0caced128008ec1
10fd416d

961bd42ea0cabbd42ff0caced128008ec110fd416d961bd42ea0cab

Valid from: Thu Aug 19 09:29:11 EST 2004 until: Fri Aug 19 09:29:11 EST
2005

Certificate fingerprints:

 MD5:  E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2

 SHA1:
70:ED:59:6E:02:B8:9B:C3:0D:9B:3D:0E:92:0C:7B:DB:73:BE:26:0E

Trust this certificate? [no]:  y

Certificate was added to keystore

 

Anyone able to help out?



Taco Fleur - E-commerce Development Manager

Shelco Searches & Services

An Authorised ASIC Information Broker

www.shelco.com.au

Ph: + 61 7 3236 2605

 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211708
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: Purging client variables

[Barney Boisvert]

I use client variables (well, client variable-like storage)
extensively.  Can I get slammed too?  Client variables aren't
inherently bad, just in many (most ?) situations their drawbacks
outweigh their advantages, and if you use them without understanding
their characteristics you're just asking for trouble.

cheers,
barneyb

On 7/12/05, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> Heck, I was waiting for somebody to roll in and slam ya for using client 
> variables in the first place.  :)
> 
> Will
> 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 50 invites.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211707
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: Purging client variables

[Will Tomlinson]

Heck, I was waiting for somebody to roll in and slam ya for using client 
variables in the first place.  :)

Will

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211706
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: Show the code not the conversion.

[Marlon Moyer]

My fault.  I half copied your regex.  I started to type my own in and
thought, "Hey, Isaac already did this", of course by then, I had
already forgot to put the "re" in front of replace. :)


On 7/12/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> > Cool solution, except the regex does not seem to be
> > working, in that none of the &'s are being changed to
> > &'s.  But I can't see what it is not working?
> 
> He (or I) typo'd the function call... in the code that was posted the
> function called was "ReplaceNoCase"... the function should be
> REReplaceNoCase (we dropped the "re") -- or REReplace() would work
> actually, since the expression doesn't include anything but
> punctuation characters.
> 
> 
> s. isaac dealey 954.522.6080
> new epoch : isn't it time for a change?
> 
> add features without fixtures with
> the onTap open source framework
> 
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211705
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: Java class called from CF errors

[Douglas Knudsen]

http://homepage.ntlworld.com/wayne_grant/keytool.html
ck out this tool, KeyTool GUI. I use it for perusing and installing certs. 
Holy non free proggies batman! Seems Wayne is asking for money for this tool 
now. Good for him. Maybe an older version is googleable


DK

On 7/12/05, Taco <[EMAIL PROTECTED]> wrote:
> 
> Funny thing is when I look at the fingerprint from
> C:\Documents and Settings\Administrator\.keystore
> I get
> asiccert, 6/07/2005, trustedCertEntry,
> Certificate fingerprint (MD5):
> AE:A9:A6:61:D4:EE:D5:4A:B6:14:56:AC:6A:46:CB:2C
> shelco, 6/07/2005, keyEntry,
> Certificate fingerprint (MD5):
> E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2
> 
> But when I look at the fingerprint from
> C:\CFusionMX\runtime\jre\lib\security\cacerts
> I get
> 
> asiccert, 13/07/2005, trustedCertEntry,
> Certificate fingerprint (MD5):
> E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2
> 
> I'm still kind of wet behind the ears when it comes to certificates and
> keys. Anyone know of a good tutorial out there? I got it working for Java
> but don't ask me how I did it, I won't be able to replicate it, I did it 
> bit
> by bit via articles.
> 
> 
> -Original Message-
> From: Taco [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 13 July 2005 8:49 AM
> To: CF-Talk
> Subject: RE: Java class called from CF errors
> 
> Yes! You are definitely on to something, did a bit of searching and ran 
> the
> following after reading some articles.
> 
> _
> C:\CFusionMX\runtime\jre\lib>keytool -import -keystore
> c:\CFusionMx\runtime\jre\
> lib\security\cacerts -alias asiccert -storepass changeit -noprompt
> -trustcacerts
> -file C:\Temp\signature\Shelco.cert.der
> Certificate was added to keystore
> _
> 
> Unfortunately I still get the same error as before.
> Connection has been shutdown: javax.net.ssl.SSLHandshakeException:
> sun.security.validator.ValidatorException: No trusted certificate found
> 
> Do you see anything I done wrong above or can you think of something else?
> 
> -Original Message-
> From: James Holmes [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 12 July 2005 5:59 PM
> To: CF-Talk
> Subject: Re: Java class called from CF errors
> 
> Are you sre that the CA cert is in CF's keystore as well as in the
> keystore for the JRE in which yout test the compiled class?
> 
> On 7/12/05, Taco Fleur <[EMAIL PROTECTED]> wrote:
> > I have a Java class that runs fine as an application with main(), but
> > when I call it form CF it errors, I made sure the right constructor is
> > called - I just cannot figure out what the difference is and why it
> > errors.
> >
> >
> >
> > The error is:
> >
> > There was an error reading the Input Stream. The error is Connection has
> > been shutdown: javax.net.ssl.SSLHandshakeException:
> > sun.security.validator.ValidatorException: No trusted certificate found
> 
> 
> 
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211704
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: Solutions for Jrun hogging memory?

[Douglas Knudsen]

http://www.houseoffusion.com/cf_lists/threads.cfm/4
popular topic.

usually its the code. look for long running requests and start tuning. 
check out http://www.petefreitag.com/item/89.cfm Pete Frietag's got great 
info on tuning the JVM
Steven Erat has good stuffs too. Both will suggest setting up thread dumps 
:)

DK 

On 7/12/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
> 
> What would be a good check list of problems that could cause Jrun to 
> slowly hog too much memory, chocking the server after a few weeks?
> 
> Especially ones that could continue to be a problem after an upgrade from 
> 6.1 to 7, which we hope to do in the near future?
> 
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org 
> Sacramento, CA
> 
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
> 
> Confidentiality Notice: This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
> 
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211703
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: Java class called from CF errors

[Taco]

Funny thing is when I look at the fingerprint from 
C:\Documents and Settings\Administrator\.keystore
I get
asiccert, 6/07/2005, trustedCertEntry,
Certificate fingerprint (MD5):
AE:A9:A6:61:D4:EE:D5:4A:B6:14:56:AC:6A:46:CB:2C
shelco, 6/07/2005, keyEntry,
Certificate fingerprint (MD5):
E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2

But when I look at the fingerprint from 
C:\CFusionMX\runtime\jre\lib\security\cacerts
I get

asiccert, 13/07/2005, trustedCertEntry,
Certificate fingerprint (MD5):
E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2

I'm still kind of wet behind the ears when it comes to certificates and
keys. Anyone know of a good tutorial out there? I got it working for Java
but don't ask me how I did it, I won't be able to replicate it, I did it bit
by bit via articles.


-Original Message-
From: Taco [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 13 July 2005 8:49 AM
To: CF-Talk
Subject: RE: Java class called from CF errors

Yes! You are definitely on to something, did a bit of searching and ran the
following after reading some articles.

_
C:\CFusionMX\runtime\jre\lib>keytool -import -keystore
c:\CFusionMx\runtime\jre\
lib\security\cacerts -alias asiccert -storepass changeit -noprompt
-trustcacerts
 -file C:\Temp\signature\Shelco.cert.der
Certificate was added to keystore
_

Unfortunately I still get the same error as before.
Connection has been shutdown: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: No trusted certificate found

Do you see anything I done wrong above or can you think of something else?

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 12 July 2005 5:59 PM
To: CF-Talk
Subject: Re: Java class called from CF errors

Are you sre that the CA cert is in CF's keystore as well as in the
keystore for the JRE in which yout test the compiled class?

On 7/12/05, Taco Fleur <[EMAIL PROTECTED]> wrote:
> I have a Java class that runs fine as an application with main(), but
> when I call it form CF it errors, I made sure the right constructor is
> called - I just cannot figure out what the difference is and why it
> errors.
> 
> 
> 
> The error is:
> 
> There was an error reading the Input Stream. The error is Connection has
> been shutdown: javax.net.ssl.SSLHandshakeException:
> sun.security.validator.ValidatorException: No trusted certificate found





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211702
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: Java class called from CF errors

[Taco]

Yes! You are definitely on to something, did a bit of searching and ran the
following after reading some articles.

_
C:\CFusionMX\runtime\jre\lib>keytool -import -keystore
c:\CFusionMx\runtime\jre\
lib\security\cacerts -alias asiccert -storepass changeit -noprompt
-trustcacerts
 -file C:\Temp\signature\Shelco.cert.der
Certificate was added to keystore
_

Unfortunately I still get the same error as before.
Connection has been shutdown: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: No trusted certificate found

Do you see anything I done wrong above or can you think of something else?

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 12 July 2005 5:59 PM
To: CF-Talk
Subject: Re: Java class called from CF errors

Are you sre that the CA cert is in CF's keystore as well as in the
keystore for the JRE in which yout test the compiled class?

On 7/12/05, Taco Fleur <[EMAIL PROTECTED]> wrote:
> I have a Java class that runs fine as an application with main(), but
> when I call it form CF it errors, I made sure the right constructor is
> called - I just cannot figure out what the difference is and why it
> errors.
> 
> 
> 
> The error is:
> 
> There was an error reading the Input Stream. The error is Connection has
> been shutdown: javax.net.ssl.SSLHandshakeException:
> sun.security.validator.ValidatorException: No trusted certificate found



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211701
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: Java class called from CF errors

[Taco]

You might be on to something.

CF Keystore - does it have one, is it different than the one in Java?
It is definitely in the Java keystore and runs fine when I call the class as
an application.
Got any more information?

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 12 July 2005 5:59 PM
To: CF-Talk
Subject: Re: Java class called from CF errors

Are you sre that the CA cert is in CF's keystore as well as in the
keystore for the JRE in which yout test the compiled class?

On 7/12/05, Taco Fleur <[EMAIL PROTECTED]> wrote:
> I have a Java class that runs fine as an application with main(), but
> when I call it form CF it errors, I made sure the right constructor is
> called - I just cannot figure out what the difference is and why it
> errors.
> 
> 
> 
> The error is:
> 
> There was an error reading the Input Stream. The error is Connection has
> been shutdown: javax.net.ssl.SSLHandshakeException:
> sun.security.validator.ValidatorException: No trusted certificate found



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211700
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: Show the code not the conversion.

[S . Isaac Dealey]

> I figured that out just seconds before I went to a
> meeting.  I don't know how long I stared at that and saw
> rereplce not the truth, replace...

I was sitting here doing the same thing. :)

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

add features without fixtures with
the onTap open source framework

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


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211699
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: Show the code not the conversion.

[Ian Skinner]

I figured that out just seconds before I went to a meeting.  I don't know how 
long I stared at that and saw rereplce not the truth, replace...


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211698
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: Purging client variables

[Mike Klostermeyer]

Sorry, I'm stupid.  I didn't notice the link from within CF Admin.  I KNEW I
had seen it somewhere!  Thanks.

Mike

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 4:47 PM
To: CF-Talk
Subject: Re: Purging client variables


The CF admin has a setting for exactly that, with a length of time you
want to keep them around.  Other than that, just doing a DELETE
against the database will wipe them out quite effectively.

cheers,
barneyb

On 7/12/05, Mike Klostermeyer <[EMAIL PROTECTED]> wrote:
> What is the preferred method to purge old client variables, either from
the
> Registry or database?  Thanks.
>
> Mike

--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 50 invites.



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211697
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: Storing and retrieving images from SQL Server 2000

[Dave Watts]

> Any hint on the latter part of your statement? Is that where I'd need
> to convert to base64 or to string and then store in the db and when
> pulled out do tobinary()?  What exactly is it coming out of the db as
> when I insert it? Notice in my first post, I'm having trouble inserting
> as well. Not quite sure of all the conversions that need to happen at
> the moment.  Any advice you can give would be great!

Yes, you'd need to convert the data from binary to base 64. Not having dealt
with this problem at all recently, I'm not sure whether it'll be as simple
as fetching the field and using ToBase64 on it, though.

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!


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211696
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: Show the code not the conversion.

[S . Isaac Dealey]

> Cool solution, except the regex does not seem to be
> working, in that none of the &'s are being changed to
> &'s.  But I can't see what it is not working?

He (or I) typo'd the function call... in the code that was posted the
function called was "ReplaceNoCase"... the function should be
REReplaceNoCase (we dropped the "re") -- or REReplace() would work
actually, since the expression doesn't include anything but
punctuation characters.


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

add features without fixtures with
the onTap open source framework

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


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211695
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: Purging client variables

[Barney Boisvert]

The CF admin has a setting for exactly that, with a length of time you
want to keep them around.  Other than that, just doing a DELETE
against the database will wipe them out quite effectively.

cheers,
barneyb

On 7/12/05, Mike Klostermeyer <[EMAIL PROTECTED]> wrote:
> What is the preferred method to purge old client variables, either from the
> Registry or database?  Thanks.
> 
> Mike

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 50 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211694
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: retrieve ID from db insert

[Aaron Rouse]

True although I work with people who convert Excel "databases" over to 
Oracle, but of course they use Access as a jump to there. At the end of the 
"day" they have a really nice Oracle "Spreadsheet"

On 7/12/05, Jochem van Dieten <[EMAIL PROTECTED]> wrote: 
> 
> 
> 
> ISTM it usually is the other way around: Excel is the worlds most
> used 'database' :)
> 
> Jochem
> 
>


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211693
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

Purging client variables

[Mike Klostermeyer]

What is the preferred method to purge old client variables, either from the
Registry or database?  Thanks.

Mike



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211692
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: Calling .net service with CF

[Dave Watts]

> I was able to register the service in the components panel 
> but the only proxy generator available is Coldfusion MX. When 
> I click to add one it never shows up as available in the 
> prior window. I beleive I need the Apache Soap. Is this a bug 
> in Dreamweaver or am I overlooking something?

You should use ColdFusion MX as your proxy generator.

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!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211691
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: retrieve ID from db insert

[Jochem van Dieten]

RADEMAKERS Tanguy wrote:
> 
> And it's not restricted to Oracle - there are doubtless plenty of people
> out there using SQLServer as if it was a big excel spreadsheet.

ISTM it usually is the other way around: Excel is the worlds most 
used 'database' :)

Jochem

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211690
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: Calling .net service with CF

[Lee Surma]

>If you're using Dreamweaver, and you register the remote web service within
>the Components panel, you should be able to drag and drop from that panel
>into your code, and it'll build the appropriate CFINVOKE and
>CFINVOKEARGUMENT tags for you.
>
>Dave Watts, CTO, Fig Leaf Software


I was able to register the service in the components panel but the only proxy 
generator available is Coldfusion MX. When I click to add one it never shows up 
as available in the prior window. I beleive I need the Apache Soap. Is this a 
bug in Dreamweaver or am I overlooking something?

Lee Surma

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211689
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: retrieve ID from db insert

[RADEMAKERS Tanguy]

>-Original Message-
>Subject: retrieve ID from db insert
>From: Aaron Rouse <[EMAIL PROTECTED]>
>Date: Tue, 12 Jul 2005 14:40:27 -0500

[snip]

> I often wonder how many CFM developers that work with Oracle use and 
>understand all the features that all that money was spent on. And if
they do 
>not understand the features well enough, what could have been intended
to 
>make their life/jobs easier could quickly make it harder but that is
just 
>part of life and anything out there.

It's not restricted to CFM developers - if anything, web developers are
more likely to be comfortable with a greater number of different
technologies than their mainstream counterparts. A lot of them
high-falutin' object cowboys are downright afraid of databases. Then
again, if i wrote SQL like that i would be too ;> 

And it's not restricted to Oracle - there are doubtless plenty of people
out there using SQLServer as if it was a big excel spreadsheet.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211688
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: Show the code not the conversion.

[Ian Skinner]

Cool solution, except the regex does not seem to be working, in that none of 
the &'s are being changed to &'s.  But I can't see what it is not working?


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

-Original Message-
From: Marlon Moyer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 1:32 PM
To: CF-Talk
Subject: Re: Show the code not the conversion.

obscureCommand.cfm






usage:


 

   

   




On 7/12/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
> No, I want the htmleditformat, but I would like it to display the
escaped code, not convert it back.  This is for a tool to take html,
escape all the code so that it can be put into an XML node.  The tool
works for geeks like me, since I can get the code by looking at the
source.  But I was hoping there was an obscure CFML or HTML tag that
would not convert the code when displaying; thus eliminating the need to
view the source.
>
>
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
>
> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 12, 2005 1:19 PM
> To: CF-Talk
> Subject: RE: Show the code not the conversion.
> 
> Oh... you want to double-up the htmledit formatting?
> 
>  i think you have to write your own equivalent of
htmleditformat --
> since I don't think the native function will double itself up like
> that.
> 
> function doubleUp(text) {
> return
> rereplacenocase(htmleditformat(text),"&([^;[:space:]]+);","&am
> p;\1;","ALL");
> 
> }
> 
> > You'd have to convert the & into & before you display
> > it
> 
> > Example:
> > <table border=0 cellpadding=0 width=500>
> 
> >> -Original Message-
> >> From: Ian Skinner [mailto:[EMAIL PROTECTED]
> >> Sent: Tuesday, July 12, 2005 3:00 PM
> >> To: CF-Talk
> >> Subject: Show the code not the conversion.
> >>
> >> Is there anyway to get an html page to display this:
> >>
> >> 
> >>  
> >>  
 >> align="center">
> >>
> >> Versus this:
> >> 
> >>  
> >>  
> 
> 
> s. isaac dealey   954.522.6080
> new epoch : isn't it time for a change?
> 
> add features without fixtures with
> the onTap open source framework
> 
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
> 
> 
> 
> 
> 
>
>



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211687
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





changing UID to string in MSSQL


2005-07-12

Thread
Russ

We have a userUId column of type uniqueidentifier in our MS SQL database.
We are running into some issues where sometimes the UID's are cut off when
passed in url's (from email clients, etc).  I think the problem may be the -
character, where certain email clients and browsers decide to chop things
off at the - character.  

 

So we've decided to create another column, userStrUid of type varchar, and
set the formula to (left(replace([userUId],'-',''),40)).  

 

Now this works as expected, and it populated data for all exisiting users
for this field.  Now, however, when I do inserts, I get this error:

 

[Macromedia][SQLServer JDBC Driver][SQLServer]INSERT failed because the
following SET options have incorrect settings: 'ARITHABORT'.

 

 

I am not using this column on the insert, and there is no default set
(should there be?).  Also the primary key is inserted by getting a
max(userid) + 1 and then inserting it.  I'd like to switch it to an identity
column, but wondering if that will mess up my data.  

 

I've taken out the column and the insert works fine now.  Why is it failing?

 

Russ



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211686
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: Web service caling local CFC


2005-07-12

Thread
Bryan Stevenson

From: "Paul Kenney" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, July 12, 2005 2:09 PM
Subject: Re: Web service caling local CFC


> To be honest, the first time I saw this someone else dealt with it and 
> that
> was what he did to fix it. I don't know why it doesn't work with mappings. 
> I
> don't even know if this is consistent behavior or a case-by-case thing.
> "Why?" is a very good question indeed.

The "why" is that a CFC setup as a web service ignores local CF 
mappings...thus "file not found".

As I just posted this was a known issue/bug in CFMX 6.1, but I'm not sure if 
it also applies to 7

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 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211685
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





SOLVED: Re: Web service caling local CFC


2005-07-12

Thread
Bryan Stevenson

I found a thread in a forum explaining this was a bug in MX 6.1 (didn't know 
my associate was still using 6.1 as we develop for 7 now).  It contained a 
link that explains in detail what Paul K. was trying to tel me (thanks 
Paul).

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 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211684
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: Web service caling local CFC


2005-07-12

Thread
Paul Kenney

To be honest, the first time I saw this someone else dealt with it and that 
was what he did to fix it. I don't know why it doesn't work with mappings. I 
don't even know if this is consistent behavior or a case-by-case thing. 
"Why?" is a very good question indeed.


On 7/12/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> 
> From: "Paul Kenney" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Tuesday, July 12, 2005 1:10 PM
> Subject: Re: Web service caling local CFC
> 
> 
> > Yeah, you have to add a virtual directory in the jrun-web.xml file under
> > {webroot}/WEB-INF
> >
> 
> Thanks Paulbut care to elaborate...virtual directory for what 
> purpose???
> to use to reference the local CFC from within the web service CFC? why 
> can't
> the web service use the CF Admin mapping "appCFCs" like CFM template can?
> 
> 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 
> 
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211683
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





Solutions for Jrun hogging memory?


2005-07-12

Thread
Ian Skinner

What would be a good check list of problems that could cause Jrun to slowly hog 
too much memory, chocking the server after a few weeks?

Especially ones that could continue to be a problem after an upgrade from 6.1 
to 7, which we hope to do in the near future?


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211682
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: retrieve ID from db insert


2005-07-12

Thread
Aaron Rouse

I have had very good luck here:
 http://forums.oracle.com/forums/forum.jsp?forum=75
 My experience everywhere else, even here at work has been the holier than 
though DBAs you described. I even got that experience from one here at work 
that I helped with by sending some LDAP/Oracle integration I had worked on 
which I thought was rather surprising.

 On 7/12/05, Deanna Schneider <[EMAIL PROTECTED]> wrote: 
> 
> You've found good oracle forums? Care to share? All I've found are a
> lot of DBA's that don't want to answer code questions. I think that's
> one of the biggest problems with the oracle community - there's a lot
> of holier than thou DBA's out there.
> 
> I'm fortunate to have a pretty approachable DBA that actually helps
> answer our questions. But, I know there are reams of things I don' t
> know, particularly now that we're moving to 10g from 8i. I haven't
> even begun to learn what new goodies there are.
> 
> I've used some of those analytics- they are way cool, aren't they?
> 
>


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211681
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: retrieve ID from db insert


2005-07-12

Thread
Deanna Schneider

You've found good oracle forums? Care to share? All I've found are a
lot of DBA's that don't want to answer code questions. I think that's
one of the biggest problems with the oracle community - there's a lot
of holier than thou DBA's out there.

I'm fortunate to have a pretty approachable DBA that actually helps
answer our questions. But, I know there are reams of things I don' t
know, particularly now that we're moving to 10g from 8i. I haven't
even begun to learn what new goodies there are.

I've used some of those analytics- they are way cool, aren't they?

On 7/12/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> Not sure what the coolest thing I have learned in it lately was, just been
> too busy with other things to remember much more than my name. I think maybe
> it was the use of pipelined functions to deal with some lists of data being
> sent in. Although I have written a few SPs in the past few months to help
> out with ref integrity checking/messaging that hopefully will help this
> group out here.
>  My only beef with Oracle has always been the general attitude of people
> when seeking help. Although their forums tend to have a good group of people
> in them. Maybe I just have been spoiled with out CFM people are.
> 
>  On 7/12/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
> >
> > ditto...heck we got a couple folks still using font tags...geesh.
> >
> > coolest thing I learned in Oracle in the past few months is the use of
> > aggregate functions as analytics via PARTION..OVER. Way kewl.
> >
> > DK
> >
> >
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211680
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: Web service caling local CFC


2005-07-12

Thread
Bryan Stevenson

From: "Paul Kenney" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, July 12, 2005 1:10 PM
Subject: Re: Web service caling local CFC


> Yeah, you have to add a virtual directory in the jrun-web.xml file under
> {webroot}/WEB-INF
>

Thanks Paulbut care to elaborate...virtual directory for what purpose??? 
to use to reference the local CFC from within the web service CFC? why can't 
the web service use the CF Admin mapping "appCFCs" like CFM template can?

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 


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211679
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: retrieve ID from db insert


2005-07-12

Thread
Aaron Rouse

Not sure what the coolest thing I have learned in it lately was, just been 
too busy with other things to remember much more than my name. I think maybe 
it was the use of pipelined functions to deal with some lists of data being 
sent in. Although I have written a few SPs in the past few months to help 
out with ref integrity checking/messaging that hopefully will help this 
group out here.
 My only beef with Oracle has always been the general attitude of people 
when seeking help. Although their forums tend to have a good group of people 
in them. Maybe I just have been spoiled with out CFM people are.

 On 7/12/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: 
> 
> ditto...heck we got a couple folks still using font tags...geesh.
> 
> coolest thing I learned in Oracle in the past few months is the use of
> aggregate functions as analytics via PARTION..OVER. Way kewl.
> 
> DK
> 
>


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211678
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: Show the code not the conversion.


2005-07-12

Thread
Marlon Moyer

obscureCommand.cfm






usage:


 

   

   




On 7/12/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
> No, I want the htmleditformat, but I would like it to display the escaped 
> code, not convert it back.  This is for a tool to take html, escape all the 
> code so that it can be put into an XML node.  The tool works for geeks like 
> me, since I can get the code by looking at the source.  But I was hoping 
> there was an obscure CFML or HTML tag that would not convert the code when 
> displaying; thus eliminating the need to view the source.
> 
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
> 
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
> 
> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 12, 2005 1:19 PM
> To: CF-Talk
> Subject: RE: Show the code not the conversion.
> 
> Oh... you want to double-up the htmledit formatting?
> 
>  i think you have to write your own equivalent of htmleditformat --
> since I don't think the native function will double itself up like
> that.
> 
> function doubleUp(text) {
> return
> rereplacenocase(htmleditformat(text),"&([^;[:space:]]+);","&am
> p;\1;","ALL");
> 
> }
> 
> > You'd have to convert the & into & before you display
> > it
> 
> > Example:
> > <table border=0 cellpadding=0 width=500>
> 
> >> -Original Message-
> >> From: Ian Skinner [mailto:[EMAIL PROTECTED]
> >> Sent: Tuesday, July 12, 2005 3:00 PM
> >> To: CF-Talk
> >> Subject: Show the code not the conversion.
> >>
> >> Is there anyway to get an html page to display this:
> >>
> >> 
> >>  
> >>  
 >> align="center">
> >>
> >> Versus this:
> >> 
> >>  
> >>  
> 
> 
> s. isaac dealey   954.522.6080
> new epoch : isn't it time for a change?
> 
> add features without fixtures with
> the onTap open source framework
> 
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
> 
> 
> 
> 
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211677
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: retrieve ID from db insert


2005-07-12

Thread
Douglas Knudsen

ditto...heck we got a couple folks still using font tags...geesh.

coolest thing I learned in Oracle in the past few months is the use of 
aggregate functions as analytics via PARTION..OVER. Way kewl. 

DK

On 7/12/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> 
> Guess it depends on your definition of "life easier" and ones 
> understanding
> of features, after all someone with a limited view would think using
> triggers to plug in sequence values is using "cool" oracle features.
> Only reason I state that is I can think of a lot of "developers" here at
> this company that if you were to try to get them to get the nextval of the
> sequence and then insert it you would get deer in the headlight looks.
> Actually not too sure any of then use the transaction tag either and bet 
> if
> any do they put no attributes on it.
> I often wonder how many CFM developers that work with Oracle use and
> understand all the features that all that money was spent on. And if they 
> do
> not understand the features well enough, what could have been intended to
> make their life/jobs easier could quickly make it harder but that is just
> part of life and anything out there.
> On 7/12/05, RADEMAKERS Tanguy <[EMAIL PROTECTED]> wrote:
> >
> >
> > My advice: oracle cost a lot of money, so get your money's worth: use
> > oracle specific features when they make your life easier. It's what
> > they're for.
> >
> >
> >
> 
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211676
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: Show the code not the conversion.


2005-07-12

Thread
Ian Skinner

No, I want the htmleditformat, but I would like it to display the escaped code, 
not convert it back.  This is for a tool to take html, escape all the code so 
that it can be put into an XML node.  The tool works for geeks like me, since I 
can get the code by looking at the source.  But I was hoping there was an 
obscure CFML or HTML tag that would not convert the code when displaying; thus 
eliminating the need to view the source.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 1:19 PM
To: CF-Talk
Subject: RE: Show the code not the conversion.

Oh... you want to double-up the htmledit formatting?

 i think you have to write your own equivalent of htmleditformat --
since I don't think the native function will double itself up like
that.

function doubleUp(text) {
return
rereplacenocase(htmleditformat(text),"&([^;[:space:]]+);","&am
p;\1;","ALL");

}

> You'd have to convert the & into & before you display
> it

> Example:
> <table border=0 cellpadding=0 width=500>

>> -Original Message-
>> From: Ian Skinner [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, July 12, 2005 3:00 PM
>> To: CF-Talk
>> Subject: Show the code not the conversion.
>>
>> Is there anyway to get an html page to display this:
>>
>> 
>>  
>>  
> align="center">
>>
>> Versus this:
>> 
>>  
>>  


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

add features without fixtures with
the onTap open source framework

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






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211675
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: Web service caling local CFC


2005-07-12

Thread
Paul Kenney

Yeah, you have to add a virtual directory in the jrun-web.xml file under 
{webroot}/WEB-INF


On 7/12/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> 
> > Hey Brian,
> >
> > Maybe try adding a ColdFusion mapping called "appCFCs" to wherever the
> > appCFCs directory is - I've had issues with CFC resolution in
> > containers other than CFM where I've needed explicit mappings, namely
> > remote gateways.
> >
> > -Joe
> 
> There is a mapping already called "appCFCs" to the CFCs directoryused 
> to
> call the local/internal CFC. The problem is that the mapping doesn't seem
> to work when the container web service (on the same server) uses that
> mapping to call the local/internal CFC.
> 
> Am I not "gettin" you Joe? ;-)
> 
> 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 
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211674
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: include udf in fusebox 4.1?


2005-07-12

Thread
Barney Boisvert

You can't.  The INCLUDE verb in FB4.x is a fusebox thing, not a CF
thing.  More specifically, it's an include to a fuse inside the
circuit you're currently operating, while CFINCLUDE is an include to
an arbitrary CFM file on the server.  If you want CFINCLUDE's
behaviour, you have to use CFINCLUDE, most likely within an action
fuse.

This seems weird at first, but it makes sense.  FB only knows about
fuses, it doesn't know about CF templates.  So if you want to include
an arbitrary CF template, that's actual application logic, it's not a
FB instruction.  And since you wrap application logic in action fuses
(or CFCs), you need to put the CFINCLUDE in an action fuse as well.

This same thing applies to CFMODULE and other custom tags; you wrap
the call in an act_ fuse or UDF/CFC method.

cheers,
barneyb

On 7/12/05, Johnny Le <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I have a udf library that is outside of the application root folder.  I
> created a mapping to it, but I can't seem to include it in the fuseaction.
> How do you include udf in your fuseaction?
> 
> Currently we have:
> 
> 
> 
> 
> 
> Johnny
> 
> Sincerely,
> 
> Johnny Le
> Web Developer
> Certified Advanced Macromedia ColdFusion Developer
> U.S. Department of State, IRM/BPC/CST/BC
> 2121 Virginia Avenue, NW, #4132
> Washington, DC 20037
> 202-663-0259
> 

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 50 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211673
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: Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
Aaron Rouse

His job is to monitor email lists. :)

On 7/12/05, Ben Forta <[EMAIL PROTECTED]> wrote: 
> 
> Like Dave (who regularly beats us all to the punch, I don't believe he 
> ever
> gets any real work done, that or he has figured out cloning) said.
> 
> ;-)
> 
>


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211672
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: retrieve ID from db insert


2005-07-12

Thread
Aaron Rouse

Guess it depends on your definition of "life easier" and ones understanding 
of features, after all someone with a limited view would think using 
triggers to plug in sequence values is using "cool" oracle features. 
 Only reason I state that is I can think of a lot of "developers" here at 
this company that if you were to try to get them to get the nextval of the 
sequence and then insert it you would get deer in the headlight looks. 
Actually not too sure any of then use the transaction tag either and bet if 
any do they put no attributes on it.
 I often wonder how many CFM developers that work with Oracle use and 
understand all the features that all that money was spent on. And if they do 
not understand the features well enough, what could have been intended to 
make their life/jobs easier could quickly make it harder but that is just 
part of life and anything out there.
 On 7/12/05, RADEMAKERS Tanguy <[EMAIL PROTECTED]> wrote: 
> 
> 
> My advice: oracle cost a lot of money, so get your money's worth: use
> oracle specific features when they make your life easier. It's what
> they're for.
> 
> 
>


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211671
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





REPOST: Re: Web service caling local CFC


2005-07-12

Thread
Bryan Stevenson

I see Dave and Ben are online.you two must have the answer I'm after ;-)

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
- Original Message - 
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, July 12, 2005 11:16 AM
Subject: Web service caling local CFC


> Hey All,
>
> An associate is having an issue with a web service calling a method in a 
> local CFC.  Both the web service and the local CFC are on the same server 
> just different directories.  Of course the local CFC uses access="public" 
> and the web service CFC uses access="remote".
>
> There is a CF mapping to the local CFC called "appCFCs"
>
> Any local CF templates calling the local CFC work just fine using the code 
> below:
>
>   component="appCFCs.FOS.groundfish"
>  method="getActivity"
>  user="#userid#"
>  pwd="#passwd#"
>  act_id="#url.act_id#"
>  trip_act_id="#url.trip_act_id#"
>  pd_id="#url.pd_id#"
>  act_verify_no="#url.act_verify_no#"
>  actyp_cde="#url.actyp_cde#"
>  returnvariable="qryAct">
>
> When the web service cals the same method in the CFC above it uses:
>
>   component="appCFCs.FOS.groundfish"
>  method="getActivity"
>  user="#arguments.user#"
>  pwd="#arguments.pwd#"
>  act_id="#arguments.act_id#"
>  trip_act_id="#arguments.trip_act_id#"
>  pd_id="#arguments.pd_id#"
>  act_verify_no="#arguments.act_verify_no#"
>  actyp_cde="#arguments.actyp_cde#"
>  returnvariable="qryAct">
>
> The call above generates an error: "Could not find the ColdFusion 
> Component appCFCs.FOS.groundfish"
>
> NOTE: The web service is in a different directory on the server than the 
> local CFC as it will be SSL secured (but isn't currently)
>
> Personally I've never had a web service cal a local CFC, but I have had 
> local CFCs call each other with not problemsso I'm not quite sure why 
> this is happening.
>
> Any thoughts?
>
>
> 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
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211670
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: Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
Ben Forta

Like Dave (who regularly beats us all to the punch, I don't believe he ever
gets any real work done, that or he has figured out cloning) said.

;-)

 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 12, 2005 3:40 PM
To: CF-Talk
Subject: RE: Storing and retrieving images from SQL Server 2000

> Thanks for the response, but I'm curious as to why the documentation 
> doesn't show the variable attribute for 
> http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a1
> 7.htm#wp2850760
> 
> Is this going to be deprecated or is this new or what? I'm using CFMX 
> 6.1.

The VARIABLE attribute is new to CFMX 7. In the absence of this attribute,
you will need to either write the file to disk then use CFCONTENT to refer
to the file, or you will need to encode the binary content appropriately
then output it yourself after the CFCONTENT tag.

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!




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211669
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: Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
Burns, John D

Dave,

Any hint on the latter part of your statement?  Is that where I'd need
to convert to base64 or to string and then store in the db and when
pulled out do tobinary()?  What exactly is it coming out of the db as
when I insert it?  Notice in my first post, I'm having trouble inserting
as well. Not quite sure of all the conversions that need to happen at
the moment.  Any advice you can give would be great!


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 12, 2005 3:40 PM
To: CF-Talk
Subject: RE: Storing and retrieving images from SQL Server 2000

> Thanks for the response, but I'm curious as to why the documentation 
> doesn't show the variable attribute for 
> http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a1
> 7.htm#wp2850760
> 
> Is this going to be deprecated or is this new or what? I'm using CFMX 
> 6.1.

The VARIABLE attribute is new to CFMX 7. In the absence of this
attribute, you will need to either write the file to disk then use
CFCONTENT to refer to the file, or you will need to encode the binary
content appropriately then output it yourself after the CFCONTENT tag.

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!




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211668
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: Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
Dave Watts

> Thanks for the response, but I'm curious as to why the documentation
> doesn't show the variable attribute for 
> http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a1
> 7.htm#wp2850760
> 
> Is this going to be deprecated or is this new or what? I'm using CFMX
> 6.1.

The VARIABLE attribute is new to CFMX 7. In the absence of this attribute,
you will need to either write the file to disk then use CFCONTENT to refer
to the file, or you will need to encode the binary content appropriately
then output it yourself after the CFCONTENT tag.

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!


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211667
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: retrieve ID from db insert


2005-07-12

Thread
RADEMAKERS Tanguy

As i see it, the benefit of this approach is that it will be more
portable across different databases (as long as they understand
transactions). The down side is that if you want this to work you will
have to use  - "repeatable_read"
won't cut it if another transaction has finished in the mean time.
Unfortunately, some other products implement this level of isolation by
locking the whole table - which means that only one thread at a time
will be able to insert into this table. 

My advice: oracle cost a lot of money, so get your money's worth: use
oracle specific features when they make your life easier. It's what
they're for.


>-Original Message-
Subject: retrieve ID from db insert
>From: Aaron Rouse <[EMAIL PROTECTED]>
>Date: Tue, 12 Jul 2005 11:10:05 -0500
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41103&forumid=4#211639
>
>We appear to just be going around in circles on this one. If 
>you have a 
>query that selects the sequence next value then you do not need a 
>CFTRANSACTION but you do have to remember to always select the 
>next value 
>since I'd assume this uses no trigger to handle it on any 
>other inserts? 
>What do you do for mass inserts from another table, guess just 
>a little 
>addition to the SQL and really no biggie on that one.
> Or you take the approach of never inserting anything manually 
>into the "ID" 
>column and just little a trigger/sequence handle it. That means using 
>CFTRANSACTION so that after you insert it you do the SELECT 
>MAX(ID) AS NEWID 
> Since there seems to be no adverse reason to using 
>CFTRANSACTION unless 
>in some of the already noted situations which seem more out of 
>the norm than 
>the norm, then this method just to me seems like an easier approach.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211666
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: Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
Burns, John D

Ben,

Thanks for the response, but I'm curious as to why the documentation
doesn't show the variable attribute for 
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a17.htm#wp28
50760

Is this going to be deprecated or is this new or what? I'm using CFMX
6.1.


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 12, 2005 2:53 PM
To: CF-Talk
Subject: RE: Storing and retrieving images from SQL Server 2000

John, check out this thread:
http://www.forta.com/blog/index.cfm?mode=e&entry=1645

--- Ben
 

-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 2:10 PM
To: CF-Talk
Subject: Storing and retrieving images from SQL Server 2000

I've looked in the archives and can't find a good answer to this. I know
I've done it in the past, I just can't remember how and my brain hurts
so i figured i'd ask the list.  I have no say about storing the images
in the DB and that decision is already made, so I just need help putting
them in there and getting them out.
 
Right now, the DB is set up with a column of the type BLOB.  I'm trying
to figure out how to let a user upload a file and then read that file
back off of the server and insert it into the database using 
but it's not working for me.  Do I need to do any conversions using any
cf functions before the insert?
 
When I'm trying to pull it from the DB, I have a page that does the
query and uses  to set the type to image/gif and then output
the result of the query using #queryname.value# and
i'm calling that page using  but I'm not
getting the result as expected.
 
I think it all goes back to how I'm putting it in and pulling it from
the DB.  Any help would be greatly appreciated and I'd like to stay away
from CFX tags if at all possible.  We have tried a couple and have
gotten patchy results.  Thanks for your help while my brain is out to
lunch!
 
John Burns
Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web
Developer
 
 






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211665
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: Show the code not the conversion.


2005-07-12

Thread
S . Isaac Dealey

Oh... you want to double-up the htmledit formatting?

 i think you have to write your own equivalent of htmleditformat --
since I don't think the native function will double itself up like
that.

function doubleUp(text) {
return rereplacenocase(htmleditformat(text),"&([^;[:space:]]+);","&am
p;\1;","ALL");

}

> You'd have to convert the & into & before you display
> it

> Example:
> <table border=0 cellpadding=0 width=500>

>> -Original Message-
>> From: Ian Skinner [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, July 12, 2005 3:00 PM
>> To: CF-Talk
>> Subject: Show the code not the conversion.
>>
>> Is there anyway to get an html page to display this:
>>
>> 
>>  
>>  
> align="center">
>>
>> Versus this:
>> 
>>  
>>  


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

add features without fixtures with
the onTap open source framework

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




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211664
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: Show the code not the conversion.


2005-07-12

Thread
S . Isaac Dealey

> Is there anyway to get an html page to display this:

> 
>   
>   
   align="center">

> Versus this:
> 
>   
>   

HTMLEditFormat() -- use  to create the variable.

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

add features without fixtures with
the onTap open source framework

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




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211663
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





include udf in fusebox 4.1?


2005-07-12

Thread
Johnny Le

Hi,

I have a udf library that is outside of the application root folder.  I
created a mapping to it, but I can't seem to include it in the fuseaction. 
How do you include udf in your fuseaction?

Currently we have:





Johnny

Sincerely,

Johnny Le
Web Developer
Certified Advanced Macromedia ColdFusion Developer
U.S. Department of State, IRM/BPC/CST/BC
2121 Virginia Avenue, NW, #4132
Washington, DC 20037
202-663-0259



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211662
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: Show the code not the conversion.


2005-07-12

Thread
Steve Brownlee

You'd have to convert the & into & before you display it

Example:
<table border=0 cellpadding=0 width=500>

> -Original Message-
> From: Ian Skinner [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, July 12, 2005 3:00 PM
> To: CF-Talk
> Subject: Show the code not the conversion.
> 
> Is there anyway to get an html page to display this:
> 
> 
>   
>   
 align="center">
> 
> Versus this:
> 
>   
>   
> 
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211661
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





Show the code not the conversion.


2005-07-12

Thread
Ian Skinner

Is there anyway to get an html page to display this:





Versus this:





--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211660
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: Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
Ben Forta

John, check out this thread:
http://www.forta.com/blog/index.cfm?mode=e&entry=1645

--- Ben
 

-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 12, 2005 2:10 PM
To: CF-Talk
Subject: Storing and retrieving images from SQL Server 2000

I've looked in the archives and can't find a good answer to this. I know
I've done it in the past, I just can't remember how and my brain hurts so i
figured i'd ask the list.  I have no say about storing the images in the DB
and that decision is already made, so I just need help putting them in there
and getting them out.
 
Right now, the DB is set up with a column of the type BLOB.  I'm trying to
figure out how to let a user upload a file and then read that file back off
of the server and insert it into the database using  but it's not
working for me.  Do I need to do any conversions using any cf functions
before the insert?
 
When I'm trying to pull it from the DB, I have a page that does the query
and uses  to set the type to image/gif and then output the result
of the query using #queryname.value# and i'm calling
that page using  but I'm not getting the result as
expected.
 
I think it all goes back to how I'm putting it in and pulling it from the
DB.  Any help would be greatly appreciated and I'd like to stay away from
CFX tags if at all possible.  We have tried a couple and have gotten patchy
results.  Thanks for your help while my brain is out to lunch!
 
John Burns
Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web
Developer
 
 




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211659
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: Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
Dawson, Michael

Uh-oh.  Let the flame wars begin...

John, email me off-list and I will send you some files that will allow
you to store any type of files in a database.

Personally, I see nothing wrong with storing images/files in a DB as
long as you are aware of any issues related to the practice.

M!ke

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 12, 2005 1:39 PM
To: CF-Talk
Subject: Re: Storing and retrieving images from SQL Server 2000

 >>I have no say about storing the images in the DB and that decision is
already made

Never too late to reverse a bad decision.

--

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211658
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: Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
Burns, John D

I just need to know technically how to do it and then if it blows up I
can tell them "I told you so". I know I've done some stuff with it but
my brain is dead today. 


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 12, 2005 2:39 PM
To: CF-Talk
Subject: Re: Storing and retrieving images from SQL Server 2000

 >>I have no say about storing the images in the DB and that decision is
already made

Never too late to reverse a bad decision.

--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211657
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: Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
Burns, John D

It's not my call. It's been decided further up and I've already fought
my battle and told to shut up and just do it. 


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 12, 2005 2:39 PM
To: CF-Talk
Subject: Re: Storing and retrieving images from SQL Server 2000

 >>I have no say about storing the images in the DB and that decision is
already made

Never too late to reverse a bad decision.

--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211656
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 sum or group by


2005-07-12

Thread
Russ

I wonder... what database are you using?  SQL server has always been pretty
helpful with that error

-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 12, 2005 2:28 PM
To: CF-Talk
Subject: Re: query sum or group by

oh thank you thank you thank you and I really mean it this time - thank you.

I am so sick of seeing that error.  This puts me back to just trying ot
figure the functionality.  yes!

oh man, thanks.

>Here's the rule. It's pretty simple.
>
>You can not select aggregate function (sum, count, max, min, etc)
>columns and regular columns without using group by. Every column in
>the select statement must either have an aggregate function, or must
>be in the group by clause. What you're trying to do above will work if
>you add food_item and pkg_size to the group by, and total the gs_price
>column.
>
>On 7/12/05, daniel kessler <[EMAIL PROTECTED]> wrote:
>>



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211655
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: Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
S . Isaac Dealey

>  >>I have no say about storing the images in the DB and
>  >>that decision is
> already made

> Never too late to reverse a bad decision.

Except when that decision was to step off the curb in front of a fast
moving buss.

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

add features without fixtures with
the onTap open source framework

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




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211654
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: Web service caling local CFC


2005-07-12

Thread
Bryan Stevenson

> Hey Brian,
>
> Maybe try adding a ColdFusion mapping called "appCFCs" to wherever the
> appCFCs directory is - I've had issues with CFC resolution in
> containers other than CFM where I've needed explicit mappings, namely
> remote gateways.
>
> -Joe

There is a mapping already called "appCFCs" to the CFCs directoryused to 
call the local/internal CFC.  The problem is that the mapping doesn't seem 
to work when the container web service (on the same server) uses that 
mapping to call the local/internal CFC.

Am I not "gettin" you Joe? ;-)

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 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211653
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: Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
Claude Schneegans

 >>I have no say about storing the images in the DB and that decision is 
already made

Never too late to reverse a bad decision.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211652
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 sum or group by


2005-07-12

Thread
daniel kessler

oh thank you thank you thank you and I really mean it this time - thank you. 
I am so sick of seeing that error.  This puts me back to just trying ot figure 
the functionality.  yes!

oh man, thanks.

>Here's the rule. It's pretty simple.
>
>You can not select aggregate function (sum, count, max, min, etc)
>columns and regular columns without using group by. Every column in
>the select statement must either have an aggregate function, or must
>be in the group by clause. What you're trying to do above will work if
>you add food_item and pkg_size to the group by, and total the gs_price
>column.
>
>On 7/12/05, daniel kessler <[EMAIL PROTECTED]> wrote:
>>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211651
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: Canadian CF hosting & CC processing?


2005-07-12

Thread
Bryan Stevenson

Little late to this myself...

I know CrystalTech got panned on here a few months back...at that time I'd 
never used them.  I know some people swear by them, but since the panning I 
have worked on a project hosted with them.  I've been pretty unimpressed so 
farconsistent intermittent MAJOR slow downs and lots of forwared mail 
goes missing or is deleiverd days late.but heyjust one persons 
experience ;-)

Just a heads uplike I said...lots of people have no tribble at all ;-)

Personally I use Uniserve.com$24.95 month gets ya CF hosting with FREE 
MS SQL Server (although I'm sure you pay if you go over  acertain size 
limit...but I haven't hit it yet).

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 


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211650
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: Web service caling local CFC


2005-07-12

Thread
Joe Rinehart

Hey Brian,

Maybe try adding a ColdFusion mapping called "appCFCs" to wherever the
appCFCs directory is - I've had issues with CFC resolution in
containers other than CFM where I've needed explicit mappings, namely
remote gateways.

-Joe

On 7/12/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> Hey All,
> 
> An associate is having an issue with a web service calling a method in a 
> local CFC.  Both the web service and the local CFC are on the same server 
> just different directories.  Of course the local CFC uses access="public" and 
> the web service CFC uses access="remote".
> 
> There is a CF mapping to the local CFC called "appCFCs"
> 
> Any local CF templates calling the local CFC work just fine using the code 
> below:
> 
>component="appCFCs.FOS.groundfish"
>   method="getActivity"
>   user="#userid#"
>   pwd="#passwd#"
>   act_id="#url.act_id#"
>   trip_act_id="#url.trip_act_id#"
>   pd_id="#url.pd_id#"
>   act_verify_no="#url.act_verify_no#"
>   actyp_cde="#url.actyp_cde#"
>   returnvariable="qryAct">
> 
> When the web service cals the same method in the CFC above it uses:
> 
>component="appCFCs.FOS.groundfish"
>   method="getActivity"
>   user="#arguments.user#"
>   pwd="#arguments.pwd#"
>   act_id="#arguments.act_id#"
>   trip_act_id="#arguments.trip_act_id#"
>   pd_id="#arguments.pd_id#"
>   act_verify_no="#arguments.act_verify_no#"
>   actyp_cde="#arguments.actyp_cde#"
>   returnvariable="qryAct">
> 
> The call above generates an error: "Could not find the ColdFusion Component 
> appCFCs.FOS.groundfish"
> 
> NOTE: The web service is in a different directory on the server than the 
> local CFC as it will be SSL secured (but isn't currently)
> 
> Personally I've never had a web service cal a local CFC, but I have had local 
> CFCs call each other with not problemsso I'm not quite sure why this is 
> happening.
> 
> Any thoughts?
> 
> 
> 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
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211649
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





Web service caling local CFC


2005-07-12

Thread
Bryan Stevenson

Hey All,

An associate is having an issue with a web service calling a method in a local 
CFC.  Both the web service and the local CFC are on the same server just 
different directories.  Of course the local CFC uses access="public" and the 
web service CFC uses access="remote".

There is a CF mapping to the local CFC called "appCFCs"

Any local CF templates calling the local CFC work just fine using the code 
below:



When the web service cals the same method in the CFC above it uses:



The call above generates an error: "Could not find the ColdFusion Component 
appCFCs.FOS.groundfish"

NOTE: The web service is in a different directory on the server than the local 
CFC as it will be SSL secured (but isn't currently)

Personally I've never had a web service cal a local CFC, but I have had local 
CFCs call each other with not problemsso I'm not quite sure why this is 
happening.

Any thoughts?


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

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211648
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





Storing and retrieving images from SQL Server 2000


2005-07-12

Thread
Burns, John D

I've looked in the archives and can't find a good answer to this. I know
I've done it in the past, I just can't remember how and my brain hurts
so i figured i'd ask the list.  I have no say about storing the images
in the DB and that decision is already made, so I just need help putting
them in there and getting them out.
 
Right now, the DB is set up with a column of the type BLOB.  I'm trying
to figure out how to let a user upload a file and then read that file
back off of the server and insert it into the database using 
but it's not working for me.  Do I need to do any conversions using any
cf functions before the insert?
 
When I'm trying to pull it from the DB, I have a page that does the
query and uses  to set the type to image/gif and then output
the result of the query using #queryname.value# and
i'm calling that page using  but I'm not
getting the result as expected.
 
I think it all goes back to how I'm putting it in and pulling it from
the DB.  Any help would be greatly appreciated and I'd like to stay away
from CFX tags if at all possible.  We have tried a couple and have
gotten patchy results.  Thanks for your help while my brain is out to
lunch!
 
John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 
 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211647
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: Canadian CF hosting & CC processing?


2005-07-12

Thread
Dirk Sieber

Rather delayed, but... just wanted to thank everyone for their
suggestions - looks like they're probably going with e-xact for CC
processing, and Crystaltech.com for hosting.

Thanks!

Dirk

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211646
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 sum or group by


2005-07-12

Thread
Deanna Schneider

Here's the rule. It's pretty simple.

You can not select aggregate function (sum, count, max, min, etc)
columns and regular columns without using group by. Every column in
the select statement must either have an aggregate function, or must
be in the group by clause. What you're trying to do above will work if
you add food_item and pkg_size to the group by, and total the gs_price
column.

On 7/12/05, daniel kessler <[EMAIL PROTECTED]> wrote:
> >I'm a bit confused as to what you're trying to count and total. It
> >looks to me like you're now doing a count and price by item, whereas
> >before you wanted a grand total. IF you want a count and price by
> >item, you'd just do:
> >
> >SELECT itemname, SUM(pricecolumn) as totalpricebyitem, COUNT(itemid)
> >AS countbyitem
> >FROM yourtables
> >group by itemname
> 
> I'm sorry. I didn't mean to confuse.  It's a very similar query as the first 
> one, but it is a different query.
> You're right, except I'm not doing a SUM on the price per item. I'm just 
> trying to find out how many orange juices there are at whatever price they're 
> at.  I tried adjusting yours and mine to this:
> SELECT s.food_item,s.pkg_size,s.gs_price, COUNT(p.food_store_id) AS item_total
> FROM fsnep_food_store_purchases p, fsnep_food_store s
> WHERE p.food_store_id = s.food_store_id
> AND p.gi_id = #cookie.fsnep_bargain_hunt_gi_id#
> GROUP BY s.food_item
> 
> but I receive the same error that I always receive, "not a GROUP BY 
> expression" and I never know why it's not a valid groupby expression.
> 
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211645
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 sum or group by


2005-07-12

Thread
daniel kessler

>I'm a bit confused as to what you're trying to count and total. It
>looks to me like you're now doing a count and price by item, whereas
>before you wanted a grand total. IF you want a count and price by
>item, you'd just do:
>
>SELECT itemname, SUM(pricecolumn) as totalpricebyitem, COUNT(itemid)
>AS countbyitem
>FROM yourtables
>group by itemname

I'm sorry. I didn't mean to confuse.  It's a very similar query as the first 
one, but it is a different query.
You're right, except I'm not doing a SUM on the price per item. I'm just trying 
to find out how many orange juices there are at whatever price they're at.  I 
tried adjusting yours and mine to this:
SELECT s.food_item,s.pkg_size,s.gs_price, COUNT(p.food_store_id) AS item_total
FROM fsnep_food_store_purchases p, fsnep_food_store s
WHERE p.food_store_id = s.food_store_id
AND p.gi_id = #cookie.fsnep_bargain_hunt_gi_id#
GROUP BY s.food_item

but I receive the same error that I always receive, "not a GROUP BY expression" 
and I never know why it's not a valid groupby expression.

 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211644
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 sum or group by


2005-07-12

Thread
Deanna Schneider

I'm a bit confused as to what you're trying to count and total. It
looks to me like you're now doing a count and price by item, whereas
before you wanted a grand total. IF you want a count and price by
item, you'd just do:

SELECT itemname, SUM(pricecolumn) as totalpricebyitem, COUNT(itemid)
AS countbyitem
FROM yourtables
group by itemname



On 7/12/05, daniel kessler <[EMAIL PROTECTED]> wrote:
> >When you ask Oracle to group by a particular column, it looks for like
> >values within that column and groups those rows of data together.
> >Let's look at some sample data.
> >
> >CustID  PricePaid Date
> >1 .505/1/05
> >1 .75   5/7/05
> >21.00  6/1/06
> >2.50 5/1/05
> >
> 
> So, why  would I get the error, "not a group by expression" when I add a 
> column to the group by?  I receive this error freqently and never understand 
> why.  In this case, I'm using the food store unique id for each food item.
> 
> Also, since I'm asking, I'm trying to figure out how to get the number of 
> items in a grouped set or if they should not be grouped but instead sorted, 
> how do I get a count of those items.  In other words, I return a list of 
> purchased items.  I may have 4 drinks and 2 waters.  I want to list the 
> shopping cart just like that:
> 4 drink 6oz 3.19
> 2 water 32 oz 1.69
> 
> but I only know how to return a list.
> 
> Here's a picture of the current setup to hopefully make my explanation 
> clearer.
> http://eatsmart.umd.edu/activities/shopping_cart.gif
> under quantity in this case is just the food_item_id.  In this case  there 
> are only two unique items and in place of the current food_item_id, I'd like 
> to put the quantity of each item.
> 
> oh, I'm using the same query as displayed above, though on a different page 
> this time.
> 
> and sorry for all the DB questions, but I'm just out of my league today.  I'm 
> not really a TOTAL loser.
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211643
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: producing a .txt-file


2005-07-12

Thread
Jerry Johnson

If you NEED to do this, change the web server to have cold fusion
handle .txt files, and put the formatting in the application.cfm and
onRequestEnd.cfm files.

On 7/12/05, Dave Watts <[EMAIL PROTECTED]> wrote:
> > Hi list,
> > what do I have to
> > do to produce a .txt-file
> > with cffile and having the
> > text-font in bold and bigger than
> > the standard size.
> > Do I need cfcontent first ?
> 
> There are no formatting commands within a plain ASCII text file. It's just,
> well, text!
> 
> 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!
> 
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211642
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: producing a .txt-file


2005-07-12

Thread
Dave Watts

> Hi list,
> what do I have to
> do to produce a .txt-file
> with cffile and having the
> text-font in bold and bigger than
> the standard size.
> Do I need cfcontent first ?

There are no formatting commands within a plain ASCII text file. It's just,
well, text!

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!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211641
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: producing a .txt-file


2005-07-12

Thread
Russ

Plain text files do not have any formatting, therefore you cannot set the
font size or boldness, unless you're trying to produce an rtf or html...

-Original Message-
From: Uwe Degenhardt [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 12, 2005 12:10 PM
To: CF-Talk
Subject: producing a .txt-file

Hi list,
what do I have to
do to produce a .txt-file
with cffile and having the
text-font in bold and bigger than
the standard size.
Do I need cfcontent first ?

Uwe




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211640
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: retrieve ID from db insert


2005-07-12

Thread
Aaron Rouse

We appear to just be going around in circles on this one. If you have a 
query that selects the sequence next value then you do not need a 
CFTRANSACTION but you do have to remember to always select the next value 
since I'd assume this uses no trigger to handle it on any other inserts? 
What do you do for mass inserts from another table, guess just a little 
addition to the SQL and really no biggie on that one.
 Or you take the approach of never inserting anything manually into the "ID" 
column and just little a trigger/sequence handle it. That means using 
CFTRANSACTION so that after you insert it you do the SELECT MAX(ID) AS NEWID 
 Since there seems to be no adverse reason to using CFTRANSACTION unless 
in some of the already noted situations which seem more out of the norm than 
the norm, then this method just to me seems like an easier approach.

 On 7/12/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: 
> 
> The two query approach secures the id from the sequence though. No other
> thread, request, etc can get the same sequence value.
> 
> Now, if you were to manually build and control a numeric sequence ala 
> SELECT
> Max(id) + 1 as newid FROM tblname, then you would have to worry about this
> issue and use a transaction or lock orsomething. But with Oracle's 
> sequence,
> no need to worry.
> 
> DK
> 
> On 7/12/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> >
> > Yes, but isn't the point in doing the CFTRANSACTION in the way I am
> > describing to ensure that you get the ID of what you just inserted in
> > order
> > to pass it back to the website? More than likely to pass it back with a
> > URL
> > for telling the user hey this is where you go to view status or to edit
> > what
> > you just put in our database. I thought the point in doing the
> > CFTRANSACTION
> > for this was not so that you can do a rollback on the sequence(which we
> > all
> > agree can not happen anyway) but was to ensure when things are being
> > inserted by multiple people and around the same times that each person
> > gets
> > the ID that belongs to them.
> >
> > On 7/12/05, Douglas Knudsen
> >
> > ok. as I mentioned earlier in the this thread, a rollback does not 
> effect
> > a
> > sequence. So wrapping a transaction around these too queries is no
> > different
> > really then wrapping it around the single insert.
> >
> > DK
> >
> >
> >
> >
> >
> >
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211639
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





producing a .txt-file


2005-07-12

Thread
Uwe Degenhardt

Hi list,
what do I have to
do to produce a .txt-file
with cffile and having the
text-font in bold and bigger than
the standard size.
Do I need cfcontent first ?

Uwe


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211638
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: retrieve ID from db insert


2005-07-12

Thread
Douglas Knudsen

The two query approach secures the id from the sequence though. No other 
thread, request, etc can get the same sequence value. 

Now, if you were to manually build and control a numeric sequence ala SELECT 
Max(id) + 1 as newid FROM tblname, then you would have to worry about this 
issue and use a transaction or lock orsomething. But with Oracle's sequence, 
no need to worry. 

DK

On 7/12/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> 
> Yes, but isn't the point in doing the CFTRANSACTION in the way I am
> describing to ensure that you get the ID of what you just inserted in 
> order
> to pass it back to the website? More than likely to pass it back with a 
> URL
> for telling the user hey this is where you go to view status or to edit 
> what
> you just put in our database. I thought the point in doing the 
> CFTRANSACTION
> for this was not so that you can do a rollback on the sequence(which we 
> all
> agree can not happen anyway) but was to ensure when things are being
> inserted by multiple people and around the same times that each person 
> gets
> the ID that belongs to them.
> 
> On 7/12/05, Douglas Knudsen
> 
> ok. as I mentioned earlier in the this thread, a rollback does not effect 
> a
> sequence. So wrapping a transaction around these too queries is no 
> different
> really then wrapping it around the single insert.
> 
> DK
> 
> 
> 
> 
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211637
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: SQL 2005 & CFMX 7


2005-07-12

Thread
Lee

I have but had to use Windows Authentication using the 
Network Login ID. I played around with trying to use SQL 
Server Authentication but never got it to work.

Lee Surma


On Tue, 12 Jul 2005 11:29:57 -0400
  "Tangorre, Michael" <[EMAIL PROTECTED]> wrote:
> Has anyone successfully setup an ODBC connection with 
>CFMX 7 and SQL
> 2005? I am playing around with SQL 2005 on my 
>workstation and am having
> trouble getting the ODBC configured Keep getting an 
>error for login
> even though the name and password specified are legal 
>logins with
> appropriate access (sa).
> 
> TIA,
> 
> Mike
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211636
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 sum or group by


2005-07-12

Thread
daniel kessler

>When you ask Oracle to group by a particular column, it looks for like
>values within that column and groups those rows of data together.
>Let's look at some sample data.
>
>CustID  PricePaid Date
>1 .505/1/05
>1 .75   5/7/05
>21.00  6/1/06
>2.50 5/1/05
>

So, why  would I get the error, "not a group by expression" when I add a column 
to the group by?  I receive this error freqently and never understand why.  In 
this case, I'm using the food store unique id for each food item.

Also, since I'm asking, I'm trying to figure out how to get the number of items 
in a grouped set or if they should not be grouped but instead sorted, how do I 
get a count of those items.  In other words, I return a list of purchased 
items.  I may have 4 drinks and 2 waters.  I want to list the shopping cart 
just like that:
4 drink 6oz 3.19
2 water 32 oz 1.69

but I only know how to return a list.

Here's a picture of the current setup to hopefully make my explanation clearer.
http://eatsmart.umd.edu/activities/shopping_cart.gif
under quantity in this case is just the food_item_id.  In this case  there are 
only two unique items and in place of the current food_item_id, I'd like to put 
the quantity of each item.

oh, I'm using the same query as displayed above, though on a different page 
this time.

and sorry for all the DB questions, but I'm just out of my league today.  I'm 
not really a TOTAL loser.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211635
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





Reference an ActionScript Variable in a CFQUERY?


2005-07-12

Thread
Claremont, Timothy

Here is what I am trying to achieve...

var SearchItem = SelectClientNum.selectedItem.data


SELECT BasicInfo.IDID, IDNo, Identity.ID,
(Trim(Identity.LastName)+", "+Trim(Identity.FirstName)+"
"+Trim(Identity.MI)) AS FullName
FROM (BasicInfo
INNER JOIN Identity ON BasicInfo.IDID = Identity.ID)
WHERE IDNo = '#SearchItem#'


I can't seem to get #SearchItem# to equal the value of
SelectClientNum.selectedItem.data

Further in my code I can reference SelectClientNum.selectedItem.data and
it is correct.

How do I refer to an ActionScript variable within a ???

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it from 
your system.

This footnote also confirms that this email message has been swept for
the presence of computer viruses.

Thank You,
Viahealth
**


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211634
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 to text file.


2005-07-12

Thread
Jeremy Meerwarth

I'd tend to go with an export from SQL server via DTS, but there's also a 
custom tag out there we use for various data imports called CF_QueryToText.
I think it's still available at:

http://www.cfmcentral.com/gallery/detail.cfm?Script_ID=23

It's pretty easy to use too:

 

I'm not sure of it's limitations as far as query size, but it's been able to 
handle whatever we've thrown at it so far.  
Just a thought
J

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211633
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





SQL 2005 & CFMX 7


2005-07-12

Thread
Tangorre, Michael

Has anyone successfully setup an ODBC connection with CFMX 7 and SQL
2005? I am playing around with SQL 2005 on my workstation and am having
trouble getting the ODBC configured Keep getting an error for login
even though the name and password specified are legal logins with
appropriate access (sa).

TIA,

Mike

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211632
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: MSXML in CF5? class not registered


2005-07-12

Thread
David Manriquez Farias

Mmmm , weird  I test another class (ExcelWorksheet) and loads perfectly.

:-S



-Mensaje original-
De: Dave Watts [mailto:[EMAIL PROTECTED] 
Enviado el: Tuesday, July 12, 2005 10:30 AM
Para: CF-Talk
Asunto: RE: MSXML in CF5? class not registered

>i have some problem using msXML in cf5 , Coldfusion just 
> says the object class is not registered
> 
>  tried :
> 
>  register the dll using regsrv32
>  upgrading the MDAC to 2.8
>  installed msXML 4.0
>  looking for the right name of the progID and CLSID with 
> OleView and use  each to test... but the same error keeps on 
> screen :-S
>  change permisions to access that object for all users in the machine.
> 
>  Any ideas?... i was used before in CFMX with no errors like this.

I would recommend that you try using it from another COM client, like
Windows Script Host, to see if it works from there. That will tell you
whether it's a CF problem or a problem with that COM object.

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!




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211631
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: retrieve ID from db insert


2005-07-12

Thread
Aaron Rouse

Yes, but isn't the point in doing the CFTRANSACTION in the way I am 
describing to ensure that you get the ID of what you just inserted in order 
to pass it back to the website? More than likely to pass it back with a URL 
for telling the user hey this is where you go to view status or to edit what 
you just put in our database. I thought the point in doing the CFTRANSACTION 
for this was not so that you can do a rollback on the sequence(which we all 
agree can not happen anyway) but was to ensure when things are being 
inserted by multiple people and around the same times that each person gets 
the ID that belongs to them.

On 7/12/05, Douglas Knudsen 

ok. as I mentioned earlier in the this thread, a rollback does not effect a
sequence. So wrapping a transaction around these too queries is no different
really then wrapping it around the single insert.

DK





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211630
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 sum or group by


2005-07-12

Thread
daniel kessler

I gave it a try, with the where clause duplicating the outside one, but it gave 
me an unusually large number, so I'll have to give it a bit more time.

thanks!


>Of course, that total_price subselect will undoubtedly need to be 
>altered with a where clause too, but you know your data, so play with 
>that some until it's the specific total you want. Then you will have 
>that column containing the total alongside all your others.
>
>Ken Ferguson wrote:

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211629
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: MSXML in CF5? class not registered


2005-07-12

Thread
Dave Watts

>i have some problem using msXML in cf5 , Coldfusion just 
> says the object class is not registered
> 
>  tried :
> 
>  register the dll using regsrv32
>  upgrading the MDAC to 2.8
>  installed msXML 4.0
>  looking for the right name of the progID and CLSID with 
> OleView and use  each to test... but the same error keeps on 
> screen :-S
>  change permisions to access that object for all users in the machine.
> 
>  Any ideas?... i was used before in CFMX with no errors like this.

I would recommend that you try using it from another COM client, like
Windows Script Host, to see if it works from there. That will tell you
whether it's a CF problem or a problem with that COM object.

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!


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211628
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 sum or group by


2005-07-12

Thread
Ken Ferguson

Of course, that total_price subselect will undoubtedly need to be 
altered with a where clause too, but you know your data, so play with 
that some until it's the specific total you want. Then you will have 
that column containing the total alongside all your others.

Ken Ferguson wrote:

> How does this work for you? Does this give you what you need?
> SELECT g.gi_id, p.si_id,s.food_store_id,s.gs_price, (select 
> SUM(gs_price) from fsnep_food_store) AS total_price
> FROM fsnep_food_store_purchases p, fsnep_food_store 
> s,fsnep_food_store_game_info g
> WHERE p.food_store_id = s.food_store_id
> AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id#
>
>
> --Ferg
>
>



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211627
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 sum or group by


2005-07-12

Thread
Ken Ferguson

How does this work for you? Does this give you what you need? 

SELECT g.gi_id, p.si_id,s.food_store_id,s.gs_price, 
(select SUM(gs_price) from fsnep_food_store) AS total_price
FROM fsnep_food_store_purchases p, fsnep_food_store 
s,fsnep_food_store_game_info g
WHERE p.food_store_id = s.food_store_id
 AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id#


--Ferg


Eddie Awad wrote:

>>SELECT p.si_id,s.food_store_id,s.gs_price, SUM(s.gs_price) AS total_price
>>FROM fsnep_food_store_purchases p, fsnep_food_store 
>>s,fsnep_food_store_game_info g
>>WHERE p.food_store_id = s.food_store_id
>>   AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id#
>>GROUP BY p.si_id,s.food_store_id,s.gs_price
>>
>>
>
>Remove the s.gs_price from the select clause and the group by clause
>if you want a sum on this column:
>
>SELECT p.si_id,s.food_store_id, SUM(s.gs_price) AS total_price
>FROM fsnep_food_store_purchases p, fsnep_food_store
>s,fsnep_food_store_game_info g
>WHERE p.food_store_id = s.food_store_id
>   AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id#
>GROUP BY p.si_id,s.food_store_id
>  
>


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211626
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





MSXML in CF5? class not registered


2005-07-12

Thread
David Manriquez

   Hi ppl ,

   i have some problem using msXML in cf5 , Coldfusion just says the object 
class is not registered

 tried :

 register the dll using regsrv32
 upgrading the MDAC to 2.8
 installed msXML 4.0
 looking for the right name of the progID and CLSID with OleView and use  each 
to test... but the same error keeps on screen :-S
 change permisions to access that object for all users in the machine.


 Any ideas?... i was used before in CFMX with no errors like this.



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211625
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: null null errors


2005-07-12

Thread
Jeremy Meerwarth

OMG! I think I just found a solution for this (at least in my instance).  Based 
on the information that this was being thrown by the  tag, and 
that it probably had something to do with missing CFTOKEN information, I added 
the folloiwng line of code just above the  tag:





All this does is just check for the existence of CFTOKEN in the URL, and if it 
doesn't exist, it creates it.  BTW, I tried this using a variety of scopes, and 
URL seemed to work the best in all the scenarios I was able to test.  Since 
adding this code yesterday morning, I haven't received a single "null null" 
error on my site (down from usually ~20-30 a day).  Does anyone see any 
potential pitfalls with using this code this way?


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211624
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 sum or group by


2005-07-12

Thread
Deanna Schneider

On 7/12/05, daniel kessler <[EMAIL PROTECTED]> wrote:

>   I guess I could also replicate the query with another name and just do a 
> sum there.

Ack. Don't do that. If you want to learn how to do it in a sub-query,
then by all means, research subqueries. But doing an extra trip back
to the DB is very inefficient and bad design, when all the information
you need is already right there in memory for you.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211623
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




    
  1   2    >  
  
  

    

      
    
    
 1 - 100 of 117 matches
    

    
Advanced search


Search the list




    
    

      

                               Site Navigation
      
      

        
The Mail Archive home
        

          cf-talk - all messages
        

          cf-talk  - about the list
        
Expand
      
    

    

      

  				Mail list logo
      
      
    
  
  

    

	        	      Footer information
    
    

      
The Mail Archive home
      
Add your mailing list
      
FAQ
      
Support
      
Privacy