I am currently out of the office and will return on Monday, August 21. Any urgent
concerns should be forwarded to David McCormick or Mary Prosceno.
>>> CF-Talk 08/13/00 22:44 >>>
CF-Talk Sun, 13 Aug 2000 Volume 1 : Number 139
In this issue:
Re: Using <CFX_PGP> tag... comments?
Re: Using <CFX_PGP> tag... comments?
Oracle Time...again
Help - writeEmergencyMessage Error !
mySQL,cf,W2K: possible?
Re: Help - writeEmergencyMessage Error !
Re: [mySQL,cf,W2K: possible?]
RE: [mySQL,cf,W2K: possible?]
RE: [mySQL,cf,W2K: possible?]
RE: More elegant way of passing URL variables?
Re: Oracle Time...again
RE: Queries
RE: user interface resources/groups
Re: Database problems
RE: user interface resources/groups
RE: user interface resources/groups
Dynamic Filefield in CFFILE?
RE: user interface resources/groups
nesting queries
Re: nesting queries
Re: nesting queries
RE: nesting queries
RE: nesting queries
RE: nesting queries
----------------------------------------------------------------------
Date: Sun, 13 Aug 2000 06:58:31 -0400
From: Bud <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Using <CFX_PGP> tag... comments?
Message-ID: <p04320400b5bc2c05cba3@[192.168.0.2]>
On 8/13/00, Britta Wingenroth penned:
>I'm building a site that will take credit card information online on SSL but
>send it to the business to be processed by hand. I need for the mail that
>gets sent from the <cfmail> tag to be encrypted. Apparently PGP is
>installed on my ISP, but the SysAdmins don't know how to use it.
>
>I'm thinking of buying the cfx_pgp tag from the allaire site... has anyone
>used it? Any comments? Is it secure just with using the free version of
>PGP6 and this tag? Are there any other products out there that would do the
>same thing for $150?
>
>Thanks for any feedback!
Yep. Pretty easy. I use it to store credit card information in a
database of recurring monthly billing. I tried all kinds of stuff,
cfx_hash, cf_cryption, cf_encryption. Nothing does what it's supposed
to do. This is probably the most secure method anyway.
Here is the tag, subject being the string to encrypt;
<cfx_pgp action="encrypt"
subject="#encryptit#"
keyring="C:\Pgpnt\Keyrings\pubring.pkr"
UserID="[EMAIL PROTECTED]">
Not exactly sure how you would get their public key into the keyring
on the ISPs server, maybe by importing from a public keyserver. I'm a
little new to PGP and have never tried that, but there is also a
parameter "KEYSERVER" that you'd replace KEYRING above with and put a
FQDN to a public keyserver to get the recipient's public key. I would
presume it may be quicker using a keyring right on the server though,
if possible. After running the tag above, you'd just place the
variable #PGPOut# into the cfmail body. You can also specify your own
variable name.
To see a quick demo:
http://www.twcreations.com/pgp/
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------
Date: Sun, 13 Aug 2000 07:00:26 -0400
From: Bud <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Using <CFX_PGP> tag... comments?
Message-ID: <p04320401b5bc2ff4b8f9@[192.168.0.2]>
I forgot to mention. I'm not sure if this will work with the freeware
version of PGP. I don't think so.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------
Date: Sun, 13 Aug 2000 10:31:43 -0400
From: Scott Mulholland <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: Oracle Time...again
Message-ID: <014811FC8CC2D1118B3800104B63EBE6010F4CF1@ADMIN>
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C00533.33F6C520
Content-Type: text/plain;
charset="iso-8859-1"
I am using the following statement to insert a date/time string into an
Oracle table (date field type):
update MyTable
set API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")#
#TimeFormat(Now(),"hh:mm:ss tt")#')
I keep getting the error message: ORA-01843: not a valid month
Any ideas?
Thanks,
Scott
------_=_NextPart_001_01C00533.33F6C520
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>I am using the
following statement to insert a date/time string into an Oracle table (date
field type):</FONT></SPAN></DIV>
<DIV><SPAN class=030583114-13082000><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>update
MyTable</FONT></SPAN></DIV>
<DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>set
</FONT></SPAN><SPAN class=030583114-13082000><FONT face=Arial size=2>API_UPDATE
= TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss
tt")#')</FONT></SPAN></DIV>
<DIV><SPAN class=030583114-13082000><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>I keep getting the
error message: <FONT face="Times New Roman" size=3>ORA-01843: not a valid month
</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=030583114-13082000></SPAN> </DIV>
<DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>Any
ideas?</FONT></SPAN></DIV>
<DIV><SPAN class=030583114-13082000><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=030583114-13082000><FONT face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2>Scott</FONT></DIV></BODY></HTML>
------_=_NextPart_001_01C00533.33F6C520--
------------------------------
Date: Sun, 13 Aug 2000 08:40:18 -0700
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Help - writeEmergencyMessage Error !
Message-ID: <[EMAIL PROTECTED]>
Hi guys,
one of the servers I'm working with gave me the following error
message for a few minutes straight :
Error occurred while processing request
Error Diagnostic Information
unknown exception condition
CFMLInterpreterImp::writeEmergencyMessage
It returned to normal afterwards, but now I'm wondering if there's
something serious gone wrong! Has anyone encountered this before?
Any ideas on what might be happening?
Thanks in advance,
J
-----
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
------------------------------
Date: Sun, 13 Aug 2000 11:40:17 -0400
From: "Mark Davies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: mySQL,cf,W2K: possible?
Message-ID: <[EMAIL PROTECTED]>
I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
development. Is this possible? I've got everything up and running, but I
can't seem to define the datasource in the CF app server. Is it possible?
Any help much appreciated.
Mark
[EMAIL PROTECTED]
------------------------------
Date: Sun, 13 Aug 2000 11:51:30 -0400
From: [EMAIL PROTECTED] (Eron Cohen)
To: <[EMAIL PROTECTED]>
Subject: Re: Help - writeEmergencyMessage Error !
Message-ID: <075901c0053e$591c9310$8d70add8@tourtoise>
Hi Jonathan,
I have also gotten this error message in ColdFusion 4.51 on Windows NT. And
it mysteriously came and went, I have only seen it twice and never saw it
again. I found another person who's experienced this issue too on
forums.allaire.com. He believes that its related to the numberformat() and
dollarformat() functions. Just out of curiousity, are you using either one
of these on the page in question?
I don't know of anything official from Allaire about this.
Eron
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, August 13, 2000 11:40 AM
Subject: Help - writeEmergencyMessage Error !
>
> Hi guys,
>
> one of the servers I'm working with gave me the following error
> message for a few minutes straight :
>
> Error occurred while processing request
>
> Error Diagnostic Information
>
> unknown exception condition
>
> CFMLInterpreterImp::writeEmergencyMessage
>
> It returned to normal afterwards, but now I'm wondering if there's
> something serious gone wrong! Has anyone encountered this before?
> Any ideas on what might be happening?
>
> Thanks in advance,
>
> J
>
> -----
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------
Date: 13 Aug 00 14:38:34 CDT
From: <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: [mySQL,cf,W2K: possible?]
Message-ID: <[EMAIL PROTECTED]>
yes. you need MyODBC.
"Mark Davies" <[EMAIL PROTECTED]> wrote:
I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
development. Is this possible? I've got everything up and running, but I
can't seem to define the datasource in the CF app server. Is it possible?=
Any help much appreciated.
Mark
[EMAIL PROTECTED]
-------------------------------------------------------------------------=
-----
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in=
the
body.
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=3D=
1
------------------------------
Date: Sun, 13 Aug 2000 15:57:38 -0400
From: "Mark Davies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: [mySQL,cf,W2K: possible?]
Message-ID: <[EMAIL PROTECTED]>
thanks, I've got myodbc installed but can you tell me which ODBC driver I
use? It isn't showing MYODBC -- should it? OR do I use a MS driver?
Mark
_______________________
nyc: 917-922-5279 cell
nyc: 212-431-9002 work
uk: 07957-138858
fax: 530-239-8059
[EMAIL PROTECTED]
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, August 13, 2000 3:39 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [mySQL,cf,W2K: possible?]
>
>
> yes. you need MyODBC.
>
> "Mark Davies" <[EMAIL PROTECTED]> wrote:
> I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
> development. Is this possible? I've got everything up and running, but I
> can't seem to define the datasource in the CF app server. Is it possible?
>
> Any help much appreciated.
>
> Mark
> [EMAIL PROTECTED]
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the
> body.
>
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
------------------------------
Date: Sun, 13 Aug 2000 13:12:15 +0100
From: Chris Straight <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: [mySQL,cf,W2K: possible?]
Message-ID: <000101c0051f$b932c090$86a5df80@uob>
What you need to do is create a system DSN under your odbc control pannel
with all the pertinent information. Once that is done then ColdFusion
recognizes that DS as a valid one under the coldfusion administrator...
---
Chris Straight
Web Applications Developer
University of Oregon Bookstore, inc.
895 E. 13th Ave
Eugene, OR 97401
(541) 346-4331
http://www.uobookstore.com
-----Original Message-----
From: Mark Davies [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 13, 2000 8:58 PM
To: [EMAIL PROTECTED]
Subject: RE: [mySQL,cf,W2K: possible?]
thanks, I've got myodbc installed but can you tell me which ODBC driver I
use? It isn't showing MYODBC -- should it? OR do I use a MS driver?
Mark
_______________________
nyc: 917-922-5279 cell
nyc: 212-431-9002 work
uk: 07957-138858
fax: 530-239-8059
[EMAIL PROTECTED]
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, August 13, 2000 3:39 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [mySQL,cf,W2K: possible?]
>
>
> yes. you need MyODBC.
>
> "Mark Davies" <[EMAIL PROTECTED]> wrote:
> I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
> development. Is this possible? I've got everything up and running, but I
> can't seem to define the datasource in the CF app server. Is it possible?
>
> Any help much appreciated.
>
> Mark
> [EMAIL PROTECTED]
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the
> body.
>
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sun, 13 Aug 2000 16:42:33 -0400
From: "Norman Elton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: More elegant way of passing URL variables?
Message-ID: <[EMAIL PROTECTED]>
Is this code (CF_DecryptURL) available? I've searched the 'net and the
Developer's Exchange but can't find it.
Thanks!
Norman Elton
Information Technology
College of William & Mary
----- Original Message -----
From: "JustinMacCarthy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 11, 2000 9:21 AM
Subject: Re: More elegant way of passing URL variables?
> Encrypt the url ????
> I wrote a couple of tags that encrypt/ decrypt query_strings
>
> so instead of index.cfm?value=6&name=jim
>
> You get
>
> page2.cfm?94946560A4946560B495214551E01031C1D1A.
> and on page2 you include <cf_DeCryptURL>
>
> and you can still use url.value and url.name etc
>
> I don't have it handy at the moment though and it chould do with
> more testing but I'll end it to you over the weekend if you want ...
>
> ~ Justin
>
> ----- Original Message -----
> From: "Milks, Jim" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, August 11, 2000 4:49 PM
> Subject: More elegant way of passing URL variables?
>
>
> > Hi,
> > I am dynamically generating a list of customers, on which a user can
click
> > to go to a detailed page. To do this, I am putting the customerID into a
> URL
> > variable in the A HREF path. But the client doesn't want to see the
value
> in
> > the address bar, as they consider it a security risk.
> >
> > What would be a better solution? A hidden FORM field for each item, and
> have
> > the HREF call Javascript which posts the form? The problem with that us
I
> > will get all of the form fields in the detail page, unless the JS passes
a
> > value to indicate the field I want, but hen I essentially have the same
> > problem....
> >
> > Any input appreciated.
> >
> > James
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
> >
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sun, 13 Aug 2000 17:01:46 -0400
From: "Joseph Eugene" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: Oracle Time...again
Message-ID: <000c01c00569$b2972a10$c7902626@gemini>
Scott,
The date format is Oracle is very picky. Its worth having an
Oracle sql referrence book.
If you just want the current date
"update MyTable
set API_UPDATE = 'Sysdate'"
This will update the date field to the current oracle db date.
If you want to manually update the date with CF
you have to use the format
"12-Jun-2000"
The month should be abbreviated to 3 chars
Thanks
Joe
----- Original Message -----
From: "Scott Mulholland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 13, 2000 10:31 AM
Subject: Oracle Time...again
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01C00533.33F6C520
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> I am using the following statement to insert a date/time string into an
> Oracle table (date field type):
>
> update MyTable
> set API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")#
> #TimeFormat(Now(),"hh:mm:ss tt")#')
>
> I keep getting the error message: ORA-01843: not a valid month
>
> Any ideas?
>
> Thanks,
> Scott
>
> ------_=_NextPart_001_01C00533.33F6C520
> Content-Type: text/html;
> charset="iso-8859-1"
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
>
>
> <META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
> <BODY>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>I am using the
> following statement to insert a date/time string into an Oracle table
(date
> field type):</FONT></SPAN></DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial
> size=2></FONT></SPAN> </DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>update
> MyTable</FONT></SPAN></DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>set
> </FONT></SPAN><SPAN class=030583114-13082000><FONT face=Arial
size=2>API_UPDATE
> = TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss
> tt")#')</FONT></SPAN></DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial
> size=2></FONT></SPAN> </DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>I keep getting
the
> error message: <FONT face="Times New Roman" size=3>ORA-01843: not a valid
month
> </FONT></FONT></SPAN></DIV>
> <DIV><SPAN class=030583114-13082000></SPAN> </DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>Any
> ideas?</FONT></SPAN></DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial
> size=2></FONT></SPAN> </DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial
> size=2>Thanks,</FONT></SPAN></DIV>
> <DIV><FONT face=Arial size=2>Scott</FONT></DIV></BODY></HTML>
>
> ------_=_NextPart_001_01C00533.33F6C520--
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------
Date: Sun, 13 Aug 2000 20:24:46 -0400
From: [EMAIL PROTECTED] (Dave Watts)
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Subject: RE: Queries
Message-ID: <000301c00586$60179a50$[EMAIL PROTECTED]>
> 1. Just curious, is it possible to do a query across two
> different datasources? I have a table in one datasource and
> I would like to do some kind of join query on another table
> that would make things simple except that the other table is
> in another datasource. Is it possible to do the query regardless
> of the fact that the tables are in different datasources?
No, you can't generally do this from within CF. You do have some options,
though. Your database may allow referencing other databases from within your
query; SQL Server 7, for example, lets you do some things like this. Also,
you can simply query each datasource, then merge the query results within
CF. This will require a little CF code, but I believe there are custom tags
available (one called CF_MERGEQUERY comes to mind) which will do this.
> 2. Is it possible to do a query on a query result set? I have
> the results from a CFQUERY but I was wondering if one could then
> do a query using the query results as if it was a table itself?
No, you can't use SQL to filter recordsets after you've retrieved them.
However, again, you can build something analogous to this using CFML to
filter your recordset.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------
Date: Sun, 13 Aug 2000 20:30:06 -0400
From: [EMAIL PROTECTED] (Dave Watts)
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Subject: RE: user interface resources/groups
Message-ID: <000401c00587$1323c8d0$[EMAIL PROTECTED]>
> can anyone suggest any user interface focused websites or user groups?
>
> i'm interested in researching application standards like:
> - button naming (Save or Submit? Edit or Modify?)
> - button placement (Save before Cancel or Cancel before Save?)
> - current trends (tabbed, explorer-like menus, etc)
> - UI critique of current software (MacOS, Windows) and websites
Although it's neither a website nor a user group, I'd strongly recommend
taking a look at Alan Cooper's book "About Face - The Essentials of User
Interface Design". You can find out more about it at http://www.cooper.com/.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------
Date: Sun, 13 Aug 2000 19:36:01 -0500
From: John Allred <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Database problems
Message-ID: <[EMAIL PROTECTED]>
Katrina,
You and Dan removed a huge weight that had made lots of stuff difficult.
Moving the CFLOCATION outside the CFTRANSACTION did the trick.
Thanks so much,
--John
"Chapman, Katrina" wrote:
>
> Try This.
>
> <cftransaction>
> <cfquery datasource="county">
> (insert query)
> </cfquery>
>
> <cfquery name="getid" datasource="county">
> (get last entered record)
> </cfquery>
>
> <cfset record = #getid.newrecord#>
> </cftransaction>
>
> <cfif IsDefined("record")>
> <cflocation url="link_add.cfm">
> <cfelse>
> There was an error.
> </cfif>
>
------------------------------
Date: Sun, 13 Aug 2000 17:49:52 -0700
From: [EMAIL PROTECTED] (paul smith)
To: [EMAIL PROTECTED]
Subject: RE: user interface resources/groups
Message-ID: <[EMAIL PROTECTED]>
I don't know about the book, but the ideas on the http://www.cooper.com/
website have a lot in common with those in "Streetwise Relationship
Marketing on the Internet",
http://www.amazon.com/exec/obidos/ASIN/1580622550/002-1005726-6333617,
which is the single best book I've seen on the subject in quite a while.
best, paul
At 08:30 PM 8/13/00 -0400, you wrote:
>Although it's neither a website nor a user group, I'd strongly recommend
>taking a look at Alan Cooper's book "About Face - The Essentials of User
>Interface Design". You can find out more about it at http://www.cooper.com/.
------------------------------
Date: Sun, 13 Aug 2000 17:59:42 -0700
From: [EMAIL PROTECTED] (paul smith)
To: [EMAIL PROTECTED]
Subject: RE: user interface resources/groups
Message-ID: <[EMAIL PROTECTED]>
The 47 reviews of the book on www.amazon.com are a must read.
best, paul
At 08:30 PM 8/13/00 -0400, you wrote:
>Although it's neither a website nor a user group, I'd strongly recommend
>taking a look at Alan Cooper's book "About Face - The Essentials of User
>Interface Design". You can find out more about it at http://www.cooper.com/.
------------------------------
Date: Mon, 14 Aug 2000 11:00:03 +1000
From: Eldo Lukman - Monitor <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Dynamic Filefield in CFFILE?
Message-ID: <91753AED702FD311B59B0080C8D846C3257356@bsyd1>
Hi All,
Is it possible at all to specify a dynamic value for the 'filefield'
parameter in a CFFILE tag? I have a code that dynamically build a form from
the database, and I need to be able to dynamically specify a dynamic
filefield in the processing bit.
The doco says that you cannot use the # sign to specify the
filefield. Is there a way around this?
thanks in advance,
---
Eldo Lukman
Multimedia Programmer
Monitor Interactive Communications Pty Ltd
ACN: 050 036 283
Level 2, 4-14 Foster Street
Surry Hills, NSW 2010
AUSTRALIA
Telephone: +61 2 9219 8956
Facsimile: +61 2 9219 8950
E-mail: [EMAIL PROTECTED]
Mobile: 0418 265 829
Web Site: http://www.monitorinteractive.com.au/
---
------------------------------
Date: Sun, 13 Aug 2000 21:06:00 -0400
From: [EMAIL PROTECTED] (Dave Watts)
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Subject: RE: user interface resources/groups
Message-ID: <000501c0058c$74f04e80$[EMAIL PROTECTED]>
> I don't know about the book, but the ideas on the
> http://www.cooper.com/ website have a lot in common
> with those in "Streetwise Relationship Marketing on the
> Internet",
> http://www.amazon.com/exec/obidos/ASIN/1580622550/002-1005726-6333617,
> which is the single best book I've seen on the subject
> in quite a while.
The book slightly predates the popularity of the internet, really (1995),
but it's still just as valid as it ever was.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------
Date: Sun, 13 Aug 2000 21:09:26 -0400
From: "Mark Davies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: nesting queries
Message-ID: <[EMAIL PROTECTED]>
also a novice, and am stuck. Am trying to nest a query theoretically like
the following...
<CFQUERY name='cities'>
select city
from areas
</CFQUERY>
<CFOUTPUT>#city#<br>
<CFQUERY>
select neighborhood
from areas
where city = '#city#'
</CFQUERY>
<CFOUTPUT>#neighborhood#<br></CFOUTPUT>
</CFOUTPUT>
I know this has got to be quite simple to do, but I'm just lost in all the
unfamiliar phrases and documentation. Can anyone tell me the trick?
Cheers,
Mark
------------------------------
Date: Mon, 14 Aug 2000 11:13:29 +1000
From: Mark Ireland <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: nesting queries
Message-ID: <[EMAIL PROTECTED]>
Its is as easy as
> where city = '#cities.city#'
At 09:09 PM 13/08/00 -0400, you wrote:
>also a novice, and am stuck. Am trying to nest a query theoretically like
>the following...
>
><CFQUERY name='cities'>
> select city
> from areas
></CFQUERY>
>
><CFOUTPUT>#city#<br>
>
> <CFQUERY>
> select neighborhood
> from areas
> where city = '#city#'
> </CFQUERY>
> <CFOUTPUT>#neighborhood#<br></CFOUTPUT>
>
></CFOUTPUT>
>
>I know this has got to be quite simple to do, but I'm just lost in all the
>unfamiliar phrases and documentation. Can anyone tell me the trick?
>
>Cheers,
>
>Mark
------------------------------
Date: Sun, 13 Aug 2000 21:50:24 -0400
From: Sharon DiOrio <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: nesting queries
Message-ID: <[EMAIL PROTECTED]> (added by bilbo.mindseye.com)
You've almost got it. Try this:
<CFQUERY name="cities" datasource="#dsn#">
select city
from areas
</CFQUERY>
<CFOUTPUT QUERY="cities">#city#<br>
<CFQUERY name="neighborhoods" datasource="#dsn#">
select neighborhood
from areas
where city = '#city#'
</CFQUERY>
<CFLOOP query="neighborhoods">#neighborhoods.neighborhood#<br></CFLOOP>
</CFOUTPUT>
HTH,
Sharon
At 09:09 PM 8/13/2000 -0400, Mark Davies wrote:
>also a novice, and am stuck. Am trying to nest a query theoretically like
>the following...
>
><CFQUERY name='cities'>
> select city
> from areas
></CFQUERY>
>
><CFOUTPUT>#city#<br>
>
> <CFQUERY>
> select neighborhood
> from areas
> where city = '#city#'
> </CFQUERY>
> <CFOUTPUT>#neighborhood#<br></CFOUTPUT>
>
></CFOUTPUT>
>
>I know this has got to be quite simple to do, but I'm just lost in all the
>unfamiliar phrases and documentation. Can anyone tell me the trick?
>
>Cheers,
>
>Mark
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------
Date: Sun, 13 Aug 2000 21:52:59 -0400
From: "Norman Elton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: nesting queries
Message-ID: <[EMAIL PROTECTED]>
>From the looks of it, you're trying to get an output like:
---
City 1
Neighborhood A
Neighborhood B
Neighborhood C
City 2
Neighborhood D
Neighborhood E
Neighborhood F
---
If so, try this:
---
<CFQUERY Name="MyQuery">
select city, neighborhood
from areas
order by city, neighborhood
</CFQUERY>
<CFOUTPUT Query="MyQuery" Group="City">
#City#<BR>
<CFOUTPUT>
#Neighborhood#<BR>
</CFOUTPUT>
<BR>
</CFOUTPUT>
---
The query returns all the neighborhoods and their corresponding cities,
sorted for a nice pretty output (this is actually important if your cities
appear out of alphabetical order in the database).
The first CFOUTPUT tells ColdFusion that you will be outputting the query,
and you want to group the output by city. The code outside the second
CFOUTPUT is only executed once per city. The code inside the second CFOUTPUT
is then executed once per record (i.e. in this case, once per neighborhood).
Once a new city is reached, this inner loop stops and the process starts
over again with the first CFOUTPUT.
Hope this helps. If this wasn't what you were trying to do, well now you
know!
Norman Elton
Information Technology
College of William & Mary
-----Original Message-----
From: Mark Ireland [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 13, 2000 9:13 PM
To: [EMAIL PROTECTED]
Subject: Re: nesting queries
Its is as easy as
> where city = '#cities.city#'
At 09:09 PM 13/08/00 -0400, you wrote:
>also a novice, and am stuck. Am trying to nest a query theoretically like
>the following...
>
><CFQUERY name='cities'>
> select city
> from areas
></CFQUERY>
>
><CFOUTPUT>#city#<br>
>
> <CFQUERY>
> select neighborhood
> from areas
> where city = '#city#'
> </CFQUERY>
> <CFOUTPUT>#neighborhood#<br></CFOUTPUT>
>
></CFOUTPUT>
>
>I know this has got to be quite simple to do, but I'm just lost in all the
>unfamiliar phrases and documentation. Can anyone tell me the trick?
>
>Cheers,
>
>Mark
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------
Date: Sun, 13 Aug 2000 21:58:21 -0400
From: "Norman Elton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: nesting queries
Message-ID: <[EMAIL PROTECTED]>
Well I see responses are rolling, and I've already noticed a problem in
mine... the CFQUERY line should read:
<CFQUERY Name="Cities" DataSource="...">
Insert the name of your datasource (as configured in the CF Administrator)
into the "...".
Norman Elton
Information Technology
College of William & Mary
------------------------------
Date: Sun, 13 Aug 2000 22:18:24 -0400
From: Sharon DiOrio <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: nesting queries
Message-ID: <[EMAIL PROTECTED]> (added by bilbo.mindseye.com)
Half asleep. Norman's got the right answer on this one.
Sharon
At 09:52 PM 8/13/2000 -0400, Norman Elton wrote:
>From the looks of it, you're trying to get an output like:
>
>---
>City 1
> Neighborhood A
> Neighborhood B
> Neighborhood C
>
>City 2
> Neighborhood D
> Neighborhood E
> Neighborhood F
>---
>
>If so, try this:
>
>---
><CFQUERY Name="MyQuery">
> select city, neighborhood
> from areas
> order by city, neighborhood
></CFQUERY>
>
><CFOUTPUT Query="MyQuery" Group="City">
> #City#<BR>
> <CFOUTPUT>
> #Neighborhood#<BR>
> </CFOUTPUT>
> <BR>
></CFOUTPUT>
>---
>
>The query returns all the neighborhoods and their corresponding cities,
>sorted for a nice pretty output (this is actually important if your cities
>appear out of alphabetical order in the database).
>
>The first CFOUTPUT tells ColdFusion that you will be outputting the query,
>and you want to group the output by city. The code outside the second
>CFOUTPUT is only executed once per city. The code inside the second CFOUTPUT
>is then executed once per record (i.e. in this case, once per neighborhood).
>Once a new city is reached, this inner loop stops and the process starts
>over again with the first CFOUTPUT.
>
>Hope this helps. If this wasn't what you were trying to do, well now you
>know!
>
>Norman Elton
>Information Technology
>College of William & Mary
>
>-----Original Message-----
>From: Mark Ireland [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, August 13, 2000 9:13 PM
>To: [EMAIL PROTECTED]
>Subject: Re: nesting queries
>
>
>
>Its is as easy as
>> where city = '#cities.city#'
>
>
>
>At 09:09 PM 13/08/00 -0400, you wrote:
>>also a novice, and am stuck. Am trying to nest a query theoretically like
>>the following...
>>
>><CFQUERY name='cities'>
>> select city
>> from areas
>></CFQUERY>
>>
>><CFOUTPUT>#city#<br>
>>
>> <CFQUERY>
>> select neighborhood
>> from areas
>> where city = '#city#'
>> </CFQUERY>
>> <CFOUTPUT>#neighborhood#<br></CFOUTPUT>
>>
>></CFOUTPUT>
>>
>>I know this has got to be quite simple to do, but I'm just lost in all the
>>unfamiliar phrases and documentation. Can anyone tell me the trick?
>>
>>Cheers,
>>
>>Mark
>
>----------------------------------------------------------------------------
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------
End of CF-Talk V1 #139
**********************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
