Client variables in external database?

2000-07-15 Thread Kevin Miller
We are doing experimentation with client variables, but want to store then in an external database to prepare for a clustered environment. What database shema is needed for this? I understand that a DSN must be created that points to a database, but I can find no documentation that describes

RE: Client variables in external database?

2000-07-15 Thread Akbar
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 go to http://www.sys-con.com/coldfusion/index2.cfm and go to the "feature stories" and then go to volume 2 issue 6 second article. thats the best ever available on the client variables mgmt regards akbar - -Original Message- From: Kevin Mil

cflock - BAH!

2000-07-15 Thread Bud
Geesh. You'd think Allaire would give at least a LITTLE thought to backward compatibility. I've discovered that setting session, application variables, etc. MUST be set with a lock if CF 4.5 administration is set to make that mandatory. OK, I can live with that, but you MUST set the SCOPE in t

RE: CFLOCK - HEELLLLPPP!!! Never mind

2000-07-15 Thread Duane Boudreau
> Hi. I wasn't setting the type or scope in the cflock tag. Nothing in > Mr. Forta's book about the scope or type attributes. :) That's because the scope attribute was introduced in version 4.5 and Ben's Bible only covers 4.0 Duane Boudreau CFExperts.Com ---

Re: cflock - BAH!

2000-07-15 Thread Larry W. Virden
From: Bud <[EMAIL PROTECTED]> > an error. What a crock. So now, everything I've developed I have to > make 2 copies of, one with scope= and one without. And to develop Is there no way to use CFIF to say "if older ColdFusion don't use scope= else use scope=" ? > Am I ranting for nothing? Pro

RE: Variable IN a list? How to check?

2000-07-15 Thread Duane Boudreau
> > > Try to use the List functions, or extend the CFIf to be; > > > > > > which is faster than the List functions > > > > This would only work if the item were not the first or last > element in the > > list. > > > > Either you would have to use a reg expression or ListFind(list, > string [, > >

RE: cflock - BAH!

2000-07-15 Thread Duane Boudreau
> > an error. What a crock. So now, everything I've developed I have to > > make 2 copies of, one with scope= and one without. And to develop > > Is there no way to use CFIF to say "if older ColdFusion don't use scope= > else use scope=" ? Server.ColdFusion.ProductVersion -

RE: Client variables in external database?

2000-07-15 Thread paul smith
One of the most annoying websites I've seen. At 05:59 PM 7/15/00 +0800, you wrote: >go to http://www.sys-con.com/coldfusion/index2.cfm > >and go to the "feature stories" and then go to volume 2 issue 6 second >article. thats the best ever >available on the client variables mgmt -

Search---help

2000-07-15 Thread Vikram Ponuganti
Hi, Iam new to cold fusion could any of the pros help me out.. Well i have a search form where in i use the sql query to retrive the matching data... when i display the data I want the color of the matching text to be different,.,.. expectin some fast help regards Vikram

Re: Search---help

2000-07-15 Thread Dick Applebaum
Try: #ReReplaceNoCase(dbfield, "(#SearchWords#)", "\1", "ALL")# At 5:46 AM -0700 7/15/2000, Vikram Ponuganti wrote: >Hi, >Iam new to cold fusion could any of the pros help me out.. > >Well i have a search form where in i use the sql query to retrive > >the matching data... when i displa

RE: OT: mail transfer agents

2000-07-15 Thread Benjamin S. Rogers
I've had to research this problem in the past. In the company for which I used to work, we had three different server admins in three different offices, each running a different MTA (VOPmail on NT, SendMail on Linux, and qMail on Linux). We ran into problems with qMail accepting mail from our VOPm

searching for key words using cf

2000-07-15 Thread AustralianAccommodation.com Pty. Ltd.
I need to extract out of the database those records who value in the Property Name field contain a certain work eg Sofitel Hotel I need to find the record by searching the property name field for the word "hotel" Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Webs

RE: searching for key words using cf

2000-07-15 Thread Bill Killillay
Claude, In your sql statement you just need to do it something like so: Select Hotel, City, Phone >From YourDatabase Where Hotel Like '%search_string%' Order By Hotel That where statement is the key, it would return anything with the word Hotel in it. You can set it up to search anything. Let

RE: searching for key words using cf

2000-07-15 Thread Matthew Walker
> I need to extract out of the database those records who value in the > Property Name field contain a certain work > > eg Sofitel Hotel > > I need to find the record by searching the property name field > for the word > "hotel" Something like... SELECT PropertyID FROM Property WHERE Property

Re: cflock - BAH!

2000-07-15 Thread Bud
On 7/15/00, Larry W. Virden penned: >Is there no way to use CFIF to say "if older ColdFusion don't use scope= >else use scope=" ? Not that I can tell. I've tried putting iif() inside the cflock tag testing for Server.ColdFusion.ProductVersion: "ERROR!" Tried putting cfif/cfelse inside the cfloc

Re: Variable IN a list? How to check?

2000-07-15 Thread Angel Stewart
Yeah well this one win, dread. This man went and did Time Trials on the loop =) Now I'm totally confused as to which method to use.. A CFLOOP with a Or one with a NOT GetListAt. (bear in mind that for htis particular problem, #DeptID# is a list of values,not necessarily a single value). -Gel

More Records from long query

2000-07-15 Thread Gordon Burns
I have a form where the user can check up 10 check boxes. These relate to Yes No fields The form passes the information to a search " find me one where A is Yes and D is YES and G is YES. This often brings up 100 records if not many check boxes are ticked. I need to restrict the listing to 2

RE: Variable IN a list? How to check?

2000-07-15 Thread David Gassner
Use ListFind, which looks for a complete value: David > -Original Message- > From: Angel Stewart [mailto:[EMAIL PROTECTED]] > Sent: Saturday, July 15, 2000 6:52 AM > To: [EMAIL PROTECTED] > Subject: Re: Variable IN a list? How to check? > > > Yeah well this one win, dread. > > This man

RE: Search---help

2000-07-15 Thread David Gassner
Vikram, you can do a quick replace function while outputting the value that looks something like this: #replace(dbvalue, searchstring, "#searchstring#", "all")# David > -Original Message- > From: Vikram Ponuganti [mailto:[EMAIL PROTECTED]] > Sent: Saturday, July 15, 2000 5:47 AM >

RE: cflock - BAH!

2000-07-15 Thread Ryan Hill
Bud, Have you tried turing off 'enforce strict attribute validation' in CFAS on your 4.01 server? This should probably allow you to leave the scope params in each tag and while 4.5 will happily understand it, 4.01 should just ignore it. I can sympathise with the version woes, but as others ha

Re: Client variables in external database?

2000-07-15 Thread Sean Renet
The simplest way for you to see the data structure is just let CF Server create the tables for you when you endable the client variables for the datasource. Then just make sure every box has that datasource registered and point your cfapplication to that datasource and you are ready to roll.

Re: Client variables in external database?

2000-07-15 Thread paul smith
This article contains a nice description of this: http://www.sys-con.com/coldfusion/archives/0206/funaro/index.html best, paul At 04:28 AM 7/15/00 -0500, you wrote: >We are doing experimentation with client variables, but want to store then >in an external database to prepare for a clustered

RE: Client variables in external database?

2000-07-15 Thread Dave Watts
> We are doing experimentation with client variables, but want > to store then in an external database to prepare for a > clustered environment. > > What database shema is needed for this? I understand that a > DSN must be created that points to a database, but I can find > no documentation that

RE: Domain specific cookies with CFCOOKIE

2000-07-15 Thread Dave Watts
> I think this is wrong: > > > Cookies cannot be read from a different domain than where > they are set. > > This is a security precaution built into the cookie specification. > > > Allaire's documentation for the CFCOOKIE tag says: > = > DOMAIN > Specifies the domain for which the c

RE: Help, probably a bad DNS-Problem !

2000-07-15 Thread Dave Watts
> Hi list, we as a customer from a CF- ISP are using a certain > .com-domain. This domain was moving 14 days ago. Up to two days > ago, everything was fine with the connection to the domain. > And then all of a sudden the connection broke. I talked to > the provider and he is 100 % positive that t

cookies?? or what to use

2000-07-15 Thread Kim Ahlbrandt
Ok, I'm new to the list...and new to using coldfusion. I need to ensure that users can only go through the system in a certain order (they must fill out forms in a particular order and should not be allowed to come into any page of the system without first going through the previous pages). D

RE: cflock - BAH!

2000-07-15 Thread Bud
On 7/15/00, Ryan Hill penned: >Bud, > >Have you tried turing off 'enforce strict attribute validation' in CFAS on >your 4.01 server? This should probably allow you to leave the scope params >in each tag and while 4.5 will happily understand it, 4.01 should just >ignore it. Well, the problem is,

Re: cookies?? or what to use

2000-07-15 Thread Dana Larose
It may be simpler to just check the referer page. You can check CGI.HTTP_REFERER to see what page linked or submitted to the current document. Dana -Original Message- From: Kim Ahlbrandt <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday, July 15, 2000 1:08 PM

Re: cookies?? or what to use

2000-07-15 Thread Bud
On 7/15/00, Kim Ahlbrandt penned: >Ok, I'm new to the list...and new to using coldfusion. I need to ensure >that users can only go through the system in a certain order (they must fill >out forms in a particular order and should not be allowed to come into any >page of the system without first go

IsDefined and CFSET problem

2000-07-15 Thread Jim Watkins
The following still allows the CFSET tag to run even though the IsDefined variables are empty and hence an error. This is from a simple mail form asking for Quantity (qty1) and price (uc1) and then calculating a total price (tc1). If Quantity and Price are not filled in I want it to go to next f

RE: Domain specific cookies with CFCOOKIE

2000-07-15 Thread Bud
On 7/15/00, Dave Watts penned: >In any case, CF doesn't control how the browser uses cookies. You could >write CF code all day long to set a cookie for another domain, but that >doesn't mean that the browser will obey that code if the browser has been >designed to follow the cookie specification.

RE: IsDefined and CFSET problem

2000-07-15 Thread Dave Watts
> The following still allows the CFSET tag to run even though > the IsDefined variables are empty and hence an error. This is > from a simple mail form asking for Quantity (qty1) and price > (uc1) and then calculating a total price (tc1). If Quantity > and Price are not filled in I want it to go t

RE: Domain specific cookies with CFCOOKIE

2000-07-15 Thread Dave Watts
> > When I tried just setting a cookie for another domain, CFCOOKIE > > threw an error: > > > > "Error Occurred While Processing Request > > Error Diagnostic Information > > Error attempting to set a cookie value with CFCOOKIE. > > Invalid CFCOOKIE DOMAIN attribute" > > The only time I get that er

RE: Domain specific cookies with CFCOOKIE

2000-07-15 Thread ron
>You can do this: > >It worked for me. Dave, That didn't work for me on CFv4.01... IEv5 still lost the cookie when going from "humankindsystems.com" to "www.humankindsystems.com" (our SSL subdomain). Even worse, Netscape v4.7 couldn't get the cookie at all. So, I added this to the very top of

RE: IsDefined and CFSET problem

2000-07-15 Thread Jim Watkins
Worked perfect! I was misunderstanding the IsDefined function. Thanks -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 15, 2000 12:30 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: IsDefined and CFSET problem > The following still allows

Re: CF Verity Errors

2000-07-15 Thread Chris Giminez
Just encountered the same error. Same scenario. I have done nothing with it lately and it is hosted on a shared server. Have you found the solution? Error Diagnostic Information Error occurred in tag CFINDEX Internal Error: VDKSessionNew failed Error Code: -125 -- Chris Giminez Owner - Cyber

RE: Domain specific cookies with CFCOOKIE

2000-07-15 Thread ron
> So, I added this to the very top of our Application.cfm file (Bud, you > may want to do this as a workaround, too): > >