Re: Need some advice on approach...

2008-06-10 Thread s. isaac dealey
> 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

RE: Need some advice on approach...

2008-06-09 Thread Rick Faircloth
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

Re: Need some advice on approach...

2008-06-09 Thread s. isaac dealey
> 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

RE: Need some advice on approach...

2008-06-08 Thread Rick Faircloth
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.

Re: Need some advice on approach...

2008-06-08 Thread s. isaac dealey
> 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

RE: Need some advice on approach...

2008-06-08 Thread Rick Faircloth
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. > >

Re: Need some advice on approach...

2008-06-08 Thread s. isaac dealey
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

Need some advice on approach...

2008-06-08 Thread Rick Faircloth
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'

Re: Advice on approach

2000-05-15 Thread Russ Michaels
Just add another column into your database called APPROVED. When you insert submissions into the database just set this flag as true and do not display any entries that have this flag set as true. When you validate them, just set the flag to zero so that the records are shown. Satachi Inter

Re: Advice on approach

2000-05-15 Thread Nick Slay
Hi John, I don't think you'd notice any performance penalties at all. In each of your four templates that list out the links simply edit your CFQUERY tag that get's the links from the database, and add WHERE StatusFlag = 1. On the search page, add the same WHERE StatusFlag = 1 to the search

Re: Advice on approach

2000-05-15 Thread John Allred
Thanks, Nick. This makes sense, as it's probably simpler than trying to maintain two sets of tables. However, there may be a downside: I have five templates, plus a search form that look at these links. Four of them list all of the links in various ways. For each, I would have to add the display

Re: Advice on approach

2000-05-15 Thread Nick Slay
Hi John, Personally, I'd have a StatusFlag on my Link Table. Let people submit links directly to the Links table and set the StatusFlag to 0, (Pending). Create yourself a password protected admin script that let's you update the StatusFlag, then once the Links have been approved, set the S

Advice on approach

2000-05-15 Thread John Allred
I accept submissions for links to be listed on one of my sites. Originally, this was merely by E-mail. Then I set up a form, so I could get as many fields filled in as possible and save some research time. The form generated an E-mail to me and the sender. Now, I'd like to have submitters enter t