Need a copy of: CFX-CRWTOPDF

2000-06-08 Thread sam komolafe

This is a multi-part message in MIME format.

--=_NextPart_000_01B1_01BFCFD8.F2D564A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi guys,

The CFX-CRWTOPDF print tag is no longer available on Alliare's Tag =
Gallary.
Can any one who has a copy send me a copy of the Tag.

Thanks
sam


--=_NextPart_000_01B1_01BFCFD8.F2D564A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi guys,The CFX-CRWTOPDF print =
tag is no=20
longer available on Alliare's Tag Gallary.Can any one who has a copy =
send me=20
a copy of the Tag.Thankssam

--=_NextPart_000_01B1_01BFCFD8.F2D564A0--

--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: Professional vs. Enterprise

2000-06-08 Thread Peter Tilbrook

No real difference (apart from the price). Enterprise supports clustering,
Professional doesn't.

==
Peter Tilbrook
Internet Applications Developer
Safetyweb Internet Solutions Pty. Ltd.
31-37 Townshend Street
Phillip, ACT, 2606

http://www.safetyweb.com.au
http://www.actcfug.asn.au

Phone: (02) 6285 3644
Facsimile: (02) 6285 4114

-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 7 June 2000 4:42 AM
To: [EMAIL PROTECTED]
Subject: Professional vs. Enterprise


Hi all,

Assuming I'm not clustering, what's the difference between Professional and
Enterprise?

Portent Interactive
http://www.portentinteractive.com
Process, Design, Content


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



RE: What are Snippets?

2000-06-08 Thread Peter Tilbrook

Snippets are useful tidbits of code you write that you can easily access
from the Snippets page. A snippet could be a standard document header (eg:
Meta tags), java scripts or ColdFusion code. If you re-type same code -
considering making it a "snippet".

==
Peter Tilbrook
Internet Applications Developer
Safetyweb Internet Solutions Pty. Ltd.
31-37 Townshend Street
Phillip, ACT, 2606

http://www.safetyweb.com.au
http://www.actcfug.asn.au

Phone: (02) 6285 3644
Facsimile: (02) 6285 4114

-Original Message-
From: jonathan hamner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 June 2000 3:44 AM
To: [EMAIL PROTECTED]
Subject: What are Snippets?


Can someone tell me what are snippets, when are they
used?
I am a new CF user. Please help!
Thanks

__
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com

--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



RE: Best Method

2000-06-08 Thread Duane Boudreau

If you are using SQL Server you can use the top command

select top 5 myfield1, myfield2, ...
from mytable
order by ?? DESC

Duane Boudreau
CFExperts.Com


> -Original Message-
> From: Jeffrey Cohen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 06, 2000 10:36 AM
> To: House OfFusion
> Subject: Best Method
>
>
> Greetings...
>
> What is the best method for reading ONLY the last  five records in a
> database for display?
>
> I have a client that adds articles daily to a news database, and then
> displays them on a news page. There are hundreds of articles, and on his
> home page he just wants to display the 5 most recent. (which would be
> the last five in the database, I presume)
>
> Suggetstions???
>
> and thanks as always for your help in advance...
>
> Jeffrey Cohen
> ImageWorks
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.



Off The Subject... SQL Question

2000-06-08 Thread Dan Blickensderfer

Sorry for this question that doesn't pertain to the CF Talk List.

I have a NT4.0 Box w/SQL 6.5 Server with Dual PII 650's / 512MB Ram.  256MB
set aside for SQL.

I have a table in one of my Datasources that has apprx 5 million records.
I'm trying to think of the best way to purge the records and just keep the
last 90 days.

I was going to do something like the following in the SQL Query Manager

set rowcount 5000
declare @rows int
select @rows = 5000
while @rows = 5000
begin
delete from calls where date < "3/6/2000"
end

I know this will take a while, I just don't want the transaction log to run
out of room compared to just deleting all records at one time.

Any suggestions?

Thanks,
Dan

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Off The Subject... SQL Question

2000-06-08 Thread Dan Blickensderfer

Sorry for this question that doesn't pertain to the CF Talk List.

I have a NT4.0 Box w/SQL 6.5 Server with Dual PII 650's / 512MB Ram.  256MB
set aside for SQL.

I have a table in one of my Datasources that has apprx 5 million records.
I'm trying to think of the best way to purge the records and just keep the
last 90 days.

I was going to do something like the following in the SQL Query Manager

set rowcount 5000
declare @rows int
select @rows = 5000
while @rows = 5000
begin
delete from calls where date < "3/6/2000"
end

I know this will take a while, I just don't want the transaction log to run
out of room compared to just deleting all records at one time.

Any suggestions?

Thanks,
Dan


--
Archives: http://www.eGroups.com/list/cf-talk
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.



Re: Ultradev

2000-06-08 Thread Ron Connelly

I haven't used it, but am thinking about getting Dreamweaver, and 
also wondering about Ultradev.  I, also, would be interested in any 
comments here.

On 6 Jun 00, at 14:33, you wrote:


> Anybody used it?
> 
> Anybody think its better than a Studio/Dreamweaver 3 combination?
> 
> 
> Adam Reynolds
> ColdFusion Consultant
> HJ Heinz
> Tel: 01344 397016  Fax: 01344 397010
> Mobile: 07973 386620
> Email: [EMAIL PROTECTED]
> 
> **
>  This email and any attachments are confidential and solely
>  for the use of the intended recipient.  They may contain
>  material protected by legal professional or other privilege.
>  If you are not the intended recipient or the person responsible
>  for delivering to the intended recipient, you are not authorised to
>  and must not disclose, copy, distribute or retain this email or its
>  attachments.  Although this email and its attachments are believed to
>  be free of any virus or other defect, it is the responsibility of the
>  recipient to ensure that they are virus free and no responsibility is
>  accepted by the company for any loss or damage arising from receipt
>  or use thereof.
> 
> **
> --
>  Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe
> visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
> k or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
> 


--

Ron Connelly,
The Internet:Works
4603 Palm Drive
La Canada, CA  91011

TEL: 818.952.9554
FAX: 818.952.9664
MOBILE & PAGER: 818.371.1110
MOBILE MESSAGING: [EMAIL PROTECTED], 150 char. max.

[EMAIL PROTECTED]
http://www.the-networks.com
--
Archives: http://www.eGroups.com/list/cf-talk
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.



Help with single quotes

2000-06-08 Thread Cyrill Vatomsky

Or maybe it is something else...

I have a list of cities in a form with multiple enabled. Selected list is
submitted (as form.by_city) to a template with the following query:


 SELECT ID, sale_price,Address, City
 FROM properties
 WHERE City IN ('#PreserveSingleQuotes(form.by_city)#')


If only one city is selected in the form, the processing template works
fine, displaying all properties  for a selected city.

But if two or three are selected, then nothing is displayed, i.e. query does
not retreive any records.

If I remove single quotes around ##, I get "Invalid Number of Parameters,
Expected 1"

I have similar queries  that work OK with IDs in the same way:

WHERE ID IN (#PreserveSingleQuotes(form.by_type)#)

//by_type is a list genetrated by a multiple  where values are
integers. In the City example above,  values are, naturally,
strings.



Thanks,

Cyrill Vatomsky
Linguacom

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Re: Unlimited traffic as a CF-Provider ?

2000-06-08 Thread Jennifer

At 10:54 AM 6/5/00 +0200, you wrote:
>Does someone know a ColdFusion Provider with unlimited Web-Traffic per month
>?

media3 has some accounts like that. go to media3.com

--
Archives: http://www.eGroups.com/list/cf-talk
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.



CF 4.5.1 on Solaris - server restarts

2000-06-08 Thread Benji Spencer

hello

I didn't see anything on this top in the archivesit would be nice if I 
could get some help though.

We are running Cold Fusion 4.5.1 (just installed the upgrade last week, 
from CF 4.0) on a Solaris machine (plenty of memory, not over worked, not 
real busy). For some reason, the CF server (cfserver) is dumping 
core/restarting very often. the span of time between these can range from 
30 seconds, to about 60 mins (with the longer times being at night). the 
log files point to no errors, they just say that the Application server has 
restarted.

has anyone run into this problem, or has idea of where I should look to fix 
this? I have played with the "settings", "caching",and "variables", but 
nothing has made a difference, or affected the times.

the 4.0 server dumped core from time to time, (daily), but wasn't near this 
bad. When the server dumps core, the cfm pages are unavailable for a few 
seconds.

benji

---
Benji Spencer
Web Programmer
Moody Bible Institute
312-329-2288

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Re: .....CF on Linux 6.2 , got a clue?

2000-06-08 Thread Benji Spencer


>We have decided to run CF 4.5 on Linux 6.2 . And using Mysql as the
>backend database.
>This project is going to be test run soon.
>Anyone has a clue as to what I'm to expect ??? cause I sure as hell don't !

you shouldn't have much trouble. you will need to probably get MyODBC and 
convince CF to use it (ftp://ftp.igc.apc.org/pub/myodbc/README)

I would have verified that they didn't include the drive on our Linux 
system, but as I only have the evaluation version there, it has expired :/ 
we are running CF and MySQL on Solaris though as our main server.

benji


---
Ben Spencer
Web Support
[EMAIL PROTECTED]
x 2288
--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: CF 4.0 and Win2000

2000-06-08 Thread Smad


Try installing CF 4.5. I've had the same problems with 4.0 but after I
upgraded to 4.5 everything seems to work fine (except for a few weird
failures, nothing serious). My box: Win2000, PIII 500, 128MB.

-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 05, 2000 4:46 PM
To: CF-Talk
Subject: CF 4.0 and Win2000


OK - I know that CF 4.0 is not certified for Win2000.  But, I just want to
use it on a development box with Win2K and IIS for about
a month - just the single user version off of CFStudio 4.0.  It seemed to
load fine, but when I start the server, it loads - then
after about 3 or 4 seconds, it dies (shuts down).  I watch this in my Task
Manager in Win2000.  Any clues as to what is happening?
Can I make this work or must I install 4.5 to run on Win2000?

Thanks,
Dave


=
"What we need is a list of specific unknown problems we will encounter"

David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524





--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



SQL Stored Proc Question

2000-06-08 Thread Nick Slay

Hi,

Just wondering if anyone can help with a SQL Server 7 Stored Procedure 
question.

I have a stored procedure that returns a group of fields from a table. What 
I'd like to do is return a field which is the result of another stored 
procedure that does something to one of the fields from the table For 
Example

Select TheId,
TheDate,
NewConvertedDate = (Execute storedprocedure TheTable.TheDate)
FROM TheTable

I know that I can nest stored procedures in other stored procs, however, I 
can't seem to find the right syntax (if it's possible) to return the result 
of a stored procedure as another field in the same select.

Is this possible? Can anyone help with the syntax?

Thanks

Nick 

--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: Dynamic CFPARAM Statements

2000-06-08 Thread Kevin Langevin

> -Original Message-
> From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 05, 2000 1:41 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Dynamic CFPARAM Statements
>
> misspelled and didn't notice.  I need to take start taking weekends off.

Slacker! ;)

Seriously, I CONSTANTLY do that...and forget to put the NAME= in a CFPARAM
statement as well.

-Kev

--
Archives: http://www.eGroups.com/list/cf-talk
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.



ot: test

2000-06-08 Thread Len Conrad

test

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Re: Can CF generate a Pop-up Window w/o Javascript?????

2000-06-08 Thread Jann at Studio303

If you're in a pure windows environment, maybe yes with ActiveX

In a pure web way -- no.  That IS what JavaScript is for.

on 6/5/00 6:21 AM, Richard Fascianella at [EMAIL PROTECTED] wrote:

> Hello,
> 
> I joined this list with the hope someone can help me with an issue I am
> having.
> 
> I need to find out if CF can be used to generate a pop-up browser window
> WITHOUT the use of javascript.
> 
> What I am trying to do is validate a form, and have a pop-up box appear when
> a field is not filled out, or when a field is a duplicate (using SQL to
> check for dupes), informing the user of such. However, I am NOT able to use
> javascript to generate the actual pop-up box. Will Cold Fusion be able to
> gereate that pop-up box
> 
> Im not a programmer, so please phrase your answers accordingly :)
> 
> Thank you!
> 
> Richard
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> 
> --
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.



RE: CF pages coming up as text

2000-06-08 Thread Kevin Langevin

If you reinstalled IIS, then you likely have to reinstall CF Server.  I've
always had to in that situation.

-Kev

> -Original Message-
> From: Caulfield, Michael [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 02, 2000 11:16 AM
> To: Cf-Talk (E-mail)
> Subject: CF pages coming up as text
>
>
> We just had to reinstall MS IIS, and now our CF pages are coming
> up as text.
> Any ideas? Happy to send more information.
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.



CFContent Confusion

2000-06-08 Thread Ken Wilson

I need some help to save what's left of my greying hair...

Server Setup is:
CF Server v4.5.1 Professional
NT4/IIS
Developing against Access2000

I'm serving out several PDF files and in order to provide some basic
security I'm using CFCONTENT to deliver the files only to those logged in
with an active session. I've got a securedoc.cfm page that contains nothing
but the following:



The document link passes what document is being requested. No problem so
far, works great. But then I decide I want to provide some basic info on who
is viewing the documents so I decide to insert a record into the database
with each request in order to log UserID, DocumentID and Date/Time. Now the
securedoc.cfm page looks like this:


  INSERT INTO DocViewLog
  (UserID, DocName, DocHitDate)
  VALUES  (#Session.UserID#, '#Url.Doc#', #CreateODBCDateTime(Now())#)




Documents are still delivered without fail but I'm getting *three* database
records for each request with each record created roughly 1 second apart. In
order to try and isolate the problem I've changed the path to the documents
to a bogus value so as to generate an error. When I do this I get only *one*
DB record and, of course, a server error saying the document can't be found.

Unless I'm missing something obvious it looks like the server is looping
back through the securedoc.cfm page three times with each request and I'm
not sure why. Any ideas? Or am I using CFCONTENT improperly?

Any ideas would be appreciated.

Ken Wilson



--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: CFUG in CT

2000-06-08 Thread Kevin Langevin

There's one just starting up in Providence, from what I understand.  There's
info on the CFUG page on the Allaire site.

-Kev

> -Original Message-
> From: Jay Sudowski [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 05, 2000 1:45 AM
> To: [EMAIL PROTECTED]
> Subject: CFUG in CT
>
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_01C0_01BFCE8F.AEF2DBE0
> Content-Type: text/plain;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hey Folks -
>
> I know there's supposedly a CFUG in Westport, CT, but that's somewhat of =
> a drive for me.  Does anyone know of a CFUG located in Eastern CT / =
> Providence, RI?
>
> Thanks,
>
> Jay
>
> --=_NextPart_000_01C0_01BFCE8F.AEF2DBE0
> Content-Type: text/html;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> Hey Folks -
>  
> I know there's supposedly a CFUG in =
> Westport, CT,=20
> but that's somewhat of a drive for me.  Does anyone know of a CFUG =
> located=20
> in Eastern CT / Providence, RI?
>  
> Thanks,
>  
> Jay
>
> --=_NextPart_000_01C0_01BFCE8F.AEF2DBE0--
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



RE: Another question on performance

2000-06-08 Thread Kevin Langevin

Yup...from what I understand, this is an area that they're working on
improving for the next version of ColdFusion.

-Kev

> -Original Message-
> From: Won Lee [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 02, 2000 11:15 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Another question on performance
>
>
> Incorrect -
> Arrays are faster by a factor of about 4.  Structures are really slow.
>
> >If the "extra fields" are computed from other fields in the SQL query
> >and/or external data (known at the time of the query), you might
> >consider computing these fields as part of the SQL query itself...
> >using scalar functions or T/SQL statements (SQL Server).
> >
> > From what I have heard/read/experienced, the SQL engine can probably
> >do this a lot more efficiently that any CF routines you could write.
> >
> >Dick
> >
> >
> >At 10:10 AM +1000 6/1/2000, Nick Slay wrote:
> >>ok... so when it comes to performance, it's better to use
> strutctures than
> >>arrays and both of those are better than lists.  But what about
> >>queries?   Queries that are generated using QueryNew as opposed to SQL
> >>statements.
> >>
> >>I have a SQL Query result set that I need to loop through, calculate a
> >>bunch of extra fields, and then store that off for looping
> through later.
> >>
> >>At the moment I create a new query, take the fields I want from the SQL
> >>result set, and add them, plus the new fields into a new query.
>   There are
> >>probably more efficient ways of doing this...
> >>
> >>Does anyone know whether creating another query, and looping through it
> >>later is going to be better or worse than creating an array of
> structures
> >>and looping through those instead?   For that matter would I be
> better to
> >>add a column to the query that I got from SQL Server, and then
> loop through
> >>that again?
> >>
> >>Thanks for any feedback!
> >-
> -
> >Archives: http://www.eGroups.com/list/cf-talk
> >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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



RE: CF Training?

2000-06-08 Thread Kevin Langevin

Dude!  I'll got get certified if you can bring me over before the Olympics!
:)

Just kidding...

-Kev

> -Original Message-
> From: Nick Slay [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 05, 2000 12:55 AM
> To: [EMAIL PROTECTED]
> Subject: RE: CF Training?
>
>
> Sorry.. I missed the original posting so don't know where you are
> based...
> but if you're in Australia then drop me a line!!   We're looking for
> someone to can train in CF!!
>
>
>
>
> At 21:43 4/06/00 -0700, you wrote:
> >Sharon,
> >
> >Truer words were never spoken!.. As a company that has recently been very
> >agressive in hiring CF folke, I can tell you that a URL is worth
> a thousand
> >words. High school dropout? No problem. If you've got the "stuff", then
> >companies like ours overlook that kinda stuff.. :)
> >
> >Gregory
> >
> >---
> >annex.com, Inc. - http://www.annex.com/
> >---
> >- If you EcoBuild it, they will come. -
> >- http://www.ecobuilder.com/ -
> >---
> >
> >
> > > -Original Message-
> > > From: Sharon DiOrio [mailto:[EMAIL PROTECTED]]
> > > Sent: Sunday, June 04, 2000 6:38 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: CF Training?
> > >
> > >
> > > My recommendation to anyone wanting to get more into CF is to find a
> > > company that specializes in it.  It's the only way you'll get
> > > to see what
> > > CF is really capable of.  Most corporations don't use 1/10th of the CF
> > > power available to them.  I believe that in order to get
> > > really good with
> > > the software, you'll need to be challenged by people wanting
> > > more than you
> > > can deliver, and surrounded by people who can show you how
> > > it's done.  I
> > > won't say that you can't get good learning by yourself, but
> > > it takes a lot
> > > more effort on your part.
> > >
> > > Check out the Allaire Partners on the allaire website.  I'm
> > > sure there is
> > > one near you.  When you interview, tell them exactly what
> > > you're looking
> > > for: an opportunity to become a CF guru.  Most of them will
> > > be thrilled to
> > > talk to you.  And these days, having URLs means a lot more
> > > than a degree.
> > >
> > > If actually changing jobs isn't an option now, then join your
> > > nearest CFUG.
> > >  Network your hiney off and find a couple of "coding
> > > partners" who would be
> > > willing to share ideas, code, and provide a CF sounding board.
> > >
> > > Sharon
> >-
> -
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/c
f_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.


===
Nick Slay
Technical Director

Webbods Pty Ltd  (ACN 086 160 189)
PO Box 4047
Copacabana
NSW 2251

Tel:02 4381 0284
Mob:0414 810284

===
Join the BodNews mailing list for News/Announcements
and Offers from Webbods.  Send an email to
[EMAIL PROTECTED] with 'subscribe bodnews' in the
subject line.
===

Proud Sponsors of the Northern Eagles NRL Side 2000!!!


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



Re: What are Snippets?

2000-06-08 Thread mr_0rga5m

Hi

A 'snippet' isnt a particular object .. its just a term used for a (small)
piece of code.

ie: you cut out a piece of code .. the result is a snippet of the code.

Cya :)

- Original Message -
From: "jonathan hamner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 07, 2000 6:43 PM
Subject: What are Snippets?


| Can someone tell me what are snippets, when are they
| used?
| I am a new CF user. Please help!
| Thanks
|
| __
| Do You Yahoo!?
| Yahoo! Photos -- now, 100 FREE prints!
| http://photos.yahoo.com
| --

| Archives: http://www.eGroups.com/list/cf-talk
| 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.eGroups.com/list/cf-talk
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.



Re: studio errors

2000-06-08 Thread Michael Kear

This happens to me too.  Allaire haven't shown the slightest interest in
helping me with it either, no matter how I report it.

Basically, I think they've created something and don't have a clue how to
make it work.  It costs more than A$1000.  I also bought a 2 year
subscription and after 3 months I haven't been able to make it produce a
single template.  I'm still using the old version.  For such an expensive
package, it doesnt do even the most basic things properly, and isn't up to
the standard of a year 1 programmer's effort.

THe only suggestion I've been able to squeeze out of their support is that
there's a bug in the deployment wizard and you have to make sure you
upload the entire project not the changed files.

Big deal.  IT still won't install properly and it still gives those
exception errors.

I believe it fails the test under the Sale of Goods ACt that it be of
merchantable quality, and therefore I have an action against them in the
courts.  If there's no sign of interest by Allaire or their distributor,
Firmware eDesign soon, I'm going to be taking them to court over it.

My advice is, don't touch Studio 4.5.1 with a barge pole unless you don't
mind never using for anything other than a text editor.

Pity, cos the demo (obviously a big fraud because it worked) looked pretty
good.

If I ever hear of a fix for my problems, I'll be sure to let you all know.

Cheers,
AFP Web Development
Windsor, NSW< Australia 
http://www.afp.zip.com.au



On Sun, 4 Jun 2000, Greg Saunders wrote:

> I'm running Studio 4.5.1, and seeing lots of exception errors.  I reboot my
> machine, start Studio, and then quit, and I get:
> 
> Application Error:  Exception EAccessViolation in module 
> cfstudio45.exe at address 004F9614 in module 'cfstudio45.exe'.  
> Read of address 01ADC064.
> 
> This happens repeatedly when I quit.  It did not happen when I first
> installed 4.5, but it seems suddenly frequent, and I'm not sure what changed.
> 
> Also, occasionally when I save a file, the file is saved, but the file tab
> still shows the file as unsaved, and I occasionally also get exception
> errors while editing.
> 
> Any ideas what would cause this?  Should I reinstall?  Originally I was
> running 4.0, then I installed a 4.5 upgrade, and finally I installed the
> 4.5.1 upgrade.  If I reinstall, do I need to follow these steps again, or
> is the 4.5.1 upgrade a complete version?
> 
> Gregory M. Saunders, Ph.D.
> Senior Design Architect
> Cognitive Arts Corporation  (http://www.cognitivearts.com)
> 1840 Oak Avenue, 4th Floor
> Evanston, IL 60201-5914
> 
> --
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.



Reading in PDF Files

2000-06-08 Thread James Taavon

How do I read in a PDF file into my browser? 

Let me explain. I have a list of numbers associated with documents in a
database. Each document has four different links associated with it
(Summary of Document, Original Document, Reponses, History). What I want
to do is when a user clicks "Original Document" is to have the scanned
PDF file of the document appear in the browser window. I tried using
, but that only works with text files.

Have any ideas on how I could do this?

James
--
Archives: http://www.eGroups.com/list/cf-talk
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.



Re: CFMAIL Alternatives

2000-06-08 Thread Justin MacCarthy

Hi Sean,

Look at iMS server from www.coolfusion.com
It's cheap, if you just want the 'post' server.
Otherwise,there is a COM on serverobjects.com for sending mail.I haven't
used this though...


~Justin MacCarthy

- Original Message -
From: Sean Daniels <[EMAIL PROTECTED]>
To: Cf-Talk@Houseoffusion. Com <[EMAIL PROTECTED]>
Sent: Monday, June 05, 2000 7:00 PM
Subject: CFMAIL Alternatives


> Hello all,
>
> I am lookig for an alternate solution to cfmail that will allow my site to
> send larger quantities of email more efficiently. For example, a
newsletter
> to all of our customers will go out to about 12,000 people. This currently
> takes CFMAIL a hell of a long time to send out - like about 5-6 hours.
>
> Does anyone have any experience with alternatives? I remember a discussion
a
> while back about a product that was an intergrated SMTP server and CF tag.
> Could someone point me in the right direction and give me some stats on
that
> (like emails per minute?)
>
> TIA
>
>
> - Sean
>
> 
> Sean Daniels
> Manager, Engineering
> Marketplace Technologies
> [EMAIL PROTECTED]
> http://www.dealstream.com
> http://www.mergernetwork.com
> 
> tel: 207.439.6030
> cel: 978.764.0779
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.



Re: Slightly OT

2000-06-08 Thread David L. Rice

Actually, Nick wrote the first version of Homesite in Delphi quite sometime
"before" CFStudio was written to maintain his web-based comic strip.
Homesite was our editor of choice back in the days when we used
Delphi/WebHub and were waiting on CF to mature--for the trivia buffs out
there.

WYSIWYG is highly overrated. However, I would probably go with Dreamweaver
because of it's integration with CF if I just had to choose a "close to
WYSIWIG" editor.

p.s. Hope you don't mind me giving away your alter-ego, Nick... ;)

Cheers,
--
David L. Rice
Sr. Web Applications Developer
[EMAIL PROTECTED]
24/7 cellular: 770.354.5953
eFAX: 240.526.7190
-

- Original Message -
From: "Roberts, Jesse D" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 01, 2000 3:31 PM
Subject: RE: Slightly OT


> Yeah.  Homesite is basically ColdFusion repackaged.  It has a few
different
> features, but it is NOT wysiwyg.  If you're looking for simple editor
> besides FrontPage, you could of course use either the Composer part of
> Netscape, or Front Page express.  If you don't like that option, what's
> wrong with either PageMill or DreamWeaver.  I guess it just depends on the
> level of the user which of these are considered easy or not.
>
> Jesse D. Roberts
> Business Process Analyst
> Procurement Quality Assurance
> Boeing - Huntington Beach, CA
>
>
> > -Original Message-
> > From: Jeffrey Cohen [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, June 01, 2000 9:08 AM
> > To: House OfFusion
> > Subject: Slightly OT
> >
> > Does anyone have experience with homesite?
> >
> > I need to recommend a SIMPLE wysiwyg editor to a customer of mine. Is
> > Homesite Wysywyg or an HTML editor?, and if it's html, can anyone
> > recommend a simple wys...editor BESIDES front page?
> >
> > Thanks,
> >
> > Jeffrey Cohen
> > ImageWorks
> >
>
> --
> > 
> > Archives: http://www.eGroups.com/list/cf-talk
> > 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.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.



Re: CFHTTP & IP checks

2000-06-08 Thread Stephen Garrett

[hit send too soon]

Of course, you could install CFPRO on the workstation you use (assuming
you installed CFSTUDIO there) and then use your own LOCAL machine. Then
your IP should be ok...

Steve

At 10:38 AM 6/5/2000 +, [EMAIL PROTECTED] wrote:
>I'm experimenting with the use of CFHTTP and CFHTTPPARAMS to log in to a
large, 
>unaffiliated web site I frequently use and which requires username/password. 
>
>It appears the other site uses an IP check of some kind, because it throws
a vague error 
>message that reports what my IP no. is (and blocks access).  No doubt
they've instituted 
>this IP checking for security reasons. 
>
>Without breaching the bounds of ethics, I'm wondering if there's any
workaround...
>
>Gene Kraybill
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>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.
>

--
Stephen Garrett
GPS
[EMAIL PROTECTED]   (360) 896-2714
ICQ# 10776767
--
Archives: http://www.eGroups.com/list/cf-talk
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.



Fw: CFX-CRWTOPDF TAG

2000-06-08 Thread sam komolafe


- Original Message -
From: "sam komolafe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 05, 2000 9:11 AM
Subject: CFX-CRWTOPDF TAG


> Hi guys,
>
> The CFX-CRWTOPDF print tag is no longer available on Alliare's Tag
Gallary.
> Can any one who has a copy send me a copy of the Tag.
>
> Thanks
> sam
> [EMAIL PROTECTED]
>
>

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Weird

2000-06-08 Thread Ben Densmore

This is a multi-part message in MIME format.

--=_NextPart_000_0095_01BFCFD8.57E3DDA0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I posted a message last week about cookies and IE and Netscape. It looks =
like this message keeps being resent a couple times a day. is there =
something going on with the mail server for this list?

Thanks
Ben Densmore
Webmaster
eSupport.com, Inc
TouchStone Software Corp.


--=_NextPart_000_0095_01BFCFD8.57E3DDA0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable








I posted a message last week about =
cookies and IE=20
and Netscape. It looks like this message keeps being resent a couple =
times a=20
day. is there something going on with the mail server for this=20
list?
 
Thanks
Ben =
DensmoreWebmastereSupport.com,=20
IncTouchStone Software Corp.

--=_NextPart_000_0095_01BFCFD8.57E3DDA0--

--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: Can CF generate a Pop-up Window w/o Javascript?????

2000-06-08 Thread Roberts, Jesse D

No can do.  In order to get the pop-up window, you need a Server-side
language of which JavaScript is probably the best for your purposes.
ColdFusion is a server-side technology meaning that all of it's code is
executed on the server before a page is sent to a user.  Because of this,
ColdFusion has no dynamic capability on the user's computer (meaning it
can't dynamically validate form fields, etc.)  HOWEVER, don't lose heart.
If you just don't want to write the JavaScript, ColdFusion can do that for
you to facilitate form validation.  All you need to do is either use CFFORM
elements or embedded HTML form validation.  The latter is pretty simple.
All you do is create a hidden input field corresponding to each INPUT field.
The names for these hidden fields are then appended with validation rule
suffixes.  Here's an example:

If I want to require a text field is completed is first create that text
field:


Then, I create a hidden form field with the appropriate validation rule
suffix:

Here, the VALUE parameter specifies the error message displayed if the rule
is violated.  Other validation rule suffixes are:

_integer
_range
_time
_date
_eurodate
_float

This will cause CF to generate appropriate JavaScript code to do the
validation.  If you want more information on this, get Ben Forta's first
book.

Jesse D. Roberts
Business Process Analyst
Procurement Quality Assurance
Boeing - Huntington Beach, CA
[EMAIL PROTECTED]
Ph. 714-896-3462
Fx. 714-896-3303

> -Original Message-
> From: Richard Fascianella [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, June 05, 2000 6:21 AM
> To:   [EMAIL PROTECTED]
> Subject:  Can CF generate a Pop-up Window w/o Javascript?
> 
> Hello,
> 
> I joined this list with the hope someone can help me with an issue I am 
> having.
> 
> I need to find out if CF can be used to generate a pop-up browser window 
> WITHOUT the use of javascript.
> 
> What I am trying to do is validate a form, and have a pop-up box appear
> when 
> a field is not filled out, or when a field is a duplicate (using SQL to 
> check for dupes), informing the user of such. However, I am NOT able to
> use 
> javascript to generate the actual pop-up box. Will Cold Fusion be able to 
> gereate that pop-up box
> 
> Im not a programmer, so please phrase your answers accordingly :)
> 
> Thank you!
> 
> Richard
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.



RE: Another question on performance

2000-06-08 Thread Dave Watts

> > > ok... so when it comes to performance, it's better to use
> > > strutctures than arrays and both of those are better than
> > > lists. But what about queries? Queries that are generated
> > > using QueryNew as opposed to SQL statements.
...
> > Incorrect -
> > Arrays are faster by a factor of about 4.  Structures are
> > really slow.
...
> I can't say I've ever compared them, however, the information
> was something that came from a Performance Tips session by Ben
> Forta at a recent developer conference. Structures, Arrays and
> Lists, in that order.

This thread is analogous to asking "which is faster: cars, aircraft or
boats?" The answer, of course, depends on where you're going. Structures,
arrays, lists, and queries, while similar, are intended to be used in
different situations. As long as you use each where appropriate, you're
making the best choice.

Arrays are faster than Structures, unless you're using the Structure to
contain key-value pairs and pull them out at will - which is what Structures
are for. Arrays are faster than lists, unless you're using a string to build
your list in the first place; if you have to convert the string/list to an
array, you'll end up paying the list speed penalty anyway!

If you want to simply contain a bunch of undifferentiated values, use a
one-dimensional Array. If you want to build a variable which contains other
variables, use a Structure. Lists, of course, occur naturally, and if you
want to treat a string as a list, feel free to do so. If you want to use a
Query instead of a two-dimensional Array, again, feel free - even if it's a
bit slower than a two-dimensional Array, you'll probably make up the
difference by being able to use all the tags that support a QUERY attribute.

In any case, if you're concerned about performance, there are places that
are far better to examine, such as your database queries. Have you run
SHOWPLAN with them (if you're using SQL Server, for instance)? Are you
testing your stored procedure performance? Are you updating DB statistics?
You'll get a much better return on investment looking at your SQL, from a
performance perspective.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: studio errors

2000-06-08 Thread Dave Watts

> Actually, it's not a RAM hog, but a Resource hog - since
> Win95/98 and NT have a limited amount of resources (64Kb
> I think), Studio 4.5 eats this up, and doesn't release it
> properly.

It's a while since I've read up on Win32 programming, but I think that NT
isn't subject to resource or stack limits as 95/98 are.

And as for it not being a RAM hog, I think 15-20 Mb for a text editor might
be a bit hefty - it's not like a typical IDE with a compiler, but then it
doesn't need to compile anything!

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: Macromedia Ultradev

2000-06-08 Thread Dave Watts

> I just received a 'special' offer from Macromedia to purchase
> Ultradev for £199.00 ex VAT. I currently use a combination of
> Dreamweaver 3 and CF Studio 4.5 and am contemplating whether
> to go for this offer.
>
> It appears that Ultradev effectively combines the above two.
> Is this a good anology? Anybody used Ultradev and then reverted
> back to Studio? Is the help as good?

Unless you don't mind using Notepad, you'll want to keep Studio around.
Ultradev, whether you like it a lot or not, is no replacement for a text
editor. Ultradev doesn't provide CF-specific help, either; the help is
focused on Ultradev specifically.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Re: Best Method

2000-06-08 Thread Tom Nunamaker

Specify a maxrows attribute in your CFQUERY call and sort by date
descending:


  SELECT 
  FROM ..
  WHERE ..
  ORDER BY submittedDateTime DESC



Tom Nunamaker



Jeffrey Cohen wrote:
> 
> Greetings...
> 
> What is the best method for reading ONLY the last  five records in a
> database for display?
> 
> I have a client that adds articles daily to a news database, and then
> displays them on a news page. There are hundreds of articles, and on his
> home page he just wants to display the 5 most recent. (which would be
> the last five in the database, I presume)
> 
> Suggetstions???
> 
> and thanks as always for your help in advance...
> 
> Jeffrey Cohen
> ImageWorks
> 
> --
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.



RE: Ultradev

2000-06-08 Thread Paul Ihrig

i just bought it & cant wait!
should get my lic for it today!

seems to be a perfect sollution for the graphic side on my noodle,
while i still peck away at learnning CF.

-paul

> -Original Message-
> From: Reynolds, Adam [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 06, 2000 9:33 AM
> To:   '[EMAIL PROTECTED]'
> Subject:  Ultradev
> 
> Anybody used it?
> 
> Anybody think its better than a Studio/Dreamweaver 3 combination?
> 
> 
> Adam Reynolds
> ColdFusion Consultant
> HJ Heinz
> Tel: 01344 397016  Fax: 01344 397010
> Mobile: 07973 386620
> Email: [EMAIL PROTECTED]
> 
> **
>  This email and any attachments are confidential and solely
>  for the use of the intended recipient.  They may contain
>  material protected by legal professional or other privilege.
>  If you are not the intended recipient or the person responsible
>  for delivering to the intended recipient, you are not authorised
>  to and must not disclose, copy, distribute or retain this email
>  or its attachments.  Although this email and its attachments
>  are believed to be free of any virus or other defect, it is the
>  responsibility of the recipient to ensure that they are virus free
>  and no responsibility is accepted by the company for any
>  loss or damage arising from receipt or use thereof.
> 
> **
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.



RE: Download Question Using CFINCLUDE and Java Applets

2000-06-08 Thread Dave Watts

> I have a java applet menu that I want to use in a nested
> table. If the applet is called from a CFINCLUDE tag will
> it still take a long time to download?

Whether you call it from CFINCLUDE or not, it'll take the same amount of
time to download. CFINCLUDE executes on the server, like other CFML tags.

> If it does, is there a better way to use this without using
> frames on the page.

If you want the Java applet menu to remain persistent, and you also want to
display content when a user clicks on a menu item, your best bet is to use a
frame for the applet, and another frame for the content.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: studio errors

2000-06-08 Thread Jeff Shepler

The problem is studio is super resource hungry. It will eat up anywhere from
20% to 50% of your User/GDI resources. 4.01 would eat from 10% to 35%. I
don't know what they added in 4.5(.1) to eat up more, but I was hoping to
get it reduced instead of increased.

You can see this yourself. Before running studio, right-click My Computer
and go to the Performance tab. Make a note of the percentage of free
resources you have. Close the window and start studio. Minimize it and check
the free resources again. Once it gets below 5%, the weirdness begins. It
doesn't matter how much memory you have nor the size of your swap file.

-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 04, 2000 2:36 PM
To: [EMAIL PROTECTED]
Subject: Re: studio errors


I run inot the same problem all the time, alot of times I end up just using
CF Studio 4.0.1   it seems to be alot more stable than 4.5.1, I haven't
tried reinstalling mine yet. i'm not positive but I think 4.5.1 might just
be an upgrade
Ben
- Original Message -
From: William J Wheatley <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 2:27 PM
Subject: Re: studio errors


> yes i get the same crap with mine and its only when i have DW3 open =0) so
> hopefully they'll come out with a fix cause its an annoying problem
> - Original Message -
> From: "paul smith" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, June 04, 2000 9:16 AM
> Subject: Re: studio errors
>
>
> > These happen to me, too.  But only occasionally.
> > The good news is that 4.5.1 doesn't appear to be
> > zeroing out templates.
> >
> > In addition, I get a phony "Someone else has
> > modified the file" (or some such) when I'm the
> > only one here doing it.
> >
> > It's annoying to worrying as to if Studio is
> > going to explode and wipe my hard drive or
> > something;-)
> >
> > Don't know the fixes.
> >
> > best,  paul
> >
> > At 06:34 AM 6/4/00 -0500, you wrote:
> > >I'm running Studio 4.5.1, and seeing lots of exception errors.  I
reboot
> my
> > >machine, start Studio, and then quit, and I get:
> > >
> > > Application Error:  Exception EAccessViolation in module
> > > cfstudio45.exe at address 004F9614 in module 'cfstudio45.exe'.
> > > Read of address 01ADC064.
> > >
> > >This happens repeatedly when I quit.  It did not happen when I first
> > >installed 4.5, but it seems suddenly frequent, and I'm not sure what
> changed.
> > >
> > >Also, occasionally when I save a file, the file is saved, but the file
> tab
> > >still shows the file as unsaved, and I occasionally also get exception
> > >errors while editing.
> > >
> > >Any ideas what would cause this?  Should I reinstall?  Originally I was
> > >running 4.0, then I installed a 4.5 upgrade, and finally I installed
the
> > >4.5.1 upgrade.  If I reinstall, do I need to follow these steps again,
or
> > >is the 4.5.1 upgrade a complete version?
> > >
> > >Gregory M. Saunders, Ph.D.
> > >Senior Design Architect
> > >Cognitive Arts Corporation  (http://www.cognitivearts.com)
> > >1840 Oak Avenue, 4th Floor
> > >Evanston, IL 60201-5914
> > >
> >
>
>---
> ---
> > >Archives: http://www.eGroups.com/list/cf-talk
> > >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.eGroups.com/list/cf-talk
> > 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.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



test

2000-06-08 Thread pan



--
Archives: http://www.eGroups.com/list/cf-talk
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.



java cfx

2000-06-08 Thread Jason Egan

I need some assistance getting a java cfx to work --- 

Or if there is anyone out there that can write a c version of the java
program I have (code can be provided) – then I’m willing to go that route…

Anyone??

Thanks!
je

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Re: CFX-CRWTOPDF TAG

2000-06-08 Thread Stephen M. Aylor

It viloates the Adobe Acrobat license if used as the tag is intended.  I
beleive the authors made an honest mistake when they developed it, and have
since pulled it upon being informed of the issues with the Adobe EULA.

Try these:

www.digapp.com

www.activepdf.com

www.pdflib.com

www.pdfzone.com

www.planetpdf.com




These tools are not dependent on Adobes pdf creation lib's and there fore do
not viloate the the Adobe EULA for creating dynamic pdf server side.  There
are other tools too - look in the PDF Zone.

All the best,

Steve



- Original Message -
From: "sam komolafe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 05, 2000 07:11 AM
Subject: CFX-CRWTOPDF TAG


> Hi guys,
>
> The CFX-CRWTOPDF print tag is no longer available on Alliare's Tag
Gallary.
> Can any one who has a copy send me a copy of the Tag.
>
> Thanks
> sam
> [EMAIL PROTECTED]
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.



RE: NT to Solaris

2000-06-08 Thread Dave Watts

> Is there a utility or guide to convert .dll cfx tags into
> unix friendly files?

You'll need to recompile them on the target platform, and make sure that the
original code will work on that platform. This is why you don't find many
CFX tags for Unix platforms.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: Can CF generate a Pop-up Window w/o Javascript?????

2000-06-08 Thread Dave Watts

> I joined this list with the hope someone can help me with an
> issue I am having.
>
> I need to find out if CF can be used to generate a pop-up
> browser window WITHOUT the use of javascript.
>
> What I am trying to do is validate a form, and have a pop-up
> box appear when a field is not filled out, or when a field is
> a duplicate (using SQL to check for dupes), informing the user
> of such. However, I am NOT able to use javascript to generate
> the actual pop-up box. Will Cold Fusion be able to gereate that
> pop-up box
>
> Im not a programmer, so please phrase your answers accordingly :)

No. How's that?

The only thing that CF does (please excuse the slight understatement) is
generate ASCII text. This text can contain HTML, JavaScript, literal text,
CSS, DHTML, and lots of other stuff. Making boxes pop up, or doing anything
at all in the browser for that matter, requires the use of some technology
that the browser knows what to do with; you can use CF to generate the text
that the browser uses, but what the browser does with that text doesn't have
anything to do with CF. The browser doesn't even know anything about CF; all
it knows is that it made a URL request, and got back some text.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: Double Output Problem

2000-06-08 Thread Dave Watts

> 
> SELECT  Products.ProductTitle, Products.CategoryID,
> Products.ProductID
> FROMProducts, Category
> WHERE   Products.CategoryID = #URL.CategoryID#
> 
...
> OK there is a big problem with this, it wants to output 2
> times, so if there is just one product to return say "Paper",
> it will return this value twice, is there an error in my code???

Yes, there's a slight problem. In your query, you're using two tables, but
there's no join between them. This is called a Cartesian product, or a cross
join, and is a resultset which contains a number of records equal to the
number in the first table multiplied by the number in the second table. In
any case, you probably want to add an AND clause:

AND Products.CategoryID = Category.CategoryID

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Re: I am blowing up, what is this crazy error?

2000-06-08 Thread Fred T. Sanders

you wouldn't happen to have CFTry CFCatch going, that would
shorten your error down a bit, at least possibly to the
point where you can't get a decent description of it.

Fred

- Original Message -
From: "Sean Renet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 05, 2000 11:04 AM
Subject: I am blowing up, what is this crazy error?


> Error Diagnostic Information
> unknown exception condition
>
> unknown error while executing a tag.
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
sts/cf_talk or send a message to
[EMAIL PROTECTED] with 'unsubscribe' in the
body.

--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: SQL Server Question

2000-06-08 Thread Dave Watts

> I am not very savvy on the 'mechanical' workings of SQL
> Server but I need to remove it from my C drive and install
> it on my D drive. I am used to Microsoft ACCESS where I
> could simply 'cut and paste' the database to the D drive
> and then re-add it into my CF Server. What do I need to
> do and what is the best way to solve this problem with
> SQL Server?

As you've guessed, this isn't as easy as moving an Access file from one
drive to another. If you're doing this on your relatively expendable
development machine, this is the path I'd follow:

1. Back up all your databases to files, if you care about them at all.
2. Try to restore one to another machine, to make sure you can do it if you
end up completely breaking your machine.
3. Uninstall SQL Server.
4. Reinstall SQL Server where you want it.

If you're using SQL Server 6.5, you'll need to remove all traces of its
existence after you uninstall (a how-to is available on the MS site), and
even then you may have great difficulty reinstalling it.

If all this sounds like too much trouble, you might simply move some of the
databases to the other drive, and leave the actual server install where it
is - after all, it's the data which takes up all the room. You can do this
by backing up a database to a file, destroying the database and its device,
creating a new database and device, then restoring the backup file into the
database. Enjoy!

As a final note, if you're going to be working with SQL Server, it's in your
best interest to learn those "mechanical" workings as soon as possible -
it's pretty complex software, and you'll need to know a lot about how it
works to use it effectively.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: CFHTTP & IP checks

2000-06-08 Thread Dave Watts

> I'm experimenting with the use of CFHTTP and CFHTTPPARAMS to
> log in to a large, unaffiliated web site I frequently use
> and which requires username/password.
>
> It appears the other site uses an IP check of some kind,
> because it throws a vague error message that reports what
> my IP no. is (and blocks access). No doubt they've instituted
> this IP checking for security reasons.
>
> Without breaching the bounds of ethics, I'm wondering if
> there's any workaround...

Given that IP spoofing would breach the bounds of ethics, your only option
would be to get your server's IP added to their checklist, if you're correct
about your suspicion.

However, if it's an "unaffiliated" web site, how does it know what your IP
address should be? That is, if it lets you connect from your workstation,
does it allow you to connect via a browser from another desktop? I wouldn't
be surprised if, instead of it being an IP address issue, it just doesn't
recognize your "browser" when you use CFHTTP.

By default, CFHTTP describes itself to the target server as "ColdFusion". It
might be the case that the server is looking for a well-known browser type
like Netscape or IE. You can have CFHTTP tell the server it is one of those,
and see what happens. In CF 4.5.x, you can add a USERAGENT attribute; in
earlier versions, you'll have to add a CFHTTPPARAM tag, which might look
like this:



Note that the "HTTP_" prefix, as you'd see in the debug output, has been
omitted. The server will add that for any CGI data coming from the browser.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.eGroups.com/list/cf-talk
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.



CFers in Boise, Hosts in Boise

2000-06-08 Thread Eric Dawson

CFers in Boise, Hosts in Boise

Any?

offlist at [EMAIL PROTECTED]

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Stock database

2000-06-08 Thread Eric Dawson

I need a database of stock symbols and basic company information. Does 
anybody have such a beast?

offlist at [EMAIL PROTECTED]

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Re: Professional vs. Enterprise

2000-06-08 Thread Neil H.

Don't forget sandboxes and native driver support.

Neil

- Original Message -
From: "Peter Tilbrook" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 08, 2000 2:09 AM
Subject: RE: Professional vs. Enterprise


> No real difference (apart from the price). Enterprise supports clustering,
> Professional doesn't.
>
> ==
> Peter Tilbrook
> Internet Applications Developer
> Safetyweb Internet Solutions Pty. Ltd.
> 31-37 Townshend Street
> Phillip, ACT, 2606
>
> http://www.safetyweb.com.au
> http://www.actcfug.asn.au
>
> Phone: (02) 6285 3644
> Facsimile: (02) 6285 4114
>
> -Original Message-
> From: Ian Lurie [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 7 June 2000 4:42 AM
> To: [EMAIL PROTECTED]
> Subject: Professional vs. Enterprise
>
>
> Hi all,
>
> Assuming I'm not clustering, what's the difference between Professional
and
> Enterprise?
>
> Portent Interactive
> http://www.portentinteractive.com
> Process, Design, Content
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.



Re: removing space between words being uploaded to a database

2000-06-08 Thread Dick Applebaum

You can use the following approach:

1) use the ReReplace function to replace all CR or CFLF with a single space

2) use the ReReplace function to replace all occurrences of 2 or more 
consecutive spaces with a single space

You now have a list of words with a single space as the delimiter... 
you can use  any of the list functions or the CFLOOP tag specifying 
space as the delimiter.

HTH

Dick

At 3:46 PM +1000 6/4/2000, AustralianAccommodation.com Pty. Ltd. wrote:
>This is a multi-part message in MIME format.
>
>--=_NextPart_000_0021_01BFCE3C.048BE5A0
>Content-Type: text/plain;
>   charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>can I ask what the code is to remove spaces between words so that I can =
>update the database with the values minus the blank spaces
>
>
>Kind Regards
>
>Claude Raiola (Director)
>AustralianAccommodation.com Pty. Ltd.
>Website: www.AustralianAccommodation.com
>Email: [EMAIL PROTECTED]
--
Archives: http://www.eGroups.com/list/cf-talk
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.



Re: SQL auto-increment with trailing category identifier.

2000-06-08 Thread Dick Applebaum

Do you truely have enough control over the document numbers such that 
an identity field can be used as the doc ID?

This means:

   you cannot control the number that is assigned

   you may have missing numbers

   you cannot easily reserve/preassign blocks of numbers

If so, you can do the following:

CREATE TABLE Documents
 (
   DocID Integer Identity,
   StateID   Integer,
.
.
.
   PRIMARY KEY (DocID, StateID)
 )

HTH

Dick


At 7:12 AM -0400 6/6/2000, Smith, Melanie wrote:
>HELP!  I've posted this twice.  Does anyone know how to do this?
>
>
>-
>>  Does anyone know the best way to create autonumbers using SQL 7.0 similar
>>  to the following:
>>
>>  First Document ever created in NY where NY = code "01", DocID = 901-01
>>  2nd Document ever created in NY = DocID = 902-01
>>
>>  First Document created in MD  (Code = "02"), DocID = 901-02
>>  2nd Document created in MD = 902-02
>>
>>  First Drawing created in NY site = DocID = 801-01
>>  2nd Drawing in NY = 802-01
>>
>>  So grab the doctype (drawing or doc) AND the site off the form, query
>>  against some tables and determine next number, then assign it with the
>>  trailing suffix.  Can I use "01" or "02" as some sort of trailer and still
>>  use an identity type field or do I have to define it as integer or alpha
>>  type?  I could also use ".02" and ".01" if that would make it easier
>>  (i.e., I could use a number type versus alpha).  Much thanks to any
>>  insight anyone has to offer!
>--
--
Archives: http://www.eGroups.com/list/cf-talk
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.



OT : Database App Performance article

2000-06-08 Thread David Shadovitz

FYI, here's a good article titled, "Speed-Enable Your Web-Enabled
Databases":

http://www.enterprisedev.com/upload/free/features/entdev/2000/06jun00/be0
006/be0006.asp

It has more info than most of us want to know, but it shows the
importance of good database design, including indexes, keys, and stored
procedures.  Advocating the use of stored procedures and client-side
validation, the author writes: "you should perform functions close to the
source" in order to "eliminate unnecessary communication."

-David

YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.eGroups.com/list/cf-talk
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.



Email authentication

2000-06-08 Thread Todd Ashworth

Sorry if this comes through twice, but I'm afraid my last message got lost
in cyberspace.

 When someone signs up on my site, I would like to be able to verify that
their Email address is valid and, at the same time, make sure they are
really the person using that address.  I would like to send some sort of
confirmation E-mail with a link they have to follow to activate their
registration, but I want the link to be different/random for each person who
signs up.  I've seen a lot of setups where you get sent a link with,
seemingly, random numbers in it.  Has anyone had any experience with this
type of thing?  Personally, I don't care how it does it, as long as it
works.  Is there an easy way to create/process 'confirmation emails' in CF?
Is there any speciffic software or technique?

 .Todd

--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: Best Method

2000-06-08 Thread Dan G. Switzer, II

Jeffrey,

You can use the TOP predicate along with ORDER BY DESC to pull off the last
X number of records

SELECT TOP 5 ArticleID, Article
FROM Articles
ORDER BY ArticleID DESC

This assumes your primary key is called "ArticleID."

-Dan
++---+
|   name | Dan G. Switzer, II|
|company | PengoWorks.com|
|www | http://www.pengoworks.com |
| mailto | [EMAIL PROTECTED]   |
++---+


-Original Message-
From: Jeffrey Cohen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 06, 2000 10:36 AM
To: House OfFusion
Subject: Best Method

Greetings...

What is the best method for reading ONLY the last  five records in a
database for display?

I have a client that adds articles daily to a news database, and then
displays them on a news page. There are hundreds of articles, and on his
home page he just wants to display the 5 most recent. (which would be
the last five in the database, I presume)

Suggetstions???

and thanks as always for your help in advance...

Jeffrey Cohen
ImageWorks


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



Re: List

2000-06-08 Thread Stephen Garrett


This has been happening for the last few days for me. Something is seriously
wrong. Looking at the mail headers, it appears that some sort of looping
is happening that is causing a reinsertion of previous mails...

Steve

At 08:20 AM 6/6/2000 -0400, Steve Doran wrote:
>Sorry for this off subject.  But today is Tuesday and I have received
>approximately 30 #65 dated Saturday June 3, 2000.  Is there something wrong?
>
>Thanks,
>
>Steve Doran
>
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>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.
>

--
Stephen Garrett
GPS
[EMAIL PROTECTED]   (360) 896-2714
ICQ# 10776767
--
Archives: http://www.eGroups.com/list/cf-talk
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.



RE: Allaire Spectra E-Business Construction Kit

2000-06-08 Thread Ben Forta

TOC is listed on www.forta.com/books

--- Ben



-Original Message-
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 06, 2000 9:58 PM
To: [EMAIL PROTECTED]
Subject: RE: Allaire Spectra E-Business Construction Kit


Ben,

I'm interested, but I haven't seen a table of contents.  Can you share that?

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Ben Forta [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 02, 2000 1:31 PM
> To: [EMAIL PROTECTED]
> Subject: Allaire Spectra E-Business Construction Kit
>
>
> This is a public service announcement (combined with some blatant
> commercial
> advertising ):
>
> The "Allaire Spectra E-Business Construction Kit" is finally available.
> Copies have shipped and I am expecting that most online stores will start
> shipping it next week.
>
> Here's a link to it on Amazon.com (although I cannot promise that
> they'll be
> the first to ship it):
> http://www.amazon.com/exec/obidos/ISBN=0789723654/benfortascoldfusA/
>
> --- Ben
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.

--
Archives: http://www.eGroups.com/list/cf-talk
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.