> Thanks for the wildcard idea, Isaac... that definitely sounds better!
Welcome. :)
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 617.365.5732
http://onTap.riaforge.org/blog
~|
Adobe® ColdFusion® 8
Thanks for the wildcard idea, Isaac... that definitely sounds better!
Rick
> -Original Message-
> From: s. isaac dealey [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 09, 2008 8:49 PM
> To: CF-Talk
> Subject: Re: Need some advice on approach...
>
> > Thanks
> Thanks for the feedback, Isaac...
Welcome.
Actually come to think of it, you can specify an arecord for
*.domain.com as a wild-card for any values that aren't otherwise set for
that domain. So you should be able to make it automatically throw people
into the agents directory with just the one a
Thanks for the feedback, Isaac...
I was actually planning to use url's like "agent.c21ar.com"
and create subdomains (A records in the DNS manager) and then
point those subdomains to the main agents' folder and use
cfif statements to setup the variables for
a particular agent's version of the site.
> To clarify your statement about application.cfm...
>
> Are you suggesting putting an application.cfm in the main agents
> folder, and then having an application.cfm in *each* of the specific
> agents' folders and simply have that "included" application.cfm
> contain the specific variables needed
erver_name or url variables
and a series cfif's and queries?
Rick
> -Original Message-
> From: s. isaac dealey [mailto:[EMAIL PROTECTED]
> Sent: Sunday, June 08, 2008 11:29 AM
> To: CF-Talk
> Subject: Re: Need some advice on approach...
>
> Hey Rick.
>
>
Hey Rick.
Brief recommendation. You mentioned you're using Application.cfm still -
what you might want to do is add an Application.cfm in your /agents
subdirectory to modify whatever the original Application.cfm did to
set up the page...
/root/Application.cfm
original code ...
/root/ag
Hi, all...
I'm working on a real estate website
and for the first time, I'm setting up agents'
sites using subdomains.
I have some ideas on how to approach this, but
I thought I'd ask about those of you with experience
doing this kind of thing to offer advice.
First, on the folder structure. I'
Thanks for all the info, Mary Jo!
It's been ( and will be ) a big help!
Rick
> -Original Message-
> From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 25, 2008 2:24 PM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
>
&
Oops, sorry about that partial post
To reiterate, don't stick the entire query in there, it should be out in a CFC,
or at the very least, in a separate template so if you make any changes, you
aren't updating it in multiple files. You would just use a variable for the
cachedwithin time sort
And to reiterate, don't stick the entire query in there, it should be out in a
CFC, or at the very least, in a separate template so if you make any changes,
you aren't updating it in multiple files. You would just use a variable for the
cachedwithin time sort of like this:
~~
> Is that all there is to it? And this creates a running
> of the query which doesn't involve the browser? Is that what
> this means (from the cfdocs):
Basically, yes, although I wouldn't really think of it in terms of whether or
not the browser is involved, it's more to do with the current run
thread and starts it processing. Code in the
cfthread tag body runs simultaneously and independently of
page-level code and code in other cfthread tags."
Rick
> -Original Message-
> From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 25, 2008 10:32 AM
>
> Where would I find info on how to use a thread like that?
> I don't have a clue... the cf docs? Know of a blog about it?
>
The cfdocs should pretty much cover it, you're just throwing a cfthread tag
with action=run around the code that does the re-cache.
http://livedocs.adobe.com/coldfusion
ow to use a thread like that?
I don't have a clue... the cf docs? Know of a blog about it?
Thanks for the tips!
Rick
> -Original Message-
> From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 24, 2008 7:01 PM
> To: CF-Talk
> Subject: Re: Need s
> After a write operation you would call the same method, passing in a
> setting that will refresh the cache, but you won't actually do
> anything with the dataset that is returned.
BTW - since you don't actually *use* the dataset that is returned, this is a
perfect example of where a cfthread
> However, I didn't see anything addressing the cache refresh
> after any writes. I assume you mean I could just have a select query
> set up to run on the same page after a write query, without actually
> outputting any info to refresh the cache?
>
> Would that be correct?
Yes, exactly. You can
ge after a write query, without actually
outputting any info to refresh the cache?
Would that be correct?
Rick
> -Original Message-
> From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 24, 2008 2:54 PM
> To: CF-Talk
> Subject: Re: Need some ad
> Up till now, my db's have been relatively small
> and fairly quick when being queried. I've never had to bother
> with indexes or other methods of optimizing queries.
>
> However, I've now got a db of about 6400 real estate properties.
In addition to the indexing, have you considering just cac
Works like a charm! Thanks, guys!
Rick
> -Original Message-
> From: Dominic Watson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 24, 2008 12:39 PM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
>
> Yup, not sure I'd call it a var
ick
>
>
>
> > -Original Message-
> > From: Dominic Watson [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, April 24, 2008 12:02 PM
> > To: CF-Talk
> > Subject: Re: Need some advice on speeding up query...
> >
> > > I don't understand tha
From: Dominic Watson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 24, 2008 12:02 PM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
>
> > I don't understand that, Dominic.
> >
> > What does the 'acr' refer to?
>
> It's just
with SELECT ... , 'acr' AS propertyType ... Dominic is creating a query
column propertyType with value 'acr'.
he just basically created 'in-memory' propertyType column - it exists
only in this particular query. but it is returned in query results and
you can use it as any other query column - i.e.
> I don't understand that, Dominic.
>
> What does the 'acr' refer to?
It's just a string, it doesn't *refer* to anything and it could be set
to anything you want - I set it to 'acr' because the table was called
smlc_acr.
So what I am doing there is selecting a 'propertyType' based on the
table th
4, 2008 8:24 AM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
>
> > If I did that for the "commercial properties" table, then I'd have a
> > property_type
> > field in each property table that I could add to the url link and pass to
> If I did that for the "commercial properties" table, then I'd have a
> property_type
> field in each property table that I could add to the url link and pass to the
> property details page to specify which table to search for the property.
I don't think you would need to add the property type f
e
property details page to specify which table to search for the property.
Thanks for the input!
Rick
> -Original Message-
> From: Dominic Watson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 24, 2008 5:36 AM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up q
This is a common problem. It sounds like having a single table with all of
the fields plus an extra field for the property 'type' may be a good idea -
or, in you Union query, select the property type for each row and pass that
in the Url, so:
select sa.street_number as prop_street_number...etc
how and where is that url/link generated? can you also pass the property
type in the url? that can tell you which table to query...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Rick Faircloth wrote:
> Now's here's a new problem I haven't encountered.
>
> How do I use a url variable to l
Message-
> From: Jon Clausen [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 24, 2008 12:28 AM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
>
> Rick,
>
> Based on what I can see, it appears that the tables are separated by
> property type (comme
, April 24, 2008 12:06 AM
> To: CF-Talk
> Subject: RE: Need some advice on speeding up query...
>
> > How do I use a url variable to link to a property details
> > page when the properties are in 8 different tables? The
> > issue really isn't the variable, since I can
Rick,
Based on what I can see, it appears that the tables are separated by
property type (commercial, residential, lot, multiunit, etc.). You
would need to add a column in the table to identify that type, but it
seems to me - as long as they are identical in structure as it seems -
that m
> How do I use a url variable to link to a property details
> page when the properties are in 8 different tables? The
> issue really isn't the variable, since I can use the aliased
> variable "property_id" (once I add it to the query).
>
> I know I could use
> property_details.cfm?property_id=
Now's here's a new problem I haven't encountered.
How do I use a url variable to link to a property details page
when the properties are in 8 different tables? The issue really isn't
the variable, since I can use the aliased variable "property_id" (once I add it
to the query).
I know I could us
have a "normal" index
> on the mls_number, but I can see how "unique" would be better.
>
> Thanks for the help!
>
> Rick
>
> > -Original Message-
> > From: Dominic Watson [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, April 23, 2
om: Dominic Watson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 23, 2008 3:43 AM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
>
> Just a note on indexes - every one of your tables should have at least one
> unique constraint or index *other* than the pri
gination settings.
Any other thoughts on this? (Especially good examples/tutorials of this usage?)
Thanks,
Rick
> -Original Message-
> From: Jarlath Gallagher [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 23, 2008 6:29 AM
> To: CF-Talk
> Subject: Re: Need some
Yes, I'm using "union all", too.
Thanks...
Rick
> -Original Message-
> From: James Holmes [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 22, 2008 11:18 PM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
>
> Did you try the U
Just a note on indexes - every one of your tables should have at least one
unique constraint or index *other* than the primary key. This way, the
primary key is not what makes a row in your table unique - it just
identifies it for relationship purposes.
This helps to avoid duplicate data and helps
Hey there,
Not sure if this input will alleviate your issues more than the methods
mentioned previously but i had a similar problem polling the gracenote db for a
massive number of matching records.
The method i used was to run the SQL Analyzer tool primarily to streamline my
query but also o
Did you try the UNION ALL as suggested by Rizal? This might make it a
little quicker as the DB won't have to scan for duplicates.
On Wed, Apr 23, 2008 at 11:03 AM, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
> If I had set up the original db that's providing the
> data, it would have definitely bee
earch page, either.
But again, if you've got any more ideas, let me know!
Thanks for the help!
Rick
> -Original Message-
> From: James Holmes [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 22, 2008 9:27 PM
> To: CF-Talk
> Subject: Re: Need some advice on spe
Well, apart from a DB redesign so that you can do 1 query instead of a
union of 5, lets look at the first query as an example:
select sa.street_number as prop_street_number, sa.street_name as
prop_street_name,
sa.city as prop_city, sa.public_remarks_01 as prop_public_remarks_01,
Rick
> -Original Message-
> From: Rizal Firmansyah [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 22, 2008 9:18 PM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
>
> Hi Rick,
> index will speed up the query if used correctly.
>
> I thin
Hi Rick,
index will speed up the query if used correctly.
I think you can put index on these tables
smlc_acr_photos -> photo_mls_number
smlc_com_photos -> photo_mls_number
smlc_lot_photos -> photo_mls_number
smlc_ren_photos -> photo_mls_number
smlc_res_photos -> photo_mls_number
Also if the c
Hi, all...
Up till now, my db's have been relatively small
and fairly quick when being queried. I've never had to bother
with indexes or other methods of optimizing queries.
However, I've now got a db of about 6400 real estate properties.
I've put together a "Browse Properties" page, which retu
F and Legacy Systems... Need Some Advice/Help
Che,
>Dan, the server will be on Windows. I'm basically using everyone's
>replies as a vote for how this should be handled. I don't want to
>re-invent the wheel and that is why I have my doubts with doing this
>via F
Che,
>Dan, the server will be on Windows. I'm basically using everyone's replies
>as a vote for how this should be handled. I don't want to re-invent the
>wheel and that is why I have my doubts with doing this via FTP.
Unix definitely handles FTP operations much more efficiently than Windows.
On
]
Sent: Tuesday, February 06, 2007 10:20 AM
To: CF-Talk
Subject: RE: CF and Legacy Systems... Need Some Advice/Help
Dan, the server will be on Windows. I'm basically using everyone's replies
as a vote for how this should be handled. I don't want to re-invent the
wheel and that is why I
EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 10:15 AM
To: CF-Talk
Subject: RE: CF and Legacy Systems... Need Some Advice/Help
Che,
>Thanks Dan. My thoughts exactly. In my mind, the SCO software
>technicians simply don't want to add a webserver because of the
>increased security
Pardon my off topic reply, but I think I might have nightmares about this
scenario when I go to bed tonight!!!
On 2/6/07, Che Vilnonis <[EMAIL PROTECTED]> wrote:
>
> Good morning all. I have a client that has a CF based website (built by
> myself around 5 years ago) and a SCO Unix Open Server back
Che,
>Thanks Dan. My thoughts exactly. In my mind, the SCO software technicians
>simply don't want to add a webserver because of the increased security
>issues that would arise. And yes, it *would* be terribly slow.
If you can keep the FTP session active all the time, it will help w/the
performan
itzer, II [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 06, 2007 9:09 AM
> To: CF-Talk
> Subject: RE: CF and Legacy Systems... Need Some Advice/Help
>
>
> Che,
>
> While it could be done, using FTP is going to be extremely sluggish--unless
> you can manage to keep
r can be an FTP'd XML file?
Chris
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 9:16 AM
To: CF-Talk
Subject: Re: CF and Legacy Systems... Need Some Advice/Help
Che Vilnonis wrote:
> Good morning all. I have a client that h
Yeah... what Tom said... "Eww". Now, I have to go do some convincing.
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 9:10 AM
To: CF-Talk
Subject: Re: CF and Legacy Systems... Need Some Advice/Help
On Tuesday 06 Feb 2007, Ch
Che Vilnonis wrote:
> Good morning all. I have a client that has a CF based website (built by
> myself around 5 years ago) and a SCO Unix Open Server backend. It's a legacy
> system with software that's been heavily modified over the last 20-25 years.
> Neither system communicates with the other.
>
Sent: Tuesday, February 06, 2007 9:09 AM
To: CF-Talk
Subject: RE: CF and Legacy Systems... Need Some Advice/Help
Che,
While it could be done, using FTP is going to be extremely sluggish--unless
you can manage to keep the FTP session open all day.
If you have to log in for each request, you
On Tuesday 06 Feb 2007, Che Vilnonis wrote:
> I was wondering, can this even be done with CF and the FTP protocol instead
> of using HTTP? With HTTP, this would be relatively easy with the
> tag. With FTP, I am not sure how the communication would work. :(
Yeah, you can do it.
If you have a versi
m.
-Dan
>-Original Message-
>From: Che Vilnonis [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, February 06, 2007 8:32 AM
>To: CF-Talk
>Subject: CF and Legacy Systems... Need Some Advice/Help
>
>Good morning all. I have a client that has a CF based website (built by
>myse
Good morning all. I have a client that has a CF based website (built by
myself around 5 years ago) and a SCO Unix Open Server backend. It's a legacy
system with software that's been heavily modified over the last 20-25 years.
Neither system communicates with the other.
The client is looking to str
alk
> Subject: cffunction with a loop inside - need some advice
>
> OK - before I tried turning this particular problem into a service, I
> had a simple query like this, which works (examples simplified for
> clarity, whatever that is!):
>
>
>
> INSER
I'm completely stumped. Nothing I've tried seems to work. All I need to
do is turn the query below, which inserts multiple records, into a
function and then invoke that function.
INSERT INTO participants (
enrID,
part_class )
VALUES (
#evaluate("form.e
OK - before I tried turning this particular problem into a service, I
had a simple query like this, which works (examples simplified for
clarity, whatever that is!):
INSERT INTO participants (
enrID,
part_class )
VALUES (
#evaluate("form.enrID#idx#")#,
Despite my obvious error in the query itself, the function error seems
to be caused by the loop:
WSenrID#idx#="#evaluate("form.enrID#idx#")#"
WSpart_class#idx#="#evaluate("form.part_class#idx#")#"
If I remove the loop - it validates properly.
OK, how do I get a loop of the value "W
First join JS-Jive at http://groups.yahoo.com/group/JS-Jive for all the
Javascript help you can stand. But to answer your question, your best bet is
to control the forms action depending on how the form in submitted (either
through the submit button or the onchange event of the select box). You ca
Hi Everyone,
I've been staring at my code to long and I'm stumped. I have a select menu (see
below) that is being populated from a databse. My problem is, if a user chooses
an option from the pull down menu it needs to also send the rest of my form variables
to the next page. Right now, usin
ECTED]]
Sent: Thursday, August 10, 2000 11:00 AM
To: '[EMAIL PROTECTED]'
Subject: RE: CFAPPLICATION - Need some advice
OK works perfectly but I have one more question to help me understand WHY
it's working!
I see that when the user closes there browser the cookie gets killed. Then
w
rt to
clean up old client vars.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 10:37 AM
To: [EMAIL PROTECTED]
Subject: RE: CFAPPLICATION - Need some advice
Curious - in what way does this mess up client vars in a database? Doesn't
on when leaving the site?I assume
it must be when the browser is closed.
A happier but still perplexed Andy!
-Original Message-
From: Matt Rodosky [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2000 20:29
To: [EMAIL PROTECTED]
Subject: RE: CFAPPLICATION - Need some advice
Actually rewrit
ION - Need some advice
Superstar.that worked a treat.you don't know how long I've been
looking at this!!
-Original Message-
From: Matt Rodosky [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2000 20:29
To: [EMAIL PROTECTED]
Subject: RE: CFAPPLICATION - Need some advice
Actua
Superstar.that worked a treat.you don't know how long I've been
looking at this!!
-Original Message-
From: Matt Rodosky [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2000 20:29
To: [EMAIL PROTECTED]
Subject: RE: CFAPPLICATION - Need some advice
Actually rewriting the coo
Thanks...I'll try it and let you know how I get on..
-Original Message-
From: Matt Rodosky [mailto:[EMAIL PROTECTED]]
Sent: 10 August 2000 15:57
To: [EMAIL PROTECTED]
Subject: RE: CFAPPLICATION - Need some advice
Yes, setting the cookie without an expires attribute makes a c
Your client variable data will build up but scheduling a purge of old data
should be easy enough.
Matt
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 5:10 AM
To: '[EMAIL PROTECTED]'
Subject: RE: CFAPPLICATION - Need some advice
iable data in the database but
I guess I can get CF to purge this on a regular basis.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2000 23:39
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: CFAPPLICATION - Need some advice
> > Put t
Thank you for that clear explanation. I was scratching my head at this code... :-)
At 06:38 PM 8/9/00 -0400, Dave Watts wrote:
>> > Put this code in your application.cfm file. It will kill the session
>> > variables when the user closes the browser:
>> >
>> >
>> >
>> >
>> >
>> >
>> >
> > Put this code in your application.cfm file. It will kill the session
> > variables when the user closes the browser:
> >
> >
> >
> >
> >
> >
> >
> >
...
> I don't think this will do what we are hoping it will. It looks to
> me as if all it's doing is testing to see if the sessio
t 09, 2000 11:10 AM
To: '[EMAIL PROTECTED]'
Subject: RE: CFAPPLICATION - Need some advice
Okso are you saying that when you re-write the cookie the session/client
variables are cleared? If that is the case what happens on the server side?
If I am storing client variables in a datab
Rodosky [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2000 17:41
To: [EMAIL PROTECTED]
Subject: RE: CFAPPLICATION - Need some advice
The code will keep session variables going as long as the browser stays
open. It will overwrite the old cfid/token when a new browser window is
opened, the result is
dosky [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 09, 2000 12:41 PM
To: [EMAIL PROTECTED]
Subject: RE: CFAPPLICATION - Need some advice
The code will keep session variables going as long as the browser stays
open. It will overwrite the old cfid/token when a new browser window is
opened, the r
]]
Sent: Wednesday, August 09, 2000 10:02 AM
To: '[EMAIL PROTECTED]'
Subject: RE: CFAPPLICATION - Need some advice
I don't think this will do what we are hoping it will. It looks to me as if
all it's doing is testing to see if the session is open, if it is it's
reading th
ssage-
From: Matt Rodosky [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2000 16:27
To: [EMAIL PROTECTED]
Subject: RE: CFAPPLICATION - Need some advice
Put this code in your application.cfm file. It will kill the session
variables when the user closes the browser:
-Original Me
;[EMAIL PROTECTED]'
> Asunto: RE: CFAPPLICATION - Need some advice
>
>
> Session management is a bit of a nightmare in CF in my
> opinion. If the user
> closes their browser their session doesn't expire
> automatically. One only
> way to force it to expire is to use t
OTECTED]'
> Asunto: RE: CFAPPLICATION - Need some advice
>
>
> Session management is a bit of a nightmare in CF in my
> opinion. If the user
> closes their browser their session doesn't expire
> automatically. One only
> way to force it to expire is to use the 'On
anyone else has any other ideas on this I'd love to hear them.
-Original Message-
From: Gavin Myers [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2000 13:41
To: '[EMAIL PROTECTED]'
Subject: CFAPPLICATION - Need some advice
I've decided to take a look at application.cfm to
I've decided to take a look at application.cfm too see what I can gather.
I've never really used it before
Now in the simplest form:
application.cfm
end application.cfm
The only thing I am using with the application.cfm file is
#session.sessionid#, and I need to carry that sessionid throug
85 matches
Mail list logo
