Re: inserting memo fields in access database

[Seth Petry-Johnson]

> I need to insert in an access database, large text zone.
> I do that in a memo field, but it crash when I try to insert
> about more than 65 ko text.


I think that 65k is the max for an Access memo field.

> How can I by pass that limitation?


Get a real database system .  I know that the text datatype in SQL
supports a MUCH larger amount of data, and I'm sure that the equivalent in
Oracle is incredibly large as well.

You may want to look into Access 2000, it may support a larger memo field
and is definately cheaper than SQL or Oracle.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates

--
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: Date Comparisons - what's wrong here?

[Michael Kear]

Thanks Seth, again you're right.  I was trying to be too clever for my own
good.

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

On Thu, 30 Mar 2000, Seth Petry-Johnson wrote:

> >So to check if they were here today, I'm using the following:
> >
> >
> 
> >
> 
> 
> Hmm... I don't think you need this step.  I have always been able to use
> Date/Time values retrieved from a DB in CF Date/Time functions WITHOUT
> parsing it like this.
> 
> ParseDateTime() requires a *STRING REPRESENTATION* of a date as its
> parameter.  I believe that CF automatically creates testvoter.whenvotes as a
> date/time object because of the datatype of the field.  This is causing your
> input to the ParseDateTime() function to not be a simple string value, and
> thus the error.
> 
> So... to make a long story short, try removing this line and see what
> happens.  Also make sure that there is data in the date/time field in the
> DB.  Your error message indicates that perhaps you are passing a blank
> string to ParseDateTime().
> 
> Regards,
> Seth Petry-Johnson
> Argo Enterprise and Associates
> 
> 
> --
> 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.

inserting memo fields in access database

[Hubert Vaudaux]

Hello

I need to insert in an access database, large text zone.
I do that in a memo field, but it crash when I try to insert
about more than 65 ko text.

How can I by pass that limitation?

Thanks for help



Hubert Vaudaux

Service Internet MARCIREAU
[EMAIL PROTECTED]
http://www.marcireau.fr
Tél : (33) 5 49 76 79 20
Fax : (33) 5 49 76 79 00

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

CFID/CFTOKEN as a Unique DB Identifier

[Kevin Merker]

Since I  am new to SQL7 server and I don't know the in's and outs yet, I
was wondering since CF generates CFID and CFTOKEN for a client session.
I assume, no two CFID's or CFTOKEN's are the same, and this information
is available for manipulation. Has anybody ever used them for the
initial unique DB identifier  new (user_id) or reversing one or both
with text manipulation functions to create a new unique access code to
coincide with the new user_id?

Is this an illogical concept? It just seemed to me that this may be a
method used by others.

How would you create a randomly generated alpha-numeric ( non
duplicated)  user_id / access code using SQL7 server syntax.

Kevin Merker



--
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: Extracting elements from a data string

[Paul Hastings]

> We have a data field called #name#

> We would like to extract 
> - the first word as their first name,
> - the last word as their last_name
> - and anything in between as their Initials

treat the name as a list delimited by spaces.
if the list length is 3 then you got middle name
otherwise just get 1st & last elements of the list..

--
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: Date Comparisons - what's wrong here?

[Seth Petry-Johnson]

>So to check if they were here today, I'm using the following:
>
>

>


Hmm... I don't think you need this step.  I have always been able to use
Date/Time values retrieved from a DB in CF Date/Time functions WITHOUT
parsing it like this.

ParseDateTime() requires a *STRING REPRESENTATION* of a date as its
parameter.  I believe that CF automatically creates testvoter.whenvotes as a
date/time object because of the datatype of the field.  This is causing your
input to the ParseDateTime() function to not be a simple string value, and
thus the error.

So... to make a long story short, try removing this line and see what
happens.  Also make sure that there is data in the date/time field in the
DB.  Your error message indicates that perhaps you are passing a blank
string to ParseDateTime().

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates


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

Extracting elements from a data string

[Robert Ward]

Hi all,

We have a data field called #name#

Trouble is it contains all elements of the name, ie: First_Name Initials
Last_Name
(Note:  only about 30% have middle initials)

We would like to extract 
- the first word as their first name,
- the last word as their last_name
- and anything in between as their Initials

Anyone go a method to do this?

Thanks in advance

Rob
--
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: cfcontent with avi's??

[Kevin Merker]

I use quicktime / .mov with Netscape in CF templates and have no problem with :
http://quicktime.apple.com">

KM

William James wrote:

> Okay, I'm having a major problem here. Some of you may recall I was trying
> to protect images by using CFCONTENT to call them from a non-public
> directory. Well, my boss wants me to do the same with some avi files, which
> I sort of managed to do. Put there is 1 problem. They only work in IE.
> Netscape downloads the file then craps out on it. Here is the code:
>
> in the dsp_avis.cfm template:
>
> **SNIP**
>
> A HREF="avi.cfm?avinum=#i#" target="_blank">AVI #i#
>
> **SNIP**
>
> The avi.cfm template:
>
> **SNIP**
>
>  DELETEFILE="No">
>
> **SNIP**
>
> In Internet Explorer, the file downloads and opens Media Player and the avi
> will play. In Netscape it downloads and pops up an error. I'm guessing its
> because the Netscape media player doesn't understand the avi.cfm file type
> and can't play it. Is there any easy way to fix this without having website
> visitors have to change browser settings (or browsers).
>
> Thanks!
>
> --
> 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.

AW: Crystal Problems

[lorenz]

Use the smart viewers and the web report server from CR. Works perfect for
me.

Armin

-Ursprüngliche Nachricht-
Von: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Gesendet am: Mittwoch, 29. März 2000 16:21
An: [EMAIL PROTECTED]
Betreff: Re: Crystal Problems

We are having the same problem.

According to someone at allaire, Crystal Reports doesn't play well with CF
anymore.  The only solutions they offered were other, non-Crystal Reports
solutions.

If anyone out there has found a work around for this problem, please let us
know :)

Thanks,

Todd Ashworth

- Original Message -
From: "Eric Bradburn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 27, 2000 5:56 PM
Subject: Crystal Problems


> We are running ColdFusion Server 4.5 and trying to use the 
> tag. Our server is running Crystal Reports version 8.0.  When we
> reference a report with the  tag we are getting this error...
>
>
>
> Error Diagnostic Information
>
>
> Error occurred while processing CFREPORT
>
>
>
> An unexpected error occurred while using the Crystal Engine.
>
>
> Error number 692 ocurred (Error in File C:\Inetpub\wwwroot\working.rpt:
> Invalid export DLL or export format.).
>
>
> Crystal Library = C:\WINNT\system32\CRPE32.DLL (1/28/2000 15:16)
> DLL Version = 8.0, Engine Version = 8.0
>
>
>
> The error occurred while processing an element with a general identifier
>
> of (CFREPORT), occupying document position (9:1) to (9:70).



--
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?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Date Comparisons - what's wrong here?

[Michael Kear]

I've got a date stored in my SQL7 database.  When someone comes to the
site, I want to compare this date with Now() to see if they were here
today.

But it's just not happening for me.  (Sigh - dates are always my nemesis!)
What am I doing wrong please?

The field in the SQL7 database is a datetime field, named whenvotes which 
is brought to the template by the query testvoter:


SELECT  whenvotes, remote_addr
FROM poll_bank_1 
Where remote_addr='#remote_addr#'
.

So to check if they were here today, I'm using the following:



   
 

But the result I'm getting is an error message thus:

The date parameter of function ParseDateTime(date), which is , does not
represent a valid date

The error occurred while evaluating the expression:

 datevoted=parsedatetime(testvoter.whenvotes)

The error occurred while processing an element with a general identifier
of (CFSET), occupying document 


--
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 with avi's??

[William James]

Okay, I'm having a major problem here. Some of you may recall I was trying
to protect images by using CFCONTENT to call them from a non-public
directory. Well, my boss wants me to do the same with some avi files, which
I sort of managed to do. Put there is 1 problem. They only work in IE.
Netscape downloads the file then craps out on it. Here is the code:

in the dsp_avis.cfm template:

**SNIP**

A HREF="avi.cfm?avinum=#i#" target="_blank">AVI #i#

**SNIP**

The avi.cfm template:

**SNIP**



**SNIP**

In Internet Explorer, the file downloads and opens Media Player and the avi
will play. In Netscape it downloads and pops up an error. I'm guessing its
because the Netscape media player doesn't understand the avi.cfm file type
and can't play it. Is there any easy way to fix this without having website
visitors have to change browser settings (or browsers).

Thanks!


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

[Mark Zukiwsky]

>I have search form that contains a large amount of yes/no check boxes -237
>to be exact. It is to search the results of a survey that has 237 questions.
>
>Only when a checkbox is checked will data be sent from the form. Because of
>this I need to check if each variable is present. I can create 237 "CFIF
>IsDefined" statements to see if the variables are present. The other option
>is to set 237 CFPARAM variables to "NO" as default, and then create my
>dynamic SQL statements with CFIF tags checking for "YES".
>
>The problems with these two options is that they are slow and will take a
>long time to code.
>
>I was thinking:
>
>Is there a way to create a loop that will run through all the values from
>the form - creating a query and output for each one.

237 checkboxes! What do your users have to say about that. I have no 
idea of what your survey consists of but couldn't you possibly 
categorize the responses and build your search forms based on the new 
categories. I can't see how you can possibly find any relationships, 
or draw any conclusions from a variation of 237 check boxes.

Also, does that mean a single query will resolve the search, and what 
are the development implications of this?

Sorry, but I went to a User Centered Design presentation last night 
and have to ask.

Mark Zukiwsky
Edmonton, Canada
--
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: login application help requested

[John Quarto-vonTivadar]

what about something a little easier, given that all times after the first
time will the SESSION.LoggedIn be true:







the binary operation is surely faster than the IsDefined() function, yes? :)

the other comment that it has to be part of an application.cfm is right, or
at least an application.cfm equivalent (such as FuseBox's app_globals.cfm),
and obviously you have to have used the  tag to allow for
SESSION variables in the first place :)

you could also put any gross application 's within this loop too,
thereby only having to set them once. (most people just put the 's in
the application.cfm with no loop and so they get set and reset and reset
everytime a page is called. For a high volume site obviously this makes a
difference). Even in a non-high volume site it makes some difference. we had
a site where only 1 or 2 people were logged in at once and not a heck of a
lot of DB queries being done. In hitting the pages many times in a row, we
noticed a 3-4% increase in speed by wrapping the 20-25 's inside such
a loop. Although not scientific, I daresay to guess at least that savings
would occur in a high-traffic site, perhaps substantially higher depending
on what you do (or in this case, don't do) outside the loop.



> You will never get out of that loop.
>
> First time in,
>
> 
> 
> 
>
> this isnt defined, so you show login page then you submit to page to
autheticate, but the application.cfm is run before that page as well.
>
> What you could do is include your authentication in the app.cfm
>
> Check there if good they are in if not send back.
>


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

[Mark Zukiwsky]

Paul Smith wrote:

>How do you output its value?
>
>>session.sessionid is a value which is set by the CF server, not by the user,


Session and application variables are stored as structures, so you 
can view them by looping through the structure. Just add this bit of 
code to a page and it will output your variables.

Application Variables

   
 
 key = #appVar# (Value = #application[appVar]#)
 
   


Session Variables

   
 
 key = #sessionVar# (Value = #session[sessionVar]#)
 
   


For more detailed information check out the book "Mastering 
ColdFusion 4" by Arman Danesh. It covers application and session 
variables, and the use of cflock in detail. In fact, that's were I 
scooped this code from. The book is worth it for the application 
framework and error handling chapters alone.

Mark Zukiwsky
Edmonton, Canada

--
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: login application help requested

[Brian Peddle]

You will never get out of that loop.

First time in, 





this isnt defined, so you show login page then you submit to page to autheticate, but 
the application.cfm is run before that page as well.

What you could do is include your authentication in the app.cfm

Check there if good they are in if not send back.


-Original Message-
From: Chris Estes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 30 March 2000 8:24 AM
To: '[EMAIL PROTECTED]'
Subject: login application help requested


I have a home page in which there are links both for public and private
pages. I want users with a password to be able to click on a private page
link, login, then be forwarded directly to that page. It is easy enough to
send them to a specific page, but I can't seem to "forward" them. This code
takes the user back to the login form.

The code I'm using is very simple and basic (which is probably the problem).
I've included it below. If anyone can help, I'd appreciate it. I've wasted
two days of my life working on this.


Application.cfm:











http://localhost/isri/login/formpage.cfm?dest=#cgi.path_info#"
addtoken="No">
 



 





Formpage.cfm:




Password:


 


Actionpage.cfm:

SELECT username, pwd
FROM login
WHERE username = '#Form.name#' AND pwd = '#form.password#'




Log In





 
 


alert("We're sorry, but we were unable to verify either your Name or
Password. Please try again.")
self.location = 'formpage.cfm'






Chris Estes
(202) 662-8536
[EMAIL PROTECTED]
http://www.isri.org
http://www.scrap.org


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

--
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: login application help requested

[Peter Tilbrook]

I have a very customisable application that might interest you (I use it for
extranets, eg: http://www.abcb.gov.au/members/).

Email me back for the code.

Cheers!

==
Peter Tilbrook (ICQ: 666275)
Internet Applications Developer
SafetyWeb Internet Solutions
31-37 Townshend Street
Phillip, ACT, 2606

Phone: (02) 6273 9901
Fax: (02) 6273 9902
Mobile: 0428 765 020

http://www.safetyweb.com.au

-Original Message-
From: Chris Estes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 30 March 2000 8:24 AM
To: '[EMAIL PROTECTED]'
Subject: login application help requested


I have a home page in which there are links both for public and private
pages. I want users with a password to be able to click on a private page
link, login, then be forwarded directly to that page. It is easy enough to
send them to a specific page, but I can't seem to "forward" them. This code
takes the user back to the login form.

The code I'm using is very simple and basic (which is probably the problem).
I've included it below. If anyone can help, I'd appreciate it. I've wasted
two days of my life working on this.


Application.cfm:











http://localhost/isri/login/formpage.cfm?dest=#cgi.path_info#"
addtoken="No">
 



 





Formpage.cfm:




Password:


 


Actionpage.cfm:

SELECT username, pwd
FROM login
WHERE username = '#Form.name#' AND pwd = '#form.password#'




Log In





 
 


alert("We're sorry, but we were unable to verify either your Name or
Password. Please try again.")
self.location = 'formpage.cfm'






Chris Estes
(202) 662-8536
[EMAIL PROTECTED]
http://www.isri.org
http://www.scrap.org


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

How-To: Search Engine Friendly URLs?

[Eron Cohen]

Could someone please point me at a resource for how to do search-engine
friendly URLs with Fusebox applications.  I can't seem to find anything
useful on this.

Thank You!

Eron

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

[Dave Watts]

> You should also make sure the mime type is setup on the server.

You don't have to configure the server if CF is returning the MIME type in
the CFCONTENT tag.

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

[Dave Watts]

> > Here is what I've done so far:
> > I replaced smtp.dll as per the allaire hot fixes page.
> > I have verified and reverified the server settings.
> > I have doubled the time out in cfadmin.
> > I have started and restarted the services and cleared the
> > spool adnauseum.
> > I am still able to use the tag about 5 times, no mail is
> > ever sent and I
> > still get the same error, nothing's changed.
> > Anyone have any more ideas?
>
> Are you running 4.5? If so, perhaps 4.5.1 RC1 would help. It
> supposedly fixes all the cfmail bugs in 4.5 (including some
> not fixed by the smtp.dll hotfix). However, Allaire recommends
> not installing the RC1 upgrade on a production server since
> it is still officially beta.

I'd be careful about that. I put 4.5.1 RC1 on a server, and broke mail
functionality entirely. The fix, for me, was to take the SMTP.DLL from the
4.5 distribution and overwrite the 4.5.1 one with it!

> Kind of a sucky situation though, since upgrading a production
> server to the 4.5 release is what may be causing your problems
> to begin with.

That's a good summation.

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

[Dave Watts]

> I ran into the same problem with our setup. The mail server
> didn't like addresses outside of our domain as the FROM: address.
> It had something to do with our mail server, not CF> the work-around
> was to only allow a from address within our domain.
...
> Heck of a work around.  Kinds makes it useless in a lot of cases.
> Right now as I try to trouble shoot this, all TO: and FROM:
> address are in our domain.

Unfortunately, this is common. Mail servers are often configured to only
accept SMTP requests from the same domain; this prevents others, such as
spammers, from improperly using your mail server to send lots of junk.

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.

Selected CFTree Node

[Duane Boudreau]

Hi All,

Is it possible to get the selected node in cftree using JavaScript?

TIA,
Duane Boudreau
Director, Web Technologies
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249
Fax: 603-594-0258
ICQ#: 18024374
Jobs: [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: cold fusion's version of 404

[Dave Watts]

> Anyway, my question is this: Has anyone figured out a way to
> trick indexing systems (like Verity) into reading cold fusion's
> custom 404 page as a regular 404 page and not indexing it? What
> happens is that Verity reads the first line of the file not
> found message, as opposed to recognizing it as a broken link.

The only way I can think of to do this is to have the web server check for
the existence of the file before asking CF to process it - if it's not
there, the web server will return a real 404 page. You can do this easily
for IIS, but I don't know about for other servers. This imposes some
overhead as well.

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: iPlanet Web Server

[Cary Gordon]

Current and past versions run on IPlanet (Netscape) 3.6.x. The new version 
(4.5.1) will work with 4.0.x.

Cary Gordon

At 03:43 PM 3/29/00 -0700, you wrote:
>Does CF run on the iPlanet Web Server? I see both support NSAPI, so I 
>presume the answer is "yes".
>
>Also is anyone out there familiar with WebSite or IIS using it? How does 
>it compare?
>
>Larry

--
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: OT: Form Action Question - JS (MORE)

[Jeff]

james & larry,

:~~
: From: Larry Meadors <[EMAIL PROTECTED]>
:
: I just stuck this in, but I think it's close. When you change
: the selection, it updates the form action.
:~~

this was close, but it won't set it with the value of the .  this is
simpler still.


  test1
  test2



good luck,

.jeff

name://jeff.howden
game://web.development
http://www.evolt.org/
mailto:[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: 237 checkboxes

[Bud]

On 3/29/00, WBB penned:
>Optionally, you can name them all the same, assign them different
>values...any that are checked will have their values passed as a list. That
>way you only have 1  to worry about.
>
> > I have search form that contains a large amount of yes/no check boxes -237
> > to be exact. It is to search the results of a survey that has 237
>questions.

In actuality, unless you explained it wrong, you are saying you have 
237 yes/no checkboxes. If you are using checkboxes, you should only 
have a Yes, and say to click any checkbox that the answer is Yes. 
Otherwise, you'll invariably have some numbskulls that will check 
both yes and no and REALLY play havoc with your survery. :) If you 
need to do Yes/No, use radio buttons and set them all to a default of 
yes or no. Then you won't have to check for existence because each 
question will be passed as either yes or no.

You could easily loop through and evaluate the "fieldnames" variable:

Do your questions with underscores:
Do_You_Smoke?

The replace the underscores in the QuerySetCell tag.







evaluate(myList) will evaluate to yes or no.

Then:
Here are your survey answers.

#Question# - #Answer#


THE ONLY THING WRONG WITH THIS IS, FOR SOME REASON COLDFUSION LIKES 
TO CHANGE FIELDNAMES TO ALL CAPS.

Wish they'd fix that.


Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--
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 issues

[Peter Tilbrook]

I had the same problem and ended up re-installing CF to fix it.

Hasn't happened since and I have one page sending out over 1000 emails to
external domains (gst.accc.gov.au).

-Original Message-
From: John Tierney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 30 March 2000 1:06 AM
To: [EMAIL PROTECTED]
Subject: RE: CFMail issues


Here is what I've done so far:
I replaced smtp.dll as per the allaire hot fixes page.
I have verified and reverified the server settings.
I have doubled the time out in cfadmin.
I have started and restarted the services and cleared the spool adnauseum.
I am still able to use the tag about 5 times, no mail is ever sent and I
still get the same error, nothing's changed.
Anyone have any more ideas?




-Original Message-
From: John Tierney [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 2:00 PM
To: Cf-Talk@Houseoffusion. Com
Subject: CFMail issues


Hi,
Im having weirdness using cfmail on our installation on NT
I get this error:
unknown exception condition

TagCFMail::sendMessage

 The error occurred while processing an element with a general identifier of
(CFMAIL), occupying document position (9:1) to (9:105) in the template file

Has anyone seen this?




John J. Tierney
Web Application Developer &
Information Artist
Dreamscape Online LLC.
315.437.4166
http://www.dreamscape.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.

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

[Michael Blair]

You can do the inserts and the updates inside a loop as well.

Possibly just append a count variable from 1 to the number of rows in your
query at the end of your variable.  For example,


boxes#count#



This would make every variable different for your form and you can then use
another loop to access the form variables and insert or update via another
loop calling boxes#count#.  I messed with this for some time last week and
the syntax gets hairy but once you figure it out you can add questions just
by inserting them into your database and then the parameters can all be
changed via the query telling the  tag how many times to loop.  So
you could have 1 question or 10,000 and it doesn't matter.  The loop will
take care of it all inserting the answers to the questions.

The list idea others have given sounds good as well.

Good luck!



Michael W. Blair

Web Applications Developer
Canyon WebWorks
An Arizona Internet LLC Company
http://www.canyon.net
[EMAIL PROTECTED]
PHONE: (520) 773-9059
FAX:   (520) 773-4945

-Original Message-
From: Judah McAuley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 3:41 PM
To: [EMAIL PROTECTED]
Subject: Re: 237 checkboxes

If you name each of the checkboxes the same (all name="survey_answer" or
some such) and give each a different value (name="survey_answer"
value="votedinelection" name="survey_answer"
value="incomegreaterthan3") then you would get a comma delimited list
of all the checked boxes coming through
(survey_answer=votedinelect,incomegreaterthan3).  You could then loop
through this list and do updates.  If you gave the checkboxes values
identical to database fields and defaulted the values in the DB to 0 or NO,
then you could construct the loop fairly simply:


*insert blank record*


  
 
 UPDATE dbtable
 SET #answer# = 'YES'
 WHERE id = #id_from_previous_query#
 


This will be easier to code than 237 ifs, but on the other hand it could
potentially involve 237 updates instead of just one Insert.
Efficiency will be determined by percentage of checkboxes likely to be
checked.

Hope this helps,
Judah

At 05:21 PM 3/29/00 -0500, you wrote:
>I have search form that contains a large amount of yes/no check boxes -237
>to be exact. It is to search the results of a survey that has 237
questions.
>
>Only when a checkbox is checked will data be sent from the form. Because of
>this I need to check if each variable is present. I can create 237 "CFIF
>IsDefined" statements to see if the variables are present. The other option
>is to set 237 CFPARAM variables to "NO" as default, and then create my
>dynamic SQL statements with CFIF tags checking for "YES".
>
>The problems with these two options is that they are slow and will take a
>long time to code.
>
>I was thinking:
>
>Is there a way to create a loop that will run through all the values from
>the form - creating a query and output for each one.
>
>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.


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

CF and PST files

[Raley, Scott M (MIL)]

Has anyone done anything with taking messages out of a PST file and
importing them using CF into a db ?  I know that Outlook has an export
feature to export to an Access db or dbase but this is manual and I'm
looking for something that I can schedule and run automatically so that my
db is populated each night.
--
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: CF4.5 doesn't support Win2000 file encryption? WTF!?!?

[Rey Bango]

> first off, i have cf-talk set to send "plain text only", so if any
> attachments are being sent, that's news to me. granted i'll figure out why
> outlook is still sending them, but no need to give a speech like i haven't
> been reading this list forever and a day.

Wow. That's a pretty rude response. I give you a simple heads-up about the
fact that your email programming is embedding two graphic images and you
need to slam me for it. Take a pill or something, man.

> i posted to get answers, to see if anyone else has run into this. isn't
that
> the point of a discussion group, to help each other out? i'm quite
> disappointed that the first replies i get are "that's microsoft's problem,
> not ours" and "well, don't do that again".

Mike, you're definitely overreacting. I made an attempt to answer your
question. I may be wrong but I tried to lend some insight as to why you may
be having the problem. In addition, in your first post, you didn't put
anywhere near the amount of detail that you just did on your response to me.

My apologies for trying to help.

Rey...


--
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: Open source development?

[Mark Ireland]

getting everyone in the Spectra beta program would be good start wouldn't it?
I was told there was 100+ registered spectra developers. . . .

At 04:46 PM 29/03/00 -0500, you wrote:
>[EMAIL PROTECTED]  Not much traffic, though.  It seems Spectra
>has a lot of people scratching their heads.  Either that, or they are all on
>the Forums, but I can't deal with Forums.
>
>Chris Evans

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

How to update database from the data in a txt file

[mirza baig]

i have  a text file with data like this:

Student_ID Lic_No
---
333   
444   
555   

... and so on.

This is pure text file. In the database, I have a
column called 'Student_ID'. I have created a new
column called Lic_No in the database. I want to put
the Lic_No info into the database. 

If I do it individually I would say:

Update tbl_Student
set Lic_No = ''
where Student_ID = '333'

But, it is going to be very painful to do it
individually. I am sure there is an easy way. Can
someone tell me how.

Thanks all.
Mirza


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.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.

Re: 237 checkboxes

[Seth Petry-Johnson]

>I was thinking:
>
>Is there a way to create a loop that will run through all the values from
>the form - creating a query and output for each one.


If your questions are all numbered sequentially then this is real easy.
Name your checkboxes something like "Question_x" where "x" is the question
number.  Then...










If your questions aren't numbered sequentially then you have to modify this
slightly.  You will need a list of all the question numbers that are on the
form (such as "1,3,4,5,9,11").  Assuming that the list of numbers is in
lstNumbers you can do:










If you have non-sequential question numbers and need help figuring out how
to build the list of numbers let me know.

Hope this makes sense,
Seth Petry-Johnson
Argo Enterprise and Associates

--
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 list syntax

[Chris Giminez]

I am doing that.. sort of.

I have
'#form.city#' like '%des_city%'


The #form.city# will have one city name, and the field des_city may have one or many 
city names in a
comma deliimited list.
This is executing without an error, but it is not returning any records, where I know 
the values
should match.
I don't know if comma delimited lists have to be dealt with or can be dealt with in a 
special
manner.

Chris


> > What is the sql syntax for checking if a form field value is
> > contained in the contents of a comma
> > delimted list of values in a field?
>
> I think about the only way to do it is using:
>
> LIKE '%#form.name#%'
>
> Thus, if your db field contained 'nuts,bolts,nail,gun' and your form field
> was 'bolts', the record would match.
>
> Is that what your are trying to do?
>
> - Sean
>
> ~
> Sean Daniels
> Manager of Engineering
> DealStream, Inc.
> [EMAIL PROTECTED]
> ~
> tel: 207.439.6030
> cel: 978.764.0799
> Fax: 240.269.6319
>
>
>
> --
> 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: login application help requested

[Eric Dawson]

   


I don't think you need the cflocation. looks like it would loop indefinitely 
after logging in.

Eric

From: Chris Estes <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: login application help requested
Date: Wed, 29 Mar 2000 17:23:51 -0500

I have a home page in which there are links both for public and private 
pages. I want users with a password to be able to click on a private page 
link, login, then be forwarded directly to that page. It is easy enough to 
send them to a specific page, but I can't seem to "forward" them. This code 
takes the user back to the login form.

The code I'm using is very simple and basic (which is probably the problem). 
I've included it below. If anyone can help, I'd appreciate it. I've wasted 
two days of my life working on this.


Application.cfm:











http://localhost/isri/login/formpage.cfm?dest=#cgi.path_info#" 
addtoken="No">
 



  





Formpage.cfm:




Password:


 


Actionpage.cfm:

SELECT username, pwd
FROM login
WHERE username = '#Form.name#' AND pwd = '#form.password#'




Log In





  
  


alert("We're sorry, but we were unable to verify either your Name or 
Password. Please try again.")
self.location = 'formpage.cfm'






Chris Estes
(202) 662-8536
[EMAIL PROTECTED]
http://www.isri.org
http://www.scrap.org

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

__
Get Your Private, Free Email 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.

Oracle ODBC error

[Lomvardias, Christopher]

I'm having trouble hitting an Oracle 8i database via ODBC (I'm running
CF4Pro). When I try to verify the connection in the CF Administrator or run
a CF template that hits the DB, I get a popup box titled OCI.DLL that says
"The specified module could not be found"  and then finally I get this
message in the browser 
ODBC Error Code = IM003 (Specified driver could not be loaded) 
Specified driver could not be loaded due to system error 1114 (Oracle ODBC
Driver).


I looked and found the OCI.DLL file, so I know that the file is there. The
crazy thing is that I am able to hit and query the DB just fine using the
"Oracle ODBC Test" application and I'm also able to use Access to link to
the DB tables just fine.

Anyone have any suggestions?

Thanks,

Chris
--
Chris Lomvardias
Syscom, Inc.
400 E. Pratt Street, Suite 300
Baltimore, MD 21202
(410)539-3737 x1722 voice
(410)539-7302 fax
[EMAIL PROTECTED]
[EMAIL PROTECTED] (pager via email)
--

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

[David Gassner]

It's a variable like any other, so:

#session.sessionid#

> -Original Message-
> From: paul smith [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 1:48 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Using CFLOCK
> 
> 
> How do you output its value?
> 
> best,  paul
> 
> 
> At 01:01 PM 3/29/2000 -0800, you wrote:
> >session.sessionid is a value which is set by the CF server, not 
> by the user,
> 
> 
> --
> 
> 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: CF4.5 doesn't support Win2000 file encryption?

[Michael Dinowitz]

Any scripting language has to read a file containing the code to run. It
doesn't matter if its CF, Perl, Rebol or even Asp. If the file is encrypted,
then the script engine can not read the file nor can it run the script. I'm
assuming that MS has something built into asp to automatically decode the
file for use, but no other script engine has that ability. They can not
unless MS gives out the encryption code and they integrate it into the
engine. As Rey said, this would render the whole thing useless.
Using this logic, I can say that every scripting language will be effected
by this.

- Original Message -
From: "William James" <[EMAIL PROTECTED]>

> On the other hand, who says that they all have problems with it? Maybe
only
> Cold Fusion does. Unless someone's tried them all, I don't think you can
say
> one way or the other who's problem it is, but I do think that Allaire is
the
> ones who would need to fix it. As well as each of the others. You don't
have
> to use the MS Encryption (I don't see why you would need to), but if you
do,
> you have to use products that work with it. It is not up to MS to make
sure
> their technology works with other programming languages unless they said
the
> encryption process is for use with them. That's like saying MS has to make
> drivers for Windows 2000 for all of your hardware. They don't. The
hardware
> manufacturer should make the drivers for windows 2000 if they want their
> hardware to work in Windows2000. MS has done an awesome job of making sure
> most stuff works, but I've read too many hardware sites that say, "MS has
a
> pretty good driver for our hardware and although it could be better, we
> aren't going to bother making a new one".
> - Original Message -
> From: "Michael Dinowitz" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 29, 2000 1:33 PM
> Subject: Re: CF4.5 doesn't support Win2000 file encryption?
>
>
> > Forgive me for asking, but if MS gives a new 'feature' that will effect
> CF,
> > Perl, Rebol and almost every non-MS scripting language, why would you
> think
> > it needs a fix from Allaire?
> > >
> > > Windows 2000 allows you to encrypt files. ColdFusion does not seem to
> > > support this, as I get the following error on any page that I encrypt:
> > >
> > > The template file exists, however, it either cannot be opened for
> reading,
> > > or it is encrypted and its data has been corrupted
> > >
> > > as soon as i unencrypt, all things are good to go.
> > >
> > > anyone heard anything about this? is allaire going to fix this in a
> > service
> > > patch?
> >
> >
>
> --
> 
> > 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: Open source development?

[Michael Dinowitz]

Spectra's kind of new so it'll take some time for the list to ramp up the
100s of messages a day that CF-Talk has. Currently the traffic is getting
better and you can have up to a few dozen messages on a good day.


> [EMAIL PROTECTED]  Not much traffic, though.  It seems
Spectra
> has a lot of people scratching their heads.  Either that, or they are all
on
> the Forums, but I can't deal with Forums.
>
> Chris Evans
> [EMAIL PROTECTED]
> http://www.fuseware.com
>
>
> -Original Message-
> From: Ron Anderson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 4:18 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Open source development?
>
>
> Is there a Spectra mailing list available?
>
>
> -Original Message-
> From: Chris Evans [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 12:35 PM
> To: [EMAIL PROTECTED]
> Subject: Open source development?
>
>
> Id any body doing any kind of open source development for Spectra?  I have
> heard there are a few known bugs and enhancements for Spectra that
everybody
> is complaining about.  The code is open, and I'm sure people are making
> changes to the underlying code to get it working.  Is there a web site
 or
> should there be) where developers can post their fixes, both for other
> developers to use and for Allaire?
>
> Chris Evans
> [EMAIL PROTECTED]
> http://www.fuseware.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.
>
>
> --

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

Allaire survey

[Michael Dinowitz]

Allaire has posted a survey for feedback about their developer resource. I
feel that everyone should answer it as truthfully as possible. One thing to
pay special attention to is questions 25 and 26. Let Allaire know what CF
resources you use (House of Fusion, Fusion Authority, Defusion, CFNewbie,
CFAdvisor, etc.). This will (hopefully) suggest to them that there are a lot
of 'third party resources' out there that they should work closer with. This
is a survey for ALL Allaire products, so it applies to the JRun and HomeSite
communities as well.

25  In your opinion, which technical Web site offers the best mix of content
and intuitive navigation? (enter valid URL)
26  Which three technical information Web sites do you access most
frequently? (enter valid URL)

Survey:
http://www.allaire.com/handlers/index.cfm?Method=Registration&Type=Event_Sur
vey&Section=developer

Michael Dinowitz
ListMaster - various lists. ;)
Latest Alert went out on the 27th- http://www.fusionauthority.com/alert

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

CFGRID and validate

[Dave Robertson]

Gang: Is there an easy way to validate a cfgrid column prior to a db update
- Thanks DHR
--
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: 237 checkboxes

[Sean German]

H.

You could give each checkbox the same name (ex/ yes_no) with incrimental
values (1,2,3,...237).  The result is a single variable, form.yes_no, to
define.  The plus side is the result is a list you can just search for the
yeses (boxes that were checked).  The minus side is the result is a list you
have to search for the yeses.

If each checkbox has a different name, you can loop through form fields with
something like:


#evaluate('form.' & field_name)#



HTH,

Sean

-Original Message-
From: Daniel Murphy [mailto:[EMAIL PROTECTED]]


I have search form that contains a large amount of yes/no check boxes -237
to be exact. It is to search the results of a survey that has 237 questions.
--
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: CF4.5 doesn't support Win2000 file encryption? - answer

[Mike Amburn]

> Just a guess here as I haven't tried EFS on a server yet, but I
> would think
> that since files are encrypted by and can only be read by the file owner
> (as I understand it) that the CF Server service would need to run
> under the
> context of the file owner - ie have the CF service login as that user.

thank you, someone that actually has constructive input to offer...

you are correct. after i RTF-Win2000-M, i found the following:

--
Accessing encrypted data
Users access encrypted files just as they do unencrypted files. Thus, when a
user accesses an encrypted file that is stored on disk, the user is able to
read the contents of the file in the normal way. When the user stores the
file on disk again, EFS transparently encrypts the file again.

Only the user that encrypted a file can access it later. This is assured
because users have private keys that allow them access to their own
encrypted files. If another user tries to access an encrypted file, that
user receives an Access Denied message.
--

so i am assuming that anything that runs as a service or using a system
account (IIS, CF, SQL Server, backup server) will not be able to read a file
that is encrypted by me using the Win2000 file encryption. that's an
important feature, i'd say.

mike

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

[WBB]

Optionally, you can name them all the same, assign them different
values...any that are checked will have their values passed as a list. That
way you only have 1  to worry about.

> I have search form that contains a large amount of yes/no check boxes -237
> to be exact. It is to search the results of a survey that has 237
questions.
>
> Only when a checkbox is checked will data be sent from the form. Because
of
> this I need to check if each variable is present. I can create 237 "CFIF
> IsDefined" statements to see if the variables are present. The other
option
> is to set 237 CFPARAM variables to "NO" as default, and then create my
> dynamic SQL statements with CFIF tags checking for "YES".
>
> The problems with these two options is that they are slow and will take a
> long time to code.
>
> I was thinking:
>
> Is there a way to create a loop that will run through all the values from
> the form - creating a query and output for each one.
>
> 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.
>

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

[Michael Blair]

Yes.

You need to create your form and your checking via a loop.  Anytime you have
more than say 5 lines of something redundant I use a loop.  No use wasting
time hardcoding all that when you can make it changeable very quickly by
just changing the loop parameters with possibly a variable you pass it or a
query attribute.

Look into CFLOOP's:  no programmer in his right mind will write all that out
without a loop.



Michael W. Blair

Web Applications Developer
Canyon WebWorks
An Arizona Internet LLC Company
http://www.canyon.net
[EMAIL PROTECTED]
PHONE: (520) 773-9059
FAX:   (520) 773-4945

-Original Message-
From: Daniel Murphy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 3:22 PM
To: '[EMAIL PROTECTED]'
Subject: 237 checkboxes

I have search form that contains a large amount of yes/no check boxes -237
to be exact. It is to search the results of a survey that has 237 questions.

Only when a checkbox is checked will data be sent from the form. Because of
this I need to check if each variable is present. I can create 237 "CFIF
IsDefined" statements to see if the variables are present. The other option
is to set 237 CFPARAM variables to "NO" as default, and then create my
dynamic SQL statements with CFIF tags checking for "YES".

The problems with these two options is that they are slow and will take a
long time to code.

I was thinking:

Is there a way to create a loop that will run through all the values from
the form - creating a query and output for each one.

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.

--
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: looping through a mailing list

[LetchfordDesign]

How many properties do you have in the database?


- Original Message -
From: Chris Giminez <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2000 3:31 PM
Subject: Re: looping through a mailing list


> I've changed part of the checking to the query, not cfif's, but I am still
getting the same wrong
> results. I could really use some help if someone can,  or at least a nudge
in the right direction.
>
> ***
> 
> SELECT  *
> FROM notify
>
> Where
> 0=0
> AND
> #form.bed# >= des_bed
> AND
> #form.bath# >= des_bath
> AND
> #form.garage# >= des_garage
> AND
> #form.price# >= gt_price
> AND
> #form.price# <= lt_price
> AND
> #form.sq_ft# >= des_sq_ft
>
> ORDER BY  date_subscribed
> 
>
> 
> 
>
> 
>  notify_list.des_city CONTAINS form.city
> AND
> form.display eq 1
> AND
> form.status eq "for sale"
> >
> 
>
> Send email to #notify_list.first_name#
> #notify_list.last_name#
>
> 
>
> 
>
>
> Don't send email #notify_list.first_name#
> #notify_list.last_name#
>
> 
>
> 
> ***
>
> Thanks!
>
> Chris Giminez
> Owner - Cyber Scriber Web Site Design
> 831-728-4469
> ICQ# 2628000
>
>
>
>
> > Yer wasting a lot of processing power in coldfusion unnecessarily.  You
> > should build a where clause that replicates the conditions you are
searchinf
> > for in your CFIF, that way you just loop over the result set and send
the
> > email to every single record.  SQL Will handle that much faster than
Cold
> > Fusion will.
> >
> > Jordon
> >
> >
>
>
> >
> > This is for a real estate web site where the realtor will add their own
> > property. When new property
> > is added, I want it to check a data table of subscribers who are
interested
> > in a property fitting
> > certain criteria, such as price, number of bedrooms, bathrooms, etc.
> >
> > I thought I had this figured out, but am not getting the desired
results.
> >
> > Here's my code:
> > **
> > 
> > 
> > SELECT  *
> > FROM notify
> > ORDER BY  date_subscribed
> > 
> >
> > 
> > 
> >
> > 
> >  > form.bed gte notify_list.des_bed
> > AND
> > form.bath gte notify_list.des_bed
> > AND
> > form.garage gte notify_list.des_garage
> > AND
> > form.price gte notify_list.gt_price
> > AND
> > form.price lte notify_list.lt_price
> > AND
> > form.sq_ft gte notify_list.des_sq_ft
> > AND
> > notify_list.des_city CONTAINS form.city
> > AND
> > form.display eq 1
> > AND
> > form.status eq "for sale"
> > >
> > 
> > Send email to #notify_list.first_name#
> > #notify_list.last_name#
> > 
> >
> > 
> >
> >
> > Don't send email #notify_list.first_name#
> > #notify_list.last_name#
> >
> > 
> >
> > 
> > **
> >
> > I currently have just 3 subscrbers in the notify table for testing and
the
> > above code gives me this
> > result.
> >
> > *
> > Send email to joe testerTest PersonChris Giminez
> > Don't send email joe testerTest PersonChris Giminez
> > Don't send email joe testerTest PersonChris Giminez
> > *
> > It's somehow evaluating to true and false for each person.
> >
> > I know I'm close to getting this. If someone could enlighten me I would
be
> > most grateful.
> >
> > Thanks!
> >
> > Chris Giminez
> > Owner - Cyber Scriber Web Site Design
> > 831-728-4469
> > ICQ# 2628000
> >
> >
> >
> >
> >
>
> --
--
> > --
> > 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: Has someone wrangled a way to get CF to print an HTML document?

[Russ Michaels]

The fact your not thinking about is that CF is server side, thus if you 
were able to send a print command, it would print on the server that is 
running CF.
If you want to print the contents of a CF page, what you are effectively 
printing is the HTML page, thus you need to use Javascript to initiate the 
browsers print command, it's nothing to do with CF.
If by some chance you really do mean that you want to print the CF source 
code, then why can't you do it from CFStudio You couldn't very well 
print source code while it is being executed.

Netscape Navigator has a print method, one of the few times that Netscape 
turns out to be better than IE.
window.print()
with IE you have to use ActiveX, although I suspect IE5 probably has a 
built in method.

Russ



  Satachi Internet Development
--
 Tel/Fax: 0870 787 3610
 Mobile: 07050 648684
 http://www.satachi.com
 email: [EMAIL PROTECTED]

--
 To join the Satachi-news mailing list
 send a blank e-mail to
 [EMAIL PROTECTED]
 or visit satachi.listbot.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.

dynamic control names

[Ayush Lall]

"dynamic variable names
In this example, the variable name is itself a variable. 

"

Hi !!

My question is very much related to dynamic names.

I have control names in the form as "varN" where N is a count changing
with every iteration of the loop.So names are like..var1,var2,var3...so
on.

I need to access the values of those variable controls in a iterative
loop like



Here I need to have access to the value of control 
"Form.var1" but I am not able to find a way to do so.

Format - (Form.var)(Count)

What can be done so as to have an output for the statement :
#Form.var1# ??

Thanks.

Ayush Lall.


Get free email and a permanent address at http://www.netaddress.com/?N=1
--
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: sql list syntax

[Sean Daniels]

> What is the sql syntax for checking if a form field value is
> contained in the contents of a comma
> delimted list of values in a field?

I think about the only way to do it is using:

LIKE '%#form.name#%'

Thus, if your db field contained 'nuts,bolts,nail,gun' and your form field
was 'bolts', the record would match.

Is that what your are trying to do?

- Sean

~
Sean Daniels
Manager of Engineering
DealStream, Inc.
[EMAIL PROTECTED]
~
tel: 207.439.6030
cel: 978.764.0799
Fax: 240.269.6319



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

iPlanet Web Server

[Larry Meadors]

Does CF run on the iPlanet Web Server? I see both support NSAPI, so I presume the 
answer is "yes".

Also is anyone out there familiar with WebSite or IIS using it? How does it compare?

Larry


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

[Judah McAuley]

If you name each of the checkboxes the same (all name="survey_answer" or 
some such) and give each a different value (name="survey_answer" 
value="votedinelection" name="survey_answer" 
value="incomegreaterthan3") then you would get a comma delimited list 
of all the checked boxes coming through 
(survey_answer=votedinelect,incomegreaterthan3).  You could then loop 
through this list and do updates.  If you gave the checkboxes values 
identical to database fields and defaulted the values in the DB to 0 or NO, 
then you could construct the loop fairly simply:


*insert blank record*


  
 
 UPDATE dbtable
 SET #answer# = 'YES'
 WHERE id = #id_from_previous_query#
 


This will be easier to code than 237 ifs, but on the other hand it could 
potentially involve 237 updates instead of just one Insert.
Efficiency will be determined by percentage of checkboxes likely to be checked.

Hope this helps,
Judah

At 05:21 PM 3/29/00 -0500, you wrote:
>I have search form that contains a large amount of yes/no check boxes -237
>to be exact. It is to search the results of a survey that has 237 questions.
>
>Only when a checkbox is checked will data be sent from the form. Because of
>this I need to check if each variable is present. I can create 237 "CFIF
>IsDefined" statements to see if the variables are present. The other option
>is to set 237 CFPARAM variables to "NO" as default, and then create my
>dynamic SQL statements with CFIF tags checking for "YES".
>
>The problems with these two options is that they are slow and will take a
>long time to code.
>
>I was thinking:
>
>Is there a way to create a loop that will run through all the values from
>the form - creating a query and output for each one.
>
>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.

--
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: CF4.5 doesn't support Win2000 file encryption? WTF!?!?

[Mike Amburn]

first off, i have cf-talk set to send "plain text only", so if any
attachments are being sent, that's news to me. granted i'll figure out why
outlook is still sending them, but no need to give a speech like i haven't
been reading this list forever and a day.

second... i can encrypt a file and have no problem opening it in
 - Microsoft Word
 - Netscape Navigator
 - ColdFusion Studio
that's because the encryption is being handled by the OS/file system. i
assume it's decrypted before streaming to the application and then
re-encrypted with each save. So no encrypting algorithm is needed by third
party vendors if the OS is handling it, as it is.

now, the only problem i have is when i attempt to access it through a web
server. this applies to *.cfm (and as i've learned in the last hour) *.html
and *.asp. apparently the functions that decrypt the file for desktop
applications is not being run by the web server (IIS5 in my case). whether
this is a securiy feature of IIS5, a security feature for any web server
running on Win2000, or a bug i have no idea.

i posted to get answers, to see if anyone else has run into this. isn't that
the point of a discussion group, to help each other out? i'm quite
disappointed that the first replies i get are "that's microsoft's problem,
not ours" and "well, don't do that again". geez, guys... what's up with
that? i've seen too many great discussions and ideas come out of this list
than to get replies like that...

mike


> -Original Message-
> From: Rey Bango [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 4:27 PM
> To: [EMAIL PROTECTED]
> Subject: Re: CF4.5 doesn't support Win2000 file encryption?
>
>
> Mike,
>
> I wouldn't expect it to be dealt with. That's a feature of Win2K to help
> protect your files in an internal, corporate environment. MS would have to
> allow 3rd party vendors access to their unecryption algorithms in order to
> do this. This would essentially negate any security that encryption might
> offer you.
>
> As a side note, the admins of CF-Talk list have disabled file attachment
> capabilities because of a virus scare so any messages w/ attached
> files are
> coming out screwy. Would you mind removing your
> atworklogo_very_small.gif &
> Glacier Bkgrd.jpg files from your messages.
>
> Thanks,
>
> Rey...
> Certified Allaire Instructor
> Member of Team Allaire
>
> "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
>
>
> - Original Message -
> From: "Mike Amburn" <[EMAIL PROTECTED]>
> To: "Cf-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 29, 2000 3:46 PM
> Subject: CF4.5 doesn't support Win2000 file encryption?
>
>
> > This is a multi-part message in MIME format.
> >
> > --=_NextPart_000__01BF9995.F72A13D0
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: 7bit
> >
> > Windows 2000 allows you to encrypt files. ColdFusion does not seem to
> > support this, as I get the following error on any page that I encrypt:
> >
> > The template file exists, however, it either cannot be opened
> for reading,
> > or it is encrypted and its data has been corrupted
> >
> > as soon as i unencrypt, all things are good to go.
> >
> > anyone heard anything about this? is allaire going to fix this in a
> service
> > patch?
> >
> > Mike Amburn
> > Application Development

--
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: some high trafic cf websites please

[dougn]

I'll have a  with  and 
or would that be a ?

-Original Message-
From: Aymeric Grassart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 2:20 PM
To: [EMAIL PROTECTED]
Subject: Re: some high trafic cf websites please


Mcd is starting to move to CF from Lotus Notes.
Although right now CF is only used in their private intranets. It looks like
they might take CF to the public side in the near future...

w00t,
Aymeric.

[EMAIL PROTECTED] wrote:

> Are you sure Amazone.com is Cold Fusion I know for a fact that
> Toys-R-Us.com, Nike.com, and my company Autobytel.com is all CF.
>
> -Original Message-
> From: Tim Maxwell [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 27, 2000 1:28 PM
> To: [EMAIL PROTECTED]
> Subject: Re: some high trafic cf websites please
>
> amazon.com and fedex.com are both CF sites.  Hope this helps
>
> Tim
>
> - Original Message -
> From: Interent Gold Coast Properties
> <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, March 27, 2000 7:07 AM
> Subject: some high trafic cf websites please
>
> > Hi,
> >
> > i am wondering if anyone could direct me to some very high traffic cf
> > websites so that i can get some idea as to what cf server firms provide
> high
> > quality cf hosting for high traffic sites
> >
> > Kind Regards
> >
> > Claude Raiola
> > E-Mail: [EMAIL PROTECTED]
> > Website: www.internetgoldcoastproperties.com.au
> >
> >
> >
--
> 
> > 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: Using CFLOCK

[paul smith]

How do you output its value?

best,  paul


At 01:01 PM 3/29/2000 -0800, you wrote:
>session.sessionid is a value which is set by the CF server, not by the user,


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

Allaire Developer Web Site Survey Launched

[Sam Coe]

Please take a few minutes and tell us what kind of technical information you
need in our monthly developer newsletter and on our Developer Web site. This
(fairly brief) online survey will make sure that we hear your voice and
consider your needs as we rebuild the Allaire DevCenters into premier
portals for the entire Allaire developer community. Every tenth survey
participant will receive an Allaire T-shirt.


http://www.allaire.com/handlers/index.cfm?Method=Registration&Type=Event_Sur
vey&Section=developer


Thanks in advance,
-Sam

--
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: CF4.5 doesn't support Win2000 file encryption?

[JF]

Mike -

Just a guess here as I haven't tried EFS on a server yet, but I would think 
that since files are encrypted by and can only be read by the file owner 
(as I understand it) that the CF Server service would need to run under the 
context of the file owner - ie have the CF service login as that user.

Jay

At 04:27 PM 3/29/2000 -0500, you wrote:
>Mike,
>
>I wouldn't expect it to be dealt with. That's a feature of Win2K to help
>protect your files in an internal, corporate environment. MS would have to
>allow 3rd party vendors access to their unecryption algorithms in order to
>do this. This would essentially negate any security that encryption might
>offer you.
>
>As a side note, the admins of CF-Talk list have disabled file attachment
>capabilities because of a virus scare so any messages w/ attached files are
>coming out screwy. Would you mind removing your atworklogo_very_small.gif &
>Glacier Bkgrd.jpg files from your messages.
>
>Thanks,
>
>Rey...
>Certified Allaire Instructor
>Member of Team Allaire
>
>"A browser's beauty, at its heart, is its usefulness as a *TOOL*."
>
>
>- Original Message -
>From: "Mike Amburn" <[EMAIL PROTECTED]>
>To: "Cf-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, March 29, 2000 3:46 PM
>Subject: CF4.5 doesn't support Win2000 file encryption?
>
>
> > This is a multi-part message in MIME format.
> >
> > --=_NextPart_000__01BF9995.F72A13D0
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: 7bit
> >
> > Windows 2000 allows you to encrypt files. ColdFusion does not seem to
> > support this, as I get the following error on any page that I encrypt:
> >
> > The template file exists, however, it either cannot be opened for reading,
> > or it is encrypted and its data has been corrupted
> >
> > as soon as i unencrypt, all things are good to go.
> >
> > anyone heard anything about this? is allaire going to fix this in a
>service
> > patch?
> >
> > Mike Amburn
> > Application Development
> >
> > --=_NextPart_000__01BF9995.F72A13D0
> > Content-Type: image/gif;

[Ugly GIF garbage removed...]

--
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: CF4.5 doesn't support Win2000 file encryption?

[Judah McAuley]

At 02:10 PM 3/29/00 -0800, you wrote:
>On the other hand, who says that they all have problems with it? Maybe only
>Cold Fusion does. Unless someone's tried them all, I don't think you can say
>one way or the other who's problem it is, but I do think that Allaire is the
>ones who would need to fix it. As well as each of the others. You don't have
>to use the MS Encryption (I don't see why you would need to), but if you do,
>you have to use products that work with it. It is not up to MS to make sure
>their technology works with other programming languages unless they said the
>encryption process is for use with them. That's like saying MS has to make
>drivers for Windows 2000 for all of your hardware. They don't. The hardware
>manufacturer should make the drivers for windows 2000 if they want their
>hardware to work in Windows2000. MS has done an awesome job of making sure
>most stuff works, but I've read too many hardware sites that say, "MS has a
>pretty good driver for our hardware and although it could be better, we
>aren't going to bother making a new one".

Actually, sounds like CF 4.5 does work with W2K encryption.  CF reports 
that it cant' read the file.  That's because it's encrypted.  File 
encryption is supposed to make the files unreadable except by the 
encrypting/unencrypting program.  Wordpad can normally read .cfm files, but 
if you use CF's code encryption, Wordpad can no longer open the files.  No 
one seems to be complaining about that, it works as it's supposed to.  Why 
is anyone complaining about W2K file encryption not being able to be undone 
by other programs?

Judah
(who is in a contrary mood today...no offense intended to anyone)


--
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: Open source development?

[Douglas . McLeod]

Yes,

[EMAIL PROTECTED]

-Original Message-
From: Ron Anderson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 3:18 PM
To: [EMAIL PROTECTED]
Subject: RE: Open source development?


Is there a Spectra mailing list available?


-Original Message-
From: Chris Evans [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 12:35 PM
To: [EMAIL PROTECTED]
Subject: Open source development?


Id any body doing any kind of open source development for Spectra?  I have
heard there are a few known bugs and enhancements for Spectra that everybody
is complaining about.  The code is open, and I'm sure people are making
changes to the underlying code to get it working.  Is there a web site ( or
should there be) where developers can post their fixes, both for other
developers to use and for Allaire?

Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.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.
--
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: CF4.5 doesn't support Win2000 file encryption?

[Fred Sanders]

maybe you shouldn't let MS encrypt the pages and just let CF do the work
like its supposed to if something is going to go through two
encryption/decryption processes from two different servers what is going to
define which goes first common sense
- Original Message -
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2000 3:33 PM
Subject: Re: CF4.5 doesn't support Win2000 file encryption?


> Forgive me for asking, but if MS gives a new 'feature' that will effect
CF,
> Perl, Rebol and almost every non-MS scripting language, why would you
think
> it needs a fix from Allaire?
> >
> > Windows 2000 allows you to encrypt files. ColdFusion does not seem to
> > support this, as I get the following error on any page that I encrypt:
> >
> > The template file exists, however, it either cannot be opened for
reading,
> > or it is encrypted and its data has been corrupted
> >
> > as soon as i unencrypt, all things are good to go.
> >
> > anyone heard anything about this? is allaire going to fix this in a
> service
> > patch?
>
>
> --

> 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 list syntax

[Chris Giminez]

What is the sql syntax for checking if a form field value is contained in the contents 
of a comma
delimted list of values in a field?


Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000



--
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: Who Said netscape is dead & as for People dressed in black wearing berets.....

[Steve Aylor]

Did you require the De-Loused model :-)?  At least I trimmed the headers and
footer..


> I can bid on a genuine Steve Aylor beret Gotta go off to Ebay!!!
>
> Hey that almost rhymes.
>
> > Good Gdd Mn!!!  Its Dave Watts everywhere :-)
> >
> > Now... off to list my beret on Ebay.
> >
> > Steve



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

237 checkboxes

[Daniel Murphy]

I have search form that contains a large amount of yes/no check boxes -237
to be exact. It is to search the results of a survey that has 237 questions.

Only when a checkbox is checked will data be sent from the form. Because of
this I need to check if each variable is present. I can create 237 "CFIF
IsDefined" statements to see if the variables are present. The other option
is to set 237 CFPARAM variables to "NO" as default, and then create my
dynamic SQL statements with CFIF tags checking for "YES". 

The problems with these two options is that they are slow and will take a
long time to code.

I was thinking:

Is there a way to create a loop that will run through all the values from
the form - creating a query and output for each one.

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

[David Gassner]

Actually, this is the Allaire recommendation for 4.01 and prior.  For 4.5,
they recommend using the new scope attribute, as in:

scope="application"

or

scope="session"

which results in the same behavior.  For more see Knowledgebase Article
14165.

> -Original Message-
> From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 1:37 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Using CFLOCK
>
>
> Good answer... makes sense... officially it conflicts with Allaire's
> recomendation, but I think you are correct.
>
> -Cameron
>
> 
> Cameron Childress
> McRae Communications
> 770.460.7277 x.232
> 770.460.0963 fax
>
> > -Original Message-
> > From: David Gassner [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 29, 2000 4:01 PM
> > To: [EMAIL PROTECTED]
> > Subject: RE: Using CFLOCK
> >
> >
> > session.sessionid is a value which is set by the CF server, not
> > by the user,
> > and is based on the CFID and CFToken cookies.  It's initialized at the
> > beginning of the session, and not changed until the session expires, and
> > therefore (theoretically) it needs no locking.
> >
> > Doing it this way simulates the rules followed by CF server 4.5 when you
> > turn on "Automatic read locking" in CF Server Administrator.
> >
> > > -Original Message-
> > > From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, March 29, 2000 11:54 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: RE: Using CFLOCK
> > >
> > >
> > > So David... riddle me this...
> > >
> > > If you should lock all session vars, and you name your lock
> > with a session
> > > var, what is locking the session var you are using as the name of
> > > the lock?
> > >
> > > -Cameron
> > >
> > > 
> > > Cameron Childress
> > > McRae Communications
> > > 770.460.7277 x.232
> > > 770.460.0963 fax
> > >
> > > > -Original Message-
> > > > From: David Gassner [mailto:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, March 29, 2000 2:31 PM
> > > > To: [EMAIL PROTECTED]
> > > > Subject: RE: Using CFLOCK
> > > >
> > > >
> > > > If you are locking session vars, use the name:
> > > >
> > > > name="#session.sessionid#"
> > > >
> > > > If you are locking application vars, use the name:
> > > >
> > > > name="#application.applicationname#"
> > > >
> > > > > -Original Message-
> > > > > From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Wednesday, March 29, 2000 10:48 AM
> > > > > To: [EMAIL PROTECTED]
> > > > > Subject: RE: Using CFLOCK
> > > > >
> > > > >
> > > > > > When using CFLOCK how important is it to name the lock
> > > > >
> > > > > In CF 4.0: very, always name it... In CF 4.5, which I am not
> > > > > using yet, I am
> > > > > uncertain if names should be used or not.  In 4.5, I *think* they
> > > > > should be
> > > > > used in all cases except for when locking application, session
> > > > and server
> > > > > vars.  Someone else should be able to answer that for you.
> > > > >
> > > > > > and if you name all locks should everylock in your application
> > > > > > have a different name?
> > > > >
> > > > > Depends on what you are locking and why you are locking it.
> > > > >
> > > > > -Cameron
> > > > >
> > > > > 
> > > > > Cameron Childress
> > > > > McRae Communications
> > > > > 770.460.7277 x.232
> > > > > 770.460.0963 fax
> > > > >
> > > > > --
> > > > > 
> > > > > 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 'un

Re: Server_Name

[Eric Dawson]

not sure. but I think older browsers don't pass the server_name, but I think 
it is simple enough to put up a front door.

ie.
index.html displays
link:domain1
link:domain2

from then on they browse
www.domain1.com/domain1/index.html

how much traffic are your sites pushing through?

?? Does the cflocation double the load on the server?

Where are you hosting? you can contact me offlist.
[EMAIL PROTECTED]

From: "John Bowering" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: Server_Name
Date: Wed, 29 Mar 2000 15:40:06 -0500

Has anyone had any problems relying on the 'server_name' variable?  I am
trying to find a way to host 2 (or more) sites on one hosting account. Just
wondering how reliable it is.


This would be the index.htm:






Or, if anyone has a better idea, can ya share?  I would prefer not to pay
for 2 or more accounts for sites that aren't bringing in any money right
now.

Thanks,
John
__
Get Your Private, Free Email 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.

login application help requested

[Chris Estes]

I have a home page in which there are links both for public and private pages. I want 
users with a password to be able to click on a private page link, login, then be 
forwarded directly to that page. It is easy enough to send them to a specific page, 
but I can't seem to "forward" them. This code takes the user back to the login form.

The code I'm using is very simple and basic (which is probably the problem). I've 
included it below. If anyone can help, I'd appreciate it. I've wasted two days of my 
life working on this.


Application.cfm:
 










http://localhost/isri/login/formpage.cfm?dest=#cgi.path_info#" addtoken="No">
  



 





Formpage.cfm:




Password:


 


Actionpage.cfm:

SELECT username, pwd
FROM login
WHERE username = '#Form.name#' AND pwd = '#form.password#'




Log In





 
 


alert("We're sorry, but we were unable to verify either your Name or Password. Please 
try again.")
self.location = 'formpage.cfm'






Chris Estes
(202) 662-8536
[EMAIL PROTECTED]
http://www.isri.org
http://www.scrap.org

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

[Cameron Childress]

Good answer... makes sense... officially it conflicts with Allaire's
recomendation, but I think you are correct.

-Cameron


Cameron Childress
McRae Communications
770.460.7277 x.232
770.460.0963 fax

> -Original Message-
> From: David Gassner [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 4:01 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Using CFLOCK
>
>
> session.sessionid is a value which is set by the CF server, not
> by the user,
> and is based on the CFID and CFToken cookies.  It's initialized at the
> beginning of the session, and not changed until the session expires, and
> therefore (theoretically) it needs no locking.
>
> Doing it this way simulates the rules followed by CF server 4.5 when you
> turn on "Automatic read locking" in CF Server Administrator.
>
> > -Original Message-
> > From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 29, 2000 11:54 AM
> > To: [EMAIL PROTECTED]
> > Subject: RE: Using CFLOCK
> >
> >
> > So David... riddle me this...
> >
> > If you should lock all session vars, and you name your lock
> with a session
> > var, what is locking the session var you are using as the name of
> > the lock?
> >
> > -Cameron
> >
> > 
> > Cameron Childress
> > McRae Communications
> > 770.460.7277 x.232
> > 770.460.0963 fax
> >
> > > -Original Message-
> > > From: David Gassner [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, March 29, 2000 2:31 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: RE: Using CFLOCK
> > >
> > >
> > > If you are locking session vars, use the name:
> > >
> > > name="#session.sessionid#"
> > >
> > > If you are locking application vars, use the name:
> > >
> > > name="#application.applicationname#"
> > >
> > > > -Original Message-
> > > > From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, March 29, 2000 10:48 AM
> > > > To: [EMAIL PROTECTED]
> > > > Subject: RE: Using CFLOCK
> > > >
> > > >
> > > > > When using CFLOCK how important is it to name the lock
> > > >
> > > > In CF 4.0: very, always name it... In CF 4.5, which I am not
> > > > using yet, I am
> > > > uncertain if names should be used or not.  In 4.5, I *think* they
> > > > should be
> > > > used in all cases except for when locking application, session
> > > and server
> > > > vars.  Someone else should be able to answer that for you.
> > > >
> > > > > and if you name all locks should everylock in your application
> > > > > have a different name?
> > > >
> > > > Depends on what you are locking and why you are locking it.
> > > >
> > > > -Cameron
> > > >
> > > > 
> > > > Cameron Childress
> > > > McRae Communications
> > > > 770.460.7277 x.232
> > > > 770.460.0963 fax
> > > >
> > > > --
> > > > 
> > > > 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.

Newbie to the List from client server

[Bogesdorfer, Dan L.]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01BF99C8.2BF5C820
Content-Type: text/plain;
charset="iso-8859-1"

I've been developing in Omnis and Omnis Studio for the past 5 years and I am
making the move over to Cold Fusion. I've been putting together some test
apps but nothing major.  What I am trying to find out is what do you find to
be the best development tool/add-ons for Cold Fusion Studio?  What I am
trying to do is take alot of our existing applications, Action Requests,
Contract Administration, Calling Card Maintenance. and develop them
using Cold Fusion Studio / Cold Fusion Enterprise Server.
What I've found most difficult coming from the client server over to
the web is that alot of requests must be posted to another page.  Is there a
way that I can have a user input a calling card number or last name and have
the "SAME" page display all found customers in a list/table field then have
my user either single click or double click to load the customer information
on the same page into the appropriate fields?

thanks

Daniel Bogesdorfer
Programmer/Analyst
RSL COM USA INC
Voice 412.244.6628


--_=_NextPart_001_01BF99C8.2BF5C820
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






Newbie to the List from client server



I've been developing in Omnis and =
Omnis Studio for the past 5 years and I am making the move over to Cold =
Fusion. I've been putting together some test apps but nothing =
major.  What I am trying to find out is what do you find to be the =
best development tool/add-ons for Cold Fusion Studio?  What I am =
trying to do is take alot of our existing applications, Action =
Requests, Contract Administration, Calling Card Maintenance. and =
develop them using Cold Fusion Studio / Cold Fusion Enterprise =
Server.

    What I've found most difficult coming from the client =
server over to the web is that alot of requests must be posted to =
another page.  Is there a way that I can have a user input a =
calling card number or last name and have the "SAME" page =
display all found customers in a list/table field then have my user =
either single click or double click to load the customer information on =
the same page into the appropriate fields?

thanks


Daniel =
Bogesdorfer
Programmer/Analyst
RSL COM USA =
INC
Voice =
412.244.6628




--_=_NextPart_001_01BF99C8.2BF5C820--
--
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: Inline html editor

[Steve DeWitt]

this is a little off topic but was does this tag do? I am looking for an
html parser to use with coldfusion. It could be written in java as well.

-Original Message-
From: Raymond K. Camden [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 1:15 PM
To: [EMAIL PROTECTED]
Subject: RE: Inline html editor


It seems like you were lied to, or a mistake was made. I prefer to think the
presenter made a mistake - it happens. Of course, by definition,
 does _work_ in Netscape, ie, it doesn't throw an error, but
you don't get the fancy DHTML stuff.

You are correct, of course, that someone could build such a tool that would
work in both Netscape and IE.

===
Raymond Camden, Webmaster of the Death Clock  (www.deathclock.com)
Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda


> -Original Message-
> From: Judah McAuley [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 3:37 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Inline html editor
>
>
> At 03:19 PM 3/29/00 -0500, you wrote:
> >Are you saying you got  to work in netscape?
>
> No, I'm saying that I was told that it worked.  I didn't do
> anything, I sat
> and watched the people demonstrating do things.  I was also saying that,
> with creative use of javascript to tweak the DOM, you *should* be able to
> make a tool such as  work under Netscape.  It is entirely
> possible that I was lied to, and it doesn't work under Netscape.
> Wouldn't
> be the first time I was lied to by presenters.
>
> Judah
>
> --
> 
> 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: CF4.5 doesn't support Win2000 file encryption?

[William James]

On the other hand, who says that they all have problems with it? Maybe only
Cold Fusion does. Unless someone's tried them all, I don't think you can say
one way or the other who's problem it is, but I do think that Allaire is the
ones who would need to fix it. As well as each of the others. You don't have
to use the MS Encryption (I don't see why you would need to), but if you do,
you have to use products that work with it. It is not up to MS to make sure
their technology works with other programming languages unless they said the
encryption process is for use with them. That's like saying MS has to make
drivers for Windows 2000 for all of your hardware. They don't. The hardware
manufacturer should make the drivers for windows 2000 if they want their
hardware to work in Windows2000. MS has done an awesome job of making sure
most stuff works, but I've read too many hardware sites that say, "MS has a
pretty good driver for our hardware and although it could be better, we
aren't going to bother making a new one".
- Original Message -
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2000 1:33 PM
Subject: Re: CF4.5 doesn't support Win2000 file encryption?


> Forgive me for asking, but if MS gives a new 'feature' that will effect
CF,
> Perl, Rebol and almost every non-MS scripting language, why would you
think
> it needs a fix from Allaire?
> >
> > Windows 2000 allows you to encrypt files. ColdFusion does not seem to
> > support this, as I get the following error on any page that I encrypt:
> >
> > The template file exists, however, it either cannot be opened for
reading,
> > or it is encrypted and its data has been corrupted
> >
> > as soon as i unencrypt, all things are good to go.
> >
> > anyone heard anything about this? is allaire going to fix this in a
> service
> > patch?
>
>
> --

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

[Ron Anderson]

John,

If you don't want to look for www. & .com use contain rather than is:


I use a virtual directory called "rootdir" that can be altered for each
site, so it would look something like this:



Then all other paths are relative to the rootdir variable.
Seems to work well, no caveats...yet.


-Original Message-
From: Pete Freitag [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 1:12 PM
To: [EMAIL PROTECTED]
Subject: RE: Server_Name


Yes it should work ok, but keep in mind what if someone types in the IP
address, then the IP address is the server name.  Also if I typed in
domain1.com then I wouldn't match anything either.  So add the sites without
the www. and also have a default case just incase something unexpected comes
along.


Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com

-Original Message-
From: John Bowering [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 3:40 PM
To: [EMAIL PROTECTED]
Subject: Server_Name


Has anyone had any problems relying on the 'server_name' variable?  I am
trying to find a way to host 2 (or more) sites on one hosting account. Just
wondering how reliable it is.


This would be the index.htm:







Or, if anyone has a better idea, can ya share?  I would prefer not to pay
for 2 or more accounts for sites that aren't bringing in any money right
now.

Thanks,
John






--
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: Open source development?

[Chris Evans]

[EMAIL PROTECTED]  Not much traffic, though.  It seems Spectra
has a lot of people scratching their heads.  Either that, or they are all on
the Forums, but I can't deal with Forums.

Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com


-Original Message-
From: Ron Anderson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 4:18 PM
To: [EMAIL PROTECTED]
Subject: RE: Open source development?


Is there a Spectra mailing list available?


-Original Message-
From: Chris Evans [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 12:35 PM
To: [EMAIL PROTECTED]
Subject: Open source development?


Id any body doing any kind of open source development for Spectra?  I have
heard there are a few known bugs and enhancements for Spectra that everybody
is complaining about.  The code is open, and I'm sure people are making
changes to the underlying code to get it working.  Is there a web site ( or
should there be) where developers can post their fixes, both for other
developers to use and for Allaire?

Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.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.


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

[Sean Daniels]

> Has anyone had any problems relying on the 'server_name' variable?  I am
> trying to find a way to host 2 (or more) sites on one hosting
> account. Just
> wondering how reliable it is.

I actually have 22 "cloned" sites running this way. The first thing I do in
my app_globals script is query a db for a set of site parameters (about 12
columns, name, colors, a few graphics, etc) where site.id = #server_name#
(it's a little more complicated than that, because I have a separate table
of domain names where multiple domain names can be used for one site).

Then the rest of the site is built around those variables.

- Sean

~
Sean Daniels
Manager of Engineering
DealStream, Inc.
[EMAIL PROTECTED]
~
tel: 207.439.6030
cel: 978.764.0799
Fax: 240.269.6319



--
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: CF4.5 doesn't support Win2000 file encryption?

[Rey Bango]

Mike,

I wouldn't expect it to be dealt with. That's a feature of Win2K to help
protect your files in an internal, corporate environment. MS would have to
allow 3rd party vendors access to their unecryption algorithms in order to
do this. This would essentially negate any security that encryption might
offer you.

As a side note, the admins of CF-Talk list have disabled file attachment
capabilities because of a virus scare so any messages w/ attached files are
coming out screwy. Would you mind removing your atworklogo_very_small.gif &
Glacier Bkgrd.jpg files from your messages.

Thanks,

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."


- Original Message -
From: "Mike Amburn" <[EMAIL PROTECTED]>
To: "Cf-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2000 3:46 PM
Subject: CF4.5 doesn't support Win2000 file encryption?


> This is a multi-part message in MIME format.
>
> --=_NextPart_000__01BF9995.F72A13D0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> Windows 2000 allows you to encrypt files. ColdFusion does not seem to
> support this, as I get the following error on any page that I encrypt:
>
> The template file exists, however, it either cannot be opened for reading,
> or it is encrypted and its data has been corrupted
>
> as soon as i unencrypt, all things are good to go.
>
> anyone heard anything about this? is allaire going to fix this in a
service
> patch?
>
> Mike Amburn
> Application Development
>
> --=_NextPart_000__01BF9995.F72A13D0
> Content-Type: image/gif;
> name="atworklogo_very_small.gif"
> Content-Transfer-Encoding: base64
> Content-ID: <994194320@29032000-1c68>
>
>
R0lGODlhhwAsAPcAAMDAwHNzc4SEhKWlpa2trdbW1ufn5+/v77Wtpf/nvffWnP/vzv/nte/WpXtr
>
Sv/WhPfv3vfWjO/OhPfGWvfGUvfOa++9OffWc+fGY+/GUue9Svfv1v/nnP/nlN7Gc97Ga+/GKffG
>
GOe1CPfGCP/GAJSMa+fWjFpSMf/WMee9GOe9APfGAN7Wrf/nc97GUv/eQufGKf/3xv/nUu/WSt7G
>
Of/ve9bGSu/npefWQt7OOf/3nP/3jP/3e//3Y6WlnM7Ovf//zv//xu/vra2te///td7elPf/vd7n
>
pdbn1qW9tWN7c87W1rW9vUpSUnuMjDFCQuf3/6W1vYyltb3Gzpylrd7v/4SMlGNrc0pSWtbe55Sc
>
pVJaY9bn/zFCWhAhOb3O56W1zmNzjL3G1pyltXuElFpjczlCUsbO3qWtvYSMnJytzjlKaxAhQhgx
>
YwgYOdbe787W57W9zq21xoyUpXN7jGtzhHOErWNznBApawgYQgghY73G3nuEnFpje5Sl1jlKezFC
>
cxgpWhAhUsbO56WtxpSctYyUrWNrhFJac0pSa2t7rWNzpSkxSkpajFJjnCk5axAhWggYSgAQQpyl
>
xoyc1oSUzjlCYzFChBghQhgpawAQStbe/7W93q211r3G73N7nGNrjFJae1pjjHOEzjE5WikxUiEp
>
Sik5exAYORAhawgYWoyUvWtznEpSe0JKcyExexAYQhgpewgQOcbO/62156Wt3pSczoSMvXuEtWNr
>
nDlCezE5ayEpWhghUrW994yUzoSMxkpSjCkxayEpYxAYUkJKjCkxcykxhCEpcyEpexAYWhAYYwgQ
>
Wufn787O1rW1vaWlrZycpdbW597e78bG1r29zpycrdbW72tre97e/4yMpb293lJSY7W13sbG94SE
>
pb2973t7nGtrjISEtSEhMTExSmNjpSEhQjExYzExawgIIca9xmtja/fn7wAA
>
ACH5BAEALACHACwA
>
QAj/AAEIHEiwoMGDCBMqXMiwocOHECNKLHigWho02yYqvDaslxaNIEO+OWXMi6kkY9oYCwSoChSC
>
tgJlWjamILheMxFVEWin1zA8vCC1eZRFYCGhmA4BsMPMmKBHhgYRLBBtDaY2gsIIFCCoVxdpBBcJ
>
aiPMG4BBXjJl+ghACjNkqAq1C6nQTiRjy0qFqtMnVJ8+ZUKRSnXMFCiBtQQtw0MF4RxNxpAdcxOK
>
oBQ3bTLFitUl20Bs6kixa0KIS0FPgIY9yhPmJRlVeLpsAhBOVi9BtQiCK5UJjyGBZCQN4+WHLsgD
>
KlbAsMDBiEQgQHRwaFEhQwYDCw1MmXaGyZmEU5ox/0TyA3vCAg7FxDHOvr17hQecERiw7oBCJAbm
>
vt/fEMqeOdgkws0VZFAhxxnTAGAfANPAEccY34SCSiTDGAMMfxgWxIkuyhijVhtRDATFGLZMMskq
>
haA4iRSTVHEIMcMo00hB2xgjDB6CLFKQL714aEYnBNGyiiKiNJKLId14BgAddAg0hSGrmGgiIZ1I
>
VRCUwCxRUCeTkCEFEhk2EskpmdgBABRo5oJMMpAUI9AGEBRiSiCBWGPQNFYJ84gvjQTSCyOmkQEJ
>
HplQMsoy6ESCBgCtmJLJMGYpROYwbqYB2zC5gGLOH2xEEskTjQEADjqQBNLIbYEokqFAaDSBSCiJ
>
fP93kAw4lHBCGYlsoZ5ffYSIkBh9JIIIWwRdww43JzjQwA0sCAGBiGKE04clpZRiSR/hUGPQAK0g
>
UkeCAlFzSCgDOgPAGX2IEsozBYkjTiJ1oLeqQjeYYAMNKeSrb74wwIDBBxKYkMACxp3BjkB0aHGG
>
AHMkAsAS0kBjJzdvpGHIG30MEs41AByyxzdgfMMHAIawAkYhnXxzDSgrg7FNOIWA8gkYVzbZhxiD
>
pEHNFlnENy+GVVwDhjZ1FFOMLrukk84aruQyTiez/Sz1qllQQ4c4VshBkH4ONbMKOrwQ48TU+3VS
>
LSm8dKOgQ4ScA/Yu4EhTzRTyAjMMG4Ac9E0v6Jz/c4h5DE1jRhlku/eFJcS0gcxMeDBipSfo9NJL
>
OjDyogwvkaDzxhvFQKJWqABcww2MeuBhii0DNROKKcMQ881ZhxgjSRuQQKKKIIG00QYzyezyy0Bp
>
KNPGMMLY2EsebuRhiRoCcYIJMszUJFAnfUSShyucrFpFIjGasgpPdymzhmkDrWIK7dIT9A2dptwC
>
gDe89GKKHbWUEoseSmVjSS+88DJLJcoYRiCU8BKE8AESwpDEHQBghWW0oRSzIAguehGJUuzhLOcj
>
BiGqIIo8EAMQb5gXF/qwjEw8QhilYEOnMMELZOAhFqmogzTgZIte0M5OBunE+TLxCmTcZg4CMcAf
>
/2TSQ2RgojVLyUNmmpSQOQwvEouAwmsy8QdbhAIWqpkE+QQyi1K0AQ+d8AYgTCGJRoQwQ2noHy+C
>
gRAgDIEUpohck2rBCwGCziCLgIUwlGGJLxCEC4K6hIcQAAAjCIEIQmBCAEqhDqEEYhiQzEQbiBGI
>
UBBiIE5QBSTQwTEATAITiQpFJ3cjyUUJpBvoyIQyENHJwgEAAiRQgQeI8B4dSCcCDWCAK3cJEQpo
>
QAQiGEEIZNADDuggCMhMpg52UIMayGAGOaCBDVxgggY8yyEFcAY1yDCNZzTjDUsAFzW0lAQ6hPNc
>
0hjEGc8gKzrYaRrUANcZqGGIM0jvDHB4yTSuIf+rgVihDgDYAz8LmIV1TKUovNTIMxKRoCloAyxn
>
sMIYziCNOdhJolZQGB2ogYY4TMEaBbACGphAhTOkwUF1sKjVqiGHek4DDWg4gzWYAI2BEE0adYip
>
Fpwxh2fQbQwGTahQh0rU9kwjC0jAD+CKylSQVGMM4rCEKchxjnNAUhjCABsmYDEhUoRCa00N60GW
>
YIhgHcIQ1ChgQzbxCWNgLh1iEGtTpfGMOQhgG0qiCyvCNja5OoQa1agGuyKChj10Iq4CWQcB5CCN
>
bHhiDxc0SAGqcYbAQiRyU/BrQ8KBClNEAhOigMg1ygGLXmBiHAYJBSbyMAywDiQb6IAkKl7HEPv/
>

Re: CF4.5 doesn't support Win2000 file encryption?

[Michael Dinowitz]

Forgive me for asking, but if MS gives a new 'feature' that will effect CF,
Perl, Rebol and almost every non-MS scripting language, why would you think
it needs a fix from Allaire?
>
> Windows 2000 allows you to encrypt files. ColdFusion does not seem to
> support this, as I get the following error on any page that I encrypt:
>
> The template file exists, however, it either cannot be opened for reading,
> or it is encrypted and its data has been corrupted
>
> as soon as i unencrypt, all things are good to go.
>
> anyone heard anything about this? is allaire going to fix this in a
service
> patch?


--
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: query date problem

[S R]

Thanks everyone. I solved it with your help!!

>From: Brad Tumy <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
>Subject: RE: query date problem
>Date: Wed, 29 Mar 2000 15:12:45 -0500
>
>Did you check the data in newDatearc?  ...maybe it is less than now in all
>of the records?
>
>--
>Director, Information & Technology
>Regulatory Affairs Professionals Society
>301.770.2920 x241
>http://www.raps.org
>
>
>-Original Message-
>From: S R [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 29, 2000 3:03 PM
>To: [EMAIL PROTECTED]
>Subject: RE: query date problem
>
>
>Its a Date/Time field in MS Access. The field has 'Short Format' specified.
>I did place pound signs around 'NOW()' but it still does the same thing
>
> >From: "Mark Warrick" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: <[EMAIL PROTECTED]>
> >Subject: RE: query date problem
> >Date: Wed, 29 Mar 2000 11:35:33 -0800
> >
> >First problem:  you need to put pound signs around "Now()".
> >
> >Second problem: even if you try that, the date format might be incorrect.
> >What kind of field are you searching against?  What kind of database is 
>it?
>
> >   What is the format of the dates in the field?
> >
> >Match up the date with your search query, and you'll get the right 
>results.
> >
> >---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: S R [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, March 29, 2000 11:26 AM
> >To: [EMAIL PROTECTED]
> >Subject: query date problem
> >
> >
> >This query gives me all records in the database instead of just what I
> >asked
> >for. What am I doing wrong?? This NewDateArc field is a DateTime field in
> >Access
> >
> >
> >select * from ArchivesCopy
> >WHERE NewDateArc < NOW()
> >
> >__
> >Get Your Private, Free Email 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.
>
>__
>Get Your Private, Free Email 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.

__
Get Your Private, Free Email 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: Inline html editor

[Raymond K. Camden]

It seems like you were lied to, or a mistake was made. I prefer to think the
presenter made a mistake - it happens. Of course, by definition,
 does _work_ in Netscape, ie, it doesn't throw an error, but
you don't get the fancy DHTML stuff.

You are correct, of course, that someone could build such a tool that would
work in both Netscape and IE.

===
Raymond Camden, Webmaster of the Death Clock  (www.deathclock.com)
Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda


> -Original Message-
> From: Judah McAuley [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 3:37 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Inline html editor
>
>
> At 03:19 PM 3/29/00 -0500, you wrote:
> >Are you saying you got  to work in netscape?
>
> No, I'm saying that I was told that it worked.  I didn't do
> anything, I sat
> and watched the people demonstrating do things.  I was also saying that,
> with creative use of javascript to tweak the DOM, you *should* be able to
> make a tool such as  work under Netscape.  It is entirely
> possible that I was lied to, and it doesn't work under Netscape.
> Wouldn't
> be the first time I was lied to by presenters.
>
> Judah
>
> --
> 
> 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: Server_Name

[Pete Freitag]

Yes it should work ok, but keep in mind what if someone types in the IP
address, then the IP address is the server name.  Also if I typed in
domain1.com then I wouldn't match anything either.  So add the sites without
the www. and also have a default case just incase something unexpected comes
along.


Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com

-Original Message-
From: John Bowering [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 3:40 PM
To: [EMAIL PROTECTED]
Subject: Server_Name


Has anyone had any problems relying on the 'server_name' variable?  I am
trying to find a way to host 2 (or more) sites on one hosting account. Just
wondering how reliable it is.


This would be the index.htm:







Or, if anyone has a better idea, can ya share?  I would prefer not to pay
for 2 or more accounts for sites that aren't bringing in any money right
now.

Thanks,
John






--
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: Open source development?

[Ron Anderson]

Is there a Spectra mailing list available?


-Original Message-
From: Chris Evans [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 12:35 PM
To: [EMAIL PROTECTED]
Subject: Open source development?


Id any body doing any kind of open source development for Spectra?  I have
heard there are a few known bugs and enhancements for Spectra that everybody
is complaining about.  The code is open, and I'm sure people are making
changes to the underlying code to get it working.  Is there a web site ( or
should there be) where developers can post their fixes, both for other
developers to use and for Allaire?

Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.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: Server_Name

[Ron Anderson]

very reliable.
I use for over 20 URLs doing the same thing, then I set a SiteID variable.

-Original Message-
From: John Bowering [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 12:40 PM
To: [EMAIL PROTECTED]
Subject: Server_Name


Has anyone had any problems relying on the 'server_name' variable?  I am
trying to find a way to host 2 (or more) sites on one hosting account. Just
wondering how reliable it is.


This would be the index.htm:







Or, if anyone has a better idea, can ya share?  I would prefer not to pay
for 2 or more accounts for sites that aren't bringing in any money right
now.

Thanks,
John






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

[David Gassner]

session.sessionid is a value which is set by the CF server, not by the user,
and is based on the CFID and CFToken cookies.  It's initialized at the
beginning of the session, and not changed until the session expires, and
therefore (theoretically) it needs no locking.

Doing it this way simulates the rules followed by CF server 4.5 when you
turn on "Automatic read locking" in CF Server Administrator.

> -Original Message-
> From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 11:54 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Using CFLOCK
>
>
> So David... riddle me this...
>
> If you should lock all session vars, and you name your lock with a session
> var, what is locking the session var you are using as the name of
> the lock?
>
> -Cameron
>
> 
> Cameron Childress
> McRae Communications
> 770.460.7277 x.232
> 770.460.0963 fax
>
> > -Original Message-
> > From: David Gassner [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 29, 2000 2:31 PM
> > To: [EMAIL PROTECTED]
> > Subject: RE: Using CFLOCK
> >
> >
> > If you are locking session vars, use the name:
> >
> > name="#session.sessionid#"
> >
> > If you are locking application vars, use the name:
> >
> > name="#application.applicationname#"
> >
> > > -Original Message-
> > > From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, March 29, 2000 10:48 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: RE: Using CFLOCK
> > >
> > >
> > > > When using CFLOCK how important is it to name the lock
> > >
> > > In CF 4.0: very, always name it... In CF 4.5, which I am not
> > > using yet, I am
> > > uncertain if names should be used or not.  In 4.5, I *think* they
> > > should be
> > > used in all cases except for when locking application, session
> > and server
> > > vars.  Someone else should be able to answer that for you.
> > >
> > > > and if you name all locks should everylock in your application
> > > > have a different name?
> > >
> > > Depends on what you are locking and why you are locking it.
> > >
> > > -Cameron
> > >
> > > 
> > > Cameron Childress
> > > McRae Communications
> > > 770.460.7277 x.232
> > > 770.460.0963 fax
> > >
> > > --
> > > 
> > > 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: Has someone wrangled a way to get CF to print an HTML document?

[Fred Sanders]

Craig, your such a tease.


- Original Message -
From: "Craig M. Rosenblum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2000 1:49 PM
Subject: RE: Has someone wrangled a way to get CF to print an HTML document?


> There is some javascript ways of doing that...
>
> > -Original Message-
> > From: Steve Aylor [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 29, 2000 2:05 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Has someone wrangled a way to get CF to print an HTML
> > document?
> >
> >
> > protofax or you might try active4
> >
> > Steve
> >
> >
> > >
> > > Howdy Y'all,
> > >
> > >Is there a way to get CF to print an HTML document? I'm looking for
a
> > way
> > > to dump
> > >   an html page to a networked fax machine.
> > >
> > >
> > >
> > > Lon Lentz
> > > GetLists.Com
> > > [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.

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

[Robert Everland III]

Well the whole idea of cfcatch is so that it "catches" the error. So if it
didn't why not just put after cfcatch that the file was succesfull. There
should be a cfabort in there also, just in case you have any other code that
runs only if the cfcatch was successful. That's what I do.




The file could not be updated. File is locked or read only.




The file updated.


Robert Everland III
Network Administrator
Orlando.com

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 3:07 PM
To: [EMAIL PROTECTED]
Subject: RE: CFTry Question


Thanks David

this works but I was kind of hoping it worked more like CFIF or CFSWITCH
like below





The file could not be updated. File is locked or read only.


The file updated.






Cheers,
Duane




-Original Message-
From: David Gassner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 1:12 PM
To: [EMAIL PROTECTED]
Subject: RE: CFTry Question


How about...






The file could not be updated. File is locked or read only.




Display success message...


> I have wrapped cftry around a cfflile call to intercept error messages if
> the file can not be updated but I want to return a success message if the
> was no errors. Here is what I have:
>
> 
>   
>   
>   The file could not be updated. File is locked or read only.
>   
> 
>


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

CF4.5 doesn't support Win2000 file encryption?

[Mike Amburn]

This is a multi-part message in MIME format.

--=_NextPart_000__01BF9995.F72A13D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Windows 2000 allows you to encrypt files. ColdFusion does not seem to
support this, as I get the following error on any page that I encrypt:

The template file exists, however, it either cannot be opened for reading,
or it is encrypted and its data has been corrupted

as soon as i unencrypt, all things are good to go.

anyone heard anything about this? is allaire going to fix this in a service
patch?

Mike Amburn
Application Development

--=_NextPart_000__01BF9995.F72A13D0
Content-Type: image/gif;
name="atworklogo_very_small.gif"
Content-Transfer-Encoding: base64
Content-ID: <994194320@29032000-1c68>

R0lGODlhhwAsAPcAAMDAwHNzc4SEhKWlpa2trdbW1ufn5+/v77Wtpf/nvffWnP/vzv/nte/WpXtr
Sv/WhPfv3vfWjO/OhPfGWvfGUvfOa++9OffWc+fGY+/GUue9Svfv1v/nnP/nlN7Gc97Ga+/GKffG
GOe1CPfGCP/GAJSMa+fWjFpSMf/WMee9GOe9APfGAN7Wrf/nc97GUv/eQufGKf/3xv/nUu/WSt7G
Of/ve9bGSu/npefWQt7OOf/3nP/3jP/3e//3Y6WlnM7Ovf//zv//xu/vra2te///td7elPf/vd7n
pdbn1qW9tWN7c87W1rW9vUpSUnuMjDFCQuf3/6W1vYyltb3Gzpylrd7v/4SMlGNrc0pSWtbe55Sc
pVJaY9bn/zFCWhAhOb3O56W1zmNzjL3G1pyltXuElFpjczlCUsbO3qWtvYSMnJytzjlKaxAhQhgx
YwgYOdbe787W57W9zq21xoyUpXN7jGtzhHOErWNznBApawgYQgghY73G3nuEnFpje5Sl1jlKezFC
cxgpWhAhUsbO56WtxpSctYyUrWNrhFJac0pSa2t7rWNzpSkxSkpajFJjnCk5axAhWggYSgAQQpyl
xoyc1oSUzjlCYzFChBghQhgpawAQStbe/7W93q211r3G73N7nGNrjFJae1pjjHOEzjE5WikxUiEp
Sik5exAYORAhawgYWoyUvWtznEpSe0JKcyExexAYQhgpewgQOcbO/62156Wt3pSczoSMvXuEtWNr
nDlCezE5ayEpWhghUrW994yUzoSMxkpSjCkxayEpYxAYUkJKjCkxcykxhCEpcyEpexAYWhAYYwgQ
Wufn787O1rW1vaWlrZycpdbW597e78bG1r29zpycrdbW72tre97e/4yMpb293lJSY7W13sbG94SE
pb2973t7nGtrjISEtSEhMTExSmNjpSEhQjExYzExawgIIca9xmtja/fn7wAA
ACH5BAEALACHACwA
QAj/AAEIHEiwoMGDCBMqXMiwocOHECNKLHigWho02yYqvDaslxaNIEO+OWXMi6kkY9oYCwSoChSC
tgJlWjamILheMxFVEWin1zA8vCC1eZRFYCGhmA4BsMPMmKBHhgYRLBBtDaY2gsIIFCCoVxdpBBcJ
aiPMG4BBXjJl+ghACjNkqAq1C6nQTiRjy0qFqtMnVJ8+ZUKRSnXMFCiBtQQtw0MF4RxNxpAdcxOK
oBQ3bTLFitUl20Bs6kixa0KIS0FPgIY9yhPmJRlVeLpsAhBOVi9BtQiCK5UJjyGBZCQN4+WHLsgD
KlbAsMDBiEQgQHRwaFEhQwYDCw1MmXaGyZmEU5ox/0TyA3vCAg7FxDHOvr17hQecERiw7oBCJAbm
vt/fEMqeOdgkws0VZFAhxxnTAGAfANPAEccY34SCSiTDGAMMfxgWxIkuyhijVhtRDATFGLZMMskq
haA4iRSTVHEIMcMo00hB2xgjDB6CLFKQL714aEYnBNGyiiKiNJKLId14BgAddAg0hSGrmGgiIZ1I
VRCUwCxRUCeTkCEFEhk2EskpmdgBABRo5oJMMpAUI9AGEBRiSiCBWGPQNFYJ84gvjQTSCyOmkQEJ
HplQMsoy6ESCBgCtmJLJMGYpROYwbqYB2zC5gGLOH2xEEskTjQEADjqQBNLIbYEokqFAaDSBSCiJ
fP93kAw4lHBCGYlsoZ5ffYSIkBh9JIIIWwRdww43JzjQwA0sCAGBiGKE04clpZRiSR/hUGPQAK0g
UkeCAlFzSCgDOgPAGX2IEsozBYkjTiJ1oLeqQjeYYAMNKeSrb74wwIDBBxKYkMACxp3BjkB0aHGG
AHMkAsAS0kBjJzdvpGHIG30MEs41AByyxzdgfMMHAIawAkYhnXxzDSgrg7FNOIWA8gkYVzbZhxiD
pEHNFlnENy+GVVwDhjZ1FFOMLrukk84aruQyTiez/Sz1qllQQ4c4VshBkH4ONbMKOrwQ48TU+3VS
LSm8dKOgQ4ScA/Yu4EhTzRTyAjMMG4Ac9E0v6Jz/c4h5DE1jRhlku/eFJcS0gcxMeDBipSfo9NJL
OjDyogwvkaDzxhvFQKJWqABcww2MeuBhii0DNROKKcMQ881ZhxgjSRuQQKKKIIG00QYzyezyy0Bp
KNPGMMLY2EsebuRhiRoCcYIJMszUJFAnfUSShyucrFpFIjGasgpPdymzhmkDrWIK7dIT9A2dptwC
gDe89GKKHbWUEoseSmVjSS+88DJLJcoYRiCU8BKE8AESwpDEHQBghWW0oRSzIAguehGJUuzhLOcj
BiGqIIo8EAMQb5gXF/qwjEw8QhilYEOnMMELZOAhFqmogzTgZIte0M5OBunE+TLxCmTcZg4CMcAf
/2TSQ2RgojVLyUNmmpSQOQwvEouAwmsy8QdbhAIWqpkE+QQyi1K0AQ+d8AYgTCGJRoQwQ2noHy+C
gRAgDIEUpohck2rBCwGCziCLgIUwlGGJLxCEC4K6hIcQAAAjCIEIQmBCAEqhDqEEYhiQzEQbiBGI
UBBiIE5QBSTQwTEATAITiQpFJ3cjyUUJpBvoyIQyENHJwgEAAiRQgQeI8B4dSCcCDWCAK3cJEQpo
QAQiGEEIZNADDuggCMhMpg52UIMayGAGOaCBDVxgggY8yyEFcAY1yDCNZzTjDUsAFzW0lAQ6hPNc
0hjEGc8gKzrYaRrUANcZqGGIM0jvDHB4yTSuIf+rgVihDgDYAz8LmIV1TKUovNTIMxKRoCloAyxn
sMIYziCNOdhJolZQGB2ogYY4TMEaBbACGphAhTOkwUF1sKjVqiGHek4DDWg4gzWYAI2BEE0adYip
Fpwxh2fQbQwGTahQh0rU9kwjC0jAD+CKylSQVGMM4rCEKchxjnNAUhjCABsmYDEhUoRCa00N60GW
YIhgHcIQ1ChgQzbxCWNgLh1iEGtTpfGMOQhgG0qiCyvCNja5OoQa1agGuyKChj10Iq4CWQcB5CCN
bHhiDxc0SAGqcYbAQiRyU/BrQ8KBClNEAhOigMg1ygGLXmBiHAYJBSbyMAywDiQb6IAkKl7HEPv/
oCERQNLsQr6RuZUYQxkBGMggGIGKCWGCFKXABCpkwYg3EGJ4KjmjQKzRC+HhYQ1RE8gvOqSMPggk
C0nARv8CoQxMmNcUoeBEyLQEACfAwhSeJYc6TFGKRPABsQAQAzkCkYffLCgOppCFOsrA3gzZgQ2Z
EMYlHKEHZJBDCjuBghr8QAtztE4YiqiFLWqxk0UkDg9KEcgZrGoMPQAiDwsUCBK6YApI6IJjokCF
SjRxikVUAhiK+IMgXpEKXjgCDsCBUTF+MYtZ2EIUvSiFG0RhGk+YAhnI+B4AmkEHVPACHVJe1Rhk
gonKGEAXkOTFb2DCiy+mTyDZaMVMumAWKLTC/4aXuAMkBFjTJfkEE2rwxC6UIclKqJUgnFgDnUoB
JAGwgRdmsElmMqG24aryI18gBTKUsbGfgQETxmBGK8g3i2GohQ1SIMgkehEISJx5esNogykaAQU0
yC8QtKjCGu7XBS5wwgvxC0Y2zJHgNiRBIYMQRibY0AoGCiUdkeJCJ/7QBky0wjNOxsoc5lAKXggj
Nz+LQv+UIQxXKCIMoVjEH6DsuR8AIAYbMB/t6lwQVrAWEot4BC9MkYiXxEF3mXBEMfTAC6IwShbE
yx4AgFCQZ53BQ8Rw0xz0kIl06AIVmHjkMFqRPvjR6ROtYAMx/hApDImHE7wRRiCIoUL+SQ4PeP84
RirI8WsA1FCApxYIF7ihCmSo4hT8y6xAzIGT3iDDDZMQCC0eESNGuLYgb+BGJIRBnPaqwsRVqN8w
BIGLP8+iF8sgRtBtYYrV8GEnGFqCLu6SCU5sAgouKSAXWJGKWMCCFJn9hSA+h5A44OUVyegFLgjy
BSw0OBWp+ARBxHAIbjShCV7oQyH28AVChIEXu5AELABxSQC8Bg+WiGAcWhEJU+kcALNIZSoKIRAx
BCMSvdDF0dsz4khg7kIHAQILWmEbWZwDDr9ggyQiAUSEjMODzOjDn6EgBU0wgxjpQM8NinAEWhYg
HLtYxu3oJAhlLMMYuGglAzWhiVJEKhthEIT/L

Re: Inline html editor

[Judah McAuley]

At 03:19 PM 3/29/00 -0500, you wrote:
>Are you saying you got  to work in netscape?

No, I'm saying that I was told that it worked.  I didn't do anything, I sat 
and watched the people demonstrating do things.  I was also saying that, 
with creative use of javascript to tweak the DOM, you *should* be able to 
make a tool such as  work under Netscape.  It is entirely 
possible that I was lied to, and it doesn't work under Netscape.  Wouldn't 
be the first time I was lied to by presenters.

Judah

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

Open source development?

[Chris Evans]

Id any body doing any kind of open source development for Spectra?  I have
heard there are a few known bugs and enhancements for Spectra that everybody
is complaining about.  The code is open, and I'm sure people are making
changes to the underlying code to get it working.  Is there a web site ( or
should there be) where developers can post their fixes, both for other
developers to use and for Allaire?

Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.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.

Server_Name

[John Bowering]

Has anyone had any problems relying on the 'server_name' variable?  I am
trying to find a way to host 2 (or more) sites on one hosting account. Just
wondering how reliable it is.


This would be the index.htm:







Or, if anyone has a better idea, can ya share?  I would prefer not to pay
for 2 or more accounts for sites that aren't bringing in any money right
now.

Thanks,
John





--
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: looping through a mailing list

[Chris Giminez]

I've changed part of the checking to the query, not cfif's, but I am still getting the 
same wrong
results. I could really use some help if someone can,  or at least a nudge in the 
right direction.

***

SELECT  *
FROM notify

Where
0=0
AND
#form.bed# >= des_bed
AND
#form.bath# >= des_bath
AND
#form.garage# >= des_garage
AND
#form.price# >= gt_price
AND
#form.price# <= lt_price
AND
#form.sq_ft# >= des_sq_ft

ORDER BY  date_subscribed









Send email to #notify_list.first_name#
#notify_list.last_name#






Don't send email #notify_list.first_name#
#notify_list.last_name#




***

Thanks!

Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000




> Yer wasting a lot of processing power in coldfusion unnecessarily.  You
> should build a where clause that replicates the conditions you are searchinf
> for in your CFIF, that way you just loop over the result set and send the
> email to every single record.  SQL Will handle that much faster than Cold
> Fusion will.
>
> Jordon
>
>


>
> This is for a real estate web site where the realtor will add their own
> property. When new property
> is added, I want it to check a data table of subscribers who are interested
> in a property fitting
> certain criteria, such as price, number of bedrooms, bathrooms, etc.
>
> I thought I had this figured out, but am not getting the desired results.
>
> Here's my code:
> **
> 
> 
> SELECT  *
> FROM notify
> ORDER BY  date_subscribed
> 
>
> 
> 
>
> 
>  form.bed gte notify_list.des_bed
> AND
> form.bath gte notify_list.des_bed
> AND
> form.garage gte notify_list.des_garage
> AND
> form.price gte notify_list.gt_price
> AND
> form.price lte notify_list.lt_price
> AND
> form.sq_ft gte notify_list.des_sq_ft
> AND
> notify_list.des_city CONTAINS form.city
> AND
> form.display eq 1
> AND
> form.status eq "for sale"
> >
> 
> Send email to #notify_list.first_name#
> #notify_list.last_name#
> 
>
> 
>
>
> Don't send email #notify_list.first_name#
> #notify_list.last_name#
>
> 
>
> 
> **
>
> I currently have just 3 subscrbers in the notify table for testing and the
> above code gives me this
> result.
>
> *
> Send email to joe testerTest PersonChris Giminez
> Don't send email joe testerTest PersonChris Giminez
> Don't send email joe testerTest PersonChris Giminez
> *
> It's somehow evaluating to true and false for each person.
>
> I know I'm close to getting this. If someone could enlighten me I would be
> most grateful.
>
> Thanks!
>
> Chris Giminez
> Owner - Cyber Scriber Web Site Design
> 831-728-4469
> ICQ# 2628000
>
>
>
>
>
> 
> --
> 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: Has someone wrangled a way to get CF to print an HTML document?

[John Quarto-vonTivadar]

Subject: RE: Has someone wrangled a way to get CF to print an HTML document?


> There is some javascript ways of doing that...


craig, can you follow up on that with any more details? and links or
examples?


--
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'm looking for good references for improving queries

[John Quarto-vonTivadar]

> does any know of any reference sites or tips sites for improving queries?

what about www.sqlserver.com and www.mssqlserver.com

(they are different but even one good nuget found is worth a visit)

--
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: query date problem

[Fred Sanders]

did you try the hmm what's it called createdateformat(now()) or some such
probably should look it up but you can format it with that function as well.
I still say your pulling up every record you have because your asking for
everything that was created before the exact time of your query, all syntax
problems aside, but then maybe that's what you want to do.


- Original Message -
From: "S R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2000 2:02 PM
Subject: RE: query date problem


> Its a Date/Time field in MS Access. The field has 'Short Format'
specified.
> I did place pound signs around 'NOW()' but it still does the same thing
>
> >From: "Mark Warrick" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: <[EMAIL PROTECTED]>
> >Subject: RE: query date problem
> >Date: Wed, 29 Mar 2000 11:35:33 -0800
> >
> >First problem:  you need to put pound signs around "Now()".
> >
> >Second problem: even if you try that, the date format might be incorrect.
> >What kind of field are you searching against?  What kind of database is
it?
> >   What is the format of the dates in the field?
> >
> >Match up the date with your search query, and you'll get the right
results.
> >
> >---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: S R [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, March 29, 2000 11:26 AM
> >To: [EMAIL PROTECTED]
> >Subject: query date problem
> >
> >
> >This query gives me all records in the database instead of just what I
> >asked
> >for. What am I doing wrong?? This NewDateArc field is a DateTime field in
> >Access
> >
> >
> >select * from ArchivesCopy
> >WHERE NewDateArc < NOW()
> >
> >__
> >Get Your Private, Free Email 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.
>
> __
> Get Your Private, Free Email 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: Inline html editor

[John N Westerlund]

Are you saying you got  to work in netscape?

-Original Message-
From: Judah McAuley <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, March 29, 2000 2:53 PM
Subject: RE: Inline html editor


At 09:57 PM 3/27/00 +1000, Peter Tillbrook wrote:
>The Spectra one doesn't work under Netscape (apparently) and all sorts of
>problems occur when people paste documents from Word into it (I'm sure you
>can understand why).
>
>Cheers!

I went to a spectra seminar yesterday and one of the things demonstrated
was the inline editing features.

It used Javascript to do the bold, underline, color change, etc.  The
demonstration was using IE, but I was promised that it works under Netscape
and IE 4.x and above.  If you did browser detection, had a good
understanding of Netscape vs. IE DOM implementation and were really good
with Javascript, it should be possible to make it work.

Be wary of most of the inline editing tools out there.  ActiveX controls,
IMHO, are a really bad idea in general and should only be considered for
very specific, short-term projects.

Judah


--
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: query date problem

[Brad Tumy]

Did you check the data in newDatearc?  ...maybe it is less than now in all
of the records?

--
Director, Information & Technology
Regulatory Affairs Professionals Society
301.770.2920 x241
http://www.raps.org


-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 3:03 PM
To: [EMAIL PROTECTED]
Subject: RE: query date problem


Its a Date/Time field in MS Access. The field has 'Short Format' specified. 
I did place pound signs around 'NOW()' but it still does the same thing

>From: "Mark Warrick" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>Subject: RE: query date problem
>Date: Wed, 29 Mar 2000 11:35:33 -0800
>
>First problem:  you need to put pound signs around "Now()".
>
>Second problem: even if you try that, the date format might be incorrect.  
>What kind of field are you searching against?  What kind of database is it?

>   What is the format of the dates in the field?
>
>Match up the date with your search query, and you'll get the right results.
>
>---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: S R [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 29, 2000 11:26 AM
>To: [EMAIL PROTECTED]
>Subject: query date problem
>
>
>This query gives me all records in the database instead of just what I 
>asked
>for. What am I doing wrong?? This NewDateArc field is a DateTime field in
>Access
>
>
>select * from ArchivesCopy
>WHERE NewDateArc < NOW()
>
>__
>Get Your Private, Free Email 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.

__
Get Your Private, Free Email 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.

ODBC error

[stas]

Hi guys, can anybody tell me quickly, what this means:

ODBC Error Code = S1000 (General error)


[INTERSOLV][ODBC Oracle 8 driver][Oracle 8]ORA-02019: connection description
for remote database not found

I am just doing a simple SELECT there. Thanks!


--
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: Inline html editor

[Raymond K. Camden]

> I went to a spectra seminar yesterday and one of the things demonstrated
> was the inline editing features.
>
> It used Javascript to do the bold, underline, color change, etc.  The
> demonstration was using IE, but I was promised that it works
> under Netscape
> and IE 4.x and above.

You were told wrong. The inline editor does -not- work with Netscape. When
you view a page With Netscape
using that tool you see a simple textarea.


===
Raymond Camden, Webmaster of the Death Clock  (www.deathclock.com)
Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda

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

[Duane Boudreau]

Thanks David

this works but I was kind of hoping it worked more like CFIF or CFSWITCH
like below





The file could not be updated. File is locked or read only.


The file updated.






Cheers,
Duane




-Original Message-
From: David Gassner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 1:12 PM
To: [EMAIL PROTECTED]
Subject: RE: CFTry Question


How about...






The file could not be updated. File is locked or read only.




Display success message...


> I have wrapped cftry around a cfflile call to intercept error messages if
> the file can not be updated but I want to return a success message if the
> was no errors. Here is what I have:
>
> 
>   
>   
>   The file could not be updated. File is locked or read only.
>   
> 
>


--
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: query date problem

[S R]

Its a Date/Time field in MS Access. The field has 'Short Format' specified. 
I did place pound signs around 'NOW()' but it still does the same thing

>From: "Mark Warrick" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>Subject: RE: query date problem
>Date: Wed, 29 Mar 2000 11:35:33 -0800
>
>First problem:  you need to put pound signs around "Now()".
>
>Second problem: even if you try that, the date format might be incorrect.  
>What kind of field are you searching against?  What kind of database is it? 
>   What is the format of the dates in the field?
>
>Match up the date with your search query, and you'll get the right results.
>
>---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: S R [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 29, 2000 11:26 AM
>To: [EMAIL PROTECTED]
>Subject: query date problem
>
>
>This query gives me all records in the database instead of just what I 
>asked
>for. What am I doing wrong?? This NewDateArc field is a DateTime field in
>Access
>
>
>select * from ArchivesCopy
>WHERE NewDateArc < NOW()
>
>__
>Get Your Private, Free Email 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.

__
Get Your Private, Free Email 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: Using CFLOCK

[Cameron Childress]

So David... riddle me this...

If you should lock all session vars, and you name your lock with a session
var, what is locking the session var you are using as the name of the lock?

-Cameron


Cameron Childress
McRae Communications
770.460.7277 x.232
770.460.0963 fax

> -Original Message-
> From: David Gassner [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 2:31 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Using CFLOCK
>
>
> If you are locking session vars, use the name:
>
> name="#session.sessionid#"
>
> If you are locking application vars, use the name:
>
> name="#application.applicationname#"
>
> > -Original Message-
> > From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 29, 2000 10:48 AM
> > To: [EMAIL PROTECTED]
> > Subject: RE: Using CFLOCK
> >
> >
> > > When using CFLOCK how important is it to name the lock
> >
> > In CF 4.0: very, always name it... In CF 4.5, which I am not
> > using yet, I am
> > uncertain if names should be used or not.  In 4.5, I *think* they
> > should be
> > used in all cases except for when locking application, session
> and server
> > vars.  Someone else should be able to answer that for you.
> >
> > > and if you name all locks should everylock in your application
> > > have a different name?
> >
> > Depends on what you are locking and why you are locking it.
> >
> > -Cameron
> >
> > 
> > Cameron Childress
> > McRae Communications
> > 770.460.7277 x.232
> > 770.460.0963 fax
> >
> > --
> > 
> > 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: Has someone wrangled a way to get CF to print an HTML document?

[Craig M. Rosenblum]

There is some javascript ways of doing that...

> -Original Message-
> From: Steve Aylor [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 2:05 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Has someone wrangled a way to get CF to print an HTML
> document?
>
>
> protofax or you might try active4
>
> Steve
>
>
> >
> > Howdy Y'all,
> >
> >Is there a way to get CF to print an HTML document? I'm looking for a
> way
> > to dump
> >   an html page to a networked fax machine.
> >
> >
> >
> > Lon Lentz
> > GetLists.Com
> > [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.

I'm looking for good references for improving queries

[Craig M. Rosenblum]

does any know of any reference sites or tips sites for improving queries?

> -Original Message-
> From: Craig M. Rosenblum [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 12:12 PM
> To: [EMAIL PROTECTED]
> Subject: Any good Improve Queries Articles?
>
>
>
> --
> 
> 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: Inline html editor

[Judah McAuley]

At 09:57 PM 3/27/00 +1000, Peter Tillbrook wrote:
>The Spectra one doesn't work under Netscape (apparently) and all sorts of
>problems occur when people paste documents from Word into it (I'm sure you
>can understand why).
>
>Cheers!

I went to a spectra seminar yesterday and one of the things demonstrated 
was the inline editing features.

It used Javascript to do the bold, underline, color change, etc.  The 
demonstration was using IE, but I was promised that it works under Netscape 
and IE 4.x and above.  If you did browser detection, had a good 
understanding of Netscape vs. IE DOM implementation and were really good 
with Javascript, it should be possible to make it work.

Be wary of most of the inline editing tools out there.  ActiveX controls, 
IMHO, are a really bad idea in general and should only be considered for 
very specific, short-term projects.

Judah

--
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: query date problem

[jstiefel]

Wrap CreateODBCDate around it:

Where NewDateArc < #CreateODBCDate(Now())#

However, remember that by using Now(), you're specifying everything older
than the date _to the second_

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 2:26 PM
To: [EMAIL PROTECTED]
Subject: query date problem


This query gives me all records in the database instead of just what I asked

for. What am I doing wrong?? This NewDateArc field is a DateTime field in 
Access


select * from ArchivesCopy
WHERE NewDateArc < NOW()

__
Get Your Private, Free Email 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.