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 cfcontent.

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 cfheader 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:

 cfset attributes.temp=structnew()

 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
cfset queryName = MyQuery

cfquery name=#queryName# datasource=#application.dns# dbtype=ODBC
username=#application.dns_username# password=#application.dns_password#
cachedwithin=#CreateTimeSpan(0,0,10,0)#
SELECT *
FROM data
WHERE dataid = #dataid#
/cfquery

cfset queryCount= evaluate(queryName  .recordcount)

cfoutput#queryCount#/cfoutput
cfabort

~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: 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:

cfquery name=Session.MyQuery.


- 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.

 cfset session.savedquery = queryname

 then you can do your cfoutput query=session.savedquery
maxrows=#nrows#

 be sure to put cflock around your cfset 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
  cfquery name=3Dlist datasource=3Dhouseboat
SELECT lake_id,lake,(statename, statename2,statename3) as statenames
FROM rental_lakes
order by statenames,lake
/CFQUERY
 
  and the output
 CFOUTPUT QUERY =3D list Group=3Dstatenames
  ul
   listatenames#/li
  ul
  =20
   cfoutput lia href=3Dlakes.cfm?lake_id=3D#lake_id##lake#/a =
  /li
  /cfoutput
 
  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
 
  !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
  HTMLHEAD
  META http-equiv=3DContent-Type content=3Dtext/html; =
  charset=3Diso-8859-1
  META content=3DMSHTML 5.50.4522.1800 name=3DGENERATOR
  STYLE/STYLE
  /HEAD
  BODY bgColor=3D#ff
  DIVFONT face=3DArial size=3D2I 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./FONT/DIV
  DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
  DIVFONT face=3DArial size=3D2My table looks like this/FONT/DIV
  DIVFONT face=3DArial size=3D2lakenbsp;nbsp;nbsp;nbsp; =
  nbsp;lake_idnbsp;=20
  nbsp;nbsp;nbsp; state1nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =20
  state2nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; state3/FONT/DIV
  DIVFONT face=3DArial size=3D2Powelnbsp;nbsp;nbsp;=20
 
7nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=
  nbsp;nbsp;nbsp;=20
  Utahnbsp;nbsp;nbsp; nbsp;nbsp;nbsp; Arizona/FONT/DIV
  DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
  DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
  DIVFONT face=3DArial size=3D2my query is/FONT/DIV
  DIVFONT face=3DArial size=3D2lt;cfquery name=3Dlist=20
  datasource=3Dhouseboatgt;BRnbsp; SELECT
lake_id,lake,(statename,=20
  statename2,statename3) as statenamesBRnbsp; FROM =
  rental_lakesBRnbsp; order=20
  by statenames,lakeBRnbsp; lt;/CFQUERYgt;/FONT/DIV
  DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
  DIVFONT face=3DArial size=3D2and the output/FONT/DIV
  DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp;lt;CFOUTPUT QUERY =
  =3D list=20
 
Group=3Dstatenamesgt;BRnbsp;nbsp;nbsp;nbsp;lt;ulgt;BRnbsp;=
  lt;ligt;statenames#lt;/ligt;BRnbsp;nbsp;nbsp;=20
  lt;ulgt;BRnbsp;nbsp;nbsp;nbsp;nbsp;BRnbsp;lt;cfoutput=20
  gt;lt;ligt;lt;a =
  href=3Dlakes.cfm?lake_id=3D#lake_id#gt;#lake#lt;/agt;=20
  lt;/ligt;BRlt;/cfoutputgt;/FONT/DIV
  DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
  DIVFONT face=3DArial size=3D2Is this possible? Am I in the wrong =
  direction here?=20
  What I need for output is:/FONT/DIV
  DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
  DIVFONT face=3DArial size=3D2Arizona/FONT/DIV
  DIVFONT face=3DArial size=3D2*Lake Powell/FONT/DIV
  DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
  DIVFONT face=3DArial size=3D2Utah/FONT/DIV
  DIVFONT face=3DArial size=3D2*Lake Powell/FONT/DIV
  DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
  DIVFONT face=3DArial size=3D2I have been working on this all week, =
  

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: 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. :-)


 !--- For Number of Skills ---
 cfquery name=q_BM_score datasource=datasource
 Select CandidateID, Count(*) AS num_skills
 From CandidateSkills
 Where CandidateSkills.CandidateID IN (#ListCandidateID#)
 Group By CandidateID
 /cfquery


 !--- Query for skill points ---
 cfquery name=q_BM_score datasource=datasource
 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#))
 /cfquery

 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

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. :-)
 
 
  !--- For Number of Skills ---
  cfquery name=q_BM_score datasource=datasource
  Select CandidateID, Count(*) AS num_skills
  From CandidateSkills
  Where CandidateSkills.CandidateID IN (#ListCandidateID#)
  Group By CandidateID
  /cfquery
 
 
  !--- Query for skill points ---
  cfquery name=q_BM_score datasource=datasource
  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#))
  /cfquery
 
  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



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: 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 cfapplication, 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



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


 cfif CheckLogin.RecordCount Is 0 Or CheckLogin.RecordCount GT 1
   cfset Session.error_message="Your Login Information Is Incorrect.
Please Try Again."
   cflocation url="/login.cfm" addtoken="No"
 cfelseif CheckLogin.RecordCount Is 1
   cfcookie name="UserLevel" value="#int(CheckLogin.UserLevel)#"
expires="1"
   cfcookie name="LoggedIn" value="true" expires="1"
   cfcookie name="Username" value="#CheckLogin.Username#" expires="1"
   cfcookie name="UserID" value="#int(CheckLogin.UserID)#" expires="1"
   cflocation url="/members/index.cfm" addtoken="Yes"
 cfelse
   cflocation url="/login.cfm" addtoken="No"
 /cfif




~~
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: 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 cfinclude the .js file, CF automatically parses it,
even though it isn't a .cfm file.

In other words, cfinclude template="myjsfile.js" 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?

 CF_ProcessThisJSFileOnly

 ..js file contents.

 /CF_ProcessThisJSFileOnly

 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 style tags, I know longer
have the option to edit the stylesheet.  Also, when I click the link on the
shortcut bar, nothing happens.  Has this happened to anyone else?  Any
suggestions?

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: 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?

 CFSCRIPT
 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';}
 }

 /CFSCRIPT
 CFOUTPUT#abc#BR#txt_status#/CFOUTPUT

 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?
 
  CFINSERT DATASOURCE="#application.DSN#" tableName="registration"
  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" 
 
   CFINSERT DATASOURCE="#application.DSN#" tableName="addlregs"
   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
 frameset and body 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...

 html
 head
 titleeMarketing Magazine/title
 /head

 !-- frames --
 frameset rows="122,*"
 frame name="H" src="header.cfm" marginwidth="0" marginheight="0"
 scrolling="no" frameborder="0"
 frameset cols="155,*"
frame name="L" src="menu.cfm" marginwidth="5" marginheight="10"
 scrolling="auto" frameborder="0"
 frame name="R" src="home.cfm" marginwidth="10" marginheight="10"
 scrolling="auto" frameborder="0"
 /frameset
 /frameset

 body bgcolor="#FF"

 /body
 /html

 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



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: 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



Re: elseif in cfscript?

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 cfscript?


 Is there no elseif in cfscript? 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



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: 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...

img src="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
 cfhttp method="GET"
url="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.
 
  cfhttp method="GET"
  url="http://www.lexus.com/images/home/mn_ph_sc_top.jpg"/cfhttp
  cfoutput
  hr
  #cfhttp.header#
  hr
  #cfhttp.filecontent#
  /cfoutput
 
 
  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



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



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: 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



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: 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: 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: Code review PLEASE

2001-03-15 Thread Jason Lotz

Take maxrows out of the cfquery and add it to the cfoutput 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
  
  
   !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"
  
   HTML
   HEAD
   CFPARAM Name="ID" Default=1
  
   cfquery name="selectcandidate" datasource="interview" maxrows=1
   dbtype="ODBC"
   SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter,
 Profile
   FROMinterview
   WHERE ID=#ID#
   /cfquery
  
   CFSET NextID=#id#+1
   CFSET PrevID=#id#-1
  
   TITLEInterview Candidates/TITLE
   /HEAD
  
   BODY bgcolor="6699ff"
   !--- include toolbar.cfm---
   cfinclude template="Toolbar.cfm"
  
   cfoutput query="Selectcandidate"
   table cellpadding="10"
   tr
tdID/tdbr
td#id#/tdbr
   /tr
   tr
tdCandidate Name/tdbr
td#EmpCandidate#/tdbr
   /tr
   tr
tdSkill Background/td
td#SKillBackground#/td
   /tr
   tr
tdStatus/td
td#Status#/td
   /tr
   tr
tdRecruiter/td
td#Recruiter#/td
   /tr
   tr
td valign="top"Profile/td
tdtextarea cols="50" rows="5"
 name="Profile"#profile#/textarea/td
   /tr
   /table
   BRBR
   table width="85%" border="0"
   TR
   TD align="left"a href="default2.cfm?ID=#PrevID#"Previous/a/TD
   td align="right"a href="default2.cfm?ID=#NextID#"Next/a/td
   /td/TR/table
   /cfoutput
  
  
  
  
 


~~
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: atomz Search for Dynamic site

2001-03-15 Thread Jason Lotz

How exactly could it follow cfinclude'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 cfinclude
 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 cfinclude template="" 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