[cfaussie] Flex 2
You those of you that are interested Flex 2 is now available from the Adobe site. http://www.adobe.com/products/flex/?promoid=BINV Brian Knott --- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Flex 2
as well as the Coldfusion 7 update ...http://www.adobe.com/support/coldfusion/downloads_updates.html#mx7 On 28/06/06, KNOTT, Brian [EMAIL PROTECTED] wrote: You those of you that are interested Flex 2 is now available from the Adobe site. http://www.adobe.com/products/flex/?promoid=BINV Brian Knott --- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Comparing names between databases
HI all, I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other. Speed is not an issue - this is not a public site. The only thing I can think of is to loop through one table and on each record, loop through the other table to find matches. I would love to hear any thoughts about different ways of doing this. Thanks, Tom -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Comparing names between databases
what database platform? -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 5:16 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Comparing names between databases HI all, I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other. Speed is not an issue - this is not a public site. The only thing I can think of is to loop through one table and on each record, loop through the other table to find matches. I would love to hear any thoughts about different ways of doing this. Thanks, Tom -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Comparing names between databases
mySQL On 6/28/06, Steve Onnis [EMAIL PROTECTED] wrote: what database platform? -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 5:16 PM To: cfaussie@googlegroups.comSubject: [cfaussie] Comparing names between databases HI all, I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other. Speed is not an issue - this is not a public site. The only thing I can think of is to loop through one table and on each record, loop through the other table to find matches. I would love to hear any thoughts about different ways of doing this. Thanks, Tom -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Comparing names between databases
How about a join? SELECT table1.* FROM table1, table2 WHERE table1.name = table2.name Or something along those lines. From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tom MacKeanSent: Wednesday, 28 June 2006 5:20 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Comparing names between databases mySQL On 6/28/06, Steve Onnis [EMAIL PROTECTED] wrote: what database platform? -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 5:16 PM To: cfaussie@googlegroups.comSubject: [cfaussie] Comparing names between databases HI all, I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other. Speed is not an issue - this is not a public site. The only thing I can think of is to loop through one table and on each record, loop through the other table to find matches. I would love to hear any thoughts about different ways of doing this. Thanks, Tom -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Comparing names between databases
The thing is that the names come from two completely separate sources and one might be Harold Smith and one might be H J Smith. I've written a function (120 lines long)that does a pretty good job of returning yes, this is a match or no this is not a match. I can't see how you would recreate all the logic in an SQLquery. Tom On 6/28/06, Tom MacKean [EMAIL PROTECTED] wrote: mySQL On 6/28/06, Steve Onnis [EMAIL PROTECTED] wrote: what database platform? -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 5:16 PM To: cfaussie@googlegroups.comSubject: [cfaussie] Comparing names between databases HI all, I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other. Speed is not an issue - this is not a public site. The only thing I can think of is to loop through one table and on each record, loop through the other table to find matches. I would love to hear any thoughts about different ways of doing this. Thanks, Tom -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Comparing names between databases
You could use some SQL to compare just the surnames, stripped of any punctuation and spaces. Then run your function on the resultant data set. This should reduce the processing time somewhat. From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tom MacKeanSent: Wednesday, 28 June 2006 5:30 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Comparing names between databases The thing is that the names come from two completely separate sources and one might be Harold Smith and one might be H J Smith. I've written a function (120 lines long)that does a pretty good job of returning "yes, this is a match" or "no this is not a match". I can't see how you would recreate all the logic in an SQLquery. Tom On 6/28/06, Tom MacKean [EMAIL PROTECTED] wrote: mySQL On 6/28/06, Steve Onnis [EMAIL PROTECTED] wrote: what database platform? -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 5:16 PM To: cfaussie@googlegroups.comSubject: [cfaussie] Comparing names between databases HI all, I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other. Speed is not an issue - this is not a public site. The only thing I can think of is to loop through one table and on each record, loop through the other table to find matches. I would love to hear any thoughts about different ways of doing this. Thanks, Tom -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Comparing names between databases
Good thinking! That will definitely help. Thanks On 6/28/06, Ryan Sabir [EMAIL PROTECTED] wrote: You could use some SQL to compare just the surnames, stripped of any punctuation and spaces. Then run your function on the resultant data set. This should reduce the processing time somewhat. From: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com] On Behalf Of Tom MacKean Sent: Wednesday, 28 June 2006 5:30 PMTo: cfaussie@googlegroups.com Subject: [cfaussie] Re: Comparing names between databases The thing is that the names come from two completely separate sources and one might be Harold Smith and one might be H J Smith. I've written a function (120 lines long)that does a pretty good job of returning yes, this is a match or no this is not a match. I can't see how you would recreate all the logic in an SQLquery. Tom On 6/28/06, Tom MacKean [EMAIL PROTECTED] wrote: mySQL On 6/28/06, Steve Onnis [EMAIL PROTECTED] wrote: what database platform? -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 5:16 PM To: cfaussie@googlegroups.comSubject: [cfaussie] Comparing names between databases HI all, I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other. Speed is not an issue - this is not a public site. The only thing I can think of is to loop through one table and on each record, loop through the other table to find matches. I would love to hear any thoughts about different ways of doing this. Thanks, Tom -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Comparing names between databases
Its easy in MSSQL, you can just query 2 databases in the single query in mySQL, i would import it as a second table so your just working with the single database and just discard it when you have done what you need -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 6:01 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Comparing names between databases Good thinking! That will definitely help. Thanks On 6/28/06, Ryan Sabir [EMAIL PROTECTED] wrote: You could use some SQL to compare just the surnames, stripped of any punctuation and spaces. Then run your function on the resultant data set. This should reduce the processing time somewhat. From: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com] On Behalf Of Tom MacKean Sent: Wednesday, 28 June 2006 5:30 PMTo: cfaussie@googlegroups.com Subject: [cfaussie] Re: Comparing names between databases The thing is that the names come from two completely separate sources and one might be Harold Smith and one might be H J Smith. I've written a function (120 lines long)that does a pretty good job of returning "yes, this is a match" or "no this is not a match". I can't see how you would recreate all the logic in an SQLquery. Tom On 6/28/06, Tom MacKean [EMAIL PROTECTED] wrote: mySQL On 6/28/06, Steve Onnis [EMAIL PROTECTED] wrote: what database platform? -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 5:16 PM To: cfaussie@googlegroups.comSubject: [cfaussie] Comparing names between databases HI all, I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other. Speed is not an issue - this is not a public site. The only thing I can think of is to loop through one table and on each record, loop through the other table to find matches. I would love to hear any thoughts about different ways of doing this. Thanks, Tom -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying
[cfaussie] Re: Comparing names between databases
You could try looking up SOUNDEX String comparison for vaguely similar values (i.e. Spearsvs. Speresvs. Speares etc) http://databases.about.com/od/development/l/aasoundex.htm Under SOUNDEX in the mySQL docos they have interesting syntax WHERE t1.name SOUNDS LIKE t2.name http://dev.mysql.com/doc/refman/5.0/en/string-functions.html You could also try left and right functions for getting intials etc My two cents Joel -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Tom MacKeanSent: Wednesday, 28 June 2006 6:01 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Comparing names between databases Good thinking! That will definitely help. Thanks On 6/28/06, Ryan Sabir [EMAIL PROTECTED] wrote: You could use some SQL to compare just the surnames, stripped of any punctuation and spaces. Then run your function on the resultant data set. This should reduce the processing time somewhat. From: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com] On Behalf Of Tom MacKean Sent: Wednesday, 28 June 2006 5:30 PMTo: cfaussie@googlegroups.com Subject: [cfaussie] Re: Comparing names between databases The thing is that the names come from two completely separate sources and one might be Harold Smith and one might be H J Smith. I've written a function (120 lines long)that does a pretty good job of returning "yes, this is a match" or "no this is not a match". I can't see how you would recreate all the logic in an SQLquery. Tom On 6/28/06, Tom MacKean [EMAIL PROTECTED] wrote: mySQL On 6/28/06, Steve Onnis [EMAIL PROTECTED] wrote: what database platform? -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 5:16 PM To: cfaussie@googlegroups.comSubject: [cfaussie] Comparing names between databases HI all, I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other. Speed is not an issue - this is not a public site. The only thing I can think of is to loop through one table and on each record, loop through the other table to find matches. I would love to hear any thoughts about different ways of doing this. Thanks, Tom -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential
[cfaussie] Re: Web service / Java experts help required.
Hi Mathew,One thing you can do is to generate a SOAP message yourself and post it with CF. I am currently dealing with web services through Java 1.4 ( without Axis :-( ) and in the end, I have a Java class that wraps an XML node in a SOAP envelope and sends it off. The response that comes back is an XML string that you could parse with CF. You could even use CF to generate the XML very easily. A (very) rough base for the XML would be:?xml version=1.0 encoding=UTF-8? doSearchRequest keystring here.../key localEN_au/local styleMy style :-)/style countriesCovered soapenc:arrayType=xsd:string[] countryFR/country countryGB/country /countriesCovered attributes soapenc:arrayType=impl:Array_Of_Attributes[] attribute nameatt1name/name valuerandom value/value /attribute attribute nameatt2name/name valuenot so random value/value /attribute attribute nameatt3name/name value nil=true/ /attribute /attributes/doSearchRequest You need to check the names for the country and attribute arrays (it looks like the WSDL is incomplete but it is late and I could be wrong and I know it is a snippet). If you can get your hands on the xsd's for it it will really help as you can validate your XML against them. I know this isn't the way you would like to do it but it can overcome some of the problems with web services. At least this way you get to the lowest common denominator (XML!)Check out http://java.boot.by/wsd-guide/ch03s02.html for a quick and reference to the array stuff in the WSDL (XML side not CF).If you get stuck I wont be able to check this address from work so it could be a few days before I respond. Damn those systems guys and there proxies/firewalls! Hope that helps a you get a start.ShaneOn 6/27/06, Matthew wrote: Hi cfaussie,I've been on this one a while so any help would be kindlyappreciated I've broken my question down into 3 parts because someof you may not be arsed to read Question 3 (which is really long) so maybe if I solve 1 or 2 I'll crack this problem.=== QUESTION 1 ===How do I write the 2 lines of Java code below in CF to pass into a webservice?---String[] countriesCovered = null; Attribute[] attributes = null;-=== QUESTION 2 ===I've tried to solve this problem by consuming a simple web service. Ifthere are any web services experts out there please show yourself, and show me how to get the code below to work!!!---cfscriptws =CreateObject(webservice, http://www.weather.gov/forecasts/xml/SOAP_server/ndfdXMLserver.php?wsdl);NDFDgenResponse =ws.NDFDgen(JavaCast('double',38.99),JavaCast('double',-77.99),JavaCast('string','time-series'),DateFormat('2004-01-01','mm/dd/ hh:ss'),DateFormat('2010-06-26','mm/dd/ hh:ss'));/cfscriptcfdump var=#NDFDgenResponse#---ANd here's the error:---Web service operation NDFDgen with parameters { 38.99,-77.99,time-series,01/01/2004 12:00,06/26/2010 12:00} could not be found.---I'm certain that the problem here is how I'm passing in parameters.Weather it be a complex type or a date or whatever, I'm doing something wrong!Any ideas... anyone??!?!?!?=== QUESTION 3 ===The main problem I'm having is trying to pass complex parameters into aweb service (WS).Here is the latest error:--:::Error::: Unable to create web service argument class [Ljava.lang.String;.Error: java.lang.InstantiationException: [Ljava.lang.String;. Oftenthis is because the web service defines an iabstract/icomplexType as an input to an operation. You must create an actual instance ofthis type in Java.:::Here's my code:::cfscriptwebservice = CreateObject(webservice,url?wsdl); countriesCovered.France = JavaCast(string,FR);result = webservice.doSearch(JavaCast(string,123456),JavaCast(null,), JavaCast(null,), countriesCovered, JavaCast(null,));/cfscriptI've tried so many options (it feels like I can see the top of thehill :)) but I just can't get doSearch method to work. FYI: I've hadno problems getting strings returned from simple functions (where no input was required) but it's the complex functions which I can't getto work (like this doSearch method).Here's some snippets of the WSDL:--:::Snippet 1:::wsdl:types schema targetNamespace=soap.ws.web.raileurope.comimport namespace=http://schemas.xmlsoap.org/soap/encoding/ /complexType name=ArrayOf_xsd_stringcomplexContentrestriction base=soapenc:Arrayattribute ref=soapenc:arrayType wsdl:arrayType=xsd:string[]/ /restriction/complexContent/complexTypecomplexType name=Attributesequenceelement name=name nillable=true type=xsd:string/ element name=value nillable=true type=xsd:string//sequence/complexTypecomplexType name=ArrayOfAttribute complexContentrestriction base=soapenc:Arrayattribute ref=soapenc:arrayTypewsdl:arrayType=impl:Attribute[]//restriction /complexContent/complexType Snippet 2 :::wsdl:message name=doSearchResponsewsdl:part name=doSearchReturn type=impl:SearchResult/
[cfaussie] Re: Web service / Java experts help required.
You will need to have the right namespaces for the types as well or they wont validate.On 6/28/06, Shane Farmer [EMAIL PROTECTED] wrote:Hi Mathew,One thing you can do is to generate a SOAP message yourself and post it with CF. I am currently dealing with web services through Java 1.4 ( without Axis :-( ) and in the end, I have a Java class that wraps an XML node in a SOAP envelope and sends it off. The response that comes back is an XML string that you could parse with CF. You could even use CF to generate the XML very easily. A (very) rough base for the XML would be:?xml version=1.0 encoding=UTF-8? doSearchRequest keystring here.../key localEN_au/local styleMy style :-)/style countriesCovered soapenc:arrayType=xsd:string[] countryFR/country countryGB/country /countriesCovered attributes soapenc:arrayType=impl:Array_Of_Attributes[] attribute nameatt1name/name valuerandom value/value /attribute attribute nameatt2name/name valuenot so random value/value /attribute attribute nameatt3name/name value nil=true/ /attribute /attributes/doSearchRequest You need to check the names for the country and attribute arrays (it looks like the WSDL is incomplete but it is late and I could be wrong and I know it is a snippet). If you can get your hands on the xsd's for it it will really help as you can validate your XML against them. I know this isn't the way you would like to do it but it can overcome some of the problems with web services. At least this way you get to the lowest common denominator (XML!)Check out http://java.boot.by/wsd-guide/ch03s02.html for a quick and reference to the array stuff in the WSDL (XML side not CF).If you get stuck I wont be able to check this address from work so it could be a few days before I respond. Damn those systems guys and there proxies/firewalls! Hope that helps a you get a start.ShaneOn 6/27/06, Matthew wrote: Hi cfaussie,I've been on this one a while so any help would be kindlyappreciated I've broken my question down into 3 parts because someof you may not be arsed to read Question 3 (which is really long) so maybe if I solve 1 or 2 I'll crack this problem.=== QUESTION 1 ===How do I write the 2 lines of Java code below in CF to pass into a webservice?---String[] countriesCovered = null; Attribute[] attributes = null;-=== QUESTION 2 ===I've tried to solve this problem by consuming a simple web service. Ifthere are any web services experts out there please show yourself, and show me how to get the code below to work!!!---cfscriptws =CreateObject(webservice, http://www.weather.gov/forecasts/xml/SOAP_server/ndfdXMLserver.php?wsdl);NDFDgenResponse =ws.NDFDgen(JavaCast('double',38.99),JavaCast('double',-77.99),JavaCast('string','time-series'),DateFormat('2004-01-01','mm/dd/ hh:ss'),DateFormat('2010-06-26','mm/dd/ hh:ss'));/cfscriptcfdump var=#NDFDgenResponse#---ANd here's the error:---Web service operation NDFDgen with parameters { 38.99,-77.99,time-series,01/01/2004 12:00,06/26/2010 12:00} could not be found.---I'm certain that the problem here is how I'm passing in parameters.Weather it be a complex type or a date or whatever, I'm doing something wrong!Any ideas... anyone??!?!?!?=== QUESTION 3 ===The main problem I'm having is trying to pass complex parameters into aweb service (WS).Here is the latest error:-- :::Error::: Unable to create web service argument class [Ljava.lang.String;.Error: java.lang.InstantiationException: [Ljava.lang.String;. Oftenthis is because the web service defines an iabstract/icomplexType as an input to an operation. You must create an actual instance ofthis type in Java.:::Here's my code:::cfscriptwebservice = CreateObject(webservice,url?wsdl); countriesCovered.France = JavaCast(string,FR);result = webservice.doSearch(JavaCast(string,123456),JavaCast(null,), JavaCast(null,), countriesCovered, JavaCast(null,));/cfscriptI've tried so many options (it feels like I can see the top of thehill :)) but I just can't get doSearch method to work. FYI: I've had no problems getting strings returned from simple functions (where no input was required) but it's the complex functions which I can't getto work (like this doSearch method).Here's some snippets of the WSDL:--:::Snippet 1:::wsdl:types schema targetNamespace=soap.ws.web.raileurope.comimport namespace= http://schemas.xmlsoap.org/soap/encoding/ /complexType name=ArrayOf_xsd_stringcomplexContentrestriction base=soapenc:Arrayattribute ref=soapenc:arrayType wsdl:arrayType=xsd:string[]/ /restriction/complexContent/complexTypecomplexType name=Attributesequenceelement name=name nillable=true type=xsd:string/ element name=value nillable=true type=xsd:string//sequence/complexTypecomplexType name=ArrayOfAttribute complexContentrestriction base=soapenc:Arrayattribute
[cfaussie] Re: Flex 2
Once more with feeling please. The SDK is free. Builder is $$$ So what do I use with Eclipse? From:"Chris Velevitch" [EMAIL PROTECTED]Reply-To:cfaussie@googlegroups.comTo:cfaussie@googlegroups.comSubject:[cfaussie] Re: Flex 2Date:Wed, 28 Jun 2006 22:10:21 +1000On 6/28/06, Bjorn Schultheiss [EMAIL PROTECTED] wrote: Anyone got the cracks yet :)What are you talking about? It's free.Chris--Chris VelevitchManager - Sydney Flash Platform Developers Groupwww.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Comparing names between databases
A couple of year ago I wrote a little utility that was doing just that. but it was in vba (excel). I had two list with first name / last name that I had to match, and I used a whole bunch of silly algorithm. like so. 1. look for exact matches 2. look for exact same surname, and try to identify a nickname (like robert in one list, and bob in the other) 3. exact same surname, and same firstname except for one typo (using different flavour of left and right)... and so on. Each of these rules had a color coding, so when viewing the result you knew right away where your matches were. Once you've run it a few times, it becomes obvious that rules 1/2 are 100% accurate, and rule 3-5 still like 85+% accurate. I also remember building an index on the fly, which sped the whole thing considerably. Of course, with a DB, you wouldn't have to do that yourself. I remember that the next feature was going to be a keyboard-smart heuristic, whereby not only do you detect typo, but you also detect the more likely ones (like an a for an s). I should build this thing again, usig coldfusion, but between work, learning new stuff, and open source projects, I'm afraid I have no time :-/ tof On 6/28/06, Tom MacKean [EMAIL PROTECTED] wrote: HI all, I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other. Speed is not an issue - this is not a public site. The only thing I can think of is to loop through one table and on each record, loop through the other table to find matches. I would love to hear any thoughts about different ways of doing this. Thanks, Tom -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Comparing names between databases
Thanks everyone. Ryan's suggestion of filtering on lastname to begin with worked a treat. The page runs in about 5 seconds and does everything exactly as it should. Another satisfied cfaussie customer :) Tom On 6/29/06, christophe albrech [EMAIL PROTECTED] wrote: A couple of year ago I wrote a little utility that was doing just that. but it was in vba (excel). I had two list with first name / last name that I had to match, and I used a whole bunch of silly algorithm. like so. 1. look for exact matches 2. look for exact same surname, and try to identify a nickname (like robert in one list, and bob in the other) 3. exact same surname, and same firstname except for one typo (using different flavour of left and right)... and so on. Each of these rules had a color coding, so when viewing the result you knew right away where your matches were. Once you've run it a few times, it becomes obvious that rules 1/2 are 100% accurate, and rule 3-5 still like 85+% accurate. I also remember building an index on the fly, which sped the whole thing considerably. Of course, with a DB, you wouldn't have to do that yourself. I remember that the next feature was going to be a keyboard-smart heuristic, whereby not only do you detect typo, but you also detect the more likely ones (like an a for an s). I should build this thing again, usig coldfusion, but between work, learning new stuff, and open source projects, I'm afraid I have no time :-/ tof On 6/28/06, Tom MacKean [EMAIL PROTECTED] wrote: HI all, I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other. Speed is not an issue - this is not a public site. The only thing I can think of is to loop through one table and on each record, loop through the other table to find matches. I would love to hear any thoughts about different ways of doing this. Thanks, Tom -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Flex 2
dood its like 499 bucks...compared to microsofts crap! Unless your joking thenahahahahaha...your funny dood. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Includes
Kym, That doesnt work for us and I just discovered why. The application.cfm does NOT run when you also have an application.cfc We use application.cfc, so how can we include a function on every page using application.cfc model? Regards Dale Fraser --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
onRequestStart? -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Dale FraserSent: Thursday, 29 June 2006 12:16 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Includes Kym, That doesnt work for us and I just discovered why. The application.cfm does NOT run when you also have an application.cfc We use application.cfc, so how can we include a function on every page using application.cfc model? RegardsDale Fraser --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
On 6/29/06, Dale Fraser [EMAIL PROTECTED] wrote: Doing an CFINCLUDE in onRequestStart doesn't seem to do anything. That's the wrong place. Make your translation function a method of the Application.cfc (by either including it or placing the whole definition in the cfc). Then in the onRequest, create a reference to the function in variables scope so, as you wanted, it will keep the name short. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
Steve, Adding the tr function into application.cfc doesn't work, can't access it as application.tr Chris, Adding it and then doing the cfset also didn't work. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chris Velevitch Sent: Thursday, 29 June 2006 12:34 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes On 6/29/06, Dale Fraser [EMAIL PROTECTED] wrote: We use application.cfc, so how can we include a function on every page using application.cfc model? Try:- cfset variables.tr = this.tr in the onRequest method of Application.cfc and have the function included as a function in the Application.cfc Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
remember you need to restart the application for it to work -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dale Fraser Sent: Thursday, June 29, 2006 12:53 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Steve, Adding the tr function into application.cfc doesn't work, can't access it as application.tr Chris, Adding it and then doing the cfset also didn't work. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chris Velevitch Sent: Thursday, 29 June 2006 12:34 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes On 6/29/06, Dale Fraser [EMAIL PROTECTED] wrote: We use application.cfc, so how can we include a function on every page using application.cfc model? Try:- cfset variables.tr = this.tr in the onRequest method of Application.cfc and have the function included as a function in the Application.cfc Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
Yep, We had a reload option in our apps that fire onApplicationStart. I assume this is sufficient, but we did this and it didn't help Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Thursday, 29 June 2006 13:07 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes remember you need to restart the application for it to work -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dale Fraser Sent: Thursday, June 29, 2006 12:53 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Steve, Adding the tr function into application.cfc doesn't work, can't access it as application.tr Chris, Adding it and then doing the cfset also didn't work. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chris Velevitch Sent: Thursday, 29 June 2006 12:34 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes On 6/29/06, Dale Fraser [EMAIL PROTECTED] wrote: We use application.cfc, so how can we include a function on every page using application.cfc model? Try:- cfset variables.tr = this.tr in the onRequest method of Application.cfc and have the function included as a function in the Application.cfc Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
cfcomponent cffunction name=onRequest cfargument name=targetPage cfset variables.sayHi = this.sayHi cfinclude template=#targetPage# /cffunction cffunction name=sayHi cfreturn Hi /cffunction /cfcomponent In your file: cfoutput#sayHi()#/cfoutput This only works because we're including the target page, which will then be using the same variables scope we just injected the function into. Because onRequest (as opposed to onRequestStart) replaces the original request, it's standard practice to include the target page in the body of the onRequest function. Robin __ Robin Hilliard Director - RocketBoots Pty Ltd Consulting . Software Licensing . Recruitment . Training http://www.rocketboots.com.au For schedule/availability call Pamela Higgins: w+61 7 5451 0362 m+61 419 677 151 f+61 3 9923 6261 e[EMAIL PROTECTED] or Direct: m+61 418 414 341 e[EMAIL PROTECTED] *** Worldwide Adobe Licensing - Volume discounts now start at one point *** --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
Dale, I am not 100% sure but the onRequest might store it in the request scope. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Thursday, 29 June 2006 1:10 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Yep, We had a reload option in our apps that fire onApplicationStart. I assume this is sufficient, but we did this and it didn't help Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Thursday, 29 June 2006 13:07 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes remember you need to restart the application for it to work -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dale Fraser Sent: Thursday, June 29, 2006 12:53 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Steve, Adding the tr function into application.cfc doesn't work, can't access it as application.tr Chris, Adding it and then doing the cfset also didn't work. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chris Velevitch Sent: Thursday, 29 June 2006 12:34 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes On 6/29/06, Dale Fraser [EMAIL PROTECTED] wrote: We use application.cfc, so how can we include a function on every page using application.cfc model? Try:- cfset variables.tr = this.tr in the onRequest method of Application.cfc and have the function included as a function in the Application.cfc Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
ok had a bit of a play this is what i have come up with cffunction name=onApplicationStart cfset this.name = testApp / cfinclude template=function.cfm cfset application.udf = structNew() / cfloop collection=#variables# item=v cfif NOT listFindNoCase(onApplicationStart,onApplicationEnd,onRequestStart,onRequest End,onSessionStart,onSessionEnd,onError,onRequest, v) cfif isCustomFunction(variables[v]) cfset application.udf[v] = variables[v] / /cfif /cfif /cfloop /cffunction all your functions will then be available as application.udf.functionName Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Andrew Scott Sent: Thursday, June 29, 2006 1:15 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Dale, I am not 100% sure but the onRequest might store it in the request scope. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Thursday, 29 June 2006 1:10 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Yep, We had a reload option in our apps that fire onApplicationStart. I assume this is sufficient, but we did this and it didn't help Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Thursday, 29 June 2006 13:07 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes remember you need to restart the application for it to work -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dale Fraser Sent: Thursday, June 29, 2006 12:53 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Steve, Adding the tr function into application.cfc doesn't work, can't access it as application.tr Chris, Adding it and then doing the cfset also didn't work. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chris Velevitch Sent: Thursday, 29 June 2006 12:34 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes On 6/29/06, Dale Fraser [EMAIL PROTECTED] wrote: We use application.cfc, so how can we include a function on every page using application.cfc model? Try:- cfset variables.tr = this.tr in the onRequest method of Application.cfc and have the function included as a function in the Application.cfc Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
...and we're back to the start :) On 6/29/06, Joel Cass [EMAIL PROTECTED] wrote: Daleall you would need to do is put one line before your code:cfset tr= application.myUdf.tr-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com ]OnBehalf Of Dale FraserSent: Thursday, 29 June 2006 2:20 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesSteve,I could have done this just by doing cfset application.myUdf = createObjectIt defeats the purpose of what I want which is a short translation functionnameIeThe quick brown fox, jumps over the lazy dog.Becomes #tr(The quick brown fox)#, #tr(over the lazy dog)#Rather than#application.udf.tr(The quick brown fox)#, #application.udf.tr(over thelazy dog)# RegardsDale Fraser-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com ] On BehalfOf Steve OnnisSent: Thursday, 29 June 2006 13:50 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Includesokhad a bit of a play this is what i have come up withcffunction name=onApplicationStart cfset this.name = testApp / cfinclude template= function.cfm cfset application.udf = structNew() / cfloop collection=#variables# item=v cfif NOTlistFindNoCase(onApplicationStart,onApplicationEnd,onRequestStart,onRequest End,onSessionStart,onSessionEnd,onError,onRequest, v) cfif isCustomFunction(variables[v]) cfset application.udf[v] = variables[v] / /cfif /cfif /cfloop/cffunctionall your functions will then be available as application.udf.functionNameSteve -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]OnBehalf Of Andrew Scott Sent: Thursday, June 29, 2006 1:15 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesDale,I am not 100% sure but the onRequest might store it in the request scope. Senior Coldfusion DeveloperAegeon Pty. Ltd.www.aegeon.com.auPhone: +6138676 4223Mobile: 0404 998 273-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On BehalfOf Dale FraserSent: Thursday, 29 June 2006 1:10 PM To: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesYep,We had a reload option in our apps that fire onApplicationStart. I assumethis is sufficient, but we did this and it didn't help RegardsDale Fraser-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com ] On BehalfOf Steve OnnisSent: Thursday, 29 June 2006 13:07 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Includesremember you need to restart the application for it to work -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]OnBehalf Of Dale Fraser Sent: Thursday, June 29, 2006 12:53 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesSteve,Adding the tr function into application.cfc doesn't work, can't access it asapplication.trChris,Adding it and then doing the cfset also didn't work.RegardsDale Fraser-Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On BehalfOf Chris VelevitchSent: Thursday, 29 June 2006 12:34 PM To: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesOn 6/29/06, Dale Fraser [EMAIL PROTECTED] wrote: We use application.cfc, so how can we include a function on every pageusing application.cfc model?Try:-cfset variables.tr = this.trin the onRequest method of Application.cfc and have the functionincluded as a function in the Application.cfcChris--Chris VelevitchManager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
Joel, I realise that but how is that better then just having a cfinclude at the top of every page. Exactly what I'm trying to avoid. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Joel Cass Sent: Thursday, 29 June 2006 14:40 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Dale all you would need to do is put one line before your code: cfset tr=application.myUdf.tr -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dale Fraser Sent: Thursday, 29 June 2006 2:20 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Steve, I could have done this just by doing cfset application.myUdf = createObject It defeats the purpose of what I want which is a short translation function name Ie The quick brown fox, jumps over the lazy dog. Becomes #tr(The quick brown fox)#, #tr(over the lazy dog)# Rather than #application.udf.tr(The quick brown fox)#, #application.udf.tr(over the lazy dog)# Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Thursday, 29 June 2006 13:50 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes ok had a bit of a play this is what i have come up with cffunction name=onApplicationStart cfset this.name = testApp / cfinclude template=function.cfm cfset application.udf = structNew() / cfloop collection=#variables# item=v cfif NOT listFindNoCase(onApplicationStart,onApplicationEnd,onRequestStart,onRequest End,onSessionStart,onSessionEnd,onError,onRequest, v) cfif isCustomFunction(variables[v]) cfset application.udf[v] = variables[v] / /cfif /cfif /cfloop /cffunction all your functions will then be available as application.udf.functionName Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Andrew Scott Sent: Thursday, June 29, 2006 1:15 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Dale, I am not 100% sure but the onRequest might store it in the request scope. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Thursday, 29 June 2006 1:10 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Yep, We had a reload option in our apps that fire onApplicationStart. I assume this is sufficient, but we did this and it didn't help Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Thursday, 29 June 2006 13:07 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes remember you need to restart the application for it to work -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dale Fraser Sent: Thursday, June 29, 2006 12:53 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Steve, Adding the tr function into application.cfc doesn't work, can't access it as application.tr Chris, Adding it and then doing the cfset also didn't work. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chris Velevitch Sent: Thursday, 29 June 2006 12:34 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes On 6/29/06, Dale Fraser [EMAIL PROTECTED] wrote: We use application.cfc, so how can we include a function on every page using application.cfc model? Try:- cfset variables.tr = this.tr in the onRequest method of Application.cfc and have the function included as a function in the Application.cfc Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
Ok, To close this off and not waste eveyones time. Is it safe to say, that it cant be easily done. Ie you cant automatically have a unscoped function name available to every page. Regards Dale Fraser From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tom MacKean Sent: Thursday, 29 June 2006 14:41 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes ...and we're back to the start :) On 6/29/06, Joel Cass [EMAIL PROTECTED] wrote: Dale all you would need to do is put one line before your code: cfset tr= application.myUdf.tr -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com ]On Behalf Of Dale Fraser Sent: Thursday, 29 June 2006 2:20 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Steve, I could have done this just by doing cfset application.myUdf = createObject It defeats the purpose of what I want which is a short translation function name Ie The quick brown fox, jumps over the lazy dog. Becomes #tr(The quick brown fox)#, #tr(over the lazy dog)# Rather than #application.udf.tr(The quick brown fox)#, #application.udf.tr(over the lazy dog)# Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com ] On Behalf Of Steve Onnis Sent: Thursday, 29 June 2006 13:50 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes ok had a bit of a play this is what i have come up with cffunction name=onApplicationStart cfset this.name = testApp / cfinclude template= function.cfm cfset application.udf = structNew() / cfloop collection=#variables# item=v cfif NOT listFindNoCase(onApplicationStart,onApplicationEnd,onRequestStart,onRequest End,onSessionStart,onSessionEnd,onError,onRequest, v) cfif isCustomFunction(variables[v]) cfset application.udf[v] = variables[v] / /cfif /cfif /cfloop /cffunction all your functions will then be available as application.udf.functionName Steve -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Andrew Scott Sent: Thursday, June 29, 2006 1:15 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Dale, I am not 100% sure but the onRequest might store it in the request scope. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +6138676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Dale Fraser Sent: Thursday, 29 June 2006 1:10 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Yep, We had a reload option in our apps that fire onApplicationStart. I assume this is sufficient, but we did this and it didn't help Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com ] On Behalf Of Steve Onnis Sent: Thursday, 29 June 2006 13:07 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes remember you need to restart the application for it to work -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Dale Fraser Sent: Thursday, June 29, 2006 12:53 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes Steve, Adding the tr function into application.cfc doesn't work, can't access it as application.tr Chris, Adding it and then doing the cfset also didn't work. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Chris Velevitch Sent: Thursday, 29 June 2006 12:34 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes On 6/29/06, Dale Fraser [EMAIL PROTECTED] wrote: We use application.cfc, so how can we include a function on every page using application.cfc model? Try:- cfset variables.tr = this.tr in the onRequest method of Application.cfc and have the function included as a function in the Application.cfc Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
...And actually in the cfadmin code for CFMX they used a custom tag for this - wherever there was something that might need to be substituted with alternate text when doing internationalisation they had something like: cf_intl id=PAGE_TITLEWelcome to our site/cf_intl Then later when you add the french version you have a config file [french] PAGE_TITLE=Bonjour mon amie and you set a global application or request variable that the tag watches to decide which, if any, language to substitute. Advantage is that when an english speaking developer reads the source code they have some idea what's on the page. Cheers, Robin --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
No, that's exactly what the code I pasted into this thread 2 hours ago does...Could someone tell me that they saw that post - I'm beginning to suspect I have a problem posting to cfaussie.Robin On 29/06/2006, at 3:04 PM, Dale Fraser wrote:Ok, To close this off and not waste eveyone’s time. Is it safe to say, that it can’t be easily done. Ie you can’t automatically have a unscoped function name available to every page.RegardsDale Fraser --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
On 6/29/06, Robin Hilliard [EMAIL PROTECTED] wrote: No, that's exactly what the code I pasted into this thread 2 hours ago does... Could someone tell me that they saw that post - I'm beginning to suspect I have a problem posting to cfaussie. Yes, I saw the post. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
Robin, Thanks for the ideas, but we already have our translation working perfectly. I ties into a linguist tool that produces an XML translation file. We have translations for 22 lanugages. Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Robin Hilliard - RocketBoots Sent: Thursday, 29 June 2006 15:09 PM To: cfaussie Subject: [cfaussie] Re: Includes ...And actually in the cfadmin code for CFMX they used a custom tag for this - wherever there was something that might need to be substituted with alternate text when doing internationalisation they had something like: cf_intl id=PAGE_TITLEWelcome to our site/cf_intl Then later when you add the french version you have a config file [french] PAGE_TITLE=Bonjour mon amie and you set a global application or request variable that the tag watches to decide which, if any, language to substitute. Advantage is that when an english speaking developer reads the source code they have some idea what's on the page. Cheers, Robin --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
Yep I saw it to which lead me to conclude that it cant be done. Regards Dale Fraser From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Robin Hilliard Sent: Thursday, 29 June 2006 15:11 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes No, that's exactly what the code I pasted into this thread 2 hours ago does... Could someone tell me that they saw that post - I'm beginning to suspect I have a problem posting to cfaussie. Robin On 29/06/2006, at 3:04 PM, Dale Fraser wrote: Regards Dale Fraser --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
Yes Robin I got your post Unfortunately I didn't read yesterdays posts about the original "issue", but in my opinion if you are going to call a function something vague like "tr", you might want to know where it comes from so you don't spend ages trying to figure it out later on when you forget what "tr" means. Hence it makes sense to have at least aline in theresomewhere to define what "tr" is - whether it's a comment saying where it is defined or simply an include that makes it obvious where the function is; i.e. application.tr ..that means my function might be defined in the application cfinclude template="globalfunctions.cfm" ..that means my custom function might be in there !--- tr is in the application.cfc --- ..etc I apologise if I am just making noise. Robin I didn't read your post at first.. Perhaps others didn't either. It like a stone of goodness in a river of.. Joel -Original Message-From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Robin HilliardSent: Thursday, 29 June 2006 3:11 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesNo, that's exactly what the code I pasted into this thread 2 hours ago does... Could someone tell me that they saw that post - I'm beginning to suspect I have a problem posting to cfaussie. Robin On 29/06/2006, at 3:04 PM, Dale Fraser wrote: Ok, To close this off and not waste eveyone’s time. Is it safe to say, that it can’t be easily done. Ie you can’t automatically have a unscoped function name available to every page. RegardsDale Fraser --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Includes
Robin, Not sure about everyone else, but I quite often get the answers before the questions through this group. Must be a FILO mail system at google. Regards Dale Fraser From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Robin Hilliard Sent: Thursday, 29 June 2006 15:11 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Includes No, that's exactly what the code I pasted into this thread 2 hours ago does... Could someone tell me that they saw that post - I'm beginning to suspect I have a problem posting to cfaussie. Robin On 29/06/2006, at 3:04 PM, Dale Fraser wrote: Regards Dale Fraser --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---