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/14/00 06:44 >>>
CF-Talk Mon, 14 Aug 2000 Volume 1 : Number 140
In this issue:
Re: CF-Talk V1 #139 (Out of office)
Re: CF-Talk V1 #139 (Out of office)
Mail Archives
Re: Mail Archives
Re: Mail Archives
cfgrid and submit buttons
Re: Double Dimesion ArraySorting
Free text verity search in CF
? onChange and cfset
RE: CF-Talk V1 #139 (Out of office)
FORM values doubling when submitted. (When C&P from Word)
RE: Select Distinct not so distinct
----------------------------------------------------------------------
Date: Sun, 13 Aug 2000 22:34:54 -0400
From: "Julie Hopple" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: CF-Talk V1 #139 (Out of office)
Message-ID: <[EMAIL PROTECTED]>
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=20
database of recurring monthly billing. I tried all kinds of stuff,=20
cfx_hash, cf_cryption, cf_encryption. Nothing does what it's supposed=20
to do. This is probably the most secure method anyway.
Here is the tag, subject being the string to encrypt;
<cfx_pgp action=3D"encrypt"
subject=3D"#encryptit#"
keyring=3D"C:\Pgpnt\Keyrings\pubring.pkr"
UserID=3D"[EMAIL PROTECTED]">
Not exactly sure how you would get their public key into the keyring=20
on the ISPs server, maybe by importing from a public keyserver. I'm a=20
little new to PGP and have never tried that, but there is also a=20
parameter "KEYSERVER" that you'd replace KEYRING above with and put a=20
FQDN to a public keyserver to get the recipient's public key. I would=20
presume it may be quicker using a keyring right on the server though,=20
if possible. After running the tag above, you'd just place the=20
variable #PGPOut# into the cfmail body. You can also specify your own=20
variable name.
To see a quick demo:
http://www.twcreations.com/pgp/
--=20
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=20
version of PGP. I don't think so.
--=20
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.
------_=3D_NextPart_001_01C00533.33F6C520
Content-Type: text/plain;
charset=3D"iso-8859-1"
I am using the following statement to insert a date/time string into an
Oracle table (date field type):
=20
update MyTable
set API_UPDATE =3D TO_DATE('#DateFormat(Now(),"mm/dd/yy")#
#TimeFormat(Now(),"hh:mm:ss tt")#')
=20
I keep getting the error message: ORA-01843: not a valid month=20
=20
Any ideas?
=20
Thanks,
Scott
------_=3D_NextPart_001_01C00533.33F6C520
Content-Type: text/html;
charset=3D"iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-=
1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D030583114-13082000><FONT face=3DArial size=3D2>I am =
using the=20
following statement to insert a date/time string into an Oracle table =
(date=20
field type):</FONT></SPAN></DIV>
<DIV><SPAN class=3D030583114-13082000><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D030583114-13082000><FONT face=3DArial size=3D2>update=20=
MyTable</FONT></SPAN></DIV>
<DIV><SPAN class=3D030583114-13082000><FONT face=3DArial size=3D2>set=20
</FONT></SPAN><SPAN class=3D030583114-13082000><FONT face=3DArial =
size=3D2>API_UPDATE=20
=3D TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss=20
tt")#')</FONT></SPAN></DIV>
<DIV><SPAN class=3D030583114-13082000><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D030583114-13082000><FONT face=3DArial size=3D2>I keep =
getting the=20
error message: <FONT face=3D"Times New Roman" size=3D3>ORA-01843: not a =
valid month=20
</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D030583114-13082000></SPAN> </DIV>
<DIV><SPAN class=3D030583114-13082000><FONT face=3DArial size=3D2>Any=20
ideas?</FONT></SPAN></DIV>
<DIV><SPAN class=3D030583114-13082000><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D030583114-13082000><FONT face=3DArial=20
size=3D2>Thanks,</FONT></SPAN></DIV>
<DIV><FONT face=3DArial size=3D2>Scott</FONT></DIV></BODY></HTML>
------_=3D_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?=20
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=3Dlists&body=3Dlists/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?=3D
Any help much appreciated.
Mark
[EMAIL PROTECTED]
-------------------------------------------------------------------------=
=3D
-----
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=3D3Dlists/cf_=
ta=3D
lk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' =
in=3D
the
body.
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=3D3D=
=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=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
> ------------------------------------------------------------------
> ------------
> 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=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
> ------------------------------------------------------------------
> ------------
> 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=3Dlists&body=3Dlists/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=3D6&name=3Djim
>
> 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=3Dlists&body=3Dlists/cf_ta=
lk 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=3Dlists&body=3Dlists/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=3Dlists&body=3Dlists/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 =3D '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.
>
> ------_=3D_NextPart_001_01C00533.33F6C520
> Content-Type: text/plain;
> charset=3D"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 =3D 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
>
> ------_=3D_NextPart_001_01C00533.33F6C520
> Content-Type: text/html;
> charset=3D"iso-8859-1"
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-885=
9-1">
>
>
> <META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR></HEAD>
> <BODY>
> <DIV><SPAN class=3D030583114-13082000><FONT face=3DArial size=3D2>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=3D030583114-13082000><FONT face=3DArial
> size=3D2></FONT></SPAN> </DIV>
> <DIV><SPAN class=3D030583114-13082000><FONT face=3DArial size=3D2>update
> MyTable</FONT></SPAN></DIV>
> <DIV><SPAN class=3D030583114-13082000><FONT face=3DArial size=3D2>set
> </FONT></SPAN><SPAN class=3D030583114-13082000><FONT face=3DArial
size=3D2>API_UPDATE
> =3D TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss
> tt")#')</FONT></SPAN></DIV>
> <DIV><SPAN class=3D030583114-13082000><FONT face=3DArial
> size=3D2></FONT></SPAN> </DIV>
> <DIV><SPAN class=3D030583114-13082000><FONT face=3DArial size=3D2>I keep =
getting
the
> error message: <FONT face=3D"Times New Roman" size=3D3>ORA-01843: not a =
valid
month
> </FONT></FONT></SPAN></DIV>
> <DIV><SPAN class=3D030583114-13082000></SPAN> </DIV>
> <DIV><SPAN class=3D030583114-13082000><FONT face=3DArial size=3D2>Any
> ideas?</FONT></SPAN></DIV>
> <DIV><SPAN class=3D030583114-13082000><FONT face=3DArial
> size=3D2></FONT></SPAN> </DIV>
> <DIV><SPAN class=3D030583114-13082000><FONT face=3DArial
> size=3D2>Thanks,</FONT></SPAN></DIV>
> <DIV><FONT face=3DArial size=3D2>Scott</FONT></DIV></BODY></HTML>
>
> ------_=3D_NextPart_001_01C00533.33F6C520--
> -------------------------------------------------------------------------=
-
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/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:
>=20
> Try This.
>=20
> <cftransaction>
> <cfquery datasource=3D"county">
> (insert query)
> </cfquery>
>=20
> <cfquery name=3D"getid" datasource=3D"county">
> (get last entered record)
> </cfquery>
>=20
> <cfset record =3D #getid.newrecord#>
> </cftransaction>
>=20
> <cfif IsDefined("record")>
> <cflocation url=3D"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/=20=
website have a lot in common with those in "Streetwise Relationship=20
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/
---=20
------------------------------
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=3D'cities'>
select city
from areas
</CFQUERY>
<CFOUTPUT>#city#<br>
<CFQUERY>
select neighborhood
from areas
where city =3D '#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 =3D '#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=3D'cities'>
> select city
> from areas
></CFQUERY>
>
><CFOUTPUT>#city#<br>
>
> <CFQUERY>
> select neighborhood
> from areas
> where city =3D '#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=3D"cities" datasource=3D"#dsn#">
select city
from areas
</CFQUERY>
<CFOUTPUT QUERY=3D"cities">#city#<br>
<CFQUERY name=3D"neighborhoods" datasource=3D"#dsn#">
select neighborhood
from areas
where city =3D '#city#'
</CFQUERY>
<CFLOOP query=3D"neighborhoods">#neighborhoods.neighborhood#<br></CFLO=
OP>
</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=3D'cities'>
> select city
> from areas
></CFQUERY>
>
><CFOUTPUT>#city#<br>
>
> <CFQUERY>
> select neighborhood
> from areas
> where city =3D '#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=3Dlistsbody=3Dlists/cf_talk =
or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>=20
------------------------------
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=3D"MyQuery">
select city, neighborhood
from areas
order by city, neighborhood
</CFQUERY>
<CFOUTPUT Query=3D"MyQuery" Group=3D"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 =3D '#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=3D'cities'>
> select city
> from areas
></CFQUERY>
>
><CFOUTPUT>#city#<br>
>
> <CFQUERY>
> select neighborhood
> from areas
> where city =3D '#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=3Dlists&body=3Dlists/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=3D"Cities" DataSource=3D"...">
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=3D"MyQuery">
> select city, neighborhood
> from areas
> order by city, neighborhood
></CFQUERY>
>
><CFOUTPUT Query=3D"MyQuery" Group=3D"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 =3D '#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=3D'cities'>
>> select city
>> from areas
>></CFQUERY>
>>
>><CFOUTPUT>#city#<br>
>>
>> <CFQUERY>
>> select neighborhood
>> from areas
>> where city =3D '#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=3Dlistsbody=3Dlists/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=3Dlistsbody=3Dlists/cf_talk =
or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>=20
------------------------------
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=3Dlists=
&body=3Dlists/cf_talk or send a message to [EMAIL PROTECTED]=
m with 'unsubscribe' in the body.
------------------------------
Date: Wed, 13 Sep 2000 20:45:32 -0600
From: "Brian Thornton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: CF-Talk V1 #139 (Out of office)
Message-ID: <001301c01df5$da1cfde0$[EMAIL PROTECTED]>
Can we say annoying?
----- Original Message -----
From: Julie Hopple <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 13, 2000 8:34 PM
Subject: Re: CF-Talk V1 #139 (Out of office)
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?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------
Date: Sun, 13 Aug 2000 21:58:37 CDT
From: "Eric Dawson" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Mail Archives
Message-ID: <[EMAIL PROTECTED]>
Where are the cftalk archives housed?
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------
Date: Wed, 13 Sep 2000 21:08:36 -0600
From: "Brian Thornton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: Mail Archives
Message-ID: <004301c01df9$261a64a0$[EMAIL PROTECTED]>
look at the footer... :)
----- Original Message -----
From: Eric Dawson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 13, 2000 8:58 PM
Subject: Mail Archives
> Where are the cftalk archives housed?
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 22:11:30 CDT
From: "Eric Dawson" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Mail Archives
Message-ID: <[EMAIL PROTECTED]>
whoops. I did go to houseoffusion.com though.
From: "Brian Thornton" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: Re: Mail Archives
Date: Wed, 13 Sep 2000 21:08:36 -0600
look at the footer... :)
----- Original Message -----
From: Eric Dawson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 13, 2000 8:58 PM
Subject: Mail Archives
> Where are the cftalk archives housed?
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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.
>
------------------------------------------------------------------------------
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 Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------
Date: Mon, 14 Aug 2000 15:06:24 +0930
From: Phil Palmer <[EMAIL PROTECTED]>
To: "CF-Talk Group (E-mail)" <[EMAIL PROTECTED]>
Subject: cfgrid and submit buttons
Message-ID: <80B70AD95D6BD411BBE10080AD74CAB52BE0@ENGAGEM2>
Dear all
When I use a CFGRID on a form and then submit the form, all the details
about the current row in the grid are passed through. This is when I
use a 'submit' button which calls a javascript function which does a
submit of the form.
If i replace the 'submit' button with a gif of a button and do the same
onclick event to the same javascript function the details of the grid are
NOT passed through by the form.
The details are :
CF version 4.5 on NT
If the code is :
<a onClick="update_onclick()"><img name="update_btn"
src="buttons/update_btn.gif"></a>
<input type="submit" name="update" value="Update" onclick="update_onclick">
The submit button works ok but the gif doesnt when the javascript function
is :
function update_onclick()
{
the_form.submit()
}
Any ideas????
Phil Palmer
------------------------------
Date: Mon, 14 Aug 2000 12:05:49 +0530
From: "Vincent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Subject: Re: Double Dimesion ArraySorting
Message-ID: <00a301c005b9$ea170640$[EMAIL PROTECTED]>
Thanks a ton! I'll work on that !
cheers,
vin
-----Original Message-----
From: JustinMacCarthy <>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, August 11, 2000 5:52 PM
Subject: Re: Double Dimesion ArraySorting
>Build a structure (associative array) where you have
> the value you are trying to sort (array[x][5]) as the keyname
>and the array[x] as the keyvalue
------------------------------
Date: Mon, 14 Aug 2000 14:43:09 +0800
From: "Roger Lim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Free text verity search in CF
Message-ID: <001601c005ba$e9107640$[EMAIL PROTECTED]>
Guys,
may I know how do I achieve searching only part of the word in verity search
without using any wildcard? For example, I just type "ho" in the textbox and
all the words that consists of "ho" will be found.
thanks
------------------------------
Date: Mon, 14 Aug 2000 01:03:19 -0700 (PDT)
From: Ins <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: ? onChange and cfset
Message-ID: <[EMAIL PROTECTED]>
Hi, There is a select list in my form. I want a new
form filed to be written after the selection is done
before the form submit:
<select name="country">
<option value="uk">UK
<option value="usa">USA
</select>
If user selects UK, a new form will written under the
selection field:
<P>UK something: UK related form
fields
If user selects USA, another field will be writtten
under this selection:
<p> USA something.....USA related form
fields
-------------------------------------------
I am doing this using onChange , but does not work:
<select name="country" size="1"
onChange="mycountry=select_country(this.form,this.options[this.selectedIndex].value)">
>
<option value="uk">UK
<option value="usa">USA
</select>
<SCRIPT LANGUAGE="JavaScript">
function select_country(my_form,my_select_value)
{
var temp=0;
temp=my_select_value;
return temp;
}
</SCRIPT>
-------------------------------------
Also tried
<select name="country" size="1"
onChange="<cfset
mycountry=select_country(this.form,this.options[this.selectedIndex].value)">
>
How to pass this.options[this.selectedIndex].value to
Coldfusion variable before submit?
I want to do this after one option is selected in the
same form:
<cfif mycountry is "uk">
field group 1
<cfelseif mycountry is "usa">
filed group2
</cfif>
Thanks
Ins
__________________________________________________
Do You Yahoo!?
Yahoo! Mail û Free email you can access from anywhere!
http://mail.yahoo.com/
------------------------------
Date: Mon, 14 Aug 2000 10:02:00 +0100
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: CF-Talk V1 #139 (Out of office)
Message-ID: <[EMAIL PROTECTED]>
> Can we say annoying?
OK... "annoying" <snigger>
On this subject though, can someone (Mike if he's available) unsubscribe
this guy
This might sound snotty, but I think we should have a "You'll be
unsubscribed if you send Out Of Office replies to this list" policy - the
quantity of people isn't huge, but it's still annoying
Philip Arnold
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.
**********************************************************************
------------------------------
Date: Mon, 14 Aug 2000 10:32:23 +0100
From: "dan kemp" <[EMAIL PROTECTED]>
To: "cf-talk" <[EMAIL PROTECTED]>
Subject: FORM values doubling when submitted. (When C&P from Word)
Message-ID: <[EMAIL PROTECTED]>
I have a simple form, show below, which is causing me problems. The
users Copy & Paste text from Word into the text area. Sometimes, the
err.. "extended characters" for want of a better word, cause problems.
For example, typing "hello world" into Word changes the double quotes
into nice looking curly one, which look like 66 99. The same for
three periods '...' turn into some funky 3dot character.
When these submit to the next page, they double up...
Here's the form I'm using...
<form action="add_update_news.cfm" method="post" name="newsForm"
enctype="multipart/form-data">
<input type="text" name="headline" value="" size="50" style="width:
393;">
<textarea cols=46 rows=20 name="article" style="width:
393;"></textarea>
<input type="file" name="image1" value="" size="50" style="width:
393;">
<input type="Submit" value="Submit"> <input type="Reset"
value="Reset">
</form>
I enter 'title' into the text box called headline and '"hello world"'
(copy and pasted from Word) into the textarea. On the next page, if I
output the form fields passed to me I get...
#headline# = title,title
#article# = "hello world","hello world"
This is even before I do anything else on the page. Now the weird
part, if I remove the file upload part of the form, everything works
fine.
Anyone come across this problem of copying and pasting from Word, and
what do I do about the funky characters.
Cheers
Dan.
This message is intended only for the use of the person(s) ("the intended
recipient(s)") to whom it is addressed.
It may contain information which is privileged and confidential within the meaning of
the applicable law. If you are not the intended recipient, please contact the sender
as soon as possible.The views expressed in this communication may not necessarily be
the views held by Live Information Systems Limited.
------------------------------
Date: Mon, 14 Aug 2000 11:36:31 +0100
From: "DeVoil, Nick" <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: RE: Select Distinct not so distinct
Message-ID: <FDB52A0429DFD31196FB0008C7D972D50116E7A3@OST_EXCH_USR5>
> I'm trying to select all of the values from a table where type=foo and I
> would like to eliminate duplicates based on name.
>
> EG.
> SQL="select distinct(name), other, field, names from table where type =
foo"
> -this returns every field where type is a match.
> SQL="select distinct(name) from table where type = foo"
> -this works but does not retrieve additional field info.
>
> Am I to understand that select distinct cannot be utilized in this
fashion?
> It works if I select the name field only, but if I want more than the
name
> field it returns all matches. I cannot ask that the database be
restructured.
But if there are n rows sharing the same value in the 'name' column, which
of those rows do you want the query to return??? Or do you want the values
in the other columns aggregated in some way?
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------
End of CF-Talk V1 #140
**********************
------------------------------------------------------------------------------
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.
