RE: Date Formats

[Matthew Walker]

> Seems really odd, have tried #createodbc(form.date_entered)# but get the same 
> error occuring.

Probably what's happening here is that CF (instead of the db) is assuming US 
format so causing the same problem. Unless you use LS functions, CF always 
assumes US format, which means most users of CF are blissfully unaware of these 
problems.

I know many of my early apps only worked properly from the 13th of every month 
onward. Apparently I did my bug checking at the end of the month. ;-) 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230384
Archives: http://www.houseoffusion.com/cf_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: Date Formats

[Matthew Walker]

Dates are not stored in a database in American of European format. They are 
stored in the database's unambiguous format. If you pass in a US or Euro date 
then your DBMS is converting it before storing. You should take charge of this 
conversion. Try using something like this...



I am assuming you've set your locale with setLocale(). When you display a date 
from a database you must always use lsDateFormat().


-Original Message-
From: Mark Flewellen [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 25 January 2006 10:46 a.m.
To: CF-Talk
Subject: Date Formats

I am having trouble with Date Formats on a Windows Server, running CFMX7 and 
mysql,

I am wanting to have dates appear in a European Format ie. dd/mm/ and once 
posted from a form for them to be saved in the MySQL Database in an American 
Format (which it does by default).

However I am finding that if I post a date such as 10/12/2005 (ie. 10 December 
2005), this will save in the database as 2005-10-12 (ie. 12 October 2005),

but

if I save a date such as 18/12/2005 (ie. 18 December 2005), this saves in the 
database in the correct format ie. 2005-12-18

It seems whenever the day value is below 13 it seems to swap the day and the 
month around.

Anyone got any ideas?

Mark




___
NEW Yahoo! Cars - sell your car and browse thousands of new and used cars 
online! http://uk.cars.yahoo.com/




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230377
Archives: http://www.houseoffusion.com/cf_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: FCK Editor 2.2

[Matthew Walker]

You may find windiff useful -- it can show you which files have changed
and what has changed. Compare your modified 2.0 with the original 2.0
then apply the same changes to the original 2.2 . There is another tool
around that lets you create a patch automatically but it's probably just
as easy by hand.

The most obvious change in 2.2 for me was that autodetection of pasting
from Word now works. 

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 19 January 2006 9:30 a.m.
To: CF-Talk
Subject: FCK Editor 2.2

Hi,

Has some one tried FCK 2.2.

I made a modification in version 2.0 so that it does not use an /image/
subdirectory for uploaded images.

Now of course it all has to be done abain for version 2.2, and it is
even more complicated.
I can't understand why, depite of all complaints from users, the
developers keep on imposing THEIR idea about how files should be stored
in the server.
Is this tool supposed to be integrated into an existing application, or
the reverse?

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




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229928
Archives: http://www.houseoffusion.com/cf_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: Professional Opinions on HostMySite.com

[Matthew Walker]

BTW they have a good range of custom tags installed too.
http://www.hostmysite.com/support/cfusion/cftags/

-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 11 January 2006 7:31 a.m.
To: CF-Talk
Subject: Professional Opinions on HostMySite.com

All, 

 

The company that I work for is considering HostMySite.com to host our
web and email presence. (I use them to host my personal site
http://www.sstwebworks.com   )

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229091
Archives: http://www.houseoffusion.com/cf_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: Professional Opinions on HostMySite.com

[Matthew Walker]

I've got a couple of small sites (~1000 sessions/day) on their CF
Builder+ plan (which they recently more-or-less doubled the specs of at
no cost). Been very happy with them. Had one or two problems with their
control panel admin interface but when I submit a support ticket
everything gets dealt with very quickly. 

They keep wishing me in a good evening when it's the middle of the day
but that's because they're in some wacky time zone (i.e. the US). 

-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 11 January 2006 7:31 a.m.
To: CF-Talk
Subject: Professional Opinions on HostMySite.com

All, 

 

The company that I work for is considering HostMySite.com to host our
web and email presence. (I use them to host my personal site
http://www.sstwebworks.com   )

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229090
Archives: http://www.houseoffusion.com/cf_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: Preventing auto-fill

[Matthew Walker]

 

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 10 January 2006 1:31 p.m.
To: CF-Talk
Subject: RE: Preventing auto-fill

I know some code in IE will stop this from happening. Not sure what it
is though. Also, if the page is accessed via HTTPS, the auto complete
doesn't happen, again on IE.

Not sure about other browsers.

Ade

-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]
Sent: 10 January 2006 00:14
To: CF-Talk
Subject: Preventing auto-fill


Guys,

Is there a way to prevent a browser's autocomplete/autofill feature from
  caching info on certain forms? For example, I don't want a credit card
form field to be cached via autocomplete. The same with login prompts.

Anyone tackled this before?

Rey...




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228983
Archives: http://www.houseoffusion.com/cf_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: Robots.txt - - best practices

[Matthew Walker]

Yeah that's what we do -- create a façade CFC just for Flash that calls the 
regular CFC. CFCs aren't really about saving effort are they? ;-)

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 10 January 2006 11:16 a.m.
To: CF-Talk
Subject: RE: Robots.txt - - best practices

The problem I am having now is that the CFC's I use with flash remoting have to 
be web accessible, which screws up the standard I use for keeping my CFC's 
outside the WWW root.  Anybody have any ides.  I thought about a wrapper CFC 
that just called the real CFC, but if I am going to go through that trouble why 
not just stick the CFC's in a web accessible place to begin with?

~Brad

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, January 09, 2006 3:58 PM
To: CF-Talk
Subject: RE: Robots.txt - - best practices

> Would that same rule of thumb apply for logic code? Say if I separate 
> out all of my queries, cfc's etc... from the presentation layer should 
> I keep those logic based templates out of the root as well?

Yes, to the extent that this is practical. For example, I typically place CFCs, 
custom tags, UDF libraries, etc outside of the web root, and create mappings as 
necessary.

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

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






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228933
Archives: http://www.houseoffusion.com/cf_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: Problem with Alagad Image Component

[Matthew Walker]

It's an error in the CFC.

Search for this line:



Replace with:




-Original Message-
From: Michael Clayton [mailto:[EMAIL PROTECTED] 
Sent: Monday, 9 January 2006 10:16 a.m.
To: CF-Talk
Subject: Problem with Alagad Image Component

I've been testing out Alagad Image Component and it's been great.
However, I'm having one peculiar problem.

Here is my setup:
http://www.twilighted.com/clayto/design/alagad/pixelcolor.cfm

As you can see, when you click on the image, it returns the coordinates
of the click in the URL, and Alagad turns those coordinates into RGB,
and a handy script turns RGB into Hex.

However, if you click too far to the right on the image, it returns this
strange error:  "Invalid y attribute.  The y attribute must be greater
than or equal to 0 and less than the image height."

Both of those conditions are met, but the error still crashes my party.
Any ideas?  I've been working on this for hours and can't make any
headway.






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228780
Archives: http://www.houseoffusion.com/cf_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: 3D bar chart question

[Matthew Walker]

You need the cfchart attribute: seriesplacement="default"  

Hilariously, in CF7 "default" is not the default!!

-Original Message-
From: Doug Hughes [mailto:[EMAIL PROTECTED] 
Sent: Friday, 6 January 2006 3:46 a.m.
To: CF-Talk
Subject: 3D bar chart question

Hello -

Quick question:  I've been trying to get cfchart to show a 3d bar chart
where each chart series is shown behind the previous chart.

I Googled around for a bit and stumped across this webtrends report that
shows an example of what I'm taking about:
http://www.i-panic.com/sample_report.html

Note that the User Profile by Regions has multiple rows of data?  That's
what I need to do.

I swear I've seen examples of CF doing this, though I've never done it
myself.

Any ideas?
--
Doug Hughes
(Check out my Image Manipulation CFC at http://www.alagad.com)




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228560
Archives: http://www.houseoffusion.com/cf_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: Accounting for Unknown Number of Loops

[Matthew Walker]

I think you need to change
#getSubCategories(CatID)# to 

And you also need to set temp as a local var in your function by placing
 neat the top. You should always do that when
working with vars inside functions, and particularly in this case.

-Original Message-
From: Samantha Brinkley [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 28 December 2005 11:46 a.m.
To: CF-Talk
Subject: Re: Accounting for Unknown Number of Loops

Thank you.  That was exactly it.  Well, at least to solve that problem.
I've renamed the query and now I'm not getting that error.  Now, I'm
getting too many entries on the display page.  My "temp" variable
clearly is adding on to itself when I don't want it to, but I've tried
some things and they're not working.  Instead of getting:

~|
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:227731
Archives: http://www.houseoffusion.com/cf_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: Accounting for Unknown Number of Loops

[Matthew Walker]

The problem is most likely that your function and query have the same
name. Try renaming your query, and I would strongly advise managing the
scope of your query by adding this line immediately after the cfargument
line:

Where myQuery is the new name you choose for the query record set.

> But the code is erroring out where getSubCategories is getting called
within itself.  
> I'm getting "The symbol you have provided getSubCategories is not the
name of a function" error.

~|
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:227717
Archives: http://www.houseoffusion.com/cf_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: Appending a variable to another variable

[Matthew Walker]

All variables are part of a variable scope. When you write 
 
you are actually writing shorthand for 

or 


That's all very well, but the shorthand breaks down if you want to use
dynamic variable names (and the dotted notation breaks down too). What
you are seeing here is a situation where you need to revert to full
variable names. Sure you can use the two workarounds Jacob has
described, or you can write...

You can create a dynamic variable name like so:

And then access it using
#variables["db_name#i#"]#

You can see this notation above is the same as you would do for session
variables. 

-Original Message-
From: Mark Henderson [mailto:[EMAIL PROTECTED] 
Sent: Friday, 23 December 2005 1:01 p.m.
To: CF-Talk
Subject: RE: Appending a variable to another variable


You can create a dynamic variable name like so:

And then access it using evaluate():
#evaluate("db_name#i#")#


Thanks Jacob, that works. I do still wonder why it's not necessary with
session variables.

~|
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:227575
Archives: http://www.houseoffusion.com/cf_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: Which page called my custom tag

[Matthew Walker]

I think this will give you the info you want -- put it inside your tag.
If necessary, get it to mail you the dump only if the unexpected value
occurs.








-Original Message-
From: jonese [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 21 December 2005 5:45 a.m.
To: CF-Talk
Subject: Re: Which page called my custom tag

Ok that helps a little bit. I'm getting out put like so
"CFQUERY,CF_FORMPROCESS,CFINCLUDE,CFINCLUDE,CF_FORMPROCESS,CF_CHROMESHEL
L "

Is there anyway to find out what those cfinclude files are?

Here's my delimma.

We have a custom tag which processes form for us and does a lot of high
level stuff. the problem i'm having is that a passed in variable (
attributes.formobjectid) is changing from one value '102' to an
unexpected value '10002' when the tag is called again upon it's self.

I need to figure out where the tag is getting called again so i can try
to find where this mystery 10002 is getting set...

jonese

~|
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:227375
Archives: http://www.houseoffusion.com/cf_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: Performance Problem - Client Variables

[Matthew Walker]

Ahem... 












DELETE
FROMclientVariables
WHERE   created < 










SELECT  val
FROMclientVariables
WHERE   clientId = 
AND name = 











INSERT INTO clientVariables
(

clientId,

name,

val,

created
)
VALUES  (

,

,

,


)
  









DELETE
FROMclientVariables
WHERE   clientId = 
AND name IN
()






 



-Original Message-
From: Matthew Walker 
Sent: Friday, 16 December 2005 10:07 a.m.
To: 'cf-talk@houseoffusion.com'
Subject: RE: Performance Problem - Client Variables

People seem to have no end of problems with client variables. One
problem is they are a database hit on every request whether you use them
or not. Another is that bots fill up your database and then weird things
start happening (see my thread yesterday "RSS looks ok but not ok"). We
found that cookie client vars were overflowing on one site so switched
to db vars. The performance impact was surprisingly large given it was
only one db hit. 

In the end, I wrote a CFC (which is initialised into a session var) that
we use as a client var store instead. It simply reads and writes data to
and from a database table, but it only does it as needed. Seems to work
well.

CFC pasted below if anybody's interested.

~|
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:227116
Archives: http://www.houseoffusion.com/cf_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: Performance Problem - Client Variables

[Matthew Walker]

People seem to have no end of problems with client variables. One
problem is they are a database hit on every request whether you use them
or not. Another is that bots fill up your database and then weird things
start happening (see my thread yesterday "RSS looks ok but not ok"). We
found that cookie client vars were overflowing on one site so switched
to db vars. The performance impact was surprisingly large given it was
only one db hit. 

In the end, I wrote a CFC (which is initialised into a session var) that
we use as a client var store instead. It simply reads and writes data to
and from a database table, but it only does it as needed. Seems to work
well.

CFC pasted below if anybody's interested.


-Original Message-
From: Cornillon, Matthieu (Consultant)
[mailto:[EMAIL PROTECTED] 
Sent: Friday, 16 December 2005 9:46 a.m.
To: CF-Talk
Subject: Performance Problem - Client Variables

All,

I am in the process of moving a CF site from one server to another.  The
new site is in CFMX7.  I do not have access to the administrator
settings, as I have to work through someone in another department on
this.  The problem is that I have ~8.5 seconds (+/- 0.2 seconds) delay
on each page load.  Not the slow load of dial-up, with pictures slowly
appearing, but the delay and then a full instant load.  This is true
regardless of page content.

I eventually ran a test where I took two identical pages, both blank
HTML pages with no CF code and put them in an isolated directory where
the Application.cfm had only the CFAPPLICATION tag.  One page had the
...html extension, the other the .cfm extension.  The former loaded
instantly, the latter only after the delay.

In another test, I tried setting clientmanagement to no, and the problem
went away.  So I am looking further there.  Because I have no direct
access to the Administrator page, I have to do my investigation
remotely.  I know that I am *supposed* to be storing the client
variables in an Oracle datasource.  This is how we currently do it, and
it works fine.  So, I am guessing that this is just a matter of a
configuration problem there.

While I am trying those things out, I am wondering whether any of you
have any thoughts on the following questions:

1) In the CF Administrator, it seems that you set the client variable
store for the *server* and not for the specific CF application.  Is that
correct?  In other words, if I have two applications, named
application_one and application_two in their Application.cfm
CFAPPLICATION tags, but those applications sit on the same server, do
all their client vars get put into the same datastore?  If not, how (in
the administrator module) does one set per-application settings?

2) Is there a way that I can programmatically display client variable
settings for the application?  In other words, is there some variable
like Application.ClientStorage that I can read and display?  (I ask
because of the above-mentioned fact that I cannot access the
administrative module directly.)

3) Does anyone have any experience with this sort of delay of constant
length?

Thanks a million,
Matthieu



~|
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:227115
Archives: http://www.houseoffusion.com/cf_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: RSS looks ok but not ok

[Matthew Walker]

This problem was caused by client variable storage failure due to a full
database. I wasn't seeing the problem in my browser as it was
recognised, so overwriting exiting client records. However when I used a
service such as an RSS reader or validator or anonymizer.com, new client
variables were being written (and failing), hence the cryptic error at
the bottom of RSS feeds.

My solution has been to stop using client variables (that's what filled
up the database with 36 rows of mostly trash). 

> Any ideas why the feed validator would be seeing something different 
> from what I see (and rejecting the feed)?
>
> Here's the feed:
> http://www.tramper.co.nz/tracks/index.cfm?&view=browse&layout=rss
>
> Here's what the validator sees at the end:
>
> 
> 
>  JRun Servlet Error500 Operation

> failed on the data source named "tramperconz". Operation 
> failed on the data source named "tramperconz".
>
> I don't even understand that error -- there's nothing wrong with the 
> datasource or the feed wouldn't display. Any hints?
>

~|
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:227079
Archives: http://www.houseoffusion.com/cf_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: backslash-digit interpreted in strings

[Matthew Walker]

That's a back reference. It refers to the fifth parenthesised section in
your regex. Of course you probably don't have a fifth parenthesised
section, so it's replaced with an empty string. You should be able to
just replace all "\" in your replacement string with "\\" first to fix
this.  

-Original Message-
From: Jonathan Gingerich [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 15 December 2005 3:01 p.m.
To: CF-Talk
Subject: backslash-digit interpreted in strings

I'm using REReplace and the replacement string contains a "\5".
The string came from a FORM, it was never a literal on a page.
Nonetheless, ColdFusion appears to process it out and it disappears.

Can anyone explain that this is not a straight out bug?



~|
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:227071
Archives: http://www.houseoffusion.com/cf_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: RSS looks ok but not ok

[Matthew Walker]

Interestingly, getting the same thing with anonymizer:
http://anon.free.anonymizer.com/http://www.tramper.co.nz/tracks/index.cf
m?&view=browse&layout=rss 

And getting it on regular HTML pages too. I'll have to follow up the
client variables connection (have to do it later though as I'm at work
and that isn't work ;-) ). Will post the results of what I find. 



-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 15 December 2005 10:46 a.m.
To: CF-Talk
Subject: Re: RSS looks ok but not ok

I see the JRun error at the end, so it's not just the validator. 
Perhaps you're hitting it on a different vhost (because you're not
outside your network) or something?

cheers,
barneyb

On 12/14/05, Matthew Walker <[EMAIL PROTECTED]> wrote:
> Any ideas why the feed validator would be seeing something different 
> from what I see (and rejecting the feed)?
>
> Here's the feed:
> http://www.tramper.co.nz/tracks/index.cfm?&view=browse&layout=rss
>
> Here's what the validator sees at the end:
>
> 
> 
>  JRun Servlet Error500 Operation

> failed on the data source named "tramperconz". Operation 
> failed on the data source named "tramperconz".
>
> I don't even understand that error -- there's nothing wrong with the 
> datasource or the feed wouldn't display. Any hints?
>
--
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:227054
Archives: http://www.houseoffusion.com/cf_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: RSS looks ok but not ok

[Matthew Walker]

Interesting point -- I'm storing them in that datasource. I'll
experiment with that, thanks! Still not clear what's actually happening
though. 

-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 15 December 2005 10:31 a.m.
To: CF-Talk
Subject: RE: RSS looks ok but not ok

This looks a bit like a session or client variable storage

How are youi storing client/session variables?
dov

-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 14, 2005 4:19 PM
To: CF-Talk
Subject: RSS looks ok but not ok

Any ideas why the feed validator would be seeing something different
from what I see (and rejecting the feed)? 
 
Here's the feed:
http://www.tramper.co.nz/tracks/index.cfm?&view=browse&layout=rss
 
Here's what the validator sees at the end:
 


 JRun Servlet Error500 Operation
failed on the data source named "tramperconz". Operation
failed on the data source named "tramperconz". 
 
I don't even understand that error -- there's nothing wrong with the
datasource or the feed wouldn't display. Any hints?






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

RSS looks ok but not ok

[Matthew Walker]

Any ideas why the feed validator would be seeing something different
from what I see (and rejecting the feed)? 
 
Here's the feed:
http://www.tramper.co.nz/tracks/index.cfm?&view=browse&layout=rss
 
Here's what the validator sees at the end:
 
 
 
 JRun Servlet Error500 Operation
failed on the data source named "tramperconz". 
Operation failed on the data source named "tramperconz". 
 
I don't even understand that error -- there's nothing wrong with the
datasource or the feed wouldn't display. Any hints?


~|
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:227041
Archives: http://www.houseoffusion.com/cf_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: What am I missin' here with this cfparam??

[Matthew Walker]

It could be that when you remove the cfparam, the cfinvoke is failing
but the cfcatch is catching it so you don't notice an error occurring.  

-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 13 December 2005 4:46 p.m.
To: CF-Talk
Subject: What am I missin' here with this cfparam??

Ok, this is a little odd, and I don't know what I'm not understanding
why it's doing what it's doing. 

I have a search form. It actions to the search results page. I'm also
adding the search criteria into tblSearches to keep track of what people
are looking for. 

I cfparam'ed FORM.criteria on the action page just to make sure it's
always there. But I noticed it entered twice into the db per one search.
If I comment out the cfparam, it inserts correctly. Why wouldn't the
submitted FORM.criteria override the cfparam FORM.criteria? It's acting
like it has TWO FORM.criterias. h

   All the search query
stuff is right here.
  
 
   

Thanks,
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:226899
Archives: http://www.houseoffusion.com/cf_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: local date time minus 17 hours

[Matthew Walker]

Whoops!

I have the same problem (hosting in the US) and I use Paul Hastings'
timezone CFC (http://www.sustainablegis.com/projects/tz/testTZCFC.cfm)
in application.cfc, then just refer to request.now instead of now()





-Original Message-
From: Matthew Walker 
Sent: Monday, 12 December 2005 12:01 p.m.
To: 'cf-talk@houseoffusion.com'
Subject: RE: local date time minus 17 hours

I have the same problem (hosting in the US) and I use Paul Hastings'
 

-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]
Sent: Sunday, 11 December 2005 4:16 p.m.
To: CF-Talk
Subject: local date time minus 17 hours

How do I get my local date and time when my ISP's local time is
17 hours behind me.

Many thanks

Seamus


Seamus Campbell   Boldacious WebDesign
http://www.boldacious.com      [EMAIL PROTECTED]
ph 02 6297 4883  mob 0410 609 267





~|
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:226753
Archives: http://www.houseoffusion.com/cf_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: local date time minus 17 hours

[Matthew Walker]

I have the same problem (hosting in the US) and I use Paul Hastings'
 

-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED] 
Sent: Sunday, 11 December 2005 4:16 p.m.
To: CF-Talk
Subject: local date time minus 17 hours

How do I get my local date and time when my ISP's local time is
17 hours behind me.

Many thanks

Seamus


Seamus Campbell   Boldacious WebDesign
http://www.boldacious.com      [EMAIL PROTECTED]
ph 02 6297 4883  mob 0410 609 267





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

[Matthew Walker]

Try  
That will give you the db-independence.

-Original Message-
From: ColdFusion [mailto:[EMAIL PROTECTED] 
Sent: Friday, 9 December 2005 3:31 p.m.
To: CF-Talk
Subject: SQL Dates

I am trying to get all records from a table where the dates are in
between two dates.

Sounds simple if I was comparing a [column] between Date1 and Date2 but
this is slightly reversed

I need to get the records where the START_DATE and END DATE are compared
to today.

Such as:

SELECT 

PA_START_DATE,

PA_END_DATE

FROM

PA_TIMES

WHERE

#DATEFORMAT(NOW(),'MM/DD/')# BETWEEN PA_START_DATE AND PA_END_DATE

Now this should be simple and for the life of me it is escaping me how
to do this.

By the way, this needs to be database IN-dependent. This should be able
to run on a MS Access, MS SQL, or a MySQL database.

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

[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: cfabort

[Matthew Walker]

But why would you? Cfreturn ends the processing. I would generally only
ever use a cfabort when debugging or in case of some fatal error.  

-Original Message-
From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 6 December 2005 3:01 p.m.
To: CF-Talk
Subject: cfabort

Hi guys,

Just a quick question, is it good practice to use a cfabort in a .cfc
file?

Basically...









 

mike

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226139
Archives: http://www.houseoffusion.com/cf_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: Using request var in CFC - was : FREE Homesite/CF Studio CFC VTML Generator

[Matthew Walker]

Just pass it in as an argument. 

 

Ensure your init() method returns "this" to use the syntax above.
Alternatively, make a small struct of useful settings and pass that in. 


-Original Message-
From: Stan Winchester [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 29 November 2005 2:16 p.m.
To: CF-Talk
Subject: Using request var in CFC - was : FREE Homesite/CF Studio CFC
VTML Generator

What is best practise for passing dsn variable to cfc? In the CFMX (v
6.x) Bible shows using request variables to pass dsn, but Douglas says
that is Blasphemy!  Heresy!, well he was just kidding, but seriously
what is best practise? Should it be passed as an argument?

> >
> > Why should I pass the DSN to the CFC and use the request scope? I
> based this wizard off chapters in the CFMX Bible.
> 
> CFMX Bible, you say?  Blasphemy!  Heresy!  ha!  J/K  It is excepted 
> practise to never use vars outside the CFC.
> 



~|
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:225478
Archives: http://www.houseoffusion.com/cf_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: pseudo-memory leak

[Matthew Walker]

> why can't a smart user has a userID 123457 using CF and set the
cookie?  

Because you'd hash the password and store that too. 

~|
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:225474
Archives: http://www.houseoffusion.com/cf_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: pseudo-memory leak

[Matthew Walker]

In that case, wouldn't you want to store the password in the cookie too?
Perhaps hashed? 

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 29 November 2005 12:46 p.m.
To: CF-Talk
Subject: RE: pseudo-memory leak

Cookies are not very secure now, are they?  Lets say I was going to let
the user be logged in, and I wanted that to persist... So I would do.. 
 
Client.userId=123456

Now, the user has no way to change that... Now, lets say I store it in
the cookie... 



Now, the user can examine their cookies and know their userid.  Worse,
they can change the userid, and be logged in as a different user.  

Russ 

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

RE: Query of Queries (QoQ) performance question

[Matthew Walker]

If your initial "Query" query was very complicated then using QoQ to
extract subsets would probably perform better.

 

-Original Message-
From: Billy Jamme [mailto:[EMAIL PROTECTED] 
Sent: Friday, 25 November 2005 4:16 p.m.
To: CF-Talk
Subject: Query of Queries (QoQ) performance question

Hi all,

I'm wondering if someone can explain to me how to properly utilize Query
of Queries (QoQ) to gain the maximum amount of performance.

Here's a code example.. 


Select ID, name
From TempTable




Select ID, Name
From Query
Where id = #i#




QoQ result -#final#



Select ID, Name
From TempTable
Where id = #i#




Regular - #final#

When I run this I'm getting QoQ times 200-250% greater than the Regular
query.  I ran this on two machines, with similar results.  

Both machines were running CFMX 6.1 & MS-SQL 2000.  

I was under the impression that QoQ's were supposed to have better
performance than regular queries.  I am doing something wrong?

--j



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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225216
Archives: http://www.houseoffusion.com/cf_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: punctuation in a URL variable

[Matthew Walker]

Perhaps urlEncodedFormat() would be more appropriate. 

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 23 November 2005 5:00 p.m.
To: CF-Talk
Subject: RE: punctuation in a URL variable

Have you tried #htmlencodedformat(name)#
 
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 22, 2005 10:39 PM
To: CF-Talk
Subject: punctuation in a URL variable

Anybody know how to pass a plus sign + in a url variable, like

#Name#

When #name# is equal to _X16110_IGHG3_03_CH3+c.out

The result is: _X16110_IGHG3_03_CH3 c.out

Notice the + is replaced with a space, screwing everything up.

TNX if you can advise.

Rick.







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

RE: CSS table-type layout

[Matthew Walker]

> So, for such tabular-style data, how would one approach a css version
of a table with lots of rows and columns?

Why would you not use a table for tabular data? Tables are "misused"
when used for layout of non-tabular data: they are not inherently
verboten.

However, if you are referring to a lot of little thumbnails, you may
like to wrap each one in a div with a fixed height and width and
style="float: left". This lets your thumbs tile across the space tidily
and wrap when they fill the space. 


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

[Matthew Walker]

It rather depends. Do you want to clear all the fields in the form (in
which case Bobby's suggestion) or only these particular fields? If a
user has checked the box then edited one of the values then unchecked
the box, what should happen? Should the box be cleared?

I would suggest instead of having a checkbox have a button. Then it
returns to its original state so you don't have to think about what
happens if it is "unpressed". 

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 22 November 2005 10:01 a.m.
To: CF-Talk
Subject: RE: JavaScript Autofill

One more thing Matthew. 

What do I add to this code so that when I uncheck the box the values
disappear as well??


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

[Matthew Walker]

You have two fields with the id "lname". Generally, you should only use
an id once per page.  That JavaScript hurts my eyes so I haven't
bothered trying to understand it. Are you trying to copy a set of values
from a set of hidden fields to a set of visible fields? Something like
this is low tech but very easy to understand


function copyData() {
document.getElementById('field1').value =
document.getElementById('default1').value;
document.getElementById('field2').value =
document.getElementById('default2').value;
document.getElementById('field3').value =
document.getElementById('default3').value;
}










Field 1: 
Field 2: 
Field 3: 



-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 22 November 2005 9:01 a.m.
To: CF-Talk
Subject: OT: JavaScript Autofill

I have a JavaScript that I hoped would autofill some fields when a user
clicks a checkbox, but it doesn't. I will admit I not a JavaScript
programmer and copied and tweaked some code. The bold areas I edited to
try to make it work but autofilling with the word "spare", but it
doesn't do anything.

Anyone can help here please? Thanks in advance.


 function
setname(box) { var f = box.form, b_which = box.checked, from_el, to_el,
i = 0; var fld_name = new Array('lname'); while (from_el =
f[fld_name[i]]) { to_el = f[fld_name[i++]]; to_el.value = b_which ?
from_el.value : ''; if (to_el.readOnly != null) to_el.readOnly = b_which
? true : false; else to_el.onfocus = b_which ? function() {this.blur();
}
: null;
}
}








Name: 



Robert O. at HWW


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.4/176 - Release Date:
11/20/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:224859
Archives: http://www.houseoffusion.com/cf_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: CFMX 7 & CFMODULE

[Matthew Walker]

Sure, so what happens if you replace your cfmodule with:





-Original Message-
From: ColdFusion Developer [mailto:[EMAIL PROTECTED] 
Sent: Monday, 21 November 2005 2:15 p.m.
To: CF-Talk
Subject: RE: CFMX 7 & CFMODULE

Actually it is a simple call:



The dir_actions.cfm resides in the same directory (there are no
subdirectories)
And the REQUEST.DIRECTORY_PATH variable is valid and does exists.

Inside the tag, it does a simple CFDIRECTORY call and then does a QoQ to
sort the directories by name (since CFDIRECTORY does not do that).

Then I set the QuerySet to CALLER.THEDIR and nothing is returned.
I get the error THEDIR does not exist.



-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 20, 2005 7:54 PM
To: CF-Talk
Subject: RE: CFMX 7 & CFMODULE

Cfmodule should work the same in CF7 as in CF6. However, I've had some
users of custom tags of mine reporting issues like that. I haven't been
able to replicate the issue and for other reasons I've had trouble
working with the users to explore the problem. 

If you use cf_ or cfimport styles to call custom tags do you get the
same failure or does it work? 

-Original Message-
From: ColdFusion Developer [mailto:[EMAIL PROTECTED]
Sent: Monday, 21 November 2005 1:33 p.m.
To: CF-Talk
Subject: CFMX 7 & CFMODULE

Does anyone know why a CFMODULE call does not perform the same as it did
on
CF5 and CF6.1 ?

In CFMX7 it is as if the call never happens.

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:224787
Archives: http://www.houseoffusion.com/cf_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: CFMX 7 & CFMODULE

[Matthew Walker]

Cfmodule should work the same in CF7 as in CF6. However, I've had some
users of custom tags of mine reporting issues like that. I haven't been
able to replicate the issue and for other reasons I've had trouble
working with the users to explore the problem. 

If you use cf_ or cfimport styles to call custom tags do you get the
same failure or does it work? 

-Original Message-
From: ColdFusion Developer [mailto:[EMAIL PROTECTED] 
Sent: Monday, 21 November 2005 1:33 p.m.
To: CF-Talk
Subject: CFMX 7 & CFMODULE

Does anyone know why a CFMODULE call does not perform the same as it did
on
CF5 and CF6.1 ?

In CFMX7 it is as if the call never happens.

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:224780
Archives: http://www.houseoffusion.com/cf_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: wraptext in cfmail

[Matthew Walker]

Perhaps this? http://www.cflib.org/udf.cfm?ID=249 You'll need to rename
the function as wrap() is now reserved. 

-Original Message-
From: Johnny Le [mailto:[EMAIL PROTECTED] 
Sent: Monday, 21 November 2005 10:02 a.m.
To: CF-Talk
Subject: Re: wraptext in cfmail

Yep, that is exactly my problem.  So what is the solution?

Johnny

>I believe the problem is that the counter doesn't reset when manual 
>line breaks are encountered. So if you start "Dear Qwerty," then those 
>12 characters count toward the line length of the next line.
>
>-Original Message-
>From: Johnny Le [mailto:[EMAIL PROTECTED]
>Sent: Monday, 21 November 2005 7:31 a.m.
>To: CF-Talk
>Subject: wraptext in cfmail
>
>Hi,
>
>When I specified wraptext="72" in cfmail, the first line of a paragraph

>in email message seems to cut off a lot shorter than 72.  The rest of 
>the paragraph looks fine.  I don't seem to be able to fix it.
>
>When I use the wrap() function, I get the same problem.
>
>Please help!
>
>Johnny



~|
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:224765
Archives: http://www.houseoffusion.com/cf_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: wraptext in cfmail

[Matthew Walker]

I believe the problem is that the counter doesn't reset when manual line
breaks are encountered. So if you start "Dear Qwerty," then those 12
characters count toward the line length of the next line.  

-Original Message-
From: Johnny Le [mailto:[EMAIL PROTECTED] 
Sent: Monday, 21 November 2005 7:31 a.m.
To: CF-Talk
Subject: wraptext in cfmail

Hi,

When I specified wraptext="72" in cfmail, the first line of a paragraph
in email message seems to cut off a lot shorter than 72.  The rest of
the paragraph looks fine.  I don't seem to be able to fix it.

When I use the wrap() function, I get the same problem.

Please help!

Johnny



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

RE: Query of Queries Subquery

[Matthew Walker]

Is cstSpecialZip another query record set? How about...


  SELECT*
  FROM  OOrder
  Where zip IN ()


In case you're wondering, the "0" will catch empty record set cases (I'm
assuming zip is an integer field). 

-Original Message-
From: Lee [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 10 November 2005 11:31 a.m.
To: CF-Talk
Subject: Query of Queries Subquery

I'm having trouble doing a subquery using a query of queries. Is this
even possible or am I doing something wrong. I have the simplified code
below. Thanks.


SELECTZip
FROM UPS




SELECT*
FROM  OOrder
Where zip IN (Select Zip from cstSpecialZip) 



~|
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:223748
Archives: http://www.houseoffusion.com/cf_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: cfinclude from a template, or onRequestStart?

[Matthew Walker]

> I don't see why you couldn't or wouldn't

Well you certainly could, although I wouldn't. It is the kind of thing
that may not be a problem now but could be a hassle later. As you
describe in your first paragraph below, it's a hassle when suddenly you
*don't* want that template wrapped around your content for a new page. I
would generally only put things I *always* wanted in
application.cfc/cfm. I couldn't guarantee that anything I was displaying
would be *always* wanted, as I may want a different template for a popup
page, or I may be delivering a different type of content such as XML. 


-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 9 November 2005 11:47 p.m.
To: CF-Talk
Subject: RE: cfinclude from a template, or onRequestStart?

He's not saying to but the actual html in the app.cfc file he's saying
put the include. And I don't see why you couldn't or wouldn't. I'm doing
it on a current site and other than a few hair pulls it works great. The
main problem is that if you have a page you don't want it on then you
got a problem. I have heard a few ppl say it's not a good idea but they
dont explain why not?

here's a quote out of one of the 2 tuts I have read on application.cfc

" onRequestEnd 

This function is called at the end of a page request after all other
ColdFusion code has executed. If you have application specific logic
that should only be run at the end of your page, this is the place to
put it. The following example simply outputs a footer by including the
footer.cfm file:  
   
   
  "

So when when ppl say its bad then WHY is it bad, it seems to run just as
good as any other method.

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense
wisdom and abuse at the same time." 


From: "Matthew Walker" <[EMAIL PROTECTED]>
Sent: Tuesday, November 08, 2005 9:12 PM
To: CF-Talk 
Subject: RE: cfinclude from a template, or onRequestStart? 

Personally, I wouldn't put any display elements in application.cfc but
rather use it for app setup purposes (defining global variables,
initialising shopping carts, etc). If you wanted to have a different
page template on a page it might be a big hassle -- or one day you may
want a page that delivers RSS or CSV or something else. Depending on the
way your site is structured, you may find custom tag pairs are a nice
way of wrapping templates around your pages


~|
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:223717
Archives: http://www.houseoffusion.com/cf_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: i18n best practice - multiple lang, multiple labels

[Matthew Walker]

There's a tool around for editing Java resource bundles, but I don't
think it's real pretty.

Alternatively, you could simply do it the old-fashioned database way,
but write out a cfml file as well which will maintain good performance
when reading the resource bundle. Or you could load the entire resource
bundle from the database into memory. My feeling is that any technique
is good as long as you don't have to hit the database individually to
get the localised version of each and every item on the screen. 

-Original Message-
From: Duncan [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 9 November 2005 4:46 p.m.
To: CF-Talk
Subject: Re: i18n best practice - multiple lang, multiple labels

what concerns me about a Java RB (or any RB) is how we would expose that
to our clients to allow them to make their own labels. Is there an
established web app available to deal with this problem?


~|
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:223640
Archives: http://www.houseoffusion.com/cf_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: Difficult Sort - Theory

[Matthew Walker]

Not familiar with MySQL so this may or may not be relevant. 

Generally, everything you are selecting needs to appear in your group by
clause unless it is some kind of aggregation (note you can't have rating
in your select clause as you are averaging it). So it may help to remove
everything from your select except the average rating and the id (you
can put it back later). Also, if your rating is an integer, you may need
to convert it to a floating point number to get an accurate average
(otherwise you may get an integer back). 
 
Here's how it would look in SQL Server...

SELECT   AVG(CAST(rating AS float)) AS avgRating, 
 ShowID
FROM Airdates
GROUP BY ShowID
ORDER BY AVG(CAST(rating AS float)) DESC

I'd be surprised if it was a lot different in MySQL although CAST is
probably different.


-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 9 November 2005 12:31 p.m.
To: CF-Talk
Subject: Re: Difficult Sort - Theory

Matthew Walker wrote:
> Won't this work?
> 
> SELECTshowId
> FROM  airdates
> GROUP BY  showId
> ORDER BY  AVG(rating) 

Hmmm - that's an idea, but doesn't seem to want to work.
Here's the actual query below. (Vastly simplified)


SELECT
  Airdates.rating,
  Airdates.ShowID,
  Shows.Title,
  Shows.ShowID
FROM
  Shows
  INNER JOIN Airdates ON (Shows.ShowID = Airdates.ShowID) WHERE
   Shows.title like '%#form.show_title#%'
   and Airdates.rating > #form.AMOUNT#
GROUP by Shows.ShowID
ORDER BY Airdates.#form.typeRATE# DESC


It works fine until I try until I try to change the order clause:
ORDER BY AVG(Airdates.rating) DESC

Error: Invalid use of group function

mySQL Database

Other Ideas?

--
---
Les Mizzell



~|
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:223635
Archives: http://www.houseoffusion.com/cf_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: cfinclude from a template, or onRequestStart?

[Matthew Walker]

Personally, I wouldn't put any display elements in application.cfc but
rather use it for app setup purposes (defining global variables,
initialising shopping carts, etc). If you wanted to have a different
page template on a page it might be a big hassle -- or one day you may
want a page that delivers RSS or CSV or something else. Depending on the
way your site is structured, you may find custom tag pairs are a nice
way of wrapping templates around your pages


  ...
  ...
  ...



-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 9 November 2005 2:46 p.m.
To: CF-Talk
Subject: cfinclude from a template, or onRequestStart?

I usually assemble my pages with a cfinclude header, menu, footer, etc. 
But I figured it might be better to include the header.cfm in
onRequestStart, and footer.cfm in onRequestEnd to keep from spreading
includes all over the place. 

This way they'd all be in one spot. Am I thinking right??

Thanks,
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:223633
Archives: http://www.houseoffusion.com/cf_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: i18n best practice - multiple lang, multiple labels

[Matthew Walker]

I think a database is quite a bad idea as there could be tens or
hundreds of there localised items on a page. You wouldn't want to hit
the database that much just to display a page. 

A "resource bundle" could be as simple or sophisticated as you want. I
generally just make one CFM file for each language that assigns values
to a bunch of well-named variables. Using the resource bundle is simply
a matter of CFINCLUDEing the appropriate file. Alternatively you can use
Java resource bundles, and there are some tools here to help:
http://www.sustainablegis.com/things.cfm (also lots of other invaluable
stuff).  

-Original Message-
From: Duncan [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 9 November 2005 12:31 p.m.
To: CF-Talk
Subject: i18n best practice - multiple lang, multiple labels

Hi everyone,

I have a question and I hope to get some suggestions on possible ways to
implement this problem.

The application in question is an ASP model, and has many clients over
many languages. The business sees the need to have labels for each
client so they can tailor the words used on menu items, descriptions etc
through out the system.

Would we be able to handle this with resource bundles? If so how would
it be managed by the client? Would we be better to do it with a database
somehow?



~|
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:223628
Archives: http://www.houseoffusion.com/cf_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: Before and after decimals.

[Matthew Walker]

listFirst(value, ".")
listRest(value, ".")

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 9 November 2005 10:31 a.m.
To: CF-Talk
Subject: Before and after decimals.

Hi guys,

I've got a number in one of my fields which has a decimal point.  I want to 
pull everything from the left of the point so I can use that value separately 
for a drop down box for the £ value (pound sterling) and to the right for the 
pence select box.  I'm just wondering what the best way of finding the digits 
before the decimal place and after it.

Any help would be great, thanks,

Saturday






~|
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:223609
Archives: http://www.houseoffusion.com/cf_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: Difficult Sort - Theory

[Matthew Walker]

Won't this work?

SELECT  showId
FROMairdates
GROUP BYshowId
ORDER BYAVG(rating) 

-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 8 November 2005 4:16 p.m.
To: CF-Talk
Subject: Difficult Sort - Theory

Just looking for ideas...

Assume I have a database with TV Miniseries It's a mySQL database.

TABLES
-
1. SHOWS
a. showID
b. showTITLE
2. AIRDATES
a. showID
b. airdate
c. rating

Now, since it's a miniseries, it will have multiple entries in the
AIRDATES table for each night (part 1, 2, 3, blah, blah..). I need to
AVERAGE the rating for all airdates for each specific title, and then
sort on the average.

I've come up with a couple of VERY convoluted ideas, but the operative
word here is convoluted.

How would any of you approach this?


--
---
Les Mizzell



~|
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:223553
Archives: http://www.houseoffusion.com/cf_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: onSessionEnd Error on 7.01

[Matthew Walker]

This sounds a bit like "'Session is invalid' error after the first
unnamed application session expires (J2EE sessions ON) ."
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=aae43964


-Original Message-
From: Steve Bryant [mailto:[EMAIL PROTECTED] 
Sent: Monday, 7 November 2005 6:01 p.m.
To: CF-Talk
Subject: onSessionEnd Error on 7.01

We just moved a site to a new server. The old server was running
ColdFusion MX 7 while the new one is running ColdFusion MX 7.01.

I suddenly started getting errors ( reported via onError() ) saying that
onSessionEnd() couldn't be found. I added onSessionEnd to
Application.cfc and  I got a new blank error every time that
onSessionEnd fires (unless I manually fire it).

Does anyone have any clues what might might be causing 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:223473
Archives: http://www.houseoffusion.com/cf_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: Cfchart hanging

[Matthew Walker]

 
We had this happening when we were using a server monitoring too
(IISTracer) but the problem went away with CF 7.0.1.

> Got this very basic code on a page, but cfchart just hangs, and 
> nothing happens, the page just seems to endlessly load forever.
> Anyone got an idea why?
> I do have the CFIDE and JrunScripts vDIR's in palce.
>

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

[Matthew Walker]

I've never had a need for it, but I've found imp to be useful sometimes.

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Friday, 4 November 2005 11:00 a.m.
To: CF-Talk
Subject: XOR

ColdFusion comparison statements (CFIF, etc.) support the XOR joiner
between clauses. This is used as such:
clause1 XOR clause2
This says that either clause1 or clause2 has to be true for the
statement to be true. If both are true or both are false, then the
entire statement is false. My question is: can anyone think of a real
world example where you would need a statement like this?





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

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

[Matthew Walker]

But in this example you couldn't tolerate somebody who had neither blue
hair nor smoke. You just killed off your ideal matches ;-)

Perhaps:


Winner!




I suppose in dating there could only be so much tolerance.  I could
tolerate a smoker, or blue hair, but not both because that would be too
much.


Winner!



~|
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:223125
Archives: http://www.houseoffusion.com/cf_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: How to recognize robots

[Matthew Walker]

> The reason I ask, is that I just implemented some statistics facility 
> on some of my customers sites. This will count all hits, including
those
> from robots, so I'd like to be able to discriminates visitors hits
from
> others.

One way is to use an image in your page that is actually a cfm file. Use
the cfm file to track stats (pass in query string info to specify what
page you're looking at). You can use JS to load the image, which will
block bots but also drop the fraction of users with JS disabled. 

Not sure what happens if you embed the image directly. Presumably Google
will get counted due to its image search functionality. But perhaps
others won't??

~|
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:222675
Archives: http://www.houseoffusion.com/cf_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: Inline frames a good alternative for creating web applications?

[Matthew Walker]

It would certainly work. You could consider embedding a visible iframe
in each box so that when the form was submitted, only that part
refreshed. That would mitigate the page size issue Barney mentioned (in
fact it could perform better than an old fashioned design), and save the
layout from changing each time you submitted the form. 

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Friday, 28 October 2005 4:45 p.m.
To: CF-Talk
Subject: RE: Inline frames a good alternative for creating web
applications?

Very nice...I pasted your code below into Homesite and it worked like a
charm...I guess I just need to dress it up and check out how you worked
with your DIV's.

That's a great way to get a lot of information on a page.  I guess I
could put forms into those DIV's and have sections for "Update Client
Info"
"Delete Client" or "Add Client" and instead of sending a user to various
pages to complete forms and perform the functions, they could do it
right in the DIV's and expand / collapse as needed.

Any reason that wouldn't work?  One reason I ask is that I'm working on
an internal office application to replace some software an insurance
company was unhappy with...the software was just too complicated for the
simple tasks they wanted to perform.  They asked me to write an app that
performed the tasks they needed in an "understandable" manner.

I've been looking for ways to consolidate adding, updating, and deleting
into a single page.  This looks like it has potential to do that.

Rick


~|
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:222532
Archives: http://www.houseoffusion.com/cf_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: Solved: Client/Session Variable: When to set?

[Matthew Walker]

That's not "setting" session and client variables. That is including
them in a page URL.

When CF developers talk about session and client veriables, they are
generally referring to variables stored in the session and client
scopes. These variables may never be visible to users. These articles
appear to be referring to variables passed in the URL that are used to
maintain a session. Personally, I don't use variables like these at all.
You only need them if you want to maintain a session without using
cookies. There are a number of potential problems with them, such as
what if Google indexes somebody's URL with these variables visible (this
can happen if you have Google toolbar) and then people start seeing
what's in somebody else's cart. Oh dear. What I'm saying is that
maintaining state without cookies is a can of worms. 


-Original Message-
From: Nomad [mailto:[EMAIL PROTECTED] 
Sent: Friday, 28 October 2005 4:16 p.m.
To: CF-Talk
Subject: Solved: Client/Session Variable: When to set?

Hello
Googled with the keywords "session variables and search engine ranking"

http://uglyduckling.net.au/web-designer-pitfalls.html
http://www.seomoz.org/articles/search-ranking-factors.php#5
http://www.livingroom.org.au/searchengineoptimization/archives/top_10_se
arch
_engine_positioning_mistakes.php


~|
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:222531
Archives: http://www.houseoffusion.com/cf_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: Inline frames a good alternative for creating web applications?

[Matthew Walker]

> Did you make the sections on the pages
> collapsible with JS?

Yes. The JS below is included in an external JS file. The HTML code
below is wrapped up as a CF custom tag where "myUniqueId" is a tag
attribute. The attribute needs to be unique for each box or JS doesn't
know which one you are referring to. The code assumes you have two
images: collapsed.gif and expanded.gif but will run without them. When
you click the title bar, three things are toggled: the visibility of the
box, the arrow image's src attribute, and the arrow image's title
attribute. The code below will work as is -- just paste into HomeSite. 

Here's what happens: when you click on the Title DIV the onclick() event
occurs and the toggleDisplay() function runs. The first line of the
function puts the div called "myUniqueId" in a variable. This is just to
save typing. You could replace all the "obj"s with
"document.getElementById(id)". 

We determine whether the box is currently expanded or collapsed by
looking at the DIV tag's display style. If it's set to none, then the
box is currently hidden so we should expand it, and vice versa.

splitSrc is all about chopping up the URL of the image so we change the
name of the image but still keep the path to the image. Toggling the
image makes the code a bit harder to follow. We take the image path and
split it into an array. The last entry in the array is either
"collapsed.gif" or "expanded.gif". 

The if clause is where we actually start changing things.
obj.style.display sets the visibility of the box.
splitSrc[splitSrc.length-1] sets the last entry in the array
representing the image path. arrow.title sets the IMG tag's title
attribute. 

Finally, we turn the array representing the image path back into a
string with join() and set the IMG tag's src attribute to the new value.


function toggleDisplay(id) {
var obj = document.getElementById(id);
var arrow = document.getElementById(id + "_arrow");
var expanded = obj.style.display != "none";
var splitSrc = arrow.src.split("/");
if ( expanded ) {
obj.style.display = "none";
splitSrc[splitSrc.length-1] = "collapsed.gif";
arrow.title = "Expand";
}
else {
obj.style.display = "block";
splitSrc[splitSrc.length-1] = "expanded.gif";
arrow.title = "Collapse";
}
arrow.src = splitSrc.join("/");
}





Title



lorem ipsum

 


~|
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:222522
Archives: http://www.houseoffusion.com/cf_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: Inline frames a good alternative for creating web applications?

[Matthew Walker]

> Most of my clients do a poor job of utilizing the capabilities I build
into their
> websites now...

Personally, I use hidden iframes techniques sparingly because I'm lazy.
One good use is where you want to make a tiny change to a big page. For
example, on this site of mine (www.tramper.co.nz) you can "bookmark"
pages if you are logged in. Instead of reloading the entire page --
which would be slow, confusing, and harder on the server -- a hidden
iframe is used to update the bookmark and display bookmark added /
removed messages. The JS is exceedingly simple as both messages are
already part of the page and the script merely swaps which one is
visible. 

The point is that you can potentially add some good functionality with
minimal JS. So while you (like me) may not have time to learn JS inside
out, there may be real benefit to learning just a little, such as
toggling visibility by manipulating styles, and perhaps displaying
messages using the innerHTML property. 

~|
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:222510
Archives: http://www.houseoffusion.com/cf_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: Client/Session Variable: When to set?

[Matthew Walker]

> I have seen google links to some items on the website that actually 
> included the session id/ Cfid tokens.

I'm pretty sure the default behaviour of cflocation is to include these,
so that may be the source of them. Check all your cflocations have:
addtoken="No"

~|
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:222509
Archives: http://www.houseoffusion.com/cf_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: Client/Session Variable: When to set?

[Matthew Walker]

By "Application page" do you mean Application.cfm? If you do, then the
search engine bot is never going to know where the session/client
variables are being set.

In general, you probably want to allow bots to spider the pages of your
shop, but surely client and session variables are irrelevant for viewing
pages of your shop catalogue? 

-Original Message-
From: Nomad [mailto:[EMAIL PROTECTED] 
Sent: Friday, 28 October 2005 11:31 a.m.
To: CF-Talk
Subject: Client/Session Variable: When to set?

Hello!

Need to clear this up once and for all
When is the best time to set session/client  variables..(Application
page or Cart page for an online shop) and why?
My understanding is that sites that set session/client variables in
Application page have poor search engine ranking.

~|
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:222497
Archives: http://www.houseoffusion.com/cf_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: Inline frames a good alternative for creating web applications?

[Matthew Walker]

Some examples of using hidden iframes here. You might find some JS you
can adapt to your purposes. 
http://www.eswsoftware.com/products/srs/

> That's mostly what I've been considering lately...working out
solutions
> that involve things that are more easily employed...even if that
solution
> is not quite as effective or "elegant" as AS, JS, and AJAX solutions.

~|
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:222493
Archives: http://www.houseoffusion.com/cf_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: Custom Tag with "auto" cfoutput

[Matthew Walker]

If you sould specify that the content of a custom tag was treated as if
wrapped in cfoutput, that would be a very nice CF feature. Unfortunately
you can't.

> Now, I know cfquery has a built in cfoutput. How can I add a 
> built in cfoutput into my custom tag? Hopefully I'm clear as
> to what I'm saying. :-)

~|
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:222148
Archives: http://www.houseoffusion.com/cf_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: CFC - separate or all in one?

[Matthew Walker]

> They can be good for both, can't they?  ;^)

Fair enough -- I guess I meant that always using them as a library of
functions is the trap many new users (e.g. me) fall into when first
using CFCs.

You can create utility CFCs that don't maintain state and are
effectively just a collection of related methods. CFCs for manipulating
images are often like this. In JavaScript, the Math class is a good
example. 

I would suggest that as a general guideline, very few of your CFCs
should be written like this. I'd also recommend you keep them in a
separate folder, so you know you don't have to initialise them. 

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

[Matthew Walker]

You could just set the mask to be a variable, and set that variable to a
diff value for a given currency symbol. 

Or you could use something like: 



#lsCurrencyFormat(12.34)# 


-Original Message-
From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] 
Sent: Friday, 21 October 2005 11:45 a.m.
To: CF-Talk
Subject: Displaying currencies

hi there,
 
my client displays several currencies on their site. i sue the following
function for displaying the prices correctly...
 
  
 
 
  
  

  
 

 
my client now wishes to display japanese yen. now this currency does not
use decimal places - whole numbers only. what would be my best approach
for displaying yen correctly?
 
thanks.


Kind Regards

Mike Little
[ Designer ]



  
Graphic Impact Ponsonby
40 College Hill, Ponsonby, Auckland
DDI +64 9 376 7622
Phone +64 9 376 7360
Fax +64 9 376 7361  

  _  

CAUTION: This e-mail message and accompanying data may contain
information that is confidential. If you are not the intended recipient
you are notified that any use, dissemination, distribution or copying of
this message or data is prohibited. All content is to be treated as
confidential unless otherwise specified, and is not to be forwarded to
third parties without the prior permission of the author. To do so may
breach the New Zealand Privacy Act 1993. If you have received this
e-mail message in error please delete it and notify me. Thank you.  





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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221750
Archives: http://www.houseoffusion.com/cf_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: CFC - separate or all in one?

[Matthew Walker]

This may be obvious but I'm a bit confued about what you're asking.

I think it's important to note that CFCs are not merely "method
libraries" as you might create with UDFs. 

They are best used when you create a CFC that represents a real-world
class of objects (e.g. contacts), and you instantiate it to represent an
individual object belonging to this class (e.g. "Michel"). 

The methods are then things like getFirstName(), setEmail(),
serialise(), delete() -- i.e. they are actions you perform on the
object.

I would generally create a contact cfc for working with just one
contact, and a contacts cfc for working with aggregate contacts --
browsing, searching, etc. The contacts cfc would generally simply return
a query record set. 


-Original Message-
From: Michel Deloux [mailto:[EMAIL PROTECTED] 
Sent: Friday, 21 October 2005 7:16 a.m.
To: CF-Talk
Subject: Re: CFC - separate or all in one?

Thanx Barney.

In resume: separate for concerned tasks is the best approach? This is
THE OO approach, right?

Cheers

MD

2005/10/20, Barney Boisvert <[EMAIL PROTECTED]>:
> Depends on the component(s).  Are the method closely related so as to 
> comprise the behaviour of a single "thing", or are they varied in 
> nature?  In general, you want each object to be concerned with a 
> single specific task.  How big that task is can vary greatly, of 
> course.
>
> cheers,
> barneyb
>
> On 10/20/05, Michel Deloux <[EMAIL PROTECTED]> wrote:
> > Hi all
> >
> > what's the best: separate functions/methods in several components or

> > include all methods in a same component?
> >
> > Cheers
> >
> > MD
> > =
>
>
> --
> 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:221738
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: OT Joins

[Matthew Walker]

It depends what your WHERE clause says, but it's probably an inner
join...

SELECT *
FROM a INNER JOIN b
ON a.x = b.y

or

SELECT *
FROM a, b
WHERE   a.x = b.y
 
In this case above, I'd recommend INNER JOIN as it makes what you're
trying to do more explicit for debugging and maintenance purposes. 

Sometimes you want to select rows where there are missing entries in one
table (in this case b) ...

SELECT *
FROM a LEFT JOIN b
ON a.x = b.y

That would be harder to write using a WHERE clause.

It's worth noting btw that CF query-of-queries doesn't support JOIN
syntax -- you need to use the WHERE clause. 
 


-Original Message-
From: Mark Fuqua [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 20 October 2005 1:15 p.m.
To: CF-Talk
Subject: OT Joins

Can anyone explain to me what type of join is created when the join is
done with the WHERE clause as opposed to the FROM clause in a sql
statement.

What are the advantages the joins in the FROM clause.

I know it is because I am still very green but I find WHERE clause joins
much easier to write.

Thanks,

Mark





~|
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:221590
Archives: http://www.houseoffusion.com/cf_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: CFDocument font probs

[Matthew Walker]

There are references to cfdocument and fonts in the 7.0.1 update. 
http://www.macromedia.com/support/documentation/en/coldfusion/mx701updat
er/cf701releasenotes01.html 

-Original Message-
From: Snake [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 19 October 2005 11:45 a.m.
To: CF-Talk
Subject: RE: CFDocument font probs

I did actually find someone reporting the error on the CT forum, but no
reply. 

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 18 October 2005 21:01
To: CF-Talk
Subject: RE: CFDocument font probs

I had the same error on some shared hosting accounts at CrystalTech.
They fixed them almost straight away so I'd guess it's  trivial matter
to fix.

Not a solution I know, but at least you know others are having it and
it's fixable.

Ade

-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 17 October 2005 11:51
To: CF-Talk
Subject: CFDocument font probs


I get the following problem with cfdocument when I use fontembed

access denied (java.io.FilePermission c:\windows\fonts\times.ttf read)

Please see the following as an example

http://www.hoa.cfmxhosting.co.uk/pdftest.cfm


I have even given EVERYONE access on the fonts folder and it will wont
work.

--
Russ






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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221412
Archives: http://www.houseoffusion.com/cf_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: Verity and Asian languages

[Matthew Walker]

> created using japanese? well that's the first problem. if your
encoding is unicode then i think 
> you need to use "uni" as the language when you build the collections.
and yes question marks 

I see. I assumed the cfindex "language" attribute referred to the
language being indexed, but apparently it refers to the character set,
or at least the implied character set (i.e. Japanese implies Shift_JIS).
Thanks for the advice. 

> what do you mean by "special intelligence to languages like Japanese"?

I assumed the stem and suggestions functionality in Verity would require
an awareness of the language in question, which I assume the Unicode
"language" wouldn't be able to provide. 

I realise these issues I've been having probably stem from Verity being
a third party application, but I think the CF docs could be a bit
clearer about what exactly a "language" is in Verity. 

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

Verity and Asian languages

[Matthew Walker]

I've been having issues within CF7 with getting Verity to index and
search Japanese. I note that you can download language packs from
Macromedia (www.macromedia.com/go/verity
 ) (the instructions for these btw
specify the wrong file location, also the file sizes are completely
wrong). So I've installed the Asian pack, created a collection and
attempted to search it. The results returned are all question marks,
indicating a character encoding issue to me. If I try  it looks like Verity is using the Shift_JIS character
set. I never asked for that -- I'm using Unicode.
 
I think the "multilanguage" pack includes support for the "Unicode"
language -- leaving aside that Unicode isn't a language. I'll have to
download that from home later as we pay through the nose for office
bandwidth, so I haven't tested this out yet. 
 
Can anybody confirm that this is the way to search Unicode data with
Verity? It seems to me that the Verity CF docs are in an appalling state
with regard to languages. My second question then is, does Verity not
apply any special intelligence to languages like Japanese or does that
only apply with the Japanese "locale" and the Shift JIS character set?
The advantages of using Verity at all for Japanese are hard for me to
see. 
 
Advice anybody?


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

RE: Query in application.cfm

[Matthew Walker]

If you are setting an application variable, it will be maintained for
the runtime of the app (i.e. until the server restarts). Why do you need
to rerun the query on every page view? Is the data static or does it
need to expire after a certain timeframe?

How about...


 


-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 15 September 2005 11:01 a.m.
To: CF-Talk
Subject: Query in application.cfm

I need to keep track of a production system configuration. So, is is OK
to put a query into application.cfm, like:

--> Do a query into production settings table

--> set application variable depending on query results

--> drink a beer ;-)

Are there any issues, other than a query that runs every time a page is
executed and perhaps slows things down just a bit ... Would it be
quicker to read a file with CFFILE to get the application variable value
than run a very simple query??

Richard 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:218336
Archives: http://www.houseoffusion.com/cf_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: Replace String

[Matthew Walker]

Isaac you crazy guy! 

#ReplaceList(myString, ",,", "Phone
number changed from,to,")#

-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 15 September 2005 2:46 a.m.
To: CF-Talk
Subject: Re: Replace String

Hi Becky,

What you're looking at is XML and it should be reasonably easy to
convert this into your desired output using CF's native XML tools.
Give this a shot:

#mystring#


Phone number changed from
#myxml.xml.token1.xmlText# to
#myxml.xml.token2.xmlText#


I could have given you an XSL template to translate the tokens, but
that's a little more involved -- I figured this would be shorter and
easier to follow in this case.


~|
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:218332
Archives: http://www.houseoffusion.com/cf_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: block forms from being filled out automatically

[Matthew Walker]

> How are submitting the form? on your form process page you could make
sure that the referrer is the actually Form URL.

I'd recommend not doing this as some software (Norton Internet Security
I think) clears the referrer field, so legitimate users would be
blocked. If it's always from one email address (if there's an email
field) or IP you could just dump data from that email / IP. They needn't
know that you're throwing away their data

~|
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:218129
Archives: http://www.houseoffusion.com/cf_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: CFMail Errors when mass mailing (not spam)

[Matthew Walker]

What error do you get? How many are you sending?

-Original Message-
From: Brian Polackoff [mailto:[EMAIL PROTECTED] 
Sent: Monday, 12 September 2005 1:30 p.m.
To: CF-Talk
Subject: CFMail Errors when mass mailing (not spam)

Does anyone know on a cfmx 6.1 box how to send using the CFMAIL tag a
slew
of emails at a time.  I have tried looping through, sending to a single
address at a time.  I have also tried sending the message to every
address
at once.  Usually CF errors.

Any ideas, I know this issue was resolved with cf 7 but can't upgrade
just
yet.

Thanks in advace,
Brian Polackoff




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

[Matthew Walker]

Alternatively, the members plugin could be aware of the presence
contacts plugin and have a button that generate the contact. Or perhaps
all the "members" would automatically be added into "contacts"? Do you
have categories of contacts?

The contact would by default be synchronised with the members data (the
member update could announce some kind of event). Then in the contact
plugin interface, a checkbox would let you turn on or off
synchronisation with the members data.


-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] 
Sent: Monday, 12 September 2005 6:01 a.m.
To: CF-Talk
Subject: Interface Question

So I'm planning to build out a contact-manager plugin for the onTap
framework. This plugin will allow people to manage multiple address
books each of which can be declared private or public, with selection
criteria including language/locale, company, location (i.e. Downtown
Office), arbitrary regions (provided in the Members onTap plugin),
etc. with custom rules for determing who can do what with each address
book.

None of which has anything to do with my question. :)

The Members onTap plugin maintains an email address for each
application member. I've always hated needing to update lots of
different coppies of an address or phone number when someone moves,
etc. so I'm thinking I'd like to provide some integration between the
email address stored for the member (where forgotten passwords and
system notices are sent, etc) and the email addresses stored in the
member table.

My problem is that I'm not sure how to design it in terms of
user-interface/usabiliy.

I've considered three things:

1) update the contact system automatically when the member email
address is updated (though a member may update their member
system-notification address without wanting to change their "public"
email address)

2) update the member system automatically when a matching contact
email address is changed (though again a member may want to change
their "public" address without altering their member address for
system notifications)

3) present a list of contact names/addresses in page, which could be
changed when changing a member email address

4) ask the user in-page if they want to change the member address when
they change a matching address in the contact system

5) send an email to a member when a matching email address is changed
in the contact system to remind them that their member address hasn't
been updated

All of these potential solutions, in addition to producing more
user-interface questions (or potential annoyances) also carry with
them a number of security implications / limitations. A member who has
permission to edit contact information may or may not be able to edit
member accounts, so there's some question as to whether that should
also apply to the email address? And the inverse is also true that a
member will always have permission to change their own email address,
although even if a person has permission to edit member accounts that
doesn't necessarily mean they have permission to edit contact
information for a particular address book (i.e. a client may be
allowed to manage the member accounts for their own employees - that
doesn't give them rights to edit another client's address book).

Thoughts?


Thanks,


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

add features without fixtures with
the onTap open source framework

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




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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217903
Archives: http://www.houseoffusion.com/cf_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: Have brain lock, need schema/query help!

[Matthew Walker]

A different approach would be to list each SKU instead of listing the
independent options. So instead of say a select box for colour and a
select box for size, you'd have just one select...

Red XS
Red S
Red M
Red L
Red XL
Blue XS
Blue S
Blue M
Blue L
Blue XL


This would make the queries easy. But also if you had no inventory of
"Blue M" then you could support that easily!

-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 7 September 2005 8:45 a.m.
To: CF-Talk
Subject: Have brain lock, need schema/query help!

Hey guys, I'll get right to it. 

I'm working on my new cfc cart app and using a new db schema. 
Here's the schema:  http://wtomlinson.com/newcartschema.gif

You add a productid/model, then add SKU'S to it. Where I'm having
trouble is with the options. They're twisting my brain up! 

I've made it to the details page where I query for options, then loop
through them producing cfselects in my addtocart form. Keep in mind no
code I'm posting is finished at all, just trying to make the basics
work. 
Here's my post to the cart:


   
  
 #optionname#
  
   

This is working fine. It's dynamic and might not even show up if there
are no options available for a given item. I'll check it with if's and
process accordingly. 

My problem is on the cart page where I'm having trouble querying the
tblprod_skus to add a specific item to the cart. I've tried looping
through form.formfields to find the options present, but can't seem to
make anything work. Used some list functions and such. 

Like this: 


SELECT tblprod_SKUS.SKUID, tblprod_SKUS.SKU_prodID,
tblprod_SKUS.SKUprice,tblprod_SKUS.merchSKUID,
tblSKUoptions_rel.optionID, tblSKUoptions_rel.optionSKUID,
tblSKUoptions_rel.option_optionID
FROM tblprod_SKUS, tblSKUoptions_rel
WHERE tblprod_SKUS.SKUID = tblSKUoptions_rel.optionSKUID

AND option_optionID = #ListLast(i, "_")#



Secondly, once I even make that work I can't figure out what my query
needs to look like to extract a specific item. If an item was added to
the cart, size = small, color = red, I can pull those out of
tblSKUoptions_rel, but how do I get the specific item out of
tblprod_SKUS? 

I'm just mixed up! UGHHH!


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:217516
Archives: http://www.houseoffusion.com/cf_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: Have brain lock, need schema/query help!

[Matthew Walker]

An SKU incorporates options such as colour and size

A product could be "ColdFusion coffee mug" while an SKU might be
"ColdFusion Coffee Mug, Size XXL, white"

I guess a product is a promotional unit, while an SKU is an inventory
unit. 

-Original Message-
From: Matthew Blatchley [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 7 September 2005 9:16 a.m.
To: CF-Talk
Subject: Re: Have brain lock, need schema/query help!

I done something similar to your drop down menu and had to end up using
the 
Evaluate functions to figure out the name of the form field.  Gave me a 
major headache as I recall.

The biggest question on my mind is why does the productID have multiple 
SKU's (1 to many) on your db schema?  Isn't the SKU for each product
going 
to be unique?

Matt

- Original Message - 
From: "Will Tomlinson" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, September 06, 2005 3:31 PM
Subject: SPAM-LOW: Have brain lock, need schema/query help!


> Hey guys, I'll get right to it.
>
> I'm working on my new cfc cart app and using a new db schema.
> Here's the schema:  http://wtomlinson.com/newcartschema.gif
>
> You add a productid/model, then add SKU'S to it. Where I'm having
trouble 
> is with the options. They're twisting my brain up!
>
> I've made it to the details page where I query for options, then loop 
> through them producing cfselects in my addtocart form. Keep in mind no

> code I'm posting is finished at all, just trying to make the basics
work.
> Here's my post to the cart:
>
>  width="400" height="200">
>   
>  
>  value="#theoptionID#">#optionname#
>  
>   
>
> This is working fine. It's dynamic and might not even show up if there
are 
> no options available for a given item. I'll check it with if's and
process 
> accordingly.
>
> My problem is on the cart page where I'm having trouble querying the 
> tblprod_skus to add a specific item to the cart. I've tried looping 
> through form.formfields to find the options present, but can't seem to

> make anything work. Used some list functions and such.
>
> Like this:
>
> 
> SELECT tblprod_SKUS.SKUID, tblprod_SKUS.SKU_prodID, 
> tblprod_SKUS.SKUprice,tblprod_SKUS.merchSKUID,
> tblSKUoptions_rel.optionID, tblSKUoptions_rel.optionSKUID, 
> tblSKUoptions_rel.option_optionID
> FROM tblprod_SKUS, tblSKUoptions_rel
> WHERE tblprod_SKUS.SKUID = tblSKUoptions_rel.optionSKUID
> 
> AND option_optionID = #ListLast(i, "_")#
> 
> 
>
> Secondly, once I even make that work I can't figure out what my query 
> needs to look like to extract a specific item. If an item was added to
the 
> cart, size = small, color = red, I can pull those out of 
> tblSKUoptions_rel, but how do I get the specific item out of
tblprod_SKUS?
>
> I'm just mixed up! UGHHH!
>
>
> 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:217511
Archives: http://www.houseoffusion.com/cf_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 Spider/Screen Scrape

[Matthew Walker]

This may help, but you need to be able to use regular expressions
http://www.eswsoftware.com/library/scraping.cfm 


-Original Message-
From: Matthew Blatchley [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 6 September 2005 12:45 p.m.
To: CF-Talk
Subject: Re: CF Spider/Screen Scrape

First you might want to start by having permission from the site owner
of 
the page your scraping which isn't as easy as a phone call :)

I would use  and then search through the page for the specific
name 
of the products your looking for and the price.  It's a lot easier to
scrape 
a page that isn't dynamically generated because it probably won't change

from one day to the next.  You'll need to use some pretty fancy Regular 
expressions to get it work for each page you scrape.  Once the data is 
collected, send out the email with link to update as Matthew
described...but 
again...scraping can be something you can get into trouble with so I'd
check 
into seeing if your not doing something illegal.

Matt


- Original Message - 
From: "Nomad" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, September 05, 2005 7:05 PM
Subject: Re: CF Spider/Screen Scrape


> Thanks.
> How do I get started with the monitoring service? Any pointers?
>
> Ben
>
> - Original Message -
> From: "Matthew Walker" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Tuesday, September 06, 2005 12:10 PM
> Subject: RE: CF Spider/Screen Scrape
>
>
>> Yes you can do this in CF, but...
>>
>> Screen scraping is very fragile. It can be useful, but I wouldn't
>> recommend attaching it to a live database. Your competitors could
change
>> their template and then suddenly you're selling your products for
$0.00.
>> Will you as the developer be liable?
>>
>> I would recommend, instead of changing the data automatically, just
>> compiling it into a mail message with links and letting the client
>> verify the prices by hand. So build a monitoring service. This would
be
>> a lot safer.
>>
>> Is what you want to do even legal?
>>
>> -Original Message-
>> From: Nomad [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, 6 September 2005 12:01 p.m.
>> To: CF-Talk
>> Subject: CF Spider/Screen Scrape
>>
>> Hello all,
>>
>> I have been asked by a  client who operates an online shop to do the
>> following:
>>
>> 1. Create a spider/crawler that will crawl and collect pricing
>> information
>> from a number of competitors sites.
>> 2. Update the clients own database with the information collected
>> undercutting the competitors by few cents/dollars.
>>
>> Can Cold Fusion do this?
>> Can someone provide some pointers for me to get started.
>> I understand that this is not an easy beast to tame.
>> Is there any ready made solution that I can integrate with the
clients
>> website (CF based).
>>
>> Will appreciate any help.
>>
>> Thanks
>>
>> Ben Thomas.
>>
>>
>>
>>
>>
>
> 



~|
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:217413
Archives: http://www.houseoffusion.com/cf_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: getCallingTemplatePath()

[Matthew Walker]

Let me rephrase

The code I posted earlier works regardless of the "Enable Robust
Exception Information" setting. This setting does not affect the
availability of context and stack trace in cfcatch data.

The "Enable Robust Exception Information" setting only seems to affect
what is displayed as debug info if you have debugging turned on. 

-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 6 September 2005 1:46 p.m.
To: CF-Talk
Subject: RE: getCallingTemplatePath()

>> So it worked? I'm still a little fuzzy... :P

> Yes it worked. Seems to me that checkbox really only
> changes what is
> displayed in the CF error, not what is gathered.

I'm still a bit confused... if it wasn't providing the necessary
tagcontext array data before you checked it and then when you checked
it the hack started working because the data was available, wouldn't
that indicate that it had changed more than just what's displayed? Or
am I missing something...


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

add features without fixtures with
the onTap open source framework

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




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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217411
Archives: http://www.houseoffusion.com/cf_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 Spider/Screen Scrape

[Matthew Walker]

Yes you can do this in CF, but...

Screen scraping is very fragile. It can be useful, but I wouldn't
recommend attaching it to a live database. Your competitors could change
their template and then suddenly you're selling your products for $0.00.
Will you as the developer be liable?

I would recommend, instead of changing the data automatically, just
compiling it into a mail message with links and letting the client
verify the prices by hand. So build a monitoring service. This would be
a lot safer.

Is what you want to do even legal? 

-Original Message-
From: Nomad [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 6 September 2005 12:01 p.m.
To: CF-Talk
Subject: CF Spider/Screen Scrape

Hello all,

I have been asked by a  client who operates an online shop to do the
following:

1. Create a spider/crawler that will crawl and collect pricing
information
from a number of competitors sites.
2. Update the clients own database with the information collected
undercutting the competitors by few cents/dollars.

Can Cold Fusion do this?
Can someone provide some pointers for me to get started.
I understand that this is not an easy beast to tame.
Is there any ready made solution that I can integrate with the clients
website (CF based).

Will appreciate any help.

Thanks

Ben Thomas.




~|
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:217403
Archives: http://www.houseoffusion.com/cf_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: getCallingTemplatePath()

[Matthew Walker]

> So it worked? I'm still a little fuzzy... :P

Yes it worked. Seems to me that checkbox really only changes what is
displayed in the CF error, not what is gathered. 

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

RE: Query Help

[Matthew Walker]

Perhaps more elegant

SELECT  p.adtype,
p.name,
p.longitude,
p.latitude,
p.address1,
p.address2,
p.city,
p.state,
p.zip,
(
SELECT  TOP 1
Areacode
FROMpropertyareas a
WHERE   a.propertyid = p.propertyid
) AS areacode
FROMproperties 
ORDER BYp.name


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 6 September 2005 11:46 a.m.
To: CF-Talk
Subject: Re: Query Help

Thanks, Mathew.  That works.  It looks familiar... I remember doing this

before, where it required the use of 'fake' aggregate functions on all 
other columns I needed returned by the query, as well as in the ORDER BY

clause.  The real query is a little more complicated.

SELECT p.propertyid,
   MIN(p.adtype) AS adtype,
   MIN(p.name) AS name,
   MIN(p.longitude) AS longitude,
   MIN(p.latitude) AS latitude,
   MIN(p.address1) AS address1,
   MIN(p.address2) AS address2,
   MIN(p.city) AS city,
   MIN(p.state) AS state,
   MIN(p.zip) AS zip,
   MIN(a.areacode) AS areacode
FROM properties p INNER JOIN propertyareas a ON a.propertyid = 
p.propertyid
WHERE a.areacode = '#form.areacode#'
GROUP BY p.propertyid
ORDER BY MIN(a.areacode), MIN(p.name)

Seems to me that there's enough 'kludge factor' in this query that I
can't 
help thinking either it should be designed differently or that there's 
something I'm missing in the design of the database that would allow me
to 
do this more easily.


- Original Message - 
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, September 05, 2005 4:50 PM
Subject: RE: Query Help


> SELECT p.propertyid, p.name, min(c.name) AS city
> FROM property p
>  INNER JOIN property_city pc ON pc.propertyid = p.propertyid
> GROUP BY p.propertyid, p.name
>
> -Original Message-
> From: Jim McAtee [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 6 September 2005 10:31 a.m.
> To: CF-Talk
> Subject: Query Help
>
> I have a number of real estate properties, each associated with one or
> more city.  If I select by specifying a city then I get a list of
unique
>
> properties.  But if I do a broader select, then I get duplicates of
the
> property record when a record is assocuated with two or more cities.
> How
> do I limit the select results returned so that I get no more than one
of
>
> each property record?
>
> SELECT p.propertyid, p.name, c.name AS city
> FROM property p
>  INNER JOIN property_city pc ON pc.propertyid = p.propertyid
>
>
> property
> --
> propertyid
> name
>
> city
> --
> cityid
> name
>
> property_city
> --
> propertyid
> cityid
>
>
>
>
> 



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

RE: Query Help

[Matthew Walker]

I think Jim wants to output just one row even if there is more than one
city. So the city that is output is an arbitrary selection from the
associated cities. Your solution still outputs one row for each city. 

-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 6 September 2005 10:45 a.m.
To: CF-Talk
Subject: Re: Query Help

SELECT DISTINCT p.propertyid, p.name, c.name AS city
FROM property p
 INNER JOIN property_city pc ON pc.propertyid = p.propertyid

DISTINCT is all you need.

On 9/5/05, Jim McAtee <[EMAIL PROTECTED]> wrote:
> I have a number of real estate properties, each associated with one or
> more city.  If I select by specifying a city then I get a list of
unique
> properties.  But if I do a broader select, then I get duplicates of
the
> property record when a record is assocuated with two or more cities.
How
> do I limit the select results returned so that I get no more than one
of
> each property record?
> 
> SELECT p.propertyid, p.name, c.name AS city
> FROM property p
>   INNER JOIN property_city pc ON pc.propertyid = p.propertyid
> 
> 
> property
> --
> propertyid
> name
> 
> city
> --
> cityid
> name
> 
> property_city
> --
> propertyid
> cityid
> 
> 
> 



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

RE: Query Help

[Matthew Walker]

SELECT p.propertyid, p.name, min(c.name) AS city
FROM property p
  INNER JOIN property_city pc ON pc.propertyid = p.propertyid
GROUP BY p.propertyid, p.name

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 6 September 2005 10:31 a.m.
To: CF-Talk
Subject: Query Help

I have a number of real estate properties, each associated with one or 
more city.  If I select by specifying a city then I get a list of unique

properties.  But if I do a broader select, then I get duplicates of the 
property record when a record is assocuated with two or more cities.
How 
do I limit the select results returned so that I get no more than one of

each property record?

SELECT p.propertyid, p.name, c.name AS city
FROM property p
  INNER JOIN property_city pc ON pc.propertyid = p.propertyid


property
--
propertyid
name

city
--
cityid
name

property_city
--
propertyid
cityid




~|
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:217392
Archives: http://www.houseoffusion.com/cf_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: getCallingTemplatePath()

[Matthew Walker]

> Aha! Yet another implementation of the getRelativePath() function...
> :) It makes me think perhaps there should be one native in CF.

Oh I totally agree there should be. 

> I believe you need to enable robust exception information in the CF
> Administrator before cfcatch will populate the tagcontext array.

Just tested this on CF7. While "Enable Robust Exception Information"
affects what gets dumped out on a regular error, it seems to make no
difference to the content of the cfcatch structure if you do this:









So that's good news for anybody who is using this nasty hack

~|
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:217389
Archives: http://www.houseoffusion.com/cf_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: getCallingTemplatePath()

[Matthew Walker]

This is how my custom tag for building forms TerraForm does it. There
are a couple of gotchas. 1) the order of the items in the stack trace is
reversed between CF5 and CFMX. 2) CFMX6.1 (and 7 I think) has a few
entries in the stack trace where the template is just the drive letter,
so you just skip these ones. This code looks rather fragile and I dread
the day it stops working

Here's the TF code:
























   




 






   















   






-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Sunday, 4 September 2005 4:46 a.m.
To: CF-Talk
Subject: Re: getCallingTemplatePath()

I've always handled this by throwing an exception, catching the error,
and examining the stack trace.  Hardly elegant, but suits the need. 
Just wrap the functionality up in another custom tag that simply
returns the full call stack, and then the code that calls the custom
tag can figure out what piece it needs (the one directly 'above'
getCurrentTemplatePath(), in this case).

cheers,
barneyb

On 9/2/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> I could be going crazy, but I could swear I remembered reading that
> someone had broken the black-magic code that would allow you to get
> the value of getCurrentTemplatePath() from the calling template within
> a custom tag...
> 
> This just became important at my day job actually ... we (or my boss
> rather) implemented a custom tag for handling client customizations
> which swaps out sections of the calling code with customized code for
> the client (it's not how I prefer to handle this problem personally,
> but I have to admit it's more elegant than most of the solutions I've
> seen)... but for this to work it needs to know what the path of the
> calling template is... Right now we're using
> 
>  default="#getBaseTemplatePath()#">
> 
> Which works, but the base template isn't always the template being
> customized, so in the event that we have an included file or another
> custom tag, we then have to explicitly declare  path="#getCurrentTemplatePath()#"> -- even tho that attribute will
> _never_ contain any value other than that function call, and it's
> really annoying since presumably, the CF server _must_ know what the
> path to that template was in order to function (because it maps those
> paths to the generated java classes).
> 
> Anybody have any insight into this?
> 
> s. isaac dealey 954.522.6080
> new epoch : isn't it time for a change?
> 
> add features without fixtures with
> the onTap open source framework
> 
-- 
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:217332
Archives: http://www.houseoffusion.com/cf_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: Paging through records

[Matthew Walker]

Actually there doesn't seem to be a BOTTOM in Access or SQL Server.
Instead of BOTTOM 50, select TOP 50 but reverse the order by clause
(i.e. ORDER BY my DESC, column DESC, list DESC .



-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 31 August 2005 9:16 a.m.
To: CF-Talk
Subject: Re: Paging through records

> In MS SQL and Access, there is the TOP clause to limit the
> number of records, but I'm not sure if and how you can set
> the first one.

SELECT BOTTOM 50 * FROM mytable
WHERE mytable_id IN
(SELECT TOP 100 mytable_id FROM mytable
ORDER BY my, column, list)
ORDER BY my, column, list

The order by clause must be the same in both the outer and sub-query.

> In Oracle, there is ROWNUM...

Yeah, but that's not how you get a set out of the middle with Oracle,
'cause if you specify a minimum value for rownum you don't get the
expected results... well... not by itself... In oracle you use the
MINUS clause, which is surprisingly efficient... but... I still don't
recommend using it, just because I advocate db independance.

SELECT * FROM mytable WHERE rownum < 100
ORDER BY my, column, list

MINUS SELECT * FROM mytable WHERE rownum > 50
ORDER BY my, column, list

. I haven't used this recently, so I'm not certain the order by
clauses are in the right place, but that's the gist of it.


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

add features without fixtures with
the onTap open source framework

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






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

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216945
Archives: http://www.houseoffusion.com/cf_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: determining darkness/lightness of hex colors

[Matthew Walker]

Try this: http://www.cflib.org/udf.cfm?ID=322 

You can then consider the "L" portion of the result. If it's 128 or
greater, use dark; if 127 or less, use light. 


-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 17 August 2005 10:46 a.m.
To: CF-Talk
Subject: SOT: determining darkness/lightness of hex colors

Hey gang,

I've done some Googling on this but haven't found anything helpful.

I'm looking for a way to determine, for lack of better terms, the 
darkness/lightness of a particular hex color, so as to determine whether

to use light or dark text above it so that the text doesn't get lost in 
the color beneath.

Any nudges in the right direction (custom tag, algorithm, etc.) would 
simply rock.

Thanks much -
--Scott



~|
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:215724
Archives: http://www.houseoffusion.com/cf_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: squares in QoQ

[Matthew Walker]

No, it doesn't. 

What's I'm doing is locating coordinate points that are within a certain
range of a specified other point, hence the calculation. I have opted to
get SQL Server to find all the points within a box around the reference
point, and to do the squares calculation. Then I'm using QoQ to turn the
square subset into a circular subset around the reference point (so QoQ
no longer needs to calculate the Hypotenuse as it is one of the
columns).

I don't actually have any idea whether this is efficient as I don't have
enough data points to work with yet. Intuitively, I feel that getting
SQL Server to find the points in a box (simply using BETWEEN operators)
should perform better than asking it to calculate the hypotenuse for
every single record. I figure that this way it only needs to calculate
the hypotenuse for records within the box. 

-Original Message-
From: Short Fuse Media [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 10 August 2005 3:45 a.m.
To: CF-Talk
Subject: Re: squares in QoQ

Haven't tested it, but does the Sqr function work in this case?

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/h
tml/wwhelp.htm?href=0870.htm

Erik Yowell
Short Fuse Media, Inc.

Matthew Walker wrote:

>I notice the power operator doesn't seem to work inside
>query-of-queries. For example:
>
> 
>
>WHERE (#params.x# - x)^2 + (#params.y# - y)^2 < #params.range^2#
>
> 
>
>The third one actually does work as CF evaluates it before processing
>the query code. The first and second don't work as they are part of the
>SQL. I can of course just use a multiplication operator. But I was
>wondering if there's any info about on what operators are supported  in
>QoQ (this is CF7). 
>
>
>
>



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

squares in QoQ

[Matthew Walker]

I notice the power operator doesn't seem to work inside
query-of-queries. For example:

 

WHERE (#params.x# - x)^2 + (#params.y# - y)^2 < #params.range^2#

 

The third one actually does work as CF evaluates it before processing
the query code. The first and second don't work as they are part of the
SQL. I can of course just use a multiplication operator. But I was
wondering if there's any info about on what operators are supported  in
QoQ (this is CF7). 



~|
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:214125
Archives: http://www.houseoffusion.com/cf_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: "or" operator in WHERE statement

[Matthew Walker]

You're using Access right? CASE is not supported. You can use iif()
though -- syntax is pretty much the same as in CF. 

-Original Message-
From: Roberto Perez [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 21 July 2005 11:31 a.m.
To: CF-Talk
Subject: RE: "or" operator in WHERE statement

Taco, I'd like to explore your CASE option further, but the more I read
on CASE the less clear it is to me what the syntax could look like. Care
to post a more complete example?


~|
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:212359
Archives: http://www.houseoffusion.com/cf_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: "or" operator in WHERE statement

[Matthew Walker]

This (http://www.pcreview.co.uk/forums/thread-1138891.php) seems to suggest
that UNION ALL might be your answer.


-Original Message-
From: Roberto Perez [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 21 July 2005 6:58 a.m.
To: CF-Talk
Subject: RE: "or" operator in WHERE statement

On 07/19/2005 10:12 PM Mathew Walker wrote:
>I'd go with a UNION. The reason a union is useful is that you want
B.content
>and C.content to appear as the same column in your record set, which is
what
>a union does well.


Thanks for your answer. I tried the UNION and it did what I wanted (it
pulled the "content" field from either the B table or the C table based on
the value of the 'status" field in the A table).

However, when I output the "content" field with:

CFOUTPUT   #QueryName.content#   /CFOUTPUT 

..the output shows only the first 255 characters of the "content" field
(the maximum length for an Access text field), although the field is set to
"memo" in both tables B and C. Can this be fixed, or is it a limitation of
UNION?

Thanks,

Roberto



~|
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:212353
Archives: http://www.houseoffusion.com/cf_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: "or" operator in WHERE statement

[Matthew Walker]

I'd go with a UNION. The reason a union is useful is that you want B.content
and C.content to appear as the same column in your record set, which is what
a union does well. Note that with unions, the order you list the columns and
the number of columns is critical. Also only add one ORDBER BY clause if you
need it right at the end.

SELECT A.status, B.content
FROM A INNER JOIN B
ON A.status=B.status 

UNION

SELECT A.status, C.content
FROM A INNER JOIN C
ON A.status=C.status



-Original Message-
From: Roberto Perez [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 20 July 2005 11:21 a.m.
To: CF-Talk
Subject: "or" operator in WHERE statement

Hi all,

Quick question: is "OR" a valid operator in a WHERE statement?

I have a main table A with a 'status' field which value can be either 'open'
or 'closed'. Then I have a table B where the 'status' field is 'open' by
default (not editable), and a table C where the 'status' field is 'closed'
by default (not editable).

I thought that if my WHERE statement was:

WHERE A.status = B.status OR A.status = C.status

..I would get data from either B or C, according to the value of 'status'
in table A. In other words, I though if the first condition was not met, the
second condition would be parsed and executed. But what happens is that the
field that is defined first in the SELECT statement is the one that is
always displayed in my output, regardles of whether the value of 'status' in
table A is 'open' or 'closed'.

If OR is not a possible operator, any idea how to achieve what I'm trying to
do (i.e., for the query to bring data from one table or the other according
to the value of a single shared field)? I tried joins with no good results
either...

Thanks in advance,

Roberto Perez



~|
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:212279
Archives: http://www.houseoffusion.com/cf_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: Daily DB updates from CSV files

[Matthew Walker]

Note that cfhttp can do this automatically. You need to make sure your CSV
is valid -- qualifiers around any fields containing the delimiter in the
data (i.e. quotes around any data containing commas), and escape any
qualifiers in the data (i.e. double up any quotes in the data).

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h
tml/wwhelp.htm?context=ColdFusion_Documentation&file=0272.htm 

>From the docs

Building a query from a delimited text file
The cfhttp tag can create a ColdFusion query object form the response body.
To do so, the response body must consist of lines of text, with each line
having fields that are delimited by a character that identifies the column
breaks. The default delimiter is a comma (,). The response data can also use
a text qualifier; the default is a double-quotation mark ("). If you
surround a string field in the text qualifier, the field can contain the
delimiter character. To include the text qualifier in field text, escape it
by using a double character. The following line shows a two-line request
body that is converted into a query. It has three comma-delimited fields:

Field1,Field2,Field3
"A comma, in text","A quote: ""Oh My!""",Plain text

Run the following code to show how ColdFusion treats this data:




Column names can be specified in three ways: 

By default, ColdFusion uses the first row of the response as the column
names. 
If you specify a comma-delimited columns attribute, ColdFusion uses the
names specified in the attribute as the column names. Set
firstRowAsHeaders="no" if the first row of the response contains data.
Otherwise, ColdFusion ignores the first row. 
If you do not specify a columns attribute and set firstrowasheaders="no",
ColdFusion generates column names of the form Column_1, Column2, etc. 
The cfhttp tag checks to ensure that column names in the data returned by
the tag start with a letter and contain only letters, numbers, and
underscore characters (_).

ColdFusion checks for invalid column names. Column names must start with a
letter. The remaining characters can be letters, numbers, or underscores
(_). If a column name is not valid, ColdFusion generates an error.




-Original Message-
From: Ken [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 19 July 2005 10:26 a.m.
To: CF-Talk
Subject: Daily DB updates from CSV files

Hi. I building a coldfusion app to upload the contents of a huge csv
file (9 cols x 22000 rows). I am facing a few issues though.
1. A lot the cells in the csv are blank at times, producing 2 commas
together, that messes up my entire array.

2. the prsence of commas in my data also creates an issue when trying
to sparate individual pieces if data to be uploaded to the DB.

Any ideas, please. Example Code preferred.

- Ken



~|
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:212175
Archives: http://www.houseoffusion.com/cf_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: Number formatting issue

[Matthew Walker]

If you use numberFormat() without a mask, it rounds to the nearest integer
(which I think is silly). If you use decimalFormat() or dollarFormat(), it
rounds to two decimal places. The standard way of rounding a 5 is to round
it up. If you want it to round down, you could do this:

int(num*100)/100


-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED] 
Sent: Monday, 18 July 2005 9:17 a.m.
To: CF-Talk
Subject: Number formatting issue

Guys,

I have a number that looks like this. 22.995

But everytime I use DollarFormat() or NumberFormat, it rounds it up to 
23.00. I need the value to display as 22.99 not 23.00. How do I get 
around this? I could just treat the value as a string and cut off the 
trailing "5" but why are the number formatting functions rounding my 
value up?

This is on CF 5.

Rey...

-- 
http://www.ReyBango.com




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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212084
Archives: http://www.houseoffusion.com/cf_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: cfbreak in cfswitch in CFMX 7?

[Matthew Walker]

Do you mean to stop each successive cfcase from executing? You don't need to
do that in cfswitch, only in the cfscript switch().


-Original Message-
From: Johnny Le [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 12 July 2005 2:12 p.m.
To: CF-Talk
Subject: cfbreak in cfswitch in CFMX 7?

Hi,

CFbreak doesn't seem to work in cfswitch in CF 7 any more.  What tag do you
use to break out of cfswitch now?

Johnny



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

[Matthew Walker]

Here's what I'd suggest...

1) Learn how to use CFCs properly. Place your business logic in CFCs and
then build your display pages to call your CFCs. 

2) Next learn how to write custom tags with start and end tags like this:

...content...

And use them to build layout elements such as boxes and columns (this might
not be very useful depending what you are doing). The trick to this is
understanding thisTag.executionMode and thisTag.generatedContent.

3) Run your entire site through one file (index.cfm) with a parameter passed
in the URL that controls what happens. Place a big cfswitch in this file. 

That may be all the framework you need. If not, it's a good point to begin
at. 



-Original Message-
From: Kevin Rosenthal [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 5 July 2005 1:14 p.m.
To: CF-Talk
Subject: Newbie Question

Greetings,

 

I am new to ColdFusion and just started to learn. Before I get set in my
ways, I have read many posts about things like Fuse Builder and other module
building blocks for creating applications. My question is which one would be
the easiest to learn and is it a good practice to use one or would creating
my own components and such would be just as good?

 

Thanks,

Kevin

 


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.12/46 - Release Date: 7/11/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:211599
Archives: http://www.houseoffusion.com/cf_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: Brain Freeze

[Matthew Walker]

WHERE Product_ID IN (0#valueList(PRODCAT.Product_ID)#)

Best to use cfqueryparam of course.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, 4 July 2005 7:08 a.m.
To: CF-Talk
Subject: Brain Freeze

All,

I've got three queries all passing variables from previous queries. The
issues? 
The second query returns 4 records.  I want to use IDs for these records in
query #3.
However what I have only returns only 1 record. I want all 4 ID values in
query #3




SELECT Categories.Name, Categories.Category_ID 
FROM Categories




SELECT ID, Product_ID, Category_ID 
FROM Product_Category
WHERE Category_ID = #CATS.Category_ID#


SELECT NAME 
FROM Products
WHERE Product_ID = #PRODCAT.Product_ID#

Thanks

D



~|
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:211092
Archives: http://www.houseoffusion.com/cf_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: Delete spaces inside form fields vars

[Matthew Walker]

You seem to be asking for all spaces in submitted values to be removed, yet
your code seems to be changing all double-spaces to single spaces. What
exactly do you want?

Also, your syntax is a bit confusing. I'd write what you have as follows:





However your code probably wouldn't catch triple spaces, in which case I'd
write:





Question is -- what are you trying to achieve?


~|
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:210992
Archives: http://www.houseoffusion.com/cf_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: AutoTab Through Forms?

[Matthew Walker]

Check this out too:
http://www.pengoworks.com/workshop/js/mask/


-Original Message-
From: Claremont, Timothy [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 30 June 2005 9:41 a.m.
To: CF-Talk
Subject: AutoTab Through Forms?

Our data entry operator would like the screen to auto tab to the next
field when finished inputting data. This is especially true of date
fields. So, once two digits are entered into the month field, auto tab
to the day field, etc.


Barring that, what is the best way to set up a date field for data
entry, like the forms where the / marks between the month/day, and the
day/year are pre-populated?

When I set the format of the field to date, it objects when I enter
120504 or 12-05-04. It only wants 12/05/04. Speed of data entry is the
objective here.

Is there a clean way to do this?

CFMX6.1 is the platform.

TIA,
Tim

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

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

Thank You,
Viahealth
**




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

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

RE: OT sql with like as variable

[Matthew Walker]

Even if they did work, you would get false matches: e.g. 34 would match
a search for 3. In the second case you could write perhaps
',' + listofids + ',' LIKE '%,' + id + ',%'
but it ain't pretty.


-Original Message-
From: DRE [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 29 June 2005 11:00 a.m.
To: CF-Talk
Subject: OT sql with like as variable

Hey, I thought I had this down but I'm having a bit of a problem

Consider a table like so.
id, listofids
"33","33,44,55,66"
"rr","rr,gg,cc,dd"
"xx","zz,ee,rr"

I'm trying to get a list of all the records where the value of the
first is somewhere in the second.

I'm thinking
SELECT 
id,
listofids,
FROM 
table
WHERE 
CHARINDEX(id ,listofids) <> 0

Or perhaps 

SELECT 
id,
listofids
FROM 
gv_locations
WHERE 
',' + listofids + ',' LIKE '%' + id + '%'

But neither returns any records.

Any ideas?

Thanks. Andre


-- 
DRE
www.webmachineinc.com
www.theanticool.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:210839
Archives: http://www.houseoffusion.com/cf_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: CF5 Regex Backreferences

[Matthew Walker]

yes but they are \1, \2, etc.
http://livedocs.macromedia.com/coldfusion/5.0/Developing_ColdFusion_Applicat
ions/regexp5.htm 

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 28 June 2005 10:37 a.m.
To: CF-Talk
Subject: CF5 Regex Backreferences

In CF5 are backreferences ($1, $2, etc.) available for use in REReplace(), 
or do you have to do an REFind() and then use the array returned if 
returnsubexpressions is set to TRUE? 




~|
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:210686
Archives: http://www.houseoffusion.com/cf_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: tips on onSessionEnd( )

[Matthew Walker]

Can't you simply invoke it? 


-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 21 June 2005 8:27 a.m.
To: CF-Talk
Subject: tips on onSessionEnd( )

Does anyone have any clever tricks for debugging onSessionEnd( ) in the
application.cfc file?  Right now I'm changing my session timeout to 10
seconds and emailing myself dumps of the scopes. It works but it is not
pretty . Is there a way to call this function directly?

-Mark

Mark A. Kruger, CFG, MCSE
www.cfwebtools.com
www.necfug.com
http://mkruger.cfwebtools.com






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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210029
Archives: http://www.houseoffusion.com/cf_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: A Test for Division by Zero a SQL Query...

[Matthew Walker]

Should work in PostgreSQL and MS SQL...

CASE 
WHEN (Indx.Net_Exp_Starts > 0)
THEN (Indx.Inv/Indx.Net_Exp_Starts)
ELSE 0
END AS Yield

-Original Message-
From: Gonzo Rock [mailto:[EMAIL PROTECTED] 
Sent: Friday, 17 June 2005 12:15 p.m.
To: CF-Talk
Subject: A Test for Division by Zero a SQL Query...

Select (Indx.Inv/Indx.Net_Exp_Starts) AS Yield from Indx Blows up when
Net_Exp_Starts = 0  with a Division by Zero SQL Error in postgreSQL
and MSSQL.

Does anyone know how can I return 0 as the yield when the divisor is 0?

Thanks s much,
Gonz



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