Re: For emergency only

[Andrew Grosset]

>Sprint PPC 6700 with unlimited incoming and unlimited internet.

so I guess they get you on outgoing phone calls? If so you could try using 
skype though I have seen some service agreements try to restrict VOIP 
arrangements...

looks really good, I never could see why there was so much hype over the 
blackberry when you can buy a device like Sprint.

Andrew.

~|
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:226386
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: database table design consideration

[Ray Champagne]

Well, as I just explained to Kiley, off-list, I might be the one who 
understood my teachings wrong.  I've been known to do that.  :)

I'll continue on with the bridge, intersection, cross-ref, whatever 
you'd call it.

Thanks for the help all!

Ray

Dave Watts wrote:
>>I was always taught to avoid bridge (or cross ref) tables, 
>>because it usually meant that you designed your data structure 
>>poorly. I understand that it's unavoidable in some cases, I was 
>>hoping that wasn't the case here.
> 
> 
> That's just crazy talk. You should use intersection tables whenever it's
> appropriate, which is pretty often.
> 
> 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:226385
Archives: http://www.houseoffusion.com/cf_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: cfLOCATION - what's it doing??

[Charlie Griefer]

On 12/7/05, Dave Watts <[EMAIL PROTECTED]> wrote:
> > server side code will execute before client side code.  so the server
> > does it's relocation (based on the ) before the JS (or any
> > other part of the document) ever has a chance to be interpreted by the
> > client/browser.
>
> Strictly speaking, this isn't exactly correct. The CFLOCATION tag doesn't
> execute on the server, it simply sends a message to the browser (along with
> your generated page). The browser then request the page specified in the
> Location header created by the CFLOCATION tag.
>
> If I recall correctly, CFMX does provide a way to do true server-side
> relocation, in which the browser requests one file, but gets back another -
> GetPageContext().forward().

yeah, i knew it wasn't truly "server side", but didn't really know the
mechanics of how it worked well enough to properly explain it :\

i get it now :)

--
Charlie Griefer


"...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed."

~|
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:226384
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: database table design consideration

[Dave Watts]

> I was always taught to avoid bridge (or cross ref) tables, 
> because it usually meant that you designed your data structure 
> poorly. I understand that it's unavoidable in some cases, I was 
> hoping that wasn't the case here.

That's just crazy talk. You should use intersection tables whenever it's
appropriate, which is pretty often.

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:226383
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: database table design consideration

[Charlie Griefer]

i think that'd still be considered a "clean" design to accomplish what
you want.
if a property record can share more than one property_type, that's the
way to do it (IMHO).

On 12/7/05, Ray Champagne <[EMAIL PROTECTED]> wrote:
> I'm pretty sure that is what I meant with my "bridge" design.  I, like
> you, think that's my only choice in this situation.  I just hate having
> to deal with the two extra tables.  This app was very lean and mean, and
> this just makes it harder to maintain, IMO.
>
> I was always taught to avoid bridge (or cross ref) tables, because it
> usually meant that you designed your data structure poorly.  I
> understand that it's unavoidable in some cases, I was hoping that wasn't
> the case here.
>
> Kiley Simpson wrote:
> > Can you have the following tables
> >
> > PROPERTY
> >PROP_ID
> >PROP_NAME
> >
> > PROPERTY_TYPES
> >PROPERTY_TYPE_ID
> >PROPERTY_TYPE_NAME
> >
> > PROP_TYPE_XREF <- This just has the unique id's from the 2 above tables.
> >PROP_ID
> >PROPERTY_TYPE_ID
> >
> > with this you can have unlimited property types per property.
> >
> >
> > At 10:19 PM 12/6/2005, you wrote:
> >
> >>So - I have a real estate listings table, and my client wants to add a
> >>"property type" field to each listing, such as "golf home", "ski home",
> >>"village home", "mountain condo" etc to each of the listings.  This
> >>"field" will then be used in a quick search set of links that will be
> >>clickable on each page as an alternative to using the full search
> >>capability.   The problem I am having is how to add this "field" to the
> >>listings table, because a listing can be more than one property type,
> >>ie, a "golf home" in the summer is also a "ski home" in the winter, etc.
> >>  (It's a resort town)  Now I think I've got a many to many
> >>relationship, and I want out.
> >>
> >>My first thought was to just input the types into a comma delimited list
> >>and store that in a prop_type field in the listings table, but that is
> >>just plain ugly to work with, search from, will slow down my pages, etc.
> >>
> >>I then went to a bridge table design, using a prop_type table with an
> >>prop_type_ID and prop_type_name, then using a bridge table to link the
> >>three tables together (prop_type_FK, listing_FK, ID)  but that'll be a
> >>nightmare to maintain in the future.
> >>
> >>I'm out of ideas.  Is there a better way to do what I'm trying to do?
> >>Am I stuck?
> >>
> >>MySQL 4.x DB, BTW.
> >>
> >>Thanks,
> >>
> >>Ray
> >>
> >>
> >
> >
> >
>
> 

~|
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:226382
Archives: http://www.houseoffusion.com/cf_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: cfLOCATION - what's it doing??

[Dave Watts]

> server side code will execute before client side code.  so the server
> does it's relocation (based on the ) before the JS (or any
> other part of the document) ever has a chance to be interpreted by the
> client/browser.

Strictly speaking, this isn't exactly correct. The CFLOCATION tag doesn't
execute on the server, it simply sends a message to the browser (along with
your generated page). The browser then request the page specified in the
Location header created by the CFLOCATION tag.

If I recall correctly, CFMX does provide a way to do true server-side
relocation, in which the browser requests one file, but gets back another -
GetPageContext().forward().

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:226381
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: database table design consideration

[Ray Champagne]

I'm pretty sure that is what I meant with my "bridge" design.  I, like 
you, think that's my only choice in this situation.  I just hate having 
to deal with the two extra tables.  This app was very lean and mean, and 
this just makes it harder to maintain, IMO.

I was always taught to avoid bridge (or cross ref) tables, because it 
usually meant that you designed your data structure poorly.  I 
understand that it's unavoidable in some cases, I was hoping that wasn't 
the case here.

Kiley Simpson wrote:
> Can you have the following tables
> 
> PROPERTY
>PROP_ID
>PROP_NAME
> 
> PROPERTY_TYPES
>PROPERTY_TYPE_ID
>PROPERTY_TYPE_NAME
> 
> PROP_TYPE_XREF <- This just has the unique id's from the 2 above tables.
>PROP_ID
>PROPERTY_TYPE_ID
> 
> with this you can have unlimited property types per property.
> 
> 
> At 10:19 PM 12/6/2005, you wrote:
> 
>>So - I have a real estate listings table, and my client wants to add a
>>"property type" field to each listing, such as "golf home", "ski home",
>>"village home", "mountain condo" etc to each of the listings.  This
>>"field" will then be used in a quick search set of links that will be
>>clickable on each page as an alternative to using the full search
>>capability.   The problem I am having is how to add this "field" to the
>>listings table, because a listing can be more than one property type,
>>ie, a "golf home" in the summer is also a "ski home" in the winter, etc.
>>  (It's a resort town)  Now I think I've got a many to many
>>relationship, and I want out.
>>
>>My first thought was to just input the types into a comma delimited list
>>and store that in a prop_type field in the listings table, but that is
>>just plain ugly to work with, search from, will slow down my pages, etc.
>>
>>I then went to a bridge table design, using a prop_type table with an
>>prop_type_ID and prop_type_name, then using a bridge table to link the
>>three tables together (prop_type_FK, listing_FK, ID)  but that'll be a
>>nightmare to maintain in the future.
>>
>>I'm out of ideas.  Is there a better way to do what I'm trying to do?
>>Am I stuck?
>>
>>MySQL 4.x DB, BTW.
>>
>>Thanks,
>>
>>Ray
>>
>>
> 
> 
> 

~|
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:226380
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: database table design consideration

[Kiley Simpson]

Can you have the following tables

PROPERTY
   PROP_ID
   PROP_NAME

PROPERTY_TYPES
   PROPERTY_TYPE_ID
   PROPERTY_TYPE_NAME

PROP_TYPE_XREF <- This just has the unique id's from the 2 above tables.
   PROP_ID
   PROPERTY_TYPE_ID

with this you can have unlimited property types per property.


At 10:19 PM 12/6/2005, you wrote:
>So - I have a real estate listings table, and my client wants to add a
>"property type" field to each listing, such as "golf home", "ski home",
>"village home", "mountain condo" etc to each of the listings.  This
>"field" will then be used in a quick search set of links that will be
>clickable on each page as an alternative to using the full search
>capability.   The problem I am having is how to add this "field" to the
>listings table, because a listing can be more than one property type,
>ie, a "golf home" in the summer is also a "ski home" in the winter, etc.
>   (It's a resort town)  Now I think I've got a many to many
>relationship, and I want out.
>
>My first thought was to just input the types into a comma delimited list
>and store that in a prop_type field in the listings table, but that is
>just plain ugly to work with, search from, will slow down my pages, etc.
>
>I then went to a bridge table design, using a prop_type table with an
>prop_type_ID and prop_type_name, then using a bridge table to link the
>three tables together (prop_type_FK, listing_FK, ID)  but that'll be a
>nightmare to maintain in the future.
>
>I'm out of ideas.  Is there a better way to do what I'm trying to do?
>Am I stuck?
>
>MySQL 4.x DB, BTW.
>
>Thanks,
>
>Ray
>
>

~|
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:226379
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

database table design consideration

[Ray Champagne]

So - I have a real estate listings table, and my client wants to add a 
"property type" field to each listing, such as "golf home", "ski home", 
"village home", "mountain condo" etc to each of the listings.  This 
"field" will then be used in a quick search set of links that will be 
clickable on each page as an alternative to using the full search 
capability.   The problem I am having is how to add this "field" to the 
listings table, because a listing can be more than one property type, 
ie, a "golf home" in the summer is also a "ski home" in the winter, etc. 
  (It's a resort town)  Now I think I've got a many to many 
relationship, and I want out.

My first thought was to just input the types into a comma delimited list 
and store that in a prop_type field in the listings table, but that is 
just plain ugly to work with, search from, will slow down my pages, etc.

I then went to a bridge table design, using a prop_type table with an 
prop_type_ID and prop_type_name, then using a bridge table to link the 
three tables together (prop_type_FK, listing_FK, ID)  but that'll be a 
nightmare to maintain in the future.

I'm out of ideas.  Is there a better way to do what I'm trying to do? 
Am I stuck?

MySQL 4.x DB, BTW.

Thanks,

Ray

~|
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:226378
Archives: http://www.houseoffusion.com/cf_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: cfLOCATION - what's it doing??

[Dave Watts]

> I'm having a problem with cfLOCATION and I'm not sure if it's a bug or
> I'm not understanding it correctly.
> 
> I have:
> 
>
>  top.will_load++;
>  parent.frames[0].location
>= "ButtonPanel.cfm"
>+ "?mode=debug";
>
>  
>   URL="CatReviewFile.cfm?Revision=#URLEncodedFormat(RevisionPath)#">
> 
> (Yes, the cfIF is firing).  When I run it, the script just does not
> take effect.  I tried replacing it with a large amount of text,
> and that is not displayed either.
> 
> If I replace the cfLOCATION with Javascript - location = 
> "CatReviewFile...
> it works just fine.
> 
> I get the impression there is some optimization that says "cfLOCATION,
> okay we are going to be overwritten anyway, so we can ignore 
> everything." Obviously it can't.

If you place CFLOCATION within an HTML page with any content, that content
will not display (or in the case of JavaScript, it will not execute). The
CFLOCATION tag sets an HTTP Location response header, which tells the
browser to disregard the page and fetch the one specified in your CFLOCATION
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:226377
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cf shopping carts

[dave]

thats why u try to copy and paste from cartweaver and mess it up then come on 
here and ask for help like you wrote the code but in reality you mess up copy & 
pasting.

then you call me cpt access and you use access and in case ya havent figured it 
out yet access doesn't run on a mac (thank god), its funny how you try and make 
fun of the things u use, kinda like the rest stop..

now back on topic, since u been working on your cart for 9 months now whats up 
with it? Jared not writing it for ya anymore? ;)

~Dave the disruptor~
good sites - make money getting rid of ie :)
http://explorerdestroyer.com/
http://www.killbillsbrowser.com/ 


From: Will Tomlinson <[EMAIL PROTECTED]>
Sent: Tuesday, December 06, 2005 11:17 PM
To: CF-Talk 
Subject: Re: cf shopping carts 

> " All we need is a few good programers,"
> well that leaves will out... haha

Yeah I totally agree! I'm not good, I'm GREAT! 

You on the other hand, well you're Captain Cartweaver. lol!

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:226376
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cf shopping carts

[Will Tomlinson]

> " All we need is a few good programers,"
> well that leaves will out... haha


Yeah I totally agree! I'm not good, I'm GREAT! 

You on the other hand, well you're Captain Cartweaver. lol!

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:226375
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cf shopping carts

[dave]

" All we need is a few good programers,"
well that leaves will out... haha

Hey man Im ready to go, lets git r done!

All the ppl on here and no help? thats is quite sad!!! It's not like you will 
be giving up your beloved copy of homesite or anything, damn give a few hours, 
make a feature, CONTRIBUTE! g
:)

~Dave the disruptor~
good sites - make money getting rid of ie :)
http://explorerdestroyer.com/
http://www.killbillsbrowser.com/ 


From: "Andy" <[EMAIL PROTECTED]>
Sent: Tuesday, December 06, 2005 10:36 PM
To: CF-Talk 
Subject: RE: cf shopping carts 

Hay, disruptor! Don't be picking on THE open source project of the decade!
And I am not talking about the development time either.

All we need is a few good programers, architects, CSS experts, DB pros...
Besides that, we are all set :-))

Andy 

-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 10:01 PM
To: CF-Talk
Subject: cf shopping carts

since forever_cart.cfc is not going to be done for awhile I need to possibly
find a different solution to a cart i need.

any suggestions on a cart? Needs the following (and not cartweaver):
of course all the add, edit, delete- products, shipping, ect

but one thing I was just asked for is that if the order is over $11 to not
give usps as a shipping option and when you select a product is shows you
the product, so lets say you go into shirts it has the main listing and when
you select a color it shows that color. 

I currently can do that but it messes some stuff up and of course I could
add those functions but it might be cheaper to find a cart with that already
in it.

any suggestions? I havent been paying attention to the current available
carts ;)

~Dave the disruptor~
good sites - make money getting rid of ie :) http://explorerdestroyer.com/
http://www.killbillsbrowser.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:226374
Archives: http://www.houseoffusion.com/cf_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: UPDATE with subquery

[Michael T. Tangorre]

> From: Richard Colman [mailto:[EMAIL PROTECTED] 
> Does anyone know if this looks right:
> update spdinput set sequence =  "(select sequence from 
> spdinput where spdinput_id = 559)"
> where spdinput_id = 627
> I am afraid of blowing up my data table in SQL-Server.

Copy the table w/ data to a test table.
Test the update SQL.





~|
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:226373
Archives: http://www.houseoffusion.com/cf_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

UPDATE with subquery

[Richard Colman]

Does anyone know if this looks right:

 

update spdinput set sequence =  "(select sequence from spdinput where
spdinput_id = 559)"

where spdinput_id = 627

 

I am afraid of blowing up my data table in SQL-Server.

 

Rick Colman  



~|
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:226372
Archives: http://www.houseoffusion.com/cf_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: Open Source Shopping Cart Coding Guidelines

[Andy]

Welcome back.

Yup.  Visit https://sourceforge.net/projects/openbizservices/, sign up and
send me your unix ID offline so I can add you to the project.  We are
getting close to needing some developer help.  And if you want to take a
stab at Archeticture, I've got a draft that is almost ready for some serious
repair.

Andy 

-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 2:28 PM
To: CF-Talk
Subject: Re: Open Source Shopping Cart Coding Guidelines

Sorry it's taken so long to respond. Major issues in my migration to
Nashville (but I'm here!) I see Sean pointed you in a good direction...

Cutter

Andy wrote:

>Cutter,
>Are you going to get a chance to take a first cut at this?  If not, can 
>you point me to someplace that I can use to do so?
>
>Andy
>
>
>
>
>



~|
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:226371
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cf shopping carts

[Andy]

Hay, disruptor!  Don't be picking on THE open source project of the decade!
And I am not talking about the development time either.

All we need is a few good programers, architects, CSS experts, DB pros...
Besides that, we are all set :-))

Andy 

-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 10:01 PM
To: CF-Talk
Subject: cf shopping carts

since forever_cart.cfc is not going to be done for awhile I need to possibly
find a different solution to a cart i need.

any suggestions on a cart? Needs the following (and not cartweaver):
of course all the add, edit, delete- products, shipping, ect

but one thing I was just asked for is that if the order is over $11 to not
give usps as a shipping option and when you select a product is shows you
the product, so lets say you go into shirts it has the main listing and when
you select a color it shows that color. 

I currently can do that but it messes some stuff up and of course I could
add those functions but it might be cheaper to find a cart with that already
in it.

any suggestions? I havent been paying attention to the current available
carts ;)

~Dave the disruptor~
good sites - make money getting rid of ie :) http://explorerdestroyer.com/
http://www.killbillsbrowser.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:226370
Archives: http://www.houseoffusion.com/cf_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

cf shopping carts

[dave]

since forever_cart.cfc is not going to be done for awhile I need to possibly 
find a different solution to a cart i need.

any suggestions on a cart? Needs the following (and not cartweaver):
of course all the add, edit, delete- products, shipping, ect

but one thing I was just asked for is that if the order is over $11 to not give 
usps as a shipping option and when you select a product is shows you the 
product, so lets say you go into shirts it has the main listing and when you 
select a color it shows that color. 

I currently can do that but it messes some stuff up and of course I could add 
those functions but it might be cheaper to find a cart with that already in it.

any suggestions? I havent been paying attention to the current available carts 
;)

~Dave the disruptor~
good sites - make money getting rid of ie :)
http://explorerdestroyer.com/
http://www.killbillsbrowser.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:226369
Archives: http://www.houseoffusion.com/cf_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: The be-all-end-all of email regex's

[Paul Vernon]

> You mind sending me those links as well?  :)
> 

Done.

Paul



~|
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:226368
Archives: http://www.houseoffusion.com/cf_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: The be-all-end-all of email regex's

[Jacob Munson]

You mind sending me those links as well?  :)

On 12/6/05, Paul Vernon <[EMAIL PROTECTED]> wrote:
>
> I have a CFX tag that will take a query and parse all the addresses listed
> in that query. It does a RegEx, then an MX lookup and if you need it an
> SMTP
> lookup. It can handle the input you specify and it will return a query
> with
> the e-mail address stripped out, the email address as it was input, the
> results for the RegEx check, MX check and SMTP check if you need them. If
> the SMTP check is done, the SMTP server response is returned too.
>
> I've sent a link to a demo and instructions offlist...
>
> Paul
>
>
> 

~|
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:226367
Archives: http://www.houseoffusion.com/cf_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: Why can't I ever GROUP correctly?

[Will Tomlinson]

Ok, gotcha!

Thanks again!

Will

~|
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:226366
Archives: http://www.houseoffusion.com/cf_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: cfLOCATION - what's it doing??

[Jonathan Gingerich]

Ah, of course.  Thanks, Charlie.

~|
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:226365
Archives: http://www.houseoffusion.com/cf_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: cfLOCATION - what's it doing??

[Jonathan Gingerich]

>server side code will execute before client side code.  so the server
>does it's relocation (based on the ) before the JS (or any
>other part of the document) ever has a chance to be interpreted by the
>client/browser.
>
>On 12/6/05, Jonathan Gingerich <[EMAIL PROTECTED]> wrote:
>>Ah, of course.  Thanks Charlie.

~|
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:226364
Archives: http://www.houseoffusion.com/cf_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: Why can't I ever GROUP correctly?

[Barney Boisvert]

Glad to help.

Based on a sentatnce in your response to James' email ["I'm thinking
if everything were grouped right in the SQL to start with, I wouldn't
have these problems."], I wanted to point out that for a CFOUTPUT
GROUP loop to work correctly, it's the ORDER BY clause of your SELECT
statement that has to be right.  The rest (aside from the columns
returned) is completely irrelevant to the CFOUTPUT.  In other words, a
grouped CFOUTPUT will behave correctly if and only if the rows in the
recordset are ordered correctly.  It doesn't care how they're created
(single table, joins, aggregate values, subqueries, etc), they just
have to be in the right order.

cheers,
barneyb

On 12/6/05, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> Barney,
>
> This explanation did it for me! Thanks a ton!
> What I needed to do was add a MAX() and MIN() to the SELECT.After all, I'm 
> just hunting for the lowest and highest price to display.
> Then GROUP BY everything but those. My mistake was trying to GROUP BY just 
> one thing, or GROUP BY  *EVERY*thing.
>
> Works like a champ!
>
> Thanks much,
> Will
>

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

Got Gmail? I have 100 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:226363
Archives: http://www.houseoffusion.com/cf_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: Why can't I ever GROUP correctly?

[Will Tomlinson]

Barney,

This explanation did it for me! Thanks a ton! 
What I needed to do was add a MAX() and MIN() to the SELECT.After all, I'm just 
hunting for the lowest and highest price to display. 
Then GROUP BY everything but those. My mistake was trying to GROUP BY just one 
thing, or GROUP BY  *EVERY*thing. 

Works like a champ!

Thanks much,
Will


~|
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:226362
Archives: http://www.houseoffusion.com/cf_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: The be-all-end-all of email regex's

[Paul Vernon]

I have a CFX tag that will take a query and parse all the addresses listed
in that query. It does a RegEx, then an MX lookup and if you need it an SMTP
lookup. It can handle the input you specify and it will return a query with
the e-mail address stripped out, the email address as it was input, the
results for the RegEx check, MX check and SMTP check if you need them. If
the SMTP check is done, the SMTP server response is returned too.

I've sent a link to a demo and instructions offlist...

Paul


~|
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:226361
Archives: http://www.houseoffusion.com/cf_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: Why can't I ever GROUP correctly?

[Will Tomlinson]

> Grouping in SQL does a different thing to grouping in cfoutput. What
> are you trying to acheive?
> 


Thanks James. I just need a ready-to-use value list of the prices for skus. 

Let's say I have a ProductID 1. 

ProductID 1 has 3 SKUID's associated with it: 6,7,8

Those SKUS have prices: 6-5.99, 7-6.99, 8-9.99

When I query for the productmaster.cfm display page, I have quite a few 
different productID's. The query returns many SKUS associated with each 
product. 

The problem I'm having is displaying each product, with its respective SKU info 
(prices to be exact). 

Currently, I'm using   and it 
works. 
But I can't figure out how to show the sku info correctly. I'm thinking if 
everything were grouped right in the SQL to start with, I wouldn't have these 
problems. 

Thanks much,
Will

~|
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:226360
Archives: http://www.houseoffusion.com/cf_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: Linux CFMX 6.1 / JVM crash revisited

[Terry Ford]

I did try installing the newest sun JDK (1.5_06) but get these errors on 
startup:

Does anyone have any tips on getting the 1.5 JDK to work with CFMX?

Thanks

--

12/06 18:54:41 user CFCServlet: destroy
12/06 18:54:41 user GraphServlet: destroy
12/06 18:54:41 user FlashGateway: destroy
Exception thrown by error-handling template:
coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Runtime 
service is not available.
at 
coldfusion.server.ServiceFactory.getRuntimeService(ServiceFactory.java:107)
at 
coldfusion.filter.ExceptionFilter.handleException(ExceptionFilter.java:98)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:61)
at 
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249)
at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
12/06 18:54:41 error The ClientScope service is not available.
coldfusion.server.ServiceFactory$ServiceNotAvailableException: The ClientScope 
service is not available.
at 
coldfusion.server.ServiceFactory.getClientScopeService(ServiceFactory.java:125)
at 
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:31)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249)
at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

12/06 18:54:41 error Exception occurred invoking custom error page 
/WEB-INF/exception/java/lang/Exception.cfm
coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Debugging 
service is not available.
at 
coldfusion.server.ServiceFactory.getDebuggingService(ServiceFactory.java:98)
at coldfusion.CfmServlet.getFilterChain(CfmServlet.java:72)
at coldfusion.CfmServlet.service(CfmServlet.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at 
jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:447)
at 
jrun.servlet.JRunRequestDispatcher.include(JRunRequestDispatcher.java:379)
at jrun.servlet.JRunResponse.sendErrorPage(JRunResponse.java:672)
at jrun.servlet.JRunResponse.sendError(JRunResponse.java:515)
at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:291)
at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Starting Macromedia JRun 4 (Build 75991), default server
[1]java.lang.NoSuchMethodException: setURL
at 
com.sun.jmx.mbeanserver.StandardMetaDataImpl.forbidInvokeGetterSetter(StandardMetaDataImpl.java:493)
at 
com.sun.jmx.mbeanserver.StandardMetaDat

Re: Why can't I ever GROUP correctly?

[Barney Boisvert]

You have to group by all the identifying fields.  So you just need to
list out all the fields.  Here's a simpler example:

SELECT p.id, p.name, count(c.*) AS carCount
FROM person p
  LEFT OUTER JOIN car c ON p.id = c.personID
GROUP BY p.id, p.name
ORDER BY p.name, p.id

If you omitted the "p.name" in the GROUP BY clause, you'd get the
error you're seeing, because that field is in the SELECT clause, but
is not an aggregate field.  In this case, it's not actually helping
the GROUP BY clause at all, because the id field will do finer
differentiation, but it has to be there.

MySQL, lifts this restriction, so you don't HAVE to list everything in
the GROUP BY clause if it's not needed for grouping, but that's mostly
a kludge because it didn't have subquery support until relatively
recently (past couple years).

The example query above would be better written with a correlated subquery:

SELECT id, name, (
SELECT COUNT(*)
FROM car
WHERE personID = person.id
  ) AS carCount
FROM person
ORDER BY name, id

In your case, it looks like you're returning multiple fields from your
related tables, so I don't think you want a GROUP BY clause at all,
but I could be mistaken.  GROUP BY in SQL and the GROUP attribute of
CFOUTPUT do totally different things for totally different reasons.

cheers,
barneyb

On 12/6/05, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> I need to learn how to GROUP in my db's. I'm sick of using the group 
> attribute in a . It always seems to make things harder for me!
>
> Ok, I have products, each product has SKUS. I run my query on the products 
> and SKUS. So far so good. How do I group the dang thing in the SQL?
>
> This doesn't work:
>
> SELECT  tblProducts.prodname, tblProducts.prodshortdescription,
> tblProducts.prodID, tblProducts.prodshowonweb, tblSKUS.SKU_prodID, 
> tblSKUS.SKUprice, tblSKUS.SKUsaleprice, tblProductCategories_rel.catID_rel, 
> tblProductCategories_rel.catID, tblProductCategories_rel.ProdID, 
> tblImages_rel.prodID,  tblImages_rel.imagetypeID, 
> tblImages_rel.prodimagefilename
> FROM (tblProducts
> LEFT OUTER JOIN tblImages_rel ON tblProducts.prodID = tblImages_rel.prodID)
> INNER JOIN tblProductCategories_rel ON tblProducts.prodID = 
> tblProductCategories_rel.ProdID
> INNER JOIN tblSKUS ON tblProducts.prodID = tblSKUS.SKU_prodID
> WHERE tblProductCategories_rel.catID =  cfsqltype="cf_sql_integer" value="#ARGUMENTS.CID#">
> AND prodshowonweb = 
> GROUP BY tblProducts.prodID
> ORDER BY tblProducts.prodname
>
> I get this error:
>
> 'tblProducts.prodname' is invalid in the select list because it is not 
> contained in either an aggregate function or the GROUP BY clause.
>
> How can I group this by the product ID?
>
> Thanks much,
> Will
>

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

Got Gmail? I have 100 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:226358
Archives: http://www.houseoffusion.com/cf_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: Why can't I ever GROUP correctly?

[James Holmes]

Grouping in SQL does a different thing to grouping in cfoutput. What
are you trying to acheive?


On 12/7/05, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> I need to learn how to GROUP in my db's. I'm sick of using the group 
> attribute in a . It always seems to make things harder for me!
>
> Ok, I have products, each product has SKUS. I run my query on the products 
> and SKUS. So far so good. How do I group the dang thing in the SQL?

--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.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:226357
Archives: http://www.houseoffusion.com/cf_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

Why can't I ever GROUP correctly?

[Will Tomlinson]

I need to learn how to GROUP in my db's. I'm sick of using the group attribute 
in a . It always seems to make things harder for me! 

Ok, I have products, each product has SKUS. I run my query on the products and 
SKUS. So far so good. How do I group the dang thing in the SQL? 

This doesn't work:

SELECT  tblProducts.prodname, tblProducts.prodshortdescription, 
tblProducts.prodID, tblProducts.prodshowonweb, tblSKUS.SKU_prodID, 
tblSKUS.SKUprice, tblSKUS.SKUsaleprice, tblProductCategories_rel.catID_rel, 
tblProductCategories_rel.catID, tblProductCategories_rel.ProdID, 
tblImages_rel.prodID,  tblImages_rel.imagetypeID, 
tblImages_rel.prodimagefilename
FROM (tblProducts 
LEFT OUTER JOIN tblImages_rel ON tblProducts.prodID = tblImages_rel.prodID)
INNER JOIN tblProductCategories_rel ON tblProducts.prodID = 
tblProductCategories_rel.ProdID
INNER JOIN tblSKUS ON tblProducts.prodID = tblSKUS.SKU_prodID
WHERE tblProductCategories_rel.catID = 
AND prodshowonweb = 
GROUP BY tblProducts.prodID
ORDER BY tblProducts.prodname

I get this error:

'tblProducts.prodname' is invalid in the select list because it is not 
contained in either an aggregate function or the GROUP BY clause.

How can I group this by the product ID?

Thanks much,
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:226356
Archives: http://www.houseoffusion.com/cf_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: cfLOCATION - what's it doing??

[Robert Redpath]

Just a stab in the dark but do you use any cfflush tags earlier in the page?  
If so, cflocation will not work.
 
 
"Using any of the following tags or functions on a page anywhere after the 
cfflush tag can cause errors or unexpected results: cfcontent, cfcookie, 
cfform, cfheader, cfhtmlhead, cflocation, and SetLocale." 
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p37.htm 
 



From: Jonathan Gingerich [mailto:[EMAIL PROTECTED]
Sent: Tue 12/6/2005 6:37 PM
To: CF-Talk
Subject: cfLOCATION - what's it doing??



I'm having a problem with cfLOCATION and I'm not sure if it's a bug or
I'm not understanding it correctly.

I have:

   
 top.will_load++;
 parent.frames[0].location
   = "ButtonPanel.cfm"
   + "?mode=debug";
   
 
 

(Yes, the cfIF is firing).  When I run it, the script just does not
take effect.  I tried replacing it with a large amount of text,
and that is not displayed either.

If I replace the cfLOCATION with Javascript - location = "CatReviewFile...
it works just fine.

I get the impression there is some optimization that says "cfLOCATION,
okay we are going to be overwritten anyway, so we can ignore everything."
Obviously it can't.

Any guess??

Jon.



~|
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:226355
Archives: http://www.houseoffusion.com/cf_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: cfLOCATION - what's it doing??

[Charlie Griefer]

server side code will execute before client side code.  so the server
does it's relocation (based on the ) before the JS (or any
other part of the document) ever has a chance to be interpreted by the
client/browser.

On 12/6/05, Jonathan Gingerich <[EMAIL PROTECTED]> wrote:
> I'm having a problem with cfLOCATION and I'm not sure if it's a bug or
> I'm not understanding it correctly.
>
> I have:
>
>
>  top.will_load++;
>  parent.frames[0].location
>= "ButtonPanel.cfm"
>+ "?mode=debug";
>
>  
>   URL="CatReviewFile.cfm?Revision=#URLEncodedFormat(RevisionPath)#">
>
> (Yes, the cfIF is firing).  When I run it, the script just does not
> take effect.  I tried replacing it with a large amount of text,
> and that is not displayed either.
>
> If I replace the cfLOCATION with Javascript - location = "CatReviewFile...
> it works just fine.
>
> I get the impression there is some optimization that says "cfLOCATION,
> okay we are going to be overwritten anyway, so we can ignore everything."
> Obviously it can't.
>
> Any guess??
>
> Jon.
>
> 

~|
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:226354
Archives: http://www.houseoffusion.com/cf_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

cfLOCATION - what's it doing??

[Jonathan Gingerich]

I'm having a problem with cfLOCATION and I'm not sure if it's a bug or
I'm not understanding it correctly.

I have:

   
 top.will_load++;
 parent.frames[0].location
   = "ButtonPanel.cfm"
   + "?mode=debug";
   
 
 

(Yes, the cfIF is firing).  When I run it, the script just does not
take effect.  I tried replacing it with a large amount of text,
and that is not displayed either.

If I replace the cfLOCATION with Javascript - location = "CatReviewFile...
it works just fine.

I get the impression there is some optimization that says "cfLOCATION,
okay we are going to be overwritten anyway, so we can ignore everything."
Obviously it can't.

Any guess??

Jon.

~|
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:226353
Archives: http://www.houseoffusion.com/cf_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: Formatted Excel

[Dave Ross]

I've used HSSF (part of the Apache POI project) for several years to accomplish 
what you're looking for. I have a few posts about it found here:

http://www.d-ross.org/index.cfm?objectid=9C65ED5A-508B-E116-6F4F7F38C6AE167C

and more here:

http://www.d-ross.org/index.cfm?objectid=9C65ECEC-508B-E116-6F8A9F878188D7CA

-Dave


>I've been dumping data from CF/SQL to Excel for years but 
>have never had to make it show up formatted in an 
>automated fashion. I did some searching in the archives 
>and didn't see anything great. Am I in for some serious 
>pain here? (By formatted I mean page headers, specified 
>fonts, rows of data, sub totals and stand alone data 
>pieces not related to the rows and maybe even print 
>areas.)
>
>Lee

~|
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:226352
Archives: http://www.houseoffusion.com/cf_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 Question. Compare one list to another

[John Wilker]

Ended up implementing the more normalized approach. Less headaches in the
future are always prefered. THanks for the input.


~|
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:226351
Archives: http://www.houseoffusion.com/cf_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: The be-all-end-all of email regex's

[Jacob Munson]

I don' t have one that fancy, but wouldn't it be better to seperate the name
out to a variable?  If you could do that, I've got a regex that will
validate email addresses pretty well, it even checks for email addresses
with an IP address.  I didn't write it, but it's pretty sweet.

On 12/6/05, Marlon Moyer <[EMAIL PROTECTED]> wrote:
>
> Anyone have a regex that will validate email addresses that look like
> such:
>
> [EMAIL PROTECTED]
> "Me Here" <[EMAIL PROTECTED]>
>
> and also be able to validate multiple email addy's at once like:
>
> [EMAIL PROTECTED], "Me Here" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>
> Thanks


~|
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:226350
Archives: http://www.houseoffusion.com/cf_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

Linux CFMX 6.1 / JVM crash revisited

[Terry Ford]

Hey folks,

Revisiting a thread from a couple of years ago that I never did get an answer 
to back then, but which was able to be worked around.  Just wondering if anyone 
now has an answer :)

The problem:  On linux, CFMX 6.1, sun JVM 1.4.2, cfserver under heavy load 
crashes randomly every couple of days due to a "hotspot error" reported by the 
JVM.  We determined that it was a bug in the JVM's hotspot compiler, and 
therefore determined that using the "-Xint" JVM flag (disabling it) could stop 
the crashes.

Good news: the server has run fine since in this "-Xint" mode.   Bad news: the 
performance hit of this workaround is less than optimal.  

I'm just wondering if anyone ever found a true fix for this problem (some 
combination of JVM flags?  some updated sun JVM?).  

Alternatively, is there a better JVM (that works!) for CFMX on linux now?  I've 
tried swapping out different JVMs (BEA's, IBM's) through the years with little 
success, as CFMX complains about not being able to find some function or other.

Any help with finding a stable, high performance JVM for CFMX on linux would be 
much appreciated. 

Regards,
Terry

~|
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:226349
Archives: http://www.houseoffusion.com/cf_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: CFEclipse

[Nathan Strutz]

Anthony, I don't have any links, and a quick google doesn't really
give me much, besides sean corfield's page where he's taking request
for changes in a future CFEclipse version.

To search in a single text file, just hit ctrl+f. It's mostly a simple
find with extra options.

To search multiple files, I usually select a folder on the navigator
view and hit the search button (or ctrl+h) This type of search is more
like the extended find/replace of HS/CFS, where it will give you a
list of results when it finishes. Actually, in Eclipse, it gives you
that list as it's going. The search view should pop up. I usually
switch it to Flat layout, using the down arrow.

In the search box, type in your criteria and choose the selected
resources radio to search within the folder you have selected, or you
can search your entire workspace of projects, or just the enclosing
projects (not sure, i think it's the projects whose files you have
open?), or you can define a working set of folders. Working sets are
great because you can filter your navigator view to show the same
working set you want to search in, it works in both places.

Replacing is the same, but it does a search before it asks you what to
replace your searched text with. A little weird but it works.

There's no option to search just the open files, that I know of...
would be interesting, and I've used it a few times in CFS, but haven't
missed it since switching.

I understand the file formatting search and replace. It is nice, and,
to this day, I may crack open HS once in a while to format a document.

-nathan strutz

PS, it looks like I'll be doing a cfeclipse preso at the azcfug in january :)


On 12/6/05, Anthony Prato <[EMAIL PROTECTED]> wrote:
> Do you have any links or postings that give some tips on searching? Do
> you use search>search... or edit>find/replace...?
> I am very very new to eclipse and I can't seem to get it do anything I
> like. Can you show the context of the results? Can you get the search
> results window to come up for just the current file or all open files?
>
> To add a comment about multi-line search & replace, I know you can use
> the regex to handle the tabs, newlines etc but the main benefit to me
> about the multiline is being able to cut and paste. I think my most
> common task is using it to reformat a file.
>
> On 12/6/05, Nathan Strutz <[EMAIL PROTECTED]> wrote:
> > On 12/6/05, Anthony Prato <[EMAIL PROTECTED]> wrote:
> > > been said by others, but the multi line find/replace from HS is the
> > > best. Its saved me manual labor more times than I can count.
> > > The results are much better too.
> >
> > My opinion is that the multi-line facet of HS's search & replace is
> > the only thing it has going for it, against Eclipse, plus you can fake
> > it in Eclipse with a regular expression like \s (any whitespace
> > character), \n (newline), \r (carriage return) and \t (tab). Eclipse's
> > regular expression searching is a LOT more powerful and precise than
> > HS's. Eclipse can display results in a flat layout like HS or in a
> > folder tree. Eclipse will save previous searches in the current
> > session (and my sessions tend to last for days, so i can see what i
> > searched for on monday). Also, you can define a working set, or a
> > group of folders and projects, possibly spanning multiple projects,
> > and search just them. All in all, I think the searching in HS is nice,
> > maybe easier, but Eclipse is better.
> >
> > Maybe we should call Mike Dinowitz's emergency-only cell and ask him
> > what he thinks.
> >
> > -nathan strutz
> > http://www.dopefly.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:226348
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Claude Schneegans]

 >>particularily accuarte

In Spanich or Portugese, I duno, but in English, I meant "accurate" ;-)

-- 
___
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:226347
Archives: http://www.houseoffusion.com/cf_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

The be-all-end-all of email regex's

[Marlon Moyer]

Anyone have a regex that will validate email addresses that look like such:

[EMAIL PROTECTED]
"Me Here" <[EMAIL PROTECTED]>

and also be able to validate multiple email addy's at once like:

[EMAIL PROTECTED], "Me Here" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]

Thanks



--
Marlon

A spaceman came travelling on his ship from afar,
'twas light years of time since his mission did start,
And over a village he halted his craft,
And it hung in the sky like a star, just like a star...
--Chris De Burgh, A Spaceman Came Travelling

~|
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:226346
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Claude Schneegans]

 >>And even more information on the subject:
 >>http://www.answers.com/topic/ieee-floating-point-standard

This one is particularily accuarte and detailed.
I can see that a number like −118.625 with as many as 6 significant digits
can be represented in single precision by
+-++---+
|S| Exp | Fraction |
|1|1101|11011010100|
+-++---+
in which less than half the bits are actually used for the fraction.
So how come it does not work for a small number like 24.82?

-- 
___
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:226345
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Bobby Hartsfield]

That was what I meant... if YOU controlled it from its early days as a wee
little datasource to its current teenage years and taught it about the birds
and the bees and how to drive... then you should handle those things before
it gets entered. Most of us have been through the nightmares that poor data
validation can and will cause with a 'hand me down' database.

but... I'm not bloating my application with checks for any FUTURE
developers mistakes
 
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 5:01 PM
To: CF-Talk
Subject: RE: Employee name

If you created the datasource and you wrote the code that puts the data into
it, you shouldn't have to check for any of these things when pulling the
data back.


True for as far as it goes, but I do a lot of work where I did not create
the database schema (but I did create a datasource that points to it) and I
did not create the code that puts the data into it.  But I have to create
the web output from this.  

So I would advice, based on my experience, don't count on the format of the
data going in unless you HAVE created the database, and one and only data
manipulation program and will ever be the only one to do so FOR ALL TIME.
Otherwise, those of us who are not one-man shows write our output to
gracefully handle, as best as we can, the unexpected because there is almost
always something unexpected!


--
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. 






~|
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:226344
Archives: http://www.houseoffusion.com/cf_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: cfscript Common Functions and Best Practices

[Bobby Hartsfield]

There was a thread not long ago about storing them in the application scope.
It sounded reasonable but I haven’t tried it so I can't elaborate on any
performance issues it might cause or clear up. You should be able to find
the thread in the archives.

..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Ryan Duckworth [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 5:54 PM
To: CF-Talk
Subject: cfscript Common Functions and Best Practices

Currently we have many functions that we use within cfscript.  We are
storing them in the request scope (see 2 examples below).


Here is what I am don't like about this approach:  Every page hit from
every user is loading these common functions.  I personally am not
convinced that the request scope is the best place for these types of
functions.  I'm sure that many of you out there use functions of your
own and from www.cflib.org.  Is the server scope a better place for
these?  Should we only reload the functions if they are not already
defined in the server scope?

Thanks,
Ryan












request.abort = abort;
request.sleep = sleep;



Call from within cfscript tag:
request.sleep(3000);
request.abort();



~|
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:226343
Archives: http://www.houseoffusion.com/cf_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: cfscript Common Functions and Best Practices

[Michael Dinowitz]

Setting commonly used functions to a 'permanent' memory scope such as server 
or application is a good idea. A better one would be to create a CFC that 
contains the common functions as well as common data and store that CFC in 
the memory scope.


> Currently we have many functions that we use within cfscript.  We are
> storing them in the request scope (see 2 examples below).
>
>
> Here is what I am don't like about this approach:  Every page hit from
> every user is loading these common functions.  I personally am not
> convinced that the request scope is the best place for these types of
> functions.  I'm sure that many of you out there use functions of your
> own and from www.cflib.org.  Is the server scope a better place for
> these?  Should we only reload the functions if they are not already
> defined in the server scope?
>
> Thanks,
> Ryan


~|
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:226342
Archives: http://www.houseoffusion.com/cf_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

cfscript Common Functions and Best Practices

[Ryan Duckworth]

Currently we have many functions that we use within cfscript.  We are
storing them in the request scope (see 2 examples below).


Here is what I am don't like about this approach:  Every page hit from
every user is loading these common functions.  I personally am not
convinced that the request scope is the best place for these types of
functions.  I'm sure that many of you out there use functions of your
own and from www.cflib.org.  Is the server scope a better place for
these?  Should we only reload the functions if they are not already
defined in the server scope?

Thanks,
Ryan












request.abort = abort;
request.sleep = sleep;



Call from within cfscript tag:
request.sleep(3000);
request.abort();

~|
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:226341
Archives: http://www.houseoffusion.com/cf_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: CFEclipse

[Anthony Prato]

Do you have any links or postings that give some tips on searching? Do
you use search>search... or edit>find/replace...?
I am very very new to eclipse and I can't seem to get it do anything I
like. Can you show the context of the results? Can you get the search
results window to come up for just the current file or all open files?

To add a comment about multi-line search & replace, I know you can use
the regex to handle the tabs, newlines etc but the main benefit to me
about the multiline is being able to cut and paste. I think my most
common task is using it to reformat a file.

On 12/6/05, Nathan Strutz <[EMAIL PROTECTED]> wrote:
> On 12/6/05, Anthony Prato <[EMAIL PROTECTED]> wrote:
> > been said by others, but the multi line find/replace from HS is the
> > best. Its saved me manual labor more times than I can count.
> > The results are much better too.
>
> My opinion is that the multi-line facet of HS's search & replace is
> the only thing it has going for it, against Eclipse, plus you can fake
> it in Eclipse with a regular expression like \s (any whitespace
> character), \n (newline), \r (carriage return) and \t (tab). Eclipse's
> regular expression searching is a LOT more powerful and precise than
> HS's. Eclipse can display results in a flat layout like HS or in a
> folder tree. Eclipse will save previous searches in the current
> session (and my sessions tend to last for days, so i can see what i
> searched for on monday). Also, you can define a working set, or a
> group of folders and projects, possibly spanning multiple projects,
> and search just them. All in all, I think the searching in HS is nice,
> maybe easier, but Eclipse is better.
>
> Maybe we should call Mike Dinowitz's emergency-only cell and ask him
> what he thinks.
>
> -nathan strutz
> http://www.dopefly.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:226340
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Claude Schneegans]

 >>it calculates to 0

I would be more impressed if it was 0.00 ;-)

-- 
___
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:226339
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Claude Schneegans]

 >>It's the hardware.

And since we are probabily all having the same kind of hardware, wil the 
same type of CPU, we'll never know ;-)
Unless may be some one is having one of these old Mac with a Motorola CPU ?

-- 
___
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:226338
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Barney Boisvert]

..NET 2.0 exhibits the same error, unless you explicitly declare the
Decimal type.  So just like Delphi.

MySQL also exhibits the same dichotomy (as should all SQL databases). 
You get an error if your types are double, float, or real, but if you
declare them as decimal, money, or currency, the operations are
perfect.

cheers,
barneyb

On 12/6/05, Damien McKenna <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: Barney Boisvert [mailto:[EMAIL PROTECTED]
> >
> > I'm telling you, it has nothing to do with software.  It's
> > the hardware.
>
> Anyone care to try it on a PC with an Athlon64 or a Mac?  I'm interested
> to see if different architectures make a difference.
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 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:226337
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Claude Schneegans]

 >>Can you explain my C

Actually yes, and beleive it or not, we were both right ! ;-)
I was right that there is no error when there is no rounding.
But I was wrong assuming there was no rounding; my problem was just 
assuming that a number
as small as 74.82 could be exactly represented in a floating value.
The following test simply shows that even 24.82 is not represented 
exactly by a float,
it is only correct as a double.
int main()
{
float x = 24.82;
double y = 24.82;
printf ("x =   %20.20e\ny =   %20.20e\n", x, y);
}
But I still can't explain why, since a mantissa for a float is supposed 
to be 23 bits long,
far sufficient to represent a 4 digits value.
After all, the whole big idea of floating values is to use the mantissa 
to represent as much
significant digits as possible, and "put" this value in the correct 
range using the exponent.
So why it doesn't work for 24.82 is still a mystery.

-- 
___
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:226336
Archives: http://www.houseoffusion.com/cf_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: CFEclipse

[Nathan Strutz]

On 12/6/05, Anthony Prato <[EMAIL PROTECTED]> wrote:
> been said by others, but the multi line find/replace from HS is the
> best. Its saved me manual labor more times than I can count.
> The results are much better too.

My opinion is that the multi-line facet of HS's search & replace is
the only thing it has going for it, against Eclipse, plus you can fake
it in Eclipse with a regular expression like \s (any whitespace
character), \n (newline), \r (carriage return) and \t (tab). Eclipse's
regular expression searching is a LOT more powerful and precise than
HS's. Eclipse can display results in a flat layout like HS or in a
folder tree. Eclipse will save previous searches in the current
session (and my sessions tend to last for days, so i can see what i
searched for on monday). Also, you can define a working set, or a
group of folders and projects, possibly spanning multiple projects,
and search just them. All in all, I think the searching in HS is nice,
maybe easier, but Eclipse is better.

Maybe we should call Mike Dinowitz's emergency-only cell and ask him
what he thinks.

-nathan strutz
http://www.dopefly.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:226335
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Ian Skinner]

If you created the datasource and you wrote the code that puts the data into 
it, you shouldn't have to check for any of these things when pulling the data 
back.


True for as far as it goes, but I do a lot of work where I did not create the 
database schema (but I did create a datasource that points to it) and I did not 
create the code that puts the data into it.  But I have to create the web 
output from this.  

So I would advice, based on my experience, don't count on the format of the 
data going in unless you HAVE created the database, and one and only data 
manipulation program and will ever be the only one to do so FOR ALL TIME.  
Otherwise, those of us who are not one-man shows write our output to gracefully 
handle, as best as we can, the unexpected because there is almost always 
something unexpected!


--
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:226334
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Barney Boisvert]

The 'dc' program (desk calculator - uses RPN) does error-less
evaluation of the expression as well.  So it clearly contains
something to handle it, probably an algorithm like Delphi's currency
type, where everything is converted to integers, and then the
exponentiation is tracked separately.

cheers,
barneyb

On 12/6/05, Adrian Moreno <[EMAIL PROTECTED]> wrote:
> >> Guess what that prints on Win2k in IE and FF?   Same exact error as
> >> Java (including CFMX) and C do on Linux.
> >
> >Just to throw the cat amongst the pigeons, in Delphi, it calculates to 0 :)
> >
> >Paul
>
> So you're saying that Deplhi produces a non-standard result? :P
>
> -- Adrian
>
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 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:226333
Archives: http://www.houseoffusion.com/cf_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: For emergency only

[Will Tomlinson]

Michael,

Can I call your cell when I need a long island iced tea? And, do you deliver?

:)

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:226332
Archives: http://www.houseoffusion.com/cf_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: CFEclipse

[Anthony Prato]

been said by others, but the multi line find/replace from HS is the
best. Its saved me manual labor more times than I can count.
The results are much better too.

On 12/6/05, Simon Horwith <[EMAIL PROTECTED]> wrote:
> what's wrong with the extended find and replace in Eclipse?  It's not
> called that, but you can do the same thing.
>
> ~Simon
>
> Ben Nadel wrote:
>
> >I think the only reason that would stop me from totally leaving homesite is
> >that Homesite's extended find/replace has not been paralleled in any other
> >application that I have seen.
> >
> >...
> >Ben Nadel
> >Web Developer
> >Nylon Technology
> >6 West 14th Street
> >New York, NY 10011
> >212.691.1134
> >212.691.3477 fax
> >www.nylontechnology.com
> >
> >"Vote for Pedro"
> >
> >
> >
>
> 

~|
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:226331
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Get low and high values from list

[Will Tomlinson]

Excellent! Thanks so much! 

I'll probably go with the array. 

:)

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:226330
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Bobby Hartsfield]

That too should be handled before it ever hits the database. If you created
the datasource and you wrote the code that puts the data into it, you
shouldn’t have to check for any of these things when pulling the data back.

..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 4:14 PM
To: CF-Talk
Subject: RE: Employee name

As for trim()... that should be done before the data goes into the database.


In my experience though, you should not rely on what 'should' happen at data
entry.  Trim the output, spaces could actually come from the database,
depending on what field types are used.  "char(10)" anybody?




--
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:226329
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Barney Boisvert]

In Delphi, double is floating point, but currency is NOT.  With a
double, "1.4" is stored as "1.4", while an equivalent Currency value
is stored as "14 / 10".  Note that the latter is integral, so it
doesn't have rounding errors.

The other way to represent perfectly consistent numbers is the way
DECIMAL (in SQL) is implemented, which is just as a string of
characters.  Then you do digit-wise integer operations (elementary
school style, with carrying and borrowing and stuff), which retains
perfect accuracy.

cheers,
barneyb

On 12/6/05, Paul Vernon <[EMAIL PROTECTED]> wrote:
> > So you're saying that Deplhi produces a non-standard result? :P
> >
>
> No, but interestingly, depending on which type I declare, I get different
> results...
>
> If I declare the types of the vars as Double, then I get a rounding error.
> If I choose extended (much greater accuracy than the processor manages by
> itself), I get 0. So, from this, it would appear that Delphi is defaulting
> its types to something that bypasses the hardware and uses its own libraries
> to calculate. If I use a type that maps to a hardware type then the error is
> there... I agree that this is a hardware issue.
>
> Even if I multiply the result by a very large number, with Extended, Comp
> and Currency I still get 0. With single, double, and real48 I get rounding
> issues.
>
> Delphi 7 types.
>
> TypeMin Max
> Precision   Size in bytes
> Real48  2.9 x 10^-391.7 x 10^38 11-12
> 6
> Single  1.5 x 10^-453.4 x 10^38 7-8
> 4
> Double  5.0 x 10^-324   1.7 x 10^30815-16   8
> Extended3.6 x 10^-4951  1.1 x 10^4932   19-20
> 10
> Comp-2^63+1 2^63 -1 19-20
> 8
> Currency-922337203685477.5808   922337203685477.580719-20
> 8
>
> Paul
>

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

Got Gmail? I have 100 invites.

~|
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:226328
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Barney Boisvert]

Java and Perl on a G5 running OSX 10.4 provide the same result.

I also tested Java on Win32 and Perl on a couple different Linuxes
(with different versions of glibc).  They also provide the same
result.

cheers,
barneyb

On 12/6/05, Damien McKenna <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: Barney Boisvert [mailto:[EMAIL PROTECTED]
> >
> > I'm telling you, it has nothing to do with software.  It's
> > the hardware.
>
> Anyone care to try it on a PC with an Athlon64 or a Mac?  I'm interested
> to see if different architectures make a difference.
>

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

Got Gmail? I have 100 invites.

~|
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:226327
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Paul Vernon]

> So you're saying that Deplhi produces a non-standard result? :P
> 

No, but interestingly, depending on which type I declare, I get different
results...

If I declare the types of the vars as Double, then I get a rounding error.
If I choose extended (much greater accuracy than the processor manages by
itself), I get 0. So, from this, it would appear that Delphi is defaulting
its types to something that bypasses the hardware and uses its own libraries
to calculate. If I use a type that maps to a hardware type then the error is
there... I agree that this is a hardware issue. 

Even if I multiply the result by a very large number, with Extended, Comp
and Currency I still get 0. With single, double, and real48 I get rounding
issues.

Delphi 7 types.

TypeMin Max
Precision   Size in bytes
Real48  2.9 x 10^-391.7 x 10^38 11-12
6
Single  1.5 x 10^-453.4 x 10^38 7-8
4
Double  5.0 x 10^-324   1.7 x 10^30815-16   8
Extended3.6 x 10^-4951  1.1 x 10^4932   19-20
10
Comp-2^63+1 2^63 -1 19-20
8
Currency-922337203685477.5808   922337203685477.580719-20
8

Paul


~|
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:226326
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Ryan Guill]

And even more information on the subject:

http://www.answers.com/topic/ieee-floating-point-standard

and

http://en.wikipedia.org/wiki/Floating_Point

Which says:

Errors in floating-point computation can include:

* Rounding
  o Non-representable numbers: for example, the literal 0.1
cannot be represented exactly by a binary floating-point number
  o Rounding of arithmetic operations: for example 2/3 might
yield 0.667
* Absorption: 1×1015 + 1 = 1×1015
* Cancellation: subtraction between nearly equivalent operands
* Overflow, which usually yields an infinity
* Underflow (often defined as an inexact tiny result outside the
range of the normal numbers for a format), which yields zero, a
subnormal number, or the smallest normal number
* Invalid operations (such as an attempt to calculate the square
root of a non-zero negative number). Invalid operations yield a result
of NaN (not a number).
* Rounding errors: unlike the fixed-point counterpart, the
application of dither in a floating point environment is nearly
impossible. See external references for more information about the
difficulty of applying dither and the rounding error problems in
floating point systems.



On 12/6/05, Ryan Guill <[EMAIL PROTECTED]> wrote:
> Let me offer two more papers on the subject:
>
> http://www.lahey.com/float.htm
>
> and
>
> http://docs.sun.com/source/806-3568/ncg_goldberg.html
>
> The second one being a much more technical document.  From the first document:
>
> At the heart of many strange results is one fundamental:
> floating-point on computers is usually base 2, whereas the external
> representation is base 10. We expect that 1/3 will not be exactly
> representable, but it seems intuitive that .01 would be. Not so! .01
> in IEEE single-precision format is exactly 10737418/1073741824 or
> approximately 0.00999776482582. You might not even notice this
> difference until you see a bit of code like the following:
>
> REAL X
> DATA X /.01/
> IF ( X * 100.d0 .NE. 1.0 ) THEN
>PRINT *, 'Many systems print this surprising result. '
> ELSE
>PRINT *, 'And some may print this.'
> ENDIF
>
> Base-10 floating-point implementations don't have this anomaly.
> However, base-10 floating-point implementations are rare because
> base-2 (binary) arithmetic is so much faster on digital computers.
>
> BTW, he is using FORTRAIN so there is another language to add to the list.
>
> On 12/6/05, Adrian Moreno <[EMAIL PROTECTED]> wrote:
> > >> Guess what that prints on Win2k in IE and FF?   Same exact error as
> > >> Java (including CFMX) and C do on Linux.
> > >
> > >Just to throw the cat amongst the pigeons, in Delphi, it calculates to 0 :)
> > >
> > >Paul
> >
> > So you're saying that Deplhi produces a non-standard result? :P
> >
> > -- Adrian
> >
> > 

~|
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:226325
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Ryan Guill]

Let me offer two more papers on the subject:

http://www.lahey.com/float.htm

and

http://docs.sun.com/source/806-3568/ncg_goldberg.html

The second one being a much more technical document.  From the first document:

At the heart of many strange results is one fundamental:
floating-point on computers is usually base 2, whereas the external
representation is base 10. We expect that 1/3 will not be exactly
representable, but it seems intuitive that .01 would be. Not so! .01
in IEEE single-precision format is exactly 10737418/1073741824 or
approximately 0.00999776482582. You might not even notice this
difference until you see a bit of code like the following:

REAL X
DATA X /.01/
IF ( X * 100.d0 .NE. 1.0 ) THEN
   PRINT *, 'Many systems print this surprising result. '
ELSE
   PRINT *, 'And some may print this.'
ENDIF

Base-10 floating-point implementations don't have this anomaly.
However, base-10 floating-point implementations are rare because
base-2 (binary) arithmetic is so much faster on digital computers.

BTW, he is using FORTRAIN so there is another language to add to the list.

On 12/6/05, Adrian Moreno <[EMAIL PROTECTED]> wrote:
> >> Guess what that prints on Win2k in IE and FF?   Same exact error as
> >> Java (including CFMX) and C do on Linux.
> >
> >Just to throw the cat amongst the pigeons, in Delphi, it calculates to 0 :)
> >
> >Paul
>
> So you're saying that Deplhi produces a non-standard result? :P
>
> -- Adrian
>
> 

~|
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:226324
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Adrian Moreno]

>> Guess what that prints on Win2k in IE and FF?   Same exact error as
>> Java (including CFMX) and C do on Linux.
>
>Just to throw the cat amongst the pigeons, in Delphi, it calculates to 0 :) 
>
>Paul

So you're saying that Deplhi produces a non-standard result? :P

-- Adrian

~|
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:226323
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Ian Skinner]

As for trim()... that should be done before the data goes into the database.


In my experience though, you should not rely on what 'should' happen at data 
entry.  Trim the output, spaces could actually come from the database, 
depending on what field types are used.  "char(10)" anybody?




--
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. 




~|
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:226322
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Barney Boisvert]

Do you know if Delphi has built-in integral floating point arithmetic
libraries?  And you displayed the result out to 15+ decimal places, I
assume.  Quite possibly has to be manually accomplished, since the
default precision is likely less than that, and any less will result
in implicit rounding to zero (as was the case with my C example).

cheers,
barneyb

On 12/6/05, Paul Vernon <[EMAIL PROTECTED]> wrote:
> > Guess what that prints on Win2k in IE and FF?   Same exact error as
> > Java (including CFMX) and C do on Linux.
>
> Just to throw the cat amongst the pigeons, in Delphi, it calculates to 0 :)
>
> Paul
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 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:226321
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Damien McKenna]

> -Original Message-
> From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
> 
> I'm telling you, it has nothing to do with software.  It's 
> the hardware.

Anyone care to try it on a PC with an Athlon64 or a Mac?  I'm interested
to see if different architectures make a difference.

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

~|
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:226320
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Paul Vernon]

> Can you explain my C and JS examples?

Ok, here is what I would think a reasonable explanation would be...

The JS interpreter is implemented in what language? Probably C or C++
although someone else will probably confirm this. I have no idea what
language the Windows and Linux JVM's are written in but I'd hazard a guess
that there will be some C/C++ legacy stuff in there... Delphi is written in
Delphi. This could well be a C/C++ math library error.

Paul

> -Original Message-
> From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
> Sent: 06 December 2005 21:01
> To: CF-Talk
> Subject: Re: Is this a bug in CFMX?
> 
> 
> FF's JS implementation may be Java-based (I've no idea), but 
> I'd be quite suprised if IE or glibc is Java based.
> 
> cheers,
> barneyb
> 
> On 12/6/05, Claude Schneegans <[EMAIL PROTECTED]> wrote:
> >  >>Maybe java's doing it wrong, but I'd be surprised.
> >
> > Ah ah, since CF is actually having Java to do it, I wouldn't be 
> > surprised at all.
> > And since Java is a virtual machine, the error is not due 
> to the CPU 
> > either ;-)
> >
> 
> --
> Barney Boisvert
> [EMAIL PROTECTED]
> 360.319.6145
> http://www.barneyb.com/
> 
> Got Gmail? I have 100 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:226319
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Tim Claremont]

As long as we are on a roll, apostrophes and dashes and all the other 
non-alphabetical characters should be removed as well if it is for a username, 
etc.

Whodda thunk that this easy little problem would generate so much response!

~|
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:226318
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Ian Skinner]

And this is the only language I know that will give this result. If there is a 
rounding error that occurs, I'd be very interested to know 
where, why and when any rounding occurs.

Interestingly I have experienced this in ColdFusion, Java, JavaScript and way 
back when, when I learned about floating point rounding, Basic (pre Visual 
Basic)


--
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:226317
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Paul Vernon]

> Guess what that prints on Win2k in IE and FF?   Same exact error as
> Java (including CFMX) and C do on Linux.

Just to throw the cat amongst the pigeons, in Delphi, it calculates to 0 :) 

Paul


~|
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:226316
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Bobby Hartsfield]

Yeah, the spaces are a good point in the middle of a name. because it looks
like its going to be used as a username or something. Probably want to
remove or replace those somewhere down the line. As for trim()... that
should be done before the data goes into the database.
 
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Tim Claremont [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 2:59 PM
To: CF-Talk
Subject: Re: Employee name

Good catch, Bobby. I think the trim is still a good idea, but would need to
be used in addition to a replace function to replace the spaces with ''.



~|
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:226315
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Barney Boisvert]

Can you explain my C and JS examples?

FF's JS implementation may be Java-based (I've no idea), but I'd be
quite suprised if IE or glibc is Java based.

cheers,
barneyb

On 12/6/05, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>  >>Maybe java's doing it wrong, but I'd be surprised.
>
> Ah ah, since CF is actually having Java to do it, I wouldn't be
> surprised at all.
> And since Java is a virtual machine, the error is not due to the CPU
> either ;-)
>

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

Got Gmail? I have 100 invites.

~|
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:226314
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Barney Boisvert]

> The only expalination is an error somewhere in the software translation
> fromm string to number and back to string.


document.write(15.12 + 59.70 - 74.82);


Guess what that prints on Win2k in IE and FF?   Same exact error as
Java (including CFMX) and C do on Linux.

I'm telling you, it has nothing to do with software.  It's the hardware.

cheers,
barneyb

On 12/6/05, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>  >>It's any computation that's performed by the
> floating point processor on your CPU.
>
> Right, and when the processor has to round a value, this will introduce
> an error, but never in this occurrence.
> The only expalination is an error somewhere in the software translation
> fromm string to number and back to string.
>

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

Got Gmail? I have 100 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:226313
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Tim Claremont]

Good catch, Bobby. I think the trim is still a good idea, but would need to be 
used in addition to a replace function to replace the spaces with ''.

~|
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:226312
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Claude Schneegans]

 >>Maybe java's doing it wrong, but I'd be surprised.

Ah ah, since CF is actually having Java to do it, I wouldn't be 
surprised at all.
And since Java is a virtual machine, the error is not due to the CPU 
either ;-)

-- 
___
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:226311
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Barney Boisvert]

Here's a small C program that illustrates the same thing.  I'm not a C
programmer, so I hacked the multiplication in there because I couldn't
figure out how to make printf display enough decimals.  This was
compiled on Linux (RedHat 8.0), and exhibits the identical error:

#include "stdio.h"
int main() {
  printf("%1.9f\n", (15.12 + 59.70 - 74.82) * 1);
}

Save to 'test.c', run 'gcc test.c', and then './a.out'.  So it's not Java.

cheers,
barneyb

On 12/6/05, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> public class Test {
> public static void main(String[] args) {
> System.out.println(15.12 + 59.70 - 74.82);
> }
> }
>
> Drop that in 'Test.java', run 'javac Test.java', and then 'java Test'
> (assuming you've got a Java SDK on your computer), and you'll see that
> it's certainly not CF doing something weird.  Maybe java's doing it
> wrong, but I'd be surprised.
>
> cheers,
> barneyb
>

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

Got Gmail? I have 100 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:226310
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Bobby Hartsfield]

Actually trim() only removes leading and trialing spaces
So "De Salvo" would stay "De Salvo"

But " De Salvo " would become "De Salvo"

..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Tim Claremont [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 2:29 PM
To: CF-Talk
Subject: Re: Employee name

By using the Trim method it will remove the spaces if a person has a space
in their last name like "De Salvo" or something like that.

>How about this...
>
>



~|
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:226309
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Claude Schneegans]

 >>It's any computation that's performed by the
floating point processor on your CPU.

Right, and when the processor has to round a value, this will introduce 
an error, but never in this occurrence.
The only expalination is an error somewhere in the software translation 
fromm string to number and back to string.

-- 
___
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:226308
Archives: http://www.houseoffusion.com/cf_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: HS+ config/preferences

[Ray Champagne]

Hey, that worked.  When I changed gif, jpg and png to "editable", I get 
the full list of images when trying to browse.

Thanks, mang!  I've been frustrated by that for months now.

Dawson, Michael wrote:
> My HS+ defaults to "Web Images".  I don't remember doing anything
> special to get those to appear.
> 
> I could see gifs, jpgs and pngs in the same window w/o selecting a new
> filter.
> 
> In Settings > File Settings > Extension Manager, do you have the correct
> types selected for both "Image" and "In Filter"?
> 
> M!ke
> 
> -Original Message-
> From: Ray Champagne [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, December 06, 2005 1:58 PM
> To: CF-Talk
> Subject: HS+ config/preferences 
> 
> When I right-click on an  tag in HomeSite+, then click "browse",
> why does the file dialog filter for "gif" only unless I change it to
> either "jpg" or "png" or "All files"?  Wouldn't a better default be to
> filter for "All" image files, then let me narrow it down from there?  Is
> there a way to change this behavior, or do I just have to live with the
> annoyance?
> 
> Ray
> --
> 
> 

~|
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:226307
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Claude Schneegans]

 >>And like he said, you shouldn't be using val() anyway. 

IMHO this is the main reason of the proble, and even so, it is still a 
CF problem, because
CF is a language that uses auto casting when uncompatible types are 
encounterd, but it is
not a reason it should do it uncorrectly.

 >>probably mean to be using is evaluate() .

evaluate is just like val(): it expects strings, not numeric values

If you write:






d = #d#


You still get d = 1.42108547152E-014
This is definitely a bug.
And this is the only language I know that will give this result.
If there is a rounding error that occurs, I'd be very interested to know 
where, why and when any rounding occurs.

-- 
___
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:226306
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Barney Boisvert]

public class Test {
public static void main(String[] args) {
System.out.println(15.12 + 59.70 - 74.82);
}
}

Drop that in 'Test.java', run 'javac Test.java', and then 'java Test'
(assuming you've got a Java SDK on your computer), and you'll see that
it's certainly not CF doing something weird.  Maybe java's doing it
wrong, but I'd be surprised.

cheers,
barneyb

On 12/6/05, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>  >>Unfortunately, that's not the case.
>
> I'm sorry, but it is the case here: floating points always represent
> exact values in computers.
> It is not always the value that was intended, WHEN there is an
> approximation made due to some rounding,
> but ONLY when.
> For instance, the result of 4.0/2.0 is represented exactly by a floating
> value, because all the decimals dropped due of the limited
> number of bits are zero anyway, so absolutely NO rounding error is made.
> On the other hand, something like 1.0/3.0 cannot be represented exactly
> by floating values, but 1.0 and 2.0 are.
>
> In our case here (15.12 + 59.70 - 74.82) there shouldn't be any roundig
> occuring, and if there is, it is only
> due to the manipulation CF is doing to calculate the result, not to the
> nature of floating arithmetics.
>


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

Got Gmail? I have 100 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:226305
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Tim Claremont]

By using the Trim method it will remove the spaces if a person has a space in 
their last name like "De Salvo" or something like that.

>How about 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:226304
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Tim Claremont]

By using the Trim method it will remove the spaces if a person has a space in 
their last name like "De Salvo" or something like that.

>How about 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:226303
Archives: http://www.houseoffusion.com/cf_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: Is this a bug in CFMX?

[Claude Schneegans]

 >>Unfortunately, that's not the case.

I'm sorry, but it is the case here: floating points always represent 
exact values in computers.
It is not always the value that was intended, WHEN there is an 
approximation made due to some rounding,
but ONLY when.
For instance, the result of 4.0/2.0 is represented exactly by a floating 
value, because all the decimals dropped due of the limited
number of bits are zero anyway, so absolutely NO rounding error is made.
On the other hand, something like 1.0/3.0 cannot be represented exactly 
by floating values, but 1.0 and 2.0 are.

In our case here (15.12 + 59.70 - 74.82) there shouldn't be any roundig 
occuring, and if there is, it is only
due to the manipulation CF is doing to calculate the result, not to the 
nature of floating arithmetics.

-- 
___
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:226302
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Tim Claremont]

How about this...






> How do I trim the letters of an employee's first name (employee_fname) 
> to the first letter and then add it to the letters of their last name 
> (employee_lname)?
> 
> For example, "John Smith" edited and then copied to a username field 
> as "JSMITH". I'm assuming its a RTRIM.
> 
> Here is the code I have to work with:
> 
> 
> select employee_fname, employee_lname
> from employees
> 
> Thanks.
> 
> Robert at HWW
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date: 
> 12/5/2005
 
> 

~|
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:226301
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Matthew Walker]

Do you want to do this inside the SQL query? What DBMS are you using? 


-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 7 December 2005 9:01 a.m.
To: CF-Talk
Subject: Employee name

How do I trim the letters of an employee's first name (employee_fname)
to the first letter and then add it to the letters of their last name
(employee_lname)?

For example, "John Smith" edited and then copied to a username field as
"JSMITH". I'm assuming its a RTRIM.

Here is the code I have to work with:

 select employee_fname,
employee_lname from employees

Thanks.

Robert at HWW

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date:
12/5/2005
 




~|
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:226300
Archives: http://www.houseoffusion.com/cf_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: HS+ config/preferences

[Dawson, Michael]

My HS+ defaults to "Web Images".  I don't remember doing anything
special to get those to appear.

I could see gifs, jpgs and pngs in the same window w/o selecting a new
filter.

In Settings > File Settings > Extension Manager, do you have the correct
types selected for both "Image" and "In Filter"?

M!ke

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 1:58 PM
To: CF-Talk
Subject: HS+ config/preferences 

When I right-click on an  tag in HomeSite+, then click "browse",
why does the file dialog filter for "gif" only unless I change it to
either "jpg" or "png" or "All files"?  Wouldn't a better default be to
filter for "All" image files, then let me narrow it down from there?  Is
there a way to change this behavior, or do I just have to live with the
annoyance?

Ray
--

~|
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:226299
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Chris Tilley]

with Oracle you could do:  select
concat(substr(employee_fname,1,1),employee_lname) from table

On 12/6/05, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
>
> In cf
>
> Left(firstname, 1) & lastname
>
> What database are you using?
>
> ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
> Bobby Hartsfield
> http://acoderslife.com
>
> -Original Message-
> From: Orlini, Robert [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 06, 2005 2:56 PM
> To: CF-Talk
> Subject: Employee name
>
> How do I trim the letters of an employee's first name (employee_fname) to
> the first letter and then add it to the letters of their last name
> (employee_lname)?
>
> For example, "John Smith" edited and then copied to a username field as
> "JSMITH". I'm assuming its a RTRIM.
>
> Here is the code I have to work with:
>
> 
> select employee_fname, employee_lname
> from employees
>
> Thanks.
>
> Robert at HWW
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date: 12/5/2005
>
>
>
>
>
> 

~|
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:226298
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Orlini, Robert]

SQL 

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 06, 2005 3:05 PM
To: CF-Talk
Subject: RE: Employee name


In cf

Left(firstname, 1) & lastname

What database are you using?
 
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 2:56 PM
To: CF-Talk
Subject: Employee name

How do I trim the letters of an employee's first name (employee_fname) to
the first letter and then add it to the letters of their last name
(employee_lname)?

For example, "John Smith" edited and then copied to a username field as
"JSMITH". I'm assuming its a RTRIM.

Here is the code I have to work with:


select employee_fname, employee_lname
from employees

Thanks.

Robert at HWW

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date: 12/5/2005
 






~|
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:226297
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Charlie Griefer]

you could do it in the SQL:

SELECT
 left(employee_fname, 1) + employee_lname AS empName
FROM
 employees

you would do it pretty much the same way in CF.




On 12/6/05, Orlini, Robert <[EMAIL PROTECTED]> wrote:
> How do I trim the letters of an employee's first name (employee_fname) to the 
> first letter and then add it to the letters of their last name 
> (employee_lname)?
>
> For example, "John Smith" edited and then copied to a username field as 
> "JSMITH". I'm assuming its a RTRIM.
>
> Here is the code I have to work with:
>
> 
> select employee_fname, employee_lname
> from employees
>
> Thanks.
>
> Robert at HWW
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date: 12/5/2005
>
>
>
> 

~|
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:226296
Archives: http://www.houseoffusion.com/cf_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: Could not unlock the named lock

[Kenton Gray]

This is a quite late reply, but as of today I can say I've seen this  
error message.

I was about to ask and see if you figured it out, but I just thought  
of a very reasonable explanation, mine occurred for a few clients at  
around the same time that I changed my cfapplication name. I believe  
that coldfusion stores client variables with the appname prepended to  
them, so that would make it have that error the first time it tries  
to access them.

Does that match up with your scenario at all?

Kenton


On Oct 19, 2005, at 1:40 PM, Ryan Duckworth wrote:

> Has anyone seen an error similar to this before?
>
> Could not unlock the named lock 623068599CLIENTSCOPESERVICE because no
> lock is known by that name.
>
> CF7, Win 2003 Server
>
> Thanks,
>
> Ryan Duckworth
> Macromedia ColdFusion Certified Professional
>
> Uhlig Communications
> 10983 Granada Lane
> Overland Park, KS 66211
> (913) 754-4272
>
> 

~|
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:226293
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Charlie Hanlon]

Robertthis should work, though there may be a more optimal way of 
writing the select clause


 select left(employee_fname,1)+employee_lname AS name
 from employees


hth
Charlie Hanlon


- Original Message - 
From: "Orlini, Robert" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, December 06, 2005 2:55 PM
Subject: Employee name


> How do I trim the letters of an employee's first name (employee_fname) to 
> the first letter and then add it to the letters of their last name 
> (employee_lname)?
>
> For example, "John Smith" edited and then copied to a username field as 
> "JSMITH". I'm assuming its a RTRIM.
>
> Here is the code I have to work with:
>
> 
> select employee_fname, employee_lname
> from employees
>
> Thanks.
>
> Robert at HWW
>
> -- 
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date: 12/5/2005
>
>
>
> 

~|
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:226295
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Bobby Hartsfield]

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=88&rl=1
 
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 2:56 PM
To: CF-Talk
Subject: Employee name

How do I trim the letters of an employee's first name (employee_fname) to
the first letter and then add it to the letters of their last name
(employee_lname)?

For example, "John Smith" edited and then copied to a username field as
"JSMITH". I'm assuming its a RTRIM.

Here is the code I have to work with:


select employee_fname, employee_lname
from employees

Thanks.

Robert at HWW

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date: 12/5/2005
 




~|
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:226291
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Dawson, Michael]

SELECT LEFT(employee_fname, 1) || employee_lname AS newName...

Check your concatenation character(s).

It could be double-pipes (||) or the plus (+).

M!ke

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 1:56 PM
To: CF-Talk
Subject: Employee name

How do I trim the letters of an employee's first name (employee_fname)
to the first letter and then add it to the letters of their last name
(employee_lname)?

For example, "John Smith" edited and then copied to a username field as
"JSMITH". I'm assuming its a RTRIM.

Here is the code I have to work with:

 select employee_fname,
employee_lname from employees

Thanks.

Robert at HWW

~|
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:226294
Archives: http://www.houseoffusion.com/cf_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: For emergency only

[Dawson, Michael]

I got you confused with Ben Forta, I guess.  I'm pretty sure he uses the
650.

;-)

M!ke 

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 2:02 PM
To: CF-Talk
Subject: Re: For emergency only

I hated the Treo. It didn't do what I wanted at all.

~|
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:226292
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Ben Forta]

SELECT Left(employee_fname, 1) + employee_lname AS username
FROM employees


-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 2:56 PM
To: CF-Talk
Subject: Employee name

How do I trim the letters of an employee's first name (employee_fname) to
the first letter and then add it to the letters of their last name
(employee_lname)?

For example, "John Smith" edited and then copied to a username field as
"JSMITH". I'm assuming its a RTRIM.

Here is the code I have to work with:

 select employee_fname,
employee_lname from employees

Thanks.

Robert at HWW

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date: 12/5/2005
 




~|
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:226290
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Ray Champagne]

First thought:

#Left(employee_fname,1)##employee_lname#



Orlini, Robert wrote:
> How do I trim the letters of an employee's first name (employee_fname) to the 
> first letter and then add it to the letters of their last name 
> (employee_lname)?
> 
> For example, "John Smith" edited and then copied to a username field as 
> "JSMITH". I'm assuming its a RTRIM.
> 
> Here is the code I have to work with:
> 
> 
> select employee_fname, employee_lname
> from employees
> 
> Thanks.
> 
> Robert at HWW
> 

-- 
=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=


~|
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:226289
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Katz, Dov B \(IT\)]

#Left(employee_fname,1)##employee_lname# in CF or if you want to do In
sql try 

Select left(employee_fname,1) + employee_lname from employees



-Dov

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 2:56 PM
To: CF-Talk
Subject: Employee name

How do I trim the letters of an employee's first name (employee_fname)
to the first letter and then add it to the letters of their last name
(employee_lname)?

For example, "John Smith" edited and then copied to a username field as
"JSMITH". I'm assuming its a RTRIM.

Here is the code I have to work with:

 select employee_fname,
employee_lname from employees

Thanks.

Robert at HWW

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date:
12/5/2005
 




~|
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:226288
Archives: http://www.houseoffusion.com/cf_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: Employee name

[Bobby Hartsfield]

In cf

Left(firstname, 1) & lastname

What database are you using?
 
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 06, 2005 2:56 PM
To: CF-Talk
Subject: Employee name

How do I trim the letters of an employee's first name (employee_fname) to
the first letter and then add it to the letters of their last name
(employee_lname)?

For example, "John Smith" edited and then copied to a username field as
"JSMITH". I'm assuming its a RTRIM.

Here is the code I have to work with:


select employee_fname, employee_lname
from employees

Thanks.

Robert at HWW

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date: 12/5/2005
 




~|
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:226287
Archives: http://www.houseoffusion.com/cf_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