[cfaussie] Re: List/Menu Question.

[Charlie Arehart \(lists account\)]

Yep, good point. I was just responding to Travis' immediate need. 

Now that you mention it, Ben, another suggestion for Travis to consider
would be to not show the actual description and cost in the value of the
select control but instead just pass the primary key of the product being
shown, and then do a lookup on the form action page. That would address the
concern Ben raises. Yes, it does mean another DB I/O (though caching may
help with that), but it's indeed an important point to keep in mind that on
a form someone could mess with the data.

/charlie

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of bsmith
Sent: Thursday, August 30, 2007 1:32 AM
To: cfaussie
Subject: [cfaussie] Re: List/Menu Question.


relying on cost values from form fields is a bad idea i think... if you have
to do it make sure you at least have some referer checking included in the
processing code.

B.


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: List/Menu Question.

[Sean Bucklar]

Treat it as a delimited list?


Freight.Description = ListFirst(form.shippingservice, ' - ');
Freight.Cost = ListLast(form.shippingservice, ' - ');



TJS wrote:
> Hi Everyone,
>
> I was wondering whether anyone knew of a simple solution to the
> following:-
>
>  
> 
> #Freight.Description# - #Freight.Cost#
> 
>  
>
> As you can see in the code above, a CFLOOP is being used to populate
> the options of a List/Menu inside a form.
>
> What I would like to do is put the #Freight.Description# and
> #Freight.Cost# into two seperate session variables.
>
> i.e:-
>
> 
> 
>
> At the moment, my single session variable includes both description
> and cost.
>
> Many thanks in advance to any suggestions.
>
> Cheers,
>
> Travis.
>
>
> >
>
>   


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] CFHTTP - asynchronous?

[AJ Mercer]

Hi Fusioneers,

I am using cfhttp to download images from a remote website
and I have a start end time around the tag and keep a running total of the
cfhttp and a total for total execution time of the page.

It is reporting that I have downloaded 391 images, totaling 26,593 KB
(checks out with file system), in 8 seconds - total run time 173 seconds

By my calculations that is 3325 KB/s
Can that be right?

Is cfhttp asynchronous?

I have cfhttp connecting to a proxy server
would that change things?

I run the process a second time (images now in the proxy server)
I get 391 images in 0 seconds (nice performance increase :-) total run time
67 seconds => was it it not just 8 seconds faster??

I run it again without the proxy server
the total processing time 193 seconds (increased by 10 seconds from the
first run)


Cheers
Andrew

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Any way to get a list of all cftags?

[Robin Hilliard]

Here's an idea:  All tags T seem to have a corresponding TTag.class  
inside cfusion.jar's coldfusion.tagext package.  So from the command  
line I get:

Similitude:~/jrun/servers/cf8b2/cf8rc2/WEB-INF/cfusion/lib robin$ jar  
tf cfusion.jar | grep .*Tag\.class
coldfusion/tagext/AntTag.class
coldfusion/tagext/CfxTag.class
coldfusion/tagext/ChildTag.class
coldfusion/tagext/FunctionGeneratorTag.class
coldfusion/tagext/GenericTag.class
coldfusion/tagext/ScopeAwareTag.class
coldfusion/tagext/datasource/AllowedSqlTag.class
coldfusion/tagext/datasource/ConnectionPropsTag.class
coldfusion/tagext/datasource/DataSourceChildTag.class
coldfusion/tagext/datasource/DataSourceTag.class
coldfusion/tagext/datasource/PoolPropsTag.class
coldfusion/tagext/html/ColTag.class
coldfusion/tagext/html/HtmlheadTag.class
coldfusion/tagext/html/TableTag.class
coldfusion/tagext/html/ajax/AjaxImportTag.class
coldfusion/tagext/html/ajax/AjaxProxyTag.class
coldfusion/tagext/html/ajax/DivTag.class
coldfusion/tagext/html/ajax/LayoutAreaTag.class
coldfusion/tagext/html/ajax/LayoutTag.class
coldfusion/tagext/html/ajax/MenuItemTag.class
coldfusion/tagext/html/ajax/MenuTag.class
coldfusion/tagext/html/ajax/PodTag.class
coldfusion/tagext/html/ajax/SpryDataSetTag.class
coldfusion/tagext/html/ajax/TooltipTag.class
coldfusion/tagext/html/ajax/WindowTag.class
coldfusion/tagext/html/form/AppletTag.class
coldfusion/tagext/html/form/CalendarTag.class
coldfusion/tagext/html/form/FormChildTag.class
coldfusion/tagext/html/form/FormGroupTag.class
coldfusion/tagext/html/form/FormItemTag.class
coldfusion/tagext/html/form/FormTag.class
coldfusion/tagext/html/form/GridColumnTag.class
coldfusion/tagext/html/form/GridRowTag.class
coldfusion/tagext/html/form/GridTag.class
coldfusion/tagext/html/form/InputTag.class
coldfusion/tagext/html/form/SelectTag.class
coldfusion/tagext/html/form/SliderTag.class
coldfusion/tagext/html/form/TextareaTag.class
coldfusion/tagext/html/form/TextinputTag.class
coldfusion/tagext/html/form/TreeItemTag.class
coldfusion/tagext/html/form/TreeTag.class
coldfusion/tagext/io/ChartDataTag.class
coldfusion/tagext/io/ChartSeriesTag.class
coldfusion/tagext/io/ChartTag.class
coldfusion/tagext/io/CompileTag.class
coldfusion/tagext/io/DirectoryTag.class
coldfusion/tagext/io/FeedTag.class
coldfusion/tagext/io/FileTag.class
coldfusion/tagext/io/FlushTag.class
coldfusion/tagext/io/GraphDataTag.class
coldfusion/tagext/io/GraphTag.class
coldfusion/tagext/io/ImageTag.class
coldfusion/tagext/io/OutputTag.class
coldfusion/tagext/io/SilentTag.class
coldfusion/tagext/io/ZipParamTag.class
coldfusion/tagext/io/ZipTag.class
coldfusion/tagext/lang/AbortTag.class
coldfusion/tagext/lang/ApplicationTag.class
coldfusion/tagext/lang/AssociateTag.class
coldfusion/tagext/lang/CustomTag.class
coldfusion/tagext/lang/DocumentItemTag.class
coldfusion/tagext/lang/DocumentSectionTag.class
coldfusion/tagext/lang/DocumentTag.class
coldfusion/tagext/lang/ErrorTag.class
coldfusion/tagext/lang/ExecuteTag.class
coldfusion/tagext/lang/ExitTag.class
coldfusion/tagext/lang/ImportedTag.class
coldfusion/tagext/lang/IncludeTag.class
coldfusion/tagext/lang/InternalIncludeTag.class
coldfusion/tagext/lang/InvokeArgumentTag.class
coldfusion/tagext/lang/InvokeTag.class
coldfusion/tagext/lang/LockTag.class
coldfusion/tagext/lang/LogTag.class
coldfusion/tagext/lang/LoopTag.class
coldfusion/tagext/lang/ModuleTag.class
coldfusion/tagext/lang/ObjectTag.class
coldfusion/tagext/lang/OldReportTag.class
coldfusion/tagext/lang/PDFFormParamTag.class
coldfusion/tagext/lang/PDFFormTag.class
coldfusion/tagext/lang/PDFParamTag.class
coldfusion/tagext/lang/PDFSubformTag.class
coldfusion/tagext/lang/PDFTag.class
coldfusion/tagext/lang/ParamTag.class
coldfusion/tagext/lang/PresentationSlideTag.class
coldfusion/tagext/lang/PresentationTag.class
coldfusion/tagext/lang/PresenterTag.class
coldfusion/tagext/lang/PrintTag.class
coldfusion/tagext/lang/ProcessingDirectiveTag.class
coldfusion/tagext/lang/RegistryTag.class
coldfusion/tagext/lang/ReportTag.class
coldfusion/tagext/lang/ScheduleTag.class
coldfusion/tagext/lang/ServletParamTag.class
coldfusion/tagext/lang/ServletTag.class
coldfusion/tagext/lang/SettingTag.class
coldfusion/tagext/lang/ThreadTag.class
coldfusion/tagext/lang/ThrowTag.class
coldfusion/tagext/lang/TimerTag.class
coldfusion/tagext/lang/WddxTag.class
coldfusion/tagext/lang/XmlTag.class
coldfusion/tagext/net/ContentTag.class
coldfusion/tagext/net/CookieTag.class
coldfusion/tagext/net/FtpTag.class
coldfusion/tagext/net/HeaderTag.class
coldfusion/tagext/net/HttpParamTag.class
coldfusion/tagext/net/HttpTag.class
coldfusion/tagext/net/LdapTag.class
coldfusion/tagext/net/LocationTag.class
coldfusion/tagext/net/MailParamTag.class
coldfusion/tagext/net/MailPartTag.class
coldfusion/tagext/net/MailTag.class
coldfusion/tagext/net/PopTag.class
coldfusion/tagext/net/exchange/ExchangeCalendarTag.class
coldfusion/tagext/net/exchange/ExchangeConnectionTag.class
coldfusion/tagext/net/exchange/ExchangeContactTa

[cfaussie] Re: List/Menu Question.

[bsmith]

relying on cost values from form fields is a bad idea i think... if
you have to do it make sure you at least have some referer checking
included in the processing code.

B.

On Aug 30, 2:25 am, "Charlie Arehart \(lists account\)"
<[EMAIL PROTECTED]> wrote:
> Um, Steve, I did do a listlast to get the cost. That was my first example. I
> see below it got all mashed onto one line for some reason, so perhaps you
> missed that. No worries.
>
> I did go on to explain, though, that if one used any other list function, it
> could be compromised by their being that separator string (" - ") in that
> first description field. The listlast worked, indeed because it seems
> reasonable to presume that cost would never have the " - " in it. As I said,
> if it ever could, then no, this would no longer work.
>
> /charlie
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
>
> Of Steve Onnis
> Sent: Wednesday, August 29, 2007 2:18 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: List/Menu Question.
>
> Even that though, if the value was
>
> 
>
> and the description was "Item1 - blue" then the description would only get
> the "Item1" part.
>
> If you know the last item in the list is always going to be the cost you
> could use the ListLast() to get the cost value and then do something like..
>
> desc = listSetAt(list,  listLen(list),  "" ,  "-") to strip out the cost
> part of the string and leave the rest.
>
> This is ofcourse if you know that things are going ot be in specific
> positions.  In that instance when you have values that could hold the
> delimiter your using, put them last like "COST - DESCRIPTION", that way you
> can be certain that ListFirst() gets the cost and ListRest() gets you
> everything else.
>
> Steve
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Charlie Arehart (lists account)
> Sent: Thursday, 30 August 2007 2:17 AM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: List/Menu Question.
>
> Travis, do you mean that when the form is submitted, you want to take the
> form field (shippingservice, which has 2 values in it) and split that into 2
> separate variables? You can do that using list functions that split the
> string at the " - ". Consider this:
>
>   listfirst(form.shippingservice," - ")>  listlast(form.shippingservice," - ")>
>
> 
> desc=#desc#
> 
> cost=#cost#
> 
>
> Now, someone may ask why I didn't just use listgetat, as in:
>
>   listgetat(form.shippingservice,2," - ")>
>
> The problem comes as soon as the description itself had a " - " in it, which
> seems reasonable. Consider this:
> 
>
> That listgetat code would produce the wrong result, splitting on the first
> dash, and returning cost=blue. Since the cost is not likely to ever have a "
> - " in it, the listfirst and listlast seem the better choice.
>
> There are, of course, still other ways to skin the cat, and some will want
> to talk about the performance of list functions, and why the heck are you
> doing such basic coding, why aren't you using CFCs and objects. I won't go
> there. Sometimes people are still walking in CFML. Let the runners pass. Not
> everyone's in a race.
>
> That said, I will note that I always lament seeing query-driven selects
> being built by hand that way. That's what CFSELECT does in one tag. I know,
> some don't like that it forces you to use CFFORM. That's my lament. There's
> no reason it should have to. Unlike other CFFORM tags, this use of CFSELECT
> has nothing to do with Javascript or Flash. I'll leave that for Travis and
> others to consider on their own.
>
> /charlie
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of TJS
> Sent: Wednesday, August 29, 2007 10:19 AM
> To: cfaussie
> Subject: [cfaussie] List/Menu Question.
>
> Hi Everyone,
>
> I was wondering whether anyone knew of a simple solution to the
> following:-
>
>  
> 
> #Freight.Description# - #Freight.Cost#
> 
>  
>
> As you can see in the code above, a CFLOOP is being used to populate the
> options of a List/Menu inside a form.
>
> What I would like to do is put the #Freight.Description# and #Freight.Cost#
> into two seperate session variables.
>
> i.e:-
>
> 
> 
>
> At the moment, my single session variable includes both description and
> cost.
>
> Many thanks in advance to any suggestions.
>
> Cheers,
>
> Travis.


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Charlie Arehart \(lists account\)]

Taco, if the ideas suggested so far (and later) don't resolve this, I'd like
to make a proposal: you say you can't replicate this. One almost never can.
The problems involved are often too unique for you to replicate. (I can say,
as others have, that this is not as unique as you may think--but by the same
token, it's almost never "CF playing up". Shame that it's always blamed.)
 
But as for being able to better observe/diagnose this, note that you could
do something like CFLOG in the suspected code to write out things (to a
file) like the user's CFID and CFTOKEN, or any other data (perhaps CGI
variables) that might help to determine what's different, as they go from
one page to the next. It would seem the only way they'd get a different
session would be if the session token changes between the page requests.
CFLOG will tell you.
 
/charlie
 

  _  

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Taco Fleur
Sent: Wednesday, August 29, 2007 8:04 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: ColdFusion sessions playing up? showing info that
belongs to others? 


It's nothing like that. We don't append cftoken to the url.
The user signs in, sees the correct information, then goes to another page
and sees the information from another user they don't know (so they say).
 
I have not been able to replicate this myself.


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Query Help

[Dale Fraser]

I have and they will probably do what I'm after.

 

Or I might change the tags to go into their own table, then it's all easy.

 

Thanks.

 

Regards

Dale Fraser

 

http://dalefraser.blogspot.com

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart (lists account)
Sent: Thursday, 30 August 2007 1:59 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help

 

OK, so have you considered looking into its text indexing features, based on
this discussion? :-)

 

/charlie

 

 

  _  

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Wednesday, August 29, 2007 7:26 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help

SQL Server 2005

 

Regards

Dale Fraser

 

http://dalefraser.blogspot.com

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart (lists account)
Sent: Thursday, 30 August 2007 8:12 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help

 

Dale, it just seems you're asking SQL (and the DBMS, and indeed traditional
relational design) to solve a problem it's not meant for. What you need is
text indexing and related functionality. 

 

You mentioned using SQL Server in your first note of the thread. What
version? Text indexing is much improved in both 2000 and 2005. You may find
that it has just the solutions you need.

 

Similarly, even CF's Verity might offer functionality to help. I'm pretty
sure it's got more power than most people realize, even in the free version
bundled with CF. Of course, to do it, you'd need to index your query
results. For some situations, that's not optimal, but it may be better than
the SQL hacks you're attempting. :-)

 

Trying to help.

 

/charlie

 



 


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Query Help

[Charlie Arehart \(lists account\)]

OK, so have you considered looking into its text indexing features, based on
this discussion? :-)
 
/charlie
 


  _  

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Wednesday, August 29, 2007 7:26 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help



SQL Server 2005

 

Regards

Dale Fraser

 

http://dalefraser.blogspot.com

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart (lists account)
Sent: Thursday, 30 August 2007 8:12 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help

 

Dale, it just seems you're asking SQL (and the DBMS, and indeed traditional
relational design) to solve a problem it's not meant for. What you need is
text indexing and related functionality. 

 

You mentioned using SQL Server in your first note of the thread. What
version? Text indexing is much improved in both 2000 and 2005. You may find
that it has just the solutions you need.

 

Similarly, even CF's Verity might offer functionality to help. I'm pretty
sure it's got more power than most people realize, even in the free version
bundled with CF. Of course, to do it, you'd need to index your query
results. For some situations, that's not optimal, but it may be better than
the SQL hacks you're attempting. :-)

 

Trying to help.

 

/charlie

 


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Haikal Saadh]

Isn't it the case that even if you make something idiot proof, someone 
will build a better idiot.

Barry Beattie wrote:
> I've been critisied in the past by indiscriminately adding NO-CACHE
> headers to my pages but the way I see it, you can make thins
> "fool-proof" but you can't make things "idiot-proof"
>
> you were lucky you got feedback to do something about it. it'd be a
> shame if the feedback came from the bankruptcy courts...
>
> >
>
>   


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Web Directions Discount

[Robin Hilliard]

Hi All,

Apologies for the cross post.  The organiser of Web Directions has  
contacted me in my ANZ User Group Co-ordinator capacity to offer a  
conference discount to the various Adobe UG members.  Here is a quick  
description of the conference - the discount code is towards the  
bottom of the message.

Thanks,
Robin




I'm the organizer of Web Directions, a  leading Australian conference  
for web designers, developer and other web professionals.

http://www.webdirections.org/

Now in its fourth year, and having branched out to North America  
earlier this year, we are expecting in excess of 500 web developers,  
designers and decision makers, and have this year added an Expo to  
the event. The conference takes place at the end of September, at the  
Sydney Convention and Exhibition Centre in Darling Harbour.

In addition, this year we are organizing a free (as in beer and  
hopefully speech) "Hatch" day (a kind of hack day). This is open to  
all interested developers/designers, regardless of whether they  
attend the conference (though we don't have unlimited places for  
that). Hatch day is sponsored by Adobe, who are also sponsoring the  
conference, and exhibiting at the conference.

http://www.webdirections.org/program/hatch-day/

So, why am I writing to you?

Firstly, I hope that the hatch day will be something which appeals  
to  many of your members, who may like to come along to share their  
skills and ideas.
In addition, our conference focusses on the broadest range of web  
technologies rather than simply products. There will be sessions  
focussing on Flash and related technologies specifically, and on web  
technologies and standards generally, as well as many design and  
strategy focussed sessions.

We'd also like to offer a discount to your group members of $100 off  
(if they sign up before September 1, it will actually be $200 off),  
making the price $795 'til September 1 and then $895

In order to get this discount, your members simply need to visit our  
registration page

https://secure.webdirections.org/wds07/register/billing

and use the promotional code WDS-UG

If you were able to pass this information to your members, that would  
be greatly appreciated.



Robin Hilliard

ANZ Adobe User Group Co-ordinator (or whatever )


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Barry Beattie]

I've been critisied in the past by indiscriminately adding NO-CACHE
headers to my pages but the way I see it, you can make thins
"fool-proof" but you can't make things "idiot-proof"

you were lucky you got feedback to do something about it. it'd be a
shame if the feedback came from the bankruptcy courts...

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Taco Fleur]

Thanks, that does make me feel better. ;-)

On 8/30/07, Haikal Saadh <[EMAIL PROTECTED]> wrote:
>
>
> I don't see why *you* should have to hit your urls with an ugly stick
> because the ISP is misbehaving. I don't see why you (and other app
> developers) have to spend 10 times the CPU time serving SSL just because
> of one misconfigured ISP.
>
> You didn't think of this because this is something that should. not.
> happen.
>
>
>
> Taco Fleur wrote:
> > Yes, I've already emailed them asking to explain.
> > I took the soft approach, as there might be something I missed?
> > This raises the questions: should everyone know to append a unique
> > string to pages behind a sign in
> > Should we now be putting pages that require sign in behind SSL, even
> > though the data is not that sensitive to warrent the extra overhead of
> > SSL?
> >
> > I never thought about something like this before, an ISP caching data
> > that should only be accessible by users who signed in.
> >
> >
> > On 8/30/07, *Haikal Saadh* <[EMAIL PROTECTED]
> > > wrote:
> >
> >
> > By rights, they should. But through either malice or stupidity,
> sounds
> > like like they're not.
> >
> > I wonder if this is something a phone call could resolve.
> >
> > And if an ISP was exposing my private pages to someone else, that
> > sounds
> > like grounds for a lawsuit...
> >
> > Taco Fleur wrote:
> > > Yes, it sounds like it is a content caching issue, as both users
> > are
> > > with iprimus...
> > > Its pretty serious though... Should they not play by the rules and
> > > look at last modified dates etc?
> > >
> > > thanks guys.
> > >
> > >
> > > On 8/30/07, *Haikal Saadh* < [EMAIL PROTECTED]
> > 
> > > >>
> > wrote:
> > >
> > >
> > > The aggressive-content-caching proxy is a possible
> > explanation for
> > > this.
> > >
> > > Maybe try adding No-Cache headers to your responses?
> > >
> > > Taco Fleur wrote:
> > > > It's nothing like that. We don't append cftoken to the url.
> > > > The user signs in, sees the correct information, then goes
> to
> > > another
> > > > page and sees the information from another user they don't
> > know (so
> > > > they say).
> > > >
> > > > I have not been able to replicate this myself.
> > > >
> > > >
> >
>
>
> >
>


-- 
*** http://www.clickfind.com.au
The new Australian search engine for businesses, products and services
*** http://brisbane-web-design.pacificfox.com.au blog
*** Virtual and Dedicated Servers with MS SQL from $250 a month
*** Virtual and Dedicated Servers with registered version of ColdFusion from
$350 a month
*** ColdFusion licenses at the lowest price

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Haikal Saadh]

I don't see why *you* should have to hit your urls with an ugly stick 
because the ISP is misbehaving. I don't see why you (and other app 
developers) have to spend 10 times the CPU time serving SSL just because 
of one misconfigured ISP.

You didn't think of this because this is something that should. not. happen.



Taco Fleur wrote:
> Yes, I've already emailed them asking to explain.
> I took the soft approach, as there might be something I missed?
> This raises the questions: should everyone know to append a unique 
> string to pages behind a sign in
> Should we now be putting pages that require sign in behind SSL, even 
> though the data is not that sensitive to warrent the extra overhead of 
> SSL?
>  
> I never thought about something like this before, an ISP caching data 
> that should only be accessible by users who signed in.
>
>  
> On 8/30/07, *Haikal Saadh* <[EMAIL PROTECTED] 
> > wrote:
>
>
> By rights, they should. But through either malice or stupidity, sounds
> like like they're not.
>
> I wonder if this is something a phone call could resolve.
>
> And if an ISP was exposing my private pages to someone else, that
> sounds
> like grounds for a lawsuit...
>
> Taco Fleur wrote:
> > Yes, it sounds like it is a content caching issue, as both users
> are
> > with iprimus...
> > Its pretty serious though... Should they not play by the rules and
> > look at last modified dates etc?
> >
> > thanks guys.
> >
> >
> > On 8/30/07, *Haikal Saadh* < [EMAIL PROTECTED]
> 
> > >>
> wrote:
> >
> >
> > The aggressive-content-caching proxy is a possible
> explanation for
> > this.
> >
> > Maybe try adding No-Cache headers to your responses?
> >
> > Taco Fleur wrote:
> > > It's nothing like that. We don't append cftoken to the url.
> > > The user signs in, sees the correct information, then goes to
> > another
> > > page and sees the information from another user they don't
> know (so
> > > they say).
> > >
> > > I have not been able to replicate this myself.
> > >
> > >
>


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Taco Fleur]

I will look at this.
Is this something thats considered a must, i.e. if you don't do it you
should know that an ISP can show the pages to someone else?

Thanks.

On 8/30/07, Ryan Sabir <[EMAIL PROTECTED]> wrote:
>
>
> We had exactly the same issue with users on iPrimus. From what I recall
> adding the no-cache directive to the headers seemed to fix the problem, but
> was hard to diagnose because it was very intermittent.
>
>
>  --
> *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On
> Behalf Of *Taco Fleur
> *Sent:* Thursday, 30 August 2007 10:15 AM
> *To:* cfaussie@googlegroups.com
> *Subject:* [cfaussie] Re: ColdFusion sessions playing up? showing info
> that belongs to others? 
>
>
>  Yes, it sounds like it is a content caching issue, as both users are with
> iprimus...
> Its pretty serious though... Should they not play by the rules and look at
> last modified dates etc?
>
> thanks guys.
>
>
> On 8/30/07, Haikal Saadh <[EMAIL PROTECTED]> wrote:
> >
> >
> > The aggressive-content-caching proxy is a possible explanation for this.
> >
> > Maybe try adding No-Cache headers to your responses?
> >
> > Taco Fleur wrote:
> > > It's nothing like that. We don't append cftoken to the url.
> > > The user signs in, sees the correct information, then goes to another
> > > page and sees the information from another user they don't know (so
> > > they say).
> > >
> > > I have not been able to replicate this myself.
> > >
> > >
> > > On 8/30/07, *skateboard.com.au *
> > > <[EMAIL PROTECTED] > wrote:
> > >
> > >
> > > I had this happen where I was a bit sloppy and left links with
> > cftoken
> > > url variables in content that was cached/shared.
> > >
> > >
> > >
> > > -Original Message-
> > > From: "Taco Fleur" <[EMAIL PROTECTED]  > [EMAIL PROTECTED]>>
> > > To: cfaussie@googlegroups.com 
> > > Date: Thu, 30 Aug 2007 09:48:16 +1000
> > > Subject: [cfaussie] ColdFusion sessions playing up? showing info
> > that
> > > belongs to others? 
> > >
> > > > Hello all,
> > > >
> > > > I was wondering if someone has seen this before. One of our
> > > > applications is
> > > > apparently displaying info that belongs to someone else. I.e.
> > > they sign
> > > > in,
> > > > see the right info, go to another page and see the sign in
> > > details of
> > > > someone else.
> > > >
> > > > Now, the only way I can see this happening is if ColdFusion is
> > > playing
> > > > up
> > > > and getting the session info mixed up.
> > > >
> > > > Two users say they saw information belonging to another user
> > when
> > > > moving
> > > > from one page to another. I just find it impossible when I look
> > > at the
> > > > code!
> > > > There is a User CFC, it contains the screen name and user id,
> > > but it is
> > > > only
> > > > populated if the user signs in. Therefore it can only be that
> > > > Coldfusion is
> > > > playing up. Anyone seen this before, know issue?
> > > >
> > > > Thanks in advance.
> > > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
> --
> *** http://www.clickfind.com.au
> The new Australian search engine for businesses, products and services
> *** http://brisbane-web-design.pacificfox.com.au blog
> *** Virtual and Dedicated Servers with MS SQL from $250 a month
> *** Virtual and Dedicated Servers with registered version of ColdFusion
> from $350 a month
> *** ColdFusion licenses at the lowest price
> >
>


-- 
*** http://www.clickfind.com.au
The new Australian search engine for businesses, products and services
*** http://brisbane-web-design.pacificfox.com.au blog
*** Virtual and Dedicated Servers with MS SQL from $250 a month
*** Virtual and Dedicated Servers with registered version of ColdFusion from
$350 a month
*** ColdFusion licenses at the lowest price

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Taco Fleur]

Yes, I've already emailed them asking to explain.
I took the soft approach, as there might be something I missed?
This raises the questions: should everyone know to append a unique string to
pages behind a sign in? Should we now be putting pages that require sign in
behind SSL, even though the data is not that sensitive to warrent the extra
overhead of SSL?

I never thought about something like this before, an ISP caching data that
should only be accessible by users who signed in.


On 8/30/07, Haikal Saadh <[EMAIL PROTECTED]> wrote:
>
>
> By rights, they should. But through either malice or stupidity, sounds
> like like they're not.
>
> I wonder if this is something a phone call could resolve.
>
> And if an ISP was exposing my private pages to someone else, that sounds
> like grounds for a lawsuit...
>
> Taco Fleur wrote:
> > Yes, it sounds like it is a content caching issue, as both users are
> > with iprimus...
> > Its pretty serious though... Should they not play by the rules and
> > look at last modified dates etc?
> >
> > thanks guys.
> >
> >
> > On 8/30/07, *Haikal Saadh* <[EMAIL PROTECTED]
> > > wrote:
> >
> >
> > The aggressive-content-caching proxy is a possible explanation for
> > this.
> >
> > Maybe try adding No-Cache headers to your responses?
> >
> > Taco Fleur wrote:
> > > It's nothing like that. We don't append cftoken to the url.
> > > The user signs in, sees the correct information, then goes to
> > another
> > > page and sees the information from another user they don't know
> (so
> > > they say).
> > >
> > > I have not been able to replicate this myself.
> > >
> > >
> > > On 8/30/07, *skateboard.com.au 
> > >*
> > > <[EMAIL PROTECTED] 
> > >>
> wrote:
> > >
> > >
> > > I had this happen where I was a bit sloppy and left links
> > with cftoken
> > > url variables in content that was cached/shared.
> > >
> > >
> > >
> > > -Original Message-
> > > From: "Taco Fleur" <[EMAIL PROTECTED]
> >   > >>
> > > To: cfaussie@googlegroups.com
> >   > cfaussie@googlegroups.com >
> > > Date: Thu, 30 Aug 2007 09:48:16 +1000
> > > Subject: [cfaussie] ColdFusion sessions playing up? showing
> > info that
> > > belongs to others? 
> > >
> > > > Hello all,
> > > >
> > > > I was wondering if someone has seen this before. One of our
> > > > applications is
> > > > apparently displaying info that belongs to someone else. I.e
> .
> > > they sign
> > > > in,
> > > > see the right info, go to another page and see the sign in
> > > details of
> > > > someone else.
> > > >
> > > > Now, the only way I can see this happening is if
> > ColdFusion is
> > > playing
> > > > up
> > > > and getting the session info mixed up.
> > > >
> > > > Two users say they saw information belonging to another
> > user when
> > > > moving
> > > > from one page to another. I just find it impossible when I
> > look
> > > at the
> > > > code!
> > > > There is a User CFC, it contains the screen name and user
> id,
> > > but it is
> > > > only
> > > > populated if the user signs in. Therefore it can only be
> that
> > > > Coldfusion is
> > > > playing up. Anyone seen this before, know issue?
> > > >
> > > > Thanks in advance.
> > > >
> > >
> > >
> > >
> > >
> > >
> >
>
>
> >
>


-- 
*** http://www.clickfind.com.au
The new Australian search engine for businesses, products and services
*** http://brisbane-web-design.pacificfox.com.au blog
*** Virtual and Dedicated Servers with MS SQL from $250 a month
*** Virtual and Dedicated Servers with registered version of ColdFusion from
$350 a month
*** ColdFusion licenses at the lowest price

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Ryan Sabir]

BTW,
 
This might be the culprit:
http://www.primus.com.au/PrimusWeb/HomeSolutions/AdditionalServices/iSpeed/
 
seeya




From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Taco 
Fleur
Sent: Thursday, 30 August 2007 10:15 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: ColdFusion sessions playing up? showing info that 
belongs to others? 


Yes, it sounds like it is a content caching issue, as both users are with 
iprimus...
Its pretty serious though... Should they not play by the rules and look at last 
modified dates etc?
 
thanks guys.

 
On 8/30/07, Haikal Saadh <[EMAIL PROTECTED]> wrote: 

The aggressive-content-caching proxy is a possible explanation for this.

Maybe try adding No-Cache headers to your responses? 

Taco Fleur wrote:
> It's nothing like that. We don't append cftoken to the url.
> The user signs in, sees the correct information, then goes to another
> page and sees the information from another user they don't know (so 
> they say).
>
> I have not been able to replicate this myself.
>
>
> On 8/30/07, *skateboard.com.au *
> <[EMAIL PROTECTED] > wrote:
>
>
> I had this happen where I was a bit sloppy and left links with cftoken 
> url variables in content that was cached/shared.
>
>
>
> -Original Message-
> From: "Taco Fleur" <[EMAIL PROTECTED] >
> To: cfaussie@googlegroups.com 
> Date: Thu, 30 Aug 2007 09:48:16 +1000
> Subject: [cfaussie] ColdFusion sessions playing up? showing info that
> belongs to others? 
>
> > Hello all, 
> >
> > I was wondering if someone has seen this before. One of our
> > applications is
> > apparently displaying info that belongs to someone else. I.e.
> they sign 
> > in,
> > see the right info, go to another page and see the sign in
> details of
> > someone else.
> >
> > Now, the only way I can see this happening is if ColdFusion is 
> playing
> > up
> > and getting the session info mixed up.
> >
> > Two users say they saw information belonging to another user when
> > moving
> > from one page to another. I just find it impossible when I look
> at the
> > code!
> > There is a User CFC, it contains the screen name and user id,
> but it is
> > only
> > populated if the user signs in. Therefore it can only be that
> > Coldfusion is
> > playing up. Anyone seen this before, know issue?
> >
> > Thanks in advance. 
> >
>
>
>
>
>






-- 
*** http://www.clickfind.com.au 
The new Australian search engine for businesses, products and services 
*** http://brisbane-web-design.pacificfox.com.au blog
*** Virtual and Dedicated Servers with MS SQL from $250 a month
*** Virtual and Dedicated Servers with registered version of ColdFusion from 
$350 a month
*** ColdFusion licenses at the lowest price 

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Ryan Sabir]

 
We had exactly the same issue with users on iPrimus. From what I recall adding 
the no-cache directive to the headers seemed to fix the problem, but was hard 
to diagnose because it was very intermittent.
 




From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Taco 
Fleur
Sent: Thursday, 30 August 2007 10:15 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: ColdFusion sessions playing up? showing info that 
belongs to others? 


Yes, it sounds like it is a content caching issue, as both users are with 
iprimus...
Its pretty serious though... Should they not play by the rules and look at last 
modified dates etc?
 
thanks guys.

 
On 8/30/07, Haikal Saadh <[EMAIL PROTECTED]> wrote: 

The aggressive-content-caching proxy is a possible explanation for this.

Maybe try adding No-Cache headers to your responses? 

Taco Fleur wrote:
> It's nothing like that. We don't append cftoken to the url.
> The user signs in, sees the correct information, then goes to another
> page and sees the information from another user they don't know (so 
> they say).
>
> I have not been able to replicate this myself.
>
>
> On 8/30/07, *skateboard.com.au *
> <[EMAIL PROTECTED] > wrote:
>
>
> I had this happen where I was a bit sloppy and left links with cftoken 
> url variables in content that was cached/shared.
>
>
>
> -Original Message-
> From: "Taco Fleur" <[EMAIL PROTECTED] >
> To: cfaussie@googlegroups.com 
> Date: Thu, 30 Aug 2007 09:48:16 +1000
> Subject: [cfaussie] ColdFusion sessions playing up? showing info that
> belongs to others? 
>
> > Hello all, 
> >
> > I was wondering if someone has seen this before. One of our
> > applications is
> > apparently displaying info that belongs to someone else. I.e.
> they sign 
> > in,
> > see the right info, go to another page and see the sign in
> details of
> > someone else.
> >
> > Now, the only way I can see this happening is if ColdFusion is 
> playing
> > up
> > and getting the session info mixed up.
> >
> > Two users say they saw information belonging to another user when
> > moving
> > from one page to another. I just find it impossible when I look
> at the
> > code!
> > There is a User CFC, it contains the screen name and user id,
> but it is
> > only
> > populated if the user signs in. Therefore it can only be that
> > Coldfusion is
> > playing up. Anyone seen this before, know issue?
> >
> > Thanks in advance. 
> >
>
>
>
>
>






-- 
*** http://www.clickfind.com.au 
The new Australian search engine for businesses, products and services 
*** http://brisbane-web-design.pacificfox.com.au blog
*** Virtual and Dedicated Servers with MS SQL from $250 a month
*** Virtual and Dedicated Servers with registered version of ColdFusion from 
$350 a month
*** ColdFusion licenses at the lowest price 

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Query Help

[Blair McKenzie]

I agree with the others. Your problem is a text book example of what
normalising is for. Having tags represented in a separate table allows you
to find all the items with a specific tag or find all tags on a specific
item with one lightening quick select.

Blair

On 8/30/07, Haikal Saadh <[EMAIL PROTECTED]> wrote:
>
>
> I know you know it's not normalised, but why not normalise?
>
> That aside, SQL Server doesn't seem to like to do too many LIKE queries,
> in my experience. But as the others have suggested, you might want to
> look into it's full text indexing capabilities.
>
> Dale Fraser wrote:
> >
> > I have a database with a field that defines a space delimited list of
> > keywords or tags.
> >
> > For example
> >
> > Item 1
> >
> > cheese bread rice noodles
> >
> > Item 2
> >
> > cheese wine fruit rice
> >
> > There are tags against every record, and I know this isn't normalised
> > data but I need to do two things.
> >
> > 1. Generate a list of unique tags from all records
> > from about would get cheese bread wine fruit rice noodles
> >
> > 2. I also then need a query that can pull out the entries matching a tag
> >
> > For example
> >
> > Select * from table where tag like '%cheese%'
> >
> > That won't quite work as there could be a tag cheesey
> >
> > So I thought I could do
> >
> > Select * from table where ' ' + tag + ' ' like '% cheese %'
> >
> > Which would probably work, but not sure if there is a better way.
> >
> > MS SQL if that makes a difference. Was half wondering if I could setup
> > a word index to do these 2 things or similar.
> >
> > Regards
> >
> > Dale Fraser
> >
> > http://dalefraser.blogspot.com
> >
> >
> > >
>
>
> >
>

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Haikal Saadh]

By rights, they should. But through either malice or stupidity, sounds 
like like they're not.

I wonder if this is something a phone call could resolve.

And if an ISP was exposing my private pages to someone else, that sounds 
like grounds for a lawsuit...

Taco Fleur wrote:
> Yes, it sounds like it is a content caching issue, as both users are 
> with iprimus...
> Its pretty serious though... Should they not play by the rules and 
> look at last modified dates etc?
>  
> thanks guys.
>
>  
> On 8/30/07, *Haikal Saadh* <[EMAIL PROTECTED] 
> > wrote:
>
>
> The aggressive-content-caching proxy is a possible explanation for
> this.
>
> Maybe try adding No-Cache headers to your responses?
>
> Taco Fleur wrote:
> > It's nothing like that. We don't append cftoken to the url.
> > The user signs in, sees the correct information, then goes to
> another
> > page and sees the information from another user they don't know (so
> > they say).
> >
> > I have not been able to replicate this myself.
> >
> >
> > On 8/30/07, *skateboard.com.au 
> >*
> > <[EMAIL PROTECTED] 
> >> wrote:
> >
> >
> > I had this happen where I was a bit sloppy and left links
> with cftoken
> > url variables in content that was cached/shared.
> >
> >
> >
> > -Original Message-
> > From: "Taco Fleur" <[EMAIL PROTECTED]
>   >>
> > To: cfaussie@googlegroups.com
>   cfaussie@googlegroups.com >
> > Date: Thu, 30 Aug 2007 09:48:16 +1000
> > Subject: [cfaussie] ColdFusion sessions playing up? showing
> info that
> > belongs to others? 
> >
> > > Hello all,
> > >
> > > I was wondering if someone has seen this before. One of our
> > > applications is
> > > apparently displaying info that belongs to someone else. I.e.
> > they sign
> > > in,
> > > see the right info, go to another page and see the sign in
> > details of
> > > someone else.
> > >
> > > Now, the only way I can see this happening is if
> ColdFusion is
> > playing
> > > up
> > > and getting the session info mixed up.
> > >
> > > Two users say they saw information belonging to another
> user when
> > > moving
> > > from one page to another. I just find it impossible when I
> look
> > at the
> > > code!
> > > There is a User CFC, it contains the screen name and user id,
> > but it is
> > > only
> > > populated if the user signs in. Therefore it can only be that
> > > Coldfusion is
> > > playing up. Anyone seen this before, know issue?
> > >
> > > Thanks in advance.
> > >
> >
> >
> >
> >
> >
>


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Taco Fleur]

Yes, it sounds like it is a content caching issue, as both users are with
iprimus...
Its pretty serious though... Should they not play by the rules and look at
last modified dates etc?

thanks guys.


On 8/30/07, Haikal Saadh <[EMAIL PROTECTED]> wrote:
>
>
> The aggressive-content-caching proxy is a possible explanation for this.
>
> Maybe try adding No-Cache headers to your responses?
>
> Taco Fleur wrote:
> > It's nothing like that. We don't append cftoken to the url.
> > The user signs in, sees the correct information, then goes to another
> > page and sees the information from another user they don't know (so
> > they say).
> >
> > I have not been able to replicate this myself.
> >
> >
> > On 8/30/07, *skateboard.com.au *
> > <[EMAIL PROTECTED] > wrote:
> >
> >
> > I had this happen where I was a bit sloppy and left links with
> cftoken
> > url variables in content that was cached/shared.
> >
> >
> >
> > -Original Message-
> > From: "Taco Fleur" <[EMAIL PROTECTED]  >>
> > To: cfaussie@googlegroups.com 
> > Date: Thu, 30 Aug 2007 09:48:16 +1000
> > Subject: [cfaussie] ColdFusion sessions playing up? showing info
> that
> > belongs to others? 
> >
> > > Hello all,
> > >
> > > I was wondering if someone has seen this before. One of our
> > > applications is
> > > apparently displaying info that belongs to someone else. I.e.
> > they sign
> > > in,
> > > see the right info, go to another page and see the sign in
> > details of
> > > someone else.
> > >
> > > Now, the only way I can see this happening is if ColdFusion is
> > playing
> > > up
> > > and getting the session info mixed up.
> > >
> > > Two users say they saw information belonging to another user when
> > > moving
> > > from one page to another. I just find it impossible when I look
> > at the
> > > code!
> > > There is a User CFC, it contains the screen name and user id,
> > but it is
> > > only
> > > populated if the user signs in. Therefore it can only be that
> > > Coldfusion is
> > > playing up. Anyone seen this before, know issue?
> > >
> > > Thanks in advance.
> > >
> >
> >
> >
> >
> >
>
>
> >
>


-- 
*** http://www.clickfind.com.au
The new Australian search engine for businesses, products and services
*** http://brisbane-web-design.pacificfox.com.au blog
*** Virtual and Dedicated Servers with MS SQL from $250 a month
*** Virtual and Dedicated Servers with registered version of ColdFusion from
$350 a month
*** ColdFusion licenses at the lowest price

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Haikal Saadh]

The aggressive-content-caching proxy is a possible explanation for this.

Maybe try adding No-Cache headers to your responses?

Taco Fleur wrote:
> It's nothing like that. We don't append cftoken to the url.
> The user signs in, sees the correct information, then goes to another 
> page and sees the information from another user they don't know (so 
> they say).
>  
> I have not been able to replicate this myself.
>
>  
> On 8/30/07, *skateboard.com.au * 
> <[EMAIL PROTECTED] > wrote:
>
>
> I had this happen where I was a bit sloppy and left links with cftoken
> url variables in content that was cached/shared.
>
>
>
> -Original Message-
> From: "Taco Fleur" <[EMAIL PROTECTED] >
> To: cfaussie@googlegroups.com 
> Date: Thu, 30 Aug 2007 09:48:16 +1000
> Subject: [cfaussie] ColdFusion sessions playing up? showing info that
> belongs to others? 
>
> > Hello all,
> >
> > I was wondering if someone has seen this before. One of our
> > applications is
> > apparently displaying info that belongs to someone else. I.e.
> they sign
> > in,
> > see the right info, go to another page and see the sign in
> details of
> > someone else.
> >
> > Now, the only way I can see this happening is if ColdFusion is
> playing
> > up
> > and getting the session info mixed up.
> >
> > Two users say they saw information belonging to another user when
> > moving
> > from one page to another. I just find it impossible when I look
> at the
> > code!
> > There is a User CFC, it contains the screen name and user id,
> but it is
> > only
> > populated if the user signs in. Therefore it can only be that
> > Coldfusion is
> > playing up. Anyone seen this before, know issue?
> >
> > Thanks in advance.
> >
>
>
>
>
>


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Taco Fleur]

Hi David,

yes, this is something that I will check thanks.


On 8/30/07, David Harris <[EMAIL PROTECTED]> wrote:
>
>
> Hi Taco,
>
> I have seen this before, and often it's a proxy sitting between the CF
> server and the users.
>
> - user one logs in and views a page
> -- the proxy caches it
> - user two logs in and views the same page
> -- the proxy says "I've got this one, don't bother the server, use
> this one"
>
> and then shows the wrong page to user two.
>
> It may not be the case in you situation, but is something to check
> out.
>
> HTH
>
> David
>
> Taco Fleur wrote:
> > Hello all,
> >
> > I was wondering if someone has seen this before. One of our applications
> is
> > apparently displaying info that belongs to someone else. I.e. they sign
> in,
> > see the right info, go to another page and see the sign in details of
> > someone else.
> >
> > Now, the only way I can see this happening is if ColdFusion is playing
> up
> > and getting the session info mixed up.
> >
> > Two users say they saw information belonging to another user when moving
> > from one page to another. I just find it impossible when I look at the
> code!
> > There is a User CFC, it contains the screen name and user id, but it is
> only
> > populated if the user signs in. Therefore it can only be that Coldfusion
> is
> > playing up. Anyone seen this before, know issue?
> >
> > Thanks in advance.
> >
> > --
> > *** http://www.clickfind.com.au
> > The new Australian search engine for businesses, products and services
> > *** http://brisbane-web-design.pacificfox.com.au blog
> > *** Virtual and Dedicated Servers with MS SQL from $250 a month
> > *** Virtual and Dedicated Servers with registered version of ColdFusion
> from
> > $350 a month
> > *** ColdFusion licenses at the lowest price
>
>
> >
>


-- 
*** http://www.clickfind.com.au
The new Australian search engine for businesses, products and services
*** http://brisbane-web-design.pacificfox.com.au blog
*** Virtual and Dedicated Servers with MS SQL from $250 a month
*** Virtual and Dedicated Servers with registered version of ColdFusion from
$350 a month
*** ColdFusion licenses at the lowest price

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Taco Fleur]

It's nothing like that. We don't append cftoken to the url.
The user signs in, sees the correct information, then goes to another page
and sees the information from another user they don't know (so they say).

I have not been able to replicate this myself.


On 8/30/07, skateboard.com.au <[EMAIL PROTECTED]> wrote:
>
>
> I had this happen where I was a bit sloppy and left links with cftoken
> url variables in content that was cached/shared.
>
>
>
> -Original Message-
> From: "Taco Fleur" <[EMAIL PROTECTED]>
> To: cfaussie@googlegroups.com
> Date: Thu, 30 Aug 2007 09:48:16 +1000
> Subject: [cfaussie] ColdFusion sessions playing up? showing info that
> belongs to others? 
>
> > Hello all,
> >
> > I was wondering if someone has seen this before. One of our
> > applications is
> > apparently displaying info that belongs to someone else. I.e. they sign
> > in,
> > see the right info, go to another page and see the sign in details of
> > someone else.
> >
> > Now, the only way I can see this happening is if ColdFusion is playing
> > up
> > and getting the session info mixed up.
> >
> > Two users say they saw information belonging to another user when
> > moving
> > from one page to another. I just find it impossible when I look at the
> > code!
> > There is a User CFC, it contains the screen name and user id, but it is
> > only
> > populated if the user signs in. Therefore it can only be that
> > Coldfusion is
> > playing up. Anyone seen this before, know issue?
> >
> > Thanks in advance.
> >
> > --
> > *** http://www.clickfind.com.au
> > The new Australian search engine for businesses, products and services
> > *** http://brisbane-web-design.pacificfox.com.au blog
> > *** Virtual and Dedicated Servers with MS SQL from $250 a month
> > *** Virtual and Dedicated Servers with registered version of ColdFusion
> > from
> > $350 a month
> > *** ColdFusion licenses at the lowest price
> >
> > >
>
>
>
> >
>


-- 
*** http://www.clickfind.com.au
The new Australian search engine for businesses, products and services
*** http://brisbane-web-design.pacificfox.com.au blog
*** Virtual and Dedicated Servers with MS SQL from $250 a month
*** Virtual and Dedicated Servers with registered version of ColdFusion from
$350 a month
*** ColdFusion licenses at the lowest price

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[Adam Chapman]

Hi Taco,

 

I had this happen years ago, the cause was that the two users were using
the same isp that was
heavily caching content.. the solution back then was to ensure that
every url was unique.. and/or
pass session token in the url.

 

Cheers,

Adam

 

 

  _  

From: Taco Fleur [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 30 August 2007 9:48 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] ColdFusion sessions playing up? showing info that
belongs to others? 

 

Hello all,

 

I was wondering if someone has seen this before. One of our applications
is apparently displaying info that belongs to someone else. I.e. they
sign in, see the right info, go to another page and see the sign in
details of someone else. 

 

Now, the only way I can see this happening is if ColdFusion is playing
up and getting the session info mixed up.

 

Two users say they saw information belonging to another user when moving
from one page to another. I just find it impossible when I look at the
code! There is a User CFC, it contains the screen name and user id, but
it is only populated if the user signs in. Therefore it can only be that
Coldfusion is playing up. Anyone seen this before, know issue? 

 

Thanks in advance.

-- 
*** http://www.clickfind.com.au 
The new Australian search engine for businesses, products and services 
*** http://brisbane-web-design.pacificfox.com.au blog
*** Virtual and Dedicated Servers with MS SQL from $250 a month
*** Virtual and Dedicated Servers with registered version of ColdFusion
from $350 a month
*** ColdFusion licenses at the lowest price 




--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Query Help

[Haikal Saadh]

I know you know it's not normalised, but why not normalise?

That aside, SQL Server doesn't seem to like to do too many LIKE queries, 
in my experience. But as the others have suggested, you might want to 
look into it's full text indexing capabilities.

Dale Fraser wrote:
>
> I have a database with a field that defines a space delimited list of 
> keywords or tags.
>
> For example
>
> Item 1
>
> cheese bread rice noodles
>
> Item 2
>
> cheese wine fruit rice
>
> There are tags against every record, and I know this isn't normalised 
> data but I need to do two things.
>
> 1. Generate a list of unique tags from all records
> from about would get cheese bread wine fruit rice noodles
>
> 2. I also then need a query that can pull out the entries matching a tag
>
> For example
>
> Select * from table where tag like '%cheese%'
>
> That won't quite work as there could be a tag cheesey
>
> So I thought I could do
>
> Select * from table where ' ' + tag + ' ' like '% cheese %'
>
> Which would probably work, but not sure if there is a better way.
>
> MS SQL if that makes a difference. Was half wondering if I could setup 
> a word index to do these 2 things or similar.
>
> Regards
>
> Dale Fraser
>
> http://dalefraser.blogspot.com
>
>
> >


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[David Harris]

Hi Taco,

I have seen this before, and often it's a proxy sitting between the CF
server and the users.

- user one logs in and views a page
-- the proxy caches it
- user two logs in and views the same page
-- the proxy says "I've got this one, don't bother the server, use
this one"

and then shows the wrong page to user two.

It may not be the case in you situation, but is something to check
out.

HTH

David

Taco Fleur wrote:
> Hello all,
>
> I was wondering if someone has seen this before. One of our applications is
> apparently displaying info that belongs to someone else. I.e. they sign in,
> see the right info, go to another page and see the sign in details of
> someone else.
>
> Now, the only way I can see this happening is if ColdFusion is playing up
> and getting the session info mixed up.
>
> Two users say they saw information belonging to another user when moving
> from one page to another. I just find it impossible when I look at the code!
> There is a User CFC, it contains the screen name and user id, but it is only
> populated if the user signs in. Therefore it can only be that Coldfusion is
> playing up. Anyone seen this before, know issue?
>
> Thanks in advance.
>
> --
> *** http://www.clickfind.com.au
> The new Australian search engine for businesses, products and services
> *** http://brisbane-web-design.pacificfox.com.au blog
> *** Virtual and Dedicated Servers with MS SQL from $250 a month
> *** Virtual and Dedicated Servers with registered version of ColdFusion from
> $350 a month
> *** ColdFusion licenses at the lowest price


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....

[skateboard.com.au]

I had this happen where I was a bit sloppy and left links with cftoken 
url variables in content that was cached/shared. 



-Original Message-
From: "Taco Fleur" <[EMAIL PROTECTED]>
To: cfaussie@googlegroups.com
Date: Thu, 30 Aug 2007 09:48:16 +1000
Subject: [cfaussie] ColdFusion sessions playing up? showing info that 
belongs to others? 

> Hello all,
> 
> I was wondering if someone has seen this before. One of our
> applications is
> apparently displaying info that belongs to someone else. I.e. they sign
> in,
> see the right info, go to another page and see the sign in details of
> someone else.
> 
> Now, the only way I can see this happening is if ColdFusion is playing
> up
> and getting the session info mixed up.
> 
> Two users say they saw information belonging to another user when
> moving
> from one page to another. I just find it impossible when I look at the
> code!
> There is a User CFC, it contains the screen name and user id, but it is
> only
> populated if the user signs in. Therefore it can only be that
> Coldfusion is
> playing up. Anyone seen this before, know issue?
> 
> Thanks in advance.
> 
> -- 
> *** http://www.clickfind.com.au
> The new Australian search engine for businesses, products and services
> *** http://brisbane-web-design.pacificfox.com.au blog
> *** Virtual and Dedicated Servers with MS SQL from $250 a month
> *** Virtual and Dedicated Servers with registered version of ColdFusion
> from
> $350 a month
> *** ColdFusion licenses at the lowest price
> 
> > 



--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] ColdFusion sessions playing up? showing info that belongs to others? ....

[Taco Fleur]

Hello all,

I was wondering if someone has seen this before. One of our applications is
apparently displaying info that belongs to someone else. I.e. they sign in,
see the right info, go to another page and see the sign in details of
someone else.

Now, the only way I can see this happening is if ColdFusion is playing up
and getting the session info mixed up.

Two users say they saw information belonging to another user when moving
from one page to another. I just find it impossible when I look at the code!
There is a User CFC, it contains the screen name and user id, but it is only
populated if the user signs in. Therefore it can only be that Coldfusion is
playing up. Anyone seen this before, know issue?

Thanks in advance.

-- 
*** http://www.clickfind.com.au
The new Australian search engine for businesses, products and services
*** http://brisbane-web-design.pacificfox.com.au blog
*** Virtual and Dedicated Servers with MS SQL from $250 a month
*** Virtual and Dedicated Servers with registered version of ColdFusion from
$350 a month
*** ColdFusion licenses at the lowest price

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Query Help

[Dale Fraser]

SQL Server 2005

 

Regards

Dale Fraser

 

http://dalefraser.blogspot.com

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart (lists account)
Sent: Thursday, 30 August 2007 8:12 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help

 

Dale, it just seems you're asking SQL (and the DBMS, and indeed traditional
relational design) to solve a problem it's not meant for. What you need is
text indexing and related functionality. 

 

You mentioned using SQL Server in your first note of the thread. What
version? Text indexing is much improved in both 2000 and 2005. You may find
that it has just the solutions you need.

 

Similarly, even CF's Verity might offer functionality to help. I'm pretty
sure it's got more power than most people realize, even in the free version
bundled with CF. Of course, to do it, you'd need to index your query
results. For some situations, that's not optimal, but it may be better than
the SQL hacks you're attempting. :-)

 

Trying to help.

 

/charlie

 

 

  _  

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Wednesday, August 29, 2007 5:42 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help

But it's a string with lots of words in it

 

"one two six sixteen"

 

So like '%six%' wouldn't work because it would also get sixteen

 

So like '% one %' wouldn't work as there is no space in front of one

 

So ' ' + field + ' ' like '% one %' should do it, just wonder if there is a
better way.

 

Also what to do with getting all words in a unique list, I could just loop
over the query and build a struct, but there might be a better way also.

 

Regards

Dale Fraser

 

http://dalefraser.blogspot.com

 



 


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: learncf.com is Coming!

[Andrew Scott]

lol,

Good to think that I am not the only one getting 3-4 hours sleep these days.

Ray must get 30 mins on that premise.



On 8/30/07, M@ Bourke <[EMAIL PROTECTED]> wrote:
>
> >what we all really wish that we could have done if we had the time to
>
> anyone sleeping more then 4 hours a day is wasting time
>
>  On 8/29/07, Andrew Scott <[EMAIL PROTECTED]> wrote:
>
> >  Well said.
> >
> > And its good that Dale has stood up and done what we all really wish
> > that we could have done if we had the time to...
> >
> > Grats Dale.
> >
> >
> >  On 8/29/07, Barry Beattie < [EMAIL PROTECTED]> wrote:
> >
> > >
> > > >
> > > > Now you've put the mozz on it.
> > > >
> > >
> > > LOL! nah, it might look like that, Mr Buzzy, bad press.
> > >
> > > but I reckon Dale has upped the anti. Fortune favours the bold, etc.
> > >
> > > Dale (like lots of community ppl) is willing to put his time and
> > > energy into a project to help the community. Same goes for people
> > > creating open source code, user group managers, presentation givers,
> > > people using their businesses to help out, Adobe staffers going above
> > > and beyond, etc.
> > >
> > > more power to his (drinking) arm. and the others who give contribute
> > > and energy.
> > >
> > > now, all that's needed is for others to do just a little bit to add to
> > > this. If _everyone_ said "someone else can do this" then where would
> > > we be?
> > >
> > > CFCamp in coming up soon (still deep in planning, peeps, hang in
> > > there) so with a bit of proactive effort with the presentations on
> > > offer, others can add to this too. And that's just one avenue for
> > > content.
> > >
> > > CF8 is a great product. I can't wait to use the stuff. it's the bits
> > > around the edges that could do with a shot in the arm. Every single
> > > programmer has been touched somehow with "community goodness" but
> > > where does that community come from? Today you use community help in
> > > some way, tomorrow the team you lead or business you own will have
> > > help too, but only if people chip in. Being a knocker is easy. Doing a
> > > bit to help out, though, is not hard.
> > >
> > > Dale's project will get my CFCamp presso. Who's with me? if people
> > > don't like the recycling analogy, how about "giving blood"? A "pint"
> > > (code example) could save someone's "life" (job) one day...
> > >
> > > eh my 2c.
> > > barry.b
> > >
> > >
> > > www.aegeon.com.au
> > > Phone: +613  8676 4223
> > > Mobile: 0404 998 273
> > >
> > >
>
> >
>


-- 



Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] changing data source in an application

[Scott Thornton]

thanks guys, will look into it today.

>>> "Maximilian Nyman" <[EMAIL PROTECTED]> 29/08/2007 5:01 pm >>>

So if I understand your problem correctly, you want the
cfapplication.clientstorage to change depending on the user selection?
If that's what you asking for, then the answer is simple - You can't. Sorry
The clientstorage is in the application scope and cannot be change or
one session only.

Now for the #DNS# issue. Just add session.DNS=this_dns (or
request.DNS=this_dns) right after your conditional this_dns
assignment.
CF will go just go through the scopes until if finds the first
occurrence of "DNS" (which means that in this case it might actually
be better to use the request scope as it will save CF one
scope-look-up-step).



   




/Max

On 8/29/07, Scott Thornton <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Apologies for this question.
>
> I am attempting to fix a problem written by someone else. (truly!)
>
> The scenario is the user needs to be able to select which database to connect 
> to from a drop down box on the password screen
>
> In Application.cfm I have:
>
> 
>  setclientcookies="Yes" clientstorage="#this_dsn#">
>
> and within the file : _db_settings.cfm
>
> 
> 
> 
> 
>
>
> Session.change_db is set on the password screen action page. The password 
> page is reached after the Application.cfm has executed obviously as the DSN 
> still points to the other database.
>
> The password pages are within another folder from the root directory of the 
> app.
>
> CF MX 6.1.
>
> I'd appreciate any helpful comments on how to make this work.
>
> Thanks,
>




--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Query Help

[Charlie Arehart \(lists account\)]

Dale, it just seems you're asking SQL (and the DBMS, and indeed traditional
relational design) to solve a problem it's not meant for. What you need is
text indexing and related functionality. 
 
You mentioned using SQL Server in your first note of the thread. What
version? Text indexing is much improved in both 2000 and 2005. You may find
that it has just the solutions you need.
 
Similarly, even CF's Verity might offer functionality to help. I'm pretty
sure it's got more power than most people realize, even in the free version
bundled with CF. Of course, to do it, you'd need to index your query
results. For some situations, that's not optimal, but it may be better than
the SQL hacks you're attempting. :-)
 
Trying to help.
 
/charlie
 

  _  

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Wednesday, August 29, 2007 5:42 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help



But it's a string with lots of words in it

 

"one two six sixteen"

 

So like '%six%' wouldn't work because it would also get sixteen

 

So like '% one %' wouldn't work as there is no space in front of one

 

So ' ' + field + ' ' like '% one %' should do it, just wonder if there is a
better way.

 

Also what to do with getting all words in a unique list, I could just loop
over the query and build a struct, but there might be a better way also.

 

Regards

Dale Fraser

 

http://dalefraser.blogspot.com

 


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Query Help

[Dale Fraser]

But it's a string with lots of words in it

 

"one two six sixteen"

 

So like '%six%' wouldn't work because it would also get sixteen

 

So like '% one %' wouldn't work as there is no space in front of one

 

So ' ' + field + ' ' like '% one %' should do it, just wonder if there is a
better way.

 

Also what to do with getting all words in a unique list, I could just loop
over the query and build a struct, but there might be a better way also.

 

Regards

Dale Fraser

 

http://dalefraser.blogspot.com

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Wednesday, 29 August 2007 11:51 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help

 

 

 

Dale,

 

'% cheese %'

 

Seems to defeat the purpose of having a like, if you put spaces I would say
that the %'s are no longer needed.

 

Anyway I am still not sure what the question is, but it is late.



 

On 8/29/07, Dale Fraser <[EMAIL PROTECTED]> wrote: 

I have a database with a field that defines a space delimited list of
keywords or tags.

 

For example

 

Item 1

cheese bread rice noodles

 

Item 2

cheese wine fruit rice

 

There are tags against every record, and I know this isn't normalised data
but I need to do two things.

 

1.  Generate a list of unique tags from all records
from about would get cheese bread wine fruit rice noodles

2.  I also then need a query that can pull out the entries matching a tag

 

For example

 

Select * from table where tag like '%cheese%'

 

That won't quite work as there could be a tag cheesey

 

So I thought I could do

 

Select * from table where ' ' + tag + ' ' like '% cheese %'

Which would probably work, but not sure if there is a better way.

 

MS SQL if that makes a difference. Was half wondering if I could setup a
word index to do these 2 things or similar.

 

Regards

Dale Fraser

 

http://dalefraser.blogspot.com  

 


www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273 


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Web on the Piste animations

[Scott Barnes]

Well apparently a "Scott Barnes" is on NZ most wanted list (true story).
Customs guy saw me come through and went "Please follow me Sir". They later
told me what was going on and i just shook my head and thought ... Adobe..
what will they do next :)

I say this as Matt was laughing..like he knew something I didn't.. i'm
watching you Matt.. watching you! :)

Besides, this is the way of Microsoft.. heheh


On 8/28/07, Barry Beattie <[EMAIL PROTECTED]> wrote:
>
>
> BTW, Scott...
>
> what's this I hear about you gas-bagging on far too long (really?
> never!) and missing the flight call, having to get personally paged,
> holding the flight up and almost being late to arrive back (with dire
> consequences)...?
>
> >
>


-- 
Regards,
Scott Barnes
http://www.mossyblog.com

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: List/Menu Question.

[Charlie Arehart \(lists account\)]

Um, Steve, I did do a listlast to get the cost. That was my first example. I
see below it got all mashed onto one line for some reason, so perhaps you
missed that. No worries.

I did go on to explain, though, that if one used any other list function, it
could be compromised by their being that separator string (" - ") in that
first description field. The listlast worked, indeed because it seems
reasonable to presume that cost would never have the " - " in it. As I said,
if it ever could, then no, this would no longer work.

/charlie

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
Sent: Wednesday, August 29, 2007 2:18 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: List/Menu Question.


Even that though, if the value was 



and the description was "Item1 - blue" then the description would only get
the "Item1" part.

If you know the last item in the list is always going to be the cost you
could use the ListLast() to get the cost value and then do something like..

desc = listSetAt(list,  listLen(list),  "" ,  "-") to strip out the cost
part of the string and leave the rest.

This is ofcourse if you know that things are going ot be in specific
positions.  In that instance when you have values that could hold the
delimiter your using, put them last like "COST - DESCRIPTION", that way you
can be certain that ListFirst() gets the cost and ListRest() gets you
everything else.

Steve

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart (lists account)
Sent: Thursday, 30 August 2007 2:17 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: List/Menu Question.


Travis, do you mean that when the form is submitted, you want to take the
form field (shippingservice, which has 2 values in it) and split that into 2
separate variables? You can do that using list functions that split the
string at the " - ". Consider this:

  


desc=#desc#

cost=#cost#


Now, someone may ask why I didn't just use listgetat, as in:

 

The problem comes as soon as the description itself had a " - " in it, which
seems reasonable. Consider this:


That listgetat code would produce the wrong result, splitting on the first
dash, and returning cost=blue. Since the cost is not likely to ever have a "
- " in it, the listfirst and listlast seem the better choice. 

There are, of course, still other ways to skin the cat, and some will want
to talk about the performance of list functions, and why the heck are you
doing such basic coding, why aren't you using CFCs and objects. I won't go
there. Sometimes people are still walking in CFML. Let the runners pass. Not
everyone's in a race.

That said, I will note that I always lament seeing query-driven selects
being built by hand that way. That's what CFSELECT does in one tag. I know,
some don't like that it forces you to use CFFORM. That's my lament. There's
no reason it should have to. Unlike other CFFORM tags, this use of CFSELECT
has nothing to do with Javascript or Flash. I'll leave that for Travis and
others to consider on their own.

/charlie

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of TJS
Sent: Wednesday, August 29, 2007 10:19 AM
To: cfaussie
Subject: [cfaussie] List/Menu Question.


Hi Everyone,

I was wondering whether anyone knew of a simple solution to the
following:-

 

#Freight.Description# - #Freight.Cost#

 

As you can see in the code above, a CFLOOP is being used to populate the
options of a List/Menu inside a form.

What I would like to do is put the #Freight.Description# and #Freight.Cost#
into two seperate session variables.

i.e:-




At the moment, my single session variable includes both description and
cost.

Many thanks in advance to any suggestions.

Cheers,

Travis.











--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: List/Menu Question.

[Steve Onnis]

Even that though, if the value was 



and the description was "Item1 - blue" then the description would only get
the "Item1" part.

If you know the last item in the list is always going to be the cost you
could use the ListLast() to get the cost value and then do something like..

desc = listSetAt(list,  listLen(list),  "" ,  "-") to strip out the cost
part of the string and leave the rest.

This is ofcourse if you know that things are going ot be in specific
positions.  In that instance when you have values that could hold the
delimiter your using, put them last like "COST - DESCRIPTION", that way you
can be certain that ListFirst() gets the cost and ListRest() gets you
everything else.

Steve

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart (lists account)
Sent: Thursday, 30 August 2007 2:17 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: List/Menu Question.


Travis, do you mean that when the form is submitted, you want to take the
form field (shippingservice, which has 2 values in it) and split that into 2
separate variables? You can do that using list functions that split the
string at the " - ". Consider this:

  


desc=#desc#

cost=#cost#


Now, someone may ask why I didn't just use listgetat, as in:

 

The problem comes as soon as the description itself had a " - " in it, which
seems reasonable. Consider this:


That listgetat code would produce the wrong result, splitting on the first
dash, and returning cost=blue. Since the cost is not likely to ever have a "
- " in it, the listfirst and listlast seem the better choice. 

There are, of course, still other ways to skin the cat, and some will want
to talk about the performance of list functions, and why the heck are you
doing such basic coding, why aren't you using CFCs and objects. I won't go
there. Sometimes people are still walking in CFML. Let the runners pass. Not
everyone's in a race.

That said, I will note that I always lament seeing query-driven selects
being built by hand that way. That's what CFSELECT does in one tag. I know,
some don't like that it forces you to use CFFORM. That's my lament. There's
no reason it should have to. Unlike other CFFORM tags, this use of CFSELECT
has nothing to do with Javascript or Flash. I'll leave that for Travis and
others to consider on their own.

/charlie

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of TJS
Sent: Wednesday, August 29, 2007 10:19 AM
To: cfaussie
Subject: [cfaussie] List/Menu Question.


Hi Everyone,

I was wondering whether anyone knew of a simple solution to the
following:-

 

#Freight.Description# - #Freight.Cost#

 

As you can see in the code above, a CFLOOP is being used to populate the
options of a List/Menu inside a form.

What I would like to do is put the #Freight.Description# and #Freight.Cost#
into two seperate session variables.

i.e:-




At the moment, my single session variable includes both description and
cost.

Many thanks in advance to any suggestions.

Cheers,

Travis.








--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: List/Menu Question.

[Charlie Arehart \(lists account\)]

Travis, do you mean that when the form is submitted, you want to take the
form field (shippingservice, which has 2 values in it) and split that into 2
separate variables? You can do that using list functions that split the
string at the " - ". Consider this:






desc=#desc#

cost=#cost#


Now, someone may ask why I didn't just use listgetat, as in:




The problem comes as soon as the description itself had a " - " in it, which
seems reasonable. Consider this:


That listgetat code would produce the wrong result, splitting on the first
dash, and returning cost=blue. Since the cost is not likely to ever have a "
- " in it, the listfirst and listlast seem the better choice. 

There are, of course, still other ways to skin the cat, and some will want
to talk about the performance of list functions, and why the heck are you
doing such basic coding, why aren't you using CFCs and objects. I won't go
there. Sometimes people are still walking in CFML. Let the runners pass. Not
everyone's in a race.

That said, I will note that I always lament seeing query-driven selects
being built by hand that way. That's what CFSELECT does in one tag. I know,
some don't like that it forces you to use CFFORM. That's my lament. There's
no reason it should have to. Unlike other CFFORM tags, this use of CFSELECT
has nothing to do with Javascript or Flash. I'll leave that for Travis and
others to consider on their own.

/charlie

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of TJS
Sent: Wednesday, August 29, 2007 10:19 AM
To: cfaussie
Subject: [cfaussie] List/Menu Question.


Hi Everyone,

I was wondering whether anyone knew of a simple solution to the
following:-

 

#Freight.Description# - #Freight.Cost#

 

As you can see in the code above, a CFLOOP is being used to populate the
options of a List/Menu inside a form.

What I would like to do is put the #Freight.Description# and #Freight.Cost#
into two seperate session variables.

i.e:-




At the moment, my single session variable includes both description and
cost.

Many thanks in advance to any suggestions.

Cheers,

Travis.





--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: List/Menu Question.

[Steve Onnis]

Neither
If it's a query just store the query in the session scope and loop over it
that way

mailto:[EMAIL PROTECTED] On Behalf
Of TJS
Sent: Thursday, 30 August 2007 12:19 AM
To: cfaussie
Subject: [cfaussie] List/Menu Question.


Hi Everyone,

I was wondering whether anyone knew of a simple solution to the
following:-

 

#Freight.Description# - #Freight.Cost#

 

As you can see in the code above, a CFLOOP is being used to populate the
options of a List/Menu inside a form.

What I would like to do is put the #Freight.Description# and #Freight.Cost#
into two seperate session variables.

i.e:-




At the moment, my single session variable includes both description and
cost.

Many thanks in advance to any suggestions.

Cheers,

Travis.





--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] List/Menu Question.

[TJS]

Hi Everyone,

I was wondering whether anyone knew of a simple solution to the
following:-

 

#Freight.Description# - #Freight.Cost#

 

As you can see in the code above, a CFLOOP is being used to populate
the options of a List/Menu inside a form.

What I would like to do is put the #Freight.Description# and
#Freight.Cost# into two seperate session variables.

i.e:-




At the moment, my single session variable includes both description
and cost.

Many thanks in advance to any suggestions.

Cheers,

Travis.


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: learncf.com is Coming!

[M@ Bourke]

>what we all really wish that we could have done if we had the time to

anyone sleeping more then 4 hours a day is wasting time

On 8/29/07, Andrew Scott <[EMAIL PROTECTED]> wrote:
>
> Well said.
>
> And its good that Dale has stood up and done what we all really wish that
> we could have done if we had the time to...
>
> Grats Dale.
>
>
> On 8/29/07, Barry Beattie <[EMAIL PROTECTED]> wrote:
>
> >
> > >
> > > Now you've put the mozz on it.
> > >
> >
> > LOL! nah, it might look like that, Mr Buzzy, bad press.
> >
> > but I reckon Dale has upped the anti. Fortune favours the bold, etc.
> >
> > Dale (like lots of community ppl) is willing to put his time and
> > energy into a project to help the community. Same goes for people
> > creating open source code, user group managers, presentation givers,
> > people using their businesses to help out, Adobe staffers going above
> > and beyond, etc.
> >
> > more power to his (drinking) arm. and the others who give contribute and
> > energy.
> >
> > now, all that's needed is for others to do just a little bit to add to
> > this. If _everyone_ said "someone else can do this" then where would
> > we be?
> >
> > CFCamp in coming up soon (still deep in planning, peeps, hang in
> > there) so with a bit of proactive effort with the presentations on
> > offer, others can add to this too. And that's just one avenue for
> > content.
> >
> > CF8 is a great product. I can't wait to use the stuff. it's the bits
> > around the edges that could do with a shot in the arm. Every single
> > programmer has been touched somehow with "community goodness" but
> > where does that community come from? Today you use community help in
> > some way, tomorrow the team you lead or business you own will have
> > help too, but only if people chip in. Being a knocker is easy. Doing a
> > bit to help out, though, is not hard.
> >
> > Dale's project will get my CFCamp presso. Who's with me? if people
> > don't like the recycling analogy, how about "giving blood"? A "pint"
> > (code example) could save someone's "life" (job) one day...
> >
> > eh my 2c.
> > barry.b
> >
> >
> > www.aegeon.com.au
> > Phone: +613  8676 4223
> > Mobile: 0404 998 273
> > > >
> >

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Query Help

[Andrew Scott]

Dale,

'% cheese %'

Seems to defeat the purpose of having a like, if you put spaces I would say
that the %'s are no longer needed.

Anyway I am still not sure what the question is, but it is late.



On 8/29/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
>  I have a database with a field that defines a space delimited list of
> keywords or tags.
>
>
>
> For example
>
>
>
> Item 1
>
> cheese bread rice noodles
>
>
>
> Item 2
>
> cheese wine fruit rice
>
>
>
> There are tags against every record, and I know this isn't normalised data
> but I need to do two things.
>
>
>
> 1.  Generate a list of unique tags from all records
> from about would get cheese bread wine fruit rice noodles
>
> 2.  I also then need a query that can pull out the entries matching a tag
>
>
>
> For example
>
>
>
> Select * from table where tag like '%cheese%'
>
>
>
> That won't quite work as there could be a tag cheesey
>
>
>
> So I thought I could do
>
>
>
> Select * from table where ' ' + tag + ' ' like '% cheese %'
>
> Which would probably work, but not sure if there is a better way.
>
>
>
> MS SQL if that makes a difference. Was half wondering if I could setup a
> word index to do these 2 things or similar.
>
>
>
> Regards
>
> Dale Fraser
>
>
>
> http://dalefraser.blogspot.com
>
>
>
> >
>
>


-- 



Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: learncf.com is Coming!

[Andrew Scott]

Well said.

And its good that Dale has stood up and done what we all really wish that we
could have done if we had the time to...

Grats Dale.


On 8/29/07, Barry Beattie <[EMAIL PROTECTED]> wrote:
>
>
> >
> > Now you've put the mozz on it.
> >
>
> LOL! nah, it might look like that, Mr Buzzy, bad press.
>
> but I reckon Dale has upped the anti. Fortune favours the bold, etc.
>
> Dale (like lots of community ppl) is willing to put his time and
> energy into a project to help the community. Same goes for people
> creating open source code, user group managers, presentation givers,
> people using their businesses to help out, Adobe staffers going above
> and beyond, etc.
>
> more power to his (drinking) arm. and the others who give contribute and
> energy.
>
> now, all that's needed is for others to do just a little bit to add to
> this. If _everyone_ said "someone else can do this" then where would
> we be?
>
> CFCamp in coming up soon (still deep in planning, peeps, hang in
> there) so with a bit of proactive effort with the presentations on
> offer, others can add to this too. And that's just one avenue for
> content.
>
> CF8 is a great product. I can't wait to use the stuff. it's the bits
> around the edges that could do with a shot in the arm. Every single
> programmer has been touched somehow with "community goodness" but
> where does that community come from? Today you use community help in
> some way, tomorrow the team you lead or business you own will have
> help too, but only if people chip in. Being a knocker is easy. Doing a
> bit to help out, though, is not hard.
>
> Dale's project will get my CFCamp presso. Who's with me? if people
> don't like the recycling analogy, how about "giving blood"? A "pint"
> (code example) could save someone's "life" (job) one day...
>
> eh my 2c.
> barry.b
>
> >
>


-- 



Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: learncf.com is Coming!

[Barry Beattie]

>
> Now you've put the mozz on it.
>

LOL! nah, it might look like that, Mr Buzzy, bad press.

but I reckon Dale has upped the anti. Fortune favours the bold, etc.

Dale (like lots of community ppl) is willing to put his time and
energy into a project to help the community. Same goes for people
creating open source code, user group managers, presentation givers,
people using their businesses to help out, Adobe staffers going above
and beyond, etc.

more power to his (drinking) arm. and the others who give contribute and energy.

now, all that's needed is for others to do just a little bit to add to
this. If _everyone_ said "someone else can do this" then where would
we be?

CFCamp in coming up soon (still deep in planning, peeps, hang in
there) so with a bit of proactive effort with the presentations on
offer, others can add to this too. And that's just one avenue for
content.

CF8 is a great product. I can't wait to use the stuff. it's the bits
around the edges that could do with a shot in the arm. Every single
programmer has been touched somehow with "community goodness" but
where does that community come from? Today you use community help in
some way, tomorrow the team you lead or business you own will have
help too, but only if people chip in. Being a knocker is easy. Doing a
bit to help out, though, is not hard.

Dale's project will get my CFCamp presso. Who's with me? if people
don't like the recycling analogy, how about "giving blood"? A "pint"
(code example) could save someone's "life" (job) one day...

eh my 2c.
barry.b

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Query Help

[Dale Fraser]

I have a database with a field that defines a space delimited list of
keywords or tags.

 

For example

 

Item 1

cheese bread rice noodles

 

Item 2

cheese wine fruit rice

 

There are tags against every record, and I know this isn't normalised data
but I need to do two things.

 

1.  Generate a list of unique tags from all records
from about would get cheese bread wine fruit rice noodles

2.  I also then need a query that can pull out the entries matching a tag

 

For example

 

Select * from table where tag like '%cheese%'

 

That won't quite work as there could be a tag cheesey

 

So I thought I could do

 

Select * from table where ' ' + tag + ' ' like '% cheese %'

Which would probably work, but not sure if there is a better way.

 

MS SQL if that makes a difference. Was half wondering if I could setup a
word index to do these 2 things or similar.

 

Regards

Dale Fraser

 

http://dalefraser.blogspot.com

 


--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: learncf.com is Coming!

[MrBuzzy]

Now you've put the mozz on it.

On 8/29/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
> If I don't get a single tutorial from cfaussie I will be very disappointed.
>
> Regards
> Dale Fraser
>
> http://dalefraser.blogspot.com
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Dale Fraser
> Sent: Tuesday, 28 August 2007 9:46 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: learncf.com is Coming!
>
>
> Thanks Ray,
>
> I can imagine it could have other handy uses to split up a query.
>
> I must admit that I'm quite a fan of the new grid, it's very sexy, the
> paging is cool and I'm sure it will only get better.
>
> Regards
> Dale Fraser
>
> http://dalefraser.blogspot.com
>
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Raymond Camden
> Sent: Tuesday, 28 August 2007 9:18 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: learncf.com is Coming!
>
>
> To be anal - the function returns a structure. It also contains the
> total # of rows I believe. I'm just warning folks in case they try to
> use it w/ returntype="query".
>
> On 8/27/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
> > Andrew,
> >
> > I think perhaps you don't understand the following line
> >
> > 
> >
> >
> >
> > According to the docs
> >
> >
> > Converts query data to a structure that contains a paged subset of the
> > query. Used in CFC functions that return data to Ajax format cfgrid
> controls
> > in response to a bind
> >
> > Expression.
>
> --
> ===
> Raymond Camden, Camden Media
>
> Email: [EMAIL PROTECTED]
> Blog  : www.coldfusionjedi.com
> AOL IM : cfjedimaster
>
> Keep up to date with the community: http://www.coldfusionbloggers.org
>
>
>
>
>
> >
>

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: learncf.com is Coming!

[Dale Fraser]

If I don't get a single tutorial from cfaussie I will be very disappointed.

Regards
Dale Fraser

http://dalefraser.blogspot.com

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Tuesday, 28 August 2007 9:46 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: learncf.com is Coming!


Thanks Ray,

I can imagine it could have other handy uses to split up a query.

I must admit that I'm quite a fan of the new grid, it's very sexy, the
paging is cool and I'm sure it will only get better.

Regards
Dale Fraser

http://dalefraser.blogspot.com


-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Raymond Camden
Sent: Tuesday, 28 August 2007 9:18 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: learncf.com is Coming!


To be anal - the function returns a structure. It also contains the
total # of rows I believe. I'm just warning folks in case they try to
use it w/ returntype="query".

On 8/27/07, Dale Fraser <[EMAIL PROTECTED]> wrote:
> Andrew,
>
> I think perhaps you don't understand the following line
>
> 
>
>
>
> According to the docs
>
>
> Converts query data to a structure that contains a paged subset of the
> query. Used in CFC functions that return data to Ajax format cfgrid
controls
> in response to a bind
>
> Expression.

-- 
===
Raymond Camden, Camden Media

Email: [EMAIL PROTECTED]
Blog  : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.org





--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: changing data source in an application

[Maximilian Nyman]

So if I understand your problem correctly, you want the
cfapplication.clientstorage to change depending on the user selection?
If that's what you asking for, then the answer is simple - You can't. Sorry
The clientstorage is in the application scope and cannot be change or
one session only.

Now for the #DNS# issue. Just add session.DNS=this_dns (or
request.DNS=this_dns) right after your conditional this_dns
assignment.
CF will go just go through the scopes until if finds the first
occurrence of "DNS" (which means that in this case it might actually
be better to use the request scope as it will save CF one
scope-look-up-step).



   




/Max

On 8/29/07, Scott Thornton <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Apologies for this question.
>
> I am attempting to fix a problem written by someone else. (truly!)
>
> The scenario is the user needs to be able to select which database to connect 
> to from a drop down box on the password screen
>
> In Application.cfm I have:
>
> 
>  setclientcookies="Yes" clientstorage="#this_dsn#">
>
> and within the file : _db_settings.cfm
>
> 
> 
> 
> 
>
>
> Session.change_db is set on the password screen action page. The password 
> page is reached after the Application.cfm has executed obviously as the DSN 
> still points to the other database.
>
> The password pages are within another folder from the root directory of the 
> app.
>
> CF MX 6.1.
>
> I'd appreciate any helpful comments on how to make this work.
>
> Thanks,
>

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---