RE: Date Formats

2006-01-24 Thread 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... cfqueryparam

RE: Date Formats

2006-01-24 Thread 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

RE: FCK Editor 2.2

2006-01-18 Thread 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

RE: Professional Opinions on HostMySite.com

2006-01-10 Thread 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

RE: Professional Opinions on HostMySite.com

2006-01-10 Thread 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,

RE: Robots.txt - - best practices

2006-01-09 Thread 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 - -

RE: Preventing auto-fill

2006-01-09 Thread Matthew Walker
input autocomplete=off ... -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

RE: Problem with Alagad Image Component

2006-01-08 Thread Matthew Walker
It's an error in the CFC. Search for this line: cfif arguments.y LT 0 OR arguments.x GTE getHeight() Replace with: cfif arguments.y LT 0 OR arguments.y GTE getHeight() -Original Message- From: Michael Clayton [mailto:[EMAIL PROTECTED] Sent: Monday, 9 January 2006 10:16 a.m. To:

RE: 3D bar chart question

2006-01-05 Thread 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

RE: Accounting for Unknown Number of Loops

2005-12-27 Thread 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: cfset var myQuery = Where myQuery is the new name you choose for the query

RE: Accounting for Unknown Number of Loops

2005-12-27 Thread Matthew Walker
I think you need to change CFOUTPUT#getSubCategories(CatID)#/CFOUTPUT to cfset temp = temp getSubCategories(CatID) And you also need to set temp as a local var in your function by placing cfset var temp = neat the top. You should always do that when working with vars inside functions, and

RE: Appending a variable to another variable

2005-12-22 Thread Matthew Walker
All variables are part of a variable scope. When you write cfset name=Mark you are actually writing shorthand for cfset variables.name = Mark or cfset variables[name] = Mark That's all very well, but the shorthand breaks down if you want to use dynamic variable names (and the dotted notation

RE: Which page called my custom tag

2005-12-20 Thread 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. cftry cfthrow cfcatch cfdump var=#cfcatch# /cfcatch /cftry -Original Message- From: jonese

RE: RSS looks ok but not ok

2005-12-15 Thread 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

RE: Performance Problem - Client Variables

2005-12-15 Thread 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

RE: Performance Problem - Client Variables

2005-12-15 Thread Matthew Walker
AND name IN (cfqueryparam value=#lCase(arguments.names)# cfsqltype=CF_SQL_VARCHAR list=Yes) /cfquery cfreturn this /cffunction /cfcomponent -Original Message- From: Matthew Walker Sent: Friday, 16

RSS looks ok but not ok

2005-12-14 Thread 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=browselayout=rss Here's what the validator sees at the end: /item /channel /rss headtitleJRun Servlet

RE: RSS looks ok but not ok

2005-12-14 Thread Matthew Walker
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

RE: RSS looks ok but not ok

2005-12-14 Thread Matthew Walker
. 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

RE: backslash-digit interpreted in strings

2005-12-14 Thread 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.

RE: What am I missin' here with this cfparam??

2005-12-12 Thread 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

RE: local date time minus 17 hours

2005-12-11 Thread 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

RE: local date time minus 17 hours

2005-12-11 Thread Matthew Walker
(), application.environment.timeZone) -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

RE: SQL Dates

2005-12-08 Thread Matthew Walker
Try cfqueryparam value=#now()# cfsqltype=CF_SQL_TIMESTAMP 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

RE: Employee name

2005-12-06 Thread 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)

RE: cfabort

2005-12-05 Thread 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

RE: pseudo-memory leak

2005-11-28 Thread 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

RE: pseudo-memory leak

2005-11-28 Thread 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

RE: Using request var in CFC - was : FREE Homesite/CF Studio CFC VTML Generator

2005-11-28 Thread Matthew Walker
Just pass it in as an argument. cfset obj = createObject(component, mycfc).init(datasource=myDatasource) 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

RE: Query of Queries (QoQ) performance question

2005-11-24 Thread 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

RE: punctuation in a URL variable

2005-11-22 Thread 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)#

RE: JavaScript Autofill

2005-11-21 Thread 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

RE: JavaScript Autofill

2005-11-21 Thread 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

RE: CSS table-type layout

2005-11-21 Thread 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

RE: wraptext in cfmail

2005-11-20 Thread 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

RE: wraptext in cfmail

2005-11-20 Thread 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

RE: CFMX 7 CFMODULE

2005-11-20 Thread 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

RE: CFMX 7 CFMODULE

2005-11-20 Thread Matthew Walker
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

RE: cfinclude from a template, or onRequestStart?

2005-11-09 Thread Matthew Walker
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 cf-talk@houseoffusion.com

RE: Query of Queries Subquery

2005-11-09 Thread Matthew Walker
Is cstSpecialZip another query record set? How about... cfquery name=Minneapolis dbtype=Query SELECT* FROM OOrder Where zip IN (cfqueryparam value=0#valueList(cstSpecialZip.zip)# cfsqltype=CF_SQL_INTEGER list=Yes) /cfquery In case you're wondering, the 0 will catch empty

RE: Before and after decimals.

2005-11-08 Thread 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

RE: i18n best practice - multiple lang, multiple labels

2005-11-08 Thread 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

RE: cfinclude from a template, or onRequestStart?

2005-11-08 Thread 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

RE: Difficult Sort - Theory

2005-11-08 Thread Matthew Walker
: 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

RE: i18n best practice - multiple lang, multiple labels

2005-11-08 Thread 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

RE: onSessionEnd Error on 7.01

2005-11-07 Thread 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

RE: Difficult Sort - Theory

2005-11-07 Thread 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...

RE: XOR

2005-11-03 Thread 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: cfif not (isSmoker and isBlueHair) Winner! /cfif I suppose in dating there could only be so much tolerance. I could tolerate a smoker, or

RE: XOR

2005-11-03 Thread 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

RE: Cfchart hanging

2005-11-03 Thread 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

RE: How to recognize robots

2005-10-30 Thread 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.

RE: Inline frames a good alternative for creating web applications?

2005-10-27 Thread 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

RE: Client/Session Variable: When to set?

2005-10-27 Thread 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

RE: Client/Session Variable: When to set?

2005-10-27 Thread 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

RE: Inline frames a good alternative for creating web applications?

2005-10-27 Thread 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

RE: Inline frames a good alternative for creating web applications?

2005-10-27 Thread 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

RE: Solved: Client/Session Variable: When to set?

2005-10-27 Thread 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

RE: Inline frames a good alternative for creating web applications?

2005-10-27 Thread 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

RE: Custom Tag with auto cfoutput

2005-10-24 Thread 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

RE: CFC - separate or all in one?

2005-10-20 Thread 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

RE: Displaying currencies

2005-10-20 Thread 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: cfset pageLocale = getLocale() cfset setLocale(Japanese) cfoutput#lsCurrencyFormat(12.34)#/cfoutput cfset setLocale(pageLocale) -Original

RE: CFC - separate or all in one?

2005-10-20 Thread 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

RE: OT Joins

2005-10-19 Thread 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.

RE: CFDocument font probs

2005-10-18 Thread 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

RE: Verity and Asian languages

2005-10-16 Thread 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

Verity and Asian languages

2005-10-12 Thread 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 http://www.macromedia.com/go/verity ) (the instructions for these btw specify the wrong file location, also the file sizes

RE: Replace String

2005-09-14 Thread Matthew Walker
Isaac you crazy guy! #ReplaceList(myString, token1,/token1token2,/token2, 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

RE: Query in application.cfm

2005-09-14 Thread 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... cfif not

RE: block forms from being filled out automatically

2005-09-13 Thread 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

RE: Interface Question

2005-09-11 Thread 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

RE: CFMail Errors when mass mailing (not spam)

2005-09-11 Thread 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

RE: Have brain lock, need schema/query help!

2005-09-06 Thread 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

RE: Have brain lock, need schema/query help!

2005-09-06 Thread 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

RE: getCallingTemplatePath()

2005-09-05 Thread 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

RE: Query Help

2005-09-05 Thread 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

RE: Query Help

2005-09-05 Thread 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,

RE: Query Help

2005-09-05 Thread Matthew Walker
. - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com 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

RE: getCallingTemplatePath()

2005-09-05 Thread 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

RE: CF Spider/Screen Scrape

2005-09-05 Thread 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

RE: getCallingTemplatePath()

2005-09-05 Thread 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

RE: CF Spider/Screen Scrape

2005-09-05 Thread Matthew Walker
Thanks. How do I get started with the monitoring service? Any pointers? Ben - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 06, 2005 12:10 PM Subject: RE: CF Spider/Screen Scrape Yes you can do this in CF

RE: getCallingTemplatePath()

2005-09-04 Thread 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

RE: Paging through records

2005-08-30 Thread 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

RE: determining darkness/lightness of hex colors

2005-08-18 Thread 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

squares in QoQ

2005-08-09 Thread 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

RE: squares in QoQ

2005-08-09 Thread Matthew Walker
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

RE: or operator in WHERE statement

2005-07-20 Thread 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

RE: or operator in WHERE statement

2005-07-20 Thread 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,

RE: or operator in WHERE statement

2005-07-19 Thread 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

RE: Daily DB updates from CSV files

2005-07-18 Thread 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).

RE: Number formatting issue

2005-07-17 Thread 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

RE: Newbie Question

2005-07-11 Thread 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: container:box ...content... /container:box And use them to build

RE: cfbreak in cfswitch in CFMX 7?

2005-07-11 Thread 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,

RE: Brain Freeze

2005-07-03 Thread 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

RE: Delete spaces inside form fields vars

2005-06-30 Thread 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: cfloop collection=#form# item=field cfset

RE: AutoTab Through Forms?

2005-06-29 Thread 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

RE: OT sql with like as variable

2005-06-28 Thread 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

RE: CF5 Regex Backreferences

2005-06-27 Thread 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

RE: tips on onSessionEnd( )

2005-06-20 Thread Matthew Walker
Can't you simply invoke it? cfinvoke component=Application method=onSessionEnd -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

RE: A Test for Division by Zero a SQL Query...

2005-06-16 Thread 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

  1   2   3   4   5   6   7   8   9   10   >