UI question

2001-06-06 Thread Jason Lotz

I would like some input on how people handle the following situation:

A client wants a form with a "Job Title" select box with 5 options -

Developer
Programmer
Engineer
Electrician
Other

If the user selects "Other" then they have to enter the information in a
text box.  Otherwise, the selection in the Select box is sufficient.

Now, my problem isn't programming related.  Rather, I am interested in a
good way to handle the user interface for this mess.  For example, in VB
it's easy enough to make the text box only appear when "Other" is selected.
However, HTML is not that flexible.  It just seems that there might be a
good way to handle this that I'm missing.

Jason



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: headers question

2001-06-05 Thread Jason Lotz

You can certainly do this with CF using .

Jason

- Original Message -
From: "Christopher Porter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 05, 2001 9:52 AM
Subject: headers question


ok here's a perl script.. i have a 20$ bet with a friend that it can be
done in CF and of course theres only one hard part to it...


#!/usr/bin/perl

print "Content-type: image/gif\n";

open IMAGEFILE, "<../html/image1.gif";
my $length = (stat(IMAGEFILE))[7];

print "Content-length: $length\n\n";

read(IMAGEFILE, $image, $length);

print "$image";






the real kicker here is that the perl script is altering the content-type
header and changing it to a a type of 'image'... ideally with cfserver 4.5
out and its capability of handling binary data, it would bre great to be
able to make CF serve images or other binary data...

in research, i found the  tag, but it wont overwrite headers,
only create new ones.. (even if they have the same name.)

anyone know of an open source custom tag that might be able to do this..
my guess is that it has to be a cfx tag as there's no cf tag avail to
change the headers block..

thnx for yer help in advance (and to answer the next questions... sure
i'll split the 20$ if i win :)... the deadline for the bet is sat
midnight.. end of hte week)

-chris
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Attributes Scoped Structure?

2001-05-24 Thread Jason Lotz

That's not true.  Fusebox uses nothing but Attributes scoped variables.  You
can set Attributes variables anywhere.

- Original Message -
From: "Howarth, Craig (IBK-NY)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 24, 2001 7:36 AM
Subject: RE: Attributes Scoped Structure?


Brad,

The attributes scope can only be used within a custom tag.  This is the
error message that you get when you attempt to assign a value to the
attributes scope in a normal template.

Craig

> -Original Message-
> From: Brad Roberts [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 9:55 AM
> To: CF-Talk
> Subject: Attributes Scoped Structure?
>
> Can you set a structure in the attributes scope?
>
> I'm wondering why this isn't working:
>
> 
>
> I get the following error:
> Cannot assign result to symbol attributes.temp
>
> Thanks in advance,
>
> Brad
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Dynamic Queries (RecordCount)

2001-05-22 Thread Jason Lotz

You can't have "21" as the name of your query.   It has to start with a
alpha-character.

Jason

- Original Message -
From: "Steve Reich" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 22, 2001 4:06 PM
Subject: Dynamic Queries (RecordCount)


How do I set a variable equal to the recordcount of this query? Here's what
I've been trying

<~CODE>



SELECT *
FROM data
WHERE dataid = #dataid#




#queryCount#


<~CODE>

This code returns the following error:

<~ERROR>
Error Diagnostic Information

An error occurred while evaluating the expression:


 queryCount=evaluate(queryName & ".RecordCount")



Error near line 109, column 7.
An error has occurred while processing the expression:

   21.RecordCount


Invalid parser construct found on line 1 at position 4. ColdFusion was
looking at the following text:

RecordCount
Invalid expression format. The usual cause is an error in the expression
structure.
<~ERROR>

Seems like I've done this a million times, but I'm not hitting on all
cylinders today. The name of the query is an integer if that makes any
difference. Can somebody point out the obvious for me?

Thanks,
Steve
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: the big export

2001-05-17 Thread Jason Lotz

What exactly do you mean?  You could use VB, C, C++, ASP, ColdFusion, etc.
Are you asking what would be fastest?  If so, I would recommend VB or C, but
I have no idea what languages you know.  Why don't you just write it in CF
if you are most familiar with it and just let it run for awhile?  No matter
what language you use, it's not going to be quick.

- Original Message -
From: "Michael Lugassy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 9:48 AM
Subject: the big export


I need the fastest way to export 100s of 1000s of text
files into a database. I need each file in a a new row like this:
file1name, file1content
file2name, file2content

CF is too slow for this, what can I use?

Thanks,

-=Michael.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: .cfm extension and URLs

2001-05-15 Thread Jason Lotz

Bud,
That's pretty ridiculous.

Here's a link to prove him wrong:

http://search.yahoo.com/search?p=cfm&n=25&hc=1&hs=1668&b=25&h=s

Look at all the .cfm pages that are indexed.

- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 12:20 PM
Subject: .cfm extension and URLs


> Hi all. I'm having an argument with a client about the cfm extension.
> He's got a guy doing his search engine optimization that is insisting
> that search engines won't follow any extension other than .htm and
> ..html. I'm telling him the search engines don't care as long as they
> don't end in .cgi or have a query string in the URL. Am I wrong? Any
> documentation you can point me to one way or the other?
>
> Thanks a bunch!
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Anybody Williams Sonoma folks on this list working on the Pottery Barn Kids site?

2001-05-14 Thread Jason Lotz

All your base are belong to us.

- Original Message -
From: "Shawnea Carter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 4:15 PM
Subject: Anybody Williams Sonoma folks on this list working on the Pottery
Barn Kids site?


Shawnea Carter
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: New Cold Fusion book, Osborne McGraw Hill

2001-05-11 Thread Jason Lotz

"Each chapter sets out to step the user through the process of
creating a real-world application, starting from database design and moving
up to a finished product." - How is this not a tutorial?

Jason


- Original Message -
From: "Jeffry Houser" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 3:16 PM
Subject: RE: New Cold Fusion book, Osborne McGraw Hill



  And while we are at it, Instant ColdFusion will be out soon as well.  It
is now available (pre-order) on Amazon.com

http://www.amazon.com/exec/obidos/ASIN/0072132388/qid%3D989608220/instantcol
dfu-20

  Unlike most of the books out there, this one is not intended as a
tutorial.  Each chapter sets out to step the user through the process of
creating a real-world application, starting from database design and moving
up to a finished product.

   I've been assured that the typo in the cover (can you find it?) will be
fixed.


At 01:52 PM 05/11/2001 -0400, you wrote:
>And since we are talking books - the Mastering CF 5 is coming out as well.
>
>===
>Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
>
>Email   : [EMAIL PROTECTED]
>ICQ UIN : 3679482
>
>"My ally is the Force, and a powerful ally it is." - Yoda
>
> > -Original Message-
> > From: Ben Forta [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, May 11, 2001 1:27 PM
> > To: CF-Talk
> > Subject: RE: New Cold Fusion book, O'riely Press
> >
> >
> > Yep, both books Construction Kit and Advanced) are being revised, and
will
> > be out for CF5. Amazon.com already has one of them listed.
> >
> > --- Ben
> >
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: using WDDX for next 'n' style browsing

2001-05-08 Thread Jason Lotz

Actually, if you want to do this, you can skip the cfset step.  Just call
the query as below:




- Original Message -
From: "Kola Oyedeji" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 9:43 AM
Subject: RE: using WDDX for next 'n' style browsing


> But wont that mean each query would be held in the server RAM?
>
> KOla
>
>
>
> -Original Message-
> From: Craig Bowes [mailto:[EMAIL PROTECTED]]
> Sent: 08 May 2001 17:15
> To: CF-Talk
> Subject: RE: using WDDX for next 'n' style browsing
>
>
> Another idea for saving query times for "N" next records is to store the
> query as a session variable and you don't even have to run that query file
> at all.
>
> 
>
> then you can do your 
>
> be sure to put  around your  when setting session vars.
>
> -Craig
>
>
> -Original Message-
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 5:53 AM
> To: CF-Talk
> Subject: using WDDX for next 'n' style browsing
>
>
> I am passing a query object which consists of 1000 records in a hidden
form
> field between pages as a
> WDDX packet, are there any reasons why this is a bad idea, such as limits
to
> the amount of data which can be held in a form field or passed in a form?
>
> The reason for this is to save a trip to the server for each page of
result.
> Are there any better solutions, would cacheing the query and executing it
> again for every page be more efficient than trying to offload the
processing
> onto the client's machine?
>
> Thanks
>
> Kola
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: having multiple groups

2001-05-07 Thread Jason Lotz

Your database should look as follows:
States
StateIDState
1  Arizona
2  Utah

Lakes-
LakeIDLake
1  Powell
2  Huron

LakeStates-
StateIDLakeID
1  1
2  1

Now that the DB structure is ok, your query will look as follows:

SELECT S.State,L.Lake
FROM (LakeStates LS INNER JOIN States S ON LS.StateID = S.StateID) INNER
JOIN Lakes L ON LS.LakeID = L.LakeID
WHERE L.LakeID = 1

I hope that helps.

Jason

- Original Message -
From: "Victor Chou" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 07, 2001 2:28 PM
Subject: Re: having multiple groups


> Just a simple union should do it:
>
> select state1 as state, lake_id, lake from table
> union
> select state2 as state, lake_id, lake from table
> union
> select state3 as state, lake_id, lake from table
> order by state
>
> But shouldn't you be using a lake_id, state_id join table?
>
>
> - Original Message -
> From: "Gregg Kachel" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, May 08, 2001 9:12 AM
> Subject: having multiple groups
>
>
> > This is a multi-part message in MIME format.
> >
> > --=_NextPart_000_01BA_01C0D708.2BE1EA70
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > I am trying to do a simple list of all states, then lakes in that state.
=
> > Problem is, since there are several lakes in two or three different =
> > states, I can't seem to get them to be listed under each state.
> >
> > My table looks like this
> > lake  lake_id  state1state2state3
> > Powel7UtahArizona
> >
> >
> > my query is
> > 
> >   SELECT lake_id,lake,(statename, statename2,statename3) as statenames
> >   FROM rental_lakes
> >   order by statenames,lake
> >   
> >
> > and the output
> >
> > 
> >  statenames#
> > 
> > =20
> >  #lake# =
> > 
> > 
> >
> > Is this possible? Am I in the wrong direction here? What I need for =
> > output is:
> >
> > Arizona
> > *Lake Powell
> >
> > Utah
> > *Lake Powell
> >
> > I have been working on this all week, trying differant things. If =
> > someone could push me in the correct direction it would be greatly =
> > appreciated.
> > Thanks,
> > Greggk
> >
> > --=_NextPart_000_01BA_01C0D708.2BE1EA70
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > 
> > 
> >  > charset=3Diso-8859-1">
> > 
> > 
> > 
> > 
> > I am trying to do a simple list of all
=
> > states, then=20
> > lakes in that state. Problem is, since there are several lakes in two or
=
> > three=20
> > different states, I can't seem to get them to be listed under each=20
> > state.
> >  
> > My table looks like this
> > lake =
> >  lake_id =20
> >     state1   =20
> > state2        state3
> > Powel   =20
> >
7=
> >    =20
> > Utah        Arizona
> >  
> >  
> > my query is
> >  > datasource=3D"houseboat">  SELECT
lake_id,lake,(statename,=20
> > statename2,statename3) as statenames  FROM =
> > rental_lakes  order=20
> > by statenames,lake  
> >  
> > and the output
> >     > =3D "list"=20
> >
Group=3D"statenames">
     &= > > lt;li>statenames#   =20 > >
         > >
    • > href=3D"lakes.cfm?lake_id=3D#lake_id#">#lake#=20 > >
    • > >   > > Is this possible? Am I in the wrong = > > direction here?=20 > > What I need for output is: > >   > > Arizona > > *Lake Powell > >   > > Utah > > *Lake Powell > >   > > I have been working on this all week, = > > trying=20 > > differant things. If someone could push me in the correct direction it = > > would be=20 > > greatly appreciated. > > Thanks, > > Greggk > > > > --=_NextPart_000_01BA_01C0D708.2BE1EA70-- > > > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Query Join Brain Fart

2001-04-25 Thread Jason Lotz

Ben,
Thanks for the information.  I never thought of doing it that way before.  I
has other applications in apps that use threads (i.e., forums.)  I assume
this will work in SQL Server as well?

Jason

- Original Message -
From: "Braver, Ben" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 10:18 AM
Subject: RE: Query Join Brain Fart


> Hi Jason,
>
> You can do a "self join" to join a table to itself using an alias to
> "pretend" there are two separate tables.  This way you can join rows in a
> table to rows in that same table.
>
> A classic example is an employee table with columns LastName, EmployeeID,
> ManagerID and you want a list of people with their managers.  Such as:
use
> the aliases "worker" and "manager" for the real "employee" table.  (Oracle
> syntax.)
>
> SELECT worker.lastname||' works for '||manager.lastname
> FROM employee worker, employee manager
> WHERE worker.ManagerID = manager.EmployeeID;
>
> Hope this applies to the question you were asking.
>
> Ben Braver
> Information Technology
> Ultramar Inc.
> Golden Eagle Refinery
> 150 Solano Way
> Martinez, CA  94553-1487
> (925) 370-3673 voice
> (925) 370-3393 fax
> (510) 716-2557 pager
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Jason Lotz [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 25, 2001 9:49 AM
> To: CF-Talk
> Subject: Re: Query Join Brain Fart
>
>
> How can you do a join on the same table?  Both of these queries are drawn
> from the CandidateSkills table?  Am I misunderstanding your question?
>
> - Original Message -
> From: "cassady " <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 25, 2001 9:22 AM
> Subject: Query Join Brain Fart
>
>
> > Hey everyone -
> > Arrgh. I haven't done any of these in a while, and I'm having a little
bit
> of a brain fart. Could somebody put these together in a join when the SQL
> table returned has the following columns:
> >
> > CandidateID, Num_Skills, BM_score
> >
> > If I get the example then I think (hope? dream?) that my brain might
start
> functioning again like it should. :-)
> >
> >
> > 
> > 
> > Select CandidateID, Count(*) AS num_skills
> > From CandidateSkills
> > Where CandidateSkills.CandidateID IN (#ListCandidateID#)
> > Group By CandidateID
> > 
> >
> >
> > 
> > 
> > Select Sum(ExpYears) AS BM_score
> > From CandidateSkills
> > Where CandidateSkills.CandidateID = #Client_saSearch.CandidateID#
> > AND ((CandidateSkills.SkillID = #Skills1#)
> > OR (CandidateSkills.SkillID = #Skills2#)
> > OR (CandidateSkills.SkillID = #Skills3#))
> > 
> >
> > Thank you for your time in advance,
> > Stephen R. Cassady
> > [EMAIL PROTECTED]
> > http://www.ububik.com
> > http://www.tallylist.com <--- cause' you no you waa!
> >
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query Join Brain Fart

2001-04-25 Thread Jason Lotz

How can you do a join on the same table?  Both of these queries are drawn
from the CandidateSkills table?  Am I misunderstanding your question?

- Original Message -
From: "cassady " <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 9:22 AM
Subject: Query Join Brain Fart


> Hey everyone -
> Arrgh. I haven't done any of these in a while, and I'm having a little bit
of a brain fart. Could somebody put these together in a join when the SQL
table returned has the following columns:
>
> CandidateID, Num_Skills, BM_score
>
> If I get the example then I think (hope? dream?) that my brain might start
functioning again like it should. :-)
>
>
> 
> 
> Select CandidateID, Count(*) AS num_skills
> From CandidateSkills
> Where CandidateSkills.CandidateID IN (#ListCandidateID#)
> Group By CandidateID
> 
>
>
> 
> 
> Select Sum(ExpYears) AS BM_score
> From CandidateSkills
> Where CandidateSkills.CandidateID = #Client_saSearch.CandidateID#
> AND ((CandidateSkills.SkillID = #Skills1#)
> OR (CandidateSkills.SkillID = #Skills2#)
> OR (CandidateSkills.SkillID = #Skills3#))
> 
>
> Thank you for your time in advance,
> Stephen R. Cassady
> [EMAIL PROTECTED]
> http://www.ububik.com
> http://www.tallylist.com <--- cause' you no you waa!
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Design Question

2001-04-25 Thread Jason Lotz

Considering you want your answer in Fusebox, you should probably take it to
the Fusebox list (www.houseoffusion.com).

- Original Message -
From: "Janine Jakim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 8:30 AM
Subject: Design Question


> Ok folks I need some help with design...this is all stuff I know inside
out
> when I'm working with Access but am struggling when I try to put it in
terms
> of CF/Fusebox...
>
> 1.  I need a login- once successfully logged in a teacher will only see
> his/her students.  I got that.
> 2.  So I need each for the teacher to choose a student (i'm trying to do
> this with frames-they pick from the list on the side) and the subject that
> they need to add grades for (math/english/etc)I'd like to have it so
> that subjects are dynamic too (versus having separate pages for each
subject
> with the subject hardcoded by courseID... I'd prefer a table to fill with
> whichever subject was chosen).
> a.  The teacher should have the choice if she/he wants to do 1
> student all subjects (which will take several "pages"- probably 5-6 to get
> through all the subjects + all the subcategories (ie: reads fluently/is
> cooperative...) So the teacher needs to be able to go through this page by
> page, doing an update at the end of each page (don't want them to lose too
> much info if power goes out)
> b.  The teacher should be able to do the whole class by subject. ie:
> she/he picks math and each page has a different student/same subject.
> (update being saved after each student page is complete-as teacher goes to
> next student.
>
> So they'd be filtered on several different levels.
> I'm trying to figure out how to do all of this without it being unweildy-
> (ie: to hook teacher-student 3 tables are involved.  To add a grade there
> are 4 tables- one with student info/one to hold the grade and 2 reference
> tables-one for the subject and one for all the subtopics of each
> subject)Or maybe more appropriately I'm trying to figure out how to
chop
> it up appropriately.
> In Access I would make a main form and add all the subforms. The
> subforms would use  specific updatable queries.  The subforms would be
> attached to the mainform by some primary/foreign key combo.  (so I could
> have 10 different subforms hooked to the main form) How do I accomplish
this
> in CF/Fusebox?  Right now I have lots of pieces but they are not
> attached--how should I stitch this together?
> I wrote up a bunch of fusedocs but now I'm second guessing everything
> Any ideas?
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Request vs. Application scope

2001-04-19 Thread Jason Lotz

Andrew,
Thanks for the response.  I completely understand what you are saying so I
think I misphrased my question.  Let's try an example and I'll show you what
I mean

Let's say you set an Application variable "Application.DSN" under the
application named "MyApp". Assuming everything is setup correctly in
Application.cfm and , the variable is created and will not
time out until "MyApp" expires. Now here is where I get confused.  For
Application and Session variables, you are supposed to lock them because
they are shared by each instance (i.e., browser) that is currently using
your app.  But, since these variables are supposed to be set seperately for
each set of unique tokens, why is looking necessary.  For example, if I
login as a user and it sets a variable called "Session.ID" to 101, how could
this be overwritten or used by another user since it is specified by the
unique token pair.

Make anymore sense?  I know I got away from the original question but this
is closer to what I want to know.

Thanks,
Jason

- Original Message -
From: "Andrew Tyrone" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 3:17 PM
Subject: RE: Request vs. Application scope


> > -Original Message-
> > From: Jason Lotz [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 19, 2001 4:25 PM
> > To: CF-Talk
> > Subject: Request vs. Application scope
> >
> >
> > I have noticed that I can easily interchange the use of Application and
> > Request scoped variables.  Both are easily accessible in custom
> > tags and are
> > only exist for the current http request.  So, what are good reasons to
use
> > one instead of the other?
> >
> > Jason
>
>
> Application variables are actually good for all requests for the life of
the application (set in the cfapplication tag with the applicationtimeout
attribute).  Request variables are only good for the lifetime of the page
that gets called (including any cfinluded files and custom tags, nested or
not).  Application variables are available to all users and only have to be
set once, unless the application times out.  In this case, they can be set
again, and checked beforehand with IsDefined() so as not to set them when
you don't need to.  Read up on session management in the ColdFusion
documentation.
>
>
> - Andy
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Request vs. Application scope

2001-04-19 Thread Jason Lotz

I have noticed that I can easily interchange the use of Application and
Request scoped variables.  Both are easily accessible in custom tags and are
only exist for the current http request.  So, what are good reasons to use
one instead of the other?

Jason


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Note passing system?

2001-04-16 Thread Jason Lotz

>>>"A browser's beauty, at its heart, is its usefulness as a *TOOL*."

What in the world does the above quote mean?  It's boggling my mind!


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cookies not being set

2001-04-16 Thread Jason Lotz

As I'm sure 100 people on this list will tell you due to the horrendous lag,
when cflocation is used on a page when cookies are being set, the cookies
will not be set correctly.

Instead, I use javascript to relocatewindow.location='whatever.cfm';
- Original Message -
From: "Mike Sprague" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 10:25 AM
Subject: cookies not being set


> I have a login page that checks my db to validate user info and if valid
uses cflocation to redirect to the appropriate page.  I need cookies to work
because people with AOL have been having problems keeing the session
variables alive.  My code is below, any help would be greatly appreciated.
>
> Mike
>
>
> 
>   
>   
> 
>   
>   
>   
>   
>   
> 
>   
> 
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Unsubscribe

2001-04-13 Thread Jason Lotz

Chris,
For some reason, the functionality on the site tells you that you need to
reply to the email to get it to work.  However, the email that is sent to
you doesn't give you any indication of this.  I've had the same problem many
times and it's very aggravating.

Jason

- Original Message -
From: "McGuckin, Chris" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 13, 2001 8:47 AM
Subject: Unsubscribe


> Please unsubscribe me from the CF-Talk list.  I have attempted to
> unsubscribe several times via the website, but to no avail.
>
> Christopher McGuckin
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF Server parsing .js files...

2001-04-06 Thread Jason Lotz

I believe that if you  the .js file, CF automatically parses it,
even though it isn't a .cfm file.

In other words,  will process
'myjsfile.js' as if it were a .cfm file.

Jason

- Original Message -
From: "Steve Reich" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 10:16 AM
Subject: CF Server parsing .js files...


> I have a single javascript file (*.js) that I want to include CF variables
> with. I know how to set IIS up to allow CF Server to process a specific
file
> extension, but I don't neccessarily want it to process all .js files. My
> question is
>
> Is there any command I can use to only process the single file or if  I
want
> CF Server to process one, it has to do them all?
>
> 
>
> ..js file contents.
>
> 
>
> Anything like that? I know I'm reaching here and am pretty positive I
can't
> do this, but I thought I'd ask anyway...
>
> Thanks,
> Steve
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFStudio - TopStyle Lite

2001-04-05 Thread Jason Lotz

For some reason, ever since I loaded CFStudio 4.5.2 I cannot use TopStyle
within ColdFusion.  When I right click between 

Re: CFSCRIPT "switch" Brain Burp

2001-04-04 Thread Jason Lotz

switch(abc) {
case 'r': txt_status='whatever';
}

is the correct format.  It should work fine without the extra brackets.
However, I don't know why the brackets would break it.  Let us know if it
works.

Jason

- Original Message -
From: "Carol Bluestein" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 12:34 PM
Subject: CFSCRIPT "switch" Brain Burp


> Looking for cfscript guru...
>
> I know the answer to this is so simple, but I have tried
everything...I
> think...
> and the next step right now seems to be... asprin, chicken soup and
medication.
>
> I tried:
> switch abc; switch 'abc', switch '#abc#', switch #abc#;
> switch (abc); switch ('abc'), switch ('#abc#'), switch (#abc#);
>
> and in the output, when the program doesn't get caught up in errors due
> to ' or " or #,   abc = r and txt_status always = Unknown
>
> I just don't know what to do next.
>
> What is the secret? how do i script the switch "???abc???" so it works?
>
> 
> abc = 'r';
> switch (???abc???) {
> case "s":{txt_status = 'Initial Submission';}
> case "r":{txt_status = ' Revision';}
> case "a":{txt_status = 'Administration Revision';}
> case "j":{txt_status = 'Previously Rejected';}
> case "p":{txt_status = 'Processed and updated';}
> case "d":{txt_status = 'Previously Deleted';}
> default:{txt_status = 'Unknown';}
> }
>
> 
> #abc##txt_status#
>
> Thank you, in advance,
> Carol
>
>
>
> Carol L. Bluestein
> Senior Programmer
> NYS Office of Real Property
> 518-486-6335
> [EMAIL PROTECTED]
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Numbers to Text

2001-03-30 Thread Jason Lotz

Then what is 10^9 in British?

- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 10:46 AM
Subject: RE: Numbers to Text


> > > Anyone know of a custom tag available or a means within CF to convert
> > > numbers to text... 2 to two, 100 to one hundred, etc.?
> >
> > http://www.tei.or.th/eic/ under the free link.
>
> Nice tag apart from it's gramatical problems...
>
> 101 should be "one hundred and one" and not "one hundred one"
>
> Also, it treats billions in American and ignores British... so for UK
sites
> it'd be wrong
>
> In case anyone is wondering, an American Billion is 1,000,000,000 (10^9)
> while a British Billion is 1,000,000,000,000 (10^12)
> Similarly, an American Trillion is 10^12 while a British Trillion is 10^18
>
> The British version is seen as "Bi-million" as in "Million million" and
> "Tri-million" as in "Million million million" - the further you take this
> the bigger the different...
>
> Strange but often ignored number fact...
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: 2 CFINSERT on ome page?

2001-03-29 Thread Jason Lotz

People actually use CFINSERT?

- Original Message -
From: "C. Hatton Humphrey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 10:57 AM
Subject: RE: 2 CFINSERT on ome page?


> Why not do two cfqueries with SQL INSERT commands for the different
tables?
>
> Hatton
>
> > -Original Message-
> > From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 29, 2001 12:48 PM
> > To: CF-Talk
> > Subject: 2 CFINSERT on ome page?
> >
> >
> > Hello cf-talk,
> >
> >   I have a form with many fields.
> >
> >   The fields go to different tables.
> >
> >   I'm trying to use CFINSERT with formfields to add data to different
> >   tables. When I submit the form, I don't get any errors, but only the
> >   first CFINSERT gets processed?
> >
> >  > Formfields=" last_name, first_name, address, city, state, zip, email,
> > phone, gender, person_notify, notify_telephone, tickets_adult, adult1,
> > adult2, adult3, adult4, adult5, adult6, adult7, adult8, adult9,
> > adult10, adult11, adult12. tickets_children, child1, childage1,
> > child2, childage2, child3, childage3, child4, childage4, child5,
> > childage5, child6, childage6, child7, childage7, child8, childage8,
> > tshirtsmall, tshirtmed, tshirtlarge, tshirtxl, else, card,
> > card_number, cardholder, expdate" >
> >
> >   >  Formfields=" alastname, afirstname, aphone, card_number, first_name,
> >  last_name" >
> >
> >
> >  As is, only the first gets processed (makes it into the table), if I
> >  comment out the top CFINSERT, then the second makes it into its table
> >  and the first does nothing.
> >
> >
> >
> >
> > Best regards,
> >  Jeff Fongemie  mailto:[EMAIL PROTECTED]
> > 
> > Internet Guns For Hire
> > (603) 356-0768
> >
> >
> >
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF pages loading only once

2001-03-27 Thread Jason Lotz

Actually, that isn't true at all. Framset tags simply go before the body
tags, which you have done.  The other response is incorrect.

- Original Message -
From: "Jay Wigginton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 11:20 AM
Subject: RE: CF pages loading only once


> I have never had any problem with them in the past... but anything is
worth
> a try a this point... :)
>
> thanks
> Jay
>
> -Original Message-
> From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 1:08 PM
> To: CF-Talk
> Subject: RE: CF pages loading only once
>
>
> I may be mistaken about this, but I don't think you're supposed to have
>  and  tags on the same page.  I don't know if that's
related
> to your problem, but it's not a good idea.
>
> Bob
>
> -Original Message-
> From: Jay Wigginton [mailto:[EMAIL PROTECTED]]
> Sent: March 27, 2001 12:48 PM
> To: CF-Talk
> Subject: CF pages loading only once
>
>
> I have a strange problem that I am trying to discover a solution for... I
> have a web site that is using frames... when accessed from a PC there is
not
> a problem... when accessed from a MAC the web site will load only one
> time... leave the site and access another web site and try to come back to
> the site it will not load...
>
> I have found in testing it with the people that are having the trouble
that
> it is related to the index page being a CF file...  I setup two identical
> pages stripping out all CF tags... one named index.cfm and one named
> index.html and the cfm file has the problem I described.. the html file
does
> not have the problem...
>
> Here is the code I am using for the index page...
>
> 
> 
> eMarketing Magazine
> 
>
> 
> 
>  scrolling="no" frameborder="0">
> 
> scrolling="auto" frameborder="0">
>  scrolling="auto" frameborder="0">
> 
> 
>
> 
>
> 
> 
>
> Here are the URL's...
>
> http://www.emarketingmag.com/index.cfm
> http://www.emarketingmag.com/index.html
>
> Anyone have any idea what could possibly cause this problem  It seems
to
> be limited to IE v5 also... in Netscape the both pages load but the
Netscape
> never thinks they are finished loading... the icon is always spinning...
> after clicking on one of the links it does load the new page and the icon
> stops spinning...
>
> I am pulling my hair out over this one...  any suggestions would be
> welcomed... :)
>
> thanks
> Jay
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: site modeling

2001-03-26 Thread Jason Lotz

That's not what I meant...sorry for the confusion.  I want a source that
will explain the shapes, lines, etc. used to draw consistent models - not a
software package used to make the models themselves.

Jason

- Original Message -
From: "Dylan Bromby" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 3:26 PM
Subject: RE: site modeling


> visio.
>
> -Original Message-
> From: Jason Lotz [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 2:12 PM
> To: CF-Talk
> Subject: site modeling
>
>
> Can anyone point me to a good resource for drawing site models on paper
> using consistent shapes, lines, etc?  Everytime I sit down to do it, I
make
> up different meaning for each shape and I'm looking for a consitent
> approach.
>
> Thanks,
> Jason
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



site modeling

2001-03-26 Thread Jason Lotz

Can anyone point me to a good resource for drawing site models on paper
using consistent shapes, lines, etc?  Everytime I sit down to do it, I make
up different meaning for each shape and I'm looking for a consitent
approach.

Thanks,
Jason


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: retrieve remote images using cfhttp?

2001-03-22 Thread Jason Lotz

You are thinking too hard.  If you want to display that image, just use a
normal image tag...

http://www.lexus.com/images/home/mn_ph_sc_top.jpg" . . .

No ColdFusion required.

Jason

- Original Message -
From: "Mike Sullivan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 2:39 PM
Subject: RE: retrieve remote images using cfhttp?


> have you tried 'resolveurl="true"'?  ie
> http://www.lexus.com/images/home/mn_ph_sc_top.jpg"
> resolveurl="true">
> mike
> > -Original Message-
> > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, March 22, 2001 1:06 PM
> > To: CF-Talk
> > Subject: retrieve remote images using cfhttp?
> >
> > i have been trying for the better part of the morning to figure out
where
> > i am going wrong with the CFHTTP tag.
> > i get a list of about 200 cars two times a week and the majority have
> > photos (with full url to other sites) but cant seem to figure out how to
> > get CFHTTP to download an image off of a remote site and save it locally
> > to my hard drive.
> >
> > suggestions? ideas? help???!!!
> >
> > here is my non-functional code so far... the header seems to return the
> > right info, and the mime type is also correct, but the filecontent makes
> > no sense to me whatsoever and i am unsure if i am doing this right, or
if
> > it is even possible with the CFHTTP tag, or if i should be using some
> > other tag, or if i should be using something from the allaire developer
> > exchange.
> >
> >  > url="http://www.lexus.com/images/home/mn_ph_sc_top.jpg">
> > 
> > 
> > #cfhttp.header#
> > 
> > #cfhttp.filecontent#
> > 
> >
> >
> > thanks in advance.
> > peter
> >
> >
> >
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: custom app running as an NT service

2001-03-22 Thread Jason Lotz

This is highly OT, so ignore if you don't like that stuff.

Suppose you write a custom app and compile it as a .exe file.  What is the
best way to have it run when the server is rebooted on Windows2000 (like a
service)?  I have a few ideas but I think they are amateurish and would like
a more informative view point.

Thanks,
Jason


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: elseif in ?

2001-03-22 Thread Jason Lotz

If (whatever == 1)
do something
Else If (whatever == 2)
do something else
Else
do default something


- Original Message -
From: "Jamie Jackson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 9:43 AM
Subject: elseif in ?


> Is there no elseif in ? If not:  Why not, and what's the
> usual workaround?
>
> Thanks,
> Jamie
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Password protect ONE form

2001-03-21 Thread Jason Lotz

Without a login, how could you determine who can and cannot click on a link?
How will you know which user is logged on?  Doesn't make sense to me...


- Original Message -
From: "Michael" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 11:34 AM
Subject: Password protect ONE form


> Could some one offer a way to just protect by some sort of password scheme
> or something the way of keeping people from being able to click on a link
to
> get to a form.   The user doesnt want a login,  unless it is ultimately
> neccessary.
>
> Thank You
>
>
> Michael
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: DB structure advice

2001-03-20 Thread Jason Lotz

Completely agreed.  However, I was trying to make up a scenario were you
would specifically want one-to-one relationships.  I gave a bad example but
I think I got my point across.  And the definite concensus is that people
break often break up complex one-to-one relationships into several
tables...which is what I wanted to hear.

Jason


- Original Message -
From: "Dick Applebaum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 10:43 AM
Subject: Re: DB structure advice


> Jason
>
> If you think about it, in real life, a person can have:
>
>many degrees  Germans even list them all on their business cards, e.g.,
>
>  Herr Doktar, Doctar, Doctar
>
>More than one  company
>
> These logically belong in a one-to-many relationship
>
> HTH
>
> Dick
>
> At 9:52 AM -0700 3/20/01, Jason Lotz wrote:
> >This is more of a theory question than an actualy request for help.
Let's
> >say you are building a database of members with lots of information that
> >applies to every member (name, address, phone, etc.)  This could be about
40
> >seperate fields.  Then, on top of that, each member can have lots of
> >optional information that can easily be grouped together.  For example,
if
> >they graduated from college, you want to store their degree information
or
> >if they own a company, you want to store their company info.  Each of
these
> >"optional groups" are one-to-one (each member can only have one chunk of
> >this data but doesn't have to have it at all.) Now here's the question -
> >
> >When you are building this database, you could easily put it into one
huge
> >table because all the information is one-to-one.  However, it's a pain
when
> >you only want to get the "degree" information or the "company"
information.
> >From a programming standpoint, is it best to break these into smaller
tables
> >for ease of use or to keep it into one table?
> >
> >Thanks,
> >Jason
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: DB structure advice

2001-03-20 Thread Jason Lotz

Yeah, I completely agree.  I didn't want to put my personal opinion in my
original post because I wanted untainted answers.  However, from a
maintenance standpoint, I thought the many smaller, specific tables is much
cleaner and easier to deal with.

Thanks,
Jason

- Original Message -
From: "Hayes, David" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 10:16 AM
Subject: RE: DB structure advice


> I would break it into smaller tables.
>
> One issue is size - you don't want to store a lot of empty fields.  Create
> each table, and use a primary key ID field to link them.
>
> Just remember that when you want a record set with all the data, you will
> need to use LEFT JOIN in order for the result set to include the members
who
> don't have records in the optional tables.
>
> -Original Message-
> From: Jason Lotz [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 10:52 AM
> To: CF-Talk
> Subject: DB structure advice
>
>
> This is more of a theory question than an actualy request for help.  Let's
> say you are building a database of members with lots of information that
> applies to every member (name, address, phone, etc.)  This could be about
40
> seperate fields.  Then, on top of that, each member can have lots of
> optional information that can easily be grouped together.  For example, if
> they graduated from college, you want to store their degree information or
> if they own a company, you want to store their company info.  Each of
these
> "optional groups" are one-to-one (each member can only have one chunk of
> this data but doesn't have to have it at all.) Now here's the question -
>
> When you are building this database, you could easily put it into one huge
> table because all the information is one-to-one.  However, it's a pain
when
> you only want to get the "degree" information or the "company"
information.
> From a programming standpoint, is it best to break these into smaller
tables
> for ease of use or to keep it into one table?
>
> Thanks,
> Jason
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



DB structure advice

2001-03-20 Thread Jason Lotz

This is more of a theory question than an actualy request for help.  Let's
say you are building a database of members with lots of information that
applies to every member (name, address, phone, etc.)  This could be about 40
seperate fields.  Then, on top of that, each member can have lots of
optional information that can easily be grouped together.  For example, if
they graduated from college, you want to store their degree information or
if they own a company, you want to store their company info.  Each of these
"optional groups" are one-to-one (each member can only have one chunk of
this data but doesn't have to have it at all.) Now here's the question -

When you are building this database, you could easily put it into one huge
table because all the information is one-to-one.  However, it's a pain when
you only want to get the "degree" information or the "company" information.
>From a programming standpoint, is it best to break these into smaller tables
for ease of use or to keep it into one table?

Thanks,
Jason


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF rules!!!

2001-03-16 Thread Jason Lotz

I think what he was getting at is the fact that he gets ripped into for a OT
post but then has 40 people making fun of him in an equally unprofessional
way.  It's kind of hard to disagree, don't you think?


- Original Message -
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 3:32 PM
Subject: Re: CF rules!!!


> No, the term is professional. Most of us are hackers in the most classical
> sense but we're also professionals who know how to spell (or use a spell
> checker) and how not to piss everyone off.
> I'm going to ask this for the last time. Keep it technical and
professional
> on this list or 
>
>
> > hippocrits
> >
> > -Original Message-
> > From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, March 16, 2001 4:51 PM
> > To: CF-Talk
> > Subject: Re: CF rules!!!
> >
> >
> > Maybe he should try [EMAIL PROTECTED]
> > - Original Message -
> > From: "Adrian Cooper" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, March 16, 2001 3:28 PM
> > Subject: Re: CF rules!!!
> >
> >
> > >
> > > - Original Message -
> > > From: "Phoeun Pha" <[EMAIL PROTECTED]>
> > > Sent: Friday, March 16, 2001 9:06 PM
> > >
> > >
> > > > Peter, you are aware this is the CF talk list, where programmers can
> be
> > > > programmers.  I will groom myself when I am in the CF jobs talklist
:)
> > >
> > > Yes, but _most_ programmers on this list conduct themselves, their
> > comments and
> > > discussions as you would expect from a professional person.
> > >
> > > Adrian Cooper.
> > >
> > >
> > >
> > >
> >
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF rules!!!

2001-03-16 Thread Jason Lotz

How in the world do you people complain about Phoeun and then send drivel
like this to the list?  Stop being hypocritical or just lighten up in the
first place.  I guarantee that the latter makes life a whole lot more
enjoyable.  In any case, at least be consistent.


- Original Message -
From: "Adrian Cooper" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 3:04 PM
Subject: Re: CF rules!!!


>
> - Original Message -
> From: "Kevin Schmidt" <[EMAIL PROTECTED]>
> Sent: Friday, March 16, 2001 10:50 PM
>
>
> > Maybe he should try [EMAIL PROTECTED]
>
> LOL :-)
>
> Adrian Cooper.
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: atomz Search for Dynamic site

2001-03-15 Thread Jason Lotz

How exactly could it follow 's since they are sent to the browser
after the file has been included?



- Original Message -
From: "Tom" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 3:10 PM
Subject: atomz Search for Dynamic site


> Can anybody give me some info on how they set up an Atomz index for a
> dynamic site?
>
> I have a coldfusion site using fusebox method that uses  template=""> for all links and heavy use of url parameters with case
values.
>
> I set up an Atomz.com index of a fusebox site with the entry point as
> domain/index.cfm
>
> Atomz.com only indexes the display files called by the default fuseaction,
> but does not follow the  in the dsp files.
>
> I know that people have said they did this successfully-can I get a
reality
> check?
>
>
> -Tom
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cfm-resources.com

2001-03-15 Thread Jason Lotz

I use them for several sites.  I wouldn't recommend them for anything
"mission critical" but there is nothing hidden in the costs.  It truly is a
free hosting service that works as expected.  Go for it!

Jason

- Original Message -
From: "Bernd VanSkiver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 1:39 PM
Subject: cfm-resources.com


> I just came across www.cfm-resources.com and was wondering if anyone is
> using them?  I just am skeptical of their service because of its price,
> seems way to good to be true.  Please let me know of your good/bad
> experiences with them.
>
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
> ICQ #: 916324
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Code review PLEASE

2001-03-15 Thread Jason Lotz

Take maxrows out of the  and add it to the  along with a
startrow attribute.

Jason

- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 12:46 PM
Subject: Re: Code review PLEASE


> Your the second one to say that, but locally everything works fine,  if I
> turn the max rows off then I will see all the records and I only want to
see
> one record at time
>
>
> Michael
>
>
>
> "Cami Lawson" <[EMAIL PROTECTED]> wrote in message
> 010001c0ad87$6836dcb0$[EMAIL PROTECTED]">news:010001c0ad87$6836dcb0$[EMAIL PROTECTED]...
> > You have a maxrows = 1 on the query.
> >
> > $.02
> > - Original Message -
> > From: "Mike" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, March 15, 2001 12:59 PM
> > Subject: Code review PLEASE
> >
> >
> > > This is really making me go bald,  I have a page that has next and
> > previous,
> > > and when viewed locally I can see everything, when I ftp to my host
(and
> > yes
> > > the odbc is working and correct) I can only see the first record, and
> > > nothing after that.
> > >
> > > I have tried putting the database(access) in the database folder, and
> > > straight in the directory with all the pages and I still get the same
> > > result, I have replaced the database, and contacted my host, and they
> say
> > > that the code is fine from what little the guy knew about CF.
> > >
> > > Below is the code if someone could share there knowledge I would as
> always
> > > appreciate it.
> > >
> > > And thank you
> > >
> > >
> > > 
> > >
> > > 
> > > 
> > > 
> > >
> > >  > > dbtype="ODBC">
> > > SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
> Profile
> > > FROMinterview
> > > WHERE ID=#ID#
> > > 
> > >
> > > 
> > > 
> > >
> > > Interview Candidates
> > > 
> > >
> > > 
> > > 
> > > 
> > >
> > > 
> > > 
> > > 
> > >  ID
> > >  #id#
> > > 
> > > 
> > >  Candidate Name
> > >  #EmpCandidate#
> > > 
> > > 
> > >  Skill Background
> > >  #SKillBackground#
> > > 
> > > 
> > >  Status
> > >  #Status#
> > > 
> > > 
> > >  Recruiter
> > >  #Recruiter#
> > > 
> > > 
> > >  Profile
> > >   name="Profile">#profile#
> > > 
> > > 
> > > 
> > > 
> > > 
> > > Previous
> > > Next
> > > 
> > > 
> > >
> > >
> > >
> > >
> >
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists