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/12/00 06:41 >>>
CF-Talk Sat, 12 Aug 2000 Volume 1 : Number 136
In this issue:
Queries
Re: Announcing: CF_OUTPUTPG - the example file
Re: Announcing: CF_OUTPUTPG - the example file
Re: CFTHROW
RE: Verity vs. Freetext
RE: CFFILE problem on Linux
----------------------------------------------------------------------
Date: Fri, 11 Aug 2000 22:36:39 -0400
From: "Andrew" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Queries
Message-ID: <010501c00406$24f206d0$0100000a@rudebwoy>
This is a multi-part message in MIME format.
------=_NextPart_000_0102_01C003E4.9D6F5580
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
2 Questions.
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?
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?
Andrew Hewitt
Web Application Developer
webworld studios inc.
------=_NextPart_000_0102_01C003E4.9D6F5580
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>2 Questions.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>1. Just curious, is it possible =
to do a query=20
across two different datasources? I have a table in one datasource =
and I=20
would like to do some kind of join query on another table that would =
make things=20
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=20
datasources?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>2. Is it possible to do a query =
on a query=20
result set? I have the results from a CFQUERY but I was wondering =
if one=20
could then do a query using the query results as if it was a table=20
itself?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV>Andrew Hewitt</DIV>
<DIV>Web Application Developer</DIV>
<DIV>webworld studios inc.</DIV>
<DIV> </DIV></FONT></DIV></BODY></HTML>
------=_NextPart_000_0102_01C003E4.9D6F5580--
------------------------------
Date: Fri, 11 Aug 2000 22:42:33 -0400
From: Peter Theobald <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Announcing: CF_OUTPUTPG - the example file
Message-ID: <[EMAIL PROTECTED]>
Sorry - any of you with HTML based email didn't see the source code, you saw the
OUTPUT (kind-of)
Here again is the example file:
<pre>
<!---
// Testpg.cfm
// Peter Theobald 8/10/2000
// [EMAIL PROTECTED]
//
// This file is a simple example of using the CF_OUTPUTPG module
// Make sure outputpg.cfm is in the same directory or in your CustomTags directory
--->
<!---
// replace this with your own favorite query
// make it 3 columns if you want to keep
// all the formatting the same as whats already below.
--->
<cfquery name="q_users" datasource="#MyDSN#">
select UserName, UserType, Email
from Users
</cfquery>
<html><body>
This is a test of custom tag CF_OUTPUTPG.<p>
<cfparam name="url.startrow" default="1">
<table border=1 width=50%><tr><td>User</td><td>Type</td><td>Email</td></tr>
<cf_outputpg query="q_users" startrow="#url.startrow#">
<tr><td>#UserName#</td><td>#UserType#</td><td>#Email#</td></tr>
</cf_outputpg>
</table>
<table border=0 width=50%>
<tr><cfoutput>
<td><a href="testpg.cfm?startrow=#outputpg.prevstart#">PREV PAGE</a></td>
<td align=center>Page #outputpg.thispage# of #outputpg.numpages#</td>
<td align=right><a href="testpg.cfm?startrow=#outputpg.nextstart#">NEXT PAGE</a></td>
</cfoutput></tr></table>
</body></html>
</pre>
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
------------------------------
Date: Fri, 11 Aug 2000 23:12:33 -0400
From: "Phil Labonte" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: Announcing: CF_OUTPUTPG - the example file
Message-ID: <00b301c0040b$29d7be10$f2bb7018@cr716804a>
test
----- Original Message -----
From: "Peter Theobald" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 11, 2000 10:42 PM
Subject: Re: Announcing: CF_OUTPUTPG - the example file
> Sorry - any of you with HTML based email didn't see the source code, you
saw the OUTPUT (kind-of)
>
> Here again is the example file:
>
> <pre>
> <!---
> // Testpg.cfm
> // Peter Theobald 8/10/2000
> // [EMAIL PROTECTED]
> //
> // This file is a simple example of using the CF_OUTPUTPG module
> // Make sure outputpg.cfm is in the same directory or in your CustomTags
directory
> --->
>
> <!---
> // replace this with your own favorite query
> // make it 3 columns if you want to keep
> // all the formatting the same as whats already below.
> --->
> <cfquery name="q_users" datasource="#MyDSN#">
> select UserName, UserType, Email
> from Users
> </cfquery>
>
> <html><body>
>
> This is a test of custom tag CF_OUTPUTPG.<p>
> <cfparam name="url.startrow" default="1">
>
> <table border=1
width=50%><tr><td>User</td><td>Type</td><td>Email</td></tr>
>
> <cf_outputpg query="q_users" startrow="#url.startrow#">
> <tr><td>#UserName#</td><td>#UserType#</td><td>#Email#</td></tr>
> </cf_outputpg>
>
> </table>
>
> <table border=0 width=50%>
> <tr><cfoutput>
> <td><a href="testpg.cfm?startrow=#outputpg.prevstart#">PREV PAGE</a></td>
> <td align=center>Page #outputpg.thispage# of #outputpg.numpages#</td>
> <td align=right><a href="testpg.cfm?startrow=#outputpg.nextstart#">NEXT
PAGE</a></td>
> </cfoutput></tr></table>
> </body></html>
>
> </pre>
>
>
> --------------------------------------------------------------------------
-
> Peter Theobald, Chief Technology Officer
> LiquidStreaming http://www.liquidstreaming.com
> [EMAIL PROTECTED]
> Phone 1.212.545.1232 Fax 1.212.679.8032
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> 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: Sat, 12 Aug 2000 01:26:18 +0000
From: "Gene Kraybill" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: "Miriam Hirschman" <[EMAIL PROTECTED]>
Subject: Re: CFTHROW
Message-ID: <[EMAIL PROTECTED]>
Miriam Hirschman wrote:
> How Do I define my own error in a cfthrow? I would like to say if the error
> is an invalid search criteria then....
Try something like this:
<CFTRY>
<CFIF SearchCriteria IS Invalid>
<CFTHROW TYPE="MyCustomError" MESSAGE="Your Search Criteria are Invalid">
</CFIF>
<CFCATCH TYPE="MyCustomError">
#CFCATCH.Message#
</CFCATCH>
</CFTRY>
Basically the idea is to wrap the CFTHROW in conditional code so that it creates an
error
when certain conditions are met. You then "catch" the error by referring to it with
the
TYPE parameter using CFCATCH, and display the defined error message using
CFCATCH.Message
(and CFCATCH.Detail, if you define that as well).
Gene Kraybill
------------------------------
Date: Sat, 12 Aug 2000 00:14:25 -0700
From: "James" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Verity vs. Freetext
Message-ID: <[EMAIL PROTECTED]>
I would like to try this too. This would certainly be a cheaper alternative
than
Texis. If you don't mind, could you email me the code to use this off list.
James
[EMAIL PROTECTED]
-----Original Message-----
From: Tom [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 11:10 AM
To: [EMAIL PROTECTED]
Subject: Re: Verity vs. Freetext
A product I use for full-text indexing and searching is called textdb
(www.webest.dk)
It's a small and cheap product. It's not as straight-forward to use as
mssql fulltext, but it's furociously quicker than mssql or oracle (and
presumably verity with comparisons of it being slower than sql7).
I have a db with 500,000 records containing descriptions ranging from 5k to
1 meg of data, and ANY search I do is finished within half a second. I can
do a wildcard "a" search, or a very complex conditional query using "sounds
like" operators, and still get my results back in that amount of time. Not
sure if version 4 is out yet, but version 3.whatever didn't support phrases,
the new version does (and is just as quick as before).
Building the full text index also blows away the competition. It's not as
rich in features as teh others, and has a couple other limitations - but raw
speed (both building, updating, and retrieving) blows ms sql and oracle
(context stuff and intermedia) out of the water. I can build an index in
about 20 minutes on multiple fields against the 500k record database - this
is from scratch.
It works as a com object, so you need to use cfobject (which I have sample
code for it) - but this still works very quickly.
Not sure about how it works with thai, but it's very impressive nonetheless.
well, that's my 2 cents.
Tom
----- Original Message -----
From: Paul Hastings <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 10, 2000 12:13 PM
Subject: Re: Verity vs. Freetext
> > Which would be faster - a verity collection, or using SQL 7's Full-text
> > indexing? We are probably talking about well over 20,000 individual
> > records.
>
> i didn't see any answers to this so...from our work sql server 7
> full text indexing beats verity flat out if you have to come back
> to the db for row details. besides the obvious hit of having to
> re-query the db, verity doesn't cache queries, etc. its also a
> shotgun search thru the "body" of your text data which may be
> from several columns & thus hard or impossible to id. on top of
> that verity doesn't work w/thai language ;-)
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> 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/[email protected]/
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: Sat, 12 Aug 2000 00:41:51 -0700
From: "James" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: CFFILE problem on Linux
Message-ID: <[EMAIL PROTECTED]>
Just a thought, make sure that cffile is enabled on the CF Administrator.
If it isn't you won't be able to write to any directory.
-----Original Message-----
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 11:25 AM
To: [EMAIL PROTECTED]
Subject: Re: CFFILE problem on linux
If you have error logs they might give you some idea. For instance, if
there is some other username being used for some reason (not that I know
what reason that would be) you may be able to trace down the username in
the error log. I'm not sure what kinds of logging are available but I know
that you can track that in Solaris. You should be able to track it in Linux
also.
At 03:35 PM 8/7/00 +1000, you wrote:
>Hi there,
>
>I'm trying to get CFFILE working on a linux box. ColdFusion is running as
>a user
>called coldfusion which has group write privileges to my HTML directory. If
I
>log in as the coldfusion user I can create directories and files in the
HTML
>directory OK.
>
>However, when I try to do a <CFFILE ACTION="WRITE"> into that same
directory I
>get a permissions error.
>
>I am not running advanced security.
>
>What is going on?
>
>--------
>Rob Keniger
>
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>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/[email protected]/
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.
------------------------------
End of CF-Talk V1 #136
**********************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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/[email protected]/
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.
