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 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
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 for the feedback, Isaac...
Welcome
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.
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 ...
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.
Brief recommendation. You mentioned you're using Application.cfm still -
what you might
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 an
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.
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.
, 2008 10:32 AM
To: CF-Talk
Subject: Re: Need some advice on speeding up query...
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
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
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:
cfparam
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
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
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
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
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 query...
This is a common problem. It sounds like having a single table with all
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 field.
SELECT sa.*,
'acr' as propertyType
FROM smlc_acr sa
I don't understand that, Dominic.
What does the 'acr' refer to?
-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 24, 2008 8:24 AM
To: CF-Talk
Subject: Re: Need some
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 that
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.
]
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 a string, it doesn't *refer* to anything and it could be set
to anything you want - I set it to 'acr
, 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 a string, it doesn't *refer* to anything and it could be set
to anything you want - I set it to 'acr' because
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 variable, but yes ;) (perhaps dataset
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 caching
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 advice on speeding up query...
Up till
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 for
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
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 some advice on speeding up query...
After
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
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
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 UNION ALL as suggested by Rizal? This might make
/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 advice on speeding up query...
Hey there,
Not sure if this input will alleviate your issues more
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 primary key. This way, the
primary key is not what makes
would be better.
Thanks for the help!
Rick
-Original Message-
From: 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
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 use
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
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
: 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 use the aliased
variable property_id (once I add it to the query).
I know I
:[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 (commercial, residential, lot, multiunit, etc.). You
would need to add
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
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
-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 think you can put index on these tables
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,
, 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 speeding up query...
Well, apart from a DB redesign so that you can do 1 query instead
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 been
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
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
myself around 5 years ago) and a SCO Unix Open Server backend
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 cfhttp
tag. With FTP, I am not sure how the communication would work. :(
Yeah, you can do it.
If you have a
: 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're going
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.
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, Che Vilnonis
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 has a CF based
: 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're
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
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 backend.
]
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 issues that would arise. And yes
]
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 have my doubts
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 a
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 FTP.
Unix definitely handles FTP operations
: 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!):
cfloop from=1 to=#form.totalPERSONS# index=idx
cfquery name=WRITE_ENROLL
Despite my obvious error in the query itself, the function error seems
to be caused by the loop:
cfinvoke webservice=myWEBSERVICE
method=ENROLLMENTS
WStotalPERSONS=#form.totalPERSONS#
cfloop from=1 to=#arguments.WStotalPERSONS# index=idx
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!):
cfloop from=1 to=#form.totalPERSONS# index=idx
cfquery name=WRITE_ENROLL
INSERT INTO participants (
enrID,
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.
cfloop from=1 to=#form.totalPERSONS# index=idx
cfquery name=WRITE_ENROLL
INSERT INTO participants (
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
htmlDIVHi Everyone,/DIV
DIVnbsp;/DIV
DIVI'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.nbsp; 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
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 this code in 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
Let me see if I
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 cookie
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 cookies turns
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
Actually rewriting the cookies
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 rewriting the cookies
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
CF remove
]]
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
when they revisit
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
htmlhead/headbody
cfapplication name="id" clientmanagement="Yes" sessionmanagement="Yes"
setclientcookies="Yes"
/body/html
end application.cfm
- 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 'OnUnload' event of
the browser to
trigger some Java Script which ends
0 9:08 AM
To: '[EMAIL PROTECTED]'
Subject: RE: CFAPPLICATION - Need some advice
There's none, either in asp nor php4
Javascript is the way
Miguel Gonzalez
www.ibcmass.com
mailto:[EMAIL PROTECTED]
-Mensaje original-
De: Andy Ewings [mailto:[EMAIL PROTECTED]]
Enviado el: miércoles 9 de
: 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:
!--- if the user closes their browser, make sure all
]]
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 the values from the cookies
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 database o the server
Put this code in your application.cfm file. It will kill the session
variables when the user closes the browser:
!--- if the user closes their browser, make sure all sesion
variables get
killed ---
cfif IsDefined("Cookie.CFID") AND IsDefined("Cookie.CFTOKEN")
cfset cfid_local =
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:
!--- if the user closes their browser, make sure
82 matches
Mail list logo